{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Introduction","Information sheet","Scoping","Vulnerability assessment","Vulnerability results","Control Template","Resources","Report"],"not_rendered":{"charts":3,"images":3,"macros":1,"external_links":1,"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":"Introduction","index":0,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[[9,1,9,4],[10,1,10,4],[1,1,1,4],[3,1,3,4],[5,1,5,4],[6,1,6,4],[7,1,7,4],[8,1,8,4]]}
[]
[null,"Introduction"]
[]
[null,"The FAMI-QS vulnerability assessment template Version 5, 18 June 2021 supports Operators in conducting the vulnerability assessment as described in Chapter 6 of the FAMI-QS Code of Practice (Feed Fraud Prevention and Defence Module). The use of this template is a mandatory requirement developed to support Operators in the process of managing feed fraud risk. Operators with a vulnerability assessment already in place can continue to use their own templates ensuring that the present elements have been incorporated in their own.\n\nThe sections must be executed in a successive order. You can easily move accross all sections with the use of the navigation buttons (arrows).\n\nThis template contains 6 sections:"]
[]
[1,"Information sheet: includes questions for informational purposes as well as information on the Operator's team conducting the vulnerability assessment"]
[2,"Scoping: includes questions to assist the Operator in performing the initial scoping of the vulnerability assessment"]
[3,"Vulnerability assessment: includes the vulnerability assessment to be performed by the Operator based on the scope identified in the scoping section"]
[4,"Vulnerability results: includes the result of the vulnerability assessment based on the Operator's setting of the risk appetite"]
[5,"Control template: includes an overview of all treated vulnerabilities in order to  define the controls to be implemented that should reduce the risks to an acceptable level. Such can include CCPs, CPs or more preventive controls. The control template holds a report generator to create a summary report of the vulnerability assessment "]
[6,"Resources: includes a list of resources that can guide the Operator in answering the questions in the vulnerability assessment"]

{"sheet":"Information sheet","index":1,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,1,2,3],[12,1,12,2]]}
[null,null,null,{"$f":"\"Version \"&'Information sheet'!C11","v":"Version "}]
[null,null,null,{"$f":"'Information sheet'!C10","v":"00:00:00"}]
[null,"Information sheet"]
[]
[]
[null,"Company details"]
[null,"Company Name:"]
[null,"Business Unit:"]
[null,"Location:"]
[null,"Date:"]
[null,"Version:"]
[]
[null,"Feed Fraud Vulnerability Assessment Team"]
[null,"'Team' is a virtual term. Changes to the team may occur after completion of the scoping. "]
[]
[null," ","Name","Job Title"]
[null,"Team leader:"]
[null,"Team member:"]
[null,"Team member:"]
[null,"Team member:"]
[null,"Team member:"]
[null,"Team member:"]
[null,"Team member:"]
[null,"Team member:"]
[null,"Team member:"]
[null,"Team member:"]

{"sheet":"Scoping","index":2,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,1,37,3],[38,1,38,3],[35,1,35,3],[23,1,23,3],[26,1,26,3],[29,1,29,3],[34,1,34,3],[4,1,8,3],[20,1,20,3],[14,1,14,3],[17,1,17,3],[32,1,32,3],[28,1,28,3],[25,1,25,3],[22,1,22,3],[19,1,19,3],[31,1,31,3],[16,1,16,3]]}
[null,null,null,null,{"$f":"\"Version \"&'Information sheet'!C11","v":"Version "}]
[null,null,null,null,{"$f":"'Information sheet'!C10","v":"00:00:00"}]
[null,"FAMI-QS Code of Practice - Feed Fraud Prevention and Defence Module - Version 1.0"]
[]
[null,"Chapter 6.1.2. 'Scope of the feed fraud prevention system' of the FAMI-QS Code of Practice describes that Operators must determine the scope of their feed fraud prevention system by conducting an initial assessment.\n\nThe below scoping questions will provide guidance to the Operators in order to conclude on which level within the company the feed fraud vulnerability assessment should be performed. This template is intended to support the Operator in defining a scope that allows for effective vulnerability assessment.\n\nBy answering the 9 scoping questions, an Operator should be able to determine a scope that allows for performing a (targeted) vulnerability assessment. This scope should  be defined in cell B36. The Operator may decide to define several scopes leading to multiple vulnerability assessments. The additional scopes can be defined in cell B39 and serve as input to a new vulnerability assessment. Operators defining additional scopes are expected to plan for execution of additional assessments."]
[]
[]
[]
[]
[]
[null,"Instructions"]
[null,"Please answer the below scoping questions (based on the results of scoping, the operator may consider updating the team before starting the vulnerability assessment)."]
[]
[null,"Which geography/business unit/product line/sites/sections of the company handle the feed products with the highest economical value?"]
[]
[]
[null,"Which geography/business unit/product line/sites/sections of the company handle the feed products which are subject to price volatility (the degree of variation of a trading price series over time)? "]
[]
[]
[null,"Which geography/business unit/product line/sites/sections of the company handle the feed products which are dependent on a high number of suppliers or are sourced from a complex supply chain (with multiple tiers and/or actors)?"]
[]
[]
[null,"Which geography/business unit/product line/sites/sections of the company handle the feed products which are prone to significant reputational impact in case of a fraud incident?"]
[]
[]
[null,"Which geography/business unit/product line/sites/sections of the company have been affected by past feed fraud incidents that have occurred?"]
[]
[]
[null,"For past feed fraud incidents that have occurred in your company and for which a root cause analysis has been performed; what has the outcome of the root cause analysis identified with regard to fraud vulnerabilities and to which part of the company it related? "]
[]
[]
[null,"Which geography/business unit/product line/sites/sections of the company have been affected by past feed fraud incidents that occurred in your industry and you consider relevant? "]
[]
[]
[null,"Based on your answers to above questions, describe below the scoping of the vulnerability assessment you will perform including geography, business unit, product line, site or section (note if several geography/business unit/product line/sites/sections will be assessed, multiple templates may be needed to complete vulnerability assessments):"]
[]
[]
[null,"Based on your answers to the above question, describe the scope of activities that have not been addressed in this template but should be addressed in a separate assessment template:"]

{"sheet":"Vulnerability assessment","index":3,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":false,"merged":[[5,2,9,6],[11,3,13,6]]}
[null,null,null,null,null,null,null,null,{"$f":"\"Version \"&'Information sheet'!C11","v":"Version "}]
[null,null,"Vulnerability assessment",null,null,null,null,null,{"$f":"'Information sheet'!C10","v":"00:00:00"}]
[]
[null,null,"FAMI-QS Code of Practice - Feed Fraud Prevention and Defence Module - Version 1.0"]
[]
[null,null,"Chapter 6.1.3 'Performing vulnerability assessments' of the FAMI-QS Code of Practice describes that Operators must conduct a feed fraud vulnerability assessment based on the scope defined in chapter 6.1.2. and document the results.\n\nThe Vulnerability Assessment approach must address the opportunities for feed fraud, motivations that fraudsters may have and consider the controls that may already exist in order to determine the current ‘vulnerability to feed fraud’ status. The approach must consider the scope of the feed fraud prevention system as defined in the scoping section of this template in order to apply the appropriate level of detail to the vulnerability assessment. This FAMI-QS template will support Operators in complying with the requirements of chapter 6.1.3."]
[]
[]
[]
[]
[]
[null,null,null,"Note that the decision to 'treat' identified opportunities, motivations or controls needs to be made after the vulnerability results have been analysed. When analysis is completed, the template will require operators to navigate back to the vulnerability assessment section using the button \"Back to Vulnerability Assessment to decide which fraud risk to treat\". Once this button is pressed, a yes/no treatment column appears in column J of this section"]
[]
[]
[]
[null,null,"Instructions"]
[null,null,"Considering the scope defined in the scoping section, please answer which option best describes the vulnerability for each category. Use the justification section to provide arguments why the chosen option applies."]
[]
["In scope (hidden column)",null,"Category","Question","Option 1","Option 2","Option 3","Answer","Justification","Treatment"]
[null,null,"Opportunity","1. How simple or complex is it to adulterate your raw materials / ingredients?","• Cannot be modified, products can only be replaced\n• Technologies / methods are not available or known\n• Simple and straightforward to check alteration of raw materials/ ingredients e.g. visual inspection, smelling","• Can be modified by mixing low-quality or foreign material e.g. powders\n• Advanced technologies, methods, facilities and knowledge are required to adulterate \n• Established on-site methods are available for fraud screening (e.g. test kits) but confirmation of adulteration requires additional testing","• Can be modified by mixing low-quality or foreign material e.g. powders\n• Can be modified by altering valuable feed components\n• Basic technologies, knowledge and methods are available, with no specialist facilities required to adulterate the raw materials/ ingredients\n• Detection and confirmation requires advanced laboratory analysis, or testing for adulteration is not available at all",null,null,"No"]
[null,null,"Opportunity","2. How simple or complex is it to adulterate your final products?","• No technologies / methods known or available\n• Simple and straightforward to check adulteration of final product (to include: are performed) e.g. visual inspection, smelling","• Advanced technologies, methods, facilities and knowledge are required to adulterate final products\n• Established on-site methods are available for fraud screening (e.g. test kits) but confirmation of adulteration requires additional testing","• Simple technologies and methods are available, and no specialist facilities or knowledge are required, to adulterate final products\n• Detection and confirmation of adulteration of final products requires advanced laboratory analyses, or testing for adulteration is not available at all",null,null,"No"]
[null,null,"Opportunity","3. How simple or complex is it to counterfeit your final product?","• Complex to counterfeit final product \n• Technologies, methods, facilities and knowledge are not generally available\n• Detection of counterfeit product is easy \n• Simple and straightforward to check counterfeited product e.g. visual inspection or smelling","• Counterfeiting is possible\n• Requires advanced technologies, methods, facilities and/or knowledge\n• Established and on-site methods are available for counterfeit screening (e.g. test kits) but confirmation of counterfeiting requires additional testing","• Counterfeiting is easy\n• Technologies, methods, facilities and knowledge are generally available\n• Detection and confirmation of counterfeiting requires advanced laboratory analyses, or testing for counterfeiting is not available at all",null,null,"No"]
[null,null,"Opportunity","4. How simple or complex would you describe the production lines and processing activities of your company?","Examples of simple production lines and processing activities:\n• Continuous flow processes\n• Minor equipment modifications between batches\n• Only authorized personnel has access both day and night","Examples of moderate complex production lines and processing activities:\n• Production of large batches\n• Minor equipment modifications between batches (repetitive flows)\n• Opportunity for unauthorized access to equipment but no night processing","Examples of complex production lines and processing activities:\n• Production of relatively small batches\n• Major modifications between batches (intermittent flows)\n• Opportunity for unauthorized access both during day and night",null,null,"No"]
[null,null,"Opportunity","5. How transparent would you consider the feed supply chain you operate in?","• Transparent \n• Good insight into all suppliers and customers\n• Long-term business relationships and based on trust\n• Integrated supply chain; well-coordinated, comprehensive information exchange across the supply chain","• Not fully transparent\n• Only direct suppliers and customer are known\n• Business relationships are variable; long-term and/ or short-term\n• Some degree of integration of supply chain; information exchange occurs mainly with direct suppliers and customers","• Complex and lacks transparency\n• Customers and suppliers are geographically spread across many territories \n• Business relationships are ad-hoc\n• Price is main driver for selecting suppliers\n• No information exchange between direct suppliers and customers",null,null,"No"]
[null,null,"Opportunity","6. Have fraud incidents of your final products or corresponding raw materials / ingredients used been reported?","• No known (or documented) feed fraud incidents related to your final products or corresponding raw materials/ ingredients","• A few feed fraud incidents have occurred with final products or raw materials/ ingredients \n• Limited documentation and few/no media reports are available","• Many fraudulent incidents have occurred with final products or raw materials/ ingredients\n• Incidents are well known and documented, and received substantial media attention",null,null,"No"]
[null,null,"Motivations","7. How readily available are your raw materials/ingredients and how stable is the pricing of those?","• Raw materials/ ingredients are readily available\n• No export bans exist\n• Prices are stable\n• Prices of substitute raw materials/ ingredients are equivalent","• Supply of raw materials/ ingredients is not readily available \n• Stable prices\n• Export bans on raw materials/ ingredient exist in a few countries","• Tight (few) global supplies of raw materials and/or shortages exist\n• Export bans in many countries\n• Price spikes (or fluctuations or volatility) are common\n• Large differences in prices of materials from different geographical regions \n• Prices of substitutes vary greatly",null,null,"No"]
[null,null,"Motivations","8. Are there any premium ingredients / raw material in the product?","• No premium ingredients/raw materials\n• The value of raw materials is not determined by its composition, way of production or origin","• Some premium ingredients/raw materials present\n• The value of raw materials is influenced by its composition (e.g. protein or fat content)","• Premium ingredients/raw materials present\n• Value of raw materials is greatly determined by its composition, way of production and/or origin",null,null,"No"]
[null,null,"Motivations","9. What is the corruption level for the countries you predominantly operate in?","• Mostly countries with low corruption levels\n• Mainly operating in countries with low levels of corruption (ranking 1-25 on the Transparency International Corruptions Perception Index)","• Mostly countries with medium corruption levels\n• Mainly operating in countries with medium levels of corruption (ranking 26-75 on the Index)","• Mostly countries with high corruption levels\n• Mainly operating in countries with high levels of corruption (ranked 76 and lower on the Index)",null,null,"No"]
[null,null,"Motivations","10. How would you describe the economic health of your direct supplier(s)?","• Most suppliers are economically healthy\n• Profitable and achieving its financial targets","• Most suppliers are economically average healthy\n• Profits are declining \n• Gap between financial targets and actual performance","• Most suppliers are economically unhealthy\n• Financial losses and it is difficult to meet financial targets",null,null,"No"]
[null,null,"Motivations","11. How common are criminal offences across your sector of the feed supply chain? (i.e. your company and your direct competitors)?","• No evidence of feed fraud (or other related criminal offences) activity or other forms of law breaking in our sector","• Incidents of feed fraud (or other related criminal offences) may have occurred across the sector but there is no specific information available","• Well-known and documented feed fraud incidents (or other related criminal offences) across our sector",null,null,"No"]
[null,null,"Motivations","12. Are there price differences as a result of regulatory differences across countries?","• Similar price policy of raw materials/ ingredients and final feed products for all countries","• Different price policy of raw materials/ ingredients and final products in some countries","• Considerable variations in price policy of raw materials/ ingredients and final products across different countries",null,null,"No"]
[null,null,"Controls","13. How extensive are your raw materials screened/monitored for feed fraud and is this subject to external verification?","• Very extensive screening/monitoring for feed fraud of raw materials \n• Systematic, evidence-based (using both historical and scientific data) sampling plan for feed fraud-related analyses\n• Specific feed fraud screening methods and systematic use of fit-for-purpose confirmatory techniques (in house or in collaboration with accredited laboratories)\n• Customized procedures for feed fraud monitoring and handling of non-conformities\n• Systematic record keeping and detailed documentation of feed fraud monitoring mitigation procedures & systems \n• Systematic and comprehensive verification (document & record analysis, observations, and actual testing), unannounced and performed by autonomous controller of fraud monitoring tasks","• Medium extensive screening/monitoring for feed fraud of raw materials \n• No systematic ad-hoc sampling for feed fraud analysis\n• General screening (quick) methods in place but no (external) confirmatory feed fraud testing\n• General procedure for sampling and screening for monitoring of raw materials/ ingredients feed fraud issues\n• Record-keeping in case of deviations; limited documentation on feed fraud monitoring mitigation procedures/systems \n• Ad-hoc and or announced verification of feed fraud monitoring tasks; mainly based on analysis of records and check of presence of procedures (e.g. as part of auditing)","• No screening/monitoring for feed fraud of raw materials \n• Sampling plan only for safety and quality analyses but not for feed fraud check \n• No methods for fraud detection in place; external feed fraud analysis only in case of inspection demands/fraud issues\n• No procedures for feed fraud monitoring tasks \n• No record keeping on adulterated or suspicious raw materials/ ingredients, and no documentation of feed fraud mitigation procedures \n• No verification of feed fraud monitoring tasks at incoming raw material/ ingredient control",null,null,"No"]
[null,null,"Controls","14. How extensively are your final products screened/monitored for feed fraud and is this subject to external verification?","• Very extensive screening/monitoring for feed fraud of final products\n• Systematic, evidence-based (using both historical and scientific data) sampling plan for feed fraud-related analyses\n• Specific feed fraud screening methods and systematic use of fit-for-purpose confirmatory techniques (in house or in collaboration with accredited laboratory)\n• Customized procedures for feed fraud monitoring and handling of non- conformities\n• Systematic-record keeping and detailed documentation of feed fraud monitoring procedures & feed fraud monitoring system design \n• Systematic, comprehensive (document & record analysis, observations, and actual verification testing) and unannounced verification by autonomous controller\n• Systematic documentation of verification activities and outcomes","• Medium extensive screening/monitoring for feed fraud of final products\n• No systematic, ad-hoc sampling for fraud analysis\n• General procedure for sampling and screening for ad-hoc monitoring of products and no or ad-hoc (external) confirmatory feed fraud testing\n• Mainly record-keeping in case of deviations; limited documentation on feed fraud monitoring procedures/system\n• Ad hoc and/or announced verification of compliance to monitoring tasks mainly based on analysis of records and check of presence of procedures (e.g. as part of auditing)\n• Ad-hoc reporting of verification outcomes; mainly in case of deviations","• No screening/monitoring for feed fraud of final products\n• Sampling plan only for safety and quality analyses but not for authenticity check\n• No methods for feed fraud monitoring and detection in place; external authenticity analysis only in case of inspection demands/fraud issues\n• No record keeping on adulterated or suspicious raw materials / ingredients and no documentation of feed fraud procedures\n• No verification of actual compliance to monitoring tasks at final product control",null,null,"No"]
[null,null,"Controls","15. How extensively is the mass balance system in your company?","• Established and comprehensive (accurate mass balance data, of all crucial ingredients, materials, & final product flows) process monitoring information system dedicated for control of mass balance flows\n• Structured record keeping of mass flow information and systematic analysis of integral data of whole company (including internal suppliers)","• Process monitoring information system with accurate information on mass balances of mainly bulk ingredients\n• No integral analysis of mass flow data throughout the company (including internal suppliers)","• Basic administrative system with limited information or no specific information on mass balances of incoming materials and final products\n• Data only analyzed in case of inspection requirements",null,null,"No"]
[null,null,"Controls","16. How extensive is the tracking & tracing system of your company and is it linked to your supplier tracing?","• System with clearly defined traceability resource units (product level; collection of accurate information including fraud-relevant issues from direct supplier up to direct customer\n• Advanced automated and systematically controlled robust data capturing and data retrieval system (fraud proof)\n• Tracing system integrated with supply chain/supplier systems on high risk raw materials/ingredients","• System with clearly defined traceability resource units; Collection of accurate information but not specifically addressing fraud issues, only information on company level\n• Computer-based data capturing & retrieval system but not systematically controlled (restricted possibilities for fraud)","• Traceability system without clearly defined traceability resource units or units cannot be exactly defined (e.g. because of continuous flow).\n• Uncertainty about accuracy of information, and limited/no fraud relevant information\n• Data capturing and retrieval system is not fraud proof/data protected",null,null,"No"]
[null,null,"Controls","17. Is there an integrity screening programme of your employees?","• Use of established integrity screening methods is standard for employment of all personnel","• Use of established integrity screening methods for employees at key positions","• No integrity screening of employees",null,null,"No"]
[null,null,"Controls","18. Do contractual requirements with your direct suppliers include elements that limit opportunities for feed fraud?","• Comprehensive contractual requirements established in close collaboration with direct supplier(s) addressing logistics, safety and quality, but also requirements on adoption of ethical code/guidelines, and adoption of similar technical fraud control measures","• Contractual requirements are established together with direct supplier(s) for both logistic and safety & quality parameters","• Contractual requirements for direct suppliers are mainly set on logistic parameters: cost, amount and availability",null,null,"No"]
[null,null,"Controls","19. What best describes the feed fraud control system of your direct supplier(s)?","• Direct supplier(s) has a well established feed Safety Management System in place that is regularly audited by a 3rd party and systematically uses fraud screening methods and confirmatory tests to identify suspicious materials","• Direct supplier(s) has a well established feed Safety Management System in place that is regularly audited by a 3rd party and uses basic fraud screening methods","• Direct supplier(s) don’t have a feed Safety Management system or the system is limited (not audited externally, no fraud measures in place)",null,null,"No"]
[null,null,"Controls","20. How extensive is the mass balance system of your direct suppliers?","• An established and comprehensive process monitoring information system exists dedicated to the control of mass balance flows (accurate mass balance data, of all crucial ingredients, materials, & final product flows)\n• Structured record keeping of mass data flow and systematic analysis of integral data across the company (including internal suppliers)","• A process monitoring information system exists with accurate information on mass balance flows of bulk ingredients only\n• No integral analysis of mass data flow across the company (including internal suppliers)","• A basic administrative system exists with limited/no specific information on mass balance flows of incoming materials and final products\n• Data only analyzed in case of inspection requirements",null,null,"No"]
[null,null,"Controls","21. How well established is guidance for feed fraud prevention and control across your sector of the feed supply chain? (i.e. your company and your direct competitors)","• Specific guidelines and examples of best Practices for fraud monitoring & mitigation are provided actively via website, training, information brochures and other mediums","• General guidelines (mainly via websites) for fraud mitigation measures are available, but there are no examples of best Practices of mitigation measures","• No specific guidelines for fraud mitigation exist or aren't shared; guidelines focus on safety only",null,null,"No"]
[null,null,"Controls","22. Does a national feed supply policy exist and how well are fraud prevention laws enforced","• Well established national feed policy with detailed specifically defined legislation to mitigate against feed fraud that is harmonized with internationally recognized recommendations for feed fraud mitigation\n• Systematic fraud-related enforcement practices with risk-based frequency of inspections by regulatory/law enforcement agencies\n• High level of fines/sanctions with substantial financial impact\n• Fraud related enforcement practices are aligned across all stages of the international supply chain with risk-based frequency of inspections by regulatory/law enforcement agencies\n• High level of fines/sanctions with substantial financial impact","• National feed policy with generally defined legislation for feed fraud mitigation but it is not harmonized with internationally recognized recommendations for feed fraud mitigation\n• Fraud-related enforcement practices exist but with low frequency of inspections by regulatory/law enforcement agencies\n• Low level of fines/sanctions with little financial impact \n• Fraud related enforcement practices exist across parts of the international supply chain but the frequency of inspections by regulatory/law enforcement agencies varies\n• Fines/sanctions vary considerably across the international supply chain","• Only a general national feed policy exists without specific legislative requirements for feed fraud mitigation\n• No national fraud related enforcement practices exist\n• Very limited or no fines/sanctions\n• Fraud related enforcement practices are lacking at most stages across the international supply chain\n• Little or no fines/sanctions and the financial impact is minimal",null,null,"No"]

{"sheet":"Vulnerability results","index":4,"n_rows":34,"n_cols":20,"rows_kept":34,"cut":false,"hidden":false,"merged":[[4,1,7,15],[18,1,18,15],[30,1,31,15],[33,1,34,15]]}
[null,null,null,null,null,null,null,null,null,{"$f":"\"Version \"&'Information sheet'!C11","v":"Version "}]
[null,"Vulnerability assessment score overview",null,null,null,null,null,null,null,{"$f":"'Information sheet'!C10","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C25/100","v":0.5},null,"Low",{"$f":"Q3/2","v":0.25}]
[null,"FAMI-QS Code of Practice - Feed Fraud Prevention and Defence Module - Version 1.0"]
[null,"Chapter '6.1.4 - Analysing risk and defining boundaries' of the FAMI-QS Code of Practice describes that Operators must analyse the output of the vulnerability assessment, document the outcome of the analysis and decide on priorities, based on an evaluation of the level of vulnerability associated with each object of focus. The Operator must set risk boundaries, depending on the levels of vulnerability that are acceptable and unacceptable for the operation. Such boundaries can be set by defining the Operator's risk appetite. Setting the operators risk appetite leads to an overall need to take action. The overall need to take action is determined based on the average score of the vulnerability assessment and the set risk appetite. This FAMI-QS template will support Operators in conducting the requirements of chapter 6.1.4."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medium",{"$f":"Q3","v":0.5}]
[]
[null,"Results of Vulnerability Assessment"]
[]
[null,"Category","Score",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High",{"$f":"(1-Q3)/2+Q3","v":0.75}]
[null,"Opportunity",{"$f":"(SUMIFS('Vulnerability assessment'!$H$20:$H$41,'Vulnerability assessment'!$C$20:$C$41,'Vulnerability results'!B13)-COUNTIFS('Vulnerability assessment'!$C$20:$C$41,'Vulnerability results'!B13))/COUNTIFS('Vulnerability assessment'!$C$20:$C$41,'Vulnerability results'!B13)/2","v":-0.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Very high",1]
[null,"Motivations",{"$f":"(SUMIFS('Vulnerability assessment'!$H$20:$H$41,'Vulnerability assessment'!$C$20:$C$41,'Vulnerability results'!B14)-COUNTIFS('Vulnerability assessment'!$C$20:$C$41,'Vulnerability results'!B14))/COUNTIFS('Vulnerability assessment'!$C$20:$C$41,'Vulnerability results'!B14)/2","v":-0.5}]
[null,"Controls",{"$f":"(SUMIFS('Vulnerability assessment'!$H$20:$H$41,'Vulnerability assessment'!$C$20:$C$41,'Vulnerability results'!B15)-COUNTIFS('Vulnerability assessment'!$C$20:$C$41,'Vulnerability results'!B15))/COUNTIFS('Vulnerability assessment'!$C$20:$C$41,'Vulnerability results'!B15)/2","v":-0.5}]
[null,"Overall",{"$f":"SUM(C13:C15)/3","v":-0.5}]
[]
[null,"Instructions"]
[null,"1. Determine the organisation's risk appetite: The risk appetite that can be indicated on the below slider is the level of risk, on a broad scale, an Operator is willing to accept in pursuit of reducing fraud risks to an acceptable level. It reflects the risk management philosophy of the Operator and may influence the allocation of resources. Risk appetite helps the Operator in guiding the organisation, the employees and the processes in designing the necessary infrastructure to effectively respond to feed fraud risks and to monitor them. Note that setting the risk appetite is not the result of an exact score, but rather the assessment of how the operators risk appetite variers between very low and very high."]
[]
[null,"Very low","Risk appetite",null," Very high"]
[]
[]
[]
[null,null,50]
[null,"A low risk appetite may lead to the implementation of a stringent control environment with many control points with regard to feed fraud."]
[null,"A medium risk appetite may lead to the implementation of an intermediate control environment with some control points with regard to feed fraud."]
[null,"A high risk appetite may lead to the implementation of a limited control environment with very few control points with regard to feed fraud."]
[]
[null,"Overall risk level:",{"$f":"IF(C16<=T3,S3,IF(C16<=T8,S8,IF(C16<=T12,S12,IF(C16<=T13,S13,\"Error\"))))","v":"Low"},"need to take action"]
[null,"Please note that it is possible to score an overall risk level of 'low'. If this is the case, FAMI-QS suggests as a minimum to evaluate and 'treat' the questions in the Vulnerability assessment tab that have a score of 3 (indicating a high vulnerability)."]
[]
[]
[null,"2. Use the below results on fraud opportunity, motivations and control maturity to analyse the results of the vulnerability assessment.  Use the overall risk level as an indicator which fraud risks need to be addressed in the control template. E.g., a high-risk level may lead to the treatment of all risks with a score of 2 and 3, while a low risk level may lead to only treating the risks with a score of 3.\nTo navigate back to the ‘Vulnerability assessment’ tab to decide which risks need to be addressed/treated, use the left button at the bottom of this page (the ‘Treatment’ column J appears and can be edited only after you have clicked on the button). Indicate in column J fraud risks you would like to treat. The fraud risks where a 'yes' is indicated will automatically be added to the list of vulnerabilities displayed in the 'Control template' section."]

{"sheet":"Control Template","index":5,"n_rows":57,"n_cols":18,"rows_kept":57,"cut":false,"hidden":false,"merged":[[17,6,17,11],[17,2,17,5],[17,12,17,14],[17,15,17,17],[4,2,6,7],[9,2,9,7]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Version \"&'Information sheet'!C11","v":"Version "}]
[null,null,"Vulnerability Control Point Identification",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Information sheet'!C10","v":"00:00:00"}]
[]
[null,null,"FAMI-QS Code of Practice - Feed Fraud Prevention and Defence Module - Version 1.0"]
[null,null,"Chapter '6.1.5 - Defining critical control points' of the FAMI-QS Code of Practice describes that Operators must define a set of preventive actions and controls to reduce the vulnerabilities to an acceptable level. Based on the controls identified, a mitigation plan based on CCP’s must be developed. This FAMI-QS template will support Operators in conducting the requirements of chapter 6.1.5."]
[]
[]
[]
[null,null,"Instructions:"]
[null,null,"Indicate in column J ('Treatment') of the Vulnerability assessment tab if all vulnerabilities have been analysed and either marked with a yes or no. The fraud risks where a 'yes' is indicated have been automatically added to the table below for documentation on further actions, based on the following steps:"]
[null,null,"1. Identify the feed fraud vulnerabilities from the Vulnerability assessment (automatically added)"]
[null,null,"2. Describe the control measures (risk mitigation measures) to reduce fraud risk, also consider legal requirements"]
[null,null,"3. Where applicable set at least one critical control limit for each control, also consider legal limit requirements and identify supporting documentation"]
[null,null,"4. Define monitoring procedures for each control including frequency, responsibilities and relevant documentation necessary to perform the monitoring procedures"]
[null,null,"5. Define anticipated corrective actions for each control outside of control limits including responsibilities and record keeping"]
[null,null,"6. Validate approach before implementation and verify effective implementation"]
[]
[null,null,"Vulnerability assessment",null,null,null,"Monitoring/Control Plan",null,null,null,null,null,"Corrective action plan",null,null,"Verification and validation"]
[null,null,"1. Feed Vulnerability Category","1. Feed Vulnerability Topic","1. Feed Vulnerability Score","1. Justification","2. Control Measures","3. Critical limit (where applicable)","4. Control monitoring procedure","4. Frequency of monitoring","4. RACI (responsible/accountable/ consulted/informed) for monitoring","4. Documentation","5. Corrective action procedure","5. RACI (responsible/accountable/ consulted/informed) for monitoring","5. Documentation","Verified","Validated","Date"]
[1,null,{"$f":"IFERROR(INDEX(Table3[Category],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A20)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Question],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A20)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Answer],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A20)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Justification],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A20)),0)","v":0}]
[2,null,{"$f":"IFERROR(INDEX(Table3[Category],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A21)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Question],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A21)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Answer],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A21)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Justification],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A21)),0)","v":0}]
[3,null,{"$f":"IFERROR(INDEX(Table3[Category],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A22)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Question],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A22)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Answer],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A22)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Justification],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A22)),0)","v":0}]
[4,null,{"$f":"IFERROR(INDEX(Table3[Category],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A23)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Question],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A23)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Answer],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A23)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Justification],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A23)),0)","v":0}]
[5,null,{"$f":"IFERROR(INDEX(Table3[Category],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A24)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Question],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A24)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Answer],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A24)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Justification],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A24)),0)","v":0}]
[6,null,{"$f":"IFERROR(INDEX(Table3[Category],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A25)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Question],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A25)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Answer],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A25)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Justification],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A25)),0)","v":0}]
[7,null,{"$f":"IFERROR(INDEX(Table3[Category],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A26)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Question],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A26)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Answer],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A26)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Justification],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A26)),0)","v":0}]
[8,null,{"$f":"IFERROR(INDEX(Table3[Category],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A27)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Question],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A27)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Answer],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A27)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Justification],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A27)),0)","v":0}]
[9,null,{"$f":"IFERROR(INDEX(Table3[Category],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A28)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Question],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A28)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Answer],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A28)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Justification],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A28)),0)","v":0}]
[10,null,{"$f":"IFERROR(INDEX(Table3[Category],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A29)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Question],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A29)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Answer],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A29)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Justification],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A29)),0)","v":0}]
[11,null,{"$f":"IFERROR(INDEX(Table3[Category],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A30)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Question],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A30)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Answer],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A30)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Justification],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A30)),0)","v":0}]
[12,null,{"$f":"IFERROR(INDEX(Table3[Category],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A31)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Question],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A31)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Answer],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A31)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Justification],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A31)),0)","v":0}]
[13,null,{"$f":"IFERROR(INDEX(Table3[Category],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A32)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Question],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A32)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Answer],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A32)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Justification],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A32)),0)","v":0}]
[14,null,{"$f":"IFERROR(INDEX(Table3[Category],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A33)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Question],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A33)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Answer],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A33)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Justification],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A33)),0)","v":0}]
[15,null,{"$f":"IFERROR(INDEX(Table3[Category],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A34)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Question],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A34)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Answer],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A34)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Justification],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A34)),0)","v":0}]
[16,null,{"$f":"IFERROR(INDEX(Table3[Category],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A35)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Question],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A35)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Answer],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A35)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Justification],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A35)),0)","v":0}]
[17,null,{"$f":"IFERROR(INDEX(Table3[Category],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A36)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Question],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A36)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Answer],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A36)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Justification],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A36)),0)","v":0}]
[18,null,{"$f":"IFERROR(INDEX(Table3[Category],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A37)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Question],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A37)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Answer],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A37)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Justification],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A37)),0)","v":0}]
[19,null,{"$f":"IFERROR(INDEX(Table3[Category],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A38)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Question],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A38)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Answer],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A38)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Justification],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A38)),0)","v":0}]
[20,null,{"$f":"IFERROR(INDEX(Table3[Category],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A39)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Question],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A39)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Answer],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A39)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Justification],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A39)),0)","v":0}]
[21,null,{"$f":"IFERROR(INDEX(Table3[Category],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A40)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Question],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A40)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Answer],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A40)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Justification],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A40)),0)","v":0}]
[22,null,{"$f":"IFERROR(INDEX(Table3[Category],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A41)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Question],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A41)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Answer],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A41)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Justification],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A41)),0)","v":0}]
[23,null,{"$f":"IFERROR(INDEX(Table3[Category],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A42)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Question],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A42)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Answer],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A42)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Justification],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A42)),0)","v":0}]
[24,null,{"$f":"IFERROR(INDEX(Table3[Category],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A43)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Question],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A43)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Answer],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A43)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Justification],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A43)),0)","v":0}]
[25,null,{"$f":"IFERROR(INDEX(Table3[Category],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A44)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Question],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A44)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Answer],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A44)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Justification],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A44)),0)","v":0}]
[26,null,{"$f":"IFERROR(INDEX(Table3[Category],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A45)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Question],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A45)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Answer],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A45)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Justification],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A45)),0)","v":0}]
[27,null,{"$f":"IFERROR(INDEX(Table3[Category],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A46)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Question],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A46)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Answer],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A46)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Justification],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A46)),0)","v":0}]
[28,null,{"$f":"IFERROR(INDEX(Table3[Category],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A47)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Question],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A47)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Answer],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A47)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Justification],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A47)),0)","v":0}]
[29,null,{"$f":"IFERROR(INDEX(Table3[Category],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A48)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Question],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A48)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Answer],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A48)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Justification],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A48)),0)","v":0}]
[30,null,{"$f":"IFERROR(INDEX(Table3[Category],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A49)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Question],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A49)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Answer],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A49)),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Justification],SMALL(IF(Table3[Treatment]=\"Yes\",ROW(Table3[Treatment])-ROW(INDEX(Table3[Treatment],1,1))+1),'Control Template'!A49)),0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"When pressing the 'create report' button, the page settings affect the display of the .pdf document."]

{"sheet":"Resources","index":6,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,13],[6,1,8,1],[13,1,14,1]]}
[]
[null,"Resources\n"]
[null,"Below list of resources can provide guidance when answering the questions of the vulnerability assessment:"]
[]
[]
[null,"Can provide guidance in answering questions:","Link to resources:"]
[null,"Opportunities ǀ questions 1 & 3 & 6","https://www.foodshield.org/tools.cfm"]
[null,null,"https://decernis.com/"]
[null,null,"https://ec.europa.eu/food/safety/rasff_en"]
[null,"Motivations ǀ question 7","e.g. http://www.indexmundi.com/commodities/?commodity=cocoa-beans"]
[null,"Motivations ǀ question 9","http://www.transparency.org"]
[null,"Motivations ǀ question 10","Annual reports of suppliers, company financial reports"]
[null,"Motivations ǀ question 11","https://www.indexmundi.com/commodities/?commodity=sugar "]
[null,"Transparency Index\nOperators should answer question 9 (motivations) by looking at the ranking on the index, not the score. E.g., New Zealand ranks 1 with a score of 88 in the 2020 index, Somalia ranks 179 with a score of 12 in the 2020 index).","https://www.transparency.org/en/cpi/2020/index/prk "]
[null,null,"The above link to the Transparency Index will be updated annually"]

{"sheet":"Report","index":7,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Company Report Name:",{"$f":"'Information sheet'!$C$7","v":0}]
[]
[null,{"$f":"TODAY()","v":"2023-01-31"}]