{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["OUTPUT1","OUTPUT2","Footnotes","PUE","PUE to WAPA ","PUE to WAPA"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":78,"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":"OUTPUT1","index":0,"n_rows":27,"n_cols":12,"rows_kept":27,"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","Related Footnotes","B) 2025 Projected Deliveries \nWintu PP\n <Sch A-12>","C) 2025 Projected Deliveries Tehama-Colusa Canal Relifts Colusa County WD\n<Sch A-12>","D) 2025 Projected Deliveries Tehama-Colusa Canal Relifts Dunnigan WD\n<Sch A-12>","E) 2025 Projected Deliveries Tehama-Colusa Canal Relifts Glenn Valley WD\n<Sch A-12>","F) 2025 Projected Deliveries  Tehama-Colusa Canal Relifts Kanawha WD\n<Sch A-12>","G) 2025 Projected Deliveries Tehama-Colusa Canal Relifts Orland-Artois WD\n<Sch A-12>"," H) 2025 Projected Deliveries Tehama-Colusa Canal Relifts Westside WD\n<Sch A-12>","I) 2025 Projected Deliveries  Corning Canal Relifts \nCorning WD\n<Sch A-12>","J) 2025 Projected Deliveries Corning Canal Relifts \nProberta WD\n<Sch A-12>"]
["Corning Canal","Corning WD","-","-","-","-","-","-","-","-",4810.4285714285716,"-"]
["Corning Canal","Proberta WD","-","-","-","-","-","-","-","-","-",171]
["Cow Creek Unit","Bella Vista WD","-",2362,"-","-","-","-","-","-","-","-"]
["Tehama-Colusa Canal","Colusa County WD","-","-",22405.857142857141,"-","-","-","-","-","-","-"]
["Tehama-Colusa Canal","Dunnigan WD","-","-","-",6015.8571428571431,"-","-","-","-","-","-"]
["Tehama-Colusa Canal","Glenn Valley WD","-","-","-","-",806.14285714285711,"-","-","-","-","-"]
["Tehama-Colusa Canal","Kanawha WD","-","-","-","-","-",17809.142857142859,"-","-","-","-"]
["Tehama-Colusa Canal","Orland-Artois WD","-","-","-","-","-","-",17254.142857142859,"-","-","-"]
["Tehama-Colusa Canal","Westside WD","-","-","-","-","-","-","-",24649,"-","-"]
["Total","Total Deliveries","-",2362,22406,6016,806,17809,17254,24649,4810,171]
["Total","Est. 2025 Non-Recurring O&M Cost","-",0,0,0,0,0,0,0,0,0]
["Total","Est. 2025 O&M Cost","-",60000.441899161298,412366.22567205399,7563.1707999999999,0,47658.667815267603,91085.599799999996,43362.155599999998,52166.5314,971.98090000000002]
["Total","Total (Sch. A-9)","-",60000.441899161298,412366.22567205399,7563.1707999999999,0,47658.667815267603,91085.599799999996,43362.155599999998,52166.5314,971.98090000000002]
["Total","Direct Pumping:  Cost Per A/F Remittance to WAPA","3/",0,18.399999999999999,0,0,2.68,5.28,0,0,0]
["Total","Direct Pumping: Cost Per A/F Offset for Direct Pumping","3/",25.4,0,1.26,0,0,0,1.76,10.85,5.68]
["Total","Other PUE Remittance to WAPA:  ","3/",0,0,0,0,0,0,0,0,0]
["Total","Paid as Other PUE ","-",0,181374.70790958541,0,0,20962.136121275285,40062.990201415982,0,0,0]
["Total","Paid thru Direct Pumping PUE","-",0,8.0949168932243776,0,0,1.1770529575650113,2.3219537615286878,0,0,0]
["Total","Credit in O&M Rate for Other PUE ","-",0,-8.0949168932243776,0,0,-1.1770529575650113,-2.3219537615286878,0,0,0]

{"sheet":"OUTPUT2","index":1,"n_rows":31,"n_cols":14,"rows_kept":31,"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","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","-","-","-","-","-","-","-","-","-","-",321.42857142857144,321.42857142857144]
["Cross Valley Canal","County of Tulare","-","-","-","-","-","-","-","-","-","-",472,472]
["Cross Valley Canal","Hills Valley ID","-","-","-","-","-","-","-","-","-","-",239,239]
["Cross Valley Canal","Kern-Tulare ID","-","-","-","-","-","-","-","-","-","-",5639.1428571428569,5639.1428571428569]
["Cross Valley Canal","Lower Tule River ID - CVC","-","-","-","-","-","-","-","-","-","-",3332.2857142857142,3332.2857142857142]
["Cross Valley Canal","Pixley ID","-","-","-","-","-","-","-","-","-","-",3332.2857142857142,3332.2857142857142]
["Cross Valley Canal","Tri-Valley WD","-","-","-","-","-","-","-","-","-","-",124.42857142857143,124.42857142857143]
["San Felipe Unit","San Benito County WD","-","-","-","-","-","-","-",8434,"-",8434,"-","-"]
["San Felipe Unit","Santa Clara Valley WD","-","-","-","-","-","-","-",12212.714285714286,12212.714285714286,12212.714285714286,"-","-"]
["San Luis Canal","Panoche WD -SLC","-",20452.428571428572,"-","-","-","-","-","-","-","-","-","-"]
["San Luis Canal","San Luis WD - SLC","-","-",30102.142857142859,"-","-","-","-","-","-","-","-","-"]
["San Luis Canal","Westlands WD - SLC","-","-","-",434277.73406593397,44163.837362637401,25762.238461538502,478441.57142857136,"-","-","-","-","-"]
["San Luis Canal","Westlands WD - SLC (DD#2)","-","-","-",1061,107.9472527472,62.969230769200003,1168.9472527472001,"-","-","-","-","-"]
["Total","Total Deliveries","-",20452,30102,435339,44272,25825,479611,20647,12213,20647,13461,13461]
["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","-",876.66769999999997,774124.70032587799,3419346.3697579298,592583.48921618203,86030.445500000002,4097960,71238.017674512696,27477.6534795968,209153.47370210299,37038.198801327657,86473.371283902161]
["Total","Total (Sch. A-9)","-",876.66769999999997,774124.70032587799,3419346.3697579298,592583.48921618203,86030.445500000002,4097960,71238.017674512696,27477.6534795968,209153.47370210299,37038.198801327657,86473.371283902161]
["Total","Direct Pumping:  Cost Per A/F Remittance to WAPA","3/",0,25.72,0,0,0,8.5399999999999991,3.45,2.25,10.130000000000001,0,0]
["Total","Direct Pumping: Cost Per A/F Offset for Direct Pumping","3/",0.04,0,0,0,0,0,0,0,0,2.75,6.42]
["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,340490.15818008292,1503961.5527333799,260641.27122308078,37839.536684809224,1802442,31333.251472559336,12085.74093520972,91993.834216585645,0,0]
["Total","Paid thru Direct Pumping PUE","3/",0,11.311213812374026,0,0,0,3.758133153743346,1.5175692096943545,0.98958003235975767,4.4555545220412478,0,0]
["Total","Credit in O&M Rate for Other PUE ","3/",0,-11.311213812374026,0,0,0,-3.758133153743346,-1.5175692096943545,-0.98958003235975767,-4.4555545220412478,0,0]

{"sheet":"Footnotes","index":2,"n_rows":35,"n_cols":5,"rows_kept":35,"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"]
[]
["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,250261.745054945,611.70109890109995]
["Westlands WD Relifts: Low Side (LS) - Gravity Feed",0.38461538461538464,184015.989010989,449.78021978020001]
["Westlands WD Relifts:  Subtotal",0.9076923076923078,434277.73406593397,1061]
["Pleasant Valley PP:  High Side - Relift Pump",5.3846153846153849E-2,25762.238461538502,62.969230769200003]
["Pleasant Valley PP:  Coalinga Canal, LS - Gravity",3.8461538461538464E-2,18401.5989010989,44.978021978000001]
["Subtotal (Pleasant Valley PP)",9.2307692307692313E-2,44163.837362637401,107.9472527472]
["Total - WWD Deliveries",1,478441.57142857136,1168.9472527472001]
[]
["2/ Cross Valley Canal Estimated 2025 Project Use Energy Cost:"]
[]
["Category","Dos Amigos PP","State Delta PP"]
["2025 PUE Estimate - Direct Billed",3498761.7614308959,207851.62568481971]
["2025 PUE Estimate - Cross Valley Canal 2025 Projected Cost",88259.241369105701,37803.121115180198]
["Total",3587021.0028000018,245654.74679999991]
[]
["Category","Deliveries","Ratio","Dos Amigos PP","State Delta PP"]
["M&I",278,2.0234369313632726E-2,1785.8700852035365,764.92231385254354]
["Irrigation",13461,0.97976563068636724,86473.371283902161,37038.198801327657]
["Total",13739,1,88259.241369105701,37803.121115180198]
[]
["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":3,"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) Ref","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,0,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,0,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,0,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,0,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":4,"n_rows":31,"n_cols":9,"rows_kept":31,"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"]
[]
["A) Ref","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    ",15227.700799999999,15227.700800000001,0,"-","-",0,0,0]
["Shasta D&R (Includes Jdg F Carr PH)",365976.13079000002,72338.030203698101,293638.100586302,"-","-",0,0,0]
["Columbia Mowry (Based on Avg. KWH's)",24914.434700000002,3780.9447176082999,21133.4899823917,"-","-",0,0,0]
["Folsom Pump Plant",187324.15650000001,187324.15650000001,0,"-","-",0,0,0]
["New Melones Dam & Reservoir",0,0,0,"-","-",0,0,0]
["Gianelli WR Pump-Gen Plt  ",3216046.4078899999,429856.83491801698,2786189.5729719801,"-","-",0,0,0]
["Regen. Credit - San Luis PP",-4133289.9169000001,-552455.62287854799,-3580834.29402145,"-","-",0,0,0]
["SFU Gianelli WR PGP (Direct Pumping)",0,0,0,"-","-",0,0,0]
["Offseting Revenue for Storage PUE Paid to WAPA",0,0,0,"-","-",0,574508.39702533628,2232292.6612935932]
["Offseting Revenue for Direct Pumping PUE Paid to WAPA",0,0,0,"-","-",0,280876.67788371281,288452.51838439115]
["Offsetting Revenue for Unpaid Costs from Current B6A",0,0,0,"-","-",0,0,0]
["Total Offsetting Revenue",0,0,0,"-","-",0,855385.07490904909,2520745.1796779842]
["Gianelli PGP - SFU  ",409245.34957106999,338007.33189655701,71238.017674512696,8.0283253385098965E-2,1.2430154275475811E-2,100006.34818331439,68673.096710755053,31333.251472559336]
["Contra Costa PP",2635697.8090999997,2635697.8091000002,0,0.62602900909641757,1.8342184173613289E-5,535495.87084117695,535495.87084117695,0]
["Colusa CWD (Incl. Arb./Will O&M Office)",414506.39380999998,2140.1681379459001,412366.22567205399,5.0833116530741239E-4,7.1952813545697367E-2,181809.5268015005,434.81889191508515,181374.70790958541]
["Kanawha WD",47735.891799999998,77.223984732399998,47658.667815267603,1.8342184173613289E-5,8.3158489363661589E-3,20977.825751858629,15.689630583341778,20962.136121275285]
["Orland-Artois WD",91085.599800000011,0,91085.599799999996,1.8342184173613289E-5,1.5893312233382462E-2,40062.990201415982,0,40062.990201415982]
["Pleasant Valley PP",592583.48921618226,0,592583.48921618203,1.8342184173613289E-5,0.10339850030234977,260641.27122308078,0,260641.27122308078]
["Pleasant Valley Relifts",86030.445500000002,0,86030.445500000002,1.8342184173613289E-5,1.5011250240551123E-2,37839.536684809224,0,37839.536684809224]
["San Luis WD Relifts",786905.84939999995,12781.1490741219,774124.70032587799,3.0357691471156623E-3,0.13507519955808436,343086.90979939501,2596.751619312111,340490.15818008292]
["Westlands WD Relifts",3442686.4033999997,23340.0336420729,3419346.3697579298,5.543707659799316E-3,0.59663371167311141,1508703.5575252313,4742.0047918513073,1503961.5527333799]
["Coyote PP - Out of Basin",233235.58360000001,205757.93012040301,27477.6534795968,4.8871472542214592E-2,4.794511175760189E-3,53889.669136647484,41803.928201437768,12085.74093520972]
["Pacheco PP - Out of Basin",1201536.6128,992383.13909789699,209153.47370210299,0.235710114819873,3.6494698059221328E-2,293616.74843860324,201622.91422201763,91993.834216585645]
["Total for Determining Rates to Remit to WAPA",0,4210184.78505373,5731064.6429435238,1.0000000000000002,1,3376130.2545870333,855385.0749090492,2520745.1796779842]

{"sheet":"PUE to WAPA","index":5,"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":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}}]
[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":6346648.5524289301},{"$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":280876.67788371281},{"$f":"PUE!J47","v":288452.51838439115}]
[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":409245.34957106999},{"$f":"PUE!I24","v":338007.33189655701},{"$f":"PUE!J24","v":71238.017674512696},{"$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":2635697.8091000002},{"$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":2140.1681379459001},{"$f":"PUE!J26","v":412366.22567205399},{"$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":77.223984732399998},{"$f":"PUE!J27","v":47658.667815267603},{"$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":91085.599799999996},{"$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":592583.48921618226},0,{"$f":"PUE!J29","v":592583.48921618203},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$f":"PUE!H29","v":592583.48921618226},"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":86030.445500000002},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$f":"PUE!H42","v":174434.98378381773}]
[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":12781.1490741219},{"$f":"PUE!J31","v":774124.70032587799},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$f":"SUM(X47:X49)","v":767018.473},"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":23340.0336420729},{"$f":"PUE!J32","v":3419346.3697579298},{"$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":205757.93012040301},{"$f":"PUE!J33","v":27477.6534795968},{"$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":992383.13909789699},{"$f":"PUE!J34","v":209153.47370210299},{"$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!"}]