{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Input","Key","Space Requirements","Service Recommendation"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":3,"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":"Instructions","index":0,"n_rows":50,"n_cols":4,"rows_kept":50,"cut":false,"hidden":false,"merged":[[49,2,50,15],[2,1,8,10],[20,1,20,10],[34,3,35,12],[10,1,17,10]]}
[]
[null,"Welcome to the Adequate Refuse Space Calculator!"]
[null,"This tool provides planning-level estimates for the quantity of trash, recycling, and composting waste generated within a given building. The user inputs detailed information regarding the project size, estimated occupancy, and sector(s), and the resulting outputs include a waste generation estimate, recommended service profiles (container type, size, and collection frequency), and estimates for the amount of space that will need to be allocated for waste containers in the building design phase. This calculator is intended to complement the Adequate Refuse Space Design Guidelines that can be found here (link to document on DBI website)."]
[]
[]
[]
[]
[]
[]
[]
[null,"Disclaimer: This Design Guide and the accompanying calculator and tools are provided for your convenience only.  It is impossible to anticipate each project’s unique characteristics and therefore this document is intended only as a guideline and not specific advice for your project.  While we take every care to ensure the accuracy of the information in this Design Guide, we do not accept responsibility for any inadvertent inaccuracies.  Under no circumstances shall Recology, Cascadia Consulting Group, Inc., or SF Environment be liable for any actions taken or omissions made from reliance on any information contained herein from whatever source nor shall Recology, Cascadia Consulting Group, Inc., or SF Environment be liable for any other consequences from any such reliance."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"In order to use this tool, please read the instructions below and then click the gray button to begin:"]
[null,"  Note: Only the white cells on the INPUT tab should be modified by the user. All other cells calculate automatically based on user inputs."]
[null,null,"1) Enter the Project Name"]
[null,null,"2) Enter the following user info: "]
[null,null,null,"a) User Name"]
[null,null,null,"b) Company/Organization"]
[null,null,null,"c) Phone Number"]
[null,null,null,"d) Email Address"]
[null,null,"3) Enter the following Project Specifications:"]
[null,null,null,"a) Address"]
[null,null,null,"b) Number of Floors"]
[null,null,null,"c) Expected Occupancy"]
[null,null,null,"d) Square Footage"]
[null,null,null,"e) Days of Operation/Week (if the building includes multifamily, default to 7 days per week)"]
[null,null,null,"f) Notes (note any building plans or operational considerations that may impact waste generation, e.g., \"all foodservice areas will use a food waste dehydrator\")"]
[]
[null,null,"4) Enter the project sector(s) using the drop-down menus to select from the following options:"]
[null,null,null,"a) Multifamily"]
[null,null,null,"b) Office"]
[null,null,null,"c) Restaurant (sit-down)"]
[null,null,"5) Enter the percentage of the building's square footage that will be dedicated to each sector using the dropdown menus."]
[null,null,"  Note: round to the nearest 5%. If the project only includes one sector, enter 100% for that sector."]
[null,null,"6) Enter the percentage of the building's expected occupants that will be dedicated to each sector using the dropdown menus."]
[null,null,"  Note: round to the nearest 5%. If the project only includes one sector, enter 100% for that sector."]
[null,null,"7) If the building includes multifamily as one of its sectors, enter the number of units that are included."]
[]
[null,"After the above information has been inputted, the remaining tables in the calculator will automatically populate. The following information will be calculated:"]
[null,null,"1) Estimated Generation(weekly of trash, recycling, and composting that will be generated by each sector and the building overall."]
[null,null,"2) Recommended service profile - the type of container, container size, and weekly collection frequency necessary to collect the building's waste."]
[null,null,"3) Recommended space allocation - estimates for the amount of space needed for each container and additional operational design consideration regarding collection and servicing access."]

{"sheet":"Input","index":1,"n_rows":94,"n_cols":11,"rows_kept":94,"cut":false,"hidden":false,"merged":[[77,8,77,9],[89,8,89,9],[83,3,83,4],[83,8,83,9],[84,3,84,4],[89,5,89,7],[90,3,90,4],[89,3,89,4],[77,3,77,4],[61,6,61,7],[61,3,61,4],[84,6,84,7],[90,6,90,7],[78,3,78,4],[78,6,78,7],[65,3,65,4],[65,6,65,7],[77,5,77,6],[70,3,70,4],[70,5,70,6],[70,8,70,9],[71,3,71,4],[71,6,71,7],[25,5,25,6],[26,2,27,6],[29,3,34,7],[61,8,61,9],[64,3,64,4],[64,6,64,7],[64,8,64,9],[62,3,62,4],[62,6,62,7],[58,3,58,4],[58,6,58,7],[58,8,58,9],[59,3,59,4],[59,6,59,7],[45,7,45,8],[41,4,41,5],[19,4,19,5],[21,4,21,5],[38,4,38,5],[39,4,39,5],[40,4,40,5],[42,4,42,5],[42,6,42,7],[43,7,43,8],[6,3,6,5],[8,3,8,5],[10,3,10,5],[2,3,2,5],[4,3,4,5],[13,4,13,5],[15,4,15,5],[17,4,17,5],[36,4,36,5],[37,4,37,5]]}
[]
[]
[null,null,"Project Name"]
[]
[null,null,"User"]
[]
[null,null,"Organization"]
[]
[null,null,"Phone Number"]
[]
[null,null,"Email Address"]
[]
[null,null,"Project Specifications"]
[null,null,"Address"]
[]
[null,null,"Number of floors"]
[]
[null,null,"Expected occupancy",null,null,null,{"$f":"IF(ISNUMBER(E18),\"\",\"Please Enter a valid number\")","v":"Please Enter a valid number"}]
[]
[null,null,"Square footage"]
[]
[null,null,"Days of operation/week"]
[]
[]
[]
[null,null,"Will the waste collection room be below grade?",null,null,"No"]
[null,null,{"$f":"IF(F26=\"No\",\"\",\"For below-grade collection rooms in multifamily properties or mixed-use developments <50,000 sq. ft., please contact Recology at (415) 575-2413\")","v":""}]
[]
[]
[null,null,"Notes"]
[]
[]
[]
[]
[]
[]
[null,null,"Sector (select up to four)",null,"Percentage (based on square footage)"]
[null,1,"Multifamily",null,0.01]
[null,2,"Office",null,0.93]
[null,3,"(select from dropdown)",null,"(select from dropdown)"]
[null,4,"(select from dropdown)",null,"(select from dropdown)"]
[null,null,"Total",null,{"$f":"SUM(E38:F41)","v":0.94000000000000006}]
[null,null,null,null,{"$f":"IF(E42=1,\"\",\"Error - values must add to 100%\")","v":"Error - values must add to 100%"}]
[null,null,"If commercial is included, is there private on-site foodservice?",null,null,null,null,"Yes"]
[]
[null,null,"If multifamily is included, how many units are planned?",null,null,null,null,200,null,{"$f":"IF(ISNUMBER(H46),\"\",\"Please Enter a valid number\")","v":""}]
[]
[]
[null,null,"Estimated Generation (weekly) Uncompacted",null,{"$f":"+Key!B50","v":"Trash"},{"$f":"+Key!C50","v":"Recycling"},{"$f":"+Key!D50","v":"Composting"},"Total"]
[null,null,null,null,"Cubic Yards","Cubic Yards","Cubic Yards","Cubic Yards"]
[null,1,{"$f":"IF(ISBLANK(C38),\"\",C38)","v":"Multifamily"},null,{"$f":"IFERROR(ROUND(INDEX(Capacity_Lookup,MATCH(Input!$C51,Key!$A$50:$A$53,0),MATCH(Input!E$49,Key!$A$50:$E$50,0)),3)*$E38*IF($C51=Key!$A$7,$H$46,$E$20/1000),\"\")","v":0.27200000000000002},{"$f":"IFERROR(ROUND(INDEX(Capacity_Lookup,MATCH(Input!$C51,Key!$A$50:$A$53,0),MATCH(Input!F$49,Key!$A$50:$E$50,0)),3)*$E38*IF($C51=Key!$A$7,$H$46,$E$20/1000),\"\")","v":0.27800000000000002},{"$f":"IFERROR(ROUND(INDEX(Capacity_Lookup,MATCH(Input!$C51,Key!$A$50:$A$53,0),MATCH(Input!G$49,Key!$A$50:$E$50,0)),3)*$E38*IF($C51=Key!$A$7,$H$46,$E$20/1000),\"\")","v":7.8E-2},{"$f":"SUM(E51,F51,G51)","v":0.628}]
[null,2,{"$f":"IF(ISBLANK(C39),\"\",C39)","v":"Office"},null,{"$f":"IFERROR(ROUND(INDEX(Capacity_Lookup,MATCH(Input!$C52,Key!$A$50:$A$53,0),MATCH(Input!E$49,Key!$A$50:$E$50,0)),3)*$E39*IF($C52=Key!$A$7,$H$46,$E$20/1000),\"\")","v":0},{"$f":"IFERROR(ROUND(INDEX(Capacity_Lookup,MATCH(Input!$C52,Key!$A$50:$A$53,0),MATCH(Input!F$49,Key!$A$50:$E$50,0)),3)*$E39*IF($C52=Key!$A$7,$H$46,$E$20/1000),\"\")","v":0},{"$f":"IFERROR(ROUND(INDEX(Capacity_Lookup,MATCH(Input!$C52,Key!$A$50:$A$53,0),MATCH(Input!G$49,Key!$A$50:$E$50,0)),3)*$E39*IF($C52=Key!$A$7,$H$46,$E$20/1000),\"\")","v":0},{"$f":"SUM(E52,F52,G52)","v":0}]
[null,3,{"$f":"IF(ISBLANK(C40),\"\",C40)","v":"(select from dropdown)"},null,{"$f":"IFERROR(ROUND(INDEX(Capacity_Lookup,MATCH(Input!$C53,Key!$A$50:$A$53,0),MATCH(Input!E$49,Key!$A$50:$E$50,0)),3)*$E40*IF($C53=Key!$A$7,$H$46,$E$20/1000),\"\")","v":""},{"$f":"IFERROR(ROUND(INDEX(Capacity_Lookup,MATCH(Input!$C53,Key!$A$50:$A$53,0),MATCH(Input!F$49,Key!$A$50:$E$50,0)),3)*$E40*IF($C53=Key!$A$7,$H$46,$E$20/1000),\"\")","v":""},{"$f":"IFERROR(ROUND(INDEX(Capacity_Lookup,MATCH(Input!$C53,Key!$A$50:$A$53,0),MATCH(Input!G$49,Key!$A$50:$E$50,0)),3)*$E40*IF($C53=Key!$A$7,$H$46,$E$20/1000),\"\")","v":""},{"$f":"SUM(E53,F53,G53)","v":0}]
[null,4,{"$f":"IF(ISBLANK(C41),\"\",C41)","v":"(select from dropdown)"},null,{"$f":"IFERROR(ROUND(INDEX(Key!#REF!,MATCH(Input!$C54,Key!#REF!,0),MATCH(Input!E$49,Key!#REF!,0))/1000*$E$20,3)*$E41,\"\")","v":""},{"$f":"IFERROR(ROUND(INDEX(Key!#REF!,MATCH(Input!$C54,Key!#REF!,0),MATCH(Input!F$49,Key!#REF!,0))/1000*$E$20,3)*$E41,\"\")","v":""},{"$f":"IFERROR(ROUND(INDEX(Key!#REF!,MATCH(Input!$C54,Key!#REF!,0),MATCH(Input!G$49,Key!#REF!,0))/1000*$E$20,3)*$E41,\"\")","v":""},{"$f":"SUM(E54,F54,G54)","v":0}]
[null,null,"Total",null,{"$f":"SUM(E51:E54)","v":0.27200000000000002},{"$f":"SUM(F51:F54)","v":0.27800000000000002},{"$f":"SUM(G51:G54)","v":7.8E-2},{"$f":"SUM(H51:H54)","v":0.628}]
[]
[null,null,"Recommended Service Profile"]
[]
[null,null,"Trash","Container type",null,"Qty","Container Size",null,"Collection Frequency",null,"Total Capacity"]
[null,null,null,{"$f":"IFERROR(VLOOKUP($E$55,'Service Recommendation'!$A:$M,'Service Recommendation'!$D$1,1),\"\")","v":"Container"},null,1,{"$f":"IFERROR(VLOOKUP($E$55,'Service Recommendation'!$A:$M,'Service Recommendation'!$B$1,1),\"\")","v":1},null,{"$f":"IF(E55>110,ROUNDUP(E55/(G60*3),0)&\"x\",IFERROR(VLOOKUP($E$55,'Service Recommendation'!$A:$M,'Service Recommendation'!$E$1,1)&\"x\",\"\"))","v":"1x"},"per week",{"$f":"IFERROR(IF(D60=\"Compactor\",F60*G60*LEFT(I60,FIND(\"x\",I60)-1)*3,F60*G60*LEFT(I60,1)),\"\")","v":1}]
[]
[null,null,"Recycling","Container type",null,"Qty","Container Size",null,"Collection Frequency",null,"Total Capacity"]
[null,null,null,{"$f":"IFERROR(VLOOKUP($F$55,'Service Recommendation'!$A:$M,'Service Recommendation'!$H$1,1),\"\")","v":"Container"},null,1,{"$f":"IFERROR(VLOOKUP($F$55,'Service Recommendation'!$A:$M,'Service Recommendation'!$F$1,1),\"\")","v":1},null,{"$f":"IF(F55>110,ROUNDUP(F55/(G63*3),0)&\"x\",IFERROR(VLOOKUP($F$55,'Service Recommendation'!$A:$M,'Service Recommendation'!$I$1,1)&\"x\",\"\"))","v":"1x"},"per week",{"$f":"IFERROR(IF(D63=\"Compactor\",F63*G63*LEFT(I63,FIND(\"x\",I63)-1)*3,F63*G63*LEFT(I63,1)),\"\")","v":1}]
[]
[null,null,"Composting","Container type",null,"Qty","Container Size",null,"Collection Frequency",null,"Total Capacity"]
[null,null,null,{"$f":"IFERROR(VLOOKUP($G$55,'Service Recommendation'!$A:$M,'Service Recommendation'!$L$1,1),\"\")","v":"Container"},null,1,{"$f":"IFERROR(VLOOKUP($G$55,'Service Recommendation'!$A:$M,'Service Recommendation'!$J$1,1),\"\")","v":1},null,{"$f":"IF(G55>110,ROUNDUP(G55/(G66*3),0)&\"x\",IFERROR(VLOOKUP($G$55,'Service Recommendation'!$A:$M,'Service Recommendation'!$M$1,1)&\"x\",\"\"))","v":"1x"},"per week",{"$f":"IFERROR(IF(D66=\"Compactor\",F66*G66*LEFT(I66,FIND(\"x\",I66)-1)*3,F66*G66*LEFT(I66,1)),\"\")","v":1}]
[]
[]
[null,null,"Recommended Space Allocation"]
[null,null,"Total"]
[null,null,"Total Space Needs",null,null,"Space for Container(s)",null,null,"Operational Space"]
[null,null,"Number of Containers",{"$f":"SUM(D81,D87,D93,)","v":3},null,"Square feet",{"$f":"SUM(G79+G85+G91)","v":175.49999999999997},null,"Entrance width",null,"12.5 ft"]
[null,null,null,null,null,"length",{"$f":"G80+G86+G92","v":40.5},"ft","Minimum overhead clearance",null,"23 ft"]
[null,null,null,null,null,"width",{"$f":"MAX(G81,G87,G93)","v":4.333333333333333},"ft","Servicing length ",null,{"$f":"+Key!B48","v":"66 ft"}]
[null,null,null,null,null,"height",{"$f":"MAX(G82,G88,G94)","v":4.75},"ft","Turning radius",null,"36.5 ft"]
[]
[null,null,"By Stream"]
[null,null,"Trash",null,null,"Space for Container(s)"]
[null,null,"Type",{"$f":"D60","v":"Container"},null,"Square feet",{"$f":"G80*G81","v":58.499999999999993}]
[null,null,"Container Size",{"$f":"G60","v":1},"yds","length",{"$f":"INDEX('Space Requirements'!$R$8:$R$20,MATCH(Input!G60,'Space Requirements'!$E$8:$E$20,0))","v":13.5},"ft"]
[null,null,"Quantity",{"$f":"F60","v":1},null,"width",{"$f":"INDEX('Space Requirements'!$T$8:$T$20,MATCH(Input!G60,'Space Requirements'!$E$8:$E$20,0))","v":4.333333333333333},"ft"]
[null,null,null,null,null,"height",{"$f":"INDEX('Space Requirements'!$V$8:$V$20,MATCH(Input!G60,'Space Requirements'!$E$8:$E$20,0))","v":4.75},"ft"]
[]
[null,null,"Recycling",null,null,"Space for Container(s)"]
[null,null,"Type",{"$f":"D63","v":"Container"},null,"Square feet",{"$f":"G86*G87","v":58.499999999999993}]
[null,null,"Container Size",{"$f":"G63","v":1},"yds","length",{"$f":"INDEX('Space Requirements'!$R$8:$R$20,MATCH(Input!G63,'Space Requirements'!$E$8:$E$20,0))","v":13.5},"ft"]
[null,null,"Quantity",{"$f":"F63","v":1},null,"width",{"$f":"INDEX('Space Requirements'!$T$8:$T$20,MATCH(Input!G63,'Space Requirements'!$E$8:$E$20,0))","v":4.333333333333333},"ft"]
[null,null,null,null,null,"height",{"$f":"INDEX('Space Requirements'!$V$8:$V$20,MATCH(Input!G63,'Space Requirements'!$E$8:$E$20,0))","v":4.75},"ft"]
[]
[null,null,"Composting",null,null,"Space for Container(s)"]
[null,null,"Type",{"$f":"D66","v":"Container"},null,"Square feet",{"$f":"G92*G93","v":58.499999999999993}]
[null,null,"Container Size",{"$f":"G66","v":1},"yds","length",{"$f":"INDEX('Space Requirements'!$R$8:$R$20,MATCH(Input!$G$66,'Space Requirements'!$E$8:$E$20,0))","v":13.5},"ft"]
[null,null,"Quantity",{"$f":"F66","v":1},null,"width",{"$f":"INDEX('Space Requirements'!$T$8:$T$20,MATCH(Input!$G$66,'Space Requirements'!$E$8:$E$20,0))","v":4.333333333333333},"ft"]
[null,null,null,null,null,"height",{"$f":"INDEX('Space Requirements'!$V$8:$V$20,MATCH(Input!$G$66,'Space Requirements'!$E$8:$E$20,0))","v":4.75},"ft"]

{"sheet":"Key","index":2,"n_rows":53,"n_cols":6,"rows_kept":53,"cut":false,"hidden":true,"merged":[]}
["Key References/Assumptions"]
[]
[]
["Dropdown Menus"]
["Sector","Percentages","(select from dropdown)","Days Per Week"]
["(select from dropdown)","(select from dropdown)","Yes",1]
["Multifamily",0,"No",2]
["Office",0.01,null,3]
["Restaurant (sit-down)",0.02,null,4]
[null,0.03,null,5]
[null,0.04,null,6]
[null,0.05,null,7]
[null,6.0000000000000005E-2]
[null,7.0000000000000007E-2]
[null,0.08]
[null,0.09]
[null,9.9999999999999992E-2]
[null,0.15]
[null,0.2]
[null,0.25]
[null,0.3]
[null,0.35]
[null,0.39999999999999997]
[null,0.44999999999999996]
[null,0.49999999999999994]
[null,0.54999999999999993]
[null,0.6]
[null,0.65]
[null,0.70000000000000007]
[null,0.75000000000000011]
[null,0.80000000000000016]
[null,0.8500000000000002]
[null,0.90000000000000024]
[null,0.91]
[null,0.92]
[null,0.93]
[null,0.94]
[null,0.95]
[null,0.96]
[null,0.97]
[null,0.98]
[null,0.99]
[null,1.0000000000000002]
[]
[]
[]
[]
["Minimum servicing length","66 ft"]
[]
[null,"Trash","Recycling","Composting","Total"]
["Office",5.9400000000000001E-2,0.14410000000000001,5.2800000000000007E-2,0.25607390300230948,"Per 1000 Square Foot"]
["Multifamily",0.13600000000000001,0.13900000000000001,3.9399999999999998E-2,0.31462962962962965,"Per Unit"]
["Restaurant (sit-down)",0.36,0.46,0.43,1.26,"Per 1000 Square Foot"]

{"sheet":"Space Requirements","index":3,"n_rows":20,"n_cols":30,"rows_kept":20,"cut":false,"hidden":true,"merged":[[0,6,0,7],[5,22,5,23],[5,24,5,25],[5,26,5,27],[4,22,4,27],[4,9,4,14],[5,9,5,10],[5,11,5,12],[5,13,5,14],[4,15,4,21],[5,16,5,17],[5,18,5,19],[5,20,5,21]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Container profile",null,null,null,null,null,"Profiles with buffer",null,null,null,null,null,null,"Pounds per week",null,null,null,null,null,null,"RECOLOGY NOTES"]
[null,null,null,null,null,null,null,null,null,"length",null,"width",null,"height",null,null,"length",null,"width",null,"height",null,"Landfill",null,"Recycling",null,"Composting"]
[null,null,"Container Name","Type","Size","Unit","Stream 1","Stream 2","Stream 3","inches","feet","inches","feet","inches","feet","buffer (inches)","inches","feet","inches","feet","inches","feet","min","max","min","max","min","max",null,"max wt"]
[0.01,1,"1 yd","container",1,"yd","Landfill","Recycling","Compost",82,6.833333333333333,28,2.3333333333333335,39,3.25,80,{"$f":"J8+P8","v":162},{"$f":"Q8/12","v":13.5},{"$f":"L8+24","v":52},{"$f":"S8/12","v":4.333333333333333},57,4.75,0.1,102.35,0.1,75.45,0.1,185.45,1,{"$f":"+X8/AC8","v":102.35}]
[1,2,"2 yd","container",2,"yd","Landfill","Recycling","Compost",82,6.833333333333333,42,3.5,47,3.9166666666666665,80,{"$f":"J9+P9","v":162},{"$f":"Q9/12","v":13.5},{"$f":"L9+24","v":66},{"$f":"S9/12","v":5.5},65,5.416666666666667,102.44999999999999,204.7,75.55,150.9,185.54999999999998,370.9,2]
[2,3,"3 yd","container",3,"yd","Landfill","Recycling","Compost",82,6.833333333333333,44,3.6666666666666665,61,5.083333333333333,80,162,13.5,68,5.666666666666667,79,6.583333333333333,204.79999999999998,307.04999999999995,151,226.35000000000002,371,556.34999999999991,3]
[3,4,"4 yd","container",4,"yd","Landfill","Recycling","Compost",82,6.833333333333333,53,4.416666666666667,66,5.5,80,162,13.5,77,6.416666666666667,84,7,307.14999999999998,409.4,226.45000000000002,301.8,556.44999999999993,650,4]
[4.5,2,"2 yd","compactor",2,"yd","Landfill","Recycling","Compost",123,10.25,48,4,75,6.3,80,203,16.916666666666668,72,6,91,7.583333333333333,410,800,301.89999999999998,800,650.1,800,{"$f":"2*3","v":6}]
[6.5,3,"3 yd","compactor",3,"yd","Landfill","Recycling","Compost",123,10.25,48,4,75,6.3,80,203,16.916666666666668,72,6,91,7.583333333333333,800.1,1600,800.1,1600,800.1,1600,{"$f":"3*3","v":9}]
[9.5,4,"4 yd ","compactor",4,"yd","Landfill","Recycling","Compost",123,10.25,48,4,75,6.3,80,203,16.916666666666668,72,6,91,7.583333333333333,1600.1,2000,1600.1,2000,1600.1,2000,{"$f":"4*3","v":12}]
[12.5,10,"10 yd compactor","compactor",10,"yd","Landfill","Recycling","Compost",158,13.166666666666666,100,8.1,87,7.3,530,688,57.333333333333336,148,12.333333333333334,105,8.75,2000.1,3500,2000.1,3500,2000.1,3500,{"$f":"10*3","v":30}]
[null,15,"15 yd compactor","compactor",15,"yd","Landfill","Recycling","Compost",182,15.2,100,8.3000000000000007,110,8.5,530,712,59.333333333333336,148,12.333333333333334,105,8.8000000000000007,null,null,null,null,null,null,45]
[31.5,20,"20 yd compactor","compactor",20,"yd","Landfill","Recycling","Compost",208,17.3,100,8.3000000000000007,110,8.5,530,738,61.5,148,12.333333333333334,105,8.75,3500.1,7000,3500.1,7000,3500.1,7000,{"$f":"20*3","v":60}]
[null,25,"25 yd compactor","compactor",25,"yd","Landfill","Recycling","Compost",239,19.899999999999999,100,8.3000000000000007,110,8.5,530,769,64.083333333333329,148,12.333333333333334,105,8.8000000000000007,null,null,null,null,null,null,75]
[61.5,30,"30 yd compactor","compactor",30,"yd","Landfill","Recycling",null,265,22.1,100,8.3000000000000007,110,8.5,530,795,66.25,148,12.333333333333334,136,11.333333333333334,7000.1,12000,7000.1,12000,"N/A","N/A",{"$f":"30*3","v":90}]
[91.5,34,"34 yd compactor","compactor",34,"yd","Landfill","Recycling",null,285,23.75,100,8.3000000000000007,110,8.5,530,815,67.916666666666671,148,12.333333333333334,136,11.333333333333334,"N/A","N/A",12000.1,16000,"N/A","N/A",{"$f":"34*3","v":102}]

{"sheet":"Service Recommendation","index":4,"n_rows":115,"n_cols":13,"rows_kept":115,"cut":false,"hidden":true,"merged":[]}
[1,{"$f":"+A1+1","v":2},{"$f":"+B1+1","v":3},4,5,6,7,8,9,10,11,12,13]
[]
[null,"Trash",null,null,null,"Recycling",null,null,null,"Recycling"]
["Uncompacted Yards","Size",null,"Type","Times Per Week","Size",null,"Type","Times Per Week","Size",null,"Type","Times Per Week"]
[0,1,"yd","Container",1,1,"yd","Container",1,1,"yd","Container",1]
[{"$f":"+A5+1","v":1},1,"yd","Container",1,1,"yd","Container",1,1,"yd","Container",1]
[2,2,"yd","Container",1,2,"yd","Container",1,2,"yd","Container",1]
[3,3,"yd","Container",1,3,"yd","Container",1,3,"yd","Container",1]
[4,4,"yd","Container",1,4,"yd","Container",1,4,"yd","Container",1]
[5,2,"yd","Compactor",1,2,"yd","Compactor",1,2,"yd","Compactor",1]
[6,2,"yd","Compactor",1,2,"yd","Compactor",1,2,"yd","Compactor",1]
[7,2,"yd","Compactor",1,2,"yd","Compactor",1,2,"yd","Compactor",1]
[8,3,"yd","Compactor",1,3,"yd","Compactor",1,3,"yd","Compactor",1]
[9,3,"yd","Compactor",1,3,"yd","Compactor",1,3,"yd","Compactor",1]
[10,3,"yd","Compactor",1,3,"yd","Compactor",1,3,"yd","Compactor",1]
[11,3,"yd","Compactor",1,3,"yd","Compactor",1,3,"yd","Compactor",1]
[12,4,"yd","Compactor",1,4,"yd","Compactor",1,4,"yd","Compactor",1]
[13,2,"yd","Compactor",2,2,"yd","Compactor",2,2,"yd","Compactor",2]
[14,3,"yd","Compactor",2,3,"yd","Compactor",2,3,"yd","Compactor",2]
[15,3,"yd","Compactor",2,3,"yd","Compactor",2,3,"yd","Compactor",2]
[16,3,"yd","Compactor",2,3,"yd","Compactor",2,3,"yd","Compactor",2]
[17,3,"yd","Compactor",2,3,"yd","Compactor",2,3,"yd","Compactor",2]
[18,3,"yd","Compactor",2,3,"yd","Compactor",2,3,"yd","Compactor",2]
[19,3,"yd","Compactor",2,3,"yd","Compactor",2,3,"yd","Compactor",2]
[20,4,"yd","Compactor",2,4,"yd","Compactor",2,4,"yd","Compactor",2]
[21,4,"yd","Compactor",2,4,"yd","Compactor",2,4,"yd","Compactor",2]
[22,4,"yd","Compactor",2,4,"yd","Compactor",2,4,"yd","Compactor",2]
[23,4,"yd","Compactor",2,4,"yd","Compactor",2,4,"yd","Compactor",2]
[24,4,"yd","Compactor",2,4,"yd","Compactor",2,4,"yd","Compactor",2]
[25,4,"yd","Compactor",2,4,"yd","Compactor",2,4,"yd","Compactor",2]
[26,3,"yd","Compactor",3,3,"yd","Compactor",3,3,"yd","Compactor",3]
[27,3,"yd","Compactor",3,3,"yd","Compactor",3,3,"yd","Compactor",3]
[28,10,"yd","Compactor",1,10,"yd","Compactor",1,10,"yd","Compactor",1]
[29,10,"yd","Compactor",1,10,"yd","Compactor",1,10,"yd","Compactor",1]
[30,10,"yd","Compactor",1,10,"yd","Compactor",1,10,"yd","Compactor",1]
[31,10,"yd","Compactor",1,10,"yd","Compactor",1,10,"yd","Compactor",1]
[32,10,"yd","Compactor",1,10,"yd","Compactor",1,10,"yd","Compactor",1]
[{"$f":"+A37+1","v":33},15,"yd","Compactor",1,15,"yd","Compactor",1,15,"yd","Compactor",1]
[34,15,"yd","Compactor",1,15,"yd","Compactor",1,15,"yd","Compactor",1]
[35,15,"yd","Compactor",1,15,"yd","Compactor",1,15,"yd","Compactor",1]
[36,15,"yd","Compactor",1,15,"yd","Compactor",1,15,"yd","Compactor",1]
[37,15,"yd","Compactor",1,15,"yd","Compactor",1,15,"yd","Compactor",1]
[38,15,"yd","Compactor",1,15,"yd","Compactor",1,15,"yd","Compactor",1]
[39,15,"yd","Compactor",1,15,"yd","Compactor",1,15,"yd","Compactor",1]
[40,15,"yd","Compactor",1,15,"yd","Compactor",1,15,"yd","Compactor",1]
[41,15,"yd","Compactor",1,15,"yd","Compactor",1,15,"yd","Compactor",1]
[42,15,"yd","Compactor",1,15,"yd","Compactor",1,15,"yd","Compactor",1]
[43,15,"yd","Compactor",1,15,"yd","Compactor",1,15,"yd","Compactor",1]
[44,15,"yd","Compactor",1,15,"yd","Compactor",1,15,"yd","Compactor",1]
[45,15,"yd","Compactor",1,15,"yd","Compactor",1,15,"yd","Compactor",1]
[46,15,"yd","Compactor",1,15,"yd","Compactor",1,15,"yd","Compactor",1]
[47,15,"yd","Compactor",1,15,"yd","Compactor",1,15,"yd","Compactor",1]
[48,15,"yd","Compactor",1,15,"yd","Compactor",1,15,"yd","Compactor",1]
[49,20,"yd","Compactor",1,20,"yd","Compactor",1,20,"yd","Compactor",1]
[50,20,"yd","Compactor",1,20,"yd","Compactor",1,20,"yd","Compactor",1]
[51,20,"yd","Compactor",1,20,"yd","Compactor",1,20,"yd","Compactor",1]
[52,20,"yd","Compactor",1,20,"yd","Compactor",1,20,"yd","Compactor",1]
[53,20,"yd","Compactor",1,20,"yd","Compactor",1,20,"yd","Compactor",1]
[54,20,"yd","Compactor",1,20,"yd","Compactor",1,20,"yd","Compactor",1]
[55,20,"yd","Compactor",1,20,"yd","Compactor",1,20,"yd","Compactor",1]
[56,20,"yd","Compactor",1,20,"yd","Compactor",1,20,"yd","Compactor",1]
[57,20,"yd","Compactor",1,20,"yd","Compactor",1,20,"yd","Compactor",1]
[58,20,"yd","Compactor",1,20,"yd","Compactor",1,20,"yd","Compactor",1]
[59,20,"yd","Compactor",1,20,"yd","Compactor",1,20,"yd","Compactor",1]
[60,20,"yd","Compactor",1,20,"yd","Compactor",1,20,"yd","Compactor",1]
[61,20,"yd","Compactor",1,20,"yd","Compactor",1,20,"yd","Compactor",1]
[62,20,"yd","Compactor",1,20,"yd","Compactor",1,20,"yd","Compactor",1]
[63,25,"yd","Compactor",1,25,"yd","Compactor",1,25,"yd","Compactor",1]
[64,25,"yd","Compactor",1,25,"yd","Compactor",1,25,"yd","Compactor",1]
[{"$f":"+A69+1","v":65},25,"yd","Compactor",1,25,"yd","Compactor",1,25,"yd","Compactor",1]
[66,25,"yd","Compactor",1,25,"yd","Compactor",1,25,"yd","Compactor",1]
[67,25,"yd","Compactor",1,25,"yd","Compactor",1,25,"yd","Compactor",1]
[68,25,"yd","Compactor",1,25,"yd","Compactor",1,25,"yd","Compactor",1]
[69,25,"yd","Compactor",1,25,"yd","Compactor",1,25,"yd","Compactor",1]
[70,25,"yd","Compactor",1,25,"yd","Compactor",1,25,"yd","Compactor",1]
[71,25,"yd","Compactor",1,25,"yd","Compactor",1,25,"yd","Compactor",1]
[72,25,"yd","Compactor",1,25,"yd","Compactor",1,25,"yd","Compactor",1]
[73,25,"yd","Compactor",1,25,"yd","Compactor",1,25,"yd","Compactor",1]
[74,25,"yd","Compactor",1,25,"yd","Compactor",1,25,"yd","Compactor",1]
[75,25,"yd","Compactor",1,25,"yd","Compactor",1,25,"yd","Compactor",1]
[76,25,"yd","Compactor",1,25,"yd","Compactor",1,25,"yd","Compactor",1]
[77,30,"yd","Compactor",1,30,"yd","Compactor",1,25,"yd","Compactor",2]
[78,30,"yd","Compactor",1,30,"yd","Compactor",1,25,"yd","Compactor",2]
[79,30,"yd","Compactor",1,30,"yd","Compactor",1,25,"yd","Compactor",2]
[80,30,"yd","Compactor",1,30,"yd","Compactor",1,25,"yd","Compactor",2]
[81,30,"yd","Compactor",1,30,"yd","Compactor",1,25,"yd","Compactor",2]
[82,30,"yd","Compactor",1,30,"yd","Compactor",1,25,"yd","Compactor",2]
[83,30,"yd","Compactor",1,30,"yd","Compactor",1,25,"yd","Compactor",2]
[84,30,"yd","Compactor",1,30,"yd","Compactor",1,25,"yd","Compactor",2]
[85,30,"yd","Compactor",1,30,"yd","Compactor",1,25,"yd","Compactor",2]
[86,30,"yd","Compactor",1,30,"yd","Compactor",1,25,"yd","Compactor",2]
[87,30,"yd","Compactor",1,30,"yd","Compactor",1,25,"yd","Compactor",2]
[88,30,"yd","Compactor",1,30,"yd","Compactor",1,25,"yd","Compactor",2]
[89,30,"yd","Compactor",1,30,"yd","Compactor",1,25,"yd","Compactor",2]
[90,30,"yd","Compactor",1,30,"yd","Compactor",1,25,"yd","Compactor",2]
[91,30,"yd","Compactor",1,30,"yd","Compactor",1,25,"yd","Compactor",2]
[92,30,"yd","Compactor",1,30,"yd","Compactor",1,25,"yd","Compactor",2]
[93,30,"yd","Compactor",1,30,"yd","Compactor",1,25,"yd","Compactor",2]
[94,30,"yd","Compactor",1,34,"yd","Compactor",1,25,"yd","Compactor",2]
[95,30,"yd","Compactor",2,34,"yd","Compactor",1,25,"yd","Compactor",2]
[96,30,"yd","Compactor",2,34,"yd","Compactor",1,25,"yd","Compactor",2]
[97,30,"yd","Compactor",2,34,"yd","Compactor",1,25,"yd","Compactor",2]
[98,30,"yd","Compactor",2,34,"yd","Compactor",1,25,"yd","Compactor",2]
[99,30,"yd","Compactor",2,34,"yd","Compactor",1,25,"yd","Compactor",2]
[100,30,"yd","Compactor",2,34,"yd","Compactor",1,25,"yd","Compactor",2]
[{"$f":"+A105+1","v":101},30,"yd","Compactor",1,34,"yd","Compactor",1,25,"yd","Compactor",2]
[102,30,"yd","Compactor",1,34,"yd","Compactor",1,25,"yd","Compactor",2]
[103,30,"yd","Compactor",1,34,"yd","Compactor",1,25,"yd","Compactor",2]
[104,30,"yd","Compactor",1,34,"yd","Compactor",1,25,"yd","Compactor",2]
[105,30,"yd","Compactor",1,34,"yd","Compactor",1,25,"yd","Compactor",2]
[106,30,"yd","Compactor",1,34,"yd","Compactor",1,25,"yd","Compactor",2]
[107,30,"yd","Compactor",1,34,"yd","Compactor",1,25,"yd","Compactor",2]
[108,30,"yd","Compactor",1,34,"yd","Compactor",1,25,"yd","Compactor",2]
[109,30,"yd","Compactor",1,34,"yd","Compactor",1,25,"yd","Compactor",2]
[110,30,"yd","Compactor",1,34,"yd","Compactor",1,25,"yd","Compactor",2]