{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Read me","Bin Count Summary","Bin Count Data","MRS Calculator","Composition Audit calculator","drop downs","MRS scores","Support"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":5,"defined_names":197,"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":"Read me","index":0,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[[3,1,3,4],[14,1,14,5],[5,1,5,5],[8,1,8,5],[12,1,12,5],[13,1,13,5],[37,1,37,5],[35,1,35,5],[6,1,7,5],[10,1,10,5],[26,1,26,5],[30,1,30,5],[31,1,31,5],[29,1,29,5],[23,1,23,5],[24,1,24,5],[16,1,16,5],[17,1,17,5],[22,1,22,5],[21,1,21,5],[18,1,18,5],[19,1,19,5]]}
[]
[]
[null,null,null,null,"Department of Planning, Industry and Environment\n59 Goulburn Street\nSydney NSW 2000","T (02) 9995 5000\nE nabers@environment.nsw.gov.au nabers.gov.au "]
[null,"NABERS WASTE\nCalculations Spreadsheet"]
[null,"Version:","v3.0","Date:","2019-09-30"]
[]
[null,"This spreadsheet enables NABERS accredited assessors to fulfil the \"testing an independent data source\" requirements (section 6.2.3) and the Material Recovery Score requirements (Chapter 7) of the NABERS Waste Rules. The completed spreadsheet must be uploaded to the Ratings page on the Waste Manager platform as part of the evidence for the rating."]
[]
[null,"How to use this calculator"]
[]
[null,"Testing an independent data source"]
[null,"In the Summary tab:"]
[null,"1. Indicate the premises address, the rating number and the rating period."]
[null,"2. Using the dropdown list, select the waste types you would like to check against a second source of data."]
[null,"3. For each waste type you selected:\n       a) Indicate the equipment type and the bin size (for the bin size choose the right unit of measurement - m³or L)\n       b) Select the month and the year you have chosen for the data verification check.",null,null,null,null," "]
[null,"In the Bin count Data tab:"]
[null,"4. You will find pre-filled tables for each bin service you have listed in the Summary tab. "]
[null,"5. Fill each table with the bin counts from the primary source and the secondary source of data.\n    Make sure to check the table headings to fill the correct column for primary and secondary sources - the order of the data matters.\n    Please do not cut and paste cells or drag them once you have filled the columns."]
[null,"The results of the data verification check will be available in the Summary tab for each waste type.\nResults tell you whether the data verification check has passed or failed."]
[null,"Details about the data verification check procedure are available in the NABERS Waste Rules for collecting and assessing data, chapter 6.\nContact the NABERS National Administrator if you have problems with this spreadsheet."]
[null,"Allowed data manipulations"]
[null,"NABERS will allow assessors to make specific amendments to a second source of data. This is to enable more accurate comparison with a primary source. If these practices happen on your site and you have altered a second source of data, describe how and why you did this in the comment field in the Summary tab of this spreadsheet. "]
[null,"These situations are: "]
[null,"1.   Where bins are tallied after before midnight, but collected the following morning before the building opens. In this situation, on-site bin tallies can be shifted forward a day so they match the date of the waste contractor bin counts they relate to."]
[null,"2.   Where bins are taken to the dock regardless of contents, but only presented for collection when full. In this situation cases, bin tallies for days between collections can be summed to the day they are collected."]
[]
[null,"Determining building specific MRS values"]
[null,"In the MRS Calculator tab:"]
[]
[null,"1. Use the tables on the left hand side to determine building specific MRS values, by choosing the correct recovery pathway combination for each bin service. "]
[null,"2. Use the tables on the right hand side to determine building specific MRS values for any mixed contents bins. If you need to calculate more than one bin, then copy the appropriate table into the space below"]
[null,"3. Transfer these values to the Material Recovery Score Data section of the rating page."]
[null,"In the MRS Calculator tab:"]
[null,"For each bin service (copy the table if more than one bin service was audited):"]
[null,"1. Input the information under audit details. This is used for verification of results by the National Administrator"]
[null,"2. For each material type: list the cateogry and type (this can be read from the MRS Calculator tab, or theMaterial Recovery pathways appendix of the Rules), then enter the combined weight of that material type for that audit. The table should auto-complete to provide the percentage splits."]
[null,"3. If you need more lines, then add them in the middle of the table so the total weight and percent is still captured"]
[null,"4. If you need a second table, then ensure the values in column E refer to the correct value in column D (should be the totals row for that audit table)"]

{"sheet":"Bin Count Summary","index":1,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[[5,3,5,4],[18,1,18,9],[20,1,20,9],[21,1,30,9]]}
[]
[null,"Premises address:"]
[null,"Rating number:"]
[null,"Rating period:"]
[]
[null,"Waste type","Equipment","Size",null,"Dock","Month to check","Year \n(yyyy)","Weighted average","Verification check result"]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(B7=\"\",\"\",(SUMPRODUCT('Bin Count Data'!$E$4:$E$34,'Bin Count Data'!$F$4:$F$34)/SUM('Bin Count Data'!$F$4:$F$34))),\"\")","v":""},{"$f":"IF(B7=\"\",\"\",IF(I7=\"\",\"\",IF(I7>Support!$C$2,\"Fail\",\"Pass\")))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(B8=\"\",\"\",(SUMPRODUCT('Bin Count Data'!$K$4:$K$34,'Bin Count Data'!$L$4:$L$34)/SUM('Bin Count Data'!$L$4:$L$34))),\"\")","v":""},{"$f":"IF(B8=\"\",\"\",IF(I8=\"\",\"\",IF(I8>Support!$C$2,\"Fail\",\"Pass\")))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(B9=\"\",\"\",(SUMPRODUCT('Bin Count Data'!$Q$4:$Q$34,'Bin Count Data'!$R$4:$R$34)/SUM('Bin Count Data'!$R$4:$R$34))),\"\")","v":""},{"$f":"IF(B9=\"\",\"\",IF(I9=\"\",\"\",IF(I9>Support!$C$2,\"Fail\",\"Pass\")))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(B10=\"\",\"\",(SUMPRODUCT('Bin Count Data'!$W$4:$W$34,'Bin Count Data'!$X$4:$X$34)/SUM('Bin Count Data'!$X$4:$X$34))),\"\")","v":""},{"$f":"IF(B10=\"\",\"\",IF(I10=\"\",\"\",IF(I10>Support!$C$2,\"Fail\",\"Pass\")))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(B11=\"\",\"\",(SUMPRODUCT('Bin Count Data'!$AC$4:$AC$34,'Bin Count Data'!$AD$4:$AD$34)/SUM('Bin Count Data'!$AD$4:$AD$34))),\"\")","v":""},{"$f":"IF(B11=\"\",\"\",IF(I11=\"\",\"\",IF(I11>Support!$C$2,\"Fail\",\"Pass\")))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(B12=\"\",\"\",(SUMPRODUCT('Bin Count Data'!$AI$4:$AI$34,'Bin Count Data'!$AJ$4:$AJ$34)/SUM('Bin Count Data'!$AJ$4:$AJ$34))),\"\")","v":""},{"$f":"IF(B12=\"\",\"\",IF(I12=\"\",\"\",IF(I12>Support!$C$2,\"Fail\",\"Pass\")))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(B13=\"\",\"\",(SUMPRODUCT('Bin Count Data'!$AO$4:$AO$34,'Bin Count Data'!$AP$4:$AP$34)/SUM('Bin Count Data'!$AP$4:$AP$34))),\"\")","v":""},{"$f":"IF(B13=\"\",\"\",IF(I13=\"\",\"\",IF(I13>Support!$C$2,\"Fail\",\"Pass\")))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(B14=\"\",\"\",(SUMPRODUCT('Bin Count Data'!$AU$4:$AU$34,'Bin Count Data'!$AV$4:$AV$34)/SUM('Bin Count Data'!$AV$4:$AV$34))),\"\")","v":""},{"$f":"IF(B14=\"\",\"\",IF(I14=\"\",\"\",IF(I14>Support!$C$2,\"Fail\",\"Pass\")))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(B15=\"\",\"\",(SUMPRODUCT('Bin Count Data'!$BA$4:$BA$34,'Bin Count Data'!$BB$4:$BB$34)/SUM('Bin Count Data'!$BB$4:$BB$34))),\"\")","v":""},{"$f":"IF(B15=\"\",\"\",IF(I15=\"\",\"\",IF(I15>Support!$C$2,\"Fail\",\"Pass\")))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(B16=\"\",\"\",(SUMPRODUCT('Bin Count Data'!$BG$4:$BG$34,'Bin Count Data'!$BH$4:$BH$34)/SUM('Bin Count Data'!$BH$4:$BH$34))),\"\")","v":""},{"$f":"IF(B16=\"\",\"\",IF(I16=\"\",\"\",IF(I16>Support!$C$2,\"Fail\",\"Pass\")))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(B17=\"\",\"\",(SUMPRODUCT('Bin Count Data'!$BM$4:$BM$34,'Bin Count Data'!$BN$4:$BN$34)/SUM('Bin Count Data'!$BN$4:$BN$34))),\"\")","v":""},{"$f":"IF(B17=\"\",\"\",IF(I17=\"\",\"\",IF(I17>Support!$C$2,\"Fail\",\"Pass\")))","v":""}]
[]
[null,"If you have made any data adjustments for the data verification check, enter details about the adjustments in the comment field below. Please also note the relevant section of the rules or the ruling used to make the adjustment."]
[]
[null,"Assessor notes:\n"]

{"sheet":"Bin Count Data","index":2,"n_rows":35,"n_cols":66,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,31,1,33],[1,1,1,3],[1,7,1,9],[1,13,1,15],[1,19,1,21],[1,25,1,27],[1,37,1,39],[1,43,1,45],[1,49,1,51],[1,55,1,57],[1,61,1,63]]}
[]
[null,{"$f":"IF('Bin Count Summary'!$B$7=\"\",\"\",_xlfn.CONCAT('Bin Count Summary'!$B$7,\" - \",'Bin Count Summary'!$C$7,\" - \",'Bin Count Summary'!$D$7,'Bin Count Summary'!$E$7,\" at Dock \",'Bin Count Summary'!$F$7))","v":""},null,null,null,null,null,{"$f":"IF('Bin Count Summary'!$B$8=\"\",\"\",_xlfn.CONCAT('Bin Count Summary'!$B$8,\" - \",'Bin Count Summary'!$C$8,\" - \",'Bin Count Summary'!$D$8,'Bin Count Summary'!$E$8,\" at Dock \",'Bin Count Summary'!$F$8))","v":""},null,null,null,null,null,{"$f":"IF('Bin Count Summary'!$B$9=\"\",\"\",_xlfn.CONCAT('Bin Count Summary'!$B$9,\" - \",'Bin Count Summary'!$C$9,\" - \",'Bin Count Summary'!$D$9,'Bin Count Summary'!$E$9,\" at Dock \",'Bin Count Summary'!$F$9))","v":""},null,null,null,null,null,{"$f":"IF('Bin Count Summary'!$B$10=\"\",\"\",_xlfn.CONCAT('Bin Count Summary'!$B$10,\" - \",'Bin Count Summary'!$C$10,\" - \",'Bin Count Summary'!$D$10,'Bin Count Summary'!$E$10,\" at Dock \",'Bin Count Summary'!$F$10))","v":""},null,null,null,null,null,{"$f":"IF('Bin Count Summary'!$B$11=\"\",\"\",_xlfn.CONCAT('Bin Count Summary'!$B$11,\" - \",'Bin Count Summary'!$C$11,\" - \",'Bin Count Summary'!$D$11,'Bin Count Summary'!$E$11,\" at Dock \",'Bin Count Summary'!$F$11))","v":""},null,null,null,null,null,{"$f":"IF('Bin Count Summary'!$B$12=\"\",\"\",_xlfn.CONCAT('Bin Count Summary'!$B$12,\" - \",'Bin Count Summary'!$C$12,\" - \",'Bin Count Summary'!$D$12,'Bin Count Summary'!$E$12,\" at Dock \",'Bin Count Summary'!$F$12))","v":""},null,null,null,null,null,{"$f":"IF('Bin Count Summary'!$B$13=\"\",\"\",_xlfn.CONCAT('Bin Count Summary'!$B$13,\" - \",'Bin Count Summary'!$C$13,\" - \",'Bin Count Summary'!$D$13,'Bin Count Summary'!$E$13,\" at Dock \",'Bin Count Summary'!$F$13))","v":""},null,null,null,null,null,{"$f":"IF('Bin Count Summary'!$B$14=\"\",\"\",_xlfn.CONCAT('Bin Count Summary'!$B$14,\" - \",'Bin Count Summary'!$C$14,\" - \",'Bin Count Summary'!$D$14,'Bin Count Summary'!$E$14,\" at Dock \",'Bin Count Summary'!$F$14))","v":""},null,null,null,null,null,{"$f":"IF('Bin Count Summary'!$B$15=\"\",\"\",_xlfn.CONCAT('Bin Count Summary'!$B$15,\" - \",'Bin Count Summary'!$C$15,\" - \",'Bin Count Summary'!$D$15,'Bin Count Summary'!$E$15,\" at Dock \",'Bin Count Summary'!$F$15))","v":""},null,null,null,null,null,{"$f":"IF('Bin Count Summary'!$B$16=\"\",\"\",_xlfn.CONCAT('Bin Count Summary'!$B$16,\" - \",'Bin Count Summary'!$C$16,\" - \",'Bin Count Summary'!$D$16,'Bin Count Summary'!$E$16,\" at Dock \",'Bin Count Summary'!$F$16))","v":""},null,null,null,null,null,{"$f":"IF('Bin Count Summary'!$B$17=\"\",\"\",_xlfn.CONCAT('Bin Count Summary'!$B$17,\" - \",'Bin Count Summary'!$C$17,\" - \",'Bin Count Summary'!$D$17,'Bin Count Summary'!$E$17,\" at Dock \",'Bin Count Summary'!$F$17))","v":""}]
[null,"Date","# Bins picked up\nPrimary source","# Bins picked up\nSecondary source","Absoulte variation","Weights for average",null,"Date","# Bins picked up\nPrimary source","# Bins picked up\nSecondary source","Absoulte variation","Weights for average",null,"Date","# Bins picked up\nPrimary source","# Bins picked up\nSecondary source","Absoulte variation","Weights for average",null,"Date","# Bins picked up\nPrimary source","# Bins picked up\nSecondary source","Absoulte variation","Weights for average",null,"Date","# Bins picked up\nPrimary source","# Bins picked up\nSecondary source","Absoulte variation","Weights for average",null,"Date","# Bins picked up\nPrimary source","# Bins picked up\nSecondary source","Absoulte variation","Weights for average",null,"Date","# Bins picked up\nPrimary source","# Bins picked up\nSecondary source","Absoulte variation","Weights for average",null,"Date","# Bins picked up\nPrimary source","# Bins picked up\nSecondary source","Absoulte variation","Weights for average",null,"Date","# Bins picked up\nPrimary source","# Bins picked up\nSecondary source","Absoulte variation","Weights for average",null,"Date","# Bins picked up\nPrimary source","# Bins picked up\nSecondary source","Absoulte variation","Weights for average",null,"Date","# Bins picked up\nPrimary source","# Bins picked up\nSecondary source","Absoulte variation","Weights for average"]
[null,{"$f":"IFERROR(IF($B$2=\"\",\"\",DATE('Bin Count Summary'!$H$7,MONTH(DATEVALUE('Bin Count Summary'!$G$7&\" 1\")),1)),\"Define month to check\")","v":""},null,null,{"$f":"IFERROR(ABS((D4-C4)/C4),0)","v":0},{"$f":"IFERROR(C4/MAX($C$4:$D$34),0)","v":0},null,{"$f":"IFERROR(IF($H$2=\"\",\"\",DATE('Bin Count Summary'!$H$8,MONTH(DATEVALUE('Bin Count Summary'!$G$8&\" 1\")),1)),\"Define month to check\")","v":""},null,null,{"$f":"IFERROR(ABS((J4-I4)/I4),0)","v":0},{"$f":"IFERROR(I4/MAX($I$4:$J$34),0)","v":0},null,{"$f":"IFERROR(IF($N$2=\"\",\"\",DATE('Bin Count Summary'!$H$9,MONTH(DATEVALUE('Bin Count Summary'!$G$9&\" 1\")),1)),\"Define month to check\")","v":""},null,null,{"$f":"IFERROR(ABS((P4-O4)/O4),0)","v":0},{"$f":"IFERROR(O4/MAX($O$4:$P$34),0)","v":0},null,{"$f":"IFERROR(IF($T$2=\"\",\"\",DATE('Bin Count Summary'!$H$10,MONTH(DATEVALUE('Bin Count Summary'!$G$10&\" 1\")),1)),\"Define month to check\")","v":""},null,null,{"$f":"IFERROR(ABS((V4-U4)/U4),0)","v":0},{"$f":"IFERROR(U4/MAX($U$4:$V$34),0)","v":0},null,{"$f":"IFERROR(IF($Z$2=\"\",\"\",DATE('Bin Count Summary'!$H$11,MONTH(DATEVALUE('Bin Count Summary'!$G$11&\" 1\")),1)),\"Define month to check\")","v":""},null,null,{"$f":"IFERROR(ABS((AB4-AA4)/AA4),0)","v":0},{"$f":"IFERROR(AA4/MAX($AA$4:$AB$34),0)","v":0},null,{"$f":"IFERROR(IF($AF$2=\"\",\"\",DATE('Bin Count Summary'!$H$12,MONTH(DATEVALUE('Bin Count Summary'!$G$12&\" 1\")),1)),\"Define month to check\")","v":""},null,null,{"$f":"IFERROR(ABS((AH4-AG4)/AG4),0)","v":0},{"$f":"IFERROR(AG4/MAX($AG$4:$AH$34),0)","v":0},null,{"$f":"IFERROR(IF($AL$2=\"\",\"\",DATE('Bin Count Summary'!$H$13,MONTH(DATEVALUE('Bin Count Summary'!$G$13&\" 1\")),1)),\"Define month to check\")","v":""},null,null,{"$f":"IFERROR(ABS((AN4-AM4)/AM4),0)","v":0},{"$f":"IFERROR(AM4/MAX($AM$4:$AN$34),0)","v":0},null,{"$f":"IFERROR(IF($AR$2=\"\",\"\",DATE('Bin Count Summary'!$H$14,MONTH(DATEVALUE('Bin Count Summary'!$G$14&\" 1\")),1)),\"Define month to check\")","v":""},null,null,{"$f":"IFERROR(ABS((AT4-AS4)/AS4),0)","v":0},{"$f":"IFERROR(AS4/MAX($AS$4:$AT$34),0)","v":0},null,{"$f":"IFERROR(IF($AX$2=\"\",\"\",DATE('Bin Count Summary'!$H$15,MONTH(DATEVALUE('Bin Count Summary'!$G$15&\" 1\")),1)),\"Define month to check\")","v":""},null,null,{"$f":"IFERROR(ABS((AZ4-AY4)/AY4),0)","v":0},{"$f":"IFERROR(AY4/MAX($AY$4:$AZ$34),0)","v":0},null,{"$f":"IFERROR(IF($BD$2=\"\",\"\",DATE('Bin Count Summary'!$H$16,MONTH(DATEVALUE('Bin Count Summary'!$G$16&\" 1\")),1)),\"Define month to check\")","v":""},null,null,{"$f":"IFERROR(ABS((BF4-BE4)/BE4),0)","v":0},{"$f":"IFERROR(BE4/MAX($BE$4:$BF$34),0)","v":0},null,{"$f":"IFERROR(IF($BJ$2=\"\",\"\",DATE('Bin Count Summary'!$H$17,MONTH(DATEVALUE('Bin Count Summary'!$G$17&\" 1\")),1)),\"Define month to check\")","v":""},null,null,{"$f":"IFERROR(ABS((BL4-BK4)/BK4),0)","v":0},{"$f":"IFERROR(BK4/MAX($BK$4:$BL$34),0)","v":0}]
[null,{"$f":"IFERROR(IF(B4=\"\",\"\",IF(B4=EOMONTH($B$4,0),\"\",B4+1)),\"Define month to check\")","v":""},null,null,{"$f":"IFERROR(ABS((D5-C5)/C5),0)","v":0},{"$f":"IFERROR(C5/MAX($C$4:$D$34),0)","v":0},null,{"$f":"IFERROR(IF(H4=\"\",\"\",IF(H4=EOMONTH($H$4,0),\"\",H4+1)),\"Define month to check\")","v":""},null,null,{"$f":"IFERROR(ABS((J5-I5)/I5),0)","v":0},{"$f":"IFERROR(I5/MAX($I$4:$J$34),0)","v":0},null,{"$f":"IFERROR(IF(N4=\"\",\"\",IF(N4=EOMONTH($N$4,0),\"\",N4+1)),\"Define month to check\")","v":""},null,null,{"$f":"IFERROR(ABS((P5-O5)/O5),0)","v":0},{"$f":"IFERROR(O5/MAX($O$4:$P$34),0)","v":0},null,{"$f":"IFERROR(IF(T4=\"\",\"\",IF(T4=EOMONTH($T$4,0),\"\",T4+1)),\"Define month to check\")","v":""},null,null,{"$f":"IFERROR(ABS((V5-U5)/U5),0)","v":0},{"$f":"IFERROR(U5/MAX($U$4:$V$34),0)","v":0},null,{"$f":"IFERROR(IF(Z4=\"\",\"\",IF(Z4=EOMONTH($Z$4,0),\"\",Z4+1)),\"Define month to check\")","v":""},null,null,{"$f":"IFERROR(ABS((AB5-AA5)/AA5),0)","v":0},{"$f":"IFERROR(AA5/MAX($AA$4:$AB$34),0)","v":0},null,{"$f":"IFERROR(IF(AF4=\"\",\"\",IF(AF4=EOMONTH($AF$4,0),\"\",AF4+1)),\"Define month to check\")","v":""},null,null,{"$f":"IFERROR(ABS((AH5-AG5)/AG5),0)","v":0},{"$f":"IFERROR(AG5/MAX($AG$4:$AH$34),0)","v":0},null,{"$f":"IFERROR(IF(AL4=\"\",\"\",IF(AL4=EOMONTH($AL$4,0),\"\",AL4+1)),\"Define month to check\")","v":""},null,null,{"$f":"IFERROR(ABS((AN5-AM5)/AM5),0)","v":0},{"$f":"IFERROR(AM5/MAX($AM$4:$AN$34),0)","v":0},null,{"$f":"IFERROR(IF(AR4=\"\",\"\",IF(AR4=EOMONTH($AR$4,0),\"\",AR4+1)),\"Define month to check\")","v":""},null,null,{"$f":"IFERROR(ABS((AT5-AS5)/AS5),0)","v":0},{"$f":"IFERROR(AS5/MAX($AS$4:$AT$34),0)","v":0},null,{"$f":"IFERROR(IF(AX4=\"\",\"\",IF(AX4=EOMONTH($AX$4,0),\"\",AX4+1)),\"Define month to check\")","v":""},null,null,{"$f":"IFERROR(ABS((AZ5-AY5)/AY5),0)","v":0},{"$f":"IFERROR(AY5/MAX($AY$4:$AZ$34),0)","v":0},null,{"$f":"IFERROR(IF(BD4=\"\",\"\",IF(BD4=EOMONTH($BD$4,0),\"\",BD4+1)),\"Define month to check\")","v":""},null,null,{"$f":"IFERROR(ABS((BF5-BE5)/BE5),0)","v":0},{"$f":"IFERROR(BE5/MAX($BE$4:$BF$34),0)","v":0},null,{"$f":"IFERROR(IF(BJ4=\"\",\"\",IF(BJ4=EOMONTH($BJ$4,0),\"\",BJ4+1)),\"Define month to check\")","v":""},null,null,{"$f":"IFERROR(ABS((BL5-BK5)/BK5),0)","v":0},{"$f":"IFERROR(BK5/MAX($BK$4:$BL$34),0)","v":0}]
[null,{"$f":"IFERROR(IF(B5=\"\",\"\",IF(B5=EOMONTH($B$4,0),\"\",B5+1)),\"Define month to check\")","v":""},null,null,{"$f":"IFERROR(ABS((D6-C6)/C6),0)","v":0},{"$f":"IFERROR(C6/MAX($C$4:$D$34),0)","v":0},null,{"$f":"IFERROR(IF(H5=\"\",\"\",IF(H5=EOMONTH($H$4,0),\"\",H5+1)),\"Define month to check\")","v":""},null,null,0,0,null,{"$f":"IFERROR(IF(N5=\"\",\"\",IF(N5=EOMONTH($N$4,0),\"\",N5+1)),\"Define month to check\")","v":""},null,null,0,{"$f":"IFERROR(O6/MAX($O$4:$P$34),0)","v":0},null,{"$f":"IFERROR(IF(T5=\"\",\"\",IF(T5=EOMONTH($T$4,0),\"\",T5+1)),\"Define month to check\")","v":""},null,null,0,0,null,{"$f":"IFERROR(IF(Z5=\"\",\"\",IF(Z5=EOMONTH($Z$4,0),\"\",Z5+1)),\"Define month to check\")","v":""},null,null,0,0,null,{"$f":"IFERROR(IF(AF5=\"\",\"\",IF(AF5=EOMONTH($AF$4,0),\"\",AF5+1)),\"Define month to check\")","v":""},null,null,0,0,null,{"$f":"IFERROR(IF(AL5=\"\",\"\",IF(AL5=EOMONTH($AL$4,0),\"\",AL5+1)),\"Define month to check\")","v":""},null,null,0,0,null,{"$f":"IFERROR(IF(AR5=\"\",\"\",IF(AR5=EOMONTH($AR$4,0),\"\",AR5+1)),\"Define month to check\")","v":""},null,null,0,0,null,{"$f":"IFERROR(IF(AX5=\"\",\"\",IF(AX5=EOMONTH($AX$4,0),\"\",AX5+1)),\"Define month to check\")","v":""},null,null,0,0,null,{"$f":"IFERROR(IF(BD5=\"\",\"\",IF(BD5=EOMONTH($BD$4,0),\"\",BD5+1)),\"Define month to check\")","v":""},null,null,0,0,null,{"$f":"IFERROR(IF(BJ5=\"\",\"\",IF(BJ5=EOMONTH($BJ$4,0),\"\",BJ5+1)),\"Define month to check\")","v":""},null,null,0,0]
[null,"",null,null,{"$f":"IFERROR(ABS((D7-C7)/C7),0)","v":0},{"$f":"IFERROR(C7/MAX($C$4:$D$34),0)","v":0},null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0]
[null,"",null,null,{"$f":"IFERROR(ABS((D8-C8)/C8),0)","v":0},{"$f":"IFERROR(C8/MAX($C$4:$D$34),0)","v":0},null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0]
[null,{"$f":"IFERROR(IF(B8=\"\",\"\",IF(B8=EOMONTH($B$4,0),\"\",B8+1)),\"Define month to check\")","v":""},null,null,{"$f":"IFERROR(ABS((D9-C9)/C9),0)","v":0},{"$f":"IFERROR(C9/MAX($C$4:$D$34),0)","v":0},null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0]
[null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0]
[null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0]
[null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0]
[null,"",null,null,{"$f":"IFERROR(ABS((D13-C13)/C13),0)","v":0},{"$f":"IFERROR(C13/MAX($C$4:$D$34),0)","v":0},null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0]
[null,"",null,null,{"$f":"IFERROR(ABS((D14-C14)/C14),0)","v":0},{"$f":"IFERROR(C14/MAX($C$4:$D$34),0)","v":0},null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0]
[null,"",null,null,{"$f":"IFERROR(ABS((D15-C15)/C15),0)","v":0},{"$f":"IFERROR(C15/MAX($C$4:$D$34),0)","v":0},null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0]
[null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0]
[null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0]
[null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0]
[null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0]
[null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0]
[null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0]
[null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0]
[null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0]
[null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0]
[null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0]
[null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0]
[null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0]
[null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0]
[null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0]
[null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0]
[null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0]
[null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0]
[null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0]
[null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0,null,"",null,null,0,0]
[null,"",null,null,null,null,null,""]

{"sheet":"MRS Calculator","index":3,"n_rows":93,"n_cols":14,"rows_kept":93,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,8,1,13],[3,1,3,6],[3,8,3,13],[13,8,13,11],[30,9,30,13],[31,9,31,13],[27,8,27,11],[16,8,18,13],[29,8,29,12]]}
[]
[null,"MRS value tables",null,null,null,null,null,null,"Calculating MRS value for mixed content bins"]
[]
[null,"Use the tables below to determine the MRS value for a particular bin type, waste type and outcome select from the tables below. The results must  be entered into the ratings page.",null,null,null,null,null,null,"If no composition audit was completed then use the table below to determine the MRS Value for that bin, using the MRS points determined from the adjacent tables."]
[]
[null,"Paper/cardboard",null,null,null,null,null,null,"Bin","Material Categories","Material Type","Outcome","MRS Points","Percent"]
[null,"Bin","Material categories","Material type","Outcome","Merged","MRS points",null,"Mixed Recycling","Plastic","HDPE - rigid",null,null,2.8000000000000004E-2]
[null,"Mixed content","Paper/Cardboard","Mixed cardboard bale","New mixed cardboard grade product",{"$f":"B8&\" \"&C8&\" \"&D8&\" \"&E8","v":"Mixed content Paper/Cardboard Mixed cardboard bale New mixed cardboard grade product"},{"$f":"VLOOKUP(F8,'MRS scores'!$E$2:$F$257,2,FALSE)","v":4},null,"Mixed Recycling","Plastic","PET - rigid",null,null,0.12600000000000003]
[null,null,"Paper/Cardboard",null,null,{"$f":"B9&\" \"&C9&\" \"&D9&\" \"&E9","v":" Paper/Cardboard  "},{"$f":"VLOOKUP(F9,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}},null,"Mixed Recycling","Plastic","Plastic containers (mixed plastic bales)",null,null,0.12600000000000003]
[null,null,"Paper/Cardboard",null,null," Paper/Cardboard  ",{"$f":"VLOOKUP(F10,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}},null,"Mixed Recycling","Metals","Aluminium cans",null,null,0.02]
[null,null,"Paper/Cardboard",null,null,{"$f":"B11&\" \"&C11&\" \"&D11&\" \"&E11","v":" Paper/Cardboard  "},{"$f":"VLOOKUP(F11,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}},null,"Mixed Recycling","Metals","Tin cans",null,null,0.03]
[null,null,"Paper/Cardboard",null,null,{"$f":"B12&\" \"&C12&\" \"&D12&\" \"&E12","v":" Paper/Cardboard  "},{"$f":"VLOOKUP(F12,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}},null,"Mixed Recycling","Paper/cardboard","Mixed paper & cardboard ",null,null,0.34]
[null,null,null,null,null,null,null,null,"Mixed Recycling","Glass","Glass containers",null,null,0.33]
[null,null,null,null,null,null,null,null,"Total",null,null,null,{"$f":"(M7*$N7)+(M8*$N8)+(M9*$N9)+(M10*$N10)+(M11*$N11)+(M12*$N12)+(M13*$N13)","v":0},{"$f":"SUM(N7:N13)","v":1.0000000000000002}]
[null,"Plastic"]
[null,"Bin","Material categories","Material type","Outcome","Merged","MRS points"]
[null,null,"Plastic",null,null,{"$f":"B17&\" \"&C17&\" \"&D17&\" \"&E17","v":" Plastic  "},{"$f":"VLOOKUP(F17,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}},null,"If a composition audit was completed then use the table below to determine the MRS value for that bin, using the MRS points determined from the adjacent tables. The percentage total must equal 100%."]
[null,null,"Plastic",null,null,{"$f":"B18&\" \"&C18&\" \"&D18&\" \"&E18","v":" Plastic  "},{"$f":"VLOOKUP(F18,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"Plastic",null,null," Plastic  ",{"$f":"VLOOKUP(F19,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"Plastic",null,null," Plastic  ",{"$f":"VLOOKUP(F20,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}},null,"Bin","Material Categories","Material Type","Outcome","MRS Points","Percent"]
[null,null,"Plastic",null,null," Plastic  ",{"$f":"VLOOKUP(F21,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}},null,"Mixed Recycling"]
[null,null,null,null,null,null,null,null,"Mixed Recycling"]
[null,null,null,null,null,null,null,null,"Mixed Recycling"]
[null,"Glass",null,null,null,null,null,null,"Mixed Recycling"]
[null,"Bin","Material categories","Material type","Outcome","Merged","MRS points",null,"Mixed Recycling"]
[null,null,"Glass",null,null,{"$f":"B26&\" \"&C26&\" \"&D26&\" \"&E26","v":" Glass  "},{"$f":"VLOOKUP(F26,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}},null,"Mixed Recycling"]
[null,null,"Glass",null,null,{"$f":"B27&\" \"&C27&\" \"&D27&\" \"&E27","v":" Glass  "},{"$f":"VLOOKUP(F27,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}},null,"Mixed Recycling"]
[null,null,"Glass",null,null," Glass  ",{"$f":"VLOOKUP(F28,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}},null,"Total",null,null,null,{"$f":"(M21*$N21)+(M22*$N22)+(M23*$N23)+(M24*$N24)+(M25*$N25)+(M26*$N26)+(M27*$N27)","v":0},{"$f":"SUM(N21:N27)","v":0}]
[null,null,"Glass",null,null," Glass  ",{"$f":"VLOOKUP(F29,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"Glass",null,null," Glass  ",{"$f":"VLOOKUP(F30,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}},null,"Did a NABERS Waste accredited assessor perform, or supervise, at least one of the audits that determined these results?"]
[null,null,null,null,null,null,null,null,"Name of assessor:"]
[null,null,null,null,null,null,null,null,"Date of audit:"]
[null,"Composites"]
[null,"Bin","Material categories","Material type","Outcome","Merged","MRS points"]
[null,null,"Composites",null,null,{"$f":"B35&\" \"&C35&\" \"&D35&\" \"&E35","v":" Composites  "},{"$f":"VLOOKUP(F35,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"Composites",null,null,{"$f":"B36&\" \"&C36&\" \"&D36&\" \"&E36","v":" Composites  "},{"$f":"VLOOKUP(F36,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"Composites",null,null," Composites  ",{"$f":"VLOOKUP(F37,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"Composites",null,null," Composites  ",{"$f":"VLOOKUP(F38,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"Composites",null,null," Composites  ",{"$f":"VLOOKUP(F39,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[]
[null,"E-waste & miscellaneous"]
[null,"Bin","Material categories","Material type","Outcome","Merged","MRS points"]
[null,null,"E-Waste",null,null,{"$f":"B44&\" \"&C44&\" \"&D44&\" \"&E44","v":" E-Waste  "},{"$f":"VLOOKUP(F44,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"E-Waste",null,null,{"$f":"B45&\" \"&C45&\" \"&D45&\" \"&E45","v":" E-Waste  "},{"$f":"VLOOKUP(F45,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"E-Waste",null,null," E-Waste  ",{"$f":"VLOOKUP(F46,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"E-Waste",null,null," E-Waste  ",{"$f":"VLOOKUP(F47,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"E-Waste",null,null," E-Waste  ",{"$f":"VLOOKUP(F48,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[]
[null,"Food waste"]
[null,"Bin","Material categories","Material type","Outcome","Merged","MRS points"]
[null,null,"Food waste",null,null,{"$f":"B53&\" \"&C53&\" \"&D53&\" \"&E53","v":" Food waste  "},{"$f":"VLOOKUP(F53,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"Food waste",null,null,{"$f":"B54&\" \"&C54&\" \"&D54&\" \"&E54","v":" Food waste  "},{"$f":"VLOOKUP(F54,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"Food waste",null,null," Food waste  ",{"$f":"VLOOKUP(F55,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"Food waste",null,null," Food waste  ",{"$f":"VLOOKUP(F56,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"Food waste",null,null," Food waste  ",{"$f":"VLOOKUP(F57,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[]
[null,"Green waste/timber"]
[null,"Bin","Material categories","Material type","Outcome","Merged","MRS points"]
[null,null,"Green waste/Timber",null,null,{"$f":"B62&\" \"&C62&\" \"&D62&\" \"&E62","v":" Green waste/Timber  "},{"$f":"VLOOKUP(F62,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"Green waste/Timber",null,null,{"$f":"B63&\" \"&C63&\" \"&D63&\" \"&E63","v":" Green waste/Timber  "},{"$f":"VLOOKUP(F63,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"Green waste/Timber",null,null," Green waste/Timber  ",{"$f":"VLOOKUP(F64,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"Green waste/Timber",null,null," Green waste/Timber  ",{"$f":"VLOOKUP(F65,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"Green waste/Timber",null,null," Green waste/Timber  ",{"$f":"VLOOKUP(F66,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[]
[null,"Metals"]
[null,"Bin","Material categories","Material type","Outcome","Merged","MRS points"]
[null,null,"Metals",null,null,{"$f":"B71&\" \"&C71&\" \"&D71&\" \"&E71","v":" Metals  "},{"$f":"VLOOKUP(F71,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"Metals",null,null,{"$f":"B72&\" \"&C72&\" \"&D72&\" \"&E72","v":" Metals  "},{"$f":"VLOOKUP(F72,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"Metals",null,null," Metals  ",{"$f":"VLOOKUP(F73,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"Metals",null,null," Metals  ",{"$f":"VLOOKUP(F74,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"Metals",null,null," Metals  ",{"$f":"VLOOKUP(F75,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[]
[null,"Textiles"]
[null,"Bin","Material categories","Material type","Outcome","Merged","MRS points"]
[null,null,"Textiles",null,null,{"$f":"B80&\" \"&C80&\" \"&D80&\" \"&E80","v":" Textiles  "},{"$f":"VLOOKUP(F80,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"Textiles",null,null,{"$f":"B81&\" \"&C81&\" \"&D81&\" \"&E81","v":" Textiles  "},{"$f":"VLOOKUP(F81,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"Textiles",null,null," Textiles  ",{"$f":"VLOOKUP(F82,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"Textiles",null,null," Textiles  ",{"$f":"VLOOKUP(F83,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"Textiles",null,null," Textiles  ",{"$f":"VLOOKUP(F84,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[]
[null,"Miscellaneous"]
[null,"Bin","Material categories","Material type","Outcome","Merged","MRS points"]
[null,null,"Miscellaneous",null,null,{"$f":"B89&\" \"&C89&\" \"&D89&\" \"&E89","v":" Miscellaneous  "},{"$f":"VLOOKUP(F89,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"Miscellaneous",null,null,{"$f":"B90&\" \"&C90&\" \"&D90&\" \"&E90","v":" Miscellaneous  "},{"$f":"VLOOKUP(F90,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"Miscellaneous",null,null," Miscellaneous  ",{"$f":"VLOOKUP(F91,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"Miscellaneous",null,null," Miscellaneous  ",{"$f":"VLOOKUP(F92,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"Miscellaneous",null,null," Miscellaneous  ",{"$f":"VLOOKUP(F93,'MRS scores'!$E$2:$F$257,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Composition Audit calculator","index":4,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[[3,1,3,4],[12,1,12,4],[1,1,1,6],[21,1,21,2],[4,1,4,6],[11,1,11,6],[5,2,5,4],[6,2,6,4],[7,2,7,4],[8,2,8,4],[9,2,9,4]]}
[]
[null,"Composition Audit results calculator"]
[]
[null,"Use the table below to determine the percentage splits of materials from mixed matieral bins, as per section 7.2.4 of the Waste Rules. These values should be transferred to the MRS calculator tab to determine the MRS value for the bin. \n\nIf you have multiple bins, then copy and paste this table into the blank space below."]
[null,"Audit details"]
[null,"Bin service audited:"]
[null,"Total weight of contamination:"]
[null,"Number of bins audited"]
[null,"Audit date:"]
[null,"Name of auditor:"]
[]
[null,"Material stream results"]
[null,"The value in the Total weight column should be the combined weight for that material type for all bins that were in the audit of this bin service. Add extra rows to this table if required"]
[null,"Material Category","Material Type","Total weight","Percent"]
[null,"Plastics","HDPE",null,{"$f":"D15/D$22","v":{"$error":"#DIV/0!"}}]
[null,"Paper","paper",null,{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Total",null,{"$f":"SUM(D15:D21)","v":0},{"$f":"SUM(E15:E21)","v":{"$error":"#DIV/0!"}}]

{"sheet":"drop downs","index":5,"n_rows":92,"n_cols":5,"rows_kept":92,"cut":false,"hidden":true,"merged":[]}
[null,"Composites"]
[null,"Bin","Material categories","Material type","Outcome"]
[null,"Mixed content","Composites","Liquid paper board","New mixed paper & cardboard grade product"]
[null,"Pre-sorted bin",null,"Coffee cups","Used in compost or other organics process"]
[null,null,null,null,"Converted to composite plastic product"]
[null,null,null,null,"Burnt"]
[]
[null,"e-waste"]
[null,"Bin","Material categories","Material type","Outcome"]
[null,"Pre-sorted bin","E-waste","Batteries","Treated appropriately - licenced facility"]
[null,null,null,"E-waste as a bulk item","Incomplete supply chain information"]
[null,null,null,null,"Re-used/repaired"]
[null,null,null,null,"Re-filled"]
[null,null,null,null,"Downcycled"]
[]
[]
[null,"Glass"]
[null,"Bin","Material categories","Material type","Outcome"]
[null,"Mixed content","Glass","Containers","New glass container product"]
[null,"Pre-sorted bin",null,"Crushed","Crushed for sand replacement"]
[null,null,null,null,"Re-used"]
[]
[null,"Plastic"]
[null,"Bin","Material categories","Material type","Outcome"]
[null,"Mixed content","Plastic","PET - 1","New PET product"]
[null,"Pre-sorted bin",null,"HDPE - 2","Downcycled"]
[null,null,null,"PVC - 3 - rigid","Burnt"]
[null,null,null,"PVC - 3- flexible","New HDPE product"]
[null,null,null,"LDPE - 4 - rigid","New PVC product"]
[null,null,null,"LDPE - 4 - flexible","New LDPE product"]
[null,null,null,"Polypropolene - 5 - rigid","New polypropolene product"]
[null,null,null,"Polypropolene - 5 - flexible","New polystyrene product"]
[null,null,null,"Polystyrene - 6 - rigid","New soft plastic product"]
[null,null,null,"Polystyrene - 6 - expanded"]
[null,null,null,"Other - 7"]
[null,null,null,"Mixed bale"]
[null,null,null,"Soft plastic - colour sorted"]
[null,null,null,"Soft plastic - mixed"]
[null,null,null,"Rigid plastic - mixed"]
[]
[null,"Paper/cardboard"]
[null,"Bin","Material categories","Material type","Outcome"]
[null,"Mixed content","Paper/cardboard","Paper sorted by grade","New paper product (for that grade)"]
[null,"Pre-sorted bin",null,"Cardboard sorted by grade","New mixed paper grade product"]
[null,null,null,"Mixed paper bale","Used in compost or other organics process"]
[null,null,null,"Mixed cardboard bale","New cardboard product (for that grade)"]
[null,null,null,"Mixed paper and cardboard bale","New mixed cardboard grade product"]
[null,null,null,null,"New mixed paper & cardboard grade product"]
[null,null,null,null,"Used in compost or other organics process"]
[null,null,null,null,"Burnt"]
[null,"Food waste"]
[null,"Bin","Material categories","Material type","Outcome"]
[null,"Pre-sorted bin","Food waste","Mixed food waste","Anaerobic digestion"]
[null,null,null,"Food donation service","Composted"]
[null,null,null,"Meat and bone","Pre-treatment to sewer"]
[null,null,null,"Fish waste","On-site dehydrator then applied to land"]
[null,null,null,"Cooking oil","On-site dehydrator then composted"]
[null,null,null,"Compostable packaging","Consumed by humans or animals. No industrial processing applied."]
[null,null,null,null,"Collected for meat&bone by-products"]
[null,null,null,null,"Collected for fish by-products"]
[null,null,null,null,"Biofuel - burnt"]
[null,null,null,null,"Stockfeed"]
[null,null,null,null,"Pre-treament to sewer"]
[null,null,null,null,"Composted (soil improver)"]
[]
[]
[null,"Green waste/Timber"]
[null,"Bin","Material categories","Material type","Outcome"]
[null,"Pre-sorted bin","Green waste/timber","Mixed garden and timber waste","Composted"]
[null,null,null,"Timber pallets","Chipped and applied to land"]
[null,null,null,null,"Chipped for wood by-products"]
[null,null,null,null,"Burnt"]
[null,null,null,null,"Re-furbished"]
[]
[null,"Metals"]
[null,"Bin","Material categories","Material type","Outcome"]
[null,"Mixed content","Metals","Aluminium","New aluminium product"]
[null,"Pre-sorted bin",null,"Ferrous metals","New ferrous metals product"]
[null,null,null,"Metals - other","New metals - other product"]
[]
[null,"Textiles"]
[null,"Bin","Material categories","Material type","Outcome"]
[null,"Mixed content","Textiles","Whole garment","Re-sold as whole garment/textile"]
[null,"Pre-sorted bin",null,"Off-cuts","Used in compost or other organics process"]
[null,null,null,null,"Shredded"]
[null,null,null,null,"Burnt"]
[]
[null,"Miscellaneous"]
[null,"Bin","Material categories","Material type","Outcome"]
[null,"Pre-sorted bin","Miscellaneous","Light globes","Treated appropriately - licenced facility"]
[null,null,null,"Printer cartridges","Re-filled"]
[null,null,null,null,"Downcycled"]

{"sheet":"MRS scores","index":6,"n_rows":257,"n_cols":6,"rows_kept":257,"cut":false,"hidden":true,"merged":[]}
["Bin","Material categories","Material type","Outcome","Merged","points"]
["Mixed content","Plastic","PET - 1","New PET product",{"$f":"A2&\" \"&B2&\" \"&C2&\" \"&D2","v":"Mixed content Plastic PET - 1 New PET product"},3]
["Mixed content","Plastic","PET - 1","Downcycled","Mixed content Plastic PET - 1 Downcycled",2]
["Mixed content","Plastic","PET - 1","Burnt","Mixed content Plastic PET - 1 Burnt",0]
["Mixed content","Plastic","HDPE - 2","New HDPE product","Mixed content Plastic HDPE - 2 New HDPE product",3]
["Mixed content","Plastic","HDPE - 2","Downcycled","Mixed content Plastic HDPE - 2 Downcycled",2]
["Mixed content","Plastic","HDPE - 2","Burnt","Mixed content Plastic HDPE - 2 Burnt",0]
["Mixed content","Plastic","PVC - 3 - Rigid","New PVC product","Mixed content Plastic PVC - 3 - Rigid New PVC product",3]
["Mixed content","Plastic","PVC - 3 - Rigid","Downcycled","Mixed content Plastic PVC - 3 - Rigid Downcycled",2]
["Mixed content","Plastic","PVC - 3 - Rigid","Burnt","Mixed content Plastic PVC - 3 - Rigid Burnt",0]
["Mixed content","Plastic","PVC - 3- Flexible","New PVC product","Mixed content Plastic PVC - 3- Flexible New PVC product",4]
["Mixed content","Plastic","PVC - 3- Flexible","Downcycled","Mixed content Plastic PVC - 3- Flexible Downcycled",3]
["Mixed content","Plastic","PVC - 3- Flexible","Burnt","Mixed content Plastic PVC - 3- Flexible Burnt",0]
["Mixed content","Plastic","LDPE - 4 - Rigid","New LDPE product","Mixed content Plastic LDPE - 4 - Rigid New LDPE product",3]
["Mixed content","Plastic","LDPE - 4 - Rigid","Downcycled","Mixed content Plastic LDPE - 4 - Rigid Downcycled",2]
["Mixed content","Plastic","LDPE - 4 - Rigid","Burnt","Mixed content Plastic LDPE - 4 - Rigid Burnt",0]
["Mixed content","Plastic","LDPE - 4 - Flexible","New LDPE product","Mixed content Plastic LDPE - 4 - Flexible New LDPE product",4]
["Mixed content","Plastic","LDPE - 4 - Flexible","Downcycled","Mixed content Plastic LDPE - 4 - Flexible Downcycled",3]
["Mixed content","Plastic","LDPE - 4 - Flexible","Burnt","Mixed content Plastic LDPE - 4 - Flexible Burnt",0]
["Mixed content","Plastic","Polypropolene - 5 - Rigid","New Polypropolene product","Mixed content Plastic Polypropolene - 5 - Rigid New Polypropolene product",3]
["Mixed content","Plastic","Polypropolene - 5 - Rigid","Downcycled","Mixed content Plastic Polypropolene - 5 - Rigid Downcycled",2]
["Mixed content","Plastic","Polypropolene - 5 - Rigid","Burnt","Mixed content Plastic Polypropolene - 5 - Rigid Burnt",0]
["Mixed content","Plastic","Polypropolene - 5 - Flexible","New Polypropolene product","Mixed content Plastic Polypropolene - 5 - Flexible New Polypropolene product",4]
["Mixed content","Plastic","Polypropolene - 5 - Flexible","Downcycled","Mixed content Plastic Polypropolene - 5 - Flexible Downcycled",3]
["Mixed content","Plastic","Polypropolene - 5 - Flexible","Burnt","Mixed content Plastic Polypropolene - 5 - Flexible Burnt",0]
["Mixed content","Plastic","Polystyrene - 6 - Rigid","New Polystyrene product","Mixed content Plastic Polystyrene - 6 - Rigid New Polystyrene product",3]
["Mixed content","Plastic","Polystyrene - 6 - Rigid","Downcycled","Mixed content Plastic Polystyrene - 6 - Rigid Downcycled",2]
["Mixed content","Plastic","Polystyrene - 6 - Rigid","Burnt","Mixed content Plastic Polystyrene - 6 - Rigid Burnt",0]
["Mixed content","Plastic","Polystyrene - 6 - Expanded","New Polystyrene product","Mixed content Plastic Polystyrene - 6 - Expanded New Polystyrene product",4]
["Mixed content","Plastic","Polystyrene - 6 - Expanded","Downcycled","Mixed content Plastic Polystyrene - 6 - Expanded Downcycled",3]
["Mixed content","Plastic","Polystyrene - 6 - Expanded","Burnt","Mixed content Plastic Polystyrene - 6 - Expanded Burnt",0]
["Mixed content","Plastic","Other - 7","Downcycled","Mixed content Plastic Other - 7 Downcycled",2]
["Mixed content","Plastic","Other - 7","Burnt","Mixed content Plastic Other - 7 Burnt",0]
["Mixed content","Plastic","Mixed bale","Downcycled","Mixed content Plastic Mixed bale Downcycled",2]
["Mixed content","Plastic","Mixed bale","Burnt","Mixed content Plastic Mixed bale Burnt",0]
["Mixed content","Plastic","Soft plastic - colour sorted","New soft plastic product","Mixed content Plastic Soft plastic - colour sorted New soft plastic product",4]
["Mixed content","Plastic","Soft plastic - colour sorted","Downcycled","Mixed content Plastic Soft plastic - colour sorted Downcycled",3]
["Mixed content","Plastic","Soft plastic - colour sorted","Burnt","Mixed content Plastic Soft plastic - colour sorted Burnt",0]
["Mixed content","Plastic","Soft plastic - mixed","Downcycled","Mixed content Plastic Soft plastic - mixed Downcycled",3]
["Mixed content","Plastic","Soft plastic - mixed","Burnt","Mixed content Plastic Soft plastic - mixed Burnt",0]
["Mixed content","Plastic","Rigid plastic - mixed","Downcycled","Mixed content Plastic Rigid plastic - mixed Downcycled",2]
["Mixed content","Plastic","Rigid plastic - mixed","Burnt","Mixed content Plastic Rigid plastic - mixed Burnt",0]
["Mixed content","Glass","Containers","New glass container product","Mixed content Glass Containers New glass container product",3]
["Mixed content","Glass","Containers","Crushed for sand replacement","Mixed content Glass Containers Crushed for sand replacement",2]
["Mixed content","Glass","Crushed","Crushed for sand replacement","Mixed content Glass Crushed Crushed for sand replacement",2]
["Mixed content","Metals","Aluminium","New Aluminium product","Mixed content Metals Aluminium New Aluminium product",3]
["Mixed content","Metals","Ferrous metals","New Ferrous metals product","Mixed content Metals Ferrous metals New Ferrous metals product",3]
["Mixed content","Metals","Metals - other","New Metals - other product","Mixed content Metals Metals - other New Metals - other product",3]
["Mixed content","Paper/cardboard","Paper sorted by grade","New paper product (for that grade)","Mixed content Paper/cardboard Paper sorted by grade New paper product (for that grade)",4]
["Mixed content","Paper/cardboard","Paper sorted by grade","New mixed paper grade product","Mixed content Paper/cardboard Paper sorted by grade New mixed paper grade product",4]
["Mixed content","Paper/cardboard","Paper sorted by grade","used in compost or other organics process","Mixed content Paper/cardboard Paper sorted by grade used in compost or other organics process",4]
["Mixed content","Paper/cardboard","Paper sorted by grade","Burnt","Mixed content Paper/cardboard Paper sorted by grade Burnt",0]
["Mixed content","Paper/cardboard","Cardboard sorted by grade","New cardboard product (for that grade)","Mixed content Paper/cardboard Cardboard sorted by grade New cardboard product (for that grade)",4]
["Mixed content","Paper/cardboard","Cardboard sorted by grade","New mixed cardboard grade product","Mixed content Paper/cardboard Cardboard sorted by grade New mixed cardboard grade product",4]
["Mixed content","Paper/cardboard","cardboard sorted by grade","used in compost or other organics process","Mixed content Paper/cardboard cardboard sorted by grade used in compost or other organics process",4]
["Mixed content","Paper/cardboard","cardboard sorted by grade","Burnt","Mixed content Paper/cardboard cardboard sorted by grade Burnt",0]
["Mixed content","Paper/cardboard","mixed paper bale","New mixed paper grade product","Mixed content Paper/cardboard mixed paper bale New mixed paper grade product",4]
["Mixed content","Paper/cardboard","mixed paper bale","used in compost or other organics process","Mixed content Paper/cardboard mixed paper bale used in compost or other organics process",4]
["Mixed content","Paper/cardboard","mixed paper bale","Burnt","Mixed content Paper/cardboard mixed paper bale Burnt",0]
["Mixed content","Paper/cardboard","Mixed cardboard bale","New mixed cardboard grade product","Mixed content Paper/cardboard Mixed cardboard bale New mixed cardboard grade product",4]
["Mixed content","Paper/cardboard","mixed cardboard bale","used in compost or other organics process","Mixed content Paper/cardboard mixed cardboard bale used in compost or other organics process",4]
["Mixed content","Paper/cardboard","mixed cardboard bale","Burnt","Mixed content Paper/cardboard mixed cardboard bale Burnt",0]
["Mixed content","Paper/cardboard","Mixed paper and cardboard bale","New mixed paper & cardboard grade product","Mixed content Paper/cardboard Mixed paper and cardboard bale New mixed paper & cardboard grade product",4]
["Mixed content","Paper/cardboard","mixed paper and cardboard bale","used in compost or other organics process","Mixed content Paper/cardboard mixed paper and cardboard bale used in compost or other organics process",4]
["Mixed content","Paper/cardboard","mixed paper and cardboard bale","Burnt","Mixed content Paper/cardboard mixed paper and cardboard bale Burnt",0]
["Mixed content","Composites","Liquid paper board","New mixed paper & cardboard grade product",{"$f":"A66&\" \"&B66&\" \"&C66&\" \"&D66","v":"Mixed content Composites Liquid paper board New mixed paper & cardboard grade product"},3]
["Mixed content","Composites","Liquid paper board","used in compost or other organics process","Mixed content Composites Liquid paper board used in compost or other organics process",2]
["Mixed content","Composites","Liquid paper board","Converted to composite plastic product","Mixed content Composites Liquid paper board Converted to composite plastic product",2]
["Mixed content","Composites","Liquid paper board","Burnt","Mixed content Composites Liquid paper board Burnt",0]
["Mixed content","Composites","coffee cups","New mixed paper & cardboard grade product","Mixed content Composites coffee cups New mixed paper & cardboard grade product",4]
["Mixed content","Composites","coffee cups","used in compost or other organics process","Mixed content Composites coffee cups used in compost or other organics process",2]
["Mixed content","Composites","coffee cups","Converted to composite plastic product","Mixed content Composites coffee cups Converted to composite plastic product",3]
["Mixed content","Composites","coffee cups","Burnt","Mixed content Composites coffee cups Burnt",0]
["Mixed content","Textiles","Whole garment","re-sold as whole garment/textile","Mixed content Textiles Whole garment re-sold as whole garment/textile",4]
["Mixed content","Textiles","Whole garment","used in compost or other organics process","Mixed content Textiles Whole garment used in compost or other organics process",3]
["Mixed content","Textiles","Whole garment","shredded","Mixed content Textiles Whole garment shredded",2]
["Mixed content","Textiles","Off-cuts","shredded","Mixed content Textiles Off-cuts shredded",2]
["Mixed content","Textiles","Off-cuts","used in compost or other organics process","Mixed content Textiles Off-cuts used in compost or other organics process",3]
["Mixed content","Textiles","Off-cuts","Burnt","Mixed content Textiles Off-cuts Burnt",0]
["Pre-sorted bin","Plastic","PET - 1","New PET product","Pre-sorted bin Plastic PET - 1 New PET product",4]
["Pre-sorted bin","Plastic","PET - 1","Downcycled","Pre-sorted bin Plastic PET - 1 Downcycled",3]
["Pre-sorted bin","Plastic","PET - 1","Burnt","Pre-sorted bin Plastic PET - 1 Burnt",0]
["Pre-sorted bin","Plastic","HDPE - 2","New HDPE product","Pre-sorted bin Plastic HDPE - 2 New HDPE product",4]
["Pre-sorted bin","Plastic","HDPE - 2","Downcycled","Pre-sorted bin Plastic HDPE - 2 Downcycled",3]
["Pre-sorted bin","Plastic","HDPE - 2","Burnt","Pre-sorted bin Plastic HDPE - 2 Burnt",0]
["Pre-sorted bin","Plastic","PVC - 3 - Rigid","New PVC product","Pre-sorted bin Plastic PVC - 3 - Rigid New PVC product",4]
["Pre-sorted bin","Plastic","PVC - 3 - Rigid","Downcycled","Pre-sorted bin Plastic PVC - 3 - Rigid Downcycled",3]
["Pre-sorted bin","Plastic","PVC - 3 - Rigid","Burnt","Pre-sorted bin Plastic PVC - 3 - Rigid Burnt",0]
["Pre-sorted bin","Plastic","PVC - 3- Flexible","New PVC product","Pre-sorted bin Plastic PVC - 3- Flexible New PVC product",5]
["Pre-sorted bin","Plastic","PVC - 3- Flexible","Downcycled","Pre-sorted bin Plastic PVC - 3- Flexible Downcycled",4]
["Pre-sorted bin","Plastic","PVC - 3- Flexible","Burnt","Pre-sorted bin Plastic PVC - 3- Flexible Burnt",0]
["Pre-sorted bin","Plastic","LDPE - 4 - Rigid","New LDPE product","Pre-sorted bin Plastic LDPE - 4 - Rigid New LDPE product",4]
["Pre-sorted bin","Plastic","LDPE - 4 - Rigid","Downcycled","Pre-sorted bin Plastic LDPE - 4 - Rigid Downcycled",3]
["Pre-sorted bin","Plastic","LDPE - 4 - Rigid","Burnt","Pre-sorted bin Plastic LDPE - 4 - Rigid Burnt",0]
["Pre-sorted bin","Plastic","LDPE - 4 - Flexible","New LDPE product","Pre-sorted bin Plastic LDPE - 4 - Flexible New LDPE product",5]
["Pre-sorted bin","Plastic","LDPE - 4 - Flexible","Downcycled","Pre-sorted bin Plastic LDPE - 4 - Flexible Downcycled",4]
["Pre-sorted bin","Plastic","LDPE - 4 - Flexible","Burnt","Pre-sorted bin Plastic LDPE - 4 - Flexible Burnt",0]
["Pre-sorted bin","Plastic","Polypropolene - 5 - Rigid","New Polypropolene product","Pre-sorted bin Plastic Polypropolene - 5 - Rigid New Polypropolene product",4]
["Pre-sorted bin","Plastic","Polypropolene - 5 - Rigid","Downcycled","Pre-sorted bin Plastic Polypropolene - 5 - Rigid Downcycled",3]
["Pre-sorted bin","Plastic","Polypropolene - 5 - Rigid","Burnt","Pre-sorted bin Plastic Polypropolene - 5 - Rigid Burnt",0]
["Pre-sorted bin","Plastic","Polypropolene - 5 - Flexible","New Polypropolene product","Pre-sorted bin Plastic Polypropolene - 5 - Flexible New Polypropolene product",5]
["Pre-sorted bin","Plastic","Polypropolene - 5 - Flexible","Downcycled","Pre-sorted bin Plastic Polypropolene - 5 - Flexible Downcycled",4]
["Pre-sorted bin","Plastic","Polypropolene - 5 - Flexible","Burnt","Pre-sorted bin Plastic Polypropolene - 5 - Flexible Burnt",0]
["Pre-sorted bin","Plastic","Polystyrene - 6 - Rigid","New Polystyrene product","Pre-sorted bin Plastic Polystyrene - 6 - Rigid New Polystyrene product",4]
["Pre-sorted bin","Plastic","Polystyrene - 6 - Rigid","Downcycled","Pre-sorted bin Plastic Polystyrene - 6 - Rigid Downcycled",3]
["Pre-sorted bin","Plastic","Polystyrene - 6 - Rigid","Burnt","Pre-sorted bin Plastic Polystyrene - 6 - Rigid Burnt",0]
["Pre-sorted bin","Plastic","Polystyrene - 6 - Expanded","New Polystyrene product","Pre-sorted bin Plastic Polystyrene - 6 - Expanded New Polystyrene product",5]
["Pre-sorted bin","Plastic","Polystyrene - 6 - Expanded","Downcycled","Pre-sorted bin Plastic Polystyrene - 6 - Expanded Downcycled",4]
["Pre-sorted bin","Plastic","Polystyrene - 6 - Expanded","Burnt","Pre-sorted bin Plastic Polystyrene - 6 - Expanded Burnt",0]
["Pre-sorted bin","Plastic","Other - 7","Downcycled","Pre-sorted bin Plastic Other - 7 Downcycled",3]
["Pre-sorted bin","Plastic","Other - 7","Burnt","Pre-sorted bin Plastic Other - 7 Burnt",0]
["Pre-sorted bin","Plastic","Mixed bale","Downcycled","Pre-sorted bin Plastic Mixed bale Downcycled",3]
["Pre-sorted bin","Plastic","Mixed bale","Burnt","Pre-sorted bin Plastic Mixed bale Burnt",0]
["Pre-sorted bin","Plastic","Soft plastic - colour sorted","New soft plastic product","Pre-sorted bin Plastic Soft plastic - colour sorted New soft plastic product",5]
["Pre-sorted bin","Plastic","Soft plastic - colour sorted","Downcycled","Pre-sorted bin Plastic Soft plastic - colour sorted Downcycled",4]
["Pre-sorted bin","Plastic","Soft plastic - colour sorted","Burnt","Pre-sorted bin Plastic Soft plastic - colour sorted Burnt",0]
["Pre-sorted bin","Plastic","Soft plastic - mixed","Downcycled","Pre-sorted bin Plastic Soft plastic - mixed Downcycled",4]
["Pre-sorted bin","Plastic","Soft plastic - mixed","Burnt","Pre-sorted bin Plastic Soft plastic - mixed Burnt",0]
["Pre-sorted bin","Plastic","Rigid plastic - mixed","Downcycled","Pre-sorted bin Plastic Rigid plastic - mixed Downcycled",3]
["Pre-sorted bin","Plastic","Rigid plastic - mixed","Burnt","Pre-sorted bin Plastic Rigid plastic - mixed Burnt",0]
["Pre-sorted bin","Glass","Containers","re-used","Pre-sorted bin Glass Containers re-used",5]
["Pre-sorted bin","Glass","Containers","New glass container product","Pre-sorted bin Glass Containers New glass container product",4]
["Pre-sorted bin","Glass","Containers","Crushed for sand replacement","Pre-sorted bin Glass Containers Crushed for sand replacement",3]
["Pre-sorted bin","Glass","Crushed","Crushed for sand replacement","Pre-sorted bin Glass Crushed Crushed for sand replacement",3]
["Pre-sorted bin","Metals","Aluminium","New Aluminium product","Pre-sorted bin Metals Aluminium New Aluminium product",4]
["Pre-sorted bin","Metals","Ferrous metals","New Ferrous metals product","Pre-sorted bin Metals Ferrous metals New Ferrous metals product",4]
["Pre-sorted bin","Metals","Metals - other","New Metals - other product","Pre-sorted bin Metals Metals - other New Metals - other product",4]
["Pre-sorted bin","Paper/cardboard","Paper sorted by grade","New paper product (for that grade)","Pre-sorted bin Paper/cardboard Paper sorted by grade New paper product (for that grade)",5]
["Pre-sorted bin","Paper/cardboard","Paper sorted by grade","New mixed paper grade product","Pre-sorted bin Paper/cardboard Paper sorted by grade New mixed paper grade product",5]
["Pre-sorted bin","Paper/cardboard","Paper sorted by grade","used in compost or other organics process",{"$f":"A130&\" \"&B130&\" \"&C130&\" \"&D130","v":"Pre-sorted bin Paper/cardboard Paper sorted by grade used in compost or other organics process"},5]
["Pre-sorted bin","Paper/cardboard","Paper sorted by grade","Burnt","Pre-sorted bin Paper/cardboard Paper sorted by grade Burnt",0]
["Pre-sorted bin","Paper/cardboard","Cardboard sorted by grade","New cardboard product (for that grade)","Pre-sorted bin Paper/cardboard Cardboard sorted by grade New cardboard product (for that grade)",5]
["Pre-sorted bin","Paper/cardboard","Cardboard sorted by grade","New mixed cardboard grade product","Pre-sorted bin Paper/cardboard Cardboard sorted by grade New mixed cardboard grade product",5]
["Pre-sorted bin","Paper/cardboard","cardboard sorted by grade","used in compost or other organics process","Pre-sorted bin Paper/cardboard cardboard sorted by grade used in compost or other organics process",5]
["Pre-sorted bin","Paper/cardboard","cardboard sorted by grade","Burnt","Pre-sorted bin Paper/cardboard cardboard sorted by grade Burnt",0]
["Pre-sorted bin","Paper/cardboard","mixed paper bale","New mixed paper grade product","Pre-sorted bin Paper/cardboard mixed paper bale New mixed paper grade product",5]
["Pre-sorted bin","Paper/cardboard","mixed paper bale","used in compost or other organics process","Pre-sorted bin Paper/cardboard mixed paper bale used in compost or other organics process",5]
["Pre-sorted bin","Paper/cardboard","mixed paper bale","Burnt","Pre-sorted bin Paper/cardboard mixed paper bale Burnt",0]
["Pre-sorted bin","Paper/cardboard","Mixed cardboard bale","New mixed cardboard grade product","Pre-sorted bin Paper/cardboard Mixed cardboard bale New mixed cardboard grade product",5]
["Pre-sorted bin","Paper/cardboard","mixed cardboard bale","used in compost or other organics process","Pre-sorted bin Paper/cardboard mixed cardboard bale used in compost or other organics process",5]
["Pre-sorted bin","Paper/cardboard","mixed cardboard bale","Burnt","Pre-sorted bin Paper/cardboard mixed cardboard bale Burnt",0]
["Pre-sorted bin","Paper/cardboard","Mixed paper and cardboard bale","New mixed paper & cardboard grade product","Pre-sorted bin Paper/cardboard Mixed paper and cardboard bale New mixed paper & cardboard grade product",5]
["Pre-sorted bin","Paper/cardboard","mixed paper and cardboard bale","used in compost or other organics process","Pre-sorted bin Paper/cardboard mixed paper and cardboard bale used in compost or other organics process",5]
["Pre-sorted bin","Paper/cardboard","mixed paper and cardboard bale","Burnt","Pre-sorted bin Paper/cardboard mixed paper and cardboard bale Burnt",0]
["Pre-sorted bin","Food waste","mixed food waste","Anaerobic digestion","Pre-sorted bin Food waste mixed food waste Anaerobic digestion",6]
["Pre-sorted bin","Food waste","mixed food waste","Composted","Pre-sorted bin Food waste mixed food waste Composted",5]
["Pre-sorted bin","Food waste","mixed food waste","Pre-treatment to sewer","Pre-sorted bin Food waste mixed food waste Pre-treatment to sewer",5]
["Pre-sorted bin","Food waste","mixed food waste","On-site dehydrator then applied to land","Pre-sorted bin Food waste mixed food waste On-site dehydrator then applied to land",5]
["Pre-sorted bin","Food waste","mixed food waste","On-site dehydrator then composted","Pre-sorted bin Food waste mixed food waste On-site dehydrator then composted",5]
["Pre-sorted bin","Food waste","mixed food waste","Composted (soil improver/low-quality)","Pre-sorted bin Food waste mixed food waste Composted (soil improver/low-quality)",3]
["Pre-sorted bin","Food waste","food donation service","consumed by humans or animals. No industrial processing applied.","Pre-sorted bin Food waste food donation service consumed by humans or animals. No industrial processing applied.",6]
["Pre-sorted bin","Food waste","meat and bone","collected for meat&bone by-products","Pre-sorted bin Food waste meat and bone collected for meat&bone by-products",5]
["Pre-sorted bin","Food waste","meat and bone","Composted","Pre-sorted bin Food waste meat and bone Composted",5]
["Pre-sorted bin","Food waste","fish waste","collected for fish by-products","Pre-sorted bin Food waste fish waste collected for fish by-products",5]
["Pre-sorted bin","Food waste","fish waste","Composted","Pre-sorted bin Food waste fish waste Composted",5]
["Pre-sorted bin","Food waste","Cooking oil","Biofuel - burnt","Pre-sorted bin Food waste Cooking oil Biofuel - burnt",1]
["Pre-sorted bin","Food waste","Cooking oil","Stockfeed","Pre-sorted bin Food waste Cooking oil Stockfeed",5]
["Pre-sorted bin","Green waste/timber","mixed garden and timber waste","Composted","Pre-sorted bin Green waste/timber mixed garden and timber waste Composted",5]
["Pre-sorted bin","Green waste/timber","mixed garden and timber waste","Chipped and applied to land","Pre-sorted bin Green waste/timber mixed garden and timber waste Chipped and applied to land",4]
["Pre-sorted bin","Green waste/timber","mixed garden and timber waste","Chipped for wood by-products","Pre-sorted bin Green waste/timber mixed garden and timber waste Chipped for wood by-products",4]
["Pre-sorted bin","Green waste/timber","mixed garden and timber waste","Burnt","Pre-sorted bin Green waste/timber mixed garden and timber waste Burnt",0]
["Pre-sorted bin","Green waste/timber","timber pallets","Re-furbished","Pre-sorted bin Green waste/timber timber pallets Re-furbished",6]
["Pre-sorted bin","Green waste/timber","timber pallets","Chipped and applied to land","Pre-sorted bin Green waste/timber timber pallets Chipped and applied to land",4]
["Pre-sorted bin","Green waste/timber","timber pallets","Chipped for wood by-products","Pre-sorted bin Green waste/timber timber pallets Chipped for wood by-products",4]
["Pre-sorted bin","Green waste/timber","timber pallets","Burnt","Pre-sorted bin Green waste/timber timber pallets Burnt",0]
["Pre-sorted bin","Composites","Liquid paper board","New mixed paper & cardboard grade product","Pre-sorted bin Composites Liquid paper board New mixed paper & cardboard grade product",4]
["Pre-sorted bin","Composites","Liquid paper board","used in compost or other organics process","Pre-sorted bin Composites Liquid paper board used in compost or other organics process",4]
["Pre-sorted bin","Composites","Liquid paper board","Converted to composite plastic product","Pre-sorted bin Composites Liquid paper board Converted to composite plastic product",3]
["Pre-sorted bin","Composites","Liquid paper board","Burnt","Pre-sorted bin Composites Liquid paper board Burnt",0]
["Pre-sorted bin","Composites","coffee cups","New mixed paper & cardboard grade product","Pre-sorted bin Composites coffee cups New mixed paper & cardboard grade product",5]
["Pre-sorted bin","Composites","coffee cups","used in compost or other organics process","Pre-sorted bin Composites coffee cups used in compost or other organics process",4]
["Pre-sorted bin","Composites","coffee cups","Converted to composite plastic product","Pre-sorted bin Composites coffee cups Converted to composite plastic product",4]
["Pre-sorted bin","Composites","coffee cups","Burnt","Pre-sorted bin Composites coffee cups Burnt",0]
["Pre-sorted bin","miscellaneous","light globes","Treated appropriately - licenced facility","Pre-sorted bin miscellaneous light globes Treated appropriately - licenced facility",5]
["Pre-sorted bin","e-waste","batteries","Treated appropriately - licenced facility","Pre-sorted bin e-waste batteries Treated appropriately - licenced facility",5]
["Pre-sorted bin","e-waste","batteries","Incomplete supply chain information","Pre-sorted bin e-waste batteries Incomplete supply chain information",2]
["Pre-sorted bin","e-waste","e-waste as a bulk item","Treated appropriately - licenced facility","Pre-sorted bin e-waste e-waste as a bulk item Treated appropriately - licenced facility",5]
["Pre-sorted bin","e-waste","e-waste as a bulk item","Re-used/repaired","Pre-sorted bin e-waste e-waste as a bulk item Re-used/repaired",6]
["Pre-sorted bin","e-waste","e-waste as a bulk item","Incomplete supply chain information","Pre-sorted bin e-waste e-waste as a bulk item Incomplete supply chain information",2]
["Pre-sorted bin","Miscellaneous","printer cartridges","re-filled","Pre-sorted bin Miscellaneous printer cartridges re-filled",5]
["Pre-sorted bin","Miscellaneous","printer cartridges","downcycled","Pre-sorted bin Miscellaneous printer cartridges downcycled",4]
["Pre-sorted bin","Textiles","Whole garment","re-sold as whole garment/textile","Pre-sorted bin Textiles Whole garment re-sold as whole garment/textile",5]
["Pre-sorted bin","Textiles","Whole garment","used in compost or other organics process","Pre-sorted bin Textiles Whole garment used in compost or other organics process",4]
["Pre-sorted bin","Textiles","Whole garment","shredded","Pre-sorted bin Textiles Whole garment shredded",3]
["Pre-sorted bin","Textiles","Off-cuts","shredded","Pre-sorted bin Textiles Off-cuts shredded",3]
["Pre-sorted bin","Textiles","Off-cuts","used in compost or other organics process","Pre-sorted bin Textiles Off-cuts used in compost or other organics process",4]
["AWT or similar","Plastic","PET - 1","New PET product","AWT or similar Plastic PET - 1 New PET product",2]
["AWT or similar","Plastic","PET - 1","Downcycled","AWT or similar Plastic PET - 1 Downcycled",1]
["AWT or similar","Plastic","PET - 1","Burnt","AWT or similar Plastic PET - 1 Burnt",0]
["AWT or similar","Plastic","HDPE - 2","New HDPE product","AWT or similar Plastic HDPE - 2 New HDPE product",2]
["AWT or similar","Plastic","HDPE - 2","Downcycled","AWT or similar Plastic HDPE - 2 Downcycled",1]
["AWT or similar","Plastic","HDPE - 2","Burnt","AWT or similar Plastic HDPE - 2 Burnt",0]
["AWT or similar","Plastic","PVC - 3 - Rigid","New PVC product","AWT or similar Plastic PVC - 3 - Rigid New PVC product",2]
["AWT or similar","Plastic","PVC - 3 - Rigid","Downcycled",{"$f":"A194&\" \"&B194&\" \"&C194&\" \"&D194","v":"AWT or similar Plastic PVC - 3 - Rigid Downcycled"},1]
["AWT or similar","Plastic","PVC - 3 - Rigid","Burnt","AWT or similar Plastic PVC - 3 - Rigid Burnt",0]
["AWT or similar","Plastic","PVC - 3- Flexible","New PVC product","AWT or similar Plastic PVC - 3- Flexible New PVC product",3]
["AWT or similar","Plastic","PVC - 3- Flexible","Downcycled","AWT or similar Plastic PVC - 3- Flexible Downcycled",2]
["AWT or similar","Plastic","PVC - 3- Flexible","Burnt","AWT or similar Plastic PVC - 3- Flexible Burnt",0]
["AWT or similar","Plastic","LDPE - 4 - Rigid","New LDPE product","AWT or similar Plastic LDPE - 4 - Rigid New LDPE product",2]
["AWT or similar","Plastic","LDPE - 4 - Rigid","Downcycled","AWT or similar Plastic LDPE - 4 - Rigid Downcycled",1]
["AWT or similar","Plastic","LDPE - 4 - Rigid","Burnt","AWT or similar Plastic LDPE - 4 - Rigid Burnt",0]
["AWT or similar","Plastic","LDPE - 4 - Flexible","New LDPE product","AWT or similar Plastic LDPE - 4 - Flexible New LDPE product",3]
["AWT or similar","Plastic","LDPE - 4 - Flexible","Downcycled","AWT or similar Plastic LDPE - 4 - Flexible Downcycled",2]
["AWT or similar","Plastic","LDPE - 4 - Flexible","Burnt","AWT or similar Plastic LDPE - 4 - Flexible Burnt",0]
["AWT or similar","Plastic","Polypropolene - 5 - Rigid","New Polypropolene product","AWT or similar Plastic Polypropolene - 5 - Rigid New Polypropolene product",2]
["AWT or similar","Plastic","Polypropolene - 5 - Rigid","Downcycled","AWT or similar Plastic Polypropolene - 5 - Rigid Downcycled",1]
["AWT or similar","Plastic","Polypropolene - 5 - Rigid","Burnt","AWT or similar Plastic Polypropolene - 5 - Rigid Burnt",0]
["AWT or similar","Plastic","Polypropolene - 5 - Flexible","New Polypropolene product","AWT or similar Plastic Polypropolene - 5 - Flexible New Polypropolene product",3]
["AWT or similar","Plastic","Polypropolene - 5 - Flexible","Downcycled","AWT or similar Plastic Polypropolene - 5 - Flexible Downcycled",2]
["AWT or similar","Plastic","Polypropolene - 5 - Flexible","Burnt","AWT or similar Plastic Polypropolene - 5 - Flexible Burnt",0]
["AWT or similar","Plastic","Polystyrene - 6 - Rigid","New Polystyrene product","AWT or similar Plastic Polystyrene - 6 - Rigid New Polystyrene product",2]
["AWT or similar","Plastic","Polystyrene - 6 - Rigid","Downcycled","AWT or similar Plastic Polystyrene - 6 - Rigid Downcycled",1]
["AWT or similar","Plastic","Polystyrene - 6 - Rigid","Burnt","AWT or similar Plastic Polystyrene - 6 - Rigid Burnt",0]
["AWT or similar","Plastic","Polystyrene - 6 - Expanded","New Polystyrene product","AWT or similar Plastic Polystyrene - 6 - Expanded New Polystyrene product",3]
["AWT or similar","Plastic","Polystyrene - 6 - Expanded","Downcycled","AWT or similar Plastic Polystyrene - 6 - Expanded Downcycled",2]
["AWT or similar","Plastic","Polystyrene - 6 - Expanded","Burnt","AWT or similar Plastic Polystyrene - 6 - Expanded Burnt",0]
["AWT or similar","Plastic","Other - 7","Downcycled","AWT or similar Plastic Other - 7 Downcycled",1]
["AWT or similar","Plastic","Other - 7","Burnt","AWT or similar Plastic Other - 7 Burnt",0]
["AWT or similar","Plastic","Mixed bale","Downcycled","AWT or similar Plastic Mixed bale Downcycled",1]
["AWT or similar","Plastic","Mixed bale","Burnt","AWT or similar Plastic Mixed bale Burnt",0]
["AWT or similar","Plastic","Soft plastic - colour sorted","New soft plastic product","AWT or similar Plastic Soft plastic - colour sorted New soft plastic product",3]
["AWT or similar","Plastic","Soft plastic - colour sorted","Downcycled","AWT or similar Plastic Soft plastic - colour sorted Downcycled",2]
["AWT or similar","Plastic","Soft plastic - colour sorted","Burnt","AWT or similar Plastic Soft plastic - colour sorted Burnt",0]
["AWT or similar","Plastic","Soft plastic - mixed","Downcycled","AWT or similar Plastic Soft plastic - mixed Downcycled",2]
["AWT or similar","Plastic","Soft plastic - mixed","Burnt","AWT or similar Plastic Soft plastic - mixed Burnt",0]
["AWT or similar","Plastic","Rigid plastic - mixed","Downcycled","AWT or similar Plastic Rigid plastic - mixed Downcycled",1]
["AWT or similar","Plastic","Rigid plastic - mixed","Burnt","AWT or similar Plastic Rigid plastic - mixed Burnt",0]
["AWT or similar","Glass","Containers","New glass container product","AWT or similar Glass Containers New glass container product",2]
["AWT or similar","Glass","Containers","Crushed for sand replacement","AWT or similar Glass Containers Crushed for sand replacement",1]
["AWT or similar","Glass","Crushed","Crushed for sand replacement","AWT or similar Glass Crushed Crushed for sand replacement",1]
["AWT or similar","Metals","Aluminium","New Aluminium product","AWT or similar Metals Aluminium New Aluminium product",2]
["AWT or similar","Metals","Ferrous metals","New Ferrous metals product","AWT or similar Metals Ferrous metals New Ferrous metals product",2]
["AWT or similar","Metals","Metals - other","New Metals - other product","AWT or similar Metals Metals - other New Metals - other product",2]
["AWT or similar","Paper/cardboard","Mixed paper and cardboard bale","New mixed paper & cardboard grade product","AWT or similar Paper/cardboard Mixed paper and cardboard bale New mixed paper & cardboard grade product",3]
["AWT or similar","Paper/cardboard","mixed paper and cardboard bale","used in compost or other organics process","AWT or similar Paper/cardboard mixed paper and cardboard bale used in compost or other organics process",3]
["AWT or similar","Paper/cardboard","mixed paper and cardboard bale","Burnt","AWT or similar Paper/cardboard mixed paper and cardboard bale Burnt",0]
["AWT or similar","Food waste","mixed food waste","Anaerobic digestion","AWT or similar Food waste mixed food waste Anaerobic digestion",4]
["AWT or similar","Food waste","mixed food waste","Composted (soil improver/low-quality)","AWT or similar Food waste mixed food waste Composted (soil improver/low-quality)",1]
["AWT or similar","Green waste/timber","mixed garden and timber waste","Chipped and applied to land","AWT or similar Green waste/timber mixed garden and timber waste Chipped and applied to land",2]
["AWT or similar","Green waste/timber","mixed garden and timber waste","Chipped for wood by-products","AWT or similar Green waste/timber mixed garden and timber waste Chipped for wood by-products",2]
["AWT or similar","Green waste/timber","mixed garden and timber waste","Burnt","AWT or similar Green waste/timber mixed garden and timber waste Burnt",0]
["AWT or similar","Green waste/timber","timber pallets","Re-furbished","AWT or similar Green waste/timber timber pallets Re-furbished",4]
["AWT or similar","Green waste/timber","timber pallets","Chipped and applied to land","AWT or similar Green waste/timber timber pallets Chipped and applied to land",0]
["AWT or similar","Green waste/timber","timber pallets","Chipped for wood by-products","AWT or similar Green waste/timber timber pallets Chipped for wood by-products",2]
["AWT or similar","Green waste/timber","timber pallets","Burnt","AWT or similar Green waste/timber timber pallets Burnt",0]
["AWT or similar","Composites","Liquid paper board","New mixed paper & cardboard grade product","AWT or similar Composites Liquid paper board New mixed paper & cardboard grade product",2]
["AWT or similar","Composites","Liquid paper board","used in compost or other organics process","AWT or similar Composites Liquid paper board used in compost or other organics process",1]
["AWT or similar","Composites","Liquid paper board","Converted to composite plastic product","AWT or similar Composites Liquid paper board Converted to composite plastic product",1]
["AWT or similar","Composites","Liquid paper board","Burnt","AWT or similar Composites Liquid paper board Burnt",0]
["AWT or similar","Composites","coffee cups","New mixed paper & cardboard grade product","AWT or similar Composites coffee cups New mixed paper & cardboard grade product",3]
["AWT or similar","Composites","coffee cups","used in compost or other organics process","AWT or similar Composites coffee cups used in compost or other organics process",1]
["AWT or similar","Composites","coffee cups","Converted to composite plastic product","AWT or similar Composites coffee cups Converted to composite plastic product",2]
["AWT or similar","Composites","coffee cups","Burnt","AWT or similar Composites coffee cups Burnt",0]
["Pre-sorted bin","Food waste","compostable packaging","Anaerobic digestion","Pre-sorted bin Food waste compostable packaging Anaerobic digestion",6]
["Pre-sorted bin","Food waste","compostable packaging","Composted","Pre-sorted bin Food waste compostable packaging Composted",5]
["Pre-sorted bin","Food waste","compostable packaging","Pre-treament to sewer","Pre-sorted bin Food waste compostable packaging Pre-treament to sewer",5]
["Pre-sorted bin","Food waste","compostable packaging","Composted (soil improver)","Pre-sorted bin Food waste compostable packaging Composted (soil improver)",3]

{"sheet":"Support","index":7,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Threshold ",0.2]
[]
[]
[null,"January",null,"General waste",null,null,"Mobile bin",null,"m³"]
[null,"February",null,"Mixed recycling",null,null,"Compactor",null,"L"]
[null,"March",null,"Paper & Cardboard",null,null,"Bags"]
[null,"April",null,"Cardboard (compacted)",null,null,"Bales"]
[null,"May",null,"Dry waste",null,null,"Cage"]
[null,"June",null,"Paper",null,null,"Crate"]
[null,"July",null,"Cardboard",null,null,"Vessel"]
[null,"August",null,"Organics"]
[null,"September",null,"Glass"]
[null,"October"]
[null,"November"]
[null,"December"]