{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["OUTPUT","Footnotes"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"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":"OUTPUT","index":0,"n_rows":74,"n_cols":16,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
[]
["M&I 2024 Sch A-2A F.Z26.XLSM"]
["01/18/2024"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF M&I COST OF SERVICE AND PROJECT USE ENERGY (PUE) WATER RATES PER ACRE-FOOT BY CONTRACTOR"]
["2024 M&I WATER RATES"]
[]
["Category","A) Contractor","B) Construction Cost Per A/F\n\n<Sch. A-2Ba>","C) Folsom Safety of Dams (FSOD)\nConstruction\nCost Per A/F\n<Sch.  A-2Bc_FSOD>","D) Estimated O&M Cost Per A/F: Water Mrktg\n\n<Sch A-8>\n","E) Estimated O&M Cost Per A/F: Storage (Includes Offset)\n\n<Sch A-8>","F) Estimated O&M Cost Per A/F: Direct Pumping Offset\n\n<Sch A-11>","G) Estimated O&M Cost Per A/F: Conveyance  1/\n\n<Sch A-8>","H) Estimated O&M Cost Per A/F: Conveyance/ Direct Pumping \n\n<Sch. A-8, Sch. A-9>","I) Conveyance/ XM Storage Estimated O&M Costs Per Acre Foot \n<Sch. A-8, Sch. A-8 XM>","J) Estimated O&M Cost Per A/F: Credit for Other PUE Remittance 2/\n\n<Sch A-11>","K) Estimated O&M Cost Per A/F: Total O&M\n\nSUM(D:J)","L) Deficit Cost Per A/F\n  \n<Sch. A-6>","M) Cost of Service Rate\n\n(B+I+J)","N) PUE Direct  Pumping\n\n<Sch A-11>","O) PUE Other PUE Remittance 2/\n\n<Sch A-11>"]
["Black Butte D&R","County of Colusa","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0.35318957142857144,0,{"$f":"SUM(E9:K9)","v":26.463189571428572},{"$f":"[1]MACRO_INPUT!L15","v":3.47},{"$f":"C9+D9+L9+M9","v":30.123189571428572},0,0]
["Black Butte D&R","Elk Creek CSD",0,{"$f":"$D$9","v":0.19},{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0,0,{"$f":"SUM(E10:K10)","v":26.11},{"$f":"[1]MACRO_INPUT!L16","v":6.79},{"$f":"C10+D10+L10+M10","v":33.090000000000003},0,0]
["Black Butte D&R","US Forest Service - BB",6.96,{"$f":"$D$9","v":0.19},{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L17","v":5.03},38.43,0,0]
["Black Butte D&R","Whitney Const.",0,0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0,0,26.11,{"$f":"[1]MACRO_INPUT!L18","v":4.1399999999999997},30.44,0,0]
["Clear Creek Unit","Clear Creek CSD","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L19","v":0.44},26.880000000000003,0,0]
["Contra Costa Canal","Contra Costa WD      ","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},{"$f":"[1]MACRO_INPUT!AO19","v":"-"},{"$f":"[1]MACRO_INPUT!$D$11","v":0},{"$f":"'[1]Manual Input'!G9","v":0},0.14000000000000001,{"$f":"-[1]MACRO_INPUT!AO21","v":-3.8831992148839767},22.366800785116023,{"$f":"[1]MACRO_INPUT!L20","v":1.53},24.086800785116026,{"$f":"[1]MACRO_INPUT!AO18","v":19.809999999999999},{"$f":"[1]MACRO_INPUT!AO21","v":3.8831992148839767}]
["Cow Creek Unit","Bella Vista WD   ","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},{"$f":"[1]MACRO_INPUT!AW19","v":44.35},{"$f":"[1]MACRO_INPUT!$D$11","v":0},{"$f":"'[1]Manual Input'!G22","v":0},0.14000000000000001,0,70.600000000000009,{"$f":"[1]MACRO_INPUT!L21","v":0},70.790000000000006,0,0]
["Cross Valley Canal","County of Fresno","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},{"$f":"[1]MACRO_INPUT!AP19+[1]MACRO_INPUT!AS19","v":28.63},{"$f":"[1]MACRO_INPUT!$D$11","v":0},{"$f":"'[1]Manual Input'!G20+'[1]Manual Input'!G21","v":0},0.03,0,54.769999999999996,{"$f":"[1]MACRO_INPUT!L22","v":112.84},167.8,0,0]
["Cross Valley Canal","County of Tulare","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},{"$f":"[1]MACRO_INPUT!AP19+[1]MACRO_INPUT!AS19","v":28.63},{"$f":"[1]MACRO_INPUT!$D$11","v":0},{"$f":"'[1]Manual Input'!G20+'[1]Manual Input'!G21","v":0},0.01,0,54.749999999999993,{"$f":"[1]MACRO_INPUT!L23","v":142.6},197.54,0,0]
["Delta-Mendota Canal","Byron-Bethany ID","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},{"$f":"[1]MACRO_INPUT!D15","v":0},0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L24","v":1.72},28.16,0,0]
["Delta-Mendota Canal","City of Tracy","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},{"$f":"I$18","v":0},0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L25","v":0.38},26.82,0,0]
["Delta-Mendota Canal","Del Puerto WD","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},{"$f":"I$18","v":0},0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L26","v":0},26.44,0,0]
["Delta-Mendota Canal","Department of VA","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L27","v":2.67},29.11,0,0]
["Delta-Mendota Canal","Panoche WD - DMC","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L28","v":4.66},31.1,0,0]
["Delta-Mendota Canal","San Luis WD - DMC","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L29","v":0},26.44,0,0]
["Delta-Mendota Canal","Santa Nella County WD","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0,0,{"$f":"SUM(E24:K24)","v":26.11},{"$f":"[1]MACRO_INPUT!L30","v":0},26.3,0,0]
["Folsom D&R","City of Folsom","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0.12,0,26.23,{"$f":"[1]MACRO_INPUT!L31","v":0},26.42,0,0]
["Folsom D&R","City of Roseville","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L32","v":0.67},27.110000000000003,0,0]
["Folsom D&R","El Dorado ID - FD&R","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L33","v":0.24},26.68,0,0]
["Folsom D&R","Placer County WA","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0,0,26.11,{"$f":"[1]MACRO_INPUT!L34","v":0.19},26.490000000000002,0,0]
["Folsom D&R","Sacramento County WA","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L35","v":2.38},28.82,0,0]
["Folsom D&R","San Juan  WD  ","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L36","v":0},26.44,0,0]
["Folsom-South Canal","East Bay MUD","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!D$11+[1]MACRO_INPUT!D$12","v":6.55},0,0.14000000000000001,0,32.799999999999997,{"$f":"[1]MACRO_INPUT!L37","v":34.99},67.97999999999999,0,0]
["Folsom-South Canal","Sacramento County WA - FSC","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!D$11+[1]MACRO_INPUT!D$12","v":6.55},0,0.13,0,32.79,{"$f":"[1]MACRO_INPUT!L38","v":13.48},46.459999999999994,0,0]
["Folsom-South Canal","Sacramento MUD","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!D$11+[1]MACRO_INPUT!D$12","v":6.55},0,0.09,0,32.75,{"$f":"[1]MACRO_INPUT!L39","v":2.8},35.739999999999995,0,0]
["Friant Dam","County of Madera","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L40","v":0.65},27.09,0,0]
["Friant Dam","Fresno County WW#18","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L41","v":6.75},33.19,0,0]
["Friant-Kern Canal   ","Arvin-Edison WSD","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L42","v":0.52},26.96,0,0]
["Friant-Kern Canal   ","City of Fresno","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L43","v":0},26.44,0,0]
["Friant-Kern Canal   ","City of Lindsay","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L44","v":2.93},29.37,0,0]
["Friant-Kern Canal   ","City of Orange Cove","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L45","v":2.17},28.61,0,0]
["Friant-Kern Canal   ","Delano-Earlimart ID","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L46","v":0.41},26.85,0,0]
["Friant-Kern Canal   ","Lindsay-Strathmore ID","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L47","v":0.28999999999999998},26.73,0,0]
["Friant-Kern Canal   ","Shafter-Wasco","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0.14000000000000001,0,{"$f":"SUM(E42:K42)","v":26.25},{"$f":"[1]MACRO_INPUT!L48","v":3.03},29.470000000000002,0,0]
["Friant-Kern Canal   ","Terra Bella ID","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L49","v":1.18},27.62,0,0]
["New Melones D & R","Stockton East WD","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L50","v":0},26.44,0,0]
["Sacramento River","City of Redding - SR",3.54,0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L51","v":3.8},33.78,0,0]
["Sacramento River","City of West Sacramento","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L52","v":0.34},26.78,0,0]
["Sacramento River","Lake California P.O.A.",3.72,0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L53","v":0.01},30.17,0,0]
["Sacramento River","Riverview Golf & CC",2.17,0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L54","v":0.73},29.34,0,0]
["San Felipe Unit","SB County WD - IB","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!D16","v":15.28},{"$f":"[1]MACRO_INPUT!AP29+[1]MACRO_INPUT!AR29","v":0},{"$f":"[1]MACRO_INPUT!$D$11","v":0},{"$f":"+[1]MACRO_INPUT!D14+[1]MACRO_INPUT!D15+'[1]Manual Input'!G8+'[1]Manual Input'!G17","v":0},0.14000000000000001,{"$f":"-[1]MACRO_INPUT!AP31-[1]MACRO_INPUT!AR31","v":-3.5937335247580409},22.42626647524196,{"$f":"[1]MACRO_INPUT!L55","v":2.42},25.036266475241959,{"$f":"[1]MACRO_INPUT!AP28+[1]MACRO_INPUT!AR28","v":18.34},{"$f":"[1]MACRO_INPUT!AP31+[1]MACRO_INPUT!AR31","v":3.5937335247580409}]
["San Felipe Unit","SC Valley WD - IB","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!D16","v":15.28},{"$f":"[1]MACRO_INPUT!AP29+[1]MACRO_INPUT!AQ29+[1]MACRO_INPUT!AR29","v":0},{"$f":"[1]MACRO_INPUT!$D$11","v":0},{"$f":"[1]MACRO_INPUT!D14+[1]MACRO_INPUT!D15+'[1]Manual Input'!G8+'[1]Manual Input'!G16+'[1]Manual Input'!G17","v":0},0.14000000000000001,{"$f":"-[1]MACRO_INPUT!AP31-[1]MACRO_INPUT!AQ31-[1]MACRO_INPUT!AR31","v":-3.870352872613624},22.149647127386377,{"$f":"[1]MACRO_INPUT!L56","v":0},22.339647127386378,{"$f":"[1]MACRO_INPUT!AP28+[1]MACRO_INPUT!AQ28+[1]MACRO_INPUT!AR28","v":19.75},{"$f":"[1]MACRO_INPUT!AP31+[1]MACRO_INPUT!AQ31+[1]MACRO_INPUT!AR31","v":3.870352872613624}]
["San Luis Canal - Fresno","City of Avenal","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},{"$f":"+[1]MACRO_INPUT!D$13+[1]MACRO_INPUT!D$14+[1]MACRO_INPUT!D$15","v":0},0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L57","v":1.53},27.970000000000002,0,0]
["San Luis Canal - Fresno","City of Coalinga","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},{"$f":"[1]MACRO_INPUT!AQ19","v":35.4},{"$f":"[1]MACRO_INPUT!$D$11","v":0},{"$f":"+[1]MACRO_INPUT!D$13+[1]MACRO_INPUT!D$14+[1]MACRO_INPUT!D$15+'[1]Manual Input'!G19","v":0},0.14000000000000001,{"$f":"-[1]MACRO_INPUT!AQ21","v":0},61.65,{"$f":"[1]MACRO_INPUT!L58","v":14.04},75.88,{"$f":"[1]MACRO_INPUT!AQ18","v":"-"},{"$f":"[1]MACRO_INPUT!AQ21","v":"-"}]
["San Luis Canal - Fresno","City of Huron","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},{"$f":"+[1]MACRO_INPUT!D$13+[1]MACRO_INPUT!D$14+[1]MACRO_INPUT!D$15","v":0},0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L59","v":39.97},66.41,0,0]
["San Luis Canal - Fresno","State of CA","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},{"$f":"+[1]MACRO_INPUT!D$13+[1]MACRO_INPUT!D$14+[1]MACRO_INPUT!D$15","v":0},0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L60","v":6.14},32.58,0,0]
["San Luis Canal - Fresno","Westlands WD","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},{"$f":"+[1]MACRO_INPUT!D$13+[1]MACRO_INPUT!D$14+[1]MACRO_INPUT!D$15+'[1]Manual Input'!G12+'[1]Manual Input'!G13+'[1]Manual Input'!G15","v":0},0.14000000000000001,{"$f":"-[1]MACRO_INPUT!AV21","v":-2.1929367606117567},24.057063239388242,{"$f":"[1]MACRO_INPUT!L61","v":0},24.247063239388243,{"$f":"[1]MACRO_INPUT!AV18","v":11.19},{"$f":"[1]MACRO_INPUT!AV21","v":2.1929367606117567}]
["San Luis Canal - Tracy","Pacheco WD - SLC","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},{"$f":"+[1]MACRO_INPUT!D$13+[1]MACRO_INPUT!D$14+[1]MACRO_INPUT!D$15","v":0},0,0,26.11,{"$f":"[1]MACRO_INPUT!L62","v":5.25},31.55,0,0]
["San Luis Canal - Tracy","Panoche WD - SLC","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},{"$f":"+[1]MACRO_INPUT!D$13+[1]MACRO_INPUT!D$14+[1]MACRO_INPUT!D$15+'[1]Manual Input'!G18","v":0},0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L63","v":3.4},29.84,0,0]
["San Luis Canal - Tracy","San Luis WD - SLC   ","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},{"$f":"[1]MACRO_INPUT!AR19","v":"-"},{"$f":"[1]MACRO_INPUT!$D$11","v":0},{"$f":"'[1]Manual Input'!G14","v":0},0.14000000000000001,{"$f":"-[1]MACRO_INPUT!AR21","v":-6.0478728098667673},20.202127190133233,{"$f":"[1]MACRO_INPUT!L64","v":0},20.392127190133234,{"$f":"[1]MACRO_INPUT!AR18","v":30.86},{"$f":"[1]MACRO_INPUT!AR21","v":6.0478728098667673}]
["San Luis Canal - Tracy","Santa Nella County WD",0,0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0,0,{"$f":"SUM(E59:K59)","v":26.11},{"$f":"[1]MACRO_INPUT!L65","v":0},26.3,0,0]
["Shasta D&R","Centerville CSD","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L66","v":0},26.44,0,0]
["Shasta D&R","Mountain Gate CSD","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L67","v":2.09},28.53,0,0]
["Shasta D&R","Shasta CWA ","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L68","v":0},26.44,0,0]
["Spring Creek Conduit","City of Redding - SCC","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L69","v":0.43},26.87,0,0]
["Spring Creek Conduit","Shasta CWA   - SCC         ","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L70","v":0},26.44,0,0]
["Spring Creek Conduit","Shasta CSD","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L71","v":1.51},27.950000000000003,0,0]
["Tehama-Colusa Canal","Colusa County WD   ","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},{"$f":"[1]MACRO_INPUT!AT19","v":"-"},{"$f":"[1]MACRO_INPUT!$D$11","v":0},{"$f":"'[1]Manual Input'!G10","v":0},0.14000000000000001,{"$f":"-[1]MACRO_INPUT!AT21","v":-4.0769377020842015},22.173062297915799,{"$f":"[1]MACRO_INPUT!L72","v":0.96},23.323062297915801,{"$f":"[1]MACRO_INPUT!AT18","v":20.8},{"$f":"[1]MACRO_INPUT!AT21","v":4.0769377020842015}]
["Tehama-Colusa Canal","Kanawha WD","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},{"$f":"[1]MACRO_INPUT!AU19","v":"-"},{"$f":"[1]MACRO_INPUT!$D$11","v":0},{"$f":"'[1]Manual Input'!G11","v":0},0.14000000000000001,{"$f":"-[1]MACRO_INPUT!AU21","v":-0.49419952301817111},25.755800476981829,{"$f":"[1]MACRO_INPUT!L73","v":0.61},26.55580047698183,{"$f":"[1]MACRO_INPUT!AU18","v":2.52},{"$f":"[1]MACRO_INPUT!AU21","v":0.49419952301817111}]
["Toyon Pipeline","City of Redding - TP","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0.14000000000000001,0,26.25,{"$f":"[1]MACRO_INPUT!L74","v":1.05},27.490000000000002,0,0]
["Toyon Pipeline","City of Shasta Lake","N/A",0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},{"$f":"[1]MACRO_INPUT!AX19","v":2.06},{"$f":"[1]MACRO_INPUT!$D$11","v":0},{"$f":"'[1]Manual Input'!G23","v":0},0.14000000000000001,0,28.31,{"$f":"[1]MACRO_INPUT!L75","v":0},28.5,0,0]
["Toyon Pipeline","US Forest Service",0,0.19,{"$f":"ROUND([1]MACRO_INPUT!$D$10,2)","v":10.6},{"$f":"[1]MACRO_INPUT!$D$17","v":15.51},0,{"$f":"[1]MACRO_INPUT!$D$11","v":0},0,0,0,26.11,{"$f":"[1]MACRO_INPUT!L76","v":16.73},43.03,0,0]
[]
[]
[]
[null,null,null,null,""]

{"sheet":"Footnotes","index":1,"n_rows":72,"n_cols":7,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
["M&I 2024 Sch A-2A F.Z26.XLSM"]
["01/18/2024"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF M&I COST OF SERVICE AND PROJECT USE ENERGY (PUE) WATER RATES PER ACRE-FOOT BY CONTRACTOR"]
["2024 M&I WATER RATES"]
[]
["Footnotes:"]
[]
["1/"]
["Except for costs of Folsom South Canal, conveyance and conveyance pumping O&M costs are direct billed to the water authorities. "]
[]
["2/"]
["Project Use Energy payment is being remitted to Western Area Power Authority for storage and direct pumping based on the deliveries of a select few contractors."]
["The rates for the select few contractors are reduced as a credit in the O&M rates.  All contractors will ultimately pay for the storage and direct pumping service"]
["but as an offset to the amount paid by the select few.  Refer to schedule A-11 and A-9 for calculation details."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
["San Felipe Unit",null,"4/"]