{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Multifamily"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"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":"Multifamily","index":0,"n_rows":60,"n_cols":17,"rows_kept":60,"cut":false,"hidden":false,"merged":[[44,12,48,18],[39,11,39,18],[37,2,38,17],[41,15,42,15],[41,12,42,14],[41,6,42,6],[41,2,42,5],[59,2,64,6],[39,1,39,9],[46,1,46,9],[56,2,56,6],[25,4,25,5],[50,2,51,2],[52,2,55,2],[33,7,33,8],[33,5,34,6],[33,2,34,4],[24,9,26,9],[48,2,48,6],[34,7,34,8],[27,2,28,2],[29,2,32,2],[12,2,13,2],[14,2,17,2],[22,1,22,9],[24,2,24,8],[25,2,26,2],[25,3,26,3],[25,6,25,7],[18,9,19,9],[18,2,19,4],[18,5,19,8],[25,8,26,8],[0,4,2,9],[7,1,7,9],[9,2,9,8],[9,9,11,9],[10,2,11,2],[10,3,11,3],[10,6,10,7],[10,8,11,8],[3,1,3,11],[5,1,5,4],[10,4,10,5]]}
[null,null,null,null,"Multifamily Property\nService Capacity Calculator"]
[]
[]
[null,"PURPOSE: Determine if a multifamily property's recycling service meets ordinance requirements."]
[]
[null,"1. Enter number of dwelling units:",null,null,null,500]
[]
[null,"2. Complete one line below for each type of trash container."]
[]
[null,null,"Exterior TRASH Containers",null,null,null,null,null,null,"Weekly\nService\nCapacity\n(cu yd/wk)"]
[null,null,"Type","Number","Container Size",null,"No. of Services",null,"Compaction\nRate*"]
[null,null,null,null,"gallons","cubic\nyards","per\nweek","per\nyear"]
[null,null,"Carts",null,null,null,null,null,null,{"$f":"(D13*E13*G13/202)*IF(ISNUMBER(I13),I13,1)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"(D14*E14*G14/202)*IF(ISNUMBER(I14),I14,1)","v":0}]
[null,null,"Dumpster,\nRoll-off,\nCompactor,\nOther",null,null,null,null,null,null,{"$f":"(D15*F15*G15)*IF(ISNUMBER(I15),I15,1)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"(D16*F16*G16)*IF(ISNUMBER(I16),I16,1)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"(D17*F17*H17/52)*IF(ISNUMBER(I17),I17,1)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"(D18*F18*H18/52)*IF(ISNUMBER(I18),I18,1)","v":0}]
[null,null,"*Enter 3 or 4 for compactors; 1 for noncompacting containers",null,null,"Total weekly trash service capacity",null,null,null,{"$f":"SUM(J13:J18)","v":0}]
[]
[null,null,null,{"$f":"SUM(D13:D18)","v":0}]
[]
[null,"3. Complete one line below for each type & size of recycling container."]
[]
[null,null,"Exterior RECYCLING Containers",null,null,null,null,null,null,"Weekly\nService\nCapacity\n(cu yd/wk)"]
[null,null,"Type","Number","Container Size",null,"No. of Services",null,"Compaction\nRate*"]
[null,null,null,null,"gallons","cubic\nyards","per week","per\nyear"]
[null,null,"Carts",null,null,null,null,null,null,{"$f":"(D28*E28*G28/202)*IF(ISNUMBER(I28),I28,1)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"(D29*E29*G29/202)*IF(ISNUMBER(I29),I29,1)","v":0}]
[null,null,"Dumpster,\nRoll-off,\nCompactor,\nOther",null,null,null,null,null,null,{"$f":"(D30*F30*G30)*IF(ISNUMBER(I30),I30,1)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"(D31*F31*G31)*IF(ISNUMBER(I31),I31,1)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"(D32*F32*H32/52)*IF(ISNUMBER(I32),I32,1)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"(D33*F33*H33/52)*IF(ISNUMBER(I33),I33,1)","v":0}]
[null,null,"*Enter 3 or 4 for compactors; 1 for noncompacting containers",null,null,"Weekly recycling service capacity",null,"cubic yards/week",null,{"$f":"SUM(J28:J33)","v":0}]
[null,null,null,null,null,null,null,"gallons/week",null,{"$f":"J34*202","v":0}]
[]
[]
[null,null,"Property must meet one of the two options below:"]
[]
[null,"OPTION 1: Does recycling service meet minimum ordinance requirement of >24 gallons/unit/week? ",null,null,null,null,null,null,null,null,null,"OPTION 2: Does Recycling Service Capacity meet 1:1 ratio requirement?"]
[]
[null,null,"Weekly Recycling Service Capacity\nper Dwelling Unit (gallon/unit/week)",null,null,null,{"$f":"IF(F6>0,202*J34/F6,0)","v":0},"Green value meets requirement",null,null,null,null,"% Recycling Service Capacity",null,null,{"$f":"IF(J19+J34>0,J34/(J19+J34),\"-\")","v":"-"},"Green value exceeds 50%"]
[null,null,null,null,null,null,null,"Red value is less than requirement",null,null,null,null,null,null,null,null,"Red value is less than 50%"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Options for increasing the % Recycling Service Capacity:\n1) Service recycling containers more often or trash containers less\n2) Add more recycling containers or remove some trash containers\n3) Increase recycling container size or decrease trash container size\n4) Combination of these options"]
[]
[null,"5. How many RECYCLING containers will provide at least 24 gallons per unit per week?"]
[null,null,null,null,0.5,1,2]
[null,null,"Number of recycling containers for\ncombinations of size and service frequency"]
[null,null,"Type","Size","Serviced\nonce per 2 weeks","Serviced\nweekly","Serviced\ntwice per week"]
[null,64,"Carts","64 gallon",{"$f":"IF(24*$F$6/(E$48*$B51)<0.5,1,0.49+24*$F$6/(E$48*$B51))","v":375.49},187.99,94.24]
[null,96,null,"96 gallon",250.49,125.49,62.99]
[null,2,"Dumpsters","2 cu yd",{"$f":"IF(24*$F$6/(202*E$48*$B53)<0.5,1,0.49+24*$F$6/(202*E$48*$B53))","v":59.895940594059411},30.192970297029703,15.341485148514852]
[null,3,null,"3 cu yd",40.093960396039606,20.2919801980198,10.390990099009901]
[null,4,null,"4 cu yd",30.192970297029703,15.341485148514852,7.9157425742574263]
[null,6,null,"6 cu yd",20.2919801980198,10.390990099009901,5.4404950495049507]
[null,null,"Red values above are less than the number of trash containers"]
[]
[]
[null,null,"Options for increasing weekly recycling service capacity:\n1) Add more recycling containers\n2) Replace recycling containers with larger containers\n3) Service recycling containers more often\n4) Combination of these options"]