{"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":39,"comments":3,"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":82,"n_cols":14,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
[]
["IRR 2024 Sch A-11 F.Z26.XLSM"]
["09/19/2023"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF ESTIMATED IRRIGATION DIRECT PUMPING OPERATION & MAINTENANCE COSTS"]
["2024 IRRIGATION WATER RATES"]
[]
["Category","A) Contractor","Related Footnotes","B) 2024 Projected Deliveries \nWintu PP\n <Sch A-12>","C) 2024 Projected Deliveries Tehama-Colusa Canal Relifts Colusa County WD\n<Sch A-12>","D) 2024 Projected Deliveries Tehama-Colusa Canal Relifts Dunnigan WD\n<Sch A-12>","E) 2024 Projected Deliveries Tehama-Colusa Canal Relifts Glenn Valley WD\n<Sch A-12>","F) 2024 Projected Deliveries  Tehama-Colusa Canal Relifts Kanawha WD\n<Sch A-12>","G) 2024 Projected Deliveries Tehama-Colusa Canal Relifts Orland-Artois WD\n<Sch A-12>"," H) 2024 Projected Deliveries Tehama-Colusa Canal Relifts Westside WD\n<Sch A-12>","I) 2024 Projected Deliveries  Corning Canal Relifts \nCorning WD\n<Sch A-12>","J) 2024 Projected Deliveries Corning Canal Relifts \nProberta WD\n<Sch A-12>"]
["Corning Canal","Corning WD","-","-","-","-","-","-","-","-",5063,"-"]
["Corning Canal","Proberta WD","-","-","-","-","-","-","-","-","-",201.42857142857142]
["Cow Creek Unit","Bella Vista WD","-",2717.8571428571427,"-","-","-","-","-","-","-","-"]
["Tehama-Colusa Canal","Colusa County WD","-","-",23228.142857142859,"-","-","-","-","-","-","-"]
["Tehama-Colusa Canal","Dunnigan WD","-","-","-",6179.7142857142853,"-","-","-","-","-","-"]
["Tehama-Colusa Canal","Glenn Valley WD","-","-","-","-",901.42857142857144,"-","-","-","-","-"]
["Tehama-Colusa Canal","Kanawha WD","-","-","-","-","-",19650.142857142859,"-","-","-","-"]
["Tehama-Colusa Canal","Orland-Artois WD","-","-","-","-","-","-",17641.571428571428,"-","-","-"]
["Tehama-Colusa Canal","Westside WD","-","-","-","-","-","-","-",27893.714285714286,"-","-"]
["Total","Total Deliveries","-",2718,23228,6180,901,19650,17642,27894,5063,201]
["Total","Est. 2024 Non-Recurring O&M Cost","-",0,0,0,0,0,0,0,0,0]
["Total","Est. 2024 O&M Cost","-",120548.906796815,483227.81037542003,9371.9709999999995,0,49553.165618434199,116610.60189999999,84698.235100000005,72349.360199999996,644.70579999999995]
["Total","Total (Sch. A-9)","-",120548.906796815,483227.81037542003,9371.9709999999995,0,49553.165618434199,116610.60189999999,84698.235100000005,72349.360199999996,644.70579999999995]
["Total","Direct Pumping:  Cost Per A/F Remittance to WAPA","3/",0,20.8,0,0,2.52,6.61,0,0,0]
["Total","Direct Pumping: Cost Per A/F Offset for Direct Pumping","3/",44.35,0,1.52,0,0,0,3.04,14.29,3.21]
["Total","Other PUE Remittance to WAPA:  ","3/","-","-","-","-","-","-","-","-","-"]
["Total","Paid as Other PUE ","-",0,104946.8827705648,0,0,10761.901843000225,25325.3618782757,0,0,0]
["Total","Paid thru Direct Pumping PUE","-",0,4.5181196302120199,0,0,0.54767948310433712,1.4355153541704853,0,0,0]
["Total","Credit in O&M Rate for Other PUE ","-",0,-4.5181196302120199,0,0,-0.54767948310433712,-1.4355153541704853,0,0,0]
[]
["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","I) San Felipe Out-of-Basin \nCoyote PP","J) San Felipe Out-of-Basin \nPacheco PP","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","-","-","-","-","-","-","-","-","-","-",400.57142857142856,400.57142857142856]
["Cross Valley Canal","Hills Valley ID","-","-","-","-","-","-","-","-","-","-",239,239]
["Cross Valley Canal","Kern-Tulare ID","-","-","-","-","-","-","-","-","-","-",5459.4285714285716,5459.4285714285716]
["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","-","-","-","-","-","-","-",8543.8571428571431,"-",8543.8571428571431,"-","-"]
["San Felipe Unit","Santa Clara Valley WD","-","-","-","-","-","-","-",12212.714285714286,12212.714285714286,12212.714285714286,"-","-"]
["San Luis Canal","Panoche WD -SLC","-",18905.428571428572,"-","-","-","-","-","-","-","-","-","-"]
["San Luis Canal","San Luis WD - SLC","-","-",27746.714285714286,"-","-","-","-","-","-","-","-","-"]
["San Luis Canal","Westlands WD - SLC","-","-","-",362023.51311953401,40307.772594752096,22393.2069970845,402331.28571428609,"-","-","-","-","-"]
["San Luis Canal","Westlands WD - SLC (DD#2)","-","-","-",810,90.138351444499989,50.076861913599998,900.13835144450002,"-","-","-","-","-"]
["Total","Total Deliveries","-",18905,27747,362834,40398,22443,403231,20757,12213,20757,13209,13209]
["Total","Est. 2024 Non-Recurring O&M Cost","-",0,0,0,0,0,0,0,0,0,0,0]
["Total","Est. 2024 O&M Cost","-",514.47220000000004,856283.49063341098,4060096.4830310699,635638.19078461896,102528.85309999999,4798264,70998.798253009503,17238.445858895098,309632.80874542601,231716.89943322467,146453.99415455433]
["Total","Total (Sch. A-9)","-",514.47220000000004,856283.49063341098,4060096.4830310699,635638.19078461896,102528.85309999999,4798264,70998.798253009503,17238.445858895098,309632.80874542601,231716.89943322467,146453.99415455433]
["Total","Direct Pumping:  Cost Per A/F Remittance to WAPA","3/",0,30.86,0,0,0,11.9,3.42,1.41,14.92,0,0]
["Total","Direct Pumping: Cost Per A/F Offset for Direct Pumping","3/",0.03,0,0,0,0,0,0,0,0,17.54,11.09]
["Total","Other PUE Remittance to WAPA:  ","3/","-","-","-","-","-","-","-","-","-","-","-"]
["Total","Paid as Other PUE ","3/",0,185966.70386180587,881767.27517154091,138047.20105190473,22267.103208581149,1042082,15419.440680205891,3743.8266545435058,67245.711822921672,0,0]
["Total","Paid thru Direct Pumping PUE","3/","-",6.7022274069919581,"-","-","-",2.584330073828649,0.74285497327195116,0.30654439159448993,3.2396642974862297,0,0]
["Total","Credit in O&M Rate for Other PUE ","3/","-",-6.7022274069919581,"-","-","-",-2.584330073828649,-0.74285497327195116,-0.30654439159448993,-3.2396642974862297,0,0]
[]
["FOOTNOTES:"]
[]
["1/ Westlands WD & Westlands WD DD#2 (DD#2) deliveries are based on firm supplies:"]
[]
["Category","Ratios ","Allocated 2024 Deliveries\n Westlands WD","Allocated 2024 Deliveries\nDD#2"]
["     Westlands WD Relifts: High Side - Relift Pumps",0.5,201165.64285714299,449.85714285709997]
["     Westlands WD Relifts: Low Side (LS) - Gravity Feed",0.39981447124304265,160857.87026239099,359.7187914127]
["      Westlands WD Relifts:  Subtotal",0.8998144712430427,362023.51311953401,810]
["        Pleasant Valley PP:  High Side - Relift Pump",5.5658627087198514E-2,22393.2069970845,50.076861913599998,null,null,""]
["        Pleasant Valley PP:  Coalinga Canal, LS - Gravity",4.4526901669758812E-2,17914.565597667599,40.061489530899998]
["      Subtotal (Pleasant Valley PP)",0.10018552875695733,40307.772594752096,90.138351444499989]
["        Total - WWD Deliveries",1,402331.28571428609,900.13835144450002]
[]
[]
["2/ Cross Valley Canal Estimated 2024 Project Use Energy Cost:"]
[]
["Category","Dos Amigos PP","State Delta PP"]
["2024 PUE Estimate - Direct Billed",5143039.6388423964,608683.74550290732]
["2024 PUE Estimate - Cross Valley Canal 2024 Projected Cost",149536.30245760272,236593.67269709299]
["Total",5292575.9412999991,845277.41820000031]
[]
["Category","Deliveries","Ratio","Dos Amigos PP","State Delta PP"]
["M&I",278,2.0612441610439684E-2,3082.3083030483845,4876.7732638683065]
["Irrigation",13209,0.97938755838956026,146453.99415455433,231716.89943322467]
["Total",13487,1,149536.30245760272,236593.67269709296]
[]
["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 2024 Sch A-11 F.Z26.XLSM"]
["09/19/2023"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF ESTIMATED IRRIGATION DIRECT PUMPING OPERATION & MAINTENANCE COSTS"]
["2024 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.85714285714289,"N/A",1,"-",1,13571.755999999999,13571.755999999999,0]
["Used in Schedule 9","Storage: Shasta D&R (Includes Jdg F Carr PH)",1073.5714285714287,3918.5714285714284,0.21505222490000001,0.78494777510000002,1,530872.32892500004,114165.275473166,416707.05345183401]
["Used in Schedule 9","Storage: Columbia Mowry (Based on Avg. KWH's)",91945.314358705989,499937.28012644761,0.15534383879999999,0.84465616119999998,1,26350.214500000002,4093.3434736334002,22256.8710263666]
["Used in Schedule 9","Storage: Folsom Pump Plant",29058.523809523809,"N/A",1,0,1,112639.67110000002,112639.67110000001,0]
["Used in Schedule 9","Storage:  New Melones Dam & Reservoir",23180.571428571428,20925,0.52557014179999995,0.4744298582,1,0,0,0]
["Used in Schedule 9","Storage:  Gianelli WR Pump-Gen Plt  ",247086.23809523814,1477459.2857142857,0.1432761471,0.85672385289999997,1,5898886.5352646997,845169.73495279497,5053716.80031191]
["Used in Schedule 9","Storage: Regen. Credit - San Luis PP",247086.23809523814,1477459.2857142857,0.1432761471,0.85672385289999997,1,-5490086.2682999996,-786598.40776864102,-4703487.8605313599]
["Used in Schedule 9","Storage:  SFU Gianelli WR PGP (Direct Pumping)",90406.71428571429,20756.571428571428,0.81327853620000001,0.18672146379999999,1,0,0,0]
["Total","Offsetting Revenue for PUE Paid to WAPA:","-","-","-","-","-","-",303041.37323095335,789192.86425875034]
["Used in Schedule 9","Conveyance Pumping (Direct Bill): Corning Pumping Plant","N/A",5354.1428571428569,"-",1,1,242905.52240000002,0,242905.52239999999]
["Used in Schedule 9","Conveyance Pumping (Direct Bill): Dos Amigos Pumping Plant",12130.857142857143,451745.66400209867,2.6151047899999998E-2,0.9738489521,1,5143039.6388423964,134495.875946966,5008543.7628954304]
["Used in Schedule 9","Conveyance Pumping (Direct Bill): O'Neill Pump-Gen Plt",103033.57142857143,474420.42857142858,0.17842732310000001,0.82157267690000002,1,3096800.5205999999,552553.82706534397,2544246.6935346602]
["Used in Schedule 9","Conveyance Pumping (Direct Bill):  Regen. Credit - O'Neill Pump-Gen Plt",103033.57142857143,474420.42857142858,0.17842732310000001,0.82157267690000002,1,-254602.16459999999,-45427.9826850436,-209174.18191495599]
["Used in Schedule 9","Conveyance Pumping (Direct Bill): Jones Pumping Plant",448473.80952380958,1106729.0007255713,0.28836998400000002,0.71163001599999998,1,15947366.7688,4598741.8999609901,11348624.868838999]
["Used in Schedule 9","Conveyance Pumping (Direct Bill): In-Lieu of Jones Pumping","-","-","-","-","-",608683.74550290732,0,608683.74550290732]
["Total","Total Coveyance Pumping Direct Bill","-","-","-","-","-","-",5240363.6202882566,19543830.41125704]
["Used in Schedule 11 Page 1","Direct Pumping: Gianelli PGP - SFU  ",90406.71428571429,20756.571428571428,0.81327853620000001,0.18672146379999999,1,380239.08343529998,309240.28518229001,70998.798253009503]
["Used in Schedule 11 Page 1","Direct Pumping: Contra Costa PP",81034,0,1,"-",1,1605684.8414,1605684.8414,0]
["Used in Schedule 11 Page 1","Direct Pumping: Colusa CWD (Incl. Arb./Will O&M Office)",126,23228.142857142859,5.3951883999999997E-3,0.99460481160000003,1,485849.05757499998,2621.2471995796,483227.81037542003]
["Used in Schedule 11 Page 1","Direct Pumping:  Kanawha WD",27.428571428571427,19650.142857142859,1.3939002000000001E-3,0.99860609980000004,1,49622.334199999998,69.168581565799997,49553.165618434199]
["Used in Schedule 11 Page 1","Direct Pumping: Orland-Artois WD","N/A",17641.571428571428,"-",1,1,116610.60189999999,0,116610.60189999999]
["Used in Schedule 11 Page 1","Direct Pumping: Pleasant Valley PP",0,17954.627087198514,"-",1,1,635638.19078461919,0,635638.19078461896]
["Used in Schedule 11 Page 1","Direct Pumping: Pleasant Valley Relifts","N/A",22443.283858998144,"-",1,1,102528.85309999999,0,102528.85309999999]
["Used in Schedule 11 Page 1","Direct Pumping: San Luis WD Relifts",515.28571428571433,27746.714285714286,1.82324575E-2,0.98176754249999998,1,872185.57709999999,15902.0864665887,856283.49063341098]
["Used in Schedule 11 Page 1","Direct Pumping: Westlands WD Relifts",2890.4285714285716,362833.08905380336,7.9033161000000001E-3,0.99209668390000005,1,4092440.3325999994,32343.8495689269,4060096.4830310699]
["Used in Schedule 11 Page 1","Direct Pumping: Coyote PP - Out of Basin",42507.928571428572,6106.3571428571431,0.87439171319999998,0.1256082868,1,137239.71799999999,120001.272141105,17238.445858895098]
["Used in Schedule 11 Page 1","Direct Pumping: Pacheco PP - Out of Basin",90406.71428571429,20756.571428571428,0.81327853620000001,0.18672146379999999,1,1658260.3973000001,1348627.58855457,309632.80874542601]
["Total","Paid Directly As PUE to WAPA","-","-","-","-","-","-",3434490.3390946263,6701808.6483002845]
["Used in Schedule 11 Page 1","Glenn Valley WD","N/A",901.42857142857144,"-",1,1,"-",0,0]
["Used in Schedule 11 Page 1","Corning WD","N/A",5063,"-",1,1,72349.360199999996,0,72349.360199999996]
["Used in Schedule 11 Page 1","Dunnigan WD","N/A",6179.7142857142853,"-",1,1,9371.9709999999995,0,9371.9709999999995]
["Used in Schedule 11 Page 1","Westside WD","N/A",27893.714285714286,"-",1,1,84698.235099999991,0,84698.235100000005]
["Used in Schedule 11 Page 1","Proberta WD","N/A",201.42857142857142,"-",1,1,644.70579999999995,0,644.70579999999995]
["Used in Schedule 11 Page 1","Panoche WD - SLC","N/A",18905.428571428572,"-",1,1,514.47220000000004,0,514.47220000000004]
["Used in Schedule 11 Page 1","Pleasant Valley PP",5603.5714285714284,0,1,0,1,198380.28311538082,198380.283115381,0]
["Used in Schedule 11 Page 1","State-Delta PP - Cross Valley Canal (CVC)",278,13209.428571428571,2.0611786600000001E-2,0.97938821340000004,1,236593.67269709296,4876.7732638683065,231716.89943322467]
["Used in Schedule 11 Page 1","Dos Amigos PP - CVC (Offset with Direct Pumping)",278,13209.428571428571,2.0611786600000001E-2,0.97938821340000004,1,149536.30245760272,3082.3083030483845,146453.99415455433]
["Used in Schedule 11 Page 1","Wintu PP",3638.5714285714284,2717.8571428571427,0.57242386789999999,0.42757613210000001,1,281935.5379,161386.63110318501,120548.906796815]
["Used in Schedule 11 Page 1","City of Shasta Lake (Shasta PP)",1115,0,1,"-",1,2300.8789000000002,2300.8789000000002,0]
["Total","Offseting Revenue for PUE Paid to WAPA","-","-","-","-","-","-",370026.8746854827,666298.54468459392]
["Total","Direct Pumping Total","-","-","-","-","-","-",3804517.2137801088,7368107.1929848781]
["Total","Reimbursable Billing","-","-","-","-","-",7628.8164000000006,"-","-"]
["Total","Project General","-","-","-","-","-",26751.562999999998,"-","-"]
["Total","Nonreimbursable F&W","-","-","-","-","-",10472.292499999996,"-","-"]
["Total","Nonreimbursable Demo Treatment","-","-","-","-","-",6094.6523999999999,"-","-"]
["Total","-","-","-","-","-","-",37100000.000099994,9347922.2072993182,27701130.468500666]

{"sheet":"PUE to WAPA ","index":2,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["IRR 2024 Sch A-11 F.Z26.XLSM"]
["09/19/2023"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF ESTIMATED IRRIGATION DIRECT PUMPING OPERATION & MAINTENANCE COSTS"]
["2024 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    ",199.85714285714289,"N/A",1,"-",1,13571.755999999999,13571.755999999999,0,"-","-","-","-","-"]
["Shasta D&R (Includes Jdg F Carr PH)",1073.5714285714287,3918.5714285714284,0.21505222490000001,0.78494777510000002,1,530872.32892500004,114165.275473166,416707.05345183401,"-","-","-","-","-"]
["Columbia Mowry (Based on Avg. KWH's)",91945.314358705989,499937.28012644761,0.15534383879999999,0.84465616119999998,1,26350.214500000002,4093.3434736334002,22256.8710263666,"-","-","-","-","-"]
["Folsom Pump Plant",29058.523809523809,"N/A",1,0,1,112639.67110000002,112639.67110000001,0,"-","-","-","-","-"]
["New Melones Dam & Reservoir",23180.571428571428,20925,0.52557014179999995,0.4744298582,1,0,0,0,"-","-","-","-","-"]
["Gianelli WR Pump-Gen Plt  ",247086.23809523814,1477459.2857142857,0.1432761471,0.85672385289999997,1,1472473.3209250011,210970.30412967599,1261503.01679533,"-","-","-","-","-"]
["Regen. Credit - San Luis PP",247086.23809523814,1477459.2857142857,0.1432761471,0.85672385289999997,1,-5490086.2682999996,-786598.40776864102,-4703487.8605313599,"-","-","-","-","-"]
["SFU Gianelli WR PGP (Direct Pumping)",90406.71428571429,20756.571428571428,0.81327853620000001,0.18672146379999999,1,0,0,0,"-","-","-","-","-"]
["Offseting Revenue for Storage PUE Paid to WAPA","-","-","-","-","-","-","-","-","-","-","-",303041.37323095335,789192.86425875034]
["Offseting Revenue for Direct Pumping PUE Paid to WAPA","-","-","-","-","-","-","-","-","-","-","-",370026.8746854827,666298.54468459392]
["Offsetting Revenue for Unpaid Costs from Current B6A","-","-","-","-","-","-","-","-","-","-","-",0,0]
["Total Offsetting Revenue","-","-","-","-","-","-","-","-","-","-","-",673068.24791643606,1455491.4089433444]
[]
[" 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  ",90406.71428571429,20756.571428571428,"-","-","-",380239.08343529998,309240.28518229001,70998.798253009503,9.0039643338699724E-2,1.0593975742804332E-2,76022.265665205312,60602.824984999424,15419.440680205891]
["Contra Costa PP",81034,0,1,"-",1,1605684.8414,1605684.8414,0,0.46751764683177949,"-",314671.28342308092,314671.28342308092,0]
["Colusa CWD (Incl. Arb./Will O&M Office)",126,23228.142857142859,5.3951883999999997E-3,0.99460481160000003,1,485849.05757499998,2621.2471995796,483227.81037542003,7.632128615247737E-4,7.210408946814327E-2,105460.57711405857,513.694343493769,104946.8827705648]
["Kanawha WD",27.428571428571427,19650.142857142859,1.3939002000000001E-3,0.99860609980000004,1,49622.334199999998,69.168581565799997,49553.165618434199,2.01394019888359E-5,7.3939988768557119E-3,10775.457035010935,13.555192010710567,10761.901843000225]
["Orland-Artois WD","N/A",17641.571428571428,0,1,1,116610.60189999999,0,116610.60189999999,0,1.7399870396116849E-2,25325.3618782757,0,25325.3618782757]
["Pleasant Valley PP",5603.5714285714284,17954.627087198514,0.2378607781,0.76213922190000005,1,635638.19078461919,0,635638.19078461896,0,9.4845768380126719E-2,138047.20105190473,0,138047.20105190473]
["Pleasant Valley Relifts","N/A",22443.283858998144,0,1,1,102528.85309999999,0,102528.85309999999,0,1.5298684053893929E-2,22267.103208581149,0,22267.103208581149]
["San Luis WD Relifts",515.28571428571433,27746.714285714286,1.82324575E-2,0.98176754249999998,1,872185.57709999999,15902.0864665887,856283.49063341098,4.6301153581875219E-3,0.12776901513751546,189083.08749359212,3116.383631786257,185966.70386180587]
["Westlands WD Relifts",2890.4285714285716,362833.08905380336,7.9033161000000001E-3,0.99209668390000005,1,4092440.3325999994,32343.8495689269,4060096.4830310699,9.4173651329743247E-3,0.6058210098345308,888105.80462158122,6338.5294500403634,881767.27517154091]
["Coyote PP - Out of Basin",42507.928571428572,6106.3571428571431,0.87439171319999998,0.1256082868,1,137239.71799999999,120001.272141105,17238.445858895098,3.4940052320175927E-2,2.5722080058593021E-3,27260.866451792925,23517.039797249417,3743.8266545435058]
["Pacheco PP - Out of Basin",90406.71428571429,20756.571428571428,0.81327853620000001,0.18672146379999999,1,1658260.3973000001,1348627.58855457,309632.80874542601,0.39267182475466933,4.6201380104153707E-2,331540.64891669678,264294.93709377514,67245.711822921672]
["Total for Determining Rates to Remit to WAPA","-","-","-","-","-","-",3434490.3390946263,6701808.6483002845,0.99999999999999989,1.0000000000000002,2128559.6568597802,673068.24791643606,1455491.4089433444]

{"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":"2024 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":5898886.5352646997},{"$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":370026.8746854827},{"$f":"PUE!J47","v":666298.54468459392}]
[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":380239.08343529998},{"$f":"PUE!I24","v":309240.28518229001},{"$f":"PUE!J24","v":70998.798253009503},{"$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":1605684.8414},{"$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":2621.2471995796},{"$f":"PUE!J26","v":483227.81037542003},{"$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":69.168581565799997},{"$f":"PUE!J27","v":49553.165618434199},{"$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":116610.60189999999},{"$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":635638.19078461919},0,{"$f":"PUE!J29","v":635638.19078461896},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$f":"PUE!H29","v":635638.19078461919},"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":102528.85309999999},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$f":"PUE!H42","v":198380.28311538082}]
[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":15902.0864665887},{"$f":"PUE!J31","v":856283.49063341098},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$f":"SUM(X47:X49)","v":834018.47389999998},"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":32343.8495689269},{"$f":"PUE!J32","v":4060096.4830310699},{"$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":120001.272141105},{"$f":"PUE!J33","v":17238.445858895098},{"$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":1348627.58855457},{"$f":"PUE!J34","v":309632.80874542601},{"$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!"}]