{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Questionnaire","Results","Background Rankings - Hide","Messages - Hide","Drop-Down Data - Hide","Methodology"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":9,"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":"Questionnaire","index":0,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[2,2,4,2],[2,5,4,8],[5,5,5,6],[1,1,1,2],[5,1,5,2]]}
[]
[null,"Introduction"]
[null,null,"Purpose: This tool is designed to accompany the Food Loss and Waste Accounting and Reporting Standard (FLW Standard). It provides suggested methods for quantifying food loss and waste (FLW). \n\nInstructions: Answer all the questions below to the best of your ability by using the drop-down menus, then press the \"Get results\" button. This will take you to the Results Tab which ranks all the methods included in the FLW Standard (see Chapter 7).  You may need to click \"Enable macros\" when prompted by Excel in order to use this sheet. ",null,null,"Note: \n• The \"Methodology Tab\" explains how this ranking of methods was developed. \n• The recommendations provided do not take into account the availability of resources (e.g., budget, staff time). The tool does not consider which methods would work well in combination (see \"Methodology Tab\" for additional details).\n• We welcome your questions and suggestions. Please contact Brian Lipinski at BLipinski@wri.org."]
[]
[]
[null,"Questions",null,null,null,"Please select answers from drop-down menus"]
[]
[null,1,"How important is it to have a low level of uncertainty (high degree of accuracy in the FLW results)? Note: A higher degree of accuracy is recommended when monitoring targets.",null,null,null,{"$f":"IF(F8=\"\",\"Please provide answer to question 1\",\"\")","v":"Please provide answer to question 1"}]
[]
[null,2,"Is it necessary to determine the reasons why FLW is generated?",null,null,null,{"$f":"IF(F10=\"\",\"Please provide answer to question 2\",\"\")","v":"Please provide answer to question 2"}]
[]
[null,3,"Can you get direct access to the FLW being quantified?",null,null,null,{"$f":"IF(F12=\"\",\"Please provide answer to question 3\",\"\")","v":"Please provide answer to question 3"}]
[]
[null,4,"Is the FLW (whether packaged or not) mixed with other items or materials (e.g. soil, garden / yard waste, non-organic solid waste, etc.)?",null,null,null,{"$f":"IF(F14=\"\",\"Please provide answer to question 4\",\"\")","v":"Please provide answer to question 4"}]
[]
[null,5,"Is the FLW mainly liquid or solid?",null,null,null,{"$f":"IF(F16=\"\",\"Please provide answer to question 5\",\"\")","v":"Please provide answer to question 5"}]
[]
[null,6,"Does all, some, or no FLW go down the drain/sewer?",null,null,null,{"$f":"IF(F18=\"\",\"Please provide answer to question 6\",\"\")","v":"Please provide answer to question 6"}]
[]
[null,7,"Are inputs and outputs recorded that could be used for inferring the amount of FLW? (e.g. in a factory, the amount of ingredients entering the site and the amount of product leaving the site)",null,null,null,{"$f":"IF(F20=\"\",\"Please provide answer to question 7\",\"\")","v":"Please provide answer to question 7"}]
[]
[null,8,"Is there existing information that describes how FLW varies in response to other factors (e.g. with climate, soil conditions, crop / food type)?",null,null,null,{"$f":"IF(F22=\"\",\"Please provide answer to question 8\",\"\")","v":"Please provide answer to question 8"}]
[]
[null,9,"Do you have existing records that could be used for quantifying FLW? (For this purpose, records are individual pieces of data that have been written down or saved often for reasons other than quantifying FLW, e.g., waste transfer receipts or warehouse record books.)",null,null,null,{"$f":"IF(F24=\"\",\"Please provide answer to question 9\",\"\")","v":"Please provide answer to question 9"}]
[]
[null,10,"Do you have access to those records? (The response is automatically \"not applicable\" to this question if the answer is \"no\" or \"don't know\" to question 9.)",null,null,{"$f":"IF(OR($F$24=\"Yes\",$F$24=\"\"),\"\",\"Not applicable\")","v":""},{"$f":"IF(F26=\"\",\"Please provide answer to question 10\",\"\")","v":"Please provide answer to question 10"}]
[]
[null,11,"Is a material/significant amount of FLW in its packaging?",null,null,null,{"$f":"IF(F28=\"\",\"Please provide answer to question 11\",\"\")","v":"Please provide answer to question 11"}]
[null,null,null,null,null,null,{"$f":"IF(AND(G8=\"\",G10=\"\",G12=\"\",G14=\"\",G16=\"\",G18=\"\",G20=\"\",G22=\"\",G24=\"\",G26=\"\",G28=\"\"),\"\",\"Not all questions complete\")","v":"Not all questions complete"}]
[]
[]
[null,null,null,null,null,{"$f":"IF(OR($F$24=\"Yes\",$F$24=\"\"),\"\",\"Not applicable\")","v":""}]

{"sheet":"Results","index":1,"n_rows":16,"n_cols":25,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,15,3,16],[1,15,1,16]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Methods in green are recommended for further consideration, based on the responses given in the questionnaire. Those in orange may be appropriate in certain situations and those in red are not recommended. Further guidance in the FLW Standard can help you decide which method (or combination of methods) is appropriate. The scores in column R are out of 100 (see \"Methodology Tab\" for details). \nIf any words appear \"cut off\" in the table below, set the Zoom feature back to 100%.",null,null,"The comments include information on why a method is recommended or not for a given context. A user may revise its answers to the questions in light of these comments. Some considerations, such as budget and staff time, have not been accounted for in this tool. Therefore, the recommendations are based on the assumption that the required resources are available."]
[]
[null,"M1","M2","M3","M4","M5","M6","M7","M8","M9","M10","M11",null,null,"        Methods & Description","Methods & Description",null,"Score","Comments",null,"When this method is good","Why this method is not ideal","Why it's been rejected. ","If reasons needed"]
["Q1",{"$f":"INDEX('Background Rankings - Hide'!C4:C6,MATCH(Questionnaire!$F8,'Background Rankings - Hide'!$B4:$B6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!D4:D6,MATCH(Questionnaire!$F8,'Background Rankings - Hide'!$B4:$B6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!E4:E6,MATCH(Questionnaire!$F8,'Background Rankings - Hide'!$B4:$B6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!F4:F6,MATCH(Questionnaire!$F8,'Background Rankings - Hide'!$B4:$B6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!G4:G6,MATCH(Questionnaire!$F8,'Background Rankings - Hide'!$B4:$B6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!H4:H6,MATCH(Questionnaire!$F8,'Background Rankings - Hide'!$B4:$B6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!I4:I6,MATCH(Questionnaire!$F8,'Background Rankings - Hide'!$B4:$B6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!J4:J6,MATCH(Questionnaire!$F8,'Background Rankings - Hide'!$B4:$B6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!K4:K6,MATCH(Questionnaire!$F8,'Background Rankings - Hide'!$B4:$B6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!L4:L6,MATCH(Questionnaire!$F8,'Background Rankings - Hide'!$B4:$B6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!M4:M6,MATCH(Questionnaire!$F8,'Background Rankings - Hide'!$B4:$B6,0))","v":{"$error":"#N/A"}},null,null,"M6",{"$f":"\"\n\"&INDEX('Background Rankings - Hide'!$C$1:$M$1,MATCH(O5,'Background Rankings - Hide'!$C$2:$M$2,0))&\"\n\"","v":"\nDiaries\n"},"Maintaining a daily log of FLW and other information",{"$f":"PRODUCT(INDEX($B$5:$M$15,0,MATCH(O5,$B$4:$M$4,0)))*100","v":{"$error":"#N/A"}},{"$f":"CONCATENATE(IF(U5=\"\",\"\",U5),IF(V5=\"\",\"\",V5),IF(W5=\"\",\"\",W5),IF(X5=\"\",\"\",X5))","v":{"$error":"#N/A"}},null,{"$f":"IF(R5>0,INDEX('Messages - Hide'!$C$3:$M$3,MATCH(O5,'Messages - Hide'!$C$2:$M$2,0)),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(R5<100,IF(R5>0,CONCATENATE(IF(INDEX($B$5:$M$5,MATCH(O5,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$6:$M$6,MATCH(O5,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$6:$M$6,MATCH(O5,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$10:$M$10,MATCH(O5,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$7:$M$7,MATCH(O5,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$14:$M$14,MATCH(O5,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$8:$M$8,MATCH(O5,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$18:$M$18,MATCH(O5,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$9:$M$9,MATCH(O5,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$22:$M$22,MATCH(O5,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$10:$M$10,MATCH(O5,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$26:$M$26,MATCH(O5,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$11:$M$11,MATCH(O5,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$30:$M$30,MATCH(O5,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$12:$M$12,MATCH(O5,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$34:$M$34,MATCH(O5,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$13:$M$13,MATCH(O5,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$38:$M$38,MATCH(O5,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$14:$M$14,MATCH(O5,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$42:$M$42,MATCH(O5,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$15:$M$15,MATCH(O5,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$46:$M$46,MATCH(O5,'Messages - Hide'!$C$2:$M$2,0)),\"\"),\"\"),\"\"),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(R5=0,CONCATENATE(IF(INDEX($B$5:$M$5,MATCH(O5,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$7:$M$7,MATCH(O5,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$6:$M$6,MATCH(O5,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$11:$M$11,MATCH(O5,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$7:$M$7,MATCH(O5,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$15:$M$15,MATCH(O5,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$8:$M$8,MATCH(O5,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$19:$M$19,MATCH(O5,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$9:$M$9,MATCH(O5,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$23:$M$23,MATCH(O5,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$10:$M$10,MATCH(O5,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$27:$M$27,MATCH(O5,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$11:$M$11,MATCH(O5,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$31:$M$31,MATCH(O5,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$12:$M$12,MATCH(O5,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$35:$M$35,MATCH(O5,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$13:$M$13,MATCH(O5,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$39:$M$39,MATCH(O5,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$14:$M$14,MATCH(O5,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$43:$M$43,MATCH(O5,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$15:$M$15,MATCH(O5,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$47:$M$47,MATCH(O5,'Messages - Hide'!$C$2:$M$2,0)),\"\"),\"\"),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(AND(Questionnaire!$F$10=\"yes\",Results!O5<>\"M6\",R5>=90),\" Additional methods may be required to gather information on why FLW is generated, e.g., diaries, qualitative interviews, waste prevention audits (e.g. using site visits) or other methods.\",\"\")","v":{"$error":"#N/A"}},"\n"]
["Q2",{"$f":"INDEX('Background Rankings - Hide'!C9:C11,MATCH(Questionnaire!$F10,'Background Rankings - Hide'!$B9:$B11,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!D9:D11,MATCH(Questionnaire!$F10,'Background Rankings - Hide'!$B9:$B11,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!E9:E11,MATCH(Questionnaire!$F10,'Background Rankings - Hide'!$B9:$B11,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!F9:F11,MATCH(Questionnaire!$F10,'Background Rankings - Hide'!$B9:$B11,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!G9:G11,MATCH(Questionnaire!$F10,'Background Rankings - Hide'!$B9:$B11,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!H9:H11,MATCH(Questionnaire!$F10,'Background Rankings - Hide'!$B9:$B11,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!I9:I11,MATCH(Questionnaire!$F10,'Background Rankings - Hide'!$B9:$B11,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!J9:J11,MATCH(Questionnaire!$F10,'Background Rankings - Hide'!$B9:$B11,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!K9:K11,MATCH(Questionnaire!$F10,'Background Rankings - Hide'!$B9:$B11,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!L9:L11,MATCH(Questionnaire!$F10,'Background Rankings - Hide'!$B9:$B11,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!M9:M11,MATCH(Questionnaire!$F10,'Background Rankings - Hide'!$B9:$B11,0))","v":{"$error":"#N/A"}},null,null,"M8",{"$f":"\"\n\"&INDEX('Background Rankings - Hide'!$C$1:$M$1,MATCH(O6,'Background Rankings - Hide'!$C$2:$M$2,0))&\"\n\"","v":"\nMass balance\n"},"Measuring inputs (e.g., ingredients at a factory site, grain going into a silo) and outputs (e.g., products made, grain shipped to market) alongside changes in levels of stock and changes to the weight of food during processing",{"$f":"PRODUCT(INDEX($B$5:$M$15,0,MATCH(O6,$B$4:$M$4,0)))*100","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,{"$f":"IF(R6>0,INDEX('Messages - Hide'!$C$3:$M$3,MATCH(O6,'Messages - Hide'!$C$2:$M$2,0)),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(R6<100,IF(R6>0,CONCATENATE(IF(INDEX($B$5:$M$5,MATCH(O6,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$6:$M$6,MATCH(O6,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$6:$M$6,MATCH(O6,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$10:$M$10,MATCH(O6,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$7:$M$7,MATCH(O6,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$14:$M$14,MATCH(O6,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$8:$M$8,MATCH(O6,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$18:$M$18,MATCH(O6,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$9:$M$9,MATCH(O6,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$22:$M$22,MATCH(O6,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$10:$M$10,MATCH(O6,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$26:$M$26,MATCH(O6,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$11:$M$11,MATCH(O6,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$30:$M$30,MATCH(O6,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$12:$M$12,MATCH(O6,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$34:$M$34,MATCH(O6,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$13:$M$13,MATCH(O6,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$38:$M$38,MATCH(O6,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$14:$M$14,MATCH(O6,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$42:$M$42,MATCH(O6,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$15:$M$15,MATCH(O6,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$46:$M$46,MATCH(O6,'Messages - Hide'!$C$2:$M$2,0)),\"\"),\"\"),\"\"),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(R6=0,CONCATENATE(IF(INDEX($B$5:$M$5,MATCH(O6,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$7:$M$7,MATCH(O6,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$6:$M$6,MATCH(O6,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$11:$M$11,MATCH(O6,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$7:$M$7,MATCH(O6,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$15:$M$15,MATCH(O6,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$8:$M$8,MATCH(O6,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$19:$M$19,MATCH(O6,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$9:$M$9,MATCH(O6,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$23:$M$23,MATCH(O6,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$10:$M$10,MATCH(O6,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$27:$M$27,MATCH(O6,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$11:$M$11,MATCH(O6,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$31:$M$31,MATCH(O6,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$12:$M$12,MATCH(O6,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$35:$M$35,MATCH(O6,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$13:$M$13,MATCH(O6,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$39:$M$39,MATCH(O6,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$14:$M$14,MATCH(O6,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$43:$M$43,MATCH(O6,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$15:$M$15,MATCH(O6,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$47:$M$47,MATCH(O6,'Messages - Hide'!$C$2:$M$2,0)),\"\"),\"\"),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(AND(Questionnaire!$F$10=\"yes\",Results!O6<>\"M6\",R6>=90),\" Additional methods may be required to gather information on why FLW is generated, e.g., diaries, qualitative interviews, waste prevention audits (e.g. using site visits) or other methods.\",\"\")","v":{"$error":"#N/A"}},"\n"]
["Q3",{"$f":"INDEX('Background Rankings - Hide'!C14:C16,MATCH(Questionnaire!$F12,'Background Rankings - Hide'!$B14:$B16,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!D14:D16,MATCH(Questionnaire!$F12,'Background Rankings - Hide'!$B14:$B16,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!E14:E16,MATCH(Questionnaire!$F12,'Background Rankings - Hide'!$B14:$B16,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!F14:F16,MATCH(Questionnaire!$F12,'Background Rankings - Hide'!$B14:$B16,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!G14:G16,MATCH(Questionnaire!$F12,'Background Rankings - Hide'!$B14:$B16,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!H14:H16,MATCH(Questionnaire!$F12,'Background Rankings - Hide'!$B14:$B16,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!I14:I16,MATCH(Questionnaire!$F12,'Background Rankings - Hide'!$B14:$B16,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!J14:J16,MATCH(Questionnaire!$F12,'Background Rankings - Hide'!$B14:$B16,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!K14:K16,MATCH(Questionnaire!$F12,'Background Rankings - Hide'!$B14:$B16,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!L14:L16,MATCH(Questionnaire!$F12,'Background Rankings - Hide'!$B14:$B16,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!M14:M16,MATCH(Questionnaire!$F12,'Background Rankings - Hide'!$B14:$B16,0))","v":{"$error":"#N/A"}},null,null,"M7",{"$f":"\"\n\"&INDEX('Background Rankings - Hide'!$C$1:$M$1,MATCH(O7,'Background Rankings - Hide'!$C$2:$M$2,0))&\"\n\"","v":"\nSurveys\n"},"Gathering data on FLW quantities or other information (e.g., attitudes, beliefs, self-reported behaviors) from a large number of individuals or entities through a set of structured questions",{"$f":"PRODUCT(INDEX($B$5:$M$15,0,MATCH(O7,$B$4:$M$4,0)))*100","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,{"$f":"IF(R7>0,INDEX('Messages - Hide'!$C$3:$M$3,MATCH(O7,'Messages - Hide'!$C$2:$M$2,0)),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(R7<100,IF(R7>0,CONCATENATE(IF(INDEX($B$5:$M$5,MATCH(O7,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$6:$M$6,MATCH(O7,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$6:$M$6,MATCH(O7,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$10:$M$10,MATCH(O7,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$7:$M$7,MATCH(O7,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$14:$M$14,MATCH(O7,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$8:$M$8,MATCH(O7,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$18:$M$18,MATCH(O7,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$9:$M$9,MATCH(O7,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$22:$M$22,MATCH(O7,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$10:$M$10,MATCH(O7,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$26:$M$26,MATCH(O7,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$11:$M$11,MATCH(O7,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$30:$M$30,MATCH(O7,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$12:$M$12,MATCH(O7,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$34:$M$34,MATCH(O7,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$13:$M$13,MATCH(O7,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$38:$M$38,MATCH(O7,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$14:$M$14,MATCH(O7,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$42:$M$42,MATCH(O7,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$15:$M$15,MATCH(O7,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$46:$M$46,MATCH(O7,'Messages - Hide'!$C$2:$M$2,0)),\"\"),\"\"),\"\"),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(R7=0,CONCATENATE(IF(INDEX($B$5:$M$5,MATCH(O7,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$7:$M$7,MATCH(O7,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$6:$M$6,MATCH(O7,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$11:$M$11,MATCH(O7,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$7:$M$7,MATCH(O7,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$15:$M$15,MATCH(O7,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$8:$M$8,MATCH(O7,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$19:$M$19,MATCH(O7,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$9:$M$9,MATCH(O7,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$23:$M$23,MATCH(O7,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$10:$M$10,MATCH(O7,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$27:$M$27,MATCH(O7,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$11:$M$11,MATCH(O7,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$31:$M$31,MATCH(O7,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$12:$M$12,MATCH(O7,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$35:$M$35,MATCH(O7,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$13:$M$13,MATCH(O7,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$39:$M$39,MATCH(O7,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$14:$M$14,MATCH(O7,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$43:$M$43,MATCH(O7,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$15:$M$15,MATCH(O7,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$47:$M$47,MATCH(O7,'Messages - Hide'!$C$2:$M$2,0)),\"\"),\"\"),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(AND(Questionnaire!$F$10=\"yes\",Results!O7<>\"M6\",R7>=90),\" Additional methods may be required to gather information on why FLW is generated, e.g., diaries, qualitative interviews, waste prevention audits (e.g. using site visits) or other methods.\",\"\")","v":{"$error":"#N/A"}},"\n"]
["Q4",{"$f":"INDEX('Background Rankings - Hide'!C19:C21,MATCH(Questionnaire!$F14,'Background Rankings - Hide'!$B19:$B21,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!D19:D21,MATCH(Questionnaire!$F14,'Background Rankings - Hide'!$B19:$B21,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!E19:E21,MATCH(Questionnaire!$F14,'Background Rankings - Hide'!$B19:$B21,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!F19:F21,MATCH(Questionnaire!$F14,'Background Rankings - Hide'!$B19:$B21,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!G19:G21,MATCH(Questionnaire!$F14,'Background Rankings - Hide'!$B19:$B21,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!H19:H21,MATCH(Questionnaire!$F14,'Background Rankings - Hide'!$B19:$B21,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!I19:I21,MATCH(Questionnaire!$F14,'Background Rankings - Hide'!$B19:$B21,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!J19:J21,MATCH(Questionnaire!$F14,'Background Rankings - Hide'!$B19:$B21,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!K19:K21,MATCH(Questionnaire!$F14,'Background Rankings - Hide'!$B19:$B21,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!L19:L21,MATCH(Questionnaire!$F14,'Background Rankings - Hide'!$B19:$B21,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!M19:M21,MATCH(Questionnaire!$F14,'Background Rankings - Hide'!$B19:$B21,0))","v":{"$error":"#N/A"}},null,null,"M10",{"$f":"\"\n\"&INDEX('Background Rankings - Hide'!$C$1:$M$1,MATCH(O8,'Background Rankings - Hide'!$C$2:$M$2,0))&\"\n\"","v":"\nProxy data\n"},"Using FLW data that are outside the scope of an entity’s FLW inventory (e.g., older data, FLW data from another country or company) to infer quantities of FLW within the scope of the entity’s inventory",{"$f":"PRODUCT(INDEX($B$5:$M$15,0,MATCH(O8,$B$4:$M$4,0)))*100","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,{"$f":"IF(R8>0,INDEX('Messages - Hide'!$C$3:$M$3,MATCH(O8,'Messages - Hide'!$C$2:$M$2,0)),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(R8<100,IF(R8>0,CONCATENATE(IF(INDEX($B$5:$M$5,MATCH(O8,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$6:$M$6,MATCH(O8,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$6:$M$6,MATCH(O8,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$10:$M$10,MATCH(O8,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$7:$M$7,MATCH(O8,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$14:$M$14,MATCH(O8,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$8:$M$8,MATCH(O8,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$18:$M$18,MATCH(O8,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$9:$M$9,MATCH(O8,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$22:$M$22,MATCH(O8,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$10:$M$10,MATCH(O8,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$26:$M$26,MATCH(O8,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$11:$M$11,MATCH(O8,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$30:$M$30,MATCH(O8,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$12:$M$12,MATCH(O8,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$34:$M$34,MATCH(O8,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$13:$M$13,MATCH(O8,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$38:$M$38,MATCH(O8,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$14:$M$14,MATCH(O8,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$42:$M$42,MATCH(O8,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$15:$M$15,MATCH(O8,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$46:$M$46,MATCH(O8,'Messages - Hide'!$C$2:$M$2,0)),\"\"),\"\"),\"\"),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(R8=0,CONCATENATE(IF(INDEX($B$5:$M$5,MATCH(O8,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$7:$M$7,MATCH(O8,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$6:$M$6,MATCH(O8,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$11:$M$11,MATCH(O8,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$7:$M$7,MATCH(O8,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$15:$M$15,MATCH(O8,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$8:$M$8,MATCH(O8,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$19:$M$19,MATCH(O8,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$9:$M$9,MATCH(O8,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$23:$M$23,MATCH(O8,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$10:$M$10,MATCH(O8,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$27:$M$27,MATCH(O8,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$11:$M$11,MATCH(O8,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$31:$M$31,MATCH(O8,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$12:$M$12,MATCH(O8,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$35:$M$35,MATCH(O8,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$13:$M$13,MATCH(O8,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$39:$M$39,MATCH(O8,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$14:$M$14,MATCH(O8,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$43:$M$43,MATCH(O8,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$15:$M$15,MATCH(O8,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$47:$M$47,MATCH(O8,'Messages - Hide'!$C$2:$M$2,0)),\"\"),\"\"),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(AND(Questionnaire!$F$10=\"yes\",Results!O8<>\"M6\",R8>=90),\" Additional methods may be required to gather information on why FLW is generated, e.g., diaries, qualitative interviews, waste prevention audits (e.g. using site visits) or other methods.\",\"\")","v":{"$error":"#N/A"}},"\n"]
["Q5",{"$f":"INDEX('Background Rankings - Hide'!C24:C26,MATCH(Questionnaire!$F16,'Background Rankings - Hide'!$B24:$B26,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!D24:D26,MATCH(Questionnaire!$F16,'Background Rankings - Hide'!$B24:$B26,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!E24:E26,MATCH(Questionnaire!$F16,'Background Rankings - Hide'!$B24:$B26,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!F24:F26,MATCH(Questionnaire!$F16,'Background Rankings - Hide'!$B24:$B26,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!G24:G26,MATCH(Questionnaire!$F16,'Background Rankings - Hide'!$B24:$B26,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!H24:H26,MATCH(Questionnaire!$F16,'Background Rankings - Hide'!$B24:$B26,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!I24:I26,MATCH(Questionnaire!$F16,'Background Rankings - Hide'!$B24:$B26,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!J24:J26,MATCH(Questionnaire!$F16,'Background Rankings - Hide'!$B24:$B26,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!K24:K26,MATCH(Questionnaire!$F16,'Background Rankings - Hide'!$B24:$B26,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!L24:L26,MATCH(Questionnaire!$F16,'Background Rankings - Hide'!$B24:$B26,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!M24:M26,MATCH(Questionnaire!$F16,'Background Rankings - Hide'!$B24:$B26,0))","v":{"$error":"#N/A"}},null,null,"M1",{"$f":"\"\n\"&INDEX('Background Rankings - Hide'!$C$1:$M$1,MATCH(O9,'Background Rankings - Hide'!$C$2:$M$2,0))&\"\n\"","v":"\nRecords\n"},"Using individual pieces of data that have been written down or saved, and that are often routinely collected for reasons other than quantifying FLW (e.g., waste transfer receipts or warehouse record books)",{"$f":"PRODUCT(INDEX($B$5:$M$15,0,MATCH(O9,$B$4:$M$4,0)))*100","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,{"$f":"IF(R9>0,INDEX('Messages - Hide'!$C$3:$M$3,MATCH(O9,'Messages - Hide'!$C$2:$M$2,0)),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(R9<100,IF(R9>0,CONCATENATE(IF(INDEX($B$5:$M$5,MATCH(O9,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$6:$M$6,MATCH(O9,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$6:$M$6,MATCH(O9,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$10:$M$10,MATCH(O9,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$7:$M$7,MATCH(O9,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$14:$M$14,MATCH(O9,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$8:$M$8,MATCH(O9,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$18:$M$18,MATCH(O9,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$9:$M$9,MATCH(O9,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$22:$M$22,MATCH(O9,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$10:$M$10,MATCH(O9,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$26:$M$26,MATCH(O9,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$11:$M$11,MATCH(O9,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$30:$M$30,MATCH(O9,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$12:$M$12,MATCH(O9,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$34:$M$34,MATCH(O9,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$13:$M$13,MATCH(O9,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$38:$M$38,MATCH(O9,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$14:$M$14,MATCH(O9,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$42:$M$42,MATCH(O9,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$15:$M$15,MATCH(O9,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$46:$M$46,MATCH(O9,'Messages - Hide'!$C$2:$M$2,0)),\"\"),\"\"),\"\"),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(R9=0,CONCATENATE(IF(INDEX($B$5:$M$5,MATCH(O9,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$7:$M$7,MATCH(O9,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$6:$M$6,MATCH(O9,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$11:$M$11,MATCH(O9,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$7:$M$7,MATCH(O9,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$15:$M$15,MATCH(O9,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$8:$M$8,MATCH(O9,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$19:$M$19,MATCH(O9,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$9:$M$9,MATCH(O9,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$23:$M$23,MATCH(O9,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$10:$M$10,MATCH(O9,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$27:$M$27,MATCH(O9,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$11:$M$11,MATCH(O9,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$31:$M$31,MATCH(O9,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$12:$M$12,MATCH(O9,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$35:$M$35,MATCH(O9,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$13:$M$13,MATCH(O9,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$39:$M$39,MATCH(O9,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$14:$M$14,MATCH(O9,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$43:$M$43,MATCH(O9,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$15:$M$15,MATCH(O9,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$47:$M$47,MATCH(O9,'Messages - Hide'!$C$2:$M$2,0)),\"\"),\"\"),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(AND(Questionnaire!$F$10=\"yes\",Results!O9<>\"M6\",R9>=90),\" Additional methods may be required to gather information on why FLW is generated, e.g., diaries, qualitative interviews, waste prevention audits (e.g. using site visits) or other methods.\",\"\")","v":{"$error":"#N/A"}},"\n"]
["Q6",{"$f":"INDEX('Background Rankings - Hide'!C29:C31,MATCH(Questionnaire!$F18,'Background Rankings - Hide'!$B29:$B31,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!D29:D31,MATCH(Questionnaire!$F18,'Background Rankings - Hide'!$B29:$B31,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!E29:E31,MATCH(Questionnaire!$F18,'Background Rankings - Hide'!$B29:$B31,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!F29:F31,MATCH(Questionnaire!$F18,'Background Rankings - Hide'!$B29:$B31,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!G29:G31,MATCH(Questionnaire!$F18,'Background Rankings - Hide'!$B29:$B31,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!H29:H31,MATCH(Questionnaire!$F18,'Background Rankings - Hide'!$B29:$B31,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!I29:I31,MATCH(Questionnaire!$F18,'Background Rankings - Hide'!$B29:$B31,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!J29:J31,MATCH(Questionnaire!$F18,'Background Rankings - Hide'!$B29:$B31,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!K29:K31,MATCH(Questionnaire!$F18,'Background Rankings - Hide'!$B29:$B31,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!L29:L31,MATCH(Questionnaire!$F18,'Background Rankings - Hide'!$B29:$B31,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!M29:M31,MATCH(Questionnaire!$F18,'Background Rankings - Hide'!$B29:$B31,0))","v":{"$error":"#N/A"}},null,null,"M2",{"$f":"\"\n\"&INDEX('Background Rankings - Hide'!$C$1:$M$1,MATCH(O10,'Background Rankings - Hide'!$C$2:$M$2,0))&\"\n\"","v":"\nDirect weighing\n"},"Using a measuring device to determine the weight of FLW",{"$f":"PRODUCT(INDEX($B$5:$M$15,0,MATCH(O10,$B$4:$M$4,0)))*100","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,{"$f":"IF(R10>0,INDEX('Messages - Hide'!$C$3:$M$3,MATCH(O10,'Messages - Hide'!$C$2:$M$2,0)),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(R10<100,IF(R10>0,CONCATENATE(IF(INDEX($B$5:$M$5,MATCH(O10,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$6:$M$6,MATCH(O10,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$6:$M$6,MATCH(O10,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$10:$M$10,MATCH(O10,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$7:$M$7,MATCH(O10,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$14:$M$14,MATCH(O10,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$8:$M$8,MATCH(O10,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$18:$M$18,MATCH(O10,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$9:$M$9,MATCH(O10,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$22:$M$22,MATCH(O10,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$10:$M$10,MATCH(O10,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$26:$M$26,MATCH(O10,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$11:$M$11,MATCH(O10,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$30:$M$30,MATCH(O10,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$12:$M$12,MATCH(O10,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$34:$M$34,MATCH(O10,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$13:$M$13,MATCH(O10,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$38:$M$38,MATCH(O10,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$14:$M$14,MATCH(O10,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$42:$M$42,MATCH(O10,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$15:$M$15,MATCH(O10,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$46:$M$46,MATCH(O10,'Messages - Hide'!$C$2:$M$2,0)),\"\"),\"\"),\"\"),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(R10=0,CONCATENATE(IF(INDEX($B$5:$M$5,MATCH(O10,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$7:$M$7,MATCH(O10,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$6:$M$6,MATCH(O10,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$11:$M$11,MATCH(O10,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$7:$M$7,MATCH(O10,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$15:$M$15,MATCH(O10,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$8:$M$8,MATCH(O10,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$19:$M$19,MATCH(O10,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$9:$M$9,MATCH(O10,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$23:$M$23,MATCH(O10,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$10:$M$10,MATCH(O10,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$27:$M$27,MATCH(O10,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$11:$M$11,MATCH(O10,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$31:$M$31,MATCH(O10,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$12:$M$12,MATCH(O10,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$35:$M$35,MATCH(O10,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$13:$M$13,MATCH(O10,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$39:$M$39,MATCH(O10,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$14:$M$14,MATCH(O10,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$43:$M$43,MATCH(O10,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$15:$M$15,MATCH(O10,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$47:$M$47,MATCH(O10,'Messages - Hide'!$C$2:$M$2,0)),\"\"),\"\"),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(AND(Questionnaire!$F$10=\"yes\",Results!O10<>\"M6\",R10>=90),\" Additional methods may be required to gather information on why FLW is generated, e.g., diaries, qualitative interviews, waste prevention audits (e.g. using site visits) or other methods.\",\"\")","v":{"$error":"#N/A"}},"\n"]
["Q7",{"$f":"INDEX('Background Rankings - Hide'!C35:C37,MATCH(Questionnaire!$F20,'Background Rankings - Hide'!$B35:$B37,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!D35:D37,MATCH(Questionnaire!$F20,'Background Rankings - Hide'!$B35:$B37,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!E35:E37,MATCH(Questionnaire!$F20,'Background Rankings - Hide'!$B35:$B37,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!F35:F37,MATCH(Questionnaire!$F20,'Background Rankings - Hide'!$B35:$B37,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!G35:G37,MATCH(Questionnaire!$F20,'Background Rankings - Hide'!$B35:$B37,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!H35:H37,MATCH(Questionnaire!$F20,'Background Rankings - Hide'!$B35:$B37,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!I35:I37,MATCH(Questionnaire!$F20,'Background Rankings - Hide'!$B35:$B37,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!J35:J37,MATCH(Questionnaire!$F20,'Background Rankings - Hide'!$B35:$B37,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!K35:K37,MATCH(Questionnaire!$F20,'Background Rankings - Hide'!$B35:$B37,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!L35:L37,MATCH(Questionnaire!$F20,'Background Rankings - Hide'!$B35:$B37,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!M35:M37,MATCH(Questionnaire!$F20,'Background Rankings - Hide'!$B35:$B37,0))","v":{"$error":"#N/A"}},null,null,"M3",{"$f":"\"\n\"&INDEX('Background Rankings - Hide'!$C$1:$M$1,MATCH(O11,'Background Rankings - Hide'!$C$2:$M$2,0))&\"\n\"","v":"\nCounting\n"},"Assessing the number of items that make up FLW and using the result to determine the weight; includes using scanner data and “visual scales”",{"$f":"PRODUCT(INDEX($B$5:$M$15,0,MATCH(O11,$B$4:$M$4,0)))*100","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,{"$f":"IF(R11>0,INDEX('Messages - Hide'!$C$3:$M$3,MATCH(O11,'Messages - Hide'!$C$2:$M$2,0)),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(R11<100,IF(R11>0,CONCATENATE(IF(INDEX($B$5:$M$5,MATCH(O11,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$6:$M$6,MATCH(O11,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$6:$M$6,MATCH(O11,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$10:$M$10,MATCH(O11,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$7:$M$7,MATCH(O11,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$14:$M$14,MATCH(O11,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$8:$M$8,MATCH(O11,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$18:$M$18,MATCH(O11,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$9:$M$9,MATCH(O11,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$22:$M$22,MATCH(O11,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$10:$M$10,MATCH(O11,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$26:$M$26,MATCH(O11,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$11:$M$11,MATCH(O11,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$30:$M$30,MATCH(O11,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$12:$M$12,MATCH(O11,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$34:$M$34,MATCH(O11,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$13:$M$13,MATCH(O11,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$38:$M$38,MATCH(O11,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$14:$M$14,MATCH(O11,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$42:$M$42,MATCH(O11,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$15:$M$15,MATCH(O11,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$46:$M$46,MATCH(O11,'Messages - Hide'!$C$2:$M$2,0)),\"\"),\"\"),\"\"),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(R11=0,CONCATENATE(IF(INDEX($B$5:$M$5,MATCH(O11,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$7:$M$7,MATCH(O11,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$6:$M$6,MATCH(O11,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$11:$M$11,MATCH(O11,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$7:$M$7,MATCH(O11,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$15:$M$15,MATCH(O11,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$8:$M$8,MATCH(O11,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$19:$M$19,MATCH(O11,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$9:$M$9,MATCH(O11,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$23:$M$23,MATCH(O11,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$10:$M$10,MATCH(O11,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$27:$M$27,MATCH(O11,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$11:$M$11,MATCH(O11,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$31:$M$31,MATCH(O11,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$12:$M$12,MATCH(O11,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$35:$M$35,MATCH(O11,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$13:$M$13,MATCH(O11,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$39:$M$39,MATCH(O11,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$14:$M$14,MATCH(O11,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$43:$M$43,MATCH(O11,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$15:$M$15,MATCH(O11,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$47:$M$47,MATCH(O11,'Messages - Hide'!$C$2:$M$2,0)),\"\"),\"\"),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(AND(Questionnaire!$F$10=\"yes\",Results!O11<>\"M6\",R11>=90),\" Additional methods may be required to gather information on why FLW is generated, e.g., diaries, qualitative interviews, waste prevention audits (e.g. using site visits) or other methods.\",\"\")","v":{"$error":"#N/A"}},"\n"]
["Q8",{"$f":"INDEX('Background Rankings - Hide'!C40:C42,MATCH(Questionnaire!$F22,'Background Rankings - Hide'!$B40:$B42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!D40:D42,MATCH(Questionnaire!$F22,'Background Rankings - Hide'!$B40:$B42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!E40:E42,MATCH(Questionnaire!$F22,'Background Rankings - Hide'!$B40:$B42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!F40:F42,MATCH(Questionnaire!$F22,'Background Rankings - Hide'!$B40:$B42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!G40:G42,MATCH(Questionnaire!$F22,'Background Rankings - Hide'!$B40:$B42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!H40:H42,MATCH(Questionnaire!$F22,'Background Rankings - Hide'!$B40:$B42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!I40:I42,MATCH(Questionnaire!$F22,'Background Rankings - Hide'!$B40:$B42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!J40:J42,MATCH(Questionnaire!$F22,'Background Rankings - Hide'!$B40:$B42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!K40:K42,MATCH(Questionnaire!$F22,'Background Rankings - Hide'!$B40:$B42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!L40:L42,MATCH(Questionnaire!$F22,'Background Rankings - Hide'!$B40:$B42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!M40:M42,MATCH(Questionnaire!$F22,'Background Rankings - Hide'!$B40:$B42,0))","v":{"$error":"#N/A"}},null,null,"M5",{"$f":"\"\n\"&INDEX('Background Rankings - Hide'!$C$1:$M$1,MATCH(O12,'Background Rankings - Hide'!$C$2:$M$2,0))&\"\n\"","v":"\nWaste composition analysis\n"},"Physically separating FLW from other material in order to determine its weight and composition; a WCA may also be referred to as a “waste characterization study,” or “waste sort”",{"$f":"PRODUCT(INDEX($B$5:$M$15,0,MATCH(O12,$B$4:$M$4,0)))*100","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,{"$f":"IF(R12>0,INDEX('Messages - Hide'!$C$3:$M$3,MATCH(O12,'Messages - Hide'!$C$2:$M$2,0)),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(R12<100,IF(R12>0,CONCATENATE(IF(INDEX($B$5:$M$5,MATCH(O12,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$6:$M$6,MATCH(O12,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$6:$M$6,MATCH(O12,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$10:$M$10,MATCH(O12,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$7:$M$7,MATCH(O12,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$14:$M$14,MATCH(O12,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$8:$M$8,MATCH(O12,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$18:$M$18,MATCH(O12,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$9:$M$9,MATCH(O12,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$22:$M$22,MATCH(O12,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$10:$M$10,MATCH(O12,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$26:$M$26,MATCH(O12,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$11:$M$11,MATCH(O12,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$30:$M$30,MATCH(O12,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$12:$M$12,MATCH(O12,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$34:$M$34,MATCH(O12,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$13:$M$13,MATCH(O12,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$38:$M$38,MATCH(O12,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$14:$M$14,MATCH(O12,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$42:$M$42,MATCH(O12,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$15:$M$15,MATCH(O12,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$46:$M$46,MATCH(O12,'Messages - Hide'!$C$2:$M$2,0)),\"\"),\"\"),\"\"),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(R12=0,CONCATENATE(IF(INDEX($B$5:$M$5,MATCH(O12,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$7:$M$7,MATCH(O12,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$6:$M$6,MATCH(O12,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$11:$M$11,MATCH(O12,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$7:$M$7,MATCH(O12,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$15:$M$15,MATCH(O12,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$8:$M$8,MATCH(O12,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$19:$M$19,MATCH(O12,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$9:$M$9,MATCH(O12,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$23:$M$23,MATCH(O12,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$10:$M$10,MATCH(O12,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$27:$M$27,MATCH(O12,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$11:$M$11,MATCH(O12,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$31:$M$31,MATCH(O12,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$12:$M$12,MATCH(O12,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$35:$M$35,MATCH(O12,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$13:$M$13,MATCH(O12,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$39:$M$39,MATCH(O12,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$14:$M$14,MATCH(O12,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$43:$M$43,MATCH(O12,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$15:$M$15,MATCH(O12,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$47:$M$47,MATCH(O12,'Messages - Hide'!$C$2:$M$2,0)),\"\"),\"\"),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(AND(Questionnaire!$F$10=\"yes\",Results!O12<>\"M6\",R12>=90),\" Additional methods may be required to gather information on why FLW is generated, e.g., diaries, qualitative interviews, waste prevention audits (e.g. using site visits) or other methods.\",\"\")","v":{"$error":"#N/A"}},"\n"]
["Q9",{"$f":"INDEX('Background Rankings - Hide'!C45:C47,MATCH(Questionnaire!$F24,'Background Rankings - Hide'!$B45:$B47,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!D45:D47,MATCH(Questionnaire!$F24,'Background Rankings - Hide'!$B45:$B47,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!E45:E47,MATCH(Questionnaire!$F24,'Background Rankings - Hide'!$B45:$B47,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!F45:F47,MATCH(Questionnaire!$F24,'Background Rankings - Hide'!$B45:$B47,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!G45:G47,MATCH(Questionnaire!$F24,'Background Rankings - Hide'!$B45:$B47,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!H45:H47,MATCH(Questionnaire!$F24,'Background Rankings - Hide'!$B45:$B47,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!I45:I47,MATCH(Questionnaire!$F24,'Background Rankings - Hide'!$B45:$B47,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!J45:J47,MATCH(Questionnaire!$F24,'Background Rankings - Hide'!$B45:$B47,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!K45:K47,MATCH(Questionnaire!$F24,'Background Rankings - Hide'!$B45:$B47,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!L45:L47,MATCH(Questionnaire!$F24,'Background Rankings - Hide'!$B45:$B47,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!M45:M47,MATCH(Questionnaire!$F24,'Background Rankings - Hide'!$B45:$B47,0))","v":{"$error":"#N/A"}},null,null,"M4",{"$f":"\"\n\"&INDEX('Background Rankings - Hide'!$C$1:$M$1,MATCH(O13,'Background Rankings - Hide'!$C$2:$M$2,0))&\"\n\"","v":"\nAssessing volume\n"},"Assessing the physical space occupied by FLW, and using the result to determine the weight",{"$f":"PRODUCT(INDEX($B$5:$M$15,0,MATCH(O13,$B$4:$M$4,0)))*100","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,{"$f":"IF(R13>0,INDEX('Messages - Hide'!$C$3:$M$3,MATCH(O13,'Messages - Hide'!$C$2:$M$2,0)),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(R13<100,IF(R13>0,CONCATENATE(IF(INDEX($B$5:$M$5,MATCH(O13,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$6:$M$6,MATCH(O13,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$6:$M$6,MATCH(O13,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$10:$M$10,MATCH(O13,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$7:$M$7,MATCH(O13,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$14:$M$14,MATCH(O13,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$8:$M$8,MATCH(O13,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$18:$M$18,MATCH(O13,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$9:$M$9,MATCH(O13,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$22:$M$22,MATCH(O13,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$10:$M$10,MATCH(O13,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$26:$M$26,MATCH(O13,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$11:$M$11,MATCH(O13,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$30:$M$30,MATCH(O13,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$12:$M$12,MATCH(O13,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$34:$M$34,MATCH(O13,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$13:$M$13,MATCH(O13,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$38:$M$38,MATCH(O13,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$14:$M$14,MATCH(O13,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$42:$M$42,MATCH(O13,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$15:$M$15,MATCH(O13,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$46:$M$46,MATCH(O13,'Messages - Hide'!$C$2:$M$2,0)),\"\"),\"\"),\"\"),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(R13=0,CONCATENATE(IF(INDEX($B$5:$M$5,MATCH(O13,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$7:$M$7,MATCH(O13,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$6:$M$6,MATCH(O13,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$11:$M$11,MATCH(O13,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$7:$M$7,MATCH(O13,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$15:$M$15,MATCH(O13,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$8:$M$8,MATCH(O13,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$19:$M$19,MATCH(O13,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$9:$M$9,MATCH(O13,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$23:$M$23,MATCH(O13,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$10:$M$10,MATCH(O13,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$27:$M$27,MATCH(O13,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$11:$M$11,MATCH(O13,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$31:$M$31,MATCH(O13,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$12:$M$12,MATCH(O13,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$35:$M$35,MATCH(O13,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$13:$M$13,MATCH(O13,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$39:$M$39,MATCH(O13,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$14:$M$14,MATCH(O13,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$43:$M$43,MATCH(O13,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$15:$M$15,MATCH(O13,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$47:$M$47,MATCH(O13,'Messages - Hide'!$C$2:$M$2,0)),\"\"),\"\"),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(AND(Questionnaire!$F$10=\"yes\",Results!O13<>\"M6\",R13>=90),\" Additional methods may be required to gather information on why FLW is generated, e.g., diaries, qualitative interviews, waste prevention audits (e.g. using site visits) or other methods.\",\"\")","v":{"$error":"#N/A"}},"\n"]
["Q10",{"$f":"INDEX('Background Rankings - Hide'!C50:C52,MATCH(Questionnaire!$F26,'Background Rankings - Hide'!$B50:$B52,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!D50:D52,MATCH(Questionnaire!$F26,'Background Rankings - Hide'!$B50:$B52,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!E50:E52,MATCH(Questionnaire!$F26,'Background Rankings - Hide'!$B50:$B52,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!F50:F52,MATCH(Questionnaire!$F26,'Background Rankings - Hide'!$B50:$B52,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!G50:G52,MATCH(Questionnaire!$F26,'Background Rankings - Hide'!$B50:$B52,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!H50:H52,MATCH(Questionnaire!$F26,'Background Rankings - Hide'!$B50:$B52,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!I50:I52,MATCH(Questionnaire!$F26,'Background Rankings - Hide'!$B50:$B52,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!J50:J52,MATCH(Questionnaire!$F26,'Background Rankings - Hide'!$B50:$B52,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!K50:K52,MATCH(Questionnaire!$F26,'Background Rankings - Hide'!$B50:$B52,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!L50:L52,MATCH(Questionnaire!$F26,'Background Rankings - Hide'!$B50:$B52,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!M50:M52,MATCH(Questionnaire!$F26,'Background Rankings - Hide'!$B50:$B52,0))","v":{"$error":"#N/A"}},null,null,"M9",{"$f":"\"\n\"&INDEX('Background Rankings - Hide'!$C$1:$M$1,MATCH(O14,'Background Rankings - Hide'!$C$2:$M$2,0))&\"\n\"","v":"\nModeling\n"},"Using a mathematical approach based on the interaction of multiple factors that influence the generation of FLW",{"$f":"PRODUCT(INDEX($B$5:$M$15,0,MATCH(O14,$B$4:$M$4,0)))*100","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,{"$f":"IF(R14>0,INDEX('Messages - Hide'!$C$3:$M$3,MATCH(O14,'Messages - Hide'!$C$2:$M$2,0)),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(R14<100,IF(R14>0,CONCATENATE(IF(INDEX($B$5:$M$5,MATCH(O14,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$6:$M$6,MATCH(O14,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$6:$M$6,MATCH(O14,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$10:$M$10,MATCH(O14,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$7:$M$7,MATCH(O14,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$14:$M$14,MATCH(O14,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$8:$M$8,MATCH(O14,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$18:$M$18,MATCH(O14,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$9:$M$9,MATCH(O14,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$22:$M$22,MATCH(O14,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$10:$M$10,MATCH(O14,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$26:$M$26,MATCH(O14,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$11:$M$11,MATCH(O14,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$30:$M$30,MATCH(O14,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$12:$M$12,MATCH(O14,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$34:$M$34,MATCH(O14,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$13:$M$13,MATCH(O14,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$38:$M$38,MATCH(O14,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$14:$M$14,MATCH(O14,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$42:$M$42,MATCH(O14,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$15:$M$15,MATCH(O14,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$46:$M$46,MATCH(O14,'Messages - Hide'!$C$2:$M$2,0)),\"\"),\"\"),\"\"),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(R14=0,CONCATENATE(IF(INDEX($B$5:$M$5,MATCH(O14,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$7:$M$7,MATCH(O14,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$6:$M$6,MATCH(O14,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$11:$M$11,MATCH(O14,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$7:$M$7,MATCH(O14,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$15:$M$15,MATCH(O14,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$8:$M$8,MATCH(O14,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$19:$M$19,MATCH(O14,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$9:$M$9,MATCH(O14,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$23:$M$23,MATCH(O14,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$10:$M$10,MATCH(O14,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$27:$M$27,MATCH(O14,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$11:$M$11,MATCH(O14,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$31:$M$31,MATCH(O14,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$12:$M$12,MATCH(O14,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$35:$M$35,MATCH(O14,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$13:$M$13,MATCH(O14,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$39:$M$39,MATCH(O14,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$14:$M$14,MATCH(O14,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$43:$M$43,MATCH(O14,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$15:$M$15,MATCH(O14,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$47:$M$47,MATCH(O14,'Messages - Hide'!$C$2:$M$2,0)),\"\"),\"\"),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(AND(Questionnaire!$F$10=\"yes\",Results!O14<>\"M6\",R14>=90),\" Additional methods may be required to gather information on why FLW is generated, e.g., diaries, qualitative interviews, waste prevention audits (e.g. using site visits) or other methods.\",\"\")","v":{"$error":"#N/A"}},"\n"]
["Q11",{"$f":"INDEX('Background Rankings - Hide'!C55:C57,MATCH(Questionnaire!$F28,'Background Rankings - Hide'!$B55:$B57,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!D55:D57,MATCH(Questionnaire!$F28,'Background Rankings - Hide'!$B55:$B57,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!E55:E57,MATCH(Questionnaire!$F28,'Background Rankings - Hide'!$B55:$B57,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!F55:F57,MATCH(Questionnaire!$F28,'Background Rankings - Hide'!$B55:$B57,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!G55:G57,MATCH(Questionnaire!$F28,'Background Rankings - Hide'!$B55:$B57,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!H55:H57,MATCH(Questionnaire!$F28,'Background Rankings - Hide'!$B55:$B57,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!I55:I57,MATCH(Questionnaire!$F28,'Background Rankings - Hide'!$B55:$B57,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!J55:J57,MATCH(Questionnaire!$F28,'Background Rankings - Hide'!$B55:$B57,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!K55:K57,MATCH(Questionnaire!$F28,'Background Rankings - Hide'!$B55:$B57,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!L55:L57,MATCH(Questionnaire!$F28,'Background Rankings - Hide'!$B55:$B57,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Background Rankings - Hide'!M55:M57,MATCH(Questionnaire!$F28,'Background Rankings - Hide'!$B55:$B57,0))","v":{"$error":"#N/A"}},null,null,"M11",{"$f":"\"\n\"&INDEX('Background Rankings - Hide'!$C$1:$M$1,MATCH(O15,'Background Rankings - Hide'!$C$2:$M$2,0))&\"\n\"","v":"\nAssessing volume using COD measurements\n"},"Using measurements of chemical oxygen demand to obtain an approximate quantification of FLW in liquid waste streams (e.g., material going to the sewer)",{"$f":"PRODUCT(INDEX($B$5:$M$15,0,MATCH(O15,$B$4:$M$4,0)))*100","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,{"$f":"IF(R15>0,INDEX('Messages - Hide'!$C$3:$M$3,MATCH(O15,'Messages - Hide'!$C$2:$M$2,0)),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(R15<100,IF(R15>0,CONCATENATE(IF(INDEX($B$5:$M$5,MATCH(O15,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$6:$M$6,MATCH(O15,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$6:$M$6,MATCH(O15,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$10:$M$10,MATCH(O15,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$7:$M$7,MATCH(O15,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$14:$M$14,MATCH(O15,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$8:$M$8,MATCH(O15,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$18:$M$18,MATCH(O15,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$9:$M$9,MATCH(O15,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$22:$M$22,MATCH(O15,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$10:$M$10,MATCH(O15,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$26:$M$26,MATCH(O15,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$11:$M$11,MATCH(O15,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$30:$M$30,MATCH(O15,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$12:$M$12,MATCH(O15,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$34:$M$34,MATCH(O15,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$13:$M$13,MATCH(O15,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$38:$M$38,MATCH(O15,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$14:$M$14,MATCH(O15,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$42:$M$42,MATCH(O15,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$15:$M$15,MATCH(O15,$B$4:$M$4,0))<1,INDEX('Messages - Hide'!$C$46:$M$46,MATCH(O15,'Messages - Hide'!$C$2:$M$2,0)),\"\"),\"\"),\"\"),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(R15=0,CONCATENATE(IF(INDEX($B$5:$M$5,MATCH(O15,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$7:$M$7,MATCH(O15,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$6:$M$6,MATCH(O15,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$11:$M$11,MATCH(O15,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$7:$M$7,MATCH(O15,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$15:$M$15,MATCH(O15,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$8:$M$8,MATCH(O15,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$19:$M$19,MATCH(O15,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$9:$M$9,MATCH(O15,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$23:$M$23,MATCH(O15,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$10:$M$10,MATCH(O15,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$27:$M$27,MATCH(O15,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$11:$M$11,MATCH(O15,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$31:$M$31,MATCH(O15,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$12:$M$12,MATCH(O15,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$35:$M$35,MATCH(O15,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$13:$M$13,MATCH(O15,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$39:$M$39,MATCH(O15,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$14:$M$14,MATCH(O15,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$43:$M$43,MATCH(O15,'Messages - Hide'!$C$2:$M$2,0)),\"\"),IF(INDEX($B$15:$M$15,MATCH(O15,$B$4:$M$4,0))=0,INDEX('Messages - Hide'!$C$47:$M$47,MATCH(O15,'Messages - Hide'!$C$2:$M$2,0)),\"\"),\"\"),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(AND(Questionnaire!$F$10=\"yes\",Results!O15<>\"M6\",R15>=90),\" Additional methods may be required to gather information on why FLW is generated, e.g., diaries, qualitative interviews, waste prevention audits (e.g. using site visits) or other methods.\",\"\")","v":{"$error":"#N/A"}},"\n"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\n"]

{"sheet":"Background Rankings - Hide","index":2,"n_rows":57,"n_cols":13,"rows_kept":57,"cut":false,"hidden":true,"merged":[]}
[null,null,"Records","Direct weighing","Counting","Assessing volume","Waste composition analysis","Diaries","Surveys","Mass balance","Modeling","Proxy data","Assessing volume using COD measurements"]
[null,null,"M1","M2","M3","M4","M5","M6","M7","M8","M9","M10","M11"]
["Q1","How important is it to have a low level of uncertainty (high degree of accuracy in the FLW results)? Note: A higher degree of accuracy is recommended when monitoring targets."]
["A1","Very important (e.g., setting/monitoring targets)",1,1,1,1,1,0.5,0.25,0.9,0.2,0,0.75]
["A2","Moderately important (e.g., seeking general understanding of FLW amounts)",1,1,1,1,1,1,0.5,1,0.85,0.5,1]
["A3","Don't know",1,1,1,1,1,1,1,1,1,1,1]
[]
["Q2","Is it necessary to determine the reasons why FLW is generated?"]
["A1","Yes",1,1,1,1,1,1,1,1,1,1,1]
["A2","No",1,1,1,1,1,1,1,1,1,1,1]
["A3","Don't know",1,1,1,1,1,1,1,1,1,1,1]
[]
["Q3","Can you get direct access to the FLW being quantified?"]
["A1","Yes",1,1,1,1,1,1,1,1,1,1,1]
["A2","No",1,0,0,0,0,1,1,1,1,1,0]
["A3","Don't know",1,1,1,1,1,1,1,1,1,1,1]
[]
["Q4","Is the FLW (whether packaged or not) mixed with other items or materials (e.g. soil, garden / yard waste, non-organic solid waste, etc.)?"]
["A1","Yes, FLW mixed with other material",1,0,0,0,1,1,1,1,1,1,0.5]
["A2","No, FLW is separate",1,1,1,1,0.9,1,1,1,1,1,1]
["A3","Don't know",1,1,1,1,1,1,1,1,1,1,1]
[]
["Q5","Is the FLW mainly liquid or solid?"]
["A1","Mainly liquid",1,0.5,0.5,1,0.2,1,1,1,1,1,1]
["A2","Mainly solid",1,1,1,0.25,1,1,1,1,1,1,0]
["A3","Mixed liquid and solid",1,1,1,1,1,1,1,1,1,1,0.8]
[]
["Q6","Does all, some, or no FLW go down the drain/sewer?"]
["A1","All",1,0,0,1,0,1,1,1,1,1,1]
["A2","None",1,1,1,1,1,1,1,1,1,1,0]
["A3","Some",1,1,1,1,1,1,1,1,1,1,1]
[]
[]
["Q7","Are inputs and outputs recorded that could be used for inferring the amount FLW? (e.g. in a factory, the amount of ingredients entering the site and the amount of product leaving the site)"]
["A1","Yes",1,1,1,1,1,1,1,1,1,1,1]
["A2","No",1,1,1,1,1,1,1,0,1,1,1]
["A3","Not applicable",1,1,1,1,1,1,1,0,1,1,1]
[]
["Q8","Is there existing information that describes how FLW varies in response to other factors (e.g. with climate, soil conditions, crop / food type)?"]
["A1","Yes",1,1,1,1,1,1,1,1,1,1,1]
["A2","No",1,1,1,1,1,1,1,1,0,0.5,1]
["A3","Not applicable",1,1,1,1,1,1,1,1,0,0,1]
[]
["Q9",{"$f":"Questionnaire!C24","v":"Do you have existing records that could be used for quantifying FLW? (For this purpose, records are individual pieces of data that have been written down or saved often for reasons other than quantifying FLW, e.g., waste transfer receipts or warehouse record books.)"}]
["A1","Yes",1,1,1,1,1,1,1,1,1,1,1]
["A2","No",0,1,1,1,1,1,1,1,1,1,1]
["A3","Don't know",1,1,1,1,1,1,1,1,1,1,1]
[]
["Q10","Do you have access to those records?"]
["A1","Yes",1,1,1,1,1,1,1,1,1,1,1]
["A2","No",0,1,1,1,1,1,1,1,1,1,1]
["A3","Not applicable",1,1,1,1,1,1,1,1,1,1,1]
[]
["Q11","Is a material/significant amount of FLW in its packaging?"]
["A1","Yes",1,1,1,1,1,1,1,1,1,1,0.2]
["A2","No",1,1,0.9,1,1,1,1,1,1,1,1]
["A3","Don't know",1,1,1,1,1,1,1,1,1,1,1]

{"sheet":"Messages - Hide","index":3,"n_rows":47,"n_cols":13,"rows_kept":47,"cut":false,"hidden":true,"merged":[[28,1,28,11],[32,1,32,11],[20,1,20,11],[8,1,8,11],[12,1,12,11],[16,1,16,11],[24,1,24,11]]}
[null,null,"Records","Direct weighing","Counting","Assessing volume","Waste composition analysis","Diaries","Surveys","Mass balance","Modeling","Proxy data","Assessing volume using COD measurements"]
[null,null,"M1","M2","M3","M4","M5","M6","M7","M8","M9","M10","M11"]
[null,100," This is a good method where records of FLW exist and the user has assess to them. The user needs to understand what has been measured and how it has been measured. It is important that the quality of these records is sufficiently high. ","This is a good method for FLW that is separated from other materials and is in a solid form. If instigating a new quantification based on direct weighing, consideration should be given to how to sample effectively. "," This is a good method where FLW is found in discrete units (e.g., items, bags) and can be quantified by manual counting, with scanning devices, or by using visual scales. If instigating a new quantification based on counting, consideration should be given to how to sample effectively. "," This is a good method for liquid FLW (e.g., drinks, sauces). If instigating a new quantification based on assessing volume, consideration should be given to how to sample effectively. "," This is a good method for solid FLW that is mixed with other materials. Waste compositional analysis can be relatively expensive."," This is a good method where insights are needed about behaviors linked to amounts and types of food. However, FLW data collected through diaries are likely to be less accurate than FLW data collected using weight-based methods. This is because quantities are most frequently captured through approximation rather than measurement, and where measurement is used, it is carried out by non-experts which may lead to inaccuracies. FLW may also be under-reported by diarists. "," This is a good method for gathering data on FLW quantities or other information (e.g., attitudes, beliefs, self-reported behaviors) from a large number of individuals or entities through a set of structured questions."," This is a good method for estimating FLW where inputs and outputs to a process or production site are accurately quantified. Furthermore, knowledge of changes in mass (e.g., evaporation of water during cooking) need to be well understood. "," This is a good method for obtaining an approximate quantification of FLW where relationships between causal factors and FLW are well described. "," This is a good method for obtaining an approximate quantification of FLW where direct measurement of FLW is not possible. It relies on proxies (e.g., data from similar countries / companies) to be available.  "," This is a good method for obtaining an approximate quantification of FLW in liquid waste streams (e.g., material going to the sewer). "]
[]
["Q1",{"$f":"Questionnaire!C8","v":"How important is it to have a low level of uncertainty (high degree of accuracy in the FLW results)? Note: A higher degree of accuracy is recommended when monitoring targets."}]
[null,"<1, >0",null,null,null,null,null," This is not an effective method for monitoring targets, as there are moderate biases in the estimates. "," This is not an effective method for monitoring targets as it is subject to biases."," As the FLW is not being measured directly, mass balance is usually (but not always) less accurate than methods in which FLW is measured. This method may produce highly accurate results if an entity uses very accurate input and output data and also understands well the relationship between the input (e.g., amount of ingredients) required to produce the output (e.g., manufacture of a certain amount of product)."," This is not an effective method for monitoring targets, unless there is an on-going program to understand how the relationships between factors and FLW are changing over time. "," This is not an effective method for monitoring targets as information comes from outside the target scope (e.g., another company, another country, another time). "," COD measurements are influenced by other material in the wastewater stream (e.g., cleaning material, soil), which need to be accounted for in the associated calculations. "]
[null,0,null,null,null,null,null,null,null,null,null," This is not an appropriate method for monitoring targets."]
[]
["Q2",{"$f":"Questionnaire!C10","v":"Is it necessary to determine the reasons why FLW is generated?"}]
[null,"<1, >0"]
[null,0]
[]
["Q3",{"$f":"Questionnaire!C12","v":"Can you get direct access to the FLW being quantified?"}]
[null,"<1, >0"]
[null,0,null," This method requires access to the FLW to be measured."," This method requires access to the FLW to be measured."," This method requires access to the FLW to be measured."," This method requires access to the FLW to be measured.",null,null,null,null,null," This method requires access to the FLW to be measured."]
[]
["Q4",{"$f":"Questionnaire!C14","v":"Is the FLW (whether packaged or not) mixed with other items or materials (e.g. soil, garden / yard waste, non-organic solid waste, etc.)?"}]
[null,"<1, >0",null,null,null,null," If FLW is already separated from other material, an entity may nonetheless elect to use a waste composition analysis to understand the different components that make up FLW (e.g., type of food categories, amount of FLW that is food versus associated inedible parts).",null,null,null,null,null," This method is not as effective if analysing waste water containing materials other than FLW (e.g., soil, cleaning materials)."]
[null,0,null," This method requires FLW to be separated from other materials. If it is mixed, other methods (e.g., waste composition analysis) may be more appropriate. "," This method requires FLW to be separated from other materials. If it is mixed, other methods (e.g., waste composition analysis) may be more appropriate. "," This method requires FLW to be separated."]
[]
["Q5",{"$f":"Questionnaire!C16","v":"Is the FLW mainly liquid or solid?"}]
[null,"<1, >0",null," This is not usually an effective method for measuring liquid FLW."," This is not usually an effective method for measuring liquid FLW (unless packaged)."," This is not usually an effective method for measuring solid FLW."," This is not usually an effective method for measuring liquid FLW (unless packaged). "]
[null,0,null,null,null,null,null,null,null,null,null,null," This method is only applicable to situations in which the FLW is dissolved or suspended in a liquid."]
[]
["Q6",{"$f":"Questionnaire!C18","v":"Does all, some, or no FLW go down the drain/sewer?"}]
[null,"<1, >0"]
[null,0,null," This method usually can't be used where FLW goes down the drain/sewer."," This method usually can't be used where FLW goes down the drain/sewer.",null," This method usually can't be used where FLW goes down the drain/sewer."]
[]
["Q7",{"$f":"Questionnaire!C20","v":"Are inputs and outputs recorded that could be used for inferring the amount of FLW? (e.g. in a factory, the amount of ingredients entering the site and the amount of product leaving the site)"}]
[null,"<1, >0"]
[null,0,null,null,null,null,null,null,null," This method requires data on inputs and outputs for relevant sites to perform the mass balance."]
[]
["Q8",{"$f":"Questionnaire!C22","v":"Is there existing information that describes how FLW varies in response to other factors (e.g. with climate, soil conditions, crop / food type)?"}]
[null,"<1, >0",null,null,null,null,null,null,null,null,null," This is not an effective method if there is not pre-existing information on how FLW varies with other factors, as this information is useful in understanding what proxy data is appropriate to use. "]
[null,0,null,null,null,null,null,null,null,null," This method requires information on how FLW varies with other factors."," This is not an effective method if there is not pre-existing information on how FLW varies with other factors, as this information is useful in understanding what proxy data is appropriate to use. "]
[]
["Q9",{"$f":"Questionnaire!C24","v":"Do you have existing records that could be used for quantifying FLW? (For this purpose, records are individual pieces of data that have been written down or saved often for reasons other than quantifying FLW, e.g., waste transfer receipts or warehouse record books.)"}]
[null,"<1, >0"]
[null,0," If records do not already exist, then they cannot be used and some other quantification method will need to be deployed. "]
[]
["Q10",{"$f":"Questionnaire!C26","v":"Do you have access to those records? (The response is automatically \"not applicable\" to this question if the answer is \"no\" or \"don't know\" to question 9.)"}]
[null,"<1, >0"]
[null,0,"Access to records is required to use them. It may be worth exploring the barriers to accessing the records. "]
[]
["Q11",{"$f":"Questionnaire!C28","v":"Is a material/significant amount of FLW in its packaging?"}]
[null,"<1, >0",null,null," Scanning requires bar codes or other readable identifiers to be present, usually (but not always) on the packaging. ",null,null,null,null,null,null,null," COD measurements are usually undertaken on unpackaged FLW. "]
[null,0]

{"sheet":"Drop-Down Data - Hide","index":4,"n_rows":27,"n_cols":2,"rows_kept":27,"cut":false,"hidden":true,"merged":[[24,1,26,1],[2,1,4,1],[6,1,8,1],[10,1,12,1],[14,1,17,1],[19,1,22,1]]}
["Drop-Down Options","Relevant Question"]
[]
["Very important (e.g., setting/monitoring targets)","Q1"]
["Moderately important (e.g., seeking general understanding of FLW amounts)"]
["Don't know"]
[]
["Yes","Q2,Q3,Q9,Q10,Q11"]
["No"]
["Don't know"]
[]
["Mainly liquid","Q5"]
["Mainly solid"]
["Mixed liquid and solid"]
[]
["All","Q6"]
["Some"]
["None"]
[]
[]
["Yes","Q7,Q8"]
["No"]
["Not applicable"]
[]
[]
["Yes, FLW mixed with other material","Q4"]
["No, FLW is separate"]
["Don't know"]

{"sheet":"Methodology","index":5,"n_rows":30,"n_cols":2,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,"How the “FLW Quantification Method Ranking Tool” works"]
[]
[null,"This tool is designed to help an entity select the quantification methods that may be more or less appropriate under different scenarios. It helps guide users’ decisions regarding the most appropriate methods, based on a set of questions about the circumstances under which the entity is quantifying FLW. These circumstances include important criteria such as the desired level of accuracy and ability to get access to the physical FLW being quantified. "]
[]
[null,"In many cases, more than one method may be required to fully meet an entity’s needs (e.g., if FLW is present in different waste streams, and if an entity is seeking to gather information about the causes of FLW, a different method may be needed for each stream). A limitation of the tool is that it does not consider which methods would work well in combination. This means that the tool may be less helpful when selecting methods to quantify FLW across different sectors or for an entire supply chain. In such cases, the entity should seek advice from experts across a range of FLW quantification methodologies before deciding on the most appropriate quantification methods."]
[]
[null,"The FLW Protocol is grateful to WRAP for developing this tool. "]
[]
[null,"About the Scores in the “Results Tab”"]
[]
[null,"The following describes how the scores are derived."]
[]
[null,"Once the questions are answered (on the “Questionnaire Tab”), a total score is assigned to each method, based on a combination of responses to the questions. The following describes why a method is marked as green, orange, or red in the “Results Tab.”"]
[]
[null,"• Methods scoring 90 or more are marked green; these methods are potentially appropriate for the situation described by an entity’s responses to the questionnaire, provided there are sufficient resources (e.g., budget, staff time) for them."]
[null,"• Methods scoring 25 or more and less than 90 are marked in orange. These methods may be appropriate, but have some drawbacks given the circumstances (these will be listed in the comments in the “Results Tab”). "]
[null,"• Methods scoring less than 25 are marked in red and are not appropriate for the given set of circumstances.  "]
[]
[null,"To obtain a total score for a method, points from each question (that range from zero to one) are multiplied together. The resulting total is then multiplied by 100, so that the range of possible scores is 0 to 100. A method receives zero points if the response to the question rules out that particular method; if the method poses no issues for the scenario described by the responses, it receives one point. In some cases, fractional points are given between these two extremes. "]
[]
[null,"For example, if the response to Question 3 (“Can you get direct access to the FLW being quantified?”) is “Yes,” then the waste composition analysis method is scored one. If the response is “No,” then it is scored zero. The rationale for these points is that an entity needs access to FLW to be able to perform a waste composition analysis. "]
[]
[null,"Because the total score is based on multiplication, if a method is assigned a zero in response to any of the questions (i.e., ruling out that particular method), then it will score zero overall, regardless of the other scores. "]
[]
[null,"The points assigned to each question can be viewed in a tab called “Background rankings – hide,” (which is usually hidden when the tool is operating normally, but can easily be unhidden; right click on any tab below and select \"Unhide\"). To see the points scored for a particular set of responses, the cells to the left of the results table in the “Results Tab” can be “unhidden.”"]
[]
[null,"About the Comments in the “Results Tab”"]
[]
[null,"The tool provides comments for each of the methods based on the responses provided. These are generated using the table in a tab called “Messages – hide” (which is usually hidden when the tool is operating normally, but can easily be unhidden). "]