{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["OUTPUT"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":13,"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":93,"n_cols":13,"rows_kept":93,"cut":false,"hidden":false,"merged":[[93,14,93,16]]}
[]
["M&I 2022 Sch B-1 F.Z26.XLSM"]
["12/16/2023"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF FY 2022 M&I NET POSITION"]
["BY PERMANENT CONTRACTOR"]
[]
["Category","A) Contractor","Related Footnotes","B) Total Water Charges\n\n<Sch B-2>","C) Total O&M Expenses\n\n<Sch B-1A>","D) Interest","E) Friant Division O&M Expense Adjustment","F) Charge Adj\n\n<B-3A> <B-6A>","G) Voluntary Payment: Prior  Year\n\n<Sch B-3A>","H) Voluntary Payment: Current Year\n\n<Sch B-3A>","I) Results of Operations\n\n(B-C-D-E+F+G+H)","J) Construction/Deficit Recovery","K) Net Results of Operations\n\n(I-J)"]
["Black Butte D & R","County of Colusa","-",297.33,527.37590531385854,3.1395732172388851,0,0,0,0,-233.18547853109743,0,-233.19]
["Black Butte D & R","Elk Creek CSD","-",0,0,32.534480038994012,0,0,0,0,-32.534480038994012,0,-32.53]
["Black Butte D & R","US Forest Service - BB","-",307.12,383.546354500988,22.627065416739356,0,0,0,0,-99.053419917727354,0,-99.05]
["Black Butte D & R","Whitney Const.","-",0,0,6.1465390487180258,0,0,0,0,-6.1465390487180258,0,-6.15]
["Total","Total Black Butte D & R","-",604.45000000000005,910.92225981484648,64.447657721690277,0,0,0,0,-370.91991753653679,0,-370.92]
["Clear Creek Unit","Clear Creek CSD","-",0,0,208.64192392176818,0,0,0,0,-208.64192392176818,0,-208.64]
["Total","Total Clear Creek Unit","-",0,0,208.64192392176818,0,0,0,0,-208.64192392176818,0,-208.64]
["Contra Costa Canal","Contra Costa WD","-",1604356.98,2321441.8152396455,110640.93649353058,0,110682.72,0,0,-717043.05173317599,0,-717043.05]
["Total","Total Contra Costa Canal","-",1604356.98,2321441.8152396455,110640.93649353058,0,110682.72,0,0,-717043.05173317599,0,-717043.05]
["Cow Creek Unit","Bella Vista WD","-",158713.54,193998.91940533792,5056.8753228503401,0,0,0,0,-40342.254728188243,0,-40342.25]
["Total","Total Cow Creek Unit","-",158713.54,193998.91940533792,5056.8753228503401,0,0,0,0,-40342.254728188243,0,-40342.25]
["Cross Valley Canal","County of Fresno","-",0,0,3135.3302782332148,0,0,0,0,-3135.3302782332148,0,-3135.33]
["Cross Valley Canal","County of Tulare","-",0,0,8267.7465093667652,0,0,24229,0,15961.253490633235,0,15961.25]
["Total","Total Cross Valley Canal","-",0,0,11403.076787599981,0,0,24229,0,12825.923212400019,0,12825.92]
["Delta-Mendota Canal","Byron Bethany ID","-",113.96,191.77326175049399,1911.5633342098317,0,0,0,0,-1989.3765959603256,0,-1989.38]
["Delta-Mendota Canal","City of Tracy","-",131897.37,183335.08247447226,1388.161837884993,0,0,516907,0,464081.12568764272,2294.4,461786.73]
["Delta-Mendota Canal","Del Puerto WD","-",0,0,0,0,0,0,0,0,0,0]
["Delta-Mendota Canal","Department of VA","-",9752.0499999999993,15293.904776101896,554.18385536855192,0,0,24479,0,18382.961368529552,389.18,17993.78]
["Delta-Mendota Canal","Panoche WD - DMC","-",566.75,1198.5819464405874,22.22893364182201,0,0,0,0,-654.06088008240954,0,-654.05999999999995]
["Delta-Mendota Canal","San Luis WD - DMC","-",89.050000000000011,143.83013481287048,8.7765166447928058E-3,0,54,0,null,-0.78891132951525833,0,-0.79]
["Total","Total Delta-Mendota Canal","-",142419.17999999996,200163.17259357811,3876.1467376218438,0,54,541386,0,479819.86066879996,2683.58,477136.28]
["Folsom D & R","City of Folsom","-",27790,47943.274826623499,367.1821843397496,0,0,0,20293.73,-226.72701096324818,0,-226.73]
["Folsom D & R","City of Roseville","-",63594,104851.9418055826,11348.271093092177,0,0,0,0,-52606.21289867477,0,-52606.21]
["Folsom D & R","El Dorado ID - FD&R","-",0,0,3624.7777830004593,0,0,0,0,-3624.7777830004593,0,-3624.78]
["Folsom D & R","Placer County WA","-",0,0,252.60214564801294,0,0,0,0,-252.60214564801294,0,-252.6]
["Folsom D & R","Sacramento County WA","-",0,0,4342.7364352812683,0,0,0,0,-4342.7364352812683,0,-4342.74]
["Folsom D & R","San Juan WD","-",0,0,0,0,0,0,0,0,0,0]
["Total","Total Folsom D & R","-",91384,152795.21663220611,19935.569641361668,0,0,0,20293.73,-61053.056273567759,0,-61053.06]
["Folsom-South Canal","East Bay MUD","-",3347245.1999999997,1645541.628557272,137744.53974672803,0,0,400000,0,1963959.0316959997,1553941.3499999999,410017.68]
["Folsom-South Canal","Sacramento County WA","-",0,0,18915.613499225103,0,0,0,0,-18915.613499225103,0,-18915.61]
["Folsom-South Canal","Sacramento MUD","-",162889.38,232484.63714372634,12854.056797734152,0,0,0,0,-82449.313941460481,0,-82449.31]
["Total","Total Folsom-South Canal","-",3510134.5799999996,1878026.2657009983,169514.21004368729,0,0,400000,0,1862594.104255314,1553941.3499999999,308652.76]
["Friant Dam","County of Madera","1/",1387.46,2349.2205969435513,59.852950888390758,-147,0,3814,0,2939.386452168058,0,2939.39]
["Friant Dam","Fresno County WW #18","1/",6175.5,14287.0960914118,130.2435483934712,-615,0,0,0,-7626.8396398052719,0,-7626.84]
["Total","Total Friant Dam","-",7562.96,16636.316688355353,190.09649928186195,-762,0,3814,0,-4687.4531876372139,0,-4687.4500000000007]
["Friant-Kern Canal","Arvin-Edison WSD","1/",9640.8599999999988,16204.826453916743,84.129715738257616,-1014,5634,0,0,-9.6169655002086074E-2,0,-0.1]
["Friant-Kern Canal","City of Fresno","1/",637420.46,1061464.1003239842,4023.2659536448223,-66420,0,0,0,-361646.90627762908,0,-361646.91]
["Friant-Kern Canal","City of Lindsay","1/",60307.869999999995,121248.54152324983,655.97150325803102,-7587,0,0,0,-54009.643026507867,0,-54009.64]
["Friant-Kern Canal","City of Orange Cove","1/",29612.399999999998,52737.602274385848,367.88313750101975,-3300,0,0,0,-20193.08541188687,0,-20193.09]
["Friant-Kern Canal","Delano-Earlimart ID","1/",3914.01,6951.7747839554067,793.68084203137357,-435,0,0,2602.7600000000002,-793.68562598678,0,-793.69]
["Friant-Kern Canal","Lindsay-Strathmore ID","1/",11481.5,18697.877185673162,1930.1013448700551,-1170,7918,0,0,-58.478530543216038,0,-58.48]
["Friant-Kern Canal","Shafter-Wasco ID","1/",4175.82,7383.2644343940183,210.4055582391349,-462,0,0,0,-2955.8499926331533,0,-2955.85]
["Friant-Kern Canal","Terra Bella ID","1/",35547.839999999997,64723.421066791721,282.66278700140691,-4050,0,0,0,-25408.24385379313,0,-25408.240000000002]
["Total","Total Friant-Kern Canal","-",792100.75999999989,1349411.4080463508,8348.1008422841005,-84438,13552,0,2602.7600000000002,-465065.98888863507,0,-465065.99999999994]
["New Melones D & R","Stockton East WD","-",0,0,30942.501218095011,0,-348639,0,0,-379581.50121809501,0,-379581.5]
["Total","Total New Melones D & R","-",0,0,30942.501218095011,0,-348639,0,0,-379581.50121809501,0,-379581.5]
["Sacramento River","City of Redding - SR","-",112495.59999999999,131748.11884958937,3906.1898274303276,0,23936,0,0,777.29132298029435,777.29132298029435,0]
["Sacramento River","City of West Sacramento","-",0,0,549.60531099423201,0,0,0,0,-549.60531099423201,0,-549.61]
["Sacramento River","Lake California P.O.A.","-",0,0,118.69526128717871,0,0,0,118.7,4.7387128212932339E-3,0,0]
["Sacramento River","Riverview Golf & CC","-",0,0,11.565428617895222,0,0,0,0,-11.565428617895222,0,-11.57]
["Total","Total Sacramento River","-",112495.59999999999,131748.11884958937,4586.0558283296332,0,23936,0,118.7,216.12532208098838,777.29132298029435,-561.18000000000006]
["San Felipe Unit","SB County WD - IB","-",55293.34,39840.291762072295,8326.2188197666437,0,0,0,0,7126.8294181610545,4453.3100000000004,2673.52]
["San Felipe Unit","SC Valley WD - IB","-",1602588.46,1443642.4126175633,5857.6673059966888,0,0,0,0,153088.38007644005,3680.22,149408.16]
["Total","Total San Felipe Unit","-",1657881.8,1483482.7043796356,14183.886125763333,0,0,0,0,160215.20949460112,8133.5300000000007,152081.68]
["San Luis Canal - Fresno","City of Avenal","-",70067.290000000008,112043.43297922611,6074.0338375985475,0,0,0,0,-48050.176816824649,0,-48050.18]
["San Luis Canal - Fresno","City of Coalinga","-",296125.44,312765.79678108648,36206.403669439816,0,0,0,0,-52846.760450526315,0,-52846.76]
["San Luis Canal - Fresno","City of Huron","-",60448.990000000005,34471.214740151292,14887.516326732108,0,0,0,0,11090.258933116609,11090.258933116609,0]
["San Luis Canal - Fresno","State of CA","-",0,0,2.442758058578185,0,0,0,0,-2.442758058578185,0,-2.44]
["San Luis Canal - Fresno","Westlands WD     ","-",110067.41,203856.35042678242,15825.3037170813,0,0,0,109614.24,-4.1438636981183663E-3,0,0]
["Total","Total San Luis Canal - Fresno","-",536709.13,663136.79492724629,72995.700308910353,0,0,0,109614.24,-89809.125236156629,11090.258933116609,-100899.38]
["San Luis Canal - Tracy","Pacheco WD - SLC","-",0,0,53.831825660431385,0,0,0,55.1,1.2681743395686169,0,1.27]
["San Luis Canal - Tracy","Panoche WD - SLC","-",4580.42,7575.0376961445127,295.7705934945655,0,0,0,0,-3290.3882896390778,0,-3290.39]
["San Luis Canal - Tracy","San Luis WD - SLC","-",17967.14,38371.916351595406,122.92316311524348,0,20527,0,0,-0.6995147106499644,0,-0.7]
["Total","Total San Luis Canal - Tracy","-",22547.559999999998,45946.95404773992,472.52558227024036,0,20527,0,55.1,-3289.819630010159,0,-3289.8199999999997]
["Shasta Dam","Centerville CSD","-",1674.2400000000002,2301.2774690059277,658.94909961534677,0,0,0,0,-1285.9865686212743,0,-1285.99]
["Shasta Dam","Mountain Gate CSD","-",8163.7199999999993,12369.365145906864,910.57754819831689,0,4066,0,1050.22,-2.6941051812627848E-3,0,0]
["Shasta Dam","Shasta CWA  ","-",1339.1999999999998,2301.2774690059277,160.8480385891597,0,0,0,0,-1122.9255075950878,0,-1122.93]
["Total","Total Shasta Dam","-",11177.16,16971.920083918718,1730.3746864028233,0,4066,0,1050.22,-2408.9147703215431,0,-2408.92]
["Spring Creek Conduit","City of Redding - SCC","-",8942.85,12225.535011093993,6589.2549494269151,0,9871,0,0,-0.93996052090915327,0,-0.94]
["Spring Creek Conduit","Shasta CWA - SCC","-",467.61,623.26274418910555,86.129642255848594,0,0,0,0,-241.78238644495411,0,-241.78]
["Spring Creek Conduit","Shasta CSD  ","-",5461.09,8150.3567303959953,355.46563024893931,0,0,0,3044.73,-2.3606449353792414E-3,0,0]
["Total","Total Spring Creek Conduit","-",14871.550000000001,20999.154485679093,7030.8502219317033,0,9871,0,3044.73,-242.72470761079865,0,-242.72]
["Tehama-Colusa Canal","Colusa County WD","-",467.84,1635.4875726833998,101.92170720867549,0,0,0,0,-1269.5692798920754,0,-1269.57]
["Tehama-Colusa Canal","Kanawha WD","-",197.67999999999998,563.87788790322782,86.393697164661759,0,452,0,0,-0.59158506788958221,0,-0.59]
["Total","Total Tehama-Colusa Canal","-",665.52,2199.3654605866277,188.31540437333723,0,452,0,0,-1270.160864959965,0,-1270.1599999999999]
["Toyon Pipeline","City of Redding - TP","-",290.15999999999997,431.48965043861148,2.7049585643795853,0,0,0,0,-144.03460900299109,0,-144.03]
["Toyon Pipeline","City of Shasta Lake  ","-",44701.88,23242.04349524443,0,0,-21459,0,0,0.83650475556714809,0,0.84]
["Toyon Pipeline","US Forest Service - TP","-",0,0,5.2556856666887128,0,0,0,0,-5.2556856666887128,0,-5.26]
["Total","Total Toyon Pipeline","-",44992.04,23673.533145683043,7.9606442310682981,0,-21459,0,0,-148.45378991411266,0,-148.44999999999999]
["Grand Total","Grand Total","-",8708616.8099999987,8501542.5819463655,461376.27197016863,-85200,-186957.28,969429,136779.48000000001,750149.15608346532,1576626.0102560967,-826476.86]
[]
["Footnotes"]
[]
["1/"]
["As per letter signed 10/21/19, and Public Law 111-11; Title X, Water Marketing for the Friant Division is being reduced by $3.00."]