{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Jan2024MultifamilyCompost","Sheet1"],"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":"Jan2024MultifamilyCompost","index":0,"n_rows":42,"n_cols":19,"rows_kept":42,"cut":false,"hidden":false,"merged":[[41,2,43,8],[0,1,2,6],[12,1,12,5],[11,1,11,5],[3,1,4,8],[27,4,27,6],[6,1,6,8],[9,1,9,8],[7,1,7,8],[8,1,8,8],[27,2,27,3],[21,2,21,3],[16,4,16,6],[19,4,19,6],[22,4,22,6],[23,4,23,6],[20,4,20,6],[21,4,21,6],[28,2,28,3],[29,2,29,3],[15,2,15,6],[28,4,28,6],[29,4,29,6],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[16,2,16,3],[19,2,19,3],[20,2,20,3],[24,4,24,6],[25,4,25,6],[37,2,39,8],[26,4,26,6],[31,2,31,9],[34,2,34,9],[32,2,33,9]]}
[null,"Multifamily Compost\nService Calculator"]
[]
[]
[null,"Purpose: Calculate the number and type of containers suggested to meet the minimum compost capacity of 1 gallon per unit per week at your property. You are required to offer your residents and employees convenient access to compost containers within 25 feet of all landfill trash containers. ",null,null,null,null,null,null,null,null,null,null,null,null,null,1,"required compost gallons/unit/week"]
[]
[]
[null,"Instructions: \n"]
[null," 1. Enter total number of dwelling units in the yellow box. "]
[null," 2. Enter the number of waste collection stations in the blue box. "]
[null," 3. The suggested number and size of compost containers will display in the green section. "]
[]
[null,"1. Enter number of dwelling units:",null,null,null,null,20]
[null,"2. Enter number of waste collection locations:",null,null,null,null,5,null,null,null,null,null,null,null,null,4,"compaction ratio"]
[]
[null,null,"Suggested Size and Number of Containers: ",null,null,null,0.5,1]
[null,null,"You can use a combination of carts, drums, buckets and/or  dumpster containers, as offered by your hauler. Work with your hauler to find a combination that works best for your property.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,100000,"maximum recommended compost containers"]
[null,null,"Container",null,"Recommended # of Containers",null,null,null,null,null,"actual gallons","actual gallons/unit/week",null,null,null,100000,"maximum recommended gallons/units/week of compost"]
[null,null,null,1,1]
[null,null,null,"1 time per \nweek","1 time per \nweek"]
[null,5,"5 gallon bucket",null,{"$f":"IF(OR(L20>$P$20,ROUNDUP($P$4*$G$12/E$18/$B20,0)>$R$16),\"--\",MAX(ROUNDUP($P$4*$G$12/E$18/$B20,0),$G$13))","v":5},null,null,null,null,null,{"$f":"IF(ROUNDUP($P$4*$G$12/E$18/$B20,0)>$R$16,\"--\",MAX(ROUNDUP($P$4*$G$12/E$18/$B20,0),$G$13))*B20*$E$18","v":25},{"$f":"K20/$G$12","v":1.25},null,null,null,5,"maximum recommended gallons/units/week of compost"]
[null,36,"36 gallon cart",null,{"$f":"IF(OR(L21>$P$20,ROUNDUP($P$4*$G$12/E$18/$B21,0)>$R$16),\"--\",MAX(ROUNDUP($P$4*$G$12/E$18/$B21,0),$G$13))","v":"--"},null,null,null,null,null,{"$f":"IF(ROUNDUP($P$4*$G$12/E$18/$B21,0)>$R$16,\"--\",MAX(ROUNDUP($P$4*$G$12/E$18/$B21,0),$G$13))*B21*$E$18","v":180},{"$f":"K21/$G$12","v":9}]
[null,55,"55 gallon drum",null,{"$f":"IF(OR(L22>$P$20,ROUNDUP($P$4*$G$12/E$18/$B22,0)>$R$16),\"--\",MAX(ROUNDUP($P$4*$G$12/E$18/$B22,0),$G$13))","v":"--"},null,null,null,null,null,{"$f":"IF(ROUNDUP($P$4*$G$12/E$18/$B22,0)>$R$16,\"--\",MAX(ROUNDUP($P$4*$G$12/E$18/$B22,0),$G$13))*B22*$E$18","v":275},13.75]
[null,64,"64 gallon cart",null,{"$f":"IF(OR(L23>$P$20,ROUNDUP($P$4*$G$12/E$18/$B23,0)>$R$16),\"--\",MAX(ROUNDUP($P$4*$G$12/E$18/$B23,0),$G$13))","v":"--"},null,null,null,null,null,{"$f":"IF(ROUNDUP($P$4*$G$12/E$18/$B23,0)>$R$16,\"--\",MAX(ROUNDUP($P$4*$G$12/E$18/$B23,0),$G$13))*B23*$E$18","v":320},16]
[null,96,"96 gallon cart",null,{"$f":"IF(OR(L24>$P$20,ROUNDUP($P$4*$G$12/E$18/$B24,0)>$R$16),\"--\",MAX(ROUNDUP($P$4*$G$12/E$18/$B24,0),$G$13))","v":"--"},null,null,null,null,null,{"$f":"IF(ROUNDUP($P$4*$G$12/E$18/$B24,0)>$R$16,\"--\",MAX(ROUNDUP($P$4*$G$12/E$18/$B24,0),$G$13))*B24*$E$18","v":480},24]
[null,2,"2 cu yd dumpster",null,{"$f":"IF(OR(L25>$P$20,(E$18*201.974*($B25))/$G$12>$P$17,ROUNDUP($P$4*$G$12/E$18/201.974/($B25),0)>$R$16),\"--\",MAX(ROUNDUP($P$4*$G$12/E$18/201.974/($B25),0),$G$13))","v":"--"},null,null,null,null,201.97399999999999,{"$f":"MAX(ROUNDUP($P$4*$G$12/E$18/201.974/($B25),0),$G$13)*B25*J25","v":2019.7399999999998},{"$f":"K25/$G$12","v":100.98699999999999}]
[null,3,"3 cu yd dumpster",null,{"$f":"IF(OR(L26>$P$20,(E$18*201.974*($B26))/$G$12>$P$17,ROUNDUP($P$4*$G$12/E$18/201.974/($B26),0)>$R$16),\"--\",MAX(ROUNDUP($P$4*$G$12/E$18/201.974/($B26),0),$G$13))","v":"--"},null,null,null,null,201.97399999999999,{"$f":"MAX(ROUNDUP($P$4*$G$12/E$18/201.974/($B26),0),$G$13)*B26*J26","v":3029.6099999999997},{"$f":"K26/$G$12","v":151.48049999999998}]
[null,4,"4 cu yd dumpster",null,{"$f":"IF(OR(L27>$P$20,(E$18*201.974*($B27))/$G$12>$P$17,ROUNDUP($P$4*$G$12/E$18/201.974/($B27),0)>$R$16),\"--\",MAX(ROUNDUP($P$4*$G$12/E$18/201.974/($B27),0),$G$13))","v":"--"},null,null,null,null,201.97399999999999,{"$f":"MAX(ROUNDUP($P$4*$G$12/E$18/201.974/($B27),0),$G$13)*B27*J27","v":4039.4799999999996},201.97399999999999]
[null,6,"6 cu yd dumpster",null,{"$f":"IF(OR(L28>$P$20,(E$18*201.974*($B28))/$G$12>$P$17,ROUNDUP($P$4*$G$12/E$18/201.974/($B28),0)>$R$16),\"--\",MAX(ROUNDUP($P$4*$G$12/E$18/201.974/($B28),0),$G$13))","v":"--"},null,null,null,null,201.97399999999999,{"$f":"MAX(ROUNDUP($P$4*$G$12/E$18/201.974/($B28),0),$G$13)*B28*J28","v":6059.2199999999993},302.96099999999996]
[null,20,"20 cu yd compactor",null,{"$f":"IF(OR(L29>$P$20,(1*201.974*($B29*$P$13))/$G$12>$P$17,ROUNDUP($P$4*$G$12/1/201.974/($B29*$P$13),0)>$R$16),\"--\",MAX(ROUNDUP($P$4*$G$12/1/201.974/($B29*$P$13),0),$G$13))","v":"--"},null,null,null,null,201.97399999999999,{"$f":"MAX(ROUNDUP($P$4*$G$12/1/201.974/($B29*$P$13),0),$G$13)*B29*$P$13*J29","v":80789.599999999991},4039.4799999999996]
[null,30,"30 cu yd compactor",null,{"$f":"IF(OR(L30>$P$20,(1*201.974*($B30*$P$13))/$G$12>$P$17,ROUNDUP($P$4*$G$12/1/201.974/($B30*$P$13),0)>$R$16),\"--\",MAX(ROUNDUP($P$4*$G$12/1/201.974/($B30*$P$13),0),$G$13))","v":"--"},null,null,null,null,201.97399999999999,{"$f":"MAX(ROUNDUP($P$4*$G$12/1/201.974/($B30*$P$13),0),$G$13)*B30*$P$13*J30","v":121184.4},6059.2199999999993]
[]
[null,null,"What is a Waste Collection Station? "]
[null,null,"A waste collection station is an area where residents and staff can dispose of their landfill trash. You are required to have access to compost and recycling within 25 feet of all landfill trash containers."]
[]
[null,null,"     - Examples include: External dumpsters, trash chutes and trash rooms. "]
[]
[null,null,"Do I need to pay for this many containers to be serviced?"]
[null,null,"No, but you are required to offer compost and recycling collection at each waste station. This material can be emptied into a larger, outdoor container that is serviced by your hauler each week. "]
[]
[]
[]
[null,null,"These are suggestions for meeting the composting requirements. For questions: email CommercialRecycling@AustinTexas.gov"]

{"sheet":"Sheet1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}