{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Supplier Evaluation_Site visit","Scoring"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Supplier Evaluation_Site visit","index":0,"n_rows":64,"n_cols":6,"rows_kept":64,"merged":[[0,0,3,5],[4,0,4,5],[6,0,6,1],[6,2,6,5],[7,0,7,1],[7,2,7,5],[8,0,8,1],[8,2,8,5],[9,0,9,1],[9,2,9,5],[10,0,10,1],[10,2,10,5],[13,0,13,5],[14,2,14,4],[19,0,19,5],[23,0,23,5],[27,0,27,5],[30,0,30,5],[32,0,32,5],[37,0,37,5],[43,0,43,5],[49,0,49,5],[53,0,53,5],[58,0,58,5],[59,0,59,2],[60,0,60,2],[61,0,61,2],[63,0,63,1],[63,2,63,3],[63,4,63,5],[64,0,64,1],[64,2,64,3],[64,4,64,5],[65,0,65,1],[65,2,65,3],[65,4,65,5],[66,0,66,1],[66,2,66,3],[66,4,66,5]]}
["SUPPLIER QUALITY ASSESSMENT QUESTIONNAIRE"]
[]
[]
[]
["Transnet Engineering (TE) would like to request your organisation to provide the below information to assess your organisation's Quality Management System and capabilities in relation to the product mentioned below"]
[]
["Material no.: Various Steel Products",null,"Bidder Name:                                                                                                                                                                                                                      "]
["Material Description.: Various Steel Products",null,"Physical Address:"]
["Transnet Engineering BEC Member: ",null,"Bidder Representative Name:"]
["BEC Member E-mail address: ",null,"Bidder Representative Contact No.: "]
["BEC Member Contact no.: ",null,"Bidder Representative e-mail address: "]
[]
[null,"Question","Selection","Score","Evidence Required\n(Yes/No)","Comment/Answer"]
["About the Organisation"]
[1,"Please provide details of your organisation’s scope of activities, products or services"]
[{"$f":"A15+1","v":2},"How long has the organisation been in business?","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
[{"$f":"A16+1","v":3},"Does the organisation have its own premises, where its products are manufactured?","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
[{"$f":"A17+1","v":4},"Does the organisation use their own machines & equipment to manufacture their products?","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
[5,"Has the organisation manufactured the required or similar product before?","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
["Quality Management System"]
[{"$f":"A19+1","v":6},"Has the organisation established, documented, implemented and maintains a Quality Management System (QMS)  based on ISO 9001:2015 or other QMS?","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
[{"$f":"A21+1","v":7},"Does the organisation have a Quality Manual based on ISO 9001:2015 or other QMS?","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
[{"$f":"A22+1","v":8},"Does the organisation have a Quality Management System that is certified by an accreditation body e.g. ISO 9001:2015?","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
["Review of Documents"]
[{"$f":"A23+1","v":9},"Does your organisation review provided information to understand customer requirements e.g. specifications, drawings, etc? ","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
[{"$f":"A25+1","v":10},"Does the organisation retain documented evidence of such reviews mentioned in (10)?","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
[{"$f":"A26+1","v":11},"Does the Supplier have all necessary specs and drawings to produce the relevant product/s?","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
["Risk Identification and Control"]
[{"$f":"A27+1","v":12},"Has the organisation identified potential risks that could impact product quality","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
[{"$f":"A29+1","v":13},"Are there documented controls or mitigation plans to manage identified risks.","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
["Personnel Training & Qualification"]
[{"$f":"A30+1","v":14},"Does the organisation have trained and/or certified personnel responsible for conducting special processes?","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
["Tools & Equipment"]
[{"$f":"A32+1","v":15},"Is the organisation in possession of relevant tools & equipment required to effectively produce quality products?","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
[{"$f":"A34+1","v":16},"Are measuring tools and equipment controlled and calibrated to maintain accuracy and reliability of measurements?","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
[{"$f":"A35+1","v":17},"Is the calibration of tools and equipment traceable to recognised National or International standards (e.g., SANAS)?","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
[18,"Do maintenance plans exists for critical equipment to prevent breakdowns?","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
["Processes"]
[{"$f":"A37+1","v":19},"Has the organisation established and maintained documented procedures for its processes?","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
[{"$f":"A39+1","v":20},"Are there documented procedures in place for Document Control, including the issuance of documents to production?","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
[{"$f":"A40+1","v":21},"Are process flow diagrams or documented workflows available for each product or production line (inclusive of incoming inspection, inline inspection and final inspection hold points)?","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
[22,"Are materials and products clearly identified and traceable throughout all process stages up to final delivery to the customer?\n","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
[23,"Are there documented Quality Control Plans (QCP) that detail the processes, documentation, and resources applied to specific products to ensure customer requirements are met?","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
["Material & Product Qualification"]
[{"$f":"A43+1","v":24},"Does the organisation perform incoming or pre-production inspections to verify material or component compliance, including verification of accompanying certificates?","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
[{"$f":"A45+1","v":25},"Is the organisation in possession of checksheets or job cards per product?","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
[{"$f":"A46+1","v":26},"Does the organisation conduct final inspection prior to despatch to ensure comformance to requirements?","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
[27,"Does the organisation document and keep inspection records e.g. checksheet, certificates etc.?","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
[28,"Are clear acceptance and rejection criteria defined and applied during inspections?","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
["Auditing"]
[{"$f":"A49+1","v":29},"Does the organisation assess or audit its service providers and sub-contractors to ensure compliance to requirements?","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
[{"$f":"A51+1","v":30},"Does the organisation conduct internal audits? ","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
[{"$f":"A52+1","v":31},"Does the organisation retain documented evidence of the assessments or audits conducted?","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
["Non-Conformance Management"]
[{"$f":"A53+1","v":32},"Does the organisation have a Non-Conformance Report (NCR) management procedure?","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
[{"$f":"A55+1","v":33},"Does the organisation have a corrective action management procedure to determine root causes and prevent their recurrence?","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
[{"$f":"A56+1","v":34},"How long does it take the organisation to respond to customer complaints?","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
[35,"Does the organisation record and investigate both internal and customer-reported non-conformances?","Choose from drop-down list",{"$f":"VLOOKUP(C:C, Scoring!A:B, 2, FALSE)","v":0},"Yes"]
["SCORE"]
["Total Score Points",null,null,38]
["Actual Score Points",null,null,{"$f":"SUM(D16:D19,D21:D23,D25:D27,D29:D30,D32,D34:D37,D39:D43,D45:D49,D51:D53,D55:D58)","v":0}]
["Actual Score (%) Minimum Threshold (75%)",null,null,{"$f":"D61/D60","v":{"v":0,"d":"0.00%"}}]
[]
["Transnet Engineering Representative Name & Surname - Department",null,"Signature",null,"Date"]

{"sheet":"Scoring","index":1,"n_rows":13,"n_cols":2,"rows_kept":13}
[]
["Scoring","Points"]
["Choose from drop-down list",0]
["Less than a year",1]
["1-5 years",2]
[">5 years",3]
["Choose from drop-down list",0]
["Yes",1]
["No",0]
["Choose from drop-down list",0]
["Less than 7 working days",3]
["7-30 working days",2]
["More than 30 working days",1]