{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["INFORMATION","Macro Input","Storage"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":26,"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":47,"n_cols":3,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
["M&I 2022 Sch B-4 F.Z26.XLSM"]
["7/28/2023","SCHEDULE OF FY 2022 M&I"]
[null,"STORAGE ALLOCATIONS - Sch B-4A"]
[null,"WATER MARKETING ALLOCATIONS - Sch B-4B"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Sch B-2",null,"A/F DELIVERED"]
[]
["Sch B-6",null,"WATER MARKETING EXPENSE"]
[null,null,"STORAGE EXPENSE"]
[]
[]
["Updates for 2022:"]
["5/01/2023","rm","Updated title, headings, fiscal year, and date. "]
["5/04/2023","rm","Updated Info. tab, cell A29 to 2022"]
["7/18/2023","rm","ran macro"]
[null,"rm","verified the Storage tab A/F with Sch B-2 Output tab"]
[null,null,"verified the Water Marketing tab A/F with Sch B-2 Output tab"]
[null,null,"verified the Storage-All Others, Storage SF Unit, and Water Marketing totals with Sch B-6, Output tab"]
["7/19/2023","rm","ready for review"]
["7/28/2023","rm","ran macro"]
[null,null,"verified A/F from Sch B-2, Output tab, into Sch B-4, Macro Input tab"]
[null,null,"verified Storage-All Others, and Storage SF Unit, in Sch B-4, Macro Input tab, with Total Storage Costs in Sch B-6, output tab"]
[null,null,"verified Water Marketing totals, in Sch B-4, Macro Input tab, with Sch B-6, Output tab, Total Water Marketing totals"]
[null,null,"verified Sch B-4, Storage All Others, and Storage SF Unit, in Macro Input tab, with Storage Grand Total Costs in Sch B-4, Storage tab"]
[null,null,"verified Sch B-4, Water Marketing Total, Macro Input tab, with Grand Total, in Water Marketing tab"]
[null,null,"deleted the Manual Input tab"]
[null,null,"ready for review"]
[]
["8/8/2023","pq","updated the date"]
[null,null,"reviewed"]

{"sheet":"Macro Input","index":1,"n_rows":93,"n_cols":10,"rows_kept":93,"cut":false,"hidden":true,"merged":[]}
[{"$f":"MACRO","v":"M&I 2022 Sch B-4 F.Z26.XLSM"}]
[{"$f":"INFORMATION!A2","v":"7/28/2023"},null,null,null,{"$f":"INFORMATION!B2","v":"SCHEDULE OF FY 2022 M&I"}]
[null,null,null,null,{"$f":"INFORMATION!B3","v":"STORAGE ALLOCATIONS - Sch B-4A"}]
[null,null,null,null,{"$f":"INFORMATION!B4","v":"WATER MARKETING ALLOCATIONS - Sch B-4B"}]
[]
[]
[]
[null,null,null,null,"Schedule B-2","Schedule B-6","Schedule B-6","Schedule B-6"]
[null,null,null,null,"A/F ","Storage - All others","Storage SF Unit","Water Marketing"]
[null,null,null,null,null,null,null,"Total"]
[null,null,null,null,null,"Sch. B-4A","Sch. B-4A","Sch. B-4a"]
[]
[null,null,null,null,null,4585070.2683246182,1678838.0216753806,1698821.85,0,0]
[]
["Black Butte D & R","County of Colusa",null,null,11]
["Black Butte D & R","Elk Creek CSD",null,null,0]
["Black Butte D & R","US Forest Service - BB",null,null,8]
["Black Butte D & R","Whitney Const.",null,null,0]
["Total","Total Black Butte D & R",null,null,19]
["Clear Creek Unit","Clear Creek CSD",null,null,0]
["Total","Total Clear Creek Unit",null,null,0]
["Contra Costa Canal","Contra Costa WD ",null,null,58225]
["Total","Total Contra Costa Canal",null,null,58225]
["Cow Creek Unit","Bella Vista WD",null,null,1269]
["Total","Total Cow Creek Unit",null,null,1269]
["Cross Valley Canal","County of Fresno",null,null,0]
["Cross Valley Canal","County of Tulare",null,null,0]
["Total","Total Cross Valley Canal",null,null,0]
["Delta-Mendota Canal","Byron Bethany ID",null,null,4]
["Delta-Mendota Canal","City of Tracy",null,null,3824]
["Delta-Mendota Canal","Del Puerto WD",null,null,0]
["Delta-Mendota Canal","Department of VA",null,null,319]
["Delta-Mendota Canal","Panoche WD - DMC",null,null,25]
["Delta-Mendota Canal","San Luis WD - DMC",null,null,3]
["Total","Total Delta-Mendota Canal",null,null,4175]
["Folsom D & R","City of Folsom",null,null,1000]
["Folsom D & R","City of Roseville",null,null,2187]
["Folsom D & R","El Dorado ID - FD&R",null,null,0]
["Folsom D & R","Placer County WA",null,null,0]
["Folsom D & R","Sacramento County WA",null,null,0]
["Folsom D & R","San Juan WD",null,null,0]
["Total","Total Folsom D & R",null,null,3187]
["Folsom-South Canal","East Bay MUD",null,null,31915]
["Folsom-South Canal","Sacramento County WA-FSC",null,null,0]
["Folsom-South Canal","Sacramento MUD",null,null,4509]
["Total","Total Folsom-South Canal",null,null,36424]
["Friant Dam","County of Madera",null,null,49]
["Friant Dam","Fresno County WW #18",null,null,298]
["Total","Total Friant Dam",null,null,347]
["Friant-Kern Canal","Arvin Edison WSD",null,null,338]
["Friant-Kern Canal","City of Fresno",null,null,22140]
["Friant-Kern Canal","City of Lindsay",null,null,2529]
["Friant-Kern Canal","City of Orange Cove",null,null,1100]
["Friant-Kern Canal","Delano-Earlimart ID",null,null,145]
["Friant-Kern Canal","Lindsay-Strathmore ID",null,null,390]
["Friant-Kern Canal","Shafter-Wasco ID",null,null,154]
["Friant-Kern Canal","Terra Bella ID",null,null,1350]
["Total","Total Friant-Kern Canal",null,null,28146]
["New Melones D & R","Stockton East WD",null,null,0]
["Total","Total New Melones D & R",null,null,0]
["Sacramento River","City of Redding - SR ",null,null,2748]
["Sacramento River","City of West Sacramento",null,null,0]
["Sacramento River","Lake California P.O.A.",null,null,0]
["Sacramento River","Riverview Golf & CC",null,null,0]
["Total","Total Sacramento River",null,null,2748]
["San Felipe Unit","SB County WD - IB",null,null,1997]
["San Felipe Unit","SC Valley WD - IB",null,null,61337]
["Total","Total San Felipe Unit",null,null,63334]
["San Luis Canal - Fresno","City of Avenal",null,null,2337]
["San Luis Canal - Fresno","City of Coalinga",null,null,3764]
["San Luis Canal - Fresno","City of Huron",null,null,719]
["San Luis Canal - Fresno","State of CA",null,null,0]
["San Luis Canal - Fresno","Westlands WD",null,null,3932]
["Total","Total San Luis Canal - Fresno",null,null,10752]
["San Luis Canal - Tracy","Pacheco WD - SLC",null,null,0]
["San Luis Canal - Tracy","Panoche WD - SLC",null,null,158]
["San Luis Canal - Tracy","San Luis WD - SLC",null,null,705]
["Total","Total San Luis Canal - Tracy",null,null,863]
["Shasta Dam","Centerville CSD",null,null,48]
["Shasta Dam","Mountain Gate CSD",null,null,258]
["Shasta Dam","Shasta CWA  ",null,null,48]
["Total","Total Shasta Dam",null,null,354]
["Spring Creek Conduit","City of Redding - SCC",null,null,255]
["Spring Creek Conduit","Shasta CWA - SCC",null,null,13]
["Spring Creek Conduit","Shasta CSD  ",null,null,170]
["Total","Total Spring Creek Conduit",null,null,438]
["Tehama-Colusa Canal","Colusa County WD",null,null,16]
["Tehama-Colusa Canal","Kanawha WD",null,null,7]
["Total","Total Tehama-Colusa Canal",null,null,23]
["Toyon Pipeline","City of Redding - TP",null,null,9]
["Toyon Pipeline","City of Shasta Lake  ",null,null,461]
["Toyon Pipeline","US Forest Service - TP",null,null,0]
["Total","Total Toyon Pipeline",null,null,470]

{"sheet":"Storage","index":2,"n_rows":93,"n_cols":10,"rows_kept":93,"cut":false,"hidden":false,"merged":[]}
[]
["M&I 2024 Sch A-2Bc FSOD.Z26.XLSM"]
["12/14/2023"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF FY 2024 ALLOCATED M&I FOLSOM SAFETY OF DAMS MODIFICATION PROJECT COSTS"]
["BY COMPONENT AND CONTRACTOR"]
[]
["Category","A) Contractor","B) 2024-2073 Historical & Projected Deliveries\n<Sch A-13 FSOD>","C) 50-Year FSOD Rate\n<Sch A-4>","D) Total Allocated FSOD Cost\n(C*D)"]
[null,"Total All Other Contractors","-"]
[null,"Total San Felipe Unit","-"]
["Black Butte D & R","County of Colusa",350,0.1921205634,67.242197189999999]
["Black Butte D & R","Elk Creek CSD",700,0.1921205634,134.48439438]
["Black Butte D & R","US Forest Service - BB",442.85714285714243,0.1921205634,85.081963791428493]
["Black Butte D & R","Whitney Const.",200,0.1921205634,38.42411268]
[null,"Total Black Butte D & R",1692.8571428571424,null,325.2326680414285]
["Clear Creek Unit","Clear Creek CSD",78578.571428571449,0.1921205634,15096.55941402429]
[null,"Total Clear Creek Unit",78578.571428571449,null,15096.55941402429]
["Contra Costa Canal","Contra Costa WD ",4051700,0.1921205634,778414.88672777999]
[null,"Total Contra Costa Canal",4051700,null,778414.88672777999]
["Cow Creek Unit","Bella Vista WD",181928.57142857142,0.1921205634,34952.219641414282]
[null,"Total Cow Creek Unit",181928.57142857142,null,34952.219641414282]
["Cross Valley Canal","County of Fresno",4300,0.1921205634,826.11842262000005]
["Cross Valley Canal","County of Tulare",9600,0.1921205634,1844.3574086399999]
[null,"Total Cross Valley Canal",13900,null,2670.4758312599997]
["Delta-Mendota Canal","Byron Bethany ID",38635.714285714275,0.1921205634,7422.7151959328548]
["Delta-Mendota Canal","City of Tracy",336257.1428571429,0.1921205634,64601.911732988578]
["Delta-Mendota Canal","Del Puerto WD",150,0.1921205634,28.818084509999998,null,null,null,null,""]
["Delta-Mendota Canal","Department of VA",19971.428571428565,0.1921205634,3836.9221090457131]
["Delta-Mendota Canal","Panoche WD - DMC",1207.1428571428564,0.1921205634,231.9169658185713]
["Delta-Mendota Canal","San Luis WD - DMC",871.4285714285719,0.1921205634,167.41934810571436]
["Delta-Mendota Canal","Santa Nella County WD",271.42857142857122,0.1921205634,52.147010065714248]
[null,"Total Delta-Mendota Canal",397364.28571428574,null,76341.850446467157]
["Folsom D & R","City of Folsom",146083.33333333337,0.1921205634,28065.612303350008]
["Folsom D & R","City of Roseville",1121950,0.1921205634,215549.66610663]
["Folsom D & R","El Dorado ID - FD&R",191600,0.1921205634,36810.299947439999,null,null,null,null,""]
["Folsom D & R","Placer County WD",250000,0.1921205634,48030.140850000003]
["Folsom D & R","Sacramento County WA",176107.14285714296,0.1921205634,33833.803504478594]
["Folsom D & R","San Juan WD",8785.714285714279,0.1921205634,1687.9163784428558]
[null,"Total Folsom D & R",1894526.1904761908,null,363977.43909034145]
["Folsom-South Canal","East Bay MUD",322735.71428571414,0.1921205634,62004.167257872832]
["Folsom-South Canal","Sacramento County WA - FSC",214300,0.1921205634,41171.436736620002]
["Folsom-South Canal","Sacramento MUD",214300,0.1921205634,41171.436736620002]
[null,"Total Folsom-South Canal",751335.71428571409,null,144347.04073111282,null,null,null,null,""]
["Friant Dam","County of Madera",3564.2857142857124,0.1921205634,684.77257954714253]
["Friant Dam","Fresno County WW #18",6428.5714285714248,0.1921205634,1235.0607647142849]
[null,"Total Friant Dam",9992.8571428571377,null,1919.8333442614276]
["Friant-Kern Canal","Arvin-Edison WSD",23050,0.1921205634,4428.3789863700003]
["Friant-Kern Canal","City of Fresno",2085685.7142857153,0.1921205634,400703.11450390302]
["Friant-Kern Canal","City of Lindsay",87550,0.1921205634,16820.155325669999]
["Friant-Kern Canal","City of Orange Cove",54892.857142857167,0.1921205634,10546.046640921433]
["Friant-Kern Canal","Delano-Earlimart ID",16078.571428571446,0.1921205634,3089.0242015242889]
["Friant-Kern Canal","Lindsay-Strathmore ID",29535.714285714301,0.1921205634,5674.4180689928598]
["Friant-Kern Canal","Shafter-Wasco ID",6542.8571428571449,0.1921205634,1257.0174005314291,null,null,null,null,""]
["Friant-Kern Canal","Terra Bella ID",73328.571428571435,0.1921205634,14087.926456174288]
[null,"Total Friant-Kern Canal",2376664.2857142868,null,456606.08158408734]
["New Melones D & R","Stockton East WD",1159028.5714285721,0.1921205634,222673.22213955442]
[null,"Total New Melones D & R",1159028.5714285721,null,222673.22213955442]
["Sacramento River","City of Redding - SR",118350,0.1921205634,22737.46867839]
["Sacramento River","City of West Sacramento",286242.85714285698,0.1921205634,54993.138983511395]
["Sacramento River","Lake California P.O.A.",8214.2857142857229,0.1921205634,1578.1331993571446]
["Sacramento River","Riverview Golf & CC",1028.5714285714282,0.1921205634,197.60972235428565]
[null,"Total Sacramento River",413835.71428571414,null,79506.350583612832]
["San Luis Canal - Fresno","City of Avenal",118128.57142857155,0.1921205634,22694.927696494309]
["San Luis Canal - Fresno","City of Coalinga",280178.5714285713,0.1921205634,53828.064995464265]
["San Luis Canal - Fresno","City of Huron",51857.142857142841,0.1921205634,9962.8235020285683]
["San Luis Canal - Fresno","State of CA",64.285714285714263,0.1921205634,12.350607647142853]
["San Luis Canal - Fresno","Westlands WD",144521.42857142849,0.1921205634,27765.538280515699]
[null,"Total San Luis Canal - Fresno",594749.99999999988,null,114263.70508214997]
["San Luis Canal - Tracy","Pacheco WD - SLC",550,0.1921205634,105.66630987000001]
["San Luis Canal - Tracy","Panoche WD - SLC",7385.714285714278,0.1921205634,1418.9475896828558]
["San Luis Canal - Tracy","San Luis WD - SLC",25764.285714285699,0.1921205634,4949.8490870271398]
["San Luis Canal - Tracy","Santa Nella County WD - SLC",2892.8571428571408,0.1921205634,555.7773441214282]
[null,"Total San Luis Canal - Tracy",36592.857142857116,null,7030.2403307014247]
["Shasta Dam","Centerville CSD",25600,0.1921205634,4918.28642304]
["Shasta Dam","Mountain Gate CSD",23142.857142857127,0.1921205634,4446.2187529714256]
["Shasta Dam","Shasta CWA  ",4935.7142857142844,0.1921205634,948.25220935285688]
[null,"Total Shasta Dam",53678.571428571413,null,10312.757385364283,null,null,null,null,""]
["Spring Creek Conduit","City of Redding - SCC",258592.85714285687,0.1921205634,49681.005405501375]
["Spring Creek Conduit","Shasta CWA   - SCC",3250,0.1921205634,624.39183104999995]
["Spring Creek Conduit","Shasta CSD  ",13000,0.1921205634,2497.5673241999998,null,null,null,null,""]
[null,"Total Spring Creek Conduit",274842.85714285687,null,52802.964560751374]
["Tehama-Colusa Canal","Colusa County WD",6300,0.1921205634,1210.3595494199999]
["Tehama-Colusa Canal","Kanawha WD",1371.4285714285706,0.1921205634,263.47962980571413]
[null,"Total Tehama-Colusa Canal",7671.4285714285706,null,1473.8391792257139]
["Toyon Pipeline","City of Redding - TP",821.4285714285719,0.1921205634,157.81331993571439]
["Toyon Pipeline","City of Shasta Lake  ",55750,0.1921205634,10710.72140955]
["Toyon Pipeline","US Forest Service - TP",50,0.1921205634,9.6060281700000001]
[null,"Total Toyon Pipeline",56621.428571428572,null,10878.140757655714]
["Subtotal","Total A/F/Expense without San Felipe Unit",12354704.761904763,null,2373592.8394978056]
["San Felipe Unit","SB County WD - IB",269542.85714285693,0.1921263386,51786.282238639957]
["San Felipe Unit","SC Valley WD - IB",4250792.8571428591,0.1921263386,816689.26778989041]
[null,"Total San Felipe Unit",4520335.7142857164,null,868475.55002853042]
[null,"GRAND TOTAL",16875040.476190478,"-",3242068.389526336]