{"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 2024 Sch S-1.Z26.XLSM"]
["01/13/2024"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF IRRIGATION UNPAID CONSTRUCTION COSTS BY COMPONENT AND/OR FACILITY"]
["AS OF SEPTEMBER 30, 2022"]
["2024 SPECIAL WATER RATES"]
[]
["Category","A) Component/Facility","Related Footnotes","B) Net Construction Costs at 9/30/2022\n<Sch A-4>","C) Ratio of Total\n<B/$1,125,085,860>  excludes Folsom SOD","D) Cumulative Construction Repayment at 9/30/2022   1/\n<C*$1,050,409,850>","E) Unpaid Construction: Net Unpaid Construction at 9/30/2022\n<B-D>","F) Unpaid Construction: Annualized Costs 7 Remaining Years\n<E/7>","G) Unpaid Construction: FY 2024 Projected Deliveries\n <Sch S-5>","H) Unpaid Construction: Unpaid Construction Cost Per Acre Foot\n<F/G>"]
["Storage","San Felipe Unit Contractors","-",2781679.4968170901,2.4724153016525306E-3,2597049.3861250998,184630.11069199024,26375.730098855747,20756.571428571428,1.27]
["Storage","All Other Contractors","-",340357341.84046668,0.30251677123803605,317766596.29600698,22590745.544459701,3227249.363494243,1477459.2857142854,2.1800000000000002]
["Folsom SOD","San Felipe Unit Contractors","8/",232658.44459740003,"-",0,232658.44459740003,4653.1688919480002,20756.571428571428,0.22]
["Folsom SOD","All Other Contractors","8/",16700270.565402603,"-",0,16700270.565402603,334005.41130805208,1477459.2857142854,0.23]
["Total","Total Storage","-",360071950.34728384,0.30498918653968859,320363645.68213207,39708304.665151693,3592283.6737930989,"-","-"]
["Conveyance","Contra Costa WD","-","-","-","-","-","-","-","-"]
["Conveyance","All Other Contractors","-",376432008.5,0.33458069447329775,351446857.09169197,24985151.408308029,3569307.3440440041,1406252.7371428572,2.54]
["Total","Total Conveyance","-",376432008.5,0.33458069447329775,351446857.09169197,24985151.408308029,3569307.3440440041,"-","-"]
["Conveyance Pumping","Corning Pumping Plant, Construction only","-",2512796.0099999998,2.2334259975544338E-3,2346012.66705789,166783.3429421098,23826.19184887283,5354.1428571428569,4.45]
["Conveyance Pumping","Corning Pumping Plant, PUE only","-",294285.00837612897,2.6156671125793885E-4,274752.24993517698,19532.758440951991,2790.3940629931417,5354.1428571428569,0.52]
["Total","Corning Pumping Plant","-","-","-","-","-","-","-",4.9700000000000006]
["Conveyance Pumping","Dos Amigos Pumping Plant, Construction only","-",13486238.627621958,1.1986852828596187E-2,12591108.2815539,895130.34606805816,127875.76372400831,451745.66400209867,0.28000000000000003]
["Conveyance Pumping","Dos Amigos Pumping Plant, PUE only","-",24014015.779238246,2.1344162810507286E-2,22420118.855975501,1593896.9232627451,227699.56046610646,464955.09257352725,0.49]
["Total","Dos Amigos Pumping Plant","-","-","-","-","-","-","-",0.77]
["Conveyance Pumping","O'Neill Pump-Generator Plant, Construction only","-",10331042.585000001,9.182448157095317E-3,9645333.9912476595,685708.59375234134,97958.370536048766,474420.42857142858,0.21]
["Conveyance Pumping","O'Neill Pump-Generator Plant, PUE only","-",10563264.67060256,9.388852035932687E-3,9862142.65865485,701122.01194771007,100160.28742110144,474420.42857142858,0.21]
["Total","O'Neill Pump-Generator Plant","-","-","-","-","-","-","-",0.42]
["Conveyance Pumping","Jones Pumping Plant, Delta Mendota Exchange, Construction only","3/",11752628.183311798,1.0445983366632099E-2,10972563.821156001,780064.36215579696,111437.76602225671,509364.57142857136,0.22]
["Conveyance Pumping","Jones Pumping Plant, Delta Mendota Exchange, PUE only","3/",29935862.339444816,2.6607624710501966E-2,27948911.080784,1986951.2586608157,283850.17980868794,509364.57142857136,0.56000000000000005]
["Total","Jones Pumping Plant","-","-","-","-","-","-","-",0.78]
["Conveyance Pumping","All Other Contractors, Construction only","3/",20327388.65668818,1.8067411006530722E-2,18978186.485101599,1349202.1715865806,192743.1673695115,571610.71428571432,0.34]
["Conveyance Pumping","All Other Contractors, PUE only","3/",52126002.930867806,4.6330688854603355E-2,48666211.929758899,3459791.0011089072,494255.85730127245,571610.71428571432,0.86]
["Total","All Other Contractors","-","-","-",0,"-",0,"-",1.2]
["Total","Total Conveyance Pumping","-",175343524.79115149,0.15584901647921201,163705342.02122501,11638182.769926017,1662597.5385608594,"-","-"]
["Direct Pumping","Bella Vista WD (Wintu PP)","-",1282916.773724644,1.1402834387401303E-3,1197764.9558346199,85151.817890024045,12164.545412860578,2717.8571428571427,4.4800000000000004]
["Direct Pumping","Colusa County WD Relift PP","-",11984000.431823187,1.0651631892370551E-2,11188579.0582278,795421.37359538674,113631.62479934096,23228.142857142859,4.8899999999999997]
["Direct Pumping","Colusa Service Area - Cortina","-",139400.85999999999,1.2390241928370699E-4,130148.321653362,9252.5383466379863,1321.7911923768552,722.71428571428567,1.83]
["Direct Pumping","Colusa Service Area - Davis","-",171721.21,1.5262942682940046E-4,160323.45334013301,11397.75665986698,1628.2509514095686,2419.5714285714284,0.67]
["Direct Pumping","Corning WD Relift PP","-",3233334.9303915892,2.8738561600698464E-3,3018726.8179956302,214608.11239595897,30658.301770851282,5063,6.06]
["Direct Pumping","Dunnigan WD Relift PP","-",1637913.9357006846,1.4558123903382872E-3,1529199.6745507601,108714.26114992448,15530.608735703498,6179.7142857142853,2.5099999999999998]
["Direct Pumping","Kanawha WD Relift PP","-",2818419.152907812,2.505070281494777E-3,2631350.4986026702,187068.65430514188,26724.093472163127,19650.142857142859,1.36]
["Direct Pumping","Orland-Artois WD Relift PP","-",7338132.0137431845,6.5222862292671734E-3,6851073.6996850502,487058.31405813433,69579.759151162041,17641.571428571428,3.94]
["Direct Pumping","Panoche WD Relift PP","-",19774.392785069133,1.7575896633179637E-5,18461.8949459213,1312.4978391478326,187.49969130683323,18905.428571428572,0.01]
["Direct Pumping","Proberta WD Relift PP","-",194034.84292118502,1.7246225355617529E-4,181156.04988710899,12878.793034076021,1839.8275762965745,201.42857142857142,9.1300000000000008]
["Direct Pumping","San Benito County WD, Gianelli, WR PGP","-",929745.72340596712,8.263775736296003E-4,868035.14315246802,61710.580253499094,8815.7971790713,"-","-"]
["Direct Pumping","San Benito County WD, Pacheco PP","-",546914.05853696703,4.8610872983854731E-4,510613.397989185,36300.660547782027,5185.8086496831465,"-","-"]
["Total","Total San Benito County WD","-",1476659.7819429343,1.3124863034681476E-3,1378648.5411416499,98011.240801281121,14001.605828754447,8543.8571428571431,1.64]
["Direct Pumping","San Luis WD Canalside Relift PP","-",11210642.204626001,9.9642548179200048E-3,10466551.4085667,744090.79605930112,106298.68515132873,27746.714285714286,3.83]
["Direct Pumping","Santa Nella County WD","-",16961.710253648002,1.5075925181639818E-5,15835.9003085268,1125.809945121202,160.82999216017171,456.42857142857144,0.35]
["Direct Pumping","Santa Clara Valley WD, Coyote PP","-",162401.15068289079,1.4434556188583063E-4,151622.00000741001,10779.150675480778,1539.8786679258253,"-","-"]
["Direct Pumping","Santa Clara Valley WD, Gianelli, WR PGP","-",871266.64941015292,7.7440014145628165E-4,813437.536420358,57829.112989794929,8261.3018556849893,"-","-"]
["Direct Pumping","Santa Clara Valley WD, Pacheco PP","-",564243.99502354907,5.0151194224857479E-4,526793.08402618603,37450.91099736304,5350.1301424804342,"-","-"]
["Total","Total Santa Clara Valley WD","-",1597911.7951165927,1.4202576455906871E-3,1491852.620453954,106059.17466263875,15151.310666091249,12212.714285714286,1.24]
["Direct Pumping","State Delta PP (CVC Contractors)","-",2991916.3031966696,2.6592782014431787E-3,2793332.0166631402,198584.2865335294,28369.183790504201,13209.428571428571,2.15]
["Direct Pumping","Westlands WD, Pleasant Valley Canalside Relifts","-",1372411.5482846929,1.2198282785728259E-3,1281319.6391108599,91091.909173832973,13013.12988197614,"-","-"]
["Direct Pumping","Westlands WD, Pleasant Valley PP","-",12723700.370463379,1.1309092771317275E-2,11879182.4414574,844517.92900597863,120645.41842942552,"-","-"]
["Direct Pumping","Westlands WD, Westlands WD Canalside Relifts","-",44821280.11212308,3.9838097421240809E-2,41846329.936185598,2974950.1759374812,424992.88227678306,"-","-"]
["Total","Total Westlands WD","-",58917392.030871153,5.2367018471130913E-2,55006832.01675386,3910560.0141172931,558651.43058818474,403231,1.39]
["Direct Pumping","Westside WD Canalside Relifts","-",6961645.9704457978,6.1876575075283215E-3,6499576.3942805501,462069.57616524771,66009.939452178238,27893.714285714286,2.37]
["Direct Pumping","Other Costs",null,0,"-","-","-","-","-","-"]
["Total","Total Direct Pumping","-",111992778.34045015,9.9541539260846121E-2,104559413.32289143,7433365.0175587125,1061909.2882226731,"-","-"]
["San Luis Drain","Panoche WD","6/",2590879.9780228399,2.3028286722961929E-3,2418913.9202223802,171966.05780045968,24566.579685779954,18905.428571428572,"-"]
["San Luis Drain","San Luis WD","6/",3602281.3684189301,3.2017835219074549E-3,3363184.94895152,239096.41946741007,34156.631352487151,27746.714285714286,"-"]
["San Luis Drain","Santa Nella County WD",null,4962.3139395890003,4.410609104996484E-6,4632.9472483497502,329.36669123925003,47.052384462750005,456.42857142857144,"-"]
["San Luis Drain","Westlands WD","6/",46183428.207237102,4.104880332655101E-2,43118067.344566099,3065360.8626710027,437908.69466728612,402331.28571428574,"-"]
["Total","Total San Luis Drain","6/",52381551.867618464,4.6557826129859654E-2,48904799.160988346,3476752.7066301117,496678.95809001598,449439.85714285716,1.1100000000000001]
["Subtotal","Subtotal","-",1076221813.846504,0.94151826288290419,988980057.27892876,87241756.567574561,10382776.802710652,"-","-"]
["Other Costs","Programmatic EIS Capitalized","-",13902414.289501501,1.2356758518947547E-2,12979660.862266799,922753.42723470181,131821.91817638598,"-","-"]
["Other Costs","All Others ","-",51894561.230000004,4.6124978598148285E-2,48450131.850134298,3444429.379865706,492061.33998081513,"-","-"]
["Total","Total Other Costs","-",65796975.519501507,5.8481737117095832E-2,61429792.7124011,4367182.8071004078,623883.25815720111,1708299.88,0.37]
["Subtotal","Subtotal","-",1142018789.3660054,1,1050409849.9913299,91608939.374674976,11006660.060867853,"-","-"]
["Other Costs","DMC California Aqueduct Intertie","7/",26955526.760000002,"-",30520965.233844697,-3565438.4738446972,-89135.961846117425,571610.71428571432,0]
["Total","Total","-",1168974316.1260054,"-","-","-","-","-","-"]

{"sheet":"Footnotes","index":1,"n_rows":51,"n_cols":19,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
["Special Rates 2024 Sch S-1.Z26.XLSM"]
["01/13/2024"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF IRRIGATION UNPAID CONSTRUCTION COSTS BY COMPONENT AND/OR FACILITY"]
["AS OF SEPTEMBER 30, 2022"]
["2024 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/2022 (Column C of A-2Ba)","Construction Repayment per Assignment","Adjusted Irrigation Construction Repayment"]
[1049630704.9913303,779145,1050409849.9913303]
[]
["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",29238974.071121868,0.36479626975131202,11785077.983311798,16238262.611148816,13697599.728296001,29935862.339444816]
["All Other Contractors",50912541.982083797,0.63520373024868704,20520838.936688181,28274973.837838747,23851029.093029063,52126002.930867806]
["Total  a/",80151516.053205669,0.99999999999999911,32305916.919999979,44513236.448987558,37548628.821325064,82061865.270312622]
[]
["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"]
[114367782.19031271,44513236.448987603,37548628.821325101,32305916.920000009]
[]
["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/2022",null,null,null,null,null,null,null,null,null,""]
["Panoche WD",1906454.4285714291,4.9461687999999997E-2,245.44442383800001]
["San Luis WD",2650676.7142857127,6.8770039000000005E-2,341.25852315600002]
["Santa Nella County WD",3651.428571428572,9.4734000000000005E-5,0.47009984900000001]
["Westlands WD",33983280.285714291,0.88167353800000003,4375.1408877840004]
["Total",38544062.857142858,0.99999999900000003,4962.3139395890003]
[]
["7/"]
["Payment period is through 2063."]
[]
["8/"]
["Folsom SOD has a repayment period of 50 years beginning in 2024."]