{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["INFORMATION","Flow Chart","MACRO_INPUT","OUTPUT","Footnotes"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":18,"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":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["Bureau of Reclamation logo"]
["Special Rates 2023 Sch S-5.Z25.XLSM"]
["01/03/2023"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF 2023 PROJECTED IRRIGATION DELIVERIES"]
["BY CONSTRUCTION COST COMPONENT AND CONTRACTOR "]
["2023 SPECIAL WATER RATES"]
["Print Output button","Load Data button","Save File button"]
[]
["SOURCE DATA:"]
[]
["SEE FLOW CHART"]
[]
["10/19/2022","jm","Updated file names, title, headings, and date.\n\nUpdated & ran macros."]
["01/03/2023","KJ","Reviewed"]

{"sheet":"Flow Chart","index":1,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[{"$f":"+INFORMATION!A2","v":"Special Rates 2023 Sch S-5.Z25.XLSM"}]
[{"$f":"+INFORMATION!A3","v":"01/03/2023"}]
[{"$f":"+INFORMATION!A4","v":"CENTRAL VALLEY PROJECT"}]
[{"$f":"+INFORMATION!A5","v":"SCHEDULE OF 2023 PROJECTED IRRIGATION DELIVERIES"}]
[{"$f":"+INFORMATION!A6","v":"BY CONSTRUCTION COST COMPONENT AND CONTRACTOR "}]
[{"$f":"+INFORMATION!A7","v":"2023 SPECIAL WATER RATES"}]

{"sheet":"MACRO_INPUT","index":2,"n_rows":305,"n_cols":13,"rows_kept":305,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,"Data from Schedule A-12 \"Input PUE\" tab"]
["RESERVED FOR MACRO INPUT",null,null,null,null,"San Luis WD"]
[null,null,null,null,null,"Excluded Deliveries (before Dos Amigos PP)"]
[]
[]
[null,null,null,null,null,7.1800439191689908E-2]
[]
[null,null," ",null," "," "," "]
[]
[]
[null,null,null,"(A-12)"]
[null,null,null,"Projected"]
[null,null,null,"Deliveries"]
[]
["Black Butte D & R"]
[null,"4-E WD",null,2.8571428571428572]
[null,"Stony Creek WD",null,153.85714285714286]
[]
[]
[]
["Buchanan Unit"]
[null,"Chowchilla WD - BU",null,24000]
[]
[]
["Clear Creek Unit"]
[null,"Clear Creek CSD",null,981.57142857142856]
[]
[]
["Colusa Basin Drain"]
[null,"Colusa Drain MWC",null,10000]
[]
[]
["Corning Canal"]
[null,"Corning WD",null,5132.1428571428569]
[null,"Proberta WD",null,201.42857142857142]
[null,"Thomes Creek WD",null,89.714285714285708]
[]
[]
[]
["Cow Creek Unit"]
[null,"Bella Vista WD",null,2851.5714285714284]
[]
[]
["Cross Valley Canal"]
[null,"County of Fresno",null,321.42857142857144]
[null,"County of Tulare",null,400.57142857142856]
[null,"Hills Valley ID",null,239]
[null,"Kern-Tulare WD",null,5498.1428571428569]
[null,"Lower Tule River ID - CVC",null,3303.7142857142858]
[null,"Pixley ID",null,3332.2857142857142]
[null,"Tri-Valley WD",null,124.42857142857143]
[]
[]
[]
["Delta-Mendota Canal"]
[null,"Banta-Carbona ID",null,6143]
[null,"Byron Bethany ID",null,2980.2857142857142]
[" ","Del Puerto WD",null,36972.571428571428]
[null,"Eagle Field WD",null,1523.8571428571429]
[null,"Mercy Springs WD",null,970.14285714285711]
[null,"Oro Loma WD",null,31.571428571428573]
[null,"Pacheco WD - DMC",null,142.85714285714286]
[null,"Panoche WD - DMC",null,6851.5714285714284]
[null,"Patterson WD",null,5645.7142857142853]
[null,"San Luis WD - DMC",null,5594.5714285714284]
[null,"West Side ID",null,297.42857142857144]
[null,"West Stanislaus ID",null,10252.857142857143]
[]
[]
[]
["Delta-Mendota Pool"]
[" ","Coelho Trust",null,642]
[null,"Fresno Slough WD",null,1322.1428571428571]
[null,"James ID",null,11862.714285714286]
[null,"Laguna WD",null,165.71428571428572]
[null,"Recl Dist #1606",null,46.142857142857146]
[null,"Tranquillity ID",null,3386.8571428571427]
[null,"Tranquillity PUD",null,10]
[null,"Westlands WD - DMP",null,3571.4285714285716]
[]
[]
[]
["Friant D & R - Class 2"]
[null,"Gravelly Ford WD",null,2000]
[]
[]
["Friant-Kern Canal - Class 1"]
[null,"Arvin-Edison WSD",null,23284.285714285714]
[null,"Delano-Earlimart ID",null,71332.571428571435]
[null,"Exeter ID",null,7031.2857142857147]
[null,"Garfield WD",null,1560.2857142857142]
[null,"Hills Valley ID",null,778.85714285714289]
[null,"International WD",null,645.71428571428567]
[null,"Ivanhoe ID",null,4089]
[null,"Kaweah Delta WCD",null,622.28571428571433]
[null,"Lewis Creek WD",null,617.71428571428567]
[null,"Lindmore ID",null,20415]
[null,"Lindsay-Strathmore ID",null,17050.571428571428]
[null,"Lower Tule River ID - FKC",null,40123.714285714283]
[null,"Orange Cove ID",null,26313.857142857141]
[null,"Porterville ID",null,9671.8571428571431]
[null,"Saucelito ID",null,12473.571428571429]
[null,"Shafter-Wasco ID",null,31445]
[null,"So San Joaquin MUD",null,61718.57]
[null,"Stone Corral ID",null,6137.57]
[null,"Tea Pot Dome WD",null,4502.8599999999997]
[null,"Terra Bella ID",null,16220.86]
[null,"Tri-Valley ID",null,215.57142857142858]
[null,"Tulare ID",null,19728]
[]
[]
[]
["Friant-Kern Canal - Class 2"]
[null,"Arvin-Edison WSD",null,36508]
[null,"Delano-Earlimart ID",null,19387.857142857141]
[null,"Exeter ID",null,3699.8571428571427]
[null,"Fresno ID",null,2803.7142857142858]
[null,"Ivanhoe ID",null,155]
[null,"Kaweah Delta WCD",null,2289.5714285714284]
[null,"Kern-Tulare WD",null,2117]
[null,"Lindmore ID",null,6267]
[null,"Lower Tule River ID - FKC",null,50475]
[null,"Porterville ID",null,6762.3085714285717]
[null,"Saucelito ID",null,5841.4285714285716]
[null,"Shafter-Wasco ID",null,11679.57]
[null,"So San Joaquin MUD",null,14136.43]
[null,"Tulare ID",null,14440]
[]
[]
[]
["Hidden Unit"]
[null,"Madera ID - HU",null,24000]
[]
[]
["Madera Canal - Class 1"]
[null,"Chowchilla WD - MC",null,35840.142857142855]
[null,"Madera ID - MC",null,55867]
[]
[]
[]
["Madera Canal - Class 2"]
[null,"Chowchilla WD - MC",null,17880.428571428572]
[null,"Madera ID - MC",null,13623.857142857143]
[]
[]
[]
["New Melones D & R"]
[null,"Central San Joaquin WCD",null,15626]
[null,"Stockton-East  WD",null,5603.4285714285716]
[]
[]
[]
["Sacramento River - Shasta",null,null,null,null,null,null,"Contract Type"]
[null,"Anderson-Cottonwood ID",null,2490.7142857142858,null,null,null,"District - Std Form"]
[null,"Daniell, H & B",null,1,null,null,null,"Short Form",null,null,null,null,"Short form = Project water AF x cos rate per rate book / irrigated acres = cos rate per contract"]
[null,"Driscoll Strawberry",null,70,null,null,null,"Short Form"]
[null,"Gjermann, H",null,3.1428571428571428,null,null,null,"Short Form"]
[null,"Leviathan Inc",null,254.28571428571428,null,null,null,"Short Form"]
[null,"Redding Rancheria",null,19.285714285714285,null,null,null,"Short Form"]
[]
[]
[]
["Sacramento River - Willows"]
[null,"Anderson, A/et al",null,6.4285714285714288,null,null,null,"Short Form"]
[null,"Anderson, R & J",null,26,null,null,null,"Short Form"]
[null,"Andreotti, A/et al",null,1037.2857142857142,null,null,null,"Short Form"]
[null,"B & D Family Partnership",null,22.285714285714285,null,null,null,"Standard Form"]
[null,"Baber, J/et al",null,2350.4285714285716,null,null,null,"Standard Form"]
[null,"Butler, Diane",null,227.85714285714286,null,null,null,"Short Form"]
[null,"Butte Creek Farms Inc",null,353.42857142857144,null,null,null,"Short Form"]
[null,"Byrd, A & Osborne, J.",null,138.42857142857142,null,null,null,"Short Form"]
[null,"Cachil Dehe Band of Wintun",null,82.142857142857139,null,null,null,"Standard Form"]
[null,"Carter MWC",null,440.42857142857144,null,null,null,"Short Form"]
[null,"Charter, Mary",null,114.14285714285714,null,null,null,"District - Std Form"]
[null,"Churkin, M Jr & C",null,45.428571428571431,null,null,null,"Short Form"]
[null,"Conaway Consv Grp",null,396.57142857142856,null,null,null,"Standard Form"]
[null,"County of Sacramento",null,32.857142857142854,null,null,null,"Short Form"]
[null,"Cummings, W",null,94.714285714285708]
[null,"Driver, Gary/et al",null,3.1428571428571428,null,null,null,"Short Form"]
[null,"Driver, J & C Trustees",null,49,null,null,null,"Short Form"]
[null,"Driver, Gregory",null,2,null,null,null,"Short Form"]
[null,"Driver, W/et al",null,15.142857142857142,null,null,null,"Short Form"]
[null,"Dyer, J & Wing, J",null,192,null,null,null,"Short Form"]
[null,"Eastside MWC",null,430.71428571428572]
[null,"Ehrke, A & B",null,119.14285714285714,null,null,null,"District - Std Form"]
[null,"Empire Group, LLC",null,2.2857142857142856,null,null,null,"Short Form - Will not show unused"]
[null,"Feather WD",null,2676.4285714285716,null,null,null,"Short Form"]
[null,"Fedora, S/Taylor, W",null,2.8571428571428572,null,null,null,"District - Std Form"]
[null,"Four Corners Farmland",null,39.285714285714285,null,null,null,"Short Form"]
[null,"Gillaspy, W",null,64.857142857142861,null,null,null,"Short Form"]
[null,"Giusti, R & S",null,374.14285714285717,null,null,null,"Short Form"]
[null,"Glenn-Colusa ID",null,70036.571428571435,null,null,null,"Short Form"]
[null,"Green Valley Corp",null,141.14285714285714,null,null,null,"Short Form"]
[null,"Griffin, J/Prater",null,751.57142857142856,null,null,null,"Standard Form"]
[null,"Hale, J/Marks, A",null,4.2857142857142856,null,null,null,"Standard Form"]
[null,"Hatfield, R & B",null,13.428571428571429,null,null,null,"Short Form"]
[null,"Heidrick & McGinnis Properties",null,28.571428571428573,null,null,null,"Short Form"]
[null,"Heidrick, M",null,39.714285714285715,null,null,null,"Short Form"]
[null,"Howald Farms Inc",null,941.42857142857144,null,null,null,"Standard Form"]
[null,"Jaeger, W & P",null,69.285714285714292,null,null,null,"Standard Form"]
[null,"Jansen, P & S",null,37,null,null,null,"Standard Form"]
[null,"Kary, C",null,85.714285714285708,null,null,null,"Short Form"]
[null,"King, Ben ",null,1,null,null,null,"Short Form"]
[null,"King, L",null,1.8571428571428572,null,null,null,"Short Form"]
[null,"KLSY, LLC",null,48.285714285714285,null,null,null,"Short Form"]
[null,"Knights Landing Investors",null,592.85714285714289,null,null,null,"Short Form"]
[null,"Knights Landing Properties",null,16.428571428571427,null,null,null,"Short Form"]
[null,"L C Dennis Company",null,235.71428571428572,null,null,null,"Standard Form"]
[null,"Lauppe Alan, Johnson J, & Lauppe W",null,2,null,null,null,"Short Form"]
[null,"Lauppe, B ET UX",null,85.714285714285708,null,null,null,"Short Form"]
[null,"Lauppe, B & K",null,90,null,null,null,"Short Form"]
[null,"Leonard, James",null,4.2857142857142856,null,null,null,"Short Form"]
[null,"Lockett, W & J",null,44.857142857142854,null,null,null,"Standard Form"]
[null,"Lomo CS & Micheli, J",null,375,null,null,null,"Short Form"]
[null,"Lonon, M",null,411.14285714285717,null,null,null,"Standard Form"]
[null,"M C M Properties",null,452.71428571428572,null,null,null,"Short Form"]
[null,"Maxwell ID",null,4141,null,null,null,"District - Std Form"]
[null,"McClatchy Partners ",null,24.571428571428573,null,null,null,"District - Std Form"]
[null,"Meridian Farms WC",null,7483.1428571428569,null,null,null,"Short Form"]
[null,"Micke, D & N",null,2.7142857142857144,null,null,null,"Short Form"]
[null,"Morehead, J/et ux",null,60,null,null,null,"Short Form"]
[null,"Munson, J & D",null,22.285714285714285,null,null,null,"Short Form"]
[null,"Natomas Basin Conserv",null,80.428571428571431,null,null,null,"District - Std Form"]
[null,"Natomas Central MWC",null,17340.285714285714,null,null,null,"Short Form"]
[null,"Nelson, Henry E",null,80.571428571428569,null,null,null,"Standard Form"]
[null,"O'Brien, J & F",null,200.14285714285714,null,null,null,"Short Form"]
[null,"Odysseus Farms ",null,263.71428571428572,null,null,null,"Standard Form"]
[null,"Oji Brothers Farm Inc",null,1297.1428571428571,null,null,null,"Standard Form"]
[null,"Oji, M/et al",null,785.42857142857144,null,null,null,"Standard Form"]
[null,"Pacific Realty Inc",null,918.57142857142856,null,null,null,"Standard Form"]
[null,"Pelger MWC",null,1339.2857142857142,null,null,null,"District - Std Form"]
[null,"Pelger Road 1700, LLC",null,1485.4285714285713,null,null,null,"Short Form"]
[null,"Penner, R & L",null,3,null,null,null,"District - Std Form"]
[null,"Pleasant Grv-Vrna MWC",null,1771.5714285714287,null,null,null,"District - Std Form"]
[null,"Princeton-Codora-Glenn ID",null,10367.285714285714,null,null,null,"District - Std Form"]
[null,"Provident ID",null,2989.7142857142858,null,null,null,"Short Form"]
[null,"Quad-H-Ranches Inc",null,174.57142857142858,null,null,null,"District - Std Form"]
[null,"Recl Dist # 108",null,22114.714285714286,null,null,null,"Short Form"]
[null,"Recl Dist #1000",null,17.571428571428573,null,null,null,"District - Std Form"]
[null,"Recl Dist #1004",null,8756.2857142857138,null,null,null,"Short Form"]
[null,"Reische, E",null,11.285714285714286,null,null,null,"Short Form"]
[null,"Reische, L",null,57.142857142857146,null,null,null,"Standard Form"]
[null,"Richter, H Jr/et al",null,598.71428571428567,null,null,null,"Standard Form"]
[null,"River Garden Farms Co",null,291.57142857142856,null,null,null,"Short Form"]
[null,"Roberts Ditch Irr Co",null,257.14285714285717,null,null,null,"District - Std Form"]
[null,"Rubio, E & E",null,3,null,null,null,"Short Form"]
[null,"Saeed, F",null,380.71428571428572,null,null,null,"Standard Form"]
[null,"Seaver, C",null,38.571428571428569,null,null,null,"Short Form"]
[null,"Sutter MWC",null,37659,null,null,null,"District - Std Form"]
[null,"Swenson Farms",null,324.14285714285717,null,null,null,"Short Form & Standard Form (no project supply deliveries)"]
[null,"Sycamore Mutual Water Company",null,7178.8571428571431,null,null,null,"District - Std Form"]
[null,"T & P Farms",null,100.85714285714286,null,null,null,"Standard Form"]
[null,"Tarke, S",null,561.14285714285711,null,null,null,"Short Form"]
[null,"Tisdale Irr & Drain Co",null,1617,null,null,null,"Standard Form"]
[null,"Van Ruiten Brothers 1415L",null,119.28571428571429,null,null,null,"District - Std Form"]
[null,"Van Ruiten Brothers 520XL",null,104.85714285714286,null,null,null,"Short Form"]
[null,"Van Ruiten Brothers 0880S",null,293.42857142857144,null,null,null,"Short Form"]
[null,"Van Ruiten Brothers 0880XR",null,156,null,null,null,"Short Form"]
[null,"Wallace, J & J",null,10.142857142857142]
[null,"Wallace, K Trust",null,156,null,null,null,"Short Form"]
[null,"Wisler, J",null,3.8571428571428572,null,null,null,"Short Form"]
[null,"Yockey, W",null,1.8571428571428572,null,null,null,"Short Form"]
[null,"Young, R/et al",null,3.7142857142857144,null,337131]
[null,null,null,null,null,0]
[]
[]
["San Felipe Unit"]
[null,"San Benito County WD",null,8814.1428571428569]
[null,"Santa Clara Valley WD",null,12212.714285714286]
[]
[]
[]
["San Luis Canal - Fresno"]
[null,"Westlands WD - SLC",null,399746]
[null,"Westlands DD#2 ",null,899.71428571428567]
[]
[]
[]
["San Luis Canal - Tracy"]
[null,"Pacheco WD - SLC",null,3198.1428571428573]
[null,"Panoche WD - SLC",null,18367.428571428572]
[null,"San Luis WD - SLC",null,29434.285714285714]
[]
[]
[]
["Tehama-Colusa Canal"]
[null,"4-M WD",null,1429.8571428571429]
[null,"Colusa County WD",null,23661.857142857141]
[null,"Cortina WD",null,725.28571428571433]
[null,"Davis WD - TCC",null,2722.5714285714284]
[null,"Dunnigan WD",null,6186.2857142857147]
[null,"Glenn Valley WD",null,963.57142857142856]
[null,"Glide WD",null,4689.1428571428569]
[null,"Holthouse WD",null,251.85714285714286]
[null,"Kanawha WD",null,19964.571428571428]
[null,"Kirkwood WD",null,300]
[null,"La Grande WD",null,2868]
[null,"Myers-Marsh MWC",null,29.857142857142858]
[null,"Orland-Artois WD",null,17550.714285714286]
[null,"Westside WD",null,29097.857142857141]
[]
[]
["Delta Mendota Exchange Contractor"]
[null,"Irrigation",null,519504.30089314282]

{"sheet":"OUTPUT","index":3,"n_rows":241,"n_cols":13,"rows_kept":241,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"INFORMATION!$A$2","v":"Special Rates 2023 Sch S-5.Z25.XLSM"}]
[{"$f":"INFORMATION!A3","v":"01/03/2023"}]
[{"$f":"INFORMATION!A4","v":"CENTRAL VALLEY PROJECT"}]
[{"$f":"INFORMATION!A5","v":"SCHEDULE OF 2023 PROJECTED IRRIGATION DELIVERIES"}]
[{"$f":"INFORMATION!A6","v":"BY CONSTRUCTION COST COMPONENT AND CONTRACTOR "}]
[{"$f":"INFORMATION!A7","v":"2023 SPECIAL WATER RATES"}]
[]
["Category","A) Facility/Contractor","Related Footnotes","B) Projected 2023 Deliveries\n<Sch A-13>","C) Storage\n<Sch A-13>","D) Conveyance\n<Sch A-13>","E) Conveyance Pumping Corning PP\n<Sch A-13>","F) Conveyance Pumping Jones PP\n<Sch A-13>","G) Conveyance Pumping O'Neill PG\n<Sch A-13>","H) Conveyance Pumping Dos Amigos PP\n<Sch A-13>","I) Direct Pumping\n<Sch A-13>","J)San Luis Drain\n<Sch A-13>"]
["Black Butte D & R","4-E WD","-",{"$f":"MACRO_INPUT!D17","v":2.8571428571428572},{"$f":"D10","v":2.8571428571428572},"-","-","-","-","-","-","-"]
["Black Butte D & R","Stony Creek WD","-",{"$f":"MACRO_INPUT!D18","v":153.85714285714286},{"$f":"D11","v":153.85714285714286},"-","-","-","-","-","-","-"]
["Total","     Total Black Butte D & R","-",{"$f":"SUBTOTAL(9,D10:D11)","v":156.71428571428572},{"$f":"SUBTOTAL(9,E10:E11)","v":156.71428571428572},"-","-","-","-","-","-","-"]
["Buchanan Unit","Chowchilla WD - BU","-",{"$f":"MACRO_INPUT!D23","v":24000},{"$f":"D13","v":24000},"-","-","-","-","-","-","-"]
["Total",{"$f":"CONCATENATE(\"Total \",A13)","v":"Total Buchanan Unit"},"-",{"$f":"D13","v":24000},{"$f":"E13","v":24000},"-","-","-","-","-","-","-"]
["Clear Creek Unit","Clear Creek CSD","-",{"$f":"MACRO_INPUT!D27","v":981.57142857142856},981.57142857142856,{"$f":"E15","v":981.57142857142856},"-","-","-","-","-","-"]
["Total",{"$f":"CONCATENATE(\"Total \",A15)","v":"Total Clear Creek Unit"},"-",{"$f":"D15","v":981.57142857142856},{"$f":"E15","v":981.57142857142856},{"$f":"F15","v":981.57142857142856},"-","-","-","-","-","-"]
["Colusa Basin Drain","Colusa Drain MWC","-","-","-","-","-","-","-","-","-","-"]
["Total",{"$f":"CONCATENATE(\"Total \",A17)","v":"Total Colusa Basin Drain"},"-","-","-","-","-","-","-","-","-","-"]
["Corning Canal","Corning WD","-",{"$f":"MACRO_INPUT!D35","v":5132.1428571428569},{"$f":"D19","v":5132.1428571428569},{"$f":"E19","v":5132.1428571428569},{"$f":"E19","v":5132.1428571428569},"-","-","-",{"$f":"E19","v":5132.1428571428569},"-"]
["Corning Canal","Proberta WD","-",{"$f":"MACRO_INPUT!D36","v":201.42857142857142},201.42857142857142,{"$f":"E20","v":201.42857142857142},{"$f":"E20","v":201.42857142857142},"-","-","-",{"$f":"E20","v":201.42857142857142},"-"]
["Corning Canal","Thomes Creek WD","-",{"$f":"MACRO_INPUT!D37","v":89.714285714285708},89.714285714285708,{"$f":"E21","v":89.714285714285708},{"$f":"E21","v":89.714285714285708},"-","-","-","-","-"]
["Total","     Total Corning Canal","-",{"$f":"SUBTOTAL(9,D19:D21)","v":5423.2857142857138},{"$f":"SUBTOTAL(9,E19:E21)","v":5423.2857142857138},{"$f":"SUBTOTAL(9,F19:F21)","v":5423.2857142857138},{"$f":"SUBTOTAL(9,G19:G21)","v":5423.2857142857138},"-","-","-",{"$f":"SUBTOTAL(9,K19:K21)","v":5333.5714285714284},"-"]
["Cow Creek Unit","Bella Vista WD","-",{"$f":"MACRO_INPUT!D42","v":2851.5714285714284},{"$f":"D23","v":2851.5714285714284},{"$f":"E23","v":2851.5714285714284},"-","-","-","-",{"$f":"E23","v":2851.5714285714284},"-"]
["Total",{"$f":"CONCATENATE(\"Total \",A23)","v":"Total Cow Creek Unit"},"-",{"$f":"D23","v":2851.5714285714284},{"$f":"E23","v":2851.5714285714284},{"$f":"F23","v":2851.5714285714284},"-","-","-","-",{"$f":"K23","v":2851.5714285714284},"-"]
["Cross Valley Canal","County of Fresno","-",{"$f":"MACRO_INPUT!D46","v":321.42857142857144},{"$f":"D25","v":321.42857142857144},"-","-","-","-",{"$f":"D25","v":321.42857142857144},{"$f":"D25","v":321.42857142857144},"-"]
["Cross Valley Canal","County of Tulare","-",{"$f":"MACRO_INPUT!D47","v":400.57142857142856},400.57142857142856,"-","-","-","-",400.57142857142856,400.57142857142856,"-"]
["Cross Valley Canal","Hills Valley ID","-",{"$f":"MACRO_INPUT!D48","v":239},239,"-","-","-","-",239,239,"-"]
["Cross Valley Canal","Kern-Tulare ID","-",{"$f":"MACRO_INPUT!D49","v":5498.1428571428569},5498.1428571428569,"-","-","-","-",5498.1428571428569,5498.1428571428569,"-"]
["Cross Valley Canal","Lower Tule River ID - CVC","-",{"$f":"MACRO_INPUT!D50","v":3303.7142857142858},3303.7142857142858,"-","-","-","-",3303.7142857142858,3303.7142857142858,"-"]
["Cross Valley Canal","Pixley ID","-",{"$f":"MACRO_INPUT!D51","v":3332.2857142857142},3332.2857142857142,"-","-","-","-",3332.2857142857142,3332.2857142857142,"-"]
["Cross Valley Canal","Tri-Valley WD","-",{"$f":"MACRO_INPUT!D52","v":124.42857142857143},124.42857142857143,"-","-","-","-",124.42857142857143,124.42857142857143,"-"]
["Total","     Total Cross Valley Canal","-",{"$f":"SUBTOTAL(9,D25:D31)","v":13219.571428571428},{"$f":"SUBTOTAL(9,E25:E31)","v":13219.571428571428},"-","-","-","-",{"$f":"SUBTOTAL(9,J25:J31)","v":13219.571428571428},{"$f":"SUBTOTAL(9,K25:K31)","v":13219.571428571428},"-"]
["Delta-Mendota Canal","Banta-Carbona ID","-",{"$f":"MACRO_INPUT!D57","v":6143},{"$f":"D33","v":6143},{"$f":"E33","v":6143},"-",{"$f":"E33","v":6143},"-","-","-","-"]
["Delta-Mendota Canal","Byron-Bethany ID ","-",{"$f":"MACRO_INPUT!D58","v":2980.2857142857142},2980.2857142857142,2980.2857142857142,"-",2980.2857142857142,"-","-","-","-"]
["Delta-Mendota Canal","Del Puerto WD","-",{"$f":"MACRO_INPUT!D59","v":36972.571428571428},36972.571428571428,36972.571428571428,"-",36972.571428571428,"-","-","-","-"]
["Delta-Mendota Canal","Eagle Field WD","-",{"$f":"MACRO_INPUT!D60","v":1523.8571428571429},1523.8571428571429,1523.8571428571429,"-",1523.8571428571429,"-","-","-","-"]
["Delta-Mendota Canal","Mercy Springs WD","-",{"$f":"MACRO_INPUT!D61","v":970.14285714285711},970.14285714285711,970.14285714285711,"-",970.14285714285711,"-","-","-","-"]
["Delta-Mendota Canal","Oro Loma WD","-",{"$f":"MACRO_INPUT!D62","v":31.571428571428573},31.571428571428573,31.571428571428573,"-",31.571428571428573,"-","-","-","-"]
["Delta-Mendota Canal","Pacheco WD - DMC","-",{"$f":"MACRO_INPUT!D63","v":142.85714285714286},142.85714285714286,142.85714285714286,"-",142.85714285714286,"-","-","-","-"]
["Delta-Mendota Canal","Panoche WD - DMC","-",{"$f":"MACRO_INPUT!D64","v":6851.5714285714284},6851.5714285714284,6851.5714285714284,"-",6851.5714285714284,"-","-","-","-"]
["Delta-Mendota Canal","Patterson WD","-",{"$f":"MACRO_INPUT!D65","v":5645.7142857142853},5645.7142857142853,5645.7142857142853,"-",5645.7142857142853,"-","-","-","-"]
["Delta-Mendota Canal","San Luis WD - DMC","-",{"$f":"MACRO_INPUT!D66","v":5594.5714285714284},5594.5714285714284,5594.5714285714284,"-",5594.5714285714284,"-","-","-","-"]
["Delta-Mendota Canal","West Side ID","-",{"$f":"MACRO_INPUT!D67","v":297.42857142857144},297.42857142857144,297.42857142857144,"-",297.42857142857144,"-","-","-","-"]
["Delta-Mendota Canal","West Stanislaus ID","-",{"$f":"MACRO_INPUT!D68","v":10252.857142857143},10252.857142857143,10252.857142857143,"-",10252.857142857143,"-","-","-","-"]
["Total","     Total Delta-Mendota Canal","-",{"$f":"SUBTOTAL(9,D33:D44)","v":77406.428571428565},{"$f":"SUBTOTAL(9,E33:E44)","v":77406.428571428565},{"$f":"SUBTOTAL(9,F33:F44)","v":77406.428571428565},"-",{"$f":"SUBTOTAL(9,H33:H44)","v":77406.428571428565},"-","-","-","-"]
["Delta-Mendota Pool","Coelho Trust","-",{"$f":"MACRO_INPUT!D73","v":642},{"$f":"D46","v":642},{"$f":"E46","v":642},"-",{"$f":"E46","v":642},"-","-","-","-"]
["Delta-Mendota Pool","Fresno Slough WD","-",{"$f":"MACRO_INPUT!D74","v":1322.1428571428571},1322.1428571428571,1322.1428571428571,"-",1322.1428571428571,"-","-","-","-"]
["Delta-Mendota Pool","James ID","-",{"$f":"MACRO_INPUT!D75","v":11862.714285714286},11862.714285714286,11862.714285714286,"-",11862.714285714286,"-","-","-","-"]
["Delta-Mendota Pool","Laguna WD","-",{"$f":"MACRO_INPUT!D76","v":165.71428571428572},165.71428571428572,165.71428571428572,"-",165.71428571428572,"-","-","-","-"]
["Delta-Mendota Pool","Recl Dist #1606","-",{"$f":"MACRO_INPUT!D77","v":46.142857142857146},46.142857142857146,46.142857142857146,"-",46.142857142857146,"-","-","-","-"]
["Delta-Mendota Pool","Tranquillity ID","-",{"$f":"MACRO_INPUT!D78","v":3386.8571428571427},3386.8571428571427,3386.8571428571427,"-",3386.8571428571427,"-","-","-","-"]
["Delta-Mendota Pool","Tranquillity PUD","-",{"$f":"MACRO_INPUT!D79","v":10},10,10,"-",10,"-","-","-","-"]
["Delta-Mendota Pool","Westlands WD - DMP","-",{"$f":"MACRO_INPUT!D80","v":3571.4285714285716},3571.4285714285716,3571.4285714285716,"-",3571.4285714285716,"-","-","-","-"]
["Total","     Total Delta-Mendota Pool","-",{"$f":"SUBTOTAL(9,D46:D53)","v":21007},{"$f":"SUBTOTAL(9,E46:E53)","v":21007},{"$f":"SUBTOTAL(9,F46:F53)","v":21007},"-",{"$f":"SUBTOTAL(9,H46:H53)","v":21007},"-","-","-","-"]
["Friant Dam - Class 2","Gravelly Ford WD","-","-","-","-","-","-","-","-","-","-"]
["Total",{"$f":"CONCATENATE(\"Total \",A55)","v":"Total Friant Dam - Class 2"},"-","-","-","-","-","-","-","-","-","-"]
["Friant-Kern Canal - Class 1","Arvin-Edison WSD","1/",{"$f":"MACRO_INPUT!D89","v":23284.285714285714},{"$f":"D57","v":23284.285714285714},23284.285714285714,"-","-","-","-","-","-"]
["Friant-Kern Canal - Class 1","Delano-Earlimart ID","1/",{"$f":"MACRO_INPUT!D90","v":71332.571428571435},71332.571428571435,71332.571428571435,"-","-","-","-","-","-"]
["Friant-Kern Canal - Class 1","Exeter ID","1/",{"$f":"MACRO_INPUT!D91","v":7031.2857142857147},7031.2857142857147,7031.2857142857147,"-","-","-","-","-","-"]
["Friant-Kern Canal - Class 1","Garfield WD","1/",{"$f":"MACRO_INPUT!D92","v":1560.2857142857142},1560.2857142857142,1560.2857142857142,"-","-","-","-","-","-"]
["Friant-Kern Canal - Class 1","Hills Valley ID","1/",{"$f":"MACRO_INPUT!D93","v":778.85714285714289},778.85714285714289,778.85714285714289,"-","-","-","-","-","-"]
["Friant-Kern Canal - Class 1","International WD","1/",{"$f":"MACRO_INPUT!D94","v":645.71428571428567},{"$f":"D62","v":645.71428571428567},{"$f":"E62","v":645.71428571428567},"-","-","-","-","-","-"]
["Friant-Kern Canal - Class 1","Ivanhoe ID","1/",{"$f":"MACRO_INPUT!D95","v":4089},4089,4089,"-","-","-","-","-","-"]
["Friant-Kern Canal - Class 1","Kaweah Delta WCD","1/",{"$f":"MACRO_INPUT!D96","v":622.28571428571433},622.28571428571433,622.28571428571433,"-","-","-","-","-","-"]
["Friant-Kern Canal - Class 1","Lewis Creek WD","1/",{"$f":"MACRO_INPUT!D97","v":617.71428571428567},617.71428571428567,617.71428571428567,"-","-","-","-","-","-"]
["Friant-Kern Canal - Class 1","Lindmore ID","1/",{"$f":"MACRO_INPUT!D98","v":20415},20415,20415,"-","-","-","-","-","-"]
["Friant-Kern Canal - Class 1","Lindsay-Strathmore ID","1/",{"$f":"MACRO_INPUT!D99","v":17050.571428571428},17050.571428571428,17050.571428571428,"-","-","-","-","-","-"]
["Friant-Kern Canal - Class 1","Lower Tule River ID - FKC","1/",{"$f":"MACRO_INPUT!D100","v":40123.714285714283},40123.714285714283,40123.714285714283,"-","-","-","-","-","-"]
["Friant-Kern Canal - Class 1","Orange Cove ID","1/",{"$f":"MACRO_INPUT!D101","v":26313.857142857141},26313.857142857141,26313.857142857141,"-","-","-","-","-","-"]
["Friant-Kern Canal - Class 1","Porterville ID","1/",{"$f":"MACRO_INPUT!D102","v":9671.8571428571431},9671.8571428571431,9671.8571428571431,"-","-","-","-","-","-"]
["Friant-Kern Canal - Class 1","Saucelito ID","1/",{"$f":"MACRO_INPUT!D103","v":12473.571428571429},12473.571428571429,12473.571428571429,"-","-","-","-","-","-"]
["Friant-Kern Canal - Class 1","Shafter-Wasco ID","1/",{"$f":"MACRO_INPUT!D104","v":31445},31445,31445,"-","-","-","-","-","-"]
["Friant-Kern Canal - Class 1","So San Joaquin MUD","1/",{"$f":"MACRO_INPUT!D105","v":61718.57},61718.57,61718.57,"-","-","-","-","-","-"]
["Friant-Kern Canal - Class 1","Stone Corral ID","1/",{"$f":"MACRO_INPUT!D106","v":6137.57},6137.57,6137.57,"-","-","-","-","-","-"]
["Friant-Kern Canal - Class 1","Tea Pot Dome WD","1/",{"$f":"MACRO_INPUT!D107","v":4502.8599999999997},4502.8599999999997,4502.8599999999997,"-","-","-","-","-","-"]
["Friant-Kern Canal - Class 1","Terra Bella ID","1/",{"$f":"MACRO_INPUT!D108","v":16220.86},16220.86,16220.86,"-","-","-","-","-","-"]
["Friant-Kern Canal - Class 1","Tri-Valley ID","1/",{"$f":"MACRO_INPUT!D109","v":215.57142857142858},215.57142857142858,{"$f":"E77","v":215.57142857142858},"-","-","-","-","-","-"]
["Friant-Kern Canal - Class 1","Tulare ID","1/",{"$f":"MACRO_INPUT!D110","v":19728},19728,19728,"-","-","-","-","-","-"]
["Total","     Total Friant-Kern Canal - Class 1","-",{"$f":"SUBTOTAL(9,D57:D78)","v":375979.00285714277},{"$f":"SUBTOTAL(9,E57:E78)","v":375979.00285714277},{"$f":"SUBTOTAL(9,F57:F78)","v":375979.00285714277},"-","-","-","-","-","-"]
["Friant-Kern Canal - Class 2","Arvin-Edison WSD","-","-","-",{"$f":"D80","v":"-"},"-","-","-","-","-","-"]
["Friant-Kern Canal - Class 2","Delano-Earlimart ID","-","-","-","-","-","-","-","-","-","-"]
["Friant-Kern Canal - Class 2","Exeter ID","-","-","-","-","-","-","-","-","-","-"]
["Friant-Kern Canal - Class 2","Fresno ID","-","-","-","-","-","-","-","-","-","-"]
["Friant-Kern Canal - Class 2","Ivanhoe ID","-","-","-","-","-","-","-","-","-","-"]
["Friant-Kern Canal - Class 2","Kaweah Delta WCD","-","-","-","-","-","-","-","-","-","-"]
["Friant-Kern Canal - Class 2","Kern-Tulare ID","-","-","-","-","-","-","-","-","-","-"]
["Friant-Kern Canal - Class 2","Lindmore ID","-","-","-","-","-","-","-","-","-","-"]
["Friant-Kern Canal - Class 2","Lower Tule River ID - FKC","-","-","-","-","-","-","-","-","-","-"]
["Friant-Kern Canal - Class 2","Porterville ID","-","-","-","-","-","-","-","-","-","-"]
["Friant-Kern Canal - Class 2","Saucelito ID","-","-","-","-","-","-","-","-","-","-"]
["Friant-Kern Canal - Class 2","Shafter-Wasco ID","-","-","-","-","-","-","-","-","-","-"]
["Friant-Kern Canal - Class 2","So San Joaquin MUD","-","-","-","-","-","-","-","-","-","-"]
["Friant-Kern Canal - Class 2","Tulare ID","-","-","-","-","-","-","-","-","-","-"]
["Total","     Total Friant-Kern Canal - Class 2","-","-","-","-","-","-","-","-","-","-"]
["Hidden Unit","Madera ID - HU","-",{"$f":"MACRO_INPUT!D133","v":24000},{"$f":"D95","v":24000},"-","-","-","-","-","-","-"]
["Total",{"$f":"CONCATENATE(\"Total \",A95)","v":"Total Hidden Unit"},"-",{"$f":"D95","v":24000},{"$f":"E95","v":24000},"-","-","-","-","-","-","-"]
["Madera Canal - Class 1","Chowchilla WD - MC","1/",{"$f":"MACRO_INPUT!D137","v":35840.142857142855},{"$f":"D97","v":35840.142857142855},{"$f":"E97","v":35840.142857142855},"-","-","-","-","-","-"]
["Madera Canal - Class 1","Madera ID - MC","1/",{"$f":"MACRO_INPUT!D138","v":55867},{"$f":"D98","v":55867},{"$f":"E98","v":55867},"-","-","-","-","-","-"]
["Total","     Total Madera Canal - Class 1","-",{"$f":"SUBTOTAL(9,D97:D98)","v":91707.142857142855},{"$f":"SUBTOTAL(9,E97:E98)","v":91707.142857142855},{"$f":"SUBTOTAL(9,F97:F98)","v":91707.142857142855},"-","-","-","-","-","-"]
["Madera Canal - Class 2","Chowchilla WD - MC","-","-","-",{"$f":"D100","v":"-"},"-","-","-","-","-","-"]
["Madera Canal - Class 2","Madera ID - MC","-","-","-",{"$f":"D101","v":"-"},"-","-","-","-","-","-"]
["Total","     Total Madera Canal - Class 2","-","-","-","-","-","-","-","-","-","-"]
["New Melones D & R","Central San Joaquin WCD","-",{"$f":"MACRO_INPUT!D149","v":15626},{"$f":"D103","v":15626},"-","-","-","-","-","-","-"]
["New Melones D & R","Stockton-East WD","-",{"$f":"MACRO_INPUT!D150","v":5603.4285714285716},{"$f":"D104","v":5603.4285714285716},"-","-","-","-","-","-","-"]
["Total","     Total New Melones D & R","-",{"$f":"SUBTOTAL(9,D103:D104)","v":21229.428571428572},{"$f":"SUBTOTAL(9,E103:E104)","v":21229.428571428572},"-","-","-","-","-","-","-"]
["Sacramento River - Shasta","Anderson-Cottonwood ID","-",{"$f":"MACRO_INPUT!D155","v":2490.7142857142858},{"$f":"D106","v":2490.7142857142858},"-","-","-","-","-","-","-"]
["Sacramento River - Shasta","Daniell, H & B","-",{"$f":"MACRO_INPUT!D156","v":1},1,"-","-","-","-","-","-","-"]
["Sacramento River - Shasta","Driscoll Strawberry","-",{"$f":"MACRO_INPUT!D157","v":70},70,"-","-","-","-","-","-","-"]
["Sacramento River - Shasta","Gjermann, H","-",{"$f":"MACRO_INPUT!D158","v":3.1428571428571428},3.1428571428571428,"-","-","-","-","-","-","-"]
["Sacramento River - Shasta","Leviathan Inc","-",{"$f":"MACRO_INPUT!D159","v":254.28571428571428},254.28571428571428,"-","-","-","-","-","-","-"]
["Sacramento River - Shasta","Redding Rancheria ","-",{"$f":"MACRO_INPUT!D160","v":19.285714285714285},19.285714285714285,"-","-","-","-","-","-","-"]
["Total","     Total Sacramento River - Shasta","-",{"$f":"SUBTOTAL(9,D106:D111)","v":2838.4285714285716},{"$f":"SUBTOTAL(9,E106:E111)","v":2838.4285714285716},"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Anderson, A/et al","-",{"$f":"MACRO_INPUT!D165","v":6.4285714285714288},{"$f":"D113","v":6.4285714285714288},"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Anderson, R & J","-",{"$f":"MACRO_INPUT!D166","v":26},26,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Andreotti, A/et al","-",{"$f":"MACRO_INPUT!D167","v":1037.2857142857142},1037.2857142857142,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","B & D Family Partnership","-",{"$f":"MACRO_INPUT!D168","v":22.285714285714285},22.285714285714285,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Baber, J/et al","-",{"$f":"MACRO_INPUT!D169","v":2350.4285714285716},2350.4285714285716,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Butler, Diane","-",{"$f":"MACRO_INPUT!D170","v":227.85714285714286},227.85714285714286,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Butte Creek Farms Inc","-",{"$f":"MACRO_INPUT!D171","v":353.42857142857144},353.42857142857144,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Byrd, A & Osborne, J.","-",{"$f":"MACRO_INPUT!D172","v":138.42857142857142},138.42857142857142,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Cachil Dehe Band of Wintun","-",{"$f":"MACRO_INPUT!D173","v":82.142857142857139},82.142857142857139,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Carter MWC","-",{"$f":"MACRO_INPUT!D174","v":440.42857142857144},440.42857142857144,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Charter, Mary","-",{"$f":"MACRO_INPUT!D175","v":114.14285714285714},114.14285714285714,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Churkin, M Jr & C","-",{"$f":"MACRO_INPUT!D176","v":45.428571428571431},45.428571428571431,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Conaway Consv Grp","-",{"$f":"MACRO_INPUT!D177","v":396.57142857142856},396.57142857142856,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","County of Sacramento","-",{"$f":"MACRO_INPUT!D178","v":32.857142857142854},32.857142857142854,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Cummings, W","-",{"$f":"MACRO_INPUT!D179","v":94.714285714285708},94.714285714285708,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Driver, Gary/et al","-",{"$f":"MACRO_INPUT!D180","v":3.1428571428571428},3.1428571428571428,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Driver, J & C Trustees","-",{"$f":"MACRO_INPUT!D181","v":49},49,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Driver, Gregory","-",{"$f":"MACRO_INPUT!D182","v":2},2,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Driver, W/et al","-",{"$f":"MACRO_INPUT!D183","v":15.142857142857142},15.142857142857142,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Dyer, J & Wing, J","-",{"$f":"MACRO_INPUT!D184","v":192},192,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Eastside MWC","-",{"$f":"MACRO_INPUT!D185","v":430.71428571428572},430.71428571428572,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Ehrke, A & B","-",{"$f":"MACRO_INPUT!D186","v":119.14285714285714},119.14285714285714,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Empire Group, LLC","-",{"$f":"MACRO_INPUT!D187","v":2.2857142857142856},2.2857142857142856,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Feather WD","-",{"$f":"MACRO_INPUT!D188","v":2676.4285714285716},2676.4285714285716,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Fedora, S/Taylor, W","-",{"$f":"MACRO_INPUT!D189","v":2.8571428571428572},2.8571428571428572,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Four Corners Farmland","-",{"$f":"MACRO_INPUT!D190","v":39.285714285714285},39.285714285714285,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Gillaspy, W","-",{"$f":"MACRO_INPUT!D191","v":64.857142857142861},64.857142857142861,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Giusti, R & S","-",{"$f":"MACRO_INPUT!D192","v":374.14285714285717},374.14285714285717,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Glenn-Colusa ID","-",{"$f":"MACRO_INPUT!D193","v":70036.571428571435},70036.571428571435,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Green Valley Corp","-",{"$f":"MACRO_INPUT!D194","v":141.14285714285714},141.14285714285714,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Griffin, J/Prater","-",{"$f":"MACRO_INPUT!D195","v":751.57142857142856},751.57142857142856,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Hale, J/Marks, A","-",{"$f":"MACRO_INPUT!D196","v":4.2857142857142856},4.2857142857142856,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Hatfield, R & B","-",{"$f":"MACRO_INPUT!D197","v":13.428571428571429},{"$f":"D145","v":13.428571428571429},"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Heidrick & McGinnis Properties","-",{"$f":"MACRO_INPUT!D198","v":28.571428571428573},28.571428571428573,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Heidrick, M","-",{"$f":"MACRO_INPUT!D199","v":39.714285714285715},39.714285714285715,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Howald Farms Inc","-",{"$f":"MACRO_INPUT!D200","v":941.42857142857144},941.42857142857144,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Jaeger, W & P","-",{"$f":"MACRO_INPUT!D201","v":69.285714285714292},69.285714285714292,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Jansen, P & S","-",{"$f":"MACRO_INPUT!D202","v":37},37,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Kary, C","-",{"$f":"MACRO_INPUT!D203","v":85.714285714285708},85.714285714285708,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","King, Ben ","-",{"$f":"MACRO_INPUT!D204","v":1},1,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","King, L","-",{"$f":"MACRO_INPUT!D205","v":1.8571428571428572},1.8571428571428572,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","KLSY, LLC","-",{"$f":"MACRO_INPUT!D206","v":48.285714285714285},48.285714285714285,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Knights Landing Investors","-",{"$f":"MACRO_INPUT!D207","v":592.85714285714289},592.85714285714289,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Knights Landing Properties ","-",{"$f":"MACRO_INPUT!D208","v":16.428571428571427},16.428571428571427,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","L C Dennis Company","-",{"$f":"MACRO_INPUT!D209","v":235.71428571428572},235.71428571428572,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Lauppe, Joan Johnson, & Warren Lauppe","-",{"$f":"MACRO_INPUT!D210","v":2},2,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Lauppe, B ET UX","-",{"$f":"MACRO_INPUT!D211","v":85.714285714285708},85.714285714285708,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Lauppe, B & K","-",{"$f":"MACRO_INPUT!D212","v":90},90,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Leonard, James","-",{"$f":"MACRO_INPUT!D213","v":4.2857142857142856},4.2857142857142856,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Lockett, W & J","-",{"$f":"MACRO_INPUT!D214","v":44.857142857142854},44.857142857142854,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Lomo CS & Micheli, J","-",{"$f":"MACRO_INPUT!D215","v":375},375,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Lonon, M","-",{"$f":"MACRO_INPUT!D216","v":411.14285714285717},411.14285714285717,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","M C M Properties","-",{"$f":"MACRO_INPUT!D217","v":452.71428571428572},452.71428571428572,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Maxwell ID","-",{"$f":"MACRO_INPUT!D218","v":4141},4141,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","McClatchy Partners ","-",{"$f":"MACRO_INPUT!D219","v":24.571428571428573},24.571428571428573,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Meridian Farms WC","-",{"$f":"MACRO_INPUT!D220","v":7483.1428571428569},7483.1428571428569,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Micke, D & N","-",{"$f":"MACRO_INPUT!D221","v":2.7142857142857144},2.7142857142857144,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Morehead, J/et ux","-",{"$f":"MACRO_INPUT!D222","v":60},60,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Munson, J & D","-",{"$f":"MACRO_INPUT!D223","v":22.285714285714285},22.285714285714285,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Natomas Basin Conserv","-",{"$f":"MACRO_INPUT!D224","v":80.428571428571431},80.428571428571431,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Natomas Central MWC","-",{"$f":"MACRO_INPUT!D225","v":17340.285714285714},17340.285714285714,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Nelson, Henry E","-",{"$f":"MACRO_INPUT!D226","v":80.571428571428569},80.571428571428569,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","O'Brien, J & F","-",{"$f":"MACRO_INPUT!D227","v":200.14285714285714},200.14285714285714,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Odysseus Farms ","-",{"$f":"MACRO_INPUT!D228","v":263.71428571428572},263.71428571428572,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Oji Brothers Farm Inc","-",{"$f":"MACRO_INPUT!D229","v":1297.1428571428571},{"$f":"D177","v":1297.1428571428571},"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Oji, M/et al","-",{"$f":"MACRO_INPUT!D230","v":785.42857142857144},785.42857142857144,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Pacific Realty Inc","-",{"$f":"MACRO_INPUT!D231","v":918.57142857142856},918.57142857142856,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Pelger MWC","-",{"$f":"MACRO_INPUT!D232","v":1339.2857142857142},1339.2857142857142,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Pelger Road 1700, LLC","-",{"$f":"MACRO_INPUT!D233","v":1485.4285714285713},1485.4285714285713,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Penner, R & L","-",{"$f":"MACRO_INPUT!D234","v":3},3,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Pleasant Grv-Vrna MWC","-",{"$f":"MACRO_INPUT!D235","v":1771.5714285714287},1771.5714285714287,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Princeton-Codora-Glenn ID","-",{"$f":"MACRO_INPUT!D236","v":10367.285714285714},10367.285714285714,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Provident ID","-",{"$f":"MACRO_INPUT!D237","v":2989.7142857142858},2989.7142857142858,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Quad-H-Ranches Inc","-",{"$f":"MACRO_INPUT!D238","v":174.57142857142858},174.57142857142858,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Recl Dist # 108","-",{"$f":"MACRO_INPUT!D239","v":22114.714285714286},22114.714285714286,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Recl Dist #1000","-",{"$f":"MACRO_INPUT!D240","v":17.571428571428573},17.571428571428573,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Recl Dist #1004","-",{"$f":"MACRO_INPUT!D241","v":8756.2857142857138},8756.2857142857138,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Reische, E","-",{"$f":"MACRO_INPUT!D242","v":11.285714285714286},11.285714285714286,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Reische, L","-",{"$f":"MACRO_INPUT!D243","v":57.142857142857146},57.142857142857146,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Richter, H Jr/et al","-",{"$f":"MACRO_INPUT!D244","v":598.71428571428567},598.71428571428567,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","River Garden Farms Co","-",{"$f":"MACRO_INPUT!D245","v":291.57142857142856},291.57142857142856,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Roberts Ditch Irr Co","-",{"$f":"MACRO_INPUT!D246","v":257.14285714285717},257.14285714285717,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Rubio, E & E","-",{"$f":"MACRO_INPUT!D247","v":3},3,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Saeed, F","-",{"$f":"MACRO_INPUT!D248","v":380.71428571428572},380.71428571428572,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Seaver, C","-",{"$f":"MACRO_INPUT!D249","v":38.571428571428569},38.571428571428569,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Sutter MWC","-",{"$f":"MACRO_INPUT!D250","v":37659},37659,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Swenson Farms","-",{"$f":"MACRO_INPUT!D251","v":324.14285714285717},324.14285714285717,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Sycamore Mutual Water Company","-",{"$f":"MACRO_INPUT!D252","v":7178.8571428571431},7178.8571428571431,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","T & P Farms","-",{"$f":"MACRO_INPUT!D253","v":100.85714285714286},100.85714285714286,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Tarke, S","-",{"$f":"MACRO_INPUT!D254","v":561.14285714285711},561.14285714285711,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Tisdale Irr & Drain Co","-",{"$f":"MACRO_INPUT!D255","v":1617},1617,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Van Ruiten Brothers 1415L","-",{"$f":"MACRO_INPUT!D256","v":119.28571428571429},119.28571428571429,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Van Ruiten Brothers 520XL","-",{"$f":"MACRO_INPUT!D257","v":104.85714285714286},104.85714285714286,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Van Ruiten Brothers 0880S","-",{"$f":"MACRO_INPUT!D258","v":293.42857142857144},293.42857142857144,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Van Ruiten Brothers 880XR","-",{"$f":"MACRO_INPUT!D259","v":156},156,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Wallace, J & J","-",{"$f":"MACRO_INPUT!D260","v":10.142857142857142},10.142857142857142,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Wallace, K Trust","-",{"$f":"MACRO_INPUT!D261","v":156},{"$f":"D209","v":156},"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Wisler, J","-",{"$f":"MACRO_INPUT!D262","v":3.8571428571428572},3.8571428571428572,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Yockey, W","-",{"$f":"MACRO_INPUT!D263","v":1.8571428571428572},1.8571428571428572,"-","-","-","-","-","-","-"]
["Sacramento River - Willows","Young, R/et al","-",{"$f":"MACRO_INPUT!D264","v":3.7142857142857144},3.7142857142857144,"-","-","-","-","-","-","-"]
["Total","     Total Sacramento River - Willows","-",{"$f":"SUBTOTAL(9,D113:D212)","v":215497.71428571426},{"$f":"SUBTOTAL(9,E113:E212)","v":215497.71428571426},"-","-","-","-","-","-","-"]
["San Felipe Unit ","San Benito County WD","2/",{"$f":"MACRO_INPUT!D269","v":8814.1428571428569},{"$f":"D214","v":8814.1428571428569},{"$f":"E214","v":8814.1428571428569},"-",{"$f":"E214","v":8814.1428571428569},{"$f":"E214","v":8814.1428571428569},"-",{"$f":"E214","v":8814.1428571428569},"-"]
["San Felipe Unit ","Santa Clara Valley WD","2/",{"$f":"MACRO_INPUT!D270","v":12212.714285714286},{"$f":"D215","v":12212.714285714286},{"$f":"E215","v":12212.714285714286},"-",{"$f":"E215","v":12212.714285714286},{"$f":"E215","v":12212.714285714286},"-",{"$f":"E215","v":12212.714285714286},"-"]
["Total","     Total San Felipe Unit","-",{"$f":"SUBTOTAL(9,D214:D215)","v":21026.857142857145},{"$f":"SUBTOTAL(9,E214:E215)","v":21026.857142857145},{"$f":"SUBTOTAL(9,F214:F215)","v":21026.857142857145},"-",{"$f":"SUBTOTAL(9,H214:H215)","v":21026.857142857145},{"$f":"SUBTOTAL(9,I214:I215)","v":21026.857142857145},"-",{"$f":"SUBTOTAL(9,K214:K215)","v":21026.857142857145},"-"]
["San Luis Canal - Fresno","Westlands WD - SLC","-",{"$f":"MACRO_INPUT!D275","v":399746},{"$f":"D217","v":399746},{"$f":"E217","v":399746},"-",{"$f":"E217","v":399746},{"$f":"E217","v":399746},{"$f":"E217","v":399746},{"$f":"E217","v":399746},{"$f":"E217","v":399746}]
["San Luis Canal - Fresno","Westlands WD--SLC  (DD#2)","-",{"$f":"MACRO_INPUT!D276","v":899.71428571428567},{"$f":"D218","v":899.71428571428567},{"$f":"E218","v":899.71428571428567},"-",{"$f":"E218","v":899.71428571428567},{"$f":"E218","v":899.71428571428567},{"$f":"E218","v":899.71428571428567},{"$f":"E218","v":899.71428571428567},"-"]
["Total","     Total San Luis Canal-Fresno","-",{"$f":"SUBTOTAL(9,D217:D218)","v":400645.71428571426},{"$f":"SUBTOTAL(9,E217:E218)","v":400645.71428571426},{"$f":"SUBTOTAL(9,F217:F218)","v":400645.71428571426},"-",{"$f":"SUBTOTAL(9,H217:H218)","v":400645.71428571426},{"$f":"SUBTOTAL(9,I217:I218)","v":400645.71428571426},{"$f":"SUBTOTAL(9,J217:J218)","v":400645.71428571426},{"$f":"SUBTOTAL(9,K217:K218)","v":400645.71428571426},{"$f":"SUBTOTAL(9,L217:L218)","v":399746}]
["San Luis Canal - Tracy","Pacheco WD - SLC","-",{"$f":"MACRO_INPUT!D281","v":3198.1428571428573},{"$f":"D220","v":3198.1428571428573},3198.1428571428573,"-",{"$f":"E220","v":3198.1428571428573},{"$f":"E220","v":3198.1428571428573},{"$f":"E220","v":3198.1428571428573},"-","-"]
["San Luis Canal - Tracy","Panoche WD - SLC","-",{"$f":"MACRO_INPUT!D282","v":18367.428571428572},18367.428571428572,18367.428571428572,"-",{"$f":"E221","v":18367.428571428572},{"$f":"E221","v":18367.428571428572},{"$f":"E221","v":18367.428571428572},{"$f":"E221","v":18367.428571428572},{"$f":"E221","v":18367.428571428572}]
["San Luis Canal - Tracy","San Luis WD - SLC","3/",{"$f":"MACRO_INPUT!D283","v":29434.285714285714},29434.285714285714,29434.285714285714,"-",{"$f":"E222","v":29434.285714285714},{"$f":"E222","v":29434.285714285714},{"$f":"E222-F222*MACRO_INPUT!F7","v":27320.891072706316},{"$f":"E222","v":29434.285714285714},{"$f":"E222","v":29434.285714285714}]
["Total","     Total San Luis Canal - Tracy","-",{"$f":"SUBTOTAL(9,D220:D222)","v":50999.857142857145},{"$f":"SUBTOTAL(9,E220:E222)","v":50999.857142857145},{"$f":"SUBTOTAL(9,F220:F222)","v":50999.857142857145},"-",{"$f":"SUBTOTAL(9,H220:H222)","v":50999.857142857145},{"$f":"SUBTOTAL(9,I220:I222)","v":50999.857142857145},{"$f":"SUBTOTAL(9,J220:J222)","v":48886.462501277747},{"$f":"SUBTOTAL(9,K220:K222)","v":47801.71428571429},{"$f":"SUBTOTAL(9,L220:L222)","v":47801.71428571429}]
["Tehama-Colusa Canal","4-M WD","-",{"$f":"MACRO_INPUT!D288","v":1429.8571428571429},{"$f":"D224","v":1429.8571428571429},{"$f":"E224","v":1429.8571428571429},"-","-","-","-","-","-"]
["Tehama-Colusa Canal","Colusa County WD","-",{"$f":"MACRO_INPUT!D289","v":23661.857142857141},23661.857142857141,23661.857142857141,"-","-","-","-",{"$f":"E225","v":23661.857142857141},"-"]
["Tehama-Colusa Canal","Cortina WD","-",{"$f":"MACRO_INPUT!D290","v":725.28571428571433},725.28571428571433,725.28571428571433,"-","-","-","-",{"$f":"E226","v":725.28571428571433},"-"]
["Tehama-Colusa Canal","Davis WD - TCC","-",{"$f":"MACRO_INPUT!D291","v":2722.5714285714284},2722.5714285714284,2722.5714285714284,"-","-","-","-",{"$f":"E227","v":2722.5714285714284},"-"]
["Tehama-Colusa Canal","Dunnigan WD","-",{"$f":"MACRO_INPUT!D292","v":6186.2857142857147},6186.2857142857147,6186.2857142857147,"-","-","-","-",{"$f":"E228","v":6186.2857142857147},"-"]
["Tehama-Colusa Canal","Glenn Valley WD","-",{"$f":"MACRO_INPUT!D293","v":963.57142857142856},963.57142857142856,963.57142857142856,"-","-","-","-","-","-"]
["Tehama-Colusa Canal","Glide WD","-",{"$f":"MACRO_INPUT!D294","v":4689.1428571428569},4689.1428571428569,4689.1428571428569,"-","-","-","-","-","-"]
["Tehama-Colusa Canal","Holthouse WD","-",{"$f":"MACRO_INPUT!D295","v":251.85714285714286},251.85714285714286,251.85714285714286,"-","-","-","-","-","-"]
["Tehama-Colusa Canal","Kanawha WD","-",{"$f":"MACRO_INPUT!D296","v":19964.571428571428},19964.571428571428,19964.571428571428,"-","-","-","-",{"$f":"E232","v":19964.571428571428},"-"]
["Tehama-Colusa Canal","Kirkwood WD","-",{"$f":"MACRO_INPUT!D297","v":300},300,300,"-","-","-","-","-","-"]
["Tehama-Colusa Canal","La Grande WD","-",{"$f":"MACRO_INPUT!D298","v":2868},2868,2868,"-","-","-","-","-","-"]
["Tehama-Colusa Canal","Myers-Marsh MWC","-",{"$f":"MACRO_INPUT!D299","v":29.857142857142858},29.857142857142858,29.857142857142858,"-","-","-","-","-","-"]
["Tehama-Colusa Canal","Orland-Artois WD","-",{"$f":"MACRO_INPUT!D300","v":17550.714285714286},17550.714285714286,17550.714285714286,"-","-","-","-",{"$f":"E236","v":17550.714285714286},"-"]
["Tehama-Colusa Canal","Westside WD","-",{"$f":"MACRO_INPUT!D301","v":29097.857142857141},29097.857142857141,29097.857142857141,"-","-","-","-",{"$f":"E237","v":29097.857142857141},"-"]
["Total","     Total Tehama-Colusa Canal","-",{"$f":"SUBTOTAL(9,D224:D237)","v":110441.42857142857},{"$f":"SUBTOTAL(9,E224:E237)","v":110441.42857142857},{"$f":"SUBTOTAL(9,F224:F237)","v":110441.42857142857},"-","-","-","-",{"$f":"SUBTOTAL(9,K224:K237)","v":99909.142857142855},"-"]
["Subtotal","Subtotal","-",{"$f":"D238+D223+D219+D216+D213+D112+D105+D102+D96+D99+D79+D56+D54+D45+D32+D24+D22+D18+D16+D14+D12","v":1459411.7171428567},1459411.7171428567,1158469.8599999999,5423.2857142857138,571085.85714285716,472672.42857142858,462751.74821556342,590788.14285714296,447547.71428571432]
["Delta-Mendota Exchange Water","Delta-Mendota Exchange Water","-",{"$f":"MACRO_INPUT!D305","v":519504.30089314282},"-","-","-",{"$f":"D240","v":519504.30089314282},"-","-","-","-"," "]
["Grand Total","Total","-",{"$f":"SUM(D239:D240)","v":1978916.0180359995},1459411.7171428567,1158469.8599999999,5423.2857142857138,1090590.1580360001,472672.42857142858,462751.74821556342,590788.14285714296,447547.71428571432]

{"sheet":"Footnotes","index":4,"n_rows":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[{"$f":"INFORMATION!$A$2","v":"Special Rates 2023 Sch S-5.Z25.XLSM"}]
[{"$f":"INFORMATION!A3","v":"01/03/2023"}]
[{"$f":"INFORMATION!A4","v":"CENTRAL VALLEY PROJECT"}]
[{"$f":"INFORMATION!A5","v":"SCHEDULE OF 2023 PROJECTED IRRIGATION DELIVERIES"}]
[{"$f":"INFORMATION!A6","v":"BY CONSTRUCTION COST COMPONENT AND CONTRACTOR "}]
[{"$f":"INFORMATION!A7","v":"2023 SPECIAL WATER RATES"}]
[]
["Footnotes:"]
[]
["1/"]
["These contractors are responsible for that portion of the Jones Pumping Plant's costs applicable to pumping the Delta-Mendota Exchange Water."]
["The computation of the amount assigned to these contractors is shown in Irrigation Water Rates, Schedule A-4."]
[]
["2/"]
["For Santa Clara Valley WD and San Benito County WD, capital costs associated with out-of basin facilities are recovered through a separate repayment contract."]
[]
["3/"]
["Dos Amigos pumped AF are determined in Sch A-12."]
[]
["*"]
["See Irrigation Water Rates, Schedule A-13 Page 36 for name changes"]