{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Instructions","Calculator Questions","Sheet1","Processing Alternatives","Option1-off site use","Option2-Offsite Treatment","Option3-Worm Farm","Option4-Dehydration","Option5-In Vessel composting","Option6-Anaerobic digester","Data"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":62,"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":"Instructions","index":0,"n_rows":89,"n_cols":13,"rows_kept":89,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Food Waste Calculator"]
[]
[null,null,"Instructions"]
[null,null,"This Food Waste Calculator will help you to determine the key parameters"]
[null,null,"in deciding the options to handle Food Waste in your business. To start"]
[null,null,"you need to go to the sheet called Calculator Questions and the macro"]
[null,null,"buttons will lead you through a series of interactive questions to assemble"]
[null,null,"the information to make a decision on the various options available to you.",null,null,null,null,null,null,null,null,"This project was funded through the Victorian Government's"]
[null,null,"The first section is the questions to ascertain the amount of food waste, cost",null,null,null,null,null,null,null,null,"Metropolitan Organics Strategy Fund "]
[null,null,"of food waste and method of disposal. The second section looks at the various "]
[null,null,"alternatives to process this food waste."]
[null,null,null,null,null,null,null,null,null,null,null,"Version No:",2]
[null,null,null,null,null,null,null,null,null,null,null,"Version Date:","2016-12-16"]
[null,null,"To start the Food Waste Calculator, simply push this macro button below."]
[null,null,"This file contains macros so make sure you have enabled macros as the file "]
[null,null,"loads. If you haven't, do so now. If your not sure how to:",null,null,null,null,null,"Press for HELP"]
[]
[]
[]
[null,null,"Warning: If you have used this Food Waste Calculator before it will erase"]
[null,null,"the old information to allow a new set of data to be entered."]
[]
[null,null,"If you want to start again retaining the original data but step through again, "]
[null,null,"then simply go to the sheet called Calculator Questions and press the 1st "]
[null,null,"Next button."]
[]
[null,null,"If you damage the food Waste Calculator then simply download another"]
[null,null,"copy."]
[]
[]
[]
[]
[]
[null,null,"If the macro buttons don't work",null,null,"Press for HELP"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Help if the Macro buttons don't work."]
[null,"1. Macros not enabled"]
[null,"If the macro button does not work then macros are not enabled. When you open  "]
[null,"the file, provided Excel is setup to allow macros to work,  you should see a message "]
[null,"asking you to enable the macros. Depending on your version of Excel it will either be"]
[null,"a dialog box in the middle of the screen (Excel 2007) or a message above where the"]
[null,"column headings are and below the Icon ribbon (Excel version 2010 onwards)."]
[null,"Press enable to allow the macros to work."]
[]
[null,"1. Enabling macros doesn't appear."]
[null,"If neither of these appear then it is possible the macros are disabled completely."]
[null,"To check this and alter the security surrounding macros in Excel Options. To access"]
[null,"Excel options."]
[null,"In Excel version 2007 select the Microsoft Option Button",null,null,null,null,null,"and at the bottom"]
[null,"of the dialog box select Excel Options."]
[null,"In Excel version 2010 or later select File and then on the left hand side select Options."]
[]
[null,"Step 1: Select Trust Center from the left hand side of the dialog box "]
[null,"Step 2: Select a button called Trust Centre Settings in the dialog box"]
[null,"Step 3: Select Macro Settings on the left hand side"]
[null,"Step 4: Choose disable all macros with notification. This gives the highest security"]
[null,"while allowing macros to work. You therefore determine if you want to load a "]
[null,"macro. Only do this from a trusted file."]
[null,"Step 5. Press OK to finalise twice to get out of the Dialog box"]
[null,"Step 6: Log out of Excel to allow the settings to take affect and log back in again."]
[]
[]
[null,null,"Return to the Top"]

{"sheet":"Calculator Questions","index":1,"n_rows":324,"n_cols":15,"rows_kept":324,"cut":false,"hidden":false,"merged":[[9,1,9,6],[13,1,13,6],[17,1,17,6],[22,1,22,6],[63,1,63,6],[19,1,19,6],[50,1,50,6],[43,1,43,6],[44,3,44,7],[305,6,305,7],[306,6,306,7],[125,1,125,6],[5,1,5,6],[11,1,11,6],[7,1,7,6],[39,1,39,6],[121,1,121,6],[81,1,81,6],[85,1,85,6],[100,1,100,6],[101,1,101,6],[111,3,111,6],[64,1,64,6],[9,7,9,12],[15,1,15,6]]}
[null,"Food Waste Calculator Questions"]
[null,"1st Section - Answering the basic questions below will assist you in determining what method "]
[null,"is appropriate to dispose of your food waste. It captures the amount of food waste and cost to "]
[null,"dispose of it. Fill in any blue numbers."]
[null,null,null,null,null,null,null,"Response",null,null,null,null,null,"YES","NO"]
["Q. 1","Do you generate Food Waste in your organisation?",null,null,null,null,null,null,null,null,null,null,"Q1","If Yes to Q2","Stops"]
[]
["No Response","As you do not generate any food waste in your organisation this calculator does not apply to you. You do not need to proceed any further."]
[]
["Q. 3",null,null,null,null,null,null,null,null,null,null,null,"Q2","If Yes to Q3","Stops"]
[]
["No Response","As you do not want to remove the food waste from landfill this calculator does not apply to you. You do not need to proceed any further."]
["Q4"]
[null,"Do you currently separate the Food Waste from the General Waste?",null,null,null,null,null,null,null,null,null,null,"Q3","If Yes to Q4","If No to Q20"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Separates Food Waste"]
[null,"Do you know the weight of the Food Waste in Kgs per week?",null,null,null,null,null,null,null,null,null,null,"Q4","If Yes to Q5","If No to Q12"]
[]
[null,"Please enter the weight of the Food Waste in Kgs in a typical  week",null,null,null,null,null,null,"Kgs",null,null,null,"Q5","When entered goto Q6"]
[]
[null,"How is the food waste currently disposed of?",null,null,null,null,null,null,null,null,null,null,"Q6","If Contractor to Q7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"If General Waste Q7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"If Treated on site Q8"]
[null,"Known Food Waste Weight- We now need to calculate the cost to dispose of this Food Waste. Fill out the table below.",null,null,null,null,null,null,null,null,null,null,"Q7","When updated goto Q8"]
[null,null,null,null,null,null,null,"Bins per mth"]
[null,null,null,"No of bins of Food Waste emptied per month",null,null,null,0,null,null,null,null,null,"}"]
[null,null,null,"Average Size of bins",null,null,null,"80 litres",null,null,null,null,null,"}"]
[null,null,null,"Number on bins hired on site",null,null,null,0]
[null,null,null,"Cost per bin per collection",null,null,null,0,null,null,null,null,null,"}"]
[null,null,null,"Per Bin rental per mth",null,null,null,0,null,null,null,null,null,"} Know Weight"]
[null,null,null,"On average how full is the bins?",null,null,null,0,null,null,null,null,null,"}"]
[null,null,null,"Total cost of Food Waste per Month",null,null,null,{"$f":"(+H25*H28)+(H27*Q7_Input4)","v":0},"Calculated",null,null,null,null,"}"]
[null,null,null,"Total cost of Food Waste per year",null,null,null,{"$f":"+H31*12","v":0},"Calculated",null,null,null,null,"}"]
[null,null,null,"Average Weight of Food Waste per week",null,null,null,{"$f":"+Q5_Answer","v":0},"Calculated",null,null,null,null,"}"]
[null,null,null,"Food Waste in kgs per month",null,null,null,{"$f":"+Q5_Answer*52/12","v":0},"Calculated",null,null,null,null,"}"]
[null,null,null,"Food Waste in kgs per year",null,null,null,{"$f":"+H33*52","v":0},"Calculated",null,null,null,null,"}"]
[null,null,null,"Food Waste in Cubic Metres per month",null,null,null,{"$f":"+H34/100*0.25","v":0},"Calculated",null,null,null,null,"}"]
[null,null,null,"Food Waste in Cubic Metres per year",null,null,null,{"$f":"+H36*12","v":0},"Calculated",null,null,null,null,"}"]
[]
[]
[null,"Identify the type of food waste?",null,null,null,null,null,null,null,null,null,null,"Q8","When entered goto Final"]
[]
[]
[]
[null,"Treated on Site - Explain how you currently treat the Food Waste on site"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Q9","Got to Finish"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Separates Food Waste - Doesn't know Kgs"]
[null,"Separates Food Waste but doesn't know weight - Enter the Number of bins, cost and how full the bins are on average.",null,null,null,null,null,null,null,null,null,null,"Q12","When entered goto Q13"]
[null,"You will need your monthly waste bill at this point to fill in the table below. "]
[null,"Key into the blue text cells.",null,null,null,null,null,"Bins per mth"]
[null,null,null,"No of bins of Food Waste emptied per month",null,null,null,0,null,null,null,null,null,"}"]
[null,null,null,"Size of bins",null,null,null,"80 litres",null,null,null,null,null,"}"]
[null,null,null,"Number on bins hired on site",null,null,null,0]
[null,null,null,"Cost per bin per collection",null,null,null,0,null,null,null,null,null,"} Doesn't know weight"]
[null,null,null,"Per Bin rental per mth",null,null,null,0,null,null,null,null,null,"}"]
[null,null,null,"On average how full is the bins?",null,null,null,0,null,null,null,null,null,"}"]
[null,null,null,"Total cost of Food Waste per Month",null,null,null,{"$f":"(+H67*H70)+(H69*Q12_Input3)","v":0},"Calculation",null,null,null,null,"}"]
[null,null,null,"Total cost of Food Waste per year",null,null,null,{"$f":"+Q12_Response*12","v":0},"Calculation",null,null,null,null,"}"]
[null,null,null,"Food Waste in kgs per month",null,null,null,{"$f":"+H77*400","v":0},"Calculation"]
[null,null,null,"Food Waste in kgs per year",null,null,null,{"$f":"+H75*12","v":0},"Calculation"]
[null,null,null,"Food Waste in Cubic Metres per month",null,null,null,{"$f":"VLOOKUP(H68,Data!$B$5:$D$15,3,FALSE)*H72*H67","v":0},"Calculation"]
[null,null,null,"Food Waste in Cubic Metres per year",null,null,null,{"$f":"+H77*12","v":0},"Calculation"]
[]
[]
[]
[null,"Identify the type of food waste?",null,null,null,null,null,null,null,null,null,null,"Q13","When entered goto Final"]
[]
[]
[]
[null,"How is the food waste currently disposed of?",null,null,null,null,null,null,null,null,null,null,"Q14","Goto Finish"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Disposed of in General Waste - We now need to calculate the cost to dispose of this Food Waste.",null,null,null,null,null,null,null,null,null,null,"Starts at row 101"]
[null,"You will need your monthly waste bill at this point to fill in the table below. "]
[null,null,null,null,null,null,null,"Bins per mth"]
[null,null,null,"Average number of bins emptied per typical month",null,null,null,0]
[null,null,null,"Average Size of bins",null,null,null,"80 litres"]
[null,null,null,"Number on bins hired on site",null,null,null,0]
[null,null,null,"Cost per bin per collection (inc any carbon price)",null,null,null,0]
[null,null,null,"Per Bin rental per mth",null,null,null,0]
[null,null,null,"Total cost of bill for General Waste",null,null,null,{"$f":"(+H104*H107)+(H106*Q20_input3)","v":0},"Calculation"]
[null,null,null,"Estimate % of Food Waste in general waste by volume",null,null,null,0,"**"]
[null,null,null,"On average how full is the bins?",null,null,null,0]
[null,null,null,"Theoretical reduction in number of bins collected if we remove the Food Waste from General Waste",null,null,null,{"$f":"ROUNDUP(+H104*H110,0)","v":0},"Calculation"]
[null,null,null,"Total cost of Food Waste per Month",null,null,null,{"$f":"+Q20_Response*Q20_Input4","v":0},"Calculation"]
[null,null,null,"Total cost of Food Waste per year",null,null,null,{"$f":"+H113*12","v":0},"Calculation"]
[null,null,null,"Food Waste in kgs per month",null,null,null,{"$f":"+H117*400","v":0},"Calculation"]
[null,null,null,"Food Waste in kgs per year",null,null,null,{"$f":"+H115*12","v":0},"Calculation"]
[null,null,null,"Food Waste in Cubic Metres per month",null,null,null,{"$f":"VLOOKUP(H105,Data!$B$5:$D$15,3,FALSE)*H110*H104*H111","v":0},"Calculation"]
[null,null,null,"Food Waste in Cubic Metres per year",null,null,null,{"$f":"+H117*12","v":0},"Calculation"]
[null,null,null,"** Refer the Guide for guidance on this by industry"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Q20"]
[]
[null,"Identify the type of food waste?",null,null,null,null,null,null,null,null,null,null,"Q21"]
[]
[]
[]
[null,"How is the food waste currently disposed of?",null,null,null,null,null,null,null,null,null,null,"Q22"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Q 11"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Table of key data",null,null,null,"Week","Per year"]
[null,null,"Food Waste in kgs",null,null,null,{"$f":"IF(Q4_Answer=\"Yes\",$H$303/52,IF(Q4_Answer=\"No\",$H$303/52,IF(Q3_Answer=\"No\",$H$303/52,\"No Answer\")))","v":"No Answer"},{"$f":"IF(Q4_Answer=\"Yes\",Q5_Answer*52,IF(Q4_Answer=\"No\",H76,IF(Q3_Answer=\"No\",H116,\"No Answer\")))","v":"No Answer"},"Kgs"]
[null,null,"Food Waste in cubic metres",null,null,null,{"$f":"IF(Q4_Answer=\"Yes\",H304/52,IF(Q4_Answer=\"No\",H304/52,IF(Q3_Answer=\"No\",H304/52,\"No Answer\")))","v":"No Answer"},{"$f":"IF(Q4_Answer=\"Yes\",H37,IF(Q4_Answer=\"No\",H78,IF(Q3_Answer=\"No\",H118,\"\"\"NoAnswer\")))","v":"\"NoAnswer"},"m3 "]
[null,null,"Current Cost of disposing of Food Waste",null,null,null,{"$f":"IF(Q4_Answer=\"Yes\",H305/52,IF(Q4_Answer=\"No\",H305/52,IF(Q3_Answer=\"No\",H305/52,\"No Answer\")))","v":"No Answer"},{"$f":"IF(Q4_Answer=\"Yes\",H32,IF(Q4_Answer=\"No\",H74,IF(Q3_Answer=\"No\",H114,\"No Answer\")))","v":"No Answer"}]
[null,null,"How Food waste currently disposed of:",null,null,null,{"$f":"IF(Q6_Answer<>\"\",Q6_Answer,IF(Q14_Answer<>\"\",Q14_Answer,IF(Q22_Answer<>\"\",Q22_Answer,\"No Selection\")))","v":"No Selection"}]
[null,null,"Type of Food Waste",null,null,null,{"$f":"IF(Q8_Answer<>\"\",Q8_Answer,IF(Q13_Answer<>\"\",Q13_Answer,IF(Q21_Answer<>\"\",Q21_Answer,\"No Selection\")))","v":"No Selection"}]
[null,null,"Potential CO2 savings from removing from landfill",null,null,null,{"$f":"(+H303*0.17)/1000","v":{"$error":"#VALUE!"}},"Tonnes","p.a."]
[null,null,"Estimate of number of bins used for food waste",null,null,null,{"$f":"IF(Q4_Answer=\"Yes\",Q7_Input1,IF(Q4_Answer=\"No\",Q12_Input1,IF(Q3_Answer=\"No\",$H112,\"No Answer\")))","v":"No Answer"},"Bins per month"]
[]
[null,"Removing Food Waste from General Waste will ALSO have the following significant benefits:"]
[null," Less smell, free up space where bins are kept, likely less noise on bins being emptied, quicker collection, "]
[null,"or less frequent collections. Less time associated with cleaning bins plus all the environmental savings."]
[]
[]
[null,null,null,null,null,"OR"]
[]
[]
[]
[]
[]
[null,"2nd Section - Options available. "]
[null,null,"Answering a couple of futher questions plus the answes already given will help to determine what "]
[null,null,"processing method is right for you."]

{"sheet":"Sheet1","index":2,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,null,null,null,"NO - hide from rows 10 down"]
[]
[]
[null,"Yes"]
[]
[null,null,null,null,null,"NO - hide from rows 14 down"]

{"sheet":"Processing Alternatives","index":3,"n_rows":112,"n_cols":14,"rows_kept":112,"cut":false,"hidden":true,"merged":[[19,0,19,5],[24,0,24,7],[31,0,31,9],[89,6,89,8],[40,6,40,8],[50,6,50,8],[61,6,61,8],[80,6,80,8],[71,6,71,8]]}
["Food Waste Processing Alternatives"]
[]
["There are a number of processing alternatives as follows to process your Food Waste."]
["Currently you generate this amount of Food Waste -->",null,null,null,null,{"$f":"+'Calculator Questions'!G303","v":"No Answer"},"kgs per week"]
[null,null,null,null,"           -->",{"$f":"+F4/7","v":{"$error":"#VALUE!"}},"kgs per day"]
[]
[null,"Options for processing Food Waste",null,null,null,"Space Required on site",null,"Required Staff Hrs per day",null,"Minimum Capital spend required","Space Available","Staff Available","Capital Spend","Overall Evaluation"]
[null,"Option 1 - Off Site Use (eg Food Charity)",null,null,null,"None",null,0,null,0,{"$f":"IF(Option_Q1=\"\",\"\",\"OK\")","v":""},{"$f":"IF(option_Q2=\"\",\"\",\"OK\")","v":""},{"$f":"IF(Option_Q3=\"\",\"\",\"OK\")","v":""},{"$f":"IF(OR(K8=\"\",L8=\"\",M8=\"\"),\"\",IF(AND(K8=\"OK\",L8=\"OK\",M8=\"OK\"),\"OK\",\"NO\"))","v":""}]
[null,"Option 2 - Off Site Processing",null,null,null,"None",null,0,null,0,{"$f":"IF(Option_Q1=\"\",\"\",\"OK\")","v":""},{"$f":"IF(option_Q2=\"\",\"\",\"OK\")","v":""},{"$f":"IF(Option_Q3=\"\",\"\",\"OK\")","v":""},{"$f":"IF(OR(K9=\"\",L9=\"\",M9=\"\"),\"\",IF(AND(K9=\"OK\",L9=\"OK\",M9=\"OK\"),\"OK\",\"NO\"))","v":""}]
[null,"Option 3 - Worm farm (on site)",null,null,null,{"$f":"IF($F$5<60,ROUNDUP(+$F5/2,0)*'Option3-Worm Farm'!$I21,ROUNDUP($F5/60,0)*'Option3-Worm Farm'!$I22)","v":{"$error":"#VALUE!"}},"m2",{"$f":"IF($F$5<60,ROUNDUP(+$F5/2,0)*'Option3-Worm Farm'!$H21,ROUNDUP($F5/60,0)*'Option3-Worm Farm'!$H22)/60","v":{"$error":"#VALUE!"}},"hrs",{"$f":"+'Option3-Worm Farm'!G66","v":{"$error":"#VALUE!"}},{"$f":"IF(Option_Q1=\"\",\"\",IF(Option_Q1>=$F10,\"OK\",\"No\"))","v":""},{"$f":"IF(option_Q2=\"\",\"\",IF(option_Q2>=$H10,\"OK\",\"No\"))","v":""},{"$f":"IF(Option_Q3=\"\",\"\",IF(Option_Q3>=$J10,\"OK\",\"No\"))","v":""},""]
[null,"Option 4 - Dehydration Unit",null,null,null,{"$f":"VLOOKUP('Option4-Dehydration'!$D27,'Option4-Dehydration'!$A$20:$I$24,9)","v":{"$error":"#VALUE!"}},"m2",{"$f":"IF('Option4-Dehydration'!G16<0.5*VLOOKUP('Option4-Dehydration'!$D27,'Option4-Dehydration'!$A$20:$I$24,1),VLOOKUP('Option4-Dehydration'!$D27,'Option4-Dehydration'!$A$20:$I$24,8)/60*1,VLOOKUP('Option4-Dehydration'!$D27,'Option4-Dehydration'!$A$20:$I$24,8)/60*2)","v":{"$error":"#VALUE!"}},"hrs",{"$f":"+'Option4-Dehydration'!G66","v":{"$error":"#VALUE!"}},{"$f":"IF(Option_Q1=\"\",\"\",IF(Option_Q1>=F11,\"OK\",\"No\"))","v":""},{"$f":"IF(option_Q2=\"\",\"\",IF(option_Q2>=$H11,\"OK\",\"No\"))","v":""},{"$f":"IF(Option_Q3=\"\",\"\",IF(Option_Q3>=$J11,\"OK\",\"No\"))","v":""},""]
[null,"Option 5 - In Vessel composting",null,null,null,{"$f":"VLOOKUP('Option5-In Vessel composting'!D24,'Option5-In Vessel composting'!$A$20:$I$21,8,FALSE)","v":{"$error":"#VALUE!"}},"m2",{"$f":"VLOOKUP('Option5-In Vessel composting'!D24,'Option5-In Vessel composting'!$A$20:$H$21,7,FALSE)/60","v":{"$error":"#VALUE!"}},"hrs",{"$f":"+'Option5-In Vessel composting'!G63","v":{"$error":"#VALUE!"}},{"$f":"IF(Option_Q1=\"\",\"\",IF(Option_Q1>=F12,\"OK\",\"No\"))","v":""},{"$f":"IF(option_Q2=\"\",\"\",IF(option_Q2>=$H12,\"OK\",\"No\"))","v":""},{"$f":"IF(Option_Q3=\"\",\"\",IF(Option_Q3>=$J12,\"OK\",\"No\"))","v":""},""]
[null,"Option 6 - Anaerobic digester",null,null,null,{"$f":"VLOOKUP('Option6-Anaerobic digester'!D24,'Option6-Anaerobic digester'!A20:H21,8,FALSE)","v":{"$error":"#VALUE!"}},"m2",{"$f":"VLOOKUP('Option6-Anaerobic digester'!D24,'Option6-Anaerobic digester'!$A$20:$H$21,7,FALSE)","v":{"$error":"#VALUE!"}},"hrs",{"$f":"+'Option6-Anaerobic digester'!G64","v":{"$error":"#VALUE!"}},{"$f":"IF(Option_Q1=\"\",\"\",IF(Option_Q1>=F13,\"OK\",\"No\"))","v":""},{"$f":"IF(option_Q2=\"\",\"\",IF(option_Q2>=$H13,\"OK\",\"No\"))","v":""},{"$f":"IF(Option_Q3=\"\",\"\",IF(Option_Q3>=$J13,\"OK\",\"No\"))","v":""},""]
[]
["Some of these may not apply so we are going to eliminate the ones that don't"]
["apply to you based on your answers to the previous questions about Food Waste "]
["and the couple of simple questions below:"]
[]
[]
["How much space do you have available for onsite processing?"]
["If none then enter 0.",null,null,null,null,null,"m2"]
[]
[]
[]
["How many hours are you prepared to spend for onsite processing per day?"]
["You may have a limitation on the hours that your existing staff can handle  for on site "]
["processing. Therefore this question can exclude options where staff are already"]
["fully engaged in other activities."]
[null,null,null,null,null,null,"Hrs"]
[]
[]
["What dollar limit to you have on Capital spend for onsite processing equipment?"]
["If no predetermined limit then enter a number higher than the minimum capital spend"]
["of the most expensive equipment. This question attempts to eliminate options with"]
["very high capital expenditure that you wouldn't possibly consider simply because of cost."]
[]
[]
[]
[]
[]
["Option 1 - Off Site Use",null,null,null,null,null,"Go to Option Details"]
["e.g. Food charity"]
[null,"Benefits: ","No capital expenditure"]
[null,null,"Good food not wasted but given to someone in need"]
[null,null,"Great social and environment benefits"]
[]
[null,"Cons:","Will take only food donations for human consumption not food scraps"]
[null,null,"May need to store food until sufficient volume for pickup "]
[null,null,"Will need to store the food in correct temperature zone - eg refrigeration"]
[]
["Option 2 - Off Site Processing",null,null,null,null,null,"Go to Option Details"]
["e.g. Go to commercial operators (recycling, worm farm, etc.)"]
[null,"Benefits: ","No capital expenditure"]
[null,null,"Food Waste removed from landfill"]
[null,null,"Doesn't require as much space as Options 3 to 6"]
[null,null,"Simple solution to get good environmental benefits"]
[]
[null,"Cons:","Will need to separate food waste"]
[null,null,"Will cost to dispose of food waste, but it costs to dispose of"]
[null,null,"in landfill so unlikely to cost much more."]
[]
["Option 3 - Worm farm (on site)",null,null,null,null,null,"Go to Option Details"]
[null,"Benefits: ","Organic Material available on site for gardens, etc from the system"]
[null,null,"Relatively low cost"]
[null,null,"Relatively easy to operate, like a home worm farm"]
[]
[null,"Cons:","Will need to separate food waste from general waste"]
[null,null,"Space will be required for worm farm units "]
[null,null,"Small capital cost"]
[]
[]
["Option 4 - Dehydration Unit",null,null,null,null,null,"Go to Option Details"]
[null,"Benefits: ","Food Waste removed from landfill"]
[null,null,"Volume of waste reduced"]
[null,null,"End product use is composte for gardens"]
[]
[null,"Cons:","Will need to separate food waste from general waste"]
[null,null,"Space will be required for unit"]
[null,null,"Some capital cost - approximately  per unit"]
[]
["Option 5 - In Vessel composting",null,null,null,null,null,"Go to Option Details"]
[null,"Benefits: ","Food Waste removed from landfill"]
[null,null,"Volume of waste reduced"]
[null,null,"End product use is generally compost"]
[]
[null,"Cons:","Will need to separate food waste from general waste"]
[null,null,"Space will be required for unit"]
[null,null,"Some capital cost"]
[]
["Option 6 - Anaerobic digester",null,null,null,null,null,"Go to Option Details"]
[null,"Benefits: ","Food Waste removed from landfill"]
[null,null,"Volume of waste reduced"]
[null,null,"End product use is compost or energy generation"]
[]
[null,"Cons:","Will need to separate food waste from general waste"]
[null,null,"Large Space will be required for unit"]
[null,null,"Large capital cost "]
[]
[]
["Important Note:"]
["The evaluation of these options are mutually exclusive. You should take into account that"]
["two or more options might be the desirable approach. For example the following could be"]
["a viable solution."]
["You might have food waste of say 70 kgs per day, but 15kgs is fit for human consumption and "]
["the rest food scraps."]
["Therefore you might invoke the following options:",null,null,null,null,null,"Per day"]
["Option 1 (food charity off site use)",null,null,null,null,null,15,"Kgs"]
["Option 4 (dehydration unit smallest size as next size too big)",null,null,null,null,null,50,"Kgs"]
["Option 2 (worm farm -3 units for remaining waste)",null,null,null,null,null,5,"Kgs"]
[null,null,null,null,null,null,{"$f":"SUM(G107:G109)","v":70},"Kgs"]
["Note: All options are already setup to print off, including this page. Simply select Print on the"]
["Excel menu."]

{"sheet":"Option1-off site use","index":4,"n_rows":70,"n_cols":8,"rows_kept":70,"cut":false,"hidden":true,"merged":[[58,0,58,1],[59,0,59,1],[23,6,23,7]]}
["Option 1: Off Site Use"]
["e.g. Food Charity donation - Edible food for human consumption"]
[]
["This option requires the separation of good quality edible food for human consumption. "]
["This alternative has great social and environmental gains as you are not wasting good"]
["food. See the accompanying Guide which provides some practical examples of how you "]
["could undertake this."]
[]
[]
["To make an informed decision the Calculator Questions produced the following"]
["information to assist you:"]
[]
["Estimated Food Waste Produced per month in kgs",null,null,null,null,null,{"$f":"+'Calculator Questions'!$H$303/12","v":{"$error":"#VALUE!"}},"kgs"]
["Estimated Food Waste Produced per month in cubic metres",null,null,null,null,null,{"$f":"+'Calculator Questions'!$H$304/12","v":{"$error":"#VALUE!"}},"cubic metres"]
["Estimated cost going to landfill per month for food waste",null,null,null,null,null,{"$f":"+'Calculator Questions'!$H$305/12","v":{"$error":"#VALUE!"}}]
[]
["Parentage of your Food Waste that is good quality edible food "]
["for donation to charities",null,null,null,null,null,0.4,"You enter"]
["All items in blue you enter your estimate. The black numbers are formulas."]
[]
["Note some large charities have a minimum of 50kg pick up policy."]
["Refer to the accompanying Guide for more information on this."]
["Requirements:",null,null,null,"Minimum pickups in kgs","Your daily food Waste kgs"]
[" - Minimum Food Pick",null,null,null,"50 kgs",{"$f":"(G13*G18)/30","v":{"$error":"#VALUE!"}},{"$f":"IF(F24>E24,\"You could have daily pickups\",\"You will need to store the food between pickups\")","v":{"$error":"#VALUE!"}}]
[]
["Benefits: ","No capital expenditure"]
[null,"Good food not wasted but given to someone in need"]
[null,"Great social and environment benefits"]
[]
["Cons:","Will take only food donations for human consumption not food scraps"]
[null,"May need to store food until sufficient volume for pickup "]
[null,"Will need to store the food in correct temperature zone - eg refrigeration"]
[]
["Refer to the accompanying Guide for a full analysis of this option."]
[]
["Template to Calculate Impact"]
["All items in blue you enter your estimate. The rest are formulas."]
[null,null,null,null,null,null,"PER MONTH"]
["1. Operational Costs & Benefits ",null,null,null,null,null,"Amount"]
[" - Transport to deliver to charities/ Pick ups normally free",null,null,null,null,null,0,"You enter"]
[" - Your costs to separate the quality food  and pack it per month"]
[null,null,null,"Hours","Rate per hr"]
[null,null,null,2,25,null,{"$f":"+D43*E43","v":50},"You enter"]
[null,null,null,null,"Monthly cost",null,{"$f":"SUM(G40:G43)","v":50}]
[null,"less Savings from going to landfill (refer cell G17)",null,null,null,null,{"$f":"-G15*G18","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"Net cost / (benefit) per month",null,{"$f":"+G44+G45","v":{"$error":"#VALUE!"}}]
[]
["2. Capital cost (once off)"]
[" - Unlikely but could be additional refrigerated storage",null,null,null,null,null,0]
[]
[null,null,null,null,null,null,{"$f":"+D51*E51","v":0}]
[]
[]
[]
["3. Cashflow Impact per year"]
[]
[null,null,"Yr 1","Yr2","Yr3","Yr 4","Yr 5","Total"]
["Initial Capital cost",null,{"$f":"+G51+0.01","v":0.01}]
["Operation costs / (benefits)",null,{"$f":"+G46","v":{"$error":"#VALUE!"}},{"$f":"+C59*(1+$C$61)","v":{"$error":"#VALUE!"}},{"$f":"+D59*(1+$C$61)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Cashflow Favourable / (Unfavourable)",null,{"$f":"-C58-C59","v":{"$error":"#VALUE!"}},{"$f":"-D58-D59","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"SUM(C60:G60)","v":{"$error":"#VALUE!"}}]
["Inflation rate",null,0.03]
[]
["Return on Investment:",null,{"$f":"IF(ISERROR(IRR(C60:G60,10%))=TRUE,\"Great Return as no cost!\",IRR(C60:G60,10%))","v":"Great Return as no cost!"}]
["  p.a."]
[]
["Removing Food Waste from General Waste will ALSO have the following benefits that"]
["haven't been quantifiable."]
["Less smell, free up space where bins are kept, less bins means less noise on bins being "]
["emptied, quicker collection, or less frequent collections. Less time associated with  "]
["cleaning bins plus all the environmental savings."]

{"sheet":"Option2-Offsite Treatment","index":5,"n_rows":63,"n_cols":8,"rows_kept":63,"cut":false,"hidden":true,"merged":[[52,0,52,1],[51,0,51,1]]}
["Option 2: Off Site Treatment"]
["e.g. Go to commercial operators (composting, worm farm, etc.)"]
[]
["This option requires the separation of food waste from general waste on site and can be "]
["picked up by commercial operators. It allows you to gain good environmental benefits of "]
["eliminating food waste from landfill. The accompanying Guide provides some practical  "]
["explanation of how you could undertake this option."]
[]
[]
["To make an informed decision the Calculator Questions produced the following"]
["information to assist you:"]
[]
["Estimated Food Waste Produced per month in kgs",null,null,null,null,null,{"$f":"+'Calculator Questions'!$H$303/12","v":{"$error":"#VALUE!"}},"kgs"]
["Estimated Food Waste Produced per month in cubic metres",null,null,null,null,null,{"$f":"+'Calculator Questions'!$H$304/12","v":{"$error":"#VALUE!"}},"cubic metres"]
["Estimated cost going to landfill per month for food waste",null,null,null,null,null,{"$f":"+'Calculator Questions'!$H$305/12","v":{"$error":"#VALUE!"}}]
["Estimated number of bins being used for Food Waste ",null,null,null,null,null,{"$f":"+'Calculator Questions'!G309","v":"No Answer"},"bins each mth"]
[]
["Benefits: ","No capital expenditure"]
[null,"Food Waste removed from landfill"]
[null,"Doesn't require as much space as Options 3 to 6"]
[null,"Simple solution to get good environmental benefits"]
[]
["Cons:","Will need to separate food waste"]
[null,"Will cost to dispose of food waste, but it costs to dispose of"]
[null,"in landfill so unlikely to cost much more."]
[]
["Refer to the accompanying Guide for a full analysis of this option."]
[]
["Template to Calculate Impact"]
["All items in blue you enter your estimate. The black numbers are formulas."]
[null,null,null,null,null,null,"Per Month"]
["1. Operational Costs & Benefits "]
[" - Transport / Pick up cost"]
[null,null,"Bins on site","No of bins emptied per mth","Rate per bin","Bin Rental","Amount"]
[null,null,2,{"$f":"+G16","v":"No Answer"},15,3,{"$f":"(E35*D35)+(C35*F35)","v":{"$error":"#VALUE!"}}]
[" - Your costs to separate the food waste per month"]
[null,null,null,"Hours","Rate per hr"]
[null,null,null,2,25,null,{"$f":"+D38*E38","v":50}]
[null,null,null,null,"Monthly cost",null,{"$f":"SUM(G34:G38)","v":{"$error":"#VALUE!"}}]
[null,"less Savings from going to landfill (refer cell G15)",null,null,null,null,{"$f":"-G15","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"Net cost / (benefit) per month",null,{"$f":"+G39+G40","v":{"$error":"#VALUE!"}}]
[]
["2. Capital cost (once off)"]
[" - Should be nil as bins hired",null,null,null,null,null,0]
[]
[]
[]
["3. Cashflow Impact per year"]
[]
[null,null,"Yr 1","Yr2","Yr3","Yr 4","Yr 5","Total"]
["Initial Capital cost",null,{"$f":"G44","v":0}]
["Operation costs / (benefits)",null,{"$f":"+G41*12","v":{"$error":"#VALUE!"}},{"$f":"+C52*(1+$C$54)","v":{"$error":"#VALUE!"}},{"$f":"+D52*(1+$C$54)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Cashflow Favourable / (Unfavourable)",null,{"$f":"-C51-C52","v":{"$error":"#VALUE!"}},{"$f":"-D51-D52","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"SUM(C53:G53)","v":{"$error":"#VALUE!"}}]
["Inflation rate",null,0.03]
[]
["Return on Investment:",null,{"$f":"IF(ISERROR(IRR(C53:G53,10%))=TRUE,\"No financial return can be calculated as costs exceed benefits\",IRR(C53:G53,10%))","v":"No financial return can be calculated as costs exceed benefits"}]
["  p.a."]
[]
["Removing Food Waste from General Waste will ALSO have the following benefits that"]
["haven't been quantifiable."]
["Less smell, less frequent collections of general waste, less bins to thoughly clean as all"]
["food waste in less bins. A simple solution at little net cost with all the environmental "]
["savings."]

{"sheet":"Option3-Worm Farm","index":6,"n_rows":82,"n_cols":9,"rows_kept":82,"cut":false,"hidden":true,"merged":[[71,0,71,1],[72,0,72,1],[25,3,25,5]]}
["Option 3: Worm Farm (on site)"]
[]
[]
["This option still requires the separation of food waste from general waste on site but then  "]
["put into the onsite worm farm. It allows you to gain the environmental benefits of eliminating "]
["food waste from landfill but also providing you with usable organic material. Worm farms"]
["range form small home-scale systems to much bigger commercial type systems."]
["The accompanying Guide provides some practical knowledge of how you could undertake this "]
["and how the system works."]
["To make an informed decision the Calculator Questions produced the following"]
["information to assist you:"]
[]
["Estimated Food Waste Produced per month in kgs",null,null,null,null,null,{"$f":"+'Calculator Questions'!$H$303/12","v":{"$error":"#VALUE!"}},"kgs"]
["Estimated Food Waste Produced per month in cubic metres",null,null,null,null,null,{"$f":"+'Calculator Questions'!$H$304/12","v":{"$error":"#VALUE!"}},"cubic metres"]
["Estimated cost going to landfill per month for food waste",null,null,null,null,null,{"$f":"+'Calculator Questions'!$H$305/12","v":{"$error":"#VALUE!"}}]
["Estimated daily Food Waste Produced in kgs",null,null,null,null,null,{"$f":"+G13/30","v":{"$error":"#VALUE!"}},"kgs"]
[]
["Example of sizes and approximate costs of worm farm systems available are as follows:"]
["The 2kg size is the typical home unit but a number of these can be connected."]
["Unit Size","Unit weight","Unit Size",null,"Max Daily  food waste kgs","Cost","Number of units you require","Labour minutes per day","sq metres floor area"]
["2 kgs/day","12kgs","60cm x 65cm x 95cm",null,2,395,{"$f":"ROUNDUP(+$G$16/E21,0)","v":{"$error":"#VALUE!"}},5,{"$f":"0.6*0.65","v":0.39}]
["60 kgs/day","150 kgs","3m x 2m x 2.5m",null,60,21500,{"$f":"ROUNDUP(+$G$16/E22,0)","v":{"$error":"#VALUE!"}},20,{"$f":"3*2","v":6}]
["** Note: costs quoted above are based on 2015 prices at an AUD/USD rate of $0.70 "]
[]
[null,null,null,null,null,null,"No of Units "]
[" - You choose likely system",null,null,"2 kgs/day",null,null,{"$f":"IF(ISNA(VLOOKUP(D26,$A$21:$G$22,7,FALSE))=TRUE,0,VLOOKUP(D26,$A$21:$G$22,7,FALSE))","v":{"$error":"#VALUE!"}}]
[]
[]
["Benefits: ","Organic Material available on site for gardens, etc from the system"]
[null,"Relatively low cost"]
[null,"Relatively easy to operate, like a home worm farm"]
[]
[]
["Cons:","Will need to separate food waste from general waste"]
[null,"Space will be required for worm farm units "]
[null,"Small capital cost =",null,{"$f":"VLOOKUP(D26,$A$21:$H$22,6,FALSE)*VLOOKUP(D26,$A$21:$H$22,7,FALSE)","v":{"$error":"#VALUE!"}}]
[]
["Refer to the accompanying Guide for a full analysis of this option."]
[]
[]
[]
["Template to Calculate Impact"]
["All items in blue you enter your estimate. The black numbers are formulas."]
[null,null,null,null,null,null,"Per Month"]
["1. Operational Costs & Benefits "]
[" - Your costs to separate the food waste per month"]
[null,null,null,"Hours","Rate per hr",null,"Amount"]
[null,null,null,4,25,null,{"$f":"+D48*E48","v":100}]
[" - Your costs to operate/service the worm farms each month"]
[null,null,null,"Hours","Rate per hr"]
[null,null,null,{"$f":"(VLOOKUP(D26,$A$21:$H$22,8,FALSE)*30)/60","v":2.5},25,null,{"$f":"+D51*E51","v":62.5}]
[null,"Remember it is quite simple to operate"]
[" - Your costs, if any, to dispose of the organic material per month **"]
[null,null,null,"Hours","Rate per hr"]
[null,null,null,0,25,null,{"$f":"+D55*E55","v":0}]
[null,null,null,null,"Monthly cost",null,{"$f":"SUM(G46:G55)","v":162.5}]
[null,"** = Staff often take home for their own gardens"]
[]
[null,"less Savings from going to landfill (refer cell G17)",null,null,null,null,{"$f":"-G15","v":{"$error":"#VALUE!"}}]
[null,"less Savings by using your own organic material on"]
[null,"your own gardens/ or sale proceeds to others",null,null,null,null,0]
[null,null,null,null,"Net cost / (benefit) per month",null,{"$f":"SUM(G56:G61)","v":{"$error":"#VALUE!"}}]
[]
["2. Capital cost (once off)"]
[null,null,null,null,"no of units","cost per unit","Amount"]
[" - Cost of Worm system",null,null,null,{"$f":"+G26","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(D26,$A$21:$G$22,6,FALSE)","v":395},{"$f":"+E66*F66","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,{"$f":"SUM(G66:G66)","v":{"$error":"#VALUE!"}}]
[]
["3. Cashflow Impact per year"]
[null,null,"Yr 1","Yr2","Yr3","Yr 4","Yr 5","Total"]
["Initial Capital cost",null,{"$f":"+D36","v":{"$error":"#VALUE!"}}]
["Operation costs / (benefits)",null,{"$f":"+G62*12","v":{"$error":"#VALUE!"}},{"$f":"+C72*(1+$C$63)","v":{"$error":"#VALUE!"}},{"$f":"+D72*(1+$C$63)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Cashflow Favourable / (Unfavourable)",null,{"$f":"-C71-C72","v":{"$error":"#VALUE!"}},{"$f":"-D71-D72","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"SUM(C73:G73)","v":{"$error":"#VALUE!"}}]
["Inflation rate",null,0.03]
[]
["Return on Investment:",null,{"$f":"IF(ISERROR(IRR(C73:G73,10%))=TRUE,\"No financial return can be calculated as costs exceed benefits\",IRR(C73:G73,10%))","v":"No financial return can be calculated as costs exceed benefits"}]
["  p.a."]
["Removing Food Waste from General Waste will ALSO have the following benefits that"]
["haven't been quantifiable."]
["Less smell, free up space where bins are kept, likely less noise on bins being emptied,  "]
["quicker collection, or less frequent collections. Less time associated with cleaning bins "]
["plus all the environmental savings."]

{"sheet":"Option4-Dehydration","index":7,"n_rows":84,"n_cols":15,"rows_kept":84,"cut":false,"hidden":true,"merged":[[73,0,73,1],[74,0,74,1]]}
["Option 4: Dehydration unit"]
[]
["This option still requires the separation of food waste from general waste on site but then  "]
["put into a dehydration unit to reduce the weight and size of the waste. You still have to "]
["dispose of the output that is good for composts and gardens. Dehydration units use gas"]
["or electricity and dehydrate the food waste. Typically a reduction of 90% can be achieved."]
["The accompanying Guide provides some knowledge of how this process works and its "]
["requirements."]
[]
["To make an informed decision the Calculator Questions produced the following"]
["information to assist you:"]
[]
["Estimated Food Waste Produced per month in kgs",null,null,null,null,null,{"$f":"+'Calculator Questions'!$H$303/12","v":{"$error":"#VALUE!"}},"kgs"]
["Estimated Food Waste Produced per month in cubic metres",null,null,null,null,null,{"$f":"+'Calculator Questions'!$H$304/12","v":{"$error":"#VALUE!"}},"cub. metres"]
["Estimated cost going to landfill per month for food waste",null,null,null,null,null,{"$f":"+'Calculator Questions'!$H$305/12","v":{"$error":"#VALUE!"}}]
["Estimated daily Food Waste Produced in kgs",null,null,null,null,null,{"$f":"+G13/30","v":{"$error":"#VALUE!"}},"kgs"]
[]
["There are a variety of sized systems available. Examples are as follows:"]
["Unit Size kgs/ day based on 2 cycles per day","Cycles possible per day","Unit footprint",null,"Max Daily  food waste kgs","Capital Cost","Electricity cost per cycle","Labour minutes per cycle","sq metres floor area",null,null,null,null,"kgs of waste","Machine size"]
[50,2,"65cm x 65cm x 90cm",null,{"$f":"+A20","v":50},27000,4,15,{"$f":"0.65*0.65","v":0.42250000000000004},null,null,null,null,0,50]
[100,2,"95cm x 140cm x 120cm",null,{"$f":"+A21","v":100},40000,6,20,{"$f":"0.95*1.4","v":1.3299999999999998},null,null,null,null,50,50]
[400,2,"150cm x 260cm x 180cm",null,{"$f":"+A22","v":400},110000,24,25,{"$f":"1.5*2.6","v":3.9000000000000004},null,null,null,null,51,100]
[600,2,"165cm x 260cm x180cm",null,{"$f":"+A23","v":600},155000,33.75,25,{"$f":"1.65*2.6","v":4.29},null,null,null,null,100,100]
[1200,2,"180cm x 330cm x 220cm",null,{"$f":"+A24","v":1200},220000,67.5,30,{"$f":"1.8*3.3","v":5.9399999999999995},null,null,null,null,101,400]
["** Note: costs quoted above are based on 2015 prices at an AUD/USD rate of $0.70 ",null,null,null,null,null,null,null,null,null,null,null,null,400,400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,401,600]
[" - Your likely system",null,null,{"$f":"VLOOKUP(G16,$N$20:$O$28,2,TRUE)","v":{"$error":"#VALUE!"}},"kgs/ day that can do 2 cycles per day",null,null,null,null,null,null,null,null,600,600]
["Requirements:",null,null,null,null,null,null,null,null,null,null,null,null,601,1200]
[" - 3 Phase power ",null,null,null," - Possibly need to flue for air"]
[" - Discharge water to trade waste",null,null,null," - Space for unit"]
[]
["Benefits: ","Food Waste removed from landfill"]
[null,"Volume of waste reduced"]
[null,"End product use is compost for gardens"]
[]
["Cons:","Will need to separate food waste from general waste"]
[null,"Space will be required for unit"]
[null,"Significant capital cost - approximately  per unit =",null,null,null,null,{"$f":"VLOOKUP(D27,$A$20:$H$24,6,FALSE)","v":{"$error":"#VALUE!"}}]
[]
["Refer to the accompanying Guide for a full analysis of this option."]
[]
["Template to Calculate Impact"]
["All items in blue you enter your estimate. The black numbers are formulas."]
[null,null,null,null,null,null,"Per Month"]
["1. Operational Costs & Benefits "]
[null,null,null,null,"Cost"]
[" - Electricity costs",null,null,null,{"$f":"VLOOKUP(D$27,$A$20:$H$24,7,FALSE)*2*30","v":{"$error":"#VALUE!"}},"per Mth",{"$f":"+E47","v":{"$error":"#VALUE!"}}]
[" - Your costs to separate the food waste per month"]
[null,null,null,"Hours","Rate per hr"]
[null,null,null,4,25,null,{"$f":"+D50*E50","v":100}]
[" - Your Labour costs to operate/service the unit each month"]
[null,null,null,"Hours","Rate per hr"]
[null,null,null,{"$f":"(VLOOKUP(D$27,$A$20:$H$24,8,FALSE)*2*30)/60","v":{"$error":"#VALUE!"}},25,null,{"$f":"+D53*E53","v":{"$error":"#VALUE!"}}]
[" - Your costs to dispose of the organic material per month"]
[null,null,null,"Hours","Rate per hr"]
[null,null,null,10,25,null,{"$f":"+D56*E56","v":250}]
[null,"Or external cost to dispose per month",null,null,null,null,0]
[null,null,null,null,"Monthly cost",null,{"$f":"SUM(G47:G57)","v":{"$error":"#VALUE!"}}]
[null,"less Savings from going to landfill (refer cell G15)",null,null,null,null,{"$f":"-G15","v":{"$error":"#VALUE!"}}]
[null,"less Savings by using your own organic material on",null,null,null,null,null,"enter as"]
[null,"your own gardens/ or sale proceeds to others",null,null,null,null,0,"negative"]
[null,null,null,null,"Net cost / (benefit) per month",null,{"$f":"SUM(G58:G61)","v":{"$error":"#VALUE!"}}]
[]
["2. Capital cost (once off)"]
[null,null,null,null,null,"Cost","Amount"]
[" - Cost of Dehydration unit",null,null,null,null,{"$f":"+G38","v":{"$error":"#VALUE!"}},{"$f":"+F66","v":{"$error":"#VALUE!"}}]
[" - Electricity/gas costs to connect",null,null,null,null,null,2000]
[" - Trade Waste Connection costs",null,null,null,null,null,1000]
[null,null,null,null,null,null,{"$f":"SUM(G66:G68)","v":{"$error":"#VALUE!"}}]
[]
["3. Cashflow Impact per year"]
[null,null,"Yr 1","Yr2","Yr3","Yr 4","Yr 5","Total"]
["Initial Capital cost",null,{"$f":"G69","v":{"$error":"#VALUE!"}}]
["Operation costs / (benefits)",null,{"$f":"+G62*12","v":{"$error":"#VALUE!"}},{"$f":"+C74*(1+$C$59)","v":{"$error":"#VALUE!"}},{"$f":"+D74*(1+$C$59)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Cashflow Favourable / (Unfavourable)",null,{"$f":"-C73-C74","v":{"$error":"#VALUE!"}},{"$f":"-D73-D74","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"SUM(C75:G75)","v":{"$error":"#VALUE!"}}]
["Inflation rate",null,0.03]
[]
["Return on Investment:",null,{"$f":"IF(ISERROR(IRR(C75:G75,10%))=TRUE,\"No financial return can be calculated as costs exceed benefits\",IRR(C75:G75,10%))","v":"No financial return can be calculated as costs exceed benefits"}]
["  p.a."]
["Removing Food Waste from General Waste will ALSO have the following benefits that"]
["haven't been quantifiable."]
["Less smell, free up space where bins are kept, likely less noise on bins being emptied,  "]
["quicker collection, or less frequent collections. Less time associated with cleaning bins "]
["plus all the environmental savings."]

{"sheet":"Option5-In Vessel composting","index":8,"n_rows":82,"n_cols":12,"rows_kept":82,"cut":false,"hidden":true,"merged":[[70,0,70,1],[71,0,71,1]]}
["Option 5: In Vessel Composting"]
[]
["This option still requires the separation of food waste from general waste on site but then  "]
["put into an In Vessel Composting unit to reduce the weight and size of the waste. The in "]
["vessel composting speeds up the decomposition. You still have to dispose of the output."]
["Some systems produce compost and others produce a mixture called \"soil conditioner\"."]
["The accompanying Guide provides some knowledge of how this process works and its "]
["requirements."]
[]
["To make an informed decision the Calculator Questions produced the following"]
["information to assist you:"]
[]
["Estimated Food Waste Produced per month in kgs",null,null,null,null,null,{"$f":"+'Calculator Questions'!$H$303/12","v":{"$error":"#VALUE!"}},"kgs"]
["Estimated Food Waste Produced per month in cubic metres",null,null,null,null,null,{"$f":"+'Calculator Questions'!$H$304/12","v":{"$error":"#VALUE!"}},"cub. metres"]
["Estimated cost going to landfill per month for food waste",null,null,null,null,null,{"$f":"+'Calculator Questions'!$H$305/12","v":{"$error":"#VALUE!"}}]
["Estimated daily Food Waste Produced in kgs",null,null,null,null,null,{"$f":"+G13/30","v":{"$error":"#VALUE!"}},"kgs"]
[]
["There are a variety of sized systems available. Examples are as follows:"]
["Unit Size kg /day","Unit footprint",null,"Power require- ment","Capital Cost","Electricity cost per batch","Labour minutes per batch","sq metres floor area"]
[85,"5.5m x 1.3m x 1.8m",null,"240 volt",9900,1.4,35,{"$f":"5.5*1.3","v":7.15},null,null,0,{"$f":"+A20","v":85}]
[6400,"12.8m x 2.1m x 1.8m",null,"3 Phase",380000,10,70,{"$f":"12.8*2.1","v":26.880000000000003},null,null,85,85]
["** Note: costs quoted above are based on 2015 prices at an AUD/USD rate of $0.70 ",null,null,null,null,null,null,null,null,null,86,6400]
[]
[" - Your likely system",null,null,{"$f":"VLOOKUP($G$16,$K$20:$L$22,2,TRUE)","v":{"$error":"#VALUE!"}},"kgs per day"]
[]
["Requirements:"]
[" - May require 3 Phase power "]
[" - Space for unit"]
[]
["Benefits: ","Food Waste removed from landfill"]
[null,"Volume of waste reduced"]
[null,"End product use is generally compost"]
[]
["Cons:","Will need to separate food waste from general waste"]
[null,"Space will be required for unit"]
[null,"Some capital cost - approximately  per unit =",null,null,null,{"$f":"VLOOKUP(D24,$A$20:$G$22,5,FALSE)","v":{"$error":"#VALUE!"}}]
[]
["Refer to the accompanying Guide for a full analysis of this option."]
[]
["Template to Calculate Impact"]
["All items in blue you enter your estimate. The black numbers are formulas."]
[null,null,null,null,null,null,"Per Month"]
["1. Operational Costs & Benefits "]
[null,null,null,null,"Cost",null,"Amount"]
[" - Electricity costs",null,null,null,{"$f":"VLOOKUP(D$24,$A$20:$G$21,6,FALSE)*30","v":{"$error":"#VALUE!"}},"per Mth",{"$f":"+E45","v":{"$error":"#VALUE!"}}]
[" - Your costs to separate the food waste per month"]
[null,null,null,"Hours","Rate per hr"]
[null,null,null,4,25,null,{"$f":"+D48*E48","v":100}]
[" - Your Labour costs to operate/service the unit each month"]
[null,null,null,"Hours","Rate per hr"]
[null,null,null,{"$f":"(VLOOKUP($D$24,$A$20:$G$21,7,FALSE)*30)/60","v":{"$error":"#VALUE!"}},25,null,{"$f":"+D51*E51","v":{"$error":"#VALUE!"}}]
[" - Your costs to dispose of the organic material per month"]
[null,null,null,"Hours","Rate per hr"]
[null,null,null,20,25,null,{"$f":"+D54*E54","v":500}]
[null,"Or external cost to dispose per month",null,null,null,null,0]
[null,null,null,null,"Monthly cost",null,{"$f":"SUM(G45:G55)","v":{"$error":"#VALUE!"}}]
[null,"less Savings from going to landfill (refer cell G15)",null,null,null,null,{"$f":"-G15","v":{"$error":"#VALUE!"}}]
[null,"less Savings by using your own organic material on",null,null,null,null,null,"enter as"]
[null,"your own gardens/ or sale proceeds to others",null,null,null,null,0,"negative"]
[null,null,null,null,"Net cost / (benefit) per month",null,{"$f":"SUM(G56:G59)","v":{"$error":"#VALUE!"}}]
[]
["2. Capital cost (once off)",null,null,null,null,"cost","Amount"]
[" - Cost of In Vessel unit",null,null,null,null,{"$f":"+F36","v":{"$error":"#VALUE!"}},{"$f":"+F63","v":{"$error":"#VALUE!"}}]
[" - Electricity costs to connect",null,null,null,null,null,2000]
[" - Other earthworks/ flooring",null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"SUM(G63:G65)","v":{"$error":"#VALUE!"}}]
[]
["3. Cashflow Impact per year"]
[null,null,"Yr 1","Yr2","Yr3","Yr 4","Yr 5","Total"]
["Initial Capital cost",null,{"$f":"G66","v":{"$error":"#VALUE!"}}]
["Operation costs / (benefits)",null,{"$f":"+G60*12","v":{"$error":"#VALUE!"}},{"$f":"+C71*(1+$C$57)","v":{"$error":"#VALUE!"}},{"$f":"+D71*(1+$C$57)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Cashflow Favourable / (Unfavourable)",null,{"$f":"-C70-C71","v":{"$error":"#VALUE!"}},{"$f":"-D70-D71","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"SUM(C72:G72)","v":{"$error":"#VALUE!"}}]
["Inflation rate",null,0.03]
[]
["Return on Investment:",null,{"$f":"IF(ISERROR(IRR(C72:G72,10%))=TRUE,\"No financial return can be calculated as costs exceed benefits\",IRR(C72:G72,10%))","v":"No financial return can be calculated as costs exceed benefits"}]
["  p.a."]
[]
["Removing Food Waste from General Waste will ALSO have the following benefits that"]
["haven't been quantifiable."]
["Less smell, free up space where bins are kept, likely less noise on bins being emptied,  "]
["quicker collection, or less frequent collections. Less time associated with cleaning bins "]
["plus all the environmental savings."]

{"sheet":"Option6-Anaerobic digester","index":9,"n_rows":82,"n_cols":12,"rows_kept":82,"cut":false,"hidden":true,"merged":[[70,0,70,1],[71,0,71,1]]}
["Option 6: Anaerobic Digestion"]
[]
["This option still requires the separation of food waste from general waste on site but then  "]
["put into an Anaerobic Digestion unit to reduce the weight and size of the waste. You still "]
["have to dispose of the output. Anaerobic Digestion uses micro organisms to break down"]
["biodegradable material to manage waste and/or generate energy. Generally this process"]
["is only used in very large scale facilities because of the capital cost."]
["The accompanying Guide provides some knowledge of how this process works and its "]
["requirements."]
["To make an informed decision the Calculator Questions produced the following"]
["information to assist you:"]
[]
["Estimated Food Waste Produced per month in kgs",null,null,null,null,null,{"$f":"+'Calculator Questions'!$H$303/12","v":{"$error":"#VALUE!"}},"kgs"]
["Estimated Food Waste Produced per month in cubic metres",null,null,null,null,null,{"$f":"+'Calculator Questions'!$H$304/12","v":{"$error":"#VALUE!"}},"cub. metres"]
["Estimated cost going to landfill per month for food waste",null,null,null,null,null,{"$f":"+'Calculator Questions'!$H$305/12","v":{"$error":"#VALUE!"}}]
["Estimated daily Food Waste Produced in kgs",null,null,null,null,null,{"$f":"+G13/30","v":{"$error":"#VALUE!"}},"kgs"]
[]
["There are not many examples in Australia. An indication of cost and size is as follows:"]
["Unit Size kg /day","Unit footprint","Power",null,"Capital Cost","Electricity cost per batch","Labour  Hours per batch","sq metres floor area"]
[1000,"200m2","Electricity or Gas",null,450000,5,3.8,200,null,null,0,{"$f":"+A20","v":1000}]
[55000,"3,500m2","Electricity or Gas",null,5750000,{"$f":"200000/365","v":547.94520547945206},7.6,3500,null,null,{"$f":"+A20","v":1000},1000]
[null,null,null,null,null,null,null,null,null,null,1001,55000]
[]
[" - Your likely system",null,null,{"$f":"VLOOKUP(G16,$K$20:$L$22,2,TRUE)","v":{"$error":"#VALUE!"}},"kgs per day"]
[]
["Requirements:"]
[" - 3 Phase power or Gas"]
[" - Space for unit"]
[]
["Benefits: ","Food Waste removed from landfill"]
[null,"Volume of waste reduced"]
[null,"End product use is compost or energy generation"]
[]
["Cons:","Will need to separate food waste from general waste"]
[null,"Large Space will be required for unit"]
[null,"Large capital cost - approximately  per unit =",null,null,null,{"$f":"VLOOKUP(D24,$A$20:$G$22,5,FALSE)","v":{"$error":"#VALUE!"}}]
[]
["Refer to the accompanying Guide for a full analysis of this option."]
[]
["Template to Calculate Impact"]
["All items in blue you enter your estimate. The black numbers are formulas."]
[null,null,null,null,null,null,"Per Month"]
["1. Operational Costs & Benefits "]
[null,null,null,null,"Cost",null,"Amount"]
[" - Electricity costs",null,null,null,{"$f":"VLOOKUP(D$24,$A$20:$G$21,6,FALSE)*30","v":{"$error":"#VALUE!"}},"per Mth",{"$f":"+E45","v":{"$error":"#VALUE!"}}]
[" - Your costs to separate the food waste per month"]
[null,null,null,"Hours","Rate per hr"]
[null,null,null,10,25,null,{"$f":"+D48*E48","v":250}]
[" - Your Labour costs to operate/service the unit each month",null,null,null,null,null,{"$f":"VLOOKUP(D$24,$A$20:$G$21,7,FALSE)","v":{"$error":"#VALUE!"}}]
[null,null,null,"Hours","Rate per hr"]
[null,null,null,{"$f":"VLOOKUP($D$24,$A$20:$G$21,7,FALSE)*30","v":{"$error":"#VALUE!"}},25,null,{"$f":"+D51*E51","v":{"$error":"#VALUE!"}}]
[" - Your costs to dispose of the organic material per month"]
[null,null,null,"Hours","Rate per hr"]
[null,null,null,20,25,null,{"$f":"+D54*E54","v":500}]
[null,"Or external cost to dispose per month",null,null,null,null,0]
[null,null,null,null,"Monthly cost",null,{"$f":"SUM(G45:G55)","v":{"$error":"#VALUE!"}}]
[null,"less Savings from going to landfill (refer cell G15)",null,null,null,null,{"$f":"-G15","v":{"$error":"#VALUE!"}}]
[null,"less Savings by using your own organic material on"]
[null,"your own gardens/ or sale proceeds to others",null,null,null,null,0,"enter as"]
[null,"less Electricity  generation savings",null,null,null,null,0,"negatives"]
[null,null,null,null,"Net cost / (benefit) per month",null,{"$f":"SUM(G56:G60)","v":{"$error":"#VALUE!"}}]
[]
["2. Capital cost (once off)",null,null,null,null,null,"Amount"]
[" - Cost of Dehydration units",null,null,null,null,{"$f":"+F36","v":{"$error":"#VALUE!"}},{"$f":"+F64","v":{"$error":"#VALUE!"}}]
[" - Electricity costs to connect",null,null,null,null,null,2000]
[]
[null,null,null,null,null,null,{"$f":"SUM(G64:G66)","v":{"$error":"#VALUE!"}}]
["3. Cashflow Impact per year"]
[null,null,"Yr 1","Yr2","Yr3","Yr 4","Yr 5","Total"]
["Initial Capital cost",null,{"$f":"G67","v":{"$error":"#VALUE!"}}]
["Operation costs / (benefits)",null,{"$f":"+G61*12","v":{"$error":"#VALUE!"}},{"$f":"+C71*(1+$C$57)","v":{"$error":"#VALUE!"}},{"$f":"+D71*(1+$C$57)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Cashflow Favourable / (Unfavourable)",null,{"$f":"-C70-C71","v":{"$error":"#VALUE!"}},{"$f":"-D70-D71","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"SUM(C72:G72)","v":{"$error":"#VALUE!"}}]
["Inflation rate",null,0.03]
[]
["Return on Investment:",null,{"$f":"IF(ISERROR(IRR(C72:G72,10%))=TRUE,\"No financial return can be calculated as costs exceed benefits\",IRR(C72:G72,10%))","v":"No financial return can be calculated as costs exceed benefits"}]
["  p.a."]
[]
["Removing Food Waste from General Waste will ALSO have the following benefits that"]
["haven't been quantifiable."]
["Less smell, free up space where bins are kept, likely less noise on bins being emptied,  "]
["quicker collection, or less frequent collections. Less time associated with cleaning bins "]
["plus all the environmental savings."]

{"sheet":"Data","index":10,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":true,"merged":[[3,0,3,3]]}
["Data Required"]
[]
[]
["Q11 Bin Sizes"]
[null,"Bin Size","Litres","Cubic Metres"]
[null,"80 litres",80,{"$f":"+C6*0.001","v":0.08}]
[null,"120 litres",120,{"$f":"+C7*0.001","v":0.12}]
[null,"240 litres",240,0.24]
[null,"660 litres",660,0.66]
[null,"Front lift 1.5m3",1500,1.5]
[null,"Front lift 3.0m3",3000,3]
[null,"Front Lift 4.5m3",4500,4.5]
[]
[]
[]
[null,"1 litre = 0.001 cubic metres"]
[]
[]
[null,"Food waste","1m3 = 400kg"]
[null,null,"0.25m3 = 100kg"]
[]
[]
[null,"Food Waste Types"]
[null,"Food scraps from plates"]
[null,"Vegetable peelings"]
[null,"Fruit & Vegetables"]
[null,"Dense food scraps"]
[null,"All of the above"]