{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["School Information","Paper purchased","How much waste","What's in your waste","Waste Minimisation","DataStore","Additional Constants","Waste Composition","Recommendation List","Report One","Report Two","Report Three","Report Four","Report Five"],"not_rendered":{"charts":5,"images":31,"macros":1,"external_links":0,"defined_names":18,"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":"School Information","index":0,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[8,3,8,13],[9,3,9,13],[0,2,0,13],[3,3,3,13],[5,3,5,13],[6,3,6,13]]}
[null,null,"School Waste Calculator"]
[null,null,null,null,null,null,null,null,"page 1 of 5"]
[]
[null,null,"School Name"]
[]
[null,null,"Number of Students"]
[null,null,"Number of Staff"]
[]
[null,null,"State or Teritory","NSW"]
[null,null,"Local Government Area"]

{"sheet":"Paper purchased","index":1,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,2,0,13],[3,2,3,13],[6,3,6,11],[8,3,8,11],[5,3,5,11]]}
[null,null,"School Waste Calculator",null,null,null,null,null,null,null,null,null,null,null,null,null,"Explanation - Delete when happy"]
[null,null,null,null,null,null,null,null,"page 2 of 5"]
[]
[null,null,"Paper Purchases"]
[]
[null,null,"Number of Reams A4",null,null,null,null,null,null,null,null,null,null,null,null,null," to be multiplied by 2.5 to give KG"]
[null,null,"Over What Period",null,null,null,null,null,null,null,null,null,null,null,null,null,"to allow for period calculation"]
[]
[null,null,"Recycled Content (%)",null,null,null,null,null,null,null,null,null,null,null,null,null,"to modify the footprint and consider alternatives"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"foot print formulae"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GH/kg","=(0.0006394)-((0.0000131799999999999)*(100*recycled content (C1)))"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Based on examples from Vic EPA doc"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"multiple by kg and by period modifier to determine outcome"]

{"sheet":"How much waste","index":2,"n_rows":141,"n_cols":22,"rows_kept":141,"cut":false,"hidden":false,"merged":[[120,14,122,16],[121,6,121,8],[122,9,122,10],[121,9,121,10],[45,15,45,17],[57,11,57,13],[57,15,57,17],[60,7,60,9],[60,11,60,13],[60,15,60,17],[54,7,54,9],[54,11,54,13],[62,15,62,17],[57,7,57,9],[140,4,143,17],[98,4,100,17],[64,7,64,9],[64,11,64,13],[64,15,64,17],[66,7,66,9],[66,11,66,13],[66,15,66,17],[130,4,132,4],[130,6,130,8],[130,9,130,10],[139,4,139,11],[128,6,128,8],[128,9,128,10],[128,14,130,16],[129,6,129,8],[122,6,122,8],[111,4,116,4],[112,6,112,7],[115,6,115,7],[129,9,129,10],[120,4,124,4],[120,6,120,8],[120,9,120,10],[17,15,17,17],[19,7,19,9],[19,11,19,13],[19,15,19,17],[21,7,21,9],[21,11,21,13],[21,15,21,17],[23,7,23,9],[23,11,23,13],[23,15,23,17],[25,15,25,17],[27,7,27,9],[27,11,27,13],[37,7,37,9],[37,11,37,13],[52,7,52,9],[52,11,52,13],[52,15,52,17],[27,15,27,17],[35,15,35,17],[29,7,29,9],[29,15,29,17],[31,7,31,9],[31,11,31,13],[31,15,31,17],[33,15,33,17],[37,15,37,17],[50,15,50,17],[39,3,39,5],[39,7,39,9],[39,11,39,13],[39,15,39,17],[41,7,41,9],[41,11,41,13],[41,15,41,17],[54,15,54,17],[48,7,48,9],[48,11,48,13],[48,15,48,17],[43,15,43,17],[45,7,45,9],[45,11,45,13],[0,2,0,19],[7,7,7,9],[7,11,7,13],[7,15,7,17],[3,2,3,19],[86,4,88,4],[13,15,13,17],[19,3,19,5],[15,15,15,17],[17,7,17,9],[73,4,73,13],[9,3,9,5],[74,4,77,17],[5,7,5,9],[5,11,5,13],[5,15,5,17],[35,7,35,9],[35,11,35,13],[13,11,13,13],[15,7,15,9],[15,11,15,13],[9,15,9,17],[11,15,11,17],[9,7,9,9],[9,11,9,13],[11,7,11,9],[11,11,11,13],[13,7,13,9],[102,4,107,4],[102,10,102,12],[103,6,103,7],[105,6,105,7],[107,6,107,7],[29,3,29,5],[33,7,33,9],[33,11,33,13],[50,3,50,5],[50,7,50,9],[50,11,50,13],[43,7,43,9],[43,11,43,13],[62,3,62,5],[62,7,62,9],[62,11,62,13],[25,7,25,9],[25,11,25,13],[17,11,17,13],[29,11,29,13]]}
[null,null,"School Waste Calculator"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"page 3 of 5"]
[]
[null,null,"How Much Waste \n(see tips at bottom of page)"]
[]
[null,null,null,null,"General Waste (garbage to landfill)",null,null,"Bin Type One",null,null,null,"Bin Type Two",null,null,null,"Bin Type Three"]
[]
[null,null,null,"Bin Size (in cubic meters)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H15,L15,P15),TRUE,FALSE)","v":false}]
[]
[null,null,null,"How many times per week is it collected"]
[]
[null,null,null,"How many bins"]
[]
[null,null,null,"How full are the bins (% estimate)"]
[null,null,null,null,null,null,null,{"$f":"IF(H8>0,IF(H10>0,IF(H12>0,IF(H14>0,TRUE,FALSE))))","v":false},null,null,null,{"$f":"IF(L8>0,IF(L10>0,IF(L12>0,IF(L14>0,TRUE,FALSE))))","v":false},null,null,null,{"$f":"IF(P8>0,IF(P10>0,IF(P12>0,IF(P14>0,TRUE,FALSE))))","v":false}]
[null,null,null,null,"Paper Recycling",null,null,"Bin Type One",null,null,null,"Bin Type Two",null,null,null,"Bin Type Three"]
[]
[null,null,null,"Bin Size",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H25,L25,P25),TRUE,FALSE)","v":false}]
[]
[null,null,null,"How many times per week is it collected"]
[]
[null,null,null,"How many bins",null,null,null,2]
[]
[null,null,null,"How full are the bins (% estimate)"]
[null,null,null,null,null,null,null,{"$f":"IF(H18>0,IF(H20>0,IF(H22>0,IF(H24>0,TRUE,FALSE))))","v":false},null,null,null,{"$f":"IF(L18>0,IF(L20>0,IF(L22>0,IF(L24>0,TRUE,FALSE))))","v":false},null,null,null,{"$f":"IF(P18>0,IF(P20>0,IF(P22>0,IF(P24>0,TRUE,FALSE))))","v":false}]
[null,null,null,null,"Cardboard Recycling",null,null,"Bin Type One",null,null,null,"Bin Type Two",null,null,null,"Bin Type Three"]
[]
[null,null,null,"Bin Size",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H35,L35,P35),TRUE,FALSE)","v":false}]
[]
[null,null,null,"How many times per week is it collected"]
[]
[null,null,null,"How many bins"]
[]
[null,null,null,"How full are the bins (% estimate)"]
[null,null,null,null,null,null,null,{"$f":"IF(H28>0,IF(H30>0,IF(H32>0,IF(H34>0,TRUE,FALSE))))","v":false},null,null,null,{"$f":"IF(L28>0,IF(L30>0,IF(L32>0,IF(L34>0,TRUE,FALSE))))","v":false},null,null,null,{"$f":"IF(P28>0,IF(P30>0,IF(P32>0,IF(P34>0,TRUE,FALSE))))","v":false}]
[null,null,null,null,"Comingled Recycling",null,null,"Bin Type One",null,null,null,"Bin Type Two",null,null,null,"Bin Type Three"]
[]
[null,null,null,"Bin Size",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H45,L45,P45),TRUE,FALSE)","v":false}]
[]
[null,null,null,"How many times per week is it collected"]
[]
[null,null,null,"How many bins"]
[]
[null,null,null,"How full are the bins (% estimate)"]
[null,null,null,null,null,null,null,{"$f":"IF(H38>0,IF(H40>0,IF(H42>0,IF(H44>0,TRUE,FALSE))))","v":false},null,null,null,{"$f":"IF(L38>0,IF(L40>0,IF(L42>0,IF(L44>0,TRUE,FALSE))))","v":false},null,null,null,{"$f":"IF(P38>0,IF(P40>0,IF(P42>0,IF(P44>0,TRUE,FALSE))))","v":false}]
[null,null,null,null,"Other Recycling",null,null,"Bin Type One",null,null,null,"Bin Type Two",null,null,null,"Bin Type Three"]
[]
[]
[null,null,null,"Bin Size",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H56,L56,P56),TRUE,FALSE)","v":false}]
[]
[null,null,null,"How many times per week is it collected"]
[]
[null,null,null,"How many bins"]
[]
[null,null,null,"How full are the bins (% estimate)"]
[null,null,null,null,null,null,null,{"$f":"IF(H49>0,IF(H51>0,IF(H53>0,IF(H55>0,TRUE,FALSE))))","v":false},null,null,null,{"$f":"IF(L49>0,IF(L51>0,IF(L53>0,IF(L55>0,TRUE,FALSE))))","v":false},null,null,null,{"$f":"IF(P49>0,IF(P51>0,IF(P53>0,IF(P55>0,TRUE,FALSE))))","v":false}]
[]
[null,null,null,null,"Other Waste Diverted or Reused",null,null,"Bin Type One",null,null,null,"Bin Type Two",null,null,null,"Bin Type Three"]
[]
[]
[null,null,null,"Bin Size",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H68,L68,P68),TRUE,FALSE)","v":false}]
[]
[null,null,null,"How many times per week is it collected"]
[]
[null,null,null,"How many bins"]
[]
[null,null,null,"How full are the bins (% estimate)"]
[null,null,null,null,null,null,null,{"$f":"IF(H61>0,IF(H63>0,IF(H65>0,IF(H67>0,TRUE,FALSE))))","v":false},null,null,null,{"$f":"IF(L61>0,IF(L63>0,IF(L65>0,IF(L67>0,TRUE,FALSE))))","v":false},null,null,null,{"$f":"IF(P61>0,IF(P63>0,IF(P65>0,IF(P67>0,TRUE,FALSE))))","v":false}]
[]
[]
[]
[]
[]
[null,null,null,"TIP","Different types of bins and collections"]
[null,null,null,null,"For each bin configuration use a separate column within the waste stream.  This will allow for waste streams that may have different bin sizes or different collection days."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"TIP","How often the bin is collected","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"]
[null,null,null,null,"Place a one in each day the bin(s) are collected over a 2 week period"]
[]
[]
[null,null,null,null,"Information to enter"]
[null,null,null,null,{"$f":"SUM(F88:S88)/2","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,null,"TIP","How big is my bin (cubic metres)"]
[null,null,null,null,"Your waste service provider or the invoice from the waste service provider will assist in identifying the size of your bin.  Please record the size in m3."]
[]
[]
[]
[null,null,null,null,"We have a wheelie bin but which size?",null,"Small (120 lts)"]
[null,null,null,null,null,null,0.12,null,null,null,null,"~ 940mm x 485mm x 560mm"]
[null,null,null,null,null,null,"Normal (240 lts)"]
[null,null,null,null,null,null,0.24,null,null,null,null,"~ 1080mm x 580mm x 735mm"]
[null,null,null,null,null,null,"Large (360 lts)"]
[null,null,null,null,null,null,0.36,null,null,null,null,"~ 1080mm x 580mm x 735mm"]
[]
[]
[]
[null,null,null,null,"We have a rear lift bin, but which size?",null,"660lt bin"]
[null,null,null,null,null,null,0.66,null,null,null,"~ 1200mm x 1200mm x 780mm"]
[]
[null,null,null,null,null,null,"1100lt bin"]
[null,null,null,null,null,null,1.1000000000000001,null,null,null,"~ 1330mm x 1240mm x 1070mm"]
[]
[]
[]
[null,null,null,null,null,null,"Ignore the base plate or wheels in all measurements"]
[null,null,null,null,"We have a front lift bin, but how big?",null,"How High",null,null,null,null,"mm",null,null,{"$f":"ROUND(((J121/1000)*(J122/1000)*(J123/1000))/0.25,0)*0.25","v":0}]
[null,null,null,null,null,null,"How Long",null,null,null,null,"mm"]
[null,null,null,null,null,null,"How Deep",null,null,null,null,"mm"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"How High",null,null,null,null,"mm",null,null,{"$f":"ROUND(((J129/1000)*(J130/1000)*(J131/1000))/0.25,0)*0.25","v":0}]
[null,null,null,null,null,null,"How Long",null,null,null,null,"mm"]
[null,null,null,null,"We have a skip bin, but how big?",null,"How Deep",null,null,null,null,"mm"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"TIP","Other waste diverted at your school"]
[null,null,null,null,"Are there other wastes generated in your school that are diverted or reused in your school?  If you didn't use this in your school would they go in the bin?  If YES you are diverting or reusing waste.  Try and estimate how much of this there is (use the bin size tips as a guide) per week and then it will be measured in your waste diversion rate."]

{"sheet":"What's in your waste","index":3,"n_rows":31,"n_cols":36,"rows_kept":31,"cut":false,"hidden":false,"merged":[[29,4,29,16],[15,3,15,4],[23,5,23,6],[23,7,23,8],[23,13,23,14],[23,16,23,17],[19,9,19,10],[19,11,19,12],[23,21,23,22],[21,5,21,6],[21,7,21,8],[21,13,21,14],[21,16,21,17],[21,18,21,19],[21,21,21,22],[23,18,23,19],[21,9,21,10],[21,11,21,12],[9,9,9,10],[9,11,9,12],[19,21,19,22],[17,5,17,6],[17,7,17,8],[17,13,17,14],[17,16,17,17],[17,18,17,19],[17,21,17,22],[19,5,19,6],[19,7,19,8],[19,13,19,14],[19,16,19,17],[19,18,19,19],[17,9,17,10],[17,11,17,12],[0,2,0,24],[7,5,7,6],[7,7,7,8],[7,13,7,14],[7,16,7,17],[7,18,7,19],[7,21,7,22],[7,9,7,10],[7,11,7,12],[3,2,3,25],[11,9,11,10],[11,11,11,12],[30,4,33,22],[9,5,9,6],[11,5,11,6],[9,7,9,8],[11,7,11,8],[9,13,9,14],[11,13,11,14],[11,21,11,22],[9,16,9,17],[11,16,11,17],[9,18,9,19],[13,4,13,22],[9,21,9,22],[11,18,11,19]]}
[null,null,"School Waste Calculator"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"page 4 of 5"]
[]
[null,null,"What's in Your Waste \n(see tips at bottom of page)"]
[]
[null,null,null,"Waste Stream",null,"Recyclable Paper",null,"Cardboard",null,"Recyclable Glass",null,"Recyclable Plastic",null,"Recyclable Metal",null,null,"Food Waste",null,"Garden waste",null,null,"General Waste"]
[]
[null,null,null,null,"General Waste",{"$f":"AC8","v":0.42},null,{"$f":"AD8","v":0.21},null,{"$f":"AE8","v":0},null,{"$f":"AF8","v":0.05},null,{"$f":"AG8","v":0.01},null,null,{"$f":"AH8","v":0.04},null,{"$f":"AI8","v":0.09},null,null,{"$f":"AJ8","v":0.19},null,null,null,null,null,{"$f":"IF(OR(SUM(F8:W8)=1,SUM(F8:W8)=0),TRUE,FALSE)","v":false},{"$f":"'Waste Composition'!C86","v":0.42},{"$f":"'Waste Composition'!D86","v":0.21},{"$f":"'Waste Composition'!E86","v":0},{"$f":"'Waste Composition'!F86","v":0.05},{"$f":"'Waste Composition'!G86","v":0.01},{"$f":"'Waste Composition'!H86","v":0.04},{"$f":"'Waste Composition'!I86","v":0.09},{"$f":"'Waste Composition'!J86","v":0.19}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Waste Composition'!C87","v":0.65},{"$f":"'Waste Composition'!D87","v":0.19},{"$f":"'Waste Composition'!E87","v":0},{"$f":"'Waste Composition'!F87","v":7.0000000000000007E-2},{"$f":"'Waste Composition'!G87","v":0.01},{"$f":"'Waste Composition'!H87","v":0},{"$f":"'Waste Composition'!I87","v":0},{"$f":"'Waste Composition'!J87","v":0.08}]
[null,null,null,null,"Comingled Recycling",{"$f":"AC9","v":0.65},null,{"$f":"AD9","v":0.19},null,{"$f":"AE9","v":0},null,{"$f":"AF9","v":7.0000000000000007E-2},null,{"$f":"AG9","v":0.01},null,null,{"$f":"AH9","v":0},null,{"$f":"AI9","v":0},null,null,{"$f":"AJ9","v":0.08},null,null,{"$f":"SUM(F10:W10)","v":1.0000000000000002},null,null,{"$f":"IF(OR(SUM(F10:W10)=1,SUM(F10:W10)=0),TRUE,FALSE)","v":true},{"$f":"'Waste Composition'!C88","v":0.56000000000000005},{"$f":"'Waste Composition'!D88","v":0.39},{"$f":"'Waste Composition'!E88","v":0},{"$f":"'Waste Composition'!F88","v":0.01},{"$f":"'Waste Composition'!G88","v":0},{"$f":"'Waste Composition'!H88","v":0},{"$f":"'Waste Composition'!I88","v":0},{"$f":"'Waste Composition'!J88","v":0.04}]
[]
[null,null,null,null,"Cardboard Recycling",{"$f":"AC10","v":0.56000000000000005},null,{"$f":"AD10","v":0.39},null,{"$f":"AE10","v":0},null,{"$f":"AF10","v":0.01},null,{"$f":"AG10","v":0},null,null,{"$f":"AH10","v":0},null,{"$f":"AI10","v":0},null,null,{"$f":"AJ10","v":0.04},null,null,{"$f":"SUM(F12:W12)","v":1},null,null,{"$f":"IF(OR(SUM(F12:W12)=1,SUM(F12:W12)=0),TRUE,FALSE)","v":true}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Waste Composition'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Waste Composition'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Waste Composition'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Waste Composition'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Waste Composition'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Waste Composition'!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"Indicate if you have conducted a waste audit by ticking the box next to the audited streams and complete the breakdown for the stream.  A tick will appear when the composition totals to 100%.\n\nWaste Stream",null,"Recyclable Paper",null,"Cardboard",null,"Recyclable Glass",null,"Recyclable Plastic",null,"Recyclable Metal",null,null,"Food Waste",null,"Garden waste",null,null,"General Waste"]
[]
[null,null,null,false,"General Waste",0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,null,0,null,null,{"$f":"IF(AND(D18=TRUE,(ROUND(AC18,2)=1)),\"ü\",IF(D18=TRUE,\"û\",\"\"))","v":""},null,null,null,{"$f":"SUM(F18:W18)","v":0}]
[]
[null,null,null,false,"Comingled Recycling",0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,null,0,null,null,{"$f":"IF(AND(D20=TRUE,(ROUND(AC20,2)=1)),\"ü\",IF(D20=TRUE,\"û\",\"\"))","v":""},null,null,null,{"$f":"SUM(F20:W20)","v":0}]
[]
[null,null,null,false,"Paper/Cardboard Recycling",0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,null,0,null,null,{"$f":"IF(AND(D22=TRUE,(ROUND(AC22,2)=1)),\"ü\",IF(D22=TRUE,\"û\",\"\"))","v":""},null,null,null,{"$f":"SUM(F22:W22)","v":0}]
[]
[null,null,null,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D24=TRUE,(ROUND(AC24,2)=1)),\"ü\",IF(D24=TRUE,\"û\",\"\"))","v":""}]
[]
[]
[]
[]
[]
[null,null,null,"TIP","We haven't done a waste audit!"]
[null,null,null,null,"Don't worry, if you haven't done a waste, the calculator will estimate the types of waste generated in school environments with similar waste and recycling services as yours.  If your school is particular effective at recycling or reducing waste, it would be worth having a look at what is in your waste stream as it might be different to the 'average' school.  If you want to use the defaul values again, just untick your audit data."]

{"sheet":"Waste Minimisation","index":4,"n_rows":29,"n_cols":16,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,2,0,20],[3,2,3,20]]}
[null,null,"School Waste Calculator"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"page 5 of 5"]
[]
[null,null,"Waste Minimisation"]
[]
[]
[null,null,null,null,"We recycle printer cartridges. ",null,null,null,null,null,null,false]
[null,null,null,null,"We recycled fluorescent tubes. ",null,null,null,null,null,null,false]
[null,null,null,null,"We recycle computers",null,null,null,null,null,null,false]
[null,null,null,null,"We recycle mobile phones",null,null,null,null,null,null,false]
[]
[null,null,null,null,"We have litter free lunch days",null,null,null,null,null,null,false]
[null,null,null,null,"We have a school policy to print double sided",null,null,null,null,null,null,false]
[null,null,null,null,"We print in black and white",null,null,null,null,null,null,false]
[null,null,null,null,"We use recycled paper",null,null,null,null,null,null,false]
[null,null,null,null,"Our school is plastic bag free",null,null,null,null,null,null,false]
[null,null,null,null,"Double Sided Printing",null,null,null,null,null,null,false]
[null,null,null,null,"Reuse of single sided paper",null,null,null,null,null,null,false]
[null,null,null,null,"Electronic filing and communication systems",null,null,null,null,null,null,false]
[null,null,null,null,"Electronic publishing",null,null,null,null,null,null,false]
[null,null,null,null,"Policies to minimise offsite introduction of packaging",null,null,null,null,null,null,false]
[]
[null,null,null,null,"Other",null,null,null,null,false,null,{"$f":"IF(OR(J23,L25,L26,L28,L29=TRUE),TRUE,FALSE)","v":false}]
[]
[null,null,null,null,null,null,null,null,null,false,null,{"$f":"IF(OR(J25=TRUE,E25<>\"\"),TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,false,null,{"$f":"IF(OR(J26=TRUE,E27<>\"\"),TRUE,FALSE)","v":false}]
[]
[null,null,null,null,null,null,null,null,null,false,null,{"$f":"IF(OR(J28=TRUE,E29<>\"\"),TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,false,null,{"$f":"IF(OR(J29=TRUE,E31<>\"\"),TRUE,FALSE)","v":false}]

{"sheet":"DataStore","index":5,"n_rows":109,"n_cols":10,"rows_kept":109,"cut":false,"hidden":true,"merged":[]}
["School Name",{"$f":"'School Information'!D4","v":0}]
[]
["Number of Students",{"$f":"'School Information'!D6","v":0}]
["Number of Staff",{"$f":"'School Information'!D7","v":0}]
[]
["What State",{"$f":"'School Information'!D9","v":"NSW"}]
["Local Government Area",{"$f":"'School Information'!D10","v":0}]
["Pg2"]
["Number of Reams A4",{"$f":"'Paper purchased'!D6","v":0}]
["Over What Period",{"$f":"'Paper purchased'!D7","v":0}]
[]
["Recycled Content (%)",{"$f":"'Paper purchased'!D9","v":0}]
["Pg3"]
["General Waste (garbage to landfill)",{"$f":"B16*B18*B20*B22","v":0},{"$f":"C16*C18*C20*C22","v":0},{"$f":"D16*D18*D20*D22","v":0},{"$f":"SUM(B14:D14)","v":0},{"$f":"B16*B18*B20","v":0}]
[]
["Bin Size",{"$f":"'How much waste'!H8","v":0},{"$f":"'How much waste'!L8","v":0},{"$f":"'How much waste'!P8","v":0}]
[]
["How many times per week is it collected",{"$f":"'How much waste'!H10","v":0},{"$f":"'How much waste'!L10","v":0},{"$f":"'How much waste'!P10","v":0}]
[]
["How many bins",{"$f":"'How much waste'!H12","v":0},{"$f":"'How much waste'!L12","v":0},{"$f":"'How much waste'!P12","v":0}]
[]
["How full are the bins (% estimate)",{"$f":"'How much waste'!H14","v":0},{"$f":"'How much waste'!L14","v":0},{"$f":"'How much waste'!P14","v":0}]
[]
["Paper Recycling",{"$f":"B26*B28*B30*B32","v":0},{"$f":"C26*C28*C30*C32","v":0},{"$f":"D26*D28*D30*D32","v":0},{"$f":"SUM(B24:D24)","v":0},{"$f":"B26*B28*B30","v":0}]
[]
["Bin Size",{"$f":"'How much waste'!H18","v":0},{"$f":"'How much waste'!L18","v":0},{"$f":"'How much waste'!P18","v":0}]
[]
["How many times per week is it collected",{"$f":"'How much waste'!H20","v":0},{"$f":"'How much waste'!L20","v":0},{"$f":"'How much waste'!P20","v":0}]
[]
["How many bins",{"$f":"'How much waste'!H22","v":2},{"$f":"'How much waste'!L22","v":0},{"$f":"'How much waste'!P22","v":0}]
[]
["How full are the bins (% estimate)",{"$f":"'How much waste'!H24","v":0},{"$f":"'How much waste'!L24","v":0},{"$f":"'How much waste'!P24","v":0}]
[]
["Cardboard Recycling",{"$f":"B36*B38*B40*B42","v":0},{"$f":"C36*C38*C40*C42","v":0},{"$f":"D36*D38*D40*D42","v":0},{"$f":"SUM(B34:D34)","v":0},{"$f":"B36*B38*B40","v":0}]
[]
["Bin Size",{"$f":"'How much waste'!H28","v":0},{"$f":"'How much waste'!L28","v":0},{"$f":"'How much waste'!P28","v":0}]
[]
["How many times per week is it collected",{"$f":"'How much waste'!H30","v":0},{"$f":"'How much waste'!L30","v":0},{"$f":"'How much waste'!P30","v":0}]
[]
["How many bins",{"$f":"'How much waste'!H32","v":0},{"$f":"'How much waste'!L32","v":0},{"$f":"'How much waste'!P32","v":0}]
[]
["How full are the bins (% estimate)",{"$f":"'How much waste'!H34","v":0},{"$f":"'How much waste'!L34","v":0},{"$f":"'How much waste'!P34","v":0}]
[]
["General Recycling (Comingled)",{"$f":"B46*B48*B50*B52","v":0},{"$f":"C46*C48*C50*C52","v":0},{"$f":"D46*D48*D50*D52","v":0},{"$f":"SUM(B44:D44)","v":0},{"$f":"B46*B48*B50","v":0}]
[]
["Bin Size",{"$f":"'How much waste'!H38","v":0},{"$f":"'How much waste'!L38","v":0},{"$f":"'How much waste'!P38","v":0}]
[]
["How many times per week is it collected",{"$f":"'How much waste'!H40","v":0},{"$f":"'How much waste'!L40","v":0},{"$f":"'How much waste'!P40","v":0}]
[]
["How many bins",{"$f":"'How much waste'!H42","v":0},{"$f":"'How much waste'!L42","v":0},{"$f":"'How much waste'!P42","v":0}]
[]
["How full are the bins (% estimate)",{"$f":"'How much waste'!H44","v":0},{"$f":"'How much waste'!L44","v":0},{"$f":"'How much waste'!P44","v":0}]
[]
["Other Rceycling",{"$f":"B57*B59*B61*B63","v":0},{"$f":"C57*C59*C61*C63","v":0},{"$f":"D57*D59*D61*D63","v":0},{"$f":"SUM(B54:D54)","v":0},{"$f":"B57*B59*B61","v":0},null,"Garden Waste"]
[{"$f":"'How much waste'!E47","v":0}]
[]
["Bin Size",{"$f":"'How much waste'!H49","v":0},{"$f":"'How much waste'!L49","v":0},{"$f":"'How much waste'!P49","v":0}]
[]
["How many times per week is it collected",{"$f":"'How much waste'!H51","v":0},{"$f":"'How much waste'!L51","v":0},{"$f":"'How much waste'!P51","v":0}]
[]
["How many bins",{"$f":"'How much waste'!H53","v":0},{"$f":"'How much waste'!L53","v":0},{"$f":"'How much waste'!P53","v":0}]
[]
["How full are the bins (% estimate)",{"$f":"'How much waste'!H55","v":0},{"$f":"'How much waste'!L55","v":0},{"$f":"'How much waste'!P55","v":0}]
[]
[]
["Other Waste Divered or Reused",{"$f":"B69*B71*B73*B75","v":0},{"$f":"C69*C71*C73*C75","v":0},{"$f":"D69*D71*D73*D75","v":0},{"$f":"SUM(B66:D66)","v":0},{"$f":"B69*B71*B73","v":0}]
[{"$f":"OtherDivert","v":0}]
[]
["Bin Size",{"$f":"'How much waste'!H61","v":0},{"$f":"'How much waste'!L61","v":0},{"$f":"'How much waste'!P61","v":0}]
[]
["How many times per week is it collected",{"$f":"'How much waste'!H63","v":0},{"$f":"'How much waste'!L63","v":0},{"$f":"'How much waste'!P63","v":0}]
[]
["How many bins",{"$f":"'How much waste'!H65","v":0},{"$f":"'How much waste'!L65","v":0},{"$f":"'How much waste'!P65","v":0}]
[]
["How full are the bins (% estimate)",{"$f":"'How much waste'!H67","v":0},{"$f":"'How much waste'!L67","v":0},{"$f":"'How much waste'!P67","v":0}]
[]
["Pg4"]
["Waste Stream","Paper","Cardboard","Containers Bottles and Tubs","Food","Garden waste","Other Waste"]
[]
["General Waste",{"$f":"'What''s in your waste'!F8","v":0.42},{"$f":"'What''s in your waste'!H8","v":0.21},{"$f":"'What''s in your waste'!N8","v":0.01},{"$f":"'What''s in your waste'!Q8","v":0.04},{"$f":"'What''s in your waste'!S8","v":0.09},{"$f":"'What''s in your waste'!V8","v":0.19},null,{"$f":"'What''s in your waste'!D18","v":false}]
[]
["Paper Recycling",{"$f":"'What''s in your waste'!F10","v":0.65},{"$f":"'What''s in your waste'!H10","v":0.19},{"$f":"'What''s in your waste'!N10","v":0.01},{"$f":"'What''s in your waste'!Q10","v":0},{"$f":"'What''s in your waste'!S10","v":0},{"$f":"'What''s in your waste'!V10","v":0.08},null,{"$f":"'What''s in your waste'!D20","v":false}]
[]
["Cardboard Recycling",{"$f":"'What''s in your waste'!F12","v":0.56000000000000005},{"$f":"'What''s in your waste'!H12","v":0.39},{"$f":"'What''s in your waste'!N12","v":0},{"$f":"'What''s in your waste'!Q12","v":0},{"$f":"'What''s in your waste'!S12","v":0},{"$f":"'What''s in your waste'!V12","v":0.04},null,{"$f":"'What''s in your waste'!D22","v":false}]
[null,null,null,null,null,null,null,null,null,"No Waste Audit"]
["Comingled General Recycling",{"$f":"'What''s in your waste'!#REF!","v":{"$error":"#REF!"}},{"$f":"'What''s in your waste'!#REF!","v":{"$error":"#REF!"}},{"$f":"'What''s in your waste'!#REF!","v":{"$error":"#REF!"}},{"$f":"'What''s in your waste'!#REF!","v":{"$error":"#REF!"}},{"$f":"'What''s in your waste'!#REF!","v":{"$error":"#REF!"}},{"$f":"'What''s in your waste'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'What''s in your waste'!D24","v":false},{"$f":"IF(AND(I80=FALSE,I82=FALSE,I84=FALSE,I86=FALSE),TRUE,FALSE)","v":true}]
[]
["Pg5"]
["We recycle printer cartridges. ",{"$f":"'Waste Minimisation'!L7","v":false}]
["We recycled fluorescent tubes. ",{"$f":"'Waste Minimisation'!L8","v":false}]
["We recycle computers",{"$f":"'Waste Minimisation'!L9","v":false}]
["We recycle mobile phones",{"$f":"'Waste Minimisation'!L10","v":false}]
[]
["We have litter free lunch days",{"$f":"'Waste Minimisation'!L12","v":false}]
["We have a school policy to print double sided",{"$f":"'Waste Minimisation'!L13","v":false}]
["We print in black and white",{"$f":"'Waste Minimisation'!L14","v":false}]
["We use recycled paper",{"$f":"'Waste Minimisation'!L15","v":false}]
["Our school is plastic bag free",{"$f":"'Waste Minimisation'!L16","v":false}]
["Double Sided Printing",{"$f":"'Waste Minimisation'!L17","v":false}]
["Reuse of single sided paper",{"$f":"'Waste Minimisation'!L18","v":false}]
["Electronic filing and communication systems",{"$f":"'Waste Minimisation'!L19","v":false}]
["Electronic publishing",{"$f":"'Waste Minimisation'!L20","v":false}]
["Policies to minimise offsite introduction of packaging",{"$f":"'Waste Minimisation'!L21","v":false}]
[]
["Other",{"$f":"'Waste Minimisation'!L23","v":false}]
[{"$f":"'Waste Minimisation'!E25","v":0},{"$f":"'Waste Minimisation'!L25","v":false}]
[{"$f":"'Waste Minimisation'!E27","v":0},{"$f":"'Waste Minimisation'!L26","v":false}]
[{"$f":"'Waste Minimisation'!E29","v":0},{"$f":"'Waste Minimisation'!L28","v":false}]
[{"$f":"'Waste Minimisation'!E31","v":0},{"$f":"'Waste Minimisation'!L29","v":false}]

{"sheet":"Additional Constants","index":6,"n_rows":63,"n_cols":18,"rows_kept":63,"cut":false,"hidden":true,"merged":[]}
["State","DR Target","Calculated Diversion Rate"]
["Qld",0.6,null,{"$f":"IF(SUM(DataStore!E14:E66)<>0,(SUM(DataStore!E24:E66)/SUM(DataStore!E14:E66)),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,13089600,60605,{"$f":"P2/Q2","v":215.98217968814456}]
["NSW",0.63,null,null,null,null,null,null,null,null,null,null,null,null,null,1038969400,4810428,{"$f":"P3/Q3","v":215.98273583972153}]
["Vic",0.8]
["SA",0.75,null,null,null,null,null,null,null,null,null,null,null,null,null,17452800,317324,{"$f":"P5/Q5","v":54.999936972936176}]
["WA",0.45,null,null,null,null,null,null,null,null,null,null,null,null,null,546826000,9942291,{"$f":"P6/Q6","v":54.999999497097804}]
["TAS","Not Set",null,null,null,null,null,null,null,null,null,null,null,null,null,1157371600,21043120,{"$f":"P7/Q7","v":55}]
["ACT",0.85,null,null,null,null,null,null,null,null,null,null,null,null,null,29306200,532840,{"$f":"P8/Q8","v":55}]
["NT","Not Set"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,258878400]
["Env Benefits of Rceycling",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P10/F49","v":62176040.364719674}]
["Material","GHG (Co2/tonne)","GJ/Tonne","KL/tonne","Landfill m3/tonne"]
["Paper/Cardboard",0.4,18,23.7,3.2314370000000001]
["LPB",-2,7.2,9.6,2.7807710000000001]
["Glass",0.4,3.8,2,1.7970969999999999]
["Aluminium",15.2,171,233.2,0.85834999999999995]
["Steel",0.8,32.9,1.1000000000000001,2.8403589999999999]
["HDPE",0.5,46.8,-10.4,1.915327]
["PET",1.5,49.5,{"$f":"-12.1","v":-12.1},1.915327]
[]
["Composition of comingled recycling in schools","Volume","Volume to mass conversion",null,null,"GHG (Co2/tonne)","GJ/Tonne","KL/tonne","Landfill m3/tonne"]
["P& C",{"$f":"SUM('Waste Composition'!C99:D103)","v":0},76,{"$f":"C22*B22","v":0},null,{"$f":"($D22/1000)*B13","v":0},{"$f":"($D22/1000)*C13","v":0},{"$f":"($D22/1000)*D13","v":0},0]
["LPB",{"$f":"B39*SUM('Waste Composition'!E$99:E$103)","v":0},45,{"$f":"C23*B23","v":0},null,{"$f":"($D23/1000)*B14","v":0},0,{"$f":"($D23/1000)*D14","v":0},0]
["Glass",{"$f":"B40*SUM('Waste Composition'!E$99:E$103)","v":0},150,0,null,0,0,0,0]
["Aluminium",{"$f":"B41*SUM('Waste Composition'!E$99:E$103)","v":0},45,0,null,0,0,0,0]
["Steel",{"$f":"B42*SUM('Waste Composition'!E$99:E$103)","v":0},85,0,null,0,0,0,0]
["HDPE",{"$f":"B43*SUM('Waste Composition'!E$99:E$103)","v":0},45,0,null,0,0,0,0]
["PET",{"$f":"B44*SUM('Waste Composition'!E$99:E$103)","v":0},45,0,null,0,0,0,0]
[null,"Bulimba","Cab SS","Hermit Park"]
["Paper/Cardboard",{"$f":"1-SUM(B31:B36)","v":0.35300000000000009},{"$f":"1-SUM(C31:C36)","v":0.88933333333333331},{"$f":"1-SUM(D31:D36)","v":0.99369482976040358},null,{"$f":"(C30*B30)*C$45","v":0}]
["LPB",0.17699999999999999,2.1999999999999999E-2,2.5220680958385876E-3,null,{"$f":"(C31*B31)*C$45","v":0}]
["Glass",2E-3,2.1999999999999999E-2,0,null,0]
["Aluminium",1.9E-2,4.4444444444444444E-3,1.2610340479192938E-3,null,0]
["Steel",1.6E-2,2.2222222222222223E-2,1.2610340479192938E-3,null,0]
["HDPE",0.32300000000000001,8.8888888888888889E-3,1.2610340479192938E-3,null,0]
["PET",0.11,3.111111111111111E-2,0,null,0]
[null,null,null,null,null,0]
[null,{"$f":"SUM(B31:B36)","v":0.64699999999999991},null,null,null,0]
[null,{"$f":"B31/B$38","v":0.27357032457496139},null,null,null,0]
[null,3.0911901081916542E-3,null,null,null,0]
[null,2.9366306027820713E-2,null,null,null,0]
[null,2.4729520865533233E-2,null,null,null,0]
[null,0.49922720247295216,null,null,null,0]
[null,0.17001545595054099,null,null,null,0]
[null,null,{"$f":"DataStore!E44","v":0},{"$f":"SUM(D22:D28)","v":0},null,{"$f":"SUM(F22:F28)","v":0},{"$f":"SUM(G22:G28)","v":0},{"$f":"SUM(H22:H28)","v":0},{"$f":"SUM(I22:I28)","v":0}]
[null,null,"Meters 3","KG",null,"tCO2 eq","GJ electricity","KL water","m3 of landfill"]
[null,null,null,null,"@ 45 wks/annum",{"$f":"F45*45","v":0},{"$f":"G45*45","v":0},{"$f":"H45*45","v":0},{"$f":"I45*45","v":0}]
[null,null,null,null,null,"Eqv # Cars off Road","Enough Electricity to Power Homes","Enough Water to Fill Back Yard Pools"]
[null,null,null,null,null,4.1636360000000003,{"$f":"215.982","v":215.982},55]
["GH/1kg","Reduction due to Recycled content",null,null,null,{"$f":"F47/F49","v":0},{"$f":"(G47/G49)*10","v":0},{"$f":"H47/H49","v":0}]
[6.3939999999999993E-4,5.2719999999999588E-7]
["recycled content",{"$f":"'Paper purchased'!D9","v":0},null,"P& C",{"$f":"C22*('Waste Composition'!C98+'Waste Composition'!D98)","v":0},{"$f":"($E52/1000)*B13","v":0},{"$f":"($E52/1000)*C13","v":0},0,0]
["GH/KG",{"$f":"A51-((B52*100)*B51)","v":6.3939999999999993E-4},null,"LPB",{"$f":"'Waste Composition'!$E$98*B39*C23","v":0},0,0,0,0]
["KG",{"$f":"('Paper purchased'!D6*2.5)*B55","v":0},null,"Glass",{"$f":"'Waste Composition'!$E$98*B40*C24","v":0},0,0,0,0]
["Period (year)",{"$f":"IF(C55<>0,(INDEX(A56:B60,MATCH(C55,A56:A60,0),2)),0)","v":0},{"$f":"'Paper purchased'!D7","v":0},"Aluminium",{"$f":"'Waste Composition'!$E$98*B41*C25","v":0},0,0,0,0]
["Day",{"$f":"45*5","v":225},null,"Steel",{"$f":"'Waste Composition'!$E$98*B42*C26","v":0},0,0,0,0]
["Week",{"$f":"45","v":45},null,"HDPE",{"$f":"'Waste Composition'!$E$98*B43*C27","v":0},0,0,0,0]
["Month",10,null,"PET",{"$f":"'Waste Composition'!$E$98*B44*C28","v":0},0,{"$f":"($E58/1000)*C19","v":0},0,0]
["Term",4,null,null,null,"tCO2 eq","GJ electricity","KL water","m3 of landfill"]
["Year",1,"0% recyckled content","Saving",null,{"$f":"SUM(F52:F58)*45","v":0},{"$f":"SUM(G52:G58)*45","v":0},{"$f":"SUM(H52:H58)*45","v":0},{"$f":"SUM(I52:I58)*45","v":0}]
["Global hectares/year",{"$f":"B54*B53","v":0},{"$f":"B54*A51","v":0},{"$f":"C61-B61","v":0},null,"Eqv # Cars off Road","Enough Electricity to Power Homes","Enough Water to Fill Back Yard Pools","Enough Landfill Space to fill Backyard Pools"]
[1.2972717237028859,{"$f":"B61*$A62","v":0},{"$f":"C61*$A62","v":0},{"$f":"D61*$A62","v":0},null,4.1636360000000003,{"$f":"215.982","v":215.982},55,55]
["soccer pitchs per global hectare",null,null,null,null,{"$f":"F60/F62","v":0},{"$f":"(G60/G62)*10","v":0},{"$f":"IF(H60/H62<0,0,H60/H62)","v":0},{"$f":"I60/I62","v":0}]

{"sheet":"Waste Composition","index":7,"n_rows":103,"n_cols":20,"rows_kept":103,"cut":false,"hidden":true,"merged":[[9,9,9,10],[3,2,3,3],[3,4,3,5],[2,6,2,7],[2,9,2,10],[3,6,3,7],[3,9,3,10],[4,2,4,3],[4,4,4,5],[4,6,4,7],[4,9,4,10],[2,2,2,3],[2,4,2,5],[9,2,9,3],[9,4,9,5],[9,6,9,7],[2,11,2,12],[2,14,2,15],[9,11,9,12],[9,14,9,15],[3,11,3,12],[3,14,3,15],[4,11,4,12],[4,14,4,15],[13,11,13,12],[13,14,13,15],[11,2,11,3],[11,4,11,5],[13,2,13,3],[13,4,13,5],[13,6,13,7],[13,9,13,10],[11,6,11,7],[11,9,11,10],[11,11,11,12],[11,14,11,15]]}
["Value",null,"Paper",null,"Cardboard",null,"Containers Bottles and Tubs",null,null,"Food",null,"Garden waste",null,null,"Other Waste"]
[]
[1,"General Waste",0.1,null,0.9,null,0.11,null,null,null,null,0.89,null,null,0.99]
[1,"General Waste",0.1,null,0.9,null,0.11,null,null,null,null,0.89,null,null,0.99]
[1,"General Waste",0.1,null,0.9,null,0.11,null,null,null,null,0.89,null,null,0.99]
[]
[]
[]
[]
[null,"Paper Recycling",1,null,null,null,0.11,null,null,0.79,null,null,null,null,0.99]
[]
[null,"Cardboard Recycling",null,null,1,null,0.11,null,null,null,null,0.89,null,null,0.99]
[]
[null,"Comingled General Recycling",null,null,null,null,0.11,null,null,0.79,null,null,null,null,0.99]
[]
[]
[]
[]
[null,"Cominations",1,2,3,4,5,6,7,8,9,10,11,12,13,14]
[1,"General",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[2,"Paper",1,1,1,1,1,null,null,null,null,null,null,null,1,1,1,1,1]
[3,"card",null,1,1,1,1,null,null,null,1,1,1,1]
[4,"Comingled",null,null,1,1,1,null,null,1,1,null,1,1,1,1,1]
[5,"Green Waste",null,null,null,1,1,null,1,1,1,null,null,1,null,1,1,null,1]
[6,"Other organic",null,null,null,null,1,1,1,1,1,null,null,null,null,null,1,1,1]
[]
[]
[]
[]
[null,null,"P","C","Con","Food","Garden","Other"]
[null,"Basic General waste",0.25,0.15,0.1,0.3,0.05,0.15,{"$f":"SUM(C31:H31)","v":1}]
[]
[{"$f":"0.25*C31","v":6.25E-2},"With paper",{"$f":"A33/(1-(C31-A33))","v":7.6923076923076927E-2},{"$f":"D31/(1-($C$31-$A33))","v":0.1846153846153846},{"$f":"E31/(1-($C$31-$A33))","v":0.12307692307692308},{"$f":"F31/(1-($C$31-$A33))","v":0.3692307692307692},{"$f":"G31/(1-($C$31-$A33))","v":6.1538461538461542E-2},{"$f":"H31/(1-($C$31-$A33))","v":0.1846153846153846},{"$f":"SUM(C33:H33)","v":1}]
[null,"Paper",1]
[]
[null,null,null,{"$f":"(1-(C31-C33))","v":0.82692307692307687}]
[]
[]
[]
[null,"Effects of Rceycling and Diversion Streams"]
[null,"Paper","reduces paper from general waste and comingled"]
[null,"Card","reduces card and paper from general waste and comingled waste streams"]
[null,"paper and Card together","same impact as combined paper and cardboard streams"]
[null,"comingled","reduces containers from general waste stream "]
[]
[]
[]
[]
[]
[null,null,"Paper","Cardboard","Containers Bottles and Tubs","Food","Garden waste","Other Waste"]
[null,"Total Waste Stream",39.15,13.05,18.36,25.02,2.2200000000000002,2.2000000000000002,{"$f":"SUM(C51:H51)","v":100}]
["Tot Waste Collected",{"$f":"SUM(DataStore!E14:E77)","v":0},{"$f":"C51/100","v":0.39149999999999996},0.1305,0.18359999999999999,0.25019999999999998,2.2200000000000001E-2,2.2000000000000002E-2]
[null,"Available Waste",{"$f":"C52*$B52","v":0},0,0,0,0,0]
["Paper",{"$f":"DataStore!E24","v":0},{"$f":"B54*0.975","v":0},{"$f":"B54*0.025","v":0},null,null,null,null,{"$f":"SUM(C54:H54)","v":0},{"$f":"IF(B54<>0,TRUE,FALSE)","v":false}]
["card",{"$f":"DataStore!E34","v":0},{"$f":"0.05*B55","v":0},{"$f":"0.95*B55","v":0},null,null,null,null,{"$f":"SUM(C55:H55)","v":0},{"$f":"IF(B54>0,TRUE,FALSE)","v":false}]
[null,{"$f":"B55","v":0},{"$f":"0.55*B56","v":0},{"$f":"0.45*B56","v":0},null,null,null,null,0,{"$f":"IF(B54=0,TRUE,FALSE)","v":true}]
["comingled",{"$f":"DataStore!E44","v":0},{"$f":"B57*0.1","v":0},{"$f":"B57*0.05","v":0},{"$f":"B57*0.85","v":0},null,null,null,0,{"$f":"IF(AND(B54>0,B55>0),TRUE,FALSE)","v":false}]
[null,{"$f":"B57","v":0},{"$f":"0.5*B58","v":0},{"$f":"0.15*B58","v":0},{"$f":"0.35*B58","v":0},null,null,null,0,{"$f":"IF(AND(B54=0,B55<>0),TRUE,FALSE)","v":false}]
[null,{"$f":"B57","v":0},{"$f":"0.1*B59","v":0},{"$f":"0.6*B59","v":0},{"$f":"0.3*B59","v":0},null,null,null,0,{"$f":"IF(AND(B54<>0,B55=0),TRUE,FALSE)","v":false}]
[null,{"$f":"B57","v":0},{"$f":"B60*0.65","v":0},{"$f":"B60*0.25","v":0},{"$f":"B60*0.1","v":0},null,null,null,0,{"$f":"IF(AND(B54=0,B55=0),TRUE,FALSE)","v":true}]
["garden",{"$f":"IF(DataStore!A55=\"Garden Waste\",DataStore!E54,0)","v":0},null,null,null,null,{"$f":"B61","v":0},null,0,{"$f":"IF(B61>0,TRUE,FALSE)","v":false}]
["food",{"$f":"IF(DataStore!A55=\"Food\",DataStore!E54,0)","v":0},null,null,null,{"$f":"B62","v":0},null,null,null,{"$f":"IF(B62>0,TRUE,FALSE)","v":false}]
[null,null,{"$f":"SUMIF($J54:$J62,TRUE,C54:C62)","v":0},0,0,0,0,0]
[null,null,{"$f":"IF(C53-C63>0,C53-C63,0)","v":0},0,0,0,0,0,{"$f":"SUM(C64:H64)","v":0}]
[null,"Garbage Composition",{"$f":"IF($I64<>0,C64/$I64,C52)","v":0.39149999999999996},0.1305,0.18359999999999999,0.25019999999999998,2.2200000000000001E-2,2.2000000000000002E-2]
[]
[]
[null,"Paper diversion recovers ~45% of all paper"]
[null,"Cardboard estimated to be ~55%"]
[null,"Cominged ~49% of containers"]
[]
[null,"Recovery Rates",0.45,0.55000000000000004,0.49,0.2,0.5,0]
[null,"one if present",{"$f":"IF('How much waste'!V18=TRUE,1,0)","v":0},{"$f":"IF('How much waste'!V28=TRUE,1,0)","v":0},{"$f":"IF('How much waste'!V38=TRUE,1,0)","v":0},{"$f":"IF(AND('How much waste'!V49,'How much waste'!E47=\"Food\"),1,IF(AND('How much waste'!V61,OtherDivert=\"food\"),1,0))","v":0},{"$f":"IF(AND('How much waste'!V49,'How much waste'!E47=\"Garden Waste\"),1,IF(AND('How much waste'!V61,OtherDivert=\"Garden Waste\"),1,0))","v":0}]
[null,"General waste Composition",{"$f":"IF(C73=1,(C51-(C51*C72)),IF(D73=1,(C51-((C51*C72)/4)),IF(E73=1,(C51-((C51*C72)/6)),C51)))","v":39.15},{"$f":"IF(D73=1,(D51-(D51*D72)),IF(E73=1,(D51-(D51*(D72/4))),D51))","v":13.05},{"$f":"IF(E73=1,(E51-(E51*E72)),E51)","v":18.36},{"$f":"IF(F73=1,(F51-(F51*F72)),F51)","v":25.02},{"$f":"IF(G73=1,(G51-(G51*G72)),G51)","v":2.2200000000000002},{"$f":"IF(H73=1,(H51-(H51*H72)),H51)","v":2.2000000000000002},{"$f":"SUM(C74:H74)","v":100}]
[null,null,{"$f":"C74/$I$74","v":0.39149999999999996},0.1305,0.18359999999999999,0.25019999999999998,2.2200000000000001E-2,2.2000000000000002E-2]
[]
[null,null,13.898]
[null,null,{"$f":"C51-C74","v":0},0,0,0,0,0]
[null,"Paper Composition",{"$f":"IF(C73=1,(C72*C51),0)-IF(C73=1,SUM(C80:C81),0)","v":0},null,null,null,null,null,{"$f":"SUM(C79:H79)","v":0}]
[null,"Cardboard Composition",{"$f":"IF(D73=1,(((C51*C72)/4)),0)-(IF(AND(D73=1,C73=0,E73=1),C81,0))","v":0},{"$f":"IF(D73=1,(D72*D51),0)-IF(D73=1,D81,0)","v":0},null,null,null,null,{"$f":"SUM(C80:H80)","v":0}]
[null,"Containers",{"$f":"IF(AND(E73=1),((C51*C72)/6),0)","v":0},{"$f":"IF(E73=1,((D51*(D72/4))),0)","v":0},{"$f":"IF(E73=1,(E72*E51),0)","v":0},null,null,null,{"$f":"SUM(C81:H81)","v":0}]
[null,"Other Diversion",null,null,null,{"$f":"IF(F73=1,(F72*F51),0)","v":0},{"$f":"IF(G73=1,(G72*G51),0)","v":0},{"$f":"IF(H73=1,(H72*H51),0)","v":0},{"$f":"SUM(C82:H82)","v":0}]
[null,null,{"$f":"SUM(C79:C82)","v":0},0,0,0,0,0,{"$f":"SUM(C83:H83,I74)","v":100}]
[]
[null,null,"Recyclable Paper","Cardboard","Recyclable Glass","Recyclable Plastic","Recyclable Metal","Food Waste","Garden Waste","General Waste"]
[null,"General Waste",0.42,0.21,0,0.05,0.01,0.04,0.09,0.19]
[null,"Comingled Recycling",0.65,0.19,0,7.0000000000000007E-2,0.01,0,0,0.08]
[null,"Paper/Cardboard",0.56000000000000005,0.39,0,0.01,0,0,0,0.04]
[]
[]
[null,null,"Recyclable Paper","Cardboard","Recyclable Glass","Recyclable Plastic","Recyclable Metal","Food Waste","Garden Waste","General Waste"]
[null,"General Waste",{"$f":"IF('What''s in your waste'!$D18=TRUE,'What''s in your waste'!F18,'Waste Composition'!C86)","v":0.42},{"$f":"IF('What''s in your waste'!$D18=TRUE,'What''s in your waste'!H18,'Waste Composition'!D86)","v":0.21},{"$f":"IF('What''s in your waste'!$D18=TRUE,'What''s in your waste'!N18,'Waste Composition'!E86)","v":0},{"$f":"IF('What''s in your waste'!$D18=TRUE,'What''s in your waste'!Q18,'Waste Composition'!F86)","v":0.05},{"$f":"IF('What''s in your waste'!$D18=TRUE,'What''s in your waste'!S18,'Waste Composition'!G86)","v":0.01},{"$f":"IF('What''s in your waste'!$D18=TRUE,'What''s in your waste'!V18,'Waste Composition'!H86)","v":0.04},{"$f":"IF('What''s in your waste'!$D18=TRUE,'What''s in your waste'!W18,'Waste Composition'!I86)","v":0.09},{"$f":"IF('What''s in your waste'!$D18=TRUE,'What''s in your waste'!X18,'Waste Composition'!J86)","v":0.19}]
[null,"Comingled Recycling",{"$f":"IF('What''s in your waste'!$D20=TRUE,'What''s in your waste'!F20,'Waste Composition'!C87)","v":0.65},{"$f":"IF('What''s in your waste'!$D20=TRUE,'What''s in your waste'!H20,'Waste Composition'!D87)","v":0.19},{"$f":"IF('What''s in your waste'!$D20=TRUE,'What''s in your waste'!N20,'Waste Composition'!E87)","v":0},{"$f":"IF('What''s in your waste'!$D20=TRUE,'What''s in your waste'!Q20,'Waste Composition'!F87)","v":7.0000000000000007E-2},{"$f":"IF('What''s in your waste'!$D20=TRUE,'What''s in your waste'!S20,'Waste Composition'!G87)","v":0.01},{"$f":"IF('What''s in your waste'!$D20=TRUE,'What''s in your waste'!V20,'Waste Composition'!H87)","v":0},{"$f":"IF('What''s in your waste'!$D20=TRUE,'What''s in your waste'!W20,'Waste Composition'!I87)","v":0},{"$f":"IF('What''s in your waste'!$D20=TRUE,'What''s in your waste'!X20,'Waste Composition'!J87)","v":0.08}]
[null,"Paper/Cardboard",{"$f":"IF('What''s in your waste'!$D22=TRUE,'What''s in your waste'!F22,'Waste Composition'!C88)","v":0.56000000000000005},{"$f":"IF('What''s in your waste'!$D22=TRUE,'What''s in your waste'!H22,'Waste Composition'!D88)","v":0.39},{"$f":"IF('What''s in your waste'!$D22=TRUE,'What''s in your waste'!N22,'Waste Composition'!E88)","v":0},{"$f":"IF('What''s in your waste'!$D22=TRUE,'What''s in your waste'!Q22,'Waste Composition'!F88)","v":0.01},{"$f":"IF('What''s in your waste'!$D22=TRUE,'What''s in your waste'!S22,'Waste Composition'!G88)","v":0},{"$f":"IF('What''s in your waste'!$D22=TRUE,'What''s in your waste'!V22,'Waste Composition'!H88)","v":0},{"$f":"IF('What''s in your waste'!$D22=TRUE,'What''s in your waste'!W22,'Waste Composition'!I88)","v":0},{"$f":"IF('What''s in your waste'!$D22=TRUE,'What''s in your waste'!X22,'Waste Composition'!J88)","v":0.04}]
[]
[]
[null,"Volume per stream"]
["General",{"$f":"DataStore!E14","v":0},{"$f":"$B98*C92","v":0},0,0,0,0,0]
["Paper Composition",{"$f":"DataStore!E24","v":0},{"$f":"$B99*C93","v":0},0,0,0,0,0]
["Cardboard Composition",{"$f":"DataStore!E34","v":0},{"$f":"$B100*C94","v":0},0,0,0,0,0]
["Containers",{"$f":"DataStore!E44","v":0},{"$f":"$B101*C95","v":0},0,0,0,0,0]
["Garden",{"$f":"IF(DataStore!A55=\"Garden Waste\",DataStore!E54,0)","v":0},{"$f":"$B102*C96","v":0},0,0,0,0,0]
["Food",{"$f":"IF(DataStore!A55=\"Food\",DataStore!E54,0)","v":0},{"$f":"$B103*C97","v":0},0,0,0,0,0]

{"sheet":"Recommendation List","index":8,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":true,"merged":[[1,0,12,0]]}
["Rec Cat","Trigger Description","Trigger formulae","Description",1,"Txt"]
["Waste Generation and Diversion Recommendations","True false based on meters of service identified",{"$f":"IF(DataStore!E44=0,TRUE,FALSE)","v":true},"New services - Commingled Recycling",2,{"$f":"\"As available in \"&H2&\" consider implementing a comingled recycling service.  Comingled recyclables commonly account for 10-20% of a schools normal waste stream and may be recoverable in your area.\"","v":"As available in your local area consider implementing a comingled recycling service.  Comingled recyclables commonly account for 10-20% of a schools normal waste stream and may be recoverable in your area."},null,{"$f":"IF(I2<>0,I2,\"your local area\")","v":"your local area"},{"$f":"'School Information'!D10","v":0}]
[null,"True false based on meters of services (AND) identified",{"$f":"IF(AND(DataStore!E24=0,DataStore!E34=0),TRUE,FALSE)","v":true},"New services - Paper/Cardboard Recycling",3,{"$f":"\"As available in \"&H2&\" consider implementing a paper and cardboard recycling service.  Paper and cardboard recyclables commonly account for approximately 50% of a schools normal waste stream and may be recoverable in your area.\"","v":"As available in your local area consider implementing a paper and cardboard recycling service.  Paper and cardboard recyclables commonly account for approximately 50% of a schools normal waste stream and may be recoverable in your area."}]
[null,"True false based on meters of services (AND) diversion rate",{"$f":"IF(AND(DataStore!E44<>0,'Additional Constants'!D2<0.5),TRUE,FALSE)","v":false},"Additional Service Capacity - Comingled Recycling",4,"Consider increasing you comingled recycling service to improve the diversion of materials from your school.  Diversion rates of >60% should be possible in most schools that have not undertaken programs to eliminate materials that are recyclable through this system."]
[null,"True false based on meters of services (AND) diversion rate",{"$f":"IF(AND(SUM(DataStore!E24,DataStore!E34)<>0,'Additional Constants'!D2<0.5),TRUE,FALSE)","v":false},"Additional Service Capacity - Paper and Cardboard",5,"Consider increasing you paper and/or cardboard services to improve the diversion of materials from your school.  Diversion rates of >60% should be possible in most schools that have not undertaken programs to eliminate materials that are recyclable through this system."]
[null,"True false based service present, less than 50% full and low DR",{"$f":"IF(DataStore!E24<>0,IF(AND(((DataStore!E24/DataStore!F24)<0.51),('Additional Constants'!D2<0.5)),TRUE, FALSE),FALSE)","v":false},"Improved Diversion Paper",6,"Half or less of the capacity of the paper recycling is being used, while the diversion rate of materials away from recycling is low.  Look for ways to improve diversion in this service to maximise your value for money and environmental outcomes."]
[null,"True false based service present, less than 50% full and low DR",{"$f":"IF(DataStore!E34<>0,IF(AND(((DataStore!E34/DataStore!F34)<0.51),('Additional Constants'!D2<0.5)),TRUE, FALSE),FALSE)","v":false},"Improved Diversion Cardboard",7,"Half or less of the capacity of the cardboard recycling is being used, while the diversion rate of materials away from recycling is low.  Look for ways to improve diversion in this service to maximise your value for money and environmental outcomes."]
[null,"True false based service present, less than 50% full and low DR",{"$f":"IF(DataStore!E44<>0,IF(AND(((DataStore!E44/DataStore!F44)<0.51),('Additional Constants'!D2<0.5)),TRUE, FALSE),FALSE)","v":false},"Improved Diversion Comingled",8,"Half or less of the capacity of the comingled recycling is being used, while the diversion rate of materials away from recycling is low.  Look for ways to improve diversion in this service to maximise your value for money and environmental outcomes."]
[null,"False True based on presence of organic diversion services",{"$f":"IF(OR(DataStore!A55=\"Food\",DataStore!A55=\"Garden Waste\",DataStore!A67=\"Food\",DataStore!A67=\"Garden Waste\"),FALSE,TRUE)","v":true},"Introduction of Organic Services",9,"No formal organic diversion services were identified in your responses.  Consider diverting offsite or reusing onsite organic materials such as garden waste or food scraps to reduce the amount of waste generated for disposal from your site."]
[null,"FALSE TRUE based on diversion service considerations",{"$f":"IF(OR(C2,C3,C4,C5,C6,C7,C8,C9=TRUE),FALSE,TRUE)","v":false},"Satisfactory Diversion Services",10,"An examination of the sites diversion services indicates that they are likely to be satisfactory for your sites needs."]
[null,"TRUE FALSE based on diversion service considerations",{"$f":"IF(OR(C2,C3,C4,C5,C6,C7,C8,C9=TRUE),TRUE, FALSE)","v":true},"Recommended changes may prompt consideration of total waste to landfill volumes",11,"It is noted that some service or usage changes were recommended for your diversion services.  When implementing these changes, it is recommended that consideration be given to monitoring the affect of the changes and reducing the general waste service if appropriate."]
[null,"True false based on used waste capacity",{"$f":"IF(DataStore!E14=0,\"NoService\",IF(DataStore!E14/DataStore!F14<0.6,TRUE,FALSE))","v":"NoService"},"Over serviced Waste Stream",12,"The total capacity of your waste service as described appears to be larger than you require.  Consider reducing the size or service frequency of this container in consultation with your waste service provider."]
[null,"True False Based on waste stream composition",{"$f":"IF(DataStore!I80=FALSE,TRUE,FALSE)","v":true},"if expected and presented compositions match, recommend compositional assessment of waste streams",13,"It is noted that compositions used in this report for the general waste composition are the default waste stream compositions.  These figures are averages based on examination of number of school waste streams, however, it is recommended that a visual assessment of the composition of the materials presented for collection be undertaken.  In particular, look for recycling potential in the garbage stream and contamination in the recycling streams and if identified develop a remediation plan to address these issues at your school."]
[null,null,null,"Diversion service count and list, drawn from below",14,{"$f":"IF(OR(C15,C16,C17,C18,C19,C20=TRUE),F20,\"No Regular Diversion Services Identified\")","v":"No Regular Diversion Services Identified"}]
[null,null,{"$f":"IF(DataStore!E44>0,TRUE,FALSE)","v":false},"Comingled Recycling",15,{"$f":"IF(C15=TRUE,D15&\", \",\"\")","v":""}]
[null,null,{"$f":"IF(DataStore!E24>0,TRUE,FALSE)","v":false},"Paper Recycling",16,{"$f":"IF(C16=TRUE,D16&\", \",\"\")","v":""}]
[null,null,{"$f":"IF(DataStore!E34>0,TRUE,FALSE)","v":false},"Cardboard Recycling",17,{"$f":"IF(C17=TRUE,D17&\", \",\"\")","v":""}]
[null,null,{"$f":"IF(OR(DataStore!A55=\"Food\",DataStore!A67=\"Food\"),TRUE,FALSE)","v":false},"Food Diversion/Reuse/Recycling",18,{"$f":"IF(C18=TRUE,D18&\", \",\"\")","v":""}]
[null,null,{"$f":"IF(OR(DataStore!A55=\"Garden Waste\",DataStore!A67=\"Garden Waste\"),TRUE,FALSE)","v":false},"Garden Organics Diversion/Reuse/Recycling",19,{"$f":"IF(C19=TRUE,D19&\", \",\"\")","v":""}]
[null,null,{"$f":"IF(OR(DataStore!A55=\"Other\",DataStore!A67=\"Other\"),TRUE,FALSE)","v":false},"Other Diversion/Reuse/Recycling",20,{"$f":"\"The following recycling streams are observed at the site; \"&F15&F16&F17&F18&F19","v":"The following recycling streams are observed at the site; "}]
[null,null,null,null,21]
[null,null,null,null,22,{"$f":"IF(DataStore!B7<>0,DataStore!B7,\"Local Council\")","v":"Local Council"}]
[null,null,null,null,23]
[null,null,null,"alternate text Row 12",24,"It is observed that more than 60% of the capacity of the general waste stream is currently being used.  If this usage rate drops below this, it is recommended that consideration be given to reducing the service capacity by reducing bin size, collection frequency or bin numbers.  Contact your waste service provider for assistance."]
[null,null,null,"Alternate text Row 13",25,"It appears you have undertaken a waste audit or provided an estimation of the composition of your general waste stream(s).  Regular reviews of the waste composition can identify opportunities as they arise.  It is recommended that you continue to undertake regular visual composition assessments."]
[null,null,null,"Alternate row 3 / 5",26,"Capacity of Paper/Cardboard Recycling appears appropriate"]
[null,null,null,"Alternate row 2 / 4",27,"Capacity of Comingled Recycling appears appropriate"]
[null,null,null,"Alt row 6 (A)",28,"No paper recycling observed"]
[null,null,null,"Alt row 6 (B)",29,"The current paper recycling stream is being used within expected capacity levels"]
[null,null,null,"Alt rwo7 (A)",30,"No cardboard recycling observed"]
[null,null,null,"Alt row 7 (B)",31,"The current cardboard recycling stream is being used within expected capacity levels"]
[null,null,null,"Alt rwo8 (A)",32,"No comingled recycling observed"]
[null,null,null,"Alt row 8 (B)",33,"The current comingled recycling stream is being used within expected capacity levels"]
[null,null,null,"alt Row 9",34,"Current diversion services for organic food and/or garden waste are identified for this site"]
[null,null,null,"alt Row 11",35,"As waste minimisation behaviours and actions are introduced it is important to monitor the capacity of the general waste stream, and reduce the bin size, numbers or collection frequency as required to get the best benefit from your waste reduction actions"]

{"sheet":"Report One","index":9,"n_rows":43,"n_cols":18,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,7,42,8],[38,9,38,10],[36,3,36,10],[33,8,33,10],[40,7,40,8],[40,3,40,6],[39,3,39,6],[38,7,38,8],[39,7,39,8],[39,9,39,10],[40,9,40,10],[41,9,41,10],[42,9,42,10],[41,7,41,8],[41,3,41,6],[42,3,42,6],[3,3,3,12],[34,3,34,5],[9,3,9,5],[10,3,10,5],[11,3,11,5],[13,3,13,8],[5,3,5,5],[6,3,6,5],[7,3,7,5],[5,6,5,8],[7,6,7,8],[6,6,6,8]]}
[]
[]
[]
[null,null,null,"Summary of Waste Generation"]
[]
[null,null,null,"School Name",null,null,{"$f":"DataStore!B1","v":0},null,null,null,null,null,null,null,null,null,"NEXT"]
[null,null,null,"Local Government Area",null,null,{"$f":"IF(DataStore!B7=0,\"Not Provided\", DataStore!B7)","v":"Not Provided"}]
[null,null,null,"State",null,null,{"$f":"DataStore!B6","v":"NSW"}]
[]
[null,null,null,"Number of Students",null,null,{"$f":"DataStore!B3","v":0}]
[null,null,null,"Number of Staff",null,null,{"$f":"DataStore!B4","v":0}]
[null,null,null,"Total Number of Persons",null,null,{"$f":"SUM(G10:G11)","v":0}]
[]
[null,null,null,"Waste Generation Estimation"]
[]
[null,null,null,null,"General Wasye",{"$f":"DataStore!E14","v":0}]
[null,null,null,null,"Paper and Cardboard Recycling",{"$f":"SUM(DataStore!E24,DataStore!E34)","v":0}]
[null,null,null,null,"Comingled Recycling",{"$f":"DataStore!E44","v":0}]
[null,null,null,null,"Other Diversion",{"$f":"SUM(DataStore!E54,DataStore!E66)","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TEXT(\"\",)","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Observed",null,"Compared to State Target",null,null,{"$f":"INDEX('Additional Constants'!A2:B9,MATCH('Report One'!G8,'Additional Constants'!A2:A9,0),2)","v":0.63}]
[null,null,null,"Diversion Rate",null,null,{"$f":"'Additional Constants'!D2","v":0},null,{"$f":"IF(L34<>\"Not Set\",G35-L34,IF(G35>0.6,\"Acceptable in many states\",\"Considered for Improvement\" ))","v":-0.63}]
[]
[null,null,null,"Waste and Recycling Generation Rates"]
[]
[null,null,null,null,null,null,null,"Per Student",null,"Per Person"]
[null,null,null,"General Waste",null,null,null,{"$f":"(DataStore!$E14/DataStore!B3)*1000","v":{"$error":"#DIV/0!"}},null,{"$f":"(DataStore!$E14/G12)*1000","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Paper and Cardboard Recycling",null,null,null,{"$f":"(SUM(DataStore!$E24,DataStore!E34)/DataStore!B3)*1000","v":{"$error":"#DIV/0!"}},null,{"$f":"(SUM(DataStore!$E24,DataStore!E34)/G12)*1000","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Comingled Recycling",null,null,null,{"$f":"(DataStore!$E44/DataStore!B3)*1000","v":{"$error":"#DIV/0!"}},null,{"$f":"(DataStore!$E44/G12)*1000","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Other Diversion",null,null,null,{"$f":"(SUM(DataStore!$E54,DataStore!E66)/DataStore!B3)*1000","v":{"$error":"#DIV/0!"}},null,{"$f":"(SUM(DataStore!$E54,DataStore!E66)/G12)*1000","v":{"$error":"#DIV/0!"}}]

{"sheet":"Report Two","index":10,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":false,"merged":[[3,3,3,11],[6,3,6,10],[34,3,34,12]]}
[]
[]
[]
[null,null,null,"Impacts of Waste Generation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NEXT"]
[]
[null,null,null,"How much waste does your school send to landfill?"]
[null,null,null,{"$f":"((D12/45)*240)/('School Information'!D6:N6+'School Information'!D7:N7)","v":{"$error":"#DIV/0!"}},"per person per week (L)"]
[null,null,null,{"$f":"DataStore!E14","v":0},"m3 per week"]
[null,null,null,{"$f":"D12/45","v":0},"wheelie bins per week"]
[null,null,null,{"$f":"D9*45","v":0},"m3 per year @45"]
[null,null,null,{"$f":"D11/0.24","v":0},"240lt wheelie bins"]
[null,null,null,1,{"$f":"(IF(((D12/10)/5)-ROUND((D12/10)/5,0)<0.25,(ROUND(((D12/10)/5),0)),(ROUND(((D12/10)/5),0)+1)))*5","v":0},{"$f":"D12","v":0}]
[null,null,null,2,{"$f":"IF(E13<F14,E13,F14)","v":0},{"$f":"F13-E$13","v":0}]
[null,null,null,3,{"$f":"IF(E14<F15,E14,F15)","v":0},0]
[null,null,null,4,0,0]
[null,null,null,5,0,0]
[null,null,null,6,0,0]
[null,null,null,7,0,0]
[null,null,null,8,0,0]
[null,null,null,9,0,0]
[null,null,null,10,{"$f":"IF((E13*10)=D12,E21,IF((E13*10)>D12,IF(F22<0,0,F22),IF((E13*10)<D12,F22)))","v":0},0]
[null,null,null,null,{"$f":"SUM(E13:E22)","v":0}]
[null,null,null,null,{"$f":"E23-D12","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Environmental savings from your school's paper, cardboard and comingled recycling (per annum)"]

{"sheet":"Report Three","index":11,"n_rows":23,"n_cols":21,"rows_kept":23,"cut":false,"hidden":false,"merged":[[3,4,3,15],[7,4,7,6],[7,9,7,11],[6,14,6,16],[12,8,15,12],[12,14,15,16],[5,3,5,6],[5,14,5,16],[5,8,5,12],[6,3,6,6],[6,8,6,12],[12,3,15,6],[9,4,9,6],[10,4,10,6],[11,4,11,6]]}
[]
[]
[]
[null,null,null,null,"Waste Stream Compositions"]
[]
[null,null,null,"General Waste",null,null,null,null,"Comingled Recycling",null,null,null,null,null,"Paper/Cardboard Recycling",null,null,null,null,null,"NEXT"]
[null,null,null,{"$f":"IF('What''s in your waste'!D18=TRUE, \"The general waste stream composition chart represents the composition of your school's waste stream based on the audit data that you have provided.\", \"The general waste stream composition chart represents the composition of your school's waste stream based on average waste stream data for schools.\")","v":"The general waste stream composition chart represents the composition of your school's waste stream based on average waste stream data for schools."},null,null,null,null,{"$f":"IF('What''s in your waste'!D20=TRUE, \"The comingled recycling stream composition chart represents the composition of your school's recycling stream based on the audit data that you have provided.\", \"The comingled recycling stream composition chart represents the composition of your school's recycling stream based on average waste stream data for schools.\")","v":"The comingled recycling stream composition chart represents the composition of your school's recycling stream based on average waste stream data for schools."},null,null,null,null,null,{"$f":"IF('What''s in your waste'!D22=TRUE, \"The paper/cardboard stream composition chart represents the composition of your school's paper/cardboard stream based on the audit data that you have provided.\", \"The paper/cardboard stream composition chart represents the composition of your school's paper/cardboard stream based on average waste stream data for schools.\")","v":"The paper/cardboard stream composition chart represents the composition of your school's paper/cardboard stream based on average waste stream data for schools."}]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"\"Your general waste stream has a resource loss of \" & SUM(H21:L21)*100 & \"%.\" & \"This means that \" & SUM(H21:L21)*100 & \"% \" & \"of your general waste could be diverted from landfill through the comingled recycling collection service.\"","v":"Your general waste stream has a resource loss of 69%.This means that 69% of your general waste could be diverted from landfill through the comingled recycling collection service."},null,null,null,null,{"$f":"\"Your comingled recycling stream has a contamination rate of \" & SUM(M22:O22)*100 & \"%.\" & \"This means that \" & SUM(M22:O22)*100 & \"% \" & \"of your comingled recycling stream is actually general waste materials and is contaminating your recycling.\"","v":"Your comingled recycling stream has a contamination rate of 8%.This means that 8% of your comingled recycling stream is actually general waste materials and is contaminating your recycling."},null,null,null,null,null,{"$f":"\"Your paper/cardboard recycling stream has a contamination rate of \" & SUM(J23:O23)*100 & \"%.\" & \"This means that \" & SUM(J23:O23)*100 & \"% \" & \"of your paper/cardboard stream is actually general waste and other recyclable materials accepted in the comingled recycling bin and is contaminating your paper/cardboard stream.\"","v":"Your paper/cardboard recycling stream has a contamination rate of 5%.This means that 5% of your paper/cardboard stream is actually general waste and other recyclable materials accepted in the comingled recycling bin and is contaminating your paper/cardboard stream."}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Recyclable Paper","Cardboard","Recyclable Glass","Recyclable Plastic","Recyclable Metal","Food Waste","Garden Waste","General Waste"]
[null,null,null,null,null,null,"General Waste",{"$f":"'Waste Composition'!C92","v":0.42},{"$f":"'Waste Composition'!D92","v":0.21},{"$f":"'Waste Composition'!E92","v":0},{"$f":"'Waste Composition'!F92","v":0.05},{"$f":"'Waste Composition'!G92","v":0.01},{"$f":"'Waste Composition'!H92","v":0.04},{"$f":"'Waste Composition'!I92","v":0.09},{"$f":"'Waste Composition'!J92","v":0.19}]
[null,null,null,null,null,null,"Comingled Recycling",{"$f":"'Waste Composition'!C93","v":0.65},{"$f":"'Waste Composition'!D93","v":0.19},{"$f":"'Waste Composition'!E93","v":0},{"$f":"'Waste Composition'!F93","v":7.0000000000000007E-2},{"$f":"'Waste Composition'!G93","v":0.01},{"$f":"'Waste Composition'!H93","v":0},{"$f":"'Waste Composition'!I93","v":0},{"$f":"'Waste Composition'!J93","v":0.08}]
[null,null,null,null,null,null,"Paper/Cardboard",{"$f":"'Waste Composition'!C94","v":0.56000000000000005},{"$f":"'Waste Composition'!D94","v":0.39},{"$f":"'Waste Composition'!E94","v":0},{"$f":"'Waste Composition'!F94","v":0.01},{"$f":"'Waste Composition'!G94","v":0},{"$f":"'Waste Composition'!H94","v":0},{"$f":"'Waste Composition'!I94","v":0},{"$f":"'Waste Composition'!J94","v":0.04}]

{"sheet":"Report Four","index":12,"n_rows":29,"n_cols":19,"rows_kept":29,"cut":false,"hidden":false,"merged":[[6,6,6,10],[7,6,7,10],[8,6,8,10],[9,6,9,10],[3,3,3,12],[19,6,19,12],[12,6,12,12],[13,6,13,12],[14,6,14,12],[15,6,15,12],[16,6,16,12],[17,6,17,12],[18,6,18,12],[27,5,27,12],[28,5,28,12],[25,5,25,12],[26,5,26,12],[20,6,20,12],[21,6,21,12]]}
[]
[]
[]
[null,null,null,"Waste Minimisation and Avoidance",null,null,null,null,null,null,null,null,null,null,null,null,null,"ü"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NEXT"]
[null,null,null,"Additional Diversion actions"]
[null,null,null,null,null,{"$f":"IF(DataStore!B89=TRUE,\"ü\",\"û\")","v":"û"},{"$f":"S7&\"recycle printer cartridges\"","v":"No we don't recycle printer cartridges"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(DataStore!B89=TRUE,\"Yes, we \",\"No we don't \")","v":"No we don't "}]
[null,null,null,null,null,{"$f":"IF(DataStore!B90=TRUE,\"ü\",\"û\")","v":"û"},{"$f":"S8&\"recycled fluorescent tubes\"","v":"No we don't recycled fluorescent tubes"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(DataStore!B90=TRUE,\"Yes, we \",\"No we don't \")","v":"No we don't "}]
[null,null,null,null,null,{"$f":"IF(DataStore!B91=TRUE,\"ü\",\"û\")","v":"û"},{"$f":"S9&\"recycle computers\"","v":"No we don't recycle computers"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(DataStore!B91=TRUE,\"Yes, we \",\"No we don't \")","v":"No we don't "}]
[null,null,null,null,null,{"$f":"IF(DataStore!B92=TRUE,\"ü\",\"û\")","v":"û"},{"$f":"S10&\"recycle mobile phones\"","v":"No we don't recycle mobile phones"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(DataStore!B92=TRUE,\"Yes, we \",\"No we don't \")","v":"No we don't "}]
[]
[null,null,null,"Waste Minimisation actions"]
[null,null,null,null,null,{"$f":"IF(DataStore!B94=TRUE,\"ü\",\"û\")","v":"û"},{"$f":"S13&\"have litter free lunch days\"","v":"No we don't have litter free lunch days"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(DataStore!B94=TRUE,\"Yes, we \",\"No we don't \")","v":"No we don't "}]
[null,null,null,null,null,{"$f":"IF(DataStore!B95=TRUE,\"ü\",\"û\")","v":"û"},{"$f":"S14&\"have a school policy to print double sided\"","v":"No we don't have a school policy to print double sided"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(DataStore!B95=TRUE,\"Yes, we \",\"No we don't \")","v":"No we don't "}]
[null,null,null,null,null,{"$f":"IF(DataStore!B96=TRUE,\"ü\",\"û\")","v":"û"},{"$f":"S15&\"print in black and white\"","v":"No we don't consistently print in black and white"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(DataStore!B96=TRUE,\"Yes, we consistently \",\"No we don't consistently \")","v":"No we don't consistently "}]
[null,null,null,null,null,{"$f":"IF(DataStore!B97=TRUE,\"ü\",\"û\")","v":"û"},{"$f":"S16&\"use recycled paper\"","v":"No we don't consistently use recycled paper"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(DataStore!B97=TRUE,\"Yes, we consistently \",\"No we don't consistently \")","v":"No we don't consistently "}]
[null,null,null,null,null,{"$f":"IF(DataStore!B98=TRUE,\"ü\",\"û\")","v":"û"},{"$f":"S17&\"plastic bag free\"","v":"No we aren't plastic bag free"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(DataStore!B98=TRUE,\"Yes, we are \",\"No we aren't \")","v":"No we aren't "}]
[null,null,null,null,null,{"$f":"IF(DataStore!B99=TRUE,\"ü\",\"û\")","v":"û"},{"$f":"S18&\"consistently use double sided printing\"","v":"No we don't consistently use double sided printing"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(DataStore!B99=TRUE,\"Yes, we \",\"No we don't \")","v":"No we don't "}]
[null,null,null,null,null,{"$f":"IF(DataStore!B100=TRUE,\"ü\",\"û\")","v":"û"},{"$f":"S19&\"use of single sided paper\"","v":"No we don't consistently use of single sided paper"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(DataStore!B100=TRUE,\"Yes, we consistently \",\"No we don't consistently \")","v":"No we don't consistently "}]
[null,null,null,null,null,{"$f":"IF(DataStore!B101=TRUE,\"ü\",\"û\")","v":"û"},{"$f":"S20&\"use electronic filing and communication systems\"","v":"No we don't consistently use electronic filing and communication systems"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(DataStore!B101=TRUE,\"Yes, we consistently \",\"No we don't consistently \")","v":"No we don't consistently "}]
[null,null,null,null,null,{"$f":"IF(DataStore!B102=TRUE,\"ü\",\"û\")","v":"û"},{"$f":"S21&\"use electronic publishing\"","v":"No we don't consistently use electronic publishing"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(DataStore!B102=TRUE,\"Yes, we consistently \",\"No we don't consistently \")","v":"No we don't consistently "}]
[null,null,null,null,null,{"$f":"IF(DataStore!B103=TRUE,\"ü\",\"û\")","v":"û"},{"$f":"S22&\"have policies to minimise offsite introduction of packaging\"","v":"No we don't have policies to minimise offsite introduction of packaging"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(DataStore!B103=TRUE,\"Yes, we \",\"No we don't \")","v":"No we don't "}]
[]
[null,null,null,"Other Actions to Reduce Waste at Our School"]
[]
[null,null,null,null,null,{"$f":"IF(AND(S26=0,S27=0,S28=0,S29=0),\"No other waste minimisation actions reported\",S26)","v":"No other waste minimisation actions reported"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DataStore!A106","v":0}]
[null,null,null,null,null,{"$f":"IF(S27<>0,S27,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DataStore!A107","v":0}]
[null,null,null,null,null,{"$f":"IF(S28<>0,S28,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DataStore!A108","v":0}]
[null,null,null,null,null,{"$f":"IF(S29<>0,S29,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DataStore!A109","v":0}]

{"sheet":"Report Five","index":13,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[5,3,5,5],[21,3,21,5],[29,3,29,5],[3,3,3,9]]}
[]
[]
[]
[null,null,null,"Recommendations from Data Provided"]
[]
[null,null,null,"Additional Diversion Services"]
[null,null,null,null,null,{"$f":"IF('Recommendation List'!C10=TRUE,'Recommendation List'!F10,'Recommendation List'!F14)","v":"No Regular Diversion Services Identified"}]
[]
[null,null,null,null,null,{"$f":"IF('Recommendation List'!C3=TRUE,'Recommendation List'!F3,IF('Recommendation List'!C5=TRUE,'Recommendation List'!F5,'Recommendation List'!F26))","v":"As available in your local area consider implementing a paper and cardboard recycling service.  Paper and cardboard recyclables commonly account for approximately 50% of a schools normal waste stream and may be recoverable in your area."}]
[]
[null,null,null,null,null,{"$f":"IF('Recommendation List'!C2=TRUE,'Recommendation List'!F2,IF('Recommendation List'!C4=TRUE,'Recommendation List'!F4,'Recommendation List'!F27))","v":"As available in your local area consider implementing a comingled recycling service.  Comingled recyclables commonly account for 10-20% of a schools normal waste stream and may be recoverable in your area."}]
[]
[null,null,null,null,null,{"$f":"IF('Recommendation List'!C6=TRUE,'Recommendation List'!F6,IF(DataStore!E24=0,'Recommendation List'!F28,'Recommendation List'!F29))","v":"No paper recycling observed"}]
[]
[null,null,null,null,null,{"$f":"IF('Recommendation List'!C7=TRUE,'Recommendation List'!F7,IF(DataStore!E34=0,'Recommendation List'!F30,'Recommendation List'!F31))","v":"No cardboard recycling observed"}]
[]
[null,null,null,null,null,{"$f":"IF('Recommendation List'!C8=TRUE,'Recommendation List'!F8,IF(DataStore!E44=0,'Recommendation List'!F32,'Recommendation List'!F33))","v":"No comingled recycling observed"}]
[]
[null,null,null,null,null,{"$f":"IF('Recommendation List'!C9=TRUE,'Recommendation List'!F9,'Recommendation List'!F34)","v":"No formal organic diversion services were identified in your responses.  Consider diverting offsite or reusing onsite organic materials such as garden waste or food scraps to reduce the amount of waste generated for disposal from your site."}]
[]
[]
[null,null,null,"Consideration of General Waste Services"]
[null,null,null,null,null,{"$f":"IF('Recommendation List'!C11=TRUE,'Recommendation List'!F11,'Recommendation List'!F35)","v":"It is noted that some service or usage changes were recommended for your diversion services.  When implementing these changes, it is recommended that consideration be given to monitoring the affect of the changes and reducing the general waste service if appropriate."}]
[]
[null,null,null,null,null,{"$f":"IF('Recommendation List'!C12=TRUE,'Recommendation List'!F12,IF('Recommendation List'!C12=FALSE,'Recommendation List'!F24,\"No Garbage Service Entered\"))","v":"No Garbage Service Entered"}]
[]
[null,null,null,null,null,{"$f":"IF('Recommendation List'!C13=TRUE,'Recommendation List'!F13,'Recommendation List'!F25)","v":"It is noted that compositions used in this report for the general waste composition are the default waste stream compositions.  These figures are averages based on examination of number of school waste streams, however, it is recommended that a visual assessment of the composition of the materials presented for collection be undertaken.  In particular, look for recycling potential in the garbage stream and contamination in the recycling streams and if identified develop a remediation plan to address these issues at your school."}]
[]
[null,null,null,null,null,{"$f":"IF(S29<>0,S29,\"\")","v":""}]
[null,null,null,"For further assistance"]
[null,null,null,null,null,{"$f":"\"For further assistance in implemented the recommendations provided, it is recommended that you contact your waste contractor and/or \"&'Recommendation List'!F22&\".\"","v":"For further assistance in implemented the recommendations provided, it is recommended that you contact your waste contractor and/or Local Council."}]