{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["INFORMATION","Flow Chart","MACRO_INPUT","OUTPUT"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":6,"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":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":true,"merged":[[3,0,3,7],[4,0,4,7],[5,0,5,7]]}
["Special Rates 2023 Sch S-6.Z25.XLSM"]
["01/05/2023"]
[]
["SCHEDULE OF 2023 PROJECTED M&I DELIVERIES"]
["BY CAPITAL COST COMPONENT AND CONTRACTOR"]
["2023 SPECIAL WATER RATES"]
[null,null,"SPECIAL FILE INFORMATION"]
[]
[]
[]
[null,null,"SOURCE DATA:"]
[]
[]
[null,"SEE FLOW CHART"]
[]
[]
["10/19/2022","jm","Updated file names, title, headings, and date"]
[null,null,"updated and ran macro"]
["01/05/2023","KJ","Review"]

{"sheet":"Flow Chart","index":1,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":true,"merged":[[2,0,2,6],[3,0,3,6],[4,0,4,6]]}
[{"$f":"INFORMATION!A1","v":"Special Rates 2023 Sch S-6.Z25.XLSM"}]
[{"$f":"INFORMATION!$A$2","v":"01/05/2023"}]
[{"$f":"INFORMATION!A4","v":"SCHEDULE OF 2023 PROJECTED M&I DELIVERIES"}]
[{"$f":"INFORMATION!A5","v":"BY CAPITAL COST COMPONENT AND CONTRACTOR"}]
[{"$f":"INFORMATION!A6","v":"2023 SPECIAL WATER RATES"}]

{"sheet":"MACRO_INPUT","index":2,"n_rows":152,"n_cols":65,"rows_kept":152,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,"San Luis WD"]
[null,null,null,null,null,"Excluded Deliveries (before Dos Amigos PP)"]
[null,null,null,null,null,"Data from Schedule A-12"]
["SCHEDULE OF PROJECTED 2022 M&I WATER DELIVERIES  "]
["FOR CALCULATION OF OPERATION AND MAINTENANCE RATES (DELIVERIES IN ACRE-FEET)",null,null,null,null,435]
["2022 M&I WATER RATES"]
[]
[]
[]
[null,null,"2022 Projected O&M Del."]
["Facility/Contractor"]
[]
[]
["Black Butte D&R"]
[null,"County of Colusa",6.5714285714285712]
[null,"Elk Creek CSD",14]
[null,"US Forest Service - BB",9.8571428571428577]
[null,"Whitney Const.",4]
[null,"Total Black Butte D&R",34.428571428571431]
[]
[]
["Clear Creek Unit"]
[null,"Clear Creek CSD",1651.1428571428571]
[]
[]
["Contra Costa Canal",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,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,"SUNFLOWER"]
[null,"Contra Costa WD   ",80723.71428571429,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,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,"","PW",null,"WD"]
[null,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,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,null,null,null,null,null,null,null,85]
["Cow Creek Unit"]
[null,"Bella Vista WD",3730.2857142857142]
[]
[]
["Cross Valley Canal"]
[null,"County of Fresno",86]
[null,"County of Tulare",192]
[null,"Total Cross Valley Canal",278]
[]
[]
["Delta-Mendota Canal"]
[null,"Byron Bethany ID",884.28571428571433]
[null,"City of Tracy",6594.5714285714284]
[null,"Del Puerto WD",3]
[null,"Department of VA",367.14285714285717]
[null,"Panoche WD",23.428571428571427]
[null,"San Luis WD",32]
[null,"Total Delta-Mendota Canal",7904.4285714285716]
[]
[]
[]
["Folsom D&R"]
[null,"City of Folsom",3306]
[null,"City of Roseville",22126.571428571428]
[null,"El Dorado ID - FD&R",3913]
[null,"Placer County WA",5000]
[null,"Sacramento County WA",3600.7142857142858]
[null,"San Juan  WD ",175.71428571428572]
[null,"Total Folsom D&R",38121.999999999993]
[]
[]
["Folsom-South Canal"]
[null,"East Bay MUD",6645.4285714285716]
[null,"Sacramento County WA - FSC",4286]
[null,"Sacramento MUD",4286]
[null,"Total Folsom-South Canal",15217.428571428572]
[]
[]
["Friant Dam"]
[null,"County of Madera",69.571428571428569]
[null,"Fresno County WW#18",100.57142857142857]
[null,"Total Friant Dam",170.14285714285714]
[]
[]
["Friant-Kern Canal"]
[null,"Arvin-Edison WSD",425.42857142857144]
[null,"City of Fresno",38550.857142857145]
[null,"City of Lindsay",1535]
[null,"City of Orange Cove",1100.8571428571429]
[null,"Delano-Earlimart ID",259.71428571428572]
[null,"Lindsay-Strathmore ID",584.57142857142856]
[null,"Shafter-Wasco ID",108.85714285714286]
[null,"Terra Bella ID",1345.1428571428571]
[null,"Total Friant-Kern Canal",43910.428571428572]
[]
[]
["New Melones Unit"]
[null,"Stockton East WD",24507.142857142859]
[]
[]
[]
["Sacramento River"]
[null,"City of Redding - SR",2681]
[null,"City of West Sacramento",5797.8571428571431]
[null,"Lake California P.O.A.",185.71428571428572]
[null,"Riverview Golf & CC",20.571428571428573]
[null,"Total Sacramento River",8685.1428571428587]
[]
[]
["San Felipe Unit"]
[null,"San Benito County WD",5210.1428571428569]
[null,"Santa Clara Valley WD",81377]
[null,"Total San Felipe Unit",86587.142857142855]
[]
[]
["San Luis Canal - Fresno"]
[null,"City of Avenal",2300.5714285714284]
[null,"City of Coalinga",5618.2857142857147]
[null,"City of Huron",1033.4285714285713]
[null,"State of CA",1.8571428571428572]
[null,"Westlands WD",2797]
[null,"Total San Luis Canal - Fresno",11751.142857142857]
[]
[]
["San Luis Canal - Tracy"]
[null,"Pacheco WD - SLC",11]
[null,"Panoche WD - SLC",136.57142857142858]
[null,"San Luis WD - SLC",454.71428571428572]
[null,"Total San Luis Canal - Tracy",602.28571428571433]
[]
[]
["Shasta D&R"]
[null,"Centerville CSD",527.57142857142856]
[null,"Mountain Gate CSD",464.71428571428572]
[null,"Shasta CWA ",97.714285714285708]
[null,"Total Shasta D&R",1090]
[]
[]
[]
["Spring Creek Conduit"]
[null,"City of Redding - SCC",5136.2857142857147]
[null,"Shasta CWA - SCC",73.142857142857139]
[null,"Shasta CSD",252]
[null,"Total Spring Creek Conduit",5461.4285714285716]
[]
[]
["Tehama Colusa Canal"]
[null,"Colusa County WD",129.28571428571428]
[null,"Kanawha WD",26.857142857142858]
[null,"Total Tehama-Colusa Canal",156.14285714285714]
[]
[]
["Toyon Pipeline"]
[null,"City of Redding - TP",17.428571428571427]
[null,"City of Shasta Lake",1167.8571428571429]
[null,"US Forest Service",1]
[null,"Total Toyon Pipeline",1186.2857142857142]
[]
[]
[null,"Total Permanent Contractors  ",331768.71428571438]
[]
[]
[null,"Delta Mendota Exchange",46430.984821142862]

{"sheet":"OUTPUT","index":3,"n_rows":96,"n_cols":10,"rows_kept":96,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"INFORMATION!A1","v":"Special Rates 2023 Sch S-6.Z25.XLSM"}]
[{"$f":"INFORMATION!$A$2","v":"01/05/2023"}]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF 2023 PROJECTED M&I DELIVERIES"]
["BY CONSTRUCTION COST COMPONENT AND CONTRACTOR\t\t\t\t\t"]
["2023 SPECIAL WATER RATES"]
["Category","A) Facility/Contractor","B) Projected\n2023\nDeliveries\n<Sch A-13>","C) 2023 Projected M&I: Deliveries Storage\n<Sch A-13>","D) 2023 Projected M&I: Conveyance\n<Sch A-13>","E) 2023 Projected M&I: Conveyance Pumping\nDos Amigos\nPP\n<Sch A-13>","F) 2023 Projected M&I: Conveyance Pumping\nO'Neill\nPG\n<Sch A-13>","G) 2023 Projected M&I: Conveyance Pumping\nJones\nPP\n<Sch A-13>","H) 2023 Projected M&I: Direct\nPumping\n<Sch A-13>"]
["Black Butte D&R","County of Colusa",{"$f":"MACRO_INPUT!C15","v":6.5714285714285712},{"$f":"C9","v":6.5714285714285712},"-","-","-","-","-"]
["Black Butte D&R","Black Butte D&R: Elk Creek CSD",{"$f":"MACRO_INPUT!C16","v":14},{"$f":"C10","v":14},"-","-","-","-","-"]
["Black Butte D&R","U. S. Forest Service - BB",{"$f":"MACRO_INPUT!C17","v":9.8571428571428577},{"$f":"C11","v":9.8571428571428577},"-","-","-","-","-"]
["Black Butte D&R","Whitney Const Inc.",{"$f":"MACRO_INPUT!C18","v":4},{"$f":"C12","v":4},"-","-","-","-","-"]
["Total",{"$f":"CONCATENATE(\"Total \",A12)","v":"Total Black Butte D&R"},{"$f":"SUBTOTAL(9,C9:C12)","v":34.428571428571431},{"$f":"SUBTOTAL(9,D9:D12)","v":34.428571428571431},"-","-","-","-","-"]
["Clear Creek Unit","Clear Creek CSD",{"$f":"MACRO_INPUT!C23","v":1651.1428571428571},{"$f":"C14","v":1651.1428571428571},{"$f":"C14","v":1651.1428571428571},"-","-","-","-"]
["Total",{"$f":"CONCATENATE(\"Total \",A14)","v":"Total Clear Creek Unit"},{"$f":"C14","v":1651.1428571428571},1651.1428571428571,1651.1428571428571,"-","-","-","-"]
["Contra Costa Canal","Contra Costa WD",{"$f":"MACRO_INPUT!C27","v":80723.71428571429},{"$f":"C16","v":80723.71428571429},"-","-","-","-",{"$f":"C16","v":80723.71428571429}]
["Total",{"$f":"CONCATENATE(\"Total \",A16)","v":"Total Contra Costa Canal"},{"$f":"C16","v":80723.71428571429},80723.71428571429,"-","-","-","-",80723.71428571429]
["Cow Creek Unit","Bella Vista WD",{"$f":"MACRO_INPUT!C31","v":3730.2857142857142},{"$f":"C18","v":3730.2857142857142},{"$f":"C18","v":3730.2857142857142},"-","-","-",{"$f":"C18","v":3730.2857142857142}]
["Total",{"$f":"CONCATENATE(\"Total \",A18)","v":"Total Cow Creek Unit"},{"$f":"C18","v":3730.2857142857142},3730.2857142857142,3730.2857142857142,"-","-","-",3730.2857142857142]
["Cross Valley Canal","County of Fresno",{"$f":"MACRO_INPUT!C35","v":86},{"$f":"C20","v":86},"-",{"$f":"C20","v":86},"-","-",{"$f":"C20","v":86}]
["Cross Valley Canal","County of Tulare",{"$f":"MACRO_INPUT!C36","v":192},{"$f":"C21","v":192},"-",{"$f":"C21","v":192},"-","-",{"$f":"C21","v":192},""]
["Total",{"$f":"CONCATENATE(\"Total \",A21)","v":"Total Cross Valley Canal"},{"$f":"SUBTOTAL(9,C20:C21)","v":278},{"$f":"SUBTOTAL(9,D20:D21)","v":278},"-",{"$f":"SUBTOTAL(9,F20:F21)","v":278},"-","-",{"$f":"SUBTOTAL(9,I20:I21)","v":278}]
["Delta-Mendota Canal","Byron Bethany ID   ",{"$f":"MACRO_INPUT!C41","v":884.28571428571433},{"$f":"C23","v":884.28571428571433},{"$f":"C23","v":884.28571428571433},"-","-",{"$f":"C23","v":884.28571428571433},"-"]
["Delta-Mendota Canal","City of Tracy",{"$f":"MACRO_INPUT!C42","v":6594.5714285714284},6594.5714285714284,6594.5714285714284,"-","-",6594.5714285714284,"-"]
["Delta-Mendota Canal","Del Puerto WD",{"$f":"MACRO_INPUT!C43","v":3},3,3,"-","-",3,"-"]
["Delta-Mendota Canal","Department of Veterans Affairs",{"$f":"MACRO_INPUT!C44","v":367.14285714285717},367.14285714285717,367.14285714285717,"-","-",367.14285714285717,"-"]
["Delta-Mendota Canal","Panoche WD - DMC",{"$f":"MACRO_INPUT!C45","v":23.428571428571427},23.428571428571427,23.428571428571427,"-","-",23.428571428571427,"-"]
["Delta-Mendota Canal","San Luis WD - DMC",{"$f":"MACRO_INPUT!C46","v":32},32,32,"-","-",32,"-"]
["Total",{"$f":"CONCATENATE(\"Total \",A28)","v":"Total Delta-Mendota Canal"},{"$f":"SUBTOTAL(9,C23:C28)","v":7904.4285714285716},{"$f":"SUBTOTAL(9,D23:D28)","v":7904.4285714285716},{"$f":"SUBTOTAL(9,E23:E28)","v":7904.4285714285716},"-","-",{"$f":"SUBTOTAL(9,H23:H28)","v":7904.4285714285716},"-"]
["Folsom D&R","City of Folsom",{"$f":"MACRO_INPUT!C52","v":3306},{"$f":"C30","v":3306},"-","-","-","-","-"]
["Folsom D&R","City of Roseville",{"$f":"MACRO_INPUT!C53","v":22126.571428571428},22126.571428571428,"-","-","-","-","-"]
["Folsom D&R","El Dorado ID - FD&R",{"$f":"MACRO_INPUT!C54","v":3913},3913,"-","-","-","-","-"]
["Folsom D&R","Placer County WA",{"$f":"MACRO_INPUT!C55","v":5000},5000,"-","-","-","-","-"]
["Folsom D&R","Sacramento County WA  ",{"$f":"MACRO_INPUT!C56","v":3600.7142857142858},3600.7142857142858,"-","-","-","-","-"]
["Folsom D&R","San Juan  WD",{"$f":"MACRO_INPUT!C57","v":175.71428571428572},175.71428571428572,"-","-","-","-","-"]
["Total",{"$f":"CONCATENATE(\"Total \",A35)","v":"Total Folsom D&R"},{"$f":"SUBTOTAL(9,C30:C35)","v":38121.999999999993},{"$f":"SUBTOTAL(9,D30:D35)","v":38121.999999999993},"-","-","-","-","-"]
["Folsom-South Canal","East Bay MUD",{"$f":"MACRO_INPUT!C62","v":6645.4285714285716},{"$f":"C37","v":6645.4285714285716},{"$f":"C37","v":6645.4285714285716},"-","-","-","-"]
["Folsom-South Canal","County WA - FSC",{"$f":"MACRO_INPUT!C63","v":4286},{"$f":"C38","v":4286},{"$f":"C38","v":4286},"-","-","-","-"]
["Folsom-South Canal","Sacramento MUD",{"$f":"MACRO_INPUT!C64","v":4286},{"$f":"C39","v":4286},{"$f":"C39","v":4286},"-","-","-","-"]
["Total",{"$f":"CONCATENATE(\"Total \",A39)","v":"Total Folsom-South Canal"},{"$f":"SUBTOTAL(9,C37:C39)","v":15217.428571428572},{"$f":"SUBTOTAL(9,D37:D39)","v":15217.428571428572},{"$f":"SUBTOTAL(9,E37:E39)","v":15217.428571428572},"-","-","-","-"]
["Friant Dam 1/:","County of Madera",{"$f":"MACRO_INPUT!C69","v":69.571428571428569},{"$f":"C41","v":69.571428571428569},"-","-","-","-","-"]
["Friant Dam 1/:","Fresno County WW #18",{"$f":"MACRO_INPUT!C70","v":100.57142857142857},{"$f":"C42","v":100.57142857142857},"-","-","-","-","-"]
["Total",{"$f":"CONCATENATE(\"Total \",A42)","v":"Total Friant Dam 1/:"},{"$f":"SUBTOTAL(9,C41:C42)","v":170.14285714285714},{"$f":"SUBTOTAL(9,D41:D42)","v":170.14285714285714},"-","-","-","-","-"]
["Friant-Kern Canal 1/","Arvin-Edison WSD",{"$f":"MACRO_INPUT!C75","v":425.42857142857144},{"$f":"C44","v":425.42857142857144},{"$f":"C44","v":425.42857142857144},"-","-","-","-"]
["Friant-Kern Canal 1/","City of Fresno",{"$f":"MACRO_INPUT!C76","v":38550.857142857145},38550.857142857145,38550.857142857145,"-","-","-","-"]
["Friant-Kern Canal 1/","City of Lindsay",{"$f":"MACRO_INPUT!C77","v":1535},1535,1535,"-","-","-","-"]
["Friant-Kern Canal 1/","City of Orange Cove",{"$f":"MACRO_INPUT!C78","v":1100.8571428571429},1100.8571428571429,1100.8571428571429,"-","-","-","-"]
["Friant-Kern Canal 1/","Delano-Earlimart ID ",{"$f":"MACRO_INPUT!C79","v":259.71428571428572},259.71428571428572,259.71428571428572,"-","-","-","-"]
["Friant-Kern Canal 1/","Lindsay-Strathmore ID",{"$f":"MACRO_INPUT!C80","v":584.57142857142856},584.57142857142856,584.57142857142856,"-","-","-","-"]
["Friant-Kern Canal 1/","Shafter-Wasco ID",{"$f":"MACRO_INPUT!C81","v":108.85714285714286},108.85714285714286,108.85714285714286,"-","-","-","-"]
["Friant-Kern Canal 1/","Terra Bella ID",{"$f":"MACRO_INPUT!C82","v":1345.1428571428571},1345.1428571428571,1345.1428571428571,"-","-","-","-"]
["Total",{"$f":"CONCATENATE(\"Total \",A51)","v":"Total Friant-Kern Canal 1/"},{"$f":"SUBTOTAL(9,C44:C51)","v":43910.428571428572},{"$f":"SUBTOTAL(9,D44:D51)","v":43910.428571428572},{"$f":"SUBTOTAL(9,E44:E51)","v":43910.428571428572},"-","-","-","-"]
["New Melones D & R","Stockton-East WD",{"$f":"MACRO_INPUT!C87","v":24507.142857142859},{"$f":"C53","v":24507.142857142859},"-","-","-","-","-"]
["Total",{"$f":"CONCATENATE(\"Total \",A53)","v":"Total New Melones D & R"},{"$f":"C53","v":24507.142857142859},24507.142857142859,"-","-","-","-","-"]
["Sacramento River","City of Redding - SR  ",{"$f":"MACRO_INPUT!C92","v":2681},{"$f":"C55","v":2681},"-","-","-","-","-"]
["Sacramento River","City of W. Sacramento",{"$f":"MACRO_INPUT!C93","v":5797.8571428571431},{"$f":"C56","v":5797.8571428571431},"-","-","-","-","-"]
["Sacramento River","Lake California P.O.A.",{"$f":"MACRO_INPUT!C94","v":185.71428571428572},{"$f":"C57","v":185.71428571428572},"-","-","-","-","-"]
["Sacramento River","Riverview Golf & CC",{"$f":"MACRO_INPUT!C95","v":20.571428571428573},{"$f":"C58","v":20.571428571428573},"-","-","-","-","-"]
["Total",{"$f":"CONCATENATE(\"Total \",A58)","v":"Total Sacramento River"},{"$f":"SUBTOTAL(9,C55:C58)","v":8685.1428571428587},{"$f":"SUBTOTAL(9,D55:D58)","v":8685.1428571428587},"-","-","-","-","-"]
["San Felipe Unit","San Benito County WD",{"$f":"MACRO_INPUT!C100","v":5210.1428571428569},{"$f":"C60","v":5210.1428571428569},{"$f":"C60","v":5210.1428571428569},"-",{"$f":"C60","v":5210.1428571428569},{"$f":"C60","v":5210.1428571428569},{"$f":"C60","v":5210.1428571428569}]
["San Felipe Unit","Santa Clara Valley WD",{"$f":"MACRO_INPUT!C101","v":81377},{"$f":"C61","v":81377},{"$f":"C61","v":81377},"-",{"$f":"C61","v":81377},{"$f":"C61","v":81377},{"$f":"C61","v":81377}]
["Total",{"$f":"CONCATENATE(\"Total \",A61)","v":"Total San Felipe Unit"},{"$f":"SUBTOTAL(9,C60:C61)","v":86587.142857142855},{"$f":"SUBTOTAL(9,D60:D61)","v":86587.142857142855},{"$f":"SUBTOTAL(9,E60:E61)","v":86587.142857142855},"-",{"$f":"SUBTOTAL(9,G60:G61)","v":86587.142857142855},{"$f":"SUBTOTAL(9,H60:H61)","v":86587.142857142855},{"$f":"SUBTOTAL(9,I60:I61)","v":86587.142857142855}]
["San Luis Canal - Fresno","City of Avenal",{"$f":"MACRO_INPUT!C106","v":2300.5714285714284},{"$f":"C63","v":2300.5714285714284},{"$f":"C63","v":2300.5714285714284},{"$f":"C63","v":2300.5714285714284},{"$f":"C63","v":2300.5714285714284},{"$f":"C63","v":2300.5714285714284},"-"]
["San Luis Canal - Fresno","City of Coalinga",{"$f":"MACRO_INPUT!C107","v":5618.2857142857147},{"$f":"C64","v":5618.2857142857147},{"$f":"C64","v":5618.2857142857147},{"$f":"C64","v":5618.2857142857147},{"$f":"C64","v":5618.2857142857147},{"$f":"C64","v":5618.2857142857147},{"$f":"C64","v":5618.2857142857147}]
["San Luis Canal - Fresno","City of Huron",{"$f":"MACRO_INPUT!C108","v":1033.4285714285713},{"$f":"C65","v":1033.4285714285713},{"$f":"C65","v":1033.4285714285713},{"$f":"C65","v":1033.4285714285713},{"$f":"C65","v":1033.4285714285713},{"$f":"C65","v":1033.4285714285713},"-"]
["San Luis Canal - Fresno","State of CA",{"$f":"MACRO_INPUT!C109","v":1.8571428571428572},{"$f":"C66","v":1.8571428571428572},{"$f":"C66","v":1.8571428571428572},{"$f":"C66","v":1.8571428571428572},{"$f":"C66","v":1.8571428571428572},{"$f":"C66","v":1.8571428571428572},"-"]
["San Luis Canal - Fresno","Westlands WD",{"$f":"MACRO_INPUT!C110","v":2797},{"$f":"C67","v":2797},{"$f":"C67","v":2797},{"$f":"C67","v":2797},{"$f":"C67","v":2797},{"$f":"C67","v":2797},{"$f":"C67","v":2797}]
["Total",{"$f":"CONCATENATE(\"Total \",A67)","v":"Total San Luis Canal - Fresno"},{"$f":"SUBTOTAL(9,C63:C67)","v":11751.142857142857},11751.142857142857,11751.142857142857,11751.142857142857,11751.142857142857,11751.142857142857,8415.2857142857138]
["San Luis Canal - Tracy","Pacheco WD",{"$f":"MACRO_INPUT!C115","v":11},{"$f":"C69","v":11},{"$f":"C69","v":11},{"$f":"C69","v":11},{"$f":"C69","v":11},{"$f":"C69","v":11},"-"]
["San Luis Canal - Tracy","Panoche WD",{"$f":"MACRO_INPUT!C116","v":136.57142857142858},{"$f":"C70","v":136.57142857142858},{"$f":"C70","v":136.57142857142858},{"$f":"C70","v":136.57142857142858},{"$f":"C70","v":136.57142857142858},{"$f":"C70","v":136.57142857142858},"-"]
["San Luis Canal - Tracy","San Luis WD  2/",{"$f":"MACRO_INPUT!C117","v":454.71428571428572},{"$f":"C71","v":454.71428571428572},{"$f":"C71","v":454.71428571428572},{"$f":"+MACRO_INPUT!C117-MACRO_INPUT!F5","v":19.714285714285722},{"$f":"C71","v":454.71428571428572},{"$f":"C71","v":454.71428571428572},{"$f":"C71","v":454.71428571428572}]
["Total",{"$f":"CONCATENATE(\"Total \",A71)","v":"Total San Luis Canal - Tracy"},{"$f":"SUBTOTAL(9,C69:C71)","v":602.28571428571433},602.28571428571433,602.28571428571433,167.28571428571431,602.28571428571433,602.28571428571433,454.71428571428572]
["Shasta D&R","Centerville CSD",{"$f":"MACRO_INPUT!C122","v":527.57142857142856},{"$f":"C73","v":527.57142857142856},"-","-","-","-","-"]
["Shasta D&R","Mountain Gate CSD",{"$f":"MACRO_INPUT!C123","v":464.71428571428572},{"$f":"C74","v":464.71428571428572},"-","-","-","-","-"]
["Shasta D&R","Shasta CWA",{"$f":"MACRO_INPUT!C124","v":97.714285714285708},{"$f":"C75","v":97.714285714285708},"-","-","-","-","-"]
["Total",{"$f":"CONCATENATE(\"Total \",A75)","v":"Total Shasta D&R"},{"$f":"SUBTOTAL(9,C73:C75)","v":1090},{"$f":"SUBTOTAL(9,D73:D75)","v":1090},"-","-","-","-","-"]
["Spring Creek Conduit","City of Redding - SCC  ",{"$f":"MACRO_INPUT!C130","v":5136.2857142857147},{"$f":"C77","v":5136.2857142857147},"-","-","-","-","-"]
["Spring Creek Conduit","Shasta CWA - SCC",{"$f":"MACRO_INPUT!C131","v":73.142857142857139},{"$f":"C78","v":73.142857142857139},"-","-","-","-","-"]
["Spring Creek Conduit","Shasta CSD",{"$f":"MACRO_INPUT!C132","v":252},{"$f":"C79","v":252},"-","-","-","-","-"]
["Total",{"$f":"CONCATENATE(\"Total \",A79)","v":"Total Spring Creek Conduit"},{"$f":"SUBTOTAL(9,C77:C79)","v":5461.4285714285716},{"$f":"SUBTOTAL(9,D77:D79)","v":5461.4285714285716},"-","-","-","-","-"]
["Tehama-Colusa Canal","Colusa County WD",{"$f":"MACRO_INPUT!C137","v":129.28571428571428},{"$f":"C81","v":129.28571428571428},{"$f":"C81","v":129.28571428571428},"-","-","-",{"$f":"C81","v":129.28571428571428}]
["Tehama-Colusa Canal","Kanawha WD",{"$f":"MACRO_INPUT!C138","v":26.857142857142858},{"$f":"C82","v":26.857142857142858},{"$f":"+C82","v":26.857142857142858},"-","-","-",{"$f":"C82","v":26.857142857142858}]
["Total",{"$f":"CONCATENATE(\"Total \",A82)","v":"Total Tehama-Colusa Canal"},{"$f":"SUBTOTAL(9,C81:C82)","v":156.14285714285714},{"$f":"SUBTOTAL(9,D81:D82)","v":156.14285714285714},{"$f":"SUBTOTAL(9,E81:E82)","v":156.14285714285714},"-","-","-",{"$f":"SUBTOTAL(9,I81:I82)","v":156.14285714285714}]
["Toyon Pipeline","City of Redding - TP",{"$f":"MACRO_INPUT!C143","v":17.428571428571427},{"$f":"C84","v":17.428571428571427},{"$f":"C84","v":17.428571428571427},"-","-","-","-"]
["Toyon Pipeline","City of Shasta Lake ",{"$f":"MACRO_INPUT!C144","v":1167.8571428571429},{"$f":"C85","v":1167.8571428571429},{"$f":"C85","v":1167.8571428571429},"-","-","-",{"$f":"C85","v":1167.8571428571429}]
["Toyon Pipeline","U.S. Forest Service",{"$f":"MACRO_INPUT!C145","v":1},{"$f":"C86","v":1},{"$f":"C86","v":1},"-","-","-","-"]
["Total",{"$f":"CONCATENATE(\"Total \",A86)","v":"Total Toyon Pipeline"},{"$f":"SUBTOTAL(9,C84:C86)","v":1186.2857142857142},{"$f":"SUBTOTAL(9,D84:D86)","v":1186.2857142857142},{"$f":"SUBTOTAL(9,E84:E86)","v":1186.2857142857142},"-","-","-",{"$f":"SUBTOTAL(9,I84:I86)","v":1167.8571428571429}]
["Subtotal","Subtotal",{"$f":"C87+C83+C80+C76+C72+C68+C62+C59+C54+C52+C43+C40+C36+C29+C22+C19+C17+C15+C13","v":331768.71428571432},{"$f":"D87+D83+D80+D76+D72+D68+D62+D59+D54+D52+D43+D40+D36+D29+D22+D19+D17+D15+D13","v":331768.71428571432},172696.71428571432,12196.428571428571,98940.57142857142,106844.99999999999,181513.14285714284]
["-","-","-","-","-","-","-","-","-"]
["Delta-Mendota Exchange","Delta-Mendota Exchange",{"$f":"MACRO_INPUT!C152","v":46430.984821142862},"-","-","-","-",{"$f":"C90","v":46430.984821142862},"-"]
["-","-","-","-","-","-","-","-","-"]
["Total","Total",{"$f":"+C88+C90","v":378199.69910685718},331768.71428571432,172696.71428571432,12196.428571428571,98940.57142857142,153275.98482114286,181513.14285714284]
[]
["Footnotes:"]
["1/ These contractors are responsible for that portion of the Jones Pumping Plant costs applicable to Pumping the Delta-Mendota Exchange Water."]
["2/ Dos Amigos pumped AF are determined in Sch A-12"]