{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["OUTPUT","PUE","PUE to WAPA"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":33,"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":"OUTPUT","index":0,"n_rows":67,"n_cols":13,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
[]
["M&I 2026 Sch A-11 F.Z28.XLSM"]
["09/15/25"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF ESTIMATED M&I DIRECT PUMPING OPERATION & MAINTENANCE COSTS"]
["2026 M&I WATER RATES"]
[]
["Category","A) Contractor / Facility","Related Footnotes","B) Projected 2026 Deliveries:  Contra Costa PP\n\n<Sch A-12>","C) Projected 2026 Deliveries:  Dos Amigos PP-CVC\n\n<Sch A-12>","D) Projected 2026 Deliveries:  Pleasant Valley PP\n\n<Sch A-12>","E) Projected 2026 Deliveries: San Luis WD Relifts\n\n<Sch A-12>","F) Projected 2026 Deliveries: State-Delta PP\n\n<Sch A-12>","G) Projected 2026 Deliveries: T-C Canal Relifts Colusa County WD\n\n<Sch A-12>","H) Projected 2026 Deliveries: T-C Canal Relifts Kanawha WD\n\n<Sch A-12>","I) Projected 2026 Deliveries: Westlands WD Relifts\n\n<Sch A-12>","J) Projected 2026 Deliveries: Wintu PP\n\n<Sch A-12>","K) Projected 2026 Deliveries: Shasta PP\n\n<Sch A-12>"]
["Contra Costa Canal","Contra Costa WD","-",77293.857142857145,"-","-",0,"-","-","-","-","-","-"]
["Cow Creek Unit","Bella Vista WD","-","-","-","-","-","-","-","-","-",3495,"-"]
["Cross Valley Canal","County of Fresno","-","-",86,"-","-",86,"-","-","-","-","-"]
["Cross Valley Canal","County of Tulare","-","-",192,"-","-",192,"-","-","-","-","-"]
["San Luis Canal - Fresno","City of Coalinga","-","-","-",5182.8571428571431,"-","-","-","-","-","-","-"]
["San Luis Canal - Fresno","Westlands WD","-","-","-","-","-","-","-","-",3164.5714285714284,"-","-"]
["San Luis Canal - Tracy","San Luis WD","-","-","-","-",466.85714285714283,"-","-","-","-","-","-"]
["Tehama-Colusa Canal","Colusa County WD","-","-","-","-","-","-",110.42857142857143,"-","-","-","-"]
["Tehama-Colusa Canal","Kanawha WD","-","-","-","-","-","-","-",32.428571428571431,"-","-","-"]
["Toyon Pipeline","City of Shasta Lake","-","-","-","-","-","-","-","-","-","-",937.14285714285711]
["Total","Total Deliveries","-",77293.857142857145,278,5182.8571428571431,466.85714285714283,278,110.42857142857143,32.428571428571431,3164.5714285714284,3495,937.14285714285711]
["Other","Est. 2026 Non-Recurring O&M Cost","-",0,0,0,0,0,0,0,0,0,0]
["Other","Est. 2026 O&M Cost","-",2862652.6828000001,2098.6796259324001,165224.20136823799,13111.5293379631,1279.7889519179,1820.9745106978,85.871691173800002,29659.507077906099,102933.64498393099,53001.571400000001]
["Total","Total (Sch. A-9)","-",2862652.6828000001,2098.6796259324001,165224.20136823799,13111.5293379631,1279.7889519179,1820.9745106978,85.871691173800002,29659.507077906099,102933.64498393099,53001.571400000001]
["Direct Pumping","Cost Per A/F Remittance to WAPA","1/",37.04,0,0,28.08,0,16.489999999999998,2.65,9.3699999999999992,0,0]
["Direct Pumping","Cost Per A/F Offset for Direct Pumping","1/",0,7.55,31.88,0,4.5999999999999996,0,0,0,29.45,56.56]
["Other PUE Remittance to WAPA","Paid as Other PUE","1/",578563.06871940836,0,0,2649.9360872366337,0,368.03228253965199,17.355297574222043,5994.4035596082285,0,0]
["Other PUE Remittance to WAPA","Paid thru Direct Pumping PUE","1/",7.4852399673894956,0,0,5.6761176899193506,0,3.332763231277573,0.5351853877513405,1.8942228655316722,0,0]
["Other PUE Remittance to WAPA","Credit in O&M Rate for Other PUE","1/",-7.4852399673894956,0,0,-5.6761176899193506,0,-3.332763231277573,-0.5351853877513405,-1.8942228655316722,0,0]
[]
[]
["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","-",5086.7142857142853,"-",5086.7142857142853]
["San Felipe Unit","Santa Clara Valley WD","-",85898.71428571429,85898.71428571429,85898.71428571429]
["Total","Total San Felipe Unit","-",90985.42857142858,85898.71428571429,90985.42857142858]
["Other","Est. 2026 Non-Recurring O&M Cost","-",0,0,0]
["Other","Est. 2026 O&M Cost","-",312884.24199274101,177932.544404632,955228.27210981399]
["Total","Total (Sch. A-9)","-",312884.24199274101,177932.544404632,955228.27210981399]
["Direct Pumping","Cost Per A/F Remittance to WAPA","1/",3.44,2.0699999999999998,10.5]
["Direct Pumping","Cost Per A/F Offset for Direct Pumping","1/",0,0,0]
["Other PUE Remittance to WAPA","Paid as Other PUE","1/",63236.196374407824,35961.470119771628,193058.62836941431]
["Other PUE Remittance to WAPA","Paid thru Direct Pumping PUE","1/",0.69501454647503169,0.41864969014736853,2.1218631532614327]
["Other PUE Remittance to WAPA","Credit in O&M Rate for Other PUE","1/",-0.69501454647503169,-0.41864969014736853,-2.1218631532614327]
[]
["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,{"$f":"D59/#REF!","v":{"$error":"#REF!"}},{"$f":"E59/#REF!","v":{"$error":"#REF!"}},{"$f":"F59/#REF!","v":{"$error":"#REF!"}}]
[]
[null,null,null,{"$f":"#REF!+D62","v":{"$error":"#REF!"}},{"$f":"#REF!+E62","v":{"$error":"#REF!"}},{"$f":"#REF!+F62","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,{"$f":"-D62","v":{"$error":"#REF!"}},{"$f":"-E62","v":{"$error":"#REF!"}},{"$f":"-F62","v":{"$error":"#REF!"}}]

{"sheet":"PUE","index":1,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[]
["M&I 2026 Sch A-11 F.Z28.XLSM"]
["09/15/25"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF ESTIMATED M&I DIRECT PUMPING OPERATION & MAINTENANCE COSTS"]
["2026 M&I 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,"-",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,0,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,"-",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,"-",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.7889519179,78472.239046176604]
["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.6796259324001,128683.78730782399]
["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,0,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.88633001928,389462.64417007001]
["Total","Direct Pumping Total","-","-","-","-","-",0,4677913.5102549475,7158052.4414595347]
["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.6353692003,34945645.588930771]

{"sheet":"PUE to WAPA","index":2,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
["M&I 2026 Sch A-11 F.Z28.XLSM"]
["09/15/25"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF ESTIMATED M&I DIRECT PUMPING OPERATION & MAINTENANCE COSTS"]
["2026 M&I 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","  Friant D&R    ",{"$error":"#REF!"},{"$error":"#REF!"},"-","-","-","-"]
["Used in Schedule 9","  Shasta D&R (Includes Jdg F Carr PH)",{"$error":"#REF!"},{"$error":"#REF!"},"-","-","-","-"]
["Used in Schedule 9","  Columbia Mowry (Based on Avg. KWH's)",{"$error":"#REF!"},{"$error":"#REF!"},"-","-","-","-"]
["Used in Schedule 9","  Folsom Pump Plant",{"$error":"#REF!"},{"$error":"#REF!"},"-","-","-","-"]
["Used in Schedule 9","  New Melones Dam & Reservoir",{"$error":"#REF!"},{"$error":"#REF!"},"-","-","-","-"]
["Used in Schedule 9","  Gianelli WR Pump-Gen Plt  ",{"$error":"#REF!"},{"$error":"#REF!"},"-","-","-","-"]
["Used in Schedule 9","  Regen. Credit - San Luis PP",{"$error":"#REF!"},{"$error":"#REF!"},"-","-","-","-"]
["Used in Schedule 9","  SFU Gianelli WR PGP (Direct Pumping)",{"$error":"#REF!"},{"$error":"#REF!"},"-","-","-","-"]
["Used in Schedule 9","Offseting Revenue for Storage PUE Paid to WAPA",0,0,"-","-",555311.20447994163,2636094.8884374285]
["Used in Schedule 9","Offseting Revenue for Direct Pumping PUE Paid to WAPA",0,0,"-","-",324537.88633001928,389462.64417007001]
["Used in Schedule 9","Offsetting Revenue for Unpaid Costs from Current B6A",0,0,"-","-",0,0]
["Total","Total Offsetting Revenue",0,0,"-","-",879849.09080996085,3025557.5326074986]
["Determination of PUE sent to WAPA, Based on Direct Pumping Cost: ","Gianelli PGP - SFU  ",312884.24199274101,90053.368664893394,7.1871639165069334E-2,1.3304598352371121E-2,63236.196374407824,40253.827763333757]
["Determination of PUE sent to WAPA, Based on Direct Pumping Cost: ","Contra Costa PP",2862652.6828000001,0,0.65757079794990958,0,578563.06871940836,0]
["Determination of PUE sent to WAPA, Based on Direct Pumping Cost: ","Colusa CWD (Incl. Arb./Will O&M Office)",1820.9745106978,445554.53701430198,4.1829023452289219E-4,6.5826789679694853E-2,368.03228253965199,199162.73936277031]
["Determination of PUE sent to WAPA, Based on Direct Pumping Cost: ","Kanawha WD",85.871691173800002,46588.228608826197,1.9725311710267625E-5,6.8830036985669928E-3,17.355297574222043,20824.923687164639]
["Determination of PUE sent to WAPA, Based on Direct Pumping Cost: ","Orland-Artois WD",0,106243.9065,"-",1.5696608847908942E-2,0,47490.993136184406]
["Determination of PUE sent to WAPA, Based on Direct Pumping Cost: ","Pleasant Valley PP",0,791346.39533176203,"-",0.11691451528775801,0,353731.59240003082]
["Determination of PUE sent to WAPA, Based on Direct Pumping Cost: ","Pleasant Valley Relifts",0,100458.4289,"-",1.4841855084825701E-2,0,44904.886449763304]
["Determination of PUE sent to WAPA, Based on Direct Pumping Cost: ","San Luis WD Relifts",13111.5293379631,806892.66176203697,3.0118074962118646E-3,0.11921134031274336,2649.9360872366337,360680.7686554566]
["Determination of PUE sent to WAPA, Based on Direct Pumping Cost: ","Westlands WD Relifts",29659.507077906099,4071451.6647220901,6.8129905710193695E-3,0.60152140795303255,5994.4035596082285,1819937.6268569657]
["Determination of PUE sent to WAPA, Based on Direct Pumping Cost: ","Coyote PP - Out of Basin",177932.544404632,35069.7776953676,4.0872316054411842E-2,5.1812532219653153E-3,35961.470119771628,15676.179714064032]
["Determination of PUE sent to WAPA, Based on Direct Pumping Cost: ","Pacheco PP - Out of Basin",955228.27210981399,274930.828090186,0.21942243321714491,4.0618627561133075E-2,193058.62836941431,122893.99458176472]
["Total","Total for Determining Rates to Remit to WAPA",4353375.6239249278,6768589.7972894646,1,0.99999999999999989,879849.09080996085,3025557.5326074986]