{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["DATA","INSTRUCTIONS","1. ISO 9001","2.ISO14001","3.SASSMAQ","RESULT","REF!"],"not_rendered":{"charts":2,"images":2,"external_links":2,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"DATA","index":0,"n_rows":78,"n_cols":18,"rows_kept":78,"merged":[[3,9,3,17],[6,9,6,18],[8,9,8,18],[11,7,11,11],[13,8,13,12],[13,15,13,18],[15,8,15,10],[15,15,15,18],[17,7,17,10],[17,11,17,12],[21,8,21,9],[22,8,22,9],[23,8,23,9],[24,8,24,9],[25,8,25,9],[26,8,26,9],[27,8,27,9],[31,7,31,8],[31,9,31,11],[31,15,31,17],[32,7,32,8],[32,9,32,11],[32,15,32,17],[33,7,33,8],[33,9,33,11],[33,15,33,17],[34,7,34,8],[34,9,34,11],[34,15,34,17],[35,7,35,8],[35,9,35,11],[35,15,35,17],[36,7,36,8],[36,9,36,11],[36,15,36,17],[37,7,37,8],[37,9,37,11],[37,15,37,17],[38,7,38,8],[38,9,38,11],[38,15,38,17],[39,7,39,8],[39,9,39,11],[39,15,39,17],[40,7,40,8],[40,9,40,11],[40,15,40,17],[44,7,44,8],[45,7,45,8],[46,7,46,8],[47,7,47,8],[48,7,48,8],[49,7,49,8],[50,7,50,8],[51,7,51,8],[52,7,52,8],[53,11,53,12],[55,11,55,12],[57,7,57,11],[57,12,57,14],[60,7,60,12],[60,13,60,17],[62,7,62,12],[62,13,62,17],[64,7,64,12],[64,13,64,17],[66,7,66,12],[66,13,66,17],[68,7,68,12],[68,13,68,17],[71,7,71,12],[71,14,71,17],[72,7,72,12],[72,14,72,17],[73,7,73,12],[73,14,73,17],[74,7,74,12],[74,14,74,17],[77,7,80,17]]}
[]
[]
[]
[{"$nulls":9},"SELF-EVALUATION QUESTIONNAIRE TRANSPORT SUPPLIER"]
[]
[]
[{"$nulls":7},"Company Name:"]
[]
[{"$nulls":7},"Internet site:"]
[]
[]
[{"$nulls":7},"Responsible for completing the Questionnaire"]
[]
[{"$nulls":7},"Name:",{"$nulls":6},"Position"]
[]
[{"$nulls":7},"Telephone:",{"$nulls":6},"Email:"]
[]
[{"$nulls":7},"Date of filling in the Questionnaire:"]
[]
[]
[]
[{"$nulls":7},"Units","Address",null,"UF","Telephone","Fax","CGC/CNPJ","Insc. State","Insc. Municipal","Building area","Land Area"]
[{"$nulls":7},"Commercial"]
[{"$nulls":7},"Unit 1"]
[{"$nulls":7},"Unit 2"]
[{"$nulls":7},"Unit 3"]
[{"$nulls":7},"Unit 4"]
[{"$nulls":7},"Unit 5"]
[]
[]
[]
[{"$nulls":7},"Contatos",null,"Name",null,null,"Position","CREA/CRQ","Telephone","Email"]
[{"$nulls":7},"Commercial"]
[{"$nulls":7},"Technical assistance"]
[{"$nulls":7},"Quality"]
[{"$nulls":7},"Production"]
[{"$nulls":7},"Health and safety"]
[{"$nulls":7},"Environment"]
[{"$nulls":7},"Logistics"]
[{"$nulls":7},"Technical manager"]
[{"$nulls":7},"Others"]
[]
[]
[{"$nulls":7},"Number of employees"]
[{"$nulls":7},"Production"]
[{"$nulls":7},"Laboratory"]
[{"$nulls":7},"Technical assistance"]
[{"$nulls":7},"Administrative"]
[{"$nulls":7},"Others"]
[{"$nulls":7},"Third Party on the Plant"]
[{"$nulls":7},"TOTAL",null,{"$f":"SUM(J45:J50)","v":0}]
[]
[]
[{"$nulls":7},"Annual Revenue (R $):",{"$nulls":6},"Base Year:"]
[]
[{"$nulls":7},"Share Capital (R $):",{"$nulls":6},"Base Year:"]
[]
[{"$nulls":7},"Do you belong to any group? Which?"]
[]
[]
[{"$nulls":7},"Subsidiary companies (Name and% of participation):"]
[]
[{"$nulls":7},"Marketed Products / Services Provided:"]
[]
[{"$nulls":7},"Product Production / Processing Capacity:"]
[]
[{"$nulls":7},"Main Suppliers:"]
[]
[{"$nulls":7},"Main customers:"]
[]
[]
[{"$nulls":7},"Is your management system certified to the standards?",{"$nulls":6},"If \"YES\" please send the updated certificate within the validity period"]
[{"$nulls":7},"1.ISO 9001 ",{"$nulls":5},"ANSWER"]
[{"$nulls":7},"2.ISO 14001",{"$nulls":5},"ANSWER"]
[{"$nulls":7},"3.SASSMAQ",{"$nulls":5},"ANSWER"]
[]
[]
[{"$nulls":7},"IF THE SUPPLIER HAS THE ABOVE CERTIFICATION REQUIRED, IT IS DISPENSED TO RESPOND TO ISSUES RELATING TO THAT STANDARD. THE UPDATED CERTIFICATE MUST BE SUBMITTED WITH THIS QUESTIONNAIRE."]

{"sheet":"INSTRUCTIONS","index":1,"n_rows":19,"n_cols":8,"rows_kept":19,"merged":[[1,2,1,7],[2,2,2,7],[3,2,3,7],[4,2,4,7],[5,2,5,7],[6,2,6,7],[7,2,7,7],[8,2,8,3],[8,5,8,7],[9,2,9,3],[9,5,9,6],[10,2,10,3],[10,5,10,6],[11,2,11,3],[11,5,11,6],[12,2,12,3],[12,5,12,6],[13,2,13,7],[14,2,14,7],[15,2,15,5],[15,6,15,7],[16,2,16,5],[16,6,16,7],[17,2,17,5],[17,6,17,7],[18,2,18,5],[18,6,18,7]]}
[]
[null,null,"SUPPLIER AUDIT CRITERIA"]
[]
[null,null,"FILLING INSTRUCTIONS"]
[]
[null,null,"1. Score in the GREEN FIELDS according to criteria based on the table in item 3."]
[null,null,"2. All information must be readable, and this report returned to Oxiteno S.A. Indústria e Comércio."]
[null,null,"3. This information must correspond to the manufacturing plant of the supplier in question."]
[null,null,"Selected",null,"Punctuation","Scoring Criteria for Assessing Compliance with Requirements"]
[null,null,"(Yes)",null,4,"REQUIREMENTS FULLY MET ",null,"Fully existing and documented practice."]
[null,null,"(In implementation)",null,3,"REQUIREMENTS PARTIALLY MET ",null,"Partially existing and undocumented practice"]
[null,null,"(No) ",null,2,"REQUIREMENTS POORLY MET  ",null,"Non-existent practice. Requirements not met.  "]
[null,null,"Not applicable *",null,4,"NOT APPLICABLE",null,"Not applicable (Please explain N.A. items)"]
[null,null,"* Please explain if the requirement is not applicable"]
[null,null,"CLASSIFICATION"]
[null,null,"Between: 0 - 29% - POOR ",{"$nulls":3},"Requires action plan with deadlines established in the \"Actions (Action Plan)\" tab, will not be allowed to supply until action is taken. "]
[null,null,"Between: 30 - 49% - REGULAR",{"$nulls":3},"Requires action plan with deadlines established in the \"Actions (Action Plan)\" tab and is allowed to supply with restrictions. "]
[null,null,"Between: 50 - 79% - GOOD",{"$nulls":3},"Suppliers rated Good have points to be improved. They can usually supply with follow-up."]
[null,null,"Between: 80 - 100% - EXCELLENT",{"$nulls":3},"Suppliers that meet 80% or more of the requirements are considered to be of an Excellent level, being able to supply without restrictions."]

{"sheet":"1. ISO 9001","index":2,"n_rows":117,"n_cols":8,"rows_kept":117,"merged":[[1,1,2,8],[3,1,3,4],[3,7,3,8],[5,1,8,2],[5,3,8,4],[5,5,8,5],[5,6,8,6],[5,7,8,8],[10,1,13,2],[10,3,13,4],[10,5,13,5],[10,6,13,6],[10,7,13,8],[15,1,18,2],[15,3,18,4],[15,5,18,5],[15,6,18,6],[15,7,18,8],[20,1,23,2],[20,3,23,4],[20,5,23,5],[20,6,23,6],[20,7,23,8],[25,1,25,2],[25,3,25,4],[25,7,25,8],[27,1,27,2],[27,3,27,4],[27,7,27,8],[29,1,29,2],[29,3,29,4],[29,7,29,8],[31,1,34,2],[31,3,34,4],[31,5,34,5],[31,6,34,6],[31,7,34,8],[36,1,39,2],[36,3,39,4],[36,5,39,5],[36,6,39,6],[36,7,39,8],[41,1,44,2],[41,3,44,4],[41,5,44,5],[41,6,44,6],[41,7,44,8],[46,1,49,2],[46,3,49,4],[46,5,49,5],[46,6,49,6],[46,7,49,8],[51,1,54,2],[51,3,54,4],[51,5,54,5],[51,6,54,6],[51,7,54,8],[56,1,59,2],[56,3,59,4],[56,5,59,5],[56,6,59,6],[56,7,59,8],[61,1,64,2],[61,3,64,4],[61,5,64,5],[61,6,64,6],[61,7,64,8],[66,1,69,2],[66,3,69,4],[66,5,69,5],[66,6,69,6],[66,7,69,8],[71,1,74,2],[71,3,74,4],[71,5,74,5],[71,6,74,6],[71,7,74,8],[76,1,79,2],[76,3,79,4],[76,5,79,5],[76,6,79,6],[76,7,79,8],[81,1,84,2],[81,3,84,4],[81,5,84,5],[81,6,84,6],[81,7,84,8],[86,1,89,2],[86,3,89,4],[86,5,89,5],[86,6,89,6],[86,7,89,8],[91,1,94,2],[91,3,94,4],[91,5,94,5],[91,6,94,6],[91,7,94,8],[96,1,99,2],[96,3,99,4],[96,5,99,5],[96,6,99,6],[96,7,99,8],[101,1,104,2],[101,3,104,4],[101,5,104,5],[101,6,104,6],[101,7,104,8],[106,1,109,2],[106,3,109,4],[106,5,109,5],[106,6,109,6],[106,7,109,8],[111,1,114,2],[111,3,114,4],[111,5,114,5],[111,6,114,6],[111,7,114,8]]}
[]
[null,"1.QUALITY MANAGEMENT SYSTEM"]
[]
[null,"ITEM",{"$nulls":3},"Self-evaluation","Score","Justification"]
[]
[null,"1.1",null,"Have the Quality Management System and its processes been established?",null,"ANSWER",{"$f":"VLOOKUP(F6,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[]
[]
[]
[null,"1.2",null,"Has the organization's context been outlined and does it consider external, internal, risk, and relevant issues related to its purpose and strategic direction? ",null,"ANSWER",{"$f":"VLOOKUP(F11,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[]
[]
[]
[null,"1.3",null,"Is the organization committed to risk management considering customer satisfaction and requirements? ",null,"ANSWER",{"$f":"VLOOKUP(F16,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[]
[]
[]
[null,"1.4",null,"Does the organization clearly assign roles, responsibilities, and power? ",null,"ANSWER",{"$f":"VLOOKUP(F21,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[]
[]
[]
[null,"1.5",null,"Does the senior management show leadership and commitment to the quality management system?",null,"ANSWER",{"$f":"VLOOKUP(F26,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[null,"1.6",null,"Are the risks and opportunities relevant to the organization and its processes assessed?",null,"ANSWER",{"$f":"VLOOKUP(F28,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[null,"1.7",null,"Are client requirements and statutory requirements taken into account for the results delivered by the organization?",null,"ANSWER",{"$f":"VLOOKUP(F30,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[null,"1.8",null,"Does the quality management system have objectives that support its quality policy?",null,"ANSWER","-"]
[]
[]
[]
[]
[null,"1.9",null,"Are internal and external communication processes established with stakeholders?",null,"ANSWER","-"]
[]
[]
[]
[]
[null,"1.10",null,"Does the organization provide enough resources, staff, and infrastructure to keep the product or service compliant?",null,"ANSWER","-"]
[]
[]
[]
[]
[null,"1.11",null,"Does the organization have a system that ensures the reliability and safety of measuring equipment that impacts product quality? (for example, calibration)",null,"ANSWER","-"]
[]
[]
[]
[]
[null,"1.12",null,"Does the organization use inspection and testing methods to guarantee the quality of the finished product?",null,"ANSWER","-"]
[]
[]
[]
[]
[null,"1.13",null,"Does the organization maintain and improve its employees' skills and awareness?",null,"ANSWER","-"]
[]
[]
[]
[]
[null,"1.14",null,"Does the organization keep a documentation and records control system in its Quality Management System?",null,"ANSWER","-"]
[]
[]
[]
[]
[null,"1.15",null,"Does the organization have adequate management of its processes to deliver a compliant product or service?",null,"ANSWER","-"]
[]
[]
[]
[]
[null,"1.16",null,"Does the organization properly monitor projects under development?",null,"ANSWER","-"]
[]
[]
[]
[]
[null,"1.17",null,"Does the organization control materials or services received externally and have a clear and documented suppliers' approval process, monitoring, and relevant information?",null,"ANSWER","-"]
[]
[]
[]
[]
[null,"1.18",null,"Does the organization ensure that products that do not comply with the specified requirements are identified and monitored to prevent their unintended use or delivery?",null,"ANSWER","-"]
[]
[]
[]
[]
[null,"1.19",null,"Does the organization take into account in its Quality Management System the product or service review records provided by customers?",null,"ANSWER","-"]
[]
[]
[]
[]
[null,"1.20",null,"Does the organization monitor its processes?",null,"ANSWER","-"]
[]
[]
[]
[]
[null,"1.21",null,"Does the organization carry out internal audits from time to time to review its Quality Management System?",null,"ANSWER","-"]
[]
[]
[]
[]
[null,"1.22",null,"Does the organization foster continuous improvement in its processes, products, and people through critical management reviews?",null,"ANSWER","-"]
[]
[]
[]
[]
[null,"1.23",null,"Does the organization handle non-conformities effectively in its Quality Management System?",null,"ANSWER","-"]
[]
[]
[]
[]
[null,"1.24",null,"Does the organization foster product and process traceability unequivocally?",null,"ANSWER","-"]
[]
[]
[]
[]
[{"$nulls":5},"GOT",{"$f":"IF(SUM(G6:G115)=0,\"-\",SUM(G6:G115))","v":"-"}]

{"sheet":"2.ISO14001","index":3,"n_rows":97,"n_cols":8,"rows_kept":97,"merged":[[1,1,2,8],[3,1,4,2],[3,3,4,4],[3,5,3,6],[3,7,4,8],[6,1,9,2],[6,3,9,4],[6,5,9,5],[6,6,9,6],[6,7,9,8],[11,1,14,2],[11,3,14,4],[11,5,14,5],[11,6,14,6],[11,7,14,8],[16,1,19,2],[16,3,19,4],[16,5,19,5],[16,6,19,6],[16,7,19,8],[21,1,24,2],[21,3,24,4],[21,5,24,5],[21,6,24,6],[21,7,24,8],[26,1,29,2],[26,3,29,4],[26,5,29,5],[26,6,29,6],[26,7,29,8],[31,1,34,2],[31,3,34,4],[31,5,34,5],[31,6,34,6],[31,7,34,8],[36,1,39,2],[36,3,39,4],[36,5,39,5],[36,6,39,6],[36,7,39,8],[41,1,44,2],[41,3,44,4],[41,5,44,5],[41,6,44,6],[41,7,44,8],[46,1,49,2],[46,3,49,4],[46,5,49,5],[46,6,49,6],[46,7,49,8],[51,1,54,2],[51,3,54,4],[51,5,54,5],[51,6,54,6],[51,7,54,8],[56,1,59,2],[56,3,59,4],[56,5,59,5],[56,6,59,6],[56,7,59,8],[61,1,64,2],[61,3,64,4],[61,5,64,5],[61,6,64,6],[61,7,64,8],[66,1,69,2],[66,3,69,4],[66,5,69,5],[66,6,69,6],[66,7,69,8],[71,1,74,2],[71,3,74,4],[71,5,74,5],[71,6,74,6],[71,7,74,8],[76,1,79,2],[76,3,79,4],[76,5,79,5],[76,6,79,6],[76,7,79,8],[81,1,84,2],[81,3,84,4],[81,5,84,5],[81,6,84,6],[81,7,84,8],[86,1,89,2],[86,3,89,4],[86,5,89,5],[86,6,89,6],[86,7,89,8],[91,1,94,2],[91,3,94,4],[91,5,94,5],[91,6,94,6],[91,7,94,8]]}
[]
[null,"3.ENVIRONMENTAL MANAGEMENT"]
[]
[{"$nulls":3},"SYSTEM CHECK",null,"SELF-EVALUATION",null,"OBSERVATIONS / JUSTIFICATION"]
[{"$nulls":5},"ACCORDING","SCORE"]
[]
[null,"3.1",null,"Are the permits up to date? (for example, Operation Permit, Fire Department -mandatory-, water resource permit, mandatory permits from the environmental agency/body, etc.)",null,"ANSWER",{"$f":"VLOOKUP(F7,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[]
[]
[]
[null,"3.2",null,"Is there a contingency plan for emergencies? (for example, fires, flood, contamination of rivers and sea, fauna, flora, and chemical spills).",null,"ANSWER",{"$f":"VLOOKUP(F12,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[]
[]
[]
[null,"3.3",null,"Is there a waste and emissions disposal and treatment management program?",null,"ANSWER",{"$f":"VLOOKUP(F17,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[]
[]
[]
[null,"3.4",null,"Is it assured that the disposal is meeting the parameters of the regulatory body?",null,"ANSWER",{"$f":"VLOOKUP(F22,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[]
[]
[]
[null,"3.5",null,"Is there an assessment for hiring suppliers and transporting waste?",null,"ANSWER",{"$f":"VLOOKUP(F27,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[]
[]
[]
[null,"3.6",null,"Is training provided, when requested, to your customers on the correct and rational use of their environmentally harmful products/services?",null,"ANSWER",{"$f":"VLOOKUP(F32,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[]
[]
[]
[null,"3.7",null,"Is technical and environmental information provided to your customers about your products/services?",null,"ANSWER",{"$f":"VLOOKUP(F37,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[]
[]
[]
[null,"3.8",null,"Are gaseous emission control devices installed? (for example, scrubbers, thermo-reactors, gas scrubbers, gas incinerators, etc.)",null,"ANSWER",{"$f":"VLOOKUP(F42,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[]
[]
[]
[null,"3.9",null,"Does the company have an inventory of sources of atmospheric emissions or fugitive emissions? Do you carry out GHG (greenhouse gas inventory)?",null,"ANSWER",{"$f":"VLOOKUP(F47,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[]
[]
[]
[null,"3.10",null,"Is there an investigation and treatment plan in case of soil and groundwater contamination?",null,"ANSWER",{"$f":"VLOOKUP(F52,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[]
[]
[]
[null,"3.11",null,"Does the company have selective collection programs or any other program to reduce the use of natural resources (for example, reduction of energy consumption; reduction of solid waste; reduction of water consumption; reduction of effluent generation, etc.)?",null,"ANSWER",{"$f":"VLOOKUP(F57,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[]
[]
[]
[null,"3.12",null,"Does the company have key environmental performance indicators (KPIs)?",null,"ANSWER",{"$f":"VLOOKUP(F62,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[]
[]
[]
[null,"3.13",null,"Does the company have an Environmental Risk Management Program?",null,"ANSWER",{"$f":"VLOOKUP(F67,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[]
[]
[]
[null,"3.14",null,"Does the company have an Environmental Management System? Does the company review its context as well as its stakeholders? Is the Environmental Management Policy set and communicated?",null,"ANSWER",{"$f":"VLOOKUP(F72,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[]
[]
[]
[null,"3.15",null,"Have the roles and responsibilities within the environmental management model been established?",null,"ANSWER",{"$f":"VLOOKUP(F77,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[]
[]
[]
[null,"3.16",null,"Have the environmental aspects and impacts of your activities, products, and services been identified, registered, controlled, and disclosed?",null,"ANSWER",{"$f":"VLOOKUP(F82,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[]
[]
[]
[null,"3.17",null,"Is there a method/procedure / system for controlling applicable legal requirements, as well as changing current legislation?",null,"ANSWER",{"$f":"VLOOKUP(F87,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[]
[]
[]
[null,"3.18",null,"Are there plans for environmental protection and control equipment inspection?",null,"ANSWER",{"$f":"VLOOKUP(F92,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[]
[]
[]
[{"$nulls":5},"GOT",{"$f":"IF(SUM(G7:G96)=0,\"-\",SUM(G7:G96))","v":"-"}]

{"sheet":"3.SASSMAQ","index":4,"n_rows":62,"n_cols":11,"rows_kept":62,"merged":[[1,4,2,11],[3,4,4,5],[3,6,4,7],[3,8,3,9],[3,10,4,11],[6,4,9,5],[6,6,9,7],[6,8,9,8],[6,9,9,9],[6,10,9,11],[11,4,14,5],[11,6,14,7],[11,8,14,8],[11,9,14,9],[11,10,14,11],[16,4,19,5],[16,6,19,7],[16,8,19,8],[16,9,19,9],[16,10,19,11],[21,4,24,5],[21,6,24,7],[21,8,24,8],[21,9,24,9],[21,10,24,11],[26,4,29,5],[26,6,29,7],[26,8,29,8],[26,9,29,9],[26,10,29,11],[31,4,34,5],[31,6,34,7],[31,8,34,8],[31,9,34,9],[31,10,34,11],[36,4,39,5],[36,6,39,7],[36,8,39,8],[36,9,39,9],[36,10,39,11],[41,4,44,5],[41,6,44,7],[41,8,44,8],[41,9,44,9],[41,10,44,11],[46,4,49,5],[46,6,49,7],[46,8,49,8],[46,9,49,9],[46,10,49,11],[51,4,54,5],[51,6,54,7],[51,8,54,8],[51,9,54,9],[51,10,54,11],[56,4,59,5],[56,6,59,7],[56,8,59,8],[56,9,59,9],[56,10,59,11]]}
[]
[{"$nulls":4},"1.SASSMAQ"]
[]
[{"$nulls":6},"SYSTEM CHECK",null,"SELF-EVALUATION",null,"OBSERVATIONS / JUSTIFICATION"]
[{"$nulls":8},"ACCORDING","SCORE"]
[]
[{"$nulls":4},"3.1",null,"Is there a plan for SASSMAQ certification?",null,"ANSWER",{"$f":"VLOOKUP(I7,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[]
[]
[]
[{"$nulls":4},"3.2",null,"Do you have all the necessary permit for the transport of hazardous and non-hazardous chemicals according to your scope of action?",null,"ANSWER",{"$f":"VLOOKUP(I12,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[]
[]
[]
[{"$nulls":4},"3.3",null,"Are the operations served by at least 70% of own fleet?a?",null,"ANSWER",{"$f":"VLOOKUP(I17,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[]
[]
[]
[{"$nulls":4},"3.4",null,"Is there tracking of 100% of the loads using a GPS or similar system that guarantees real-time information?",null,"ANSWER",{"$f":"VLOOKUP(I22,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[]
[]
[]
[{"$nulls":4},"3.5",null,"Is the inbound information at the loading and unloading points monitored, with intermediate information in case of diversions for different reasons?",null,"ANSWER",{"$f":"VLOOKUP(I27,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[]
[]
[]
[{"$nulls":4},"3.6",null,"Is there a system that enables access to real-time cargo tracking by the customer?",null,"ANSWER",{"$f":"VLOOKUP(I32,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[]
[]
[]
[{"$nulls":4},"3.7",null,"Is the electronic bill of landing issued within 20 minutes to clear the vehicle 24 hours a day?",null,"ANSWER",{"$f":"VLOOKUP(I37,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[]
[]
[]
[{"$nulls":4},"3.8",null,"Are there controls to ensure that the loading or unloading window is adhered to?",null,"ANSWER",{"$f":"VLOOKUP(I42,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[]
[]
[]
[{"$nulls":4},"3.9",null,"Is there a proactive communication of possible delivery delays for different reasons?",null,"ANSWER",{"$f":"VLOOKUP(I47,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[]
[]
[]
[{"$nulls":4},"3.10",null,"Is there a sustainable action to tackle CO2 emissions from vehicles used by your company?",null,"ANSWER",{"$f":"VLOOKUP(I52,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[]
[]
[]
[{"$nulls":4},"3.11",null,"Is there follow-up for immediate action on divergent freight values on the electronic bill of landing?",null,"ANSWER",{"$f":"VLOOKUP(I57,'REF!'!$B$2:$C$6,2,FALSE)","v":"-"}]
[]
[]
[]
[]
[{"$nulls":8},"GOT",{"$f":"IF(SUM(J7:J61)=0,\"-\",SUM(J7:J61))","v":"-"}]

{"sheet":"RESULT","index":5,"n_rows":8,"n_cols":6,"rows_kept":8,"merged":[[1,1,1,4],[1,5,1,13],[2,1,3,1],[2,2,3,2],[2,3,2,4]]}
[]
[null,"EVALUATION RESULT",{"$nulls":3},"SELF-EVALUATION"]
[null,"MAIN POINTS","MAXIMUM POINT","SELF-EVALUATION"]
[{"$nulls":3},"POINTS OBTAINED","ATTENDANCE (%)"]
[null,{"$f":"DATA!H73","v":"1.ISO 9001 "},96,{"$f":"IF(DATA!N73=\"YES\",96,'1. ISO 9001'!G117)","v":"-"},{"$f":"IFERROR((D5/C5),\"DOES NOT HAVE CERTIFICATION FOR THIS CRITERION\")","v":"DOES NOT HAVE CERTIFICATION FOR THIS CRITERION"}]
[null,{"$f":"DATA!H74","v":"2.ISO 14001"},72,{"$f":"IF(DATA!N74=\"YES\",72,'2.ISO14001'!G97)","v":"-"},{"$f":"IFERROR((D6/C6),\"DOES NOT HAVE CERTIFICATION FOR THIS CRITERION\")","v":"DOES NOT HAVE CERTIFICATION FOR THIS CRITERION"}]
[null,{"$f":"DATA!H75","v":"3.SASSMAQ"},44,{"$f":"IF(DATA!N75=\"YES\",44,'3.SASSMAQ'!J62)","v":"-"},{"$f":"IFERROR((D7/C7),\"DOES NOT HAVE CERTIFICATION FOR THIS CRITERION\")","v":"DOES NOT HAVE CERTIFICATION FOR THIS CRITERION"}]
[{"$nulls":4},{"$f":"IFERROR(SUM(D5:D7)/SUM(C5:C7),\"-\")","v":{"v":0,"d":"0%"}}]

{"sheet":"REF!","index":6,"n_rows":6,"n_cols":5,"rows_kept":6,"hidden":true}
[null,"ANSWER","Scores"]
[null,"ANSWER","-",null,"ANSWER"]
[null,"Not Applicable ",4,null,"YES"]
[null,"No  ",0,null,"NO"]
[null,"In Implementation",2]
[null,"Yes",4]