{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["PA"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"PA","index":0,"n_rows":109,"n_cols":7,"rows_kept":109,"cut":false,"hidden":false,"merged":[[92,0,104,0],[108,0,108,6],[0,2,0,3],[13,0,33,0],[35,0,60,0],[62,0,65,0],[67,0,79,0],[81,0,90,0]]}
[null,null,"Potential Analysis - Questionnaire for selection of vendor"]
[]
[null,null,"this fields must be completed by the potential supplier",null,"year"]
[null,null,"this fields will be completed by WIKA",null,{"$f":"YEAR(E5)","v":2013}]
[null,null,"this fields will be completed by WIKA (Rating&comments)","Date:",{"$f":"TODAY()","v":"2013-08-22"}]
[null,null,"Company name"]
[null,null,"DUNS #"]
[null,null,"local supplier #"]
[null,null,"Commodity Manager"]
[null,null,"Commodity Team members"]
[null,null,"IPO"]
[null,null,"all currency are in Euro"]
[null,null,null,null,"max. points","reached ","WIKA comments "]
["Corporate information","Corporate Information and Profile"]
[null,"1.","Date"]
[null,"2.","Location & address"]
[null,"3.","Phone"]
[null,"4.","Fax"]
[null,"5.","Main contact & e-mail adress"]
[null,"6.","Website"]
[null,"7.","Formation of the company (Establishment)",null,2,null,"WIKA comments "]
[null,"8.","Legal form"]
[null,"9.","Please attach an organizational chart for the company / or location"]
[null,"10.","Registered capital"]
[null,"11.","Company belongs to group"]
[null,"12.","Labor union organization"]
[null,"13.","CEO / General Manager"]
[null,"14.","Core business"]
[null,"15.","Customer references & branch of trade (please name Top 3 refer.)",null,2,null,"WIKA comments "]
[null,"16.","Do you have principles in your company installed regarding"]
[null,null,"  -discrimination",null,1,null,"WIKA comments "]
[null,null,"  -prohibition of child labour",null,1,null,"WIKA comments "]
[null,null,"  -payment of minimum wages",null,1,null,"WIKA comments "]
[null,null,"  -working conditions, times < 12 h ",null,1,null,"WIKA comments "]
[null,null,null,null,{"$f":"SUM(E21:E34)","v":8},{"$f":"SUM(F21:F34)","v":0},{"$f":"F35/E35","v":0}]
["Commercial aspects","Commercial Aspects"]
[null,"17.","Number of employees",null,2]
[null,null,{"$f":"C40-2","v":2011}]
[null,null,{"$f":"C40-1","v":2012}]
[null,null,{"$f":"E4","v":2013}]
[null,"18.","Annual sales / sales revenue",null,2,null,"WIKA comments "]
[null,null,{"$f":"C44-2","v":2011}]
[null,null,{"$f":"C44-1","v":2012}]
[null,null,{"$f":"E4","v":2013}]
[null,"19.","Share of exports ",null,3,null,"WIKA comments "]
[null,null,"Europe"]
[null,null,{"$f":"C48-1","v":2011}]
[null,null,{"$f":"E4-1","v":2012}]
[null,null,"Asia"]
[null,null,{"$f":"C51-1","v":2011}]
[null,null,{"$f":"E4-1","v":2012}]
[null,null,"America"]
[null,null,{"$f":"C54-1","v":2011}]
[null,null,{"$f":"E4-1","v":2012}]
[null,"20.","Capital investment",null,2,null,"WIKA comments "]
[null,null,{"$f":"C57-1","v":2011},null,null,null,"WIKA comments "]
[null,null,{"$f":"E4-1","v":2012},null,null,null,"WIKA comments "]
[null,"21.","Delivery terms (Incoterms)"]
[null,null,"to WIKA China",null,2,null,"WIKA comments "]
[null,null,"to WIKA subsidiaries (Germany / Poland / America)",null,2,null,"WIKA comments "]
[null,"22.","Do you accept the WIKA standard payment terms 30 days net?",null,2,null,"WIKA comments "]
[null,null,null,null,{"$f":"SUM(E36:E61)","v":15},{"$f":"SUM(F37:F61)","v":0},{"$f":"F62/E62","v":0}]
[null,"Technical aspects"]
[null,"23.","Which materials do you predominantly handle / process?",null,3,null,"WIKA comments "]
[null,"24.","Equipment list",null,3,null,"WIKA comments "]
[null,"25.","Descripe your strength in terms of the technologies, know-how or production processes.",null,4,null,"WIKA comments "]
[null,null,null,null,{"$f":"SUM(E64:E66)","v":10},null,{"$f":"F67/E67","v":0}]
[null,"Quality principles and methods"]
[null,"26.","Number of employees in the quality department",null,2,null,"WIKA comments "]
[null,null,{"$f":"C72-2","v":2011}]
[null,null,{"$f":"C72-1","v":2012}]
[null,null,{"$f":"E4","v":2013}]
[null,"27.","Do you have continuous improvement programs?",null,2,null,"WIKA comments "]
[null,"28.","Which key quality data is measured? (If yes please write in the results of the last year)"]
[null,null,"-incoming inspection defect rate",null,0.5,null,"WIKA comments "]
[null,null,"-finished product defect rate",null,0.5,null,"WIKA comments "]
[null,null,"-customer complaint",null,0.5,null,"WIKA comments "]
[null,null,"-PPM",null,0.5,null,"WIKA comments "]
[null,null,"-CPK",null,0.5,null,"WIKA comments "]
[null,null,"free text…",null,0.5,null,"WIKA comments "]
[null,null,null,null,{"$f":"SUM(E68:E80)","v":7},{"$f":"SUM(F69:F80)","v":0},{"$f":"F81/E81","v":0}]
[null,"Quality management and integration"]
[null,"29.","Which quality assurance system is maintained in your organisation?"]
[null,null,"(Please attach all valid certifications and awards.)"]
[null,null,"-ISO TS16949",null,4,null,"WIKA comments "]
[null,null,"-ISO 9001:2008",null,2,null,"WIKA comments "]
[null,"30.","Do you have a system for internal quality audits?",null,2,null,"WIKA comments "]
[null,"31.","Do you agree to enclose the following documents to your quote packages"]
[null,null,"-control chart",null,0.5,null,"WIKA comments "]
[null,null,"-material certificate",null,0.5,null,"WIKA comments "]
[null,null,"-cost breakdown",null,0.5,null,"WIKA comments "]
[null,null,null,null,9.5,{"$f":"SUM(F85:F91)","v":0},{"$f":"F92/E92","v":0}]
[null,"Environmental management"]
[null,"32.","Have you set up an environmental management system, e.g. in accordance with:"]
[null,null,"-DIN EN ISO 14001",null,8,null,"WIKA comments "]
[null,null,"-Eco-management and audit scheme (EMAS)",null,8,null,"WIKA comments "]
[null,null,"Please attach all certifications and awards"]
[null,null,"-others?",null,2,null,"WIKA comments "]
[null,"33.","We have not set up an environmental management sytem yet, but it is planned for (year)",null,1,null,"WIKA comments "]
[null,"34.","Have you been audited for environmental measures by external companies with a positive result yet?",null,0.5,null,"WIKA comments "]
[null,"35.","Do you inform and train your employees regularly in aspects of environmental protection?",null,0.5,null,"WIKA comments "]
[null,"36.","Do you document measures for environmental protection and results in your company in written form?",null,0.5,null,"WIKA comments "]
[null,"37.","Does your company follow written guidelines concerning environmental protection?",null,0.5]
[null,"38.","Do you define aims to improve the environmental protection regularly in your company and do you document their fullfillment?",null,0.5,null,"WIKA comments "]
[null,"39.","Do you work towards the improvement of the environmental protection with your suppliers and contract partners?",null,0.5,null,"WIKA comments "]
[null,null,null,"Sum",8,{"$f":"SUM(F95:F105)","v":0},{"$f":"F106/E106","v":0}]
[null,null,null,"Sum overall",{"$f":"E106+E92+E81+E67+E62+E35","v":57.5},{"$f":"F35+F62+F67+F81+F92+F106","v":0},{"$f":"F107/E107","v":0}]
[]
["A minimum achievement of 50 % in the total amount is required for the potential supplier. Additonally it is necessary to have an achievement of minimum 50 % in every section."]