{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["INFORMATION","MACRO_INPUT","OUTPUT","Footnotes"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"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":"INFORMATION","index":0,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
["Special Rates 2023 Sch S-1.Z25.XLSM"]
["01/04/2023"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF IRRIGATION UNPAID CONSTRUCTION COSTS BY COMPONENT AND/OR FACILITY"]
["AS OF SEPTEMBER 30, 2021"]
["2023 SPECIAL WATER RATES"]
[]
[]
[null,null,"SOURCE DATA:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["10/19/2022","jm","Updated file names, title, headings, and date"]
[null,null,"Updated & ran macro"]
[]
["10/22/2022","mna","updated formula in cell S106 for DMC intertie.  Cost per a/f should not be a negative cost. "]
[]
["10/24/2022","jm","updated headings and footnotes"]
[]
["01/04/23","KJ","Reviewed"]

{"sheet":"MACRO_INPUT","index":1,"n_rows":299,"n_cols":37,"rows_kept":299,"cut":false,"hidden":true,"merged":[[6,31,6,34],[8,32,8,34]]}
[{"$f":"INFORMATION!A1","v":"Special Rates 2023 Sch S-1.Z25.XLSM"}]
[{"$f":"INFORMATION!A2","v":"01/04/2023"}]
[{"$f":"INFORMATION!A4","v":"SCHEDULE OF IRRIGATION UNPAID CONSTRUCTION COSTS BY COMPONENT AND/OR FACILITY"}]
[{"$f":"INFORMATION!A5","v":"AS OF SEPTEMBER 30, 2021"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"663986","v":663986},-633781,{"$f":"SUM(M4:N4)","v":30205}]
[{"$f":"INFORMATION!A6","v":"2023 SPECIAL WATER RATES"}]
[]
[null,"Schedule A-5",null,null,null,null,null,null,null,null,"Schedule S-5",null,null,null,null,null,null,null,null,null,null,"Schedule A-4",null,null,null,null,null,null,null,"Schedule A-2B",null,"Schedule A-4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Projected",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Capital"]
[null,null,null,null,"Total",null,"PUE (BOR)",null,"PUE (DOE)",null,null,null,null,"Deliveries","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Repayment",null,null,"Net Construction Cost"]
[]
["Conveyance Pumping",null,null,null,null,null,null,null,null,null,"Black Butte D & R",null,null,null,null,null,null,null,null,null,null,"Programmatic EIS Capitalized   4/"]
[null,"Corning Pumping Plant",null,null,2824379.9007134931,null,161064.225040922,null,134253.175672571,null,null,"4-E WD",null,2.8571428571428572,2.8571428571428572,null,null,null,null,null,null,"All Others"]
[null,"DMC - California Aqueduct Intertie",null,null,26962640.82,null,0,null,0,null,null,"Stony Creek WD",null,153.85714285714286,153.85714285714286,null,null,null,null,null,null,null,"Total Other Costs",null,null,null,null,null,null,1061680705.3052276]
[null,"Dos Amigos Pumping Plant",null,null,38876439.171386003,null,13368248.4942139,null,11142945.077172101,null,null,"     Total Black Butte D & R",null,156.71428571428572,156.71428571428572,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-3560019.8446534006]
[null,"O'Neill Pump-Generator Plant",null,null,21879488.431990121,null,5792517.5186260398,null,4828284.31836408]
[null,"Jones Pumping Plant",null,null,114731591.51184881,null,44810419.093674101,null,37351193.693174697,null,null,null,null,null,null,null,null,null,null,null,null,"Sub allocation of Jones Pumping Plant Costs:"]
[null,null,"Total Conveyance Pumping",null,205274539.83593842,null,64132249.331554964,null,53456676.26438345,null,"Buchanan Unit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Historical",null,null,null,null,"Storage"]
[null,null,null,null,null,null,null,null,null,null,null,"Chowchilla WD - BU",null,24000,24000,0,null,null,null,null,null,null,null,null,null,null,"& Projected",null,null,null,null,null,"San Felipe Unit Contractors",null,2819259.0976596707]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deliveries",null,null,null,null,null,"All Other Contractors",null,342433451.99267137]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1981-2030",null,null,null,null,null,null,"Total Storage",345252711.09033102]
[null,null,null,null,null,null,null,null,null,null,"Clear Creek Unit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Sch A-7)"]
[null,null,null,null,null,null,null,null,null,null,null,"Clear Creek CSD",null,981.57142857142856,981.57142857142856,981.57142857142856,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conveyance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"    Delta-Mendota Exchange",null,29157082.487641286,null,null,null,null,null,"Contra Costa WD",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"    All Other Contractors",null,51373991.714285702,null,null,null,null,null,"All Other Contractors",null,377317187.61000001]
[null,null,null,null,null,null,null,null,null,null,"Colusa Basin Drain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"    Total",80531074.201926991,null,null,null,null,null,null,"Total Conveyance",377317187.61000001]
[null,null,null,null,null,null,null,null,null,null,null,"Colusa Drain MWC",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conveyance Pumping"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub allocation of San Luis Drain Costs:",null,null,null,null,null,null,null,null,null,null,"Corning Pumping Plant",null,2808344.530713493]
[null,null,null,null,null,null,null,null,null,null,"Corning Canal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Historical",null,null,null,null,null,"DMC - California Aqueduct Intertie",null,26955526.760000002]
[null,null,null,null,null,null,null,null,null,null,null,"Corning WD",null,5132.1428571428569,5132.1428571428569,5132.1428571428569,5132.1428571428569,null,null,null,null,null,null,null,null,null,"& Projected",null,null,null,null,null,"Dos Amigos Pumping Plant - Construction only   2/",null,13497147.380790524]
[null,null,null,null,null,null,null,null,null,null,null,"Proberta WD",null,201.42857142857142,201.42857142857142,201.42857142857142,201.42857142857142,null,null,null,null,null,null,null,null,null,"Deliveries",null,null,null,null,null,null,null,24138808.91059548]
[null,null,null,null,null,null,null,null,null,null,null,"Thomes Creek WD",null,89.714285714285708,89.714285714285708,89.714285714285708,89.714285714285708,null,null,null,null,null,null,null,null,null,"1981-2030",null,null,null,null,null,"O'Neill Pump-Generator Plant",null,20999846.61199012]
[null,null,null,null,null,null,null,null,null,null,null,"     Total Corning Canal",null,5423.2857142857138,5423.2857142857138,5423.2857142857138,5423.2857142857138,null,null,null,null,null,null,"San Luis Canal Contractors:",null,null,"(Sch A-7)",null,null,null,null,null,"Jones Pumping Plant   1/"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FK/Madera Exchange (class 1 only)",41508559.146875001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"    Panoche WD",null,1915445.8571428577,null,null,null,null,null,null,"All Other Contractors",72998418.684973806]
[null,null,null,null,null,null,null,null,null,null,"Cow Creek Unit",null,null,null,null,null,null,null,null,null,null,null,null,null,"    San Luis WD",null,2690216.5714285732,null,null,null,null,null,null,"Total Conveyance Pumping",202906652.02593842]
[null,null,null,null,null,null,null,null,null,null,null,"Bella Vista WD",null,2851.5714285714284,2851.5714285714284,2851.5714285714284,null,null,null,null,null,null,null,null,"    Westlands WD",null,34274241]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"    Total",38879903.428571433]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Direct Pumping"]
[null,null,null,null,null,null,null,null,null,null,"Cross Valley Canal",null,null,null,null," ",null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,"Bella Vista WD (Wintu PP)",null,1288490.8224760031]
[null,null,null,null,null,null,null,null,null,null,null,"County of Fresno",null,321.42857142857144,321.42857142857144," ",null,null,null,321.42857142857144,null,"Jones Pumping Plant   1/",null,null,null,null,31163.4,null,null,null,null,null,"Colusa County WD Relift PP",null,11997486.526238142,0,14133]
[null,null,null,null,null,null,null,null,null,null,null,"County of Tulare",null,400.57142857142856,400.57142857142856," ",null,null,null,400.57142857142856,null,null,null,null,null,null,193450.28,null,null,null,null,null,"Colusa Service Area - Cortina",null,139400.85999999999,0,193450.28]
[null,null,null,null,null,null,null,null,null,null,null,"Hills Valley ID",null,239,239," ",null,null,null,239,null,null,null,null,null,null,null,null,null,null,null,null,"Colusa Service Area - Davis",null,171721.21]
[null,null,null,null,null,null,null,null,null,null,null,"Kern-Tulare ID",null,5498.1428571428569,5498.1428571428569," ",null,null,null,5498.1428571428569,null,null,null,null,null,null,null,null,null,null,null,null,"Contra Costa PP (Contra Costa WD)",null,0]
[null,null,null,null,null,null,null,null,null,null,null,"Lower Tule River ID - CVC",null,3303.7142857142858,3303.7142857142858," ",null,null,null,3303.7142857142858,null,null,null,null,null,null,null,null,null,null,null,null,"Corning WD Relift PP",null,3236242.2188431425]
[null,null,null,null,null,null,null,null,null,null,null,"Pixley ID",null,3332.2857142857142,3332.2857142857142," ",null,null,null,3332.2857142857142,null,null,null,null,null,null,null,null,null,null,null,null,"Dunnigan WD Relift PP",null,1637766.6962540259]
[null,null,null,null,null,null,null,null,null,null,null,"Tri-Valley WD",null,124.42857142857143,124.42857142857143," ",null,null,null,124.42857142857143,null,null,null,null,null,null,null,null,null,null,null,null,"Kanawha WD Relift PP",null,2820678.8778452361]
[null,null,null,null,null,null,null,null,null,null,null,"     Total Cross Valley Canal",null,13219.571428571428,13219.571428571428,null,null,null,null,13219.571428571428,null,null,null,null,null,null,null,null,null,null,null,null,"Orland-Artois WD Relift PP",null,7339803.6255620085]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Panoche WD Relift PP",null,19786.185374092725]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proberta WD Relift PP",null,193993.53600810911]
[null,null,null,null,null,null,null,null,null,null,"Delta-Mendota Canal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"San Benito County WD"]
[null,null,null,null,null,null,null,null,null,null,null,"Banta-Carbona ID",null,6143,6143,6143,null,6143,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gianelli, WR PGP",941297.94896314305]
[null,null,null,null,null,null,null,null,null,null,null,"Byron-Bethany ID ",null,2980.2857142857142,2980.2857142857142,2980.2857142857142,null,2980.2857142857142,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pacheco PP",553450.20890736394]
[null,null,null,null,null,null,null,null,null,null,null,"Del Puerto WD",null,36972.571428571428,36972.571428571428,36972.571428571428,null,36972.571428571428,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1494748.1578705069]
[null,null,null,null,null,null,null,null,null,null,null,"Eagle Field WD",null,1523.8571428571429,1523.8571428571429,1523.8571428571429,null,1523.8571428571429]
[null,null,null,null,null,null,null,null,null,null,null,"Mercy Springs WD",null,970.14285714285711,970.14285714285711,970.14285714285711,null,970.14285714285711,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"San Luis WD Canalside Relift PP",null,11280163.671969457]
[null,null,null,null,null,null,null,null,null,null,null,"Oro Loma WD",null,31.571428571428573,31.571428571428573,31.571428571428573,null,31.571428571428573]
[null,null,null,null,null,null,null,null,null,null,null,"Pacheco WD - DMC",null,142.85714285714286,142.85714285714286,142.85714285714286,null,142.85714285714286]
[null,null,null,null,null,null,null,null,null,null,null,"Panoche WD - DMC",null,6851.5714285714284,6851.5714285714284,6851.5714285714284,null,6851.5714285714284,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Santa Clara Valley WD"]
[null,null,null,null,null,null,null,null,null,null,null,"Patterson WD",null,5645.7142857142853,5645.7142857142853,5645.7142857142853,null,5645.7142857142853,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coyote PP",165006.54888763238]
[null,null,null,null,null,null,null,null,null,null,null,"San Luis WD - DMC",null,5594.5714285714284,5594.5714285714284,5594.5714285714284,null,5594.5714285714284,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gianelli, WR PGP",887204.08474908397]
[null,null,null,null,null,null,null,null,null,null,null,"West Side ID",null,297.42857142857144,297.42857142857144,297.42857142857144,null,297.42857142857144,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pacheco PP",573294.97206224699]
[null,null,null,null,null,null,null,null,null,null,null,"West Stanislaus ID",null,10252.857142857143,10252.857142857143,10252.857142857143,null,10252.857142857143,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1625505.6056989632]
[null,null,null,null,null,null,null,null,null,null,null,"     Total Delta-Mendota Canal",null,77406.428571428565,77406.428571428565,77406.428571428565,null,77406.428571428565]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"State Delta PP (CVC Contractors)",null,2998092.8096061298]
[null,null,null,null,null,null,null,null,null,null,"Delta-Mendota Pool",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Westlands WD"]
[null,null,null,null,null,null,null,null,null,null," ","Coelho Trust",null,642,642,642,null,642,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pleasant Valley Canalside Relifts",1373192.2632780767]
[null,null,null,null,null,null,null,null,null,null,null,"Fresno Slough WD",null,1322.1428571428571,1322.1428571428571,1322.1428571428571,null,1322.1428571428571,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pleasant Valley PP",12742514.08831995]
[null,null,null,null,null,null,null,null,null,null,null,"James ID",null,11862.714285714286,11862.714285714286,11862.714285714286,null,11862.714285714286,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Westlands WD Canalside Relifts",44913719.330624796]
[null,null,null,null,null,null,null,null,null,null,null,"Laguna WD",null,165.71428571428572,165.71428571428572,165.71428571428572,null,165.71428571428572,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59029425.682222821]
[null,null,null,null,null,null,null,null,null,null,null,"Recl Dist #1606",null,46.142857142857146,46.142857142857146,46.142857142857146,null,46.142857142857146]
[null,null,null,null,null,null,null,null,null,null,null,"Tranquillity ID",null,3386.8571428571427,3386.8571428571427,3386.8571428571427,null,3386.8571428571427]
[null,null,null,null,null,null,null,null,null,null,null,"Tranquillity PUD",null,10,10,10,null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Westside WD Canalside Relifts",null,6964451.8677616343]
[null,null,null,null,null,null,null,null,null,null,null,"Westlands WD - DMP",null,3571.4285714285716,3571.4285714285716,3571.4285714285716,null,3571.4285714285716,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Direct Pumping",112237758.35373026]
[null,null,null,null,null,null,null,null,null,null,null,"     Total Delta-Mendota Pool",null,21007,21007,21007,null,21007]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"San Luis Drain    3/"]
[null,null,null,null,null,null,null,null,null,null,"Friant Dam - Class 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Panoche WD",null,2580614.0843329001]
[null,null,null,null,null,null,null,null,null,null,null,"Gravelly Ford WD",null,0,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"San Luis WD",null,3624435.9362772801]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Westlands WD ",null,46176501.899389803]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total San Luis Drain",52381551.919999987]
[null,null,null,null,null,null,null,null,null,null,"Friant-Kern Canal - Class 1"]
[null,null,null,null,null,null,null,null,null,null,null,"Arvin-Edison WSD",null,23284.285714285714,23284.285714285714,23284.285714285714,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub-total",null,1090095860.9999998]
[null,null,null,null,null,null,null,null,null,null,null,"Delano-Earlimart ID",null,71332.571428571435,71332.571428571435,71332.571428571435]
[null,null,null,null,null,null,null,null,null,null,null,"Exeter ID",null,7031.2857142857147,7031.2857142857147,7031.2857142857147,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Costs"]
[null,null,null,null,null,null,null,null,null,null,null,"Garfield WD",null,1560.2857142857142,1560.2857142857142,1560.2857142857142,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Programmatic EIS Capitalized   4/",null,13902414.289501501]
[null,null,null,null,null,null,null,null,null,null,null,"Hills Valley ID",null,778.85714285714289,778.85714285714289,778.85714285714289,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All Others",null,50728059.490000002]
[null,null,null,null,null,null,null,null,null,null,null,"International WD",null,645.71428571428567,645.71428571428567,645.71428571428567,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Other Costs",64630473.779501505]
[null,null,null,null,null,null,null,null,null,null,null,"Ivanhoe ID",null,4089,4089,4089]
[null,null,null,null,null,null,null,null,null,null,null,"Kaweah Delta WCD",null,622.28571428571433,622.28571428571433,622.28571428571433,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand Total     5/",null,1154726334.7795012]
[null,null,null,null,null,null,null,null,null,null,null,"Lewis Creek WD",null,617.71428571428567,617.71428571428567,617.71428571428567]
[null,null,null,null,null,null,null,null,null,null,null,"Lindmore ID",null,20415,20415,20415]
[null,null,null,null,null,null,null,null,null,null,null,"Lindsay-Strathmore ID",null,17050.571428571428,17050.571428571428,17050.571428571428]
[null,null,null,null,null,null,null,null,null,null,null,"Lower Tule River ID - FKC",null,40123.714285714283,40123.714285714283,40123.714285714283]
[null,null,null,null,null,null,null,null,null,null,null,"Orange Cove ID",null,26313.857142857141,26313.857142857141,26313.857142857141]
[null,null,null,null,null,null,null,null,null,null,null,"Porterville ID",null,9671.8571428571431,9671.8571428571431,9671.8571428571431]
[null,null,null,null,null,null,null,null,null,null,null,"Saucelito ID",null,12473.571428571429,12473.571428571429,12473.571428571429]
[null,null,null,null,null,null,null,null,null,null,null,"Shafter-Wasco ID",null,31445,31445,31445]
[null,null,null,null,null,null,null,null,null,null,null,"So San Joaquin MUD",null,61718.57,61718.57,61718.57]
[null,null,null,null,null,null,null,null,null,null,null,"Stone Corral ID",null,6137.57,6137.57,6137.57]
[null,null,null,null,null,null,null,null,null,null,null,"Tea Pot Dome WD",null,4502.8599999999997,4502.8599999999997,4502.8599999999997]
[null,null,null,null,null,null,null,null,null,null,null,"Terra Bella ID",null,16220.86,16220.86,16220.86]
[null,null,null,null,null,null,null,null,null,null,null,"Tri-Valley ID",null,215.57142857142858,215.57142857142858,215.57142857142858]
[null,null,null,null,null,null,null,null,null,null,null,"Tulare ID",null,19728,19728,19728]
[null,null,null,null,null,null,null,null,null,null,null,"     Total Friant-Kern Canal - Class 1",null,375979.00285714277,375979.00285714277,375979.00285714277]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Friant-Kern Canal - Class 2"]
[null,null,null,null,null,null,null,null,null,null,null,"Arvin-Edison WSD",null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"Delano-Earlimart ID",null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"Exeter ID",null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"Fresno ID",null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"Ivanhoe ID",null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"Kaweah Delta WCD",null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"Kern-Tulare ID",null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"Lindmore ID",null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"Lower Tule River ID - FKC",null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"Porterville ID",null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"Saucelito ID",null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"Shafter-Wasco ID",null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"So San Joaquin MUD",null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"Tulare ID",null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"     Total Friant-Kern Canal - Class 2",null,0,null,0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Hidden Unit"]
[null,null,null,null,null,null,null,null,null,null,null,"Madera ID - HU",null,24000,24000]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Madera Canal - Class 1"]
[null,null,null,null,null,null,null,null,null,null,null,"Chowchilla WD - MC",null,35840.142857142855,35840.142857142855,35840.142857142855]
[null,null,null,null,null,null,null,null,null,null,null,"Madera ID - MC",null,55867,55867,55867]
[null,null,null,null,null,null,null,null,null,null,null,"     Total Madera Canal - Class 1",null,91707.142857142855,91707.142857142855,91707.142857142855]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Madera Canal - Class 2"]
[null,null,null,null,null,null,null,null,null,null,null,"Chowchilla WD - MC",null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"Madera ID - MC",null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"     Total Madera Canal - Class 2",null,0,null,0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"New Melones D & R"]
[null,null,null,null,null,null,null,null,null,null,null,"Central San Joaquin WCD",null,15626,15626]
[null,null,null,null,null,null,null,null,null,null,null,"Stockton-East WD",null,5603.4285714285716,5603.4285714285716]
[null,null,null,null,null,null,null,null,null,null,null,"     Total New Melones D & R",null,21229.428571428572,21229.428571428572]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Sacramento River - Shasta"]
[null,null,null,null,null,null,null,null,null,null,null,"Anderson-Cottonwood ID",null,2490.7142857142858,2490.7142857142858]
[null,null,null,null,null,null,null,null,null,null,null,"Daniell, H & B",null,1,1]
[null,null,null,null,null,null,null,null,null,null,null,"Driscoll Strawberry",null,70,70]
[null,null,null,null,null,null,null,null,null,null,null,"Gjermann, H",null,3.1428571428571428,3.1428571428571428]
[null,null,null,null,null,null,null,null,null,null,null,"Leviathan Inc",null,254.28571428571428,254.28571428571428]
[null,null,null,null,null,null,null,null,null,null,null,"Redding Rancheria ",null,19.285714285714285,19.285714285714285]
[null,null,null,null,null,null,null,null,null,null,null,"     Total Sacramento River - Shasta",null,2838.4285714285716,2838.4285714285716]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Sacramento River - Willows"]
[null,null,null,null,null,null,null,null,null,null,null,"Anderson, A/et al",null,6.4285714285714288,6.4285714285714288]
[null,null,null,null,null,null,null,null,null,null,null,"Anderson, R & J",null,26,26]
[null,null,null,null,null,null,null,null,null,null,null,"Andreotti, A/et al",null,1037.2857142857142,1037.2857142857142]
[null,null,null,null,null,null,null,null,null,null,null,"B & D Family Partnership",null,22.285714285714285,22.285714285714285]
[null,null,null,null,null,null,null,null,null,null,null,"Baber, J/et al",null,2350.4285714285716,2350.4285714285716]
[null,null,null,null,null,null,null,null,null,null,null,"Butler, Diane",null,227.85714285714286,227.85714285714286]
[null,null,null,null,null,null,null,null,null,null,null,"Butte Creek Farms Inc",null,353.42857142857144,353.42857142857144]
[null,null,null,null,null,null,null,null,null,null,null,"Byrd, A & Osborne, J.",null,138.42857142857142,138.42857142857142]
[null,null,null,null,null,null,null,null,null,null,null,"Cachil Dehe Band of Wintun",null,82.142857142857139,82.142857142857139]
[null,null,null,null,null,null,null,null,null,null,null,"Carter MWC",null,440.42857142857144,440.42857142857144]
[null,null,null,null,null,null,null,null,null,null,null,"Charter, Mary",null,114.14285714285714,114.14285714285714]
[null,null,null,null,null,null,null,null,null,null,null,"Churkin, M Jr & C",null,45.428571428571431,45.428571428571431]
[null,null,null,null,null,null,null,null,null,null,null,"Conaway Consv Grp",null,396.57142857142856,396.57142857142856]
[null,null,null,null,null,null,null,null,null,null,null,"County of Sacramento",null,32.857142857142854,32.857142857142854]
[null,null,null,null,null,null,null,null,null,null,null,"Cummings, W",null,94.714285714285708,94.714285714285708]
[null,null,null,null,null,null,null,null,null,null,null,"Driver, Gary/et al",null,3.1428571428571428,3.1428571428571428]
[null,null,null,null,null,null,null,null,null,null,null,"Driver, J & C Trustees",null,49,49]
[null,null,null,null,null,null,null,null,null,null,null,"Driver, Gregory",null,2,2]
[null,null,null,null,null,null,null,null,null,null,null,"Driver, W/et al",null,15.142857142857142,15.142857142857142]
[null,null,null,null,null,null,null,null,null,null,null,"Dyer, J & Wing, J",null,192,192]
[null,null,null,null,null,null,null,null,null,null,null,"Eastside MWC",null,430.71428571428572,430.71428571428572]
[null,null,null,null,null,null,null,null,null,null,null,"Ehrke, A & B",null,119.14285714285714,119.14285714285714]
[null,null,null,null,null,null,null,null,null,null,null,"Empire Group, LLC",null,2.2857142857142856,2.2857142857142856]
[null,null,null,null,null,null,null,null,null,null,null,"Feather WD",null,2676.4285714285716,2676.4285714285716]
[null,null,null,null,null,null,null,null,null,null,null,"Fedora, S/Taylor, W",null,2.8571428571428572,2.8571428571428572]
[null,null,null,null,null,null,null,null,null,null,null,"Four Corners Farmland",null,39.285714285714285,39.285714285714285]
[null,null,null,null,null,null,null,null,null,null,null,"Gillaspy, W",null,64.857142857142861,64.857142857142861]
[null,null,null,null,null,null,null,null,null,null,null,"Giusti, R & S",null,374.14285714285717,374.14285714285717]
[null,null,null,null,null,null,null,null,null,null,null,"Glenn-Colusa ID",null,70036.571428571435,70036.571428571435]
[null,null,null,null,null,null,null,null,null,null,null,"Green Valley Corp",null,141.14285714285714,141.14285714285714]
[null,null,null,null,null,null,null,null,null,null,null,"Griffin, J/Prater",null,751.57142857142856,751.57142857142856]
[null,null,null,null,null,null,null,null,null,null,null,"Hale, J/Marks, A",null,4.2857142857142856,4.2857142857142856]
[null,null,null,null,null,null,null,null,null,null,null,"Hatfield, R & B",null,13.428571428571429,13.428571428571429]
[null,null,null,null,null,null,null,null,null,null,null,"Heidrick & McGinnis Properties",null,28.571428571428573,28.571428571428573]
[null,null,null,null,null,null,null,null,null,null,null,"Heidrick, M",null,39.714285714285715,39.714285714285715]
[null,null,null,null,null,null,null,null,null,null,null,"Howald Farms Inc",null,941.42857142857144,941.42857142857144]
[null,null,null,null,null,null,null,null,null,null,null,"Jaeger, W & P",null,69.285714285714292,69.285714285714292]
[null,null,null,null,null,null,null,null,null,null,null,"Jansen, P & S",null,37,37]
[null,null,null,null,null,null,null,null,null,null,null,"Kary, C",null,85.714285714285708,85.714285714285708]
[null,null,null,null,null,null,null,null,null,null,null,"King, Ben ",null,1,1]
[null,null,null,null,null,null,null,null,null,null,null,"King, L",null,1.8571428571428572,1.8571428571428572]
[null,null,null,null,null,null,null,null,null,null,null,"KLSY, LLC",null,48.285714285714285,48.285714285714285]
[null,null,null,null,null,null,null,null,null,null,null,"Knights Landing Investors",null,592.85714285714289,592.85714285714289]
[null,null,null,null,null,null,null,null,null,null,null,"Knights Landing Properties ",null,16.428571428571427,16.428571428571427]
[null,null,null,null,null,null,null,null,null,null,null,"L C Dennis Company",null,235.71428571428572,235.71428571428572]
[null,null,null,null,null,null,null,null,null,null,null,"Lauppe, Joan Johnson, & Warren Lauppe",null,2,2]
[null,null,null,null,null,null,null,null,null,null,null,"Lauppe, B ET UX",null,85.714285714285708,85.714285714285708]
[null,null,null,null,null,null,null,null,null,null,null,"Lauppe, B & K",null,90,90]
[null,null,null,null,null,null,null,null,null,null,null,"Leonard, James",null,4.2857142857142856,4.2857142857142856]
[null,null,null,null,null,null,null,null,null,null,null,"Lockett, W & J",null,44.857142857142854,44.857142857142854]
[null,null,null,null,null,null,null,null,null,null,null,"Lomo CS & Micheli, J",null,375,375]
[null,null,null,null,null,null,null,null,null,null,null,"Lonon, M",null,411.14285714285717,411.14285714285717]
[null,null,null,null,null,null,null,null,null,null,null,"M C M Properties",null,452.71428571428572,452.71428571428572]
[null,null,null,null,null,null,null,null,null,null,null,"Maxwell ID",null,4141,4141]
[null,null,null,null,null,null,null,null,null,null,null,"McClatchy Partners ",null,24.571428571428573,24.571428571428573]
[null,null,null,null,null,null,null,null,null,null,null,"Meridian Farms WC",null,7483.1428571428569,7483.1428571428569]
[null,null,null,null,null,null,null,null,null,null,null,"Micke, D & N",null,2.7142857142857144,2.7142857142857144]
[null,null,null,null,null,null,null,null,null,null,null,"Morehead, J/et ux",null,60,60]
[null,null,null,null,null,null,null,null,null,null,null,"Munson, J & D",null,22.285714285714285,22.285714285714285]
[null,null,null,null,null,null,null,null,null,null,null,"Natomas Basin Conserv",null,80.428571428571431,80.428571428571431]
[null,null,null,null,null,null,null,null,null,null,null,"Natomas Central MWC",null,17340.285714285714,17340.285714285714]
[null,null,null,null,null,null,null,null,null,null,null,"Nelson, Henry E",null,80.571428571428569,80.571428571428569]
[null,null,null,null,null,null,null,null,null,null,null,"O'Brien, J & F",null,200.14285714285714,200.14285714285714]
[null,null,null,null,null,null,null,null,null,null,null,"Odysseus Farms ",null,263.71428571428572,263.71428571428572]
[null,null,null,null,null,null,null,null,null,null,null,"Oji Brothers Farm Inc",null,1297.1428571428571,1297.1428571428571]
[null,null,null,null,null,null,null,null,null,null,null,"Oji, M/et al",null,785.42857142857144,785.42857142857144]
[null,null,null,null,null,null,null,null,null,null,null,"Pacific Realty Inc",null,918.57142857142856,918.57142857142856]
[null,null,null,null,null,null,null,null,null,null,null,"Pelger MWC",null,1339.2857142857142,1339.2857142857142]
[null,null,null,null,null,null,null,null,null,null,null,"Pelger Road 1700, LLC",null,1485.4285714285713,1485.4285714285713]
[null,null,null,null,null,null,null,null,null,null,null,"Penner, R & L",null,3,3]
[null,null,null,null,null,null,null,null,null,null," ","Pleasant Grv-Vrna MWC",null,1771.5714285714287,1771.5714285714287]
[null,null,null,null,null,null,null,null,null,null,null,"Princeton-Codora-Glenn ID",null,10367.285714285714,10367.285714285714]
[null,null,null,null,null,null,null,null,null,null,null,"Provident ID",null,2989.7142857142858,2989.7142857142858]
[null,null,null,null,null,null,null,null,null,null,null,"Quad-H-Ranches Inc",null,174.57142857142858,174.57142857142858]
[null,null,null,null,null,null,null,null,null,null,null,"Recl Dist # 108",null,22114.714285714286,22114.714285714286]
[null,null,null,null,null,null,null,null,null,null,null,"Recl Dist #1000",null,17.571428571428573,17.571428571428573]
[null,null,null,null,null,null,null,null,null,null,null,"Recl Dist #1004",null,8756.2857142857138,8756.2857142857138]
[null,null,null,null,null,null,null,null,null,null,null,"Reische, E",null,11.285714285714286,11.285714285714286]
[null,null,null,null,null,null,null,null,null,null,null,"Reische, L",null,57.142857142857146,57.142857142857146]
[null,null,null,null,null,null,null,null,null,null,null,"Richter, H Jr/et al",null,598.71428571428567,598.71428571428567]
[null,null,null,null,null,null,null,null,null,null,null,"River Garden Farms Co",null,291.57142857142856,291.57142857142856]
[null,null,null,null,null,null,null,null,null,null,null,"Roberts Ditch Irr Co",null,257.14285714285717,257.14285714285717]
[null,null,null,null,null,null,null,null,null,null,null,"Rubio, E & E",null,3,3]
[null,null,null,null,null,null,null,null,null,null,null,"Saeed, F",null,380.71428571428572,380.71428571428572]
[null,null,null,null,null,null,null,null,null,null,null,"Seaver, C",null,38.571428571428569,38.571428571428569]
[null,null,null,null,null,null,null,null,null,null,null,"Sutter MWC",null,37659,37659]
[null,null,null,null,null,null,null,null,null,null,null,"Swenson Farms",null,324.14285714285717,324.14285714285717]
[null,null,null,null,null,null,null,null,null,null,null,"Sycamore Mutual Water Company",null,7178.8571428571431,7178.8571428571431]
[null,null,null,null,null,null,null,null,null,null,null,"T & P Farms",null,100.85714285714286,100.85714285714286]
[null,null,null,null,null,null,null,null,null,null,null,"Tarke, S",null,561.14285714285711,561.14285714285711]
[null,null,null,null,null,null,null,null,null,null,null,"Tisdale Irr & Drain Co",null,1617,1617]
[null,null,null,null,null,null,null,null,null,null,null,"Van Ruiten Brothers 1415L",null,119.28571428571429,119.28571428571429]
[null,null,null,null,null,null,null,null,null,null,null,"Van Ruiten Brothers 520XL",null,104.85714285714286,104.85714285714286]
[null,null,null,null,null,null,null,null,null,null,null,"Van Ruiten Brothers 0880S",null,293.42857142857144,293.42857142857144]
[null,null,null,null,null,null,null,null,null,null,null,"Van Ruiten Brothers 880XR",null,156,156]
[null,null,null,null,null,null,null,null,null,null,null,"Wallace, J & J",null,10.142857142857142,10.142857142857142]
[null,null,null,null,null,null,null,null,null,null,null,"Wallace, K Trust",null,156,156]
[null,null,null,null,null,null,null,null,null,null,null,"Wisler, J",null,3.8571428571428572,3.8571428571428572]
[null,null,null,null,null,null,null,null,null,null,null,"Yockey, W",null,1.8571428571428572,1.8571428571428572]
[null,null,null,null,null,null,null,null,null,null,null,"Young, R/et al",null,3.7142857142857144,3.7142857142857144]
[null,null,null,null,null,null,null,null,null,null,null,"Total Sacramento River - Willows",null,215497.71428571426,215497.71428571426]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"San Felipe Unit "]
[null,null,null,null,null,null,null,null,null,null,null,"San Benito County WD",null,8814.1428571428569,8814.1428571428569,8814.1428571428569,null,8814.1428571428569,8814.1428571428569]
[null,null,null,null,null,null,null,null,null,null,null,"Santa Clara Valley WD",null,12212.714285714286,12212.714285714286,12212.714285714286,null,12212.714285714286,12212.714285714286]
[null,null,null,null,null,null,null,null,null,null,null,"     Total San Felipe Unit",null,21026.857142857145,21026.857142857145,21026.857142857145,null,21026.857142857145,21026.857142857145]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"San Luis Canal - Fresno"]
[null,null,null,null,null,null,null,null,null,null,null,"Westlands WD - SLC",null,399746,399746,399746,null,399746,399746,399746]
[null,null,null,null,null,null,null,null,null,null,null,"Westlands WD--SLC  (DD#2)",null,899.71428571428567,899.71428571428567,899.71428571428567,null,899.71428571428567,899.71428571428567,899.71428571428567]
[null,null,null,null,null,null,null,null,null,null,null,"     Total San Luis Canal-Fresno",null,400645.71428571426,400645.71428571426,400645.71428571426,null,400645.71428571426,400645.71428571426,400645.71428571426]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"San Luis Canal - Tracy"]
[null,null,null,null,null,null,null,null,null,null,null,"Pacheco WD - SLC",null,3198.1428571428573,3198.1428571428573,3198.1428571428573,null,3198.1428571428573,3198.1428571428573,3198.1428571428573]
[null,null,null,null,null,null,null,null,null,null,null,"Panoche WD - SLC",null,18367.428571428572,18367.428571428572,18367.428571428572,null,18367.428571428572,18367.428571428572,18367.428571428572]
[null,null,null,null,null,null,null,null,null,null,null,"San Luis WD - SLC   3/",null,29434.285714285714,29434.285714285714,29434.285714285714,null,29434.285714285714,29434.285714285714,27320.891072706316]
[null,null,null,null,null,null,null,null,null,null,null,"     Total San Luis Canal - Tracy",null,50999.857142857145,50999.857142857145,50999.857142857145,null,50999.857142857145,50999.857142857145,48886.462501277747]
[null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,null,null,null,null,null,null,null,null,"Tehama-Colusa Canal"]
[null,null,null,null,null,null,null,null,null,null,null,"4-M WD",null,1429.8571428571429,1429.8571428571429,1429.8571428571429]
[null,null,null,null,null,null,null,null,null,null,null,"Colusa County WD",null,23661.857142857141,23661.857142857141,23661.857142857141]
[null,null,null,null,null,null,null,null,null,null,null,"Cortina WD",null,725.28571428571433,725.28571428571433,725.28571428571433]
[null,null,null,null,null,null,null,null,null,null,null,"Davis WD - TCC",null,2722.5714285714284,2722.5714285714284,2722.5714285714284]
[null,null,null,null,null,null,null,null,null,null,null,"Dunnigan WD",null,6186.2857142857147,6186.2857142857147,6186.2857142857147]
[null,null,null,null,null,null,null,null,null,null,null,"Glenn Valley WD",null,963.57142857142856,963.57142857142856,963.57142857142856]
[null,null,null,null,null,null,null,null,null,null,null,"Glide WD",null,4689.1428571428569,4689.1428571428569,4689.1428571428569]
[null,null,null,null,null,null,null,null,null,null,null,"Holthouse WD",null,251.85714285714286,251.85714285714286,251.85714285714286]
[null,null,null,null,null,null,null,null,null,null,null,"Kanawha WD",null,19964.571428571428,19964.571428571428,19964.571428571428]
[null,null,null,null,null,null,null,null,null,null,null,"Kirkwood WD",null,300,300,300]
[null,null,null,null,null,null,null,null,null,null,null,"La Grande WD",null,2868,2868,2868]
[null,null,null,null,null,null,null,null,null,null,null,"Myers-Marsh MWC",null,29.857142857142858,29.857142857142858,29.857142857142858]
[null,null,null,null,null,null,null,null,null,null,null,"Orland-Artois WD",null,17550.714285714286,17550.714285714286,17550.714285714286]
[null,null,null,null,null,null,null,null,null,null,null,"Westside WD",null,29097.857142857141,29097.857142857141,29097.857142857141]
[null,null,null,null,null,null,null,null,null,null,null,"     Total Tehama-Colusa Canal",null,110441.42857142857,110441.42857142857,110441.42857142857]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Subtotal",null,1459411.7171428564,1459411.7171428564,1158469.8599999994,5423.2857142857138,571085.85714285704,472672.42857142858,462751.74821556342]

{"sheet":"OUTPUT","index":2,"n_rows":66,"n_cols":10,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"INFORMATION!A1","v":"Special Rates 2023 Sch S-1.Z25.XLSM"}]
[{"$f":"INFORMATION!A2","v":"01/04/2023"}]
[{"$f":"INFORMATION!A3","v":"CENTRAL VALLEY PROJECT"}]
[{"$f":"INFORMATION!A4","v":"SCHEDULE OF IRRIGATION UNPAID CONSTRUCTION COSTS BY COMPONENT AND/OR FACILITY"}]
[{"$f":"INFORMATION!A5","v":"AS OF SEPTEMBER 30, 2021"}]
[{"$f":"INFORMATION!A6","v":"2023 SPECIAL WATER RATES"}]
["Category","A) Component/Facility","Related Footnotes","B) Net Construction Costs at 9/30/2021\n<Sch A-4>","C) Ratio of Total\n<B/$1,154,726,335>","D) Cumulative Construction Repayment at 9/30/2021   1/\n<C*$1,045,413,672>","E) Unpaid Construction: Net Unpaid Construction at 9/30/2021\n<B-D>","F) Unpaid Construction: Annualized Costs 8 Remaining Years\n<E/8>","G) Unpaid Construction: FY 2023 Projected Deliveries\n <Sch S-5>","H) Unpaid Construction: Unpaid Construction Cost Per Acre Foot\n<F/G>"]
["Storage","San Felipe Unit Contractors","-",{"$f":"MACRO_INPUT!AI18","v":2819259.0976596707},{"$f":"D9/$D$64","v":2.4998511023801217E-3},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E9,15)","v":2613378.52039245},{"$f":"D9-F9","v":205880.57726722071},{"$f":"G9/8","v":25735.072158402589},{"$f":"MACRO_INPUT!N266","v":21026.857142857145},{"$f":"ROUND(H9/I9,2)","v":1.22}]
["Storage","All Other Contractors","-",{"$f":"MACRO_INPUT!AI19","v":342433451.99267137},{"$f":"D10/$D$64","v":0.3036374496995759},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E10,15)","v":317426741.24714899},{"$f":"D10-F10","v":25006710.74552238},{"$f":"G10/8","v":3125838.8431902975},{"$f":"+MACRO_INPUT!O299-I9","v":1438384.8599999994},{"$f":"ROUND(H10/I10,2)","v":2.17}]
["Total","Total Storage","-",{"$f":"SUM(D9:D10)","v":345252711.09033102},{"$f":"SUM(E9:E10)","v":0.306137300801956},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E11,15)","v":320040119.76754099},{"$f":"SUM(G9:G10)","v":25212591.322789602},3151573.9153487002,"-","-"]
["Conveyance","Contra Costa WD","-",{"$f":"MACRO_INPUT!AI23","v":0},{"$f":"D12/$D$64","v":0},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E12,15)","v":0},{"$f":"D12-F12","v":0},0,"-",0]
["Conveyance","All Other Contractors","-",{"$f":"MACRO_INPUT!AI24","v":377317187.61000001},{"$f":"D13/$D$64","v":0.33456903204704647},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E13,15)","v":349763040.32978898},{"$f":"D13-F13","v":27554147.280211031},3444268.4100263789,{"$f":"MACRO_INPUT!P299","v":1158469.8599999994},{"$f":"ROUND(H13/I13,2)","v":2.97}]
["Total","Total Conveyance","-",{"$f":"SUM(D12:D13)","v":377317187.61000001},{"$f":"SUM(E12:E13)","v":0.33456903204704647},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E14,15)","v":349763040.32978898},{"$f":"SUM(G12:G13)","v":27554147.280211031},3444268.4100263789,"-","-"]
["Conveyance Pumping","Corning Pumping Plant, Construction only","-",{"$f":"MACRO_INPUT!AI28-MACRO_INPUT!G12-MACRO_INPUT!I12","v":2513027.13},{"$f":"D15/$D$64","v":2.2283136893862083E-3},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E15,15)","v":2329509.5963891},{"$f":"D15-F15","v":183517.53361089993},22939.691701362492,{"$f":"MACRO_INPUT!Q33","v":5423.2857142857138},{"$f":"IF(I15<>0,(ROUND(H15/I15,2)),0)","v":4.2300000000000004}]
["Conveyance Pumping","Corning Pumping Plant, PUE only","-",{"$f":"MACRO_INPUT!G12+MACRO_INPUT!I12","v":295317.400713493},{"$f":"D16/$D$64","v":2.6185941204853958E-4},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E16,15)","v":273751.40949742502},{"$f":"D16-F16","v":21565.991216067981},2695.7489020084977,{"$f":"MACRO_INPUT!Q33","v":5423.2857142857138},{"$f":"IF(I16<>0,(ROUND(H16/I16,2)),0)","v":0.5}]
["Total","Corning Pumping Plant","-","-","-",{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E17,15)","v":0},"-",0,"-",{"$f":"SUM(J15:J16)","v":4.7300000000000004}]
["Conveyance Pumping","Dos Amigos Pumping Plant, Construction only","-",{"$f":"MACRO_INPUT!AI30","v":13497147.380790524},{"$f":"D18/$D$64","v":1.1967987896843252E-2},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E18,15)","v":12511498.1736905},{"$f":"D18-F18","v":985649.20710002445},123206.15088750306,{"$f":"MACRO_INPUT!T299-MACRO_INPUT!T48","v":449532.176786992},{"$f":"IF(I18<>0,(ROUND(H18/I18,2)),0)","v":0.27}]
["Conveyance Pumping","Dos Amigos Pumping Plant, PUE only","-",{"$f":"MACRO_INPUT!AI31","v":24138808.91059548},{"$f":"D19/$D$64","v":2.1404002248458693E-2},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E19,15)","v":22376036.586057499},{"$f":"D19-F19","v":1762772.3245379813},220346.54056724766,{"$f":"MACRO_INPUT!T299","v":462751.74821556342},{"$f":"IF(I19<>0,(ROUND(H19/I19,2)),0)","v":0.48}]
["Total","Dos Amigos Pumping Plant","-","-","-",{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E20,15)","v":0},"-",0,"-",{"$f":"SUM(J18:J19)","v":0.75}]
["Conveyance Pumping","O'Neill Pump-Generator Plant, Construction only","-",{"$f":"MACRO_INPUT!AI32-MACRO_INPUT!G15-MACRO_INPUT!I15","v":10379044.775},{"$f":"D21/$D$64","v":9.2031507653818675E-3},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E21,15)","v":9621099.6356074698},{"$f":"D21-F21","v":757945.13939253055},94743.142424066318,{"$f":"MACRO_INPUT!S299","v":472672.42857142858},{"$f":"IF(I21<>0,(ROUND(H21/I21,2)),0)","v":0.2}]
["Conveyance Pumping","O'Neill Pump-Generator Plant, PUE only","-",{"$f":"MACRO_INPUT!G15+MACRO_INPUT!I15","v":10620801.83699012},{"$f":"D22/$D$64","v":9.4175179579630217E-3},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E22,15)","v":9845202.0295600593},{"$f":"D22-F22","v":775599.80743006058},96949.975928757573,{"$f":"+I21","v":472672.42857142858},{"$f":"IF(I22<>0,(ROUND(H22/I22,2)),0)","v":0.21}]
["Total","O'Neill Pump-Generator Plant","-","-","-",{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E23,15)","v":0},"-",0,"-",{"$f":"SUM(J21:J22)","v":0.41000000000000003}]
["Conveyance Pumping","Jones Pumping Plant, Delta Mendota Exchange, Construction only","3/",{"$f":"Footnotes!D24-MACRO_INPUT!AA41","v":11761123.809833627},{"$f":"D24/$D$64","v":1.0428647138408867E-2},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E24,15)","v":10902250.298956299},{"$f":"D24-F24","v":858873.51087732799},107359.188859666,{"$f":"MACRO_INPUT!P106+MACRO_INPUT!P134","v":467686.14571428561},{"$f":"IF(I24<>0,(ROUND(H24/I24,2)),0)","v":0.23}]
["Conveyance Pumping","Jones Pumping Plant, Delta Mendota Exchange, PUE only","3/",{"$f":"Footnotes!G24","v":29747435.323375687},{"$f":"D25/$D$64","v":2.6377199260562256E-2},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E25,15)","v":27575084.736060102},{"$f":"D25-F25","v":2172350.5873155855},271543.82341444818,{"$f":"+I24","v":467686.14571428561},{"$f":"IF(I25<>0,(ROUND(H25/I25,2)),0)","v":0.57999999999999996}]
["Total","Jones Pumping Plant","-","-","-",{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E26,15)","v":0},"-",0,"-",{"$f":"SUM(J24:J25)","v":0.80999999999999994}]
["Conveyance Pumping","All Other Contractors, Construction only","3/",{"$f":"Footnotes!D25-MACRO_INPUT!AA42","v":20584241.235166386},{"$f":"D27/$D$64","v":1.8252149362967415E-2},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E27,15)","v":19081046.4874322},{"$f":"D27-F27","v":1503194.7477341853},187899.34346677316,{"$f":"MACRO_INPUT!R299","v":571085.85714285704},{"$f":"IF(I27<>0,(ROUND(H27/I27,2)),0)","v":0.33}]
["Conveyance Pumping","All Other Contractors, PUE only","3/",{"$f":"Footnotes!G25","v":52414177.463473111},{"$f":"D28/$D$64","v":4.6475912561984647E-2},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E28,15)","v":48586554.4109753},{"$f":"D28-F28","v":3827623.0524978116},478452.88156222645,{"$f":"+I27","v":571085.85714285704},{"$f":"IF(I28<>0,(ROUND(H28/I28,2)),0)","v":0.84}]
["Total","All Other Contractors","-","-","-",{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E29,15)","v":0},"-",0,"-",{"$f":"SUM(J27:J28)","v":1.17}]
["Total","Total Conveyance Pumping","-",{"$f":"SUM(D15:D29)","v":175951125.26593843},{"$f":"SUM(E15:E29)","v":0.15601674029400475},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E30,15)","v":163102033.36422601},{"$f":"SUM(G15:G29)","v":12849091.901712475},1606136.4877140594,"-","-"]
["Direct Pumping","Bella Vista WD (Wintu PP)","-",{"$f":"MACRO_INPUT!AI40","v":1288490.8224760031},{"$f":"D31/$D$64","v":1.1425112383771888E-3},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E31,15)","v":1194396.86901316},{"$f":"D31-F31","v":94093.953462843085},11761.744182855386,{"$f":"MACRO_INPUT!N37","v":2851.5714285714284},{"$f":"IF(I31<>0,(ROUND(H31/I31,2)),0)","v":4.12}]
["Direct Pumping","Colusa County WD Relift PP","-",{"$f":"MACRO_INPUT!AI41","v":11997486.526238142},{"$f":"D32/$D$64","v":1.0638231137856056E-2},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E32,15)","v":11121352.2774108},{"$f":"D32-F32","v":876134.24882734194},109516.78110341774,{"$f":"MACRO_INPUT!N284","v":23661.857142857141},{"$f":"IF(I32<>0,(ROUND(H32/I32,2)),0)","v":4.63}]
["Direct Pumping","Colusa Service Area - Cortina","-",{"$f":"MACRO_INPUT!AI42","v":139400.85999999999},{"$f":"D33/$D$64","v":1.2360743779563186E-4},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E33,15)","v":129220.905432443},{"$f":"D33-F33","v":10179.954567556983},1272.4943209446228,{"$f":"MACRO_INPUT!N285","v":725.28571428571433},{"$f":"IF(I33<>0,(ROUND(H33/I33,2)),0)","v":1.75}]
["Direct Pumping","Colusa Service Area - Davis","-",{"$f":"MACRO_INPUT!AI43","v":171721.21},{"$f":"D34/$D$64","v":1.5226605333184916E-4},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E34,15)","v":159181.01393459601},{"$f":"D34-F34","v":12540.196065403987},1567.5245081754983,{"$f":"MACRO_INPUT!N286","v":2722.5714285714284},{"$f":"IF(I34<>0,(ROUND(H34/I34,2)),0)","v":0.57999999999999996}]
["Direct Pumping","Corning WD Relift PP","-",{"$f":"MACRO_INPUT!AI45","v":3236242.2188431425},{"$f":"D35/$D$64","v":2.8695921155525972E-3},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E35,15)","v":2999910.8306620899},{"$f":"D35-F35","v":236331.38818105264},29541.42352263158,{"$f":"MACRO_INPUT!N30","v":5132.1428571428569},{"$f":"IF(I35<>0,(ROUND(H35/I35,2)),0)","v":5.76}]
["Direct Pumping","Dunnigan WD Relift PP","-",{"$f":"MACRO_INPUT!AI46","v":1637766.6962540259},1.4522158975990324E-3,{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E36,15)","v":1518166.3540457799},119600.342208246,14950.04277603075,{"$f":"MACRO_INPUT!N287","v":6186.2857142857147},2.42]
["Direct Pumping","Kanawha WD Relift PP","-",{"$f":"MACRO_INPUT!AI47","v":2820678.8778452361},2.5011100285515296E-3,{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E37,15)","v":2614694.6190240802},205984.25882115588,25748.032352644484,{"$f":"MACRO_INPUT!N291","v":19964.571428571428},1.29]
["Direct Pumping","Orland-Artois WD Relift PP","-",{"$f":"MACRO_INPUT!AI48","v":7339803.6255620085},6.5082404805738596E-3,{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E38,15)","v":6803803.5790557601},536000.04650624841,67000.005813281052,{"$f":"MACRO_INPUT!N295","v":17550.714285714286},3.82]
["Direct Pumping","Panoche WD Relift PP","-",{"$f":"MACRO_INPUT!AI49","v":19786.185374092725},1.7544509250810991E-5,{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E39,15)","v":18341.269839328299},1444.9155347644264,180.6144418455533,{"$f":"MACRO_INPUT!N277","v":18367.428571428572},0.01]
["Direct Pumping","Proberta WD Relift PP","-",{"$f":"MACRO_INPUT!AI50","v":193993.53600810911},1.7201503588196672E-4,{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E40,15)","v":179826.870300579},14166.665707530105,1770.8332134412631,{"$f":"MACRO_INPUT!N31","v":201.42857142857142},8.7899999999999991]
["Direct Pumping","San Benito County WD, Gianelli, WR PGP","-",{"$f":"MACRO_INPUT!AI52","v":941297.94896314305},{"$f":"D41/$D$64","v":8.3465358587900805E-4},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E41,15)","v":872558.270061741},68739.678901402047,8592.4598626752559,"-","-"]
["Direct Pumping","San Benito County WD, Pacheco PP","-",{"$f":"MACRO_INPUT!AI53","v":553450.20890736394},{"$f":"D42/$D$64","v":4.9074706045928594E-4},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E42,15)","v":513033.68649794802},40416.52240941592,5052.06530117699,"-","-"]
["Direct Pumping","Total San Benito County WD","-",{"$f":"SUM(D41:D42)","v":1494748.1578705069},{"$f":"SUM(E41:E42)","v":1.3254006463382941E-3},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E43,15)","v":1385591.9565596899},{"$f":"SUM(G41:G42)","v":109156.20131081797},13644.525163852246,{"$f":"MACRO_INPUT!N264","v":8814.1428571428569},{"$f":"IF(I43<>0,(ROUND(H43/I43,2)),0)","v":1.55}]
["Direct Pumping","San Luis WD Canalside Relift PP","-",{"$f":"MACRO_INPUT!AI56","v":11280163.671969457},{"$f":"D44/$D$64","v":1.0002177385473168E-2},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E44,15)","v":10456412.988542899},{"$f":"D44-F44","v":823750.68342655711},102968.83542831964,{"$f":"MACRO_INPUT!N278","v":29434.285714285714},{"$f":"IF(I44<>0,(ROUND(H44/I44,2)),0)","v":3.5}]
["Direct Pumping","Santa Clara Valley WD, Coyote PP","-",{"$f":"MACRO_INPUT!AI60","v":165006.54888763238},{"$f":"D45/$D$64","v":1.463121298354968E-4},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E45,15)","v":152956.70090946701},{"$f":"D45-F45","v":12049.847978165373},1506.2309972706717,"-","-"]
["Direct Pumping","Santa Clara Valley WD, Gianelli, WR PGP","-",{"$f":"MACRO_INPUT!AI61","v":887204.08474908397},{"$f":"D46/$D$64","v":7.866882866981804E-4},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E46,15)","v":822414.69051653403},{"$f":"D46-F46","v":64789.394232549937},8098.6742790687422,"-","-"]
["Direct Pumping","Santa Clara Valley WD, Pacheco PP","-",{"$f":"MACRO_INPUT!AI62","v":573294.97206224699},{"$f":"D47/$D$64","v":5.0834351092046855E-4},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E47,15)","v":531429.25638873898},{"$f":"D47-F47","v":41865.715673508006},5233.2144591885008,"-","-"]
["Total","Total Santa Clara Valley WD","-",{"$f":"SUM(D45:D47)","v":1625505.6056989632},{"$f":"SUM(E45:E47)","v":1.4413439274541457E-3},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E48,15)","v":1506800.64781474},{"$f":"SUM(G45:G47)","v":118704.95788422332},14838.119735527915,{"$f":"MACRO_INPUT!N265","v":12212.714285714286},{"$f":"IF(I48<>0,(ROUND(H48/I48,2)),0)","v":1.21}]
["Direct Pumping","State Delta PP (CVC Contractors)","-",{"$f":"MACRO_INPUT!AI66","v":2998092.8096061298},{"$f":"D49/$D$64","v":2.6584238466600628E-3},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E49,15)","v":2779152.63526926},{"$f":"D49-F49","v":218940.17433686974},27367.521792108717,{"$f":"MACRO_INPUT!N48","v":13219.571428571428},{"$f":"IF(I49<>0,(ROUND(H49/I49,2)),0)","v":2.0699999999999998}]
["Direct Pumping","Westlands WD, Pleasant Valley Canalside Relifts","-",{"$f":"MACRO_INPUT!AI68","v":1373192.2632780767},{"$f":"D50/$D$64","v":1.2176164283677147E-3},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E50,15)","v":1272912.8614674199},{"$f":"D50-F50","v":100279.40181065677},12534.925226332096,"-","-"]
["Direct Pumping","Westlands WD, Pleasant Valley PP","-",{"$f":"MACRO_INPUT!AI69","v":12742514.08831995},{"$f":"D51/$D$64","v":1.1298850792828474E-2},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E51,15)","v":11811973.0967109},{"$f":"D51-F51","v":930540.99160904996},116317.62395113125,"-","-"]
["Direct Pumping","Westlands WD, Westlands WD Canalside Relifts","-",{"$f":"MACRO_INPUT!AI70","v":44913719.330624796},{"$f":"D52/$D$64","v":3.9825218928568114E-2},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E52,15)","v":41633828.358318299},{"$f":"D52-F52","v":3279890.9723064974},409986.37153831217,"-","-"]
["Total","Total Westlands WD","-",{"$f":"SUM(D50:D52)","v":59029425.682222821},{"$f":"SUM(E50:E52)","v":5.2341686149764304E-2},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E53,15)","v":54718714.316496603},{"$f":"SUM(G50:G52)","v":4310711.3657262046},538838.92071577557,{"$f":"MACRO_INPUT!N272","v":400645.71428571426},{"$f":"IF(I53<>0,(ROUND(H53/I53,2)),0)","v":1.34}]
["Direct Pumping","Westside WD Canalside Relifts","-",{"$f":"MACRO_INPUT!AI74","v":6964451.8677616343},{"$f":"D54/$D$64","v":6.1754142049411922E-3},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E54,15)","v":6455862.4401085302},{"$f":"D54-F54","v":508589.42765310407},63573.678456638008,{"$f":"MACRO_INPUT!N296","v":29097.857142857141},{"$f":"IF(I54<>0,(ROUND(H54/I54,2)),0)","v":2.1800000000000002}]
["Total","Total Direct Pumping","-",{"$f":"SUM(D31:D40,D43,D44,D48,D49,D53,D54)","v":112237758.35373026},{"$f":"SUM(E31:E40,E43,E44,E48,E49,E53,E54)","v":9.9521780095401691E-2},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E55,15)","v":104041429.57351001},{"$f":"SUM(G31:G40,G43,G44,G48,G49,G53,G54)","v":8196328.78021992},1024541.09752749,"-","-"]
["San Luis Drain","Panoche WD","6/",{"$f":"MACRO_INPUT!AI79","v":2580614.0843329001},{"$f":"D56/$D$64","v":2.2882433788694737E-3},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E56,15)","v":2392160.9131336198},{"$f":"D56-F56","v":188453.1711992803},23556.646399910038,{"$f":"MACRO_INPUT!N277","v":18367.428571428572},"-"]
["San Luis Drain","San Luis WD","6/",{"$f":"MACRO_INPUT!AI80","v":3624435.9362772801},{"$f":"D57/$D$64","v":3.2138054208392022E-3},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E57,15)","v":3359756.1260930202},{"$f":"D57-F57","v":264679.8101842599},33084.976273032487,{"$f":"MACRO_INPUT!N278","v":29434.285714285714},"-"]
["San Luis Drain","Westlands WD","6/",{"$f":"MACRO_INPUT!AI81","v":46176501.899389803},{"$f":"D58/$D$64","v":4.0944934530165039E-2},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E58,15)","v":42804394.3569794},{"$f":"D58-F58","v":3372107.5424104035},421513.44280130044,{"$f":"MACRO_INPUT!N270","v":399746},"-"]
["Total","Total San Luis Drain","6/",{"$f":"SUM(D56:D58)","v":52381551.919999987},4.6446983329873716E-2,{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E59,15)","v":48556311.396206103},3825240.5237939437,478155.06547424296,447547.71428571432,{"$f":"IF(I59<>0,(ROUND(H59/I59,2)),0)","v":1.07}]
["Subtotal","Subtotal","-",{"$f":"SUM(D11,D14,D30,D55,D59)","v":1063140334.2399997},{"$f":"SUM(E11,E14,E30,E55,E59)","v":0.9426918365682827},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E60,15)","v":985502934.43127203},{"$f":"SUM(G11,G14,G30,G55,G59)","v":77637399.808726981},9704674.9760908727,"-","-"]
["Other Costs","Programmatic EIS Capitalized","-",{"$f":"MACRO_INPUT!AI87","v":13902414.289501501},{"$f":"D61/SUM($D$64)","v":1.2327340085984122E-2},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E61,15)","v":12887169.8652815},{"$f":"D61-F61","v":1015244.4242200013},126905.55302750017,"-","-"]
["Other Costs","All Others ","-",{"$f":"MACRO_INPUT!AI88","v":50728059.490000002},{"$f":"D62/SUM($D$64)","v":4.4980823345733223E-2},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E62,15)","v":47023567.703446299},{"$f":"D62-F62","v":3704491.7865537032},463061.47331921291,"-","-"]
["Total","Total Other Costs","-",{"$f":"SUM(D61:D62)","v":64630473.779501505},{"$f":"SUM(E61:E62)","v":5.7308163431717345E-2},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E63,15)","v":59910737.568727799},{"$f":"SUM(G61:G62)","v":4719736.2107737046},589967.02634671307,{"$f":"MACRO_INPUT!N299","v":1459411.7171428564},{"$f":"IF(I63<>0,(ROUND(H63/I63,2)),0)","v":0.4}]
["Subtotal","Subtotal","-",{"$f":"D60+D63","v":1127770808.0195012},{"$f":"E60+E63","v":1},{"$f":"ROUND(AdjustedIrrigationConstructionRepayment[Adjusted Irrigation Construction Repayment]*E64,15)","v":1045413672},{"$f":"G60+G63","v":82357136.019500688},10294642.002437586,"-","-"]
["Other Costs","DMC California Aqueduct Intertie","7/",{"$f":"MACRO_INPUT!AI29","v":26955526.760000002},0,{"$f":"D65-G65","v":30515546.604653403},{"$f":"MACRO_INPUT!AD14","v":-3560019.8446534006},{"$f":"G65/(8+33)","v":-86829.752308619529},{"$f":"MACRO_INPUT!N64+MACRO_INPUT!N76+MACRO_INPUT!N266+MACRO_INPUT!N272+MACRO_INPUT!N279","v":571085.85714285716},{"$f":"IF(OR(I65<0, H65<0), 0, (ROUND(H65/I65,2)))","v":0}]
["Total","Total","-",{"$f":"SUM(D64:D65)","v":1154726334.7795012},"-","-","-","-","-","-"]

{"sheet":"Footnotes","index":3,"n_rows":50,"n_cols":19,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"INFORMATION!A1","v":"Special Rates 2023 Sch S-1.Z25.XLSM"}]
[{"$f":"INFORMATION!A2","v":"01/04/2023"}]
[{"$f":"+INFORMATION!A3","v":"CENTRAL VALLEY PROJECT"}]
[{"$f":"+INFORMATION!A4","v":"SCHEDULE OF IRRIGATION UNPAID CONSTRUCTION COSTS BY COMPONENT AND/OR FACILITY"}]
[{"$f":"+INFORMATION!A5","v":"AS OF SEPTEMBER 30, 2021"}]
[{"$f":"+INFORMATION!A6","v":"2023 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 9/30/21 (Column C of A-2Ba)","Construction Repayment per Assignment","Adjusted Irrigation Construction Repayment"]
[1044634527,779145,{"$f":"SUM(A15:B15)","v":1045413672}]
[]
["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 Allocated","Project Use Energy: BOR","Project Use Energy: DOE","Project Use Energy: TOTAL"]
["    Delta-Mendota Exchange",{"$f":"MACRO_INPUT!AA23","v":29157082.487641286},{"$f":"ROUND(B24/B26,15)","v":0.36206002188088998},{"$f":"C24*D32","v":11792287.209833628},{"$f":"MACRO_INPUT!G16*C24","v":16224061.317547495},{"$f":"MACRO_INPUT!I16*C24","v":13523374.005828191},{"$f":"SUM(E24:F24)","v":29747435.323375687}]
["    All Other Contractors",{"$f":"MACRO_INPUT!AA24","v":51373991.714285702},{"$f":"ROUND(B25/B26,15)","v":0.63793997811910996},{"$f":"C25*D32","v":20777691.515166387},{"$f":"MACRO_INPUT!G16*C25","v":28586357.776126605},{"$f":"MACRO_INPUT!I16*C25","v":23827819.687346503},{"$f":"SUM(E25:F25)","v":52414177.463473111}]
["    Total  a/",{"$f":"SUM(B24:B25)","v":80531074.201926991},{"$f":"SUM(C24:C25)","v":1},{"$f":"SUM(D24:D25)","v":32569978.725000016},{"$f":"SUM(E24:E25)","v":44810419.093674101},{"$f":"SUM(F24:F25)","v":37351193.69317469},{"$f":"SUM(E26:F26)","v":82161612.786848783}]
[]
["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"]
[{"$f":"+MACRO_INPUT!E16","v":114731591.51184881},{"$f":"+MACRO_INPUT!G16","v":44810419.093674101},{"$f":"+MACRO_INPUT!I16","v":37351193.693174697},{"$f":"A32-B32-C32","v":32569978.725000016}]
[]
["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, 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/2021",null,null,null,null,null,null,null,null,null,""]
["Panoche WD",{"$f":"MACRO_INPUT!AA35","v":1915445.8571428577},{"$f":"ROUND(B44/B47,9)","v":4.9265705E-2},{"$f":"ROUND(C44*$D$47,9)","v":2580614.0843329001}]
["San Luis WD",{"$f":"MACRO_INPUT!AA36","v":2690216.5714285732},{"$f":"ROUND(B45/B47,9)","v":6.9192984999999999E-2},{"$f":"ROUND(C45*$D$47,9)","v":3624435.9362772801}]
["Westlands WD",{"$f":"MACRO_INPUT!AA37","v":34274241},{"$f":"ROUND(B46/B47,9)","v":0.88154131000000002},{"$f":"ROUND(C46*$D$47,9)","v":46176501.899389803}]
["Total",{"$f":"SUM(B44:B46)","v":38879903.428571433},{"$f":"SUM(C44:C46)","v":1},{"$f":"MACRO_INPUT!AI82","v":52381551.919999987}]
[]
["7/"]
["Payment period is through 2063."]