{"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/07/2024"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF FY 2023 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","-","-",2576684.9899999984]
["Black Butte D & R","County of Colusa",6,1.6495599999999998E-5,42.503965000000001]
["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",1,2.7493000000000001E-6,7.0840800000000002]
["Black Butte D & R","Whitney Const.",0,0,0]
["Total"," Total Black Butte D & R",7,1.9244899999999999E-5,49.588045000000001]
["Clear Creek Unit","Clear Creek CSD",914,2.5128322000000001E-3,6474.7770119999996]
["Total"," Total Clear Creek Unit",914,2.5128322000000001E-3,6474.7770119999996]
["Contra Costa Canal","Contra Costa WD ",72284,0.198728188,512059.93910900003]
["Total"," Total Contra Costa Canal",72284,0.198728188,512059.93910900003]
["Cow Creek Unit","Bella Vista WD",1733,4.7644838000000002E-3,12276.573893000001]
["Total"," Total Cow Creek Unit",1733,4.7644838000000002E-3,12276.573893000001]
["Cross Valley Canal","County of Fresno",0,0,0]
["Cross Valley Canal","County of Tulare",0,0,0]
["Total"," Total Cross Valley Canal",0,0,0]
["Delta-Mendota Canal","Byron Bethany ID",1464,4.0249303999999996E-3,10370.977747000001]
["Delta-Mendota Canal","City of Tracy",6166,1.6951995000000001E-2,43679.951067000002]
["Delta-Mendota Canal","Del Puerto WD",30,8.2478099999999999E-5,212.520082,null,null,null,null,null,""]
["Delta-Mendota Canal","Department of VA",273,7.5055049999999996E-4,1933.9322079999999]
["Delta-Mendota Canal","Panoche WD - DMC",23,6.3233199999999996E-5,162.93203700000001]
["Delta-Mendota Canal","San Luis WD - DMC",4,1.09971E-5,28.336062999999999]
["Delta-Mendota Canal","Santa Nella County WD - DMC",0,0,0]
["Total"," Total Delta-Mendota Canal",7960,2.1884184299999995E-2,56388.649204000001]
["Folsom D & R","City of Folsom",4918,1.3520906799999999E-2,34839.117602999999]
["Folsom D & R","City of Roseville",20774,5.7113322100000002E-2,147163.03978399999]
["Folsom D & R","El Dorado ID - FD&R",4044,1.11180454E-2,28647.700700000001,null,null,null,null,null,""]
["Folsom D & R","Placer County WD",0,0,0]
["Folsom D & R","Sacramento County WA",5000,1.3746346899999999E-2,35420.005725000003]
["Folsom D & R","San Juan WD",7650,2.1031910800000001E-2,54192.608869000003]
["Total"," Total Folsom D & R",42386,0.11653053199999999,300262.47268099996]
["Folsom-South Canal","East Bay MUD",0,0,0]
["Folsom-South Canal","Sacramento County WA - FSC",2050,5.6360022000000003E-3,14522.202272]
["Folsom-South Canal","Sacramento MUD",498,1.3691362E-3,3527.8326959999999]
["Total"," Total Folsom-South Canal",2548,7.0051384000000003E-3,18050.034968,null,null,null,null,null,""]
["Friant Dam","County of Madera",14,3.8489799999999999E-5,99.176090000000002]
["Friant Dam","Fresno County WW #18",109,2.9967040000000001E-4,772.15622199999996]
["Total"," Total Friant Dam",123,3.3816020000000002E-4,871.332312]
["Friant-Kern Canal","Arvin-Edison WSD",284,7.8079250000000005E-4,2011.856315]
["Friant-Kern Canal","City of Fresno",58819,0.1617092758,416673.86369799997]
["Friant-Kern Canal","City of Lindsay",1041,2.8619893999999998E-3,7374.4451289999997]
["Friant-Kern Canal","City of Orange Cove",1156,3.1781553999999999E-3,8189.1053149999998]
["Friant-Kern Canal","Delano-Earlimart ID",204,5.6085100000000001E-4,1445.1363530000001]
["Friant-Kern Canal","Lindsay-Strathmore ID",651,1.7897744E-3,4611.6848319999999]
["Friant-Kern Canal","Shafter-Wasco ID",208,5.7184800000000002E-4,1473.472158,null,null,null,null,null,""]
["Friant-Kern Canal","Terra Bella ID",1383,3.8022396E-3,9797.1737059999996]
["Total"," Total Friant-Kern Canal",63746,0.17525492609999999,451576.73750599992]
["New Melones D & R","Stockton East WD",36495,0.1003345861,258530.62198200001]
["Total"," Total New Melones D & R",36495,0.1003345861,258530.62198200001]
["Sacramento River","City of Redding - SR",2377,6.5350132999999998E-3,16838.670679999999]
["Sacramento River","City of West Sacramento",2541,6.9858934999999997E-3,18000.446923]
["Sacramento River","Lake California P.O.A.",200,5.4985389999999998E-4,1416.800291]
["Sacramento River","Riverview Golf & CC",25,6.8731699999999998E-5,177.09994]
["Total"," Total Sacramento River",5143,1.4139492399999998E-2,36433.017833999998]
["San Felipe Unit","SB County WD - IB",8871,2.4388768700000001E-2,62842.174233999998]
["San Felipe Unit","SC Valley WD - IB",105100,0.28894821199999998,744528.52074800001]
["Total"," Total San Felipe Unit",113971,0.31333698069999999,807370.69498200004]
["San Luis Canal - Fresno","City of Avenal",2284,6.2793312999999996E-3,16179.858708]
["San Luis Canal - Fresno","City of Coalinga",2955,8.124091E-3,20933.223336999999]
["San Luis Canal - Fresno","City of Huron",767,2.1086896000000002E-3,5433.4288409999999]
["San Luis Canal - Fresno","State of CA",2,5.4985E-6,14.167902]
["San Luis Canal - Fresno","Westlands WD",3619,9.9496059000000001E-3,25637.000178999999]
["Total"," Total San Luis Canal - Fresno",9627,2.6467216299999999E-2,68197.678967]
["San Luis Canal - Tracy","Pacheco WD - SLC",0,0,0]
["San Luis Canal - Tracy","Panoche WD - SLC",147,4.0414260000000001E-4,1041.3481710000001]
["San Luis Canal - Tracy","San Luis WD - SLC",273,7.5055049999999996E-4,1933.9322079999999]
["San Luis Canal - Tracy","Santa Nella County WD - SLC",182,5.0036700000000004E-4,1289.2881379999999]
["Total"," Total San Luis Canal - Tracy",602,1.6550601000000001E-3,4264.5685169999997]
["Shasta Dam","Centerville CSD",275,7.5604909999999999E-4,1948.1003679999999]
["Shasta Dam","Mountain Gate CSD",458,1.2591653999999999E-3,3244.4725859999999]
["Shasta Dam","Shasta CWA  ",82,2.2544009999999999E-4,580.88812199999995]
["Total"," Total Shasta Dam",815,2.2406546000000001E-3,5773.4610759999996,null,null,null,null,null,""]
["Spring Creek Conduit","City of Redding - SCC",4526,1.2443193199999999E-2,32062.189146000001]
["Spring Creek Conduit","Shasta CWA   - SCC",0,0,0]
["Spring Creek Conduit","Shasta CSD  ",186,5.1136409999999997E-4,1317.6242010000001,null,null,null,null,null,""]
["Total"," Total Spring Creek Conduit",4712,1.2954557299999999E-2,33379.813347000003]
["Tehama-Colusa Canal","Colusa County WD",72,1.9794739999999999E-4,510.04809399999999]
["Tehama-Colusa Canal","Kanawha WD",27,7.4230300000000007E-5,191.2681]
["Total"," Total Tehama-Colusa Canal",99,2.7217769999999999E-4,701.316194]
["Toyon Pipeline","City of Redding - TP",11,3.0241999999999999E-5,77.924107000000006]
["Toyon Pipeline","City of Shasta Lake  ",557,1.5313429999999999E-3,3945.7885230000002]
["Toyon Pipeline","US Forest Service - TP",0,0,0]
["Toyon Pipeline"," Total Toyon Pipeline",568,1.5615849999999999E-3,4023.71263]
["GRAND TOTAL","GRAND TOTAL",363733,1.0000000001,2576684.9902589996]