{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Rebate Analysis","Commodity Revenue","Tonnages Collected","CRC Prices","CRC Composition","Customers"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":5,"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":"Rebate Analysis","index":0,"n_rows":31,"n_cols":30,"rows_kept":31,"cut":false,"hidden":false,"merged":[[4,18,4,23],[4,24,4,29],[4,12,4,17],[4,6,4,11],[4,0,4,5]]}
["WM Skagit County",null,null,null,null,null,"WM Skagit County",null,null,null,null,null,"WM Skagit County",null,null,null,null,null,"WM Skagit County",null,null,null,null,null,"WM Skagit County"]
["2020 - 2021 Rebate Calculation",null,null,null,null,null,"2019 - 2020 Rebate Calculation",null,null,null,null,null,"2018 - 2019 Rebate Calculation",null,null,null,null,null,"2017 - 2018 Rebate Calculation",null,null,null,null,null,"2016 - 2017 Rebate Calculation"]
[]
[]
["Residential",null,null,null,null,null,"Residential",null,null,null,null,null,"Residential",null,null,null,null,null,"Residential",null,null,null,null,null,"Residential"]
[]
[null,null,null,"Commodity","Total",null,null,null,null,"Commodity","Total",null,null,null,null,"Commodity","Total",null,null,null,null,"Commodity","Total",null,null,null,null,"Commodity","Total"]
[null,null,"Customers","Credit","Credits",null,null,null,"Customers","Credit","Credits",null,null,null,"Customers","Credit","Credits",null,null,null,"Customers","Credit","Credits",null,null,null,"Customers","Credit","Credits"]
["Projected Revenue May 2019-Apr 2020",null,null,null,null,null,"Projected Revenue May 2018-Apr 2019",null,null,null,null,null,"Projected Revenue May 2017-Apr 2018",null,null,null,null,null,"Projected Revenue May 2016-Apr 2017",null,null,null,null,null,"Projected Revenue May 2015-Apr 2016"]
["May - June projected value without adjustment factor",null,{"$f":"+Customers!C20+Customers!D20","v":22959},{"$f":"+J11","v":1.25},{"$f":"C10*D10","v":28698.75},null,"May - June projected value without adjustment factor",null,21720,{"$f":"+P11","v":2.04},{"$f":"I10*J10","v":44308.800000000003},null,"May - June projected value without adjustment factor",null,20086,{"$f":"+V11","v":1.71},{"$f":"O10*P10","v":34347.06},null,"May - June projected value without adjustment factor",null,18118,{"$f":"+AB11","v":2.3199999999999998},{"$f":"U10*V10","v":42033.759999999995},null,"May - June projected value without adjustment factor",null,17149,2.37,{"$f":"AA10*AB10","v":40643.130000000005}]
["July - April projected value without adjustment factor",null,{"$f":"SUM(Customers!E20:N20)","v":116746},{"$f":"+L25","v":0.6},{"$f":"C11*D11","v":70047.599999999991},null,"July - April projected value without adjustment factor",null,111104,{"$f":"+R25","v":1.25},{"$f":"I11*J11","v":138880},null,"July - April projected value without adjustment factor",null,104400,{"$f":"+X25","v":2.04},{"$f":"O11*P11","v":212976},null,"July - April projected value without adjustment factor",null,93257,{"$f":"+AD25","v":1.71},{"$f":"U11*V11","v":159469.47},null,"July - April projected value without adjustment factor",null,87893,2.3199999999999998,{"$f":"AA11*AB11","v":203911.75999999998}]
["Total",null,{"$f":"SUM(C10:C11)","v":139705},null,{"$f":"SUM(E10:E11)","v":98746.349999999991},null,"Total",null,{"$f":"SUM(I10:I11)","v":132824},null,{"$f":"SUM(K10:K11)","v":183188.8},null,"Total",null,{"$f":"SUM(O10:O11)","v":124486},null,{"$f":"SUM(Q10:Q11)","v":247323.06},null,"Total",null,{"$f":"SUM(U10:U11)","v":111375},null,{"$f":"SUM(W10:W11)","v":201503.22999999998},null,"Total",null,{"$f":"SUM(AA10:AA11)","v":105042},null,{"$f":"SUM(AC10:AC11)","v":244554.88999999998}]
[]
["Actual Commodity Revenue ",null,null,null,{"$f":"+'Commodity Revenue'!Y40","v":36117.612530615101},null,"Actual Commodity Revenue ",null,null,null,99599.598432167913,null,"Actual Commodity Revenue ",null,null,null,205192,null,"Actual Commodity Revenue ",null,null,null,231469,null,"Actual Commodity Revenue (adj. to reflect current customers)",null,null,null,183627]
[]
["Owe Customer (company)",null,null,null,{"$f":"E14-E12","v":-62628.737469384891},null,"Owe Customer (company)",null,null,null,{"$f":"K14-K12","v":-83589.201567832075},null,"Owe Customer (company)",null,null,null,{"$f":"Q14-Q12","v":-42131.06},null,"Owe Customer (company)",null,null,null,{"$f":"W14-W12","v":29965.770000000019},null,"Owe Customer (company)",null,null,null,{"$f":"AC14-AC12","v":-60927.889999999985}]
[]
["Total Current Customers",null,null,null,{"$f":"+C12","v":139705},null,"Total Current Customers",null,null,null,{"$f":"+I12","v":132824},null,"Total Current Customers",null,null,null,{"$f":"+O12","v":124486},null,"Total Current Customers",null,null,null,{"$f":"+U12","v":111375},null,"Total Customers",null,null,null,{"$f":"+AA12","v":105042}]
[]
["Adjust for Under/(Over) payment in 2019-2020",null,null,null,null,{"$f":"ROUND(+E16/E18,2)","v":-0.45},"Adjust for Under/(Over) payment in 2018-2019",null,null,null,null,{"$f":"+K16/K18","v":-0.6293230257169794},"Adjust for Under/(Over) payment in 2017-2018",null,null,null,null,{"$f":"+Q16/Q18","v":-0.33844014587985793},"Adjust for Under/(Over) payment in 2016-2017",null,null,null,null,{"$f":"+W16/W18","v":0.26905292929292945},"Adjust for Under/(Over) payment in 2015-2016",null,null,null,null,-0.65]
[]
[]
["Projected Rev. May 2020-Apr 2021 (based on most recent 6 mo. avg.)",null,null,null,{"$f":"SUM('Commodity Revenue'!Y34:Y39)","v":15859.85370008423},null,"Projected Rev. May 2019-Apr 2020 (based on most recent 6 mo. avg.)",null,null,null,39969.884180818815,null,"Projected Rev. May 2018-Apr 2019(based on 6 mo. avg. - since \"China Sword\")",null,null,null,78930,null,"Projected Revenue May 2017-Apr 2018",null,null,null,{"$f":"+W14","v":231469},null,"Projected Revenue May 2016-Apr 2017",null,null,null,{"$f":"+AC14","v":183627}]
["Total Current Customers (most recent 6 months)",null,null,null,{"$f":"SUM(Customers!I20:N20)","v":70108},null,"Total Current Customers (annualized)",null,null,null,66822,null,"Total Current Customers (most recent 6 months)",null,null,null,63172,null,"Total Customers",null,null,null,113724,null,"Total Customers",null,null,null,107280]
["Projected Value",null,null,null,null,{"$f":"ROUND(+E23/E24,2)","v":0.23},"Projected Value",null,null,null,null,{"$f":"ROUND(+K23/K24,2)","v":0.6},"Projected Value",null,null,null,null,{"$f":"ROUND(+Q23/Q24,2)","v":1.25},"Projected Value",null,null,null,null,2.04,"Projected Value",null,null,null,null,{"$f":"ROUND(+AC23/AC24,2)","v":1.71}]
[]
["Residential Commodity Adjustment - as calculated",null,null,null,null,{"$f":"SUM(F20:F25)","v":-0.22},"Residential Commodity Adjustment - as calculated",null,null,null,null,{"$f":"SUM(L20:L25)","v":-2.9323025716979423E-2},"Residential Commodity Adjustment",null,null,null,null,{"$f":"SUM(R20:R25)","v":0.91155985412014207},"Residential Commodity Adjustment",null,null,null,null,{"$f":"SUM(X20:X25)","v":2.3090529292929296},"Residential Commodity Adjustment",null,null,null,null,{"$f":"SUM(AD20:AD25)","v":1.06}]
[]
["Estimated cost of customer notice letters",null,null,8313.5,null,{"$f":"ROUND(-D29/12400/12,2)","v":-0.06},"Residential Commodity Adjustment - as proposed",null,null,null,null,0]
[]
["Residential Commodity Adjustment - as including cost of customer notices",null,null,null,null,{"$f":"+F27+F29","v":-0.28000000000000003}]

{"sheet":"Commodity Revenue","index":1,"n_rows":40,"n_cols":36,"rows_kept":40,"cut":false,"hidden":false,"merged":[[3,26,3,35],[22,14,22,24],[3,14,3,23],[3,2,3,12],[22,2,22,12]]}
["Waste Management of Skagit County"]
["Single Stream Tonnage and Revenue"]
[]
[null,null,"Total Single Stream Tonnage Processed",null,null,null,null,null,null,null,null,null,null,null,"Total Single Stream Commodity Revenue",null,null,null,null,null,null,null,null,null,null,null,"Average rate per ton"]
[null,null,null,"Mixed",null,null,null,null,null,"Natural","Colored","Mixed",null,null,null,"Mixed",null,null,null,null,null,"Natural","Colored","Mixed",null,null,null,"Mixed",null,null,null,null,null,"Natural","Colored","Mixed"]
[null,null,"ONP 6","Paper","OCC","Alum.","Tin","Glass","PET","HDPE","HDPE","Plastics","Total",null,"ONP 6","Paper","OCC","Alum.","Tin","Glass","PET","HDPE","HDPE","Plastics","Total",null,"ONP 6","Paper","OCC","Alum.","Tin","Glass","PET","HDPE","HDPE","Plastics"]
[null,null,{"$f":"+'CRC Composition'!$AC8","v":0},{"$f":"+'CRC Composition'!$AC9","v":0.44957599993041408},{"$f":"+'CRC Composition'!$AC10","v":0.27081958546802554},{"$f":"+'CRC Composition'!$AC11","v":1.002387341288022E-2},{"$f":"+'CRC Composition'!AC12","v":1.1347303566237917E-2},{"$f":"+'CRC Composition'!AC13","v":0.23716662873629818},{"$f":"+'CRC Composition'!AC14","v":9.4765336515935765E-3},{"$f":"+'CRC Composition'!$AC15","v":4.3065357119071454E-3},{"$f":"+'CRC Composition'!$AC16","v":3.9360168127818892E-3},{"$f":"+'CRC Composition'!$AC17","v":3.3475227098615024E-3},{"$f":"+M20/$M$20","v":1}]
["May, 19",null,{"$f":"+'Tonnages Collected'!$E10*C$7","v":0},{"$f":"+'Tonnages Collected'!$E10*D$7","v":304.72454288569645},{"$f":"+'Tonnages Collected'!$E10*E$7","v":183.56267772081085},{"$f":"+'Tonnages Collected'!$E10*F$7","v":6.7942244340373898},{"$f":"+'Tonnages Collected'!$E10*G$7","v":7.6912510737723654},{"$f":"+'Tonnages Collected'!$E10*H$7","v":160.75255916818571},{"$f":"+'Tonnages Collected'!$E10*I$7","v":6.4232351939821939},{"$f":"+'Tonnages Collected'!$E10*J$7","v":2.9189883944760235},{"$f":"+'Tonnages Collected'!$E10*K$7","v":2.6678490939263253},{"$f":"+'Tonnages Collected'!$E10*L$7","v":2.2689652644267535},{"$f":"SUM(C8:L8)","v":677.804293229314},null,{"$f":"+C8*'CRC Prices'!B8","v":0},{"$f":"+D8*'CRC Prices'!C8","v":-1413.9218789896315},{"$f":"+E8*'CRC Prices'!D8","v":9016.5987296462281},{"$f":"+F8*'CRC Prices'!E8","v":6767.7269587446444},{"$f":"+G8*'CRC Prices'!F8","v":980.40377437376344},{"$f":"+H8*'CRC Prices'!G8","v":-8574.5415060310261},{"$f":"+I8*'CRC Prices'!H8","v":1091.9499829769729},{"$f":"+J8*'CRC Prices'!I8","v":1225.97512567993},{"$f":"+K8*'CRC Prices'!J8","v":613.60529160305487},{"$f":"+L8*'CRC Prices'!K8","v":-317.6551370197455},{"$f":"SUM(O8:X8)","v":9390.1413409841898},null,{"$f":"+O8/C8","v":{"$error":"#DIV/0!"}},{"$f":"+P8/D8","v":-4.6399999999999997},49.12,996.1,127.47,-53.34,170,420.00000000000006,230.00000000000003,{"$f":"+X8/L8","v":-140}]
["Jun",null,{"$f":"+'Tonnages Collected'!$E11*C$7","v":0},{"$f":"+'Tonnages Collected'!$E11*D$7","v":256.57781317069316},{"$f":"+'Tonnages Collected'!$E11*E$7","v":154.55962287563125},{"$f":"+'Tonnages Collected'!$E11*F$7","v":5.7207313561550031},{"$f":"+'Tonnages Collected'!$E11*G$7","v":6.4760270451713895},{"$f":"+'Tonnages Collected'!$E11*H$7","v":135.35352191318879},{"$f":"+'Tonnages Collected'!$E11*I$7","v":5.4083587227536807},{"$f":"+'Tonnages Collected'!$E11*J$7","v":2.4577858147980693},{"$f":"+'Tonnages Collected'!$E11*K$7","v":2.2463267313712727},{"$f":"+'Tonnages Collected'!$E11*L$7","v":1.9104668767203734},570.71065450648302,null,{"$f":"+C9*'CRC Prices'!B9","v":0},{"$f":"+D9*'CRC Prices'!C9","v":161.64402229753668},{"$f":"+E9*'CRC Prices'!D9","v":7540.9640001020489},{"$f":"+F9*'CRC Prices'!E9","v":5352.9455372677985},{"$f":"+G9*'CRC Prices'!F9","v":768.25108836868196},{"$f":"+H9*'CRC Prices'!G9","v":-7219.7568588494905},{"$f":"+I9*'CRC Prices'!H9","v":1000.5463637094309},{"$f":"+J9*'CRC Prices'!I9","v":1032.2700422151891},{"$f":"+K9*'CRC Prices'!J9","v":516.65514821539273},{"$f":"+L9*'CRC Prices'!K9","v":-267.4653627408523},{"$f":"SUM(O9:X9)","v":8886.053980585737},null,{"$f":"+O9/C9","v":{"$error":"#DIV/0!"}},0.63,48.79,935.71000000000015,118.63000000000001,-53.34,185,419.99999999999994,230,{"$f":"+X9/L9","v":-140}]
["Jul",null,{"$f":"+'Tonnages Collected'!$E12*C$7","v":0},{"$f":"+'Tonnages Collected'!$E12*D$7","v":303.25075003382682},{"$f":"+'Tonnages Collected'!$E12*E$7","v":182.67488128756963},{"$f":"+'Tonnages Collected'!$E12*F$7","v":6.7613643325501318},{"$f":"+'Tonnages Collected'!$E12*G$7","v":7.6540525247250306},{"$f":"+'Tonnages Collected'!$E12*H$7","v":159.97508331941336},{"$f":"+'Tonnages Collected'!$E12*I$7","v":6.3921693729455233},{"$f":"+'Tonnages Collected'!$E12*J$7","v":2.904870777989573},{"$f":"+'Tonnages Collected'!$E12*K$7","v":2.6549461065684272},{"$f":"+'Tonnages Collected'!$E12*L$7","v":2.25799146902391},674.52610922461247,null,{"$f":"+C10*'CRC Prices'!B10","v":0},{"$f":"+D10*'CRC Prices'!C10","v":-873.36216009742122},{"$f":"+E10*'CRC Prices'!D10","v":8857.9049936342526},{"$f":"+F10*'CRC Prices'!E10","v":6596.6574974092109},{"$f":"+G10*'CRC Prices'!F10","v":852.35528915337943},{"$f":"+H10*'CRC Prices'!G10","v":-8533.0709442575098},{"$f":"+I10*'CRC Prices'!H10","v":1182.5513339949218},{"$f":"+J10*'CRC Prices'!I10","v":1220.0457267556208},{"$f":"+K10*'CRC Prices'!J10","v":557.53868237936967},{"$f":"+L10*'CRC Prices'!K10","v":-316.11880566334742},9544.5016133084755,null,{"$error":"#DIV/0!"},-2.88,48.490000000000009,975.6400000000001,111.36,-53.340000000000011,185,420,209.99999999999997,-140]
["Aug",null,{"$f":"+'Tonnages Collected'!$E13*C$7","v":0},{"$f":"+'Tonnages Collected'!$E13*D$7","v":273.08635245492576},{"$f":"+'Tonnages Collected'!$E13*E$7","v":164.50418345344343},{"$f":"+'Tonnages Collected'!$E13*F$7","v":6.0888104085117147},{"$f":"+'Tonnages Collected'!$E13*G$7","v":6.8927027723506562},{"$f":"+'Tonnages Collected'!$E13*H$7","v":144.06233779305825},{"$f":"+'Tonnages Collected'!$E13*I$7","v":5.7563393269004752},{"$f":"+'Tonnages Collected'!$E13*J$7","v":2.6159228461119604},{"$f":"+'Tonnages Collected'!$E13*K$7","v":2.3908582192337637},{"$f":"+'Tonnages Collected'!$E13*L$7","v":2.0333887190099151},607.43089599354607,null,{"$f":"+C11*'CRC Prices'!B11","v":0},{"$f":"+D11*'CRC Prices'!C11","v":-385.05175696144528},{"$f":"+E11*'CRC Prices'!D11","v":10605.584707243497},{"$f":"+F11*'CRC Prices'!E11","v":5583.6826970215825},{"$f":"+G11*'CRC Prices'!F11","v":798.58854320454702},{"$f":"+H11*'CRC Prices'!G11","v":-7684.2850978817278},{"$f":"+I11*'CRC Prices'!H11","v":748.32411249706183},{"$f":"+J11*'CRC Prices'!I11","v":1072.5283669059038},{"$f":"+K11*'CRC Prices'!J11","v":478.17164384675277},{"$f":"+L11*'CRC Prices'!K11","v":-284.67442066138813},10932.868795214783,null,{"$error":"#DIV/0!"},-1.41,64.47,917.04,115.86,-53.34,130,410,200,-140]
["Sep",null,{"$f":"+'Tonnages Collected'!$E14*C$7","v":0},{"$f":"+'Tonnages Collected'!$E14*D$7","v":285.02309978197843},{"$f":"+'Tonnages Collected'!$E14*E$7","v":171.69474737022131},{"$f":"+'Tonnages Collected'!$E14*F$7","v":6.354955496742476},{"$f":"+'Tonnages Collected'!$E14*G$7","v":7.1939864163496932},{"$f":"+'Tonnages Collected'!$E14*H$7","v":150.35937794215937},{"$f":"+'Tonnages Collected'!$E14*I$7","v":6.0079519302264828},{"$f":"+'Tonnages Collected'!$E14*J$7","v":2.730266202198409},{"$f":"+'Tonnages Collected'!$E14*K$7","v":2.4953638827400022},{"$f":"+'Tonnages Collected'!$E14*L$7","v":2.122269203656276},633.98201822627243,null,{"$f":"+C12*'CRC Prices'!B12","v":0},{"$f":"+D12*'CRC Prices'!C12","v":199.5161698473849},{"$f":"+E12*'CRC Prices'!D12","v":9920.5225030513866},{"$f":"+F12*'CRC Prices'!E12","v":5859.0147697766934},{"$f":"+G12*'CRC Prices'!F12","v":740.54896169903736},{"$f":"+H12*'CRC Prices'!G12","v":-8020.1692194347816},{"$f":"+I12*'CRC Prices'!H12","v":653.0042952963164},{"$f":"+J12*'CRC Prices'!I12","v":1365.1331010992044},{"$f":"+K12*'CRC Prices'!J12","v":548.98005420280049},{"$f":"+L12*'CRC Prices'!K12","v":-355.48009161242624},10911.070543925614,null,{"$error":"#DIV/0!"},0.7,57.779999999999994,921.96,102.94,-53.34,108.69,499.99999999999994,220,-167.5]
["Oct",null,{"$f":"+'Tonnages Collected'!$E15*C$7","v":0},{"$f":"+'Tonnages Collected'!$E15*D$7","v":295.10993665766586},{"$f":"+'Tonnages Collected'!$E15*E$7","v":177.77094579224578},{"$f":"+'Tonnages Collected'!$E15*F$7","v":6.5798544593070094},{"$f":"+'Tonnages Collected'!$E15*G$7","v":7.4485782986326976},{"$f":"+'Tonnages Collected'!$E15*H$7","v":155.68052741808791},{"$f":"+'Tonnages Collected'!$E15*I$7","v":6.2205705956031538},{"$f":"+'Tonnages Collected'!$E15*J$7","v":2.8268890718179023},{"$f":"+'Tonnages Collected'!$E15*K$7","v":2.583673666929192},{"$f":"+'Tonnages Collected'!$E15*L$7","v":2.197375338141343},656.41835129843082,null,{"$f":"+C13*'CRC Prices'!B13","v":0},{"$f":"+D13*'CRC Prices'!C13","v":-2676.6471254850294},{"$f":"+E13*'CRC Prices'!D13","v":9215.6458298700218},{"$f":"+F13*'CRC Prices'!E13","v":5893.2466464783229},{"$f":"+G13*'CRC Prices'!F13","v":554.02525385230001},{"$f":"+H13*'CRC Prices'!G13","v":-8303.9993324808092},{"$f":"+I13*'CRC Prices'!H13","v":520.786170263896},{"$f":"+J13*'CRC Prices'!I13","v":2280.1404564376021},{"$f":"+K13*'CRC Prices'!J13","v":671.75515340158995},{"$f":"+L13*'CRC Prices'!K13","v":-368.06036913867496},7786.8926831992185,null,{"$error":"#DIV/0!"},-9.07,51.84,895.65,74.38,-53.34,83.72,806.59000000000015,260,-167.5]
["Nov",null,{"$f":"+'Tonnages Collected'!$E16*C$7","v":0},{"$f":"+'Tonnages Collected'!$E16*D$7","v":242.33889129377562},{"$f":"+'Tonnages Collected'!$E16*E$7","v":145.98225459793122},{"$f":"+'Tonnages Collected'!$E16*F$7","v":5.4032563342405684},{"$f":"+'Tonnages Collected'!$E16*G$7","v":6.1166364882503395},{"$f":"+'Tonnages Collected'!$E16*H$7","v":127.84200639876907},{"$f":"+'Tonnages Collected'!$E16*I$7","v":5.1082189858684677},{"$f":"+'Tonnages Collected'!$E16*J$7","v":2.3213896869542956},{"$f":"+'Tonnages Collected'!$E16*K$7","v":2.1216656375581913},{"$f":"+'Tonnages Collected'!$E16*L$7","v":1.8044445037416048},539.03876392708924,null,{"$f":"+C14*'CRC Prices'!B14","v":0},{"$f":"+D14*'CRC Prices'!C14","v":-3104.3611974732657},{"$f":"+E14*'CRC Prices'!D14","v":7529.7646921612923},{"$f":"+F14*'CRC Prices'!E14","v":4074.4335039607859},{"$f":"+G14*'CRC Prices'!F14","v":500.95252838770284},{"$f":"+H14*'CRC Prices'!G14","v":-6819.092621310343},{"$f":"+I14*'CRC Prices'!H14","v":409.62808047679243},{"$f":"+J14*'CRC Prices'!I14","v":1996.3951307806942},{"$f":"+K14*'CRC Prices'!J14","v":657.71634764303928},{"$f":"+L14*'CRC Prices'!K14","v":-302.24445437671881},4943.1920102499798,null,{"$error":"#DIV/0!"},-12.81,51.58,754.07,81.900000000000006,-53.34,80.19,860,310,-167.5]
["Dec",null,{"$f":"+'Tonnages Collected'!$E17*C$7","v":0},{"$f":"+'Tonnages Collected'!$E17*D$7","v":304.81073879069277},{"$f":"+'Tonnages Collected'!$E17*E$7","v":183.61460117594137},{"$f":"+'Tonnages Collected'!$E17*F$7","v":6.7961462822688912},{"$f":"+'Tonnages Collected'!$E17*G$7","v":7.6934266594359944},{"$f":"+'Tonnages Collected'!$E17*H$7","v":160.79803043934345},{"$f":"+'Tonnages Collected'!$E17*I$7","v":6.4250521023457496},{"$f":"+'Tonnages Collected'!$E17*J$7","v":2.9198140741011462},{"$f":"+'Tonnages Collected'!$E17*K$7","v":2.6686037350355285},{"$f":"+'Tonnages Collected'!$E17*L$7","v":2.2696070752652258},677.99602033443011,null,{"$f":"+C15*'CRC Prices'!B15","v":0},{"$f":"+D15*'CRC Prices'!C15","v":-4605.6902631273679},{"$f":"+E15*'CRC Prices'!D15","v":8830.026170551022},{"$f":"+F15*'CRC Prices'!E15","v":5948.7348023327831},{"$f":"+G15*'CRC Prices'!F15","v":766.9577036791743},{"$f":"+H15*'CRC Prices'!G15","v":-8576.9669436345794},{"$f":"+I15*'CRC Prices'!H15","v":483.42092018049419},{"$f":"+J15*'CRC Prices'!I15","v":2948.8954222791936},{"$f":"+K15*'CRC Prices'!J15","v":693.83697110923742},{"$f":"+L15*'CRC Prices'!K15","v":-380.15918510692529},6109.0555982630322,null,{"$error":"#DIV/0!"},-15.110000000000001,48.090000000000011,875.31000000000006,99.69,-53.339999999999996,75.239999999999995,1009.9599999999999,260,-167.5]
["Jan., '20",null,{"$f":"+'Tonnages Collected'!$E18*C$7","v":0},{"$f":"+'Tonnages Collected'!$E18*D$7","v":278.12416759005208},{"$f":"+'Tonnages Collected'!$E18*E$7","v":167.53890729717759},{"$f":"+'Tonnages Collected'!$E18*F$7","v":6.2011349569747436},{"$f":"+'Tonnages Collected'!$E18*G$7","v":7.0198572860651662},{"$f":"+'Tonnages Collected'!$E18*H$7","v":146.71995659828704},{"$f":"+'Tonnages Collected'!$E18*I$7","v":5.8625305485535915},{"$f":"+'Tonnages Collected'!$E18*J$7","v":2.664180606296592},{"$f":"+'Tonnages Collected'!$E18*K$7","v":2.4349640546756319},{"$f":"+'Tonnages Collected'!$E18*L$7","v":2.0709000643119988},618.63659900239441,null,{"$f":"+C16*'CRC Prices'!B16","v":0},{"$f":"+D16*'CRC Prices'!C16","v":-1312.7460710250457},{"$f":"+E16*'CRC Prices'!D16","v":9028.6717142448997},{"$f":"+F16*'CRC Prices'!E16","v":5487.6323688252296},{"$f":"+G16*'CRC Prices'!F16","v":807.00279360605145},{"$f":"+H16*'CRC Prices'!G16","v":-7826.0424849526316},{"$f":"+I16*'CRC Prices'!H16","v":820.75427679750283},{"$f":"+J16*'CRC Prices'!I16","v":2780.9516422705715},{"$f":"+K16*'CRC Prices'!J16","v":633.09065421566424},{"$f":"+L16*'CRC Prices'!K16","v":-346.87576077225981},10072.43913320998,null,{"$error":"#DIV/0!"},-4.72,53.89,884.94,114.96,-53.34,140,1043.83,260,-167.5]
["Feb",null,{"$f":"+'Tonnages Collected'!$E19*C$7","v":0},{"$f":"+'Tonnages Collected'!$E19*D$7","v":249.61094615148559},{"$f":"+'Tonnages Collected'!$E19*E$7","v":150.3628596177067},{"$f":"+'Tonnages Collected'!$E19*F$7","v":5.5653961222997355},{"$f":"+'Tonnages Collected'!$E19*G$7","v":6.3001832390411794},{"$f":"+'Tonnages Collected'!$E19*H$7","v":131.6782626376596},{"$f":"+'Tonnages Collected'!$E19*I$7","v":5.2615053547715895},{"$f":"+'Tonnages Collected'!$E19*J$7","v":2.3910494640521014},{"$f":"+'Tonnages Collected'!$E19*K$7","v":2.1853321370774026},{"$f":"+'Tonnages Collected'!$E19*L$7","v":1.8585918977023828},555.21412662179614,null,{"$f":"+C17*'CRC Prices'!B17","v":0},{"$f":"+D17*'CRC Prices'!C17","v":-3561.9482015816993},{"$f":"+E17*'CRC Prices'!D17","v":8963.1300618114965},{"$f":"+F17*'CRC Prices'!E17","v":4662.1323316504886},{"$f":"+G17*'CRC Prices'!F17","v":632.160386205392},{"$f":"+H17*'CRC Prices'!G17","v":-7023.7185290927637},{"$f":"+I17*'CRC Prices'!H17","v":894.45591031117021},{"$f":"+J17*'CRC Prices'!I17","v":2582.3334211762694},{"$f":"+K17*'CRC Prices'!J17","v":349.65314193238441},{"$f":"+L17*'CRC Prices'!K17","v":-311.31414286514911},7186.8843795475914,null,{"$error":"#DIV/0!"},-14.27,59.61,837.7,100.34,-53.34,170,1080,160,-167.5]
["Mar",null,{"$f":"+'Tonnages Collected'!$E20*C$7","v":0},{"$f":"+'Tonnages Collected'!$E20*D$7","v":258.38758179412298},{"$f":"+'Tonnages Collected'!$E20*E$7","v":155.64980737939962},{"$f":"+'Tonnages Collected'!$E20*F$7","v":5.7610824682932646},{"$f":"+'Tonnages Collected'!$E20*G$7","v":6.5217056266746045},{"$f":"+'Tonnages Collected'!$E20*H$7","v":136.30823640701857},{"$f":"+'Tonnages Collected'!$E20*I$7","v":5.4465065181524244},{"$f":"+'Tonnages Collected'!$E20*J$7","v":2.4751217784800632},{"$f":"+'Tonnages Collected'!$E20*K$7","v":2.2621711708657464},{"$f":"+'Tonnages Collected'!$E20*L$7","v":1.9239423326331977},574.73615547564032,null,{"$f":"+C18*'CRC Prices'!B18","v":0},{"$f":"+D18*'CRC Prices'!C18","v":-6712.9093750113152},{"$f":"+E18*'CRC Prices'!D18","v":12294.778284898775},{"$f":"+F18*'CRC Prices'!E18","v":4701.3889590754015},{"$f":"+G18*'CRC Prices'!F18","v":715.5615413587376},{"$f":"+H18*'CRC Prices'!G18","v":-7270.681329950371},{"$f":"+I18*'CRC Prices'!H18","v":871.44104290438793},{"$f":"+J18*'CRC Prices'!I18","v":1594.6962106569199},{"$f":"+K18*'CRC Prices'!J18","v":339.32567562986196},{"$f":"+L18*'CRC Prices'!K18","v":-322.26034071606063},6211.3406688463383,null,{"$error":"#DIV/0!"},-25.98,78.989999999999995,816.06,109.72,-53.34,160,644.29,150,-167.5]
["Apr",null,{"$f":"+'Tonnages Collected'!$E21*C$7","v":0},{"$f":"+'Tonnages Collected'!$E21*D$7","v":292.47664863940133},{"$f":"+'Tonnages Collected'!$E21*E$7","v":176.18468235817747},{"$f":"+'Tonnages Collected'!$E21*F$7","v":6.5211419262562602},{"$f":"+'Tonnages Collected'!$E21*G$7","v":7.3821140778442},{"$f":"+'Tonnages Collected'!$E21*H$7","v":154.29137843798185},{"$f":"+'Tonnages Collected'!$E21*I$7","v":6.1650639793173987},{"$f":"+'Tonnages Collected'!$E21*J$7","v":2.8016645293775837},{"$f":"+'Tonnages Collected'!$E21*K$7","v":2.5606193537221023},{"$f":"+'Tonnages Collected'!$E21*L$7","v":2.1777679937899737},650.56108129586823,null,{"$f":"+C19*'CRC Prices'!B19","v":0},{"$f":"+D19*'CRC Prices'!C19","v":-4986.7268593017925},{"$f":"+E19*'CRC Prices'!D19","v":15914.762357414171},{"$f":"+F19*'CRC Prices'!E19","v":4647.8786965198869},{"$f":"+G19*'CRC Prices'!F19","v":491.27969188053152},{"$f":"+H19*'CRC Prices'!G19","v":-8229.9021258819521},{"$f":"+I19*'CRC Prices'!H19","v":924.75959689760975},{"$f":"+J19*'CRC Prices'!I19","v":1905.1318799767569},{"$f":"+K19*'CRC Prices'!J19","v":153.63716122332613},{"$f":"+L19*'CRC Prices'!K19","v":-364.77613895982057},10456.044259768718,null,{"$error":"#DIV/0!"},-17.05,90.33,712.74,66.55,-53.34,150,680,60,-167.5]
[null,null,{"$f":"SUM(C8:C19)","v":0},{"$f":"SUM(D8:D19)","v":3343.5214692443169},2014.1001709262557,74.548098577637191,84.390521508313299,1763.8212784731531,70.477502631420734,32.02794324665372,29.272373789703586,24.895710738422952,7437.0550691358776,null,{"$f":"SUM(O8:O19)","v":0},{"$f":"SUM(P8:P19)","v":-29272.204696909095},117718.3540446291,65575.474769062828,8608.087555769298,-94082.226993757999,9601.6220863065573,22004.496526233856,6213.9659254024746,-3937.0842096333681,{"$f":"SUM(Y8:Y19)","v":102430.48500710368},null,{"$f":"+O20/C20","v":{"$error":"#DIV/0!"}},{"$f":"+P20/D20","v":-8.7549025678979788},{"$f":"+Q20/E20","v":58.447119832422295},{"$f":"+R20/F20","v":879.63980329786773},{"$f":"+S20/G20","v":102.00301410533784},{"$f":"+T20/H20","v":-53.34},{"$f":"+U20/I20","v":136.23669579384188},{"$f":"+V20/J20","v":687.04057443753857},{"$f":"+W20/K20","v":212.28090246607218},-158.14307335910055]
[]
[]
[null,null,"Total Single Stream Tonnage Processed",null,null,null,null,null,null,null,null,null,null,null,"Total Single Stream Commodity Revenue"]
[null,"%",null,"Mixed",null,null,null,null,null,"Natural","Colored","Mixed",null,null,null,"Mixed",null,null,null,null,null,"Natural","Colored","Mixed",null,null,null,"lbs./"]
[null,"Reg.",{"$f":"+C6","v":"ONP 6"},"Paper",{"$f":"+E6","v":"OCC"},"Alum.","Tin","Glass","PET","HDPE","HDPE","Plastics","Total",null,{"$f":"+O6","v":"ONP 6"},"Paper",{"$f":"+Q6","v":"OCC"},"Alum.","Tin","Glass","PET","HDPE","HDPE","Plastics","Total",null,"Customers","Customer"]
[]
[]
[{"$f":"+A8","v":"May, 19"},{"$f":"+Customers!C$21","v":0.35005676762097643},{"$f":"+C8*$B28","v":0},{"$f":"+D8*$B28","v":106.67088849734651},{"$f":"+E8*$B28","v":64.257357618798068},2.3783642438705868,2.6923744898461184,56.272521249214847,2.2484969496747023,1.0218116420934205,0.93389863032040021,0.79426664630950339,{"$f":"SUM(C28:L28)","v":237.26997996747414},null,{"$f":"+O8*$B$40","v":0},-498.55746138823008,3179.3075981121647,2386.3417223103593,345.696338779695,-3023.4355301649507,385.02821093973103,432.28629209760209,216.36096097091868,-112.00713495052725,{"$f":"SUM(O28:X28)","v":3311.0209967067622},null,{"$f":"+Customers!C$20","v":11408},{"$f":"+M28*2000/AA28","v":41.597121312670787},null,{"$f":"+Y28/M28","v":13.954656198650371}]
[{"$f":"+A9","v":"Jun"},{"$f":"+Customers!D$21","v":0.35201438410434571},{"$f":"+C9*$B29","v":0},90.31908087812144,{"$f":"+E9*$B29","v":54.407210453965277},2.0137797249633218,2.2796546717490926,47.64638665262521,1.9038200648055028,0.86517595985653983,0.79073932084078657,0.67251182096047524,{"$f":"SUM(C29:L29)","v":200.89835954788762},null,{"$f":"+O9*$B$40","v":0},56.996666225173612,2658.9898099585739,1887.4811810089116,270.89001027378799,-2545.7302166937184,352.79873839186598,363.98470054207269,182.17575025537519,-94.30991502348715,{"$f":"SUM(O29:X29)","v":3133.2767249385552},null,{"$f":"+Customers!D$20","v":11551},34.784583074692684,null,{"$f":"+Y29/M29","v":15.596328073508655}]
["Jul",{"$f":"+Customers!E$21","v":0.35370449158208228},0,107.26115236259983,{"$f":"+E10*$B30","v":64.612926010637054},2.3915249336458695,2.7072727568004202,56.583905511294354,2.2609390181642541,1.0274658416404499,0.93906636280161437,0.79866172454778117,238.58291452213166,null,{"$f":"+O10*$B$40","v":0},-307.95281399977847,3123.3512207903277,2326.0215889056826,300.54566343142062,-3008.8127576430893,416.97479881920452,430.19554994332259,196.59153326874548,-111.46541516227111,3365.4493683535643,null,{"$f":"+Customers!E$20","v":11639},40.997150016690725,null,14.105994870145553]
["Aug",{"$f":"+Customers!F$21","v":0.35416666666666669},0,96.718083161119552,{"$f":"+E11*$B31","v":58.261898306427888},2.1564536863478989,2.4411655652075241,51.022077968374802,2.0387035116105849,0.92647267466465266,0.84676228597862468,0.72015850464934494,215.13177566438085,null,{"$f":"+O11*$B$40","v":0},-135.77159340016385,3739.5937263234946,1968.8405080864302,281.58718151973903,-2709.5257014630401,263.86363728152713,378.18003088938178,168.60623235735511,-100.37793360162549,3854.9960879930977,null,{"$f":"+Customers!F$20","v":11679},36.840786996212152,null,17.919231485390309]
["Sep",{"$f":"+Customers!G$21","v":0.35367330870328872},0,100.80506275675992,{"$f":"+E12*$B32","v":60.723849389401451},2.2475781371950632,2.544320978636911,53.178098691371794,2.1248522376935104,0.96562228137227357,0.88254360082734196,0.75058997121620885,224.22251804447447,null,{"$f":"+O12*$B$40","v":0},70.350615987423012,3498.0366229995784,2065.9242729473558,261.12207178107406,-2827.9604873238891,230.25328950364806,481.3542413159393,193.57370887541674,-125.34444418880537,3847.3098918977407,null,{"$f":"+Customers!G$20","v":11679},38.397554250273906,null,17.158445661263283]
["Oct",{"$f":"+Customers!H$21","v":0.35275757575757577},0,104.10226583732995,{"$f":"+E13*$B33","v":62.710047877804037},2.3210935079028152,2.6275424234661586,54.917485444665495,2.1943534031338277,0.99720653591006669,0.91141045929462805,0.77514079731222352,231.55654628681918,null,{"$f":"+O13*$B$40","v":0},-943.80206979151319,3249.4928172949781,2077.9946410493862,195.35267698308101,-2928.0407129208506,183.63237377612609,803.99140466123822,236.86495621220504,-129.78032662350384,2745.7057606411472,null,{"$f":"+Customers!H$20","v":11641},39.782930381723077,null,11.8576037027265]
["Nov",{"$f":"+Customers!I$21","v":0.35225345287133514},0,85.364711223243603,{"$f":"+E14*$B34","v":51.422753240063614},1.9033157004851531,2.1546063229449799,45.032788175965727,1.7993877757950776,0.81771753268955838,0.74736404666833556,0.63562180695768311,189.87826582481375,null,{"$f":"+O14*$B$40","v":0},-1094.6166551651097,2655.0408658059887,1436.6700554781758,176.63891091879756,-2404.4535676052201,144.43735467321449,703.94107561380008,231.91478784441165,-106.57323444234832,1742.9995931217099,null,{"$f":"+Customers!I$20","v":11630},32.653184148721195,null,9.1795634721555928]
["Dec",{"$f":"+Customers!J$21","v":0.35209348793557566},0,107.32187618103468,{"$f":"+E15*$B35","v":64.649505363936854},2.392878849044449,2.7088054266973636,56.615939390559298,2.2622190048827182,1.028047521473656,0.93959799698656399,0.79911387137339396,238.71798360598902,null,{"$f":"+O15*$B$40","v":0},-1623.994422638189,3113.5209780665928,2097.5601025723963,270.43395495914774,-3024.2907542281409,170.45715914614317,1039.7984764769799,244.65113955284994,-134.04644278208866,2154.0901911256915,null,{"$f":"+Customers!J$20","v":11630},41.052103801545833,null,9.0235773551148952]
["Jan., '20",{"$f":"+Customers!K$21","v":0.35164901664145237},0,97.802090037264307,{"$f":"+E16*$B36","v":58.914892000235945},2.1806230096811037,2.4685259116081504,51.593928459464209,2.061553102429345,0.93685649035942498,0.85625271538396963,0.7282299711780349,217.54295169760445,null,{"$f":"+O16*$B$40","v":0},-462.88225562030459,3183.5646059725946,1934.9725776847172,284.55409743072039,-2759.5102190529383,289.40295411235826,980.5804773348533,223.23161843985437,-122.31050475808999,3551.6033515437653,null,{"$f":"+Customers!K$20","v":11622},37.436405385924012,null,16.325986771020148]
["Feb",{"$f":"+Customers!L$21","v":0.35096197408559604},0,87.603950414698801,{"$f":"+E17*$B37","v":52.771646040585694},1.9532424096506364,2.2111247466748769,46.214062999474599,1.8465883059725714,0.83916744004003196,0.76696848086137959,0.65229508143712245,194.85904591939573,null,{"$f":"+O17*$B$40","v":0},-1255.9646182474598,3160.4542203579826,1643.8962395748474,222.90360027668439,-2476.6059082926463,315.39059872748851,910.54648354378071,123.28982626168585,-109.77126181257691,2534.1391803897859,null,{"$f":"+Customers!L$20","v":11620},33.538562120377918,null,13.00498608331503]
["Mar",{"$f":"+Customers!M21","v":0.35249157438613382},{"$f":"+C18*$B38","v":0},91.079445508436336,54.865245656063038,2.0307330294170467,2.2988462840294388,48.047504852907302,1.919847657487888,0.87245957249384509,0.79739627754939069,0.67817346185800664,{"$f":"SUM(C38:L38)","v":202.58965230024228},null,{"$f":"+O18*$B$40","v":0},-2367.0127085991812,4335.2136643011945,1657.7383653686811,252.31135526510749,-2563.686495192454,307.27541638324794,562.29959114761982,119.64829877783549,-113.6309578067456,2190.1565296453055,null,{"$f":"+Customers!M$20","v":11714},34.589320863964879]
["Apr",{"$f":"+Customers!N21","v":0.3553882015420477},{"$f":"+C19*$B39","v":0},103.94275015300224,62.613957402529628,2.317536901172657,2.6235162457032821,54.833335496517847,2.1909910000012705,0.99567851841964694,0.91001390695305839,0.77395305068885201,231.20173267498848,null,{"$f":"+O19*$B$40","v":0},-1758.350245903674,5611.6420839171114,1638.8703210627546,173.22820988566497,-2901.9135868279413,326.07586308313728,671.76109784065613,54.173398270865427,-128.62228707060132,3686.8648542579726,null,{"$f":"+Customers!N$20","v":11892},38.883574281027329]
[null,{"$f":"+Customers!O21","v":0.35260608722208342},{"$f":"SUM(C28:C39)","v":0},{"$f":"SUM(D28:D39)","v":1178.9913570109572},710.21128936044852,26.287124133376601,29.757755823364313,621.95803489243553,24.851752031651252,11.293682011013567,10.322014084466094,8.7787167084886306,2622.4517260562016,null,{"$f":"SUM(O28:O39)","v":0},{"$f":"SUM(P28:P39)","v":-10321.557562541007},41508.208213900587,23122.311576049695,3035.2640715049201,-33173.965937408881,3385.5903948376927,7758.9194214072477,2191.0822110875192,-1388.2398582226708,{"$f":"SUM(Y28:Y39)","v":36117.612530615101},null,{"$f":"SUM(AA28:AA39)","v":139705},37.542703926934635]

{"sheet":"Tonnages Collected","index":2,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["WM of Skagit County"]
["Residential Recycling Tons Collected"]
[]
[]
[null,null,null,"Less:",null,null,"WUTC"]
[null,null,"Total","CRC",null,null,"Res'l "]
[null,null,"Tons","Residual","Net","%","Collected"]
["Month",null,"Collected","Rate","Tons","Reg.","Tons"]
[]
["May, 19",null,825.83,{"$f":"+'CRC Composition'!C18","v":0.17924476801603964},{"$f":"+C10-C10*D10","v":677.804293229314},{"$f":"+Customers!C$21","v":0.35005676762097643},{"$f":"+F10*E10","v":237.26997996747414}]
["Jun",null,711.79,{"$f":"+'CRC Composition'!E18","v":0.1982036070941107},{"$f":"+C11-C11*D11","v":570.71065450648291},{"$f":"+Customers!D$21","v":0.35201438410434571},{"$f":"+F11*E11","v":200.89835954788762}]
["Jul",null,834.86,{"$f":"+'CRC Composition'!G18","v":0.1920488354638954},674.52610922461236,{"$f":"+Customers!E$21","v":0.35370449158208228},238.5829145221316]
["Aug",null,750.91,{"$f":"+'CRC Composition'!I18","v":0.19107363599692917},607.43089599354585,{"$f":"+Customers!F$21","v":0.35416666666666669},215.13177566438083]
["Sep",null,768.81,{"$f":"+'CRC Composition'!K18","v":0.17537230495665701},633.98201822627243,{"$f":"+Customers!G$21","v":0.35367330870328872},224.22251804447447]
["Oct",null,784.49,{"$f":"+'CRC Composition'!M18","v":0.16325466060952873},656.41835129843082,{"$f":"+Customers!H$21","v":0.35275757575757577},231.55654628681918]
["Nov",null,657.48,{"$f":"+'CRC Composition'!O18","v":0.1801442417608303},539.03876392708935,{"$f":"+Customers!I$21","v":0.35225345287133514},189.87826582481372]
["Dec",null,808.83,{"$f":"+'CRC Composition'!Q18","v":0.16175708080260365},677.99602033443011,{"$f":"+Customers!I$21","v":0.35225345287133514},238.82643919582696]
["Jan., '20",null,757.49,{"$f":"+'CRC Composition'!S18","v":0.18330723969637311},618.63659900239441,{"$f":"+Customers!K$21","v":0.35164901664145237},217.54295169760448]
["Feb",null,680.71,{"$f":"+'CRC Composition'!U18","v":0.18436026116584706},555.21412662179625,{"$f":"+Customers!L$21","v":0.35096197408559604},194.8590459193957]
["Mar",null,703.05,{"$f":"+'CRC Composition'!W18","v":0.18251026886332347},574.73615547564043,{"$f":"+Customers!M$21","v":0.35249157438613382},202.58965230024228]
["Apr",null,807,{"$f":"+'CRC Composition'!Y18","v":0.19385243953424025},650.56108129586812,{"$f":"+Customers!N$21","v":0.3553882015420477},231.20173267498845]
[null,null,{"$f":"SUM(C10:C21)","v":9091.25},{"$f":"(+G22-I22)/G22","v":1},{"$f":"SUM(E10:E21)","v":7437.0550691358767},null,{"$f":"SUM(G10:G21)","v":2622.5601816460394}]

{"sheet":"CRC Prices","index":3,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[4,1,4,10]]}
["Cascade Recycling Center"]
["Monthly Price per ton of Commodities Sold"]
[]
[]
[null,"Passback Price/ton schedule"]
[null,null,null,null,null,null,null,null,"Natural","Colored","Mixed"]
["Month","ONP 6","Mixed Paper","OCC","Alum.","Tin","Glass","PET","HDPE","HDPE","Plastics 3-7"]
["2019-05-10",0,-4.6399999999999997,49.12,996.1,127.47,-53.34,170,420,230,-140]
["2019-06-10",0,0.63,48.79,935.71,118.63,{"$f":"+G8","v":-53.34},185,420,230,-140]
["2019-07-10",0,-2.88,48.49,975.64,111.36,-53.34,185,420,210,-140]
["2019-08-10",0,-1.41,64.47,917.04,115.86,{"$f":"+G10","v":-53.34},130,410,200,-140]
["2019-09-10",0,0.7,57.78,921.96,102.94,{"$f":"+G11","v":-53.34},108.69,500,220,-167.5]
["2019-10-10",0,-9.07,51.84,895.65,74.38,{"$f":"+G12","v":-53.34},83.72,806.59,260,-167.5]
["2019-11-10",0,-12.81,51.58,754.07,81.900000000000006,{"$f":"+G13","v":-53.34},80.19,860,310,-167.5]
["2019-12-10",0,-15.11,48.09,875.31,99.69,{"$f":"+G14","v":-53.34},75.239999999999995,1009.96,260,-167.5]
["2020-01-10",0,-4.72,53.89,884.94,114.96,-53.34,140,1043.83,260,-167.5]
["2020-02-10",0,-14.27,59.61,837.7,100.34,-53.34,170,1080,160,-167.5]
["2020-03-10",null,-25.98,78.989999999999995,816.06,109.72,-53.34,160,644.29,150,-167.5]
["2020-04-10",{"$f":"+B18","v":0},-17.05,90.33,712.74,66.55,-53.34,150,680,60,-167.5]
["Average",{"$f":"+'Commodity Revenue'!AA20","v":{"$error":"#DIV/0!"}},{"$f":"+'Commodity Revenue'!AB20","v":-8.7549025678979788},{"$f":"+'Commodity Revenue'!AC20","v":58.447119832422295},{"$f":"+'Commodity Revenue'!AD20","v":879.63980329786773},{"$f":"+'Commodity Revenue'!AE20","v":102.00301410533784},{"$f":"+'Commodity Revenue'!AF20","v":-53.34},{"$f":"+'Commodity Revenue'!AG20","v":136.23669579384188},{"$f":"+'Commodity Revenue'!AH20","v":687.04057443753857},{"$f":"+'Commodity Revenue'!AI20","v":212.28090246607218},{"$f":"+'Commodity Revenue'!AJ20","v":-158.14307335910055}]

{"sheet":"CRC Composition","index":4,"n_rows":19,"n_cols":29,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Cascade Recycling Center"]
["Tonnage Delivered and Processed "]
[]
[]
["Stream Composition-CRC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% "]
[null,"2019-05-05",null,"2019-06-05",null,"2019-07-05",null,"2019-08-05",null,"2019-09-05",null,"2019-10-05",null,"2019-11-05",null,"2019-12-05",null,"2020-01-05",null,"2020-02-05",null,"2020-03-11",null,"2020-04-11",null,"Total ",null,null,"Excluding"]
[null,"Tons",null,"Tons",null,"Tons",null,"Tons",null,"Tons",null,"Tons",null,"Tons",null,"Tons",null,"Tons",null,"Tons",null,"Tons",null,"Tons",null,"Tons",null,null,"Residue"]
["Newspaper",null,{"$f":"+B8/B$19","v":0},0,{"$f":"+D8/D$19","v":0},0,{"$f":"+F8/F$19","v":0},0,{"$f":"+H8/H$19","v":0},0,{"$f":"+J8/J$19","v":0},0,{"$f":"+L8/L$19","v":0},0,{"$f":"+N8/N$19","v":0},0,{"$f":"+P8/P$19","v":0},0,{"$f":"+R8/R$19","v":0},0,{"$f":"+T8/T$19","v":0},0,{"$f":"V8/V$19","v":0},0,{"$f":"X8/X$19","v":0},{"$f":"+P8+N8+L8+J8+H8+F8+D8+B8+R8+T8+V8+X8","v":0},{"$f":"+Z8/$Z$19","v":0},null,{"$f":"+Z8/($Z$19-$Z$18)","v":0}]
["Mix Paper",2966.64,{"$f":"+B9/B$19","v":0.36806765226971583},2461.9299999999998,0.34535323963735465,3094.58,{"$f":"+F9/F$19","v":0.37826704510728604},2511.27,{"$f":"+H9/H$19","v":0.3267712846937581},2540,{"$f":"+J9/J$19","v":0.33209994377835594},2379.19,{"$f":"+L9/L$19","v":0.30872069561065113},2565.58,{"$f":"+N9/N$19","v":0.35548873847347601},3250.05,{"$f":"+P9/P$19","v":0.38562209378896944},3279.3,{"$f":"+R9/R$19","v":0.36724834199014944},2739.03,{"$f":"+T9/T$19","v":0.38310898135249},3412.03,{"$f":"V9/V$19","v":0.43619881388715953},3429.94,0.41806970306780766,{"$f":"+P9+N9+L9+J9+H9+F9+D9+B9+R9+T9+V9+X9","v":34629.539999999994},{"$f":"+Z9/$Z$19","v":0.367772895786454},null,{"$f":"+Z9/($Z$19-$Z$18)","v":0.44957599993041408}]
["OCC",2060.39,0.25563024501119103,1496.03,0.20985925964372332,1750.81,{"$f":"+F10/F$19","v":0.21401085938779654},1911.13,{"$f":"+H10/H$19","v":0.24867991307855467},1808.39,{"$f":"+J10/J$19","v":0.23644339264934688},2057.2199999999998,{"$f":"+L10/L$19","v":0.26694227422952505},1852.57,{"$f":"+N10/N$19","v":0.2566935243624473},1969.95,{"$f":"+P10/P$19","v":0.23373678671392142},1864.32,{"$f":"+R10/R$19","v":0.20878493243651855},1539.44,{"$f":"+T10/T$19","v":0.21532195348472899},1359.46,{"$f":"V10/V$19","v":0.17379531819094143},1190.74,0.14513732550160097,20860.45,0.22154230474642561,null,0.27081958546802554]
["Aluminum",64.19,7.9639803276410539E-3,28.92,4.0568235856877728E-3,58.58,{"$f":"+F11/F$19","v":7.1605463430852697E-3},67.989999999999995,{"$f":"+H11/H$19","v":8.8469896292826394E-3},57.96,{"$f":"+J11/J$19","v":7.57815462259587E-3},60.14,{"$f":"+L11/L$19","v":7.8036905980710071E-3},85.63,{"$f":"+N11/N$19","v":1.186495867425056E-2},52.99,{"$f":"+P11/P$19","v":6.2873231949900736E-3},60.98,{"$f":"+R11/R$19","v":6.829141552940966E-3},55.48,{"$f":"+T11/T$19","v":7.7600049234349908E-3},74.78,{"$f":"V11/V$19","v":9.5599825624281699E-3},104.47,1.2733675189505899E-2,772.11,8.199968309301222E-3,null,1.002387341288022E-2]
["Tin Cans",79.86,9.9081394137001816E-3,48.26,6.7697892892562891E-3,56.24,{"$f":"+F12/F$19","v":6.8745156424567366E-3},52.05,{"$f":"+H12/H$19","v":6.7728461568489686E-3},62.71,{"$f":"+J12/J$19","v":8.1992076670632675E-3},82.36,{"$f":"+L12/L$19","v":1.0686929791438779E-2},51.4,{"$f":"+N12/N$19","v":7.1220235414747026E-3},86.22,{"$f":"+P12/P$19","v":1.023010012968568E-2},94.07,{"$f":"+R12/R$19","v":1.0534885960727396E-2},74.180000000000007,{"$f":"+T12/T$19","v":1.0375579762444263E-2},79.44,{"$f":"V12/V$19","v":1.0155723652838912E-2},107.26,1.3073743666376977E-2,874.05000000000018,9.2825922481832041E-3,null,1.1347303566237917E-2]
["Glass",1267.58,0.15726720959201196,1568.3,0.21999711028472108,1465.99,{"$f":"+F13/F$19","v":0.17919578923693369},1514.28,{"$f":"+H13/H$19","v":0.19704102744271385},1700.54,{"$f":"+J13/J$19","v":0.2223422198397029},1750.58,{"$f":"+L13/L$19","v":0.22715305432609151},1230.2,{"$f":"+N13/N$19","v":0.17045745837980894},1632.98,{"$f":"+P13/P$19","v":0.19375491660605568},1876.73,{"$f":"+R13/R$19","v":0.21017472657676123},1298.8499999999999,{"$f":"+T13/T$19","v":0.18167055506134711},1332.25,{"$f":"V13/V$19","v":0.17031675272525981},1629.98,0.19867556126534724,18268.259999999998,0.19401270941455898,null,0.23716662873629818]
["PET",87.94,1.091061582820929E-2,63.07,8.8472981863529677E-3,96.62,{"$f":"+F14/F$19","v":1.1810378758431186E-2},84.69,{"$f":"+H14/H$19","v":1.1020025764141001E-2},59.84,{"$f":"+J14/J$19","v":7.8239608801955983E-3},40.46,{"$f":"+L14/L$19","v":5.250038603225024E-3},58,{"$f":"+N14/N$19","v":8.0365246187846847E-3},22.42,{"$f":"+P14/P$19","v":2.6601582568725698E-3},33.090000000000003,{"$f":"+R14/R$19","v":3.7057444077864318E-3},56.03,{"$f":"+T14/T$19","v":7.8369335951705577E-3},54.79,{"$f":"V14/V$19","v":7.0044322625760821E-3},73,8.8978490364117029E-3,729.94999999999993,7.7522203667539941E-3,null,9.4765336515935765E-3]
["HDPE Natl",30.31,3.7605272430409776E-3,26.77,3.7552270881349124E-3,34.130000000000003,{"$f":"+F15/F$19","v":4.1718922275435352E-3},29.12,{"$f":"+H15/H$19","v":3.7891504339566183E-3},23.81,{"$f":"+J15/J$19","v":3.1131101028986827E-3},28.46,{"$f":"+L15/L$19","v":3.6929337283189371E-3},19.02,{"$f":"+N15/N$19","v":2.6354258318842189E-3},22.51,{"$f":"+P15/P$19","v":2.6708368582605505E-3},43.25,{"$f":"+R15/R$19","v":4.8435613670825975E-3},23.68,{"$f":"+T15/T$19","v":3.3121289939967665E-3},27.46,{"$f":"V15/V$19","v":3.5105258246092208E-3},23.2,2.8278095567774177E-3,331.71999999999997,3.5229351874232961E-3,null,4.3065357119071454E-3]
["HDPE Col",25.73,3.1922918496682402E-3,17.7,2.4829107007840099E-3,29.45,{"$f":"+F16/F$19","v":3.5998308262864664E-3},23.67,{"$f":"+H16/H$19","v":3.0799859468321825E-3},25.59,{"$f":"+J16/J$19","v":3.345841559562255E-3},28.86,{"$f":"+L16/L$19","v":3.7448372241491398E-3},34.090000000000003,{"$f":"+N16/N$19","v":4.7235366250753434E-3},8.39,{"$f":"+P16/P$19","v":9.9548295161288399E-4},22.53,{"$f":"+R16/R$19","v":2.5231315052108884E-3},27.54,{"$f":"+T16/T$19","v":3.8520283992681988E-3},28.5,{"$f":"V16/V$19","v":3.643480917748099E-3},31.13,3.7943841164862508E-3,303.17999999999995,3.219834469199912E-3,null,3.9360168127818892E-3]
["#3 - 7",32.68,4.0545704487818923E-3,4.8099999999999996,6.7473448987407281E-4,23.4,{"$f":"+F17/F$19","v":2.8603070062853415E-3},22.48,{"$f":"+H17/H$19","v":2.9251408569829938E-3},28.16,{"$f":"+J17/J$19","v":3.6818639436214579E-3},21.2,{"$f":"+L17/L$19","v":2.7508852790007537E-3},20.45,{"$f":"+N17/N$19","v":2.8335677319680482E-3},19.260000000000002,{"$f":"+P17/P$19","v":2.2852206970279077E-3},18.29,{"$f":"+R17/R$19","v":2.048294506449496E-3},17.170000000000002,{"$f":"+T17/T$19","v":2.401573261272149E-3},25.85,{"$f":"V17/V$19","v":3.3047011131153809E-3},24.1,2.9375090654455076E-3,257.84999999999997,2.7384204693027157E-3,null,3.3475227098615024E-3]
["Residue",{"$f":"1444.02+0.7","v":1444.72},0.17924476801603964,{"$f":"1412.74+0.2","v":1412.94},0.1982036070941107,{"$f":"0.25+1570.89","v":1571.14},{"$f":"+F18/F$19","v":0.1920488354638954},{"$f":"1468.22+0.2","v":1468.42},{"$f":"+H18/H$19","v":0.19107363599692917},{"$f":"0.18+1341.12","v":1341.3},{"$f":"+J18/J$19","v":0.17537230495665701},{"$f":"1257.93+0.21","v":1258.1400000000001},{"$f":"+L18/L$19","v":0.16325466060952873},{"$f":"1299.91+0.2","v":1300.1100000000001},{"$f":"+N18/N$19","v":0.1801442417608303},{"$f":"1363.01+0.29","v":1363.3},{"$f":"+P18/P$19","v":0.16175708080260365},{"$f":"0.25+1636.57","v":1636.82},{"$f":"+R18/R$19","v":0.18330723969637311},{"$f":"0.17+1317.91","v":1318.0800000000002},{"$f":"+T18/T$19","v":0.18436026116584706},{"$f":"0.19+1427.44","v":1427.63},{"$f":"V18/V$19","v":0.18251026886332347},1590.41,0.19385243953424025,17133.009999999998,0.18195611900239722]
[null,{"$f":"SUM(B8:B18)","v":8060.0399999999991},1.0000000000000002,7128.7300000000014,{"$f":"SUM(E8:E18)","v":0.99999999999999978},8180.9399999999987,{"$f":"SUM(G8:G18)","v":1.0000000000000002},7685.0999999999985,{"$f":"SUM(I8:I18)","v":1.0000000000000004},7648.3000000000011,{"$f":"SUM(K8:K18)","v":1},7706.61,{"$f":"SUM(M8:M18)","v":1},7217.0499999999993,{"$f":"SUM(O8:O18)","v":1},8428.0700000000015,{"$f":"SUM(Q8:Q18)","v":0.99999999999999989},{"$f":"SUM(R8:R18)","v":8929.3799999999992},{"$f":"SUM(S8:S18)","v":1.0000000000000002},{"$f":"SUM(T8:T18)","v":7149.48},{"$f":"SUM(U8:U18)","v":1.0000000000000002},{"$f":"SUM(V8:V18)","v":7822.19},{"$f":"SUM(W8:W18)","v":1.0000000000000002},{"$f":"SUM(X8:X18)","v":8204.2300000000014},{"$f":"SUM(Y8:Y18)","v":0.99999999999999978},{"$f":"SUM(Z8:Z18)","v":94160.119999999981},1.0000000000000002,null,{"$f":"SUM(AC8:AC18)","v":1.0000000000000002}]

{"sheet":"Customers","index":5,"n_rows":23,"n_cols":16,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Waste Management of Skagit County"]
["Recycling Customers by Jurisdiction - per Enspire"]
[]
[]
[null,null,"2019-05-01","2019-06-01","2019-07-01","2019-08-01","2019-09-01","2019-10-01","2019-11-01","2019-12-01","2020-01-01","2020-02-01","2020-03-01","2020-04-01","Total","%"]
["Contract Cities:"]
[null,"Anacortes",6696,6702,6703,6710,6712,6715,6718,6718,6722,6721,6722,6727,{"$f":"SUM(C7:N7)","v":80566},{"$f":"+O7/$O$23","v":0.20334320191213179}]
[null,"Burlington",2195,2199,2201,2205,2213,2211,2216,2215,2228,2280,2283,2276,26722,6.7444542877839103E-2]
[null,"Darrington",490,487,487,487,486,484,484,489,493,494,493,491,5865,1.4802868197684544E-2]
[null,"Mount Vernon",9441,9504,9499,9506,9536,9545,9560,9568,9572,9574,9581,9597,114483,0.28894744413904855]
[null,"Stanwood",1815,1816,1820,1838,1844,1856,1867,1869,1875,1884,1895,1913,22292,5.6263518817183944E-2]
[null,"Other",{"$f":"543+1","v":544},{"$f":"554+1","v":555},{"$f":"556+1","v":557},{"$f":"550+1","v":551},{"$f":"552","v":552},548,541,542,538,536,544,566,6574,1.6592336834028679E-2]
[null,"Total",{"$f":"SUM(C7:C12)","v":21181},21263,21267,21297,21343,21359,21386,21401,21428,21489,21518,21570,256502,0.64739391277791658]
[null,null,{"$f":"+C13/C23","v":0.64994323237902363},0.64798561589565429,0.64629550841791772,0.64583333333333337,0.64632669129671128,0.64724242424242429,0.64774654712866486,0.64790651206442429,0.64835098335854768,0.64903802591440396,0.64750842561386612,0.64461179845795236,0.64739391277791658]
[]
["WUTC:"]
[null,"Skagit County",{"$f":"169+5630","v":5799},{"$f":"5700+168","v":5868},{"$f":"173+5752","v":5925},{"$f":"5761+173","v":5934},{"$f":"5774+1+173","v":5948},{"$f":"5737+1+175","v":5913},{"$f":"5746+2+175","v":5923},{"$f":"2+173+5742","v":5917},{"$f":"2+172+5745","v":5919},{"$f":"5742+2+173","v":5917},{"$f":"5795+2+173","v":5970},{"$f":"2+172+5860","v":6034},{"$f":"SUM(C17:N17)","v":71067},{"$f":"+O17/$O$23","v":0.17936836047823487}]
[null,"Island County",2597,2645,2666,2683,2675,2658,2654,2662,2654,2649,2680,2751,{"$f":"SUM(C18:N18)","v":31974},{"$f":"+O18/$O$23","v":8.070024002604699E-2}]
[null,"Snohomish County",3012,3038,3048,3062,3056,3070,3053,3051,3049,3054,3064,3107,{"$f":"SUM(C19:N19)","v":36664},{"$f":"+O19/$O$23","v":9.2537486717801556E-2}]
[null,"Total",{"$f":"SUM(C17:C19)","v":11408},11551,11639,11679,11679,11641,11630,11630,11622,11620,{"$f":"SUM(M17:M19)","v":11714},{"$f":"SUM(N17:N19)","v":11892},{"$f":"SUM(O17:O19)","v":139705},{"$f":"+O20/$O$23","v":0.35260608722208342}]
[null,null,{"$f":"+C20/C$23","v":0.35005676762097643},{"$f":"+D20/D$23","v":0.35201438410434571},0.35370449158208228,0.35416666666666669,0.35367330870328872,0.35275757575757577,0.35225345287133514,0.35209348793557566,0.35164901664145237,0.35096197408559604,0.35249157438613382,0.3553882015420477,0.35260608722208342]
[]
[null,"Grand Total",{"$f":"+C20+C13","v":32589},32814,32906,32976,33022,33000,33016,33031,33050,33109,33232,33462,396207,{"$f":"+O23/$O$23","v":1}]