{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Data Input (3)","Data Input"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":0,"comments":2,"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":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"Brewers Association On-Site Waste Management Tool"]
[null,"Guidance  / Instructions"]
[]
[null,"Overview"]
[null,"This tool is designed to help evaluate cost effective waste management options."]
[]
[null,"The flow of the tool has been designed to allow the operator to move freely through the tool without the use of a guidance document.  However, this tool is designed for multiple skill set levels and some individuals may require additional assistance.  It is important to work through the tool in the order suggested as results are often accumulated through the various worksheets."]
[]
[null,"To use the tool, please adhere to the following recommendations:"]
[]
[null,"The tool will only function properly if the macros are enabled."]
[]
[null,"Fields that may be edited by the user are shaded in light gray with a black font.  Often, these fields may be pre-populated with a drop-down cell. If you do not see an option in the drop down that is applicable to your operations, select \"Other\". Once you have selected \"Other\" simply enter the appropriate information. Note: Fields that are not shaded in light gray should not be modified for general use.  If the cell is not applicable, leave it blank or enter \"0\".  "]
[]
[null,"To navigate from one area to another click on any Icon in the workbook or select the worksheet at the bottom of this tool."]

{"sheet":"Data Input (3)","index":1,"n_rows":54,"n_cols":28,"rows_kept":54,"cut":false,"hidden":true,"merged":[[35,3,35,4],[43,3,43,4],[44,3,44,4],[37,3,37,4],[38,3,38,4],[39,3,39,4],[40,3,40,4],[41,3,41,4],[42,3,42,4],[36,3,36,4],[51,5,51,8],[16,19,16,23],[22,1,22,3],[22,13,22,16],[31,1,31,6],[31,13,31,18],[33,1,33,2],[33,3,33,4],[33,13,33,14],[34,3,34,4],[32,1,32,2],[32,3,32,4],[32,13,32,14],[16,1,16,3],[16,5,16,8],[16,13,16,16],[10,7,10,8],[11,7,11,8],[12,7,12,8],[14,2,14,3],[14,14,14,16],[1,1,3,8],[8,1,8,3],[8,7,8,8],[8,13,8,16],[9,2,9,3],[9,7,9,8],[9,14,9,16],[5,2,5,3],[6,2,6,3],[7,2,7,3],[4,1,4,3]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Select Unit","Select Yes/No",null,null,null,"Select Option","-","(Select Time Period)","(Select Source)","Select Option",null,"Select Option","-","Select Option","-"]
[null,"Calculating the Costs & Benefits of On-Site Waste Treatment",null,null,null,null,null,null,null,null,null,null,null,"lb","Yes",null,null,null,"Reduced",{"$f":"IF(D35=\"Enter Years\",0,(D41*D14)-D40)","v":0},"Previous Years data","Purchased Electricity","Single Stream",null,"Reduced",{"$f":"IF(F35=\"Enter Years\",0,(F41*D14)-F40)","v":0},"Reduced",{"$f":"IF(G35=\"Enter Years\",0,(G41*D14)-G40)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ton","No",null,null,null,"Recycled Externally",{"$f":"IF(D35=\"Enter Years\",0,(D41*D16)-D40)","v":0},"Year to Date data","Natural Gas","Multi Use",null,"Recycled Externally",{"$f":"IF(F35=\"Enter Years\",0,(F41*D16)-F40)","v":0},"Recycled Externally",{"$f":"IF(G35=\"Enter Years\",0,(G41*D16)-G40)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Previous Month data","Propane"]
[null,"Background information"]
[null,"Name of Brewery","Enter Name"]
[null,"Name of Project","Enter Name"]
[null,"Today's Date","Enter Date"]
[null,"Current Waste Situation",null,null,null,null,"Map Key"]
[null,"Unit of measurement for quantifying waste","Select Unit",null,null,null,"-","Category Description"]
[null,null,"Unit","Quantity",null,null,"-","Operator Input / Drop Down Cells"]
[null,"Amount of waste sent to landfill, per year",{"$f":"IF(C10=\"Select Unit\", \"-\",C10)","v":"-"},"Enter Quantity",null,null,"-","Calculated Value Cells"]
[null,"Cost to dispose waste to landfill, per year","$","Enter Cost",null,null,"-","Automatically Filled Cell"]
[null,"Cost per unit to dispose into landfill","$",{"$f":"IF(D13=\"Enter Cost\",\"-\",(D13/D12))","v":"-"}]
[null,"Current Recycling Option","Select Option"]
[null,null,null,{"$f":"IF(C15=\"Single Stream\",D30,I30)","v":0}]
[null,"Costs Associated with Single Stream Recycling",null,null,null,"Costs/Savings Associated with Multi Stream  Recycling"]
[null,"Amount of waste diverted to recycling , per year",{"$f":"IF(C10=\"Select Unit\", \"-\",C10)","v":"-"},"Enter Quantity",null,null,"Unit","Quantity","Cost/Return"]
[null,"Cost to recycle, per year","$","Enter Cost",null,"Aluminum",{"$f":"IF($C$10=\"Select Unit\", \"-\",$C$10)","v":"-"},"Enter Quantity","Enter Cost/Return"]
[null,null,null,{"$f":"IF(D19=\"Enter Cost\",0,D19)","v":0},null,null,{"$f":"IF($C$10=\"Select Unit\", \"-\",$C$10)","v":"-"},{"$f":"IF(H19=\"Enter Quantity\",0,H19)","v":0},{"$f":"IF(I19=\"Enter Cost/Return\",0,I19)","v":0}]
[null,"Cost per unit to recycle","$",{"$f":"IF(D19=\"Enter Cost\",\"-\",(D19/D18))","v":"-"},null,"Plastics","-","Enter Quantity","Enter Cost/Return"]
[null,null,null,null,null,null,"-",{"$f":"IF(H21=\"Enter Quantity\",0,H21)","v":0},{"$f":"IF(I21=\"Enter Cost/Return\",0,I21)","v":0}]
[null,"Current Rebates Associated with Recycling ",null,null,null,"Glass","-","Enter Quantity","Enter Cost/Return"]
[null,null,null,null,null,null,"-",{"$f":"IF(H23=\"Enter Quantity\",0,H23)","v":0},{"$f":"IF(I23=\"Enter Cost/Return\",0,I23)","v":0}]
[null,"Amount of waste diverted to recycling, per year",{"$f":"IF(C10=\"Select Unit\", \"-\",C10)","v":"-"},"Enter Quantity",null,"Paperboard","-","Enter Quantity","Enter Cost/Return"]
[null,null,null,{"$f":"IF(D25=\"Enter Quantity\",0,D25*-1)","v":0},null,null,"-",{"$f":"IF(H25=\"Enter Quantity\",0,H25)","v":0},{"$f":"IF(I25=\"Enter Cost/Return\",0,I25)","v":0}]
[null,"Total revenue from recycling","$","Enter Return",null,"Other","-","Enter Quantity","Enter Cost/Return"]
[null,null,null,{"$f":"IF(D27=\"Enter Return\",0,D27*-1)","v":0},null,null,"-",{"$f":"IF(H27=\"Enter Quantity\",0,H27)","v":0},{"$f":"IF(I27=\"Enter Cost/Return\",0,I27)","v":0}]
[null,"Revenue per unit to recycle","$",{"$f":"IF(D27=\"Enter Return\",\"-\",(D27/D25))","v":"-"},null,"Totals","-",{"$f":"SUM(H20+H22+H24+H26+H28)","v":0},{"$f":"SUM(I20+I22+I24+I26+I28)","v":0}]
[null,"Cost Per Unit Option 1",null,{"$f":"IF(D18=\"Enter Quantity\",0,(D20+D28)/(D18+D26))","v":0},null,"Cost Per Unit #2",null,null,{"$f":"IF(I29=0,0,I29/H29)","v":0}]
[]
[null,"Proposed Project Comparison "]
[null,"Project options",null,"Option 1",null,"Option 2","Option 3"]
[null,"Enter project name",null,"Enter Name",null,"Enter Name","Enter Name"]
[null,"Expected life of equipment (max 40)","Years","Enter Years",null,"Enter Years","Enter Years"]
[null,"Total cost for project","$","Enter Cost",null,"Enter Cost","Enter Cost"]
[null,"Are there any incentives available? ","Select","Select Yes/No",null,"Select Yes/No","Select Yes/No"]
[null,"If yes, the amount of funding available over life of project","$","Enter Cost",null,"Enter Cost","Enter Cost"]
[null,null,null,{"$f":"IF(D38=\"Enter Cost\",0,D38)","v":0},null,{"$f":"IF(F38=\"Enter Cost\",0,F38)","v":0},{"$f":"IF(G38=\"Enter Cost\",0,G38)","v":0}]
[null,"Additional annual costs - Maintenance, \nchemicals, checks, etc…","$","Enter Cost",null,"Enter Cost","Enter Cost"]
[null,"Amount of waste diverted from landfill, per year",{"$f":"IF(C10=\"Select Unit\", \"-\",C10)","v":"-"},"Enter Quantity",null,"Enter Quantity","Enter Quantity"]
[null,"Is this waste reduced internally or recycled \nexternally?","Option","Select Option",null,"Select Option","Select Option"]
[null,"Cost savings per year","$",{"$f":"VLOOKUP(D42,S1:T3,2,FALSE)","v":"-"},null,{"$f":"VLOOKUP(F42,Y1:Z3,2,FALSE)","v":"-"},{"$f":"VLOOKUP(G42,AA1:AB3,2,FALSE)","v":"-"}]
[null,"Simple payback ","Years",{"$f":"IF(D43=\"-\",\"-\",(D36-D39)/D43)","v":"-"},null,{"$f":"IF(F43=\"-\",\"-\",(F36-F39)/F43)","v":"-"},{"$f":"IF(G43=\"-\",\"-\",(G36-G39)/G43)","v":"-"}]
[null,"Cost savings over life of project","$",{"$f":"IF(D43=\"-\",\"-\",(D43*D35)-D36)","v":"-"},null,{"$f":"IF(F43=\"-\",\"-\",(F43*F35)-F36)","v":"-"},{"$f":"IF(G43=\"-\",\"-\",(G43*G35)-G36)","v":"-"}]
[]
[]
[]
[]
[]
[]
[null,"*Conversion Factors",null,null,null,"Conversion Tool"]
[null,"To convert lbs to tons multiply pounds by .0005",null,null,null,"Enter Amount in Pounds","Pounds",{"$f":"IF(F53=\"Enter Amount in Pounds\",\"-\",F53*0.0005)","v":"-"},"Tons"]
[null,"To convert tons to pounds multiply tons by 2204",null,null,null,"Enter Amount in Tons","Tons",{"$f":"IF(F54=\"Enter Amount in Tons\",\"-\",F54*2204)","v":"-"},"Pounds"]

{"sheet":"Data Input","index":2,"n_rows":54,"n_cols":28,"rows_kept":54,"cut":false,"hidden":false,"merged":[[41,3,41,4],[42,3,42,4],[43,3,43,4],[44,3,44,4],[51,5,51,8],[16,19,16,23],[22,1,22,3],[22,13,22,16],[31,1,31,6],[31,13,31,18],[37,3,37,4],[38,3,38,4],[39,3,39,4],[40,3,40,4],[8,7,8,8],[33,3,33,4],[32,3,32,4],[35,3,35,4],[34,3,34,4],[12,7,12,8],[36,3,36,4],[8,1,8,3],[9,2,9,3],[14,2,14,3],[16,1,16,3],[32,1,32,2],[8,13,8,16],[9,7,9,8],[9,14,9,16],[10,7,10,8],[11,7,11,8],[1,1,3,8],[5,2,5,3],[4,1,4,3],[6,2,6,3],[7,2,7,3],[32,13,32,14],[33,1,33,2],[33,13,33,14],[14,14,14,16],[16,5,16,8],[16,13,16,16]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Select Unit","Select Yes/No",null,null,null,"Select Option","-","(Select Time Period)","(Select Source)","Select Option",null,"Select Option","-","Select Option","-"]
[null,"Calculating the Costs & Benefits of On-Site Waste Treatment",null,null,null,null,null,null,null,null,null,null,null,"lb","Yes",null,null,null,"Reduced",{"$f":"IF(D35=\"Enter Years\",0,(D41*D14)-D40)","v":0},"Previous Years data","Purchased Electricity","Single Stream",null,"Reduced",{"$f":"IF(F35=\"Enter Years\",0,(F41*D14)-F40)","v":0},"Reduced",{"$f":"IF(G35=\"Enter Years\",0,(G41*D14)-G40)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ton","No",null,null,null,"Recycled Externally",{"$f":"IF(D35=\"Enter Years\",0,(D41*D16)-D40)","v":0},"Year to Date data","Natural Gas","Multi Use",null,"Recycled Externally",{"$f":"IF(F35=\"Enter Years\",0,(F41*D16)-F40)","v":0},"Recycled Externally",{"$f":"IF(G35=\"Enter Years\",0,(G41*D16)-G40)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Previous Month data","Propane"]
[null,"Background information"]
[null,"Name of Brewery","Enter Name"]
[null,"Name of Project","Enter Name"]
[null,"Today's Date","Enter Date"]
[null,"Current Waste Situation",null,null,null,null,"Map Key"]
[null,"Unit of measurement for quantifying waste","Select Unit",null,null,null,"-","Category Description"]
[null,null,"Unit","Quantity",null,null,"-","Operator Input / Drop Down Cells"]
[null,"Amount of waste sent to landfill, per year",{"$f":"IF(C10=\"Select Unit\", \"-\",C10)","v":"-"},"Enter Quantity",null,null,"-","Calculated Value Cells"]
[null,"Cost to dispose waste to landfill, per year","$","Enter Cost",null,null,"-","Automatically Filled Cell"]
[null,"Cost per unit to dispose into landfill","$",{"$f":"IF(D13=\"Enter Cost\",\"-\",(D13/D12))","v":"-"}]
[null,"Current Recycling Option","Select Option"]
[null,null,null,{"$f":"IF(C15=\"Single Stream\",D30,I30)","v":0}]
[null,"Costs Associated with Single Stream Recycling",null,null,null,"Costs/Savings Associated with Multi Stream  Recycling"]
[null,"Amount of waste diverted to recycling , per year",{"$f":"IF(C10=\"Select Unit\", \"-\",C10)","v":"-"},"Enter Quantity",null,null,"Unit","Quantity","Cost/Return"]
[null,"Cost to recycle, per year","$","Enter Cost",null,"Aluminum",{"$f":"IF($C$10=\"Select Unit\", \"-\",$C$10)","v":"-"},"Enter Quantity","Enter Cost/Return"]
[null,null,null,{"$f":"IF(D19=\"Enter Cost\",0,D19)","v":0},null,null,{"$f":"IF($C$10=\"Select Unit\", \"-\",$C$10)","v":"-"},{"$f":"IF(H19=\"Enter Quantity\",0,H19)","v":0},{"$f":"IF(I19=\"Enter Cost/Return\",0,I19)","v":0}]
[null,"Cost per unit to recycle","$",{"$f":"IF(D19=\"Enter Cost\",\"-\",(D19/D18))","v":"-"},null,"Plastics","-","Enter Quantity","Enter Cost/Return"]
[null,null,null,null,null,null,"-",{"$f":"IF(H21=\"Enter Quantity\",0,H21)","v":0},{"$f":"IF(I21=\"Enter Cost/Return\",0,I21)","v":0}]
[null,"Current Rebates Associated with Recycling ",null,null,null,"Glass","-","Enter Quantity","Enter Cost/Return"]
[null,null,null,null,null,null,"-",{"$f":"IF(H23=\"Enter Quantity\",0,H23)","v":0},{"$f":"IF(I23=\"Enter Cost/Return\",0,I23)","v":0}]
[null,"Amount of waste diverted to recycling, per year",{"$f":"IF(C10=\"Select Unit\", \"-\",C10)","v":"-"},"Enter Quantity",null,"Paperboard","-","Enter Quantity","Enter Cost/Return"]
[null,null,null,{"$f":"IF(D25=\"Enter Quantity\",0,D25*-1)","v":0},null,null,"-",{"$f":"IF(H25=\"Enter Quantity\",0,H25)","v":0},{"$f":"IF(I25=\"Enter Cost/Return\",0,I25)","v":0}]
[null,"Total revenue from recycling","$","Enter Return",null,"Other","-","Enter Quantity","Enter Cost/Return"]
[null,null,null,{"$f":"IF(D27=\"Enter Return\",0,D27*-1)","v":0},null,null,"-",{"$f":"IF(H27=\"Enter Quantity\",0,H27)","v":0},{"$f":"IF(I27=\"Enter Cost/Return\",0,I27)","v":0}]
[null,"Revenue per unit to recycle","$",{"$f":"IF(D27=\"Enter Return\",\"-\",(D27/D25))","v":"-"},null,"Totals","-",{"$f":"SUM(H20+H22+H24+H26+H28)","v":0},{"$f":"SUM(I20+I22+I24+I26+I28)","v":0}]
[null,"Cost Per Unit Option 1",null,{"$f":"IF(D18=\"Enter Quantity\",0,(D20+D28)/(D18+D26))","v":0},null,"Cost Per Unit #2",null,null,{"$f":"IF(I29=0,0,I29/H29)","v":0}]
[]
[null,"Proposed Project Comparison "]
[null,"Project options",null,"Option 1",null,"Option 2","Option 3"]
[null,"Enter project name",null,"Enter Name",null,"Enter Name","Enter Name"]
[null,"Expected life of equipment (max 40)","Years","Enter Years",null,"Enter Years","Enter Years"]
[null,"Total cost for project","$","Enter Cost",null,"Enter Cost","Enter Cost"]
[null,"Are there any incentives available? ","Select","Select Yes/No",null,"Select Yes/No","Select Yes/No"]
[null,"If yes, the amount of funding available over life of project","$","Enter Cost",null,"Enter Cost","Enter Cost"]
[null,null,null,{"$f":"IF(D38=\"Enter Cost\",0,D38)","v":0},null,{"$f":"IF(F38=\"Enter Cost\",0,F38)","v":0},{"$f":"IF(G38=\"Enter Cost\",0,G38)","v":0}]
[null,"Additional annual costs - Maintenance, \nchemicals, checks, etc…","$","Enter Cost",null,"Enter Cost","Enter Cost"]
[null,"Amount of waste diverted from landfill, per year",{"$f":"IF(C10=\"Select Unit\", \"-\",C10)","v":"-"},"Enter Quantity",null,"Enter Quantity","Enter Quantity"]
[null,"Is this waste reduced internally or recycled \nexternally?","Option","Select Option",null,"Select Option","Select Option"]
[null,"Cost savings per year","$",{"$f":"VLOOKUP(D42,S1:T3,2,FALSE)","v":"-"},null,{"$f":"VLOOKUP(F42,Y1:Z3,2,FALSE)","v":"-"},{"$f":"VLOOKUP(G42,AA1:AB3,2,FALSE)","v":"-"}]
[null,"Simple payback ","Years",{"$f":"IF(D43=\"-\",\"-\",(D36-D39)/D43)","v":"-"},null,{"$f":"IF(F43=\"-\",\"-\",(F36-F39)/F43)","v":"-"},{"$f":"IF(G43=\"-\",\"-\",(G36-G39)/G43)","v":"-"}]
[null,"Cost savings over life of project","$",{"$f":"IF(D43=\"-\",\"-\",(D43*D35)-D36)","v":"-"},null,{"$f":"IF(F43=\"-\",\"-\",(F43*F35)-F36)","v":"-"},{"$f":"IF(G43=\"-\",\"-\",(G43*G35)-G36)","v":"-"}]
[]
[]
[]
[]
[]
[]
[null,"*Conversion Factors",null,null,null,"Conversion Tool"]
[null,"To convert lbs to tons multiply pounds by .0005",null,null,null,"Enter Amount in Pounds","Pounds",{"$f":"IF(F53=\"Enter Amount in Pounds\",\"-\",F53*0.0005)","v":"-"},"Tons"]
[null,"To convert tons to pounds multiply tons by 2204",null,null,null,"Enter Amount in Tons","Tons",{"$f":"IF(F54=\"Enter Amount in Tons\",\"-\",F54*2204)","v":"-"},"Pounds"]