{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["INFORMATION","Flow Chart","MACRO_INPUT","OUTPUT","Footnotes"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":35,"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":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["2023 Full Cost Additional Service Water Rates Sch TR-2b.Z25.xlsm"]
["01/03/2023"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF M&I FULL COST ADDITIONAL SERVICE WATER RATES"]
["AS OF SEPTEMBER 30, 2021"]
["2023 SPECIAL WATER RATES"]
[]
[null,null,"SOURCE DATA:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["10/25/2022","rm","updated file names, title, headings, and dates"]
[null,null,"ran macro"]
[null,null,"Verified SchTR-2B, Output tab with M & I Sch A-4, Output tab, for Total M & I Construction"]
[null,null,"Verified SchTR-2B, Output tab with Sch S-6, Output tab, FY2023 Projected Deliveries"]
[null,null,"ready for review"]
["01/03/2023","KJ","Review"]

{"sheet":"Flow Chart","index":1,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[{"$f":"INFORMATION!A1","v":"2023 Full Cost Additional Service Water Rates Sch TR-2b.Z25.xlsm"}]
[{"$f":"INFORMATION!A2","v":"01/03/2023"}]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF M&I UNPAID CAPITAL COST PER ACRE-FOOT BY COMPONENT AND/OR FACILITY"]
[{"$f":"INFORMATION!A6","v":"2023 SPECIAL WATER RATES"}]

{"sheet":"MACRO_INPUT","index":2,"n_rows":170,"n_cols":26,"rows_kept":170,"cut":false,"hidden":true,"merged":[]}
[{"$f":"INFORMATION!A1","v":"2023 Full Cost Additional Service Water Rates Sch TR-2b.Z25.xlsm"}]
[{"$f":"INFORMATION!$A$2","v":"01/03/2023"}]
[]
[{"$f":"OUTPUT!A5","v":"SCHEDULE OF M&I FULL COST ADDITIONAL SERVICE WATER RATES"}]
[{"$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,2023]
[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 FC (FA-1I)"]
[null,null,null,null,null,null,"Capital Costs",null,null,null,"CVP PUE BOR","CVP 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,null,"Deferred Interest Capitalized  ",null,null,null,21277763,null,"  Grand Total                    ",140056688,null,"CVP Sub-Total (A/F)",4956444,null,8.0119999999999997E-2]
["  Total Conveyance - all other contractors",null,null,172696.71428571426,null,null,null,null,null,null,null,null,null,"Programmatic EIS Capitalized     2/",null,null,null,1591067.9586188002,null,null,null,null,"Delta-Mendota Exchange",2496684.902082284]
["  Total Dos Amigos Convey. Pumping",null,null,12196.428571428572,null,null,"Storage        1/",null,null,null,null,null,null,"All others",null,null,null,7378781.3949999996]
["  Total O'Neill Convey. Pumping",null,null,98940.571428571435,null,null,null,"San Felipe Unit Contractors",null,10103901.890000001,0,0]
["  CVP-Subtotal-Jones PP-Conv Pumping",null,null,106845,null,null,null,"All Other Contractors",null,40454308.979800545,548627.86061206402,533375.289188475]
["  Delta-Mendota Exc. -Conveyance PP Tracy",null,null,46430.984821142862,null,null,null,null,"Total Storage",50558210.869800545,548627.86061206402,533375.289188475]
["  Total Jones PP - conveyance Pumping",null,null,153275.98482114286]
[null,null,null,null,null,null,"Conveyance",null,null,null,null,null,"San Felipe Unit Contractors",null,null,null,null,809388.1100000001]
[null,null,null,null,null,null,null,"Contra Costa WD    3/",null,0,null,null,"All Other Contractors",null,null,null,null,379393.76]
[null,null,null,null,null,null,null,"All Other Contractors",null,26600102.019999996,null,null,"All Other Contractors",null,null,null,null,288911.73000000004]
[null,null,null,null,null,null,null,null,"Total Conveyance",26600102.019999996,null,null,"Dos Amigos PP",null,null,null,null,4604.8099999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,"O'Neill Pump-Generator Plant",null,null,null,null,138321.72999999998]
[null,"Schedule S-6",null,"2022",null,null,"Conveyance Pumping",null,null,null,null,null,"All Other Contractors",null,null,null,null,18027.080000000002]
[null,null,null,"Projected Deliveries",null,null,null,"Dos Amigos Pumping Plant",null,821360.68395645195,274432.25461938698,266802.67933706503,"Bella Vista WD (Wintu PP)",null,null,null,null,60913.26]
["Black Butte D&R",null,null,null,null,null,null,"O'Neill Pump-Generator Plant",null,3436478.7917264057,855429.16769389994,831647.11903250602,"Gianelli, WR PGP",null,null,null,null,115667.26999999999]
[null,"County of Colusa",null,6.5714285714285712,null,null,null,"Jones Pumping Plant",null,15108319.42781157,5437365.5982568199,5286199.72955475,"Westlands WD Relifts",null,null,null,null,3501.54]
[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,null,null,null,null,"Gianelli, WR PGP",null,null,null,null,15649.349999999999]
[null,"Whitney Const Inc.",null,4,null,null,null,null,"Total Conveyance Pumping",19366158.903494429,6567227.0205701068,6384649.5279243216,"Shasta PP (City of Shasta Lake)",null,null,null,null,16388.68]
[null,null,null,34.428571428571431]
[null,null,null,null,null,null,"Direct Pumping"]
[null,null,null,null,null,null,null,"Bella Vista WD (Wintu PP)",null,902585.83750450797,206588.863937046,200845.42356746201]
["Clear Creek Unit",null,null,null,null,null,null,"Colusa County WD",null,36408.492566129527,2142.4831993397702,2082.9193667897598]
[null,"Clear Creek CSD",null,1651.1428571428571,null,null,null,"Contra Costa Pumping Plants",null,4974012.6289530396,2522064.6610714099,2451947.9678816302]
[null,null,null,null,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]
["Contra Costa Canal",null,null,null,null,null,null,"Pleasant Valley Pumping Plant",null,206069.19000193162,152.35280448881801,148.117197442801]
[null,"Contra Costa WD",null,80723.71428571429,null,null,null,"San Benito County WD"]
[null,null,null,null,null,null,null,null,"Pacheco Pumping Plant      ",224076.68224069598,113617.701402648,110458.980838048]
[null,null,null,null,null,null,null,null,"Gianelli, William R. Pump-Generator Plant   1/",379445.30464216101,171345.440899145,166581.81374301601]
["Cow Creek Unit",null,null,null,null,null,null,"San Luis WD Canalside Relifts & Turnouts",null,73891.369871414092,37466.493676771403,36424.876194642697]
[null,"Bella Vista WD",null,3730.2857142857142,null,null,null,"Santa Clara Valley WD                  "]
[null,null,null,null,null,null,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]
["Cross Valley Canal",null,null,null,null,null,null,null,"Gianelli, William R. Pump-Generator Plant   1/",7981221.61155657,3604070.4142776602,3503872.5472789099]
[null,"County of Fresno",null,86,null,null,null,"Shasta Pumping Plant",null,585576.766114,137625.45682528499,133799.28928871499]
[null,"County of Tulare",null,192,null,null,null,"State-Delta Pumping Plant (Cross Valley Canal)",null,15079.579995012889,7646.0754417558701,7433.5045532570202]
[null,null,null,278,null,null,null,"Westlands WD Canalside Relift PP",null,787112.82421443041,43459.069061410897,42250.850153019499]
[null,null,null,null,null,null,null,null,"Total Direct Pumping",22286248.566705063,9935809.988817852,9659581.4878872111]
[]
["Delta-Mendota Canal"]
[null,"Byron Bethany ID   ",null,884.28571428571433,null,null,"Other Costs   4/",null,null,7378781.3949999996]
[null,"City of Tracy",null,6594.5714285714284]
[null,"Del Puerto WD",null,3]
[null,"Department of Veterans Affairs",null,367.14285714285717,null,null,null,"Total       ",null,126189501.75500004,17051664.870000023,16577606.305000007]
[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,"Santa Clara Valley WD",null,81377]
[null,null,null,86587.142857142855]
[]
[]
["San Luis Canal - Fresno"]
[null,"City of Avenal",null,2300.5714285714284]
[null,"City of Coalinga",null,5618.2857142857147]
[null,"City of Huron",null,1033.4285714285713]
[null,"State of CA",null,1.8571428571428572]
[null,"Westlands WD",null,2797]
[null,null,null,11751.142857142857]
[]
[]
["San Luis Canal - Tracy"]
[null,"Pacheco WD",null,11]
[null,"Panoche WD",null,136.57142857142858]
[null,"San Luis WD  2/",null,454.71428571428572]
[null,null,null,602.28571428571433]
[]
[]
["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,"Kanawha WD",null,26.857142857142858]
[null,null,null,156.14285714285714]
[]
[]
["Toyon Pipeline"]
[null,"City of Redding - TP",null,17.428571428571427]
[null,"City of Shasta Lake ",null,1167.8571428571429]
[null,"U.S. Forest Service",null,1]
[null,null,null,1186.2857142857142]
[]
[]
[null,null,null,331768.71428571432]
[]
[]
["Delta-Mendota Exchange",null,null,46430.984821142862]
[]
[null,null,null,378199.69910685718]

{"sheet":"OUTPUT","index":3,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"INFORMATION!A1","v":"2023 Full Cost Additional Service Water Rates Sch TR-2b.Z25.xlsm"}]
[{"$f":"INFORMATION!$A$2","v":"01/03/2023"}]
[{"$f":"INFORMATION!A3","v":"CENTRAL VALLEY PROJECT"}]
[{"$f":"INFORMATION!A4","v":"SCHEDULE OF M&I FULL COST ADDITIONAL SERVICE WATER RATES"}]
[{"$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 M&I Construction at 9/30/2021\n<Sch A-4>","C) Ratio of Total\n(B/$147,204,054)","D) Allocation of Construction Repayment at 9/30/2021  1/\n(C*$139,277,543)","E) Unpaid M&I Construction: Net Unpaid Construction at 9/30/2021\n(B-D)","F) Unpaid M&I Construction: Annualized Costs Remaining Years\n(E/10)","G) Unpaid M&I Construction: Annual Interest @\n(E*0.08012) ","H) FY 2023 Projected Deliveries\n<Sch S-6>","I) Unpaid M&I Construction Cost Per Acre Foot: Construction Only\n(F/H)","J) Unpaid M&I Construction Cost Per Acre Foot: Interest\n(G/H)","K) Unpaid M&I Construction Cost Per Acre Foot: Total\n(I+J)"]
["Storage","San Felipe Unit","-",{"$f":"+MACRO_INPUT!J19-MACRO_INPUT!R23","v":9294513.7800000012},{"$f":"D10/$D$52","v":6.3140338310930313E-2},{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E10","v":8794031.1841351446},{"$f":"D10-F10","v":500482.59586485662},{"$f":"G10/10","v":50048.259586485663},{"$f":"G10*MACRO_INPUT!$Z$16","v":40098.665580692308},{"$f":"MACRO_INPUT!D118","v":86587.142857142855},{"$f":"ROUND(H10/J10,2)","v":0.57999999999999996},{"$f":"ROUND(I10/J10,2)","v":0.46},{"$f":"K10+L10","v":1.04}]
["Storage","All Other Contractors","-",{"$f":"+MACRO_INPUT!J20-MACRO_INPUT!R24","v":40074915.219800547},{"$f":"D11/$D$52","v":0.2722405673554294},{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E11","v":37916997.326190211},{"$f":"D11-F11","v":2157917.8936103359},{"$f":"G11/10","v":215791.78936103359},{"$f":"G11*MACRO_INPUT!$Z$16","v":172892.3816360601},{"$f":"MACRO_INPUT!D16-J10","v":245181.57142857148},{"$f":"ROUND(H11/J11,2)","v":0.88},{"$f":"ROUND(I11/J11,2)","v":0.71},{"$f":"K11+L11","v":1.5899999999999999}]
["Total","Storage","-",{"$f":"SUM(D10:D11)","v":49369428.999800548},0.3353809056663597,46711028.510325357,2658400.4894751925,265840.04894751927,212991.04721675243,"-","-","-","-"]
["Conveyance","Contra Costa Canal System","2/",{"$f":"+MACRO_INPUT!J24","v":0},"-",{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E13","v":0},{"$f":"D13-F13","v":0},{"$f":"G13/10","v":0},{"$f":"G13*MACRO_INPUT!$Z$16","v":0},"-","-","-","-"]
["Conveyance","All Other Contractors","-",{"$f":"+MACRO_INPUT!J25-MACRO_INPUT!R25","v":26311190.289999995},{"$f":"D14/$D$52","v":0.17873957644225089},{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E14","v":24894409.043737385},{"$f":"D14-F14","v":1416781.24626261},{"$f":"G14/10","v":141678.12462626101},{"$f":"G14*MACRO_INPUT!$Z$16","v":113512.51345056031},{"$f":"MACRO_INPUT!D17","v":172696.71428571426},{"$f":"ROUND(H14/J14,2)","v":0.82},{"$f":"ROUND(I14/J14,2)","v":0.66},{"$f":"K14+L14","v":1.48}]
["Total","Conveyance","-",{"$f":"SUM(D13:D14)","v":26311190.289999995},{"$f":"SUM(E13:E14)","v":0.17873957644225089},{"$f":"SUM(F13:F14)","v":24894409.043737385},{"$f":"SUM(G13:G14)","v":1416781.24626261},{"$f":"SUM(H13:H14)","v":141678.12462626101},{"$f":"I14","v":113512.51345056031},"-","-","-","-"]
["Conveyance Pumping","Dos Amigos Pumping Plant, Construction only","3/",{"$f":"+MACRO_INPUT!J29-MACRO_INPUT!K29-MACRO_INPUT!L29-MACRO_INPUT!R26","v":275520.93999999994},{"$f":"D16/$D$52","v":1.8716939664750842E-3},{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E16","v":260684.93689857409},{"$f":"D16-F16","v":14836.003101425857},{"$f":"G16/10","v":1483.6003101425856},{"$f":"G16*MACRO_INPUT!$Z$16","v":1188.6605684862395},{"$f":"MACRO_INPUT!D18-MACRO_INPUT!D53","v":11918.428571428572},{"$f":"ROUND(H16/J16,2)","v":0.12},{"$f":"ROUND(I16/J16,2)","v":0.1},{"$f":"K16+L16","v":0.22}]
["Conveyance Pumping","Dos Amigos Pumping Plant, PUE only","-",{"$f":"+MACRO_INPUT!K29+MACRO_INPUT!L29","v":541234.93395645195},{"$f":"D17/$D$52","v":3.6767664930724758E-3},{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E17","v":512091.00333986094},{"$f":"D17-F17","v":29143.930616591009},2914.393061659101,{"$f":"G17*MACRO_INPUT!$Z$16","v":2335.0117210012718},{"$f":"MACRO_INPUT!D18","v":12196.428571428572},{"$f":"ROUND(H17/J17,2)","v":0.24},{"$f":"ROUND(I17/J17,2)","v":0.19},{"$f":"K17+L17","v":0.43}]
["Conveyance Pumping","Dos Amigos Pumping Plant, Unpaid M&I Construction Per Acre Foot Total","-",0,"-",{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E18","v":0},0,0,{"$f":"G18*MACRO_INPUT!$Z$16","v":0},"-",{"$f":"SUM(K16:K17)","v":0.36},{"$f":"SUM(L16:L17)","v":0.29000000000000004},{"$f":"SUM(M16:M17)","v":0.65}]
["Conveyance Pumping","O'Neill P-Generator/Pumping Plant, Construction only  ","-",{"$f":"+MACRO_INPUT!J30-MACRO_INPUT!K30-MACRO_INPUT!L30-MACRO_INPUT!R27","v":1611080.7749999999},{"$f":"D19/$D$52","v":1.0944540789064901E-2},{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E19","v":1524328.7503642407},{"$f":"D19-F19","v":86752.024635759182},8675.202463575919,{"$f":"G19*MACRO_INPUT!$Z$16","v":6950.5722138170258},{"$f":"MACRO_INPUT!D19","v":98940.571428571435},{"$f":"ROUND(H19/J19,2)","v":0.09},{"$f":"ROUND(I19/J19,2)","v":7.0000000000000007E-2},{"$f":"K19+L19","v":0.16}]
["Conveyance Pumping","O'Neill P-Generator/Pumping Plant, PUE only  ","-",{"$f":"+MACRO_INPUT!K30+MACRO_INPUT!L30","v":1687076.2867264058},{"$f":"D20/$D$52","v":1.1460800427179885E-2},{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E20","v":1596232.124310965},{"$f":"D20-F20","v":90844.162415440893},9084.4162415440896,{"$f":"G20*MACRO_INPUT!$Z$16","v":7278.4342927251237},{"$f":"J19","v":98940.571428571435},{"$f":"ROUND(H20/J20,2)","v":0.09},{"$f":"ROUND(I20/J20,2)","v":7.0000000000000007E-2},{"$f":"K20+L20","v":0.16}]
["Conveyance Pumping","O'Neill P-Generator/Pumping Plant, Unpaid M&I Construction Per Acre Foot Total","-",0,"-",{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E21","v":0},0,0,{"$f":"G21*MACRO_INPUT!$Z$16","v":0},"-",{"$f":"SUM(K19:K20)","v":0.18},{"$f":"SUM(L19:L20)","v":0.14000000000000001},{"$f":"SUM(M19:M20)","v":0.32}]
["Conveyance Pumping","Jones Pumping Plant, Friant Kern/Madera, Construction only","4/, 5/",{"$f":"+Footnotes!D25","v":1468825.9796224346},{"$f":"D22/$D$52","v":9.9781625449636112E-3},{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E22","v":1389733.9629171588},{"$f":"D22-F22","v":79092.016705275746},7909.2016705275746,{"$f":"G22*MACRO_INPUT!$Z$16","v":6336.8523784266927},{"$f":"MACRO_INPUT!D87+MACRO_INPUT!D99","v":44080.571428571428},{"$f":"ROUND(H22/J22,2)","v":0.18},{"$f":"ROUND(I22/J22,2)","v":0.14000000000000001},{"$f":"K22+L22","v":0.32}]
["Conveyance Pumping","Jones Pumping Plant, Friant Kern/Madera, PUE only","4/, 5/",{"$f":"+Footnotes!G25","v":3592231.3973474586},{"$f":"D23/$D$52","v":2.4403073801205818E-2},{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E23","v":3398800.160679617},{"$f":"D23-F23","v":193431.23666784167},19343.123666784166,{"$f":"G23*MACRO_INPUT!$Z$16","v":15497.710681827473},{"$f":"J22","v":44080.571428571428},{"$f":"ROUND(H23/J23,2)","v":0.44},{"$f":"ROUND(I23/J23,2)","v":0.35},{"$f":"K23+L23","v":0.79}]
["Conveyance Pumping","Jones Pumping Plant, Friant Kern/Madera, Unpaid M&I Construction Per Acre Foot Total","-",0,"-",{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E24","v":0},0,0,{"$f":"G24*MACRO_INPUT!$Z$16","v":0},"-",{"$f":"SUM(K22:K23)","v":0.62},{"$f":"SUM(L22:L23)","v":0.49},{"$f":"SUM(M22:M23)","v":1.1100000000000001}]
["Conveyance Pumping","Jones Pumping Plant, All Other Contractors, Construction only Construction only","4/, 6/",{"$f":"+Footnotes!D26-MACRO_INPUT!R28","v":2897901.0403775666},{"$f":"D25/$D$52","v":1.9686285524129533E-2},{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E25","v":2741857.4785972284},{"$f":"D25-F25","v":156043.56178033818},15604.356178033817,{"$f":"G25*MACRO_INPUT!$Z$16","v":12502.210169840695},{"$f":"MACRO_INPUT!D20","v":106845},{"$f":"ROUND(H25/J25,2)","v":0.15},{"$f":"ROUND(I25/J25,2)","v":0.12},{"$f":"K25+L25","v":0.27}]
["Conveyance Pumping","Jones Pumping Plant, All Other Contractors, PUE only","4/, 6/",{"$f":"+Footnotes!G26","v":7131333.9304641113},{"$f":"D26/$D$52","v":4.8445227758618738E-2},{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E26","v":6747332.2922958145},{"$f":"D26-F26","v":384001.63816829678},38400.163816829678,{"$f":"G26*MACRO_INPUT!$Z$16","v":30766.211250043936},{"$f":"J25","v":106845},{"$f":"ROUND(H26/J26,2)","v":0.36},{"$f":"ROUND(I26/J26,2)","v":0.28999999999999998},{"$f":"K26+L26","v":0.64999999999999991}]
["Conveyance Pumping","Jones Pumping Plant, All Other Contractors, Unpaid M&I Construction Per Acre Foot Total","-",0,"-",{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E27","v":0},0,0,{"$f":"G27*MACRO_INPUT!$Z$16","v":0},"-",{"$f":"SUM(K25:K26)","v":0.51},{"$f":"SUM(L25:L26)","v":0.41},{"$f":"SUM(M25:M26)","v":0.91999999999999993}]
["Total","Conveyance Pumping","-",{"$f":"SUM(D16:D26)","v":19205205.283494428},0.13046655130471005,18171060.709403459,1034144.5740909693,103414.45740909693,82855.66327616846,"-","-","-","-"]
["Direct Pumping","Bella Vista WD (Wintu PP)","-",{"$f":"+MACRO_INPUT!J37-MACRO_INPUT!R29","v":841672.57750450796},{"$f":"D29/$D$52","v":5.7177268815311114E-3},{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E29","v":796350.9516047053},{"$f":"D29-F29","v":45321.625899802661},{"$f":"G29/10","v":4532.1625899802657},{"$f":"G29*MACRO_INPUT!$Z$16","v":3631.168667092189},{"$f":"MACRO_INPUT!D47","v":3730.2857142857142},{"$f":"ROUND(H29/J29,2)","v":1.21},{"$f":"ROUND(I29/J29,2)","v":0.97},{"$f":"K29+L29","v":2.1799999999999997}]
["Direct Pumping","Colusa County WD Relift PP","-",{"$f":"+MACRO_INPUT!J38","v":36408.492566129527},2.473334907483896E-4,{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E30","v":34448.000893048935},1960.4916730805926,196.04916730805925,{"$f":"G30*MACRO_INPUT!$Z$16","v":157.07459284721708},{"$f":"MACRO_INPUT!D153","v":129.28571428571428},1.52,1.21,2.73]
["Direct Pumping","Contra Costa PP (Contra Costa WD)","-",{"$f":"+MACRO_INPUT!J39","v":4974012.6289530396},3.3789916028822628E-2,{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E31","v":4706176.4826707328},267836.14628230687,26783.614628230687,{"$f":"G31*MACRO_INPUT!$Z$16","v":21459.032040138427},{"$f":"MACRO_INPUT!D43","v":80723.71428571429},0.33,0.27,0.60000000000000009]
["Direct Pumping","Kanawha WD","-",{"$f":"+MACRO_INPUT!J40","v":1558.7797758448521},1.0589244873773277E-5,{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E32","v":1474.844008244487},83.935767600365125,8.3935767600365132,{"$f":"G32*MACRO_INPUT!$Z$16","v":6.7249337001412535},{"$f":"MACRO_INPUT!D154","v":26.857142857142858},0.31,0.25,0.56000000000000005]
["Direct Pumping","Pleasant Valley PP (City of Coalinga)","-",{"$f":"+MACRO_INPUT!J41-MACRO_INPUT!R32","v":45918.574482405602},3.1193824617415777E-4,{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E33","v":43445.992494865844},2472.5819875397574,247.25819875397573,{"$f":"G33*MACRO_INPUT!$Z$16","v":198.10326884168535},{"$f":"MACRO_INPUT!D123","v":5618.2857142857147},0.04,0.04,0.08]
["Direct Pumping","Canalside Relift PP (City of Coalinga)","-",{"$f":"+MACRO_INPUT!J42","v":206069.19000193162},1.3998880070713437E-3,{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E34","v":194972.96210006336},11096.22790186826,1109.622790186826,{"$f":"G34*MACRO_INPUT!$Z$16","v":889.02977949768501},{"$f":"J33","v":5618.2857142857147},0.2,0.16,0.36]
["Direct Pumping","San Benito County WD, Pacheco PP","-",{"$f":"+MACRO_INPUT!J44","v":224076.68224069598},1.5222181449354281E-3,{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E35","v":212010.80313662431},12065.879104071675,1206.5879104071676,{"$f":"G35*MACRO_INPUT!$Z$16","v":966.71823381822253},"-","-","-","-"]
["Direct Pumping","San Benito County WD, Gianelli, WR PGP","-",{"$f":"+MACRO_INPUT!J45-MACRO_INPUT!R33","v":363795.95464216103},2.4713718432137185E-3,{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E36","v":344206.5981621879},19589.356479973125,1958.9356479973126,{"$f":"G36*MACRO_INPUT!$Z$16","v":1569.4992411754467},"-","-","-","-"]
["Total","San Benito County WD","-",{"$f":"SUM(D35:D36)","v":587872.63688285695},3.9935899881491464E-3,556217.40129881224,31655.2355840448,3165.5235584044804,2536.2174749936694,{"$f":"MACRO_INPUT!D116","v":5210.1428571428569},{"$f":"ROUND(H37/J37,2)","v":0.61},{"$f":"ROUND(I37/J37,2)","v":0.49},{"$f":"K37+L37","v":1.1000000000000001}]
["Direct Pumping","San Luis WD Canalside Relift PP","-",{"$f":"+MACRO_INPUT!J46","v":73891.369871414092},{"$f":"D38/$D$52","v":5.0196558984919482E-4},{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E38","v":69912.534024741588},{"$f":"D38-F38","v":3978.835846672504},{"$f":"G38/10","v":397.88358466725037},{"$f":"G38*MACRO_INPUT!$Z$16","v":318.78432803540102},{"$f":"MACRO_INPUT!D133","v":454.71428571428572},{"$f":"ROUND(H38/J38,2)","v":0.88},{"$f":"ROUND(I38/J38,2)","v":0.7},{"$f":"K38+L38","v":1.58}]
["Direct Pumping","Santa Clara Valley WD, Coyote PP","-",{"$f":"+MACRO_INPUT!J48","v":1356563.24660623},{"$f":"D39/$D$52","v":9.2155291130130903E-3},{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E39","v":1283516.2523054325},{"$f":"D39-F39","v":73046.994300797582},{"$f":"G39/10","v":7304.6994300797578},{"$f":"G39*MACRO_INPUT!$Z$16","v":5852.525183379902},"-","-","-","-"]
["Direct Pumping","Santa Clara Valley WD, Pacheco PP","-",{"$f":"+MACRO_INPUT!J49","v":4713216.4381806897},{"$f":"D40/$D$52","v":3.2018251571129169E-2},{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E40","v":4459423.4099827604},{"$f":"D40-F40","v":253793.02819792926},{"$f":"G40/10","v":25379.302819792927},{"$f":"G40*MACRO_INPUT!$Z$16","v":20333.89741921809},"-","-","-","-"]
["Direct Pumping","Santa Clara Valley WD, Gianelli, WR PGP","-",{"$f":"+MACRO_INPUT!J50-MACRO_INPUT!R30","v":7865554.3415565705},{"$f":"D41/$D$52","v":5.3433000787792534E-2},{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E41","v":7442017.0648408085},{"$f":"D41-F41","v":423537.27671576198},{"$f":"G41/10","v":42353.727671576198},{"$f":"G41*MACRO_INPUT!$Z$16","v":33933.806610466847},"-","-","-","-"]
["Total","Santa Clara WD","-",{"$f":"SUM(D39:D41)","v":13935334.026343491},9.4666781471934802E-2,13184956.727129001,750377.29921448883,75037.729921448888,60120.229213064842,{"$f":"MACRO_INPUT!D117","v":81377},{"$f":"ROUND(H42/J42,2)","v":0.92},{"$f":"ROUND(I42/J42,2)","v":0.74},{"$f":"K42+L42","v":1.6600000000000001}]
["Direct Pumping","Shasta Pumping Plant (City of Shasta Lake)","-",{"$f":"+MACRO_INPUT!J51-MACRO_INPUT!R34","v":569188.08611399995},{"$f":"D43/$D$52","v":3.8666603945568512E-3},{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E43","v":538538.95936928876},{"$f":"D43-F43","v":30649.12674471119},{"$f":"G43/10","v":3064.9126744711189},{"$f":"G43*MACRO_INPUT!$Z$16","v":2455.6080347862603},{"$f":"MACRO_INPUT!D160","v":1167.8571428571429},{"$f":"ROUND(H43/J43,2)","v":2.62},{"$f":"ROUND(I43/J43,2)","v":2.1},{"$f":"K43+L43","v":4.7200000000000006}]
["Direct Pumping","State Delta PP (Cross Valley Canal)  ","-",{"$f":"+MACRO_INPUT!J52","v":15079.579995012889},{"$f":"D44/$D$52","v":1.0243997749733291E-4},{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E44","v":14267.588370803816},{"$f":"D44-F44","v":811.99162420907305},{"$f":"G44/10","v":81.1991624209073},{"$f":"G44*MACRO_INPUT!$Z$16","v":65.056768931630927},{"$f":"MACRO_INPUT!D53","v":278},{"$f":"ROUND(H44/J44,2)","v":0.28999999999999998},{"$f":"ROUND(I44/J44,2)","v":0.23},{"$f":"K44+L44","v":0.52}]
["Direct Pumping","Westlands WD Relifts","-",{"$f":"+MACRO_INPUT!J53-MACRO_INPUT!R31","v":783611.28421443037},{"$f":"D45/$D$52","v":5.3232996110057626E-3},{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E45","v":741416.09047373838},{"$f":"D45-F45","v":42195.19374069199},{"$f":"G45/10","v":4219.5193740691993},{"$f":"G45*MACRO_INPUT!$Z$16","v":3380.6789225042421},{"$f":"MACRO_INPUT!D126","v":2797},{"$f":"ROUND(H45/J45,2)","v":1.51},{"$f":"ROUND(I45/J45,2)","v":1.21},{"$f":"K45+L45","v":2.7199999999999998}]
["Total","Direct Pumping","-",{"$f":"SUM(D29:D34)+D37+D38+D42+D43+D44+D45","v":22070617.226705067},0.1499321289322145,20882178.534438044,1188438.692267017,118843.8692267017,95217.708024433392,"-","-","-","-"]
["Subtotal","-","-",{"$f":"SUM(D12,D15,D28,D46)","v":116956441.80000004},{"$f":"ROUND(SUM(E12+E15+E28+E46),8)","v":0.79451916},{"$f":"SUM(F12,F15,F28,F46)","v":110658676.79790424},{"$f":"SUM(G12,G15,G28,G46)","v":6297765.0020957887},{"$f":"SUM(H12,H15,H28,H46)","v":629776.5002095789},{"$f":"SUM(I12,I15,I28,I46)","v":504576.93196791457},"-","-","-","-"]
["Other Costs","Other Costs: Deferred Interest Capitalized ","-",{"$f":"+MACRO_INPUT!R16","v":21277763},{"$f":"D48/$D$52","v":0.14454603932168203},{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E48","v":20132017.20710526},{"$f":"D48-F48","v":1145745.7928947397},{"$f":"G48/10","v":114574.57928947397},{"$f":"G48*MACRO_INPUT!$Z$16","v":91797.152926726543},"-","-","-","-"]
["Other Costs","Other Costs: Programmatic EIS Capitalized  ","-",{"$f":"+MACRO_INPUT!R17","v":1591067.9586188002},1.0808587900428322E-2,{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E49","v":1505393.5660711853},{"$f":"D49-F49","v":85674.392547614872},{"$f":"G49/10","v":8567.439254761488},{"$f":"G49*MACRO_INPUT!$Z$16","v":6864.2323309149033},"-","-","-","-"]
["Other Costs","Other Costs: All others","-",{"$f":"+MACRO_INPUT!R18","v":7378781.3949999996},5.0126210432354462E-2,{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E50","v":6981455.4289192976},{"$f":"D50-F50","v":397325.96608070191},{"$f":"G50/10","v":39732.596608070191},{"$f":"G50*MACRO_INPUT!$Z$16","v":31833.756402385836},"-","-","-","-"]
["Total","Other Costs","-",{"$f":"SUM(D48:D50)","v":30247612.353618801},0.20548083765446482,28618866.202095743,1628746.1515230564,162874.61515230563,130495.14166002729,{"$f":"+MACRO_INPUT!D165","v":331768.71428571432},{"$f":"ROUND(H51/J51,2)","v":0.49},{"$f":"ROUND(I51/J51,2)","v":0.39},{"$f":"K51+L51","v":0.88}]
["Grand Total","-","-",{"$f":"D47+D51","v":147204054.15361884},0.99999999765446479,{"$f":"AllocationOfAdjustedMIConstructionRepayment[Adjusted M&I Construction Repayment]*E52","v":139277542.67331961},7926511.1536188452,792651.11536188447,635072.07362794189,"-","-","-","-"]

{"sheet":"Footnotes","index":4,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[{"$f":"INFORMATION!A1","v":"2023 Full Cost Additional Service Water Rates Sch TR-2b.Z25.xlsm"}]
[{"$f":"INFORMATION!$A$2","v":"01/03/2023"}]
[{"$f":"+OUTPUT!A4","v":"CENTRAL VALLEY PROJECT"}]
[{"$f":"+OUTPUT!A5","v":"SCHEDULE OF M&I FULL COST ADDITIONAL SERVICE WATER RATES"}]
[{"$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/2021 (Column C of A-2Ba)","Construction Repayment per Assignment","Adjusted M&I Construction Repayment"]
[{"$f":"MACRO_INPUT!U16","v":140056688},-779145,{"$f":"SUM(A13:B13)","v":139277543}]
[]
["2/"]
["Contra Costa WD's conveyance costs are recovered through a repayment contract."]
[]
["3/"]
["Cross Valley Canal contractors are charged for PUE constrcution component only.  Therefore their deliveries are not included in determining the \"Construction only\" rate."]
[]
["4/"]
["Suballocation of Jones Pumping Plant costs:"]
[]
["Component/Facility","Historical & Projected Deliveries (1981-2030) (Sch A-7)","Ratio","M&I\nConstruction\nCosts\nat 9/30/2021","Project Use Energy\nBOR","Project Use Energy\nDOE","Project Use Energy\nTotal"]
["Jones Pumping Plant: Delta-Mendota Exchange",{"$f":"+MACRO_INPUT!X17","v":2496684.902082284},{"$f":"ROUND(B25/B27,9)","v":0.334984801},{"$f":"+D33*C25","v":1468825.9796224346},{"$f":"+B33*C25","v":1821434.8328963066},{"$f":"+C33*C25","v":1770796.5644511518},{"$f":"SUM(E25:F25)","v":3592231.3973474586}]
["Jones Pumping Plant: All Other Contractors",{"$f":"+MACRO_INPUT!X16","v":4956444},{"$f":"ROUND(B26/B27,9)","v":0.66501519899999995},{"$f":"+D33*C26","v":2915928.1203775667},{"$f":"+B33*C26","v":3615930.7653605128},{"$f":"+C33*C26","v":3515403.165103598},{"$f":"SUM(E26:F26)","v":7131333.9304641113}]
["Total a/",{"$f":"SUM(B25:B26)","v":7453128.902082284},1,4384754.1000000015,5437365.598256819,5286199.72955475,10723565.327811569]
[]
["a/"]
["Jones Pumping Plant - Conveyance Pumping:"]
[]
["Total Construction (M&I Sch A-5)","Less:  BOR PUE (M&I Sch A-5)","Less:  DOE PUE (M&I Sch A-5)","Construction Allocation"]
[{"$f":"+MACRO_INPUT!J31","v":15108319.42781157},{"$f":"+MACRO_INPUT!K31","v":5437365.5982568199},{"$f":"+MACRO_INPUT!L31","v":5286199.72955475},{"$f":"A33-B33-C33","v":4384754.1000000015}]
[]
["5/"]
["FY 2021 projected deliveries include Friant Dam and Friant-Kern Canal"]
[]
["6/"]
["FY 2021 projected deliveries for Jones PP do not include Delta Mendota Exchange contractors' deliveries."]