{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["OUTPUT1","OUTPUT2","PUE","PUE to WAPA "],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":48,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"OUTPUT1","index":0,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
["M&I 2025 Sch A-11 F.Z27.XLSM"]
["09/17/2024"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF ESTIMATED M&I DIRECT PUMPING OPERATION & MAINTENANCE COSTS"]
["2025 M&I WATER RATES"]
[]
["Category","A) Contractor / Facility","Related Footnotes","B) Projected 2025 Deliveries:  Contra Costa PP\n\n<Sch A-12>","C) Projected 2025 Deliveries:  Dos Amigos PP-CVC\n\n<Sch A-12>","D) Projected 2025 Deliveries:  Pleasant Valley PP\n\n<Sch A-12>","E) Projected 2025 Deliveries: San Luis WD Relifts\n\n<Sch A-12>","F) Projected 2025 Deliveries: State-Delta PP\n\n<Sch A-12>","G) Projected 2025 Deliveries: T-C Canal Relifts Colusa County WD\n\n<Sch A-12>","H) Projected 2025 Deliveries: T-C Canal Relifts Kanawha WD\n\n<Sch A-12>","I) Projected 2025 Deliveries: Westlands WD Relifts\n\n<Sch A-12>","J) Projected 2025 Deliveries: Wintu PP\n\n<Sch A-12>","K) Projected 2025 Deliveries: Shasta PP\n\n<Sch A-12>"]
["Contra Costa Canal","Contra Costa WD","-",75905.428571428565,"-","-",0,"-","-","-","-","-","-"]
["Cow Creek Unit","Bella Vista WD","-","-","-","-","-","-","-","-","-",3487.1428571428573,"-"]
["Cross Valley Canal","County of Fresno","-","-",86,"-","-",86,"-","-","-","-","-"]
["Cross Valley Canal","County of Tulare","-","-",192,"-","-",192,"-","-","-","-","-"]
["San Luis Canal - Fresno","City of Coalinga","-","-","-",5430,"-","-","-","-","-","-","-"]
["San Luis Canal - Fresno","Westlands WD","-","-","-","-","-","-","-","-",2971.5714285714284,"-","-"]
["San Luis Canal - Tracy","San Luis WD","-","-","-","-",497,"-","-","-","-","-","-"]
["Tehama-Colusa Canal","Colusa County WD","-","-","-","-","-","-",116.28571428571429,"-","-","-","-"]
["Tehama-Colusa Canal","Kanawha WD","-","-","-","-","-","-","-",28.857142857142858,"-","-","-"]
["Toyon Pipeline","City of Shasta Lake","-","-","-","-","-","-","-","-","-","-",1120.8571428571429]
["Total","Total Deliveries","-",75905.428571428565,278,5430,497,278,116.28571428571429,28.857142857142858,2971.5714285714284,3487.1428571428573,1120.8571428571429]
["Other","Est. 2025 Non-Recurring O&M Cost","-",0,0,0,0,0,0,0,0,0,0]
["Other","Est. 2025 O&M Cost","-",2635697.8091000002,1785.9257932334999,174434.983783818,12781.1490741219,764.94617466720001,2140.1681379459001,77.223984732399998,23340.0336420729,88581.758000838701,15309.143700000001]
["Total","Total (Sch. A-9)","-",2635697.8091000002,1785.9257932334999,174434.983783818,12781.1490741219,764.94617466720001,2140.1681379459001,77.223984732399998,23340.0336420729,88581.758000838701,15309.143700000001]
["Direct Pumping","Cost Per A/F Remittance to WAPA","1/",34.72,0,0,25.72,0,18.399999999999999,2.68,7.85,0,0]
["Direct Pumping","Cost Per A/F Offset for Direct Pumping","1/",0,6.42,32.119999999999997,0,2.75,0,0,0,25.4,13.66]
["Other PUE Remittance to WAPA","Paid as Other PUE","1/",535495.92065358185,0,0,2596.7518608647542,0,434.81893236240865,15.689632042808178,4742.0052329577202,0,0]
["Other PUE Remittance to WAPA","Paid thru Direct Pumping PUE","1/",7.0547776454442808,0,0,5.2248528387620814,0,3.7392291480796809,0.54370012029533288,1.5957904250134149,0,0]
["Other PUE Remittance to WAPA","Credit in O&M Rate for Other PUE","1/",-7.0547776454442808,0,0,-5.2248528387620814,0,-3.7392291480796809,-0.54370012029533288,-1.5957904250134149,0,0]

{"sheet":"OUTPUT2","index":1,"n_rows":45,"n_cols":6,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
["M&I 2025 Sch A-11 F.Z27.XLSM"]
["09/17/2024"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF ESTIMATED M&I DIRECT PUMPING OPERATION & MAINTENANCE COSTS"]
["2025 M&I WATER RATES"]
[]
["Category","Component / Facility / Contractor\nRef","Related Footnotes","San Felipe Out-of-Basin: Gianelli PP <Sch A-12>","San Felipe Out-of-Basin: Coyote PP <Sch A-12>","San Felipe Out-of-Basin: Pacheco PP <Sch A-12>"]
["San Felipe Unit","San Benito County WD","-",6512.5714285714284,"-",6512.5714285714284]
["San Felipe Unit","Santa Clara Valley WD","-",91451.142857142855,91451.142857142855,91451.142857142855]
["Total","Total San Felipe Unit","-",97963.71428571429,91451.142857142855,97963.71428571429]
["Other","Est. 2025 Non-Recurring O&M Cost","-",0,0,0]
["Other","Est. 2025 O&M Cost","-",338007.33189655701,205757.93012040301,992383.13909789699]
["Total","Total (Sch. A-9)","-",338007.33189655701,205757.93012040301,992383.13909789699]
["Direct Pumping","Cost Per A/F Remittance to WAPA","1/",3.45,2.25,10.130000000000001]
["Direct Pumping","Cost Per A/F Offset for Direct Pumping","1/",0,0,0]
["Other PUE Remittance to WAPA","Paid as Other PUE","1/",68673.103098800755,41803.932090084367,201622.93297719912]
["Other PUE Remittance to WAPA","Paid thru Direct Pumping PUE","1/",0.70100550596227362,0.45711765631389528,2.0581389185505912]
["Other PUE Remittance to WAPA","Credit in O&M Rate for Other PUE","1/",-0.70100550596227362,-0.45711765631389528,-2.0581389185505912]
[]
["FOOTNOTES:"]
[]
["1/"]
["Project Use Energy payment is being remitted to Western Area Power Authority for storage and direct pumping based on the deliveries of a select few contractors. The rates for the select few"]
["contractors are reduced as a credit in the O&M rates.  All contractors will ultimately pay for the storage and direct pumping service but as an offset to the amount paid by the select few.  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,26647,0,0]
[]
[]
[null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[]
[null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"PUE","index":2,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["IRR 2025 Sch A-11 F.Z27.XLSM"]
["09/17/2024"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF ESTIMATED IRRIGATION DIRECT PUMPING OPERATION & MAINTENANCE COSTS"]
["2025 IRRIGATION WATER RATES"]
[]
["Category","A) Contractor","B) (Acre-Feet) M&I \n\n<Sch A-12>","C) (Acre-Feet) Irrigation \n\n<Sch A-12>","D) (Ratio of Acre-Feet) M&I \n\n(B/(B+C))","E) (Ratio of Acre-Feet) Irrigation\n\n(C/(B+C))","F) (Ratio of Acre-Feet) Total \n\n(D+E)","G) Total $\n\n<Meter Costs>","H) (For Water Ratesetting) M&I \n\n(D*G)","I) (For Water Ratesetting) Irrigation\n\n(E*G)"]
["Used in Schedule 9: Storage","Friant D&R    ",199.14285714285714,"-",1,"-",1,15227.700799999999,15227.700800000001,0]
["Used in Schedule 9: Storage","Shasta D&R (Includes Jdg F Carr PH)",1065.7142857142858,4326,0.19765778179999999,0.80234221819999996,1,365976.13079000002,72338.030203698101,293638.100586302]
["Used in Schedule 9: Storage","Columbia Mowry (Based on Avg. KWH's)",95840.433473449593,535697.55493573716,0.15175719469999999,0.84824280529999996,1,24914.434700000002,3780.9447176082999,21133.4899823917]
["Used in Schedule 9: Storage","Folsom Pump Plant",29043.714285714283,"-",1,"-",1,187324.15650000001,187324.15650000001,0]
["Used in Schedule 9: Storage","New Melones Dam & Reservoir",28394.142857142859,27604.142857142859,0.50705378739999996,0.49294621259999999,1,0,0,0]
["Used in Schedule 9: Storage","Gianelli WR Pump-Gen Plt  ",245858.42857142849,1593572.8699999999,0.13366002239999999,0.86633997760000003,1,6346648.5524289301,848293.18768257799,5498355.3647463499]
["Used in Schedule 9: Storage","Regen. Credit - San Luis PP",245858.42857142849,1593572.8699999999,0.13366002239999999,0.86633997760000003,1,-4133289.9169000001,-552455.62287854799,-3580834.29402145]
["Used in Schedule 9: Storage","SFU Gianelli WR PGP (Direct Pumping)",97963.71428571429,20646.714285714286,0.82592833919999997,0.1740716608,1,0,0,0]
["Used in Schedule 9: Offsetting Revenue for PUE Paid to WAPA","Offseting Revenue for PUE Paid to WAPA","-","-","-","-","-",0,574508.39702533628,2232292.6612935932]
["Used in Schedule 9: Conveyance Pumping (Direct Bill)","Corning Pumping Plant","-",5048.1428571428569,"-",1,1,190128.07060000001,0,190128.07060000001]
["Used in Schedule 9: Conveyance Pumping (Direct Bill)","Dos Amigos Pumping Plant",12093.142857142855,532529.58021781989,2.2204624100000001E-2,0.97779537589999999,1,3498761.7614308959,77688.689728026904,3421073.0717028701]
["Used in Schedule 9: Conveyance Pumping (Direct Bill)","O'Neill Pump-Gen Plt",110534.85714285714,555197.71428571432,0.16603492440000001,0.83396507559999999,1,2516857.2289,417886.19972600503,2098971.0291739898]
["Used in Schedule 9: Conveyance Pumping (Direct Bill)","Regen. Credit - O'Neill Pump-Gen Plt",110534.85714285714,555197.71428571432,0.16603492440000001,0.83396507559999999,1,0,0,0]
["Used in Schedule 9: Conveyance Pumping (Direct Bill)","Jones Pumping Plant",167935.20630785715,1204981.5657764287,0.1223200195,0.87767998049999996,1,17275721.422600001,2113166.5812889999,15162554.841311]
["Used in Schedule 9: Conveyance Pumping (Direct Bill)","In-Lieu of Jones Pumping","-","-","-","-","-",207851.62568481971,0,207851.62568481971]
["Total","Total Conveyance Pumping Direct Bill","-","-","-","-","-",0,2608741.4707430317,21080578.63847268]
["Used in Schedule 11 Page 1: Direct Pumping","Gianelli PGP - SFU  ",97963.71428571429,20646.714285714286,0.82592833919999997,0.1740716608,1,409245.34957106999,338007.33189655701,71238.017674512696]
["Used in Schedule 11 Page 1: Direct Pumping","Contra Costa PP",75905.428571428565,"-",1,"-",1,2635697.8090999997,2635697.8091000002,0]
["Used in Schedule 11 Page 1: Direct Pumping","Colusa CWD (Incl. Arb./Will O&M Office)",116.28571428571429,22405.857142857141,5.1631728E-3,0.9948368272,1,414506.39380999998,2140.1681379459001,412366.22567205399]
["Used in Schedule 11 Page 1: Direct Pumping","Kanawha WD",28.857142857142858,17809.142857142859,1.6177342000000001E-3,0.9983822658,1,47735.891799999998,77.223984732399998,47658.667815267603]
["Used in Schedule 11 Page 1: Direct Pumping","Orland-Artois WD","-",17254.142857142859,"-",1,1,91085.599800000011,0,91085.599799999996]
["Used in Schedule 11 Page 1: Direct Pumping","Pleasant Valley PP","-",18446.576923076926,"-",1,1,592583.48921618226,0,592583.48921618203]
["Used in Schedule 11 Page 1: Direct Pumping","Pleasant Valley Relifts","-",25825.207692307693,"-",1,1,86030.445500000002,0,86030.445500000002]
["Used in Schedule 11 Page 1: Direct Pumping","San Luis WD Relifts",497,30102.142857142859,1.6242284999999999E-2,0.98375771499999998,1,786905.84939999995,12781.1490741219,774124.70032587799]
["Used in Schedule 11 Page 1: Direct Pumping","Westlands WD Relifts",2971.5714285714284,435339.21538461541,6.7795991000000003E-3,0.99322040089999997,1,3442686.4033999997,23340.0336420729,3419346.3697579298]
["Used in Schedule 11 Page 1: Direct Pumping","Coyote PP - Out of Basin",45725.571428571428,6106.3571428571431,0.88218927380000001,0.11781072619999999,1,233235.58360000001,205757.93012040301,27477.6534795968]
["Used in Schedule 11 Page 1: Direct Pumping","Pacheco PP - Out of Basin",97963.71428571429,20646.714285714286,0.82592833919999997,0.1740716608,1,1201536.6128,992383.13909789699,209153.47370210299]
["Used in Schedule 11 Page 1: Paid Directly As PUE to WAPA","Paid Directly As PUE to WAPA","-","-","-","-","-",0,4210184.78505373,5731064.6429435238]
["Used in Schedule 11 Page 1: Direct Pumping","Glenn Valley WD","-",806.14285714285711,"-",1,1,0,0,0]
["Used in Schedule 11 Page 1: Direct Pumping","Corning WD","-",4810.4285714285716,"-",1,1,52166.5314,0,52166.5314]
["Used in Schedule 11 Page 1: Direct Pumping","Dunnigan WD","-",6015.8571428571431,"-",1,1,7563.1707999999999,0,7563.1707999999999]
["Used in Schedule 11 Page 1: Direct Pumping","Westside WD","-",24649,"-",1,1,43362.155599999998,0,43362.155599999998]
["Used in Schedule 11 Page 1: Direct Pumping","Proberta WD","-",171,"-",1,1,971.98090000000002,0,971.98090000000002]
["Used in Schedule 11 Page 1: Direct Pumping","Panoche WD - SLC","-",20452.428571428572,"-",1,1,876.66769999999997,0,876.66769999999997]
["Used in Schedule 11 Page 1: Direct Pumping","Pleasant Valley PP (City of Coalinga)",5430,"-",1,"-",1,174434.98378381773,174434.983783818,0]
["Used in Schedule 11 Page 1: Direct Pumping","State-Delta PP - Cross Valley Canal (CVC)",278,13460.571428571428,2.0235000499999999E-2,0.97976499949999996,1,37803.121115180198,764.92231385254354,37038.198801327657]
["Used in Schedule 11 Page 1: Direct Pumping","Dos Amigos PP - CVC (Offset with Direct Pumping)",278,13460.571428571428,2.0235000499999999E-2,0.97976499949999996,1,88259.241369105701,1785.8700852035365,86473.371283902161]
["Used in Schedule 11 Page 1: Direct Pumping","Wintu PP",3487.1428571428573,2362,0.59618014850000001,0.40381985149999999,1,148582.19990000001,88581.758000838701,60000.441899161298]
["Used in Schedule 11 Page 1: Direct Pumping","City of Shasta Lake (Shasta PP)",1120.8571428571429,"-",1,"-",1,15309.143700000001,15309.143700000001,0]
["Used in Schedule 11 Page 1: Offsetting Revenue for PUE Paid to WAPA","Offsetting Revenue for PUE Paid to WAPA","-","-","-","-","-",0,280876.67788371281,288452.51838439115]
["Total","Direct Pumping Total","-","-","-","-","-",0,4491061.4629374426,6019517.1613279153]
["Used in Schedule 11 Page 1: Other","Reimbursable Billing","-","-","-","-","-",8462.9555,0,0]
["Used in Schedule 11 Page 1: Other","Project General","-","-","-","-","-",17239.946599999999,0,0]
["Used in Schedule 11 Page 1: Other","Nonreimbursable F&W","-","-","-","-","-",56097.132500000007,0,0]
["Used in Schedule 11 Page 1: Other","Nonreimbursable Demo Treatment","-","-","-","-","-",11500.1736,0,0]
["Grand Total","Grand Total","-","-","-","-","-",37100000.000000007,7674311.3307058103,29332388.461094189]

{"sheet":"PUE to WAPA ","index":3,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["IRR 2025 Sch A-11 F.Z27.XLSM"]
["09/17/2024"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF ESTIMATED IRRIGATION DIRECT PUMPING OPERATION & MAINTENANCE COSTS"]
["2025 IRRIGATION WATER RATES"]
[]
["Category","A) Facility / Contractor\n<Ref>","B) Cost to Determine Ratio: M&I","C) Cost to Determine Ratio: Irrigation","D) Ratio: M&I","E) Ratio: Irrigation","F) Distribution: M&I","G) Distribution: Irrigation"]
["Used in Schedule 9","Offseting Revenue for Storage PUE Paid to WAPA",0,0,"-","-",574508.39702533628,2232292.6612935932]
["Used in Schedule 9","Offseting Revenue for Direct Pumping PUE Paid to WAPA",0,0,"-","-",280876.75745255739,288452.43881554651]
["Used in Schedule 9","Offsetting Revenue for Unpaid Costs from Current B6A",0,0,"-","-",0,0]
["Total","Total Offsetting Revenue",0,0,"-","-",855385.15447789361,2520745.1001091399]
["Determination of PUE sent to WAPA, Based on Direct Pumping Cost: ","Gianelli PGP - SFU  ",338007.33189655701,71238.017674512696,8.0283253385098965E-2,1.2430154275475811E-2,68673.103098800755,31333.250483506326]
["Determination of PUE sent to WAPA, Based on Direct Pumping Cost: ","Contra Costa PP",2635697.8091000002,0,0.62602900909641757,0,535495.92065358185,0]
["Determination of PUE sent to WAPA, Based on Direct Pumping Cost: ","Colusa CWD (Incl. Arb./Will O&M Office)",2140.1681379459001,412366.22567205399,5.0833116530741239E-4,7.1952813545697367E-2,434.81893236240865,181374.70218438318]
["Determination of PUE sent to WAPA, Based on Direct Pumping Cost: ","Kanawha WD",77.223984732399998,47658.667815267603,1.8342184173613289E-5,8.3158489363661589E-3,15.689632042808178,20962.135459592799]
["Determination of PUE sent to WAPA, Based on Direct Pumping Cost: ","Orland-Artois WD",0,91085.599799999996,"-",1.5893312233382462E-2,0,40062.988936803493]
["Determination of PUE sent to WAPA, Based on Direct Pumping Cost: ","Pleasant Valley PP",0,592583.48921618203,"-",0.10339850030234977,0,260641.26299578161]
["Determination of PUE sent to WAPA, Based on Direct Pumping Cost: ","Pleasant Valley Relifts",0,86030.445500000002,"-",1.5011250240551123E-2,0,37839.535490381393]
["Determination of PUE sent to WAPA, Based on Direct Pumping Cost: ","San Luis WD Relifts",12781.1490741219,774124.70032587799,3.0357691471156623E-3,0.13507519955808436,2596.7518608647542,340490.14743230544]
["Determination of PUE sent to WAPA, Based on Direct Pumping Cost: ","Westlands WD Relifts",23340.0336420729,3419346.3697579298,5.543707659799316E-3,0.59663371167311141,4742.0052329577202,1503961.505259925]
["Determination of PUE sent to WAPA, Based on Direct Pumping Cost: ","Coyote PP - Out of Basin",205757.93012040301,27477.6534795968,4.8871472542214592E-2,4.794511175760189E-3,41803.932090084367,12085.740553716008]
["Determination of PUE sent to WAPA, Based on Direct Pumping Cost: ","Pacheco PP - Out of Basin",992383.13909789699,209153.47370210299,0.235710114819873,3.6494698059221328E-2,201622.93297719912,91993.831312744704]
["Total","Total for Determining Rates to Remit to WAPA",4210184.78505373,5731064.6429435238,1.0000000000000002,1,855385.15447789384,2520745.1001091404]