{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["INFORMATION","MACRO_INPUT","OUTPUT","Footnote"],"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":42,"n_cols":3,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
["2023 Cost of Service Additional Service Water Rates Sch TR-1.Z25.xlsm"]
["01/03/2023"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF WATER RATES FOR ADDITIONAL CVP SERVICES WHEN TRANSFERRING"]
["CVP WATER TO CVP M&I WATER CONTRACTORS"]
["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 Net Contruction Costs in Sch TR-1, Output tab, and M & I Sch A-4, Output tabs"]
[null,null,"Verified Net Contruction Costs in Sch TR-1, Output tab, and M & I Sch A-4, Output tabs"]
[null,null,"Verified 7 year Average Water Deliveries in Sch TR-1, Output tab, and M & I Sch A-7, Output tab"]
[null,null,"ready for review"]
["10/31/2022","KJ","Reviewed"]
["01/03/23","KJ","Updated with Final"]

{"sheet":"MACRO_INPUT","index":1,"n_rows":284,"n_cols":18,"rows_kept":284,"cut":false,"hidden":true,"merged":[]}
[{"$f":"INFORMATION!A1","v":"2023 Cost of Service Additional Service Water Rates Sch TR-1.Z25.xlsm"}]
[{"$f":"INFORMATION!$A$2","v":"01/03/2023"}]
[{"$f":"OUTPUT!A4","v":"CENTRAL VALLEY PROJECT"}]
[{"$f":"OUTPUT!A5","v":"SCHEDULE OF WATER RATES FOR ADDITIONAL CVP SERVICES WHEN TRANSFERRING"}]
[{"$f":"OUTPUT!A6","v":"CVP WATER TO CVP M&I WATER CONTRACTORS"}]
[{"$f":"OUTPUT!A7","v":"2023 SPECIAL WATER RATES"}]
[null,"RESERVED FOR MACRO INPUT"]
[]
[]
[]
[]
[]
[]
[null,"M&I Schedule A-13"]
[null,"Composite Construction Interest Rate",null,2.3754608109186889E-2]
[]
[]
[null,"M&I Schedule A-7",null,null,null,null,"M&I Schedule A-5",null,null,"Total","PUE BOR","PUE DOE",null,"M&I Schedule A-4",null,null,"Misc. Revenue","Other Cost"]
[]
["Storage",null,null,null,null,null,"Storage        1/",null,null,null,null,null,null,null,"San Felipe Unit Contractors",null,809388.1100000001]
["Total",null,null,17731349.52,null,null,null,"San Felipe Unit Contractors",null,10103901.890000001,0,0,null,null,"All Other Contractors",null,379393.76]
[null,null,null,null,null,null,null,"All Other Contractors",null,40454308.979800545,548627.86061206402,533375.289188475,null,null,"  Total Storage",null,1188781.8700000001]
["Conveyance",null,null,null,null,null,null,null,"Total Storage",50558210.869800545,548627.86061206402,533375.289188475]
["Total",null,null,9447904.4285714272,null,null,null,null,null,null,null,null,null,"Conveyance"]
[null,null,null,null,null,null,"Conveyance",null,null,null,null,null,null,null,"Contra Costa Canal System   ",null,0]
["Conveyance Pumping",null,null,null,null,null,null,"Contra Costa WD    3/",null,0,null,null,null,null,"All Other Contractors",null,288911.73000000004]
["Dos Amigos PP",null,null,647865.12275094097,null,null,null,"All Other Contractors",null,26600102.019999996]
[null,null,null,null,null,null,null,null,"Total Conveyance",26600102.019999996]
["O'Neill PP",null,null,4550366.1428571427,null,null,null,null,null,null,null,null,null,null,null,"Total Conveyance",288911.73000000004]
[null,null,null,null,null,null,"Conveyance Pumping"]
["Jones PP - Subtotal",null,null,4956444,null,null,null,"Dos Amigos Pumping Plant",null,821360.68395645195,274432.25461938698,266802.67933706503,null,"Conveyance Pumping"]
["Jones PP - Total",null,null,7453128.902082284,null,null,null,"O'Neill Pump-Generator Plant",null,3436478.7917264057,855429.16769389994,831647.11903250602,null,null,"Dos Amigos PP",null,4604.8099999999995]
[null,null,null,null,null,null,null,"Jones Pumping Plant",null,15108319.42781157,5437365.5982568199,5286199.72955475,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"O'Neill Pump-Generator Plant",null,138321.72999999998]
[null,"County of Colusa",null,1172.142857142858,null,null,null,null,null,null,null,null,null,null,"Jones PP  ",null,0]
[null,"Elk Creek CSD",null,499,null,null,null,null,"Total Conveyance Pumping",19366158.903494429,6567227.0205701068,6384649.5279243216,null,null,null,"FK/Madera Exchange",0]
[null,"US Forest Service - BB",null,339.7142857142855,null,null,null,null,null,null,null,null,null,null,null,"All Other Contractors",18027.080000000002]
[null,"Whitney Const.",null,807,null,null,"Direct Pumping"]
[null,null,"Total Black Butte D&R",2817.8571428571436,null,null,null,"Bella Vista WD (Wintu PP)",null,902585.83750450797,206588.863937046,200845.42356746201,null,null,null,"Total Conveyance Pumping",160953.62]
[null,null,null,null,null,null,null,"Colusa County WD",null,36408.492566129527,2142.4831993397702,2082.9193667897598]
[null,null,null,null,null,null,null,"Contra Costa Pumping Plants",null,4974012.6289530396,2522064.6610714099,2451947.9678816302,null,"Direct Pumping"]
[null,null,null,null,null,null,null,"Kanawha WD",null,1558.7797758448521,36.781170219676497,35.758605625175399]
[null,"Clear Creek CSD",null,87953.285714285696,null,null,null,"Pleasant Valley Canalside Relifts",null,49429.8144824056,11922.7081746023,11591.241307803301,null,null,"Bella Vista WD (Wintu PP)",null,60913.26]
[null,null,null,null,null,null,null,"Pleasant Valley Pumping Plant",null,206069.19000193162,152.35280448881801,148.117197442801,null,null,"Colusa County WD Relift PP",null,0]
[null,null,null,null,null,null,null,"San Benito County WD",null,null,null,null,null,null,"Contra Costa PP (Contra Costa WD)",null,0]
[null,null,null,null,null,null,null,null,"Pacheco Pumping Plant      ",224076.68224069598,113617.701402648,110458.980838048,null,null,"Kanawha WD Relift PP",null,0]
[null,"Contra Costa WD",null,5074478.428571431,null,null,null,null,"Gianelli, William R. Pump-Generator Plant   1/",379445.30464216101,171345.440899145,166581.81374301601,null,null,"Pleasant Valley PP (City of Coalinga)",null,3511.24]
[null,null,null,null,null,null,null,"San Luis WD Canalside Relifts & Turnouts",null,73891.369871414092,37466.493676771403,36424.876194642697,null,null,"Pleasant Valley WD Canalside Relift PP",null,0]
[null,null,null,null,null,null,null,"Santa Clara Valley WD                  ",null,null,null,null,null,null,"San Benito County WD"]
[null,null,null,null,null,null,null,null,"Coyote Pumping Plant       ",1356563.24660623,687843.09168391,668720.15492232004,null,null,null,"Pacheco PP",0]
[null,"Bella Vista WD",null,176335.57142857139,null,null,null,null,"Pacheco Pumping Plant    ",4713216.4381806897,2389828.3951921598,2323388.0429885299,null,null,null,"Gianelli, WR PGP",15649.349999999999]
[null,null,null,null,null,null,null,null,"Gianelli, William R. Pump-Generator Plant   1/",7981221.61155657,3604070.4142776602,3503872.5472789099,null,null,null,"   Total San Benito County WD",15649.349999999999]
[null,null,null,null,null,null,null,"Shasta Pumping Plant",null,585576.766114,137625.45682528499,133799.28928871499]
[null,null,null,null,null,null,null,"State-Delta Pumping Plant (Cross Valley Canal)",null,15079.579995012889,7646.0754417558701,7433.5045532570202,null,null,"San Luis WD Canalside Relifts & Turnouts",null,0]
[null,"County of Fresno",null,1782,null,null,null,"Westlands WD Canalside Relift PP",null,787112.82421443041,43459.069061410897,42250.850153019499,null,null,"Santa Clara Valley WD"]
[null,"County of Tulare",null,6599,null,null,null,null,"Total Direct Pumping",22286248.566705063,9935809.988817852,9659581.4878872111,null,null,null,"Coyote PP",0]
[null,null,"Total Cross Valley Canal",8381,null,null,null,null,null,null,null,null,null,null,null,"Pacheco PP",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gianelli, WR PGP",115667.26999999999]
[null,null,null,null,null,null,"Other Costs   4/",null,null,7378781.3949999996,null,null,null,null,null,"   Total Santa Clara WD",115667.26999999999]
[]
[null,"Byron Bethany ID",null,31453.571428571424]
[null,"City of Tracy",null,359752.14285714278,null,null,null,"Total       ",null,126189501.75500004,17051664.870000023,16577606.305000007,null,null,"Shasta PP (City of Shasta Lake)",null,16388.68]
[null,"Del Puerto WD",null,526,null,null,null,null,null,null,null,null,null,null,"State Delta PP (Cross Valley Canal)",null,0]
[null,"Department of Veterans Affairs",null,8089.2857142857119,null,null,null,null,null,null,null,null,null,null,"Westlands WD Relifts",null,3501.54]
[null,"Panoche WD - DMC",null,1171.8571428571422,null,null,null,null,null,null,null,null,null," "]
[null,"San Luis WD - DMC",null,5085,null,null,null,null,null,null,null,null,null,null,null,"Total Direct Pumping",215631.34]
[null,null,"Total Delta-Mendota Canal",406077.8571428571]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub-total",1854278.5600000003]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Costs"]
[null,"City of Folsom",null,46284]
[null,"City of Roseville",null,1099189.142857143,null,null,null,null,null,null,null,null,null,null,"Deferred Interest Capitalized  ",null,0,21277763]
[null,"El Dorado ID - FD&R",null,262795,null,null,null,null,null,null,null,null,null,null,"Programmatic EIS Capitalized     2/",null,0,1591067.9586188002]
[null,"Placer County WA",null,30085,null,null,null,null,null,null,null,null,null,null,"All others",null,0,7378781.3949999996]
[null,"Sacramento County WA  ",null,106759.42857142861,null,null,null,null,null,null,null,null,null,null,null,"Total Other Costs",0]
[null,"San Juan  WD",null,230052.42857142861]
[null,null,"Total Folsom D&R",1775165.0000000002,null,null,null,null,null,null,null,null,null,null,null,"   Grand Total",1854278.5600000003]
[]
[]
[]
[null,"East Bay MUD",null,890526.85714285669]
[null,"Sacramento County WA  - FSC",null,52745]
[null,"Sacramento MUD",null,638341]
[null,null,"Total Folsom-South Canal",1581612.8571428568]
[]
[]
[]
[null,"County of Madera",null,3762.142857142856]
[null,"Fresno County WW #18",null,5852.142857142856]
[null,null,"Total Friant Dam",9614.2857142857119]
[]
[]
[]
[null,"Arvin-Edison WSD",null,29103.857142857152]
[null,"City of Fresno",null,2293460.7142857146]
[null,"City of Lindsay",null,83998]
[null,"City of Orange Cove",null,54205.714285714304]
[null,"Delano-Earlimart ID ",null,7437.4285714285679]
[null,"Lindsay-Strathmore ID",null,16356.142857142864]
[null,"Shafter-Wasco ID",null,12503.714285714288]
[null,"Terra Bella ID",null,42057.285714285703]
[null,null,"Total Friant-Kern Canal",2539122.8571428573]
[]
[]
[]
[null,"Stockton-East WD",null,710589.28571428556]
[]
[]
[]
[null,"City of Redding - SR   ",null,160892]
[null,"City of W. Sacramento",null,265659.7142857142]
[null,"Lake California P.O.A.",null,9212.4285714285725]
[null,"Riverview Golf & CC",null,1243.142857142858]
[null,null,"Total Sacramento River",437007.28571428562]
[]
[]
[]
[null,"San Benito County WD",null,175965.28571428583]
[null,"Santa Clara Valley WD",null,3701244]
[null,null,"Total San Felipe Unit",3877209.2857142859]
[]
[]
[]
[null,"City of Avenal",null,108133.14285714291]
[null,"City of Coalinga",null,276102.57142857148]
[null,"City of Huron",null,50083.857142857152]
[null,"State of CA",null,269.71428571428555]
[null,"Westlands WD",null,199434]
[null,null,"Total SLC - Fresno",634023.2857142858]
[]
[]
[]
[null,"Pacheco WD",null,565]
[null,"Panoche WD",null,3398.142857142856]
[null,"San Luis WD  2/",null,35170.428571428558]
[null,null,"Total SLC - Tracy",39133.571428571413]
[]
[]
[]
[null,"Centerville CSD",null,33309.319707942137]
[null,"Mountain Gate CSD",null,29673.571428571431]
[null,"Shasta CWA",null,7545.2002920578516]
[null,null,"Total Shasta D&R",70528.091428571424]
[]
[]
[]
[null,"City of Redding - SCC ",null,164439.57142857139]
[null,"Shasta CWA - SCC",null,5885.2857142857119]
[null,"Shasta CSD",null,24539]
[null,null,"Total Spring Creek Conduit",194863.8571428571]
[]
[]
[]
[null,"Colusa County WD",null,5072.5714285714312]
[null,"Kanawha WD",null,488.7142857142855]
[null,null,"Total Tehama-Colusa Canal",5561.2857142857165]
[]
[]
[]
[null,"City of Redding - TP",null,5253.857142857144]
[null,"City of Shasta Lake ",null,95326.714285714304]
[null,"US Forest Service ",null,294]
[null,null,"Total Toyon Pipeline",100874.57142857145]
[]
[null,null,"CVP Sub-Total (A/F)",17731349.52]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,12722029.91,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,222557931.15000001,null,null,null,null,null,null,893712]
[]
[]
[null,null,null,null,null,null,null,null,null,423787724.34999996,0,"",null,0,null,"",16149711.240740247]

{"sheet":"OUTPUT","index":2,"n_rows":49,"n_cols":11,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"INFORMATION!A1","v":"2023 Cost of Service Additional Service Water Rates Sch TR-1.Z25.xlsm"}]
[{"$f":"+INFORMATION!A2","v":"01/03/2023"}]
[{"$f":"INFORMATION!A3","v":"CENTRAL VALLEY PROJECT"}]
[{"$f":"INFORMATION!A4","v":"SCHEDULE OF WATER RATES FOR ADDITIONAL CVP SERVICES WHEN TRANSFERRING"}]
[{"$f":"INFORMATION!A5","v":"CVP WATER TO CVP M&I WATER CONTRACTORS"}]
[{"$f":"INFORMATION!A6","v":"2023 SPECIAL WATER RATES"}]
["Category","A) Component / Facility","Related Footnotes","B) Net\nConstruction\nCosts\nat 9/30/2021\n<M&I Sch A-4>","C) Construction with Int. Annualized Costs @ 0.023755\n","D) 7 Year Average Water\nDeliveries\n<M&I Sch A-7 divided by 50>","7 Year Average Water\nDeliveries Footnotes","E) Construction\nCost\nper Acre-Foot\n(C/D)",null,null,{"$f":"MACRO_INPUT!D15","v":2.3754608109186889E-2}]
["Storage","San Felipe Unit","-",{"$f":"MACRO_INPUT!J21-MACRO_INPUT!Q20","v":9294513.7800000012},{"$f":"(-PMT($K$8,50,D9,0,0))","v":319600.50890535495},{"$f":"MACRO_INPUT!D120/50","v":77544.185714285719},"-",{"$f":"ROUND(+E9/F9,2)","v":4.12}]
["Storage","All Other Contractors","-",{"$f":"MACRO_INPUT!J22-MACRO_INPUT!Q21","v":40074915.219800547},{"$f":"(-PMT($K$8,50,D10,0,0))","v":1378013.2669389844},{"$f":"(MACRO_INPUT!D21-MACRO_INPUT!D120)/50","v":277082.80468571431},"-",{"$f":"ROUND(+E10/F10,2)","v":4.97}]
["Total","Storage","-",{"$f":"SUM(D9:D10)","v":49369428.999800548},{"$f":"SUM(E9:E10)","v":1697613.7758443393},"-","-","-"]
["Conveyance","Contra Costa Canal System","1/",0,{"$f":"(-PMT($K$8,50,D12,0,0))","v":0},"-","-",0]
["Conveyance","All Other Contractors","-",{"$f":"MACRO_INPUT!J27-MACRO_INPUT!Q26","v":26311190.289999995},{"$f":"(-PMT($K$8,50,D13,0,0))","v":904734.77210656542},{"$f":"MACRO_INPUT!D24/50","v":188958.08857142855},"-",{"$f":"ROUND(+E13/F13,2)","v":4.79}]
["Total","Conveyance","-",{"$f":"SUM(D12:D13)","v":26311190.289999995},{"$f":"SUM(E12:E13)","v":904734.77210656542},"-","-","-"]
["Conveyance Pumping","Dos Amigos Pumping Plant, Construction only","-",{"$f":"MACRO_INPUT!J31-MACRO_INPUT!Q32-D16","v":275520.93999999994},{"$f":"(-PMT($K$8,50,D15,0,0))","v":9474.0440137452497},{"$f":"(MACRO_INPUT!D27-MACRO_INPUT!D57)/50","v":12789.682455018819},"  3/",{"$f":"ROUND(+E15/F15,2)","v":0.74}]
["Conveyance Pumping","Dos Amigos Pumping Plant, PUE only","-",{"$f":"MACRO_INPUT!K31+MACRO_INPUT!L31","v":541234.93395645195},18610.86705816237,{"$f":"MACRO_INPUT!D27/50","v":12957.30245501882},"-",1.44]
["Conveyance Pumping","O'Neill P-Generator/Pumping Plant, Construction only","-",{"$f":"MACRO_INPUT!J32-MACRO_INPUT!Q34-D18","v":1611080.7749999999},55398.512258446885,{"$f":"MACRO_INPUT!D29/50","v":91007.322857142848},"-",0.61]
["Conveyance Pumping","O'Neill P-Generator/Pumping Plant, PUE only","-",{"$f":"MACRO_INPUT!K32+MACRO_INPUT!L32","v":1687076.2867264058},58011.68867597459,{"$f":"F17","v":91007.322857142848},"-",0.64]
["Conveyance Pumping","Jones Pumping Plant, Friant Kern/Madera, Construction only","2/",{"$f":"Footnote!D16","v":1468825.9796224346},50506.948689545818,{"$f":"(MACRO_INPUT!D90+MACRO_INPUT!D102)/50","v":50974.742857142861},"4/",0.99]
["Conveyance Pumping","Jones Pumping Plant, Friant Kern/Madera, PUE only","2/",{"$f":"Footnote!G16","v":3592231.3973474586},123522.22072858576,{"$f":"F19","v":50974.742857142861},{"$f":"+G19","v":"4/"},2.42]
["Conveyance Pumping","Jones Pumping Plant, All Other Contractors, Construction only","2/",{"$f":"Footnote!D17-MACRO_INPUT!Q37","v":2897901.0403775666},99647.025028352553,{"$f":"MACRO_INPUT!D31/50","v":99128.88},"1/",1.01]
["Conveyance Pumping","Jones Pumping Plant, All Other Contractors, PUE only","2/",{"$f":"Footnote!G17","v":7131333.9304641113},245217.55600112252,{"$f":"F21","v":99128.88},{"$f":"+G21","v":"1/"},2.4700000000000002]
["Total","Conveyance Pumping","-",{"$f":"SUM(D15:D22)","v":19205205.283494428},{"$f":"SUM(E15:E22)","v":660388.86245393578},"-","-","-"]
["Direct Pumping","Bella Vista WD (Wintu PP)","-",{"$f":"MACRO_INPUT!J39-MACRO_INPUT!Q43","v":841672.57750450796},{"$f":"(-PMT($K$8,50,D24,0,0))","v":28941.695119217144},{"$f":"MACRO_INPUT!D51/50","v":3526.7114285714279},"-",{"$f":"ROUND(+E24/F24,2)","v":8.2100000000000009}]
["Direct Pumping","Colusa County WD Relift PP","-",{"$f":"MACRO_INPUT!J40-MACRO_INPUT!Q44","v":36408.492566129527},1251.9399107945405,{"$f":"MACRO_INPUT!D154/50","v":101.45142857142862},"-",12.34]
["Direct Pumping","Contra Costa PP (Contra Costa WD)","-",{"$f":"MACRO_INPUT!J41-MACRO_INPUT!Q45","v":4974012.6289530396},171036.05472464571,{"$f":"MACRO_INPUT!D47/50","v":101489.56857142862},"-",1.69]
["Direct Pumping","Kanawha WD","-",{"$f":"MACRO_INPUT!J42-MACRO_INPUT!Q46","v":1558.7797758448521},53.600093713712234,{"$f":"MACRO_INPUT!D155/50","v":9.7742857142857105},"-",5.48]
["Direct Pumping","Pleasant Valley PP (City of Coalinga)","-",{"$f":"MACRO_INPUT!J44-MACRO_INPUT!Q47","v":202557.95000193163},6965.1436789244053,{"$f":"MACRO_INPUT!D125/50","v":5522.0514285714298},"-",1.26]
["Direct Pumping","Pleasant Valley WD Canalside Relift PP","-",{"$f":"MACRO_INPUT!J43-MACRO_INPUT!Q48","v":49429.8144824056},1699.6901868786204,{"$f":"F28","v":5522.0514285714298},"-",0.31]
["Direct Pumping","San Benito County WD, Gianelli, WR PGP","-",{"$f":"MACRO_INPUT!J47-MACRO_INPUT!Q51","v":363795.95464216103},12509.462570439493,"-","-","-"]
["Direct Pumping","San Benito County WD, Pacheco PP","-",{"$f":"MACRO_INPUT!J46-MACRO_INPUT!Q50","v":224076.68224069598},7705.0853194764895,"-","-","-"]
["Total","San Benito County WD","-",{"$f":"+D30+D31","v":587872.63688285695},{"$f":"+E30+E31","v":20214.547889915983},{"$f":"MACRO_INPUT!D118/50","v":3519.3057142857165},"-",{"$f":"ROUND(+E32/F32,2)","v":5.74}]
["Direct Pumping","San Luis WD Canalside Relift PP","-",{"$f":"MACRO_INPUT!J48-MACRO_INPUT!Q54","v":73891.369871414092},{"$f":"(-PMT($K$8,50,D33,0,0))","v":2540.8235410263442},{"$f":"MACRO_INPUT!D135/50","v":703.40857142857112},"-",{"$f":"ROUND(+E33/F33,2)","v":3.61}]
["Direct Pumping","Santa Clara Valley WD, Coyote PP","-",{"$f":"MACRO_INPUT!J50-MACRO_INPUT!Q56","v":1356563.24660623},46646.690105574467,"-","-","-"]
["Direct Pumping","Santa Clara Valley WD, Gianelli, WR PGP","-",{"$f":"MACRO_INPUT!J52-MACRO_INPUT!Q58","v":7865554.3415565705},270464.40834737278,"-","-","-"]
["Direct Pumping","Santa Clara Valley WD, Pacheco PP","-",{"$f":"MACRO_INPUT!J51-MACRO_INPUT!Q57","v":4713216.4381806897},162068.33492086476,"-","-","-"]
["Total","Santa Clara WD","-",{"$f":"+D34+D35+D36","v":13935334.026343491},{"$f":"SUM(E34:E36)","v":479179.433373812},{"$f":"MACRO_INPUT!D119/50","v":74024.88},"-",{"$f":"ROUND(+E37/F37,2)","v":6.47}]
["Direct Pumping","Shasta Pumping Plant (City of Shasta Lake)","-",{"$f":"MACRO_INPUT!J53-MACRO_INPUT!Q62","v":569188.08611399995},{"$f":"(-PMT($K$8,50,D38,0,0))","v":19572.06221764291},{"$f":"MACRO_INPUT!D161/50","v":1906.5342857142862},"-",{"$f":"ROUND(+E38/F38,2)","v":10.27}]
["Direct Pumping","State Delta PP (Cross Valley Canal)  ","-",{"$f":"MACRO_INPUT!J54-MACRO_INPUT!Q63","v":15079.579995012889},518.52539622412917,{"$f":"MACRO_INPUT!D57/50","v":167.62},"-",{"$f":"ROUND(+E39/F39,2)","v":3.09}]
["Direct Pumping","Westlands WD Relifts","-",{"$f":"MACRO_INPUT!J55-MACRO_INPUT!Q64","v":783611.28421443037},26945.203498198549,{"$f":"MACRO_INPUT!D128/50","v":3988.68},"-",{"$f":"ROUND(+E40/F40,2)","v":6.76}]
["Total","Direct Pumping","-",{"$f":"SUM(D24:D29)+D32+D37+SUM(D38:D40)+D33","v":22070617.226705067},{"$f":"SUM(E24:E29)+E32+E37+SUM(E38:E40)+E33","v":758918.71963099402},"-","-","-"]
["Subtotal","-","-",{"$f":"+D11+D14+D23+D41","v":116956441.80000004},{"$f":"+E11+E14+E23+E41","v":4021656.1300358344},"-","-","-"]
["Other Costs","Deferred Interest Capitalized ","-",{"$f":"MACRO_INPUT!R72","v":21277763},{"$f":"(-PMT($K$8,50,D43,0,0))","v":731655.68895068462},"-","-","-"]
["Other Costs","Programmatic EIS Capitalized  ","-",{"$f":"MACRO_INPUT!R73","v":1591067.9586188002},54710.352936565629,"-","-","-"]
["Other Costs","All others","-",{"$f":"MACRO_INPUT!R74","v":7378781.3949999996},253726.26742647795,"-","-","-"]
["Total","Other Costs","-",{"$f":"SUM(D43:D45)","v":30247612.353618801},{"$f":"SUM(E43:E45)","v":1040092.3093137282},{"$f":"MACRO_INPUT!D165/50","v":354626.99040000001},"-",{"$f":"ROUND(+E46/F46,2)","v":2.93}]
["Grand Total","-","-",{"$f":"+D42+D46","v":147204054.15361884},{"$f":"+E42+E46","v":5061748.4393495629},"-","-","-"]
[]
[null,null,null,"Variance",{"$f":"(-PMT(K8,50,D47,0,0))-E47","v":0}]

{"sheet":"Footnote","index":3,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[{"$f":"INFORMATION!A1","v":"2023 Cost of Service Additional Service Water Rates Sch TR-1.Z25.xlsm"}]
[{"$f":"INFORMATION!A2","v":"01/03/2023"}]
[{"$f":"INFORMATION!A3","v":"CENTRAL VALLEY PROJECT"}]
[{"$f":"INFORMATION!A4","v":"SCHEDULE OF WATER RATES FOR ADDITIONAL CVP SERVICES WHEN TRANSFERRING"}]
[{"$f":"INFORMATION!A5","v":"CVP WATER TO CVP M&I WATER CONTRACTORS"}]
[{"$f":"INFORMATION!A6","v":"2023 SPECIAL WATER RATES"}]
[]
["Footnotes:"]
["1/"]
["Total Conveyance Pumping for Jones Pumping Plant less Delta Mendota Exchange"]
[]
["2/"]
["Suballocation of Jones Pumping Plant costs:"]
[]
["Facility/Contractor Ref","Historical &\nProjected\nDeliveries\n(1981-2030)\n(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!D32-MACRO_INPUT!D31","v":2496684.902082284},{"$f":"ROUND(B16/B18,9)","v":0.334984801},{"$f":"+SuballocationOfJonesPumpingPlantCosts[[#This Row],[Ratio]]*JonesPumpingPlantConveyancePumping[Construction Allocation]","v":1468825.9796224346},{"$f":"+SuballocationOfJonesPumpingPlantCosts[[#This Row],[Ratio]]*JonesPumpingPlantConveyancePumping[Less:  BOR PUE (M&I Sch A-5)]","v":1821434.8328963066},{"$f":"+SuballocationOfJonesPumpingPlantCosts[[#This Row],[Ratio]]*JonesPumpingPlantConveyancePumping[Less:  DOE PUE (M&I Sch A-5)]","v":1770796.5644511518},{"$f":"+E16+F16","v":3592231.3973474586}]
["Jones Pumping Plant: All Other Contractors",{"$f":"+MACRO_INPUT!D31","v":4956444},{"$f":"ROUND(B17/B18,9)","v":0.66501519899999995},{"$f":"+SuballocationOfJonesPumpingPlantCosts[[#This Row],[Ratio]]*JonesPumpingPlantConveyancePumping[Construction Allocation]","v":2915928.1203775667},{"$f":"+SuballocationOfJonesPumpingPlantCosts[[#This Row],[Ratio]]*JonesPumpingPlantConveyancePumping[Less:  BOR PUE (M&I Sch A-5)]","v":3615930.7653605128},{"$f":"+SuballocationOfJonesPumpingPlantCosts[[#This Row],[Ratio]]*JonesPumpingPlantConveyancePumping[Less:  DOE PUE (M&I Sch A-5)]","v":3515403.165103598},{"$f":"+E17+F17","v":7131333.9304641113}]
["Total  a/",{"$f":"SUM(B16:B17)","v":7453128.902082284},1,4384754.1000000015,5437365.598256819,5286199.72955475,10723565.327811569]
[]
["a/ Jones Pumping Plant - Conveyance Pumping:",null,null,null,null,""]
[]
["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!J33","v":15108319.42781157},{"$f":"+MACRO_INPUT!K33","v":5437365.5982568199},{"$f":"+MACRO_INPUT!L33","v":5286199.72955475},{"$f":"A23-B23-C23","v":4384754.1000000015}]
[]
["3/"]
["Cross Valley Canal contractors are charged for PUE construction component only.  Therefore their deliveries are not included in determining the \"Construction only\" rate."]
[]
["4/"]
["Includes Friant Dam and Friant-Kern Canal"]