{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["NoWaste Info","Calculator"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"NoWaste Info","index":0,"n_rows":36,"n_cols":21,"rows_kept":36,"cut":false,"hidden":true,"merged":[[12,12,12,14],[2,9,2,11],[2,12,3,14],[4,12,4,14],[5,12,5,14],[6,12,6,14],[7,12,7,14],[8,12,8,14],[9,12,9,14],[10,12,10,14],[11,12,11,14],[14,12,14,14],[15,12,15,14],[16,12,16,14],[17,12,17,14],[18,12,18,14],[2,17,2,18],[30,12,30,14],[2,7,2,8],[28,7,28,8],[28,9,28,11],[28,12,29,14],[25,12,25,14],[26,12,26,14],[27,12,27,14],[19,12,19,14],[20,12,20,14],[21,12,21,14],[22,12,22,14],[23,12,23,14],[24,12,24,14],[13,12,13,14],[31,12,31,14],[32,12,32,14],[33,12,33,14],[34,12,34,14],[35,12,35,14],[13,20,13,22],[2,20,3,22],[4,20,4,22],[5,20,5,22],[6,20,6,22],[7,20,7,22],[8,20,8,22],[9,20,9,22],[10,20,10,22],[11,20,11,22],[12,20,12,22],[25,20,25,22],[14,20,14,22],[15,20,15,22],[16,20,16,22],[17,20,17,22],[18,20,18,22],[19,20,19,22],[20,20,20,22],[21,20,21,22],[22,20,22,22],[23,20,23,22],[24,20,24,22],[26,20,26,22],[27,20,27,22],[28,17,28,18],[28,20,29,22],[30,20,30,22],[31,20,31,22],[32,20,32,22],[33,20,33,22],[34,20,34,22],[35,20,35,22]]}
["Standard allocations for waste and recycling",null,null,null,null,null,null,"Standard waste hopper and service frequency allocations",null,null,null,null,null,null,null,null,null,"Standard recycling hopper and service frequency allocations"]
[]
["Type of unit","Waste \n(litres/week)","Reyclables \n(litres/week)",null,null,null,null,"Calculated waste volume \n(litres/week)",null,"Waste hopper quantity",null,null,"Service frequency*",null,null,null,null,"Calculated waste volume \n(litres/week)",null,"Hoppers","Service frequency*"]
["1 bedroom or studio unit",80,70,null,null,null,null,"Minimum","Maximum","1.5 m3","2 m3","3m3",null,null,null,null,null,"Minimum","Maximum","1,100L"]
["1 bedroom with separate study room",90,80,null,null,null,{"$f":"IF(AND(H5<$B$15,I5>=$B$15),1,0)","v":0},0,1650,1,null,null,"Weekly",null,null,null,{"$f":"IF(AND(R5<$B$16,S5>=$B$16),1,0)","v":0},0,1100,1,"Weekly"]
["2 bedroom unit",100,90,null,null,null,{"$f":"IF(AND(H6<=$B$15,I6>=$B$15),1,0)","v":0},1651,2250,null,1,null,"Weekly",null,null,null,{"$f":"IF(AND(R6<=$B$16,S6>=$B$16),1,0)","v":0},1101,2200,2,"Weekly"]
["3 bedroom unit",120,110,null,null,null,0,2251,3350,null,null,1,"Weekly",null,null,null,0,2201,3300,3,"Weekly"]
["4 bedroom unit or greater",140,120,null,null,null,0,3351,3800,1,1,null,"Weekly",null,null,null,0,3301,4400,4,"Weekly"]
["Single unit dwelling (SUD)",140,120,null,null,null,0,3801,4350,null,2,null,"Weekly",null,null,null,0,4401,5500,5,"Weekly"]
[null,null,null,null,null,null,0,4351,5350,null,1,1,"Weekly",null,null,null,0,5501,6600,6,"Weekly"]
[null,null,null,null,null,null,0,5351,6350,null,null,2,"Weekly",null,null,null,0,6601,7700,7,"Weekly"]
[null,null,null,null,null,null,0,6351,7350,1,1,null,"Twice weekly",null,null,null,0,7701,8800,8,"Weekly"]
[null,null,null,null,null,null,0,7351,8350,null,2,null,"Twice weekly",null,null,null,0,8801,9900,9,"Weekly"]
[null,null,null,null,null,null,0,8351,10350,null,1,1,"Twice weekly",null,null,null,0,9901,11000,5,"Twice weekly"]
["Calculated waste",{"$f":"Calculator!$F$14","v":0},null,null,null,null,0,10351,12350,null,null,2,"Twice weekly",null,null,null,0,11001,13200,6,"Twice weekly"]
["Calculated recycling",{"$f":"Calculator!$I$14","v":0},null,null,null,null,0,12351,13350,1,1,1,"Twice weekly",null,null,null,0,13201,15400,7,"Twice weekly"]
[null,null,null,null,null,null,0,13351,14350,null,2,1,"Twice weekly",null,null,null,0,15401,17600,8,"Twice weekly"]
[null,null,null,null,null,null,0,14351,16350,null,1,2,"Twice weekly",null,null,null,0,17601,19800,9,"Twice weekly"]
[null,null,null,null,null,null,0,16351,18350,null,null,3,"Twice weekly",null,null,null,0,19801,22000,10,"Twice weekly"]
[null,null,null,null,null,null,0,18351,20350,null,2,2,"Twice weekly",null,null,null,0,22001,23100,7,"Three times/week (see note 2)"]
[null,null,null,null,null,null,0,20351,22350,null,1,3,"Twice weekly",null,null,null,0,23101,26400,8,"Three times/week (see note 2)"]
[null,null,null,null,null,null,0,22351,25000,null,1,2,"Three times/week (see note 2)",null,null,null,0,26401,29700,9,"Three times/week (see note 2)"]
[null,null,null,null,null,null,0,25001,28000,null,null,3,"Three times/week (see note 2)",null,null,null,0,29701,33000,10,"Three times/week (see note 2)"]
[null,null,null,null,null,null,0,28001,31000,null,2,2,"Three times/week (see note 2)",null,null,null,0,33001,36000,11,"Three times/week (see note 2)"]
[null,null,null,null,null,null,0,31001,34000,null,1,3,"Three times/week (see note 2)",null,null,null,0,36001,999999999,null,"Compactors are required"]
[null,null,null,null,null,null,0,34000,36000,null,null,4,"Three times/week (see note 2)"]
[null,null,null,null,null,null,0,36001,999999999,null,null,null,"Compactors are required"]
[]
[null,null,null,null,null,null,null,"Calculated waste volume \n(litres/week)",null,"Waste hopper quantity",null,null,"Service frequency*",null,null,null,null,"Calculated waste volume \n(litres/week)",null,"Hoppers","Service frequency*"]
[null,null,null,null,null,null,null,"Minimum","Maximum","1.5 m3","2 m3","3m3",null,null,null,null,null,"Minimum","Maximum","1,100L"]
[null,null,null,null,null,null,{"$f":"IF(AND(H31<=$B$15,I31>=$B$15),1,0)","v":0},22351,25000,null,null,4,"Twice weekly",null,null,null,{"$f":"IF(AND(R31<=$B$16,S31>=$B$16),1,0)","v":0},22001,23100,11,"Twice weekly"]
[null,null,null,null,null,null,0,25001,28000,null,1,4,"Twice weekly",null,null,null,0,23101,26400,12,"Twice weekly"]
[null,null,null,null,null,null,0,28001,31000,null,null,5,"Twice weekly",null,null,null,0,26401,29700,14,"Twice weekly"]
[null,null,null,null,null,null,0,31001,34000,null,1,5,"Twice weekly",null,null,null,0,29701,33000,15,"Twice weekly"]
[null,null,null,null,null,null,0,34000,36000,null,null,6,"Twice weekly",null,null,null,0,33001,36000,17,"Twice weekly"]
[null,null,null,null,null,null,0,36001,999999999,null,null,null,"Compactors are required",null,null,null,0,36001,999999999,null,"Compactors are required"]

{"sheet":"Calculator","index":1,"n_rows":40,"n_cols":9,"rows_kept":40,"cut":false,"hidden":false,"merged":[[6,3,6,5],[6,6,6,8],[6,2,7,2],[19,2,20,2],[19,3,19,5],[19,6,20,8],[21,6,21,8],[30,2,31,2],[30,3,30,5],[30,6,31,8],[32,6,32,8],[24,2,25,2],[24,3,24,5],[24,6,25,8],[26,6,26,8],[31,3,31,5],[32,3,32,5],[39,2,44,8],[35,2,36,2],[35,3,35,5],[35,6,36,8],[37,6,37,8],[36,3,36,5],[37,3,37,5]]}
[]
[]
[null,null,null,"Multi-unit residential development"]
[null,null,null,"Shared waste and recycling allocation calculator"]
[]
[]
[null,null,"Type of units by size","Waste (litres/week)",null,null,"Recycling (litres/week)"]
[null,null,null,"Number of units","litres/week per unit","Total litres/week","Number of units","litres/week per unit","Total litres/week"]
[null,null,"1 bedroom or studio unit",null,{"$f":"VLOOKUP($C9,Type_of_unit,2,FALSE)","v":80},{"$f":"IFERROR(D9*E9,0)","v":0},{"$f":"IF(D9=\"\",\"\",D9)","v":""},{"$f":"VLOOKUP($C9,Type_of_unit,3,FALSE)","v":70},{"$f":"IFERROR(G9*H9,0)","v":0}]
[null,null,"1 bedroom with separate study room",null,{"$f":"VLOOKUP($C10,Type_of_unit,2,FALSE)","v":90},{"$f":"IFERROR(D10*E10,0)","v":0},{"$f":"IF(D10=\"\",\"\",D10)","v":""},{"$f":"VLOOKUP($C10,Type_of_unit,3,FALSE)","v":80},{"$f":"IFERROR(G10*H10,0)","v":0}]
[null,null,"2 bedroom unit",null,{"$f":"VLOOKUP($C11,Type_of_unit,2,FALSE)","v":100},0,"",{"$f":"VLOOKUP($C11,Type_of_unit,3,FALSE)","v":90},0]
[null,null,"3 bedroom unit",null,{"$f":"VLOOKUP($C12,Type_of_unit,2,FALSE)","v":120},0,"",{"$f":"VLOOKUP($C12,Type_of_unit,3,FALSE)","v":110},0]
[null,null,"4 bedroom unit or greater",null,{"$f":"VLOOKUP($C13,Type_of_unit,2,FALSE)","v":140},0,"",{"$f":"VLOOKUP($C13,Type_of_unit,3,FALSE)","v":120},0]
[null,null,"Total calculated waste",null,null,{"$f":"SUM(F9:F13)","v":0},null,null,{"$f":"SUM(I9:I13)","v":0}]
[null,null,"*NB: Standard allocations updated as of 1 February 2019"]
[null,null,"*NB: If the calculated waste volume in litres/week exceeds 36,000, compactors MUST be used."]
[]
[null,null,"Shared waste allocation calculated as per assumptions above"]
[]
[null,null,"Calculated waste volume \n(litres/week)","Waste hopper quantity",null,null,"Service frequency*"]
[null,null,null,"1.5 m3","2 m3","3m3"]
[null,null,{"$f":"F14","v":0},{"$f":"IFERROR(VLOOKUP(1,'NoWaste Info'!$G$5:$O$27,4,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(1,'NoWaste Info'!$G$5:$O$27,5,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(1,'NoWaste Info'!$G$5:$O$27,6,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(1,'NoWaste Info'!$G$5:$O$27,7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(1,'NoWaste Info'!$G$5:$O$27,7,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(1,'NoWaste Info'!$G$5:$O$27,7,FALSE),0)","v":0}]
[]
[null,null,"Scenario 2 (only applicable to total calculated waste volume greater than 22,351 litres/week)"]
[null,null,"Calculated waste volume \n(litres/week)","Waste hopper quantity",null,null,"Service frequency*"]
[null,null,null,"1.5 m3","2 m3","3m3"]
[null,null,{"$f":"IF(F14>='NoWaste Info'!H31,F14,0)","v":0},{"$f":"IFERROR(VLOOKUP(1,'NoWaste Info'!$G$31:$O$36,4,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(1,'NoWaste Info'!$G$31:$O$36,5,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(1,'NoWaste Info'!$G$31:$O$36,6,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(1,'NoWaste Info'!$G$31:$O$36,7,FALSE),\"\")","v":""},{"$f":"VLOOKUP(1,'NoWaste Info'!$G$31:$O$36,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(1,'NoWaste Info'!$G$31:$O$36,6,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"Shared recycling allocation calculated as per assumptions above"]
[]
[null,null,"Calculated recycling volume \n(litres/week)","Recycling hopper quantity",null,null,"Service frequency*"]
[null,null,null,"1,100L"]
[null,null,{"$f":"I14","v":0},{"$f":"IFERROR(VLOOKUP(1,'NoWaste Info'!$Q$5:$W$27,4,FALSE),0)","v":0},null,null,{"$f":"IFERROR(VLOOKUP(1,'NoWaste Info'!$Q$5:$W$27,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(1,'NoWaste Info'!$G$5:$O$27,7,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(1,'NoWaste Info'!$G$5:$O$27,7,FALSE),0)","v":0}]
[]
[null,null,"Scenario 2 (only applicable to total calculated recycling volume greater than 22,001 litres/week)"]
[null,null,"Calculated recycling volume \n(litres/week)","Recycling hopper quantity",null,null,"Service frequency*"]
[null,null,null,"1,100L"]
[null,null,{"$f":"IF(I14>='NoWaste Info'!R31,I14,0)","v":0},{"$f":"IFERROR(VLOOKUP(1,'NoWaste Info'!$Q$31:$W$36,4,FALSE),0)","v":0},null,null,{"$f":"IFERROR(VLOOKUP(1,'NoWaste Info'!$Q$31:$W$36,5,FALSE),\"\")","v":""},{"$f":"VLOOKUP(1,'NoWaste Info'!$G$31:$O$36,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(1,'NoWaste Info'!$G$31:$O$36,6,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"*Note 1: This calculator does not apply if the option of shared MGBs with kerbside collection is available. \n*Note 2: Developments where sufficient waste is generated as per the above may be entitled to three (3) times a week collection only in those areas where three (3) times a week collection is already provided. Availability of this limited service is subject to operational considerations and may not be available in all areas.  Three (3) times a week collection requires Place Coordination’s approval in writing at the pre-application stage. In cases where a three (3) times a week collection cannot be provided, the development must be able to accommodate sufficient waste and recycling storage space to accommodate twice a week collection."]