{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Rebate Analysis","Commodity Revenue","CRC Prices","CRC Composition","Customers","Tonnages Collected"],"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":29,"n_cols":24,"rows_kept":29,"cut":false,"hidden":false,"merged":[[4,12,4,17],[4,18,4,23],[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"]
["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,"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"]
["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!C21+Customers!D21","v":21720},{"$f":"+J11","v":2.04},{"$f":"C10*D10","v":44308.800000000003},null,"May - June projected value without adjustment factor",null,20086,{"$f":"+P11","v":1.71},{"$f":"I10*J10","v":34347.06},null,"May - June projected value without adjustment factor",null,18118,{"$f":"+V11","v":2.3199999999999998},{"$f":"O10*P10","v":42033.759999999995},null,"May - June projected value without adjustment factor",null,17149,2.37,{"$f":"U10*V10","v":40643.130000000005}]
["July - April projected value without adjustment factor",null,{"$f":"SUM(Customers!E21:N21)","v":111104},{"$f":"+L25","v":1.25},{"$f":"C11*D11","v":138880},null,"July - April projected value without adjustment factor",null,104400,{"$f":"+R25","v":2.04},{"$f":"I11*J11","v":212976},null,"July - April projected value without adjustment factor",null,93257,{"$f":"+X25","v":1.71},{"$f":"O11*P11","v":159469.47},null,"July - April projected value without adjustment factor",null,87893,2.3199999999999998,{"$f":"U11*V11","v":203911.75999999998}]
["Total",null,{"$f":"SUM(C10:C11)","v":132824},null,{"$f":"SUM(E10:E11)","v":183188.8},null,"Total",null,{"$f":"SUM(I10:I11)","v":124486},null,{"$f":"SUM(K10:K11)","v":247323.06},null,"Total",null,{"$f":"SUM(O10:O11)","v":111375},null,{"$f":"SUM(Q10:Q11)","v":201503.22999999998},null,"Total",null,{"$f":"SUM(U10:U11)","v":105042},null,{"$f":"SUM(W10:W11)","v":244554.88999999998}]
[]
["Actual Commodity Revenue ",null,null,null,{"$f":"+'Commodity Revenue'!Y40","v":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":-83589.201567832075},null,"Owe Customer (company)",null,null,null,{"$f":"K14-K12","v":-42131.06},null,"Owe Customer (company)",null,null,null,{"$f":"Q14-Q12","v":29965.770000000019},null,"Owe Customer (company)",null,null,null,{"$f":"W14-W12","v":-60927.889999999985}]
[]
["Total Current Customers",null,null,null,{"$f":"+C12","v":132824},null,"Total Current Customers",null,null,null,{"$f":"+I12","v":124486},null,"Total Current Customers",null,null,null,{"$f":"+O12","v":111375},null,"Total Customers",null,null,null,{"$f":"+U12","v":105042}]
[]
["Adjust for Under/(Over) payment in 2018-2019",null,null,null,null,{"$f":"+E16/E18","v":-0.6293230257169794},"Adjust for Under/(Over) payment in 2017-2018",null,null,null,null,{"$f":"+K16/K18","v":-0.33844014587985793},"Adjust for Under/(Over) payment in 2016-2017",null,null,null,null,{"$f":"+Q16/Q18","v":0.26905292929292945},"Adjust for Under/(Over) payment in 2015-2016",null,null,null,null,-0.65]
[]
[]
["Projected Rev. May 2019-Apr 2020 (based on most recent 6 mo. avg.)",null,null,null,{"$f":"SUM('Commodity Revenue'!Y34:Y39)","v":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":"+Q14","v":231469},null,"Projected Revenue May 2016-Apr 2017",null,null,null,{"$f":"+W14","v":183627}]
["Total Current Customers (annualized)",null,null,null,{"$f":"SUM(Customers!I21:N21)","v":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.6},"Projected Value",null,null,null,null,{"$f":"ROUND(+K23/K24,2)","v":1.25},"Projected Value",null,null,null,null,2.04,"Projected Value",null,null,null,null,{"$f":"ROUND(+W23/W24,2)","v":1.71}]
[]
["Residential Commodity Adjustment - as calculated",null,null,null,null,{"$f":"SUM(F20:F25)","v":-2.9323025716979423E-2},"Residential Commodity Adjustment",null,null,null,null,{"$f":"SUM(L20:L25)","v":0.91155985412014207},"Residential Commodity Adjustment",null,null,null,null,{"$f":"SUM(R20:R25)","v":2.3090529292929296},"Residential Commodity Adjustment",null,null,null,null,{"$f":"SUM(X20:X25)","v":1.06}]
[]
["Residential Commodity Adjustment - as proposed",null,null,null,null,0]

{"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.27824253283737055},{"$f":"+'CRC Composition'!$AC9","v":0.1557825777965948},{"$f":"+'CRC Composition'!$AC10","v":0.2876596506083608},{"$f":"+'CRC Composition'!$AC11","v":7.3672392415399046E-3},{"$f":"+'CRC Composition'!AC12","v":1.3642503603794313E-2},{"$f":"+'CRC Composition'!AC13","v":0.23549737401840704},{"$f":"+'CRC Composition'!AC14","v":9.9975050654731307E-3},{"$f":"+'CRC Composition'!$AC15","v":3.8991542423967491E-3},{"$f":"+'CRC Composition'!$AC16","v":3.6024082418524002E-3},{"$f":"+'CRC Composition'!$AC17","v":4.309054344210239E-3},{"$f":"+M20/$M$20","v":1}]
["May, 18",null,{"$f":"+'Tonnages Collected'!$E10*C$7","v":213.14765005358572},{"$f":"+'Tonnages Collected'!$E10*D$7","v":119.33722007929617},{"$f":"+'Tonnages Collected'!$E10*E$7","v":220.36163169289765},{"$f":"+'Tonnages Collected'!$E10*F$7","v":5.6436725029189532},{"$f":"+'Tonnages Collected'!$E10*G$7","v":10.450837815280909},{"$f":"+'Tonnages Collected'!$E10*H$7","v":180.40272762738473},{"$f":"+'Tonnages Collected'!$E10*I$7","v":7.6585872381701234},{"$f":"+'Tonnages Collected'!$E10*J$7","v":2.9869465156468435},{"$f":"+'Tonnages Collected'!$E10*K$7","v":2.7596242869644398},{"$f":"+'Tonnages Collected'!$E10*L$7","v":3.3009504264340461},{"$f":"SUM(C8:L8)","v":766.04984823857967},null,{"$f":"+C8*'CRC Prices'!B8","v":17985.39871152156},{"$f":"+D8*'CRC Prices'!C8","v":-1028.686837083533},{"$f":"+E8*'CRC Prices'!D8","v":20672.12466911073},{"$f":"+F8*'CRC Prices'!E8","v":8817.6739185605729},{"$f":"+G8*'CRC Prices'!F8","v":1900.9028902214445},{"$f":"+H8*'CRC Prices'!G8","v":-9622.681491644702},{"$f":"+I8*'CRC Prices'!H8","v":1386.9701488326093},{"$f":"+J8*'CRC Prices'!I8","v":2335.7921752358316},{"$f":"+K8*'CRC Prices'!J8","v":1095.5708419248826},{"$f":"+L8*'CRC Prices'!K8","v":-132.03801705736186},{"$f":"SUM(O8:X8)","v":43411.027009622034},null,{"$f":"+O8/C8","v":84.379999999999981},{"$f":"+P8/D8","v":-8.6199999999999992},93.81,1562.4,181.89,-53.34,181.1,782,397,{"$f":"+X8/L8","v":-40}]
["Jun",null,{"$f":"+'Tonnages Collected'!$E11*C$7","v":203.29338277678724},{"$f":"+'Tonnages Collected'!$E11*D$7","v":113.82000765665927},{"$f":"+'Tonnages Collected'!$E11*E$7","v":210.17384676678037},{"$f":"+'Tonnages Collected'!$E11*F$7","v":5.3827535706553311},{"$f":"+'Tonnages Collected'!$E11*G$7","v":9.9676734497701478},{"$f":"+'Tonnages Collected'!$E11*H$7","v":172.06232746319432},{"$f":"+'Tonnages Collected'!$E11*I$7","v":7.3045145304080012},{"$f":"+'Tonnages Collected'!$E11*J$7","v":2.8488536523228234},{"$f":"+'Tonnages Collected'!$E11*K$7","v":2.632041011706864},{"$f":"+'Tonnages Collected'!$E11*L$7","v":3.1483404973010467},730.6337413755856,null,{"$f":"+C9*'CRC Prices'!B9","v":-2683.4726526535915},{"$f":"+D9*'CRC Prices'!C9","v":-764.87045145275033},{"$f":"+E9*'CRC Prices'!D9","v":20624.359583224155},{"$f":"+F9*'CRC Prices'!E9","v":7793.1506195947877},{"$f":"+G9*'CRC Prices'!F9","v":1777.8342365010037},{"$f":"+H9*'CRC Prices'!G9","v":-9177.8045468867858},{"$f":"+I9*'CRC Prices'!H9","v":1687.4889468148565},{"$f":"+J9*'CRC Prices'!I9","v":1994.1975566259764},{"$f":"+K9*'CRC Prices'!J9","v":789.61230351205916},{"$f":"+L9*'CRC Prices'!K9","v":-125.93361989204186},{"$f":"SUM(O9:X9)","v":21914.561975387667},null,{"$f":"+O9/C9","v":-13.2},-6.7200000000000006,98.129999999999981,1447.8,178.36,-53.34,231.02,700,300,{"$f":"+X9/L9","v":-40}]
["Jul",null,{"$f":"+'Tonnages Collected'!$E12*C$7","v":209.76857989968471},{"$f":"+'Tonnages Collected'!$E12*D$7","v":117.44534447795556},{"$f":"+'Tonnages Collected'!$E12*E$7","v":216.86819691878119},{"$f":"+'Tonnages Collected'!$E12*F$7","v":5.554202291503481},{"$f":"+'Tonnages Collected'!$E12*G$7","v":10.285158699719478},{"$f":"+'Tonnages Collected'!$E12*H$7","v":177.5427689440271},{"$f":"+'Tonnages Collected'!$E12*I$7","v":7.537174201005314},{"$f":"+'Tonnages Collected'!$E12*J$7","v":2.9395938855813308},{"$f":"+'Tonnages Collected'!$E12*K$7","v":2.7158754393383102},{"$f":"+'Tonnages Collected'!$E12*L$7","v":3.2486198327696734},753.90551459036612,null,{"$f":"+C10*'CRC Prices'!B10","v":0},{"$f":"+D10*'CRC Prices'!C10","v":411.05870567284444},{"$f":"+E10*'CRC Prices'!D10","v":20244.646182368222},{"$f":"+F10*'CRC Prices'!E10","v":7391.3102414411724},{"$f":"+G10*'CRC Prices'!F10","v":1794.0402319920686},{"$f":"+H10*'CRC Prices'!G10","v":-9470.1312954744062},{"$f":"+I10*'CRC Prices'!H10","v":1601.6495177136292},{"$f":"+J10*'CRC Prices'!I10","v":2234.0913530418115},{"$f":"+K10*'CRC Prices'!J10","v":896.23889498164237},{"$f":"+L10*'CRC Prices'!K10","v":-129.94479331078693},24972.959038426194,null,0,3.5,93.35,1330.76,174.43,-53.34,212.5,760,330,-40]
["Aug",null,{"$f":"+'Tonnages Collected'!$E13*C$7","v":202.34342891901753},{"$f":"+'Tonnages Collected'!$E13*D$7","v":113.28814698373446},{"$f":"+'Tonnages Collected'!$E13*E$7","v":209.1917417232649},{"$f":"+'Tonnages Collected'!$E13*F$7","v":5.3576009195949563},{"$f":"+'Tonnages Collected'!$E13*G$7","v":9.9210962827356717},{"$f":"+'Tonnages Collected'!$E13*H$7","v":171.25831077795885},{"$f":"+'Tonnages Collected'!$E13*I$7","v":7.2703818318296367},{"$f":"+'Tonnages Collected'!$E13*J$7","v":2.8355414653727107},{"$f":"+'Tonnages Collected'!$E13*K$7","v":2.6197419517043832},{"$f":"+'Tonnages Collected'!$E13*L$7","v":3.1336288615353731},727.2196197167483,null,{"$f":"+C11*'CRC Prices'!B11","v":2023.4342891901751},{"$f":"+D11*'CRC Prices'!C11","v":993.53704904735116},{"$f":"+E11*'CRC Prices'!D11","v":19917.145729472049},{"$f":"+F11*'CRC Prices'!E11","v":6963.1131871699772},{"$f":"+G11*'CRC Prices'!F11","v":1576.5614102895256},{"$f":"+H11*'CRC Prices'!G11","v":-9134.918296896325},{"$f":"+I11*'CRC Prices'!H11","v":1599.48400300252},{"$f":"+J11*'CRC Prices'!I11","v":2098.3006843758058},{"$f":"+K11*'CRC Prices'!J11","v":785.92258551131499},{"$f":"+L11*'CRC Prices'!K11","v":-125.34515446141492},26697.235486700978,null,10,8.77,95.21,1299.67,158.91,-53.339999999999996,220,740,300,-40]
["Sep",null,{"$f":"+'Tonnages Collected'!$E14*C$7","v":183.30889433174852},{"$f":"+'Tonnages Collected'!$E14*D$7","v":102.631081599355},{"$f":"+'Tonnages Collected'!$E14*E$7","v":189.51298336439493},{"$f":"+'Tonnages Collected'!$E14*F$7","v":4.8536090649860828},{"$f":"+'Tonnages Collected'!$E14*G$7","v":8.9878144294715483},{"$f":"+'Tonnages Collected'!$E14*H$7","v":155.14796680842488},{"$f":"+'Tonnages Collected'!$E14*I$7","v":6.5864538427670443},{"$f":"+'Tonnages Collected'!$E14*J$7","v":2.5688008433292167},{"$f":"+'Tonnages Collected'!$E14*K$7","v":2.3733016840078522},{"$f":"+'Tonnages Collected'!$E14*L$7","v":2.8388470281582605},658.80975299664328,null,{"$f":"+C12*'CRC Prices'!B12","v":6831.922491744268},{"$f":"+D12*'CRC Prices'!C12","v":1245.9413306161698},{"$f":"+E12*'CRC Prices'!D12","v":18297.478543832331},{"$f":"+F12*'CRC Prices'!E12","v":5978.1417492527089},{"$f":"+G12*'CRC Prices'!F12","v":1312.7601755686144},{"$f":"+H12*'CRC Prices'!G12","v":-8275.5925495613847},{"$f":"+I12*'CRC Prices'!H12","v":1114.4279901961838},{"$f":"+J12*'CRC Prices'!I12","v":1798.1605903304517},{"$f":"+K12*'CRC Prices'!J12","v":664.52447152219861},{"$f":"+L12*'CRC Prices'!K12","v":-397.43858394215647},28570.326209559385,null,37.270000000000003,12.14,96.55,1231.69,146.06,-53.340000000000011,169.2,700,280,-140]
["Oct",null,{"$f":"+'Tonnages Collected'!$E15*C$7","v":199.09287029524666},{"$f":"+'Tonnages Collected'!$E15*D$7","v":111.46822248647598},{"$f":"+'Tonnages Collected'!$E15*E$7","v":205.83116795166811},{"$f":"+'Tonnages Collected'!$E15*F$7","v":5.2715334057401719},{"$f":"+'Tonnages Collected'!$E15*G$7","v":9.7617182132258673},{"$f":"+'Tonnages Collected'!$E15*H$7","v":168.5071209717679},{"$f":"+'Tonnages Collected'!$E15*I$7","v":7.1535863298070872},{"$f":"+'Tonnages Collected'!$E15*J$7","v":2.789989732793265},{"$f":"+'Tonnages Collected'!$E15*K$7","v":2.5776569438607377},{"$f":"+'Tonnages Collected'!$E15*L$7","v":3.0832884854036742},715.53715481598954,null,{"$f":"+C13*'CRC Prices'!B13","v":3826.5649670746407},{"$f":"+D13*'CRC Prices'!C13","v":1211.6595784279939},{"$f":"+E13*'CRC Prices'!D13","v":20694.265625860713},{"$f":"+F13*'CRC Prices'!E13","v":5493.3068161196607},{"$f":"+G13*'CRC Prices'!F13","v":1539.325345043587},{"$f":"+H13*'CRC Prices'!G13","v":-8988.1698326341011},{"$f":"+I13*'CRC Prices'!H13","v":1245.0817007029236},{"$f":"+J13*'CRC Prices'!I13","v":2092.4922995949487},{"$f":"+K13*'CRC Prices'!J13","v":799.07365259682865},{"$f":"+L13*'CRC Prices'!K13","v":-404.31161909098375},27509.288533696217,null,19.22,10.87,100.54,1042.07,157.69,-53.34,174.05,750,310,-131.13]
["Nov",null,{"$f":"+'Tonnages Collected'!$E16*C$7","v":208.97859844151492},{"$f":"+'Tonnages Collected'!$E16*D$7","v":117.00304923750383},{"$f":"+'Tonnages Collected'!$E16*E$7","v":216.05147854029724},{"$f":"+'Tonnages Collected'!$E16*F$7","v":5.5332853513816094},{"$f":"+'Tonnages Collected'!$E16*G$7","v":10.246425135946497},{"$f":"+'Tonnages Collected'!$E16*H$7","v":176.8741488124279},{"$f":"+'Tonnages Collected'!$E16*I$7","v":7.5087894549740568},{"$f":"+'Tonnages Collected'!$E16*J$7","v":2.9285234732952339},{"$f":"+'Tonnages Collected'!$E16*K$7","v":2.7056475432406106},{"$f":"+'Tonnages Collected'!$E16*L$7","v":3.2363856390989247},751.06633162968092,null,{"$f":"+C14*'CRC Prices'!B14","v":0},{"$f":"+D14*'CRC Prices'!C14","v":1645.062872279304},{"$f":"+E14*'CRC Prices'!D14","v":22875.530547846669},{"$f":"+F14*'CRC Prices'!E14","v":5345.4856465557168},{"$f":"+G14*'CRC Prices'!F14","v":1647.2153048547589},{"$f":"+H14*'CRC Prices'!G14","v":-9434.4670976549041},{"$f":"+I14*'CRC Prices'!H14","v":1201.4063127958491},{"$f":"+J14*'CRC Prices'!I14","v":2225.6778397043777},{"$f":"+K14*'CRC Prices'!J14","v":974.03311556661981},{"$f":"+L14*'CRC Prices'!K14","v":-453.09398947384949},26026.850552474541,null,0,14.06,105.87999999999998,966.05999999999983,160.76,-53.339999999999996,160,760,360,-140]
["Dec",null,{"$f":"+'Tonnages Collected'!$E17*C$7","v":188.98649165413545},{"$f":"+'Tonnages Collected'!$E17*D$7","v":105.80985781862354},{"$f":"+'Tonnages Collected'!$E17*E$7","v":195.38273895279514},{"$f":"+'Tonnages Collected'!$E17*F$7","v":5.0039391290658219},{"$f":"+'Tonnages Collected'!$E17*G$7","v":9.2661925808695198},{"$f":"+'Tonnages Collected'!$E17*H$7","v":159.95334018725893},{"$f":"+'Tonnages Collected'!$E17*I$7","v":6.7904550334241769},{"$f":"+'Tonnages Collected'!$E17*J$7","v":2.6483639045925522},{"$f":"+'Tonnages Collected'!$E17*K$7","v":2.4468095808039192},{"$f":"+'Tonnages Collected'!$E17*L$7","v":2.9267741870912456},679.21496302866035,null,{"$f":"+C15*'CRC Prices'!B15","v":0},{"$f":"+D15*'CRC Prices'!C15","v":852.82745401810575},{"$f":"+E15*'CRC Prices'!D15","v":20599.202167793192},{"$f":"+F15*'CRC Prices'!E15","v":4495.3387559875719},{"$f":"+G15*'CRC Prices'!F15","v":1445.6187045414538},{"$f":"+H15*'CRC Prices'!G15","v":-8531.9111655883917},{"$f":"+I15*'CRC Prices'!H15","v":1086.4728053478684},{"$f":"+J15*'CRC Prices'!I15","v":1880.338372260712},{"$f":"+K15*'CRC Prices'!J15","v":856.38335328137168},{"$f":"+L15*'CRC Prices'!K15","v":-409.74838619277438},22274.522061449112,null,0,8.06,105.43,898.36,156.01,-53.34,160.00000000000003,710,350,-140]
["Jan., '19",null,{"$f":"+'Tonnages Collected'!$E18*C$7","v":190.62304455882935},{"$f":"+'Tonnages Collected'!$E18*D$7","v":106.72613193241166},{"$f":"+'Tonnages Collected'!$E18*E$7","v":197.07468098612009},{"$f":"+'Tonnages Collected'!$E18*F$7","v":5.047271385487468},{"$f":"+'Tonnages Collected'!$E18*G$7","v":9.3464343709093498},{"$f":"+'Tonnages Collected'!$E18*H$7","v":161.33847677140179},{"$f":"+'Tonnages Collected'!$E18*I$7","v":6.8492578547892169},{"$f":"+'Tonnages Collected'!$E18*J$7","v":2.671297753476733},{"$f":"+'Tonnages Collected'!$E18*K$7","v":2.4679980440197236},{"$f":"+'Tonnages Collected'!$E18*L$7","v":2.9521189657330611},685.09671262317852,null,{"$f":"+C16*'CRC Prices'!B16","v":0},{"$f":"+D16*'CRC Prices'!C16","v":860.21262337523808},{"$f":"+E16*'CRC Prices'!D16","v":20444.527405500095},{"$f":"+F16*'CRC Prices'!E16","v":4398.6465397384736},{"$f":"+G16*'CRC Prices'!F16","v":1205.3161764724698},{"$f":"+H16*'CRC Prices'!G16","v":-8605.7943509865727},{"$f":"+I16*'CRC Prices'!H16","v":1095.8812567662746},{"$f":"+J16*'CRC Prices'!I16","v":1896.6214049684804},{"$f":"+K16*'CRC Prices'!J16","v":863.79931540690325},{"$f":"+L16*'CRC Prices'!K16","v":-413.29665520262853},21745.913716038736,null,0,8.06,103.74,871.49,128.96,-53.340000000000011,160,710,350,-140]
["Feb",null,{"$f":"+'Tonnages Collected'!$E19*C$7","v":153.08095121246748},{"$f":"+'Tonnages Collected'!$E19*D$7","v":85.707044671604677},{"$f":"+'Tonnages Collected'!$E19*E$7","v":158.26197559203496},{"$f":"+'Tonnages Collected'!$E19*F$7","v":4.053240816219577},{"$f":"+'Tonnages Collected'!$E19*G$7","v":7.5057088048037519},{"$f":"+'Tonnages Collected'!$E19*H$7","v":129.56380771536058},{"$f":"+'Tonnages Collected'!$E19*I$7","v":5.5003365932864252},{"$f":"+'Tonnages Collected'!$E19*J$7","v":2.1452012899088126},{"$f":"+'Tonnages Collected'!$E19*K$7","v":1.9819402687824148},{"$f":"+'Tonnages Collected'!$E19*L$7","v":2.3707164074137688},550.1709233718824,null,{"$f":"+C17*'CRC Prices'!B17","v":0},{"$f":"+D17*'CRC Prices'!C17","v":-335.11454466597428},{"$f":"+E17*'CRC Prices'!D17","v":14471.475048135677},{"$f":"+F17*'CRC Prices'!E17","v":3646.781827169078},{"$f":"+G17*'CRC Prices'!F17","v":993.38056031577651},{"$f":"+H17*'CRC Prices'!G17","v":-6910.9335035373342},{"$f":"+I17*'CRC Prices'!H17","v":926.42169240723263},{"$f":"+J17*'CRC Prices'!I17","v":1372.92882554164},{"$f":"+K17*'CRC Prices'!J17","v":606.47372224741889},{"$f":"+L17*'CRC Prices'!K17","v":-331.9002970379276},14439.51333057559,null,0,-3.9099999999999997,91.44,899.72,132.35,-53.34,168.43,640,306,-140]
["Mar",null,{"$f":"+'Tonnages Collected'!$E20*C$7","v":192.81578160635263},{"$f":"+'Tonnages Collected'!$E20*D$7","v":107.95380272094967},{"$f":"+'Tonnages Collected'!$E20*E$7","v":199.3416312130835},{"$f":"+'Tonnages Collected'!$E20*F$7","v":5.10533015262906},{"$f":"+'Tonnages Collected'!$E20*G$7","v":9.4539464136152507},{"$f":"+'Tonnages Collected'!$E20*H$7","v":163.19435341017012},{"$f":"+'Tonnages Collected'!$E20*I$7","v":6.9280448738560594},{"$f":"+'Tonnages Collected'!$E20*J$7","v":2.7020256938607008},{"$f":"+'Tonnages Collected'!$E20*K$7","v":2.4963874276688074},{"$f":"+'Tonnages Collected'!$E20*L$7","v":2.9860771927661061},692.97738070495188,null,{"$f":"+C18*'CRC Prices'!B18","v":0},{"$f":"+D18*'CRC Prices'!C18","v":-394.03137993146629},{"$f":"+E18*'CRC Prices'!D18","v":16453.658240327914},{"$f":"+F18*'CRC Prices'!E18","v":5029.7712663701504},{"$f":"+G18*'CRC Prices'!F18","v":1343.1221669823185},{"$f":"+H18*'CRC Prices'!G18","v":-8704.7868108984749},{"$f":"+I18*'CRC Prices'!H18","v":1108.4871798169695},{"$f":"+J18*'CRC Prices'!I18","v":1621.2154163164205},{"$f":"+K18*'CRC Prices'!J18","v":773.88010257733026},{"$f":"+L18*'CRC Prices'!K18","v":-254.83182763065949},16976.484353930504,null,0,-3.65,82.54,985.20000000000016,142.07,-53.34,160,600,310,-85.34]
["Apr",null,{"$f":"+'Tonnages Collected'!$E21*C$7","v":204.18195930421493},{"$f":"+'Tonnages Collected'!$E21*D$7","v":114.3175043571121},{"$f":"+'Tonnages Collected'!$E21*E$7","v":211.09249716437446},{"$f":"+'Tonnages Collected'!$E21*F$7","v":5.4062810874415685},{"$f":"+'Tonnages Collected'!$E21*G$7","v":10.011241226249398},{"$f":"+'Tonnages Collected'!$E21*H$7","v":172.81439594348637},{"$f":"+'Tonnages Collected'!$E21*I$7","v":7.3364418861700011},{"$f":"+'Tonnages Collected'!$E21*J$7","v":2.8613057275008438},{"$f":"+'Tonnages Collected'!$E21*K$7","v":2.6435454189349028},{"$f":"+'Tonnages Collected'!$E21*L$7","v":3.1621016017110382},733.82727371719545,null,{"$f":"+C19*'CRC Prices'!B19","v":0},{"$f":"+D19*'CRC Prices'!C19","v":-733.91837797265964},{"$f":"+E19*'CRC Prices'!D19","v":14806.027751109224},{"$f":"+F19*'CRC Prices'!E19","v":5158.5112252041208},{"$f":"+G19*'CRC Prices'!F19","v":1409.4826522436526},{"$f":"+H19*'CRC Prices'!G19","v":-9217.9198796255641},{"$f":"+I19*'CRC Prices'!H19","v":1283.8773300797502},{"$f":"+J19*'CRC Prices'!I19","v":1430.6528637504218},{"$f":"+K19*'CRC Prices'!J19","v":713.75726311242374},{"$f":"+L19*'CRC Prices'!K19","v":-301.06369349890792},14549.407134402463,null,0,-6.42,70.14,954.16999999999985,140.79,-53.34,175,500,270,-95.21]
[null,null,{"$f":"SUM(C8:C19)","v":2349.6216330535854},{"$f":"SUM(D8:D19)","v":1315.5074140216818},2429.1445708664924,62.212719677624079,115.20424742259739,1988.659745432863,84.424023670487145,32.926443937681064,30.420569601032962,36.38784912541621,8444.5092168094616,null,{"$f":"SUM(O8:O19)","v":27983.847806877056},{"$f":"SUM(P8:P19)","v":3963.6780223306237},230100.44149458097,70511.231793163999,17945.559855026673,-106075.11082138894,15337.648884476668,22980.469381746876,9819.2696222409941,-3478.9466367914933,{"$f":"SUM(Y8:Y19)","v":289088.08940226352},null,{"$f":"+O20/C20","v":11.909937929243972},{"$f":"+P20/D20","v":3.0130411885807096},{"$f":"+Q20/E20","v":94.724885564346039},{"$f":"+R20/F20","v":1133.3893158592234},{"$f":"+S20/G20","v":155.77168599694042},{"$f":"+T20/H20","v":-53.340000000000011},{"$f":"+U20/I20","v":181.67398588274568},{"$f":"+V20/J20","v":697.93353406888855},{"$f":"+W20/K20","v":322.78388442495077},-95.607372252225716]
[]
[]
[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, 18"},{"$f":"+Customers!C$22","v":0.34033917503067679},{"$f":"+C8*$B28","v":72.542495378964759},{"$f":"+D8*$B28","v":40.615131032241976},{"$f":"+E8*$B28","v":74.997695938774626},1.9207628437867514,3.5568295204321054,61.398115493988001,2.6065172625392892,1.0165749129960013,0.93920825322009716,1.123442744949724,{"$f":"SUM(C28:L28)","v":260.71677338189335},null,{"$f":"+O8*$B$40","v":6196.5143324094079},-354.41375705869751,7122.1727606983868,3037.9556045021804,654.91859217054582,-3315.3050836170592,477.85320435290981,804.75111636566544,377.45732152206779,-45.491094094829947,{"$f":"SUM(O28:X28)","v":14956.412997250576},null,{"$f":"+Customers!C$21","v":10817},{"$f":"+M28*2000/AA28","v":48.205005709881362}]
[{"$f":"+A9","v":"Jun"},{"$f":"+Customers!D$22","v":0.34155128124804213},{"$f":"+C9*$B29","v":69.435115356660347},38.87536944679394,{"$f":"+E9*$B29","v":71.785146648023513},1.838486378699802,3.4044716378310862,58.76810839957421,2.4948662967557937,0.97302961503902463,0.89897697984587244,1.0753197306582707,{"$f":"SUM(C29:L29)","v":249.54889048988184},null,{"$f":"+O9*$B$40","v":-924.53756625059179},-263.52102563215618,7105.716242606557,2684.9763123688354,612.51771527697338,-3162.0315082814741,581.39102793546544,687.06142907872618,272.04534268261148,-43.387944471497264,{"$f":"SUM(O29:X29)","v":7550.2300253134508},null,{"$f":"+Customers!D$21","v":10903},45.776188294943012]
["Jul",{"$f":"+Customers!E$22","v":0.34356766201753564},72.069700560873301,40.350422417135277,{"$f":"+E10*$B30","v":74.508899381344179},1.90824429566429,3.5336479279419377,60.997954034218928,2.589529318458283,1.009949398550221,0.93308697502431071,1.1161207207284742,259.01755502993922,null,{"$f":"+O10*$B$40","v":0},141.62216818311248,6974.8934808568038,2546.5301370847378,618.10117133163476,-3262.7469228477039,551.81674597246092,769.71210430643532,308.78143137626819,-44.7699151454702,8603.9404011182796,null,{"$f":"+Customers!E$21","v":11011},47.047053860673728]
["Aug",{"$f":"+Customers!F$22","v":0.34560124127230413},69.930140197706692,39.15252421901787,{"$f":"+E11*$B31","v":72.2969256034756},1.8515935280536551,3.4287431900954903,59.187084783060598,2.5126529856039306,0.97996665011189699,0.90538607032216345,1.0829860242333422,251.32800325168122,null,{"$f":"+O11*$B$40","v":697.13436853771202},342.30359098226654,6862.0596603342883,2399.0032889761546,543.17313346656204,-3147.2558968540252,551.07066059733745,722.92810812750508,270.77412313163683,-43.185200315891116,9198.0058369835479,null,{"$f":"+Customers!F$21","v":11137},45.133878648052658]
["Sep",{"$f":"+Customers!G$22","v":0.3446719780903772},63.181439210883696,35.374057908404602,{"$f":"+E12*$B32","v":65.319814850014751},1.6729030373061393,3.0978477781151934,53.475156616559993,2.2701660745874834,0.88539366799051022,0.81801058603220977,0.97847102069129643,227.07326075058586,null,{"$f":"+O12*$B$40","v":2353.8041228346001},429.26450707809704,6304.0352823081057,2059.6508103370024,452.2856219871386,-2851.1921623226208,383.95417996850483,619.52075951580434,228.94879774815576,-136.9296239216776,9843.3422955331098,null,{"$f":"+Customers!G$21","v":11075},41.006457923356358]
["Oct",{"$f":"+Customers!H$22","v":0.34438839063278526},68.565273187441846,38.38836174881471,{"$f":"+E13*$B33","v":70.885864672941509},1.8154549057698233,3.3618224252636044,58.031896201631206,2.4636120833749557,0.96084007395866711,0.88771512649962314,1.0618487593447694,246.42268918504072,null,{"$f":"+O13*$B$40","v":1318.367473676527},417.45340562956164,7129.8009905772524,1892.6104983484154,530.34418173299946,-3096.6966083642228,428.96833854920118,720.92694373187385,275.30506386800539,-139.29759259949063,9477.7826951501211,null,{"$f":"+Customers!H$21","v":11059},44.565094345789078]
["Nov",{"$f":"+Customers!I$22","v":0.34439911556787395},71.972044475871613,40.29574667614073,{"$f":"+E14*$B34","v":74.40793812640986},1.9056585812004989,3.5288597545524061,60.915300417820696,2.5860204472784436,1.0085808941226369,0.93182262093045731,1.1146083517422383,258.66658034606957,null,{"$f":"+O14*$B$40","v":0},566.77396088323439,7881.3127901577236,1841.6816304079055,567.51553906658637,-3250.4595270280684,413.92084521971731,766.81339425738156,335.58389545089699,-156.10459599679029,8967.0379324185869,null,{"$f":"+Customers!I$21","v":11059},46.779379753335668]
["Dec",{"$f":"+Customers!J$22","v":0.34483294966714367},65.168769364340562,36.486725375457041,{"$f":"+E15*$B35","v":67.374406187137879},1.7255230898306053,3.1952885198450391,55.157182105884566,2.3415726387577616,0.9132431370126437,0.84374056502244277,1.0092481759443308,234.21569915923286,null,{"$f":"+O15*$B$40","v":0},293.82487575936233,7097.0487513941171,1548.780289906395,498.05940727640461,-2939.5016851388832,374.32277249424226,647.8334931784874,295.04999070414897,-141.17072345461236,7674.2471721196634,null,{"$f":"+Customers!J$21","v":11085},42.258132459942779]
["Jan., '19",{"$f":"+Customers!K$22","v":0.34550535631113183},65.861282931411097,36.874450241016753,{"$f":"+E16*$B36","v":68.090357874012057},1.7438592984418277,3.229243137559644,55.743307903598442,2.3664552755857668,0.92294768212810463,0.85270654357421105,1.0199729151284513,236.70458380245634,null,{"$f":"+O16*$B$40","v":0},296.36929017589819,7043.758613277957,1515.46689422192,415.26791162055429,-2964.9566791919542,377.56426883219029,653.44349088646936,297.60501416159525,-142.39320954610614,7492.1255944385239,null,{"$f":"+Customers!K$21","v":11127},42.545984326854736]
["Feb",{"$f":"+Customers!L$22","v":0.34514044245587872},52.834427233037808,29.580967319543401,{"$f":"+E17*$B37","v":54.622608279776422},1.3989373286902518,2.5905236578349515,44.717709921147943,1.8983886054631374,0.74039572235604934,0.68404774128868584,0.81823010979219934,189.88623591893082,null,{"$f":"+O17*$B$40","v":0},-115.45710564043911,4985.8612525188528,1256.426739360933,342.24967587681817,-2381.0258083166277,319.18031882045193,473.01554340282212,208.94855723873388,-114.34970002688743,4974.8494732346571,null,{"$f":"+Customers!L$21","v":11108},34.189095412122938]
["Mar",{"$f":"+Customers!M22","v":0.34577469154938312},{"$f":"+C18*$B38","v":66.670817410789795},37.327692837419328,68.927291045654826,1.7652939587830783,3.2689354050922099,56.428477213002594,2.3955425792978637,0.9342921008531917,0.86318759278993984,1.0325099202713481,{"$f":"SUM(C38:L38)","v":239.61404006395415},null,{"$f":"+O18*$B$40","v":0},-135.75573899289037,5668.7833693364182,1732.9084687368006,462.74624718501013,-2999.0625784540935,381.90739094528755,558.5577903642652,266.62512319590405,-87.797279203819016,5848.9127931128824,null,{"$f":"+Customers!M$21","v":11154},42.96468353307408]
["Apr",{"$f":"+Customers!N22","v":0.34847970365797193},{"$f":"+C19*$B39","v":71.153268670636905},39.837330041285341,73.561450856262496,1.8839792312433361,3.4887143757718615,60.222309486217561,2.5566010943964548,0.99710697199435183,0.92122192419682414,1.1019282291006609,255.72391088110578,null,{"$f":"+O19*$B$40","v":0},-252.85709929871848,5101.1247866874828,1777.2632819307644,485.60944330443118,-3175.8524548310756,442.33460733891383,492.90322205940527,245.9109848871,-103.72555658379792,5012.7112154945053,null,{"$f":"+Customers!N$21","v":11289},45.30497136701316]
[null,{"$f":"+Customers!O22","v":0.34453027323991886},{"$f":"SUM(C28:C39)","v":809.38477397861834},{"$f":"SUM(D28:D39)","v":453.1587792632709},836.77839946382767,21.430696477470061,39.684927330335526,685.04260257670467,29.081924662099166,11.3423208271133,10.479110978746839,12.534686702585109,2908.9182222607719,null,{"$f":"SUM(O28:O39)","v":9641.2827312076552},{"$f":"SUM(P28:P39)","v":1365.6070720686312},79276.567980753942,24293.253956182045,6182.7886402956592,-36546.086915247804,5284.2843610266827,7917.4673952748408,3383.0356459671243,-1198.60243536087,{"$f":"SUM(Y28:Y39)","v":99599.598432167913},null,{"$f":"SUM(AA28:AA39)","v":132824},43.801093511124073]

{"sheet":"CRC Prices","index":2,"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"]
["2018-05-10",84.38,-8.6199999999999992,93.81,1562.4,181.89,-53.34,181.1,782,397,-40]
["2018-06-10",-13.2,-6.72,98.13,1447.8,178.36,-53.34,231.02,700,300,-40]
["2018-07-10",0,3.5,93.35,1330.76,174.43,-53.34,212.5,760,330,-40]
["2018-08-10",10,8.77,95.21,1299.67,158.91,-53.34,220,740,300,-40]
["2018-09-10",37.270000000000003,12.14,96.55,1231.69,146.06,-53.34,169.2,700,280,-140]
["2018-10-10",19.22,10.87,100.54,1042.07,157.69,-53.34,174.05,750,310,-131.13]
["2018-11-10",0,14.06,105.88,966.06,160.76,-53.34,160,760,360,-140]
["2018-12-10",0,8.06,105.43,898.36,156.01,-53.34,160,710,350,-140]
["2019-01-10",0,8.06,103.74,871.49,128.96,-53.34,160,710,350,-140]
["2019-02-10",0,-3.91,91.44,899.72,132.35,-53.34,168.43,640,306,-140]
["2019-03-10",0,-3.65,82.54,985.2,142.07,-53.34,160,600,310,-85.34]
["2019-04-10",0,-6.42,70.14,954.17,140.79,-53.34,175,500,270,-95.21]
["Average",{"$f":"+'Commodity Revenue'!AA20","v":11.909937929243972},{"$f":"+'Commodity Revenue'!AB20","v":3.0130411885807096},{"$f":"+'Commodity Revenue'!AC20","v":94.724885564346039},{"$f":"+'Commodity Revenue'!AD20","v":1133.3893158592234},{"$f":"+'Commodity Revenue'!AE20","v":155.77168599694042},{"$f":"+'Commodity Revenue'!AF20","v":-53.340000000000011},{"$f":"+'Commodity Revenue'!AG20","v":181.67398588274568},{"$f":"+'Commodity Revenue'!AH20","v":697.93353406888855},{"$f":"+'Commodity Revenue'!AI20","v":322.78388442495077},{"$f":"+'Commodity Revenue'!AJ20","v":-95.607372252225716}]

{"sheet":"CRC Composition","index":3,"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,"2018-05-05",null,"2018-06-05",null,"2018-07-05",null,"2018-08-05",null,"2018-09-05",null,"2018-10-05",null,"2018-11-05",null,"2018-12-05",null,"2019-01-05",null,"2019-02-05",null,"2019-03-11",null,"2019-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",2053.7199999999998,{"$f":"+B8/B$19","v":0.2456264987471819},1973.47,{"$f":"+D8/D$19","v":0.24933196715615735},2150.37,{"$f":"+F8/F$19","v":0.27026174430851296},2519.75,{"$f":"+H8/H$19","v":0.30036321329930465},1859.48,{"$f":"+J8/J$19","v":0.26358553899888865},2562.7399999999998,{"$f":"+L8/L$19","v":0.31924390192250912},2574.5500000000002,{"$f":"+N8/N$19","v":0.30859321623519997},2464.29,{"$f":"+P8/P$19","v":0.30568059888484367},2361.9699999999998,{"$f":"+R8/R$19","v":0.26661511891727141},1561.21,{"$f":"+T8/T$19","v":0.2587042005193273},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":22081.55},{"$f":"+Z8/$Z$19","v":0.2346766031628317},null,{"$f":"+Z8/($Z$19-$Z$18)","v":0.27824253283737055}]
["Mix Paper",1127.6500000000001,{"$f":"+B9/B$19","v":0.13486781124606068},1188.8599999999999,0.15020284193490105,1012.95,{"$f":"+F9/F$19","v":0.12730908350530756},567.59,{"$f":"+H9/H$19","v":6.7658758304019184E-2},516.89,{"$f":"+J9/J$19","v":7.3270338617858519E-2},347.9,{"$f":"+L9/L$19","v":4.3338361862241555E-2},331.78,{"$f":"+N9/N$19","v":3.9768137065706484E-2},231.02,{"$f":"+P9/P$19","v":2.8656664578591232E-2},692.09,{"$f":"+R9/R$19","v":7.8121931121671484E-2},297.24,{"$f":"+T9/T$19","v":4.9254896242251101E-2},3035.96,{"$f":"V9/V$19","v":0.40448402293705099},3013.1,0.39721680620866301,{"$f":"+P9+N9+L9+J9+H9+F9+D9+B9+R9+T9+V9+X9","v":12363.03},{"$f":"+Z9/$Z$19","v":0.1313908618371529},null,{"$f":"+Z9/($Z$19-$Z$18)","v":0.1557825777965948}]
["OCC",1752.87,0.20964460630415671,1890.36,0.23883169109908617,1840.49,{"$f":"+F10/F$19","v":0.23131555861659855},1937.47,{"$f":"+H10/H$19","v":0.23095335444826029},1614.22,{"$f":"+J10/J$19","v":0.2288193735683019},2197.63,{"$f":"+L10/L$19","v":0.273761667661161},2086.09,{"$f":"+N10/N$19","v":0.25004494861474369},1909.43,{"$f":"+P10/P$19","v":0.23685349773309436},2258.15,{"$f":"+R10/R$19","v":0.25489609554017895},1436.08,{"$f":"+T10/T$19","v":0.23796922148961094},1965.68,{"$f":"V10/V$19","v":0.26188953550340005},1940.43,0.2558067794867333,22828.9,0.24261923216187128,null,0.2876596506083608]
["Aluminum",57.02,6.8196360548489149E-3,28.85,3.6449640746781761E-3,47.19,{"$f":"+F11/F$19","v":5.9309103614348822E-3},60.7,{"$f":"+H11/H$19","v":7.2356571275990853E-3},45.43,{"$f":"+J11/J$19","v":6.4398063096777116E-3},42.91,{"$f":"+L11/L$19","v":5.3453552960873382E-3},43.36,{"$f":"+N11/N$19","v":5.1972584940895572E-3},42.72,{"$f":"+P11/P$19","v":5.2991633226448683E-3},60.56,{"$f":"+R11/R$19","v":6.8359088394983674E-3},44.11,{"$f":"+T11/T$19","v":7.3093576680315431E-3},58.31,{"$f":"V11/V$19","v":7.7687003048325549E-3},53.51,7.0542203379328795E-3,584.67000000000007,6.2137109746015487E-3,null,7.3672392415399046E-3]
["Tin Cans",77.599999999999994,9.2810199553889118E-3,60.44,7.6361049800190272E-3,58.65,{"$f":"+F12/F$19","v":7.3712204428513627E-3},69.77,{"$f":"+H12/H$19","v":8.3168335715418148E-3},100.62,{"$f":"+J12/J$19","v":1.4263114921412533E-2},115.69,{"$f":"+L12/L$19","v":1.4411655889171388E-2},116.67,{"$f":"+N12/N$19","v":1.398441301903664E-2},101.54,{"$f":"+P12/P$19","v":1.2595436418102995E-2},119.14,{"$f":"+R12/R$19","v":1.3448318677969542E-2},83.57,{"$f":"+T12/T$19","v":1.3848175477610429E-2},93.26,{"$f":"V12/V$19","v":1.2425124171303106E-2},85.73,1.1301781154382093E-2,1082.6799999999998,1.1506423449093682E-2,null,1.3642503603794313E-2]
["Glass",1548.92,0.18525202872810559,1585.46,0.20031004304468841,1541.59,{"$f":"+F13/F$19","v":0.19374935588227166},1830.87,{"$f":"+H13/H$19","v":0.21824625313356402},1527.84,{"$f":"+J13/J$19","v":0.21657481118595628},1587.31,{"$f":"+L13/L$19","v":0.19773330028041003},1594.76,{"$f":"+N13/N$19","v":0.19115267426278282},1581.31,{"$f":"+P13/P$19","v":0.19615215247498963},1595.39,{"$f":"+R13/R$19","v":0.18008488446907697},1313.26,{"$f":"+T13/T$19","v":0.21761702677667433},1483.67,{"$f":"V13/V$19","v":0.19767085544968133},1498.88,0.1975972674289074,18689.259999999998,0.19862428373130436,null,0.23549737401840704]
["PET",117.27,1.4025582605263631E-2,94.93,1.1993637421462712E-2,57.46,{"$f":"+F14/F$19","v":7.2216594483587269E-3},87.51,{"$f":"+H14/H$19","v":1.0431505028602898E-2},75.989999999999995,{"$f":"+J14/J$19","v":1.0771756140708987E-2},64.819999999999993,{"$f":"+L14/L$19","v":8.0747128942526523E-3},27.61,{"$f":"+N14/N$19","v":3.3094166748573036E-3},13.93,{"$f":"+P14/P$19","v":1.7279341077819058E-3},49.21,{"$f":"+R14/R$19","v":5.5547403235091585E-3},52.94,{"$f":"+T14/T$19","v":8.7725548616093829E-3},56.45,{"$f":"V14/V$19","v":7.5208906226684573E-3},95.29,1.2562075425184529E-2,793.41000000000008,8.4321419336696162E-3,null,9.9975050654731307E-3]
["HDPE Natl",23.36,2.7938740484263528E-3,26.62,3.363221617605998E-3,23.71,{"$f":"+F15/F$19","v":2.9799085541347969E-3},32.700000000000003,{"$f":"+H15/H$19","v":3.8979569698927526E-3},9.4700000000000006,{"$f":"+J15/J$19","v":1.3423941393935271E-3},25.39,{"$f":"+L15/L$19","v":3.1628657881066775E-3},31.17,{"$f":"+N15/N$19","v":3.736128857490118E-3},31.79,{"$f":"+P15/P$19","v":3.9433614706666752E-3},31.1,{"$f":"+R15/R$19","v":3.5105146120937786E-3},26.18,{"$f":"+T15/T$19","v":4.338222256836677E-3},17.940000000000001,{"$f":"V15/V$19","v":2.3901643537763001E-3},30.01,3.9562166387846331E-3,309.43999999999994,3.2886426941363552E-3,null,3.8991542423967491E-3]
["HDPE Col",22.53,2.6946054071509302E-3,26.09,3.2962604058354803E-3,15.44,{"$f":"+F16/F$19","v":1.9405224831649623E-3},22.82,{"$f":"+H16/H$19","v":2.7202256285306608E-3},35.520000000000003,{"$f":"+J16/J$19","v":5.0350411648635782E-3},35.58,{"$f":"+L16/L$19","v":4.4322475281936028E-3},21.9,{"$f":"+N16/N$19","v":2.6249991010277056E-3},19.239999999999998,{"$f":"+P16/P$19","v":2.3866082005544768E-3},21.06,{"$f":"+R16/R$19","v":2.3772166472892271E-3},12.31,{"$f":"+T16/T$19","v":2.0398592811940218E-3},26.63,{"$f":"V16/V$19","v":3.5479418473279185E-3},26.77,3.5290876181361089E-3,285.89,3.038359810711746E-3,null,3.6024082418524002E-3]
["#3 - 7",50.32,6.0183108782882744E-3,50.82,6.4206958154296324E-3,38.979999999999997,{"$f":"+F17/F$19","v":4.8990651809436682E-3},29.53,{"$f":"+H17/H$19","v":3.5200816306095715E-3},37.229999999999997,{"$f":"+J17/J$19","v":5.277437572293665E-3},41,{"$f":"+L17/L$19","v":5.1074240768953835E-3},27.66,{"$f":"+N17/N$19","v":3.3154098234897868E-3},33.520000000000003,{"$f":"+P17/P$19","v":4.1579577381801501E-3},24.97,{"$f":"+R17/R$19","v":2.8185707351762587E-3},7.94,{"$f":"+T17/T$19","v":1.3157175217449661E-3},0,{"$f":"V17/V$19","v":0},0,0,341.96999999999997,3.6343625326842343E-3,null,4.309054344210239E-3]
["Residue",{"$f":"1528.64+1.25","v":1529.89},0.18297602602512814,{"$f":"0.54+988.59","v":989.13},0.12496857245013601,{"$f":"1167.86+1.93","v":1169.79},{"$f":"+F18/F$19","v":0.14702097121642108},{"$f":"0.25+1230.05","v":1230.3},{"$f":"+H18/H$19","v":0.14665616085807501},{"$f":"0.52+1231.35","v":1231.8699999999999},{"$f":"+J18/J$19","v":0.17462038738064456},{"$f":"1.18+1005.38","v":1006.56},{"$f":"+L18/L$19","v":0.12538850680097113},{"$f":"1.89+1485.42","v":1487.3100000000002},{"$f":"+N18/N$19","v":0.17827339785157612},{"$f":"2.23+1630.63","v":1632.8600000000001},{"$f":"+P18/P$19","v":0.2025466250705501},{"$f":"2.84+1642.62","v":1645.4599999999998},{"$f":"+R18/R$19","v":0.18573670011626456},{"$f":"1.41+1198.48","v":1199.8900000000001},{"$f":"+T18/T$19","v":0.19883076790510926},{"$f":"765.55+2.31","v":767.8599999999999},{"$f":"V18/V$19","v":0.10230276480995927},{"$f":"0.73+841.08","v":841.81000000000006},0.11097576570127599,14732.729999999998,0.15657537771194255]
[null,{"$f":"SUM(B8:B18)","v":8361.15},1,7915.03,{"$f":"SUM(E8:E18)","v":1.0000000000000002},7956.6199999999981,{"$f":"SUM(G8:G18)","v":1},8389.01,{"$f":"SUM(I8:I18)","v":0.99999999999999989},7054.56,{"$f":"SUM(K8:K18)","v":1},8027.5300000000007,{"$f":"SUM(M8:M18)","v":0.99999999999999978},8342.8599999999988,{"$f":"SUM(O8:O18)","v":1.0000000000000002},8061.65,{"$f":"SUM(Q8:Q18)","v":1},{"$f":"SUM(R8:R18)","v":8859.1000000000022},{"$f":"SUM(S8:S18)","v":0.99999999999999956},{"$f":"SUM(T8:T18)","v":6034.7300000000005},{"$f":"SUM(U8:U18)","v":0.99999999999999989},{"$f":"SUM(V8:V18)","v":7505.76},{"$f":"SUM(W8:W18)","v":1},{"$f":"SUM(X8:X18)","v":7585.5300000000007},{"$f":"SUM(Y8:Y18)","v":0.99999999999999989},{"$f":"SUM(Z8:Z18)","v":94093.53},0.99999999999999989,null,{"$f":"SUM(AC8:AC18)","v":0.99999999999999978}]

{"sheet":"Customers","index":4,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Waste Management of Skagit County"]
["Recycling Customers by Jurisdiction"]
[]
[]
[null,null,"2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01","2019-01-01","2019-02-01","2019-03-01","2019-04-01","Total","%"]
["Contract Cities:"]
[null,"Anacortes",6603,6608,6612,6621,6635,6644,6644,6650,6653,6661,6666,6681,{"$f":"SUM(C7:N7)","v":79678},{"$f":"+O7/$O$24","v":0.20667562421859192}]
[null,"Burlington",2137,2148,2160,2168,2169,2166,2159,2159,2161,2159,2168,2170,25924,{"$f":"+O8/$O$24","v":6.7243892696136662E-2}]
[null,"Darrington",485,486,483,484,486,489,489,488,487,489,487,487,5840,1.5148292445048532E-2]
[null,"Sedro-Woolley -annex",5,2,2,2,1,1,1,1,1,1,1,1,19,4.9283828160260633E-5]
[null,"Mount Vernon",9429,9452,9450,9464,9451,9446,9452,9452,9461,9464,9471,9419,113411,0.29417517028859574]
[null,"Stanwood",1783,1791,1796,1813,1796,1797,1797,1796,1795,1784,1784,1809,21541,5.587489170527233E-2]
[null,"Other",524,532,535,536,519,510,510,515,520,518,527,539,6285,1.630257157827569E-2]
[null,"Total",{"$f":"SUM(C7:C13)","v":20966},21019,21038,21088,21057,21053,21052,21061,21078,21076,21104,21106,252698,0.65546972676008108]
[null,null,{"$f":"+C14/C24","v":0.65966082496932321},0.65844871875195787,0.65643233798246436,0.65439875872769593,0.6553280219096228,0.65561160936721474,0.65560088443212605,0.65516705033285638,0.65449464368886823,0.65485955754412128,0.65422530845061688,0.65152029634202813,0.65546972676008108]
[]
["WUTC:"]
[null,"Skagit County",5443,5493,5553,5632,5614,5609,5609,5620,{"$f":"5468+167","v":5635},{"$f":"168+5480","v":5648},{"$f":"169+5498","v":5667},{"$f":"168+5566","v":5734},{"$f":"SUM(C18:N18)","v":67257},0.17445697003024471]
[null,"Island County",2403,2452,2489,2521,2504,2490,2490,2485,2471,2453,2480,2541,{"$f":"SUM(C19:N19)","v":29779},7.7243322041284285E-2]
[null,"Snohomish County",2971,2958,2969,2984,2957,2960,2960,2980,3021,3007,3007,3014,{"$f":"SUM(C20:N20)","v":35788},9.2829981168389877E-2]
[null,"Total",{"$f":"SUM(C18:C20)","v":10817},10903,11011,11137,11075,11059,11059,11085,11127,11108,{"$f":"SUM(M18:M20)","v":11154},{"$f":"SUM(N18:N20)","v":11289},{"$f":"SUM(O18:O20)","v":132824},0.34453027323991886]
[null,null,{"$f":"+C21/C$24","v":0.34033917503067679},{"$f":"+D21/D$24","v":0.34155128124804213},0.34356766201753564,0.34560124127230413,0.3446719780903772,0.34438839063278526,0.34439911556787395,0.34483294966714367,0.34550535631113183,0.34514044245587872,0.34577469154938312,0.34847970365797193,0.34453027323991886]
[]
[null,"Grand Total",{"$f":"+C21+C14","v":31783},31922,32049,32225,32132,32112,32111,32146,32205,32184,32258,32395,385522,1]

{"sheet":"Tonnages Collected","index":5,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["WM of Skagit County"]
["Residential Recycling Tons Collected"]
[]
[]
[null,null,null,"Less:"]
[null,null,"Res'l ","CRC"]
[null,null,"Collected","Residual","Net"]
["Month",null,"Tons","Rate","Tons"]
[]
["May, 18",null,937.61,{"$f":"+'CRC Composition'!C18","v":0.18297602602512814},{"$f":"+C10-C10*D10","v":766.04984823857967}]
["Jun",null,834.98,{"$f":"+'CRC Composition'!E18","v":0.12496857245013601},{"$f":"+C11-C11*D11","v":730.63374137558549}]
["Jul",null,883.85,{"$f":"+'CRC Composition'!G18","v":0.14702097121642108},753.90551459036624]
["Aug",null,852.2,{"$f":"+'CRC Composition'!I18","v":0.14665616085807501},727.21961971674853]
["Sep",null,798.19,{"$f":"+'CRC Composition'!K18","v":0.17462038738064456},658.8097529966434]
["Oct",null,818.12,{"$f":"+'CRC Composition'!M18","v":0.12538850680097113},715.53715481598954]
["Nov",null,914.01,{"$f":"+'CRC Composition'!O18","v":0.17827339785157612},751.06633162968092]
["Dec",null,851.73,{"$f":"+'CRC Composition'!Q18","v":0.2025466250705501},679.21496302866035]
["Jan., '19",null,841.37,{"$f":"+'CRC Composition'!S18","v":0.18573670011626456},685.09671262317852]
["Feb",null,686.71,{"$f":"+'CRC Composition'!U18","v":0.19883076790510926},550.17092337188251]
["Mar",null,771.95,{"$f":"+'CRC Composition'!W18","v":0.10230276480995927},692.977380704952]
["Apr",null,825.43,{"$f":"+'CRC Composition'!Y18","v":0.11097576570127599},733.82727371719568]
[null,null,{"$f":"SUM(C10:C21)","v":10016.150000000001},{"$f":"(+C22-E22)/C22","v":0.15691066759089431},{"$f":"SUM(E10:E21)","v":8444.5092168094652}]