{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["OUTPUT","Footnote"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":28,"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":"OUTPUT","index":0,"n_rows":50,"n_cols":8,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["Bureau of Reclamation logo"]
["2024 Cost of Service Additional Service Water Rates Sch TR-1.Z26.xlsm"]
["01/09/2024"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF WATER RATES FOR ADDITIONAL CVP SERVICES WHEN TRANSFERRING"]
["CVP WATER TO CVP M&I WATER CONTRACTORS"]
["2024 SPECIAL WATER RATES"]
[]
["Category","A) Component / Facility\n<Ref>","Related Footnotes","B) Net\nConstruction\nCosts\nat 9/30/2022\n<M&I Sch A-4>","C) Construction with Int. Annualized Costs @ 0.023596\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)"]
["Storage","San Felipe Unit","-",9431853.7400000002,323281.45389967482,77690.254285714313,"-",4.16]
["Storage","All Other Contractors","-",40487396.777021267,1387725.5580394997,276271.87706666661,"-",5.0199999999999996]
["Folsom SOD","San Felipe Unit","5/",868475.55,29767.429205313325,77690.254285714313,"-",0.38]
["Folsom SOD","All Other Contractors","5/",2373592.84,81356.069064855765,276271.87706666661,"-",0.28999999999999998]
["Total","Storage","-",53161318.907021269,1822130.5102093436,"-","-",0]
["Conveyance","Contra Costa Canal System","1/",0,0,"-","-",0]
["Conveyance","All Other Contractors","-",26667619.59999999,914045.85715421208,190107.83714285714,"-",4.8099999999999996]
["Total","Conveyance","-",26667619.59999999,914045.85715421208,"-","-",0]
["Conveyance Pumping","Dos Amigos Pumping Plant, Construction only","-",282406.18499999982,9679.6117278490019,12800.800595022507,"  3/",0.76]
["Conveyance Pumping","Dos Amigos Pumping Plant, PUE only","-",610621.29445152404,20929.347007918095,12979.540595022507,"-",1.61]
["Conveyance Pumping","O'Neill P-Generator/Pumping Plant, Construction only","-",1641110.5249999999,56249.875279772794,91182.371428571452,"-",0.62]
["Conveyance Pumping","O'Neill P-Generator/Pumping Plant, PUE only","-",1903753.2862080932,65252.085878044585,91182.371428571452,"-",0.72]
["Conveyance Pumping","Jones Pumping Plant, Friant Kern/Madera, Construction only","2/",1508062.1722162066,51689.577154655606,51253.162857142845,"4/",1.01]
["Conveyance Pumping","Jones Pumping Plant, Friant Kern/Madera, PUE only","2/",2696842.6909966739,92435.617654532907,51253.162857142845,"4/",1.8]
["Conveyance Pumping","Jones Pumping Plant, All Other Contractors, Construction only","2/",2988138.8427837943,102419.93739284137,99236.197142857171,"1/",1.03]
["Conveyance Pumping","Jones Pumping Plant, All Other Contractors, PUE only","2/",5325612.2913145963,182537.99644290932,99236.197142857171,"1/",1.84]
["Total","Conveyance Pumping","-",16956547.287970886,581194.04853852373,"-","-",0]
["Direct Pumping","Bella Vista WD (Wintu PP)","-",885051.07537456101,30335.563539236853,3462.8114285714273,"-",8.76]
["Direct Pumping","Colusa County WD Relift PP","-",38370.190829280757,1315.1572765692454,98.66,"-",13.33]
["Direct Pumping","Contra Costa PP (Contra Costa WD)","-",5579969.2961099595,191256.20864027232,101089.24,"-",1.89]
["Direct Pumping","Kanawha WD","-",1959.9055208682541,67.176731505623266,9.4685714285714315,"-",7.09]
["Direct Pumping","Pleasant Valley PP (City of Coalinga)","-",211114.20948866755,7236.0439913243363,5482.6114285714275,"-",1.32]
["Direct Pumping","Pleasant Valley WD Canalside Relift PP","-",53245.441992766602,1825.0138705980808,5482.6114285714275,"-",0.33]
["Direct Pumping","San Benito County WD, Gianelli, WR PGP","-",402618.13871040707,13799.93592316682,"-","-",0]
["Direct Pumping","San Benito County WD, Pacheco PP","-",249835.34593094399,8563.2301024298722,"-","-",0]
["Total","San Benito County WD","-",652453.48464135104,22363.166025596693,3483.9571428571408,"-",6.42]
["Direct Pumping","San Luis WD Canalside Relift PP","-",86055.487861171889,2949.5944274264648,718.10571428571461,"-",4.1100000000000003]
["Direct Pumping","Santa Clara Valley WD, Coyote PP","-",1531596.6072296952,52496.231559780841,"-","-",0]
["Direct Pumping","Santa Clara Valley WD, Gianelli, WR PGP","-",8793195.26482426,301391.11864939955,"-","-",0]
["Direct Pumping","Santa Clara Valley WD, Pacheco PP","-",5321350.1028961595,182391.90782590045,"-","-",0]
["Total","Santa Clara WD","-",15646141.974950114,536279.25803508086,74206.297142857162,"-",7.23]
["Direct Pumping","Shasta Pumping Plant (City of Shasta Lake)","-",599837.29753402702,20559.720177557807,1883.94,"-",10.91]
["Direct Pumping","State Delta PP (Cross Valley Canal)  ","-",18110.338307963761,620.74080665435554,178.74,"-",3.47]
["Direct Pumping","Westlands WD Relifts","-",811492.06739718176,27814.292143191542,4026.3285714285726,"-",6.91]
["Total","Direct Pumping","-",24583800.770007912,842621.9356650142,"-","-",0]
["Subtotal","-","-",121369286.56500006,4159992.3515670937,"-","-",0]
["Other Costs","Deferred Interest Capitalized ","-",21277763,729305.85524248239,"-","-",0]
["Other Costs","Programmatic EIS Capitalized  ","-",1608832.8485963999,55143.541949771527,"-","-",0]
["Other Costs","All others","-",7641684.1350000007,261922.5048972058,"-","-",0]
["Total","Other Costs","-",30528279.983596403,1046371.9020894598,353962.13135238097,"-",2.96]
["Grand Total","-","-",151897566.54859647,5206364.2536565531,"-","-",0]

{"sheet":"Footnote","index":1,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["2024 Cost of Service Additional Service Water Rates Sch TR-1.Z26.xlsm"]
["01/09/2024"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF WATER RATES FOR ADDITIONAL CVP SERVICES WHEN TRANSFERRING"]
["CVP WATER TO CVP M&I WATER CONTRACTORS"]
["2024 SPECIAL WATER RATES"]
[]
["Footnotes:"]
["1/"]
["Refer to M&I Water Rates, Schedule A-4."]
["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",2504139.9169388572,0.33540808500000002,1508062.1722162066,1358744.7986512729,1338097.892345401,2696842.6909966739]
["Jones Pumping Plant: All Other Contractors",4961809.8571428582,0.66459191500000003,2988138.8427837943,2692275.0169601273,2651364.3543544691,5343639.3713145964]
["Total  a/",7465949.7740817154,1,4496201.0150000006,4051019.8156114002,3989462.2466998701,8040482.0623112703]
[]
["a/",null,null,null,null,""]
["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"]
[12536683.07731127,4051019.8156114002,3989462.2466998701,4496201.0150000006]
[]
["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."]
[]
["5/"]
["Folsom SOD Historical & Projected Deliveries are based on a new 50-year repayment period beginning in 2024."]