{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["OUTPUT","Footnotes"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":66,"comments":1,"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":52,"n_cols":9,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
["IRR 2026 Sch A-5 F.Z28.XLSM"]
["7/29/2025"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF IRRIGATION CONSTRUCTION AND PROJECT USE ENERGY COSTS BY COMPONENT"]
["AS OF SEPTEMBER 30, 2024"]
["2026 IRRIGATION WATER RATES"]
[]
["Category ","A) Component/Facility","B) Irrigation\nConstruction \nCosts at \n09/30/2024\n\n<Cost Allocation>","C) Allocation of Project Use Energy Construction Costs: Historical & \nProjected \n(1981-2030)\n KWH Per AF \n1/\n\n <Sch A-7>","D) Allocation of Project Use Energy Construction Costs:   \nRatio of \nTotal \n\n(C/Total C)","E) Allocation of Project Use Energy Construction Costs: CVP PUE \nConstruction \nCosts at \n09/30/2024\n(BOR)    1/\n\n(D*PUE BOR)","F) Allocation of Project Use Energy Construction Costs: CVP PUE \nConstruction \nCosts at\n09/30/2024\n (DOE)    1/\n\n(D*PUE DOE)","G) Total Irrigation\nConstruction \nCosts at\n09/30/2024\n\n(B+E+F)"]
["Storage     2/","San Felipe Unit Contractors",3535355.9910493498,"-","-","-","-",3535355.9910493498]
["Storage     2/","All Other Contractors",338356728.98178178,8897482580.2101192,0.20128722860000001,19916757.640821401,17111432.2640098,375384918.88661295]
["Total","Total Storage",341892084.97283113,8897482580.2101192,0.20128722860000001,19916757.640821401,17111432.2640098,378920274.8776623]
["Conveyance","Contra Costa WD     3/",0,"-","-","-","-",0]
["Conveyance","All Other Contractors    4/",379164335.51999998,"-","-","-","-",379164335.51999998]
["Total","Total Conveyance",379164335.51999998,"-","-","-","-",379164335.51999998]
["Conveyance Pumping","Corning Pumping Plant",2529062.5,68521203,1.5501511999999999E-3,153382.73556531299,131778.391715476,2814223.627280789]
["Conveyance Pumping","DMC - California Aqueduct Intertie",26962640.82,0,0,0,0,26962640.82]
["Conveyance Pumping","Dos Amigos Pumping Plant",14354620.499999998,5825334776,0.13178620830000001,13039843.557734299,11203148.815454099,38597612.873188391]
["Conveyance Pumping","O'Neill Pump-Generator Plant",11165274.920000002,2525122535,5.7125699600000003E-2,5652413.8262966303,4856257.1308588702,21673945.877155505]
["Conveyance Pumping","Jones Pumping Plant",32085675.215,19402378641,0.43893887840000001,43431663.901535697,37314204.870432697,112831543.9869684]
["Total","Total Conveyance Pumping",87097273.954999998,27821357155,0.62940093750000004,62277304.02113194,53505389.208461143,202879967.18459308]
["Direct Pumping    2/","Bella Vista WD (Wintu PP)",654327.13,147659936,3.3405021E-3,330532.49919083598,283976.16584767401,1268835.7950385101]
["Direct Pumping    2/","Colusa County WD Canalside Relifts",12603256.550000001,236560284,5.3516895000000004E-3,529533.36126576702,454947.25628738798,13587737.167553157]
["Direct Pumping    2/","Colusa Service Area - Cortina",141792.21,"-","-","-","-",141792.21]
["Direct Pumping    2/","Colusa Service Area - Davis",180305.28,"-","-","-","-",180305.28]
["Direct Pumping    2/","Contra Costa Pumping Plants",0,"-","-","-","-","-"]
["Direct Pumping    2/","Corning WD Canalside Relifts",2779835.16,108485919,2.4542705999999999E-3,242842.59396471901,208637.60419149901,3231315.3581562182]
["Direct Pumping    2/","Dunnigan WD Canalside Relifts",1700383.63,2638952,5.9700900000000003E-5,5907.2220553138004,5075.1749803287003,1711366.0270356424]
["Direct Pumping    2/","Kanawha WD Canalside Relifts",2751862.9550000001,32947194,7.4536239999999998E-4,73751.337224089497,63363.275993456402,2888977.5682175462]
["Direct Pumping    2/","Orland-Artois WD Canalside Relifts",7496789.3700000001,71773255,1.6237222E-3,160662.36173228,138032.664238634,7795484.3959709136]
["Direct Pumping    2/","Panoche WD Relifts",17103.890379600227,1938937,4.38645E-5,4340.2585529751004,3728.9222260406,25173.071158615927]
["Direct Pumping    2/","Proberta WD Canalside Relifts",172158.29,5257097,1.18931E-4,11767.8598858732,10110.3272410545,194036.4771269277]
["Direct Pumping    2/","San Benito County WD:   ","-","-","-","-","-","-"]
["Direct Pumping    2/","San Benito County WD: Pacheco Pumping Plant",0,127415072,2.8825037E-3,285214.95373040799,245041.710576304,530256.66430671199]
["Direct Pumping    2/","San Benito County WD: Gianelli, William R. Pump-Generator Plant   2/",124371.83425184801,192153082,4.3470679000000003E-3,430129.11655983003,369544.34931248799,924045.30012416607]
["Direct Pumping    2/","San Luis WD Canalside Relift Pumping Plants",8367156.0996203981,924291112,2.0910183799999999E-2,2068998.94179193,1777575.24016948,12213730.281581808]
["Direct Pumping    2/","Santa Clara Valley WD:   ","-","-","-","-","-","-"]
["Direct Pumping    2/","Santa Clara Valley WD: Coyote Pumping Plant ",0,40005141,9.0503399999999998E-4,89550.3552812251,76936.962644562896,166487.317925788]
["Direct Pumping    2/","Santa Clara Valley WD: Pacheco Pumping Plant",0,138993219,3.1444354999999998E-3,311132.30683476699,267308.53934961301,578440.84618438]
["Direct Pumping    2/","Santa Clara Valley WD: Gianelli, William R. Pump-Generator Plant    2/",135673.442917312,209613940,4.7420839000000001E-3,469214.74554367899,403124.66920765798,1008012.8576686489]
["Direct Pumping    2/","State-Delta Pumping Plant (Cross Valley Canal)",0,721713267,1.6327277099999999E-2,1615534.2949325801,1387982.2286567399,3003516.52358932]
["Direct Pumping    2/","Westlands WD:","-","-","-","-","-","-"]
["Direct Pumping    2/","Westlands WD: Pleasant Valley Canalside Relifts",1335560.8500000001,31598463,7.1485020000000002E-4,70732.248051293995,60769.433119483198,1467062.5311707773]
["Direct Pumping    2/","Westlands WD: Pleasant Valley Pumping Plant",9867758.3550000004,420900372,9.5220045000000003E-3,942173.31720623199,809465.83721480099,11619397.509421034]
["Direct Pumping    2/","Westlands WD: Westlands WD Canalside Relifts",36146441.539999999,4035242048,9.1289045099999994E-2,9032772.7157087792,7760483.9737695204,52939698.2294783]
["Direct Pumping    2/","Westside WD Canalside Relifts",7002376.6299999999,34889587,7.8930510000000005E-4,78099.333428669997,67098.846003424202,7147574.809432094]
["Total","Total Direct Pumping",91477153.217169166,7484076877,0.16931183399999999,16752889.822941247,14393203.181030151,122623246.22114056]
["Direct Pumping    2/","San Luis Drain",52381551.920000002,"-","-","-","-",52381551.920000002]
["Direct Pumping    2/","Other Costs",54005388.379999995,"-","-","-","-",54005388.379999995]
["Grand Total","Grand Total",1006017787.9650002,44202916612.210121,1.0000000001,98946951.484894574,85010024.653501064,1189974764.1033959]
[]
[null,null,null,null,null,null,null,null,""]

{"sheet":"Footnotes","index":1,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["IRR 2026 Sch A-5 F.Z28.XLSM"]
["7/29/2025"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF IRRIGATION CONSTRUCTION AND PROJECT USE ENERGY COSTS BY COMPONENT"]
["AS OF SEPTEMBER 30, 2024"]
["2026 IRRIGATION WATER RATES"]
[]
["Footnotes:"]
[]
["1/ The costs (BOR - $98,946,951.48 and DOE - $85,010,024.65) are allocated to components based on the ratios identified under \"Allocation of Project Use Energy Costs\".  "]
["They are then suballocated to individual facilities based on the historical and projected 1981-2030 KWHs per A/F."]
[]
["2/ Allocation of Storage Costs:"]
[]
["-","San Felipe Unit\nStorage","San Felipe Unit \nSan Benito","San Felipe Unit\nSanta Clara","All Other\nStorage\nContractors","Total"]
["Historical and Projected 1981-2030 Irrigation Del. (Sch A-7)",1267403.857142857,606161.14285714296,661242.71428571409,112987953.63856165,114255357.4957045]
["Ratios",1.1092730199999999E-2,5.3053192000000002E-3,5.7874110000000001E-3,0.98890726979999999,1]
["Allocated Gianelli, WR Pump-Generator Costs",260045.27716915999,124371.83425184801,135673.442917312,23182810.762830801,23442856.039999962]
["Allocated Other Storage Costs",3535355.9910493498,"-","-",315173918.21895099,318709274.21000034]
["Total",3795401.2682185099,124371.83425184801,135673.442917312,338356728.98178178,342152130.2500003]
[]
["3/ Contra Costa Water District's conveyance facility costs are recovered through a repayment contract."]
[]
["4/ Glide WD's cost of the Relift Pumping Plant is included in conveyance for ratesetting purposes."]