{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Phase 1 ","Phase 2"],"read":"whole","date_system":"1900"}

{"sheet":"Phase 1 ","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"merged":[[0,0,0,6],[1,5,1,6],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,6,21,6],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[8,0,9,0],[8,1,9,1],[8,2,9,2],[8,3,9,3],[10,0,11,0],[10,1,11,1],[10,2,11,2],[10,3,11,3],[12,0,13,0],[12,1,13,1],[12,2,13,2],[12,3,13,3],[14,0,15,0],[14,1,15,1],[14,2,15,2],[14,3,15,3],[16,0,17,0],[16,1,17,1],[16,2,17,2],[16,3,17,3],[16,4,17,4],[18,0,19,0],[18,1,19,1],[18,2,19,2],[18,3,19,3],[20,0,21,0],[20,1,21,1],[20,2,21,2],[20,3,21,3]]}
["PHASE 1: PRE-QUALIFICATION CRITERIA (100% COMPLIANCE TO SPECIFICATION)  (THRESHOLD: 100%) ALL SUPPLIERS MUST SCORE 100% FOR PHASE 1 IN ORDER TO MOVE TO PHASE 2."]
["MEASURE","CRITERIA","QUESTIONS","PORTFOLIO OF EVIDENCE","SCORING METHOD","WEIGHTING"]
["Compliance to the technical specification from the diesel locomotive OEMs","Ability to supply the locomotive OEM approved diesel locomotive engine oils","Can your company supply the locomotive OEMs list of approved diesel locomotive engine oils","*Completed and Signed Technical Specification RT_TE_SPC_0113 with all detail","Signed Technical Specification indication that the supplier comply line by line with completed Annexures = 10 points","10 = 10%",{"v":1,"d":"100%"}]
[{"$nulls":3},"completed for the Annexures (Annexures 1 and 2) in the specification.","No signed or incomplete Technical Specification indication that the supplier comply line by line with Annexures  = 0 point","0 = 0%"]
["Submit Technical Data Sheets","Technical Data Sheets for oil that comply to specification RT_TE_SPC_0113. ","Can the supplier supply the relevant data sheets","The lubricant supplier shall submit complete technical data sheets for all lubricants tendered, including the results of all tests required to comply with LMOA Gen 7, GM EMD and GE requirements. In addition, physical parameters detailed in Annexure No. 1 shall be submitted for each oil offered.","Submit complete Technical Data Sheets that comply with specification RT_TE_SPC_0113 = 10 points ","10 = 10%"]
[{"$nulls":4},"Submit incomplete non-compliant or NO Technical Datasheets = 0 point","0 = 0%"]
["Submit Lubricant Formulation Data","Lubricant formulations data that is used to make up the oil in compliance with the technical specification RT_TE_SPC_0113, Gen 7 LMOA approved oil for Transnet locomotives.","Can the supplier supply the Lubricant formulations data","The supplier shall submit formulation data showing the composition of the candidate lubricant, regarding both the specific base stocks (crude source and refinery, etc.) and additive treatment (concentration, generic chemical description of each component, manufacturer).","Submit complete Lubricant Formulation Data = 10 points","10 = 10%"]
[{"$nulls":4},"Submit incomplete or NO Lubricant Formulation Data = 0 point","0 = 0%"]
["Submit locomotive OEMs Approved Certificates/ Letters","Locomotive OEMs Certificates/Letters that the oil offered is suitable for the fleet of locomotives mentioned in RT_TE_SPC_0113","Can the supplier supply the locomotive OEMs Certificates/Letters","The lubricant supplier shall submit a letter or certificate of compliance or approval from both GE and GM EMD, indicating conformance to their requirements, for each lubricating oil tendered. The results of OEM bench and engine testing should be made available to Transnet on request.","Submit Locomotive OEMs certificates/ letters = 10 points ","10 = 10%"]
[{"$nulls":4},"Submit NO Lubricant Locomotive OEMs certificates/ letters  = 0 point","0 = 0%"]
["Submit Laboratory Test Certificates","Laboratory Test Certificates for the oil approved by the locomotive OEM for the fleet mentioned in RT_TE_SPC_0113","Can the supplier supply the Laboratory Test Certificates","The lubricant supplier shall submit test results from a SANAS accredited laboratories, confirming that the product submitted for approval meets all of the stated requirements. Test limits shown are absolute; test precision was considered when setting them.","Submit Laboratory test certificates = 10 points    ","10 = 10%"]
[{"$nulls":4},"Submit NO Laboratory test certificates  = 0 point","0 = 0%"]
["Submit Material Safety Data Sheets","Material Safety Data Sheets for the oil offered","Can the supplier supply the Material Safety Data Sheets","The supplier shall submit a Material Safety Data Sheet (MSDS) for each lubricant tendered","Submit Material Data Safety Sheets = 10 points ","10 = 10%"]
[{"$nulls":4},"Submit NO Material Data Safety Sheets  = 0 point","0 = 0%"]
["Submit Chemical properties","Chemical properties for the oil offered as per section 6.7 of document RT_TE_SPC_0113 ","Can the supplier supply the Chemical properties ","Compliance with the Chemical lubricant properties as per Technical Specification","Compliance with Chemical Lubricant properties = 10 points   ","10 = 10%"]
[{"$nulls":4},"Non-compliance with Chemical Lubricant properties = 0 point","0 = 0%"]
["Submit Lubricant Compatibility","Lubricant Compatibility as per section 6.8 of document RT_TE_SPC_0113","Can the supplier supply the Lubricant Compatibility","Mixtures of the lubricant approved, and the lubricant currently used shall pass all the requirements of this specification. The incoming supplier shall certify that, when his lubricant is mixed with a lubricant already in use, there shall be no incompatibility or loss in operating performance. Transnet reserves the right to request proof of compatibility, e.g. laboratory tests, etc.","Submit proof of Lubricant Compatibility = 10 points    Submit NO proof of Lubricant Compatibility  = 0 point","10 = 10%"]
[{"$nulls":5},"0 = 0%"]
["Submit Total Base Number","Total Base Number should be 10.5 mg potassium hydroxide per gram of oil (mg KOH/g) as per section 6.11 of document RT_TE_SPC_0113","Can the supplier supply the Total Base Number","The Total Base Number of the Oil shall be equivalent to 10.5 mg potassium hydroxide per gram of oil (mg KOH/g) when determined by ASTM D2896 methods. In addition, the oil supplier shall also report the TBN value as determined by ASTM D664 test methods.","Submit the TBN of the oil offered = 10 points   ","10 = 10%"]
[{"$nulls":4},"Submit NO TBN of the oil offered  = 0 point","0 = 0%"]
["Submit Viscosity Index","Viscosity Index to be supplied for oil as per section 6.12 of document RT_TE_SPC_0113","Can the supplier supply the Viscosity Index","The viscosity index of the lubricant shall be determined by ASTM D2270","Submit Viscosity index = 10 points   ","10 = 10%"]
[{"$nulls":4},"Submit NO Viscosity index  = 0 point","0 = 0%"]

{"sheet":"Phase 2","index":1,"n_rows":15,"n_cols":7,"rows_kept":15,"merged":[[0,0,0,6],[1,5,1,6],[2,0,7,0],[2,2,5,2],[2,3,5,3],[2,6,5,6],[6,2,7,2],[6,3,7,3],[6,6,7,6],[8,0,11,0],[8,2,11,2],[8,6,11,6],[12,0,13,0],[12,1,13,1],[12,2,13,2],[12,3,13,3],[12,6,13,6]]}
["PHASE 2: TECHNICAL FUNCTIONALITY (THRESHOLD: 70%) "]
["MEASURE","CRITERIA","QUESTIONS","PORTFOLIO OF EVIDENCE","SCORING METHOD","WEIGHTING"]
["Previous experience",null,"Has your company supplied lubricants for use on locomotives or in the industrial market (SOE/Manufacturing Plant/Factories)?","Bidder to provide a signed letter of reference/completion certificate/delivery note on referee letterhead with contactable contact details from different clients indicating previous experience supplying lubricants","Three or more Reference/Completion Certificates = 3 points","3 = 50%",{"v":0.5,"d":"50%"}]
[{"$nulls":4},"Two Reference/Completion Certificates = 2 points","2 = 25%"]
[null,"Previous experience related to supplying of lubricants locomotives or industrial applications.",null,null,"One Reference/Completion Certificate = 1 point","1 = 10%"]
[null,"Indicate your current supply of lubricants",null,null,"No similar work = 0 points","0 = 0%"]
[null,null,"Has your company supplied lubricants that are currently being used on locomotive fleets?","Bidder to provide datasheet showing oils that are currently being used on locomotives and details of the locomotive/ or oil supply to other industries","Datasheet of oils application with delivery Qty and Zar value = 3 points","3 = 17%",{"v":0.17,"d":"17%"}]
[{"$nulls":4},"No datasheets supplied = 0 points","0 = 0%"]
["Procurement and Logistics Capability",null,"Will have proven capability to procure and manage the logistics to deliver to Transnet depots country-wide","Proof of logistics capability and delivery management plan containing the following:",null,null,{"v":0.17,"d":"17%"}]
[null,"Will have proven capability to procure and manage countrywide on-time delivery.",null,"•Distribution plan throughout the various Transnet depots","Submitted proof of logistics capability and delivery management plan= 3 points","3 =17%"]
[null,"Evidence of similar quantities delivered.",null,"•Warehouse Plan (levels of stockholding)","None submitted = 0 points ","0 = 0%"]
[{"$nulls":3},"•Local/ Imported Blending Plant "]
["Quality Management System","Have ISO rating: The Contractor and its Sub-Contractors has ISO rating 9001: 2015 as a basis for their Quality Management System or the latest version if applicable. ","Have ISO rating: The Contractor has ISO rating 9001: 2015 as a basis for their Quality Management System or the latest version if applicable. ","Quality management system:  ISO certification 9001:2015.","Submitted valid ISO 9001:2015 certificate = 3 points","3 = 16%",{"v":0.16,"d":"16%"}]
[{"$nulls":4},"No ISO 9001/2015 certificate submitted = 0 points","0 = 0%"]
[{"$nulls":6},{"v":1,"d":"100%"}]