{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Introduction","Cover","1.00 2.00","3.00 4.00","5.00 6.00","7.00","8.00 9.00 10.00","11.00 (1)","11.00 (2)","12.00 ","Comments","Audit Results"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":3,"defined_names":287,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,6,3,9],[8,2,9,15]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"No: MA-4-042-0917"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"DATE: 09/12/2017"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 1 of 12"]
[]
[]
[]
[null,null,"Wagner Supplier Performance Excellence Evaluation"]

{"sheet":"Cover","index":1,"n_rows":41,"n_cols":20,"rows_kept":41,"cut":false,"hidden":false,"merged":[[2,6,3,9],[31,6,31,13],[30,6,30,13],[29,6,29,13],[39,6,39,13],[34,6,34,13],[40,6,40,13],[37,6,37,13],[38,6,38,13],[35,9,35,13],[36,6,36,13],[34,3,34,5],[37,3,37,5],[38,3,38,5],[39,3,39,5],[40,3,40,5],[36,3,36,5],[32,3,32,5],[33,3,33,5],[32,6,32,13],[33,6,33,13],[10,2,11,14],[28,3,28,5],[27,3,27,5],[26,3,26,5],[25,3,25,5],[28,6,28,13],[27,6,27,13],[26,6,26,13],[25,6,25,13],[31,3,31,5],[30,3,30,5],[29,3,29,5]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Introduction!N3","v":"No: MA-4-042-0917"},null,null,null,null,null,"File Name = Company Name & Survey Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Introduction!N4","v":"DATE: 09/12/2017"},null,null,null,null,null,{"$f":"G26&\" \"&IF(G39=\"\",\"\",TEXT(G39,\"mm-dd-yyyy\"))","v":"MA-4-042-0917 09-29-2017"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 2 of 12"]
[]
[]
[]
[]
[]
[null,null,"Wagner Supplier Performance Excellence Evaluation"]
[]
[null,null,null,null,"1.00 Management "]
[null,null,null,null,"2.00 Communication "]
[null,null,null,null,"3.00 Contract Review/Document Control"]
[null,null,null,null,"4.00 Manufacturing  "]
[null,null,null,null,"5.00 Procurement                    "]
[null,null,null,null,"6.00 Engineering "]
[null,null,null,null,"7.00 Quality"]
[null,null,null,null,"8.00 Product Identification and Traceability        "]
[null,null,null,null,"9.00 Control of Non-conforming Product"]
[null,null,null,null,"10.00 Packaging, Storage, Handling & Shipping"]
[null,null,null,null,"11.00 Wagner - Supplier Partnership Evaluation"]
[null,null,null,null,"12.00 Wagner / Supplier Performance Excellence Planned Actions"]
[]
[null,null,null,"Company Name",null,null,"MA-4-042-0917"]
[null,null,null,"Address"]
[null,null,null,"City"]
[null,null,null,"State / Zip code"]
[null,null,null,"Country"]
[null,null,null,"Telephone"]
[null,null,null,"Fax"]
[null,null,null,"E-Mail"]
[null,null,null,"Supplier Representative"]
[null,null,null,"( Name / Department)"]
[]
[null,null,null,"Survey Completed By"]
[null,null,null,"Department"]
[null,null,null,"Survey Date",null,null,{"$f":"TEXT(NOW(),\"mm-dd-yyyy\")","v":"09-29-2017"}]
[null,null,null,"Wagner Representative"]
[null,null,null,"( Name / Department)"]

{"sheet":"1.00 2.00","index":2,"n_rows":62,"n_cols":18,"rows_kept":62,"cut":false,"hidden":false,"merged":[[39,2,42,2],[34,2,35,2],[2,6,3,13],[45,2,45,17],[46,3,46,14],[10,2,10,17],[18,4,18,14],[19,4,19,14],[20,4,20,14],[21,4,21,14],[16,3,16,14],[17,3,17,14],[11,3,11,14],[22,4,22,14],[34,3,34,14]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Introduction!N3","v":"No: MA-4-042-0917"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Introduction!N4","v":"DATE: 09/12/2017"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 3 of 12"]
[]
[]
[]
[]
[]
[null,null,"1.00 Management"]
[null,null,"Item","Description",null,null,null,null,null,null,null,null,null,null,null,"Max\nScore","Self\nScore","Wagner\nScore"]
[null,null,1.01,"Is the company currently or has previously been a supplier to Wagner?",null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,1.02,"*Is the company certified, by an accredited body, to a quality system standard such as ISO 9001?",null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,1.03,"*Does the company have a formal Organization Chart?",null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,1.04,"*Can your company provide customer and financial references?",null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,1.05,"Who are your main customers and what are their primary products?",null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,"     List customer and product"]
[null,null,null,1]
[null,null,null,2]
[null,null,null,3]
[null,null,null,4]
[null,null,null,5]
[null,null,1.06,"Will the company sign a non-compete agreement?",null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,{"$f":"C24+0.01","v":1.07},"Will the company sign a non-disclosure agreement?",null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,{"$f":"C25+0.01","v":1.08},"Does your company provide Electronics Manufacturing Services (EMS)?",null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,{"$f":"C26+0.01","v":1.0900000000000001},"Does your company follow ISO 26000 Guidance on social responsibility?",null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,1.1000000000000001,"Does your company have JIT, Kanban or Consignment capabilities?",null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,1.1100000000000001,"Does your company have a formal internal/external corrective action system?",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,1.1200000000000001,"Does your company have a formal Safety Program?",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,1.1300000000000001,"Does your company have a formal Cost Reduction Program?",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,1.1400000000000001,"Does your company have a formal Lean Production Operations and Services Program?",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,1.1500000000000001,"What are your company's payment terms?",null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,{"$f":"C33+0.01","v":1.1600000000000001},"Does the company understand UL and regulatory agency approvals?",null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,1.1700000000000002,"Does the company have established performance measures that are regularly ",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,"reported to management?"]
[null,null,{"$f":"C35+0.01","v":1.1800000000000002},"Does the company measure on-time delivery performance to your customers?",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,{"$f":"C37+0.01","v":1.1900000000000002},"Does the company measure quality performance (reject rate) of your customers?",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,1.2000000000000002,"Does the company use these measures to initiate improvement efforts?",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,1.2100000000000002,"Does the company have expertise in the following fields?",null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,"Electrical",null,null,"Mechanical",null,null,"Design",null,null,"Test"]
[null,null,null,"Tooling",null,null,"Quality",null,null,"Fluid/Hydraulic"]
[null,null,null,"Other"]
[null,null,{"$f":"\"Maximum scoring for \"&C11 &\" is \"& P44 &\" points.\"","v":"Maximum scoring for 1.00 Management is 47 points."},null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(P13:P43)","v":47},{"$f":"SUM(Q13:Q43)","v":0},{"$f":"SUM(R13:R43)","v":0}]
[]
[null,null,"2.00 Communication"]
[null,null,"Item","Description",null,null,null,null,null,null,null,null,null,null,null,"Max\nScore","Self\nScore","Wagner\nScore"]
[null,null,2.0099999999999998,"Does your company have Electronic Data Interchange (EDI) capabilities?",null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,{"$f":"C48+0.01","v":2.0199999999999996},"Does the company have File Transfer Protocol site for CAD files?",null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,{"$f":"C49+0.01","v":2.0299999999999994},"Does the company have the ability to electronically communicate. E-mail /Fax etc.",null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,{"$f":"C50+0.01","v":2.0399999999999991},"Is there a formal system in place to notify customers of a process change?",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,2.0499999999999989,"Do all key personnel understand English? Internal/External Communications.",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,{"$f":"\"Maximum scoring for \"&C46&\" is \"& P53 &\" points.\"","v":"Maximum scoring for 2.00 Communication is 9 points."},null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(P48:P52)","v":9},{"$f":"SUM(Q48:Q52)","v":0},{"$f":"SUM(R48:R52)","v":0}]
[]
[null,null,"Item #","Comments (additional comments may be added to Comments page)"]
[null,null,"*","Please provide documentation noted in the Item with the evaluation response"]
[]
[]
[null,null,"Score = 0 There is no formal system in place."]
[null,null,"Score = 1 There is a system in place but it isn’t documented or no evidence available."]
[null,null,"Score = 2 There is a system in place and documented."]
[null,null,"Score = 3 There is a system in place, documented and evidence of conformity exists."]

{"sheet":"3.00 4.00","index":3,"n_rows":60,"n_cols":18,"rows_kept":60,"cut":false,"hidden":false,"merged":[[2,6,3,9],[11,3,11,14],[10,2,10,17],[37,2,38,2],[39,2,40,2],[47,12,47,14],[12,2,13,2],[15,2,16,2],[17,2,18,2],[43,2,44,2],[45,2,46,2],[41,2,42,2],[23,2,28,2],[22,3,22,14],[23,3,23,14],[21,2,21,17],[29,2,30,2]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Introduction!N3","v":"No: MA-4-042-0917"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Introduction!N4","v":"DATE: 09/12/2017"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 4 of 12"]
[]
[]
[]
[]
[]
[null,null,"3.00 Contract Review/Document Control "]
[null,null,"Item","Description",null,null,null,null,null,null,null,null,null,null,null,"Max\nScore","Self\nScore","Wagner\nScore"]
[null,null,3.01,"Are incoming customer purchase orders reviewed for clarity, understanding, including ",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,"specifications and delivery dates?"]
[null,null,{"$f":"C13+0.01","v":3.0199999999999996},"Does the company have a formal documentation control program?",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,{"$f":"C15+0.01","v":3.0299999999999994},"Is there a formal system in place to ensure the correct revision of specifications is used ",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,"on the shop floor?"]
[null,null,{"$f":"C16+0.01","v":3.0399999999999991},"Is there a formal system in place to ensure that obsolete documents are removed from ",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,"all points of use?"]
[null,null,{"$f":"\"Maximum scoring for \"&C11 &\" is \"& P20 &\" points.\"","v":"Maximum scoring for 3.00 Contract Review/Document Control  is 12 points."},null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(P13:P18)","v":12},{"$f":"SUM(Q13:Q18)","v":0},{"$f":"SUM(R13:R18)","v":0}]
[]
[null,null,"4.00 Manufacturing"]
[null,null,"Item","Description",null,null,null,null,null,null,null,null,null,null,null,"Max\nScore","Self\nScore","Wagner\nScore"]
[null,null,4.01,"What Are Your Key Production Processes? (Check all that apply)",null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,"Sheet Metal Fab.",null,null,"Milling",null,null,"Die Cutting",null,null,"Turning"]
[null,null,null,"Grinding",null,null,"Die Casting",null,null,"Plating",null,null,"Painting"]
[null,null,null,"PCB Fabrication",null,null,"PCB Assembly",null,null,"PCB Test",null,null,"Plastic Molding"]
[null,null,null,"Welding",null,null,"Heat Treat",null,null,"Finishing",null,null,"Honing"]
[null,null,null,"Assembly Oper.",null,null,"Other"]
[null,null,{"$f":"C24+0.01","v":4.0199999999999996},"Is there a formal process in place for obtaining customer approval for the start up of ",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,"new jobs or jobs that have been revised, for materials, tooling or process?"]
[null,null,{"$f":"C30+0.01","v":4.0299999999999994},"Does this include First Article Inspection (FAI) results that can be supplied?",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,{"$f":"C32+0.01","v":4.0399999999999991},"Does this include Production Part Approval Process (PPAP) that can be supplied?",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,4.0499999999999989,"Does the company formally utilize control plans?",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,4.0599999999999987,"Is SPC used to control processes and are records readily available to customers?",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,4.0699999999999985,"Has your company identified and validated \"Special\" Processes?",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,4.0799999999999983,"Is there a system in place for operator training?",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,4.0899999999999981,"Is there a formal system in place to ensure operators understand customer requirements",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null," and expectations?"]
[null,null,{"$f":"C38+0.01","v":4.0999999999999979},"Is there a system in place for communicating changes to customer requirements to the ",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,"operators? "]
[null,null,{"$f":"C40+0.01","v":4.1099999999999977},"Do the operators have the tools and equipment necessary to ensure that quality ",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,"requirements are being met?"]
[null,null,{"$f":"C42+0.01","v":4.1199999999999974},"Is there a system in place for developing and distributing work instructions or process",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,"documentation to the shop floor?"]
[null,null,{"$f":"C44+0.01","v":4.1299999999999972},"Is there a preventive maintenance program in place that includes a maintenance schedule ",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,"for production equipment?"]
[null,null,{"$f":"\"Maximum scoring for \"&C22 &\" is \"& P48 &\" points.\"","v":"Maximum scoring for 4.00 Manufacturing is 37 points."},null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(P24:P47)","v":37},{"$f":"SUM(Q24:Q47)","v":0},0]
[]
[null,null,"Item #","Comments (additional comments may be added to Comments page)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Scoring"]
[null,null,"Score = 2 There is a system in place and documented."]
[null,null,"Score = 3 There is a system in place, documented and evidence of conformity exists."]

{"sheet":"5.00 6.00","index":4,"n_rows":62,"n_cols":16,"rows_kept":62,"cut":false,"hidden":false,"merged":[[2,6,3,9],[23,2,29,2],[10,2,10,15],[11,3,11,12],[18,2,18,15],[19,3,19,12],[21,2,22,2]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Introduction!N3","v":"No: MA-4-042-0917"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Introduction!N4","v":"DATE: 09/12/2017"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 5 of 12"]
[]
[]
[]
[]
[]
[null,null,"5.00 Procurement"]
[null,null,"Item","Description",null,null,null,null,null,null,null,null,null,"Max\nScore","Self\nScore","Wagner\nScore"]
[null,null,5.01,"Does the company have a formal supplier evaluation and selection program?",null,null,null,null,null,null,null,null,null,3]
[null,null,{"$f":"C13+0.01","v":5.0199999999999996},"Is there a formal system in place to measure and report on the performance of suppliers?",null,null,null,null,null,null,null,null,null,3]
[null,null,{"$f":"C14+0.01","v":5.0299999999999994},"Is there a foraml system in place to ensure that only conforming product is accepted for use?",null,null,null,null,null,null,null,null,null,3]
[null,null,5.0399999999999991,"Does the supplier have local (US) representation?",null,null,null,null,null,null,null,null,null,3]
[null,null,{"$f":"\"Maximum scoring for \"&C11 &\" is \"& N17 &\" points.\"","v":"Maximum scoring for 5.00 Procurement is 12 points."},null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(N13:N16)","v":12},{"$f":"SUM(O13:O16)","v":0},{"$f":"SUM(P13:P16)","v":0}]
[]
[null,null,"6.00 Engineering"]
[null,null,"Item","Description",null,null,null,null,null,null,null,null,null,"Max\nScore","Self\nScore","Wagner\nScore"]
[null,null,6.01,"Does the company have an engineering staff on the premises?",null,null,null,null,null,null,null,null,null,3]
[null,null,{"$f":"C21+0.01","v":6.02},"Does the company have the ability to electronically transfer engineering documentation?",null,null,null,null,null,null,null,null,null,3]
[null,null,null,"Format?"]
[null,null,{"$f":"C22+0.01","v":6.0299999999999994},"Can the supplier perform following tests? (Check all that apply)",null,null,null,null,null,null,null,null,null,6]
[null,null,null," a. Pre-production Line Performance"]
[null,null,null," b. Has the company the ability to design and build test fixtures?"]
[null,null,null," c. Does the company do Performance testing?"]
[null,null,null," d. Does the company do Life Testing?"]
[null,null,null," e. Does the company do Reliability testing?"]
[null,null,null," f. Does the company do Drop/Packaging testing?"]
[null,null,{"$f":"C24+0.01","v":6.0399999999999991},"Does the company have a formal reporting system to log and report test results?",null,null,null,null,null,null,null,null,null,3]
[null,null,{"$f":"\"Maximum scoring for \"&C19 &\" is \"& N32 &\" points.\"","v":"Maximum scoring for 6.00 Engineering is 15 points."},null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(N21:N31)","v":15},{"$f":"SUM(O21:O31)","v":0},0]
[]
[null,null,"Item #","Comments (additional comments may be added to Comments page)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Score = 0 There is no formal system in place."]
[null,null,"Score = 1 There is a system in place but it isn’t documented or no evidence available."]
[null,null,"Score = 2 There is a system in place and documented."]
[null,null,"Score = 3 There is a system in place, documented and evidence of conformity exists."]

{"sheet":"7.00","index":5,"n_rows":64,"n_cols":16,"rows_kept":64,"cut":false,"hidden":false,"merged":[[2,6,3,9],[33,10,33,12],[11,3,11,12],[10,2,10,15],[24,2,28,2],[29,2,32,2]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Introduction!N3","v":"No: MA-4-042-0917"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Introduction!N4","v":"DATE: 09/12/2017"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 6 of 12"]
[]
[]
[]
[]
[]
[null,null,"7.00 Quality"]
[null,null,"Item","Description",null,null,null,null,null,null,null,null,null,"Max\nScore","Self\nScore","Wagner\nScore"]
[null,null,7.01,"Does the company have an independent quality function?",null,null,null,null,null,null,null,null,null,3]
[null,null,{"$f":"C13+0.01","v":7.02},"Are incoming, in-process and/or final inspection records maintained?",null,null,null,null,null,null,null,null,null,3]
[null,null,{"$f":"C14+0.01","v":7.0299999999999994},"Is product inspected/verified as to conformity prior to moving to the next operation?",null,null,null,null,null,null,null,null,null,3]
[null,null,7.0399999999999991,"Are inspections/verifications  performed per written procedures?",null,null,null,null,null,null,null,null,null,3]
[null,null,7.0499999999999989,"Are specifications available where inspections/verificatons are performed?",null,null,null,null,null,null,null,null,null,3]
[null,null,7.0599999999999987,"Is there a documented calibration system?",null,null,null,null,null,null,null,null,null,3]
[null,null,7.0699999999999985,"Is all inspection & test equipment identified as to calibration status and calibration due date?",null,null,null,null,null,null,null,null,null,3]
[null,null,7.0799999999999983,"Are calibration records maintained?",null,null,null,null,null,null,null,null,null,3]
[null,null,7.0899999999999981,"Are process parameters critical to quality defined?",null,null,null,null,null,null,null,null,null,3]
[null,null,7.0999999999999979,"Does your company measure and report process capability (Cp, Cpk, etc.)?",null,null,null,null,null,null,null,null,null,3]
[null,null,7.1099999999999977,"Does your company measure and report  process yields or defects?",null,null,null,null,null,null,null,null,null,3]
[null,null,7.11,"Does your company investigate and analyze customer returns for internal corrective actions?",null,null,null,null,null,null,null,null,null,3]
[null,null,{"$f":"C24+0.01","v":7.12},"What verification methods are used by your company? (Check all that apply)",null,null,null,null,null,null,null,null,null,1]
[null,null,null,"None",null,null,"Receiving Inspection",null,null,"Inprocess Inspection"]
[null,null,null,"Final Inspection",null,null,"SPC",null,null,"Roving/Random"]
[null,null,null,"Audit",null,null,"1st Article"]
[null,null,null,"Other"]
[null,null,{"$f":"C25+0.01","v":7.13},"What sampling methods are used by your company?  (Check all that apply)",null,null,null,null,null,null,null,null,null,1]
[null,null,null,"100% Insp.",null,null,"AQL Insp.",null,null,"C=0 Insp."]
[null,null,null,"Fixed Sample Size",null,null,"Percent of Lot Size",null,null,"SPC"]
[null,null,null,"Other"]
[null,null,{"$f":"\"Maximum scoring for \"&C11 &\" is \"& N34 &\" points.\"","v":"Maximum scoring for 7.00 Quality is 38 points."},null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(N13:N33)","v":38},{"$f":"SUM(O13:O33)","v":0},{"$f":"SUM(P13:P33)","v":0}]
[]
[null,null,"Item #","Comments (additional comments may be added to Comments page)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Scoring"]
[null,null,"Items with Max Score of 1 are Yes/No.  1 = Yes  0 = No"]
[null,null,"Score = 0 There is no formal system in place."]
[null,null,"Score = 1 There is a system in place but it isn’t documented or no evidence available."]
[null,null,"Score = 2 There is a system in place and documented."]
[null,null,"Score = 3 There is a system in place, documented and evidence of conformity exists."]

{"sheet":"8.00 9.00 10.00","index":6,"n_rows":59,"n_cols":16,"rows_kept":59,"cut":false,"hidden":false,"merged":[[36,3,36,12],[2,6,3,9],[40,2,41,2],[10,2,10,15],[11,3,11,12],[14,2,15,2],[37,2,38,2],[18,2,18,15],[19,3,19,12],[27,3,27,12],[29,3,29,12],[31,3,31,12],[25,2,26,2],[31,2,32,2],[29,2,30,2],[27,2,28,2]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Introduction!N3","v":"No: MA-4-042-0917"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Introduction!N4","v":"DATE: 09/12/2017"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 7 of 10"]
[]
[]
[]
[]
[]
[null,null,"8.00 Product Identification and Traceability "]
[null,null,"Item","Description",null,null,null,null,null,null,null,null,null,"Max\nScore","Self\nScore","Wagner\nScore"]
[null,null,8.01,"Is there a system in place to control customer-supplied product, equipment and gauges?",null,null,null,null,null,null,null,null,null,3]
[null,null,{"$f":"C13+0.01","v":8.02},"Is raw product properly identified and is the disposition readily apparent?",null,null,null,null,null,null,null,null,null,3]
[null,null,{"$f":"C14+0.01","v":8.0299999999999994},"Is product traceable by lot or batch and identifiable through dates or lot numbers",null,null,null,null,null,null,null,null,null,3]
[null,null,null," that remain with the product through shipment to the customer?"]
[null,null,{"$f":"\"Maximum scoring for \"&C11 &\"is \"& N17 &\" points.\"","v":"Maximum scoring for 8.00 Product Identification and Traceability is 9 points."},null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(N13:N16)","v":9},{"$f":"SUM(O13:O16)","v":0},{"$f":"SUM(P13:P16)","v":0}]
[]
[null,null,"9.00 Control of Non-conforming Product "]
[null,null,"Item","Description",null,null,null,null,null,null,null,null,null,"Max\nScore","Self\nScore","Wagner\nScore"]
[null,null,9.01,"Is there a formal system in place to handle non-conforming product?",null,null,null,null,null,null,null,null,null,3]
[null,null,{"$f":"C21+0.01","v":9.02},"Is there a formal system in place to prevent shipment of non-conforming product?",null,null,null,null,null,null,null,null,null,3]
[null,null,9.0299999999999994,"Has responsibility for review and disposition of non-conforming product been defined?",null,null,null,null,null,null,null,null,null,3]
[null,null,{"$f":"C23+0.01","v":9.0399999999999991},"Is non-conforming product properly identified?",null,null,null,null,null,null,null,null,null,3]
[null,null,{"$f":"C24+0.01","v":9.0499999999999989},"Is non-conforming product segregated from conforming product to prevent accidental use?",null,null,null,null,null,null,null,null,null,3]
[null,null,{"$f":"C25+0.01","v":9.0599999999999987},"Is there a formal system in place for purging of suspected non-conforming product from the ",null,null,null,null,null,null,null,null,null,3]
[null,null,null,"shop floor?"]
[null,null,{"$f":"C26+0.01","v":9.0699999999999985},"Is there a formal system in place to ensure that reworked product conforms",null,null,null,null,null,null,null,null,null,3]
[null,null,null," to customer specifications?"]
[null,null,{"$f":"C28+0.01","v":9.0799999999999983},"Is there a formal system in place for initiating corrective/preventive action when non-conforming",null,null,null,null,null,null,null,null,null,3]
[null,null,null,"product is identified?"]
[null,null,{"$f":"C30+0.01","v":9.0899999999999981},"Is there a formal system in place to initiate corrective/preventive action based upon ",null,null,null,null,null,null,null,null,null,3]
[null,null,null,"customer complaints?"]
[null,null,{"$f":"\"Maximum scoring for \"&C19 &\"is \"& N34 &\" points.\"","v":"Maximum scoring for 9.00 Control of Non-conforming Product is 27 points."},null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(N21:N33)","v":27},{"$f":"SUM(O21:O33)","v":0},0]
[]
[null,null,"10.00 Packaging, Storage, Handling & Shipping "]
[null,null,"Item","Description",null,null,null,null,null,null,null,null,null,"Max\nScore","Self\nScore","Wagner\nScore"]
[null,null,10.01,"Do shipping and/or inspection personnel have access to information to assure that customer",null,null,null,null,null,null,null,null,null,3]
[null,null,null," requirements for packaging and labeling are met?"]
[null,null,10.02,"Is material handled/stored in a suitable way to preserve product quality?",null,null,null,null,null,null,null,null,null,3]
[null,null,10.029999999999999,"Is material packaged in a suitable way to prevent product damaged during national/",null,null,null,null,null,null,null,null,null,3]
[null,null,null,"international shipping?"]
[null,null,10.039999999999999,"Does your company have a prefered method of delivery?",null,null,null,null,null,null,null,null,null,1]
[null,null,{"$f":"\"Maximum scoring for \"&C36 &\"is \"& N44 &\" points.\"","v":"Maximum scoring for 10.00 Packaging, Storage, Handling & Shipping is 10 points."},null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(N38:N43)","v":10},{"$f":"SUM(O38:O43)","v":0},0]
[]
[null,null,"Item #","Comments (additional comments may be added to Comments page)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Scoring"]
[null,null,"Items with Max Score of 1 are Yes/No.  1 = Yes  0 = No"]
[null,null,"Score = 0 There is no formal system in place."]
[null,null,"Score = 3 There is a system in place, documented and evidence of conformity exists."]

{"sheet":"11.00 (1)","index":7,"n_rows":60,"n_cols":16,"rows_kept":60,"cut":false,"hidden":false,"merged":[[60,3,60,13],[34,15,34,17],[35,15,35,17],[53,15,53,17],[54,15,54,17],[55,15,55,17],[58,3,58,13],[59,3,59,13],[34,3,34,13],[35,3,35,13],[53,3,53,13],[54,3,54,13],[55,3,55,13],[56,3,56,13],[57,3,57,13],[60,15,60,17],[2,6,3,13],[10,2,10,17],[28,15,28,17],[19,3,19,13],[28,3,28,13],[20,3,20,13],[21,3,21,13],[22,3,22,13],[23,3,23,13],[24,3,24,13],[25,3,25,13],[12,4,12,12],[13,4,13,11],[14,4,14,11],[15,4,15,11],[16,4,16,11],[29,3,29,13],[30,3,30,13],[31,3,31,13],[32,3,32,13],[33,3,33,13],[38,3,38,15],[39,3,39,14],[40,3,40,14],[42,3,42,14],[41,3,41,14],[43,3,43,14],[44,3,44,14],[45,3,45,14],[46,3,46,14],[47,3,47,14],[48,3,48,14],[49,3,49,14],[50,3,50,14],[58,15,58,17],[59,15,59,17],[56,15,56,17],[57,15,57,17],[29,15,29,17],[30,15,30,17],[31,15,31,17],[32,15,32,17],[33,15,33,17]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Introduction!N3","v":"No: MA-4-042-0917"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Introduction!N4","v":"DATE: 09/12/2017"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 8 of 12"]
[]
[]
[]
[]
[]
[null,null,"11.00 Wagner - Supplier Partnership Evaluation"]
[null,null,"11.01","What do you consider your business capabilities? (Check all that apply)"]
[null,null,null,"Type","Description"]
[null,null,null,"I","Build to Print"]
[null,null,null,"II","Develop and Build (OEM)"]
[null,null,null,"III","Develop and Build (Key Component)"]
[null,null,null,"IV","Develop Only"]
[]
[null,null,"11.02","What other customers do you provide these capabilities?"]
[null,null,null,"Customer Name and their primary products",null,null,null,null,null,null,null,null,null,null,"Location"]
[null,null,null,"Customer List is Same as Section 1.05"]
[]
[]
[]
[]
[]
[]
[null,null,"11.03","What Engineering skill sets do you have at your facility, and how many speak English?"]
[null,null,null,"Engineering Skill Set",null,null,null,null,null,null,null,null,null,null,"No. Engineers","Speak English"]
[null,null,null,"Design"]
[null,null,null,"Electrical"]
[null,null,null,"Regulatory Compliance"]
[null,null,null,"Manufacturing"]
[null,null,null,"Quality"]
[null,null,null,"Software"]
[null,null,null,"Reliability"]
[]
[null,null,"11.04","What test and inspection capabilities do you have in your facilities? (Check all that apply)"]
[null,null,null,"Test Type"]
[null,null,null,"Electrical"]
[null,null,null,"Power supply 120V /60 Hz and 230V/50Hz (test & production areas)"]
[null,null,null,"Mechanical"]
[null,null,null,"Life Testing (Accelerated)"]
[null,null,null,"Ongoing Reliability Test (ORT)"]
[null,null,null,"Environmental Conditioning"]
[null,null,null,"Chemical"]
[null,null,null,"Metrology"]
[null,null,null,"Handling (Drop)"]
[null,null,null,"Durability"]
[null,null,null,"Performance (Functional)"]
[null,null,null,"XY table/measurement equipment"]
[]
[null,null,"11.05","What type of technicians do you have to test your products or designs, and how many speak English?"]
[null,null,null,"Technical Skill Set",null,null,null,null,null,null,null,null,null,null,"No. Technicians","Speak English"]
[null,null,null,"Design"]
[null,null,null,"Electrical"]
[null,null,null,"Regulatory Compliance"]
[null,null,null,"Manufacturing"]
[null,null,null,"Reliability"]
[null,null,null,"Inspection (Mechanical)"]

{"sheet":"11.00 (2)","index":8,"n_rows":57,"n_cols":16,"rows_kept":57,"cut":false,"hidden":false,"merged":[[2,6,3,13],[10,2,10,17],[44,7,44,14],[17,3,17,14],[28,3,28,14],[29,3,29,14],[30,3,30,14],[31,3,31,14],[18,3,18,14],[19,3,19,14],[20,3,20,14],[21,3,21,14],[22,3,22,14],[23,3,23,14],[24,3,24,14],[25,3,25,14],[12,3,12,14],[13,3,13,14],[14,3,14,14],[15,3,15,14],[16,3,16,14],[49,3,49,14],[50,3,50,14],[51,3,51,14],[52,3,52,14],[34,3,34,14],[35,3,35,14],[36,3,36,14],[37,3,37,14],[38,3,38,14],[39,3,39,14],[46,3,46,14],[43,3,43,14],[45,3,45,14],[42,3,42,14]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Introduction!N3","v":"No: MA-4-042-0917"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Introduction!N4","v":"DATE: 09/12/2017"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 9 of 12"]
[]
[]
[]
[]
[]
[null,null,"11.00 Wagner - Supplier Partnership Evaluation (cont)"]
[null,null,"11.06","What regulatory agency approvals do you have on your designs? (Check all that apply)"]
[null,null,null,"Underwriters Laboratory (UL)"]
[null,null,null,"European Commission (CE)"]
[null,null,null,"Norma Oficial Mexicana (NOM)"]
[null,null,null,"Edison Testing Laboratories (ETL)"]
[null,null,null,"Scheme of the IECEE for Mutual Recognition of Test Certificates for Elect. Equip. (CB)"]
[null,null,null,"Canadian Standards Association (CSA)"]
[null,null,null,"Energy Star "]
[null,null,null,"Restriction of Hazardous Substances (RoHS)"]
[null,null,null,"Federal Communications Commission (FCC)"]
[null,null,null,"DesignLights™ Consortium (DLC)"]
[null,null,null,"Ingress Protection (IP)"]
[]
[]
[]
[]
[null,null,"11.07","What type of test documentation do you prepare and maintain?"]
[null,null,null,"Detailed/Documented Test Plans"]
[null,null,null,"Detailed/Documented Test Report"]
[]
[]
[]
[null,null,"11.08","What type of CAD system/systems do you use to design products? "]
[null,null,null,"CREO (Mandatory System)"]
[]
[]
[]
[]
[]
[]
[null,null,"11.09","What is your documentation/change management system?"]
[null,null,null,"ISO/TC 171 Document management applications"]
[null,null,null,"ISO 9001"]
[null,null,null,"Industry Standard"]
[null,null,null,"Internally Developed and formalized/documented"]
[null,null,null,"Informal"]
[]
[null,null,"11.10","What is your file backup storage system to protect against loss of data?  "]
[null,null,null,"None"]
[null,null,null,"Onsite Backup"]
[null,null,null,"Onsite Backup and Offsite Backup"]
[null,null,null,"Do you have a disaster recovery plan for data management"]
[]
[null,null,"11.11","Do you have an Intellectual Property program to patent your ideas?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]

{"sheet":"12.00 ","index":9,"n_rows":15,"n_cols":17,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,6,3,9],[10,2,10,16],[12,4,12,15]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Introduction!N3","v":"No: MA-4-042-0917"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Introduction!N4","v":"DATE: 09/12/2017"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 10 of 12"]
[]
[]
[]
[]
[]
[null,null,"12.00 Wagner / Supplier Performance Excellence Planned Actions"]
[]
[null,null,"Item #","W or S","Performance Excellence Planned Action",null,null,null,null,null,null,null,null,null,null,null,"Est. Date"]
[null,null,"All","W","Wagner will provide feedback on performace excellence area(s) of most importanance to relationship success."]
[null,null,null,"S","Supplier will identify and provide planned actions to Planned Actions List."]

{"sheet":"Comments","index":10,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[10,2,10,15],[2,6,3,9]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Introduction!N3","v":"No: MA-4-042-0917"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Introduction!N4","v":"DATE: 09/12/2017"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 11 of 12"]
[]
[]
[]
[]
[]
[null,null,"Comments"]
[]
[null,null,"Item #","Comment"]

{"sheet":"Audit Results","index":11,"n_rows":25,"n_cols":23,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,2,24,9],[10,2,10,14],[12,2,12,9],[2,6,3,9]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Introduction!N3","v":"No: MA-4-042-0917"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Introduction!N4","v":"DATE: 09/12/2017"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Page 12 of 12"]
[]
[]
[]
[]
[]
[null,null,"SYSTEM AUDIT RESULTS"]
[]
[null,null,"Function Area",null,null,null,null,null,null,null,null,"Max \nScore","Supplier\nSelf\nScore","Wagner\nScore",null,null,null,null,"Supplier %","Wagner %","Supplier Self\nScore","Wagner\nScore","Max"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COMPOSITE",{"$f":"IF(U14>0,(U14/W15),0)","v":0},{"$f":"IF(V14>0,(V14/W15),0)","v":0},{"$f":"M25","v":0},{"$f":"N25","v":0}]
[null,null,"1.00 Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,null,null,null,{"$f":"'1.00 2.00'!P44","v":47},{"$f":"'1.00 2.00'!Q44","v":0},{"$f":"'1.00 2.00'!R44","v":0},null,null,null,"Management",0,0,{"$f":"M15","v":0},{"$f":"N15","v":0},{"$f":"L25","v":216}]
[null,null,"2.00 Communication . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,null,null,null,{"$f":"'1.00 2.00'!P53","v":9},{"$f":"'1.00 2.00'!Q53","v":0},{"$f":"'1.00 2.00'!R53","v":0},null,null,null,"Communication",0,0,0,0,{"$f":"L15","v":47}]
[null,null,"3.00 Contract Review/Document Control . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,null,null,null,null,null,{"$f":"'3.00 4.00'!P20","v":12},{"$f":"'3.00 4.00'!Q20","v":0},{"$f":"'3.00 4.00'!R20","v":0},null,null,null,"Documentation",0,0,0,0,9]
[null,null,"4.00 Manufacturing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,null,null,null,{"$f":"'3.00 4.00'!P48","v":37},{"$f":"'3.00 4.00'!Q48","v":0},{"$f":"'3.00 4.00'!R48","v":0},null,null,null,"Manufacturing",0,0,0,0,12]
[null,null,"5.00 Procurement . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,null,null,null,{"$f":"'5.00 6.00'!N17","v":12},{"$f":"'5.00 6.00'!O17","v":0},{"$f":"'5.00 6.00'!P17","v":0},null,null,null,"Procurement",0,0,0,0,37]
[null,null,"6.00 Engineering . . . . . . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,null,null,null,{"$f":"'5.00 6.00'!N32","v":15},{"$f":"'5.00 6.00'!O32","v":0},{"$f":"'5.00 6.00'!P32","v":0},null,null,null,"Engineering",0,0,0,0,12]
[null,null,"7.00 Quality . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,null,null,null,{"$f":"'7.00'!N34","v":38},{"$f":"'7.00'!O34","v":0},{"$f":"'7.00'!P34","v":0},null,null,null,"Quality",0,0,0,0,15]
[null,null,"8.00 Product Identification and Traceability . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,null,null,null,{"$f":"'8.00 9.00 10.00'!N17","v":9},{"$f":"'8.00 9.00 10.00'!O17","v":0},{"$f":"'8.00 9.00 10.00'!P17","v":0},null,null,null,"Product ID etc.",0,0,0,0,38]
[null,null,"9.00 Control of Non-conforming Product . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,null,null,null,{"$f":"'8.00 9.00 10.00'!N34","v":27},{"$f":"'8.00 9.00 10.00'!O34","v":0},{"$f":"'8.00 9.00 10.00'!P34","v":0},null,null,null,"Control of Non-conforming etc.",0,0,0,0,9]
[null,null,"10.00 Packaging, Storage, Handling & Shipping . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,null,null,null,{"$f":"'8.00 9.00 10.00'!N44","v":10},{"$f":"'8.00 9.00 10.00'!O44","v":0},{"$f":"'8.00 9.00 10.00'!P44","v":0},null,null,null,"Packaging etc.",0,0,0,0,27]
[null,null,"Totals",null,null,null,null,null,null,null,null,{"$f":"SUM(L15:L24)","v":216},{"$f":"SUM(M15:M24)","v":0},0,null,null,null,null,null,null,null,null,10]