{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["INFORMATION","MACRO_INPUT","OUTPUT","Footnotes"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":29,"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":"INFORMATION","index":0,"n_rows":57,"n_cols":3,"rows_kept":57,"cut":false,"hidden":true,"merged":[]}
["Special Rates 2023 Sch S-2.Z25.XLSM"]
["01/05/2023"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF M&I UNPAID CONSTRUCTION COSTS BY COMPONENT AND/OR FACILITY"]
["AS OF SEPTEMBER 30, 2021"]
["2023 SPECIAL WATER RATES"]
[]
[null,null,"SOURCE DATA:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["10/19/2022","jm","Updated file names, title, headings, and date"]
[null,null,"Updated & ran macro"]
[]
["10/24/2022","jm","Epdated footnotes tab"]
[]
["01/05/23","KJ","Reviewed"]

{"sheet":"MACRO_INPUT","index":1,"n_rows":170,"n_cols":26,"rows_kept":170,"cut":false,"hidden":true,"merged":[]}
[{"$f":"INFORMATION!A1","v":"Special Rates 2023 Sch S-2.Z25.XLSM"}]
[{"$f":"INFORMATION!$A$2","v":"01/05/2023"}]
[]
[{"$f":"OUTPUT!A5","v":"SCHEDULE OF M&I UNPAID CONSTRUCTION COSTS BY COMPONENT AND/OR FACILITY"}]
[{"$f":"OUTPUT!A6","v":"AS OF SEPTEMBER 30, 2021"}]
[{"$f":"OUTPUT!A7","v":"2023 SPECIAL WATER RATES"}]
[null,"RESERVED FOR MACRO INPUT"]
[]
[null,null,null,2020]
[null,"Schedule S-6",null,"Projected Deliveries",null,null,"Schedule A-5",null,null,null,null,null,"Schedule A-4",null,null,null,null,null,null,"Schedule A-2B",null,null,"Schedule A-7",null,null,"Schedule A-13"]
[null,null,null,null,null,null,"Capital Costs",null,null,"Total","PUE BOR","PUE DOE","Other Cost and Miscellaneous Revenue",null,null,null,null,null,null,"Capital Repayment",null,null,"Jones PP",null,null,"PW Interest Rate"]
[]
[]
[]
[]
["  Total Storage",null,null,331768.71428571432,null,null,null,null,null,null,null,null,"Other Costs",null,null,null,null,null,null,"  Grand Total                    ",140056688,null,"CVP Sub-Total (A/F)",4956444,null,2.3754608109186889E-2]
["  Total Conveyance - all other contractors",null,null,172696.71428571426,null,null,"Storage        1/",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Delta-Mendota Exchange",2496684.902082284]
["  Total Dos Amigos Convey. Pumping",null,null,12196.428571428572,null,null,null,"San Felipe Unit Contractors",null,10103901.890000001,0,0,null,"Deferred Interest Capitalized  ",null,null,null,21277763]
["  Total O'Neill Convey. Pumping",null,null,98940.571428571435,null,null,null,"All Other Contractors",null,40454308.979800545,548627.86061206402,533375.289188475,null,"Programmatic EIS Capitalized     2/",null,null,null,1591067.9586188002]
["  CVP-Subtotal-Jones PP-Conv Pumping",null,null,106845,null,null,null,null,"Total Storage",50558210.869800545,548627.86061206402,533375.289188475,null,"All others",null,null,null,7378781.3949999996]
["  Delta-Mendota Exc. -Conveyance PP Tracy",null,null,46430.984821142862,null,null,null,null,null,null,null,null,null,null,"Total Other Costs",null,null,30247612.353618801]
["  Total Jones PP - conveyance Pumping",null,null,153275.98482114286,null,null,"Conveyance"]
[null,null,null,null,null,null,null,"Contra Costa WD    3/",null,0,null,null,"San Felipe Unit Contractors",null,null,null,null,809388.1100000001]
[null,null,null,null,null,null,null,"All Other Contractors",null,26600102.019999996,null,null,"All Other Contractors",null,null,null,null,379393.76]
[null,null,null,null,null,null,null,null,"Total Conveyance",26600102.019999996,null,null,"All Other Contractors",null,null,null,null,288911.73000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,"O'Neill Pump-Generator Plant",null,null,null,null,138321.72999999998]
[null,null,null,null,null,null,"Conveyance Pumping",null,null,null,null,null,"Bella Vista WD (Wintu PP)",null,null,null,null,60913.26]
[null,"Schedule S-6",null,"2020",null,null,null,"Dos Amigos Pumping Plant",null,821360.68395645195,274432.25461938698,266802.67933706503,"Dos Amigos PP",null,null,null,null,4604.8099999999995]
[null,null,null,"Projected Deliveries",null,"Direct Pumping",null,"O'Neill Pump-Generator Plant",null,3436478.7917264057,855429.16769389994,831647.11903250602,"Westlands WD Relifts",null,null,null,null,3501.54]
["Black Butte D&R",null,null,null,null,null,null,"Jones Pumping Plant",null,15108319.42781157,5437365.5982568199,5286199.72955475,"All Other Contractors",null,null,null,null,18027.080000000002]
[null,"County of Colusa",null,6.5714285714285712,null,null,null,null,null,null,null,null,"Gianelli, WR PGP",null,null,null,null,115667.26999999999]
[null,"Elk Creek CSD",null,14,null,null,null,null,null,null,null,null,"Pleasant Valley PP (City of Coalinga)",null,null,null,null,3511.24]
[null,"U. S. Forest Service - BB",null,9.8571428571428577,null,null,null,null,"Total Conveyance Pumping",19366158.903494429,6567227.0205701068,6384649.5279243216,"Gianelli, WR PGP",null,null,null,null,15649.349999999999]
[null,"Whitney Const Inc.",null,4,null,null,null,null,null,null,null,null,"Shasta PP (City of Shasta Lake)",null,null,null,null,569188.08611399995]
[null,null,null,34.428571428571431,null,null,"Direct Pumping"]
[null,null,null,null,null,null,null,"Bella Vista WD (Wintu PP)",null,902585.83750450797,206588.863937046,200845.42356746201]
[null,null,null,null,null,null,null,"Colusa County WD",null,36408.492566129527,2142.4831993397702,2082.9193667897598]
["Clear Creek Unit",null,null,null,null,null,null,"Contra Costa Pumping Plants",null,4974012.6289530396,2522064.6610714099,2451947.9678816302]
[null,"Clear Creek CSD",null,1651.1428571428571,null,null,null,"Kanawha WD",null,1558.7797758448521,36.781170219676497,35.758605625175399]
[null,null,null,null,null,null,null,"Pleasant Valley Canalside Relifts",null,49429.8144824056,11922.7081746023,11591.241307803301]
[null,null,null,null,null,null,null,"Pleasant Valley Pumping Plant",null,206069.19000193162,152.35280448881801,148.117197442801]
["Contra Costa Canal",null,null,null,null,null,null,"San Benito County WD"]
[null,"Contra Costa WD",null,80723.71428571429,null,80723.71428571429,null,null,"Pacheco Pumping Plant      ",224076.68224069598,113617.701402648,110458.980838048]
[null,null,null,null,null,0,null,null,"Gianelli, William R. Pump-Generator Plant   1/",379445.30464216101,171345.440899145,166581.81374301601]
[null,null,null,null,null,null,null,"San Luis WD Canalside Relifts & Turnouts",null,73891.369871414092,37466.493676771403,36424.876194642697]
["Cow Creek Unit",null,null,null,null,null,null,"Santa Clara Valley WD                  "]
[null,"Bella Vista WD",null,3730.2857142857142,null,3730.2857142857142,null,null,"Coyote Pumping Plant       ",1356563.24660623,687843.09168391,668720.15492232004]
[null,null,null,null,null,null,null,null,"Pacheco Pumping Plant    ",4713216.4381806897,2389828.3951921598,2323388.0429885299]
[null,null,null,null,null,null,null,null,"Gianelli, William R. Pump-Generator Plant   1/",7981221.61155657,3604070.4142776602,3503872.5472789099]
["Cross Valley Canal",null,null,null,null,null,null,"Shasta Pumping Plant",null,585576.766114,137625.45682528499,133799.28928871499]
[null,"County of Fresno",null,86,null,86,null,"State-Delta Pumping Plant (Cross Valley Canal)",null,15079.579995012889,7646.0754417558701,7433.5045532570202]
[null,"County of Tulare",null,192,null,192,null,"Westlands WD Canalside Relift PP",null,787112.82421443041,43459.069061410897,42250.850153019499]
[null,null,null,278,null,278,null,null,"Total Direct Pumping",22286248.566705063,9935809.988817852,9659581.4878872111]
[]
[]
["Delta-Mendota Canal",null,null,null,null,null,"Other Costs   4/",null,null,7378781.3949999996]
[null,"Byron Bethany ID   ",null,884.28571428571433]
[null,"City of Tracy",null,6594.5714285714284]
[null,"Del Puerto WD",null,3,null,null,null,"Total       ",null,126189501.75500004,17051664.870000023,16577606.305000007]
[null,"Department of Veterans Affairs",null,367.14285714285717]
[null,"Panoche WD - DMC",null,23.428571428571427]
[null,"San Luis WD - DMC",null,32]
[null,null,null,7904.4285714285716]
[]
[]
[]
["Folsom D&R"]
[null,"City of Folsom",null,3306]
[null,"City of Roseville",null,22126.571428571428]
[null,"El Dorado ID - FD&R",null,3913]
[null,"Placer County WA",null,5000]
[null,"Sacramento County WA  ",null,3600.7142857142858]
[null,"San Juan  WD",null,175.71428571428572]
[null,null,null,38121.999999999993]
[]
[]
["Folsom-South Canal"]
[null,"East Bay MUD",null,6645.4285714285716]
[null,"Sacramento County WA - FSC",null,4286]
[null,"Sacramento MUD",null,4286]
[null,null,null,15217.428571428572]
[]
[]
["Friant Dam"]
[null,"County of Madera",null,69.571428571428569]
[null,"Fresno County WW #18",null,100.57142857142857]
[null,null,null,170.14285714285714]
[]
[]
["Friant-Kern Canal"]
[null,"Arvin-Edison WSD",null,425.42857142857144]
[null,"City of Fresno",null,38550.857142857145]
[null,"City of Lindsay",null,1535]
[null,"City of Orange Cove",null,1100.8571428571429]
[null,"Delano-Earlimart ID ",null,259.71428571428572]
[null,"Lindsay-Strathmore ID",null,584.57142857142856]
[null,"Shafter-Wasco ID",null,108.85714285714286]
[null,"Terra Bella ID",null,1345.1428571428571]
[null,null,null,43910.428571428572]
[]
[]
["New Melones D & R"]
[null,"Stockton-East WD",null,24507.142857142859]
[]
[]
[]
["Sacramento River"]
[null,"City of Redding - SR  ",null,2681]
[null,"City of W. Sacramento",null,5797.8571428571431]
[null,"Lake California P.O.A.",null,185.71428571428572]
[null,"Riverview Golf & CC",null,20.571428571428573]
[null,null,null,8685.1428571428587]
[]
[]
["San Felipe Unit"]
[null,"San Benito County WD",null,5210.1428571428569,null,5210.1428571428569]
[null,"Santa Clara Valley WD",null,81377,null,81377]
[null,null,null,86587.142857142855,null,86587.142857142855]
[]
[]
["San Luis Canal - Fresno"]
[null,"City of Avenal",null,2300.5714285714284]
[null,"City of Coalinga",null,5618.2857142857147,null,5618.2857142857147]
[null,"City of Huron",null,1033.4285714285713]
[null,"State of CA",null,1.8571428571428572]
[null,"Westlands WD",null,2797,null,2797]
[null,null,null,11751.142857142857,null,8415.2857142857138]
[]
[]
["San Luis Canal - Tracy"]
[null,"Pacheco WD",null,11]
[null,"Panoche WD",null,136.57142857142858]
[null,"San Luis WD  2/",null,454.71428571428572,null,454.71428571428572]
[null,null,null,602.28571428571433,null,454.71428571428572]
[]
[]
["Shasta D&R"]
[null,"Centerville CSD",null,527.57142857142856]
[null,"Mountain Gate CSD",null,464.71428571428572]
[null,"Shasta CWA",null,97.714285714285708]
[null,null,null,1090]
[]
[]
[]
["Spring Creek Conduit"]
[null,"City of Redding - SCC  ",null,5136.2857142857147]
[null,"Shasta CWA - SCC",null,73.142857142857139]
[null,"Shasta CSD",null,252]
[null,null,null,5461.4285714285716]
[]
[]
["Tehama-Colusa Canal"]
[null,"Colusa County WD",null,129.28571428571428,null,129.28571428571428]
[null,"Kanawha WD",null,26.857142857142858,null,26.857142857142858]
[null,null,null,156.14285714285714,null,156.14285714285714]
[]
[]
["Toyon Pipeline"]
[null,"City of Redding - TP",null,17.428571428571427]
[null,"City of Shasta Lake ",null,1167.8571428571429,null,1167.8571428571429]
[null,"U.S. Forest Service",null,1]
[null,null,null,1186.2857142857142,null,1167.8571428571429]
[]
[]
[null,null,null,331768.71428571432,null,181513.14285714281]
[]
[]
["Delta-Mendota Exchange",null,null,46430.984821142862]
[]
[null,null,null,378199.69910685718,null,181513.14285714281]

{"sheet":"OUTPUT","index":2,"n_rows":243,"n_cols":17,"rows_kept":243,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"INFORMATION!A1","v":"Special Rates 2023 Sch S-2.Z25.XLSM"}]
[{"$f":"INFORMATION!$A$2","v":"01/05/2023"}]
[{"$f":"INFORMATION!A3","v":"CENTRAL VALLEY PROJECT"}]
[{"$f":"INFORMATION!A4","v":"SCHEDULE OF M&I UNPAID CONSTRUCTION COSTS BY COMPONENT AND/OR FACILITY"}]
[{"$f":"INFORMATION!A5","v":"AS OF SEPTEMBER 30, 2021"}]
[{"$f":"INFORMATION!A6","v":"2023 SPECIAL WATER RATES"}]
["Category","A) Component/Facility","Related Footnotes","B) Total Construction at 9/30/2021\n<Sch A-4>","C) Ratio of Total\n<B/$147,204,054>","D) Cumulative Construction Repayment at 9/30/2021\n1/\n<C*$139,277,543>","E) Net Unpaid Construction at 9/30/2021\n(B-D)","F) Unpaid Construction Annualized Costs 8\nRemaining Years\nE*\n(E/8)","G) Annual Interest @ 0.023755\n2/","H) FY 2023 Projected Deliveries\n<Sch S-6>","I) Unpaid Construction Cost Per Acre Foot Construction Only\n(F/H)","J) Unpaid Construction Cost Per Acre Foot Interest\n(G/H)","K) Unpaid Construction Cost Per Acre Foot Total\n(I+J)",null,null,null,2.3754608109999999E-2]
["Storage","San Felipe Unit","-",{"$f":"MACRO_INPUT!J18-MACRO_INPUT!R23","v":9294513.7800000012},{"$f":"D9/$D$51","v":6.3140338310930313E-2},{"$f":"ROUND((+MACRO_INPUT!$U$16-779145)*E9,2)","v":8794031.1799999997},{"$f":"D9-F9","v":500482.60000000149},{"$f":"(G9/8)","v":62560.325000000186},{"$f":"G9*$Q$8","v":11888.768028873921},{"$f":"MACRO_INPUT!D118","v":86587.142857142855},{"$f":"ROUND(H9/J9,2)","v":0.72},{"$f":"ROUND(I9/J9,2)","v":0.14000000000000001},{"$f":"K9+L9","v":0.86}]
["Storage","All Other Contractors","-",{"$f":"MACRO_INPUT!J19-MACRO_INPUT!R24","v":40074915.219800547},{"$f":"D10/$D$51","v":0.2722405673554294},{"$f":"ROUND((+MACRO_INPUT!$U$16-779145)*E10,2)","v":37916997.329999998},{"$f":"D10-F10","v":2157917.8898005486},269739.73622506857,{"$f":"G10*$Q$8","v":51260.493805770195},{"$f":"MACRO_INPUT!D16-J9","v":245181.57142857148},{"$f":"ROUND(H10/J10,2)","v":1.1000000000000001},{"$f":"ROUND(I10/J10,2)","v":0.21},{"$f":"K10+L10","v":1.31}]
["Total","Total Storage","-",{"$f":"SUM(D9:D10)","v":49369428.999800548},0.3353809056663597,46711028.509999998,2658400.48980055,332300.06122506876,{"$f":"G11*$Q$8","v":63149.261834644116},"-","-","-","-"]
["Conveyance","Contra Costa Canal System","3/",{"$f":"+MACRO_INPUT!J23","v":0},{"$f":"ROUND(D12/$D$51,8)","v":0},{"$f":"ROUND((+MACRO_INPUT!$U$16-779145)*E12,2)","v":0},{"$f":"D12-F12","v":0},0,0,"-",0,0,{"$f":"K12+L12","v":0}]
["Conveyance","All Other Contractors","-",{"$f":"+MACRO_INPUT!J24-MACRO_INPUT!R25","v":26311190.289999995},{"$f":"D13/$D$51","v":0.17873957644225089},{"$f":"ROUND((+MACRO_INPUT!$U$16-779145)*E13,2)","v":24894409.039999999},{"$f":"D13-F13","v":1416781.2499999963},177097.65624999953,33655.083371345849,{"$f":"MACRO_INPUT!D17","v":172696.71428571426},{"$f":"ROUND(H13/J13,2)","v":1.03},{"$f":"ROUND(I13/J13,2)","v":0.19},{"$f":"K13+L13","v":1.22}]
["Total","Total Conveyance","-",{"$f":"SUM(D12:D13)","v":26311190.289999995},{"$f":"SUM(E12:E13)","v":0.17873957644225089},{"$f":"SUM(F12:F13)","v":24894409.039999999},{"$f":"SUM(G12:G13)","v":1416781.2499999963},177097.65624999953,33655.083371345849,"-","-","-","-"]
["Conveyance Pumping","Dos Amigos Pumping Plant, Capital only","4/",{"$f":"MACRO_INPUT!J28-MACRO_INPUT!K28-MACRO_INPUT!L28-MACRO_INPUT!R28","v":275520.93999999994},{"$f":"D15/$D$51","v":1.8716939664750842E-3},{"$f":"ROUND((+MACRO_INPUT!$U$16-779145)*E15,2)","v":260684.94},{"$f":"D15-F15","v":14835.999999999942},1854.4999999999927,352.4233659199586,{"$f":"MACRO_INPUT!D18-MACRO_INPUT!D53","v":11918.428571428572},{"$f":"ROUND(H15/J15,2)","v":0.16},{"$f":"ROUND(I15/J15,2)","v":0.03},{"$f":"K15+L15","v":0.19}]
["Conveyance Pumping","Dos Amigos Pumping Plant, PUE only","-",{"$f":"+MACRO_INPUT!K28+MACRO_INPUT!L28","v":541234.93395645195},{"$f":"D16/$D$51","v":3.6767664930724758E-3},{"$f":"ROUND((+MACRO_INPUT!$U$16-779145)*E16,2)","v":512091},{"$f":"D16-F16","v":29143.933956451947},3642.9917445564934,692.30272991923778,{"$f":"MACRO_INPUT!D18","v":12196.428571428572},{"$f":"ROUND(H16/J16,2)","v":0.3},{"$f":"ROUND(I16/J16,2)","v":0.06},{"$f":"K16+L16","v":0.36}]
["Total","Total Dos Amigos Pumping Plant","-","-","-","-","-",0,0,"-",{"$f":"SUM(K15:K16)","v":0.45999999999999996},{"$f":"SUM(L15:L16)","v":0.09},{"$f":"SUM(M15:M16)","v":0.55000000000000004}]
["Conveyance Pumping","O'Neill P-Generator/Pumping Plant, Capital only","-",{"$f":"MACRO_INPUT!J29-MACRO_INPUT!K29-MACRO_INPUT!L29-MACRO_INPUT!R26","v":1611080.7749999999},{"$f":"D18/$D$51","v":1.0944540789064901E-2},{"$f":"ROUND((+MACRO_INPUT!$U$16-779145)*E18,2)","v":1524328.75},{"$f":"D18-F18","v":86752.024999999907},10844.003124999988,2060.7603566239204,{"$f":"MACRO_INPUT!D19","v":98940.571428571435},{"$f":"ROUND(H18/J18,2)","v":0.11},{"$f":"ROUND(I18/J18,2)","v":0.02},{"$f":"K18+L18","v":0.13}]
["Conveyance Pumping","O'Neill P-Generator/Pumping Plant, PUE only","-",{"$f":"MACRO_INPUT!K29+MACRO_INPUT!L29","v":1687076.2867264058},{"$f":"D19/$D$51","v":1.1460800427179885E-2},{"$f":"ROUND((+MACRO_INPUT!$U$16-779145)*E19,2)","v":1596232.12},{"$f":"D19-F19","v":90844.166726405732},11355.520840800717,2157.9675796652696,{"$f":"J18","v":98940.571428571435},{"$f":"ROUND(H19/J19,2)","v":0.11},{"$f":"ROUND(I19/J19,2)","v":0.02},{"$f":"K19+L19","v":0.13}]
["Total","Total O'Neill P-Generator/Pumping Plant","-","-","-","-","-",0,0,"-",{"$f":"SUM(K18:K19)","v":0.22},{"$f":"SUM(L18:L19)","v":0.04},{"$f":"SUM(M18:M19)","v":0.26}]
["Conveyance Pumping","Jones Pumping Plant, Friant Kern/Madera, Capital only","5/, 6/",{"$f":"+Footnotes!D29","v":1468825.9796224346},{"$f":"D21/$D$51","v":9.9781625449636112E-3},{"$f":"ROUND((+MACRO_INPUT!$U$16-779145)*E21,2)","v":1389733.96},{"$f":"D21-F21","v":79092.019622434629},9886.5024528043286,1878.7999307593648,{"$f":"MACRO_INPUT!D87+MACRO_INPUT!D99","v":44080.571428571428},{"$f":"ROUND(H21/J21,2)","v":0.22},{"$f":"ROUND(I21/J21,2)","v":0.04},{"$f":"K21+L21","v":0.26}]
["Conveyance Pumping","Jones Pumping Plant, Friant Kern/Madera, PUE only","5/, 6/",{"$f":"+Footnotes!G29","v":3592231.3973474586},{"$f":"D22/$D$51","v":2.4403073801205818E-2},{"$f":"ROUND((+MACRO_INPUT!$U$16-779145)*E22,2)","v":3398800.16},{"$f":"D22-F22","v":193431.23734745849},24178.904668432311,4594.8832394212723,{"$f":"J21","v":44080.571428571428},{"$f":"ROUND(H22/J22,2)","v":0.55000000000000004},{"$f":"ROUND(I22/J22,2)","v":0.1},{"$f":"K22+L22","v":0.65}]
["Total","Total Friant Kern/Madera","-","-","-","-","-",0,0,"-",{"$f":"SUM(K21:K22)","v":0.77},{"$f":"SUM(L21:L22)","v":0.14000000000000001},{"$f":"SUM(M21:M22)","v":0.91}]
["Conveyance Pumping","Jones Pumping Plant, All Other Contractors, Capital only","5/, 7/",{"$f":"+Footnotes!D30-MACRO_INPUT!R30","v":2897901.0403775666},{"$f":"D24/$D$51","v":1.9686285524129533E-2},{"$f":"ROUND((+MACRO_INPUT!$U$16-779145)*E24,2)","v":2741857.48},{"$f":"D24-F24","v":156043.56037756661},19505.445047195826,3706.7536248582182,{"$f":"MACRO_INPUT!D20","v":106845},{"$f":"ROUND(H24/J24,2)","v":0.18},{"$f":"ROUND(I24/J24,2)","v":0.03},{"$f":"K24+L24","v":0.21}]
["Conveyance Pumping","Jones Pumping Plant, All Other Contractors, PUE only","5/, 7/",{"$f":"+Footnotes!G30","v":7131333.9304641113},{"$f":"D25/$D$51","v":4.8445227758618738E-2},{"$f":"ROUND((+MACRO_INPUT!$U$16-779145)*E25,2)","v":6747332.29},{"$f":"D25-F25","v":384001.64046411123},48000.205058013904,9121.8084828220799,{"$f":"J24","v":106845},{"$f":"ROUND(H25/J25,2)","v":0.45},{"$f":"ROUND(I25/J25,2)","v":0.09},{"$f":"K25+L25","v":0.54}]
["Total","Total All Other Contractors","-","-","-","-","-",0,0,"-",{"$f":"SUM(K24:K25)","v":0.63},{"$f":"SUM(L24:L25)","v":0.12},{"$f":"SUM(M24:M25)","v":0.75}]
["Total","Total Conveyance Pumping","-",{"$f":"SUM(D15:D26)","v":19205205.283494428},0.13046655130471005,18171060.699999999,1034144.5834944285,129268.07293680357,24565.699309989323,"-","-","-","-"]
["Direct Pumping","Bella Vista WD (Wintu PP)","-",{"$f":"+MACRO_INPUT!J36-MACRO_INPUT!R27","v":841672.57750450796},{"$f":"D28/$D$51","v":5.7177268815311114E-3},{"$f":"ROUND((+MACRO_INPUT!$U$16-779145)*E28,2)","v":796350.95},{"$f":"D28-F28","v":45321.627504508011},5665.2034380635014,1076.5975002769851,{"$f":"+MACRO_INPUT!F47","v":3730.2857142857142},{"$f":"ROUND(H28/J28,2)","v":1.52},{"$f":"ROUND(I28/J28,2)","v":0.28999999999999998},{"$f":"K28+L28","v":1.81}]
["Direct Pumping","Colusa County WD Relift PP","-",{"$f":"+MACRO_INPUT!J37","v":36408.492566129527},2.473334907483896E-4,{"$f":"ROUND((+MACRO_INPUT!$U$16-779145)*E29,2)","v":34448},1960.4925661295274,245.06157076619093,46.570732610975178,{"$f":"+MACRO_INPUT!F153","v":129.28571428571428},1.9,0.36,2.2599999999999998]
["Direct Pumping","Contra Costa PP (Contra Costa WD)","-",{"$f":"+MACRO_INPUT!J38","v":4974012.6289530396},3.3789916028822628E-2,{"$f":"ROUND((+MACRO_INPUT!$U$16-779145)*E30,2)","v":4706176.4800000004},267836.1489530392,33479.5186191299,6362.3427560710325,{"$f":"MACRO_INPUT!F43","v":80723.71428571429},0.41,0.08,0.49]
["Direct Pumping","Kanawha WD","-",{"$f":"+MACRO_INPUT!J39","v":1558.7797758448521},1.0589244873773277E-5,{"$f":"ROUND((+MACRO_INPUT!$U$16-779145)*E31,2)","v":1474.84},83.939775844852193,{"$f":"(G31/8)","v":10.492471980606524},1.9939564800357079,{"$f":"+MACRO_INPUT!F154","v":26.857142857142858},{"$f":"ROUND(H31/J31,2)","v":0.39},7.0000000000000007E-2,0.46]
["Direct Pumping","Pleasant Valley PP (City of Coalinga)","-",{"$f":"+MACRO_INPUT!J40","v":49429.8144824056},3.3579112183161581E-4,{"$f":"ROUND((+MACRO_INPUT!$U$16-779145)*E32,2)","v":46768.160000000003},2661.6544824055964,{"$f":"(G32/8)","v":332.70681030069954},63.226559153769827,{"$f":"MACRO_INPUT!F123","v":5618.2857142857147},0.06,0.01,6.9999999999999993E-2]
["Direct Pumping","Pleasant Valley WD Canalside Relift PP (City of Coalinga)","-",{"$f":"+MACRO_INPUT!J41-MACRO_INPUT!R32","v":202557.95000193163},1.3760351314138855E-3,{"$f":"ROUND((+MACRO_INPUT!$U$16-779145)*E33,2)","v":191650.79},10907.160001931625,1363.3950002414531,259.09531143895259,{"$f":"J32","v":5618.2857142857147},0.24,0.05,0.28999999999999998]
["Direct Pumping","San Benito County WD, Pacheco PP","-",{"$f":"+MACRO_INPUT!J43","v":224076.68224069598},1.5222181449354281E-3,{"$f":"ROUND((+MACRO_INPUT!$U$16-779145)*E34,2)","v":212010.8},12065.882240695995,1508.2352800869994,286.62030412914203,"-","-","-","-"]
["Direct Pumping","San Benito County WD, Gianelli, WR PGP","-",{"$f":"+MACRO_INPUT!J44-MACRO_INPUT!R33","v":363795.95464216103},2.4713718432137185E-3,{"$f":"ROUND((+MACRO_INPUT!$U$16-779145)*E35,2)","v":344206.6},19589.354642161052,2448.6693302701315,465.33744265234503,"-","-","-","-"]
["Total","Total San Benito County WD","-",{"$f":"SUM(D34:D35)","v":587872.63688285695},3.9935899881491464E-3,556217.39999999991,31655.236882857047,3956.9046103571309,751.95774678148712,{"$f":"MACRO_INPUT!F116","v":5210.1428571428569},{"$f":"ROUND(H36/J36,2)","v":0.76},{"$f":"ROUND(I36/J36,2)","v":0.14000000000000001},{"$f":"K36+L36","v":0.9}]
["Direct Pumping","San Luis WD Canalside Relift PP","-",{"$f":"+MACRO_INPUT!J45","v":73891.369871414092},{"$f":"D37/$D$51","v":5.0196558984919482E-4},{"$f":"ROUND((+MACRO_INPUT!$U$16-779145)*E37,2)","v":69912.53},{"$f":"D37-F37","v":3978.8398714140931},497.35498392676163,94.515781877884564,{"$f":"MACRO_INPUT!F133","v":454.71428571428572},{"$f":"ROUND(H37/J37,2)","v":1.0900000000000001},{"$f":"ROUND(I37/J37,2)","v":0.21},{"$f":"K37+L37","v":1.3}]
["Direct Pumping","Santa Clara Valley WD, Coyote PP","-",{"$f":"+MACRO_INPUT!J47","v":1356563.24660623},{"$f":"D38/$D$51","v":9.2155291130130903E-3},{"$f":"ROUND((+MACRO_INPUT!$U$16-779145)*E38,2)","v":1283516.25},{"$f":"D38-F38","v":73046.996606230037},9130.8745757787547,1735.2027779934945,"-","-","-","-"]
["Direct Pumping","Santa Clara Valley WD, Pacheco PP","-",{"$f":"+MACRO_INPUT!J48","v":4713216.4381806897},{"$f":"D39/$D$51","v":3.2018251571129169E-2},{"$f":"ROUND((+MACRO_INPUT!$U$16-779145)*E39,2)","v":4459423.41},{"$f":"D39-F39","v":253793.02818068955},31724.128522586194,6028.753925482466,"-","-","-","-"]
["Direct Pumping","Santa Clara Valley WD, Gianelli, WR PGP","-",{"$f":"+MACRO_INPUT!J49-MACRO_INPUT!R31","v":7865554.3415565705},{"$f":"D40/$D$51","v":5.3433000787792534E-2},{"$f":"ROUND((+MACRO_INPUT!$U$16-779145)*E40,2)","v":7442017.0599999996},{"$f":"D40-F40","v":423537.2815565709},52942.160194571363,10060.962143351073,"-","-","-","-"]
["Total","Total Santa Clara WD","-",{"$f":"SUM(D38:D40)","v":13935334.026343491},{"$f":"SUM(E38:E40)","v":9.4666781471934802E-2},{"$f":"SUM(F38:F40)","v":13184956.719999999},750377.30634349049,93797.163292936311,17824.918846827033,{"$f":"MACRO_INPUT!F117","v":81377},{"$f":"ROUND(H41/J41,2)","v":1.1499999999999999},{"$f":"ROUND(I41/J41,2)","v":0.22},{"$f":"K41+L41","v":1.3699999999999999}]
["Direct Pumping","Shasta Pumping Plant (City of Shasta Lake)","-",{"$f":"MACRO_INPUT!R34","v":569188.08611399995},{"$f":"D42/$D$51","v":3.8666603945568512E-3},{"$f":"ROUND((+MACRO_INPUT!$U$16-779145)*E42,2)","v":538538.96},{"$f":"D42-F42","v":30649.126113999984},3831.140764249998,728.05797975203677,{"$f":"MACRO_INPUT!F160","v":1167.8571428571429},{"$f":"ROUND(H42/J42,2)","v":3.28},{"$f":"ROUND(I42/J42,2)","v":0.62},{"$f":"K42+L42","v":3.9}]
["Direct Pumping","State Delta PP (Cross Valley Canal)  ","-",{"$f":"+MACRO_INPUT!J51","v":15079.579995012889},{"$f":"D43/$D$51","v":1.0243997749733291E-4},{"$f":"ROUND((+MACRO_INPUT!$U$16-779145)*E43,2)","v":14267.59},{"$f":"D43-F43","v":811.98999501288927},101.49874937661116,19.288504120772039,{"$f":"MACRO_INPUT!F53","v":278},{"$f":"ROUND(H43/J43,2)","v":0.37},{"$f":"ROUND(I43/J43,2)","v":7.0000000000000007E-2},{"$f":"K43+L43","v":0.44}]
["Direct Pumping","Westlands WD Relifts","-",{"$f":"+MACRO_INPUT!J52-MACRO_INPUT!R29","v":783611.28421443037},{"$f":"D44/$D$51","v":5.3232996110057626E-3},{"$f":"ROUND((+MACRO_INPUT!$U$16-779145)*E44,2)","v":741416.09},{"$f":"D44-F44","v":42195.194214430405},5274.3992768038006,1002.3303026891335,{"$f":"MACRO_INPUT!F126","v":2797},{"$f":"ROUND(H44/J44,2)","v":1.89},{"$f":"ROUND(I44/J44,2)","v":0.36},{"$f":"K44+L44","v":2.25}]
["Total","Total Direct Pumping","-",{"$f":"SUM(D28:D33)+D36+D37+D41+D42+D43+D44","v":22070617.226705067},0.1499321289322145,20882178.510000002,1188438.7167050641,148554.83958813301,28230.895978080105,"-","-","-","-"]
["Subtotal","Subtotal","-",{"$f":"SUM(D11,D14,D27,D45)","v":116956441.80000004},{"$f":"ROUND(SUM(E11+E14+E27+E45),8)","v":0.79451916},{"$f":"SUM(F11,F14,F27,F45)","v":110658676.76000001},{"$f":"SUM(G11,G14,G27,G45)","v":6297765.0400000392},787220.63000000489,149600.94049405941,"-","-","-","-"]
["Other Costs","Deferred Interest Capitalized ","-",{"$f":"+MACRO_INPUT!R18","v":21277763},{"$f":"D47/$D$51","v":0.14454603932168203},{"$f":"ROUND((+MACRO_INPUT!$U$16-779145)*E47,2)","v":20132017.210000001},{"$f":"D47-F47","v":1145745.7899999991},143218.22374999989,27216.742235132333,"-","-","-","-"]
["Other Costs","Programmatic EIS Capitalized  ","-",{"$f":"+MACRO_INPUT!R19","v":1591067.9586188002},{"$f":"D48/$D$51","v":1.0808587900428322E-2},{"$f":"ROUND((+MACRO_INPUT!$U$16-779145)*E48,2)","v":1505393.57},{"$f":"D48-F48","v":85674.388618800091},10709.298577350011,2035.1615267034401,"-","-","-","-"]
["Other Costs","All others","-",{"$f":"+MACRO_INPUT!R20","v":7378781.3949999996},{"$f":"D49/$D$51","v":5.0126210432354462E-2},{"$f":"ROUND((+MACRO_INPUT!$U$16-779145)*E49,2)","v":6981455.4299999997},{"$f":"D49-F49","v":397325.96499999985},49665.745624999981,9438.322590502572,"-","-","-","-"]
["Total","Total Other Costs","-",{"$f":"SUM(D47:D49)","v":30247612.353618801},0.20548083765446482,28618866.210000001,1628746.143618799,203593.26795234988,38690.226352338344,{"$f":"+MACRO_INPUT!D165","v":331768.71428571432},{"$f":"ROUND(H50/J50,2)","v":0.61},{"$f":"ROUND(I50/J50,2)","v":0.12},{"$f":"K50+L50","v":0.73}]
["Grand Total","Total","-",{"$f":"D46+D50","v":147204054.15361884},0.99999999765446479,139277542.97,7926511.183618838,990813.89795235475,188291.16684639774,"-","-","-","-"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,2.4207491611354961E-2]

{"sheet":"Footnotes","index":3,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[{"$f":"INFORMATION!A1","v":"Special Rates 2023 Sch S-2.Z25.XLSM"}]
[{"$f":"INFORMATION!$A$2","v":"01/05/2023"}]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF M&I UNPAID CAPITAL COSTS BY COMPONENT AND/OR FACILITY"]
[{"$f":"+OUTPUT!A6","v":"AS OF SEPTEMBER 30, 2021"}]
[{"$f":"+OUTPUT!A7","v":"2023 SPECIAL WATER RATES"}]
[]
["Footnotes:"]
[]
["1/"]
["Refer to M&I Water Rates, Schedule A-2Ba.  Total Allocation of Construction Repayment is being reduced by the Assignment "]
[]
["Repayment as of 9/30/21 (Column C of A-2Ba)","Construction Repayment per Assignment","Adjusted M&I Construction Repayment"]
[{"$f":"MACRO_INPUT!U16","v":140056688},-779145,{"$f":"SUM(A14:B14)","v":139277543}]
[]
["2/"]
["Annual Interest of 0.023755 is from M&I Schedule A-13."]
[]
["3/"]
["Contra Costa WD's conveyance costs are recovered through a repayment contract."]
[]
["4/"]
["Cross Valley Canal contractors are charged for PUE construction component only.  Therefore their deliveries are not included in determining the \"Construction only\" rate."]
[]
["5/"]
["Suballocation of Jones Pumping Plant costs:"]
[]
["Facility/Contractor\n<Ref>","Historical & Projected Deliveries (1981-2030)\n<Sch A-7>","Ratio","M&I Construction Costs at 9/30/2020","Project Use Energy: BOR","Project Use Energy: DOE","Project Use Energy: Total"]
["Jones Pumping Plant: Delta-Mendota Exchange",{"$f":"+MACRO_INPUT!X17","v":2496684.902082284},{"$f":"ROUND(B29/B31,9)","v":0.334984801},{"$f":"+D37*C29","v":1468825.9796224346},{"$f":"JonesPumpingPlantConveyancePumping[less:  BOR PUE (M&I Sch A-5)]*C29","v":1821434.8328963066},{"$f":"JonesPumpingPlantConveyancePumping[less:  DOE PUE (M&I Sch A-5)]*C29","v":1770796.5644511518},{"$f":"SUM(E29:F29)","v":3592231.3973474586}]
["Jones Pumping Plant: All Other Contractors",{"$f":"+MACRO_INPUT!X16","v":4956444},{"$f":"ROUND(B30/B31,9)","v":0.66501519899999995},{"$f":"+D37*C30","v":2915928.1203775667},{"$f":"JonesPumpingPlantConveyancePumping[less:  BOR PUE (M&I Sch A-5)]*C30","v":3615930.7653605128},{"$f":"JonesPumpingPlantConveyancePumping[less:  DOE PUE (M&I Sch A-5)]*C30","v":3515403.165103598},{"$f":"SUM(E30:F30)","v":7131333.9304641113}]
["Jones Pumping Plant: Total  a/",{"$f":"SUM(B29:B30)","v":7453128.902082284},1,4384754.1000000015,5437365.598256819,5286199.72955475,10723565.327811569]
[]
["a/"]
["Jones Pumping Plant - Conveyance Pumping:"]
[]
["Total Construction Cost (M&I Sch A-5)","less:  BOR PUE (M&I Sch A-5)","less:  DOE PUE (M&I Sch A-5)","   Capital Allocation"]
[{"$f":"+MACRO_INPUT!J30","v":15108319.42781157},{"$f":"+MACRO_INPUT!K30","v":5437365.5982568199},{"$f":"+MACRO_INPUT!L30","v":5286199.72955475},{"$f":"A37-B37-C37","v":4384754.1000000015}]
[]
["6/"]
["FY 2023 projected deliveries include Friant Dam and Friant-Kern Canal."]
[]
["7/"]
["FY 2023 projected deliveries for Jones PP do not include Delta Mendota Exchange contractors' deliveries."]