{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["0. INSTRUCTION","1. PRIMARY DATA & IMS ","2. SELF-ASSESSMENT UAP&CODE","3. LIST OF TRAININGS","4. PESTICIDE REPORT","5. Verifier ONLY- CODE RATING","6. Verifier ONLY - SUMMARY","Mandatory requirements - 4C IP","Calculations","Dropdowns","Pesticide answers","HELP!"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":40,"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":"0. INSTRUCTION","index":0,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,1,37,12],[33,2,33,11],[30,2,30,11],[32,2,32,11],[13,7,13,11],[31,2,31,11],[15,7,15,11],[16,7,16,11],[17,7,17,11],[28,2,28,7],[27,2,27,11],[10,2,10,7],[11,2,11,11],[9,1,9,12],[1,1,7,12],[8,1,8,12]]}
[null,"2017-12-01"]
[null,"ASSESSMENT TOOL FOR 4C UNITS AND VERIFIERS VERSION 3.4\n\nCAS_Doc_21_Assessment Tool_v3.4_en"]
[]
[]
[]
[]
[]
[]
[null,"INSTRUCTION"]
[]
[null,null,"CONTENT"]
[null,null,"The 4C Assessment Tool is used by 4C Units and verifiers and consists of 7 pages: "]
[]
[null,null,"PAGE 1 ","-","FOR 4C UNITS","PRIMARY DATA & IMS",null,"4C Units provide basic data and determine the performance level of the Internal Management System"]
[]
[null,null,"PAGE 2 - ",null,"FOR 4C UNITS","SELF-ASSESSMENT UAP & CODE ",null,"4C Units assess their performance against the 10 Unacceptable Practices (UAP) & 27 Code Principles"]
[]
[null,null,"PAGE 3 -",null,"FOR 4C UNITS","LIST OF TRAININGS",null,"4C Units use this page to provide information on trainings given in the past 12 months"]
[]
[null,null,"PAGE 4 - IMPROVEMENT PLAN. Filled in by 4C Units 6 weeks after issuing of the 4C license",null,"FOR 4C UNITS","PESTICIDE REPORT",null,"4C Units provide information on pesticides used"]
[]
[null,null,"PAGE 5 - CODE RATING. Used by verifiers during any verification visit",null,"FOR VERIFIERS","CODE RATING",null,"Verifiers use this page to verify the 4C Unit's performance level against the code principles (based on the sample taken)"]
[]
[null,null,"PAGE 6 - ",null,"FOR VERIFIERS","SUMMARY OF RESULTS",null,"Verifiers use this page to evaluate the IMS, UAP and Code Principles of the entire 4C Unit"]
[]
[null,null,"PAGE 7 - IMPROVEMENT PLAN. Filled in by 4C Units 6 weeks after issuing of the 4C license",null,"FOR 4C UNITS","IMPROVEMENT PLAN",null,"4C Units provide information on improvement activities based on the verification results"]
[]
[null,null,"Guidance "]
[null,null,"WHEN ARE 4C UNITS ASKED TO FILL IN OR UPDATE THE RESPECTIVE PAGES "]
[]
[null,null,"PAGES 1,2,3, and 4 are completed by 4C Units before any verification. The 4C Assessment Tool is send to the 4C Verifier and to Coffee Assurance Services.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            "]
[null,null,"PAGES 1,2,3, 4 and the Improvement Plan are updated by 4C Units annually and sent to Coffee Assurance Services jointly with an updated Business Partner Mapping (Annual Update)."]
[]
[null,null,"During verification visits in the field, 4C Verifiers use the 4C Assessment Tool which has been completed by 4C Units as application for before verification, to verify correctness of the information provided by the 4C Unit."]
[]
[]
[]
[null,"For more information please refer to the 4C Verification Regulations www.cas-veri.com or contact us at info@cas-veri.com"]

{"sheet":"1. PRIMARY DATA & IMS ","index":1,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[[8,1,8,12],[9,1,10,3],[11,3,13,3],[9,12,10,12],[11,1,16,1],[11,2,15,2],[14,12,15,12],[11,12,13,12],[9,4,9,11],[16,2,16,11],[3,5,3,6],[4,5,4,6],[1,1,1,12],[2,1,2,12],[7,1,7,12],[5,5,5,6]]}
[]
[null,"PRIMARY DATA & IMS OF THE 4C UNIT"]
[null,"                     Please provide basic information about the 4C Unit and Managing Entity."]
[null,"NAME OF 4C UNIT:",null,null,null,null,null,"TYPE OF VERIFICATION OR ANNUAL UPDATE:"]
[null,"4C UNIT NUMBER:",null,null,null,null,null,"NAME OF 4C UNIT CONTACT PERSON:"]
[null,"NAME OF MANAGING ENTITY:",null,null,null,null,null,"DATE OF COMPLETION:"]
[]
[null,"                            SELF-ASSESSMENT OF THE INTERNAL MANAGEMENT SYSTEM (IMS)"]
[null,"Please determine the performance level of your Internal Management System (IMS) on a scale from “Basic” via “Intermediate” to “Advanced”. \nPlease tick the corresponding cell in column M.\nThe table below depicts the indicators necessary to attain a certain IMS performance level. \nBasic IMS: ALL basic indicators are in place\nIntermediate IMS: ALL basic AND intermediate indicators are in place\nAdvanced: ALL basic, intermediate AND advanced indicators are in place\n"]
[null,"LEVELS",null,null,"INDICATORS OF THE DIFFERENT LEVELS ",null,null,null,null,null,null,null,"ASSESSMENT BY 4C UNIT Please select"]
[null,null,null,null,"4C Unit Managing Entity (ME)","List of Business Partners (BPs) and their data","4C Unit structure and key functions of BPs","Self-Assessment","Improvement Plan","IMS documentation and communication","Implementation plan","Sanction measures"]
[null,"Advanced","                   Intermediate","Basic","1. Name and contact details of the Managing Entity, main role and responsibility within the 4C Unit","3. Completed and up-to-date Business Partner Mapping (BPM) listing all BPs\nand their basic data ","4. An organisational chart of the 4C Unit including a clear product flow with key functions of each type of BP  within the 4C Unit","5. An aggregated Self-Assessment before verification","8. An Improvement Plan is developed after each verification and is being implemented ","9. Evidence of communicating the IMS and its requirements to BPs (this includes what is required of the BPs and that they should allow for internal or external assessments)",null,"12. Implemen-tation of a documented procedure for sanctions and appeals"]
[null,null,null,null,"2. Appointed person(s) taking care of the IMS and 4C Code implementation, their roles, responsibilities and competences",null,null,"6. Up to date assessments of individual BPs available at the ME office",null,"10. Mutual commitment by the ME and BPs in implementing the 4C requirements"]
[null,null,null,null,null,null,null,"7. Implementation of a documented procedure for annual decision making on conformity assessment status both at individual BP level and at aggregated level",null,"11. Implementation of a documented procedure for obtaining agreement with all BPs to be part of the 4C Unit, including approval and removal criteria and processes, requirements for the ME and BPs on record keeping"]
[null,null,null,null,"13. Training is provided to the appointed person(s) that take care of the IMS and Code implementation",null,"                                       ","14. Training is provided to those who conduct the Self -Assessment within the 4C Unit on 4C requirements (Code of Conduct, IMS and others)",null,null,"17. A plan prepared by the ME on implementing the 4C Code, including verification, within the 4C Unit over a defined time"]
[null,null,null,null,null,null,null,"15. Records of site evaluations of a representative sample of BPs available at ME level ",null,"16. A document describing the 4C Unit’s IMS"]
[null,null,"                    Other scheme's ICS (IMS) requirements encompassing ISEAL P035_ Common requirements for producer group certification. "]

{"sheet":"2. SELF-ASSESSMENT UAP&CODE","index":2,"n_rows":407,"n_cols":10,"rows_kept":407,"cut":false,"hidden":false,"merged":[[1,2,1,9],[6,2,6,6],[6,8,6,9],[7,2,9,2],[8,3,8,6],[9,3,9,6],[26,3,26,6],[27,3,27,6],[28,2,30,2],[29,3,29,6],[30,3,30,6],[25,2,27,2],[19,2,21,2],[20,3,20,6],[21,3,21,6],[22,2,24,2],[23,3,23,6],[24,3,24,6],[10,2,12,2],[11,3,11,6],[12,3,12,6],[3,2,3,9],[4,2,4,9],[13,2,15,2],[14,3,14,6],[15,3,15,6],[8,8,9,9],[11,8,12,9],[16,2,18,2],[17,3,17,6],[18,3,18,6],[362,9,367,9],[296,9,301,9],[304,9,309,9],[276,2,287,2],[276,3,287,3],[123,4,129,4],[123,5,129,5],[40,2,40,9],[43,2,43,9],[31,2,33,2],[32,3,32,6],[33,3,33,6],[34,2,36,2],[35,3,35,6],[36,3,36,6],[37,2,37,6],[37,7,37,9],[340,9,345,9],[350,2,359,2],[350,3,359,3],[149,2,149,9],[251,2,268,2],[376,9,381,9],[290,2,301,2],[290,3,301,3],[290,4,301,4],[290,5,301,5],[326,9,331,9],[340,2,347,2],[326,2,337,2],[227,2,236,2],[227,3,236,3],[227,4,236,4],[227,5,236,5],[179,3,188,3],[179,4,188,4],[151,9,154,9],[170,7,172,7],[326,3,337,3],[326,4,337,4],[326,5,337,5],[54,2,66,2],[54,3,66,3],[54,4,66,4],[54,5,66,5],[213,2,224,2],[213,3,224,3],[213,4,224,4],[213,5,224,5],[151,3,160,3],[151,4,160,4],[96,2,106,2],[96,3,106,3],[96,4,106,4],[96,5,106,5],[151,5,160,5],[163,2,175,2],[83,3,93,3],[83,4,93,4],[83,5,93,5],[163,3,175,3],[163,4,175,4],[163,5,175,5],[132,2,142,2],[132,3,142,3],[76,7,77,7],[76,8,78,8],[179,2,188,2],[109,5,120,5],[109,2,120,2],[109,3,120,3],[109,4,120,4],[123,2,129,2],[69,2,79,2],[69,3,79,3],[69,4,79,4],[83,2,93,2],[123,3,129,3],[69,5,79,5],[132,4,142,4],[132,5,142,5],[78,7,79,7],[390,9,393,9],[350,9,355,9],[362,5,373,5],[201,5,210,5],[390,2,399,2],[390,3,399,3],[390,4,399,4],[390,5,399,5],[304,2,313,2],[304,3,313,3],[239,2,248,2],[239,3,248,3],[239,4,248,4],[239,5,248,5],[376,4,387,4],[251,3,268,3],[251,4,268,4],[251,5,268,5],[290,9,295,9],[350,4,359,4],[350,5,359,5],[362,2,373,2],[362,3,373,3],[362,4,373,4],[376,2,387,2],[376,3,387,3],[304,4,313,4],[304,5,313,5],[316,2,323,2],[376,5,387,5],[316,3,323,3],[316,4,323,4],[316,5,323,5],[340,3,347,3],[340,4,347,4],[340,5,347,5],[276,5,287,5],[191,2,198,2],[191,3,198,3],[191,4,198,4],[191,5,198,5],[201,2,210,2],[201,3,210,3],[201,4,210,4],[273,2,273,9],[272,2,272,8],[251,9,256,9],[258,7,259,7],[264,7,266,7],[276,9,287,9],[191,9,194,9],[201,9,204,9],[213,9,216,9],[227,9,232,9],[276,4,287,4],[32,8,33,9],[35,8,36,9],[14,8,15,9],[17,8,18,9],[20,8,21,9],[23,8,24,9],[26,8,27,9],[29,8,30,9],[270,4,270,8],[176,2,176,9],[179,5,188,5],[144,4,144,8],[151,2,160,2],[41,2,41,9],[114,7,116,7],[69,9,70,9],[45,2,51,2],[45,3,51,3],[45,4,51,4],[45,5,51,5],[39,2,39,9],[147,2,147,9],[80,2,80,9],[179,9,187,9]]}
[]
[null,null,"SELF-ASSESSMENT AGAINST THE 4C CODE OF CONDUCT"]
[]
[null,null,"10 UNACCEPTABLE PRACTICES"]
[null,null," Please evaluate the performance of the 4C Unit against the 10 Unacceptable Practices by ticking the respective answer. "]
[]
[null,null,"PRACTICES",null,null,null,null,"TICK \nHERE","RESULTS"]
[null,null,1,"CHILD LABOUR"]
[null,null,null,"Within my 4C Unit, worst forms of child labour are still practiced. Or:\nChildren below the age of 18 years do work which is likely to jeopardize their health, safety or morals.",null,null,null,null,{"$f":"IF(Calculations!B3=2,Calculations!$K$7,IF(Calculations!B3=1,Calculations!$K$8,IF(Calculations!B3=0,Calculations!$K$6)))","v":"OK"}]
[null,null,null,"Within my 4C Unit, the worst forms of child labour are banned and excluded. And: Children below the age of 18 years do not do work which is likely to jeopardize their health, safety or morals.\n\n"]
[null,null,2,"FORCED AND BONDED LABOUR, TRAFFICKING IN PERSONS"]
[null,null,null,"Within my 4C Unit, practices of forced and bonded labour exist or trafficking of persons is practiced.",null,null,null,null,{"$f":"IF(Calculations!B4=2,Calculations!$K$7,IF(Calculations!B4=1,Calculations!$K$8,IF(Calculations!B4=0,Calculations!$K$6)))","v":"OK"}]
[null,null,null,"Within my 4C Unit, practices of forced and bonded labour are excluded. No trafficking of persons is practiced."]
[null,null,3,"MEMBERSHIP OF AND REPRESENTATION BY A TRADE UNION"]
[null,null,null,"Within my 4C Unit, there is no free choice of membership of or representation by a trade union for all workers.",null,null,null,null,{"$f":"IF(Calculations!B5=2,Calculations!$K$7,IF(Calculations!B5=1,Calculations!$K$8,IF(Calculations!B5=0,Calculations!$K$6)))","v":"OK"}]
[null,null,null,"Within my 4C Unit, there is free choice of membership of or representation by a trade union for all workers."]
[null,null,4,"FORCED EVICTION WITHOUT ADEQUATE COMPENSATION"]
[null,null,null,"Within my 4C Unit there is evidence of forced eviction without adequate compensation having taken place after 2006.",null,null,null,null,{"$f":"IF(Calculations!B6=2,Calculations!$K$7,IF(Calculations!B6=1,Calculations!$K$8,IF(Calculations!B6=0,Calculations!$K$6)))","v":"OK"}]
[null,null,null,"Within my 4C Unit do not exist any cases of forced eviction without adequate compensation that took place before 2006."]
[null,null,5,"ADEQUATE HOUSING FOR WORKERS"]
[null,null,null,"Within my 4C Unit, housing on the farm / plantation (with at least 10 permanent workers) is required by workers, but not provided.\nOR\nWithin my 4C Unit, housing on the farm / plantation (with at least 10 permanent workers) is required and provided, but this is not adequate for the workers. ",null,null,null,null,{"$f":"IF(Calculations!B7=2,Calculations!$K$7,IF(Calculations!B7=1,Calculations!$K$8,IF(Calculations!B7=0,Calculations!$K$6)))","v":"OK"}]
[null,null,null,"Within my 4C Unit, adequate housing is made available to workers on the farm/plantation. OR\nWithin my 4C Unit, there is no housing, because it is not required by workers. OR                                                                  \nThere is no farm / plantation with at least 10 permanent workers."]
[null,null,6,"POTABLE WATER"]
[null,null,null,"Within my 4C Unit, potable water (drinking water) is not made available for workers during working practice.",null,null,null,null,{"$f":"IF(Calculations!B8=2,Calculations!$K$7,IF(Calculations!B8=1,Calculations!$K$8,IF(Calculations!B8=0,Calculations!$K$6)))","v":"OK"}]
[null,null,null,"Within my 4C Unit, potable water (drinking water) is made available to all workers during working practice. "]
[null,null,7,"NATURAL RESOURCES"]
[null,null,null,"Within my 4C Unit, designated protected areas (designated by national and / or international legislation) like primary forests or other natural resources were cut down or destroyed by any Business Partner since 2006.",null,null,null,null,{"$f":"IF(Calculations!B9=2,Calculations!$K$7,IF(Calculations!B9=1,Calculations!$K$8,IF(Calculations!B9=0,Calculations!$K$6)))","v":"OK"}]
[null,null,null,"Within my 4C Unit, no primary forest or other protected areas exist. OR:  \nWithin my 4C Unit, there are protected areas like primary forest or other natural resources. They are conserved and were not cut down or destoyed by any Business Partner since 2006. "]
[null,null,8,"USE OF INTERNATIONALLY BANNED PESTICIDES "]
[null,null,null,"Within my 4C Unit, pesticides listed under the Stockholm Convention on Persistent Organic Pollutants (POPs), the Rotterdam Convention on Prior Informed Consent (PIC) or under the Montreal Protocol of Ozone Depleting Substances are applied on the coffee plot.",null,null,null,null,{"$f":"IF(Calculations!B10=2,Calculations!$K$7,IF(Calculations!B10=1,Calculations!$K$8,IF(Calculations!B10=0,Calculations!$K$6)))","v":"OK"}]
[null,null,null,"Within my 4C Unit, no pesticides listed under the Stockholm Convention on Persistent Organic Pollutants (POPs), the Rotterdam Convention on Prior Informed Consent (PIC) or the Montreal Protocol of Ozone Depleting Substances are applied on the coffee plot."]
[null,null,9,"USE OF GENETICALLY MODIFIED ORGANISMS (GMOs)"]
[null,null,null,"Within my 4C Unit, genetically modified (transgenic) coffee seeds, seedlings or trees are used or traded. ",null,null,null,null,{"$f":"IF(Calculations!B11=2,Calculations!$K$7,IF(Calculations!B11=1,Calculations!$K$8,IF(Calculations!B11=0,Calculations!$K$6)))","v":"OK"}]
[null,null,null,"Within my 4C Unit, no genetically modified (transgenic) coffee seeds, seedlings or trees are used or traded. "]
[null,null,10,"BUSINESS RELATIONS"]
[null,null,null,"Within my 4C Unit, there is evidence of fraud, corruption, bribery and/or extortion. ",null,null,null,null,{"$f":"IF(Calculations!B12=2,Calculations!$K$7,IF(Calculations!B12=1,Calculations!$K$8,IF(Calculations!B12=0,Calculations!$K$6)))","v":"OK"}]
[null,null,null,"Within my 4C Unit, there is no evidence of fraud, corruption, bribery and/or extortion."]
[null,null,"\nRESULTS UNACCEPTABLE PRACTICES",null,null,null,null,{"$f":"IF(Calculations!B14>0,Calculations!K10,IF(Calculations!B15>0,Calculations!K5,IF(Calculations!B16=20,Calculations!K9)))","v":"YOU CAN CONTINUE WITH THE SELF ASSESSMENT"}]
[]
[null,null,"CODE PRINCIPLES "]
[null,null," Please evaluate the performance of the 4C Unit against the 27 Code Principles in the economic, social and environmental dimension. The evaluation is conducted along the traffic light colors of green, yellow and red. Please tick the respective color for each principle by using the indicators.  "]
["H",null,"ECONOMIC DIMENSION"]
[null,null,null,"CATEGORY","NO.","PRINCIPLE","GREEN CRITERIA","YELLOW CRITERIA","RED CRITERIA","APPLIES TO"]
[null,null,"COFFEE FARMING AS A BUSINESS"]
[]
["c",null,"Economic dimension","Profitability and long term productivity","1.1","Actions to maintain or increase profitability and long term productivity at farm level are promoted and starting to be implemented","Producers are implementing practices that will lead to maintained or increased profitability and long term productivity of their farms.","There is awareness on practices that have the potential to maintain or increase profitability and long term productivity.","There is no awareness on practices that have the potential to maintain or increase profitability and long term productivity.","Business Partners which grow coffee "]
[1,null,null,null,null,null,2]
[]
["i",null,null,null,null,null,null,"INDICATORS"]
[]
["i",null,null,null,null,null,"Producers are implementing practices that can lead to maintained or increased profitability and long term productivity such as good agricultural practices, post-harvest and handling practices, and good management practices. \nImplementation of good practices are evident on the farm. \n","Producers are aware of practices that can be implemented at farm level and that can lead to maintained or increased profitability and long term productivity and implementation of good practices has started.","Producers are not aware of practices that have the potential to increase productivity.  "]
[]
[]
[]
["c",null,"Economic dimension","Capacity and skill development","1.2","Business Partners and workers within the 4C Unit have access to trainings to improve their skills and capacities according to identified needs","Business Partners and workers within the 4C Unit are given access to relevant training and skill development in order to apply good agricultural and management practices, according to identified needs.","Business Partners and workers within the 4C Unit have access to training in relevant technical skills.","Business Partners and workers within the 4C Unit do not have access to any training to improve their skills.","Managing Entity and Business Partners"]
[1,null,null,null,null,null,2]
[]
["i",null,null,null,null,null,null,"INDICATORS"]
[]
["i",null,null,null,null,null,"A training policy and implementation plan based on identified needs, have been developed covering Good Agricultural Practices, Good Management Practices, and quality aspects.","Training policy and plan regarding relevant technical skills are documented, and starting to be implemented.","No training policy is in place.\n\n"]
[null,null,null,null,null,null,"And","And","And"]
[null,null,null,null,null,null,"Training activities are available to all workers on an equal basis, and offered for free during working hours. Training activities are available to all Business Partners.","Training activities have started and are available to some workers and Business Partners.","No training activities are evident."]
[null,null,null,null,null,null,"And",null,"And"]
[null,null,null,null,null,null,"Women and men have the same opportunities to participate. ",null,"No documentation is available."]
[null,null,null,null,null,null,"And"]
["i",null,null,null,null,null,"Documentation of training programmes for all workers and Business Partners is available. "]
[]
[]
[]
["c",null,"Economic dimension ","Record keeping","1.3","Record keeping to monitor profitability is promoted","Record keeping of main costs and income by producers is evident.","Steps are taken to ensure that main coffee costs and coffee income are kept.","No records of any costs and incomes are evident.","Managing Entity and Business Partners that grow coffee"]
[1,null,null,null,null,null,2]
[]
["i",null,null,null,null,null,null,"INDICATORS"]
[]
["i",null,null,null,null,null,"Producers have records of costs and income ","Producers have records of main costs and income.","There is no record keeping in place at all."]
[null,null,null,null,null,null,"And","Or","Or"]
["i",null,null,null,null,null,"Managing Entity provides training to producers to understand use of records on costs and income.\n","In absence of records at small holder level, producer can explain main coffee costs and income verbally. Producers are being trained on how to keep records of main costs and income, and understand and agree to start recording.","                                                                                   Producers are not aware of their main costs (such as labour and/or inputs) and the price at which they have been selling their coffee."]
[null,null,null,null,null,null,"And"]
["i",null,null,null,null,null,"Managing Entity makes analysis of costs and income at farm level and uses this information to train producers."]
[]
[null,null,"SUPPORTING COFFEE FARMERS"]
[]
[]
["c",null,"Economic dimension","Access to services","1.4","Based on producer needs, the ME provides or facilitates the provision of services in order to produce coffee following sustainability practices ","Producers have access to adequate services based on their needs.","Producers have access to services that partially address their main needs.","Producers do not have access to any services and needs have not been identified.","Managing Entity and Business Partners"]
[1,null,null,null,null,null,2]
[]
["i",null,null,null,null,null,null,"INDICATORS"]
[]
["i",null,null,null,null,null,"An assessment of the types of services needed by the producers has been conducted.","An assessment of the types of services needed by the producers is being conducted.","The Managing Entity has not  identified the main needs of their Business Partners."]
[null,null,null,null,null,null,"And","And","And"]
["i",null,null,null,null,null,"Business Partners have access to services at market rates such as supply of fertilizers, pesticides, equipment, credit, planting material/seedlings and technical assistance.","Business Partners have access to only some of the services.","Business Partners do not have access to, or information about, any services available."]
[null,null,null,null,null,null,"And"]
[null,null,null,null,null,null,"The Managing Entity actively communicates about these services."]
["i"]
[]
[]
["c",null,"Economic dimension","Market information and commerce","1.5","Market information is accessible within the 4C Unit. Transparent pricing mechanisms reflect coffee quality and sustainable production practices","Coffee quality requirements and market prices are up-to-date, passed on and accessible within the 4C Unit.  Price mechanisms reflect quality of coffee and sustainable production practices. ","Coffee quality requirements and market prices are accessible within the 4C Unit.  Price mechanisms reflect coffee quality.","Coffee quality requirements and market information are not accessible within the 4C Unit. Price mechanisms do not reflect the quality of the coffee.","Managing Entity and Business Partners"]
[1,null,null,null,null,null,2]
[]
["i",null,null,null,null,null,null,"INDICATORS"]
[]
["i",null,null,null,null,null,"Managing Entity regularly provides updated market information to business partners within the 4C Unit, in particular local prices differentiated by quality. \nProducers are aware of price mechanisms according to the coffee quality attributes and sustainable production practices. \n","Managing Entity regularly provides updated market information to business partners within the 4C Unit, in particular local prices differentiated by quality","Business Partners have no access to information about coffee prices and quality requirements or information is not understandable to them."]
[null,null,null,null,null,null,"And","And","And"]
["i",null,null,null,null,null,"Price mechanisms reflect the coffee quality attributes and the 4C sustainability practices.","Producers are aware of price mechanisms according to the coffee quality attributes ","There is no proof that coffee price mechanisms reflect coffee quality attributes. "]
[null,null,null,null,null,null,null,"And"]
["i",null,null,null,null,null,null,"Price mechanisms reflect the coffee quality attributes"]
[]
[]
[]
["c",null,"Economic dimension","Quality","1.6","Coffee quality is monitored within the 4C Unit","Systematic monitoring of quality enables meeting market requirements or national/international export standards. ","First steps are taken to monitor coffee quality against market requirements or national/international export standards.","Coffee quality is not monitored against any standards or requirement within the 4C Unit.","Managing Entity and Business Partners"]
[1,null,null,null,null,null,2]
[]
["i",null,null,null,null,null,null,"INDICATORS"]
[]
["i",null,null,null,null,null,"Systematic quality assessment from farm up to the Managing Entity level is in place. ","Quality specifications have been defined and control is partially implemented. In the case of small farmers, they are aware of the quality parameters. ","There is no control of quality taking place."]
[null,null,null,null,null,null,"And"]
["i",null,null,null,null,null,"Quality assessment is made at each point of the chain "]
[null,null,null,null,null,null,"And"]
["i",null,null,null,null,null,"Green coffee quality is assessed according to moisture content and physical defects at the time of delivery.\nSimilar control is in place for delivery of cherries or parchment.\n"]
[null,null,null,null,null,null,"And"]
["i",null,null,null,null,null,"Proper storage conditions at farm level and along the supply chain within the 4C Unit."]
[]
[]
["c",null,"Economic dimension","Business integrity (transparent business practices)","1.7","Transparent business practices are promoted so that the market is not affected by any preferential treatment based on the offering and receiving of any personal or improper advantage in exchange for retaining business or other advantages","Transparent business practices are actively promoted. ","There is awareness of the need to promote transparent business practices.","No awareness of the need to promote transparent business practices. ","Managing Entity and Business Partners"]
[1,null,null,null,null,null,2]
[]
["i",null,null,null,null,null,null,"INDICATORS"]
[]
["i",null,null,null,null,null,"At ME level a policy on transparent business practices exists and is implemented in order to create a barrier to corruption. \nPolicy emphasises abstaining from offering or receiving personal or improper advantages or gifts in order to retain business or other advantages.\n","At ME level there is awareness of the need for a policy on transparent business practices that emphasises abstaining from offering or receiving personal or improper advantages or gifts in order to retain business or other advantages. ","At ME level there is no policy on transparent business practices."]
["i"]
[]
[]
["c",null,"Economic dimension","Traceability","1.8","Mechanisms for traceability within the 4C Unit are in place","Within the 4C Unit, coffee is clearly identified, segregated, stored, and protected from being mixed with other sources. Written documents are available and operational.","Coffee is traceable within the 4C Unit.","There are no clear procedures to ensure coffee is traceable within the 4C Units.","Managing Entity and Business Partners"]
[1,null,null,null,null,null,2]
[]
["i",null,null,null,null,null,null,"INDICATORS"]
[]
["i",null,null,null,null,null,"4C Compliant Coffee is clearly identified, segregated, stored and protected from being mixed with other sources. ","4C Compliant Coffee is clearly identified along the supply chain.","Coffee from different origins is likely to be mixed without possibility to keep track of 4C Compliant Coffee."]
[null,null,null,null,null,null,"And","And","And"]
["i",null,null,null,null,null,"Standard Operational Procedure of traceability is available and operational.","Every supply chain actor within the 4C Unit knows who they buy their 4C Compliant Coffee from and who buys their 4C Compliant Coffee","There are no clear procedures in place to identify 4C Compliant Coffee."]
[null,null,null,null,null,null,"And","And"]
["i",null,null,null,null,null,"Written documents are available. ","Written documents at Managing Entity are available. "]
["i"]
[]
["r",null,null,null,"RESULTS ECONOMIC  DIMENSION:"]
["r",null,null,null,null,null,null,null,{"$f":"Calculations!I15","v":"AVERAGE YELLOW"}]
[]
["h",null,"SOCIAL DIMENSION"]
[null,null,null,"CATEGORY","NO.","PRINCIPLE","GREEN CRITERIA","YELLOW CRITERIA","RED CRITERIA"]
[null,null,"ALL BUSINESS PARTNERS"]
[]
["C",null,"Social dimension ","Discrimination (ILO Conventions 110, 111, 100)","2.1","Equal rights are secured with respect to gender, maternity, religion, ethnicity, physical conditions and political views","Positive action programmes to secure equal rights are implemented.","Awareness to secure equal rights is raised and concrete steps to develop positive action programmes are evident. ","No positive action to either raise awareness or secure equal rights is evident.","Managing Entity and Business Partners and their permanently or temporarily hired workers "]
[1,null,null,null,null,null,2]
[]
[null,null,null,null,null,null,null,"INDICATORS"]
[]
["i",null,null,null,null,null,"Policy and procedures include grievance mechanisms to secure equal rights exist and are communicated within the 4C Unit.","Policy and procedures to secure equal rights exist and are communicated within the 4C Unit.","No policy or procedures for equal rights exist."]
[null,null,null,null,null,null,"And","And","And"]
["i",null,null,null,null,null,"The policy and procedures are being implemented, i.e. potentially vulnerable groups are identified and efforts have been made in order to explain in further detail the procedures to them, in particular the grievance mechanisms.  There is evidence that this and other actions to remove the obstacles that foster discrimination are being developed.","In case incidents of discrimination, harassment or abusive treatment have occurred, these are being addressed.","Incidents of discrimination, harassment or abusive treatment have occurred."]
[null,null,null,null,null,null,"And"]
["i",null,null,null,null,null,"There is no evidence that equal rights are violated or that harassment or abusive treatment occurs. "]
[]
[]
["c",null,"Social dimension ","Right to childhood and education","2.2","Children have the right to childhood and education. ILO Convention 182, 138 1999","Children’s rights to childhood and education are implemented.","Deliberate efforts to remove children from work and get them into education are evident.","There are no measures to encourage the education of children.","Managing Entity and Business Partners"]
[1,null,null,null,null,null,2]
[]
["i",null,null,null,null,null,null,"INDICATORS"]
[]
["i",null,null,null,null,null,"All children under the age of 15 (or of legal school age) are attending school. ","The majority of the children under the age of 15 (or of legal school age) are attending school. ","The majority of the children under the age of 15 (or of legal school age) are not attending school. "]
[null,null,null,null,null,null,"And","And","And"]
["i",null,null,null,null,null,"Children under the age of 15 (or legal school age) are not part of the regular work force. ","Children under the age of 15 are not part of the regular work force at the Managing Entity, buying and processing facilities or coffee estates. The Managing Entity has identified vulnerable regions or producers where child labour may be happening, encourages farmers to send children to school and raises awareness on young workers (below 18 and above legal school age) to not perform hazardous work. ","Some of the children under the age of 15 are part of the regular work force"]
[null,null,null,null,null,null,"And",null,"And"]
["i",null,null,null,null,null,"Child work is only accepted as part of light family work and outside school hours for children below 15 years old and they are not performing hazardous work. ",null,"No awareness on the educational needs of children within the 4C Unit is evident. "]
[null,null,null,null,null,null,"And","And","And"]
[null,null,null,null,null,null,"There are measures to improve the educational situation within the 4C Unit.","Child work is only accepted as part of light family work and outside school hours for children below 15 years old","No efforts to facilitate access to education are evident"]
["i"]
[null,null,"WORKERS"]
[]
[]
["c",null,"Social dimension ","Freedom of Association","2.3","Workers and producers have the right to found, to belong to and to be represented by an independent organisation of their choice","Resources, information and institutional structures are available to improve representation of workers and farmers by their organisation.","Right to found, belong to and to be represented by an independent organisation of free choice is accepted and easy access to it exists.","Organisations exist but are not accepted as valid counterparts / interlocutors.\n\n","Managing Entity and Business Partners with Permanently hired workers.  \nBusiness Partners who wish to join an organization\n"]
[1,null,null,null,null,null,2]
[]
["i",null,null,null,null,null,null,"INDICATORS"]
[]
["i",null,null,null,null,null,"Workers and producers declare that they are free to form and join independent organizations for the purpose of protecting their interests (such as trade unions and labour organizations for workers, and federations, associations, farmer groups for producers). ","A process has been started to enable workers, producers and representatives of independent organizations to freely join independent organizations for the purpose of protecting their interests.","Organisations exist, but no indications of any process or programme to enable workers and producers to freely join independent organisations are evident."]
[null,null,null,null,null,null,"And","And","And"]
["i",null,null,null,null,null,"Representatives of independent organizations are guaranteed access to the information and resources necessary to carry out their functions.","Representatives of independent organizations have access to the information and resources necessary to carry out their functions.","Representatives of independent organizations have no guaranteed access to the information and resources necessary to carry out their functions."]
[null,null,null,null,null,null,"And","And","And"]
["i",null,null,null,null,null,"No cases of discrimination, adverse action against or exclusion of members of independent organizations by Managing Entity, employer or other workers.","No cases of discrimination, adverse action against or exclusion of members of independent organizations by Managing Entity, employer or other workers. ","Cases of discrimination or adverse actions against members of independent organizations (other than trade unions) still occur."]
[]
[]
["c",null,"Social dimension ","Right to collective bargaining","2.4","Workers have the right to bargain collectively","Collective bargaining results are applied to all workers.","Trade Unions and / or worker’s organisations can bargain collectively. Bargaining results are applied to some workers.","The right to and the outcomes of collective bargaining are ignored.","Managing Entity and Business Partners with permanently hired workers "]
[1,null,null,null,null,null,2]
[]
["i",null,null,null,null,null,null,"INDICATORS"]
[]
["i",null,null,null,null,null,"Regular consultations between employers and authorised workers’ representatives concerning working conditions, remuneration, dispute resolution, internal relations and matters of mutual concern relating to all workers are taking place. ","Consultations between employers and authorised workers’ representatives are taking place. ","Consultations are not accepted by employer. "]
[null,null,null,null,null,null,"And","And","Or"]
["i",null,null,null,null,null,"Results of collective bargaining are applied to all workers.","Results of collective bargaining are partially applied.","Results of collective bargaining are being ignored."]
[]
[]
["c",null,"Social dimension ","Working Conditions – Labour contract","2.5","Workers receive a labour contract and know their rights","All workers receive written labour contracts. Contractual agreements are adhered to.","Informal but transparent contractual agreements are used and implemented. ","Contractual agreements with workers are not implemented or adhered to.","Managing Entity and Business Partners with permanently or temporarily hired workers"]
[1,null,null,null,null,null,2]
[]
["i",null,null,null,null,null,null,"INDICATORS"]
[]
["i",null,null,null,null,null,"Written labour contracts for all workers are available.","At least verbal contractual agreements for all workers exist. Workers know their rights and duties.  ","There are complaints from workers or from their legal representatives or organizations that contractual agreements are not respected."]
[null,null,null,null,null,null,"And","And"]
["i",null,null,null,null,null,"All workers have a copy of their labour contracts.","Contractual agreements are being implemented.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    ","\n\n"]
[null,null,null,null,null,null,"And"]
[null,null,null,null,null,null,"Contractual agreements are adhered to."]
[]
[]
["c",null,"Social dimension ","Working Conditions – Working hours","2.6","Working hours comply with national laws / international conventions and/or collective bargaining and overtime work is remunerated","Working hours comply with national laws / international conventions and/or collective bargaining and overtime is fully remunerated.","Working hours comply with national laws/international conventions and working hours are recorded individually.","Working hours do not comply with national laws / international conventions and overtime is not remunerated.","Managing Entity and Business Partners with permanently or temporarily hired workers "]
[1,null,null,null,null,null,2]
[]
["i",null,null,null,null,null,null,"INDICATORS"]
[]
["i",null,null,null,null,null,"The working time of all workers and employees does not exceed 48 hours weekly or fewer if provided by national law.","Regular working hours of workers and employees are limited to 48 per week or fewer if provided by national law. For some specific jobs, e.g. watchmen, more than 48 hours per week may be acceptable if specifically allowed by national law.  ","Regular working hours of workers and employees exceed 48 hours per week or provision of national or local law."]
[null,null,null,null,null,null,"And","And","And"]
["i",null,null,null,null,null,"Overtime is voluntary, infrequent, and fully remunerated according to national law and paid in due time. Overtime is agreed with workers but it does not exceed 12 hours per week. Exception to this may only happen for a maximum 2 months during peak season. ","Overtime is paid according to national law.    ","Workers declare that overtime is not paid for, irregular and / or not voluntary."]
[null,null,null,null,null,null,"And","And","And"]
[null,null,null,null,null,null,"Documentation of working hours and voluntary overtime for individual workers is available.   ","Working hours of permanent workers are recorded. ","Working hours are not recorded."]
[null,null,null,null,null,null,null,"And"]
[null,null,null,null,null,null,null,"Workers enjoy at least one free day following six consecutive days worked as well as public and annual holidays."]
[]
[]
["c",null,"Social dimension ","Working Conditions – Wages","2.7","Wages comply with national laws or sector agreements","Living wages or wages above existing national minimum wages or sector agreements are paid.","Wages comply with existing national minimum wages or sector agreements.","Wages are below existing national minimum wages or sector agreements.","Managing Entities and Business Partners with permanently hired workers.  \nFor temporarily hired workers see 2.9\n"]
[1,null,null,null,null,null,2]
[]
["i",null,null,null,null,null,null,"INDICATORS"]
[]
["i",null,null,null,null,null,"Living wages or wages of all workers and employees are above existing national minimum wages or sector agreements, whichever is higher. ","Minimum wages or sector agreements, whichever is higher, are paid.","Wages paid are below national minimum or sector agreements. "]
[null,null,null,null,null,null,"And"]
["i",null,null,null,null,null,"Wages are paid in time/ as stated in the labour agreement."]
[null,null,null,null,null,null,"And"]
["i",null,null,null,null,null,"Payment records or payslips for all workers and employees are available."]
[]
[]
["c",null,"Social dimension ","Working Conditions – Seasonal and piece rate workers","2.8","Equitable treatment of seasonal and piece rate workers","Seasonal and piece rate workers are equitably treated.","Seasonal and piece rate workers receive minimum wage but get no other benefit.","Seasonal and piece rate workers do not get the equivalent of minimum wages in normal working hours and have no access to other benefits.","Managing Entity and Business Partners"]
[1,null,null,null,null,null,2]
[]
["i",null,null,null,null,null,null,"INDICATORS"]
[]
["i",null,null,null,null,null,"Piece rate payment systems are monitored to ensure that the total salary paid is at least equivalent to national or sector minimum wages (whichever is higher) and proportional to wages paid to other workers for equivalent working time.  ","Piece rate payments are monitored to ensure that daily earnings are at least equivalent to national or sector minimum wages (whichever is higher) for equivalent working time .","Piece rate payment systems are lower than national or sector minimum wages.\n\n"]
[null,null,null,null,null,null,"And","And","And"]
["i",null,null,null,null,null,"Seasonal and piece rate workers receive the same benefits as other workers (e.g. housing, food, transport, hygiene).","Seasonal and piece rate workers do not receive other benefits (e.g. housing, food, transport, hygiene).","Seasonal and piece rate workers do not receive other benefits."]
[null,null,null,null,null,null,"And"]
["i",null,null,null,null,null,"Records/documentation regarding working hours and wages are available."]
[]
[]
["c",null,"Social dimension ","Working Conditions – Occupational Health and Safety","2.9","Employer assures proper occupational health and safety conditions for workers","A health and safety programme is fully implemented and a monitoring system is in place.","A health and safety programme exists, and a start has been made in its monitoring and implementation.","No health and safety programme exists. Unhealthy and dangerous working conditions are evident.","Managing Entity and Business Partners with hired workers (temporary or permanent)"]
[1,null,null,null,null,null,2]
[]
["i",null,null,null,null,null,null,"INDICATORS"]
[]
["i",null,null,null,null,null,"Risk Assessment is carried out including the identification and evaluation of hazards.","A Risk Assessment is carried out including identification and prioritization.","There is no evidence of protection measures or awareness of health and safety risks among staff and workers."]
[null,null,null,null,null,null,"And","And","And"]
[null,null,null,null,null,null,"A health and safety programme, including procedures, equipment, responsibilities and monitoring is implemented. ","Procedures and equipment to minimize risks and ensure healthy and safe working conditions and practices (e.g. in relation to pesticides, machinery and heavy loads) are known but not always available or used. ","Unhealthy and dangerous working conditions are evident. "]
[null,null,null,null,null,null,"And"]
[null,null,null,null,null,null,"Workers are well informed and trained on health and safety issues (incl. an emergency kit and (a) persons trained in first aid). "]
[null,null,null,null,null,null,"And","And"]
[null,null,null,null,null,null,"Appropriate equipment and gear, including personal protection equipment are available, well maintained, and clean.","Workers are aware of safe practices "]
[null,null,null,null,null,null,"And","And"]
[null,null,null,null,null,null,"Safe facilities are available.","Monitoring is being implemented. A health and safety programme is documented. Small farmers may not have a documented program but do know the main risks and implement measures to address them - including measures for personal protection. \n"]
[null,null,null,null,null,null,"And"]
[null,null,null,null,null,null,"Hazardous wastes are safely collected and measures for safe disposal are taken."]
[null,null,null,null,null,null,"And"]
[null,null,null,null,null,null,"Workers are fully aware of, and sufficiently protected against, dangerous machinery, unhealthy working situations, chemicals and other risks.  "]
[]
[null,null,null,null," RESULTS SOCIAL DIMENSION:"]
[null,null,null,null,null,null,null,null,{"$f":"Calculations!I30","v":"AVERAGE YELLOW"}]
["h"]
[null,null,"ENVIRONMENTAL DIMENSION"]
[null,null,null,"CATEGORY","NO.","PRINCIPLE","GREEN CRITERIA","YELLOW CRITERIA","RED CRITERIA"]
[]
["c",null,"Environmental dimension","Conservation of Biodiversity","3.1","Conservation of biodiversity, including protected or endangered native flora and fauna is supported","A program of conservation and enhancing wildlife and native flora is developed and implemented. ","Conservation actions are being taken and awareness is being raised in relation to endangered and protected species and native flora.","Exploitation of native flora and fauna is practiced.","Managing Entity and Business Partners "]
[1,null,null,null,null,null,2]
[]
["i",null,null,null,null,null,null,"INDICATORS"]
[]
[null,null,null,null,null,null,"Each individual farm has a map indicating land use. ","Maps are being developed.\n\n","No awareness within the 4C Unit of the importance of biodiversity and lack of knowledge on endangered species of animals and plants in the region."]
[null,null,null,null,null,null,"And","And","And"]
[null,null,null,null,null,null,"A general map of the Unit´s land use exists.","Managing Entity has identified the main sensitive areas within the 4C Unit  ","No measures to protect or enhance native plants and fauna are taken.\n\n"]
[null,null,null,null,null,null,"And","And","And"]
[null,null,null,null,null,null,"There are measures and actions in the  conservation or restoration of natural vegetation and fauna and protection of sensitive areas (slopes, river banks, wetlands) ","No hunting or extraction of endangered species of animals and plants is practiced. In case small holders are hunting or collecting endangered species, there is evidence of activities to raise their awareness on conservation.","Hunting or extraction of endangered species of animals and plants is evident."]
[]
["i"]
[]
[]
["c",null,"Environmental dimension","Use of pesticides  ","3.2","Use of pesticides is minimised and integrated pest, weed and disease management is improved with time","Pest control methods integrate biological, cultural and physical approaches and decision on pesticide use is based on monitoring of pests, diseases and weeds.\nPesticides in the 4C Red List are not used and pesticides in the 4C Yellow List are not used or are minimized.\n","Steps are taken to monitor pest, disease and weed levels, and at least one method to reduce use of pesticides is implemented.\nPesticides in the 4C Red List are not used. Pesticides in the 4C Yellow List may be in use.\n","There is no system in place to minimise the use of pesticides.\nPesticides in the 4C Red List are being used.\n","Managing Entity and Business Partners "]
[1,null,null,null,null,null,2]
[]
["i",null,null,null,null,null,null,"INDICATORS"]
[]
["i",null,null,null,null,null,"An integrated pest management (IPM) system is documented and being implemented.","An integrated pest management – IPM- system is being developed: farmers monitor their crop for pest, weeds and diseases and are aware of preventive measures and potential control techniques which are not chemical. ","There is no (integrated) pest management system.  Farmers are not aware of preventive measures or of potential non-chemical controls"]
[null,null,null,null,null,null,"And","And","And"]
[null,null,null,null,null,null,"Pesticides in the 4C Red List are not used.  Pesticides in 4C Yellow List are avoided if possible.  Use of all pesticides is minimized as provided by evidence of records and IPM replacements.  ","Pesticides in the 4C Red List are not used.","Pesticides in the 4C Red List are being used."]
[null,null,null,null,null,null,"And","And","And"]
[null,null,null,null,null,null,"Records of types and rates of all pesticides used are kept. ","The Managing Entity has knowledge on the type of the pesticides used by its Business Partners.\n\n","The Managing Entity has limited knowledge of the pesticides used by its Business Partners "]
[null,null,null,null,null,null,"And","And","And"]
["i",null,null,null,null,null,"There is evidence that training on IPM is provided to farmers and workers and a manual is available.","At farm level, records of types of pesticides used are incomplete, or in the case of small holders, no records are kept","No records are kept."]
[]
[]
["c",null,"Environmental dimension","Handling of pesticides and other hazardous chemicals","3.3","Harmful effects of pesticides and other hazardous chemicals on human health and the environment are minimised","Pesticides and other hazardous chemicals are stored, applied and disposed of in the least hazardous manner for human health and the environment.","A plan for handling pesticides and other hazardous chemicals referring to application, storage and disposal is formulated. Steps are taken to avoid the most hazardous application, storage and disposal practices.","Pesticides and other hazardous chemicals are stored, applied and disposed of in a hazardous manner for human health and the environment.","Managing Entity and Business Partners "]
[1,null,null,null,null,null,2]
[]
["i",null,null,null,null,null,null,"INDICATORS"]
[]
["i",null,null,null,null,null,"A plan for applying, storing and disposing pesticides and other hazardous chemicals is available","A plan for applying, storing and disposing pesticides and other hazardous chemicals is available, including identification of critical points and measures to reduce risks. ","No measures are taken to apply, store and dispose of pesticides and other hazardous chemicals properly according to national and/or local legislation, and manufacturers´ instructions and ILO recommendations.\n\n"]
[null,null,null,null,null,null,"And","And","And"]
["i",null,null,null,null,null,"All pesticides and other hazardous chemicals are properly applied, stored and disposed of by trained personnel using personal protective equipment, according to national and/or local legislation, manufacturers´ instructions and ILO recommendations.","People handling pesticides and other hazardous chemicals are being trained on proper handling (including application, storage and disposal). The Managing Entity is aware of national and/ or local legislation, manufacturers’ instructions and ILO recommendations. Workers handling pesticides, are given personal protection equipment.  In the case of smallholders, hazard awareness is being raised and they have started to take measures for personal protection. ","Farmers are unaware of the  hazardous nature of the pesticides and chemicals they are using."]
[null,null,null,null,null,null,"And","And"]
["i",null,null,null,null,null,"Personal protective equipment is controlled and ensured it is in good state for smallholders as well as larger farms. ","Pesticides and fertilisers are properly stored away from reach of non-trained people and to avoid polluting the environment. "]
[]
[]
["c",null,"Environmental dimension","Soil  Conservation","3.4","Soil conservation practices are in place","Soil is protected from erosion by adequate soil conservation measures. ","Soil conservation measures have been started.","Practices that contribute to soil erosion are evident.","Managing Entity and Business Partners who grow coffee"]
[1,null,null,null,null,null,2]
[]
["i",null,null,null,null,null,null,"INDICATORS"]
[]
["i",null,null,null,null,null,"Soil conservation measures to protect soil from erosion are in place with vegetation and/or plant residues and/or minimum tillage and other soil conservation techniques.\nIn case there are signs of erosion actions have been implemented to control erosion and restore the soil.\n","Some measures are taken to protect soil from erosion.\n\nIn case there are signs of erosion, there is a plan to implement measures to control erosion and to restore the soil. At small holder level, plans can be verbally explained.\n","No measures are taken to protect soil from erosion, where applicable."]
[null,null,null,null,null,null,null,null,"And"]
["i",null,null,null,null,null,null,null,"Practices that contribute to soil erosion are evident. "]
[]
[]
["c",null,"Environmental dimension","Soil Fertility and nutrient management – Fertilisers ","3.5","Mineral and/or organic fertilisers are used in a balanced and appropriate way","Application of fertilisers is in accordance with the needs of the crop based on soil and or leaf analysis. ","Application of fertilisers is based on a technical recommendation. ","Excessive or no use of fertilisers is evident.","Managing Entity and Business Partners "]
[1,null,null,null,null,null,2]
[]
["i",null,null,null,null,null,null,"INDICATORS"]
[]
["i",null,null,null,null,null,"Soil and/or leaf analysis is done and documented.","There is some use of mineral and/or organic fertilisers ","There is evidence of excessive or no use of fertilisers. "]
[null,null,null,null,null,null,"And","And","And"]
[null,null,null,null,null,null,"The use of mineral and/or organic fertilisers is according to soil and or leaf analysis and expected yield. ","Technical recommendations from a credible institution for balanced and appropriate application of fertilisers are available but not necessarily implemented ","Managing Entity is not aware on proper nutrition needs as on average for its supply chain. "]
[null,null,null,null,null,null,"And"]
[null,null,null,null,null,null,"There is awareness within the 4C Unit of the need to reduce the use of acidifying Nitrogen fertilizers in order to avoid further soil acidification "]
[null,null,null,null,null,null,"And"]
["i",null,null,null,null,null,"Fertilisation is documented."]
[]
[]
[null,null,"Environmental dimension","Soil Fertility and nutrient management – Organic matter","3.6","Maintenance of organic matter in the soil is promoted","Organic matter is reused and recycled and partially replaces mineral fertiliser.","Organic matter is reused and recycled.","Wasteful and improper disposal of organic matter.","Managing Entity and Business partners who are coffee processors or coffee growers "]
[null,null,null,null,null,null,2]
[]
[null,null,null,null,null,null,null,"INDICATORS"]
[]
[null,null,null,null,null,null,"Organic waste materials are recycled and considered as a nutrient supply and/or practices to increase fertility are in place, e.g. soil is covered with leaf litter or organic mulch, there are shade trees and /or boundary plants.   ","Some organic waste materials including coffee pulp and husk are recycled and/or practices to increase fertility are in place, e.g. soil is covered with leaf litter or organic mulch, there are shade trees and /or boundary plants.  ","Organic waste materials are not recycled or reused as fertilizer. "]
[null,null,null,null,null,null,"And","And"]
[null,null,null,null,null,null,"Central coffee processors and service providers return or make available to coffee farmers the organic matter from coffee processing (processed waste), if economically feasible and considering plant health risks.   ","Central coffee processors and service providers start to implement efforts to return or make available to coffee farmers the organic matter from coffee processing, if economically feasible and considering plant health risks."]
[]
[]
[null,null,"Environmental dimension","Water – water sources ","3.7","Water resources are conserved and used efficiently","Necessary steps are taken to conserve water resources.","Water conservation practices are implemented."," Overuse of water sources.","Managing Entity and Business partners who are coffee processors or coffee growers "]
[null,null,null,null,null,null,2]
[]
[null,null,null,null,null,null,null,"INDICATORS"]
[]
[null,null,null,null,null,null,"Water sources have been identified and are conserved by recycling, by using less amounts that might not endanger its sustainability.  ","Water sources have been identified and some measures to conserve water sources are implemented. In the case of smallholders they are being trained in conservation of water sources.","Water sources are not conserved."]
[null,null,null,null,null,null,"And","And","And"]
[null,null,null,null,null,null,"Managing Entity is in dialogue with other stakeholders to coordinate conservation efforts for those sources which are known or considered to be in critical stage or overused ","Managing Entity is aware of sources which are known or considered to be in critical stage or overused.","No evidence of awareness of efficient water use."]
[null,null,null,null,null,null,"And","And"]
[null,null,null,null,null,null,"Water for coffee processing and irrigation is used efficiently. In the case of smallholders, there is evidence that the Managing Entity is facilitating trainings on more efficient use of water. At the processing level use of water is be measured and documented to show efficient use. ","Some measures to reduce water use are implemented. In the case of smallholders, these are being trained in efficient irrigation and processing, if applicable.  At central processing level use of water is being measured and efforts made to make efficient use."]
[]
[]
[null,null,"Environmental dimension","Water – wastewater ","3.8","Wastewater management is in place","Wastewater is treated and the discharged load of contaminants is minimized.","Untreated wastewater is not directly discharged into water courses.","Untreated wastewater is discharged directly into water courses.","Managing Entity and Business partners who are coffee processors or coffee growers "]
[null,null,null,null,null,null,2]
[]
[null,null,null,null,null,null,null,"INDICATORS"]
[]
[null,null,null,null,null,null,"Wastewater from central processing facilities and from workers’ housing sewage is not being discharged directly into water courses.","Wastewater from central processing facilities and from workers’ housing sewage is not being discharged directly into water courses","Wastewater from wet processing and sewage is being discharged directly into water course ."]
[null,null,null,null,null,null,"And","And","And"]
[null,null,null,null,null,null,"Wastewater treatment system for wet processing and sewage is in place. ","Actions exist to minimize wastewater pollution from wet processing and sewage. ","No development of any wastewater treatment system is evident. "]
[null,null,null,null,null,null,"And","And","And"]
[null,null,null,null,null,null,"Treated wastewater complies with parameters specified in national/local legislation before being discharged and analysis results are available. \nCentral washing stations analyse treated wastewater once per harvesting season and this confirms to national legislations before being discharged and analysis results are available.\n","There is evidence of awareness of the importance of wastewater treatment among coffee producers dealing with wastewater from wet processing and with sewage. ","There is no evidence of awareness of importance of wastewater treatment among Business Partners dealing with wastewater."]
[null,null,null,null,null,null,"And"]
[null,null,null,null,null,null,"All Business Partners dealing with wastewater are aware of importance of its treatment."]
[]
[]
[null,null,"Environmental dimension","Waste ","3.9","Safe waste management is in place","Waste generation is minimized, reuse and recycling is maximized. Safe disposal of hazardous waste is ensured.","Safe disposal of hazardous waste is practiced. Steps are taken to improve waste management.","Hazardous waste is disposed of unsafely. No management system is in place. ","Managing Entity and Business Partners "]
[null,null,null,null,null,null,2]
[]
[null,null,null,null,null,null,null,"INDICATORS"]
[]
[null,null,null,null,null,null,"Different types of waste generated within the 4C Unit are identified.","Hazardous wastes are identified.","Hazardous wastes are disposed of without consideration of possible contamination of the environment."]
[null,null,null,null,null,null,"And","And","And"]
[null,null,null,null,null,null,"Reuse, recycling and safe disposal is in place and according to the different types of waste.  ","Hazardous wastes are safely disposed of in order to prevent contamination of water and soil resources as well as harm to human beings and animals.","\nThere is no minimization, re-use and recycling of waste. \n"]
[null,null,null,null,null,null,null,"And"]
[null,null,null,null,null,null,null,"Steps are taken to minimise waste. "]
[null,null,null,null,null,null,null,"And"]
[null,null,null,null,null,null,null,"Steps are taken to maximize re-use and recycling, including starting to separate wastes according to the different types.  "]
[]
[]
["c",null,"Environmental dimension","Energy","3.10","Saving Energy and preferential use of renewable energy","Energy use is monitored and evaluated regularly. Minimization of energy use is evident.  The use of renewable energy sources is maximized. ","Use of energy is regularly eva-luated and first steps towards energy efficiency and alternative op¬tions are implemented.  Options for use of renewable energy are assessed and implementation is planned if appropriate. ","Wasteful use of energy as input for coffee processing is evident and renewable sources are not known.","Managing Entity and Business Partners who are central coffee processing facilities "]
[1,null,null,null,null,null,2]
[]
["i",null,null,null,null,null,null,"INDICATORS"]
[]
["i",null,null,null,null,null,"Energy use in coffee processing is quantified and documented.","Energy use in coffee processing is quantified.","No measures are taken to reduce energy use and improve energy efficiency."]
[null,null,null,null,null,null,"And","And","And"]
[null,null,null,null,null,null,"Optimization or reduction of energy use and improvement of energy efficiency is evident.","Some measures are taken to reduce energy use and improve energy efficiency. ","Knowledge of the availability of potential renewable sources is lacking. "]
[null,null,null,null,null,null,"And","And"]
["i",null,null,null,null,null,"Renewable energy sources are used if available","Potential renewable energy sources have been identified and their use is being evaluated or some renewable energy sources are used if available."]
["h",null,null,null,null,null,null,null," RESULTS ENVIRONMENTAL DIMENSION:"]
[null,null,null,null,null,null,null,null,{"$f":"Calculations!I43","v":"AVERAGE YELLOW"}]
[]
[null,null,null,null,null,null,null,null,"Overall results of all 3 dimensions:"]
[null,null,null,null,null,null,null,"Economic",{"$f":"Calculations!I45","v":"AVERAGE YELLOW"}]
[null,null,null,null,null,null,null,"Social",{"$f":"Calculations!I46","v":"AVERAGE YELLOW"}]
[null,null,null,null,null,null,null,"Environmental",{"$f":"Calculations!I47","v":"AVERAGE YELLOW"}]

{"sheet":"3. LIST OF TRAININGS","index":3,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[3,1,3,7],[2,1,2,7],[1,1,1,7],[4,1,4,3]]}
[]
[null,"LIST OF TRAININGS                                                                                                                 "]
[null,"              The purpose of this sheet is to collect information on trainings that 4C Unit Business Partners may have received over the past 12 months\nPlease start by answering three general opening questions, before completing the table below.         \n"]
[]
[null,"I: DID THE BUSINESS PARTNERS IN YOUR UNIT RECEIVE ANY TRAININGS OVER THE LAST 12 MONTHS?"]
[null,"II: TOTAL NUMBER OF TRAINING EVENTS:"]
[null,"III: TOTAL NUMBER OF INDIVIDUAL BUSINESS PARTNERS TRAINED:"]
[]
[]
[null,"Main topic of the training                                             Please Describe","Date of the training","Category of the training                                Select from dropdown menu","No of BPs who participated in the training","Did the Managing Entity give the training?              ","If column e = \"no\", what is the name of the organization that gave the training? ","Did the Managing Entity finance the training?              "]
[null,"Example: Creating composting pits","Example: 31/12/2016","GAPS (agricultural innovative techniques and sustainable practices)",456,"No","Sublime Coffee Services","Yes"]

{"sheet":"4. PESTICIDE REPORT","index":4,"n_rows":184,"n_cols":12,"rows_kept":184,"cut":false,"hidden":false,"merged":[[0,0,0,11],[1,0,1,11],[3,0,4,0],[3,2,4,2],[3,3,4,5],[3,6,4,6],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,3,11],[3,1,4,1]]}
["4C Annual Pesticide Report "]
["In this sheet, 4C Units are required to report on the pesticide use of their 4C Business Partners to the best of their knowledge.\nThe 4C Pesticide Report is to be completed by the 4C Unit’s Managing Entity. It needs to be updated annually (after initial verification). Together with sheets 1,2,3,4 and 7 of the 4C Assessment Tool, the Business Partner Mapping and the Organizational Plan it constitutes the obligatory Annual Update.\n"]
[]
["Pesticide Name (Active Ingredient)","Legend\nRed: Red List\nYellow: Yellow List\nGrey: Unacceptables List","1. Is this active ingredient used by your Business Partners? \nYes/No","2. Pesticide Name (Commercial)",null,null,"3. What is this pesticide used to control?","4. How often is this pesticide used? ","5. Approximately how many farmers use this pesticide in the 4C Unit or farmer group?","6. How much pesticide is used?","7. Information on measures to reduce pesticide risks "]
[null,null,null,null,null,null,null,null,null,null,"7a. What measures do farmers take to reduce the risk of exposing themselves or others to pesticides?","7b. What measures do farmers take to avoid contaminating water courses, wells and soil or drifting beyond the target area?"]
["Abamectin","Abamectin"]
["Acephate","Acephate"]
["Acrolein","Acrolein"]
["Alachlor","Alachlor"]
["Aldicarb","Aldicarb"]
["Alpha-Bhc;Alpha-Hch","Alpha-Bhc;Alpha-Hch"]
["Alpha-Chlorohydrin","Alpha-Chlorohydrin"]
["Aluminum Phosphide","Aluminum Phosphide"]
["Amitrole","Amitrole"]
["Anthracene Oil","Anthracene Oil"]
["Arsenic And Its Compounds","Arsenic And Its Compounds"]
["Atrazine","Atrazine"]
["Azafenidin","Azafenidin"]
["Azinphos-Ethyl","Azinphos-Ethyl"]
["Azinphos-Methyl","Azinphos-Methyl"]
["Azocyclotin","Azocyclotin"]
["Beta-Cyfluthrin; Cyfluthrin","Beta-Cyfluthrin; Cyfluthrin"]
["Beta-Hch; Beta-Bch","Beta-Hch; Beta-Bch"]
["Bifenthrin","Bifenthrin"]
["Blasticidin-S","Blasticidin-S"]
["Borax; Disodium Tetraborate Decahydrate","Borax; Disodium Tetraborate Decahydrate"]
["Boric Acid","Boric Acid"]
["Brodifacoum","Brodifacoum"]
["Bromadiolone","Bromadiolone"]
["Bromethalin","Bromethalin"]
["Bromoxynil","Bromoxynil"]
["Butoxycarboxim","Butoxycarboxim"]
["Cadusafos","Cadusafos"]
["Captafol","Captafol"]
["Carbaryl","Carbaryl"]
["Carbendazim","Carbendazim"]
["Carbofuran","Carbofuran"]
["Carbosulfan","Carbosulfan"]
["Chlorantraniliprole","Chlorantraniliprole"]
["Chlordane","Chlordane"]
["Chlorethoxyphos","Chlorethoxyphos"]
["Chlorfenapyr","Chlorfenapyr"]
["Chlorfenvinphos","Chlorfenvinphos"]
["Chlormephos","Chlormephos"]
["Chlorophacinone","Chlorophacinone"]
["Chloropicrin","Chloropicrin"]
["Chlorothalonil","Chlorothalonil"]
["Chlorotoluron","Chlorotoluron"]
["Chlorpyrifos","Chlorpyrifos"]
["Clothianidin","Clothianidin"]
["Coumaphos","Coumaphos"]
["Coumatetralyl","Coumatetralyl"]
["Creosote","Creosote"]
["Cyhalothrin (Not Lambda)","Cyhalothrin (Not Lambda)"]
["Cyhalothrin, Gamma","Cyhalothrin, Gamma"]
["Daminozide","Daminozide"]
["Ddt","Ddt"]
["Deltamethrin","Deltamethrin"]
["Demeton-S-Methyl","Demeton-S-Methyl"]
["Dichlorvos; Ddvp","Dichlorvos; Ddvp"]
["Dicrotophos","Dicrotophos"]
["Difenacoum","Difenacoum"]
["Difethialone","Difethialone"]
["Dimethoate","Dimethoate"]
["Dimoxystrobin","Dimoxystrobin"]
["Dinocap","Dinocap"]
["Dinotefuran","Dinotefuran"]
["Dinoterb","Dinoterb"]
["Diphacinone","Diphacinone"]
["Diquat Dibromide","Diquat Dibromide"]
["Diquat Dichloride","Diquat Dichloride"]
["Disulfoton","Disulfoton"]
["Diuron","Diuron"]
["Dnoc And Its Salts","Dnoc And Its Salts"]
["Edifenphos","Edifenphos"]
["Endosulfan","Endosulfan"]
["E-Phosphamidon","E-Phosphamidon"]
["Epichlorohydrin","Epichlorohydrin"]
["Epn","Epn"]
["Epoxiconazole","Epoxiconazole"]
["Ethiofencarb","Ethiofencarb"]
["Ethoprophos; Ethoprop","Ethoprophos; Ethoprop"]
["Ethylene Dibromide (Edb: 1,2-Dibromoethane) ","Ethylene Dibromide (Edb: 1,2-Dibromoethane) "]
["Ethylene Dichloride (Edc)","Ethylene Dichloride (Edc)"]
["Ethylene Oxide","Ethylene Oxide"]
["Ethylene Thiourea","Ethylene Thiourea"]
["Famphur","Famphur"]
["Fenamiphos","Fenamiphos"]
["Fenbutatin-Oxide","Fenbutatin-Oxide"]
["Fenchlorazole-Ethyl","Fenchlorazole-Ethyl"]
["Fenitrothion","Fenitrothion"]
["Fenoxycarb","Fenoxycarb"]
["Fenpropathrin","Fenpropathrin"]
["Fenthion","Fenthion"]
["Fentin Acetate","Fentin Acetate"]
["Fentin Hydroxide","Fentin Hydroxide"]
["Fenvalerate","Fenvalerate"]
["Fipronil","Fipronil"]
["Flocoumafen","Flocoumafen"]
["Fluazifop-Butyl","Fluazifop-Butyl"]
["Flucythrinate","Flucythrinate"]
["Flumioxazin","Flumioxazin"]
["Fluoroacetamide","Fluoroacetamide"]
["Flusilazole","Flusilazole"]
["Formaldehyde","Formaldehyde"]
["Formetanate","Formetanate"]
["Furathiocarb","Furathiocarb"]
["Glufosinate-Ammonium","Glufosinate-Ammonium"]
["Haloxyfop-Methyl; Haloxyfop","Haloxyfop-Methyl; Haloxyfop"]
["Heptenophos","Heptenophos"]
["Hexachlorobenzene (Hcb)","Hexachlorobenzene (Hcb)"]
["Hexachlorocyclohexane  (Hch)","Hexachlorocyclohexane  (Hch)"]
["Imidacloprid","Imidacloprid"]
["Isoxathion","Isoxathion"]
["Lambda-Cyhalothrin","Lambda-Cyhalothrin"]
["Lindane","Lindane"]
["Linuron","Linuron"]
["Magnesium Phosphide","Magnesium Phosphide"]
["Malathion","Malathion"]
["Mancozeb","Mancozeb"]
["Mecarbam","Mecarbam"]
["Mercury And Its Compounds","Mercury And Its Compounds"]
["Methabenzthiazuron","Methabenzthiazuron"]
["Methamidophos","Methamidophos"]
["Methidathion","Methidathion"]
["Methiocarb","Methiocarb"]
["Methomyl","Methomyl"]
["Methyl Bromide","Methyl Bromide"]
["Mevinphos","Mevinphos"]
["Molinate","Molinate"]
["Monocrotophos","Monocrotophos"]
["Nicotine","Nicotine"]
["Nitrobenzene","Nitrobenzene"]
["Omethoate","Omethoate"]
["Oxamyl","Oxamyl"]
["Oxydemeton-Methyl","Oxydemeton-Methyl"]
["Paraffin Oils; Mineral Oils","Paraffin Oils; Mineral Oils"]
["Paraquat Dichloride","Paraquat Dichloride"]
["Parathion","Parathion"]
["Parathion-Methyl (Methyl Parathion)","Parathion-Methyl (Methyl Parathion)"]
["Pentachlorophenol (Pcp)","Pentachlorophenol (Pcp)"]
["Permethrin","Permethrin"]
["Phorate","Phorate"]
["Phosphamidon","Phosphamidon"]
["Phosphine","Phosphine"]
["Picloram","Picloram"]
["Potasan","Potasan"]
["Profoxydim","Profoxydim"]
["Propargite","Propargite"]
["Propetamphos","Propetamphos"]
["Propylene Oxide","Propylene Oxide"]
["Pyrazophos","Pyrazophos"]
["Pyrazoxon","Pyrazoxon"]
["Quizalofop-P-Tefuryl","Quizalofop-P-Tefuryl"]
["Resmethrin","Resmethrin"]
["Silafluofen","Silafluofen"]
["Sodium Fluoroacetate (1080)","Sodium Fluoroacetate (1080)"]
["Strychnine","Strychnine"]
["Sulfotep","Sulfotep"]
["Tcmtb","Tcmtb"]
["Tebupirimifos","Tebupirimifos"]
["Tefluthrin","Tefluthrin"]
["Tepraloxydim","Tepraloxydim"]
["Terbufos","Terbufos"]
["Thiacloprid","Thiacloprid"]
["Thiamethoxam","Thiamethoxam"]
["Thiodicarb","Thiodicarb"]
["Thiofanox","Thiofanox"]
["Thiometon","Thiometon"]
["Thiourea","Thiourea"]
["Tolylfluanid","Tolylfluanid"]
["Triazophos","Triazophos"]
["Trichlorfon","Trichlorfon"]
["Tridemorph","Tridemorph"]
["Trifluralin","Trifluralin"]
["Vamidothion","Vamidothion"]
["Vinclozolin","Vinclozolin"]
["Warfarin","Warfarin"]
["Zeta-Cypermethrin","Zeta-Cypermethrin"]
["Zinc Phosphide","Zinc Phosphide"]
["Zineb","Zineb"]
["Ziram","Ziram"]
["Z-Phosphamidon","Z-Phosphamidon"]
["",""]

{"sheet":"5. Verifier ONLY- CODE RATING","index":5,"n_rows":44,"n_cols":16,"rows_kept":44,"cut":false,"hidden":false,"merged":[[3,1,4,2],[6,1,6,2],[3,14,4,14],[2,1,2,14],[1,1,1,14],[3,3,3,12],[3,13,4,13],[5,1,5,2]]}
[]
[null,"RATING OF THE SAMPLE AGAINST THE CODE PRINCIPLES - FOR VERIFIERS ONLY"]
[null,"\nThis sheet is completed by verifiers. For each principle in all three dimensions, please evaluate the performance of the Managing Entity and its Business Partners in the sample using the drop-down menu: Use grey fields only! \nIf a principle should not be applicable to any of the assessed Business Partners or the Managing Entity, please leave corresponding cells blank\n"]
[null,null,null,"Individual rating of ME and each BP of sample",null,null,null,null,null,null,null,null,null,"BP n      \n    Add BPs by pressing the \"Insert Column\" button","Comments (Optional)"]
[null,null,null,"ME","BP 1 (Full name)","BP 2 (Full name)","BP 3 (Full name)","BP 4 (Full name)","BP 5 (Full name)","BP 6 (Full name)","BP 7 (Full name)","BP 8 (Full name)","BP 9 (Full name)"]
[null,"ID of the partner, as stated in the BPM"]
[null,"Please write \"yes\" or \"no\" if the BP was visited in the previous Verification"]
[null,null,"Average rating  per principle  filled in automatically"]
[null,"Economic dimension ",null,"Please evaluate on a scale from (1=green, 2=yellow, 3=red)  using the drop-down menu "]
[null,"1.1",{"$f":"IF(ISERROR(AVERAGE(D10:N10)),0,AVERAGE(D10:N10))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"1.2",0,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"1.3",0,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,"1.4",0]
[null,"1.5",0]
[null,"1.6",0]
[null,"1.7",0]
[null,"1.8",0]
[]
[null,null,{"$f":"IF(ISERROR((AVERAGEIF(C10:C17,\"<>0\"))),\"-\",(AVERAGEIF(C10:C17,\"<>0\")))","v":"-"}]
[null,"Social dimension ",null,"Please evaluate on a scale from  to  (1=green, 2=yellow, 3=red) using the drop-down menu "]
[null,"2.1",{"$f":"IF(ISERROR(AVERAGE(D21:N21)),0,AVERAGE(D21:N21))","v":0}]
[null,"2.2",0]
[null,"2.3",0]
[null,"2.4",0]
[null,"2.5",0]
[null,"2.6",0]
[null,"2.7",0]
[null,"2.8",0]
[null,"2.9",0]
[]
[null,null,{"$f":"IF(ISERROR((AVERAGEIF(C21:C29,\"<>0\"))),\"-\",(AVERAGEIF(C21:C29,\"<>0\")))","v":"-"}]
[null,"Environmental dimension ",null,"Please evaluate on a scale from  to  (=green, =yellow, =red) using the drop-down menu "]
[null,"3.1",{"$f":"IF(ISERROR(AVERAGE(D33:N33)),0,AVERAGE(D33:N33))","v":0}]
[null,"3.2",0]
[null,"3.3",0]
[null,"3.4",0]
[null,"3.5",0]
[null,"3.6",0]
[null,"3.7",0]
[null,"3.8",0]
[null,"3.9",0]
[null,"3.10",0]
[]
[null,null,{"$f":"IF(ISERROR((AVERAGEIF(C33:C42,\"<>0\"))),\"-\",(AVERAGEIF(C33:C42,\"<>0\")))","v":"-"}]

{"sheet":"6. Verifier ONLY - SUMMARY","index":6,"n_rows":47,"n_cols":15,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,1,1,13],[2,1,2,13],[3,11,3,13],[6,11,6,13],[18,11,18,13],[18,1,18,10],[6,1,6,10],[7,1,7,3],[3,1,3,3],[3,4,3,10],[8,1,8,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[13,1,13,3]]}
[]
[null,"SUMMARY OF RESULTS - FOR VERIFIERS ONLY"]
[null," This sheet summarizes and compares the results of the 4C Unit's Self Assessment and the assessment done by the verifier(s)\n\n It covers  1.) the Internal Management System 2.) the 10 Unacceptable Practices and 3.) the 27 Code Principles\nColumn E summarizes the results of the Self-Assessment of the 4C Unit \n Column F shows the evaluation results of the verifier, partly entered during the verification visit (IMS and UAP) and partly automatically transferred from sheet 4 (code rating of the sample).                                                                                                                                            \nIf results in column E and F differ, an 'F' for 'finding' will appear in column G and column K will indicate 'yes', implying that an explanation is required in column L.\n"]
[null,"INTERNAL MANAGEMENT SYSTEM",null,null,"                                          ",null,null,null,null,null,null,"CAS V.O. ONLY"]
[null,null,null,null,"Self-Assessment of the 4C Unit","Evaluation by verifier: \nPlease select from drop down list","Adjustment of the verifier result (if applicable)","Finding?","Desription of a risk, if applicable","Explanation is required?","Explanation of the finding: In case of deviation of 4C Unit Self-Assessment & verifier evaluation","CAS V.O. \nInclude additional observation? (please select Yes/No)","Please insert V.O. Evaluation\n(if inserted this will show in tab 7 - column E- Current performance level)","Please insert additional observation:\n(if inserted this will show in tab 7 - column H - Description of risk)"]
[null,null,null,null,{"$f":"IF(Calculations!C47=1,Dropdowns!F9,IF(Calculations!C47=2,Dropdowns!F10,IF(Calculations!C47=3,Dropdowns!F11,\"-\")))","v":"-"},null,null,{"$f":"IF(E6<>F6, \"F\",\"\")","v":"F"},null,{"$f":"IF(E6<>F6, \"Yes\",\"No\")","v":"Yes"},null,"No",null,null,"Yes"]
[null,"UNACCEPTABLE PRACTICES",null,null,null,null,null,null,null,null,null,"CAS V.O. ONLY",null,null,"No"]
[null,null,null,null,"Self-Assessment of the 4C Unit \n(1 = UAP not excluded, 2=UAP  excluded)","Evaluation by verifier: \nPlease select from drop down list (1 = UAP not excluded, 2=UAP  excluded)","Adjustment of the verifier result (if applicable)","Finding?","Desription of a risk, if applicable","Explanation is required?","Explanation of the finding: In case of deviation of 4C Unit Self-Assessment & verifier evaluation","CAS V.O. \nInclude additional observations? (please select Yes/No)","Please insert V.O. Evaluation\n(if inserted this will show in tab 7 - column E- Current performance level)","Please insert additional observation:\n(if inserted this will show in tab 7 - column H - Description of risk)"]
[null,"UAP 1 - Worst forms of child labor",null,null,{"$f":"Calculations!B3","v":2},null,null,{"$f":"IF(E9<>F9, \"F\",\"\")","v":"F"},null,{"$f":"IF(E9<>F9, \"Yes\",\"No\")","v":"Yes"},null,"No"]
[null,"UAP 2 - Forced and bonded labor, trafficking of persons",null,null,{"$f":"Calculations!B4","v":2},null,null,"F",null,"Yes",null,"No"]
[null,"UAP 3 - Prohibition of membership in and representation by trade union",null,null,{"$f":"Calculations!B5","v":2},null,null,"F",null,"Yes",null,"No"]
[null,"UAP 4 - Forced eviction without compensation",null,null,{"$f":"Calculations!B6","v":2},null,null,"F",null,"Yes",null,"No"]
[null,"UAP 5 - Failure to provide adequate housing for workers",null,null,{"$f":"Calculations!B7","v":2},null,null,"F",null,"Yes",null,"No"]
[null,"UAP 6 - Failure to provide potable water","                     ",null,{"$f":"Calculations!B8","v":2},null,null,"F",null,"Yes",null,"No"]
[null,"UAP 7 - Deforestation or destruction of natural resources",null,null,{"$f":"Calculations!B9","v":2},null,null,"F",null,"Yes",null,"No"]
[null,"UAP 8 - Use of unacceptable persticides",null,null,{"$f":"Calculations!B10","v":2},null,null,"F",null,"Yes",null,"No"]
[null,"UAP 9 - Use of genetically modified organisms (GMO)",null,null,{"$f":"Calculations!B11","v":2},null,null,"F",null,"Yes",null,"No"]
[null,"UAP 10 - Immoral transactions in business",null,null,2,null,null,"F",null,"Yes",null,"No"]
[null,"CODE PRINCIPLES",null,null,null,null,null,null,null,null,null,"CAS V.O. ONLY"]
[null,"Criteria","Category","Principle","Self-Assessment of the 4C Unit","Evaluation by verifier transferred from sheet 5","Adjustment of the verifier result (if applicable)","Finding?","Desription of a risk, if applicable","Explanation is required?","Explanation of the finding: In case of deviation from 4C Unit Self-Assessment & verifier evaluation. Plus: Describtion why red practice occurs.  ","CAS V.O. different\nConclusion to the Verifier \n(please select Yes/No)","Please insert V.O. Evaluation\n(if inserted this will show in tab 7 - column E- Current performance level)","Please insert additional observation:\n(if inserted this will show in tab 7 - column H - Description of risk)"]
[null,"Econ 1.1","Profitability and long term productivity","Actions to maintain or increase profitability and long term productivity at farm level are promoted and starting to be implemented. ",{"$f":"Calculations!I3","v":2},{"$f":"IF('5. Verifier ONLY- CODE RATING'!C10=0,0,IF('5. Verifier ONLY- CODE RATING'!C10<=1.25,1,IF('5. Verifier ONLY- CODE RATING'!C10<=2.25,2,IF('5. Verifier ONLY- CODE RATING'!C10>2.25,3))))","v":0},null,{"$f":"IF(EXACT(E21,F21),\"\",\"F\")","v":"F"},null,{"$f":"IF(OR(H21=\"F\",I21=\"R\",AND(E21=3,F21>2.25),AND(E21=3,H21=3)),\"Yes\",\"No\")","v":"Yes"},null,"No"]
[null,"Econ 1.2","Capacity and skill development","Business Partners and workers within the 4C Unit have access to trainings to improve their skills and capacities according to identified needs.",{"$f":"Calculations!I4","v":2},{"$f":"IF('5. Verifier ONLY- CODE RATING'!C11=0,0,IF('5. Verifier ONLY- CODE RATING'!C11<=1.25,1,IF('5. Verifier ONLY- CODE RATING'!C11<=2.25,2,IF('5. Verifier ONLY- CODE RATING'!C11>2.25,3))))","v":0},null,{"$f":"IF(EXACT(E22,F22),\"\",\"F\")","v":"F"},null,{"$f":"IF(OR(H22=\"F\",I22=\"R\",AND(E22=3,F22>2.25),AND(E22=3,H22=3)),\"Yes\",\"No\")","v":"Yes"},null,"No"]
[null,"Econ 1.3","Record keeping","Record keeping to monitor profitability is promoted. ",{"$f":"Calculations!I5","v":2},{"$f":"IF('5. Verifier ONLY- CODE RATING'!C12=0,0,IF('5. Verifier ONLY- CODE RATING'!C12<=1.25,1,IF('5. Verifier ONLY- CODE RATING'!C12<=2.25,2,IF('5. Verifier ONLY- CODE RATING'!C12>2.25,3))))","v":0},null,"F",null,"Yes",null,"No"]
[null,"Econ 1.4","Access to services","Based on producer needs, the ME provides or facilitates the provision of services in order to produce coffee following sustainability practices.   ",{"$f":"Calculations!I6","v":2},{"$f":"IF('5. Verifier ONLY- CODE RATING'!C13=0,0,IF('5. Verifier ONLY- CODE RATING'!C13<=1.25,1,IF('5. Verifier ONLY- CODE RATING'!C13<=2.25,2,IF('5. Verifier ONLY- CODE RATING'!C13>2.25,3))))","v":0},null,"F",null,"Yes",null,"No"]
[null,"Econ 1.5","Market information and commerce","Market information is accessible within the 4C Unit. Transparent pricing mechanisms reflect coffee quality and sustainable production practices.",{"$f":"Calculations!I7","v":2},{"$f":"IF('5. Verifier ONLY- CODE RATING'!C14=0,0,IF('5. Verifier ONLY- CODE RATING'!C14<=1.25,1,IF('5. Verifier ONLY- CODE RATING'!C14<=2.25,2,IF('5. Verifier ONLY- CODE RATING'!C14>2.25,3))))","v":0},null,"F",null,"Yes",null,"No"]
[null,"Econ 1.6","Quality","Coffee quality is monitored within the 4C Unit.",{"$f":"Calculations!I8","v":2},{"$f":"IF('5. Verifier ONLY- CODE RATING'!C15=0,0,IF('5. Verifier ONLY- CODE RATING'!C15<=1.25,1,IF('5. Verifier ONLY- CODE RATING'!C15<=2.25,2,IF('5. Verifier ONLY- CODE RATING'!C15>2.25,3))))","v":0},null,"F",null,"Yes",null,"No"]
[null,"Econ 1.7","Business integrity (transparent business practices)","Transparent business practices are promoted so that the market is not affected by any preferential treatment based on the offering and receiving of any personal or improper advantage in exchange for retaining business or other advantages.",{"$f":"Calculations!I9","v":2},{"$f":"IF('5. Verifier ONLY- CODE RATING'!C16=0,0,IF('5. Verifier ONLY- CODE RATING'!C16<=1.25,1,IF('5. Verifier ONLY- CODE RATING'!C16<=2.25,2,IF('5. Verifier ONLY- CODE RATING'!C16>2.25,3))))","v":0},null,"F",null,"Yes",null,"No"]
[null,"Econ 1.8","Traceability","Mechanisms for traceability within the 4C Unit are in place.",{"$f":"Calculations!I10","v":2},{"$f":"IF('5. Verifier ONLY- CODE RATING'!C17=0,0,IF('5. Verifier ONLY- CODE RATING'!C17<=1.25,1,IF('5. Verifier ONLY- CODE RATING'!C17<=2.25,2,IF('5. Verifier ONLY- CODE RATING'!C17>2.25,3))))","v":0},null,"F",null,"Yes",null,"No"]
[null,"Social 2.1","Discrimination","Equal rights are secured with respect to gender, maternity, religion, ethnicity, physical conditions and political views. ",{"$f":"Calculations!I18","v":2},{"$f":"IF('5. Verifier ONLY- CODE RATING'!C21=0,0,IF('5. Verifier ONLY- CODE RATING'!C21<=1.25,1,IF('5. Verifier ONLY- CODE RATING'!C21<=2.25,2,IF('5. Verifier ONLY- CODE RATING'!C21>2.25,3))))","v":0},null,"F",null,"Yes",null,"No"]
[null,"Social 2.2","Right  to childhood and educationt","Children have the right to childhood and education. ILO Convention 182, 138 1999.",{"$f":"Calculations!I19","v":2},{"$f":"IF('5. Verifier ONLY- CODE RATING'!C22=0,0,IF('5. Verifier ONLY- CODE RATING'!C22<=1.25,1,IF('5. Verifier ONLY- CODE RATING'!C22<=2.25,2,IF('5. Verifier ONLY- CODE RATING'!C22>2.25,3))))","v":0},null,"F",null,"Yes",null,"No"]
[null,"Social 2.3","Freedom of Association","Workers and producers have the right to found, to belong to and to be represented by an independent organisation of their choice.",{"$f":"Calculations!I20","v":2},{"$f":"IF('5. Verifier ONLY- CODE RATING'!C23=0,0,IF('5. Verifier ONLY- CODE RATING'!C23<=1.25,1,IF('5. Verifier ONLY- CODE RATING'!C23<=2.25,2,IF('5. Verifier ONLY- CODE RATING'!C23>2.25,3))))","v":0},null,"F",null,"Yes",null,"No"]
[null,"Social 2.4","Right to collective bargaining","Workers have the right to bargain collectively",{"$f":"Calculations!I21","v":2},{"$f":"IF('5. Verifier ONLY- CODE RATING'!C24=0,0,IF('5. Verifier ONLY- CODE RATING'!C24<=1.25,1,IF('5. Verifier ONLY- CODE RATING'!C24<=2.25,2,IF('5. Verifier ONLY- CODE RATING'!C24>2.25,3))))","v":0},null,"F",null,"Yes",null,"No"]
[null,"Social 2.5","Working Conditions – Labour contract","Workers receive a labour contract and know their rights. ",{"$f":"Calculations!I22","v":2},{"$f":"IF('5. Verifier ONLY- CODE RATING'!C25=0,0,IF('5. Verifier ONLY- CODE RATING'!C25<=1.25,1,IF('5. Verifier ONLY- CODE RATING'!C25<=2.25,2,IF('5. Verifier ONLY- CODE RATING'!C25>2.25,3))))","v":0},null,"F",null,"Yes",null,"No"]
[null,"Social 2.6","Working Conditions – Working hours","Working hours comply with national laws / international conventions and/or collective bargaining and overtime work is remunerated.",{"$f":"Calculations!I23","v":2},{"$f":"IF('5. Verifier ONLY- CODE RATING'!C26=0,0,IF('5. Verifier ONLY- CODE RATING'!C26<=1.25,1,IF('5. Verifier ONLY- CODE RATING'!C26<=2.25,2,IF('5. Verifier ONLY- CODE RATING'!C26>2.25,3))))","v":0},null,"F",null,"Yes",null,"No"]
[null,"Social 2.7","Working Conditions – Wages","Wages comply with national laws or sector agreements.",{"$f":"Calculations!I24","v":2},{"$f":"IF('5. Verifier ONLY- CODE RATING'!C27=0,0,IF('5. Verifier ONLY- CODE RATING'!C27<=1.25,1,IF('5. Verifier ONLY- CODE RATING'!C27<=2.25,2,IF('5. Verifier ONLY- CODE RATING'!C27>2.25,3))))","v":0},null,"F",null,"Yes",null,"No"]
[null,"Social 2.8","Working Conditions – Seasonal and piece rate workers","Equitable treatment of seasonal and piece rate workers.",{"$f":"Calculations!I25","v":2},{"$f":"IF('5. Verifier ONLY- CODE RATING'!C28=0,0,IF('5. Verifier ONLY- CODE RATING'!C28<=1.25,1,IF('5. Verifier ONLY- CODE RATING'!C28<=2.25,2,IF('5. Verifier ONLY- CODE RATING'!C28>2.25,3))))","v":0},null,"F",null,"Yes",null,"No"]
[null,"Social 2.9","Working Conditions – Occupational Health and Safety","Employer assures proper occupational health and safety conditions for workers. ",{"$f":"Calculations!I26","v":2},{"$f":"IF('5. Verifier ONLY- CODE RATING'!C29=0,0,IF('5. Verifier ONLY- CODE RATING'!C29<=1.25,1,IF('5. Verifier ONLY- CODE RATING'!C29<=2.25,2,IF('5. Verifier ONLY- CODE RATING'!C29>2.25,3))))","v":0},null,"F",null,"Yes",null,"No"]
[null,"Environmental 3.1 ","Conservation of Biodiversity","Conservation of biodiversity, including protected or endangered native flora and fauna is supported.",{"$f":"Calculations!I32","v":2},{"$f":"IF('5. Verifier ONLY- CODE RATING'!C33=0,0,IF('5. Verifier ONLY- CODE RATING'!C33<=1.25,1,IF('5. Verifier ONLY- CODE RATING'!C33<=2.25,2,IF('5. Verifier ONLY- CODE RATING'!C33>2.25,3))))","v":0},null,"F",null,"Yes",null,"No"]
[null,"Environmental 3.2","Use of pesticides  ","Use of pesticides is minimised and integrated pest, weed and disease management is improved with time.",{"$f":"Calculations!I33","v":2},{"$f":"IF('5. Verifier ONLY- CODE RATING'!C34=0,0,IF('5. Verifier ONLY- CODE RATING'!C34<=1.25,1,IF('5. Verifier ONLY- CODE RATING'!C34<=2.25,2,IF('5. Verifier ONLY- CODE RATING'!C34>2.25,3))))","v":0},null,"F",null,"Yes",null,"No"]
[null,"Environmental 3.3","Handling of pesticides and other hazardous chemicals","Harmful effects of pesticides and other hazardous chemicals on human health and the environment are minimised.",{"$f":"Calculations!I34","v":2},{"$f":"IF('5. Verifier ONLY- CODE RATING'!C35=0,0,IF('5. Verifier ONLY- CODE RATING'!C35<=1.25,1,IF('5. Verifier ONLY- CODE RATING'!C35<=2.25,2,IF('5. Verifier ONLY- CODE RATING'!C35>2.25,3))))","v":0},null,"F",null,"Yes",null,"No"]
[null,"Environmental 3.4","Soil  Conservation","Soil conservation practices are in place.",{"$f":"Calculations!I35","v":2},{"$f":"IF('5. Verifier ONLY- CODE RATING'!C36=0,0,IF('5. Verifier ONLY- CODE RATING'!C36<=1.25,1,IF('5. Verifier ONLY- CODE RATING'!C36<=2.25,2,IF('5. Verifier ONLY- CODE RATING'!C36>2.25,3))))","v":0},null,"F",null,"Yes",null,"No"]
[null,"Environmental 3.5","Soil Fertility and nutrient management – Fertilisers ","Mineral and/or organic fertilisers are used in a balanced and appropriate way.",{"$f":"Calculations!I36","v":2},{"$f":"IF('5. Verifier ONLY- CODE RATING'!C37=0,0,IF('5. Verifier ONLY- CODE RATING'!C37<=1.25,1,IF('5. Verifier ONLY- CODE RATING'!C37<=2.25,2,IF('5. Verifier ONLY- CODE RATING'!C37>2.25,3))))","v":0},null,"F",null,"Yes",null,"No"]
[null,"Environmental 3.6","Soil Fertility and nutrient management – Organic matter","Maintenance of organic matter in the soil is promoted.",{"$f":"Calculations!I37","v":2},{"$f":"IF('5. Verifier ONLY- CODE RATING'!C38=0,0,IF('5. Verifier ONLY- CODE RATING'!C38<=1.25,1,IF('5. Verifier ONLY- CODE RATING'!C38<=2.25,2,IF('5. Verifier ONLY- CODE RATING'!C38>2.25,3))))","v":0},null,"F",null,"Yes",null,"No"]
[null,"Environmental 3.7","Water – water sources ","Water resources are conserved and used efficiently.",{"$f":"Calculations!I38","v":2},{"$f":"IF('5. Verifier ONLY- CODE RATING'!C39=0,0,IF('5. Verifier ONLY- CODE RATING'!C39<=1.25,1,IF('5. Verifier ONLY- CODE RATING'!C39<=2.25,2,IF('5. Verifier ONLY- CODE RATING'!C39>2.25,3))))","v":0},null,"F",null,"Yes",null,"No"]
[null,"Environmental 3.8","Water – wastewater ","Wastewater management is in place",{"$f":"Calculations!I39","v":2},{"$f":"IF('5. Verifier ONLY- CODE RATING'!C40=0,0,IF('5. Verifier ONLY- CODE RATING'!C40<=1.25,1,IF('5. Verifier ONLY- CODE RATING'!C40<=2.25,2,IF('5. Verifier ONLY- CODE RATING'!C40>2.25,3))))","v":0},null,"F",null,"Yes",null,"No"]
[null,"Environmental 3.9","Waste ","Safe waste management is in place. ",{"$f":"Calculations!I40","v":2},{"$f":"IF('5. Verifier ONLY- CODE RATING'!C41=0,0,IF('5. Verifier ONLY- CODE RATING'!C41<=1.25,1,IF('5. Verifier ONLY- CODE RATING'!C41<=2.25,2,IF('5. Verifier ONLY- CODE RATING'!C41>2.25,3))))","v":0},null,"F",null,"Yes",null,"No"]
[null,"Environmental 3.10","Energy","Saving Energy and preferential use of renewable energy",{"$f":"Calculations!I41","v":2},{"$f":"IF('5. Verifier ONLY- CODE RATING'!C42=0,0,IF('5. Verifier ONLY- CODE RATING'!C42<=1.25,1,IF('5. Verifier ONLY- CODE RATING'!C42<=2.25,2,IF('5. Verifier ONLY- CODE RATING'!C42>2.25,3))))","v":0},null,"F",null,"Yes",null,"No"]

{"sheet":"Mandatory requirements - 4C IP","index":7,"n_rows":56,"n_cols":8,"rows_kept":56,"cut":false,"hidden":false,"merged":[[11,2,11,3],[14,2,14,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[1,2,1,7],[10,2,10,3],[2,2,2,7],[3,2,3,7],[4,2,4,7],[5,2,5,7],[7,4,7,7],[6,2,6,7]]}
[]
[null,null,"Improvement Plan for 4C Unit"]
[null,null,"Instruction for 4C Units:          \nWithin 6 weeks after issuing the license, the Improvement Plan needs to be completed and sent to Coffee Assurance Services (the template is availale at CAS website).\nMoreover, the Improvement Plan needs to be updated regularly (as part of the Annual Update, in a separate \"Improvement Plan\" file)."]
[null,null,"A. Internal Management System: In case you have not reached the \"basic\" level,  AND/OR a risk has been identified "]
[null,null,"B. Unacceptable Practices: In case an Unacceptable Practice occurs AND/OR a risk has been identified "]
[null,null,"C. Code Principles: In case of red rated principles in an Initial Verification and/or principles rated as yellow with risks identified."]
[]
[null,null,null,null,"Results from the latest verification"]
[]
[null,null,"A. Internal Management System",null,"Current performance  level \nHIDDEN!!","Current performance  level ","Description of finding","Description of risk"]
[null,null,"Example",null,"Example: Lack of basic IMS","Example: \nLack of basic IMS","Example: \nIncomplete Business Partner Mapping "]
[null,null,"Unit IMS",null,{"$f":"IF('6. Verifier ONLY - SUMMARY'!L6 = \"No\",\"\", 6)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L6=\"Yes\",'6. Verifier ONLY - SUMMARY'!M6<>\"\"), '6. Verifier ONLY - SUMMARY'!M6,IF(AND('6. Verifier ONLY - SUMMARY'!L6=\"Yes\",'6. Verifier ONLY - SUMMARY'!M6=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!F6<>\"\",'6. Verifier ONLY - SUMMARY'!F6,\"\")))","v":""},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K6<>\"\",'6. Verifier ONLY - SUMMARY'!K6,\"\")","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L6=\"Yes\",'6. Verifier ONLY - SUMMARY'!N6<>\"\"), '6. Verifier ONLY - SUMMARY'!N6,IF(AND('6. Verifier ONLY - SUMMARY'!L6=\"Yes\",'6. Verifier ONLY - SUMMARY'!N6=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I6<>\"\",'6. Verifier ONLY - SUMMARY'!I6,\"\")))","v":""}]
[]
[null,null,"B. Unacceptable Practises",null,"Current performance level (3 = UAP not excluded)\nHIDDEN!!","Current performance level ","Description of finding","Description of risk"]
[null,null,"Example: UAP 8 - Use of internationally banned pesticides",null,null,"UAP not excluded","Example:                           \nSome Business Partners apply Endosulfan"]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B9","v":"UAP 1 - Worst forms of child labor"},null,{"$f":"IF(OR(AND('6. Verifier ONLY - SUMMARY'!L9<> \"No\",OR('6. Verifier ONLY - SUMMARY'!F9=1,'6. Verifier ONLY - SUMMARY'!F9=2)),AND('6. Verifier ONLY - SUMMARY'!L9<> \"No\",OR(H16<>\"\",H16=\"\"))),6,IF(AND(OR('6. Verifier ONLY - SUMMARY'!L9=\"No\",'6. Verifier ONLY - SUMMARY'!L9=\"\"),OR('6. Verifier ONLY - SUMMARY'!F9=1,H16<>\"\")),3,0))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L9=\"Yes\",'6. Verifier ONLY - SUMMARY'!M9=1), Dropdowns!$K$15,IF(AND('6. Verifier ONLY - SUMMARY'!L9=\"Yes\",'6. Verifier ONLY - SUMMARY'!M9=\"\"),\"-\",IF(AND('6. Verifier ONLY - SUMMARY'!L9=\"Yes\",'6. Verifier ONLY - SUMMARY'!M9=2), Dropdowns!$K$14, IF('6. Verifier ONLY - SUMMARY'!F9=1, Dropdowns!$K$15, IF('6. Verifier ONLY - SUMMARY'!F9=2,Dropdowns!$K$14,\"-\")))))","v":"-"},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K9=0,\"\",'6. Verifier ONLY - SUMMARY'!K9)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L9=\"Yes\",'6. Verifier ONLY - SUMMARY'!N9<>\"\"), '6. Verifier ONLY - SUMMARY'!N9,IF(AND('6. Verifier ONLY - SUMMARY'!L9=\"Yes\",'6. Verifier ONLY - SUMMARY'!N9=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I9<>\"\",'6. Verifier ONLY - SUMMARY'!I9,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B10","v":"UAP 2 - Forced and bonded labor, trafficking of persons"},null,{"$f":"IF(OR(AND('6. Verifier ONLY - SUMMARY'!L10<> \"No\",OR('6. Verifier ONLY - SUMMARY'!F10=1,'6. Verifier ONLY - SUMMARY'!F10=2)),AND('6. Verifier ONLY - SUMMARY'!L10<> \"No\",OR(H17<>\"\",H17=\"\"))),6,IF(AND(OR('6. Verifier ONLY - SUMMARY'!L10=\"No\",'6. Verifier ONLY - SUMMARY'!L10=\"\"),OR('6. Verifier ONLY - SUMMARY'!F10=1,H17<>\"\")),3,0))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L10=\"Yes\",'6. Verifier ONLY - SUMMARY'!M10=1), Dropdowns!$K$15,IF(AND('6. Verifier ONLY - SUMMARY'!L10=\"Yes\",'6. Verifier ONLY - SUMMARY'!M10=\"\"),\"-\",IF(AND('6. Verifier ONLY - SUMMARY'!L10=\"Yes\",'6. Verifier ONLY - SUMMARY'!M10=2), Dropdowns!$K$14, IF('6. Verifier ONLY - SUMMARY'!F10=1, Dropdowns!$K$15, IF('6. Verifier ONLY - SUMMARY'!F10=2,Dropdowns!$K$14,\"-\")))))","v":"-"},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K10=0,\"\",'6. Verifier ONLY - SUMMARY'!K10)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L10=\"Yes\",'6. Verifier ONLY - SUMMARY'!N10<>\"\"), '6. Verifier ONLY - SUMMARY'!N10,IF(AND('6. Verifier ONLY - SUMMARY'!L10=\"Yes\",'6. Verifier ONLY - SUMMARY'!N10=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I10<>\"\",'6. Verifier ONLY - SUMMARY'!I10,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B11","v":"UAP 3 - Prohibition of membership in and representation by trade union"},null,{"$f":"IF(OR(AND('6. Verifier ONLY - SUMMARY'!L11<> \"No\",OR('6. Verifier ONLY - SUMMARY'!F11=1,'6. Verifier ONLY - SUMMARY'!F11=2)),AND('6. Verifier ONLY - SUMMARY'!L11<> \"No\",OR(H18<>\"\",H18=\"\"))),6,IF(AND(OR('6. Verifier ONLY - SUMMARY'!L11=\"No\",'6. Verifier ONLY - SUMMARY'!L11=\"\"),OR('6. Verifier ONLY - SUMMARY'!F11=1,H18<>\"\")),3,0))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L11=\"Yes\",'6. Verifier ONLY - SUMMARY'!M11=1), Dropdowns!$K$15,IF(AND('6. Verifier ONLY - SUMMARY'!L11=\"Yes\",'6. Verifier ONLY - SUMMARY'!M11=\"\"),\"-\",IF(AND('6. Verifier ONLY - SUMMARY'!L11=\"Yes\",'6. Verifier ONLY - SUMMARY'!M11=2), Dropdowns!$K$14, IF('6. Verifier ONLY - SUMMARY'!F11=1, Dropdowns!$K$15, IF('6. Verifier ONLY - SUMMARY'!F11=2,Dropdowns!$K$14,\"-\")))))","v":"-"},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K11=0,\"\",'6. Verifier ONLY - SUMMARY'!K11)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L11=\"Yes\",'6. Verifier ONLY - SUMMARY'!N11<>\"\"), '6. Verifier ONLY - SUMMARY'!N11,IF(AND('6. Verifier ONLY - SUMMARY'!L11=\"Yes\",'6. Verifier ONLY - SUMMARY'!N11=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I11<>\"\",'6. Verifier ONLY - SUMMARY'!I11,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B12","v":"UAP 4 - Forced eviction without compensation"},null,{"$f":"IF(OR(AND('6. Verifier ONLY - SUMMARY'!L12<> \"No\",OR('6. Verifier ONLY - SUMMARY'!F12=1,'6. Verifier ONLY - SUMMARY'!F12=2)),AND('6. Verifier ONLY - SUMMARY'!L12<> \"No\",OR(H19<>\"\",H19=\"\"))),6,IF(AND(OR('6. Verifier ONLY - SUMMARY'!L12=\"No\",'6. Verifier ONLY - SUMMARY'!L12=\"\"),OR('6. Verifier ONLY - SUMMARY'!F12=1,H19<>\"\")),3,0))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L12=\"Yes\",'6. Verifier ONLY - SUMMARY'!M12=1), Dropdowns!$K$15,IF(AND('6. Verifier ONLY - SUMMARY'!L12=\"Yes\",'6. Verifier ONLY - SUMMARY'!M12=\"\"),\"-\",IF(AND('6. Verifier ONLY - SUMMARY'!L12=\"Yes\",'6. Verifier ONLY - SUMMARY'!M12=2), Dropdowns!$K$14, IF('6. Verifier ONLY - SUMMARY'!F12=1, Dropdowns!$K$15, IF('6. Verifier ONLY - SUMMARY'!F12=2,Dropdowns!$K$14,\"-\")))))","v":"-"},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K12=0,\"\",'6. Verifier ONLY - SUMMARY'!K12)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L12=\"Yes\",'6. Verifier ONLY - SUMMARY'!N12<>\"\"), '6. Verifier ONLY - SUMMARY'!N12,IF(AND('6. Verifier ONLY - SUMMARY'!L12=\"Yes\",'6. Verifier ONLY - SUMMARY'!N12=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I12<>\"\",'6. Verifier ONLY - SUMMARY'!I12,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B13","v":"UAP 5 - Failure to provide adequate housing for workers"},null,{"$f":"IF(OR(AND('6. Verifier ONLY - SUMMARY'!L13<> \"No\",OR('6. Verifier ONLY - SUMMARY'!F13=1,'6. Verifier ONLY - SUMMARY'!F13=2)),AND('6. Verifier ONLY - SUMMARY'!L13<> \"No\",OR(H20<>\"\",H20=\"\"))),6,IF(AND(OR('6. Verifier ONLY - SUMMARY'!L13=\"No\",'6. Verifier ONLY - SUMMARY'!L13=\"\"),OR('6. Verifier ONLY - SUMMARY'!F13=1,H20<>\"\")),3,0))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L13=\"Yes\",'6. Verifier ONLY - SUMMARY'!M13=1), Dropdowns!$K$15,IF(AND('6. Verifier ONLY - SUMMARY'!L13=\"Yes\",'6. Verifier ONLY - SUMMARY'!M13=\"\"),\"-\",IF(AND('6. Verifier ONLY - SUMMARY'!L13=\"Yes\",'6. Verifier ONLY - SUMMARY'!M13=2), Dropdowns!$K$14, IF('6. Verifier ONLY - SUMMARY'!F13=1, Dropdowns!$K$15, IF('6. Verifier ONLY - SUMMARY'!F13=2,Dropdowns!$K$14,\"-\")))))","v":"-"},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K13=0,\"\",'6. Verifier ONLY - SUMMARY'!K13)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L13=\"Yes\",'6. Verifier ONLY - SUMMARY'!N13<>\"\"), '6. Verifier ONLY - SUMMARY'!N13,IF(AND('6. Verifier ONLY - SUMMARY'!L13=\"Yes\",'6. Verifier ONLY - SUMMARY'!N13=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I13<>\"\",'6. Verifier ONLY - SUMMARY'!I13,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B14","v":"UAP 6 - Failure to provide potable water"},null,{"$f":"IF(OR(AND('6. Verifier ONLY - SUMMARY'!L14<> \"No\",OR('6. Verifier ONLY - SUMMARY'!F14=1,'6. Verifier ONLY - SUMMARY'!F14=2)),AND('6. Verifier ONLY - SUMMARY'!L14<> \"No\",OR(H21<>\"\",H21=\"\"))),6,IF(AND(OR('6. Verifier ONLY - SUMMARY'!L14=\"No\",'6. Verifier ONLY - SUMMARY'!L14=\"\"),OR('6. Verifier ONLY - SUMMARY'!F14=1,H21<>\"\")),3,0))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L14=\"Yes\",'6. Verifier ONLY - SUMMARY'!M14=1), Dropdowns!$K$15,IF(AND('6. Verifier ONLY - SUMMARY'!L14=\"Yes\",'6. Verifier ONLY - SUMMARY'!M14=\"\"),\"-\",IF(AND('6. Verifier ONLY - SUMMARY'!L14=\"Yes\",'6. Verifier ONLY - SUMMARY'!M14=2), Dropdowns!$K$14, IF('6. Verifier ONLY - SUMMARY'!F14=1, Dropdowns!$K$15, IF('6. Verifier ONLY - SUMMARY'!F14=2,Dropdowns!$K$14,\"-\")))))","v":"-"},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K14=0,\"\",'6. Verifier ONLY - SUMMARY'!K14)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L14=\"Yes\",'6. Verifier ONLY - SUMMARY'!N14<>\"\"), '6. Verifier ONLY - SUMMARY'!N14,IF(AND('6. Verifier ONLY - SUMMARY'!L14=\"Yes\",'6. Verifier ONLY - SUMMARY'!N14=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I14<>\"\",'6. Verifier ONLY - SUMMARY'!I14,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B15","v":"UAP 7 - Deforestation or destruction of natural resources"},null,{"$f":"IF(OR(AND('6. Verifier ONLY - SUMMARY'!L15<> \"No\",OR('6. Verifier ONLY - SUMMARY'!F15=1,'6. Verifier ONLY - SUMMARY'!F15=2)),AND('6. Verifier ONLY - SUMMARY'!L15<> \"No\",OR(H22<>\"\",H22=\"\"))),6,IF(AND(OR('6. Verifier ONLY - SUMMARY'!L15=\"No\",'6. Verifier ONLY - SUMMARY'!L15=\"\"),OR('6. Verifier ONLY - SUMMARY'!F15=1,H22<>\"\")),3,0))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L15=\"Yes\",'6. Verifier ONLY - SUMMARY'!M15=1), Dropdowns!$K$15,IF(AND('6. Verifier ONLY - SUMMARY'!L15=\"Yes\",'6. Verifier ONLY - SUMMARY'!M15=\"\"),\"-\",IF(AND('6. Verifier ONLY - SUMMARY'!L15=\"Yes\",'6. Verifier ONLY - SUMMARY'!M15=2), Dropdowns!$K$14, IF('6. Verifier ONLY - SUMMARY'!F15=1, Dropdowns!$K$15, IF('6. Verifier ONLY - SUMMARY'!F15=2,Dropdowns!$K$14,\"-\")))))","v":"-"},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K15=0,\"\",'6. Verifier ONLY - SUMMARY'!K15)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L15=\"Yes\",'6. Verifier ONLY - SUMMARY'!N15<>\"\"), '6. Verifier ONLY - SUMMARY'!N15,IF(AND('6. Verifier ONLY - SUMMARY'!L15=\"Yes\",'6. Verifier ONLY - SUMMARY'!N15=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I15<>\"\",'6. Verifier ONLY - SUMMARY'!I15,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B16","v":"UAP 8 - Use of unacceptable persticides"},null,{"$f":"IF(OR(AND('6. Verifier ONLY - SUMMARY'!L16<> \"No\",OR('6. Verifier ONLY - SUMMARY'!F16=1,'6. Verifier ONLY - SUMMARY'!F16=2)),AND('6. Verifier ONLY - SUMMARY'!L16<> \"No\",OR(H23<>\"\",H23=\"\"))),6,IF(AND(OR('6. Verifier ONLY - SUMMARY'!L16=\"No\",'6. Verifier ONLY - SUMMARY'!L16=\"\"),OR('6. Verifier ONLY - SUMMARY'!F16=1,H23<>\"\")),3,0))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L16=\"Yes\",'6. Verifier ONLY - SUMMARY'!M16=1), Dropdowns!$K$15,IF(AND('6. Verifier ONLY - SUMMARY'!L16=\"Yes\",'6. Verifier ONLY - SUMMARY'!M16=\"\"),\"-\",IF(AND('6. Verifier ONLY - SUMMARY'!L16=\"Yes\",'6. Verifier ONLY - SUMMARY'!M16=2), Dropdowns!$K$14, IF('6. Verifier ONLY - SUMMARY'!F16=1, Dropdowns!$K$15, IF('6. Verifier ONLY - SUMMARY'!F16=2,Dropdowns!$K$14,\"-\")))))","v":"-"},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K16=0,\"\",'6. Verifier ONLY - SUMMARY'!K16)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L16=\"Yes\",'6. Verifier ONLY - SUMMARY'!N16<>\"\"), '6. Verifier ONLY - SUMMARY'!N16,IF(AND('6. Verifier ONLY - SUMMARY'!L16=\"Yes\",'6. Verifier ONLY - SUMMARY'!N16=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I16<>\"\",'6. Verifier ONLY - SUMMARY'!I16,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B17","v":"UAP 9 - Use of genetically modified organisms (GMO)"},null,{"$f":"IF(OR(AND('6. Verifier ONLY - SUMMARY'!L17<> \"No\",OR('6. Verifier ONLY - SUMMARY'!F17=1,'6. Verifier ONLY - SUMMARY'!F17=2)),AND('6. Verifier ONLY - SUMMARY'!L17<> \"No\",OR(H24<>\"\",H24=\"\"))),6,IF(AND(OR('6. Verifier ONLY - SUMMARY'!L17=\"No\",'6. Verifier ONLY - SUMMARY'!L17=\"\"),OR('6. Verifier ONLY - SUMMARY'!F17=1,H24<>\"\")),3,0))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L17=\"Yes\",'6. Verifier ONLY - SUMMARY'!M17=1), Dropdowns!$K$15,IF(AND('6. Verifier ONLY - SUMMARY'!L17=\"Yes\",'6. Verifier ONLY - SUMMARY'!M17=\"\"),\"-\",IF(AND('6. Verifier ONLY - SUMMARY'!L17=\"Yes\",'6. Verifier ONLY - SUMMARY'!M17=2), Dropdowns!$K$14, IF('6. Verifier ONLY - SUMMARY'!F17=1, Dropdowns!$K$15, IF('6. Verifier ONLY - SUMMARY'!F17=2,Dropdowns!$K$14,\"-\")))))","v":"-"},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K17=0,\"\",'6. Verifier ONLY - SUMMARY'!K17)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L17=\"Yes\",'6. Verifier ONLY - SUMMARY'!N17<>\"\"), '6. Verifier ONLY - SUMMARY'!N17,IF(AND('6. Verifier ONLY - SUMMARY'!L17=\"Yes\",'6. Verifier ONLY - SUMMARY'!N17=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I17<>\"\",'6. Verifier ONLY - SUMMARY'!I17,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B18","v":"UAP 10 - Immoral transactions in business"},null,{"$f":"IF(OR(AND('6. Verifier ONLY - SUMMARY'!L18<> \"No\",OR('6. Verifier ONLY - SUMMARY'!F18=1,'6. Verifier ONLY - SUMMARY'!F18=2)),AND('6. Verifier ONLY - SUMMARY'!L18<> \"No\",OR(H25<>\"\",H25=\"\"))),6,IF(AND(OR('6. Verifier ONLY - SUMMARY'!L18=\"No\",'6. Verifier ONLY - SUMMARY'!L18=\"\"),OR('6. Verifier ONLY - SUMMARY'!F18=1,H25<>\"\")),3,0))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L18=\"Yes\",'6. Verifier ONLY - SUMMARY'!M18=1), Dropdowns!$K$15,IF(AND('6. Verifier ONLY - SUMMARY'!L18=\"Yes\",'6. Verifier ONLY - SUMMARY'!M18=\"\"),\"-\",IF(AND('6. Verifier ONLY - SUMMARY'!L18=\"Yes\",'6. Verifier ONLY - SUMMARY'!M18=2), Dropdowns!$K$14, IF('6. Verifier ONLY - SUMMARY'!F18=1, Dropdowns!$K$15, IF('6. Verifier ONLY - SUMMARY'!F18=2,Dropdowns!$K$14,\"-\")))))","v":"-"},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K18=0,\"\",'6. Verifier ONLY - SUMMARY'!K18)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L18=\"Yes\",'6. Verifier ONLY - SUMMARY'!N18<>\"\"), '6. Verifier ONLY - SUMMARY'!N18,IF(AND('6. Verifier ONLY - SUMMARY'!L18=\"Yes\",'6. Verifier ONLY - SUMMARY'!N18=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I18<>\"\",'6. Verifier ONLY - SUMMARY'!I18,\"\")))","v":""}]
[]
[null,null,"C. Code Principles",null,"Current performance  level \nHIDDEN!!","Current performance  level ","Description of finding  (for Red ratings)","Description of risk"]
[null,null,"No of Princ.","Principle "]
[]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B21","v":"Econ 1.1"},{"$f":"'6. Verifier ONLY - SUMMARY'!D21","v":"Actions to maintain or increase profitability and long term productivity at farm level are promoted and starting to be implemented. "},{"$f":"IF('6. Verifier ONLY - SUMMARY'!L21<> \"No\",6,IF('6. Verifier ONLY - SUMMARY'!F21<2,0,IF('6. Verifier ONLY - SUMMARY'!F21>2,3,IF(H30<>\"\",3,0))))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L21=\"Yes\",'6. Verifier ONLY - SUMMARY'!M21<>\"\"), '6. Verifier ONLY - SUMMARY'!M21,IF(AND('6. Verifier ONLY - SUMMARY'!L21=\"Yes\",'6. Verifier ONLY - SUMMARY'!M21=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!F21<>\"\",'6. Verifier ONLY - SUMMARY'!F21,\"\")))","v":0},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K21=0,\"\",'6. Verifier ONLY - SUMMARY'!K21)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L21=\"Yes\",'6. Verifier ONLY - SUMMARY'!N21<>\"\"), '6. Verifier ONLY - SUMMARY'!N21,IF(AND('6. Verifier ONLY - SUMMARY'!L21=\"Yes\",'6. Verifier ONLY - SUMMARY'!N21=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I21<>\"\",'6. Verifier ONLY - SUMMARY'!I21,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B22","v":"Econ 1.2"},{"$f":"'6. Verifier ONLY - SUMMARY'!D22","v":"Business Partners and workers within the 4C Unit have access to trainings to improve their skills and capacities according to identified needs."},{"$f":"IF('6. Verifier ONLY - SUMMARY'!L22<> \"No\",6,IF('6. Verifier ONLY - SUMMARY'!F22<2,0,IF('6. Verifier ONLY - SUMMARY'!F22>2,3,IF(H31<>\"\",3,0))))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L22=\"Yes\",'6. Verifier ONLY - SUMMARY'!M22<>\"\"), '6. Verifier ONLY - SUMMARY'!M22,IF(AND('6. Verifier ONLY - SUMMARY'!L22=\"Yes\",'6. Verifier ONLY - SUMMARY'!M22=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!F22<>\"\",'6. Verifier ONLY - SUMMARY'!F22,\"\")))","v":0},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K22=0,\"\",'6. Verifier ONLY - SUMMARY'!K22)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L22=\"Yes\",'6. Verifier ONLY - SUMMARY'!N22<>\"\"), '6. Verifier ONLY - SUMMARY'!N22,IF(AND('6. Verifier ONLY - SUMMARY'!L22=\"Yes\",'6. Verifier ONLY - SUMMARY'!N22=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I22<>\"\",'6. Verifier ONLY - SUMMARY'!I22,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B23","v":"Econ 1.3"},{"$f":"'6. Verifier ONLY - SUMMARY'!D23","v":"Record keeping to monitor profitability is promoted. "},{"$f":"IF('6. Verifier ONLY - SUMMARY'!L23<> \"No\",6,IF('6. Verifier ONLY - SUMMARY'!F23<2,0,IF('6. Verifier ONLY - SUMMARY'!F23>2,3,IF(H32<>\"\",3,0))))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L23=\"Yes\",'6. Verifier ONLY - SUMMARY'!M23<>\"\"), '6. Verifier ONLY - SUMMARY'!M23,IF(AND('6. Verifier ONLY - SUMMARY'!L23=\"Yes\",'6. Verifier ONLY - SUMMARY'!M23=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!F23<>\"\",'6. Verifier ONLY - SUMMARY'!F23,\"\")))","v":0},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K23=0,\"\",'6. Verifier ONLY - SUMMARY'!K23)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L23=\"Yes\",'6. Verifier ONLY - SUMMARY'!N23<>\"\"), '6. Verifier ONLY - SUMMARY'!N23,IF(AND('6. Verifier ONLY - SUMMARY'!L23=\"Yes\",'6. Verifier ONLY - SUMMARY'!N23=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I23<>\"\",'6. Verifier ONLY - SUMMARY'!I23,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B24","v":"Econ 1.4"},{"$f":"'6. Verifier ONLY - SUMMARY'!D24","v":"Based on producer needs, the ME provides or facilitates the provision of services in order to produce coffee following sustainability practices.   "},{"$f":"IF('6. Verifier ONLY - SUMMARY'!L24<> \"No\",6,IF('6. Verifier ONLY - SUMMARY'!F24<2,0,IF('6. Verifier ONLY - SUMMARY'!F24>2,3,IF(H33<>\"\",3,0))))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L24=\"Yes\",'6. Verifier ONLY - SUMMARY'!M24<>\"\"), '6. Verifier ONLY - SUMMARY'!M24,IF(AND('6. Verifier ONLY - SUMMARY'!L24=\"Yes\",'6. Verifier ONLY - SUMMARY'!M24=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!F24<>\"\",'6. Verifier ONLY - SUMMARY'!F24,\"\")))","v":0},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K24=0,\"\",'6. Verifier ONLY - SUMMARY'!K24)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L24=\"Yes\",'6. Verifier ONLY - SUMMARY'!N24<>\"\"), '6. Verifier ONLY - SUMMARY'!N24,IF(AND('6. Verifier ONLY - SUMMARY'!L24=\"Yes\",'6. Verifier ONLY - SUMMARY'!N24=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I24<>\"\",'6. Verifier ONLY - SUMMARY'!I24,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B25","v":"Econ 1.5"},{"$f":"'6. Verifier ONLY - SUMMARY'!D25","v":"Market information is accessible within the 4C Unit. Transparent pricing mechanisms reflect coffee quality and sustainable production practices."},{"$f":"IF('6. Verifier ONLY - SUMMARY'!L25<> \"No\",6,IF('6. Verifier ONLY - SUMMARY'!F25<2,0,IF('6. Verifier ONLY - SUMMARY'!F25>2,3,IF(H34<>\"\",3,0))))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L25=\"Yes\",'6. Verifier ONLY - SUMMARY'!M25<>\"\"), '6. Verifier ONLY - SUMMARY'!M25,IF(AND('6. Verifier ONLY - SUMMARY'!L25=\"Yes\",'6. Verifier ONLY - SUMMARY'!M25=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!F25<>\"\",'6. Verifier ONLY - SUMMARY'!F25,\"\")))","v":0},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K25=0,\"\",'6. Verifier ONLY - SUMMARY'!K25)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L25=\"Yes\",'6. Verifier ONLY - SUMMARY'!N25<>\"\"), '6. Verifier ONLY - SUMMARY'!N25,IF(AND('6. Verifier ONLY - SUMMARY'!L25=\"Yes\",'6. Verifier ONLY - SUMMARY'!N25=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I25<>\"\",'6. Verifier ONLY - SUMMARY'!I25,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B26","v":"Econ 1.6"},{"$f":"'6. Verifier ONLY - SUMMARY'!D26","v":"Coffee quality is monitored within the 4C Unit."},{"$f":"IF('6. Verifier ONLY - SUMMARY'!L26<> \"No\",6,IF('6. Verifier ONLY - SUMMARY'!F26<2,0,IF('6. Verifier ONLY - SUMMARY'!F26>2,3,IF(H35<>\"\",3,0))))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L26=\"Yes\",'6. Verifier ONLY - SUMMARY'!M26<>\"\"), '6. Verifier ONLY - SUMMARY'!M26,IF(AND('6. Verifier ONLY - SUMMARY'!L26=\"Yes\",'6. Verifier ONLY - SUMMARY'!M26=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!F26<>\"\",'6. Verifier ONLY - SUMMARY'!F26,\"\")))","v":0},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K26=0,\"\",'6. Verifier ONLY - SUMMARY'!K26)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L26=\"Yes\",'6. Verifier ONLY - SUMMARY'!N26<>\"\"), '6. Verifier ONLY - SUMMARY'!N26,IF(AND('6. Verifier ONLY - SUMMARY'!L26=\"Yes\",'6. Verifier ONLY - SUMMARY'!N26=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I26<>\"\",'6. Verifier ONLY - SUMMARY'!I26,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B27","v":"Econ 1.7"},{"$f":"'6. Verifier ONLY - SUMMARY'!D27","v":"Transparent business practices are promoted so that the market is not affected by any preferential treatment based on the offering and receiving of any personal or improper advantage in exchange for retaining business or other advantages."},{"$f":"IF('6. Verifier ONLY - SUMMARY'!L27<> \"No\",6,IF('6. Verifier ONLY - SUMMARY'!F27<2,0,IF('6. Verifier ONLY - SUMMARY'!F27>2,3,IF(H36<>\"\",3,0))))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L27=\"Yes\",'6. Verifier ONLY - SUMMARY'!M27<>\"\"), '6. Verifier ONLY - SUMMARY'!M27,IF(AND('6. Verifier ONLY - SUMMARY'!L27=\"Yes\",'6. Verifier ONLY - SUMMARY'!M27=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!F27<>\"\",'6. Verifier ONLY - SUMMARY'!F27,\"\")))","v":0},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K27=0,\"\",'6. Verifier ONLY - SUMMARY'!K27)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L27=\"Yes\",'6. Verifier ONLY - SUMMARY'!N27<>\"\"), '6. Verifier ONLY - SUMMARY'!N27,IF(AND('6. Verifier ONLY - SUMMARY'!L27=\"Yes\",'6. Verifier ONLY - SUMMARY'!N27=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I27<>\"\",'6. Verifier ONLY - SUMMARY'!I27,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B28","v":"Econ 1.8"},{"$f":"'6. Verifier ONLY - SUMMARY'!D28","v":"Mechanisms for traceability within the 4C Unit are in place."},{"$f":"IF('6. Verifier ONLY - SUMMARY'!L28<> \"No\",6,IF('6. Verifier ONLY - SUMMARY'!F28<2,0,IF('6. Verifier ONLY - SUMMARY'!F28>2,3,IF(H37<>\"\",3,0))))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L28=\"Yes\",'6. Verifier ONLY - SUMMARY'!M28<>\"\"), '6. Verifier ONLY - SUMMARY'!M28,IF(AND('6. Verifier ONLY - SUMMARY'!L28=\"Yes\",'6. Verifier ONLY - SUMMARY'!M28=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!F28<>\"\",'6. Verifier ONLY - SUMMARY'!F28,\"\")))","v":0},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K28=0,\"\",'6. Verifier ONLY - SUMMARY'!K28)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L28=\"Yes\",'6. Verifier ONLY - SUMMARY'!N28<>\"\"), '6. Verifier ONLY - SUMMARY'!N28,IF(AND('6. Verifier ONLY - SUMMARY'!L28=\"Yes\",'6. Verifier ONLY - SUMMARY'!N28=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I28<>\"\",'6. Verifier ONLY - SUMMARY'!I28,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B29","v":"Social 2.1"},{"$f":"'6. Verifier ONLY - SUMMARY'!D29","v":"Equal rights are secured with respect to gender, maternity, religion, ethnicity, physical conditions and political views. "},{"$f":"IF('6. Verifier ONLY - SUMMARY'!L29<> \"No\",6,IF('6. Verifier ONLY - SUMMARY'!F29<2,0,IF('6. Verifier ONLY - SUMMARY'!F29>2,3,IF(H38<>\"\",3,0))))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L29=\"Yes\",'6. Verifier ONLY - SUMMARY'!M29<>\"\"), '6. Verifier ONLY - SUMMARY'!M29,IF(AND('6. Verifier ONLY - SUMMARY'!L29=\"Yes\",'6. Verifier ONLY - SUMMARY'!M29=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!F29<>\"\",'6. Verifier ONLY - SUMMARY'!F29,\"\")))","v":0},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K29=0,\"\",'6. Verifier ONLY - SUMMARY'!K29)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L29=\"Yes\",'6. Verifier ONLY - SUMMARY'!N29<>\"\"), '6. Verifier ONLY - SUMMARY'!N29,IF(AND('6. Verifier ONLY - SUMMARY'!L29=\"Yes\",'6. Verifier ONLY - SUMMARY'!N29=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I29<>\"\",'6. Verifier ONLY - SUMMARY'!I29,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B30","v":"Social 2.2"},{"$f":"'6. Verifier ONLY - SUMMARY'!D30","v":"Children have the right to childhood and education. ILO Convention 182, 138 1999."},{"$f":"IF('6. Verifier ONLY - SUMMARY'!L30<> \"No\",6,IF('6. Verifier ONLY - SUMMARY'!F30<2,0,IF('6. Verifier ONLY - SUMMARY'!F30>2,3,IF(H39<>\"\",3,0))))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L30=\"Yes\",'6. Verifier ONLY - SUMMARY'!M30<>\"\"), '6. Verifier ONLY - SUMMARY'!M30,IF(AND('6. Verifier ONLY - SUMMARY'!L30=\"Yes\",'6. Verifier ONLY - SUMMARY'!M30=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!F30<>\"\",'6. Verifier ONLY - SUMMARY'!F30,\"\")))","v":0},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K30=0,\"\",'6. Verifier ONLY - SUMMARY'!K30)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L30=\"Yes\",'6. Verifier ONLY - SUMMARY'!N30<>\"\"), '6. Verifier ONLY - SUMMARY'!N30,IF(AND('6. Verifier ONLY - SUMMARY'!L30=\"Yes\",'6. Verifier ONLY - SUMMARY'!N30=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I30<>\"\",'6. Verifier ONLY - SUMMARY'!I30,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B31","v":"Social 2.3"},{"$f":"'6. Verifier ONLY - SUMMARY'!D31","v":"Workers and producers have the right to found, to belong to and to be represented by an independent organisation of their choice."},{"$f":"IF('6. Verifier ONLY - SUMMARY'!L31<> \"No\",6,IF('6. Verifier ONLY - SUMMARY'!F31<2,0,IF('6. Verifier ONLY - SUMMARY'!F31>2,3,IF(H40<>\"\",3,0))))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L31=\"Yes\",'6. Verifier ONLY - SUMMARY'!M31<>\"\"), '6. Verifier ONLY - SUMMARY'!M31,IF(AND('6. Verifier ONLY - SUMMARY'!L31=\"Yes\",'6. Verifier ONLY - SUMMARY'!M31=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!F31<>\"\",'6. Verifier ONLY - SUMMARY'!F31,\"\")))","v":0},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K31=0,\"\",'6. Verifier ONLY - SUMMARY'!K31)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L31=\"Yes\",'6. Verifier ONLY - SUMMARY'!N31<>\"\"), '6. Verifier ONLY - SUMMARY'!N31,IF(AND('6. Verifier ONLY - SUMMARY'!L31=\"Yes\",'6. Verifier ONLY - SUMMARY'!N31=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I31<>\"\",'6. Verifier ONLY - SUMMARY'!I31,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B32","v":"Social 2.4"},{"$f":"'6. Verifier ONLY - SUMMARY'!D32","v":"Workers have the right to bargain collectively"},{"$f":"IF('6. Verifier ONLY - SUMMARY'!L32<> \"No\",6,IF('6. Verifier ONLY - SUMMARY'!F32<2,0,IF('6. Verifier ONLY - SUMMARY'!F32>2,3,IF(H41<>\"\",3,0))))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L32=\"Yes\",'6. Verifier ONLY - SUMMARY'!M32<>\"\"), '6. Verifier ONLY - SUMMARY'!M32,IF(AND('6. Verifier ONLY - SUMMARY'!L32=\"Yes\",'6. Verifier ONLY - SUMMARY'!M32=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!F32<>\"\",'6. Verifier ONLY - SUMMARY'!F32,\"\")))","v":0},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K32=0,\"\",'6. Verifier ONLY - SUMMARY'!K32)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L32=\"Yes\",'6. Verifier ONLY - SUMMARY'!N32<>\"\"), '6. Verifier ONLY - SUMMARY'!N32,IF(AND('6. Verifier ONLY - SUMMARY'!L32=\"Yes\",'6. Verifier ONLY - SUMMARY'!N32=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I32<>\"\",'6. Verifier ONLY - SUMMARY'!I32,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B33","v":"Social 2.5"},{"$f":"'6. Verifier ONLY - SUMMARY'!D33","v":"Workers receive a labour contract and know their rights. "},{"$f":"IF('6. Verifier ONLY - SUMMARY'!L33<> \"No\",6,IF('6. Verifier ONLY - SUMMARY'!F33<2,0,IF('6. Verifier ONLY - SUMMARY'!F33>2,3,IF(H42<>\"\",3,0))))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L33=\"Yes\",'6. Verifier ONLY - SUMMARY'!M33<>\"\"), '6. Verifier ONLY - SUMMARY'!M33,IF(AND('6. Verifier ONLY - SUMMARY'!L33=\"Yes\",'6. Verifier ONLY - SUMMARY'!M33=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!F33<>\"\",'6. Verifier ONLY - SUMMARY'!F33,\"\")))","v":0},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K33=0,\"\",'6. Verifier ONLY - SUMMARY'!K33)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L33=\"Yes\",'6. Verifier ONLY - SUMMARY'!N33<>\"\"), '6. Verifier ONLY - SUMMARY'!N33,IF(AND('6. Verifier ONLY - SUMMARY'!L33=\"Yes\",'6. Verifier ONLY - SUMMARY'!N33=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I33<>\"\",'6. Verifier ONLY - SUMMARY'!I33,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B34","v":"Social 2.6"},{"$f":"'6. Verifier ONLY - SUMMARY'!D34","v":"Working hours comply with national laws / international conventions and/or collective bargaining and overtime work is remunerated."},{"$f":"IF('6. Verifier ONLY - SUMMARY'!L34<> \"No\",6,IF('6. Verifier ONLY - SUMMARY'!F34<2,0,IF('6. Verifier ONLY - SUMMARY'!F34>2,3,IF(H43<>\"\",3,0))))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L34=\"Yes\",'6. Verifier ONLY - SUMMARY'!M34<>\"\"), '6. Verifier ONLY - SUMMARY'!M34,IF(AND('6. Verifier ONLY - SUMMARY'!L34=\"Yes\",'6. Verifier ONLY - SUMMARY'!M34=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!F34<>\"\",'6. Verifier ONLY - SUMMARY'!F34,\"\")))","v":0},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K34=0,\"\",'6. Verifier ONLY - SUMMARY'!K34)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L34=\"Yes\",'6. Verifier ONLY - SUMMARY'!N34<>\"\"), '6. Verifier ONLY - SUMMARY'!N34,IF(AND('6. Verifier ONLY - SUMMARY'!L34=\"Yes\",'6. Verifier ONLY - SUMMARY'!N34=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I34<>\"\",'6. Verifier ONLY - SUMMARY'!I34,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B35","v":"Social 2.7"},{"$f":"'6. Verifier ONLY - SUMMARY'!D35","v":"Wages comply with national laws or sector agreements."},{"$f":"IF('6. Verifier ONLY - SUMMARY'!L35<> \"No\",6,IF('6. Verifier ONLY - SUMMARY'!F35<2,0,IF('6. Verifier ONLY - SUMMARY'!F35>2,3,IF(H44<>\"\",3,0))))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L35=\"Yes\",'6. Verifier ONLY - SUMMARY'!M35<>\"\"), '6. Verifier ONLY - SUMMARY'!M35,IF(AND('6. Verifier ONLY - SUMMARY'!L35=\"Yes\",'6. Verifier ONLY - SUMMARY'!M35=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!F35<>\"\",'6. Verifier ONLY - SUMMARY'!F35,\"\")))","v":0},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K35=0,\"\",'6. Verifier ONLY - SUMMARY'!K35)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L35=\"Yes\",'6. Verifier ONLY - SUMMARY'!N35<>\"\"), '6. Verifier ONLY - SUMMARY'!N35,IF(AND('6. Verifier ONLY - SUMMARY'!L35=\"Yes\",'6. Verifier ONLY - SUMMARY'!N35=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I35<>\"\",'6. Verifier ONLY - SUMMARY'!I35,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B36","v":"Social 2.8"},{"$f":"'6. Verifier ONLY - SUMMARY'!D36","v":"Equitable treatment of seasonal and piece rate workers."},{"$f":"IF('6. Verifier ONLY - SUMMARY'!L36<> \"No\",6,IF('6. Verifier ONLY - SUMMARY'!F36<2,0,IF('6. Verifier ONLY - SUMMARY'!F36>2,3,IF(H45<>\"\",3,0))))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L36=\"Yes\",'6. Verifier ONLY - SUMMARY'!M36<>\"\"), '6. Verifier ONLY - SUMMARY'!M36,IF(AND('6. Verifier ONLY - SUMMARY'!L36=\"Yes\",'6. Verifier ONLY - SUMMARY'!M36=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!F36<>\"\",'6. Verifier ONLY - SUMMARY'!F36,\"\")))","v":0},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K36=0,\"\",'6. Verifier ONLY - SUMMARY'!K36)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L36=\"Yes\",'6. Verifier ONLY - SUMMARY'!N36<>\"\"), '6. Verifier ONLY - SUMMARY'!N36,IF(AND('6. Verifier ONLY - SUMMARY'!L36=\"Yes\",'6. Verifier ONLY - SUMMARY'!N36=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I36<>\"\",'6. Verifier ONLY - SUMMARY'!I36,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B37","v":"Social 2.9"},{"$f":"'6. Verifier ONLY - SUMMARY'!D37","v":"Employer assures proper occupational health and safety conditions for workers. "},{"$f":"IF('6. Verifier ONLY - SUMMARY'!L37<> \"No\",6,IF('6. Verifier ONLY - SUMMARY'!F37<2,0,IF('6. Verifier ONLY - SUMMARY'!F37>2,3,IF(H46<>\"\",3,0))))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L37=\"Yes\",'6. Verifier ONLY - SUMMARY'!M37<>\"\"), '6. Verifier ONLY - SUMMARY'!M37,IF(AND('6. Verifier ONLY - SUMMARY'!L37=\"Yes\",'6. Verifier ONLY - SUMMARY'!M37=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!F37<>\"\",'6. Verifier ONLY - SUMMARY'!F37,\"\")))","v":0},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K37=0,\"\",'6. Verifier ONLY - SUMMARY'!K37)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L37=\"Yes\",'6. Verifier ONLY - SUMMARY'!N37<>\"\"), '6. Verifier ONLY - SUMMARY'!N37,IF(AND('6. Verifier ONLY - SUMMARY'!L37=\"Yes\",'6. Verifier ONLY - SUMMARY'!N37=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I37<>\"\",'6. Verifier ONLY - SUMMARY'!I37,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B38","v":"Environmental 3.1 "},{"$f":"'6. Verifier ONLY - SUMMARY'!D38","v":"Conservation of biodiversity, including protected or endangered native flora and fauna is supported."},{"$f":"IF('6. Verifier ONLY - SUMMARY'!L38<> \"No\",6,IF('6. Verifier ONLY - SUMMARY'!F38<2,0,IF('6. Verifier ONLY - SUMMARY'!F38>2,3,IF(H47<>\"\",3,0))))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L38=\"Yes\",'6. Verifier ONLY - SUMMARY'!M38<>\"\"), '6. Verifier ONLY - SUMMARY'!M38,IF(AND('6. Verifier ONLY - SUMMARY'!L38=\"Yes\",'6. Verifier ONLY - SUMMARY'!M38=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!F38<>\"\",'6. Verifier ONLY - SUMMARY'!F38,\"\")))","v":0},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K38=0,\"\",'6. Verifier ONLY - SUMMARY'!K38)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L38=\"Yes\",'6. Verifier ONLY - SUMMARY'!N38<>\"\"), '6. Verifier ONLY - SUMMARY'!N38,IF(AND('6. Verifier ONLY - SUMMARY'!L38=\"Yes\",'6. Verifier ONLY - SUMMARY'!N38=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I38<>\"\",'6. Verifier ONLY - SUMMARY'!I38,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B39","v":"Environmental 3.2"},{"$f":"'6. Verifier ONLY - SUMMARY'!D39","v":"Use of pesticides is minimised and integrated pest, weed and disease management is improved with time."},{"$f":"IF('6. Verifier ONLY - SUMMARY'!L39<> \"No\",6,IF('6. Verifier ONLY - SUMMARY'!F39<2,0,IF('6. Verifier ONLY - SUMMARY'!F39>2,3,IF(H48<>\"\",3,0))))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L39=\"Yes\",'6. Verifier ONLY - SUMMARY'!M39<>\"\"), '6. Verifier ONLY - SUMMARY'!M39,IF(AND('6. Verifier ONLY - SUMMARY'!L39=\"Yes\",'6. Verifier ONLY - SUMMARY'!M39=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!F39<>\"\",'6. Verifier ONLY - SUMMARY'!F39,\"\")))","v":0},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K39=0,\"\",'6. Verifier ONLY - SUMMARY'!K39)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L39=\"Yes\",'6. Verifier ONLY - SUMMARY'!N39<>\"\"), '6. Verifier ONLY - SUMMARY'!N39,IF(AND('6. Verifier ONLY - SUMMARY'!L39=\"Yes\",'6. Verifier ONLY - SUMMARY'!N39=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I39<>\"\",'6. Verifier ONLY - SUMMARY'!I39,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B40","v":"Environmental 3.3"},{"$f":"'6. Verifier ONLY - SUMMARY'!D40","v":"Harmful effects of pesticides and other hazardous chemicals on human health and the environment are minimised."},{"$f":"IF('6. Verifier ONLY - SUMMARY'!L40<> \"No\",6,IF('6. Verifier ONLY - SUMMARY'!F40<2,0,IF('6. Verifier ONLY - SUMMARY'!F40>2,3,IF(H49<>\"\",3,0))))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L40=\"Yes\",'6. Verifier ONLY - SUMMARY'!M40<>\"\"), '6. Verifier ONLY - SUMMARY'!M40,IF(AND('6. Verifier ONLY - SUMMARY'!L40=\"Yes\",'6. Verifier ONLY - SUMMARY'!M40=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!F40<>\"\",'6. Verifier ONLY - SUMMARY'!F40,\"\")))","v":0},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K40=0,\"\",'6. Verifier ONLY - SUMMARY'!K40)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L40=\"Yes\",'6. Verifier ONLY - SUMMARY'!N40<>\"\"), '6. Verifier ONLY - SUMMARY'!N40,IF(AND('6. Verifier ONLY - SUMMARY'!L40=\"Yes\",'6. Verifier ONLY - SUMMARY'!N40=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I40<>\"\",'6. Verifier ONLY - SUMMARY'!I40,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B41","v":"Environmental 3.4"},{"$f":"'6. Verifier ONLY - SUMMARY'!D41","v":"Soil conservation practices are in place."},{"$f":"IF('6. Verifier ONLY - SUMMARY'!L41<> \"No\",6,IF('6. Verifier ONLY - SUMMARY'!F41<2,0,IF('6. Verifier ONLY - SUMMARY'!F41>2,3,IF(H50<>\"\",3,0))))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L41=\"Yes\",'6. Verifier ONLY - SUMMARY'!M41<>\"\"), '6. Verifier ONLY - SUMMARY'!M41,IF(AND('6. Verifier ONLY - SUMMARY'!L41=\"Yes\",'6. Verifier ONLY - SUMMARY'!M41=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!F41<>\"\",'6. Verifier ONLY - SUMMARY'!F41,\"\")))","v":0},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K41=0,\"\",'6. Verifier ONLY - SUMMARY'!K41)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L41=\"Yes\",'6. Verifier ONLY - SUMMARY'!N41<>\"\"), '6. Verifier ONLY - SUMMARY'!N41,IF(AND('6. Verifier ONLY - SUMMARY'!L41=\"Yes\",'6. Verifier ONLY - SUMMARY'!N41=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I41<>\"\",'6. Verifier ONLY - SUMMARY'!I41,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B42","v":"Environmental 3.5"},{"$f":"'6. Verifier ONLY - SUMMARY'!D42","v":"Mineral and/or organic fertilisers are used in a balanced and appropriate way."},{"$f":"IF('6. Verifier ONLY - SUMMARY'!L42<> \"No\",6,IF('6. Verifier ONLY - SUMMARY'!F42<2,0,IF('6. Verifier ONLY - SUMMARY'!F42>2,3,IF(H51<>\"\",3,0))))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L42=\"Yes\",'6. Verifier ONLY - SUMMARY'!M42<>\"\"), '6. Verifier ONLY - SUMMARY'!M42,IF(AND('6. Verifier ONLY - SUMMARY'!L42=\"Yes\",'6. Verifier ONLY - SUMMARY'!M42=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!F42<>\"\",'6. Verifier ONLY - SUMMARY'!F42,\"\")))","v":0},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K42=0,\"\",'6. Verifier ONLY - SUMMARY'!K42)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L42=\"Yes\",'6. Verifier ONLY - SUMMARY'!N42<>\"\"), '6. Verifier ONLY - SUMMARY'!N42,IF(AND('6. Verifier ONLY - SUMMARY'!L42=\"Yes\",'6. Verifier ONLY - SUMMARY'!N42=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I42<>\"\",'6. Verifier ONLY - SUMMARY'!I42,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B43","v":"Environmental 3.6"},{"$f":"'6. Verifier ONLY - SUMMARY'!D43","v":"Maintenance of organic matter in the soil is promoted."},{"$f":"IF('6. Verifier ONLY - SUMMARY'!L43<> \"No\",6,IF('6. Verifier ONLY - SUMMARY'!F43<2,0,IF('6. Verifier ONLY - SUMMARY'!F43>2,3,IF(H52<>\"\",3,0))))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L43=\"Yes\",'6. Verifier ONLY - SUMMARY'!M43<>\"\"), '6. Verifier ONLY - SUMMARY'!M43,IF(AND('6. Verifier ONLY - SUMMARY'!L43=\"Yes\",'6. Verifier ONLY - SUMMARY'!M43=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!F43<>\"\",'6. Verifier ONLY - SUMMARY'!F43,\"\")))","v":0},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K43=0,\"\",'6. Verifier ONLY - SUMMARY'!K43)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L43=\"Yes\",'6. Verifier ONLY - SUMMARY'!N43<>\"\"), '6. Verifier ONLY - SUMMARY'!N43,IF(AND('6. Verifier ONLY - SUMMARY'!L43=\"Yes\",'6. Verifier ONLY - SUMMARY'!N43=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I43<>\"\",'6. Verifier ONLY - SUMMARY'!I43,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B44","v":"Environmental 3.7"},{"$f":"'6. Verifier ONLY - SUMMARY'!D44","v":"Water resources are conserved and used efficiently."},{"$f":"IF('6. Verifier ONLY - SUMMARY'!L44<> \"No\",6,IF('6. Verifier ONLY - SUMMARY'!F44<2,0,IF('6. Verifier ONLY - SUMMARY'!F44>2,3,IF(H53<>\"\",3,0))))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L44=\"Yes\",'6. Verifier ONLY - SUMMARY'!M44<>\"\"), '6. Verifier ONLY - SUMMARY'!M44,IF(AND('6. Verifier ONLY - SUMMARY'!L44=\"Yes\",'6. Verifier ONLY - SUMMARY'!M44=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!F44<>\"\",'6. Verifier ONLY - SUMMARY'!F44,\"\")))","v":0},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K44=0,\"\",'6. Verifier ONLY - SUMMARY'!K44)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L44=\"Yes\",'6. Verifier ONLY - SUMMARY'!N44<>\"\"), '6. Verifier ONLY - SUMMARY'!N44,IF(AND('6. Verifier ONLY - SUMMARY'!L44=\"Yes\",'6. Verifier ONLY - SUMMARY'!N44=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I44<>\"\",'6. Verifier ONLY - SUMMARY'!I44,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B45","v":"Environmental 3.8"},{"$f":"'6. Verifier ONLY - SUMMARY'!D45","v":"Wastewater management is in place"},{"$f":"IF('6. Verifier ONLY - SUMMARY'!L45<> \"No\",6,IF('6. Verifier ONLY - SUMMARY'!F45<2,0,IF('6. Verifier ONLY - SUMMARY'!F45>2,3,IF(H54<>\"\",3,0))))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L45=\"Yes\",'6. Verifier ONLY - SUMMARY'!M45<>\"\"), '6. Verifier ONLY - SUMMARY'!M45,IF(AND('6. Verifier ONLY - SUMMARY'!L45=\"Yes\",'6. Verifier ONLY - SUMMARY'!M45=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!F45<>\"\",'6. Verifier ONLY - SUMMARY'!F45,\"\")))","v":0},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K45=0,\"\",'6. Verifier ONLY - SUMMARY'!K45)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L45=\"Yes\",'6. Verifier ONLY - SUMMARY'!N45<>\"\"), '6. Verifier ONLY - SUMMARY'!N45,IF(AND('6. Verifier ONLY - SUMMARY'!L45=\"Yes\",'6. Verifier ONLY - SUMMARY'!N45=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I45<>\"\",'6. Verifier ONLY - SUMMARY'!I45,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B46","v":"Environmental 3.9"},{"$f":"'6. Verifier ONLY - SUMMARY'!D46","v":"Safe waste management is in place. "},{"$f":"IF('6. Verifier ONLY - SUMMARY'!L46<> \"No\",6,IF('6. Verifier ONLY - SUMMARY'!F46<2,0,IF('6. Verifier ONLY - SUMMARY'!F46>2,3,IF(H55<>\"\",3,0))))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L46=\"Yes\",'6. Verifier ONLY - SUMMARY'!M46<>\"\"), '6. Verifier ONLY - SUMMARY'!M46,IF(AND('6. Verifier ONLY - SUMMARY'!L46=\"Yes\",'6. Verifier ONLY - SUMMARY'!M46=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!F46<>\"\",'6. Verifier ONLY - SUMMARY'!F46,\"\")))","v":0},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K46=0,\"\",'6. Verifier ONLY - SUMMARY'!K46)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L46=\"Yes\",'6. Verifier ONLY - SUMMARY'!N46<>\"\"), '6. Verifier ONLY - SUMMARY'!N46,IF(AND('6. Verifier ONLY - SUMMARY'!L46=\"Yes\",'6. Verifier ONLY - SUMMARY'!N46=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I46<>\"\",'6. Verifier ONLY - SUMMARY'!I46,\"\")))","v":""}]
[null,null,{"$f":"'6. Verifier ONLY - SUMMARY'!B47","v":"Environmental 3.10"},{"$f":"'6. Verifier ONLY - SUMMARY'!D47","v":"Saving Energy and preferential use of renewable energy"},{"$f":"IF('6. Verifier ONLY - SUMMARY'!L47<> \"No\",6,IF('6. Verifier ONLY - SUMMARY'!F47<2,0,IF('6. Verifier ONLY - SUMMARY'!F47>2,3,IF(H56<>\"\",3,0))))","v":0},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L47=\"Yes\",'6. Verifier ONLY - SUMMARY'!M47<>\"\"), '6. Verifier ONLY - SUMMARY'!M47,IF(AND('6. Verifier ONLY - SUMMARY'!L47=\"Yes\",'6. Verifier ONLY - SUMMARY'!M47=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!F47<>\"\",'6. Verifier ONLY - SUMMARY'!F47,\"\")))","v":0},{"$f":"IF('6. Verifier ONLY - SUMMARY'!K47=0,\"\",'6. Verifier ONLY - SUMMARY'!K47)","v":""},{"$f":"IF(AND('6. Verifier ONLY - SUMMARY'!L47=\"Yes\",'6. Verifier ONLY - SUMMARY'!N47<>\"\"), '6. Verifier ONLY - SUMMARY'!N47,IF(AND('6. Verifier ONLY - SUMMARY'!L47=\"Yes\",'6. Verifier ONLY - SUMMARY'!N47=\"\"),\"\",IF('6. Verifier ONLY - SUMMARY'!I47<>\"\",'6. Verifier ONLY - SUMMARY'!I47,\"\")))","v":""}]

{"sheet":"Calculations","index":8,"n_rows":49,"n_cols":15,"rows_kept":49,"cut":false,"hidden":true,"merged":[[31,10,31,15],[32,10,32,15],[34,10,34,15],[40,10,42,15],[29,10,29,15],[1,0,1,1],[1,5,1,8],[16,5,16,8],[18,10,18,15],[30,5,30,8],[26,6,27,6],[27,10,27,15]]}
[]
["Unacceptable practices",null,null,null,null,"ECONOMIC DIMENSION"]
[{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D8","v":"CHILD LABOUR"},2,null,null,null,1.1000000000000001,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D46","v":"Profitability and long term productivity"},null,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!G47","v":2}]
[{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D11","v":"FORCED AND BONDED LABOUR, TRAFFICKING IN PERSONS"},2,null,null,null,1.2,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D55","v":"Capacity and skill development"},null,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!G56","v":2},null,"The text  in this box is only used for the text of the unacceptable practices"]
[{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D14","v":"MEMBERSHIP OF AND REPRESENTATION BY A TRADE UNION"},2,null,null,null,1.3,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D70","v":"Record keeping"},null,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!G71","v":2},null,"PLEASE ANSWER ALL QUESTIONS !"]
[{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D17","v":"FORCED EVICTION WITHOUT ADEQUATE COMPENSATION"},2,null,null,null,1.4,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D84","v":"Access to services"},null,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!G85","v":2},null,"PLEASE TICK FOR ASSESSMENT"]
[{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D20","v":"ADEQUATE HOUSING FOR WORKERS"},2,null,null,null,1.5,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D97","v":"Market information and commerce"},null,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!G98","v":2},null,"OK"]
[{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D23","v":"POTABLE WATER"},2,null,null,null,1.6,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D110","v":"Quality"},null,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!G111","v":2},null,"UNNACEPTABLE PRACTICES"]
[{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D26","v":"NATURAL RESOURCES"},2,null,null,null,1.7,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D124","v":"Business integrity (transparent business practices)"},null,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!G125","v":2},null,"YOU CAN CONTINUE WITH THE SELF ASSESSMENT"]
[{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D29","v":"USE OF INTERNATIONALLY BANNED PESTICIDES "},2,null,null,null,1.8,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D133","v":"Traceability"},null,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!G134","v":2},null,"YOU CAN NOT CONTINUE WITH THE SELF ASSESSMENT"]
[{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D32","v":"USE OF GENETICALLY MODIFIED ORGANISMS (GMOs)"},2]
[{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D35","v":"BUSINESS RELATIONS"},2,null,null,null,null,null,null,null,null,"Changing the text in this box, changes the text throughout all sheets!"]
["Results unacceptables",null,null,null,null,null,null,null,null,null,"You cannot change the formulas in this box. "]
["Unacceptables:",{"$f":"COUNTIF(B3:B12,1)","v":0},null,null,null,null,"AVG",null,{"$f":"AVERAGE(I3:I10)","v":2},null,"The actual formulas can only be changed in Cells B 15, 14 and 15 respectively!!!"]
["Not ticked yet:",{"$f":"COUNTIF(B3:B12,0)","v":0},null,null,null,null,null,null,{"$f":"IF(B19>0,$O$24,IF(B20=8,$O$23,IF(B23>0,$O$20,IF(I14>1<=1.5,$O$22,IF(I14<2.1,$O$21)))))","v":"AVERAGE YELLOW"}]
["Acceptables",{"$f":"SUM(B3:B12)","v":20}]
[null,null,null,null,null,"SOCIAL DIMENSION"]
["Results Economic",null,null,null,null,2.1,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D152","v":"Discrimination (ILO Conventions 110, 111, 100)"},null,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!G153","v":2}]
["Not ticked yet:",{"$f":"COUNTIF($I$3:$I$13,0)","v":0},null,null,null,2.2000000000000002,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D164","v":"Right to childhood and education"},null,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!G165","v":2},null,"Explanation different averages with results\nDimensions:"]
["amount of greens",{"$f":"COUNTIF($I$3:$I$13,1)","v":0},null,null,null,2.2999999999999998,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D180","v":"Freedom of Association"},null,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!G181","v":2},null,null,null,null,null,"TOO MANY REDS"]
["amount of yellows",{"$f":"COUNTIF($I$3:$I$13,2)","v":8},null,null,null,2.4,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D192","v":"Right to collective bargaining"},null,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!G193","v":2},null,null,null,null,null,"AVERAGE YELLOW"]
["amount of reds",{"$f":"COUNTIF($I$3:$I$13,3)","v":0},null,null,null,2.5,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D202","v":"Working Conditions – Labour contract"},null,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!G203","v":2},null,null,null,null,null,"ALMOST GREEN"]
["reds - greens",{"$f":"B22-B20","v":0},null,null,null,2.6,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D214","v":"Working Conditions – Working hours"},null,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!G215","v":2},null,null,null,null,null,"ALL GREEN"]
[null,null,null,null,null,2.7,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D228","v":"Working Conditions – Wages"},null,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!G229","v":2},null,"Overall results (see cell I45)",null,null,null,"Please tick for assessment"]
["Results Social",null,null,null,null,2.8,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D240","v":"Working Conditions – Seasonal and piece rate workers"},null,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!G241","v":2},null,null,null,null,"Text in case one of the dimensions is red:","You are not ready for verification"]
["Not ticked yet:",{"$f":"COUNTIF($I$18:$I$28,0)","v":0},null,null,null,2.9,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D252","v":"Working Conditions – Occupational Health and Safety"},null,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!G253","v":2},null,null,null,null,"Text in case none of the dimensions is red:","You are ready for verification"]
["amount of greens",{"$f":"COUNTIF($I$18:$I$28,1)","v":0}]
["amount of yellows",{"$f":"COUNTIF($I$18:$I$28,2)","v":9},null,null,null,null,null,null,null,null,"Changing the Bold text in the greenbox, changes the text throughout all sheets!"]
["amount of reds",{"$f":"COUNTIF($I$18:$I$28,3)","v":0},null,null,null,null,"AVG",null,{"$f":"AVERAGE(I18:I28)","v":2}]
["reds - greens",{"$f":"B29-B27","v":0},null,null,null,null,null,null,{"$f":"IF(B26>0,$O$24,IF(B27=9,$O$23,IF(B30>0,$O$20,IF(I29>1<=1.5,$O$22,IF(I29<2.1,$O$21,$O$20)))))","v":"AVERAGE YELLOW"},null,"You cannot change the formulas in this box. "]
[null,null,null,null,null,"ENVIRONMENTAL DIMENSION"]
["Results Environment",null,null,null,null,3.1,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D277","v":"Conservation of Biodiversity"},null,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!G278","v":2},null,"For the results of the 3 dimensions:"]
["Not ticked yet:",{"$f":"COUNTIF($I$32:$I$41,0)","v":0},null,null,null,3.2,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D291","v":"Use of pesticides  "},null,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!G292","v":2},null,"The actual formulas can only be changed in Cells C 15, 31 and 40 respectively!!!"]
["amount of greens",{"$f":"COUNTIF($I$32:$I$41,1)","v":0},null,null,null,3.3,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D305","v":"Handling of pesticides and other hazardous chemicals"},null,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!G306","v":2}]
["amount of yellows",{"$f":"COUNTIF($I$32:$I$41,2)","v":10},null,null,null,3.4,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D317","v":"Soil  Conservation"},null,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!G318","v":2},null,"For the overall results of the 3 dimensions:"]
["amount of reds",{"$f":"COUNTIF($I$32:$I$41,3)","v":0},null,null,null,3.5,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D327","v":"Soil Fertility and nutrient management – Fertilisers "},null,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!G328","v":2},null,"There is only two final results possible: see the text in cells O25 and O26"]
["reds - greens",{"$f":"B36-B34","v":0},null,null,null,3.6,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D341","v":"Soil Fertility and nutrient management – Organic matter"},null,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!G342","v":2}]
[null,null,null,null,null,3.7,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D351","v":"Water – water sources "},null,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!G352","v":2}]
[null,null,null,null,null,3.8,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D363","v":"Water – wastewater "},null,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!G364","v":2}]
["Average ratings",null,"Rounded",null,null,3.9,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D377","v":"Waste "},null,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!G378","v":2}]
[{"$f":"'5. Verifier ONLY- CODE RATING'!B9","v":"Economic dimension "},{"$f":"'5. Verifier ONLY- CODE RATING'!C19","v":"-"},{"$f":"IF(B41<=1.25,\"1\",IF(B41<=2.25,\"2\",IF(B41>2.25,\"3\")))","v":"3"},null,null,3.1,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!D391","v":"Energy"},null,{"$f":"'2. SELF-ASSESSMENT UAP&CODE'!G392","v":2},null,"The actual formula for this, is in cell I45, which will check whether one of the dimensions has a result in red, changing the language or text of the bold text in this greenbox does not effect the working of the formula"]
[{"$f":"'5. Verifier ONLY- CODE RATING'!B20","v":"Social dimension "},{"$f":"'5. Verifier ONLY- CODE RATING'!C31","v":"-"},"3",null,null,null,"AVG",null,{"$f":"AVERAGE(I32:I41)","v":2}]
[{"$f":"'5. Verifier ONLY- CODE RATING'!B32","v":"Environmental dimension "},{"$f":"'5. Verifier ONLY- CODE RATING'!C44","v":"-"},"3",null,null,null,null,null,{"$f":"IF(B33>0,$O$24,IF(B34=10,$O$23,IF(B37>0,$O$20,IF(I42>1<=1.5,$O$22,IF(I42<2.1,$O$21,$O$20)))))","v":"AVERAGE YELLOW"}]
[]
[null,null,null,null,null,null,"Economic",null,{"$f":"I15","v":"AVERAGE YELLOW"}]
[null,null,null,null,null,null,"Social",null,{"$f":"I30","v":"AVERAGE YELLOW"}]
["Advanced, intermediate or basic",null,0,null,null,null,"Environmental",null,{"$f":"I43","v":"AVERAGE YELLOW"}]
[]
[null,null,null,null,null,null,"Is one of the dimensions red or please tick for assessment?",null,{"$f":"IF(I45=O24,O24,IF(I46=O24,O24,IF(I47=O24,O24,IF(I45=O20,O25,IF(I46=O20,O25,IF(I47=O20,O25,O26))))))","v":"You are ready for verification"}]

{"sheet":"Dropdowns","index":9,"n_rows":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":true,"merged":[[5,1,5,3],[1,1,1,10]]}
[]
[null,"For 4C maintenance team: in the green boxes below, you will find the text of the different dropdown boxes used throughout the SA.\nChanging or translating the text here, will change the respective text throughout the SA. Changing the text and or the colors is allowed. Do NOT move the text to another position"]
[]
[]
[]
[null,"3. LIST OF TRAININGS",null,null,null,"6. Verifier ONLY - SUMMARY",null,null,null,"7.IMPROVEMENT PLAN","I20"]
[]
[null,"Yes",null,"GAPS (agricultural innovative techniques and sustainable practices)",null,"Lack of basic IMS",null,null,null,"Elimination of UAP"]
[null,"No",null,"Integrated Pest Management (IPM)",null,"Basic",null,null,null,"Elimination of risk of UAP"]
[null,null,null,"Internal Management System (IMS), business and financial management, record keeping, accounting and administrative procedures; adult literacy",null,"Intermediate"]
[null,1,null,"Occupational health and safety; safe use of agrochemicals\n",null,"Advanced",null,null,null,null,"yellow"]
[null,2,null,"Environmental conservation, waste management , energy conservation, biodiversity conservation",null,null,null,null,null,null,"green"]
[null,null,null,"Business development (market access, marketing strategy, quality control (post-harvest practices, factory processing, quality control, etc.)  ",null,"Not started"]
[null,"Initial Verification",null,"4C and other standards certification or verification process, national legislation and requirements",null,"In progress",null,null,null,null,"UAP excluded"]
[null,"Follow-up Visit",null,"Gender Equality",null,"Finalized: expected performance level reached",null,null,null,null,"UAP not excluded"]
[null,"Addendum Verification",null,"Climate Change"]
[null,"Re-verification",null,"Other cross cutting topics (e.g. youth empowerment, climate change etc.)",null,"V.O. Agreement/disagreement"]
[null,"Annual Update",null,null,null,"Yes"]
[null,null,null,null,null,"No"]
[]
[null,"Initial verification"]
[null,"Addendum Verification",null,"Red rated principles need to be eliminated and turned  into yellow rated principles three years after the first verification. "]
[null,"Re-verification"]
[null,"Follow-up Verification"]
[null,"Annual Update"]
[null,"Follow-up/Addendum"]
[null,"RA Recognition"]
[null,"FT Recognition"]

{"sheet":"Pesticide answers","index":10,"n_rows":196,"n_cols":8,"rows_kept":196,"cut":false,"hidden":true,"merged":[]}
["Q1 ","Q2","Q3","Q4","Q5","Q6","Q7a","Q7b"]
["To be filled in by unit","ValidAI","ValidPest","freq","ValidAmntFarmers","ValidQtyPesticide","Reduce exposure risk","Reduce polluting water"]
[null,"Abamectin","Coffee cherry borer / broca","Just once per season","All or almost all farmers (over 90%)","Open question \nGive approximate volume per season or per application in litres or kg per hectare or per local measure of area (e.g. manzana) or per bush"]
[null,"Acephate","Stemborer caterpillar","Between 1-3 times per season","Many farmers (50-90%)"]
[null,"Acrolein","Black twig borer","More than 3 times per season","Some farmers (10-49%)"]
[null,"Alachlor","Other insects",null,"Only a few farmers (less than 10%)"]
[null,"Aldicarb","Leaf rust"]
[null,"alpha-BHC;alpha-HCH","Coffee berry disease"]
[null,"Alpha-chlorohydrin","Bacterial blight"]
[null,"Aluminum phosphide","Nematodes"]
[null,"Amitrole","Weeds"]
[null,"Anthracene oil","Other"]
[null,"Arsenic and its compounds"]
[null,"Atrazine"]
[null,"Azafenidin"]
[null,"Azinphos-ethyl"]
[null,"Azinphos-methyl"]
[null,"Azocyclotin"]
[null,"Beta-cyfluthrin;Cyfluthrin"]
[null,"beta-HCH; beta-BCH"]
[null,"Bifenthrin"]
[null,"Blasticidin-S"]
[null,"Borax; disodium tetraborate decahydrate"]
[null,"Boric acid"]
[null,"Brodifacoum"]
[null,"Bromadiolone"]
[null,"Bromethalin"]
[null,"Bromoxynil"]
[null,"Butoxycarboxim"]
[null,"Cadusafos"]
[null,"Captafol"]
[null,"Carbaryl"]
[null,"Carbendazim"]
[null,"Carbofuran"]
[null,"Carbosulfan"]
[null,"Chlorantraniliprole"]
[null,"Chlordane"]
[null,"Chlorethoxyphos"]
[null,"Chlorfenapyr"]
[null,"Chlorfenvinphos"]
[null,"Chlormephos"]
[null,"Chlorophacinone"]
[null,"Chloropicrin"]
[null,"Chlorothalonil"]
[null,"Chlorotoluron"]
[null,"Chlorpyrifos"]
[null,"Clothianidin"]
[null,"Coumaphos"]
[null,"Coumatetralyl"]
[null,"Creosote"]
[null,"Cyhalothrin (not lambda)"]
[null,"Cyhalothrin, gamma"]
[null,"Daminozide"]
[null,"DDT"]
[null,"Deltamethrin"]
[null,"Demeton-S-methyl"]
[null,"Dichlorvos;DDVP"]
[null,"Dicrotophos"]
[null,"Difenacoum"]
[null,"Difethialone"]
[null,"Dimethoate"]
[null,"Dimoxystrobin"]
[null,"Dinocap"]
[null,"Dinotefuran"]
[null,"Dinoterb"]
[null,"Diphacinone"]
[null,"Diquat dibromide"]
[null,"Diquat dichloride"]
[null,"Disulfoton"]
[null,"Diuron"]
[null,"DNOC and its salts"]
[]
[null,"Edifenphos"]
[null,"Endosulfan"]
[null,"E-Phosphamidon"]
[null,"Epichlorohydrin"]
[null,"EPN"]
[null,"Epoxiconazole"]
[null,"Ethiofencarb"]
[null,"Ethoprophos; Ethoprop"]
[null,"Ethylene dichloride, EDC"]
[null,"Ethylene oxide"]
[null,"Ethylene thiourea"]
[null,"Ethylenedibromide;1,2-dibromoethane, EDB"]
[null,"Famphur"]
[null,"Fenamiphos"]
[null,"Fenbutatin-oxide"]
[null,"Fenchlorazole-ethyl"]
[null,"Fenitrothion"]
[null,"Fenoxycarb"]
[null,"Fenpropathrin"]
[null,"Fenthion"]
[null,"Fentin acetate"]
[null,"Fentin hydroxide"]
[null,"Fenvalerate"]
[null,"Fipronil"]
[null,"Flocoumafen"]
[null,"Fluazifop-butyl"]
[null,"Flucythrinate"]
[null,"Flumioxazin"]
[null,"Fluoroacetamide"]
[null,"Flusilazole"]
[null,"Formaldehyde"]
[null,"Formetanate"]
[null,"Furathiocarb"]
[null,"Glufosinate-ammonium"]
[null,"Haloxyfop-methyl; haloxyfop"]
[null,"Heptenophos"]
[null,"Hexachlorobenzene (HCB)"]
[null,"Hexachlorocyclohexane  HCH"]
[null,"Imidacloprid"]
[null,"Isoxathion"]
[null,"Lambda-cyhalothrin"]
[null,"Lindane"]
[null,"Linuron"]
[null,"Magnesium phosphide"]
[null,"Malathion"]
[null,"Mancozeb"]
[null,"Mecarbam"]
[null,"Mercury and its compounds"]
[null,"Methabenzthiazuron"]
[null,"Methamidophos"]
[null,"Methamidophos (soluble liquid formulations of the substance that exceed 600 g active ingredient/l)"]
[null,"Methidathion"]
[null,"Methiocarb"]
[null,"Methomyl"]
[null,"Methyl bromide"]
[null,"Methyl-parathion (emulsifiable concentrate (EC) at or above 19.5% active ingredient and dusts at or above 1.5% active ingredient)"]
[null,"Mevinphos"]
[null,"Molinate"]
[null,"Monocrotophos"]
[null,"Nicotine"]
[null,"Nitrobenzene"]
[null,"Omethoate"]
[null,"Oxamyl"]
[null,"Oxydemeton-methyl"]
[null,"Paraffin oils; mineral oils"]
[null,"Paraquat dichloride"]
[null,"Parathion"]
[null,"Parathion-methyl"]
[null,"PCP pentachlorophenol"]
[null,"Permethrin"]
[null,"Phorate"]
[null,"Phosphamidon"]
[null,"Phosphamidon (soluble liquid formulations of the substance that exceed 1000 g active ingredient/l)"]
[null,"Phosphine"]
[null,"Picloram"]
[null,"Potasan"]
[null,"Profoxydim"]
[null,"Propargite"]
[null,"Propetamphos"]
[null,"Propylene oxide"]
[null,"Pyrazophos"]
[null,"Pyrazoxon"]
[null,"Quizalofop-p-tefuryl"]
[null,"Resmethrin"]
[null,"Silafluofen"]
[null,"Sodium fluoroacetate (1080)"]
[null,"Strychnine"]
[null,"Sulfotep"]
[null,"TCMTB"]
[null,"Tebupirimifos"]
[null,"Tefluthrin"]
[null,"Tepraloxydim"]
[null,"Terbufos"]
[null,"Thiacloprid"]
[null,"Thiamethoxam"]
[null,"Thiodicarb"]
[null,"Thiofanox"]
[null,"Thiometon"]
[null,"Thiourea"]
[null,"Tolylfluanid"]
[null,"Triazophos"]
[null,"Trichlorfon"]
[null,"Tridemorph"]
[null,"Trifluralin"]
[null,"Vamidothion"]
[null,"Vinclozolin"]
[null,"Warfarin"]
[null,"zeta-Cypermethrin"]
[null,"Zinc phosphide"]
[null,"Zineb"]
[null,"Ziram"]
[null,"Z-Phosphamidon"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Yes"]
[null,null,"No"]

{"sheet":"HELP!","index":11,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":true,"merged":[[3,1,4,1],[1,1,1,2]]}
[]
[null,"Please see useful tips below"]
[]
[null,"How to add or translate a helping box:","http://excelribbon.tips.net/T006177_Adding_Pop-Up_Documentation_to_a_Cell.html"]
[null,null,"Please be aware, messages have a 256 character limitation"]
[null,"How to amend text in Dropdown boxes:","All Dropbox texts in this Excel, with exception of sheet 7, are amended and/or translated in the Dropdowns sheet."]
[null,"How to amend text in Dropdown boxes, page 7:","Dropdowns in page 7. Pesticice Report are amended/translated in the Pesticide answers sheet"]
[null,"How to delete entries from Dropdown boxes:","Select the cell and hit the backspace or delete button. The entry will be deleted, the dropdown functionality remains."]
[null,"How to amend text in sheet 2. Assessing UAP & Code","Texts can be amended and translated in the Calculations sheet, yellow and green boxes."]
[null,"How to reset the UAP values","Go to the calculation sheet, and set the values in B3 to B12 to zero."]
[null,"How to reset the code principle values (the scroll boxes)","Go to sheet 2. ASSESSING UAP&CODE and select column G;\nType CTRL F\nSelect Replace\nIn the find what box, type 1\nIn the Replace with box, type 0\nHit the Replace All button and click OK\nRepeat this procedure, replacing values 2 and 3 for 0"]
[null,"How to reset the 1. PRIMARY DATA & IMS ","In the calculations sheet, reset Cell C47 to 0"]
[null,"For layout managers the RGB codes for the red yellow green:","Red: 255 102 0\nYellow: 255 204 0\nGreen: 153 204 0"]