{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","Prework","Audit Checklist","CAPA Tracking","Evaluation","List of supportive documents","Revision Tracking"],"not_rendered":{"charts":1,"images":8,"macros":1,"external_links":6,"defined_names":79,"comments":2,"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":"Instructions","index":0,"n_rows":66,"n_cols":5,"rows_kept":66,"cut":false,"hidden":false,"merged":[[1,1,2,9],[3,4,3,6],[41,3,41,4]]}
[]
[null,"ABB Electrification GATE1 Supplier Qualification Generic Audit Checklist"]
[]
[null,"Information and Instructions"]
[]
[]
[null,"PURPOSE"]
[null,"This document is developed as an Audit Tool to qualify new or existing suppliers"]
[]
[null,"SCOPE"]
[null,"The  Audit checklist  is primarily intended to be used for New or Existing direct material supplier, manufacturers  for ABB."]
[]
[null,"HOW TO"]
[null,"Please (have the supplier) fill all requested information in the PreWork Sheet and Audit Checklist tabs"]
[null,"Please fill the header of Audit Checklist tab with info. Add a unique report id number by following the coding rules:"]
[null,"Report id number format coding:\nG1GEN_BusAreaDivision code_SITEID_vendorname_GUID NR_DD_MM_YYYY\nExample:\nG1GEN_ELSB_DESTO_Prasmet_G11274950_14_05_2020\n","G1 Gen = Gate 1 Generic  -If new supplier with no GUID insert \"NEW\""]
[null,"In the audit Checklist , in the column E \"Score\"  please indicate your response. The scoring guide in column D will support "]
[null,"In the column F is mandatory  to indicate the type of improvement requested. Please select."]
[null,"Please indicate, in the \"Comments\" cell details or clarifications if required"]
[null,"Please note some questions require supporting documentation, please ensure appropriate  documents are attached. "]
[null,"Insufficient comments and documentation, may delay the assessment."]
[null,"To Create Audit Report, please go to CAPA Tracking sheet and select the improvement types that you wish to see."]
[null,"                                                                           "]
[null,"AUDIT MECHANICS and QUESTIONS"]
[null,"The questions in the Audit checklist are grouped in sections,  covering several areas."]
[null,"The questions were devised and developed as closed questions with every attempt to avoid ambiguity."]
[null,"The questions are intended to determine if the criterion is either fully, partially or not met. If the Criterion is Fully Met, a score of 3 is obtained. "]
[null,"Any Criterion that scores 3 shall be clearly demonstrated, followed, and be beyond reproach."]
[null,"The questions are supported by a scoring guide in order to determine the more appropriate answer"]
[null,"If the Criterion is not met, the answer is No, and a score of 0 is given."]
[null,"If the question is not applicable the NA selection is allowed and will not be counted in the overall summary"]
[]
[]
[null,"AUDIT RESULTS"]
[null,"The SQE Auditor reviews all the information provided by the supplier"]
[null,"The SQE could request support from different functions in ABB to assess the audit result"]
[null,"The overall process average result determines the Audit score achieved for the supplier assessed."]
[null,"The overall audit outcome shall be evaluated based on overall score, number of minor, major and show stopper findings, and whether the audit is conducted at a new supplier or existing supplier. The detailed evaluation rules are as defined in the below Audit Evaluation Matrix"]
[]
[]
[]
[null,null,null,"CONSEQUENCES, ACTIONS"]
[null,"ShowStopper ",null,"New Vendor","Existing Vendor"]
[null,"Yes",null,"FAILED: No Business allowed","FAILED: No new PO allowed"]
[null,"No",null,"PASSED: Business Allowed","PASSED: Business Allowed"]
[]
[null,"Score"]
[null,"from 0%","to 79,99%","FAILED: No Business allowed","CONDITIONALLY PASSED\nNo new business until all  major findings closed "]
[null,"from 80%","to 100%","PASSED: Business Allowed","PASSED: Business Allowed"]
[]
[null,"Major Finding "]
[null,"Yes",null,"FAILED: No Business allowed","CONDITIONALLY PASSED\nNo new business until all  major findings closed "]
[null,"No",null,"PASSED: Business Allowed","PASSED: Business Allowed"]
[]
[null,"Minor finding"]
[null,"Yes",null,"CONDITIONALLY PASSED\nBusiness can started, findings to be closed in agreed timeframe. ","PASSED \nExisting business can be  continued, new business can be started, findings to be closed in agreed timeframe. "]
[null,"No",null,"PASSED: Business Allowed","PASSED: Business Allowed"]
[]
[]
[]
[]
[]
[]
[null,"A PASS RESULT"]
[null,"Once a supplier's facility has passed the Audit , the supplier is qualified or re-qualified and a PO can be issued or can continue to be part of the ABB Supply base."]
[null,"In case of new supplier qualification, the report shall be uploaded by the Project Owner to SAP ARIBA Supplier Qualification Workflow."]

{"sheet":"Prework","index":1,"n_rows":64,"n_cols":15,"rows_kept":64,"cut":false,"hidden":false,"merged":[[62,2,62,14],[65,2,65,12],[65,13,65,14],[55,12,55,13],[56,12,56,13],[57,12,57,13],[58,12,58,13],[59,12,59,13],[64,2,64,12],[64,13,64,14],[63,2,63,12],[63,13,63,14],[46,1,46,15],[48,2,48,14],[55,2,55,3],[55,4,55,11],[60,12,60,13],[12,10,12,11],[13,2,13,4],[13,5,13,7],[12,5,12,7],[44,2,44,5],[44,6,44,8],[44,9,44,14],[4,1,4,15],[7,2,7,4],[7,5,7,7],[11,5,11,7],[5,1,5,15],[7,10,7,11],[8,2,8,4],[8,5,8,7],[9,10,9,11],[11,2,11,4],[15,2,15,4],[15,5,15,7],[14,13,14,14],[15,10,15,11],[24,2,24,14],[16,2,16,4],[16,5,16,7],[17,2,17,4],[17,5,17,7],[18,2,18,4],[18,5,18,7],[19,2,19,4],[19,5,19,7],[20,2,20,4],[20,5,20,7],[21,2,21,4],[21,5,21,7],[40,2,40,5],[40,6,40,8],[40,9,40,14],[25,2,25,14],[26,2,26,14],[27,2,27,14],[28,2,28,14],[29,2,29,14],[30,2,30,14],[33,2,33,14],[43,2,43,5],[43,6,43,8],[43,9,43,14],[1,9,2,11],[69,10,70,12],[41,2,41,5],[41,6,41,8],[41,9,41,14],[42,2,42,5],[42,6,42,8],[42,9,42,14],[31,2,31,14],[32,2,32,14],[47,2,47,14],[50,3,50,4],[51,3,51,4],[49,5,49,11],[49,12,49,13],[50,5,50,11],[52,3,52,4],[54,2,54,14]]}
[]
[]
[]
[null,"*TO BE FILLED OUT BY SUPPLIER"]
[null,"Supplier Information"]
[null,"Supplier Information"]
[null,null,"A)  Description of the Auditee (site audited):",null,null,null,null,null,null,null,"B)  Key Contacts at Auditee:"]
[null,null,"Have ISO Certificate? (Y/N)",null,null,"Yes",null,null,null,null,"Quality Manager:",null,null,"Phone:","M (803) 968-2859 "]
[null,null,"Which ISO standards?",null,null,"9001:2015",null,null,null,null,"Name:","Patrick Macias ",null,"Email:","pmacias@jemisonmetals.com"]
[null,null,null,null,null,null,null,null,null,null,"Operations Manager:",null,null,"Phone:","803-968-3173"]
[null,null,null,null,null,null,null,null,null,null,"Name:","Marion Pitts",null,"Email:","mpitts@jemisonmetals.com"]
[null,null,"Date of last third parties external audit:",null,null,"2022-03-11"]
[null,null,"External audit result ( # NCs):",null,null,0,null,null,null,null,"Engineering Manager:",null,null,"Phone:","205-910-0485"]
[null,null,"3 month rolling DPPM:",null,null,2996,null,null,null,null,"Name:","Rick Rowland",null,"Email:","rrowland@jemisonmetals.com"]
[null,null,"DPPM Trend",null,null,"Provided"]
[null,null,"Organizational Chart:  ",null,null,"Available in person during audit",null,null,null,null,"Sourcing Manager:",null,null,"Phone:","205-612-9606"]
[null,null,"Number of Employees:  ",null,null,null,null,null,null,null,"Name:","Brandy McDonald",null,"Email:","bmcdonal@jemisonmetals.com"]
[null,null,"Number of Shifts:  ",null,null,1.5]
[null,null,"Facility Size (ft2 or m2):  ",null,null,"81,000 square feet"]
[null,null,"Non-disclosure signed? (Y/N)",null,null,"no",null,null,null,null,"Filled out by (supplier repr.):",null,null,"Patrick Macias"]
[null,null,"  If yes,  location?",null,null,null,null,null,null,null,"Date: ","2024-04-29"]
[null,null,"Primary Language of Audit",null,null,"English"]
[]
[null,null,"C) Additional Supplier Information"]
[null,null,"1. General background Information about this supplier site. "]
[null,null,"Jemison-Sumter has supplied Mebane site since 2006 and Selmer since 2010"]
[]
[null,null,"2.  Details of other supplier sites.  Do the other sites make products for ABB ?"]
[null,null,"Lynchburg, VA and Decatur, AL and Gadsden, AL have supplied Mebane and Selmer on occasion (to fill in excess orders)                                            "]
[]
[null,null,"3.  Major Products/Services supplied to other ABB if already supplied ABB in the past "]
[null,null,"Carbon sheet, blank and slit coil (HRPO, Galvanized and Cold Rolled).  Very little stainless and aluminum                                                         "]
[]
[]
[]
[null,null,"D) Supplier to provide a copy of: (Send information with this file before the audit)"]
[null,null,null,"Quality Manual (If available)",null,null,null,"Corrective Actions Procedure",null,null,null,null,"Relevant process flow diagrams or process maps"]
[null,null,null,"Documented Information Procedures ",null,null,null,"Organization Chart",null,null,null,null,"Relevant Contol Plans"]
[]
[null,null,"E)  Sub-tier Supplier(s) of interest. (especially those used for outsourced processes)"]
[null,null,"Supplier Name",null,null,null,"Location",null,null,"Activity"]
[null,null,"NA"]
[]
[]
[]
[]
[null,"Section 2:  Preparation"]
[]
[null,null,"Previous CAPA (Supplier Corrective Actions and Preventive Actions)"]
[null,null,"CAPA type","CAPA ID/ Source",null,"CAPA details",null,null,null,null,null,null,"CAPA open or closed?",null,"Closure verified during audit?"]
[null,null,"CA  ","CA 3912 (1/30/2012)",null,"Jemison folloeing GE corporate instructions packaged wirh plastic banding. Banding broke in transit. Selmer location requested change to metal banding.",null,null,null,null,null,null,"Closed"]
[]
[]
[]
[null,null,"Engineering changes (list the most recent engineering changes from ABB)"]
[null,null,"Change number",null,"Details",null,null,null,null,null,null,null,"Change implemented?",null,"Closure verified during audit?"]
[null,null,"NA"]
[]
[]
[]
[]
[]
[null,null,"Any other Problems, Projects, or Issues with supplier? (to be filled out by ABB Auditor)"]
[null,null,"Details",null,null,null,null,null,null,null,null,null,null,"Audit Outcome"]

{"sheet":"Audit Checklist","index":2,"n_rows":116,"n_cols":7,"rows_kept":116,"cut":false,"hidden":false,"merged":[[8,2,8,3],[7,2,7,3],[1,2,1,3],[2,2,2,3],[3,2,3,3],[4,2,4,3],[5,2,5,3],[6,2,6,3]]}
[]
[null,"Supplier Name:","Jemison Steel Site Audit"]
[null,"Supplier site (Address):","1255 North Gate Drive  Sumter, SC 29154"]
[null,"Supplier GUID:"]
[null,"Audit Date:","May 2nd 2024"]
[null,"ABB Lead Auditor:","Henry George"]
[null,"ABB Participants: ","Shri Mehta,  Roberto Arroya  Jennifer Robison"]
[null,"ABB BA and Division conducting the audit:"]
[null,"Audit report id:"]
[]
["Sr. No.","1. Compliance (HSE, sustainability, SRG)","Audit Area","Scoring guide","Score","Improvement type","Comment"]
["1.1","During  the facility tour (including outside premises), did  any concern arose on the following areas: noise, air emissions, waste disposal, water discharges?\n(Look for: excessive noise levels and boundary, visible haze or chemical mist or dust, abnormal vegetation, waterways, hazardous waste storage)","Factory Tour, \nHSE","0 - Pollution observed to the air, waste water discharged to public drain or to soil, abnormal vegetation conditions, excessive noise and located in a residential area.\n1 - Local authority permits in process, concerns found but corrective actions in place to mitigate problem.\n2 - Plant located in a residential area but have all law permits to operate.\n3 - During plant inspection/tour, no evidence found of environmental threats or breach, hazardous material and chemical containers well storage and disposed.",3,null,"Jemison uses an outside certified hazmat business to handle disposal of hazardous materials. Jemison's air emissions and water discharges are minimal, near to zero. Noise protection levels and hearing ability checks for employees on periodic level."]
["1.2\n","Is there a medical surveillance program in place to monitor personnel health conditions? Are there First Aid Kits (FAK) available, suitable for the purpose, conisdering the size of the facility, type of hazards and number of employees? \n","Meeting Room,\nFactory Tour, \nHSE","0 - No plan or FAK in place.\n1 - Considered but not consistent.\n2 - General program in place, not focused on individuals or areas of concern due to the type of work executed. FAK in some places, but content not complete, or expiry dates of materilas have run out.\n3 - Extensive and comprehensive program to monitor employees health, including follow up and relocation programs if necessary.  Metrics established and monitored.",2,null,"FAK in place. An outside contractor reviews and replenishes inventory monthly. Have people get certified for First Aid training.  No medical surveilance program for employees."]
["1.3","While doing the plant tour, have any concerns been identified regarding: electrical safety, machine guarding, or other risk on employees due to improper working practices?\n(Check: electrical cables and boards conditions, rotatory or machinery with movement guarding)","Factory Tour, \nHSE","0 - Poor electrical wiring, no guards on machinery.\n1 - Just some guards observed.  Found electrical wiring in bad conditions.\n2 - The majority of the wiring and electrical installations are professionally made.  Guards on all expose to employee machinery\n3 - Electrical wiring in good conditions, boards and switches identified and locked where needed.  Guards in place (light curtains, physical, etc.)",2,"Meet Requirement","All wiring is protected and professionally made. One machine with poor wiring was observed."]
["1.4","Are employees wearing the appropriate personal protective equipment when necessary, such as specific masks, hearing protection equipment, eye protection measures, safety shoes, gloves, etc..\n","Factory Tour, \nHSE","0 - Personnel performing operations with no PPE or high risk operations.\n1 - Confusion on what and where to wear PPE, no clear signs to identify what to use. Some level of PPE been used.\n2 - Employees wearing proper PPE, areas of opportunity on signs and instructions.\n3 - Evidence of training program in place to make people conscious  about high risks, auto evaluations on PPE importance. ",1,"Observation","All floor personnel are required to wear the same PPE regardless of position in plant. Safety glasses and safety shoes. Employees not wearing hearing protection as observed. Review with OSHA the requirement for hard hats. There should be a signage indicating which area needs the hearing protection.   1910.95  Occupational noise exposure  OSHA Hearing conservation program - whenever noise exposures equal or exceed 8-hour TWA of 85 db "]
["1.5","Rate overall facility housekeeping, include office areas, dining room, restroom and common areas.  (Observe for equipment well preserved, no oil leaks, wet areas, etc.)","Factory Tour, \nHSE","0 - Plant not well preserved, excessive dust or water/oil leaks.  Dark areas and not proper lighting on productive stations.\n1 - Poor lighting, excessive cleaning (outside of normal operation), no program to permanent fix of issues.\n2 - Areas of opportunity identified.\n3 - Well preserved facility, proper lighting and good housekeeping program",3,"Minor","Housekeeping. One fork lift was under maintenance for oil leaks as observed. 5S program not in place which is recommended.  Another recommendation is about the measurement of lighting in the plant if it meets the requirements.         Minor Findings During our factory Audit we came across several Racks  without load ratings. OSHA 1910.176 (b) Storage of material shall not create a hazard. Bags, containers, bundles, etc., stored in tiers shall be stacked, blocked, interlocked and limited in height so that they are stable and secure against sliding or collapse. OSHA recommends that load ratings be present which provide the maximum permissible unit load and/or maximum uniformly distributed load per level, the average unit load, and maximum total load per bay. See ANSI/RMI MH16.1 for additional information. "]
["1.6","Does the facility have all required local fire code authorizations?\nAre fire drills performed at least once per year and including all shifts? \nAre there clearly marked emergency exits that are visible from all corridors, staircases, and aisle ways?  \nDoes the facility have at least two clearly designated emergency exits equipped with crash bars on each floor with a travel distance of no more than 60 meters from any work area?","Meeting Room, \nHSE","0 - No fire authorization, no evidence of fire drills conducted, exits not marked or plan in place to evacuate the plant, no fire extinguishers or they are not regularly inspected.\n1 - No exit signs marked and or obstructed.  No evidence of at least 1 drill performed every year. Fire extinguishers in place and some are regularly inspected.\n2 - Drills performed but they don´t including all shifts. Fire extinguishers in place in sufficient quantity, and most of them are regularly inspected. \n3 - Documents presented and up to date, fire drills conducted including all shifts along with proper authorities, exit signs visible and according to facility. Fire extinguishers in place in sufficient quantity, and are regularly inspected. ",3,"Minor","Fire extinguishers in place and inspected regularly. All exits clearly marked with crash bars and unobstructed. No fire drills conducted in a recent past as per audittee which should be conducted. Although the employees trained using safety videos.      Minor Findings During our factory floor Audit, we noticed electrical load centers had obstructed access. The National Electrical Code requires “clear space”, referred to as working space around the panelboard to ensure easy access. Additionally, OSHA requirement 1910.303 (g)(1)(i)(B) states: The width of working space in front of the electric equipment shall be the width of the equipment or 762 mm (30 in.), whichever is greater. In all cases, the working space shall permit at least a 90-degree opening of equipment doors or hinged panels. "]
["1.7","Does the company maintain a process to restrict unauthorized access?","Factory Tour / \nMeeting Room, \nSecurity","0 - No process to prevent unauthorized access to productive areas\n1 - No sign-in evidence, no ID verification, poor physical barriers\n2 - Plan in place to restrict access, no sign-in requirement\n3 - Visitors sign-in, batch ID visible, ID verification, training program in place to report suspicions activities, physical barriers where needed",2,null,"Jemison facility consists of one building with a small workforce. Unauthorized access is not a problem faced at these facilities. Total employees count is 39."]
["1.8","Based on interviews with personnel - does supplier have any company policies in written against discrimination, harassment, regarding code of conduct?\nDo workers have the right to form or freely join to  representative organization independent from the company (i.e. unions, worker's associtations) which handles their own working related issues?","Factory Tour / \nMeeting Room, \nWorker's Rights","0 - No evidence of policy in place, and/or employees are not allowed to form ot join freely to a workers association, union.\n3 - Code of conduct in place and well communicated to employees, available either in electronic or as hard copy.  Campaigns to reinforce policies are used. Employees are not restricted to form or join to workers associations, unions.",3,null,"Jemison employee handbook details the company’s stance on discrimination and harassment on pages 43, 44, and 46-49. Jemison Metals has company policies against discrimination and harassment. South Carolina is a right to work state and being so Union activity has not had a strong presence in the state. Jemison has no active policy against employees joining a representative organization. "]
["1.9","Are all employees observed at least 16 years old?  What is the legal minimum age?  (ask for employment records of suspected individuals to confirm)\nAre all employees seems to be present voluntarily.  (check if there is an excessive or unusual number of security guards)","Factory Tour / \nMeeting Room, \nWorker's Rights","0 - If a minor is identified or find employees there against their will, inform company legal department and obtain advice. \n3 - All employees meet with minimum age required and appear to be working voluntarily",3,null,"All Jemison employees meet all age related Labor law requirements. Minimum legal age is 18 or above."]
["1.10","If the  supplier  manages compliancy of Conflict Minerals / Reach / RoHS in supply chain,  is it  in compliance with ABB list of restricted and prohibited substances? \nPlease provide an evidence","Meeting Room,\nMaterial Compliance","0 - No evidence\n1 - Yes, partially (some with lack of updates)\n2 - Yes, partially (some updated)\n3 - Yes, fully (all and updated)",3,null,"Documentation supplied as required by customer. Doc titled as Conflict minerals reporting template (CMRT)"]
["1.11","Are Chemical materials used at supplier properly managed:\n - do they have an effective process in place to ensure compliance with the chemical restrictions?\n - are all storage containers of chem. raw materials, supply chemicals in progress in good condition, stored in contained areas & well managed with the correct information?\n - are all material safety data sheets (MSDS) for all chemicals updated and available to employees for their use, are those easily accessible from all the employees?\n\nPlease check in warehouse and production area","Factory Tour,\nHSE","0 - No evidence\n1 - Yes, partially (some with lack of updates)\n2 - Yes, partially (some updated)\n3 - Yes, fully (all and updated)",3,"Minor","All chemicals are handled by an fully accredited waste management/hazmat company.  None of these chemicals are used in the final product anyways.  During Audit we came across Oxygen welding cylinders that was not secured. And could be knocked over. This is OSHA recordable.    \n1910.253\tOxygen-fuel gas welding and cutting:  (b)(2)(ii)\tInside of buildings, cylinders shall be stored in a well-protected, well-ventilated, dry location, at least 20 (6.1 m) feet from highly combustible materials such as oil or excelsior. Cylinders should be stored in definitely assigned places away from elevators, stairs, or gangways. Assigned storage spaces shall be located where cylinders will not be knocked over or damaged by passing or falling objects, or subject to tampering by unauthorized persons. Cylinders shall not be kept in unventilated enclosures such as lockers and cupboards.  "]
[null,"Total","x",null,{"$f":"+IF(E12=\"\",\"evaluation incomplete\",IF(E13=\"\",\"evaluation incomplete\",IF(E14=\"\",\"evaluation incomplete\",IF(E15=\"\",\"evaluation incomplete\",IF(E16=\"\",\"evaluation incomplete\",IF(E17=\"\",\"evaluation incomplete\",IF(E18=\"\",\"evaluation incomplete\",IF(E19=\"\",\"evaluation incomplete\",IF(E20=\"\",\"evaluation incomplete\",IF(E21=\"\",\"evaluation incomplete\",IF(E22=\"\",\"evaluation incomplete\",AVERAGE(E12:E22)/3)))))))))))","v":0.84848484848484851}]
[null,null,"x"]
["Sr. No.","2. Organizational management (general business, company management, general)","x","Scoring guide","Score","Improvement type","Comments"]
["2.1","If the supplier has a skill matrix (a.k.a. qualification, competence or polivalncy matrix), is the matrix updated with predefined frequency? Is there a clear rule for managing the score upgrade and downgrade?","Meeting Room,\nTraining","0- NO skill matrix in place                                                                                                                                      1- skill matrix exisit, but incomplete or not updated  regularly                                                                                                                                        2- skill matrix updated at predefined frequency, however not all training records are available                                                                               \n3- skill matrix updated at predefined frequency, back up training records are available  ",3,null,"Training matrix is kept and updated, but frequency is not per a schedule"]
["2.2","Are relevant personnel trained and certified for their assigned functions? If yes, can the supplier specify how the operators are qualified?\n","Factory Tour / Meeting Room,\nTraining","0- NO  \n1- some trained, but not certified/recorded \n2- all trained, but not certified/recorded                                                                                                                                                                                                    3-Yes, all trained and certified/recorded",3,null,"Matrix has a skill level component that ranks competency levels."]
["2.3","Does a training plan exist to qualify the internal  operators? If so, can the supplier specify how the  first and the following plans are made  \n","Meeting Room,\nTraining","0- NO                                                                                                                                                                                         1- people trained but trainings not always recorded                                                                                   2- trainings recorded                                                                                                                                                        3- trainings recorded and refresher trainings planned ",1,"Observation","A training matrix is kept which includes skill levels. But it would be recommended to keep training records."]
["2.4","What kind of risk analysis method do you use regularly, e.g. Business Continuity Plan? Is there a periodically \"Risk Analysis Procedure\" which allow the supplier to evaluate the impact on the production network caused by force major like political events/geographical hazards?","Meeting Room, Miscellaneous","0- NO risk analysis is in use                                                                                                                                                                                         1- A risk analysis method is used but no periodically analysis performed                                                                                                            \n2- risk analysis method is used  but with sporadic analysis performed                                                                                                                                                            3- risk analysis method is used  periodically the  analysis are performed",3,null,"Jemison risk assessment evaluated annually at Management Review. Contingency plan updated as needed. Doc - Jemison Business Risk Assessment 1/19/24 Rev-2. One example of an action was - BEST Project/ Machine intelligence as described by audittee."]
[null,"Total","x",null,{"$f":"+IF(E26=\"\",\"evaluation incomplete\",IF(E27=\"\",\"evaluation incomplete\",IF(E28=\"\",\"evaluation incomplete\",IF(E29=\"\",\"evaluation incomplete\",AVERAGE(E26:E29)/3))))","v":0.83333333333333337}]
[null,null,"x"]
["Sr. N.","3. Supply chain (Sub-Tier Management, logistics, internal/external)","x","Scoring guide",null,"Improvement type","Comments"]
["3.1\nMajor Requirement","Does the supplier  commit not to make product or process changes without prior written notification and/or approval from ABB?\nThis also includes any changes in part design, materials, sub-suppliers or manufacturing location.\n\nAsk to provide an evidence","Meeting Room, Miscellaneous","0 - NO\n3 - YES",3,null,"ABB is listed on Jemison's \"Customers Requiring Change Notification\" document to be notified of \"any significant changes\" and \"mill source\" //\n"]
["3.2\nMajor Requirement","Is there an agreement that the supplier agrees to notify the customer of changes in the product or service so that  customer may determine whether the changes may affect the quality of a finished product.","Meeting Room, Miscellaneous","0 - NO\n3 - YES",3,null,"ABB is listed on Jemison's \"Customers Requiring Change Notification\" document to be notified of \"any significant changes\" and \"mill source\""]
["3.3","Does Supplier have a robust production scheduling process  in order to meet ABB needs?\n","Factory Tour / Meeting Room,\nProduction Planning","0 - NO\n1 -  Yes- but the scheduling is manual\n2 -   Yes- Manual scheduling considering customer priorities and lead time\n3 - Yes ERP manages the scheduling considering also customers' priorities (e.g. change in requested delivery date )",2,null,"Jemison scheduling is reviewed every morning on a multifunctional daily call that includes operations, logistics, and commercial department representatives. The schedule is monitored throughout the day and adjusted as needed. "]
["3.4","What type of Enterprise Resource Planning (ERP) and inventory management system is in place? Is it an automated system? What are the major functional modules?\n(For Supplier owned RM, WIP, FG)","Factory Tour / Meeting Room,\nProduction Planning","0 -  ERP basics are missing (i.e. manual MPS/MRP/Prod order management/ master data/ inventory management …etc.)\n1 - ERP basics in place with some manual interaction (i.e. order release, MRP output analysis…etc.)\n2 - ERP fully implemented and automatized\n3 - ERP fully implemented, synchronized and connected to customers tools/ERP system ",2,null,"Stelplan"]
["3.5","Does the supplier work on a FIFO system?\n\nCheck dates and control sequence of usage is monitored","Factory Tour / Meeting Room,\nProduction Planning","0 - No evidence\n1 - Yes, partially (some with lack of updates)\n2 - Yes, partially (some updated)\n3 - Yes, fully (all and updated)",3,null,"All material, shipping, raw material and WIP are scheduled based on FIFO."]
["3.6","Does the supplier  apply advanced logistical concepts (EDI, Kanban, Vendor Managed Inventory, Just In Time systems) with ABB or any of its customers? \nDoes the supplier use any Internal Logistics concept (Warehouse Management System, Logistics automation, barcode or RFID technologies, etc.)\n\nPlease provide examples of where you use these techniques.","Factory Tour / Meeting Room,\nProduction Planning","0 - No evidence\n1 - Yes, partially (at least internal)\n2 - Yes, partially (at least external)\n3 - Yes, fully (all)",2,null,"Jemison uses a robust customer forecast system to precut stock based on customer information and agreements, as well as KANBAN systems with some customers. "]
["3.7","Does the supplier have an effective identification system in place? \nApplicable for finished products/work in progress/incoming (raw) material\n\nCheck that for the particular item, you can trace it from source to delivery to ABB. This should include any 'special' lots as well.","Factory Tour,\nTraceability ","0 - No evidence\n1 - Yes, partially (1 of 3 mat. types)\n2 - Yes, partially (2 of 3 mat. types)\n3 - Yes, fully (3 of 3 mat. types)",3,"Best Practice","all material supplied by Jemison is assigned a identification number and is traceable through all steps of production from purchase and raw material certification to finished product. "]
["3.8","Does the supplier have an effective traceability system in place? \nApplicable for finished products/work in progress/incoming (raw) material\n\nCheck that for the particular item, you can trace it from source to delivery to ABB. This should include any 'special' lots as well.","Factory Tour,\nTraceability ","0 - No evidence\n1 - Yes, partially (1 of 3 mat. types)\n2 - Yes, partially (2 of 3 mat. types)\n3 - Yes, fully (3 of 3 mat. types)",3,null,"all material supplied by Jemison is assigned a identification number and is traceable through all steps of production from purchase and raw material certification to finished product. "]
["3.9\n","Does the supplier have a (Sub-)Supplier approval process ? How does a supplier become approved and dis-qualified? Are all new (sub-)suppliers approved before business is placed with them? \n\nPlease check Supplier approval list, criteria for qualification and disqualification.\nIf not, what is required to do business with a supplier?"," Meeting Room","0 - No evidence\n1 - Yes, partially (with concerns)\n2 - Yes, partially (without concerns)\n3 - Yes, fully",3,null,"QMP 8.4// they have a score card that they send to the supplier every quarter, they do not audit their suppliers"]
["3.10","How have transportation suppliers been identified and selected? Is there a process in place?\nAre transport/warehousing companies regularly inspected? \nHow the performance of these suppliers is monitored and managed? Including corrective actions.\n\nPlease provide an evidence","Meeting Room, \nSub-tiers, Logistic ","0 - No evidence\n1 - Yes, partially (with concerns)\n2 - Yes, partially (without concerns)\n3 - Yes, fully",3,null,"They have an outside contracted dedicated freight company"]
["3.11\n","Does the supplier  have a Sub-Supplier performance Delivery or Quality monitoring process in place? \nHow this used and connected to Sub-Supplier management improvement and corrective plans?\nDoes the supplier give formal feedback on performance to  its suppliers?\n\nMainly On Time Delivery, On Quality Delivery, Lead Time, Complaints resolution, Responsiveness in case complaints.\nPlease provide an evidence of present and last year data","Meeting Room, \nSub-tiers, Logistic ","0 - No evidence\n1 - Yes, partially (at least 1)\n2 - Yes, partially (at least 2)\n3 - Yes, fully (at least 3)",3,null,"A scorecard system is used for all major suppliers of raw material. // They negotite the contract every year// Scoracard sistem"]
["3.12","What is the  supplier sourcing strategy in terms of: \n - number of sources for each component?\n - single source situations?\n - high value items?\n - high runner items?","Meeting Room, \nSub-tiers, Logistic ","0 - No evidence of any sourcing strategy\n1 - There is no strategy for managing single sources\n2 - Yes, partially - there is a strategy for managing single sources, but nothing about high runners, high value items\n3 - Yes, fully meet requirements",3,null,"Jemison’s vendors are mill sources only. Jemison only brings in raw materials directly from the mill sources. // They have 6 mills with redundency between them, at least they have 2 or 3 mills for each item"]
["3.13","Did supplier establish and implement a process for the avoidance, detection, mitigation, and disposition of Counterfeit Material?","Meeting Room,\nProduction Planning","0 - NO\n3 - YES",3,null,"Master coils of steel by nature of what they are at a minimum risk level of being counterfeited. "]
["3.14","Does the supplier use a forecasting process for material and capacity planning? \nCheck use and sophistication of forecasting techniques and tools, e.g., variable planning horizons, ability to involve suppliers and customers, ability to use external data ","Meeting Room,\nProduction Planning","0 - NO forecasting process are used\n1 - Yes, simple, estimate based process in place\n2 - Yes, simple process based on some inputs form customer \n3 - YES, complex planning in place, including exact supplier and customer inputs",3,null,"FIT system and Model.  Was demonstrated during the audit."]
["3.15","Does supplier have consignment or safety stock agreements with its suppliers to eliminate OTD issues?","Meeting Room, \nSub-tiers, Logistic ","0 - NO\n3 - YES",0,null,"Jemison does not have safety stock agreements with suppliers. The mill where all stock is purchased will not hold safety stock for any customers. // They have SS internaly but not with theier supplier, lead time from the mills are 5 weeks"]
["3.16","Does supplier audit its (sub-)suppliers'  production processes? Do they  monitor or audit their suppliers for sustainability?\n\nAsk eveidences, like audit plan, audit records, follow up documents","Meeting Room, \nSub-tiers, Logistic ","0 - No evidence\n1 - Yes, but only occassionally, some suppliers, some processes\n2 - Yes, regularly,  some suppliers only \n3 - Yes, regularly, key suppliers at least, according to plan (i.e. on an annual base etc), processes and sustainability aspects as well",0,null,"All of Jemison's raw material vendors are major mills with multiple locations. The vendors individually and collectively have redundancy across locations and companies insuring sustainable access to raw materials. "]
["3.17\nMajor Requirement","Does the Supplier have a process / system in place to ensure that all design requirements / engineering specifications / Material Compliance requirements are communicated to their supply base and verified upon?  ","Meeting Room, \nSub-tiers, Logistic ","0 - NO\n3 - YES",3,null,"Jemison Model function on the consumption has this verification. "]
[null,"Total","x",null,{"$f":"+IF(E33=\"\",\"evaluation incomplete\",IF(E34=\"\",\"evaluation incomplete\",IF(E35=\"\",\"evaluation incomplete\",IF(E36=\"\",\"evaluation incomplete\",IF(E37=\"\",\"evaluation incomplete\",IF(E38=\"\",\"evaluation incomplete\",IF(E39=\"\",\"evaluation incomplete\",IF(E40=\"\",\"evaluation incomplete\",IF(E41=\"\",\"evaluation incomplete\",IF(E42=\"\",\"evaluation incomplete\",IF(E43=\"\",\"evaluation incomplete\",IF(E44=\"\",\"evaluation incomplete\",IF(E45=\"\",\"evaluation incomplete\",IF(E46=\"\",\"evaluation incomplete\",IF(E47=\"\",\"evaluation incomplete\",IF(E48=\"\",\"evaluation incomplete\",IF(E49=\"\",\"evaluation incomplete\",AVERAGE(E33:E49)/3)))))))))))))))))","v":0.82352941176470595}]
[null,null,"x"]
["Sr. N.","4. Pre-production & development (technology support)","x","Scoring guide","Score","Improvement type","Comments"]
["4.1\n","Does the Supplier have documents ( Quality file) for product developed / under development?\nPlease check documents for New product development.\nRefer to Supplier Requirements for list of documents ( Quality File)-  - Drawing, Technical Specifications, Standards., Engineering Change Documents, Control Plan / Process Flow Diagram, Dimensional Results.\nRaw material Test Certificates (e.g. chemical/mechanical/metallurgical etc.)\nOther Test Results As Applicable, List of Checking Aids and Toolings  (Gauges, Instruments, Checking Fixtures)\nSPC study etc.","Meeting Room,\nR&D","0 - No evidence\n1 - Yes, partially (1 of 3 cases)\n2 - Yes, partially  (More than 3 cases )\n3 - Yes, fully (latest available)","NA",null,"Not applicable. Jemison does not provide any product design  function."]
["4.2","Is there a documented New Product Introduction (NPI) process? \nPlease check Program Gant Chart for timeline and activity to be perform for new development etc. / \nOr check supplier  process for prototype development, pre-pilot stage, initial production, production quality assurance plan and pre-launch chanche control management.","Meeting Room,\nR&D","0 - No evidence\n1 - Yes, some basic elements are covered\n2 - Yes, a comprehensive process in place, but not all products are covered\n3 - Yes, fully documented (latest available), available for all products","NA",null,"Not applicable. Jemison does not provide any product design  function."]
["4.3\n","Has a Process Failure Mode Effects Analysis been performed? Are the corrective actions documented, implemented and effective? \nPlease check Process FMEA  and if it is reviewed and updated on a regular basis. Is Material Compliance considered in PFMEA?","Meeting Room,\nR&D","0 - No Evidence                                                                                                                         1 - PFMEA performed once just for few processes and not updated                                        \n2 - PFMEA performed once for all processes but not regularly updated, or only upon customer's request\n3- PFMEA in place reviewed and updated on regular basis","NA",null,"Not applicable. Jemison does not provide any product design  function."]
["4.4","Provide a list of your equipment and facilities available for testing, identifying what is available internal versus external. Are the product performance testing facilities adequate?","Meeting Room,\nR&D","0 - No evidence\n3 - Yes","NA",null,"Not applicable. Jemison does not provide any product design  function."]
["4.5","Are test procedures and results available? Is any national / International accreditation needed for Testing facilities?\nCheck calibration /certification of testing equipment available.","Meeting Room,\nR&D","0 - No evidence of any of these\n1 - Yes, few elements exisits\n2 - Yes, majority, but not all of these elements exist\n3 - Yes, full compliance","NA",null,"Not applicable. Jemison does not provide any product design  function."]
["4.6","Are test results communicated to customers upon such request?","Meeting Room,\nR&D","0 - No evidence\n3 - Yes","NA",null,"Not applicable. Jemison does not provide any product design  function."]
["4.7","Has process capability study been completed? Is process capability reviewed on regular Interval to meet Customers' requirements?\nCheck capacity capability study examples","Meeting Room,\nR&D","0 - No evidence\n3 - Yes","NA",null,"Not applicable. Jemison does not provide any product design  function."]
["4.8\n","Does the supplier have adequate containment plans for first production runs; if not in-house, is there an external containment plan in place? Containment plans are necessary to ensure that initial production runs meet all requirements\n(like 100% check, enhanced traceability, more labeling for products, more records and special release protocol to ship to customer)","Meeting Room,\nR&D","0 - No evidence\n1 - Yes, partially (1 of 3 cases)\n2 - Yes, partially  (More than 3 cases )\n3 - Yes, fully (latest available)","NA",null,"Not applicable. Jemison does not provide any product design  function."]
["4.9","Are tools and equipment developed and validated according a pre-defined plan, through first part inspection, and are the  results documented? ","Meeting Room,\nR&D","0 - No evidence\n1 - Yes, partially (1 of 3 cases)\n2 - Yes, partially  (More than 3 cases )\n3 - Yes, fully (latest available)","NA",null,"Not applicable. Jemison does not provide any product design  function."]
["4.10\n","Is Material Compliance Program in place and being followed throughout the product realization processes, including first article inspection and approval of sub-tier components and materials? \n(Are material compliance related requirements (REACH, RoHS etc) considered during the  development stage? Are the actually supplied materials from selected vendors verified against those requirements during PPAP/FAI?)","Meeting Room,\nR&D,\nMaterial Compliance","0 - No evidence (no process in place)\n1 - Yes, process in place, but only partially implemented, and / or indiviual cases are not compliant)\n2 - Yes, process in place, fully implemented, but some individual cases are not compliant\n3 - Yes, fully compliant ","NA",null,"Not applicable. Jemison does not provide any product design  function."]
["4.11\n","Does the Supplier have a process for developing, valdating and releasing the finsihed products they sell?","Trading (Branded Sourced Finished) Product Specific","0 - No evidence (no documented process in place)\n1 - Yes, partially (process in place, partially implemented)\n2 - Yes, most products are covered with documentation, only some exemptions\n3 - Yes, fully compliant ","NA",null,"Not applicable. Jemison does not provide any product design  function."]
["4.12","Does Supplier obtain for its products the required 3rd party certificates (initial and re-occuring) process?","Trading (Branded Sourced Finished) Product Specific","0 - No evidence (no documented process in place)\n1 - Yes, partially (process in place, partially implemented)\n2 - Yes, most products are covered with documentation, only some exemptions\n3 - Yes, fully compliant ","NA",null,"Not applicable. Jemison does not provide any product design  function."]
["4.13","Does Supplier consider service, warranty, liability, insurance obligations in contract when selling finished products to customers?","Trading (Branded Sourced Finished) Product Specific","0 - No evidence, or commitment not in written\n1 - Yes, partially\n2 - Yes, most (but not all) of these elements covered in contractual committments\n3 - Yes, fully compliant ","NA",null,"Not applicable. Jemison does not provide any product design  function."]
["4.14\nMajor Requirement\n","Does the supplier maintain a documented process for monitoring the changes of regulations, legislation relevant for its finished products?\nCheck documentation (certificates are uptodate), process, and find out who is the person/function in charge for this activity. ","Trading (Branded Sourced Finished) Product Specific","0 - No evidence (no documented process in place)\n1 - Yes, partially (process in place, partially implemented)\n2 - Yes, most products are covered with documentation, only some exemptions\n3 - Yes, fully compliant ","NA",null,"Not applicable. Jemison does not provide any product design  function."]
[null,"Total",null,null,{"$f":"+IF(E53=\"\",\"evaluation incomplete\",IF(E54=\"\",\"evaluation incomplete\",IF(E55=\"\",\"evaluation incomplete\",IF(E56=\"\",\"evaluation incomplete\",IF(E57=\"\",\"evaluation incomplete\",IF(E58=\"\",\"evaluation incomplete\",IF(E59=\"\",\"evaluation incomplete\",IF(E60=\"\",\"evaluation incomplete\",IF(E61=\"\",\"evaluation incomplete\",IF(E62=\"\",\"evaluation incomplete\",IF(E63=\"\",\"evaluation incomplete\",IF(E64=\"\",\"evaluation incomplete\",IF(E65=\"\",\"evaluation incomplete\",IF(E66=\"\",\"evaluation incomplete\",AVERAGE(E53:E66)/3))))))))))))))","v":{"$error":"#DIV/0!"}}]
[]
["Sr. N.","5. Production",null,"Scoring guide",null,"Improvement type","Comments"]
["5.1","Does supplier monitor the internal production lead time (Through-Put-Time) of each individual product and put in place actions to shorten the throughput time?","Meeting Room,\nProduction Planning","0 - No \n1 - Yes, partially for few process \n2 - Yes, partially  and in place efforts to shorted the throughput time  for most of the process/ stations\n3 - Yes, fully (latest available)",2,null,"Jemison has individual continual improvement plans that have an improvement component for processing time. Jemison does NOT measure it at present."]
["5.2","Is ther any automated notification system in place for rapid warning and response in production line in case of any interruption (ANDON system or similar)?","Factory Tour / Meeting Room","0 - NO\n3 - YES",3,null,"All schedule and production is monitored in real time manually. If any problem is observed then it will be immediately addressed by production supervisors and quality.  (SMT-SL-001)"]
["5.3","Does supplier identify and address bottle-necks in its  processes?   If yes, ask for eveidences, examples","Meeting Room,\nProduction Planning","0 - NO\n3 - YES",3,null,"Jemison has identified a bottleneck based on weight goals on the sheet side and instituted a floater position to alleviate. Weekly monitoring charts (reference - Production summary). Example - added a person in SCT line recently."]
["5.4","Is there any Visual management system or poka yoke system for tools","Factory Tour","0- No                                                                                                                                          1- just instructions at workstations                                                                                2- visual management                                                                                                 3- poka yoke",1,null,"Online thickness measurement system when it does not meet requirements then there will be an alarm to show up. Work Instructions are available in the computers at work stations."]
["5.5","Is There is a documented Maintenance Plan?","Factory Tour / Meeting Room,\nPreventive Maintenance","0 - NO\n1- Yes, only for extraordinary maintenance.\n3 - Yes, for extraordinary and preventive maintenance",3,null,"There are individual maintenance schedules for each piece of equipment. "]
["5.6","Whether there is work station and machine specific TPM check list for maintenance plan and preventive maintenance covering also inaccessible areas and logistic bins/racks/supermarket?\nTPM checklist is real elaborated with tasks and not just through general information?","Factory Tour / Meeting Room,\nPreventive Maintenance","0-  TPM checklist is missing\n1 -  TPM checklist is in place but doesn't cover all machines/tools/production and logistic areas or contains general instructions\n2 - TPM checklist is in place, covers all machines/tools/production and logistic areas but contains general instructions.\n3  - TPM checklist covers all machines/tools/production and logistic areas and is elaborated with specific tasks","NA",null,"All preventive maintenance is scheduled by maintenance department and performed by qualified maintenance technicians. "]
["5.7","Are the TPM activities performed according to the schedule / frequency of task mentioned in check list? Whether there is clear evidence( date/ sign) of activities done on TPM checklists / any other automated record keeping?","Factory Tour / Meeting Room,\nPreventive Maintenance","0 - No evidence\n1 - Yes, partially (1 of 3 cases)\n2 - Yes, partially  (More than 3 cases )\n3 - Yes, fully (latest available)","NA",null,"All preventive maintenance is scheduled by maintenance department and performed by qualified maintenance technicians. But a history of breakdown maintenance for a particular machine which gets updated in your preventive maintenance tasks - will help."]
["5.8","Is there an estimation of the tool life available? Is it in line with ABB production plan?\nDoes the estimation match the minimum guaranteed production volume on ABB purchase order?","Factory Tour / Meeting Room,\nPreventive Maintenance","0 - No evidence\n1 - Yes, partially (1 of 3 cases)\n2 - Yes, partially  (More than 3 cases )\n3 - Yes, fully (latest available)",2,null,"Cutters being used of different sizes. They are now sending out the cutters to refurbish once at a defined frequency to KC. (once in a two weeks on an average)"]
["5.9","Are the working stations standardized and 5S (or similar)  methodology implemented?\n(Are the bins on the working stations in a good condition? No broken or dirty bins?   \nAre the labels on the working stations in a good condition? Labels for material bins, tool places, jigs location, document locations etc.\nAre the needed trolley places / pallet places clearly marked on the floor? \nAre the material bins, the scrap bins and the tools in the defined places?\nAre there trash bins in every working station?  )","Factory Tour","0 -  No 5S standard (or similar) in place\n1 - Yes, 5S partially implemented\n2 - Yes, 5S mostly implemented\n3 -  Yes, 5S standard (or similar) is in place and all workstations/production areas/machines meets the standard",0,"Observation","Jemison needs to start the 5S program from the beginning."]
["5.10","Has a reworking process been defined?\nAre there reworking instruction?","Factory Tour / Meeting Room","0 - No, the rework flow is embedded in the standard production flow\n1 - Yes, a rework flow exists partially\n2 - Yes, a rework flow and rework instructions exist partially\n3 - Yes, a flow exists and rework instructions are available for the operators",2,null,"Jemison has a separate schedule for rework items called the \"As is\" schedule"]
["5.11","Is there a formal start-up procedure?\n(First part should be approved. In case of a long stoppage in operations, start-up procedure should be applied)","Factory Tour","0 - NO\n3 - YES",3,null,"Jemison has a first article inspection process in the standard operating procedure. "]
["5.12","Is there a formal approval procedure before the lot is transferred to the next stage? (i.e. the lots are checked at a given frequency before they are moved to the next stages)","Factory Tour","0 - No evidence\n1 - Yes, partially implemented\n2 - Yes, mostly implemented\n3 - Yes, fully implemented",3,"Best Practice","All Operating procedures include an inspection/sampling plan that includes sampling frequency. "]
["5.13","Are customer approved master samples available at required workstations?","Factory Tour","0 -  NO\n3 -  YES\nApplicable if ABB has requested it.","NA",null,"Jemison process does not include master samples."]
["5.14","Does the packaging used in production comply with safety requirements? Does it protect efficiently components and materials?","Factory Tour / Meeting Room","0 - NO\n3 - YES",3,null,"All packaging is customer specific based on customer instructions and best practice."]
["5.15","Does the supplier have a systematic incoming/WIP/finished goods inventory check? \nDoes it include incoming/WIP/finished goods/consignment stock/obsolescence inventory check? Are the results accurate enough?","Factory Tour, \nWarehouse","0 -  No, stocks are not under control \n1 -  Only specific stock types are under control (i.e. raw materials or FP)\n2 -  It is possible to control all stock types (raw material/SFP/Fp..etc.) through manual queries (not in real time)\n3 -  Yes, ERP is able to to control in real time all the stock types",3,null,"All inventory is tracked and designated in real time by the ERP system.  (STELPLAN)"]
["5.16","Does the supplier respect the validity dates for perishable items /Shelf life Items?","Factory Tour, \nWarehouse","0 - NO\n3 - YES","NA",null,"All raw material and finished product are carbon flat roll. Jemison operates under a FIFO system but there is not a \"perishable\" date for Jemison products"]
["5.17","Is the Supplier able to quickly resolve capacity constraints by increasing machine, manpower and material availability according to customer's demand?\nWhat process is in place to proactively evaluate tooling / machine capacity to be able to respond to a 20% spike increase in customer orders?","Meeting Room,\nProduction Planning","0 -  Not available free capacity (manpower or machines) or low raw materials/components stock \n1 -  Current capacity is not enough to cover the spike but supplier is able to increase by 20% his capacity in 1 week\n3-  Yes there is at least a 20% more of free capacity available and supplier manages an adequate safety stock especially for components with a long lead time.",3,null,"Jemison evaluates capacity at the model stage of an award. Without making any changes to staffing Jemison or equipment Jemison can expand for a 20% spike of ABB orders"]
["5.18","Is the non-conforming material segregated properly from regular material in separate area either in production line or other central place?\nIs the non-conforming material labeled / identified correctly so that nobody uses it by mistake?","Factory Tour","0 - NO\n3 - YES",3,null,"Jemison performs a virtual (warehouse designation) and visual (tag identification) segregation of nonconforming materials. Example- they move it in SRJ (Reject warehouse) and also physically segregated."]
["5.19","How does supplier identify if there is a delay in production and what process is in place reschedule the plan?","Meeting Room","0-  No ability to identify delays in the production \n1 - The delays are identified but no possibility to reschedule the plan \n2 -  A reschedule plan is done but manually and not regularly                          3 -  There is an automatic way to reschedule the plan and clear steps to be followed to perform the complete reschedule plan",2,null,"All schedules are reviewed on a cross functional team's morning production call where delays are identified and scheduled for. Schedules are then monitored in real time by production Managers."]
["5.20","Are Work Instructions for all employees affecting product quality, including for repair and re-work operations available and posted? Please explain  how  it is ensured that production is executed in accordance with approved and controlled procedures (control plan, flow chart, boundary samples, revision of drawings), also audits are performed to check if it complies to the procedure ","Factory Tour","0 - NO\n1 -  for some workstations only, and/or do not include re-work operations.\n2 -  for most (but not all) workstations yes, including re-work related instructions as well. \n3 - YES",3,null,"Procedures are available electronically at each work station. "]
["5.21","Does the Supplier's Process flow diagram match the actual production flow laid out for this facility?","Factory Tour","0- NO                                                                                                                                                                                         1- The process flow diagram matches with the actual production flow but there is no documented production planning process and no  explain the coverage of the process                                                                                                                                               3-Everything is in place",3,null,"Process flow available to review. Example - SMT -VA-003 , rev-0."]
[null,"Total","x",null,{"$f":"+IF(E70=\"\",\"evaluation incomplete\",IF(E71=\"\",\"evaluation incomplete\",IF(E72=\"\",\"evaluation incomplete\",IF(E73=\"\",\"evaluation incomplete\",IF(E74=\"\",\"evaluation incomplete\",IF(E75=\"\",\"evaluation incomplete\",IF(E76=\"\",\"evaluation incomplete\",IF(E77=\"\",\"evaluation incomplete\",IF(E78=\"\",\"evaluation incomplete\",IF(E79=\"\",\"evaluation incomplete\",IF(E80=\"\",\"evaluation incomplete\",IF(E81=\"\",\"evaluation incomplete\",IF(E82=\"\",\"evaluation incomplete\",IF(E83=\"\",\"evaluation incomplete\",IF(E84=\"\",\"evaluation incomplete\",IF(E85=\"\",\"evaluation incomplete\",IF(E86=\"\",\"evaluation incomplete\",IF(E87=\"\",\"evaluation incomplete\",IF(E88=\"\",\"evaluation incomplete\",IF(E89=\"\",\"evaluation incomplete\",IF(E90=\"\",\"evaluation incomplete\",AVERAGE(E70:E90)/3)))))))))))))))))))))","v":0.82352941176470595}]
[null,null,"x"]
["Sr. N.","6. Quality system (quality management, operational excellence, continuous improvement)","x","Scoring guide",null,"Improvement type","Comments"]
["6.1","Does the supplier have any formal continuous improvement, productivity or waste elimination programs in place that is championed by management with defined goals and measurements?","Meeting Room,\nQMS","0- No\n1- Yes, only few continuous improvement projects.\n2- Yes, program in place\n3- Yes, continuous improvement program in place with awards ",2,null,"Continuous improvement tracker available to review.  Each local plant manager and their mgt team identified the projects and decides project team. FIT system is the repository for these projects. Internal evaluation of these projects being done once a week."]
["6.2\n","Are processes being operated along a defined Quality Management System, which is certified or compatible to ISO 9001, and are the results followed up by standard internal auditing process?","Factory Tour / Meeting Room,\nQMS","0- NO    \n1- Some, but not all elements of a QMS system exist, and/or no cerification, or internal auditing process in place.                                                                                                                      2- All basic elements of a QMS system exist, but no cerification in place.                                                                                                                                                                               3-Yes, a valid ISO 9001 or equivalent certificate is in place, and regularly refreshed. Internal audits regularly planned and held.",3,null,"ISO certificate supplied with this checklist. Internal audits schedule for 2024 was reviewed. It includes the PA (Process Audits) schedule."]
["6.3","Does the Supplier have a process for managing Advanced Quality Planning activity and sufficient resources to manage activity? If yes - does Supplier's AQP include scheduled formal Design Review, Management Reviews, Program Reviews, etc. with their Customer and internally?","Meeting Room,\nProduction Planning","0 -  No AQP activity is performed\n1 -  An advanced quality planning activity is performed but with no sufficient resources                                                                                             2 -  An advanced quality planning activity is performed  with no sufficient resources  but does not include scheduled formal reviews     \n3 -  An advanced quality planning activity is performed  with sufficient resources  including  scheduled formal reviews with customers and internally",3,"Best Practice","All new parts go through a model process with a multifunctional team including quality representation. Example - "]
["6.4","Does the supplier  monitor process effectiveness and implement changes for improvement?\nCheck the use of SPC, process capability studies (short an long term), kaizen events, feedback to engineering,…","Meeting Room,\nQMS","0 - No\n1- Yes, data collection with SPC\n2- Yes, data collection and process capabilities studies\n3- Yes, kaizen and feedback to engineering",1,null,"Data is collected."]
["6.5\n","Is there in place any governance meetings to manage the Quality issues?\nWhat is the process to get Q-management's attention and focus on specific or escalated quality issues?","Meeting Room,\nQMS","0- No (evidence of) meetings\n1- Monthly meeting/review in place\n2- Weekly meeting/review in place\n3- Daily meeting/review in place",2,null,"A weekly call is held to review the weeks quality issues. "]
["6.6","Is the supplier handling and tracking the action points coming from internal and external audits? If ABB has already conducted audit(s) in the past, are there evidences in place that supplier has implemented corrective actions requested at those audit(s)? ","Meeting Room,\nQMS","0- NO process to effectively trace preventive and corrective actions of audits.\n1- Yes, some corrective actions are ongoing, but no systematic follow up process is in use\n2- Yes, a process exist to follow up on corrective actions, however not all actions are closed by  due date. \n3- Yes, process in place, and all actions closed on time.",3,null,"There is a Corrective Action case system in place.  Jemison is also using ABB's Supplier Net system.  Corrective action report # 25508. ABB Selmer Supplier Net case # 230785 from 2023 - material has warped. Case is closed in system by Jemison."]
["6.7","Is the supplier handling and monitoring (  n. of repair, defective parts… etc.) quality complaint/ feedback from external customers?\n","Meeting Room,\nNon-conformity management","0- No, non conformance management\n1- Yes, complaints handled with Corrective Action  \n2- Yes, complaints handled manually with RCA\n3- Yes, all complaints handled with Problem solving methodology (8D, PDCA, Ishikawa, 5 Whys)",2,null,"If requested by customer to be needed. "]
["6.8\n","Does the supplier  handle internal non-conformances? \nAsk for  evidences, i.e. Minutes of meeting, review summary, tracking sheet etc\n","Meeting Room,\nNon-conformity management","0- No, non conformance management\n1- Yes, complaints handled with Corrective Action  \n2- Yes, complaints handled manually with RCA\n3- Yes, all complaints handled with Problem solving methodology (8D, PDCA, Ishikawa, 5 Whys)",2,null,"A weekly call is held to review the weeks quality issues. It is called \"Internal Devaluation\"."]
["6.9","Is supplier verifying  that the non-conformance management  (NC) covers identification, documents, quarantine, and disposition of non-conforming materials?","Meeting Room,\nNon-conformity management","0- NO\n1- No, NC parts scrapped.\n2-  Yes, all the NC parts are correctly identified                                                   3- Yes, all the NC parts are well segregated and correctly identified.",3,null,"As part of any customer complaint or Corrective Action (internal issues)"]
["6.10","Does the supplier have a process to autopsy failed internal or returned field parts and/or product ? \n","Meeting Room,\nNon-conformity management","0 - NO\n3 - YES",3,null,"QMP 10.2 - Non conformity and corrective action"]
["6.11\n","Are immediate and efficient  / actions taken and tracked for all reported issues (management, production, quality, maintenance etc) opened?\nAsk for  evidences, i.e. minutes of meeting, tracking sheet etc","Meeting Room,\nNon-conformity management","0- No action taken\n1- Yes, containment action\n2 - Yes, corrective action\n3- Yes, preventive action",2,null,"Corrective action as needed.  Also tracking internal & external DPPM on a weekly & monthly frequency."]
["6.12","Does the supplier  have a KPI dashboard updated regularly?","Meeting Room,\nQMS","0 -No\n3 - Yes",3,null,"monthly and weekly charts"]
["6.13","Does supplier have a Problem Solving or Corrective/Preventive Actions process in place, triggered by  FPY, internal quality issues, customer reported issues, and OEE problems? \nIs this process applied at all levels of the organization and through all functions, such as design, engineering, production, suppliers, etc.?","Meeting Room,\nNon-conformity management","0- No action taken\n1- Yes, process in place not covering all part of the organization\n2 - Yes, a process is in place for all the organization but no identification of a process to trigger problem solving actions\n3- Yes, process completely in place",2,null,"QMP 10.2"]
["6.14\n","Are the  pre-defined Quality / Process Control plans covering: \na) Incoming material; \nb) Initial start-up checks;\nc) In process checks; \nd) Final inspection; \ne) Packaging   \nf) Requirements (specification with \"critical to quality\" (CTQ) charackteristics, tolerances, acceptance and control limits)\ng) personal requirements (role or training level to certain actions and decisions)\nh) Methode of inspection/control (visual, measurement, SPC etc)\ni) Mesurament and test equipments, techniques to be used\nj) Frequency and sampling instructions\nk) Rules to record the inspection results\nl) Rules to be followed in case of non-conformity found\nm) Date and revision control of documents","Factory Tour, \nQuality Inspection","0 - Nothing\n1 - less than half of the listed requirements are covered\n2 - more than half of the listed requirements are covered\n3 - all area covered",2,null,"A, C, D. E, F, J, K, M. Example -SMT-CP003-CTL Control Plan."]
["6.15","Are the executed inpsections and controls covering/matching and following the below listed areas and requirements according to the pre-defined Quality / Control Plans: \na) Incoming material; \nb) Initial start-up checks;\nc) In process checks; \nd) Final inspection; \ne) Packaging   \nf) Requirements (specification with \"critical to quality\" (CTQ) charackteristics, tolerances, acceptance and control limits)\ng) personal requirements (role or training level to certain actions and decisions)\nh) Methode of inspection/control (visual, measurement, SPC etc)\ni) Mesurament and test equipments, techniques to be used\nj) Frequency and sampling instructions\nk) Rules to record the inspection results\nl) Rules to be followed in case of non-conformity found","Factory Tour, \nQuality Inspection","0 - Nothing\n1 - less than half of the listed requirements are covered\n2 - more than half of the listed requirements are covered\n3 - all area covered",2,null,"A, C, D, E, F, J, K, I"]
["6.16\n","Are there any major differences between the Control Plan and the actual  process and product/process controls?","Factory Tour, \nQuality Inspection","0 - YES\n3 - NO",3,null,"CP available"]
["6.17","Has Control Plan been submitted and accepted by ABB?\nCheck that last revision has been incorporated.","Factory Tour, \nQuality Inspection","0 - NO\n3 - YES","NA",null,"Jemison control plan has been submitted to ABB."]
["6.18\n","Does the supplier  run a process capability study for at least CTQ dimensions?","Factory Tour, \nQuality Inspection","0 - NO\n3 - YES",3,null,"Capability study performed by Jemison on Galvanized blank."]
["6.19","Does the supplier monitor variation in critical processes through SPC? If yes please provide example.","Factory Tour, \nQuality Inspection","0 - No\n1- Yes, data collection\n2- Yes, data collection with SPC\n3- Yes, SPC and corrective actions",1,null,"Data collected"]
["6.20\n","Are calibration plans for inspection, measurement, and test equipment in place and properly recorded? \n(equipment type, method of calibration & adjustment, acceptance criteria, frequency of checks, corrective actions)","Factory Tour, \nQuality Inspection","0 - No \n1- Yes, some calibration plans are in place and are not recorded\n2- Yes, all calibration plans are in place but not recorded\n3- Yes, all calibration plans are in plan and are properly recorded and a Gage R&R is performed and has a % less of 10%",2,null,"Gagetrak software is used to track calibration of all measuring equipment and schedule calibration frequency. "]
["6.21","Are equipment process devices / gaging included in a calibration program? ","Factory Tour, \nQuality Inspection","0 - NO\n3 - YES",3,"Best Practice","Gagetrak software is used to track calibration of all measuring equipment and schedule calibration frequency. "]
["6.22\n","If the measuring or the test equipment is out of calibration , what type of actions are taken?","Factory Tour, \nQuality Inspection","0 - No  actions\n1- The measurement or the test is out of calibration even if a  previous test has been checked for  validity, no other action taken.                                                                                                               2- The material is going to be retested but no information to the customer about possible defects to material already shipped\n3- The material is going to be retested and  the customer is promptly informed about possible defects to material already shipped",3,"Best Practice","Customer is notified if applicable. SOP 3 Control of monitoring and measuring resources , rev A."]
[null,"Total",null,null,{"$f":"+IF(E94=\"\",\"evaluation incomplete\",IF(E95=\"\",\"evaluation incomplete\",IF(E96=\"\",\"evaluation incomplete\",IF(E97=\"\",\"evaluation incomplete\",IF(E98=\"\",\"evaluation incomplete\",IF(E99=\"\",\"evaluation incomplete\",IF(E100=\"\",\"evaluation incomplete\",IF(E101=\"\",\"evaluation incomplete\",IF(E102=\"\",\"evaluation incomplete\",IF(E103=\"\",\"evaluation incomplete\",IF(E104=\"\",\"evaluation incomplete\",IF(E105=\"\",\"evaluation incomplete\",IF(E106=\"\",\"evaluation incomplete\",IF(E107=\"\",\"evaluation incomplete\",IF(E108=\"\",\"evaluation incomplete\",IF(E109=\"\",\"evaluation incomplete\",IF(E110=\"\",\"evaluation incomplete\",IF(E111=\"\",\"evaluation incomplete\",IF(E112=\"\",\"evaluation incomplete\",IF(E113=\"\",\"evaluation incomplete\",IF(E114=\"\",\"evaluation incomplete\",IF(E115=\"\",\"evaluation incomplete\",AVERAGE(E94:E115)/3))))))))))))))))))))))","v":0.79365079365079361}]

{"sheet":"CAPA Tracking","index":3,"n_rows":105,"n_cols":11,"rows_kept":105,"cut":false,"hidden":false,"merged":[[12,1,12,10],[1,1,1,3],[14,7,14,8]]}
[]
[]
[]
[null,null,"Supplier Name:",{"$f":"'Audit Checklist'!C2","v":"Jemison Steel Site Audit"}]
[null,null,"Supplier site (Address):",{"$f":"'Audit Checklist'!C3","v":"1255 North Gate Drive  Sumter, SC 29154"}]
[null,null,"Supplier GUID:",{"$f":"'Audit Checklist'!C4","v":0}]
[null,null,"Audit Date:",{"$f":"'Audit Checklist'!C5","v":"May 2nd 2024"}]
[null,null,"ABB Lead Auditor:",{"$f":"'Audit Checklist'!C6","v":"Henry George"}]
[null,null,"ABB Participants: ",{"$f":"'Audit Checklist'!C7","v":"Shri Mehta,  Roberto Arroya  Jennifer Robison"}]
[null,null,"ABB BA and Division:",{"$f":"'Audit Checklist'!C8","v":0}]
[null,null,"Audit report id:",{"$f":"'Audit Checklist'!C9","v":0}]
[]
[null,"Improvement types:\n• Major – Unacceptable practice or full lack of a critical process , or systemic level deficiency: a process does not exist, not implemented, or violated multiple times. Require CAPA as pre-requisite for vendor approval.\n• Minor – Individual deficiencies: process exists, implemented well, but in one or few cases not followed properly. Require commitment for CAPA with agreed dead line, but it is NOT a pre-requisite for vendor approval\n• Observation – Basic compliance given, but there is room for Improvement. It is NOT a pre-requisite for vendor approval."]
[]
[null,null,null,"Select type to show in the report",null,"To define by supplier"]
[null,"Sr. No.","Checklist reference","Improvement type","Comment","Next step & Action item","Status","Owner","Due date","Closure date","Additional comment"]
[null,{"$f":"'Audit Checklist'!A12","v":"1.1"},{"$f":"IF(OR('Audit Checklist'!$F12=\"Observation\",'Audit Checklist'!$F12=\"Minor\",'Audit Checklist'!$F12=\"Major\",'Audit Checklist'!$F12=\"Best Practice\"),'Audit Checklist'!$B12,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F12=\"Observation\",'Audit Checklist'!$F12=\"Minor\",'Audit Checklist'!$F12=\"Major\",'Audit Checklist'!$F12=\"Best Practice\"),'Audit Checklist'!$F12,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F12=\"Observation\",'Audit Checklist'!$F12=\"Minor\",'Audit Checklist'!$F12=\"Major\",'Audit Checklist'!$F12=\"Best Practice\"),'Audit Checklist'!$G12,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A13","v":"1.2\n"},{"$f":"IF(OR('Audit Checklist'!$F13=\"Observation\",'Audit Checklist'!$F13=\"Minor\",'Audit Checklist'!$F13=\"Major\",'Audit Checklist'!$F13=\"Best Practice\"),'Audit Checklist'!$B13,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F13=\"Observation\",'Audit Checklist'!$F13=\"Minor\",'Audit Checklist'!$F13=\"Major\",'Audit Checklist'!$F13=\"Best Practice\"),'Audit Checklist'!$F13,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F13=\"Observation\",'Audit Checklist'!$F13=\"Minor\",'Audit Checklist'!$F13=\"Major\",'Audit Checklist'!$F13=\"Best Practice\"),'Audit Checklist'!$G13,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A14","v":"1.3"},{"$f":"IF(OR('Audit Checklist'!$F14=\"Observation\",'Audit Checklist'!$F14=\"Minor\",'Audit Checklist'!$F14=\"Major\",'Audit Checklist'!$F14=\"Best Practice\"),'Audit Checklist'!$B14,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F14=\"Observation\",'Audit Checklist'!$F14=\"Minor\",'Audit Checklist'!$F14=\"Major\",'Audit Checklist'!$F14=\"Best Practice\"),'Audit Checklist'!$F14,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F14=\"Observation\",'Audit Checklist'!$F14=\"Minor\",'Audit Checklist'!$F14=\"Major\",'Audit Checklist'!$F14=\"Best Practice\"),'Audit Checklist'!$G14,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A15","v":"1.4"},{"$f":"IF(OR('Audit Checklist'!$F15=\"Observation\",'Audit Checklist'!$F15=\"Minor\",'Audit Checklist'!$F15=\"Major\",'Audit Checklist'!$F15=\"Best Practice\"),'Audit Checklist'!$B15,\"0\")","v":"Are employees wearing the appropriate personal protective equipment when necessary, such as specific masks, hearing protection equipment, eye protection measures, safety shoes, gloves, etc..\n"},{"$f":"IF(OR('Audit Checklist'!$F15=\"Observation\",'Audit Checklist'!$F15=\"Minor\",'Audit Checklist'!$F15=\"Major\",'Audit Checklist'!$F15=\"Best Practice\"),'Audit Checklist'!$F15,\"0\")","v":"Observation"},{"$f":"IF(OR('Audit Checklist'!$F15=\"Observation\",'Audit Checklist'!$F15=\"Minor\",'Audit Checklist'!$F15=\"Major\",'Audit Checklist'!$F15=\"Best Practice\"),'Audit Checklist'!$G15,\"0\")","v":"All floor personnel are required to wear the same PPE regardless of position in plant. Safety glasses and safety shoes. Employees not wearing hearing protection as observed. Review with OSHA the requirement for hard hats. There should be a signage indicating which area needs the hearing protection.   1910.95  Occupational noise exposure  OSHA Hearing conservation program - whenever noise exposures equal or exceed 8-hour TWA of 85 db "}]
[null,{"$f":"'Audit Checklist'!A16","v":"1.5"},{"$f":"IF(OR('Audit Checklist'!$F16=\"Observation\",'Audit Checklist'!$F16=\"Minor\",'Audit Checklist'!$F16=\"Major\",'Audit Checklist'!$F16=\"Best Practice\"),'Audit Checklist'!$B16,\"0\")","v":"Rate overall facility housekeeping, include office areas, dining room, restroom and common areas.  (Observe for equipment well preserved, no oil leaks, wet areas, etc.)"},{"$f":"IF(OR('Audit Checklist'!$F16=\"Observation\",'Audit Checklist'!$F16=\"Minor\",'Audit Checklist'!$F16=\"Major\",'Audit Checklist'!$F16=\"Best Practice\"),'Audit Checklist'!$F16,\"0\")","v":"Minor"},{"$f":"IF(OR('Audit Checklist'!$F16=\"Observation\",'Audit Checklist'!$F16=\"Minor\",'Audit Checklist'!$F16=\"Major\",'Audit Checklist'!$F16=\"Best Practice\"),'Audit Checklist'!$G16,\"0\")","v":"Housekeeping. One fork lift was under maintenance for oil leaks as observed. 5S program not in place which is recommended.  Another recommendation is about the measurement of lighting in the plant if it meets the requirements.         Minor Findings During our factory Audit we came across several Racks  without load ratings. OSHA 1910.176 (b) Storage of material shall not create a hazard. Bags, containers, bundles, etc., stored in tiers shall be stacked, blocked, interlocked and limited in height so that they are stable and secure against sliding or collapse. OSHA recommends that load ratings be present which provide the maximum permissible unit load and/or maximum uniformly distributed load per level, the average unit load, and maximum total load per bay. See ANSI/RMI MH16.1 for additional information. "},"Please provide prove of containment / resolution of the finding. Photo of corrected finding will be required.","Closed","Patrick V. Macias ","2024-05-30"]
[null,{"$f":"'Audit Checklist'!A17","v":"1.6"},{"$f":"IF(OR('Audit Checklist'!$F17=\"Observation\",'Audit Checklist'!$F17=\"Minor\",'Audit Checklist'!$F17=\"Major\",'Audit Checklist'!$F17=\"Best Practice\"),'Audit Checklist'!$B17,\"0\")","v":"Does the facility have all required local fire code authorizations?\nAre fire drills performed at least once per year and including all shifts? \nAre there clearly marked emergency exits that are visible from all corridors, staircases, and aisle ways?  \nDoes the facility have at least two clearly designated emergency exits equipped with crash bars on each floor with a travel distance of no more than 60 meters from any work area?"},{"$f":"IF(OR('Audit Checklist'!$F17=\"Observation\",'Audit Checklist'!$F17=\"Minor\",'Audit Checklist'!$F17=\"Major\",'Audit Checklist'!$F17=\"Best Practice\"),'Audit Checklist'!$F17,\"0\")","v":"Minor"},{"$f":"IF(OR('Audit Checklist'!$F17=\"Observation\",'Audit Checklist'!$F17=\"Minor\",'Audit Checklist'!$F17=\"Major\",'Audit Checklist'!$F17=\"Best Practice\"),'Audit Checklist'!$G17,\"0\")","v":"Fire extinguishers in place and inspected regularly. All exits clearly marked with crash bars and unobstructed. No fire drills conducted in a recent past as per audittee which should be conducted. Although the employees trained using safety videos.      Minor Findings During our factory floor Audit, we noticed electrical load centers had obstructed access. The National Electrical Code requires “clear space”, referred to as working space around the panelboard to ensure easy access. Additionally, OSHA requirement 1910.303 (g)(1)(i)(B) states: The width of working space in front of the electric equipment shall be the width of the equipment or 762 mm (30 in.), whichever is greater. In all cases, the working space shall permit at least a 90-degree opening of equipment doors or hinged panels. "},"Please provide prove of containment / resolution of the finding. Photo of corrected finding will be required.","Closed","Patrick V. Macias ","2024-05-30"]
[null,{"$f":"'Audit Checklist'!A18","v":"1.7"},{"$f":"IF(OR('Audit Checklist'!$F18=\"Observation\",'Audit Checklist'!$F18=\"Minor\",'Audit Checklist'!$F18=\"Major\",'Audit Checklist'!$F18=\"Best Practice\"),'Audit Checklist'!$B18,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F18=\"Observation\",'Audit Checklist'!$F18=\"Minor\",'Audit Checklist'!$F18=\"Major\",'Audit Checklist'!$F18=\"Best Practice\"),'Audit Checklist'!$F18,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F18=\"Observation\",'Audit Checklist'!$F18=\"Minor\",'Audit Checklist'!$F18=\"Major\",'Audit Checklist'!$F18=\"Best Practice\"),'Audit Checklist'!$G18,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A19","v":"1.8"},{"$f":"IF(OR('Audit Checklist'!$F19=\"Observation\",'Audit Checklist'!$F19=\"Minor\",'Audit Checklist'!$F19=\"Major\",'Audit Checklist'!$F19=\"Best Practice\"),'Audit Checklist'!$B19,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F19=\"Observation\",'Audit Checklist'!$F19=\"Minor\",'Audit Checklist'!$F19=\"Major\",'Audit Checklist'!$F19=\"Best Practice\"),'Audit Checklist'!$F19,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F19=\"Observation\",'Audit Checklist'!$F19=\"Minor\",'Audit Checklist'!$F19=\"Major\",'Audit Checklist'!$F19=\"Best Practice\"),'Audit Checklist'!$G19,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A20","v":"1.9"},{"$f":"IF(OR('Audit Checklist'!$F20=\"Observation\",'Audit Checklist'!$F20=\"Minor\",'Audit Checklist'!$F20=\"Major\",'Audit Checklist'!$F20=\"Best Practice\"),'Audit Checklist'!$B20,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F20=\"Observation\",'Audit Checklist'!$F20=\"Minor\",'Audit Checklist'!$F20=\"Major\",'Audit Checklist'!$F20=\"Best Practice\"),'Audit Checklist'!$F20,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F20=\"Observation\",'Audit Checklist'!$F20=\"Minor\",'Audit Checklist'!$F20=\"Major\",'Audit Checklist'!$F20=\"Best Practice\"),'Audit Checklist'!$G20,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A21","v":"1.10"},{"$f":"IF(OR('Audit Checklist'!$F21=\"Observation\",'Audit Checklist'!$F21=\"Minor\",'Audit Checklist'!$F21=\"Major\",'Audit Checklist'!$F21=\"Best Practice\"),'Audit Checklist'!$B21,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F21=\"Observation\",'Audit Checklist'!$F21=\"Minor\",'Audit Checklist'!$F21=\"Major\",'Audit Checklist'!$F21=\"Best Practice\"),'Audit Checklist'!$F21,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F21=\"Observation\",'Audit Checklist'!$F21=\"Minor\",'Audit Checklist'!$F21=\"Major\",'Audit Checklist'!$F21=\"Best Practice\"),'Audit Checklist'!$G21,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A22","v":"1.11"},{"$f":"IF(OR('Audit Checklist'!$F22=\"Observation\",'Audit Checklist'!$F22=\"Minor\",'Audit Checklist'!$F22=\"Major\",'Audit Checklist'!$F22=\"Best Practice\"),'Audit Checklist'!$B22,\"0\")","v":"Are Chemical materials used at supplier properly managed:\n - do they have an effective process in place to ensure compliance with the chemical restrictions?\n - are all storage containers of chem. raw materials, supply chemicals in progress in good condition, stored in contained areas & well managed with the correct information?\n - are all material safety data sheets (MSDS) for all chemicals updated and available to employees for their use, are those easily accessible from all the employees?\n\nPlease check in warehouse and production area"},{"$f":"IF(OR('Audit Checklist'!$F22=\"Observation\",'Audit Checklist'!$F22=\"Minor\",'Audit Checklist'!$F22=\"Major\",'Audit Checklist'!$F22=\"Best Practice\"),'Audit Checklist'!$F22,\"0\")","v":"Minor"},{"$f":"IF(OR('Audit Checklist'!$F22=\"Observation\",'Audit Checklist'!$F22=\"Minor\",'Audit Checklist'!$F22=\"Major\",'Audit Checklist'!$F22=\"Best Practice\"),'Audit Checklist'!$G22,\"0\")","v":"All chemicals are handled by an fully accredited waste management/hazmat company.  None of these chemicals are used in the final product anyways.  During Audit we came across Oxygen welding cylinders that was not secured. And could be knocked over. This is OSHA recordable.    \n1910.253\tOxygen-fuel gas welding and cutting:  (b)(2)(ii)\tInside of buildings, cylinders shall be stored in a well-protected, well-ventilated, dry location, at least 20 (6.1 m) feet from highly combustible materials such as oil or excelsior. Cylinders should be stored in definitely assigned places away from elevators, stairs, or gangways. Assigned storage spaces shall be located where cylinders will not be knocked over or damaged by passing or falling objects, or subject to tampering by unauthorized persons. Cylinders shall not be kept in unventilated enclosures such as lockers and cupboards.  "},"Please provide prove of containment / resolution of the finding. Photo of corrected finding will be required.","Closed","Patrick V. Macias ","2024-05-30"]
[null,{"$f":"'Audit Checklist'!A26","v":"2.1"},{"$f":"IF(OR('Audit Checklist'!$F26=\"Observation\",'Audit Checklist'!$F26=\"Minor\",'Audit Checklist'!$F26=\"Major\",'Audit Checklist'!$F26=\"Best Practice\"),'Audit Checklist'!$B26,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F26=\"Observation\",'Audit Checklist'!$F26=\"Minor\",'Audit Checklist'!$F26=\"Major\",'Audit Checklist'!$F26=\"Best Practice\"),'Audit Checklist'!$F26,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F26=\"Observation\",'Audit Checklist'!$F26=\"Minor\",'Audit Checklist'!$F26=\"Major\",'Audit Checklist'!$F26=\"Best Practice\"),'Audit Checklist'!$G26,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A27","v":"2.2"},{"$f":"IF(OR('Audit Checklist'!$F27=\"Observation\",'Audit Checklist'!$F27=\"Minor\",'Audit Checklist'!$F27=\"Major\",'Audit Checklist'!$F27=\"Best Practice\"),'Audit Checklist'!$B27,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F27=\"Observation\",'Audit Checklist'!$F27=\"Minor\",'Audit Checklist'!$F27=\"Major\",'Audit Checklist'!$F27=\"Best Practice\"),'Audit Checklist'!$F27,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F27=\"Observation\",'Audit Checklist'!$F27=\"Minor\",'Audit Checklist'!$F27=\"Major\",'Audit Checklist'!$F27=\"Best Practice\"),'Audit Checklist'!$G27,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A28","v":"2.3"},{"$f":"IF(OR('Audit Checklist'!$F28=\"Observation\",'Audit Checklist'!$F28=\"Minor\",'Audit Checklist'!$F28=\"Major\",'Audit Checklist'!$F28=\"Best Practice\"),'Audit Checklist'!$B28,\"0\")","v":"Does a training plan exist to qualify the internal  operators? If so, can the supplier specify how the  first and the following plans are made  \n"},{"$f":"IF(OR('Audit Checklist'!$F28=\"Observation\",'Audit Checklist'!$F28=\"Minor\",'Audit Checklist'!$F28=\"Major\",'Audit Checklist'!$F28=\"Best Practice\"),'Audit Checklist'!$F28,\"0\")","v":"Observation"},{"$f":"IF(OR('Audit Checklist'!$F28=\"Observation\",'Audit Checklist'!$F28=\"Minor\",'Audit Checklist'!$F28=\"Major\",'Audit Checklist'!$F28=\"Best Practice\"),'Audit Checklist'!$G28,\"0\")","v":"A training matrix is kept which includes skill levels. But it would be recommended to keep training records."}]
[null,{"$f":"'Audit Checklist'!A29","v":"2.4"},{"$f":"IF(OR('Audit Checklist'!$F29=\"Observation\",'Audit Checklist'!$F29=\"Minor\",'Audit Checklist'!$F29=\"Major\",'Audit Checklist'!$F29=\"Best Practice\"),'Audit Checklist'!$B29,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F29=\"Observation\",'Audit Checklist'!$F29=\"Minor\",'Audit Checklist'!$F29=\"Major\",'Audit Checklist'!$F29=\"Best Practice\"),'Audit Checklist'!$F29,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F29=\"Observation\",'Audit Checklist'!$F29=\"Minor\",'Audit Checklist'!$F29=\"Major\",'Audit Checklist'!$F29=\"Best Practice\"),'Audit Checklist'!$G29,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A33","v":"3.1\nMajor Requirement"},{"$f":"IF(OR('Audit Checklist'!$F33=\"Observation\",'Audit Checklist'!$F33=\"Minor\",'Audit Checklist'!$F33=\"Major\",'Audit Checklist'!$F33=\"Best Practice\"),'Audit Checklist'!$B33,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F33=\"Observation\",'Audit Checklist'!$F33=\"Minor\",'Audit Checklist'!$F33=\"Major\",'Audit Checklist'!$F33=\"Best Practice\"),'Audit Checklist'!$F33,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F33=\"Observation\",'Audit Checklist'!$F33=\"Minor\",'Audit Checklist'!$F33=\"Major\",'Audit Checklist'!$F33=\"Best Practice\"),'Audit Checklist'!$G33,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A34","v":"3.2\nMajor Requirement"},{"$f":"IF(OR('Audit Checklist'!$F34=\"Observation\",'Audit Checklist'!$F34=\"Minor\",'Audit Checklist'!$F34=\"Major\",'Audit Checklist'!$F34=\"Best Practice\"),'Audit Checklist'!$B34,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F34=\"Observation\",'Audit Checklist'!$F34=\"Minor\",'Audit Checklist'!$F34=\"Major\",'Audit Checklist'!$F34=\"Best Practice\"),'Audit Checklist'!$F34,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F34=\"Observation\",'Audit Checklist'!$F34=\"Minor\",'Audit Checklist'!$F34=\"Major\",'Audit Checklist'!$F34=\"Best Practice\"),'Audit Checklist'!$G34,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A35","v":"3.3"},{"$f":"IF(OR('Audit Checklist'!$F35=\"Observation\",'Audit Checklist'!$F35=\"Minor\",'Audit Checklist'!$F35=\"Major\",'Audit Checklist'!$F35=\"Best Practice\"),'Audit Checklist'!$B35,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F35=\"Observation\",'Audit Checklist'!$F35=\"Minor\",'Audit Checklist'!$F35=\"Major\",'Audit Checklist'!$F35=\"Best Practice\"),'Audit Checklist'!$F35,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F35=\"Observation\",'Audit Checklist'!$F35=\"Minor\",'Audit Checklist'!$F35=\"Major\",'Audit Checklist'!$F35=\"Best Practice\"),'Audit Checklist'!$G35,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A36","v":"3.4"},{"$f":"IF(OR('Audit Checklist'!$F36=\"Observation\",'Audit Checklist'!$F36=\"Minor\",'Audit Checklist'!$F36=\"Major\",'Audit Checklist'!$F36=\"Best Practice\"),'Audit Checklist'!$B36,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F36=\"Observation\",'Audit Checklist'!$F36=\"Minor\",'Audit Checklist'!$F36=\"Major\",'Audit Checklist'!$F36=\"Best Practice\"),'Audit Checklist'!$F36,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F36=\"Observation\",'Audit Checklist'!$F36=\"Minor\",'Audit Checklist'!$F36=\"Major\",'Audit Checklist'!$F36=\"Best Practice\"),'Audit Checklist'!$G36,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A37","v":"3.5"},{"$f":"IF(OR('Audit Checklist'!$F37=\"Observation\",'Audit Checklist'!$F37=\"Minor\",'Audit Checklist'!$F37=\"Major\",'Audit Checklist'!$F37=\"Best Practice\"),'Audit Checklist'!$B37,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F37=\"Observation\",'Audit Checklist'!$F37=\"Minor\",'Audit Checklist'!$F37=\"Major\",'Audit Checklist'!$F37=\"Best Practice\"),'Audit Checklist'!$F37,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F37=\"Observation\",'Audit Checklist'!$F37=\"Minor\",'Audit Checklist'!$F37=\"Major\",'Audit Checklist'!$F37=\"Best Practice\"),'Audit Checklist'!$G37,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A38","v":"3.6"},{"$f":"IF(OR('Audit Checklist'!$F38=\"Observation\",'Audit Checklist'!$F38=\"Minor\",'Audit Checklist'!$F38=\"Major\",'Audit Checklist'!$F38=\"Best Practice\"),'Audit Checklist'!$B38,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F38=\"Observation\",'Audit Checklist'!$F38=\"Minor\",'Audit Checklist'!$F38=\"Major\",'Audit Checklist'!$F38=\"Best Practice\"),'Audit Checklist'!$F38,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F38=\"Observation\",'Audit Checklist'!$F38=\"Minor\",'Audit Checklist'!$F38=\"Major\",'Audit Checklist'!$F38=\"Best Practice\"),'Audit Checklist'!$G38,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A39","v":"3.7"},{"$f":"IF(OR('Audit Checklist'!$F39=\"Observation\",'Audit Checklist'!$F39=\"Minor\",'Audit Checklist'!$F39=\"Major\",'Audit Checklist'!$F39=\"Best Practice\"),'Audit Checklist'!$B39,\"0\")","v":"Does the supplier have an effective identification system in place? \nApplicable for finished products/work in progress/incoming (raw) material\n\nCheck that for the particular item, you can trace it from source to delivery to ABB. This should include any 'special' lots as well."},{"$f":"IF(OR('Audit Checklist'!$F39=\"Observation\",'Audit Checklist'!$F39=\"Minor\",'Audit Checklist'!$F39=\"Major\",'Audit Checklist'!$F39=\"Best Practice\"),'Audit Checklist'!$F39,\"0\")","v":"Best Practice"},{"$f":"IF(OR('Audit Checklist'!$F39=\"Observation\",'Audit Checklist'!$F39=\"Minor\",'Audit Checklist'!$F39=\"Major\",'Audit Checklist'!$F39=\"Best Practice\"),'Audit Checklist'!$G39,\"0\")","v":"all material supplied by Jemison is assigned a identification number and is traceable through all steps of production from purchase and raw material certification to finished product. "}]
[null,{"$f":"'Audit Checklist'!A40","v":"3.8"},{"$f":"IF(OR('Audit Checklist'!$F40=\"Observation\",'Audit Checklist'!$F40=\"Minor\",'Audit Checklist'!$F40=\"Major\",'Audit Checklist'!$F40=\"Best Practice\"),'Audit Checklist'!$B40,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F40=\"Observation\",'Audit Checklist'!$F40=\"Minor\",'Audit Checklist'!$F40=\"Major\",'Audit Checklist'!$F40=\"Best Practice\"),'Audit Checklist'!$F40,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F40=\"Observation\",'Audit Checklist'!$F40=\"Minor\",'Audit Checklist'!$F40=\"Major\",'Audit Checklist'!$F40=\"Best Practice\"),'Audit Checklist'!$G40,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A41","v":"3.9\n"},{"$f":"IF(OR('Audit Checklist'!$F41=\"Observation\",'Audit Checklist'!$F41=\"Minor\",'Audit Checklist'!$F41=\"Major\",'Audit Checklist'!$F41=\"Best Practice\"),'Audit Checklist'!$B41,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F41=\"Observation\",'Audit Checklist'!$F41=\"Minor\",'Audit Checklist'!$F41=\"Major\",'Audit Checklist'!$F41=\"Best Practice\"),'Audit Checklist'!$F41,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F41=\"Observation\",'Audit Checklist'!$F41=\"Minor\",'Audit Checklist'!$F41=\"Major\",'Audit Checklist'!$F41=\"Best Practice\"),'Audit Checklist'!$G41,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A42","v":"3.10"},{"$f":"IF(OR('Audit Checklist'!$F42=\"Observation\",'Audit Checklist'!$F42=\"Minor\",'Audit Checklist'!$F42=\"Major\",'Audit Checklist'!$F42=\"Best Practice\"),'Audit Checklist'!$B42,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F42=\"Observation\",'Audit Checklist'!$F42=\"Minor\",'Audit Checklist'!$F42=\"Major\",'Audit Checklist'!$F42=\"Best Practice\"),'Audit Checklist'!$F42,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F42=\"Observation\",'Audit Checklist'!$F42=\"Minor\",'Audit Checklist'!$F42=\"Major\",'Audit Checklist'!$F42=\"Best Practice\"),'Audit Checklist'!$G42,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A43","v":"3.11\n"},{"$f":"IF(OR('Audit Checklist'!$F43=\"Observation\",'Audit Checklist'!$F43=\"Minor\",'Audit Checklist'!$F43=\"Major\",'Audit Checklist'!$F43=\"Best Practice\"),'Audit Checklist'!$B43,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F43=\"Observation\",'Audit Checklist'!$F43=\"Minor\",'Audit Checklist'!$F43=\"Major\",'Audit Checklist'!$F43=\"Best Practice\"),'Audit Checklist'!$F43,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F43=\"Observation\",'Audit Checklist'!$F43=\"Minor\",'Audit Checklist'!$F43=\"Major\",'Audit Checklist'!$F43=\"Best Practice\"),'Audit Checklist'!$G43,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A44","v":"3.12"},{"$f":"IF(OR('Audit Checklist'!$F44=\"Observation\",'Audit Checklist'!$F44=\"Minor\",'Audit Checklist'!$F44=\"Major\",'Audit Checklist'!$F44=\"Best Practice\"),'Audit Checklist'!$B44,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F44=\"Observation\",'Audit Checklist'!$F44=\"Minor\",'Audit Checklist'!$F44=\"Major\",'Audit Checklist'!$F44=\"Best Practice\"),'Audit Checklist'!$F44,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F44=\"Observation\",'Audit Checklist'!$F44=\"Minor\",'Audit Checklist'!$F44=\"Major\",'Audit Checklist'!$F44=\"Best Practice\"),'Audit Checklist'!$G44,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A45","v":"3.13"},{"$f":"IF(OR('Audit Checklist'!$F45=\"Observation\",'Audit Checklist'!$F45=\"Minor\",'Audit Checklist'!$F45=\"Major\",'Audit Checklist'!$F45=\"Best Practice\"),'Audit Checklist'!$B45,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F45=\"Observation\",'Audit Checklist'!$F45=\"Minor\",'Audit Checklist'!$F45=\"Major\",'Audit Checklist'!$F45=\"Best Practice\"),'Audit Checklist'!$F45,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F44=\"Observation\",'Audit Checklist'!$F44=\"Minor\",'Audit Checklist'!$F44=\"Major\",'Audit Checklist'!$F44=\"Best Practice\"),'Audit Checklist'!$G45,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A46","v":"3.14"},{"$f":"IF(OR('Audit Checklist'!$F46=\"Observation\",'Audit Checklist'!$F46=\"Minor\",'Audit Checklist'!$F46=\"Major\",'Audit Checklist'!$F46=\"Best Practice\"),'Audit Checklist'!$B46,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F46=\"Observation\",'Audit Checklist'!$F46=\"Minor\",'Audit Checklist'!$F46=\"Major\",'Audit Checklist'!$F46=\"Best Practice\"),'Audit Checklist'!$F46,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F46=\"Observation\",'Audit Checklist'!$F46=\"Minor\",'Audit Checklist'!$F46=\"Major\",'Audit Checklist'!$F46=\"Best Practice\"),'Audit Checklist'!$G46,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A47","v":"3.15"},{"$f":"IF(OR('Audit Checklist'!$F47=\"Observation\",'Audit Checklist'!$F47=\"Minor\",'Audit Checklist'!$F47=\"Major\",'Audit Checklist'!$F47=\"Best Practice\"),'Audit Checklist'!$B47,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F47=\"Observation\",'Audit Checklist'!$F47=\"Minor\",'Audit Checklist'!$F47=\"Major\",'Audit Checklist'!$F47=\"Best Practice\"),'Audit Checklist'!$F47,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F47=\"Observation\",'Audit Checklist'!$F47=\"Minor\",'Audit Checklist'!$F47=\"Major\",'Audit Checklist'!$F47=\"Best Practice\"),'Audit Checklist'!$G47,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A48","v":"3.16"},{"$f":"IF(OR('Audit Checklist'!$F48=\"Observation\",'Audit Checklist'!$F48=\"Minor\",'Audit Checklist'!$F48=\"Major\",'Audit Checklist'!$F48=\"Best Practice\"),'Audit Checklist'!$B48,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F48=\"Observation\",'Audit Checklist'!$F48=\"Minor\",'Audit Checklist'!$F48=\"Major\",'Audit Checklist'!$F48=\"Best Practice\"),'Audit Checklist'!$F48,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F48=\"Observation\",'Audit Checklist'!$F48=\"Minor\",'Audit Checklist'!$F48=\"Major\",'Audit Checklist'!$F48=\"Best Practice\"),'Audit Checklist'!$G48,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A49","v":"3.17\nMajor Requirement"},{"$f":"IF(OR('Audit Checklist'!$F49=\"Observation\",'Audit Checklist'!$F49=\"Minor\",'Audit Checklist'!$F49=\"Major\",'Audit Checklist'!$F49=\"Best Practice\"),'Audit Checklist'!$B49,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F49=\"Observation\",'Audit Checklist'!$F49=\"Minor\",'Audit Checklist'!$F49=\"Major\",'Audit Checklist'!$F49=\"Best Practice\"),'Audit Checklist'!$F49,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F49=\"Observation\",'Audit Checklist'!$F49=\"Minor\",'Audit Checklist'!$F49=\"Major\",'Audit Checklist'!$F49=\"Best Practice\"),'Audit Checklist'!$G49,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A53","v":"4.1\n"},{"$f":"IF(OR('Audit Checklist'!$F53=\"Observation\",'Audit Checklist'!$F53=\"Minor\",'Audit Checklist'!$F53=\"Major\",'Audit Checklist'!$F53=\"Best Practice\"),'Audit Checklist'!$B53,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F53=\"Observation\",'Audit Checklist'!$F53=\"Minor\",'Audit Checklist'!$F53=\"Major\",'Audit Checklist'!$F53=\"Best Practice\"),'Audit Checklist'!$F53,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F53=\"Observation\",'Audit Checklist'!$F53=\"Minor\",'Audit Checklist'!$F53=\"Major\",'Audit Checklist'!$F53=\"Best Practice\"),'Audit Checklist'!$G53,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A54","v":"4.2"},{"$f":"IF(OR('Audit Checklist'!$F54=\"Observation\",'Audit Checklist'!$F54=\"Minor\",'Audit Checklist'!$F54=\"Major\",'Audit Checklist'!$F54=\"Best Practice\"),'Audit Checklist'!$B54,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F54=\"Observation\",'Audit Checklist'!$F54=\"Minor\",'Audit Checklist'!$F54=\"Major\",'Audit Checklist'!$F54=\"Best Practice\"),'Audit Checklist'!$F54,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F54=\"Observation\",'Audit Checklist'!$F54=\"Minor\",'Audit Checklist'!$F54=\"Major\",'Audit Checklist'!$F54=\"Best Practice\"),'Audit Checklist'!$G54,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A55","v":"4.3\n"},{"$f":"IF(OR('Audit Checklist'!$F55=\"Observation\",'Audit Checklist'!$F55=\"Minor\",'Audit Checklist'!$F55=\"Major\",'Audit Checklist'!$F55=\"Best Practice\"),'Audit Checklist'!$B55,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F55=\"Observation\",'Audit Checklist'!$F55=\"Minor\",'Audit Checklist'!$F55=\"Major\",'Audit Checklist'!$F55=\"Best Practice\"),'Audit Checklist'!$F55,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F55=\"Observation\",'Audit Checklist'!$F55=\"Minor\",'Audit Checklist'!$F55=\"Major\",'Audit Checklist'!$F55=\"Best Practice\"),'Audit Checklist'!$G55,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A56","v":"4.4"},{"$f":"IF(OR('Audit Checklist'!$F56=\"Observation\",'Audit Checklist'!$F56=\"Minor\",'Audit Checklist'!$F56=\"Major\",'Audit Checklist'!$F56=\"Best Practice\"),'Audit Checklist'!$B56,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F56=\"Observation\",'Audit Checklist'!$F56=\"Minor\",'Audit Checklist'!$F56=\"Major\",'Audit Checklist'!$F56=\"Best Practice\"),'Audit Checklist'!$F56,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F56=\"Observation\",'Audit Checklist'!$F56=\"Minor\",'Audit Checklist'!$F56=\"Major\",'Audit Checklist'!$F56=\"Best Practice\"),'Audit Checklist'!$G56,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A57","v":"4.5"},{"$f":"IF(OR('Audit Checklist'!$F57=\"Observation\",'Audit Checklist'!$F57=\"Minor\",'Audit Checklist'!$F57=\"Major\",'Audit Checklist'!$F57=\"Best Practice\"),'Audit Checklist'!$B57,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F57=\"Observation\",'Audit Checklist'!$F57=\"Minor\",'Audit Checklist'!$F57=\"Major\",'Audit Checklist'!$F57=\"Best Practice\"),'Audit Checklist'!$F57,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F57=\"Observation\",'Audit Checklist'!$F57=\"Minor\",'Audit Checklist'!$F57=\"Major\",'Audit Checklist'!$F57=\"Best Practice\"),'Audit Checklist'!$G57,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A58","v":"4.6"},{"$f":"IF(OR('Audit Checklist'!$F58=\"Observation\",'Audit Checklist'!$F58=\"Minor\",'Audit Checklist'!$F58=\"Major\",'Audit Checklist'!$F58=\"Best Practice\"),'Audit Checklist'!$B58,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F58=\"Observation\",'Audit Checklist'!$F58=\"Minor\",'Audit Checklist'!$F58=\"Major\",'Audit Checklist'!$F58=\"Best Practice\"),'Audit Checklist'!$F58,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F58=\"Observation\",'Audit Checklist'!$F58=\"Minor\",'Audit Checklist'!$F58=\"Major\",'Audit Checklist'!$F58=\"Best Practice\"),'Audit Checklist'!$G58,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A59","v":"4.7"},{"$f":"IF(OR('Audit Checklist'!$F59=\"Observation\",'Audit Checklist'!$F59=\"Minor\",'Audit Checklist'!$F59=\"Major\",'Audit Checklist'!$F59=\"Best Practice\"),'Audit Checklist'!$B59,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F59=\"Observation\",'Audit Checklist'!$F59=\"Minor\",'Audit Checklist'!$F59=\"Major\",'Audit Checklist'!$F59=\"Best Practice\"),'Audit Checklist'!$F59,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F59=\"Observation\",'Audit Checklist'!$F59=\"Minor\",'Audit Checklist'!$F59=\"Major\",'Audit Checklist'!$F59=\"Best Practice\"),'Audit Checklist'!$G59,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A60","v":"4.8\n"},{"$f":"IF(OR('Audit Checklist'!$F60=\"Observation\",'Audit Checklist'!$F60=\"Minor\",'Audit Checklist'!$F60=\"Major\",'Audit Checklist'!$F60=\"Best Practice\"),'Audit Checklist'!$B60,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F60=\"Observation\",'Audit Checklist'!$F60=\"Minor\",'Audit Checklist'!$F60=\"Major\",'Audit Checklist'!$F60=\"Best Practice\"),'Audit Checklist'!$F60,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F60=\"Observation\",'Audit Checklist'!$F60=\"Minor\",'Audit Checklist'!$F60=\"Major\",'Audit Checklist'!$F60=\"Best Practice\"),'Audit Checklist'!$G60,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A61","v":"4.9"},{"$f":"IF(OR('Audit Checklist'!$F61=\"Observation\",'Audit Checklist'!$F61=\"Minor\",'Audit Checklist'!$F61=\"Major\",'Audit Checklist'!$F61=\"Best Practice\"),'Audit Checklist'!$B61,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F61=\"Observation\",'Audit Checklist'!$F61=\"Minor\",'Audit Checklist'!$F61=\"Major\",'Audit Checklist'!$F61=\"Best Practice\"),'Audit Checklist'!$F61,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F61=\"Observation\",'Audit Checklist'!$F61=\"Minor\",'Audit Checklist'!$F61=\"Major\",'Audit Checklist'!$F61=\"Best Practice\"),'Audit Checklist'!$G61,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A62","v":"4.10\n"},{"$f":"IF(OR('Audit Checklist'!$F62=\"Observation\",'Audit Checklist'!$F62=\"Minor\",'Audit Checklist'!$F62=\"Major\",'Audit Checklist'!$F62=\"Best Practice\"),'Audit Checklist'!$B62,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F62=\"Observation\",'Audit Checklist'!$F62=\"Minor\",'Audit Checklist'!$F62=\"Major\",'Audit Checklist'!$F62=\"Best Practice\"),'Audit Checklist'!$F62,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F62=\"Observation\",'Audit Checklist'!$F62=\"Minor\",'Audit Checklist'!$F62=\"Major\",'Audit Checklist'!$F62=\"Best Practice\"),'Audit Checklist'!$G62,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A63","v":"4.11\n"},{"$f":"IF(OR('Audit Checklist'!$F63=\"Observation\",'Audit Checklist'!$F63=\"Minor\",'Audit Checklist'!$F63=\"Major\",'Audit Checklist'!$F63=\"Best Practice\"),'Audit Checklist'!$B63,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F63=\"Observation\",'Audit Checklist'!$F63=\"Minor\",'Audit Checklist'!$F63=\"Major\",'Audit Checklist'!$F63=\"Best Practice\"),'Audit Checklist'!$F63,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F63=\"Observation\",'Audit Checklist'!$F63=\"Minor\",'Audit Checklist'!$F63=\"Major\",'Audit Checklist'!$F63=\"Best Practice\"),'Audit Checklist'!$G63,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A64","v":"4.12"},{"$f":"IF(OR('Audit Checklist'!$F64=\"Observation\",'Audit Checklist'!$F64=\"Minor\",'Audit Checklist'!$F64=\"Major\",'Audit Checklist'!$F64=\"Best Practice\"),'Audit Checklist'!$B64,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F64=\"Observation\",'Audit Checklist'!$F64=\"Minor\",'Audit Checklist'!$F64=\"Major\",'Audit Checklist'!$F64=\"Best Practice\"),'Audit Checklist'!$F64,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F64=\"Observation\",'Audit Checklist'!$F64=\"Minor\",'Audit Checklist'!$F64=\"Major\",'Audit Checklist'!$F64=\"Best Practice\"),'Audit Checklist'!$G64,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A65","v":"4.13"},{"$f":"IF(OR('Audit Checklist'!$F65=\"Observation\",'Audit Checklist'!$F65=\"Minor\",'Audit Checklist'!$F65=\"Major\",'Audit Checklist'!$F65=\"Best Practice\"),'Audit Checklist'!$B65,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F65=\"Observation\",'Audit Checklist'!$F65=\"Minor\",'Audit Checklist'!$F65=\"Major\",'Audit Checklist'!$F65=\"Best Practice\"),'Audit Checklist'!$F65,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F65=\"Observation\",'Audit Checklist'!$F65=\"Minor\",'Audit Checklist'!$F65=\"Major\",'Audit Checklist'!$F65=\"Best Practice\"),'Audit Checklist'!$G65,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A66","v":"4.14\nMajor Requirement\n"},{"$f":"IF(OR('Audit Checklist'!$F66=\"Observation\",'Audit Checklist'!$F66=\"Minor\",'Audit Checklist'!$F66=\"Major\",'Audit Checklist'!$F66=\"Best Practice\"),'Audit Checklist'!$B66,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F66=\"Observation\",'Audit Checklist'!$F66=\"Minor\",'Audit Checklist'!$F66=\"Major\",'Audit Checklist'!$F66=\"Best Practice\"),'Audit Checklist'!$F66,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F66=\"Observation\",'Audit Checklist'!$F66=\"Minor\",'Audit Checklist'!$F66=\"Major\",'Audit Checklist'!$F66=\"Best Practice\"),'Audit Checklist'!$G66,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A70","v":"5.1"},{"$f":"IF(OR('Audit Checklist'!$F70=\"Observation\",'Audit Checklist'!$F70=\"Minor\",'Audit Checklist'!$F70=\"Major\",'Audit Checklist'!$F70=\"Best Practice\"),'Audit Checklist'!$B70,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F70=\"Observation\",'Audit Checklist'!$F70=\"Minor\",'Audit Checklist'!$F70=\"Major\",'Audit Checklist'!$F70=\"Best Practice\"),'Audit Checklist'!$F70,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F70=\"Observation\",'Audit Checklist'!$F70=\"Minor\",'Audit Checklist'!$F70=\"Major\",'Audit Checklist'!$F70=\"Best Practice\"),'Audit Checklist'!$G70,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A71","v":"5.2"},{"$f":"IF(OR('Audit Checklist'!$F71=\"Observation\",'Audit Checklist'!$F71=\"Minor\",'Audit Checklist'!$F71=\"Major\",'Audit Checklist'!$F71=\"Best Practice\"),'Audit Checklist'!$B71,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F71=\"Observation\",'Audit Checklist'!$F71=\"Minor\",'Audit Checklist'!$F71=\"Major\",'Audit Checklist'!$F71=\"Best Practice\"),'Audit Checklist'!$F71,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F71=\"Observation\",'Audit Checklist'!$F71=\"Minor\",'Audit Checklist'!$F71=\"Major\",'Audit Checklist'!$F71=\"Best Practice\"),'Audit Checklist'!$G71,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A72","v":"5.3"},{"$f":"IF(OR('Audit Checklist'!$F72=\"Observation\",'Audit Checklist'!$F72=\"Minor\",'Audit Checklist'!$F72=\"Major\",'Audit Checklist'!$F72=\"Best Practice\"),'Audit Checklist'!$B72,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F72=\"Observation\",'Audit Checklist'!$F72=\"Minor\",'Audit Checklist'!$F72=\"Major\",'Audit Checklist'!$F72=\"Best Practice\"),'Audit Checklist'!$F72,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F72=\"Observation\",'Audit Checklist'!$F72=\"Minor\",'Audit Checklist'!$F72=\"Major\",'Audit Checklist'!$F72=\"Best Practice\"),'Audit Checklist'!$G72,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A73","v":"5.4"},{"$f":"IF(OR('Audit Checklist'!$F73=\"Observation\",'Audit Checklist'!$F73=\"Minor\",'Audit Checklist'!$F73=\"Major\",'Audit Checklist'!$F73=\"Best Practice\"),'Audit Checklist'!$B73,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F73=\"Observation\",'Audit Checklist'!$F73=\"Minor\",'Audit Checklist'!$F73=\"Major\",'Audit Checklist'!$F73=\"Best Practice\"),'Audit Checklist'!$F73,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F73=\"Observation\",'Audit Checklist'!$F73=\"Minor\",'Audit Checklist'!$F73=\"Major\",'Audit Checklist'!$F73=\"Best Practice\"),'Audit Checklist'!$G73,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A74","v":"5.5"},{"$f":"IF(OR('Audit Checklist'!$F74=\"Observation\",'Audit Checklist'!$F74=\"Minor\",'Audit Checklist'!$F74=\"Major\",'Audit Checklist'!$F74=\"Best Practice\"),'Audit Checklist'!$B74,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F74=\"Observation\",'Audit Checklist'!$F74=\"Minor\",'Audit Checklist'!$F74=\"Major\",'Audit Checklist'!$F74=\"Best Practice\"),'Audit Checklist'!$F74,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F74=\"Observation\",'Audit Checklist'!$F74=\"Minor\",'Audit Checklist'!$F74=\"Major\",'Audit Checklist'!$F74=\"Best Practice\"),'Audit Checklist'!$G74,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A75","v":"5.6"},{"$f":"IF(OR('Audit Checklist'!$F75=\"Observation\",'Audit Checklist'!$F75=\"Minor\",'Audit Checklist'!$F75=\"Major\",'Audit Checklist'!$F75=\"Best Practice\"),'Audit Checklist'!$B75,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F75=\"Observation\",'Audit Checklist'!$F75=\"Minor\",'Audit Checklist'!$F75=\"Major\",'Audit Checklist'!$F75=\"Best Practice\"),'Audit Checklist'!$F75,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F75=\"Observation\",'Audit Checklist'!$F75=\"Minor\",'Audit Checklist'!$F75=\"Major\",'Audit Checklist'!$F75=\"Best Practice\"),'Audit Checklist'!$G75,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A76","v":"5.7"},{"$f":"IF(OR('Audit Checklist'!$F76=\"Observation\",'Audit Checklist'!$F76=\"Minor\",'Audit Checklist'!$F76=\"Major\",'Audit Checklist'!$F76=\"Best Practice\"),'Audit Checklist'!$B76,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F76=\"Observation\",'Audit Checklist'!$F76=\"Minor\",'Audit Checklist'!$F76=\"Major\",'Audit Checklist'!$F76=\"Best Practice\"),'Audit Checklist'!$F76,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F76=\"Observation\",'Audit Checklist'!$F76=\"Minor\",'Audit Checklist'!$F76=\"Major\",'Audit Checklist'!$F76=\"Best Practice\"),'Audit Checklist'!$G76,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A77","v":"5.8"},{"$f":"IF(OR('Audit Checklist'!$F77=\"Observation\",'Audit Checklist'!$F77=\"Minor\",'Audit Checklist'!$F77=\"Major\",'Audit Checklist'!$F77=\"Best Practice\"),'Audit Checklist'!$B77,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F77=\"Observation\",'Audit Checklist'!$F77=\"Minor\",'Audit Checklist'!$F77=\"Major\",'Audit Checklist'!$F77=\"Best Practice\"),'Audit Checklist'!$F77,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F77=\"Observation\",'Audit Checklist'!$F77=\"Minor\",'Audit Checklist'!$F77=\"Major\",'Audit Checklist'!$F77=\"Best Practice\"),'Audit Checklist'!$G77,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A78","v":"5.9"},{"$f":"IF(OR('Audit Checklist'!$F78=\"Observation\",'Audit Checklist'!$F78=\"Minor\",'Audit Checklist'!$F78=\"Major\",'Audit Checklist'!$F78=\"Best Practice\"),'Audit Checklist'!$B78,\"0\")","v":"Are the working stations standardized and 5S (or similar)  methodology implemented?\n(Are the bins on the working stations in a good condition? No broken or dirty bins?   \nAre the labels on the working stations in a good condition? Labels for material bins, tool places, jigs location, document locations etc.\nAre the needed trolley places / pallet places clearly marked on the floor? \nAre the material bins, the scrap bins and the tools in the defined places?\nAre there trash bins in every working station?  )"},{"$f":"IF(OR('Audit Checklist'!$F78=\"Observation\",'Audit Checklist'!$F78=\"Minor\",'Audit Checklist'!$F78=\"Major\",'Audit Checklist'!$F78=\"Best Practice\"),'Audit Checklist'!$F78,\"0\")","v":"Observation"},{"$f":"IF(OR('Audit Checklist'!$F78=\"Observation\",'Audit Checklist'!$F78=\"Minor\",'Audit Checklist'!$F78=\"Major\",'Audit Checklist'!$F78=\"Best Practice\"),'Audit Checklist'!$G78,\"0\")","v":"Jemison needs to start the 5S program from the beginning."}]
[null,{"$f":"'Audit Checklist'!A79","v":"5.10"},{"$f":"IF(OR('Audit Checklist'!$F79=\"Observation\",'Audit Checklist'!$F79=\"Minor\",'Audit Checklist'!$F79=\"Major\",'Audit Checklist'!$F79=\"Best Practice\"),'Audit Checklist'!$B79,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F79=\"Observation\",'Audit Checklist'!$F79=\"Minor\",'Audit Checklist'!$F79=\"Major\",'Audit Checklist'!$F79=\"Best Practice\"),'Audit Checklist'!$F79,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F79=\"Observation\",'Audit Checklist'!$F79=\"Minor\",'Audit Checklist'!$F79=\"Major\",'Audit Checklist'!$F79=\"Best Practice\"),'Audit Checklist'!$G79,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A80","v":"5.11"},{"$f":"IF(OR('Audit Checklist'!$F80=\"Observation\",'Audit Checklist'!$F80=\"Minor\",'Audit Checklist'!$F80=\"Major\",'Audit Checklist'!$F80=\"Best Practice\"),'Audit Checklist'!$B80,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F80=\"Observation\",'Audit Checklist'!$F80=\"Minor\",'Audit Checklist'!$F80=\"Major\",'Audit Checklist'!$F80=\"Best Practice\"),'Audit Checklist'!$F80,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F80=\"Observation\",'Audit Checklist'!$F80=\"Minor\",'Audit Checklist'!$F80=\"Major\",'Audit Checklist'!$F80=\"Best Practice\"),'Audit Checklist'!$G80,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A81","v":"5.12"},{"$f":"IF(OR('Audit Checklist'!$F81=\"Observation\",'Audit Checklist'!$F81=\"Minor\",'Audit Checklist'!$F81=\"Major\",'Audit Checklist'!$F81=\"Best Practice\"),'Audit Checklist'!$B81,\"0\")","v":"Is there a formal approval procedure before the lot is transferred to the next stage? (i.e. the lots are checked at a given frequency before they are moved to the next stages)"},{"$f":"IF(OR('Audit Checklist'!$F81=\"Observation\",'Audit Checklist'!$F81=\"Minor\",'Audit Checklist'!$F81=\"Major\",'Audit Checklist'!$F81=\"Best Practice\"),'Audit Checklist'!$F81,\"0\")","v":"Best Practice"},{"$f":"IF(OR('Audit Checklist'!$F81=\"Observation\",'Audit Checklist'!$F81=\"Minor\",'Audit Checklist'!$F81=\"Major\",'Audit Checklist'!$F81=\"Best Practice\"),'Audit Checklist'!$G81,\"0\")","v":"All Operating procedures include an inspection/sampling plan that includes sampling frequency. "}]
[null,{"$f":"'Audit Checklist'!A82","v":"5.13"},{"$f":"IF(OR('Audit Checklist'!$F82=\"Observation\",'Audit Checklist'!$F82=\"Minor\",'Audit Checklist'!$F82=\"Major\",'Audit Checklist'!$F82=\"Best Practice\"),'Audit Checklist'!$B82,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F82=\"Observation\",'Audit Checklist'!$F82=\"Minor\",'Audit Checklist'!$F82=\"Major\",'Audit Checklist'!$F82=\"Best Practice\"),'Audit Checklist'!$F82,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F82=\"Observation\",'Audit Checklist'!$F82=\"Minor\",'Audit Checklist'!$F82=\"Major\",'Audit Checklist'!$F82=\"Best Practice\"),'Audit Checklist'!$G82,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A83","v":"5.14"},{"$f":"IF(OR('Audit Checklist'!$F83=\"Observation\",'Audit Checklist'!$F83=\"Minor\",'Audit Checklist'!$F83=\"Major\",'Audit Checklist'!$F83=\"Best Practice\"),'Audit Checklist'!$B83,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F83=\"Observation\",'Audit Checklist'!$F83=\"Minor\",'Audit Checklist'!$F83=\"Major\",'Audit Checklist'!$F83=\"Best Practice\"),'Audit Checklist'!$F83,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F83=\"Observation\",'Audit Checklist'!$F83=\"Minor\",'Audit Checklist'!$F83=\"Major\",'Audit Checklist'!$F83=\"Best Practice\"),'Audit Checklist'!$G83,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A84","v":"5.15"},{"$f":"IF(OR('Audit Checklist'!$F84=\"Observation\",'Audit Checklist'!$F84=\"Minor\",'Audit Checklist'!$F84=\"Major\",'Audit Checklist'!$F84=\"Best Practice\"),'Audit Checklist'!$B84,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F84=\"Observation\",'Audit Checklist'!$F84=\"Minor\",'Audit Checklist'!$F84=\"Major\",'Audit Checklist'!$F84=\"Best Practice\"),'Audit Checklist'!$F84,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F84=\"Observation\",'Audit Checklist'!$F84=\"Minor\",'Audit Checklist'!$F84=\"Major\",'Audit Checklist'!$F84=\"Best Practice\"),'Audit Checklist'!$G84,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A85","v":"5.16"},{"$f":"IF(OR('Audit Checklist'!$F85=\"Observation\",'Audit Checklist'!$F85=\"Minor\",'Audit Checklist'!$F85=\"Major\",'Audit Checklist'!$F85=\"Best Practice\"),'Audit Checklist'!$B85,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F85=\"Observation\",'Audit Checklist'!$F85=\"Minor\",'Audit Checklist'!$F85=\"Major\",'Audit Checklist'!$F85=\"Best Practice\"),'Audit Checklist'!$F85,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F85=\"Observation\",'Audit Checklist'!$F85=\"Minor\",'Audit Checklist'!$F85=\"Major\",'Audit Checklist'!$F85=\"Best Practice\"),'Audit Checklist'!$G85,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A86","v":"5.17"},{"$f":"IF(OR('Audit Checklist'!$F86=\"Observation\",'Audit Checklist'!$F86=\"Minor\",'Audit Checklist'!$F86=\"Major\",'Audit Checklist'!$F86=\"Best Practice\"),'Audit Checklist'!$B86,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F86=\"Observation\",'Audit Checklist'!$F86=\"Minor\",'Audit Checklist'!$F86=\"Major\",'Audit Checklist'!$F86=\"Best Practice\"),'Audit Checklist'!$F86,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F86=\"Observation\",'Audit Checklist'!$F86=\"Minor\",'Audit Checklist'!$F86=\"Major\",'Audit Checklist'!$F86=\"Best Practice\"),'Audit Checklist'!$G86,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A87","v":"5.18"},{"$f":"IF(OR('Audit Checklist'!$F87=\"Observation\",'Audit Checklist'!$F87=\"Minor\",'Audit Checklist'!$F87=\"Major\",'Audit Checklist'!$F87=\"Best Practice\"),'Audit Checklist'!$B87,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F87=\"Observation\",'Audit Checklist'!$F87=\"Minor\",'Audit Checklist'!$F87=\"Major\",'Audit Checklist'!$F87=\"Best Practice\"),'Audit Checklist'!$F87,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F87=\"Observation\",'Audit Checklist'!$F87=\"Minor\",'Audit Checklist'!$F87=\"Major\",'Audit Checklist'!$F87=\"Best Practice\"),'Audit Checklist'!$G87,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A88","v":"5.19"},{"$f":"IF(OR('Audit Checklist'!$F88=\"Observation\",'Audit Checklist'!$F88=\"Minor\",'Audit Checklist'!$F88=\"Major\",'Audit Checklist'!$F88=\"Best Practice\"),'Audit Checklist'!$B88,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F88=\"Observation\",'Audit Checklist'!$F88=\"Minor\",'Audit Checklist'!$F88=\"Major\",'Audit Checklist'!$F88=\"Best Practice\"),'Audit Checklist'!$F88,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F88=\"Observation\",'Audit Checklist'!$F88=\"Minor\",'Audit Checklist'!$F88=\"Major\",'Audit Checklist'!$F88=\"Best Practice\"),'Audit Checklist'!$G88,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A89","v":"5.20"},{"$f":"IF(OR('Audit Checklist'!$F89=\"Observation\",'Audit Checklist'!$F89=\"Minor\",'Audit Checklist'!$F89=\"Major\",'Audit Checklist'!$F89=\"Best Practice\"),'Audit Checklist'!$B89,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F89=\"Observation\",'Audit Checklist'!$F89=\"Minor\",'Audit Checklist'!$F89=\"Major\",'Audit Checklist'!$F89=\"Best Practice\"),'Audit Checklist'!$F89,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F89=\"Observation\",'Audit Checklist'!$F89=\"Minor\",'Audit Checklist'!$F89=\"Major\",'Audit Checklist'!$F89=\"Best Practice\"),'Audit Checklist'!$G89,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A90","v":"5.21"},{"$f":"IF(OR('Audit Checklist'!$F90=\"Observation\",'Audit Checklist'!$F90=\"Minor\",'Audit Checklist'!$F90=\"Major\",'Audit Checklist'!$F90=\"Best Practice\"),'Audit Checklist'!$B90,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F90=\"Observation\",'Audit Checklist'!$F90=\"Minor\",'Audit Checklist'!$F90=\"Major\",'Audit Checklist'!$F90=\"Best Practice\"),'Audit Checklist'!$F90,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F90=\"Observation\",'Audit Checklist'!$F90=\"Minor\",'Audit Checklist'!$F90=\"Major\",'Audit Checklist'!$F90=\"Best Practice\"),'Audit Checklist'!$G90,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A94","v":"6.1"},{"$f":"IF(OR('Audit Checklist'!$F94=\"Observation\",'Audit Checklist'!$F94=\"Minor\",'Audit Checklist'!$F94=\"Major\",'Audit Checklist'!$F94=\"Best Practice\"),'Audit Checklist'!$B94,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F94=\"Observation\",'Audit Checklist'!$F94=\"Minor\",'Audit Checklist'!$F94=\"Major\",'Audit Checklist'!$F94=\"Best Practice\"),'Audit Checklist'!$F94,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F94=\"Observation\",'Audit Checklist'!$F94=\"Minor\",'Audit Checklist'!$F94=\"Major\",'Audit Checklist'!$F94=\"Best Practice\"),'Audit Checklist'!$G94,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A95","v":"6.2\n"},{"$f":"IF(OR('Audit Checklist'!$F95=\"Observation\",'Audit Checklist'!$F95=\"Minor\",'Audit Checklist'!$F95=\"Major\",'Audit Checklist'!$F95=\"Best Practice\"),'Audit Checklist'!$B95,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F95=\"Observation\",'Audit Checklist'!$F95=\"Minor\",'Audit Checklist'!$F95=\"Major\",'Audit Checklist'!$F95=\"Best Practice\"),'Audit Checklist'!$F95,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F95=\"Observation\",'Audit Checklist'!$F95=\"Minor\",'Audit Checklist'!$F95=\"Major\",'Audit Checklist'!$F95=\"Best Practice\"),'Audit Checklist'!$G95,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A96","v":"6.3"},{"$f":"IF(OR('Audit Checklist'!$F96=\"Observation\",'Audit Checklist'!$F96=\"Minor\",'Audit Checklist'!$F96=\"Major\",'Audit Checklist'!$F96=\"Best Practice\"),'Audit Checklist'!$B96,\"0\")","v":"Does the Supplier have a process for managing Advanced Quality Planning activity and sufficient resources to manage activity? If yes - does Supplier's AQP include scheduled formal Design Review, Management Reviews, Program Reviews, etc. with their Customer and internally?"},{"$f":"IF(OR('Audit Checklist'!$F96=\"Observation\",'Audit Checklist'!$F96=\"Minor\",'Audit Checklist'!$F96=\"Major\",'Audit Checklist'!$F96=\"Best Practice\"),'Audit Checklist'!$F96,\"0\")","v":"Best Practice"},{"$f":"IF(OR('Audit Checklist'!$F96=\"Observation\",'Audit Checklist'!$F96=\"Minor\",'Audit Checklist'!$F96=\"Major\",'Audit Checklist'!$F96=\"Best Practice\"),'Audit Checklist'!$G96,\"0\")","v":"All new parts go through a model process with a multifunctional team including quality representation. Example - "}]
[null,{"$f":"'Audit Checklist'!A97","v":"6.4"},{"$f":"IF(OR('Audit Checklist'!$F97=\"Observation\",'Audit Checklist'!$F97=\"Minor\",'Audit Checklist'!$F97=\"Major\",'Audit Checklist'!$F97=\"Best Practice\"),'Audit Checklist'!$B97,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F97=\"Observation\",'Audit Checklist'!$F97=\"Minor\",'Audit Checklist'!$F97=\"Major\",'Audit Checklist'!$F97=\"Best Practice\"),'Audit Checklist'!$F97,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F97=\"Observation\",'Audit Checklist'!$F97=\"Minor\",'Audit Checklist'!$F97=\"Major\",'Audit Checklist'!$F97=\"Best Practice\"),'Audit Checklist'!$G97,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A98","v":"6.5\n"},{"$f":"IF(OR('Audit Checklist'!$F98=\"Observation\",'Audit Checklist'!$F98=\"Minor\",'Audit Checklist'!$F98=\"Major\",'Audit Checklist'!$F98=\"Best Practice\"),'Audit Checklist'!$B98,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F98=\"Observation\",'Audit Checklist'!$F98=\"Minor\",'Audit Checklist'!$F98=\"Major\",'Audit Checklist'!$F98=\"Best Practice\"),'Audit Checklist'!$F98,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F98=\"Observation\",'Audit Checklist'!$F98=\"Minor\",'Audit Checklist'!$F98=\"Major\",'Audit Checklist'!$F98=\"Best Practice\"),'Audit Checklist'!$G98,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A99","v":"6.6"},{"$f":"IF(OR('Audit Checklist'!$F99=\"Observation\",'Audit Checklist'!$F99=\"Minor\",'Audit Checklist'!$F99=\"Major\",'Audit Checklist'!$F99=\"Best Practice\"),'Audit Checklist'!$B99,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F99=\"Observation\",'Audit Checklist'!$F99=\"Minor\",'Audit Checklist'!$F99=\"Major\",'Audit Checklist'!$F99=\"Best Practice\"),'Audit Checklist'!$F99,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F99=\"Observation\",'Audit Checklist'!$F99=\"Minor\",'Audit Checklist'!$F99=\"Major\",'Audit Checklist'!$F99=\"Best Practice\"),'Audit Checklist'!$G99,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A100","v":"6.7"},{"$f":"IF(OR('Audit Checklist'!$F100=\"Observation\",'Audit Checklist'!$F100=\"Minor\",'Audit Checklist'!$F100=\"Major\",'Audit Checklist'!$F100=\"Best Practice\"),'Audit Checklist'!$B100,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F100=\"Observation\",'Audit Checklist'!$F100=\"Minor\",'Audit Checklist'!$F100=\"Major\",'Audit Checklist'!$F100=\"Best Practice\"),'Audit Checklist'!$F100,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F100=\"Observation\",'Audit Checklist'!$F100=\"Minor\",'Audit Checklist'!$F100=\"Major\",'Audit Checklist'!$F100=\"Best Practice\"),'Audit Checklist'!$G100,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A101","v":"6.8\n"},{"$f":"IF(OR('Audit Checklist'!$F101=\"Observation\",'Audit Checklist'!$F101=\"Minor\",'Audit Checklist'!$F101=\"Major\",'Audit Checklist'!$F101=\"Best Practice\"),'Audit Checklist'!$B101,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F101=\"Observation\",'Audit Checklist'!$F101=\"Minor\",'Audit Checklist'!$F101=\"Major\",'Audit Checklist'!$F101=\"Best Practice\"),'Audit Checklist'!$F101,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F101=\"Observation\",'Audit Checklist'!$F101=\"Minor\",'Audit Checklist'!$F101=\"Major\",'Audit Checklist'!$F101=\"Best Practice\"),'Audit Checklist'!$G101,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A102","v":"6.9"},{"$f":"IF(OR('Audit Checklist'!$F102=\"Observation\",'Audit Checklist'!$F102=\"Minor\",'Audit Checklist'!$F102=\"Major\",'Audit Checklist'!$F102=\"Best Practice\"),'Audit Checklist'!$B102,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F102=\"Observation\",'Audit Checklist'!$F102=\"Minor\",'Audit Checklist'!$F102=\"Major\",'Audit Checklist'!$F102=\"Best Practice\"),'Audit Checklist'!$F102,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F102=\"Observation\",'Audit Checklist'!$F102=\"Minor\",'Audit Checklist'!$F102=\"Major\",'Audit Checklist'!$F102=\"Best Practice\"),'Audit Checklist'!$G102,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A103","v":"6.10"},{"$f":"IF(OR('Audit Checklist'!$F103=\"Observation\",'Audit Checklist'!$F103=\"Minor\",'Audit Checklist'!$F103=\"Major\",'Audit Checklist'!$F103=\"Best Practice\"),'Audit Checklist'!$B103,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F103=\"Observation\",'Audit Checklist'!$F103=\"Minor\",'Audit Checklist'!$F103=\"Major\",'Audit Checklist'!$F103=\"Best Practice\"),'Audit Checklist'!$F103,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F103=\"Observation\",'Audit Checklist'!$F103=\"Minor\",'Audit Checklist'!$F103=\"Major\",'Audit Checklist'!$F103=\"Best Practice\"),'Audit Checklist'!$G103,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A104","v":"6.11\n"},{"$f":"IF(OR('Audit Checklist'!$F104=\"Observation\",'Audit Checklist'!$F104=\"Minor\",'Audit Checklist'!$F104=\"Major\",'Audit Checklist'!$F104=\"Best Practice\"),'Audit Checklist'!$B104,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F104=\"Observation\",'Audit Checklist'!$F104=\"Minor\",'Audit Checklist'!$F104=\"Major\",'Audit Checklist'!$F104=\"Best Practice\"),'Audit Checklist'!$F104,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F104=\"Observation\",'Audit Checklist'!$F104=\"Minor\",'Audit Checklist'!$F104=\"Major\",'Audit Checklist'!$F104=\"Best Practice\"),'Audit Checklist'!$G104,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A105","v":"6.12"},{"$f":"IF(OR('Audit Checklist'!$F105=\"Observation\",'Audit Checklist'!$F105=\"Minor\",'Audit Checklist'!$F105=\"Major\",'Audit Checklist'!$F105=\"Best Practice\"),'Audit Checklist'!$B105,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F105=\"Observation\",'Audit Checklist'!$F105=\"Minor\",'Audit Checklist'!$F105=\"Major\",'Audit Checklist'!$F105=\"Best Practice\"),'Audit Checklist'!$F105,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F105=\"Observation\",'Audit Checklist'!$F105=\"Minor\",'Audit Checklist'!$F105=\"Major\",'Audit Checklist'!$F105=\"Best Practice\"),'Audit Checklist'!$G105,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A106","v":"6.13"},{"$f":"IF(OR('Audit Checklist'!$F106=\"Observation\",'Audit Checklist'!$F106=\"Minor\",'Audit Checklist'!$F106=\"Major\",'Audit Checklist'!$F106=\"Best Practice\"),'Audit Checklist'!$B106,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F106=\"Observation\",'Audit Checklist'!$F106=\"Minor\",'Audit Checklist'!$F106=\"Major\",'Audit Checklist'!$F106=\"Best Practice\"),'Audit Checklist'!$F106,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F106=\"Observation\",'Audit Checklist'!$F106=\"Minor\",'Audit Checklist'!$F106=\"Major\",'Audit Checklist'!$F106=\"Best Practice\"),'Audit Checklist'!$G106,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A107","v":"6.14\n"},{"$f":"IF(OR('Audit Checklist'!$F107=\"Observation\",'Audit Checklist'!$F107=\"Minor\",'Audit Checklist'!$F107=\"Major\",'Audit Checklist'!$F107=\"Best Practice\"),'Audit Checklist'!$B107,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F107=\"Observation\",'Audit Checklist'!$F107=\"Minor\",'Audit Checklist'!$F107=\"Major\",'Audit Checklist'!$F107=\"Best Practice\"),'Audit Checklist'!$F107,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F107=\"Observation\",'Audit Checklist'!$F107=\"Minor\",'Audit Checklist'!$F107=\"Major\",'Audit Checklist'!$F107=\"Best Practice\"),'Audit Checklist'!$G107,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A108","v":"6.15"},{"$f":"IF(OR('Audit Checklist'!$F108=\"Observation\",'Audit Checklist'!$F108=\"Minor\",'Audit Checklist'!$F108=\"Major\",'Audit Checklist'!$F108=\"Best Practice\"),'Audit Checklist'!$B108,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F108=\"Observation\",'Audit Checklist'!$F108=\"Minor\",'Audit Checklist'!$F108=\"Major\",'Audit Checklist'!$F108=\"Best Practice\"),'Audit Checklist'!$F108,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F108=\"Observation\",'Audit Checklist'!$F108=\"Minor\",'Audit Checklist'!$F108=\"Major\",'Audit Checklist'!$F108=\"Best Practice\"),'Audit Checklist'!$G108,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A109","v":"6.16\n"},{"$f":"IF(OR('Audit Checklist'!$F109=\"Observation\",'Audit Checklist'!$F109=\"Minor\",'Audit Checklist'!$F109=\"Major\",'Audit Checklist'!$F109=\"Best Practice\"),'Audit Checklist'!$B109,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F109=\"Observation\",'Audit Checklist'!$F109=\"Minor\",'Audit Checklist'!$F109=\"Major\",'Audit Checklist'!$F109=\"Best Practice\"),'Audit Checklist'!$F109,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F109=\"Observation\",'Audit Checklist'!$F109=\"Minor\",'Audit Checklist'!$F109=\"Major\",'Audit Checklist'!$F109=\"Best Practice\"),'Audit Checklist'!$G109,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A110","v":"6.17"},{"$f":"IF(OR('Audit Checklist'!$F110=\"Observation\",'Audit Checklist'!$F110=\"Minor\",'Audit Checklist'!$F110=\"Major\",'Audit Checklist'!$F110=\"Best Practice\"),'Audit Checklist'!$B110,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F110=\"Observation\",'Audit Checklist'!$F110=\"Minor\",'Audit Checklist'!$F110=\"Major\",'Audit Checklist'!$F110=\"Best Practice\"),'Audit Checklist'!$F110,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F110=\"Observation\",'Audit Checklist'!$F110=\"Minor\",'Audit Checklist'!$F110=\"Major\",'Audit Checklist'!$F110=\"Best Practice\"),'Audit Checklist'!$G110,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A111","v":"6.18\n"},{"$f":"IF(OR('Audit Checklist'!$F111=\"Observation\",'Audit Checklist'!$F111=\"Minor\",'Audit Checklist'!$F111=\"Major\",'Audit Checklist'!$F111=\"Best Practice\"),'Audit Checklist'!$B111,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F111=\"Observation\",'Audit Checklist'!$F111=\"Minor\",'Audit Checklist'!$F111=\"Major\",'Audit Checklist'!$F111=\"Best Practice\"),'Audit Checklist'!$F111,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F111=\"Observation\",'Audit Checklist'!$F111=\"Minor\",'Audit Checklist'!$F111=\"Major\",'Audit Checklist'!$F111=\"Best Practice\"),'Audit Checklist'!$G111,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A112","v":"6.19"},{"$f":"IF(OR('Audit Checklist'!$F112=\"Observation\",'Audit Checklist'!$F112=\"Minor\",'Audit Checklist'!$F112=\"Major\",'Audit Checklist'!$F112=\"Best Practice\"),'Audit Checklist'!$B112,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F112=\"Observation\",'Audit Checklist'!$F112=\"Minor\",'Audit Checklist'!$F112=\"Major\",'Audit Checklist'!$F112=\"Best Practice\"),'Audit Checklist'!$F112,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F112=\"Observation\",'Audit Checklist'!$F112=\"Minor\",'Audit Checklist'!$F112=\"Major\",'Audit Checklist'!$F112=\"Best Practice\"),'Audit Checklist'!$G112,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A113","v":"6.20\n"},{"$f":"IF(OR('Audit Checklist'!$F113=\"Observation\",'Audit Checklist'!$F113=\"Minor\",'Audit Checklist'!$F113=\"Major\",'Audit Checklist'!$F113=\"Best Practice\"),'Audit Checklist'!$B113,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F113=\"Observation\",'Audit Checklist'!$F113=\"Minor\",'Audit Checklist'!$F113=\"Major\",'Audit Checklist'!$F113=\"Best Practice\"),'Audit Checklist'!$F113,\"0\")","v":"0"},{"$f":"IF(OR('Audit Checklist'!$F113=\"Observation\",'Audit Checklist'!$F113=\"Minor\",'Audit Checklist'!$F113=\"Major\",'Audit Checklist'!$F113=\"Best Practice\"),'Audit Checklist'!$G113,\"0\")","v":"0"}]
[null,{"$f":"'Audit Checklist'!A114","v":"6.21"},{"$f":"IF(OR('Audit Checklist'!$F114=\"Observation\",'Audit Checklist'!$F114=\"Minor\",'Audit Checklist'!$F114=\"Major\",'Audit Checklist'!$F114=\"Best Practice\"),'Audit Checklist'!$B114,\"0\")","v":"Are equipment process devices / gaging included in a calibration program? "},{"$f":"IF(OR('Audit Checklist'!$F114=\"Observation\",'Audit Checklist'!$F114=\"Minor\",'Audit Checklist'!$F114=\"Major\",'Audit Checklist'!$F114=\"Best Practice\"),'Audit Checklist'!$F114,\"0\")","v":"Best Practice"},{"$f":"IF(OR('Audit Checklist'!$F114=\"Observation\",'Audit Checklist'!$F114=\"Minor\",'Audit Checklist'!$F114=\"Major\",'Audit Checklist'!$F114=\"Best Practice\"),'Audit Checklist'!$G114,\"0\")","v":"Gagetrak software is used to track calibration of all measuring equipment and schedule calibration frequency. "}]
[null,{"$f":"'Audit Checklist'!A115","v":"6.22\n"},{"$f":"IF(OR('Audit Checklist'!$F115=\"Observation\",'Audit Checklist'!$F115=\"Minor\",'Audit Checklist'!$F115=\"Major\",'Audit Checklist'!$F115=\"Best Practice\"),'Audit Checklist'!$B115,\"0\")","v":"If the measuring or the test equipment is out of calibration , what type of actions are taken?"},{"$f":"IF(OR('Audit Checklist'!$F115=\"Observation\",'Audit Checklist'!$F115=\"Minor\",'Audit Checklist'!$F115=\"Major\",'Audit Checklist'!$F115=\"Best Practice\"),'Audit Checklist'!$F115,\"0\")","v":"Best Practice"},{"$f":"IF(OR('Audit Checklist'!$F115=\"Observation\",'Audit Checklist'!$F115=\"Minor\",'Audit Checklist'!$F115=\"Major\",'Audit Checklist'!$F115=\"Best Practice\"),'Audit Checklist'!$G115,\"0\")","v":"Customer is notified if applicable. SOP 3 Control of monitoring and measuring resources , rev A."}]

{"sheet":"Evaluation","index":4,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[11,1,19,1],[22,7,22,10],[23,7,23,10],[24,7,24,10],[25,7,25,10],[28,3,29,3],[28,2,29,2],[11,2,12,2],[11,3,12,3],[11,4,11,12],[26,7,26,10]]}
[]
[null,null,"Supplier Name:",{"$f":"'Audit Checklist'!C2","v":"Jemison Steel Site Audit"}]
[null,null,"Supplier site (Address):",{"$f":"'Audit Checklist'!C3","v":"1255 North Gate Drive  Sumter, SC 29154"}]
[null,null,"Supplier GUID:",{"$f":"'Audit Checklist'!C4","v":0}]
[null,null,"Audit Date:",{"$f":"'Audit Checklist'!C5","v":"May 2nd 2024"}]
[null,null,"ABB Lead Auditor:",{"$f":"'Audit Checklist'!C6","v":"Henry George"}]
[null,null,"ABB Participants: ",{"$f":"'Audit Checklist'!C7","v":"Shri Mehta,  Roberto Arroya  Jennifer Robison"}]
[null,null,"ABB BA and Division:",{"$f":"'Audit Checklist'!C8","v":0}]
[null,null,"Audit report id:",{"$f":"'Audit Checklist'!C9","v":0}]
[]
[null,null,0.15,null,0.15,0.15,0.15]
[null,"RESULTS","Audit section","Audit score ","Findings"]
[null,null,null,null,"Show Stopper","Major","Minor","Observation","Meet Req.","Best practice","N/A","Tot","Check"]
[null,null,"Compliance",{"$f":"IFERROR(IF(SUM('Audit Checklist'!E12:E22)/(3*(COUNTA('Audit Checklist'!A12:A22)-COUNTIF('Audit Checklist'!E12:E22,\"NA\")))=0,0,SUM('Audit Checklist'!E12:E22)/(3*(COUNTA('Audit Checklist'!A12:A22)-COUNTIF('Audit Checklist'!E12:E22,\"NA\")))),\"NA\")","v":0.84848484848484851},{"$f":"COUNTIF('Audit Checklist'!$F$12:$F$22,\"ShowStopper\")","v":0},{"$f":"COUNTIF('Audit Checklist'!$F$12:$F$22,\"Major\")","v":0},{"$f":"COUNTIF('Audit Checklist'!$F$12:$F$22,\"Minor\")","v":3},{"$f":"COUNTIF('Audit Checklist'!$F$12:$F$22,\"Observation\")","v":1},{"$f":"COUNTIF('Audit Checklist'!$F$12:$F$22,\"Meet Requirement\")","v":1},{"$f":"COUNTIF('Audit Checklist'!$F$12:$F$22,\"Best practice\")","v":0},{"$f":"COUNTIF('Audit Checklist'!$F$12:$F$22,\"N/A\")","v":0},{"$f":"SUM(E14:K14)","v":5},{"$f":"11-L14","v":6}]
[null,null,"Organizational management",{"$f":"IFERROR(IF(SUM('Audit Checklist'!E26:E29)/(3*(COUNTA('Audit Checklist'!A26:A29)-COUNTIF('Audit Checklist'!E26:E29,\"NA\")))=0,0,SUM('Audit Checklist'!E26:E29)/(3*(COUNTA('Audit Checklist'!A26:A29)-COUNTIF('Audit Checklist'!E26:E29,\"NA\")))),\"NA\")","v":0.83333333333333337},{"$f":"COUNTIF('Audit Checklist'!$F$26:$F$29,\"ShowStopper\")","v":0},{"$f":"COUNTIF('Audit Checklist'!$F$26:$F$29,\"Major\")","v":0},{"$f":"COUNTIF('Audit Checklist'!$F$26:$F$29,\"Minor\")","v":0},{"$f":"COUNTIF('Audit Checklist'!$F$26:$F$29,\"Observation\")","v":1},{"$f":"COUNTIF('Audit Checklist'!$F$26:$F$29,\"Meet Requirement\")","v":0},{"$f":"COUNTIF('Audit Checklist'!$F$26:$F$29,\"Best Practice\")","v":0},{"$f":"COUNTIF('Audit Checklist'!$F$26:$F$29,\"N/A\")","v":0},{"$f":"SUM(E15:K15)","v":1},{"$f":"4-L15","v":3}]
[null,null,"Supply Chain",{"$f":"IFERROR(IF(SUM('Audit Checklist'!E33:E49)/(3*(COUNTA('Audit Checklist'!A33:A49)-COUNTIF('Audit Checklist'!E33:E49,\"NA\")))=0,0,SUM('Audit Checklist'!E33:E49)/(3*(COUNTA('Audit Checklist'!A33:A49)-COUNTIF('Audit Checklist'!E33:E49,\"NA\")))),\"NA\")","v":0.82352941176470584},{"$f":"COUNTIF('Audit Checklist'!$F$33:$F$49,\"ShowStopper\")","v":0},{"$f":"COUNTIF('Audit Checklist'!$F$33:$F$49,\"Major\")","v":0},{"$f":"COUNTIF('Audit Checklist'!$F$33:$F$49,\"Minor\")","v":0},{"$f":"COUNTIF('Audit Checklist'!$F$33:$F$49,\"Observation\")","v":0},{"$f":"COUNTIF('Audit Checklist'!$F$33:$F$49,\"Meet Requirement\")","v":0},{"$f":"COUNTIF('Audit Checklist'!$F$33:$F$49,\"Best Practice\")","v":1},{"$f":"COUNTIF('Audit Checklist'!$F$33:$F$49,\"N/A\")","v":0},1,{"$f":"17-L16","v":16}]
[null,null,"Pre-production & development",{"$f":"IFERROR(IF(SUM('Audit Checklist'!E53:E66)/(3*(COUNTA('Audit Checklist'!A53:A66)-COUNTIF('Audit Checklist'!E53:E66,\"NA\")))=0,\"NA\",SUM('Audit Checklist'!E53:E66)/(3*(COUNTA('Audit Checklist'!A53:A66)-COUNTIF('Audit Checklist'!E53:E66,\"NA\")))),\"NA\")","v":"NA"},{"$f":"COUNTIF('Audit Checklist'!$F$53:$F$66,\"ShowStopper\")","v":0},{"$f":"COUNTIF('Audit Checklist'!$F$53:$F$66,\"Major\")","v":0},{"$f":"COUNTIF('Audit Checklist'!$F$53:$F$66,\"Minor\")","v":0},{"$f":"COUNTIF('Audit Checklist'!$F$53:$F$66,\"Observation\")","v":0},{"$f":"COUNTIF('Audit Checklist'!$F$53:$F$66,\"Meet Requirement\")","v":0},{"$f":"COUNTIF('Audit Checklist'!$F$53:$F$66,\"Best Practice\")","v":0},{"$f":"COUNTIF('Audit Checklist'!$F$53:$F$66,\"N/A\")","v":0},0,{"$f":"14-L17","v":14}]
[null,null,"Production",{"$f":"IFERROR(IF(SUM('Audit Checklist'!E70:E90)/(3*(COUNTA('Audit Checklist'!A70:A90)-COUNTIF('Audit Checklist'!E70:E90,\"NA\")))=0,0,SUM('Audit Checklist'!E70:E90)/(3*(COUNTA('Audit Checklist'!A70:A90)-COUNTIF('Audit Checklist'!E70:E90,\"NA\")))),\"NA\")","v":0.82352941176470584},{"$f":"COUNTIF('Audit Checklist'!$F$70:$F$90,\"ShowStopper\")","v":0},{"$f":"COUNTIF('Audit Checklist'!$F$70:$F$90,\"Major\")","v":0},{"$f":"COUNTIF('Audit Checklist'!$F$70:$F$90,\"Minor\")","v":0},{"$f":"COUNTIF('Audit Checklist'!$F$70:$F$90,\"Observation\")","v":1},{"$f":"COUNTIF('Audit Checklist'!$F$70:$F$90,\"Meet Requirement\")","v":0},{"$f":"COUNTIF('Audit Checklist'!$F$70:$F$90,\"Best Practice\")","v":1},{"$f":"COUNTIF('Audit Checklist'!$F$70:$F$90,\"N/A\")","v":0},2,{"$f":"21-L18","v":19}]
[null,null,"Quality System",{"$f":"IFERROR(IF(SUM('Audit Checklist'!E94:E115)/(3*(COUNTA('Audit Checklist'!A94:A115)-COUNTIF('Audit Checklist'!E94:E115,\"NA\")))=0,0,SUM('Audit Checklist'!E94:E115)/(3*(COUNTA('Audit Checklist'!A94:A115)-COUNTIF('Audit Checklist'!E94:E115,\"NA\")))),\"NA\")","v":0.79365079365079361},{"$f":"COUNTIF('Audit Checklist'!$F$94:$F$115,\"ShowStopper\")","v":0},{"$f":"COUNTIF('Audit Checklist'!$F$94:$F$115,\"Major\")","v":0},{"$f":"COUNTIF('Audit Checklist'!$F$94:$F$115,\"Minor\")","v":0},{"$f":"COUNTIF('Audit Checklist'!$F$94:$F$115,\"Observation\")","v":0},{"$f":"COUNTIF('Audit Checklist'!$F$94:$F$115,\"Meet Requirement\")","v":0},{"$f":"COUNTIF('Audit Checklist'!$F$94:$F$115,\"Best Practice\")","v":3},{"$f":"COUNTIF('Audit Checklist'!$F$94:$F$115,\"N/A\")","v":0},3,{"$f":"22-L19","v":19}]
[null,null,"Total",{"$f":"IF(SUMPRODUCT(D14:D19,D31:D36)=0,\"NA\",SUMPRODUCT(D14:D19,F31:F36))","v":0.82447107630931149},{"$f":"SUM(E14:E19)","v":0},{"$f":"SUM(F14:F19)","v":0},{"$f":"SUM(G14:G19)","v":3},3,1,{"$f":"SUM(J14:J19)","v":5},{"$f":"SUM(K14:K19)","v":0},{"$f":"SUM(L14:L19)","v":12},{"$f":"SUM(M14:M19)","v":77}]
[null,null,null,{"$f":"+IF(L20<89,\"EVALUATION INCOMPLETE!\",\"EVALUATION COMPLETE\")","v":"EVALUATION INCOMPLETE!"}]
[null,null,null,null,null,null,0.15]
[null,null,null,"Audit score ","Show Stopper","Major","Minor","OVERALL CONCLUSION"]
[null,null,"Target","80 - 100%",0,0,0,"SEE EVALUATION MATRIX"]
[null,null,"Actual after audit",{"$f":"+D20","v":0.82447107630931149},{"$f":"+IF(E20>0,\"Yes\",\"No\")","v":"No"},{"$f":"+IF(F20>0,\"Yes\",\"No\")","v":"No"},"Yes"]
[null,null,"Conclusion NEW VENDOR",{"$f":"+IF(D25<80%,\"FAILED\",IF(D25=\"NA\",\"FAILED\",\"PASSED\"))","v":"PASSED"},{"$f":"+IF(E20>0,\"FAILED\",\"OK\")","v":"OK"},{"$f":"+IF(F20>0,\"FAILED\",\"OK\")","v":"OK"},{"$f":"+IF(G20>0,\"COND. PASSED\",\"OK\")","v":"COND. PASSED"},{"$f":"IF(OR(E$26=\"FAILED\"),\"FAILED\",IF(OR(D$26=\"FAILED\",F$26=\"FAILED\"),\"FAILED\",IF(OR(G26=\"COND. PASSED\"),\"CONDITIONALLY PASSED\",\"PASSED\")))","v":"CONDITIONALLY PASSED"}]
[null,null,"Conclusion EXITING VENDOR",{"$f":"+IF(D25<80%,\"COND. PASSED\",IF(D25=\"NA\",\"FAILED\",\"PASSED\"))","v":"PASSED"},{"$f":"+IF(E20>0,\"FAILED\",\"OK\")","v":"OK"},{"$f":"+IF(F20>0,\"COND. PASSED\",\"OK\")","v":"OK"},{"$f":"+IF(G20>89,\"COND. PASSED\",\"OK\")","v":"OK"},{"$f":"IF(OR(E$27=\"FAILED\"),\"FAILED\",IF(OR(D27=\"FAILED\"),\"FAILED\",IF(OR(D27=\"COND. PASSED\",F27=\"COND. PASSED\",G27=\"COND. PASSED\"),\"CONDITIONALLY PASSED\",\"PASSED\")))","v":"PASSED"}]
[]
[null,null,"topic","WEIGHT (DO NOT CHANGE)"]
[null,null,null,null,null,"new weight"]
[null,null,"Compliance",0.25,{"$f":"IF(D14=\"NA\",0,D31/$D$37)","v":0.25},{"$f":"E31/$E$37","v":0.3125}]
[null,null,"Organizational management",0.05,{"$f":"IF(D15=\"NA\",0,D32/$D$37)","v":0.05},{"$f":"E32/$E$37","v":6.25E-2}]
[null,null,"Supply Chain",0.1,0.1,0.125]
[null,null,"Pre-production & development",0.2,0,0]
[null,null,"Production",0.2,0.2,0.25]
[null,null,"Quality System",0.2,0.2,0.25]
[null,null,"Total",{"$f":"SUM(D31:D36)","v":1},{"$f":"SUM(E31:E36)","v":0.8},{"$f":"SUM(F31:F36)","v":1}]

{"sheet":"List of supportive documents","index":5,"n_rows":52,"n_cols":3,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
["Section","Question","Supporting Document "]
["Compliance","1.1","Permits and monitoring performed for air emissions, water disposal, and waste disposal. "]
["Compliance",1.2,"Documents of medical surveillance program and metrics (redact any employee names and personal information)"]
["Compliance",1.6,"Permits, if applicable, for local Fire agencies.   Evidence of fire installation maintenance.  Evidence of last fire drills"]
["Compliance","1.10","Provide reports from system used to manage Compliancy of Conflict Minerals / Reach / RoHS & ABB list of restricted and prohibits substances"]
["Compliance","1.11","Material safety data sheets (in local language)."]
[]
["Organization","2.2","Certificates regarding ISO 9.001, ISO 14.001, ISO 45.001 or others management systems"]
["Organization","2.3","Skill matrix by operator, training documents used, and training plan for operators"]
["Organization","2.6","Management meeting reports which includes General Risk Analysis items and actions"]
[]
["Supply Chain","3.1","Internal change management procedure which includes requirement to notify your Customers about changes in process or products.  "]
["Supply Chain","3.2","Evidence of communication to suppliers to require notification of changes in process or products for approval."]
["Supply Chain","3.4","Provide Material Management Flow Chart and example reports of raw material, WIP, and FG inventory, as well as overdues"]
["Supply Chain","3.7","Provide documentation showing traceability of raw material thru FG."]
["Supply Chain","3.11","Present current and last year performance evaluation of Sub-Suppliers "]
["Supply Chain","3.16","Sub-Suppliers audit process and records, and tracking of findings corrective actions"]
[]
["Pre-Production","4.1","Examples of Quality files for products developed / under development: drawings, specification, gauges, PPAP content"]
["Pre-Production","4.2","New Product Introduction (NPI) written procedure and sample documentation of approvals at each gate"]
["Pre-Production","4.3","FMEA example"]
["Pre-Production","4.4","List of your equipment and facilities available for testing"]
["Pre-Production","4.5","Example of Test procedures & test reports, along with calibration and certification of associated equipment"]
["Pre-Production","4.7","Example of process capability study for key processes and/or product."]
["Pre-Production","4.9","Tooling and/or Equipment qualification records"]
["Pre-Production","4.10","PPAP records of product, as well as PPAP records of sub-tier components as appropriate"]
["Pre-Production","4.12","If applicable, 3rd party agency certificates (such as UL, etc.)"]
[]
["Production","5.1","Capacity analysis and KPI Measurements such as TAKT, FPY, and OEE of production lines or areas"]
["Production","5.4","Bottlenecks in production analysis & plans to address "]
["Production","5.7 - 5.9","Provide reports from Maintenance PM System, including verification of TPM activities"]
["Production","5.10","Provide report or file with Estimation of the tool life, and inclusion in Maintanance PM System"]
["Production","5.12","Reworking process and procedures"]
["Production","5.13","Formal start-up procedure, including Process flow diagram"]
["Production","5.14","Quality gate or approval documentation before a lot is transferred to the next stage"]
["Production","5.17","Demonstrate Inventory System, and show procedure and documented evidences of actual inventory verfication to inventory system"]
["Production","5.18","Demonstrate control of validity dates for perishable items"]
["Production","5.19","Internal change management procedure and evidence of production modification process approvals"]
["Production","5.24","Provide examples of Work Instructions to review template content (such as revision, approvals, etc.) and evidence of internal audits  "]
[null," "]
["Quality System","6.1","Provide Continuous improvement projects ongoing with owner, status, timing"]
["Quality System","6.2","Provide examples of monitoring process effectiveness and implementing changes for improvement"]
["Quality System","6.3","Sample minutes of meeting from governance meetings to manage the Quality issues"]
["Quality System","6.4","Show documents of Internal and External Audits, and tracking of findings corrective actions."]
["Quality System","6.5 - 6.7","Present procedures, system, and examples for processing of claims, RCA/CAPA, generated by both external customer claims & internally"]
["Quality System","6.11","Demonstrate Problem Solving process with examples"]
["Quality System","6.13","Provide IQC flow chart and procedure, and IQC records"]
["Quality System","6.14","Provide examples of Quality Control Plans "]
["Quality System","6.15","Provide examples of Process Control Plans "]
["Quality System","6.18-6.19","Provide example of Capability Study and ongoing control for part and/or process CTQ"]
["Quality System","6.20 - 6.22","Provide Calibration procedure and reports from calibration system, such as records of testing and measurement equipment, and reports avaialble"]

{"sheet":"Revision Tracking","index":6,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Revision","Approved by","Date","Revision note","Author"]
[null,1,"Supplier Quality Team","2020-03-18","Score ranges changed, deleted \"yellow area\" from 79% to 60%.","Alessandro Pasinetti"]
[null,2,"Supplier Quality Team","2020-03-26","Added sentence #5.4 ","Alessandro Pasinetti"]
[null,3,"Supplier Quality Team","2020-05-05","Added CAPA Tracking","Attila Tibor"]
[null,4,"Supplier Quality Team","2020-05-28","Adding New and Existing supplier checklist and functions","Attila Tibor"]
[null,5,"Supplier Quality Team","2020-06-16","Added prework tab for new and existing suppliers","Rosaria Veneziano"]
[null,6,"Supplier Quality Team","2020-11-05","Score calculation formula adjusted to be able to handel \"N/A\" sections","Attila Tibor"]
[null,7,"EL Supplier Quality Council","2021-12-01","Full content review and upgrade","Rosaria Veneziano"]
[null,"7.1","EL Supplier Quality Council","2022-01-19","Removed the Portection from the Audit Checklist and made the entire file as read-only","Rosaria Veneziano"]
[null,"2023-07-02","EL Supplier Quality Council","2023-04-18","Bugs fixed","Alessandro Pasinetti / Zsolt Salamon"]