{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sept.2021Multifamily"],"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":"Sept.2021Multifamily","index":0,"n_rows":23,"n_cols":17,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,1,27,5],[0,0,2,5],[3,1,3,15],[5,1,5,4],[10,1,11,1],[12,1,17,1],[18,1,20,1],[7,1,7,5],[8,1,8,2],[8,3,8,5]]}
["Multifamily Property\nService Capacity Calculator"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35]
[]
[null,"Purpose: Calculate the number of recycling containers needed to meet the minimum recycling capacity of 24 gallon per unit per week for multifamily properties with five units or more."]
[]
[null,"1. Enter number of dwelling units:",null,null,null,100]
[null,null,null,null,0.5,1,2]
[null,"Number of recycling containers \nfor combinations of size and service frequency"]
[null,"Container",null,"Frequency"]
[null,"Type","Size","1 time per \n2 weeks","1 time per \nweek","2 times per week"]
[null,"Carts","64 gallon",{"$f":"IF(ROUNDUP(24*$F$6/0.5/64,0)>$Q$2,\"--\",ROUNDUP(24*$F$6/0.5/64,0))","v":"--"},{"$f":"IF(ROUNDUP(24*$F$6/1/64,0)>$Q$2,\"--\",ROUNDUP(24*$F$6/1/64,0))","v":"--"},{"$f":"IF(ROUNDUP(24*$F$6/2/64,0)>$Q$2,\"--\",ROUNDUP(24*$F$6/2/64,0))","v":19}]
[null,null,"96 gallon",{"$f":"IF(ROUNDUP(24*$F$6/0.5/96,0)>$Q$2,\"--\",ROUNDUP(24*$F$6/0.5/96,0))","v":"--"},{"$f":"IF(ROUNDUP(24*$F$6/1/96,0)>$Q$2,\"--\",ROUNDUP(24*$F$6/1/96,0))","v":25},{"$f":"IF(ROUNDUP(24*$F$6/2/96,0)>$Q$2,\"--\",ROUNDUP(24*$F$6/2/96,0))","v":13}]
[null,"Dumpsters","2 cu yd",{"$f":"IF(ROUNDUP(24*$F$6/0.5/201.974/2,0)>$Q$2,\"--\",ROUNDUP(24*$F$6/0.5/201.974/2,0))","v":12},{"$f":"IF(ROUNDUP(24*$F$6/1/201.974/2,0)>$Q$2,\"--\",ROUNDUP(24*$F$6/1/201.974/2,0))","v":6},{"$f":"IF(ROUNDUP(24*$F$6/2/201.974/2,0)>$Q$2,\"--\",ROUNDUP(24*$F$6/2/201.974/2,0))","v":3}]
[null,null,"3 cu yd",{"$f":"IF(ROUNDUP(24*$F$6/0.5/201.974/3,0)>$Q$2,\"--\",ROUNDUP(24*$F$6/0.5/201.974/3,0))","v":8},{"$f":"IF(ROUNDUP(24*$F$6/1/201.974/3,0)>$Q$2,\"--\",ROUNDUP(24*$F$6/1/201.974/3,0))","v":4},{"$f":"IF(ROUNDUP(24*$F$6/2/201.974/3,0)>$Q$2,\"--\",ROUNDUP(24*$F$6/2/201.974/3,0))","v":2}]
[null,null,"4 cu yd",{"$f":"IF(ROUNDUP(24*$F$6/0.5/201.974/4,0)>$Q$2,\"--\",ROUNDUP(24*$F$6/0.5/201.974/4,0))","v":6},{"$f":"IF(ROUNDUP(24*$F$6/1/201.974/4,0)>$Q$2,\"--\",ROUNDUP(24*$F$6/1/201.974/4,0))","v":3},{"$f":"IF(ROUNDUP(24*$F$6/2/201.974/4,0)>$Q$2,\"--\",ROUNDUP(24*$F$6/2/201.974/4,0))","v":2}]
[null,null,"6 cu yd",{"$f":"IF(ROUNDUP(24*$F$6/0.5/201.974/6,0)>$Q$2,\"--\",ROUNDUP(24*$F$6/0.5/201.974/6,0))","v":4},{"$f":"IF(ROUNDUP(24*$F$6/1/201.974/6,0)>$Q$2,\"--\",ROUNDUP(24*$F$6/1/201.974/6,0))","v":2},{"$f":"IF(ROUNDUP(24*$F$6/2/201.974/6,0)>$Q$2,\"--\",ROUNDUP(24*$F$6/2/201.974/6,0))","v":1}]
[null,null,"8 cu yd",{"$f":"IF(ROUNDUP(24*$F$6/0.5/201.974/8,0)>$Q$2,\"--\",ROUNDUP(24*$F$6/0.5/201.974/8,0))","v":3},{"$f":"IF(ROUNDUP(24*$F$6/1/201.974/8,0)>$Q$2,\"--\",ROUNDUP(24*$F$6/1/201.974/8,0))","v":2},{"$f":"IF(ROUNDUP(24*$F$6/2/201.974/8,0)>$Q$2,\"--\",ROUNDUP(24*$F$6/2/201.974/8,0))","v":1}]
[null,null,"10 cu yd",{"$f":"IF(ROUNDUP(24*$F$6/0.5/201.974/10,0)>$Q$2,\"--\",ROUNDUP(24*$F$6/0.5/201.974/10,0))","v":3},{"$f":"IF(ROUNDUP(24*$F$6/1/201.974/10,0)>$Q$2,\"--\",ROUNDUP(24*$F$6/1/201.974/10,0))","v":2},{"$f":"IF(ROUNDUP(24*$F$6/2/201.974/10,0)>$Q$2,\"--\",ROUNDUP(24*$F$6/2/201.974/10,0))","v":1}]
[null,"Other","20 cu yd roll off",{"$f":"IF(ROUNDUP(24*$F$6/0.5/201.974/(20*3),0)>$Q$2,\"--\",ROUNDUP(24*$F$6/0.5/201.974/(20*3),0))","v":1},{"$f":"IF(ROUNDUP(24*$F$6/1/201.974/(20*3),0)>$Q$2,\"--\",ROUNDUP(24*$F$6/1/201.974/(20*3),0))","v":1},{"$f":"IF(ROUNDUP(24*$F$6/2/201.974/(20*3),0)>$Q$2,\"--\",ROUNDUP(24*$F$6/2/201.974/(20*3),0))","v":1}]
[null,null,"30 cu yd roll off",{"$f":"IF(ROUNDUP(24*$F$6/0.5/201.974/20,0)>$Q$2,\"--\",ROUNDUP(24*$F$6/0.5/201.974/20,0))","v":2},{"$f":"IF(ROUNDUP(24*$F$6/1/201.974/20,0)>$Q$2,\"--\",ROUNDUP(24*$F$6/1/201.974/20,0))","v":1},{"$f":"IF(ROUNDUP(24*$F$6/2/201.974/20,0)>$Q$2,\"--\",ROUNDUP(24*$F$6/2/201.974/20,0))","v":1}]
[null,null,"20 cu yd compactor",{"$f":"IF(ROUNDUP(24*$F$6/0.5/201.974/20,0)>$Q$2,\"--\",ROUNDUP(24*$F$6/0.5/201.974/(20*3),0))","v":1},{"$f":"IF(ROUNDUP(24*$F$6/1/201.974/20,0)>$Q$2,\"--\",ROUNDUP(24*$F$6/1/201.974/(20*3),0))","v":1},{"$f":"IF(ROUNDUP(24*$F$6/2/201.974/20,0)>$Q$2,\"--\",ROUNDUP(24*$F$6/2/201.974/(20*3),0))","v":1}]
[]
[null,"Options for increasing recycling capacity:\n1) Add recycling containers\n2) Increase size of recycling containers\n3) Increase frequency of recycling service                               \n4) Combination of these options"]