{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Output","PUE","PUE to WAPA ","PUE to WAPA"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":41,"comments":1,"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":"Output","index":0,"n_rows":83,"n_cols":14,"rows_kept":83,"cut":false,"hidden":false,"merged":[]}
[]
["IRR 2026 Sch A-11 F.Z28.XLSM"]
["09/26/2025"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF ESTIMATED IRRIGATION DIRECT PUMPING OPERATION & MAINTENANCE COSTS"]
["2026 IRRIGATION WATER RATES"]
["Create PDF file button"]
[]
["Category","A) Contractor / Facility","Related Footnotes","B) 2026 Projected Deliveries \nWintu PP\n <Sch A-12>","C) 2026 Projected Deliveries Tehama-Colusa Canal Relifts Colusa County WD\n<Sch A-12>","D) 2026 Projected Deliveries Tehama-Colusa Canal Relifts Dunnigan WD\n<Sch A-12>","E) 2026 Projected Deliveries Tehama-Colusa Canal Relifts Glenn Valley WD\n<Sch A-12>","F) 2026 Projected Deliveries  Tehama-Colusa Canal Relifts Kanawha WD\n<Sch A-12>","G) 2026 Projected Deliveries Tehama-Colusa Canal Relifts Orland-Artois WD\n<Sch A-12>"," H) 2026 Projected Deliveries Tehama-Colusa Canal Relifts Westside WD\n<Sch A-12>","I) 2026 Projected Deliveries  Corning Canal Relifts \nCorning WD\n<Sch A-12>","J) 2026 Projected Deliveries Corning Canal Relifts \nProberta WD\n<Sch A-12>"]
["Corning Canal","Corning WD","-","-","-","-","-","-","-","-",5102.8571428571431,"-"]
["Corning Canal","Proberta WD","-","-","-","-","-","-","-","-","-",141]
["Cow Creek Unit","Bella Vista WD","-",2112.5714285714284,"-","-","-","-","-","-","-","-"]
["Tehama-Colusa Canal","Colusa County WD","-","-",27019.571428571428,"-","-","-","-","-","-","-"]
["Tehama-Colusa Canal","Dunnigan WD","-","-","-",6511.5714285714284,"-","-","-","-","-","-"]
["Tehama-Colusa Canal","Glenn Valley WD","-","-","-","-",892.85714285714289,"-","-","-","-","-"]
["Tehama-Colusa Canal","Kanawha WD","-","-","-","-","-",17593.571428571428,"-","-","-","-"]
["Tehama-Colusa Canal","Orland-Artois WD","-","-","-","-","-","-",18948.285714285714,"-","-","-"]
["Tehama-Colusa Canal","Westside WD","-","-","-","-","-","-","-",22762,"-","-"]
["Total","Total Deliveries","-",2113,27020,6512,893,17594,18948,22762,5103,141]
["Total","Est. 2025 Non-Recurring O&M Cost","-",0,0,0,0,0,0,0,0,0]
["Total","Est. 2025 O&M Cost","-",62218.791816069403,445554.53701430198,8539.42,0,46588.228608826197,106243.9065,47937.835400000004,61671.267599999999,1048.8067000000001]
["Total","Total (Sch. A-9)","-",62218.791816069403,445554.53701430198,8539.42,0,46588.228608826197,106243.9065,47937.835400000004,61671.267599999999,1048.8067000000001]
["Total","Direct Pumping:  Cost Per A/F Remittance to WAPA","3/",0,16.489999999999998,0,0,2.65,5.61,0,0,0]
["Total","Direct Pumping: Cost Per A/F Offset for Direct Pumping","3/",29.45,0,1.31,0,0,0,2.11,12.09,7.44]
["Total","Other PUE Remittance to WAPA:  ","3/",0,0,0,0,0,0,0,0,0]
["Total","Paid as Other PUE ","-",0,199162.73936296647,0,0,20824.923687185146,47490.993136231184,0,0,0]
["Total","Paid thru Direct Pumping PUE","-",0,7.3709378002578267,0,0,1.1836378132991443,2.5063855360054457,0,0,0]
["Total","Credit in O&M Rate for Other PUE ","-",0,-7.3709378002578267,0,0,-1.1836378132991443,-2.5063855360054457,0,0,0]
[]
["Category","A) Contractor / Facility","Related Footnotes","B) San Luis Canal Relifts \nPanoche WD\n <Sch A-12>","C) San Luis Canal Relifts \nSan Luis WD\n <Sch A-12>","D) San Luis Canal Relifts \nWestlands WD 1/ \nWestlands WD Relifts \n<Sch A-12>","E) San Luis Canal Relifts \nWestlands WD 1/ \nPleasant Valley PP \n<Sch A-12>","F) San Luis Canal Relifts \nWestlands WD 1/ \nPleasant Valley Relifts \n<Sch A-12>","G) San Luis Canal Relifts \nWestlands WD 1/ Total\nAF (D+E) Cost (D+E+F)","H) San Felipe Out-of-Basin \nGianelli PP\n","I) San Felipe Out-of-Basin \nCoyote PP\n","J) San Felipe Out-of-Basin \nPacheco PP\n","K) Cross Valley Contractors 2/\n State Delta PP\n <Sch A-12>","L) Cross Valley Contractors 2/\nDos Amigos PP\n<Sch A-12>"]
["Cross Valley Canal","County of Fresno","-","-","-","-","-","-","-","-","-","-",300,300]
["Cross Valley Canal","County of Tulare","-","-","-","-","-","-","-","-","-","-",450.57142857142856,450.57142857142856]
["Cross Valley Canal","Hills Valley ID","-","-","-","-","-","-","-","-","-","-",239,239]
["Cross Valley Canal","Kern-Tulare WD","-","-","-","-","-","-","-","-","-","-",5639.1428571428569,5639.1428571428569]
["Cross Valley Canal","Lower Tule River ID - CVC","-","-","-","-","-","-","-","-","-","-",5165,5165]
["Cross Valley Canal","Pixley ID","-","-","-","-","-","-","-","-","-","-",5170.7142857142853,5170.7142857142853]
["Cross Valley Canal","Tri-Valley WD","-","-","-","-","-","-","-","-","-","-",81.571428571428569,81.571428571428569]
["San Felipe Unit","San Benito County WD","-","-","-","-","-","-","-",9256.8571428571431,"-",9256.8571428571431,"-","-"]
["San Felipe Unit","Santa Clara Valley WD","-","-","-","-","-","-","-",16930.285714285714,16930.285714285714,16930.285714285714,"-","-"]
["San Luis Canal","Panoche WD -SLC","-",22471.714285714286,"-","-","-","-","-","-","-","-","-","-"]
["San Luis Canal","San Luis WD - SLC","-","-",28730.714285714286,"-","-","-","-","-","-","-","-","-"]
["San Luis Canal","Westlands WD - SLC","-","-","-",446438.47692307702,45400.523076923098,26483.6384615385,491839.00000000012,"-","-","-","-","-"]
["San Luis Canal","Westlands WD - SLC (DD#2)","-","-","-",1386,140.96703296710001,82.230769230800007,1526.9670329671001,"-","-","-","-","-"]
["Total","Total Deliveries","-",22472,28731,447824,45541,26566,493366,26187,16930,26187,17046,17046]
["Total","Est. 2025 Non-Recurring O&M Cost","-",0,0,0,0,0,0,0,0,0,0,0]
["Total","Est. 2025 O&M Cost","-",890.49630000000002,806892.66176203697,4071451.6647220901,791346.39533176203,100458.4289,4963256,90053.368664893394,35069.7776953676,274930.828090186,78472.239047305411,128683.787309675]
["Total","Total (Sch. A-9)","-",890.49630000000002,806892.66176203697,4071451.6647220901,791346.39533176203,100458.4289,4963256,90053.368664893394,35069.7776953676,274930.828090186,78472.239047305411,128683.787309675]
["Total","Direct Pumping:  Cost Per A/F Remittance to WAPA","3/",0,28.08,0,0,0,10.06,3.44,2.0699999999999998,10.5,0,0]
["Total","Direct Pumping: Cost Per A/F Offset for Direct Pumping","3/",0.04,0,0,0,0,0,0,0,0,4.5999999999999996,7.55]
["Total","Other PUE Remittance to WAPA:  ","3/",0,0,0,0,0,0,0,0,0,0,0]
["Total","Paid as Other PUE ","3/",0,360680.76865581184,1819937.626858758,353731.59240037919,44904.886449807527,2218574,40253.827763373403,15676.17971407947,122893.99458188575,0,0]
["Total","Paid thru Direct Pumping PUE","3/",0,12.553714407984819,0,0,0,4.4968116976038077,1.5371683569470884,0.92594091636618248,4.6929390377624678,0,0]
["Total","Credit in O&M Rate for Other PUE ","3/",0,-12.553714407984819,0,0,0,-4.4968116976038077,-1.5371683569470884,-0.92594091636618248,-4.6929390377624678,0,0]
[]
["FOOTNOTES:"]
[]
["1/ Westlands WD & Westlands WD DD#2 (DD#2) deliveries are based on firm supplies:"]
[]
["Category","Ratios ","Allocated 2025 Deliveries\n Westlands WD","Allocated 2025 Deliveries\nDD#2"]
["Westlands WD Relifts: High Side - Relift Pumps",0.52307692307692311,257269.63076923101,798.81318681319999]
["Westlands WD Relifts: Low Side (LS) - Gravity Feed",0.38461538461538464,189168.84615384601,587.36263736260003]
["Westlands WD Relifts:  Subtotal",0.9076923076923078,446438.47692307702,1386]
["Pleasant Valley PP:  High Side - Relift Pump",5.3846153846153849E-2,26483.6384615385,82.230769230800007,null,null,""]
["Pleasant Valley PP:  Coalinga Canal, LS - Gravity",3.8461538461538464E-2,18916.884615384599,58.736263736300003]
["Subtotal (Pleasant Valley PP)",9.2307692307692313E-2,45400.523076923098,140.96703296710001]
["Total - WWD Deliveries",1,491839.00000000012,1526.9670329671001]
[]
[]
["2/ Cross Valley Canal Estimated 2025 Project Use Energy Cost:"]
[]
["Category","Dos Amigos PP","State Delta PP"]
["2025 PUE Estimate - Direct Billed",4220361.1988662407,185774.73530190549]
["2025 PUE Estimate - Cross Valley Canal 2025 Projected Cost",130782.4669337563,79752.027998094505]
["Total",4351143.6657999968,265526.76329999999]
[]
["Category","Deliveries","Ratio","Dos Amigos PP","State Delta PP"]
["M&I",278,1.6047102285846226E-2,2098.6796240812891,1279.7889507890945]
["Irrigation",17046,0.98395289771415373,128683.787309675,78472.239047305411]
["Total",17324,1,130782.46693375628,79752.027998094505]
[]
["3/ 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.  "]

{"sheet":"PUE","index":1,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["IRR 2026 Sch A-11 F.Z28.XLSM"]
["09/26/2025"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF ESTIMATED IRRIGATION DIRECT PUMPING OPERATION & MAINTENANCE COSTS"]
["2026 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    ",191.42857142857144,"-",1,"-",1,16678.116600000001,16678.116600000001,0]
["Used in Schedule 9: Storage","Shasta D&R (Includes Jdg F Carr PH)",1155.5714285714284,4321.7142857142862,0.2109751963,0.78902480370000005,1,396849.08007500001,83725.312570297596,313123.76750470197]
["Used in Schedule 9: Storage","Columbia Mowry (Based on Avg. KWH's)",78304.41366509709,461744.68420240365,0.14499499020000001,0.85500500980000005,1,27104.0694,3929.9542770331,23174.115122966901]
["Used in Schedule 9: Storage","Folsom Pump Plant",30443,"-",1,0,1,103350.89279999999,103350.8928,0]
["Used in Schedule 9: Storage","New Melones Dam & Reservoir",30471.857142857141,28992.142857142855,0.51244210180000005,0.48755789820000001,1,0,0,0]
["Used in Schedule 9: Storage","Gianelli WR Pump-Gen Plt  ",254422.71428571432,1683185.4761904764,0.1313076171,0.86869238289999995,1,6663122.6501423698,874918.75763523101,5788203.8925071396]
["Used in Schedule 9: Storage","Regen. Credit - San Luis PP",254422.71428571432,1683185.4761904764,0.1313076171,0.86869238289999995,1,-4015698.7160999998,-527291.82940261997,-3488406.8866973799]
["Used in Schedule 9: Storage","SFU Gianelli WR PGP (Direct Pumping)",90985.42857142858,26187.142857142855,0.77650791019999998,0.22349208979999999,1,0,0,0]
["Used in Schedule 9: Offsetting Revenue for PUE Paid to WAPA","Offseting Revenue for PUE Paid to WAPA","-","-","-","-","-",0,555311.20447994163,2636094.8884374285]
["Used in Schedule 9: Conveyance Pumping (Direct Bill)","Corning Pumping Plant","-",5296,"-",1,1,223885.06660000002,0,223885.06659999999]
["Used in Schedule 9: Conveyance Pumping (Direct Bill)","Dos Amigos Pumping Plant",12092.285714285714,546954.6501887677,2.16301798E-2,0.97836982019999996,1,4220361.1988662407,91287.171552420303,4129074.0273138201]
["Used in Schedule 9: Conveyance Pumping (Direct Bill)","O'Neill Pump-Gen Plt",103525.71428571429,575075.85714285716,0.1525574338,0.84744256620000002,1,3890071.6063999999,593459.34157062799,3296612.2648293702]
["Used in Schedule 9: Conveyance Pumping (Direct Bill)","Regen. Credit - O'Neill Pump-Gen Plt",103525.71428571429,575075.85714285716,0.1525574338,0.84744256620000002,1,-189885.6765,-28968.471522217002,-160917.204977783]
["Used in Schedule 9: Conveyance Pumping (Direct Bill)","Jones Pumping Plant",160438.26103814284,1236771.9298301428,0.1148275772,0.88517242279999997,1,19744254.249000002,2267184.8790334798,17477069.3699665]
["Used in Schedule 9: Conveyance Pumping (Direct Bill)","In-Lieu of Jones Pumping","-","-","-","-","-",185774.73530190549,0,185774.73530190549]
["Total","Total Conveyance Pumping Direct Bill","-","-","-","-","-",0,2922962.9206343112,25151498.25903381]
["Used in Schedule 11 Page 1: Direct Pumping","Gianelli PGP - SFU  ",90985.42857142858,26187.142857142855,0.77650791019999998,0.22349208979999999,1,402937.61065763398,312884.24199274101,90053.368664893394]
["Used in Schedule 11 Page 1: Direct Pumping","Contra Costa PP",77293.857142857145,0,1,"-",1,2862652.6828000001,2862652.6828000001,0]
["Used in Schedule 11 Page 1: Direct Pumping","Colusa CWD (Incl. Arb./Will O&M Office)",110.42857142857143,27019.571428571428,4.0703490999999996E-3,0.99592965089999996,1,447375.51152499998,1820.9745106978,445554.53701430198]
["Used in Schedule 11 Page 1: Direct Pumping","Kanawha WD",32.428571428571431,17593.571428571428,1.8398145999999999E-3,0.99816018539999996,1,46674.100299999998,85.871691173800002,46588.228608826197]
["Used in Schedule 11 Page 1: Direct Pumping","Orland-Artois WD","-",18948.285714285714,"-",1,1,106243.90649999998,0,106243.9065]
["Used in Schedule 11 Page 1: Direct Pumping","Pleasant Valley PP","-",24823.453728661276,"-",1,1,791346.39533176168,0,791346.39533176203]
["Used in Schedule 11 Page 1: Direct Pumping","Pleasant Valley Relifts","-",34132.248876909252,"-",1,1,100458.4289,0,100458.4289]
["Used in Schedule 11 Page 1: Direct Pumping","San Luis WD Relifts",466.85714285714283,28730.714285714286,1.5989588200000002E-2,0.98401041180000004,1,820004.19109999971,13111.5293379631,806892.66176203697]
["Used in Schedule 11 Page 1: Direct Pumping","Westlands WD Relifts",3164.5714285714284,434410.44025157235,7.2320661000000001E-3,0.99276793389999995,1,4101111.1718000011,29659.507077906099,4071451.6647220901]
["Used in Schedule 11 Page 1: Direct Pumping","Coyote PP - Out of Basin",42949.357142857145,8465.1428571428569,0.83535495130000004,0.16464504869999999,1,213002.32209999999,177932.544404632,35069.7776953676]
["Used in Schedule 11 Page 1: Direct Pumping","Pacheco PP - Out of Basin",90985.42857142858,26187.142857142855,0.77650791019999998,0.22349208979999999,1,1230159.1002,955228.27210981399,274930.828090186]
["Used in Schedule 11 Page 1: Paid Directly As PUE to WAPA","Paid Directly As PUE to WAPA","-","-","-","-","-",0,4353375.6239249278,6768589.7972894646]
["Used in Schedule 11 Page 1: Direct Pumping","Glenn Valley WD","-",892.85714285714289,"-",1,1,0,0,0]
["Used in Schedule 11 Page 1: Direct Pumping","Corning WD","-",5102.8571428571431,"-",1,1,61671.267599999999,0,61671.267599999999]
["Used in Schedule 11 Page 1: Direct Pumping","Dunnigan WD","-",6511.5714285714284,"-",1,1,8539.42,0,8539.42]
["Used in Schedule 11 Page 1: Direct Pumping","Westside WD","-",22762,"-",1,1,47937.835399999996,0,47937.835400000004]
["Used in Schedule 11 Page 1: Direct Pumping","Proberta WD","-",141,"-",1,1,1048.8067000000001,0,1048.8067000000001]
["Used in Schedule 11 Page 1: Direct Pumping","Panoche WD - SLC","-",22471.714285714286,"-",1,1,890.49630000000002,0,890.49630000000002]
["Used in Schedule 11 Page 1: Direct Pumping","Pleasant Valley PP (City of Coalinga)",5182.8571428571431,"-",1,0,1,165224.20136823819,165224.20136823799,0]
["Used in Schedule 11 Page 1: Direct Pumping","State-Delta PP - Cross Valley Canal (CVC)",278,17046,1.6047102300000001E-2,0.98395289770000005,1,79752.027998094505,1279.7889507890945,78472.239047305411]
["Used in Schedule 11 Page 1: Direct Pumping","Dos Amigos PP - CVC (Offset with Direct Pumping)",278,17046,1.6047102300000001E-2,0.98395289770000005,1,130782.46693375628,2098.6796240812891,128683.787309675]
["Used in Schedule 11 Page 1: Direct Pumping","Wintu PP",3495,2112.5714285714284,0.62326446390000001,0.37673553609999999,1,165152.4368,102933.64498393099,62218.791816069403]
["Used in Schedule 11 Page 1: Direct Pumping","City of Shasta Lake (Shasta PP)",937.14285714285711,0,1,"-",1,53001.571400000001,53001.571400000001,0]
["Used in Schedule 11 Page 1: Offsetting Revenue for PUE Paid to WAPA","Offsetting Revenue for PUE Paid to WAPA","-","-","-","-","-",0,324537.88632703939,389462.64417304983]
["Total","Direct Pumping Total","-","-","-","-","-",0,4677913.5102519672,7158052.4414625149]
["Used in Schedule 11 Page 1: Other","Reimbursable Billing","-","-","-","-","-",8882.9754999999986,0,0]
["Used in Schedule 11 Page 1: Other","Project General","-","-","-","-","-",18022.106400000001,0,0]
["Used in Schedule 11 Page 1: Other","Nonreimbursable F&W","-","-","-","-","-",60460.302600000003,0,0]
["Used in Schedule 11 Page 1: Other","Nonreimbursable Demo Treatment","-","-","-","-","-",10801.3905,0,0]
["Grand Total","Grand Total","-","-","-","-","-",43199999.999300003,8156187.63536622,34945645.588933751]

{"sheet":"PUE to WAPA ","index":2,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["IRR 2026 Sch A-11 F.Z28.XLSM"]
["09/26/2025"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF ESTIMATED IRRIGATION DIRECT PUMPING OPERATION & MAINTENANCE COSTS"]
["2026 IRRIGATION WATER RATES"]
[null,null,null,null,null,null,null,null,null,""]
["A) Ref","B) Acre-Feet - M&I <Sch A-12>","C) Acre-Feet - Irrigation <Sch A-12>","D) Ratio of Acre-Feet - M&I","E) Ratio of Acre-Feet - Irrigation","F) Ratio of Acre-Feet - Total","B) Cost to Determine Ratio - Total <Meter Costs>","C) Cost to Determine Ratio - M&I","D) Cost to Determine Ratio - Irrigation","E) Ratio - M&I","F) Ratio - Irrigation","G) Distribution - Total","H) Distribution - M&I","I) Distribution - Irrigation"]
["Friant D&R    ",191.42857142857144,"N/A",1,"-",1,16678.116600000001,16678.116600000001,0,"-","-",0,0,0]
["Shasta D&R (Includes Jdg F Carr PH)",1155.5714285714284,4321.7142857142862,0.2109751963,0.78902480370000005,1,396849.08007500001,83725.312570297596,313123.76750470197,"-","-",0,0,0]
["Columbia Mowry (Based on Avg. KWH's)",78304.41366509709,461744.68420240365,0.14499499020000001,0.85500500980000005,1,27104.0694,3929.9542770331,23174.115122966901,"-","-",0,0,0]
["Folsom Pump Plant",30443,"N/A",1,0,1,103350.89279999999,103350.8928,0,"-","-",0,0,0]
["New Melones Dam & Reservoir",30471.857142857141,28992.142857142855,0.51244210180000005,0.48755789820000001,1,0,0,0,"-","-",0,0,0]
["Gianelli WR Pump-Gen Plt  ",254422.71428571432,1683185.4761904764,0.1313076171,0.86869238289999995,1,3594343.7035750002,471964.70675482199,3122378.9968201802,"-","-",0,0,0]
["Regen. Credit - San Luis PP",254422.71428571432,1683185.4761904764,0.1313076171,0.86869238289999995,1,-4015698.7160999998,-527291.82940261997,-3488406.8866973799,"-","-",0,0,0]
["SFU Gianelli WR PGP (Direct Pumping)",90985.42857142858,26187.142857142855,0.77650791019999998,0.22349208979999999,1,0,0,0,"-","-",0,0,0]
["Offseting Revenue for Storage PUE Paid to WAPA","-","-","-","-","-",0,0,0,"-","-",0,555311.20447994163,2636094.8884374285]
["Offseting Revenue for Direct Pumping PUE Paid to WAPA","-","-","-","-","-",0,0,0,"-","-",0,324537.88632703939,389462.64417304983]
["Offsetting Revenue for Unpaid Costs from Current B6A","-","-","-","-","-",0,0,0,"-","-",0,0,0]
["Total Offsetting Revenue","-","-","-","-","-",0,0,0,"-","-",0,879849.09080698108,3025557.5326104783]
[]
[" Determination of PUE sent to WAPA: Based on Direct Pumping Cost:"]
["A) Ref","B) Acre-Feet - M&I <Sch A-12>","C) Acre-Feet - Irrigation <Sch A-12>","D) Ratio of Acre-Feet - M&I","E) Ratio of Acre-Feet - Irrigation","F) Ratio of Acre-Feet - Total","G) Cost to Determine Ratio - Total <Meter Costs>","H) Cost to Determine Ratio - M&I","I) Cost to Determine Ratio - Irrigation","J) Ratio - M&I","K) Ratio - Irrigation","L) Distribution - Total","M) Distribution - M&I","N) Distribution - Irrigation"]
["Gianelli PGP - SFU  ",90985.42857142858,26187.142857142855,"-","-","-",402937.61065763398,312884.24199274101,90053.368664893394,7.1871639165069334E-2,1.3304598352371121E-2,103490.02413756706,63236.196374193663,40253.827763373403]
["Contra Costa PP",77293.857142857145,0,1,"-",1,2862652.6828000001,2862652.6828000001,0,0.65757079794990958,"-",578563.06871744897,578563.06871744897,0]
["Colusa CWD (Incl. Arb./Will O&M Office)",110.42857142857143,27019.571428571428,4.0703490999999996E-3,0.99592965089999996,1,447375.51152499998,1820.9745106978,445554.53701430198,4.1829023452289219E-4,6.5826789679694853E-2,199530.77164550486,368.03228253840558,199162.73936296647]
["Kanawha WD",32.428571428571431,17593.571428571428,1.8398145999999999E-3,0.99816018539999996,1,46674.100299999998,85.871691173800002,46588.228608826197,1.9725311710267625E-5,6.8830036985669928E-3,20842.278984759309,17.355297574163266,20824.923687185146]
["Orland-Artois WD","N/A",18948.285714285714,0,1,1,106243.90649999998,0,106243.9065,0,1.5696608847908942E-2,47490.993136231184,0,47490.993136231184]
["Pleasant Valley PP",5182.8571428571431,24823.453728661276,0.17272556980000001,0.82727443020000002,1,791346.39533176168,0,791346.39533176203,0,0.11691451528775801,353731.59240037919,0,353731.59240037919]
["Pleasant Valley Relifts","N/A",34132.248876909252,0,1,1,100458.4289,0,100458.4289,0,1.4841855084825701E-2,44904.886449807527,0,44904.886449807527]
["San Luis WD Relifts",466.85714285714283,28730.714285714286,1.5989588200000002E-2,0.98401041180000004,1,820004.19109999971,13111.5293379631,806892.66176203697,3.0118074962118646E-3,0.11921134031274336,363330.7047430395,2649.9360872276593,360680.76865581184]
["Westlands WD Relifts",3164.5714285714284,434410.44025157235,7.2320661000000001E-3,0.99276793389999995,1,4101111.1718000011,29659.507077906099,4071451.6647220901,6.8129905710193695E-3,0.60152140795303255,1825932.0304183459,5994.4035595879268,1819937.626858758]
["Coyote PP - Out of Basin",42949.357142857145,8465.1428571428569,0.83535495130000004,0.16464504869999999,1,213002.32209999999,177932.544404632,35069.7776953676,4.0872316054411842E-2,5.1812532219653153E-3,51637.649833729301,35961.470119649835,15676.17971407947]
["Pacheco PP - Out of Basin",90985.42857142858,26187.142857142855,0.77650791019999998,0.22349208979999999,1,1230159.1002,955228.27210981399,274930.828090186,0.21942243321714491,4.0618627561133075E-2,315952.62295064621,193058.62836876049,122893.99458188575]
["Total for Determining Rates to Remit to WAPA","-","-","-","-","-",0,4353375.6239249278,6768589.7972894646,1,0.99999999999999989,3905406.6234174594,879849.09080698108,3025557.5326104783]

{"sheet":"PUE to WAPA","index":3,"n_rows":58,"n_cols":25,"rows_kept":58,"cut":false,"hidden":true,"merged":[]}
[{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Output!$A$4","v":"CENTRAL VALLEY PROJECT"}]
[{"$f":"Output!$A$5","v":"SCHEDULE OF ESTIMATED IRRIGATION DIRECT PUMPING OPERATION & MAINTENANCE COSTS"}]
[{"$f":"Output!$A$6","v":"2026 IRRIGATION WATER RATES"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["A",null,null,null,null,"B",null,"C",null,"D",null,"E","F","B","C","D","E","F","G","H","I "]
[null,null,null,null,null,"Acre-Feet",null,null,null,"Ratio of Acre-Feet",null,null,null,"Cost to Determine Ratio",null,null,"Ratio",null,"Distribution"]
[null,null,null,null,null,"M&I",null,"Irrigation",null,"M&I",null,"Irrigation","Total","Total","M&I","Irrigation","M&I","Irrigation","Total","M&I","Irrigation"]
["Ref",null,null,null,null,"<Sch A-12>",null,"<Sch A-12>",null,"(C/(C+D))",null,"(D/(C+D))","(E+F)","<Meter Costs>"]
[]
[]
[null,"  Friant D&R    ",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,"N/A",null,{"$f":"ROUND(F14/SUM(F14:H14),10)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(H14/SUM(F14:H14),10)","v":{"$error":"#REF!"}},{"$f":"SUM(J14:L14)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(J14*N14,10)","v":{"$error":"#REF!"}},{"$f":"ROUND(L14*N14,10)","v":{"$error":"#REF!"}}]
[null,"  Shasta D&R (Includes Jdg F Carr PH)",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"  Columbia Mowry (Based on Avg. KWH's)",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"  Folsom Pump Plant",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,"N/A",null,{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"  New Melones Dam & Reservoir",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"  Gianelli WR Pump-Gen Plt  ",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"PUE!H13","v":6663122.6501423698},{"$f":"ROUND(J19*N19,10)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"  Regen. Credit - San Luis PP",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"  SFU Gianelli WR PGP (Direct Pumping)",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Offseting Revenue for Storage PUE Paid to WAPA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PUE!#REF!","v":{"$error":"#REF!"}},{"$f":"PUE!#REF!","v":{"$error":"#REF!"}}]
[null,"Offseting Revenue for Direct Pumping PUE Paid to WAPA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PUE!I47","v":324537.88632703939},{"$f":"PUE!J47","v":389462.64417304983}]
[null,"Offsetting Revenue for Unpaid Costs from Current B6A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Total Offsetting Revenue",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T22:T24)","v":{"$error":"#REF!"}},{"$f":"SUM(U22:U24)","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Determination of PUE sent to WAPA:"]
[null," Based on Direct Pumping Cost:"]
[]
[null,"  Gianelli PGP - SFU  ",null,null,null,{"$f":"F21","v":{"$error":"#REF!"}},null,{"$f":"H21","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"SUM(J39:L39)","v":0},{"$f":"PUE!H24","v":402937.61065763398},{"$f":"PUE!I24","v":312884.24199274101},{"$f":"PUE!J24","v":90053.368664893394},{"$f":"O39/O$58","v":{"$error":"#REF!"}},{"$f":"P39/P$58","v":{"$error":"#REF!"}},{"$f":"SUM(T39:U39)","v":{"$error":"#REF!"}},{"$f":"Q39*T$25","v":{"$error":"#REF!"}},{"$f":"R39*U$25","v":{"$error":"#REF!"}}]
[null,"  Contra Costa PP",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"ROUND(F40/SUM(F40:H40),10)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(H40/SUM(F40:H40),10)","v":{"$error":"#REF!"}},{"$f":"SUM(J40:L40)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"PUE!I25","v":2862652.6828000001},{"$f":"PUE!J25","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(T40:U40)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"  Colusa CWD (Incl. Arb./Will O&M Office)",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"ROUND(F41/SUM(F41:H41),10)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"SUM(J41:L41)","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"PUE!I26","v":1820.9745106978},{"$f":"PUE!J26","v":445554.53701430198},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PUE!#REF!","v":{"$error":"#REF!"}},{"$f":"PUE!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PUE!#REF!","v":{"$error":"#REF!"}},{"$f":"PUE!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"  Kanawha WD",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"ROUND(F44/SUM(F44:H44),10)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"PUE!I27","v":85.871691173800002},{"$f":"PUE!J27","v":46588.228608826197},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"  Orland-Artois WD",null,null,null,"N/A",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"PUE!I28","v":0},{"$f":"PUE!J28","v":106243.9065},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PUE!#REF!","v":{"$error":"#REF!"}},{"$f":"PUE!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"  Pleasant Valley PP",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"PUE!H29","v":791346.39533176168},0,{"$f":"PUE!J29","v":791346.39533176203},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$f":"PUE!H29","v":791346.39533176168},"Pleasant Valley PP"]
[null,"  Pleasant Valley Relifts",null,null,null,"N/A",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"PUE!I30","v":0},{"$f":"PUE!J30","v":100458.4289},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$f":"PUE!H42","v":165224.20136823819}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PUE!#REF!","v":{"$error":"#REF!"}},{"$f":"PUE!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"  San Luis WD Relifts",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"PUE!I31","v":13111.5293379631},{"$f":"PUE!J31","v":806892.66176203697},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$f":"SUM(X47:X49)","v":956570.59669999988},"Total, see PUE tab"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PUE!#REF!","v":{"$error":"#REF!"}},{"$f":"PUE!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PUE!#REF!","v":{"$error":"#REF!"}},{"$f":"PUE!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"  Westlands WD Relifts",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$error":"#REF!"},{"$f":"SUM(J53:L53)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"PUE!I32","v":29659.507077906099},{"$f":"PUE!J32","v":4071451.6647220901},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PUE!#REF!","v":{"$error":"#REF!"}},{"$f":"PUE!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PUE!#REF!","v":{"$error":"#REF!"}},{"$f":"PUE!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"  Coyote PP - Out of Basin",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"ROUND(F56/SUM(F56:H56),10)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(H56/SUM(F56:H56),10)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"PUE!I33","v":177932.544404632},{"$f":"PUE!J33","v":35069.7776953676},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"  Pacheco PP - Out of Basin",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"ROUND(F57/SUM(F57:H57),10)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(H57/SUM(F57:H57),10)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"PUE!I34","v":955228.27210981399},{"$f":"PUE!J34","v":274930.828090186},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Total for Determining Rates to Remit to WAPA",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O39:O57)","v":{"$error":"#REF!"}},{"$f":"SUM(P39:P57)","v":{"$error":"#REF!"}},{"$f":"SUM(Q39:Q57)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]