{"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 2026 Sch S-1.Z28.XLSM"]
["01/12/2026"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF IRRIGATION UNPAID CONSTRUCTION COSTS BY COMPONENT AND/OR FACILITY"]
["AS OF SEPTEMBER 30, 2024"]
["2026 SPECIAL WATER RATES"]
[]
["Category","A) Component/Facility","Related Footnotes","B) Net Construction at 9/30/2024\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/2024   1/\n<C*$1,053,738,184.28>\n                                                                            Folsom SOD <C/$0.00>","E) Net Unpaid Construction at 9/30/2024\n<B-D>","F) Unpaid Construction Annualized Costs Remaining Years\n(E/5)\nFolsom SOD                         (E/48)","G) Unpaid Construction FY 2026 Projected Deliveries\n <Sch S-5>","H) Unpaid Construction Cost Per Acre Foot\n<F/G>"]
["Storage","San Felipe Unit Contractors","-",2688750.4510493497,2.4045563429769012E-3,2542655.66622876,146094.7848205897,29218.956964117941,26187.142857142855,1.1200000000000001]
["Storage","All Other Contractors","-",332427158.09661293,0.29729045001816146,314364539.41376299,18062618.682849944,3612523.7365699885,1683185.4761904762,2.15]
["Folsom SOD","San Felipe Unit Contractors","8/",469317.10999999993,1.5413016319220247E-2,0,469317.10999999993,9777.4397916666658,26187.142857142855,0.37]
["Folsom SOD","All Other Contractors","8/",29980083.596515499,0.98458698368077979,0,29980083.596515499,624585.07492740627,1683185.4761904762,0.37]
["Total","Total Storage","-",365565309.25417775,1.2996950063611385,316907195.07999176,48658114.174186036,4276105.2082531797,"-","-"]
["Conveyance","Contra Costa WD","-",0,"-",0,"-","-","-","-"]
["Conveyance","All Other Contractors","-",375076402.07999998,0.33543177700646531,354696412.471156,20379989.608843982,4075997.9217687966,1649152.4471428571,2.4700000000000002]
["Total","Total Conveyance","-",375076402.07999998,0.33543177700646531,354696412.471156,20379989.608843982,4075997.9217687966,"-","-"]
["Conveyance Pumping","Corning Pumping Plant, Construction only","-",2512796.5,2.24720027860044E-3,2376262.2731727501,136534.22682724986,27306.845365449972,5296,5.16]
["Conveyance Pumping","Corning Pumping Plant, PUE only","-",285161.12728078896,2.5502031886442234E-4,269666.735261989,15494.392018799961,3098.8784037599921,5296,0.59]
["Total","Corning Pumping Plant","-","-","-","-","-","-","-",5.75]
["Conveyance Pumping","Dos Amigos Pumping Plant, Construction only","-",13419215.38082106,1.200083832589722E-2,12690074.681743899,729140.69907716103,145828.13981543219,546954.6501887677,0.27]
["Conveyance Pumping","Dos Amigos Pumping Plant, PUE only","-",23649651.922367331,2.1149943653912002E-2,22364634.6358684,1285017.2864989303,257003.45729978607,564000.6501887677,0.46]
["Total","Dos Amigos Pumping Plant","-","-","-","-","-","-","-",0.73]
["Conveyance Pumping","O'Neill Pump-Generator Plant, Construction only","-",10110901.280000003,9.0422046406533722E-3,9561519.7089927793,549381.5710072238,109876.31420144477,575075.85714285716,0.19]
["Conveyance Pumping","O'Neill Pump-Generator Plant, PUE only","-",10508670.9571555,9.3979310710756679E-3,9937676.3445327897,570994.61262270994,114198.92252454199,575075.85714285716,0.2]
["Total","O'Neill Pump-Generator Plant","-","-","-","-","-","-","-",0.39]
["Conveyance Pumping","Jones Pumping Plant, Delta Mendota Exchange, Construction only","3/",11457235.810578052,1.0246235023616889E-2,10834700.387206201,622535.42337185144,124507.08467437029,577817.14285714284,0.22]
["Conveyance Pumping","Jones Pumping Plant, Delta Mendota Exchange, PUE only","3/",28914605.671417806,2.5858405135645465E-2,27343514.128842901,1571091.5425749049,314218.30851498095,577817.14285714284,0.54]
["Total","Jones Pumping Plant","-","-","-","-","-","-","-",0.76]
["Conveyance Pumping","All Other Contractors, Construction only","3/",20254102.54442196,1.8113295239239192E-2,19153584.364385299,1100518.1800366603,220103.63600733207,704175.00000000012,0.31]
["Conveyance Pumping","All Other Contractors, PUE only","3/",51831263.100550592,4.6352829956492689E-2,49014981.944112599,2816281.156437993,563256.23128759861,704175.00000000012,0.8]
["Total","All Other Contractors","-","-","-","-","-","-","-",1.1100000000000001]
["Total","Total Conveyance Pumping","-",172943604.2945931,0.15466390364399735,163546615.20412001,9396989.0904734842,1879397.8180946966,"-","-"]
["Direct Pumping","Bella Vista WD (Wintu PP)","-",1236472.6150385102,1.1057805934528938E-3,1169288.17233201,67184.44270650018,13436.888541300035,2112.5714285714284,6.36]
["Direct Pumping","Colusa County WD Relift PP","-",11985892.907553157,1.0719014405316344E-2,11334632.600175699,651260.30737745762,130252.06147549153,27019.571428571428,4.82]
["Direct Pumping","Colusa Service Area - Cortina","-",139400.85999999999,1.2466654240768835E-4,131826.43499616301,7574.4250038369792,1514.8850007673959,649.14285714285711,2.33]
["Direct Pumping","Colusa Service Area - Davis","-",171721.21,1.5357071332820012E-4,162390.64039868501,9330.5696013149864,1866.1139202629972,2206.1428571428573,0.85]
["Direct Pumping","Corning WD Relift PP","-",3220515.8481562184,2.8801154853621397E-3,3045527.2880746899,174988.5600815285,34997.712016305697,5102.8571428571431,6.86]
["Direct Pumping","Dunnigan WD Relift PP","-",1638032.6270356425,1.4648967299306197E-3,1549029.19271451,89003.434321132489,17800.686864226496,6511.5714285714284,2.73]
["Direct Pumping","Kanawha WD Relift PP","-",2812526.2182175461,2.5152493252635108E-3,2659706.00669795,152820.21151959617,30564.042303919232,17593.571428571428,1.74]
["Direct Pumping","Orland-Artois WD Relift PP","-",7300771.795970914,6.5290987208490902E-3,6904080.2085681604,396691.58740275353,79338.317480550701,18948.285714285714,4.1900000000000004]
["Direct Pumping","Panoche WD Relift PP","-",19577.571158615927,1.7508271506252755E-5,18513.812696163001,1063.7584624529263,212.75169249058527,22471.714285714286,0.01]
["Direct Pumping","Proberta WD Relift PP","-",193130.7271269277,1.7271729875695762E-4,182636.859237164,10493.8678897637,2098.7735779527402,141,14.88]
["Direct Pumping","San Benito County WD, Gianelli, WR PGP","-",901445.70012416609,8.0616517432358515E-4,852465.13536565797,48980.564758508117,9796.1129517016234,"-","-"]
["Direct Pumping","San Benito County WD, Pacheco PP","-",530256.66430671199,4.7420987881819444E-4,501444.86690046999,28811.797406241996,5762.3594812483989,"-","-"]
["Total","Total San Benito County WD","-",1431702.3644308781,1.2803750531417797E-3,1353910.0022661299,77792.362164750113,15558.472432950022,9256.8571428571431,1.68]
["Direct Pumping","San Luis WD Canalside Relift PP","-",11050320.2431725,9.8823294003638276E-3,10449894.8085641,600425.43460839987,120085.08692167998,28730.714285714286,4.18]
["Direct Pumping","Santa Nella County WD","-",12537.088409262,1.1211949939492478E-5,11855.878580840401,681.20982842159901,136.24196568431981,456.42857142857144,0.3]
["Direct Pumping","Santa Clara Valley WD, Coyote PP","-",166487.317925788,1.4889003038100012E-4,157441.134826783,9046.183099004993,1809.2366198009986,"-","-"]
["Direct Pumping","Santa Clara Valley WD, Gianelli, WR PGP","-",896757.44766864891,8.0197245827030048E-4,848031.62177346903,48725.825895179878,9745.1651790359756,"-","-"]
["Direct Pumping","Santa Clara Valley WD, Pacheco PP","-",578440.84618438,5.1730111479358269E-4,547010.93385400099,31429.912330379011,6285.9824660758022,"-","-"]
["Total","Total Santa Clara Valley WD","-",1641685.6117788167,1.4681636034448832E-3,1552483.690454253,89201.921324563882,17840.384264912776,16930.285714285714,1.05]
["Direct Pumping","State Delta PP (CVC Contractors)","-",2898561.1635893201,2.5921905949639517E-3,2741066.1943858201,157494.96920350008,31498.993840700015,17046,1.85]
["Direct Pumping","Westlands WD, Pleasant Valley Canalside Relifts","-",1216999.4211707772,1.0883656668224206E-3,1150873.0655272701,66126.355643507093,13225.271128701419,"-","-"]
["Direct Pumping","Westlands WD, Pleasant Valley PP","-",11619397.509421034,1.039125664188891E-2,10988050.937922999,631346.57149803452,126269.31429960691,"-","-"]
["Direct Pumping","Westlands WD, Westlands WD Canalside Relifts","-",51023072.659478299,4.5630063196693452E-2,48250704.990264997,2772367.6692133024,554473.53384266049,"-","-"]
["Total","Total Westlands WD","-",63859469.590070114,5.7109685505404781E-2,60389628.993715264,3469840.596354844,693968.11927096883,493366.14285714284,1.41]
["Direct Pumping","Westside WD Canalside Relifts","-",6952326.1494320938,6.2174828960184104E-3,6574567.5543912398,377758.59504085407,75551.71900817081,22762,3.32]
["Direct Pumping","Other Costs",null,0,"-",0,0,0,"-","-"]
["Total","Total Direct Pumping","-",116564644.59114051,0.10424405708945081,110231038.33824883,6333606.2528916709,1266721.2505783343,"-","-"]
["San Luis Drain","Panoche WD","6/",2557538.5440286901,2.287213201973433E-3,2418573.2327948301,138965.31123385997,27793.062246771995,22471.714285714286,"-"]
["San Luis Drain","San Luis WD","6/",3515508.1847703299,3.1439278796504262E-3,3324491.0483199698,191017.13645036006,38203.42729007201,28730.714285714286,"-"]
["San Luis Drain","Santa Nella County WD",null,3612.2842019549998,3.2304749170962486E-6,3416.0086855754498,196.27551637955003,39.255103275910002,456.42857142857144,"-"]
["San Luis Drain","Westlands WD","6/",46304892.906998999,4.1410583085885258E-2,43788890.217813604,2516002.6891853958,503200.53783707914,493366.14285714284,"-"]
["Total","Total San Luis Drain","6/",52381551.919999972,4.6844954642426211E-2,49535370.507613979,2846181.4123859955,569236.2824771991,545025,1.04]
["Subtotal","Subtotal","-",1082531512.1399114,1.940879698743478,994916631.6011306,87614880.538781181,12067458.481172208,"-","-"]
["Other Costs","Programmatic EIS Capitalized","-",12102331.29724,1.082314555232489E-2,11444744.2437417,657587.05349829979,131517.41069965996,"-","-"]
["Other Costs","All Others ","-",54005388.379999995,4.8297155704196876E-2,51070974.890101902,2934413.489898093,586882.69797961856,"-","-"]
["Total","Total Other Costs","-",66107719.677239999,5.9120301256521762E-2,62515719.133843601,3592000.5433963928,718400.10867927852,1964360.3519047622,0.37]
["Subtotal","Subtotal","-",1148639231.8171513,1.9999999999999998,1057432350.7349741,91206881.082177579,12785858.589851486,"-","-"]
["Other Costs","DMC California Aqueduct Intertie","7/",26955526.760000002,"-",30531802.493328888,-3576275.7333288854,-94112.519298128565,704175.00000000012,0]
["Total","Total","-",1175594758.5771513,"-","-","-","-","-","-"]

{"sheet":"Footnotes","index":1,"n_rows":56,"n_cols":19,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
["Bureau of Reclamation logo"]
["Special Rates 2026 Sch S-1.Z28.XLSM"]
["01/12/2026"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF IRRIGATION UNPAID CONSTRUCTION COSTS BY COMPONENT AND/OR FACILITY"]
["AS OF SEPTEMBER 30, 2024"]
["2026 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/2024 (Column C of A-2Ba)","Construction Repayment per Assignment","Adjusted Irrigation Construction Repayment"]
[1056653205.7349734,779145,1057432350.7349734]
[]
["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",29254206.589339849,0.35809393237286902,11489685.610578053,15552615.315997701,13361990.355420105,28914605.671417806]
["All Other Contractors",52440019.267798066,0.64190606762713098,20595989.604421958,27879048.585537996,23952214.515012592,51831263.100550592]
["Total  a/",81694225.857137918,1,32085675.215000011,43431663.901535697,37314204.870432697,80745868.771968395]
[]
["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"]
[112831543.9869684,43431663.901535697,37314204.870432697,32085675.215000011]
[]
["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/2024",null,null,null,null,null,null,null,null,null,""]
["Panoche WD",1938937.2857142859,4.8825176999999997E-2,2557538.5440286901]
["San Luis WD",2665199.2857142845,6.7113479000000004E-2,3515508.1847703299]
["Santa Nella County WD",2738.5714285714289,6.8961000000000006E-5,3612.2842019549998]
["Westlands WD",35104958,0.88399238300000005,46304892.906998999]
["Total",39711833.142857142,1,52381551.919999972]
[]
["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/2024\n","B) Ratio of Total\n","C) Cumulative Construction Repayment at 9/30/2024","D) Net Unpaid Construction at 9/30/2024\n<C-A>","F) Unpaid Construction Annualized Costs Remaining Years\n(D/6)\n","G) Unpaid Construction FY 2026 Projected Deliveries\n <Sch S-5>","H) Unpaid Construction Cost Per Acre Foot\n<F/G>"]
[11619397.509421034,1.039125664188891E-2,10988050.937922999,631346.57149803452,126269.31429960691,493366.14285714284,0.26]