{"text_format":"1","workbook":"xlsx","n_sheets":24,"sheets":["Cover","Instructions","SUPPLIER WIKI ","Scoring_Summary","Draft","A-Basic Info. ","B-Quality Management 1","C-Quality Management 2","D-Quality Management 3","E-Customer Service 1","F-Customer Service 2","G-Human Resources","H-Environmental","I-Health & Safety","J-Regulatory Compliance","Arkusz1","K-Procurement","L-Engineering","M-Distributor","N-Generic, Business","O-Special Process Documentation","P-Other Documents","Q-Contractor","R-Service"],"not_rendered":{"charts":13,"images":2,"macros":1,"external_links":1,"defined_names":75,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":false,"merged":[[35,7,35,8],[37,7,37,8],[34,3,34,5],[34,7,34,8],[36,3,36,5],[36,7,36,8],[38,3,38,5],[38,7,38,8],[1,2,1,6],[2,2,2,6],[3,2,3,6],[1,7,1,8],[2,7,3,8],[31,7,31,8],[22,1,25,8],[18,0,18,8],[27,1,27,8],[26,1,26,8],[31,1,31,2],[28,1,29,8],[35,3,35,5],[37,3,37,5]]}
[]
["EnerSys ",null,"GLOBAL QUALITY MANAGEMENT SYSTEM",null,null,null,null,"PROPIETARY DOCUMENT"]
["DOCUMENT NUMBER:",null,"QMS-GFORM-004",null,null,null,null,"REVISION: AD                       SUPERCEDES: AC             CHANGE NO: ECO 1002439"]
["DOCUMENT TITLE:",null,"SUPPLIER RISK ASSESSMENT QUESTIONNARIE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["EnerSys Supplier/Contractor Evaluation"]
[]
[]
[]
[null,"Our Vision at EnerSys is to provide extraordinary CUSTOMER service by meeting or exceeding our CUSTOMERS’ expectations 100% of the time.  We shall be the best in the industry by being easy to do business with, while supplying the highest Quality products and services on-time and in the most cost-effective manner. We will do this in a culture that demonstrates respect for our CUSTOMERS, our fellow associates, our suppliers and our community while focusing on maximizing shareholder value."]
[]
[]
[]
[]
[null,"As a potential or current supplier to EnerSys, we request that you complete the attached survey and return it to EnerSys Attn: Quality Assurance.  The completion of this survey does not create any binding agreement between our companies.  The intent is to gather information in order to evaluate the management, manufacturing, quality, and material capabilities of your organization.  This survey will be used as a self-assessment and EnerSys assessment during the supplier selection stage. "]
[null,"Note: The intention of this survey is for it to be completed electronically. Your rating per category will automatically be calculated on the tab labeled Scoring_Summary and your  score will be reflected on the other half of the same sheet . Once complete, the survey should be e-mailed to the Quality Assurance Department of EnerSys (see Instructions sheet)."]
[]
[]
[]
[]
[]
["Revision ","Release","By","Description of change",null,null,"Change NO.","Commited Change"]
["AA","2018-09-26","J.Gaspari","Initial Release",null,null,"ECO1002004","No"]
["AB","2020-08-31","M. Jarnot","Add sections, and distribute the questions uniformly ",null,null,"ECO1002223","No"]
["AC","2021-10-13","M. Jarnot","Check heading and bottom alignment, printing view",null,null,1002342,"No"]
["AD","2022-06-16","A.Wala","New formulas added, automatization",null,null,1002439,"NO"]

{"sheet":"Instructions","index":1,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[[4,1,5,1]]}
[null,"Instructions for Completing the Supplier Quality Survey"]
[]
[1,"Please complete the form found in Sheet A-Basic Info. (first yellow tab) of this workbook. Provide as much detail as possible."]
[]
[2,"Based on the various topics and statements listed in sheets A through R, in the boxes provided, rate your company.\nNote, all answers should be numeric and should not exceed the maximum allowable rating for any specific statement. Maximum scores are listed to the right of each answer box."]
[]
[3,"As you complete the survey, the graphs on the sheet labeled Scoring_Summary  will automatically update."]
[4,"Please select the Type of Supplier in the Scoring_Summary sheet. The categories that are valid for the given type of Supplier will be highlighted in yellow. Complete all visible yellow sheets. The sheets that the Supplier does not need to complete will be white."]
[5,"Once completed, please email the form and any corroborating information to requester."]
[6,"If you have any questions or comments regarding the survey, please feel free to contact requester."]
[7,"Please supply the documents in tab N."]
[8,"Please supply copies of all documents that apply in tab O."]
[9,"Please supply copies of all documents that apply in tab P."]
[10,"If you are MANUFACTURER complete all the tabs."]
[11,"If you are CONTRACTOR complete tabs H, I, J & Q."]
[12,"If you are SERVICE Supplier (like calibration, test) complete tabs H, I, J & R."]
[13,"If you are DISTRIBUTOR (Off the shelf parts...) complete tabs H, I, J &  M."]
[]
[null,"Evaluation grid:"]
[null,"0 - Not implemented"]
[null,"0,5 - Partially implemented"]
[null,"1 - Fully implemented"]
[]
[]
[null,"Thank You For Taking the Time to "]
[null,"Complete This Document."]

{"sheet":"SUPPLIER WIKI ","index":2,"n_rows":42,"n_cols":3,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["Section ","Acronym","Description "]
["A","H&S","Health & Safety "]
["A,H,P","ISO","International Organization for Standardization"]
["A,N","TL","Telecom Quality Management system"]
["A,P","C-TPAT","Customs-Trade Partnership Against Terrorism "]
["A","SVI","Status Verification Interface."]
["B,J","ROHS","Restriction of Hazardous Substances Directive"]
["B,J","REACH","Registration, Evaluation, Authorization and Restriction of Chemicals is a European Union regulation"]
["C","KPI","Key Performance indicators"]
["D","DFMEA","Design Failure modes and effects analysis"]
["D","PFMEA","Process Failure modes and effects analysis"]
["D","QMS","Quality Management System"]
["D","Cp","Process capability index"]
["D","Cpk","Process capability index"]
["D","SPC","Statistical process control"]
["E","RMA","Return Merchandise Authorization"]
["F","EDI","Electronic Data Interchange "]
["H","EMS","Environmental Management System"]
["H","EMAS","Engineered Material Arresting System"]
["I","OSHA","Occupational Safety and Health Administration"]
["I","RIDDOR","Reporting of Injuries, Diseases and Dangerous Occurrences Regulations"]
["K","MRP","Material Requirement Planning"]
["K","OTD","On-time Delivery "]
["K","WIP","Work In Progress"]
["K","ASL","Approved Supplier List "]
["K","EHS","Environment, Health, and Safety"]
["M, Q, R","COSHH","Control of Substances Hazardous to Health Regulations 2002"]
["M, Q, R","PPE","Personal protective equipment"]
["N","PM","preventive maintenance"]
["M","FIFO ","First In First Out"]
["M","EEFO ","Earliest Expiry First Out "]
["N ","IATF","International Automotive Task Force"]
["N","UL","Underwriters Laboratories"]
["N","AS ","Aerospace"]
["O","CQI","Continuous Quality Improvement"]
["P","SAP","Systems, Applications & Products in Data Processing"]
["P","FMEA","Failure modes and effects analysis"]
["P","MSA","Measurement system analysis"]
["P","APQP","Advanced product quality planning"]
["P","PPAP","Production Part Approval Process"]
["P","DV","Design Validation"]
["P","PV","Process Validation"]

{"sheet":"Scoring_Summary","index":3,"n_rows":78,"n_cols":26,"rows_kept":78,"cut":false,"hidden":false,"merged":[[78,19,78,22],[47,12,47,15],[48,12,48,15],[49,12,49,15],[52,11,52,13],[53,12,53,15],[54,12,54,15],[57,11,57,13],[58,12,58,14],[46,11,46,13],[66,11,66,13],[18,12,18,14],[24,12,24,15],[27,11,27,13],[28,12,28,14],[32,11,32,13],[33,12,33,14],[41,11,41,13],[38,12,38,14],[37,11,37,13],[0,10,0,23],[4,11,4,13],[5,12,5,14],[6,12,6,13],[7,12,7,13],[2,10,2,23],[8,12,8,14],[14,11,14,13],[15,12,15,14],[16,12,16,14],[17,12,17,14],[9,12,9,14],[10,12,10,14],[11,12,11,15],[25,0,25,5],[2,7,2,9],[18,0,18,5],[4,2,4,8],[15,0,15,5],[5,2,5,8],[13,0,13,5],[17,0,17,5],[11,0,11,5],[6,7,6,9],[16,0,16,5],[12,0,12,5],[2,0,2,1],[2,2,2,5],[3,0,3,1],[0,3,0,9],[1,8,1,9],[24,0,24,5],[7,2,7,5],[7,7,7,9],[1,0,1,7],[3,2,3,8],[6,0,6,1],[6,2,6,5],[9,6,10,6],[9,7,10,7],[9,8,10,8],[9,9,10,9],[14,0,14,5],[9,0,10,5]]}
[null,null,null,"Supplier/Contractor Scoring Summary",null,null,null,null,null,null,"Approved → 80% - 100%\nConditional Approved → 60% - 79%\nNot - Approved → <59%"]
["Type of Supplier:",null,null,null,null,null,null,null,"MANUFACTURER",null,"After selecting the supplier type, complete required categories in the yellow sheets below↓"]
["Supplier Name: ",null,{"$f":"'A-Basic Info. '!C3","v":0},null,null,null,"Date: ",{"$f":"'A-Basic Info. '!H9","v":"00:00:00"},null,null,"Supplier Score by Category"]
[null,null,{"$f":"'A-Basic Info. '!C4","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"manufacturer"]
[null,null,{"$f":"'A-Basic Info. '!C5","v":0},null,null,null,null,null,null,null,1,"Quality Management",null,null,null,null,"Score","Max",null,null,null,null,null,null,null,"MANUFACTURER"]
[null,null,{"$f":"'A-Basic Info. '!C6","v":0},null,null,null,null,null,null,null,null,null,"1) Quality Management System",null,null,null,{"$f":"'B-Quality Management 1'!G4","v":0},{"$f":"'B-Quality Management 1'!I4","v":5},null,null,null,null,null,null,null,"CONTRACTOR"]
["Participant: ",null,{"$f":"'A-Basic Info. '!C9","v":0},null,null,null,"E-mail: ",{"$f":"'A-Basic Info. '!H10","v":0},null,null,null,null,"2) Leadership",null,null,null,{"$f":"'B-Quality Management 1'!G21","v":0},{"$f":"'B-Quality Management 1'!I21","v":6},null,null,null,null,null,null,null,"SERVICE SUPPLIER"]
[null,null,{"$f":"'A-Basic Info. '!C10","v":0},null,null,null,null,null,null,null,null,null,"3) Planning",null,null,null,{"$f":"'C-Quality Management 2'!G4","v":0},{"$f":"'C-Quality Management 2'!I4","v":3},null,null,null,null,null,null,null,"DISTRIBUTOR"]
[null,null,null,null,null,null,null,null,null,null,null,null,"4) Resources",null,null,null,{"$f":"'C-Quality Management 2'!G15","v":0},{"$f":"'C-Quality Management 2'!I15","v":8}]
["Category",null,null,null,null,null,"Max Score","Earned Score",null,null,null,null,"5) Operations",null,null,null,{"$f":"'D-Quality Management 3'!G4","v":0},{"$f":"'D-Quality Management 3'!I4","v":12}]
[null,null,null,null,null,null,null,null,null,null,null,null,"6) Performance Evaluation",null,null,null,{"$f":"'D-Quality Management 3'!G40","v":0},{"$f":"'D-Quality Management 3'!I40","v":4}]
["1  Quality Management (BCD)",null,null,null,null,null,{"$f":"R13","v":41},{"$f":"Q13","v":0},null,null,null,null,"7) Statistical Process Control",null,null,null,{"$f":"'D-Quality Management 3'!G56","v":0},{"$f":"'D-Quality Management 3'!I56","v":3}]
["2  Customer Service (EF)",null,null,null,null,null,{"$f":"R21","v":10},{"$f":"Q21","v":0},null,null,null,null,null,null,null,"Total",{"$f":"SUM(Q6:Q12)","v":0},{"$f":"SUM(R6:R12)","v":41}]
["3  Human Resources (G)",null,null,null,null,null,{"$f":"R30","v":7},{"$f":"Q30","v":0}]
["4 Environmental (H)",null,null,null,null,null,{"$f":"R35","v":11},{"$f":"Q35","v":0},null,null,2,"Customer Service",null,null,null,null,"Score","Max"]
["5 Health & Safety (I)",null,null,null,null,null,{"$f":"R40","v":14},{"$f":"Q40","v":0},null,null,null,null,"1) Customer Service",null,null,null,{"$f":"'E-Customer Service 1'!G4","v":0},{"$f":"'E-Customer Service 1'!I4","v":4}]
["6 Regulatory Compliance (J)",null,null,null,null,null,{"$f":"R45","v":8},{"$f":"Q45","v":0},null,null,null,null,"2) Quality Support ",null,null,null,{"$f":"'E-Customer Service 1'!G15","v":0},{"$f":"'E-Customer Service 1'!I15","v":1}]
["7 Procurement (K)",null,null,null,null,null,{"$f":"R51","v":18},{"$f":"Q51","v":0},null,null,null,null,"3) Technical Support",null,null,null,{"$f":"'E-Customer Service 1'!G20","v":0},{"$f":"'E-Customer Service 1'!I20","v":2}]
["8 Engineering (L)",null,null,null,null,null,{"$f":"R56","v":9},{"$f":"Q56","v":0},null,null,null,null,"4) Delivery",null,null,null,{"$f":"'F-Customer Service 2'!G4","v":0},{"$f":"'F-Customer Service 2'!I4","v":1}]
["9 Distributor (M)",null,null,null,null,null,{"$f":"R60","v":18},{"$f":"Q60","v":0},null,null,null,null,"5) Customer Support System",null,null,null,{"$f":"'F-Customer Service 2'!G9","v":0},{"$f":"'F-Customer Service 2'!I9","v":2}]
["10 Generic & Business Requirements (N)",null,null,null,null,null,{"$f":"R66","v":14},{"$f":"Q66","v":0},null,null,null,null,null,null,null,"Total",{"$f":"Q16+Q17+Q18+Q19+Q20","v":0},{"$f":"SUM(R16:R20)","v":10}]
["11 Contractor (Q)",null,null,null,null,null,{"$f":"R71","v":12},{"$f":"Q71","v":0}]
["12 Service  (R)",null,null,null,null,null,{"$f":"R75","v":13},{"$f":"Q75","v":0}]
[null,null,null,null,null,null,null,null,"Total Max","Total Score"]
["Total ",null,null,null,null,null,null,null,{"$f":"IF(I2=\"CONTRACTOR\",SUM(G15:G17)+G22,IF(I2=\"MANUFACTURER\",SUM(G12:G19)+G21,IF(I2=\"DISTRIBUTOR\",SUM(G15:G17)+G20,IF(I2=\"SERVICE SUPPLIER\",SUM(G15:G17)+G23,\"Aga\"))))","v":132},{"$f":"IF(I2=\"CONTRACTOR\",SUM(H15:H17)+H22,IF(I2=\"MANUFACTURER\",SUM(H12:H19)+H21,IF(I2=\"DISTRIBUTOR\",SUM(H15:H17)+H20,IF(I2=\"SERVICE SUPPLIER\",SUM(H15:H17)+H23,\"Aga\"))))","v":0}]
["Total %",null,null,null,null,null,null,null,1,{"$f":"IF(I2=\"CONTRACTOR\",(SUM(H15:H17)+H22)/45,IF(I2=\"MANUFACTURER\",(SUM(H12:H19)+H21)/132,IF(I2=\"DISTRIBUTOR\",(SUM(H15:H17)+H20)/51,IF(I2=\"SERVICE SUPPLIER\",(SUM(H15:H17)+H23)/46,\"Aga\"))))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,3,"Human Resources",null,null,null,null,"Score","Max"]
[null,null,null,null,null,null,null,null,null,null,null,null,"1) General",null,null,null,{"$f":"'G-Human Resources'!G4","v":0},{"$f":"'G-Human Resources'!I4","v":7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(Q29:Q29)","v":0},{"$f":"SUM(R29:R29)","v":7}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,4,"Environmental",null,null,null,null,"Score","Max"]
[null,null,null,null,null,null,null,null,null,null,null,null,"1) Environmental",null,null,null,{"$f":"'H-Environmental'!G4","v":0},{"$f":"'H-Environmental'!I4","v":11}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(Q34:Q34)","v":0},{"$f":"SUM(R34:R34)","v":11}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,5,"Health & Safety",null,null,null,null,"Score","Max"]
[null,null,null,null,null,null,null,null,null,null,null,null,"1) Health & Safety",null,null,null,{"$f":"'I-Health & Safety'!G4","v":0},{"$f":"'I-Health & Safety'!I4","v":14}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(Q39:Q39)","v":0},{"$f":"SUM(R39:R39)","v":14}]
[null,null,null,null,null,null,null,{"$f":"Cover!H$32","v":0}]
[null,null,null,null,null,null,null,null,null,null,6,"Regulatory Compliance",null,null,null,null,"Score","Max"]
[null,null,null,null,null,null,null,null,null,null,null,null,"1)REACH & ROHS",null,null,null,{"$f":"'J-Regulatory Compliance'!G4","v":0},{"$f":"'J-Regulatory Compliance'!I4","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,"2)Anti-slavery & Human Trafficking",null,null,null,{"$f":"'J-Regulatory Compliance'!G25","v":0},{"$f":"'J-Regulatory Compliance'!I25","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(Q43:Q44)","v":0},{"$f":"SUM(R43:R44)","v":8}]
[]
[null,null,null,null,null,null,null,null,null,null,7,"Procurement",null,null,null,null,"Score","Max"]
[null,null,null,null,null,null,null,null,null,null,null,null,"1) Material Management",null,null,null,{"$f":"'K-Procurement'!G4","v":0},{"$f":"'K-Procurement'!I4","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,"2) Sub-Supplier Management",null,null,null,{"$f":"'K-Procurement'!G13","v":0},{"$f":"'K-Procurement'!I13","v":11}]
[null,null,null,null,null,null,null,null,null,null,null,null,"3) Communication",null,null,null,{"$f":"'K-Procurement'!G43","v":0},{"$f":"'K-Procurement'!I43","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(Q48:Q50)","v":0},{"$f":"SUM(R48:R50)","v":18}]
[]
[null,null,null,null,null,null,null,null,null,null,8,"Engineering",null,null,null,null,"Score","Max"]
[null,null,null,null,null,null,null,null,null,null,null,null,"1) Tooling",null,null,null,{"$f":"'L-Engineering'!G4","v":0},{"$f":"'L-Engineering'!I4","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,"2) Engineering/Manufacturing",null,null,null,{"$f":"'L-Engineering'!G14","v":0},{"$f":"'L-Engineering'!I14","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(Q54:Q55)","v":0},{"$f":"SUM(R54:R55)","v":9}]
[]
[null,null,null,null,null,null,null,null,null,null,9,"Distributor",null,null,null,null,"Score","Max"]
[null,null,null,null,null,null,null,null,null,null,null,null,"1) Your Company",null,null,null,{"$f":"'M-Distributor'!G4","v":0},{"$f":"'M-Distributor'!I4","v":18}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(Q59:Q59)","v":0},{"$f":"SUM(R59:R59)","v":18}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,10,"Generic & Business Requirements",null,null,null,null,"Score","Max"]
[null,null,null,null,null,null,null,null,null,null,null,null,"1) Generic Requirements",null,null,null,{"$f":"'N-Generic, Business'!D5","v":0},{"$f":"'N-Generic, Business'!F5","v":7}]
[null,null,null,null,null,null,null,null,null,null,null,null,"2) Specific Business Requirements",null,null,null,{"$f":"'N-Generic, Business'!D22","v":0},{"$f":"'N-Generic, Business'!F22","v":7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(Q64:Q65)","v":0},{"$f":"SUM(R64:R65)","v":14}]
[]
[null,null,null,null,null,null,null,null,null,null,11,"Contractor",null,null,null,null,"Score","Max"]
[null,null,null,null,null,null,null,null,null,null,null,null,"1) Working with Hazardous Materials",null,null,null,{"$f":"'Q-Contractor'!G4","v":0},{"$f":"'Q-Contractor'!I4","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,"2) General",null,null,null,{"$f":"'Q-Contractor'!G22","v":0},{"$f":"'Q-Contractor'!I22","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(Q69:Q70)","v":0},{"$f":"SUM(R69:R70)","v":12}]
[null,null,null,null,null,null,null,null,null,null,12,"Service",null,null,null,null,"Score","Max"]
[null,null,null,null,null,null,null,null,null,null,null,null,"1) Working with Hazardous Materials",null,null,null,{"$f":"'R-Service'!G4","v":0},{"$f":"'R-Service'!I4","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,"2) General",null,null,null,{"$f":"'R-Service'!G22","v":0},{"$f":"'R-Service'!I22","v":7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(Q73:Q74)","v":0},{"$f":"SUM(R73:R74)","v":13}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overall Scoring:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(Q13+Q21+Q30+Q35+Q40+Q45+Q51+Q56+Q60+Q66+Q71+Q75)/(R13+R21+R30+R35+R40+R45+R51+R60+R56+R66+R71+R75)","v":0}]

{"sheet":"Draft","index":4,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
[null,"choose"]
[null,0,null,0,0]
[null,0.5,null,1,1]
[null,1,null,null,"N/A"]

{"sheet":"A-Basic Info. ","index":5,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[26,6,26,9],[29,2,29,4],[31,2,31,4],[24,7,24,9],[27,1,28,9],[29,5,29,9],[30,5,30,9],[31,5,31,9],[25,6,25,9],[25,4,25,5],[26,4,26,5],[30,2,30,4],[69,7,69,9],[32,2,32,4],[34,1,34,4],[42,1,46,9],[38,1,38,4],[55,6,55,9],[36,1,36,4],[32,5,32,9],[33,5,33,9],[34,5,34,9],[36,5,36,9],[38,5,38,9],[61,7,61,9],[33,2,33,4],[39,1,39,4],[0,1,1,9],[3,2,3,9],[5,2,5,9],[10,2,10,5],[6,2,6,9],[4,2,4,9],[7,2,7,9],[9,2,9,5],[9,7,9,9],[10,7,10,9],[18,7,18,9],[13,2,13,5],[16,7,16,9],[17,2,17,5],[16,2,16,5],[15,2,15,5],[15,7,15,9],[13,7,13,9],[14,2,14,5],[14,7,14,9],[19,1,20,9],[2,2,2,9],[21,6,21,9],[22,6,22,9],[23,6,23,9],[8,2,8,5],[11,2,11,5],[8,7,8,9],[11,7,11,9],[12,7,12,9],[12,2,12,5],[21,4,21,5],[22,4,22,5],[23,4,23,5],[18,2,18,5],[17,7,17,9]]}
[null,"EnerSys Supplier/Contractor Quality Evaluation"]
[]
[null,"Supplier Name:"]
[null,"Address 1:"]
[null,"Address 2:"]
[null,"City, Post Code:"]
[null,"Product(s):"]
[null,"Website:"]
[null,"Completed By:",null,null,null,null,"Date:"]
[null,"Title:",null,null,null,null,"E-mail:"]
[null,"Telephone:",null,null,null,null,"Ext."]
[null,"Quality Manager:",null,null,null,null,"E-mail:"]
[null,"Telephone:",null,null,null,null,"Ext."]
[null,"Environmentally Responsible Manager:",null,null,null,null,"E-mail:"]
[null,"Telephone:",null,null,null,null,"Ext."]
[null,"H&S Responsible Manager:",null,null,null,null,"E-mail:"]
[null,"Telephone:",null,null,null,null,"Ext."]
[null,"Commercial Manager:",null,null,null,null,"E-mail:"]
[null,"Telephone:",null,null,null,null,"Ext."]
[]
[]
[null,"ISO Registration:",null,null,"Registrar:"]
[null,null,null,null,"Certificate Number:"]
[null,null,null,null,"Date of Last Audit:"]
[]
[null,null,null,"SVI","Status Verification #"]
[null,null,null,null,"Explain:"]
[]
[]
[null,"Facility Information:","Plant - sq/mtrs:"]
[null,null,"Number of Employees:"]
[null,null,"Number of QA Employees:"]
[null,null,"Number of Shifts per day:"]
[null,null,"Labor Union:"]
[null,"How long has your company been in operation?"]
[]
[null,"Potential product supplied to EnerSys:"]
[]
[null,"Has this location ever supplied material to EnerSys?"]
[null,"If yes, how long?"]
[]
[null,"Comment:  (please enter below any information that will help to clarify your answers)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"Cover!H$32","v":0}]

{"sheet":"B-Quality Management 1","index":6,"n_rows":44,"n_cols":13,"rows_kept":44,"cut":false,"hidden":false,"merged":[[27,13,27,19],[0,0,0,10],[1,0,1,3],[3,1,3,3],[5,2,5,8],[7,2,8,8],[11,2,11,8],[43,7,43,10],[14,2,14,8],[17,2,19,8],[20,1,20,2],[22,2,22,8],[25,2,26,8],[28,2,29,8],[31,2,32,8],[34,2,35,8],[37,2,38,8],[41,5,41,6]]}
["Evaluation Work Sheet: Supplier Assessment"]
["Quality Management",null,null,null,null,null,null,null,null,null,null,null,"Comments/Remarks"]
[]
["1)","Quality Management System",null,null,null,"Score ",{"$f":"SUM(J6,J9,J12,J15,J18)","v":0},"out of ",{"$f":"SUM(K6:K18)","v":5},null,"Max"]
[]
[null,null,"A) Organization have a quality management system",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"B) Does the organization monitor and review external and internal issues"]
[null,null,null,null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"C) Are the relevant requirements of the interested parties identified",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"D) Are the inputs, outputs and key KPI's been defined in each process",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"E) Does the company have a document control system",null,null,null,null,null,null,0,1,"→"]
[]
[]
["2)","Leadership",null,null,null,"Score",{"$f":"J23+J26+J29+J32+J35+J38","v":0},"out of ",{"$f":"SUM(K23:K38)","v":6},null,"Max"]
[]
[null,null,"A) Do you have a quality policy and quality objectives established",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"B) Top management involved in engaging, directing and supporting quality management system",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"C) Management reviewed the risks and opportunities that can affect the conformity of the products",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"D) Top management involved in engaging, directing and supporting quality management system",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"E) Is the Quality policy communicated and available to all employees",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"F) Are responsibilities and authorities for relevant roles assigned, communicated and understood",null,null,null,null,null,null,0,1,"→"]
[]
[]
[]
[null,null,null,null,null,"Overall Score:  ",null,{"$f":"SUM(J6,J9,J12,J15,J18,J23,J26,J29,J32,J35,J38)/(I4+I21)","v":0}]
[]
[null,null,null,null,null,null,null,{"$f":"[1]Cover!H32","v":0}]

{"sheet":"C-Quality Management 2","index":7,"n_rows":44,"n_cols":13,"rows_kept":44,"cut":false,"hidden":false,"merged":[[30,2,30,8],[0,0,0,10],[3,1,3,2],[5,2,6,8],[8,2,9,8],[11,2,12,8],[14,1,14,2],[16,2,17,8],[19,2,21,8],[23,2,24,8],[26,2,27,8],[29,2,29,8],[32,2,33,8],[35,2,36,8],[38,2,39,8],[41,5,41,6],[43,7,43,10]]}
["Evaluation Work Sheet: Supplier Assessment"]
["Quality Management",null,null,null,null,null,null,null,null,null,null,null,"Comments/Remarks"]
[]
["3)","Planning",null,null,null,"Score ",{"$f":"J6+J9+J12","v":0},"out of ",{"$f":"SUM(K6:K13)","v":3},null,"Max"]
[]
[null,null,"A) Are the risks and opportunities addressed in the Quality management system",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"B) Does the organization maintain documented information on the quality objectives",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"C) Are the quality management system and objectives carried out in a planned manner",null,null,null,null,null,null,0,1,"→"]
[]
[]
["4)","Resources",null,null,null,"Score",{"$f":"J17+J20+J24+J27+J30+J33+J36+J39","v":0},"out of ",{"$f":"SUM(K17:K39)","v":8},null,"Max"]
[]
[null,null,"A) Does the organization support continual improvement of the quality management system.",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"B) Does the organization have suitable infrastructure necessary for the operation of it processes and to achieve conformity of products and services. i.e. buildings and associated utilities, equipment, including hardware and software",null,null,null,null,null,null,0,1,"→"]
[]
[]
[]
[null,null,"C) Does the organization retain appropriate documented information as evidence of monitoring and measurement resources.",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"D) Does the organization maintain traceability for validity of the measurement results for product and services provided.",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"E) Does the organization maintain traceability of calibration on the equipment used.",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"F) Does the origination verify traceability of the material used.",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"G) Does the organization have training programs for all employees.",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"H) Does the organization have document control system.",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,null,null,null,"Overall Score:  ",null,{"$f":"SUM(J6,J9,J12,J17,J20,J24,J27,J30,J33,J36,J39)/(I4+I15)","v":0}]
[]
[null,null,null,null,null,null,null,{"$f":"[1]Cover!H32","v":0}]

{"sheet":"D-Quality Management 3","index":8,"n_rows":68,"n_cols":13,"rows_kept":68,"cut":false,"hidden":false,"merged":[[10,2,11,8],[0,0,0,10],[1,0,1,3],[3,1,3,2],[5,2,6,8],[8,2,8,8],[44,2,45,8],[13,2,13,8],[15,2,16,8],[18,2,19,8],[21,2,22,8],[24,2,25,8],[27,2,28,8],[30,2,31,8],[33,2,34,8],[36,2,37,8],[39,1,39,3],[41,2,42,8],[62,2,62,8],[65,5,65,6],[67,7,67,10],[47,2,48,8],[50,2,51,8],[55,1,55,4],[57,2,57,8],[59,2,60,8],[61,2,61,8]]}
["Evaluation Work Sheet: Supplier Assessment"]
["Quality Management",null,null,null,null,null,null,null,null,null,null,null,"Comments/Remarks"]
[]
["5)","Operation",null,null,null,"Score ",{"$f":"J6+J9+J11+J14+J16+J19+J22+J25+J28+J31+J34+J37","v":0},"out of ",{"$f":"SUM(K6:K37)","v":12},null,"Max"]
[]
[null,null,"A) Does the organization determine the reequipments, criteria, resources needed to achieve conformity for the products and services.",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"B) Does the organization use DFMEA and PFMEA to determine risk mitigation.",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"C) Does the organization use control plans to ensure the conformity of products and services",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"D) Does the organization have a change review and customer notification process.",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"E) Does the organization define and control applicable statutory, regulatory and customer requirements",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"F) Does the organization review the requirements for products and services before committing to Customer.",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"G) Does the organization have a change management process to document the changes for the products and services.",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"H) Does the organization have design capabilities.",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"I) Does the organization use externally provided processes, products and services. ",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"J) Does the organization have the proper controls in place for the  release of product and services. ",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"K) Does the organization have a documented process implemented for corrective/preventive actions. Root cause analysis used to eliminate nonconformances and effectiveness verified.",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"L) Does the organization have preventative and predictive maintenance program. ",null,null,null,null,null,null,0,1,"→"]
[]
[]
["6)","Performance Evaluation",null,null,null,"Score",{"$f":"J42+J45+J48+J51","v":0},"out of ",{"$f":"SUM(K42:K51)","v":4},null,"Max"]
[]
[null,null,"A) Does the organization monitor, measure, analyze and evaluate their process based on customer scorecards.",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"B) Does the organization have certified internal auditors",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"C) Does the organization have internal audit program established.",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"D) Continual improvement evaluated for the QMS using audit results, analysis of data, corrective & preventive action.",null,null,null,null,null,null,0,1,"→"]
[]
[]
[]
[]
["7)","Statistical Process Control (SPC)",null,null,null,"Score",{"$f":"J58+J60+J63","v":0},"out of ",{"$f":"SUM(K58:K63)","v":3},null,"Max"]
[]
[null,null,"A) Effective use of a variety of statistical techniques (control charts, Cp/Cpk, etc.…).",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"B) Is the capability of critical processes measured and monitored with Cpk's > 1.33 and targeted at 1.67.",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"C) Is quality data collected and analyzed \"real time\".",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,null,null,null,"Overall Score:  ",null,{"$f":"SUM(J6,J9,J11,J14,J16,J19,J22,J25,J28,J31,J34,J37,J42,J45,J48,J51,J58,J60,J63)/(I4+I40+I56)","v":0}]
[]
[null,null,null,null,null,null,null,{"$f":"[1]Cover!H$32","v":0}]

{"sheet":"E-Customer Service 1","index":9,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[[29,7,29,10],[27,5,27,6],[24,2,24,8],[19,1,19,2],[21,2,21,8],[23,2,23,8],[14,1,14,2],[16,2,16,8],[0,0,0,10],[5,2,5,8],[8,2,8,8],[10,2,10,8],[3,1,3,2],[1,0,1,2],[6,2,6,8],[12,2,12,8]]}
["Evaluation Work Sheet: Supplier Assessment"]
["Customer Service",null,null,null,null,null,null,null,null,null,null,null,"Comments/Remarks"]
[]
["1)","Customer Service ",null,null,null,"Score ",{"$f":"J6+J9+J11+J13","v":0},"out of ",{"$f":"SUM(K5:K13)","v":4},null,"Max"]
[]
[null,null,"A) Is customer support guaranteed? ",null,null,null,null,null,null,0,1,"→"]
[null,null,"If answer is \"1\" please explain how. Include customer service hours."]
[]
[null,null,"B) Are there routine customer surveys/feedback to measure customer satisfaction? ",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"C) Do you have a system in place to track customer response time?",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"D) Do you have a system in place to track customer complaints? ",null,null,null,null,null,null,0,1,"→"]
[]
["2)","Quality Support",null,null,null,"Score",{"$f":"J17","v":0},"out of ",{"$f":"SUM(K16:K18)","v":1},null,"Max"]
[]
[null,null,"A) Do you have a process in place to return non conformance material? (RMA) ",null,null,null,null,null,null,0,1,"→"]
[]
[]
["3)","Technical Support",null,null,null,"Score",{"$f":"J22+J24","v":0},"out of ",{"$f":"SUM(K21:K26)","v":2},null,"Max"]
[]
[null,null,"A) Installation manual and drawing available (if applicable).",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"B) On-line technical support service available. (if applicable).",null,null,null,null,null,null,0,1,"→"]
[]
[]
[]
[null,null,null,null,null,"Overall Score:  ",null,{"$f":"SUM(J6,J9,J11,J13,J17,J22,J24)/(I4+I15+I20)","v":0}]
[]
[null,null,null,null,null,null,null,{"$f":"Cover!H$32","v":0}]

{"sheet":"F-Customer Service 2","index":10,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,10],[8,1,8,3],[9,2,9,8],[5,2,5,8],[1,0,1,2],[14,2,14,8],[18,2,18,8],[22,7,22,10],[20,5,20,6],[11,2,12,8]]}
["Evaluation Work Sheet: Supplier Assessment"]
["Customer Service",null,null,null,null,null,null,null,null,null,null,null,"Comments/Remarks"]
[]
["4)","Delivery",null,null,null,"Score ",{"$f":"J6","v":0},"out of ",{"$f":"SUM(K5:K7)","v":1},null,"Max"]
[]
[null,null,"A) Do you have? a system to acknowledge Purchase Orders? i.e. Electronic Data Interchange (EDI)",null,null,null,null,null,null,0,1,"→"]
[]
[]
["5)","Customer Support Systems",null,null,null,"Score",{"$f":"J12+J15","v":0},"out of ",{"$f":"SUM(K10:K40)","v":2},null,"Max"]
[]
[]
[null,null,"A) Do you have a process to notify your customers if a delivery date changes or it will not be met per the request date? ",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"B) Do you have a system/process in place to notify your customers about lead times.",null,null,null,null,null,null,0,1,"→"]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Overall Score:  ",null,{"$f":"(G4+G9)/(I4+I9)","v":0}]
[]
[null,null,null,null,null,null,null,{"$f":"Cover!H$32","v":0}]

{"sheet":"G-Human Resources","index":11,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[[15,2,15,8],[22,7,22,10],[20,5,20,6],[16,2,16,8],[18,2,18,8],[17,2,17,8],[0,0,0,10],[1,0,1,1],[9,2,10,8],[13,2,13,8],[11,2,11,8],[5,2,5,8],[7,2,7,8]]}
["Evaluation Work Sheet: Supplier Assessment"]
["Human Resources",null,null,null,null,null,null,null,null,null,null,null,"Comments/Remarks"]
[]
["1)","General",null,null,null,"Score ",{"$f":"J6+J8+J10+J12+J14+J16+J18","v":0},"out of ",{"$f":"SUM(K5:K25)","v":7},null,"Max"]
[]
[null,null,"A) Are job descriptions developed specifying required competence? ",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"B) Does a comprehensive employee training program exist?",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"C) Is there an evaluation of the effectiveness of training?",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"D) Do that Mission Statement defined and communicated?",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"E) Do you have established metrics for labor turnover and absenteeism?",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"F) Is employee qualification/certification records maintained? ",null,null,null,null,null,null,0,1,"→"]
[]
[null," ","G) Operator Certification Program (special processes i.e. welding).",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,null,null,null,"Overall Score:  ",null,{"$f":"SUM(J6,J8,J10,J12,J14,J16,J18)/I4","v":0}]
[]
[null,null,null,null,null,null,null,{"$f":"Cover!H$32","v":0}]

{"sheet":"H-Environmental","index":12,"n_rows":38,"n_cols":31,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,10],[5,2,5,8],[8,2,8,8],[11,2,11,8],[12,2,12,8],[9,2,9,8],[1,0,1,2],[26,2,26,8],[31,2,31,8],[6,2,6,8],[15,2,15,8],[35,5,35,6],[28,2,29,8],[24,2,24,8],[33,2,33,8],[14,2,14,8],[17,2,17,8],[23,2,23,8],[20,2,20,8],[21,2,21,8],[18,2,18,8]]}
["Evaluation Work Sheet: Supplier Assessment"]
["Environmental",null,null,null,null,null,null,null,null,null,null,null,"Comments/Remarks"]
[]
["1)","Environmental",null,null,null,"Score ",{"$f":"J6+J9+J12+J15+J18+J21+J24+J27+J29+J32+J34","v":0},"out of ",{"$f":"SUM(K6:K34)","v":11},null,"Max",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,5]
[]
[null,null,"A) Does the facility have an Environmental Management System (EMS) in place? E.g. ISO14001 or EMAS.",null,null,null,null,null,null,0,1,"→",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J6","v":0}]
[null,null,"(If yes, please provide a copy of your up to date accreditation certificate)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J6>AD4,AE4,0)","v":0}]
[]
[null,null,"B) Does the Company have an environmental and/or sustainability policy? ",null,null,null,null,null,null,0,1,"→",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J9","v":0}]
[null,null,"(If yes, please provide a copy.)"]
[]
[null,null,"C) Do you set environmental and/or sustainability objectives  and targets to improve performance?",null,null,null,null,null,null,0,1,"→",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J12","v":0}]
[null,null,"For example waste and energy reduction or using less materials."]
[]
[null,null,"D) Does the Company have a corrective and preventative action procedure in place to deal with environmental issues?",null,null,null,null,null,null,0,1,"→",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J15","v":0}]
[null,null,"For example spills."]
[]
[null,null,"E) Do you communicate and train employees in relevant environmental issues?",null,null,null,null,null,null,0,1,"→",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J18","v":0}]
[null,null,"For example waste segregation and energy or water saving."]
[]
[null,null,"F) Does your business require monitoring of emissions & discharges to air, sewer and water?  ",null,null,null,null,null,null,0,1,"→",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J21","v":0}]
[null,null,"(Regulators and what permits, licenses and consents are in place? Please put information in comments box on Page A.)"]
[]
[null,null,"G) Has the Company ever had any breaches, fines, criminal or civil prosecutions related to environmental issues?",null,null,null,null,null,null,0,1,"→",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J24","v":0}]
[null,null,"(If no 1 point, if yes 0.  Please provide a short description in comments box on Page A.)"]
[]
[null,null,"H) Do you have an emergency response plan in place for Environmental Issues? E.g. Spills or unplanned discharges.",null,null,null,null,null,null,0,1,"→",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J27","v":0}]
[]
[null,null,"I) Does the company consider sustainability and try to reduce its Carbon Footprint, and greenhouse gas emissions?            \nFor example keeping transport movements to a minimum, reducing material use or turning off lights.",null,null,null,null,null,null,0,1,"→",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J29","v":0}]
[]
[]
[null,null,"J) Does the Company consider the environmental impact of the business from cradle to grave - life cycle analysis ?",null,null,null,null,null,null,0,1,"→",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J32","v":0}]
[]
[null,null,"K) Does your Environment policies and rules included on your training program?",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,null,null,null,"Overall Score:  ",null,{"$f":"SUM(J6,J9,J12,J15,J18,J21,J24,J27,J29,J32,J34)/(I4)","v":0}]
[]
[null,null,null,null,null,null,null,{"$f":"Cover!H$32","v":0}]

{"sheet":"I-Health & Safety","index":13,"n_rows":48,"n_cols":13,"rows_kept":48,"cut":false,"hidden":false,"merged":[[25,2,26,8],[0,0,0,10],[1,0,1,2],[5,2,5,8],[7,2,7,8],[10,2,10,8],[8,2,8,8],[11,2,11,8],[19,2,19,8],[23,2,23,8],[18,2,18,8],[21,2,22,8],[13,2,13,8],[15,2,16,8],[47,7,47,10],[29,2,30,8],[27,2,27,8],[32,2,33,8],[37,2,38,8],[45,5,45,6],[35,2,36,8],[42,2,43,8],[40,2,40,8]]}
["Evaluation Work Sheet: Supplier Assessment"]
["Health & Safety",null,null,null,null,null,null,null,null,null,null,null,"Comments/Remarks"]
[null,null,null,null,null,null,null,null,null,null,"Max"]
["1)","Health & Safety",null,null,null,"Score ",{"$f":"J6+J8+J11+J14+J16+J19+J22+J26+J30+J33+J36+J38+J41+J43","v":0},"out of ",{"$f":"SUM(K6:K43)","v":14}]
[]
[null,null,"A) Does the facility have a Health & Safety management system in place? ",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"B) Is this certified?",null,null,null,null,null,null,0,1,"→"]
[null,null,"     (Please provide a copy)"]
[]
[null,null,"C) Do you have a Health & Safety policy? ",null,null,null,null,null,null,0,1,"→"]
[null,null,"     (Please provide a copy)"]
[]
[null,null,"D) Do you set Health & Safety  objectives  and targets to improve performance?",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"E) Does the Company have a corrective and preventative action procedure in place to deal with Health & Safety issues?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"F) Has the facility operated without serious injury in the last year?",null,null,null,null,null,null,0,1,"→"]
[null,null,"(If yes 1 point, if no 0. Please provide any information in comments box on Page A.)"]
[]
[null,null,"G) Has the facility operated in the last three years without any incidents generally reported under RIDDOR/ OSHA?",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"(If yes 1 point, if no 0. Please provide any information in comments box on Page A.)"]
[]
[null,null,"H) Has the Company ever had any breaches, fines, criminal or civil prosecutions related to Health & Safety issues?",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"(If no 1 point, if yes 0. Please provide a short description in comments box on Page A.)"]
[]
[null,null,"I) Does the facility have procedures in place to ensure appropriate machinery is well-maintained and equipped with necessary safety devices?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"J) Does the company have an emergency response plan for dealing with accidents / incidents including the provision of first aiders and first aid materials?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"K) Does your company comply with OSHA standards ? Please provide certification.",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"L) Do you have emergency exits clearly identified and there is an evacuation response plan in place?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"M) Are Safety Audits conducted?  Records, actions from findings",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"N) Does your Health & Safety policies, procedures and rules included on your training program?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,null,null,null,"Overall Score:  ",null,{"$f":"SUM(J6,J8,J11,J14,J16,J19,J22,J26,J30,J33,J36,J38,J41,J43)/(I4)","v":0}]
[]
[null,null,null,null,null,null,null,{"$f":"Cover!H$32","v":0}]

{"sheet":"J-Regulatory Compliance","index":14,"n_rows":42,"n_cols":13,"rows_kept":42,"cut":false,"hidden":false,"merged":[[33,2,36,8],[7,2,7,8],[30,2,31,8],[16,2,17,8],[10,2,10,8],[14,2,14,8],[28,2,28,8],[41,7,41,10],[0,0,0,10],[1,0,1,10],[26,2,26,8],[39,5,39,6],[19,2,21,8],[6,2,6,8],[5,2,5,8],[9,2,9,8],[13,2,13,8],[11,2,11,8],[22,2,22,8],[18,2,18,8]]}
["Evaluation Work Sheet: Supplier Assessment"]
["Regulatory Compliance",null,null,null,null,null,null,null,null,null,null,null,"Comments/Remarks"]
[]
["1)","REACH & ROHS",null,null,null,"Score ",{"$f":"J6+J10+J14+J17","v":0},"out of",{"$f":"SUM(K5:K17)","v":4},null,"Max"]
[]
[null,null,"A) Is your company REACH compliant?",null,null,null,null,null,null,0,1,"→"]
[null,null,"(If yes, 1 point, if no 0.)"]
[null,null,"(If yes, please provide a copy of certification.)"]
[]
[null,null,"B) Is your company ROHS compliant?",null,null,null,null,null,null,0,1,"→"]
[null,null,"(If yes, 1 point, if no 0.)"]
[null,null,"(If yes, please provide a copy of certification.)"]
[]
[null,null,"C) Are you aware of the Dodd-Frank Act Section 1502 Conflict Minerals?",null,null,null,null,null,null,0,1,"→"]
[null,null,"(If yes, 1 point, if no 0.)"]
[]
[null,null,"D) Does any of the product, supplied to EnerSys by your company, contain the following minerals (Tantalum, Tin, Gold and Tungsten)?",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"(If yes, 0 point, If no, 1 )"]
[null,null,"(If yes, please follow the link below to complete the Conflict Mineral Reporting Template.  Completed forms are to returned via email to your procurement and supplier quality contact)"]
[]
[]
[null,null,"http://www.responsiblemineralsinitiative.org/conflict-minerals-reporting-template/?"]
[]
["2)","Anti-slavery & Human Trafficking",null,null,null,"Score",{"$f":"J27+J29+J31+J34","v":0},"out of",{"$f":"SUM(K27:K34)","v":4},null,"Max"]
[]
[null,null,"A) Does your company comply with anti-slavery and human trafficking laws?",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"B)  Does your company prohibit slavery and child labor?",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"C) Do you verify or confirm that slavery and child labor are not present in your own supply chain?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"D) Does the company/ factory implement the social accountability standard or procedure to comply with local, national and all other applicable law?                                     (For example: forced or compulsory labor, policy against the discrimination within the workplace, comply with the local working hours regulations, etc.)",null,null,null,null,null,null,0,1,"→"]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Overall Score:  ",null,{"$f":"SUM(J6,J10,J14,J17,J27,J29,J31,J34)/(I4+I25)","v":0}]
[]
[null,null,null,null,null,null,null,{"$f":"Cover!H32","v":0}]

{"sheet":"Arkusz1","index":15,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":true,"merged":[[2,5,2,6],[7,5,7,6]]}
[]
[null,"answer",null,"answers"]
[null,"yes",null,"yes"]
[null,"no",null,"no"]
[null,null,null,"unknown"]
[]
[]
[]
[null,"information"]
[null,"Yes, 100% "]
[null,"No, but greater than 75%"]
[null,"No, but greater than 50%"]
[null,"No, but greater than 25%"]
[null,"No, but less than 25%"]
[null,"None"]

{"sheet":"K-Procurement","index":16,"n_rows":59,"n_cols":13,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,1,2],[5,2,5,8],[7,2,8,8],[3,1,3,3],[10,2,10,8],[27,2,27,8],[42,1,42,4],[14,2,14,8],[18,2,19,8],[16,2,16,8],[12,1,12,3],[24,2,25,8],[36,2,37,8],[21,2,22,8],[33,2,34,8],[33,13,33,19],[39,2,40,8],[29,2,29,8],[31,2,31,8],[56,5,56,6],[48,2,49,8],[54,2,54,8],[51,2,52,8],[44,2,46,8]]}
["Evaluation Work Sheet: Supplier Assessment"]
["Procurement",null,null,null,null,null,null,null,null,null,null,null,"Comments/Remarks"]
[]
["1)","Material Management",null,null,null,"Score ",{"$f":"J6+J8+J11","v":0},"out of ",{"$f":"SUM(K6:K11)","v":3},null,"Max"]
[]
[null,null,"A) Integrated Material Requirement Planning (MRP) system in place.",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"B) Tracking of inventory turns, supplier On-time Delivery (OTD) and supplier defects.",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"C) Does the company track cost reduction projects and work in process (WIP).",null,null,null,null,null,null,0,1,"→"]
[]
["2)","Sub-Supplier Management",null,null,null,"Score",{"$f":"J15+J17+J19+J22+J25+J28+J30+J32+J34+J37+J40","v":0},"out of ",{"$f":"SUM(K15:K40)","v":11}]
[]
[null,null,"A) Does your company have a qualification process and criteria for suppliers? ",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"B) Does your company have a documented Approved Supplier List (ASL)?",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"C) Does your company take any action when a supplier does not meet the qualification criteria ",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"D) Is quality history and EHS performance considered along with price, delivery and service when making source decisions?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"E) Are suppliers /  sub-suppliers expected to conform to requirements and are statistical tools used in sub-supplier control.",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"F) Does your company have a process in place to monitor supplier performance?",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"G) Does your company have incoming inspection process implemented ",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"H) Are incoming goods delivered and stored appropriately? ",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"I) Do you have non-conformance and corrective action process for your supplier's?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"J) Does an effective procured material and services quality improvement program exist including sub-suppliers.",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"K) Does your company's supply chain management process ensure that no product or process changes can be made by your suppliers without your companies consent and your customers approval?",null,null,null,null,null,null,0,1,"→"]
[]
[]
["3)","Communication",null,null,null,"Score",{"$f":"J45+J49+J52+J55","v":0},"out of ",{"$f":"SUM(K45:K55)","v":4},null,"Max"]
[]
[null,null,"A) In the event of a vacancy and/or project/account realignment, does a contingency plan exist to ensure adequate resources are in place for knowledge transfer?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[]
[null,null,"B) Are purchased material requirements adequately specified and communicated to suppliers?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"C) Does the company have appropriate technical communications with it's suppliers?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"D) Is there a contract review to ensure all supplier specifications are met?",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,null,null,null,"Overall Score:  ",null,{"$f":"SUM(J6,J8,J11,J15,J17,J19,J22,J25,J28,J30,J32,J34,J37,J40,J45,J49,J52,J55)/(I4+I13+I43)","v":0}]
[]
[null,null,null,null,null,null,null,{"$f":"Cover!H$32","v":0}]

{"sheet":"L-Engineering","index":17,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[[17,2,18,8],[24,2,25,8],[27,2,28,8],[35,7,35,10],[33,5,33,6],[22,2,22,8],[20,2,21,8],[13,1,13,3],[15,2,15,8],[0,0,0,10],[1,0,1,2],[5,2,5,8],[3,1,3,2],[7,2,8,8],[10,2,11,8]]}
["Evaluation Work Sheet: Supplier Assessment"]
["Engineering",null,null,null,null,null,null,null,null,null,null,null,"Comments/Remarks"]
[]
["1)","Tooling",null,null,null,"Score ",{"$f":"J6+J8+J11","v":0},"out of ",{"$f":"SUM(K6:K11)","v":3},null,"Max"]
[]
[null,null,"A) Does your company have in-house machine shop capabilities?",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"B) Does your company have in-house tool/mold maintenance and repair capabilities?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"C) Does your company have a preventive maintenance program for tooling & manufacturing equipment?",null,null,null,null,null,null,0,1,"→"]
[]
[]
["2)","Engineering/Manufacturing",null,null,null,"Score",{"$f":"J16+J18+J21+J23+J25+J28","v":0},"out of ",{"$f":"SUM(K16:K28)","v":6},null,"Max"]
[]
[null,null,"A) Does your company have design control capabilities?",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"B) Does your company have software capabilities such as AutoCAD, Solidworks, Pro-Engineer etc.?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"D) Does your company have new product development processes implemented?",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"E) Machine and process capability study performed.",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"F) Does your company identified and managed critical spare parts list and equipment?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"G) Does your company have contingency plans are established in the event of a catastrophe and/or supply chain interruption?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Overall Score:  ",null,{"$f":"SUM(J6,J8,J11,J16,J18,J21,J23,J25,J28)/(I4+I14)","v":0}]
[]
[null,null,null,null,null,null,null,{"$f":"Cover!H$32","v":0}]

{"sheet":"M-Distributor","index":18,"n_rows":58,"n_cols":13,"rows_kept":58,"cut":false,"hidden":false,"merged":[[57,5,57,6],[29,2,29,8],[31,2,31,8],[37,2,38,8],[40,2,41,8],[43,2,44,8],[33,2,35,8],[55,2,55,8],[46,2,47,8],[49,2,50,8],[52,2,54,8],[23,2,24,8],[26,2,27,8],[0,0,0,10],[1,0,1,2],[3,1,3,4],[5,2,6,8],[8,2,9,8],[11,2,12,8],[14,2,15,8],[17,2,18,8],[22,2,22,8],[20,2,21,8]]}
["Evaluation Work Sheet: Supplier Assessment"]
["Distributor",null,null,null,null,null,null,null,null,null,null,null,"Comments/Remarks"]
[]
["1)","Your Company",null,null,null,"Score ",{"$f":"J6+J9+J12+J15+J18+J21+J24+J27+J30+J32+J34+J38+J41+J44+J47+J50+J53+J56","v":0},"out of ",{"$f":"SUM(K6:K56)","v":18},null,"Max"]
[]
[null,null,"A) Are premises well constructed and visibly good condition and well ventilated?  Is there an effective pest control program in place?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"B) Has the site implemented security measures to control access of unauthorized persons?  ",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"C) If a heating/air-conditioning system is installed is it compatible with the stored products?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"D)  Is there adequate lighting in the warehouse?  Inspection areas? Is the facility organized and clean?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"E) Are the racking systems in good condition, maintained and protected from vehicle collision?  ",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"F)  Do the current sampling processes ensure sufficient protection of product quality?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"G) When sampling is performed, are sampling areas arranged and procedures in place to prevent contamination and cross-contamination?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"H)  Are sampling procedures sufficient to ensure representative samples for quality control? ",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"I)  Are cleaning procedures in place for sampling areas? ",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"J) Is product reception recorded/documented according to a written procedure? ",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"K) Are there written procedures to prevent contamination in the case that a container has to be opened? In the case that a container has to be opened, is there a quality re-certification and release procedure?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[]
[null,null,"L)  Is each product lot released and re-certified each time it is mixed with another lot?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"M) Are containers stored in dedicated areas with adequate separation from other products in order to prevent errors? Are materials in segregated areas controlled?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"N) Are rejected and recalled materials stored in a defined segregated area? Are they blocked from entering mainstream good product shipments?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"O) Does the company apply FIFO (First In First Out) or EEFO (Earliest Expiry First Out) principles in the warehouse?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"P)  For container loading/shipment is there a check list for final inspection? Order is correct product, quantity and labelled accordingly to the customer?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"Q)  Is the company able to provide full traceability on product origin and are distribution records kept for each shipment? P.Os, shipping docs, order sheets etc.…",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"R) Does the organization maintain traceability of calibration on the equipment used.",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,null,null,null,"Overall Score:  ",null,{"$f":"SUM(J6,J9,J12,J15,J18,J21,J24,J27,J30,J32,J34,J38,J41,J44,J47,J50,J53,J56)/(I4)","v":0}]

{"sheet":"N-Generic, Business","index":19,"n_rows":36,"n_cols":21,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,7],[2,1,2,5],[2,6,3,6]]}
["Summary of the Documents Required\n EnerSys Supplier/Contractor Quality Survey"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0]
[null,"Copies of the following documents should be returned with this spreadsheet. ",null,null,null,null,"Please enter 1 in box if document is attached "]
[null,"Electronic files (jpeg, pdf etc.) or photocopies please"]
[1,"Generic Requirements ","Score ",{"$f":"SUM(G7:G19)","v":0},"out of",{"$f":"COUNTIFS(G7:G19,T2)+COUNTIFS(G7:G19,U2)","v":7}]
[]
["A","Current ISO 9001 certification",null,null,null,null,0]
[null,null,null,null,null,null,null,{"$f":"IF(G8,Scoring_Summary!G12,0)","v":0}]
["B","Current ISO 14001 certification",null,null,null,null,0]
[]
["C","Current ISO 45001 certification",null,null,null,null,0]
[]
["D","Current ISO 50001 certification",null,null,null,null,0]
[]
["E","Current ISO 17025 certification",null,null,null,null,0]
[]
["F","Sustainability Policy/Program",null,null,null,null,0]
[]
["G","C-TPAT Compliant",null,null,null,null,0]
[]
[]
[2,"Specific Bussiness requirements","Score ",{"$f":"SUM(IFERROR(G24+G26+G28+G30+G32+G34+G36,0))","v":0},"out of",{"$f":"COUNTIFS(G24:G36,T2)+COUNTIFS(G24:G36,U2)","v":7}]
[]
["A","Specific UL certification",null,null,null,null,0]
[]
["B","Specific Automotive reguirement IATF 16949",null,null,null,null,0]
[]
["C","Specific Telecommunication requirment TL 9000",null,null,null,null,0]
[]
["D","Specific Rail requirement ISO TS 22163",null,null,null,null,0]
[]
["E","Specific Aero requirement AS EN 9100",null,null,null,null,0]
[]
["F","Specific Military requirements",null,null,null,null,0]
[]
["G","Specific Nuclear requirements",null,null,null,null,0]

{"sheet":"O-Special Process Documentation","index":20,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,4],[2,2,4,2]]}
["Specific Process Requirements"]
[]
[null,"Copies of the following documents should be returned with this spreadsheet. ","Please enter 1 in box if document is attached "]
[null,"Electronic files (jpeg, pdf etc.) or photocopies please"]
[]
[]
[1,"Heat Layered Audit (i.e. CQI-9)",0]
[null,null,null,{"$f":"IF(C8,Scoring_Summary!G12,0)","v":0}]
[2,"Plating System Assessment (i.e. CQI-11)",0]
[]
[3,"Coating System Assessment (i.e. CQI-12)",0]
[]
[4,"Consumer Centric Warranty Process (i.e. CQI-14)",0]
[]
[5,"Welding System Assessment (i.e. CQI-15)",0]
[]
[6,"Soldering System Assessment (i.e. CQI-17)",0]
[]
[7,"Sub-Tier Supplier Management Process Guideline (i.e. CQI-19)",0]
[]
[8,"Molding System Assessment(i.e. CQI-23)",0]
[]
[9,"Casting System Assessment (i.e. CQI-27)",0]
[]
[10,"Traceability Guideline (i.e. CQI-28)",0]

{"sheet":"P-Other Documents","index":21,"n_rows":45,"n_cols":4,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,0,0,4],[8,1,9,1],[2,2,4,2]]}
["Other Documents"]
[]
[null,"Copies of the following documents should be returned with this spreadsheet. ","Please enter 1 in box if document is attached "]
[null,"Electronic files (jpeg, pdf etc.) or photocopies please"]
[]
[]
[1,"Quality Core Tools Implementation (SPC, FMEA, MSA, APQP)",0]
[null,null,null,{"$f":"IF(C8,Scoring_Summary!G12,0)","v":0}]
[2,"Advanced Product Quality Planning (APQP) & Production Part Approval Process (PPAP)",0]
[]
[3,"ERP System (i.e. SAP, Baan, etc)",0]
[]
[4,"Lean manufacturing tools",0]
[]
[5,"DV and PV testing",0]
[]
[5,"Current Health & Safety Policy",0]
[]
[6,"Professional Body accreditation",0]
[]
[7,"Environmental Sustainability Policy",0]
[]
[8,"Examples of non conformance report",0]
[]
[9,"Examples of customer complaint ",0]
[]
[10,"Non - conformance procedure",0]
[]
[11,"Internal audit procedure and example ",0]
[]
[12,"Training plan and training records",0]
[]
[13,"Example of Inspection - Work Instruction - Procedure",0]
[]
[14,"Example of Spare part list ",0]
[]
[15,"Example of Change management ",0]
[]
[16,"Organization chart ",0]
[]
[17,"Policy the record retention",0]
[]
[18,"Corrective / Preventative Action ",0]
[]
[19,"Copy Quality Manual ",0]

{"sheet":"Q-Contractor","index":22,"n_rows":56,"n_cols":13,"rows_kept":56,"cut":false,"hidden":false,"merged":[[41,7,41,10],[0,0,0,10],[1,0,1,2],[8,2,8,8],[13,2,13,8],[3,1,3,4],[28,2,28,8],[10,2,11,8],[15,2,16,8],[18,2,19,8],[26,2,26,8],[36,2,37,8],[20,2,20,8],[34,2,34,8],[23,2,23,8],[32,2,33,8],[5,2,6,8],[30,2,30,8],[24,2,24,8],[21,1,21,4],[39,5,39,6]]}
["Evaluation Work Sheet: Supplier Assessment - Site Responsibility"]
["Contractor",null,null,null,null,null,null,null,null,null,null,null,"Comments/Remarks"]
[]
["1)","Working with Hazardous Materials",null,null,null,"Score ",{"$f":"J6+J9+J11+J14+J16+J19","v":0},"out of ",{"$f":"SUM(K6:K19)","v":6},null,"Max"]
[]
[null,null,"A) Does your company have familiarity at Enersys site layout and precautions required?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"B) Does your company have experience of working with Lead?",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"C) Does your company have experience of working with Acids & Hazardous material?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"D) Does your company have experience with COSHH regulations? ",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"E) Does your company have specialist PPE that is required, will you provide your own?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"F) Does your company control the correct disposal of any waste arising from your work?",null,null,null,null,null,null,0,1,"→"]
[]
[]
["2)","General",null,null,null,"Score ",{"$f":"J24+J27+J29+J31+J33+J37","v":0},"out of ",{"$f":"SUM(K24:K37)","v":6},null,"Max"]
[]
[null,null,"A) Are you a member of a professional Organization?",null,null,null,null,null,null,0,1,"→"]
[null,null,"(if so please supply a copy of your accreditation)"]
[]
[null,null,"B) Does your company provide risk assessments  before starting a contract?",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"C) Does your company provide a Training program for your employees?",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"D) Does your company anticipate the need to use sub-contractors ?",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"E) Does your company have Employers Liability Insurance / workers compensation policy?",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"(if so please supply a copy)"]
[]
[null,null,"F) Does your company have a process in place to manage and calibrate measuring equipment?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,null,null,null,"Overall Score:  ",null,{"$f":"SUM(J6,J9,J11,J14,J16,J19,J24,J27,J29,J31,J33,J37)/(I4+I22)","v":0}]
[]
[null,null,null,null,null,null,null,{"$f":"Cover!H$32","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"→"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"→"]

{"sheet":"R-Service","index":23,"n_rows":45,"n_cols":13,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,7,44,10],[32,2,33,8],[28,2,28,8],[30,2,30,8],[13,2,13,8],[36,2,36,8],[38,2,39,8],[24,2,24,8],[34,2,34,8],[42,5,42,6],[10,2,11,8],[15,2,16,8],[18,2,19,8],[26,2,27,8],[20,2,20,8],[21,1,21,4],[23,2,23,8],[0,0,0,10],[1,0,1,2],[3,1,3,4],[5,2,6,8],[8,2,8,8]]}
["Evaluation Work Sheet: Supplier Assessment -Site Responsibility"]
["SERVICE",null,null,null,null,null,null,null,null,null,null,null,"Comments/Remarks"]
[]
["1)","Working with Hazardous Materials",null,null,null,"Score ",{"$f":"J6+J9+J11+J14+J16+J19","v":0},"out of ",{"$f":"SUM(K6:K19)","v":6},null,"Max"]
[]
[null,null,"A) Does your company have familiarity at Enersys site layout and precautions required?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"B) Does your company have experience of working with Lead?",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"C) Does your company have experience of working with Acids & Hazardous materials?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"D) Does your company have experience with COSHH regulations? ",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"E) Does your company have specialist PPE that is required, will you provide your own?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[null,null,"F) Does your company control the correct disposal of any waste arising from your work?",null,null,null,null,null,null,0,1,"→"]
[]
[]
["2)","General",null,null,null,"Score ",{"$f":"J24+J27+J29+J31+J33+J37+J39","v":0},"out of ",{"$f":"SUM(K24:K39)","v":7},null,"Max"]
[]
[null,null,"A) Are you a member of a professional Organization?",null,null,null,null,null,null,0,1,"→"]
[null,null,"(if so please supply a copy of your accreditation)"]
[]
[null,null,"B) Does your company provide risk assessments  before starting a contract?",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"C) Does your company provide a Training program for your employees?",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"D) Does your company anticipate the need to use sub-contractors ?",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"E) Does your company have Employers Liability Insurance / workers compensation policy?",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"(if so please supply a copy)"]
[]
[null,null,"Does your company have a preventive maintenance (PM) program in place?",null,null,null,null,null,null,0,1,"→"]
[]
[null,null,"I) Does your company have a process in place to manage and calibrate measurement equipment?",null,null,null,null,null,null,0,1,"→"]
[]
[]
[]
[null,null,null,null,null,"Overall Score:  ",null,{"$f":"SUM(J6,J9,J11,J14,J16,J19,J24,J27,J29,J31,J33,J37,J39)/(I4+I22)","v":0}]
[]
[null,null,null,null,null,null,null,{"$f":"Cover!H$32","v":0}]