{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["OUTPUT"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":46,"comments":1,"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":8,"rows_kept":93,"cut":false,"hidden":false,"merged":[]}
[]
["M&I 2023 Sch B-5 F.Z27.XLSM"]
["08/13/2024"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF FY 2023 ALLOCATED M&I PROJECT USE ENERGY (PUE) OFFSET AND ASSOCIATED CREDIT (SEE SCH. B-6A)"]
[]
[]
["Category","A) Facility/Contractor\n\n<Ref>","B) Storage PUE Offset: Total A/F\n\n<2023 Sch B-2>","C) Storage PUE Offset: Ratio of A/F by Contractor\n(E/(Total A/F))","D) Storage PUE Offset: Total Cost\n\nC* Total (Sch B-6A)","E) Direct Pumping PUE Offset\n\n<Sch B-6A>","F) Direct Pumping PUE Credit\n\n<Sch B-6A>","G) Total PUE Offset & Credit\n\nD+E+F"]
["Total","All Other Contractors","-","-",796530.99021433701,"-","-","-"]
["Total","San Felipe Unit Contractors","-","-",25139.75,"-","-","-"]
["Black Butte D & R","County of Colusa",6,2.40229E-5,19.134983999999999,"-","-",19.134983999999999]
["Black Butte D & R","Elk Creek CSD",0,0,0,"-","-",0]
["Black Butte D & R","US Forest Service - BB",1,4.0037999999999997E-6,3.1891509999999998,"-","-",3.1891509999999998]
["Black Butte D & R","Whitney Const.",0,0,0,"-","-",0]
["Total","Total Black Butte D & R",7,2.8026700000000001E-5,22.324134999999998,0,0,22.324134999999998]
["Clear Creek Unit","Clear Creek CSD",914,3.6594838000000001E-3,2914.8922550000002,"-","-",2914.8922550000002]
["Total","Total Clear Creek Unit",914,3.6594838000000001E-3,2914.8922550000002,"-","-",2914.8922550000002]
["Contra Costa Canal","Contra Costa WD",72284,0.28941151980000002,230525.244446,0,-295975.79722896079,-65450.552782960789]
["Total","Total Contra Costa Canal",72284,0.28941151980000002,230525.244446,0,-295975.79722896079,-65450.552782960789]
["Cow Creek Unit","Bella Vista WD (Wintu PP)",1733,6.9386055999999998E-3,5526.8143890000001,137030.53347443399,"-",142557.347863434]
["Total","Total Cow Creek Unit",1733,6.9386055999999998E-3,5526.8143890000001,137030.53347443399,"-",142557.347863434]
["Cross Valley Canal","County of Fresno",0,0,0,"-","-",0]
["Cross Valley Canal","County of Tulare",0,0,0,"-","-",0]
["Total","Total Cross Valley Canal",0,0,0,0,0,0]
["Delta-Mendota Canal","Byron Bethany ID",1464,5.8615802E-3,4668.9302809999999,"-","-",4668.9302809999999]
["Delta-Mendota Canal","City of Tracy",6166,2.46875025E-2,19664.360811999999,"-","-",19664.360811999999]
["Delta-Mendota Canal","Del Puerto WD",30,1.201143E-4,95.674762000000001,"-","-",95.674762000000001]
["Delta-Mendota Canal","Department of VA",273,1.0930406E-3,870.64071100000001,"-","-",870.64071100000001]
["Delta-Mendota Canal","Panoche WD - DMC",23,9.2087699999999996E-5,73.350707,"-","-",73.350707]
["Delta-Mendota Canal","San Luis WD - DMC",4,1.6015199999999999E-5,12.756603,"-","-",12.756603]
["Delta-Mendota Canal","Santa Nella County WD - DMC",0,0,0,"-","-",0]
["Total","Total Delta-Mendota Canal",7960,3.1870340499999997E-2,25385.713876000002,0,0,25385.713876000002]
["Folsom D & R","City of Folsom",4918,1.96907456E-2,15684.289091000001,"-",null,15684.289091000001]
["Folsom D & R","City of Roseville",20774,8.3175182799999997E-2,66251.610717000003,"-",null,66251.610717000003]
["Folsom D & R","El Dorado ID - FD&R",4044,1.61914142E-2,12896.963186000001,"-",null,12896.963186000001]
["Folsom D & R","Placer County WD",0,0,0,"-",null,0]
["Folsom D & R","Sacramento County WA",5000,2.0019058100000001E-2,15945.800171999999,"-",null,15945.800171999999]
["Folsom D & R","San Juan WD",7650,3.0629159E-2,24397.074347999998,"-",null,24397.074347999998]
["Total","Total Folsom D & R",42386,0.16970555969999998,135175.73751400001,0,0,135175.73751400001]
["Folsom-South Canal","East Bay MUD",0,0,0,"-","-",0]
["Folsom-South Canal","Sacramento County WA - FSC",2050,8.2078137999999998E-3,6537.7780540000003,"-","-",6537.7780540000003]
["Folsom-South Canal","Sacramento MUD",498,1.9938982000000001E-3,1588.2017080000001,"-","-",1588.2017080000001]
["Total","Total Folsom-South Canal",2548,1.0201712E-2,8125.9797620000008,0,0,8125.9797620000008]
["Friant Dam","County of Madera",14,5.6053400000000001E-5,44.648269999999997,"-","-",44.648269999999997]
["Friant Dam","Fresno County WW #18",109,4.3641550000000001E-4,347.61847,"-","-",347.61847]
["Total","Total Friant Dam",123,4.9246890000000001E-4,392.26674000000003,0,0,392.26674000000003]
["Friant-Kern Canal","Arvin-Edison WSD",284,1.1370824999999999E-3,905.72145,"-","-",905.72145]
["Friant-Kern Canal","City of Fresno",58819,0.23550019620000001,187583.20447500001,"-","-",187583.20447500001]
["Friant-Kern Canal","City of Lindsay",1041,4.1679678999999997E-3,3319.9155989999999,"-","-",3319.9155989999999]
["Friant-Kern Canal","City of Orange Cove",1156,4.6284061999999999E-3,3686.6689740000002,"-","-",3686.6689740000002]
["Friant-Kern Canal","Delano-Earlimart ID",204,8.1677759999999996E-4,650.58867099999998,"-","-",650.58867099999998]
["Friant-Kern Canal","Lindsay-Strathmore ID",651,2.6064814E-3,2076.1432110000001,"-","-",2076.1432110000001]
["Friant-Kern Canal","Shafter-Wasco ID",208,8.3279280000000001E-4,663.34527400000002,"-","-",663.34527400000002]
["Friant-Kern Canal","Terra Bella ID",1383,5.5372714999999996E-3,4410.6083509999999,"-","-",4410.6083509999999]
["Total","Total Friant-Kern Canal",63746,0.25522697610000006,203296.19600500001,0,0,203296.19600500001]
["New Melones D & R","Stockton East WD",36495,0.1461191054,116388.39571300001,"-","-",116388.39571300001]
["Total","Total New Melones D & R",36495,0.1461191054,116388.39571300001,"-","-",116388.39571300001]
["Sacramento River","City of Redding - SR",2377,9.5170602E-3,7580.6333850000001,"-","-",7580.6333850000001]
["Sacramento River","City of West Sacramento",2541,1.0173685300000001E-2,8103.6556259999998,"-","-",8103.6556259999998]
["Sacramento River","Lake California P.O.A.",200,8.007623E-4,637.83198800000002,"-","-",637.83198800000002]
["Sacramento River","Riverview Golf & CC",25,1.000953E-4,79.729007999999993,"-","-",79.729007999999993]
["Total","Total Sacramento River",5143,2.0591603100000001E-2,16401.850007000001,0,0,16401.850007000001]
["San Luis Canal - Fresno","City of Avenal",2284,9.1447057999999998E-3,7284.0415659999999,"-","-",7284.0415659999999]
["San Luis Canal - Fresno","City of Coalinga",2955,1.18312634E-2,9423.9679510000005,69588.451867524898,"-",79012.419818524897]
["San Luis Canal - Fresno","City of Huron",767,3.0709234999999999E-3,2446.085736,"-","-",2446.085736]
["San Luis Canal - Fresno","State of CA",2,8.0075999999999994E-6,6.3783019999999997,"-","-",6.3783019999999997]
["San Luis Canal - Fresno","Westlands WD",3619,1.4489794300000001E-2,11541.570202000001,"-",-10252.060939177316,1289.5092628226848]
["Total","Total San Luis Canal - Fresno",9627,3.8544694599999998E-2,30702.043756999999,69588.451867524898,-10252.060939177316,90038.434685347573]
["San Luis Canal - Tracy","Pacheco WD - SLC",0,0,0,"-","-",0]
["San Luis Canal - Tracy","Panoche WD - SLC",147,5.8856030000000001E-4,468.80651899999998,"-","-",468.80651899999998]
["San Luis Canal - Tracy","San Luis WD - SLC",273,1.0930406E-3,870.64071100000001,"-",-1806.0600337988667,-935.41932279886669]
["San Luis Canal - Tracy","Santa Nella County WD - SLC",182,7.2869370000000001E-4,580.42711399999996,"-","-",580.42711399999996]
["Total","Total San Luis Canal - Tracy",602,2.4102946000000001E-3,1919.8743439999998,0,-1806.0600337988667,113.81431020113325]
["Shasta Dam","Centerville CSD",275,1.1010481999999999E-3,877.01901299999997,"-","-",877.01901299999997]
["Shasta Dam","Mountain Gate CSD",458,1.8337456999999999E-3,1460.635278,"-","-",1460.635278]
["Shasta Dam","Shasta CWA  ",82,3.2831260000000003E-4,261.51116000000002,"-","-",261.51116000000002]
["Total","Total Shasta Dam",815,3.2631064999999997E-3,2599.1654509999998,0,0,2599.1654509999998]
["Spring Creek Conduit","City of Redding - SCC",4526,1.81212514E-2,14434.138322000001,"-","-",14434.138322000001]
["Spring Creek Conduit","Shasta CWA  - SCC",0,0,0,"-","-",0]
["Spring Creek Conduit","Shasta CSD  ",186,7.4470899999999997E-4,593.18379700000003,"-","-",593.18379700000003]
["Total","Total Spring Creek Conduit",4712,1.8865960399999999E-2,15027.322119,0,0,15027.322119]
["Tehama-Colusa Canal","Colusa County WD",72,2.8827440000000001E-4,229.61949300000001,"-",-446.2037712317952,-216.5842782317952]
["Tehama-Colusa Canal","Kanawha WD",27,1.081029E-4,86.107309999999998,"-",-14.136701502724081,71.970608497275919]
["Total","Total Tehama-Colusa Canal",99,3.963773E-4,315.72680300000002,0,-460.34047273451927,-144.61366973451928]
["Toyon Pipeline","City of Redding - TP",11,4.4041900000000003E-5,35.080737999999997,"-","-",35.080737999999997]
["Toyon Pipeline","City of Shasta Lake  ",557,2.2301231000000001E-3,1776.362161,578.44560000000001,"-",2354.807761]
["Toyon Pipeline","US Forest Service - TP",0,0,0,"-","-",0]
["Total","Total Toyon Pipeline",568,2.2741650000000003E-3,1811.4428990000001,578.44560000000001,0,2389.8884990000001]
["Total","Total AF/Cost without San Felipe Unit",249762,0.99999999999999978,796530.990215,207197.43094195888,-308494.25867467147,695234.16248228739]
["San Felipe Unit","SB County WD - IB",8871,7.7835589799999993E-2,1956.7672689999999,"-",-51895.525342431836,-49938.758073431833]
["San Felipe Unit","SC Valley WD - IB",105100,0.92216441019999995,23182.982731,"-",-668478.38718289661,-645295.40445189655]
["Total","Total San Felipe Unit",113971,1,25139.75,0,-720373.91252532846,-695234.16252532834]
["GRAND TOTAL","GRAND TOTAL",363733,"-",821670.740215,207197.43094195888,-1028868.1712,-4.3040956370532513E-5]