{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["OUTPUT","Footnotes"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":27,"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":72,"n_cols":10,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
[]
["Special Rates 2025 Sch S-1.Z27.XLSM"]
["01/20/2025"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF IRRIGATION UNPAID CONSTRUCTION COSTS BY COMPONENT AND/OR FACILITY"]
["AS OF SEPTEMBER 30, 2023"]
["2025 SPECIAL WATER RATES"]
[]
["Category","A) Component/Facility","Related Footnotes","B) Net Construction at 9/30/2023\n\n<Sch A-4>                               <Sch A-2Bc FSOD>","C) Ratio of Total\n<B/$1,147,146,469.68>\n                                                                            Folsom SOD <B/$30,443,579.30>","D) Cumulative Construction Repayment at 9/30/2023   1/\n<C*$1,053,738,184.28>\n                                                                            Folsom SOD <C/$0.00>","E) Net Unpaid Construction at 9/30/2023\n<B-D>","F) Unpaid Construction Annualized Costs Remaining Years\n(E/6)\nFolsom SOD                         (E/49)","G) Unpaid Construction FY 2025 Projected Deliveries\n <Sch S-5>","H) Unpaid Construction Cost Per Acre Foot\n<F/G>"]
["Storage","San Felipe Unit Contractors","-",2679378.5662158797,2.3918945097341892E-3,2520430.57766676,158947.98854911979,26491.331424853299,20646.714285714286,1.28]
["Storage","All Other Contractors","-",334752010.67758262,0.29883477704795458,314893615.36500001,19858395.312582612,3309732.5520971022,1593567.8699999999,2.08]
["Folsom SOD","San Felipe Unit Contractors","8/",389403.81999999995,1.2790999907162696E-2,0,389403.81999999995,7947.0167346938761,20646.714285714286,0.38]
["Folsom SOD","All Other Contractors","8/",30054175.479999982,0.9872090000928373,0,30054175.479999982,613350.51999999967,1593567.8699999999,0.38]
["Total","Total Storage","-",367874968.54379845,1.3012266715576888,317414045.94266677,50460922.601131715,3957521.4202566487,"-","-"]
["Conveyance","Contra Costa WD","-",0,"-",0,"-","-","-","-"]
["Conveyance","All Other Contractors","-",375477662.20000005,0.33519076776538181,353203311.01113302,22274351.188867033,3712391.8648111722,1572292.3257142857,2.36]
["Total","Total Conveyance","-",375477662.20000005,0.33519076776538181,353203311.01113302,22274351.188867033,3712391.8648111722,"-","-"]
["Conveyance Pumping","Corning Pumping Plant, Construction only","-",2512796.5,2.2431858745954559E-3,2363730.61048953,149065.88951046998,24844.314918411663,5048.1428571428569,4.92]
["Conveyance Pumping","Corning Pumping Plant, PUE only","-",278677.872619876,2.4877711642117364E-4,262145.946947038,16531.925672837999,2755.3209454729999,5048.1428571428569,0.55000000000000004]
["Total","Corning Pumping Plant","-","-","-","-","-","-","-",5.47]
["Conveyance Pumping","Dos Amigos Pumping Plant, Construction only","-",13475122.533151448,1.2029308590969569E-2,12675741.792742601,799380.74040884711,133230.12340147453,532529.58021781978,0.25]
["Conveyance Pumping","Dos Amigos Pumping Plant, PUE only","-",23109223.594543058,2.0629718299968586E-2,21738321.903531902,1370901.6910111569,228483.61516852616,545990.15164639126,0.42]
["Total","Dos Amigos Pumping Plant","-","-","-","-","-","-","-",0.66999999999999993]
["Conveyance Pumping","O'Neill Pump-Generator Plant, Construction only","-",10222494.180000003,9.1256711586912304E-3,9616068.1570580993,606426.02294190414,101071.0038236507,555197.71428571432,0.18]
["Conveyance Pumping","O'Neill Pump-Generator Plant, PUE only","-",10218794.93318202,9.1223688227445084E-3,9612588.3595737405,606206.57360827923,101034.4289347132,555197.71428571432,0.18]
["Total","O'Neill Pump-Generator Plant","-","-","-","-","-","-","-",0.36]
["Conveyance Pumping","Jones Pumping Plant, Delta Mendota Exchange, Construction only","3/",11542386.443163939,1.0303945515853527E-2,10857660.8387531,684725.60441083834,114120.93406847306,534041.01285714272,0.21]
["Conveyance Pumping","Jones Pumping Plant, Delta Mendota Exchange, PUE only","3/",28497639.540431086,2.5439983889028798E-2,26807082.431233,1690557.109198086,281759.51819968101,534041.01285714272,0.53]
["Total","Jones Pumping Plant","-","-","-","-","-","-","-",0.74]
["Conveyance Pumping","All Other Contractors, Construction only","3/",20081626.306836072,1.7926967213779225E-2,18890329.881421,1191296.4254150726,198549.40423584543,662711,0.3]
["Conveyance Pumping","All Other Contractors, PUE only","3/",50283382.835848816,4.4888224774370572E-2,47300436.469113,2982946.366735816,497157.72778930265,662711,0.75]
["Total","All Other Contractors","-","-","-","-","-","-","-",1.05]
["Total","Total Conveyance Pumping","-",170222144.73977631,0.15195815125642265,160124106.390863,10098038.348913308,1683006.3914855514,"-","-"]
["Direct Pumping","Bella Vista WD (Wintu PP)","-",1235515.9534627351,1.1029512078057034E-3,1162221.8030580799,73294.150404655142,12215.69173410919,2362,5.17]
["Direct Pumping","Colusa County WD Relift PP","-",11935496.304740062,1.0654876635286291E-2,11227450.3593501,708045.94538996182,118007.65756499364,22405.857142857141,5.27]
["Direct Pumping","Colusa Service Area - Cortina","-",139400.85999999999,1.2444383779524473E-4,131131.22368268401,8269.6363173159771,1378.2727195526629,664.57142857142856,2.0699999999999998]
["Direct Pumping","Colusa Service Area - Davis","-",171721.21,1.5329637423501662E-4,161534.24304248299,10186.966957516997,1697.8278262528329,2205,0.77]
["Direct Pumping","Corning WD Relift PP","-",3208652.32321893,2.8643798126639372E-3,3018306.3828730001,190345.94034592994,31724.323390988324,4810.4285714285716,6.59]
["Direct Pumping","Dunnigan WD Relift PP","-",1637611.1927426537,1.4619036183947795E-3,1540463.66443366,97147.528308993671,16191.254718165612,6015.8571428571431,2.69]
["Direct Pumping","Kanawha WD Relift PP","-",2809637.895832526,2.5081776581030823E-3,2642962.57129088,166675.32454164606,27779.220756941009,17809.142857142859,1.56]
["Direct Pumping","Orland-Artois WD Relift PP","-",7322609.612389897,6.5369298499460358E-3,6888212.59082097,434397.02156892698,72399.503594821159,17254.142857142859,4.2]
["Direct Pumping","Panoche WD Relift PP","-",19391.817404946229,1.7311171392315173E-5,18241.4423106268,1150.3750943194282,191.72918238657135,20452.428571428572,0.01]
["Direct Pumping","Proberta WD Relift PP","-",192815.31541997672,1.7212718656515129E-4,181376.989035679,11438.326384297718,1906.3877307162863,171,11.15]
["Direct Pumping","San Benito County WD, Gianelli, WR PGP","-",876627.48251719307,7.825696931943126E-4,824623.56757591094,52003.914941282128,8667.3191568803541,"-","-"]
["Direct Pumping","San Benito County WD, Pacheco PP","-",513760.67953772401,4.5863670188237894E-4,483283.00548381801,30477.674053905997,5079.6123423176659,"-","-"]
["Total","Total San Benito County WD","-",1390388.1620549171,1.2412063950766915E-3,1307906.57305973,82481.588995188125,13746.931499198021,8434,1.63]
["Direct Pumping","San Luis WD Canalside Relift PP","-",11038043.785443,9.8537163286688337E-3,10383237.152541099,654806.63290190138,109134.43881698356,30102.142857142859,3.63]
["Direct Pumping","Santa Nella County WD","-",14535.563109715,1.2975969143145291E-5,13673.2741641178,862.28894559719993,143.7148242662,456.42857142857144,0.31]
["Direct Pumping","Santa Clara Valley WD, Coyote PP","-",151166.03287731641,1.3494666586372133E-4,142198.454661322,8967.5782159944065,1494.5963693324011,"-","-"]
["Direct Pumping","Santa Clara Valley WD, Gianelli, WR PGP","-",808008.17306454992,7.2131289596116474E-4,760074.94128489797,47933.231779651949,7988.8719632753246,"-","-"]
["Direct Pumping","Santa Clara Valley WD, Pacheco PP","-",525208.26440997794,4.6885601756658683E-4,494051.488637437,31156.775772540946,5192.7959620901574,"-","-"]
["Total","Total Santa Clara Valley WD","-",1484382.4703518443,1.3251155793914729E-3,1396324.8845836571,88057.585768187302,14676.264294697881,12212.714285714286,1.2]
["Direct Pumping","State Delta PP (CVC Contractors)","-",2824036.8664842597,2.5210316904828167E-3,2656507.3560313298,167529.51045292988,27921.585075488314,13460.571428571428,2.0699999999999998]
["Direct Pumping","Westlands WD, Pleasant Valley Canalside Relifts","-",1418332.8239096957,1.2661527330483442E-3,1334193.48193831,84139.341971385758,14023.223661897626,"-","-"]
["Direct Pumping","Westlands WD, Pleasant Valley PP","-",11167549.063454308,9.9693263314368733E-3,10505059.826942099,662489.23651220836,110414.87275203473,"-","-"]
["Direct Pumping","Westlands WD, Westlands WD Canalside Relifts","-",52796546.131048538,4.713173808885656E-2,49664512.115518302,3132034.0155302361,522005.66925503936,"-","-"]
["Total","Total Westlands WD","-",65382428.018412545,5.8367217153341776E-2,61503765.424398713,3878662.5940138302,646443.7656689717,479611,1.35]
["Direct Pumping","Westside WD Canalside Relifts","-",6950864.6653571287,6.2050712954884258E-3,6538520.56021039,412344.1051467387,68724.017524456445,24649,2.79]
["Direct Pumping","Other Costs",null,0,"-",0,0,0,"-","-"]
["Total","Total Direct Pumping","-",117757532.01642512,0.10512273176378072,110771836.49488719,6985695.5215379372,1164282.5869229895,"-","-"]
["San Luis Drain","Panoche WD","6/",2551667.2006370798,2.2778859414750168E-3,2400295.3959574499,151371.80467962986,25228.634113271644,20452.428571428572,"-"]
["San Luis Drain","San Luis WD","6/",3555749.0024940702,3.1742347364784938E-3,3344812.3476822898,210936.65481178043,35156.109135296741,30102.142857142859,"-"]
["San Luis Drain","Santa Nella County WD",null,4257.2582507460002,3.8004755150599692E-6,4004.70616862425,252.55208212175012,42.092013686958353,456.42857142857144,"-"]
["San Luis Drain","Westlands WD","6/",46269878.510999702,4.1305349595608859E-2,43525024.083757497,2744854.4272422045,457475.73787370074,479611,"-"]
["Total","Total San Luis Drain","6/",52381551.972381599,4.6761270749077433E-2,49274136.533565864,3107415.4388157367,517902.57313595607,530622,0.98]
["Subtotal","Subtotal","-",1083713859.4723816,1.9402595930923512,990787436.37311578,92926423.099265724,11035104.836612318,"-","-"]
["Other Costs","Programmatic EIS Capitalized","-",13854948.724092599,1.236838131186861E-2,13033035.6660002,821913.05809239857,136985.50968206642,"-","-"]
["Other Costs","All Others ","-",53065714.020000003,4.7372025595779861E-2,49917712.236767799,3148001.7832322046,524666.9638720341,"-","-"]
["Total","Total Other Costs","-",66920662.744092599,5.9740406907648473E-2,62950747.902768001,3969914.8413246032,661652.47355410049,1882575.6114285714,0.35]
["Subtotal","Subtotal","-",1150634522.2164743,1.9999999999999996,1053738184.2758838,96896337.940590322,11696757.310166419,"-","-"]
["Other Costs","DMC California Aqueduct Intertie","7/",26955526.760000002,"-",30526383.863271944,-3570857.1032719421,-91560.438545434416,662711,0]
["Total","Total","-",1177590048.9764743,"-","-","-","-","-","-"]

{"sheet":"Footnotes","index":1,"n_rows":56,"n_cols":19,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
["Bureau of Reclamation logo"]
["Special Rates 2025 Sch S-1.Z27.XLSM"]
["01/20/2025"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF IRRIGATION UNPAID CONSTRUCTION COSTS BY COMPONENT AND/OR FACILITY"]
["AS OF SEPTEMBER 30, 2023"]
["2025 SPECIAL WATER RATES"]
[]
["Footnotes:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["1/",null,null,null,null,null,null,null,null,null,null,null,null,null,"ok"]
["Refer to Irrigation Water Rates, Schedule A-2Ba.  Total Allocation of Construction is being increased by the Assignment."]
[]
["Repayment as of 09/30/2023 (Column C of A-2Ba)","Construction Repayment per Assignment","Adjusted Irrigation Construction Repayment"]
[1052959039.2758846,779145,1053738184.2758846]
[]
["2/"]
["Cross Valley Canal contractors are charged for PUE construction component only.  Therefore their deliveries are not included in determining the \"Construction only\" rate."]
[]
["3/"]
["Suballocation of Jones Pumping Plant Costs:"]
["Facility/Contractor\n<Ref>","Historical & Projected Deliveries (1981-2030)\n<Sch A-7>","Ratio of Total","Allocated Construction Costs","Project Use Energy: BOR                      <Sch A-5>","Project Use Energy: DOE                      <Sch A-5>","Project Use Energy: TOTAL"]
["Delta-Mendota Exchange",29316504.718890011,0.36173228882862801,11574836.24316394,15448926.736398643,13048712.804032443,28497639.540431086]
["All Other Contractors",51728250.267798096,0.63826771117137204,20423513.366836071,27259250.59116536,23024132.244683456,50283382.835848816]
["Total  a/",81044754.986688107,1,31998349.610000011,42708177.327564001,36072845.048715897,78781022.376279891]
[]
["a/",null,null,null,null,null,null,null,null,null,null,null,null,"ok"]
["  Jones Pumping Plant - Conveyance Pumping:"]
["Total Construction           <Sch A-5>","less:  BOR PUE                 <Sch A-5>","less:  DOE PUE        <Sch A-5>","   Construction Allocation"]
[110779371.9862799,42708177.327564001,36072845.048715897,31998349.610000007]
[]
["4/",null,null,null,null,null,null,null,null,null,null,null,null,null,"ok"]
["Includes Friant-Kern Canal - Class 1 and Madera Canal - Class 1"]
[]
["5/"]
["Total Conveyance Pumping for Jones Pumping Plant less Delta-Mendota Exchange"]
[]
["6/",null,null,null,null,null,null,null,null,null,null,null,null,null,"ok"]
["San Luis Drain allocated to Panoche WD, San Luis WD, Santa Nella County WD and Westlands WD on the basis of their projected San Luis Canal deliveries:"]
["San Luis Canal Contractors","Historical & Projected Deliveries (1981-2030)\n<Sch A-4>","Ratio of Total","Allocated Construction Costs at 9/30/2023",null,null,null,null,null,null,null,null,null,""]
["Panoche WD",1914982.0000000005,4.8713089000000001E-2,2551667.20318875]
["San Luis WD",2668527.9999999991,6.7881704000000001E-2,3555749.0060498202]
["Santa Nella County WD",3195.0000000000005,8.1273999999999995E-5,4257.2582550030002]
["Westlands WD",34724742.000000007,0.88332393399999998,46269878.557269603]
["Total",39311447.000000007,1.0000000010000001,52381551.972381599]
[]
["7/"]
["Payment period is through 2063."]
[]
["8/"]
["Folsom SOD has a repayment period of 50 years beginning in 2024."]
[]
["9/"]
["Direct Pumping rate for City of Coalinga, based on Westlands WD, Pleasant Valley Pumping Plant on the Output tab."]
["A) Net Construction at 9/30/2023\n","B) Ratio of Total\n","C) Cumulative Construction Repayment at 9/30/2023","D) Net Unpaid Construction at 9/30/2023\n<C-A>","F) Unpaid Construction Annualized Costs Remaining Years\n(D/6)\n","G) Unpaid Construction FY 2025 Projected Deliveries\n <Sch S-5>","H) Unpaid Construction Cost Per Acre Foot\n<F/G>"]
[11167549.063454308,9.9693263314368733E-3,10505059.826942099,662489.23651220836,110414.87275203473,479611,0.23]