{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Water Marketing"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":44,"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":"Water Marketing","index":0,"n_rows":91,"n_cols":15,"rows_kept":91,"cut":false,"hidden":false,"merged":[]}
[]
["M&I 2023 Sch B-4B F.Z26.XLSM"]
["08/20/2025"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF FY 2024 ALLOCATED M&I WATER MARKETING EXPENSE"]
["BY COMPONENT AND CONTRACTOR"]
[]
["Category","A) Contractor","B) Total A/F\n\n<Sch B-2>","C) Ratio of A/F by Contractor\n\n(B/ (Total A/F))","Allocated Water Marketing Expense\n(C* Total Expense)"]
["Total Expense","Total All Contractors","-","-",3641275.5248352271]
["Black Butte D & R","County of Colusa",6,1.57437E-5,57.327148999999999]
["Black Butte D & R","Elk Creek CSD",0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"(C11/$C$91)*$E$91-(E11)","v":0}]
["Black Butte D & R","US Forest Service - BB",4,1.04958E-5,38.2181]
["Black Butte D & R","Whitney Const.",0,0,0]
["Total"," Total Black Butte D & R",10,2.6239499999999998E-5,95.545248999999998]
["Clear Creek Unit","Clear Creek CSD",2096,5.4997822E-3,20026.222317]
["Total"," Total Clear Creek Unit",2096,5.4997822E-3,20026.222317]
["Contra Costa Canal","Contra Costa WD ",87528,0.22966838619999999,836285.87349799997]
["Total"," Total Contra Costa Canal",87528,0.22966838619999999,836285.87349799997]
["Cow Creek Unit","Bella Vista WD",4254,1.11622488E-2,40644.823358000001]
["Total"," Total Cow Creek Unit",4254,1.11622488E-2,40644.823358000001]
["Cross Valley Canal","County of Fresno",471,1.2358766000000001E-3,4500.1672150000004]
["Cross Valley Canal","County of Tulare",0,0,0]
["Total"," Total Cross Valley Canal",471,1.2358766000000001E-3,4500.1672150000004]
["Delta-Mendota Canal","Byron Bethany ID",1194,3.1329866000000001E-3,11408.067426]
["Delta-Mendota Canal","City of Tracy",6923,1.8165549699999999E-2,66145.771517999994]
["Delta-Mendota Canal","Del Puerto WD",71,1.8629989999999999E-4,678.36926600000004,null,null,null,null,null,""]
["Delta-Mendota Canal","Department of VA",312,8.1866990000000004E-4,2981.0026699999999]
["Delta-Mendota Canal","Panoche WD - DMC",25,6.5598499999999999E-5,238.862213]
["Delta-Mendota Canal","San Luis WD - DMC",3,7.8717999999999997E-6,28.663392999999999]
["Delta-Mendota Canal","Santa Nella County WD - DMC",62,1.6268439999999999E-4,592.37872400000003]
["Total"," Total Delta-Mendota Canal",8590,2.2539660799999996E-2,82073.115209999974]
["Folsom D & R","City of Folsom",7018,1.8414824199999999E-2,67053.448654000007]
["Folsom D & R","City of Roseville",30931,8.11611468E-2,295530.09740999999]
["Folsom D & R","El Dorado ID - FD&R",7011,1.83964566E-2,66986.567160999999,null,null,null,null,null,""]
["Folsom D & R","Placer County WD",0,0,0]
["Folsom D & R","Sacramento County WA",10067,2.6415223099999999E-2,96185.105356999993]
["Folsom D & R","San Juan WD",2850,7.4782344000000004E-3,27230.311890000001]
["Total"," Total Folsom D & R",57877,0.15186588510000001,552985.53047200001]
["Folsom-South Canal","East Bay MUD",0,0,0]
["Folsom-South Canal","Sacramento County WA - FSC",3672,9.6351145999999995E-3,35084.106972000001]
["Folsom-South Canal","Sacramento MUD",3170,8.3178958000000008E-3,30287.750394999999]
["Total"," Total Folsom-South Canal",6842,1.79530104E-2,65371.857367000004,null,null,null,null,null,""]
["Friant Dam","County of Madera",19,4.9854900000000003E-5,181.535427]
["Friant Dam","Fresno County WW #18",72,1.889238E-4,687.92360900000006]
["Total"," Total Friant Dam",91,2.387787E-4,869.45903600000008]
["Friant-Kern Canal","Arvin-Edison WSD",471,1.2358766000000001E-3,4500.1672150000004]
["Friant-Kern Canal","City of Fresno",59999,0.1574338898,573260.16970800003]
["Friant-Kern Canal","City of Lindsay",2780,7.2945585000000002E-3,26561.497330999999]
["Friant-Kern Canal","City of Orange Cove",1299,3.4085004999999998E-3,12411.289446999999]
["Friant-Kern Canal","Delano-Earlimart ID",274,7.1896009999999997E-4,2617.9318149999999]
["Friant-Kern Canal","Lindsay-Strathmore ID",410,1.0758161999999999E-3,3917.343198]
["Friant-Kern Canal","Shafter-Wasco ID",174,4.5656590000000001E-4,1662.4822369999999,null,null,null,null,null,""]
["Friant-Kern Canal","Terra Bella ID",1176,3.0857557000000002E-3,11236.086706]
["Total"," Total Friant-Kern Canal",66583,0.17470992329999999,636166.96765700018]
["New Melones D & R","Stockton East WD",31883,8.3659139499999993E-2,304625.97709]
["Total"," Total New Melones D & R",31883,8.3659139499999993E-2,304625.97709]
["Sacramento River","City of Redding - SR",2324,6.0980410000000002E-3,22204.647443000002]
["Sacramento River","City of West Sacramento",3829,1.00470735E-2,36584.162832000002]
["Sacramento River","Lake California P.O.A.",200,5.2478840000000002E-4,1910.8991570000001]
["Sacramento River","Riverview Golf & CC",25,6.5598499999999999E-5,238.862213]
["Total"," Total Sacramento River",6378,1.6735501400000002E-2,60938.571645000004]
["San Felipe Unit","SB County WD - IB",3119,8.1840747999999998E-3,29800.471262999999]
["San Felipe Unit","SC Valley WD - IB",84807,0.2225286403,810288.09149899997]
["Total"," Total San Felipe Unit",87926,0.23071271509999999,840088.56276200002]
["San Luis Canal - Fresno","City of Avenal",2274,5.9668439000000002E-3,21726.922654000002]
["San Luis Canal - Fresno","City of Coalinga",3753,9.8476538999999995E-3,35858.021122999999]
["San Luis Canal - Fresno","City of Huron",951,2.4953686999999998E-3,9086.3249730000007]
["San Luis Canal - Fresno","State of CA",1,2.6239E-6,9.5543429999999994]
["San Luis Canal - Fresno","Westlands WD",4077,1.0697811099999999E-2,38953.677728000002]
["Total"," Total San Luis Canal - Fresno",11056,2.9010301499999998E-2,105634.50082099999]
["San Luis Canal - Tracy","Pacheco WD - SLC",0,0,0]
["San Luis Canal - Tracy","Panoche WD - SLC",118,3.0962509999999998E-4,1127.4302990000001]
["San Luis Canal - Tracy","San Luis WD - SLC",243,6.3761790000000003E-4,2321.7424529999998]
["San Luis Canal - Tracy","Santa Nella County WD - SLC",259,6.7960099999999995E-4,2474.6144880000002]
["Total"," Total San Luis Canal - Tracy",620,1.6268439999999999E-3,5923.7872399999997]
["Shasta Dam","Centerville CSD",1121,2.9414389000000001E-3,10710.589474]
["Shasta Dam","Mountain Gate CSD",581,1.5245102E-3,5551.1616789999998]
["Shasta Dam","Shasta CWA  ",91,2.387787E-4,869.45903599999997]
["Total"," Total Shasta Dam",1793,4.7047278E-3,17131.210189000001,null,null,null,null,null,""]
["Spring Creek Conduit","City of Redding - SCC",6314,1.6567569099999999E-2,60327.083870000002]
["Spring Creek Conduit","Shasta CWA   - SCC",0,0,0]
["Spring Creek Conduit","Shasta CSD  ",403,1.0574486000000001E-3,3850.461706,null,null,null,null,null,""]
["Total"," Total Spring Creek Conduit",6717,1.7625017699999999E-2,64177.545576000004]
["Tehama-Colusa Canal","Colusa County WD",128,3.358646E-4,1222.9755479999999]
["Tehama-Colusa Canal","Kanawha WD",36,9.4461899999999998E-5,343.96180399999997]
["Total"," Total Tehama-Colusa Canal",164,4.3032649999999998E-4,1566.9373519999999]
["Toyon Pipeline","City of Redding - TP",17,4.4607000000000002E-5,162.426377]
["Toyon Pipeline","City of Shasta Lake  ",210,5.510278E-4,2006.4440420000001]
["Toyon Pipeline","US Forest Service - TP",0,0,0]
["Toyon Pipeline"," Total Toyon Pipeline",227,5.956348E-4,2168.8704189999999]
["GRAND TOTAL","GRAND TOTAL",381106,0.99999999989999999,3641275.5244730003]