{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["PHASE 1A","PHASE 1B","PHASE 2 ","PHASE 3"],"read":"whole","date_system":"1900"}

{"sheet":"PHASE 1A","index":0,"n_rows":12,"n_cols":5,"rows_kept":12,"merged":[[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[11,0,11,1]]}
["TO FIND ALTERNATIVE ORIGINAL EQUIPMENT MANUFACTURER(S) (OEM) TO SUPPORT THE RETURN TO SERVICE OF THE ESTIMATED 160 LONG-STANDING LOCOMOTIVES AND THE SUPPLY OF COMPONENTS FOR THE 20E, 21E AND 22E FLEETS"]
["RFP NUMBER: HOAC-HO-40346"]
["TECHNICAL EVALUATION CRITERIA - PHASE 1A [MANDATORY TECHNICAL QUESTIONNAIRE]"]
["Bidder Notes:\n1. Bidders are to complete all three sheets for each phase of evaluation by indicating whether the required documents were submitted. Please indicate 'Yes' or 'No'.\n2. A Respondent must pass all three (3) phases to progress the next stage of evaluation.\n3. Respondents may utilise the comments section to reference where in their bd proposal the relevant documents/evidence may be located."]
["Item #","Criteria/Capability and evidence required","Scoring Guide","Submitted\nYes/No","Comments"]
[1,"Provision of full scope of work required to bring a locomotive back into service, inclusive of component repairs and replacement; and material and parts supply to effect the repairs. This must include an estimated timeline to return the locomotive to service taking cognisance of all engineering effort required ","YES = 2 Points\nNO = 0 Points"]
[2,"Confirmation of where the set out work will be carried out - either at Transnet’s facilities using Transnet’s workforce, equipment and tools or at the supplier proposed alternative facilities. The respondents to provide relevant agreements which confirm the facilities to be used. ","YES = 2 Points\nNO = 0 Points"]
[3,"The bidder must include a proposal for component repairs and replacement, and material and parts supply for the repair and maintenance of the respective locomotive fleet for a maximum period of 10 years. ","YES = 2 Points\nNO = 0 Points"]
[4,"Regardless of whether the repair is work performed at Transnet or the bidder’s facilities, the bidder shall provide maintenance training and detailed documentation to nominated Transnet employees. Bidders must provide a proposed training plan and a final plan will be mutually agreed during contracting.","YES = 2 Points\nNO = 0 Points"]
[5,"Interested tenderers will be required to visit the locomotives at various sites around the country. Evidence that the tenderer attended all the relevant sites must be provided in the form of a signed confirmation by a Transnet representative.","YES = 2 Points\nNO = 0 Points"]
[6,"Each tenderer will submit the quotation and linked financial response in accordance with the scope of work applicable to each locomotive.","YES = 2 Points\nNO = 0 Points"]
["Total score",null,"12 Points"]

{"sheet":"PHASE 1B","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,5],[3,0,3,5],[5,0,9,0],[5,1,9,1],[5,5,9,5],[10,0,11,0],[10,1,11,1],[10,5,11,5]]}
["TO FIND ALTERNATIVE ORIGINAL EQUIPMENT MANUFACTURER(S) (OEM) TO SUPPORT THE RETURN TO SERVICE OF THE ESTIMATED 160 LONG-STANDING LOCOMOTIVES AND THE SUPPLY OF COMPONENTS FOR THE 20E, 21E AND 22E FLEETS"]
["RFP NUMBER: HOAC-HO-40346"]
["TECHNICAL EVALUATION CRITERIA - PHASE 1B [MANDATORY TECHNICAL QUESTIONNAIRE]"]
["Scoring Guide:\n0 = Not eligible\n1 = Inadequate \n2 = Limited \n3 = Acceptable"]
["MEASURE","CRITERIA","QUESTIONS","Portfolio of Evidence","SCORING METHOD","WEIGHTING"]
["Design and manufacturing of Electrical, Electronic System and electric propulsion systems. Testing Capacity and Capability","*Will have established facilities for design and manufacturing of electric/electronic, propulsion systems. \n*Engineering Design capacity and capability: Must have inhouse ability to redesign and supply own systems on electric locomotives:  provide detail and examples of this.\n","Are you an established original eqipment manufacturer of electric locomotive and of Electrical, Electronic System and electric propulsion systems for AC/DC locomotives? ","Supply detail of premises; TRANSNET reserves the right to perform an audit of facilities to confirm details","No local manufacturing plant =0\nLocal manufacturing plant = 3",{"v":0.3,"d":"30%"}]
[null,null,"Proven track record of upgrading/retrofitting own Electrical, Electronic System and electric propulsion systems subsystems for the AC/DC electric locomotives in accordance with International Electrotechnical Commision (IEC) Railway specifications?","Provide detail of these, e.g certification, reference letters.","Certificate and 3 reference letters=3\nCertificate and 2 reference letters=2\nCertificate and only 1 reference =1\nNo certificate/reference = 0"]
[null,null,"Do you have relationships with other locomotive OEMs  with regards to either a complete locomotive manufacturing  or manufacturing of locomotive Electrical, Electronic System and electric propulsion systems to locomotive OEMs? ","Provide detail of these e.g contract documents or any reference letters.","Certificates,copy of contracts and 3 reference letters=3\nCertificate and 2 reference letters=2\nCertificate and only 1 reference =1\nNo certificate/reference = 1"]
[null,null,"Indicate which of the current Electrical, Electronic  and electric propulsion  components/systems on the AC/DC locomotive were designed, manufactured and supplied by your firm?","Provide details and supporting documents (ie references)","Systems operational in existing fleet=0\nSystems still under testing/trials=1\nSystems in existing fleet abroad = 2\nSystem in existing fleet in SA=3"]
[null,null,"Do you have appropriately equipped facilities for research and design (R&D). Supply detail as evidence confirming the following. (See next column)","(a) R&D Facilities Available. \n(b)Inspection and Quality Control of Raw Material, Components and Finished Products \n(c) Testing/Calibration equipment \n(d) Laboratory and Drawing Office Facility \n(e) Percentage of Total Turn-Over Spent on R&D during the Last Three Years.","All activities available = 3\nOnly 3 or 4 activities available = 2\nOnly 2 or less activities available  = 1\nNo R&D activities = 0"]
["Previous experience","*Previous experience related to this project.\n*Indicate which of the current components/systems on the locomotive was supplied by the company or for which of the components/systems on the locomotive do they have proven knowledge","Indicate current annual manufacturing quantities/volumes of locomotives and locomotive Electrical, Electronic and electric propulsion systems/components supplied by your firm locally or internationally? ","Provide detail of volumes of locomotives and systems/components supplied","Volumes:\n0 to 100 = 0\n101-300 = 1\n301-600 = 2\nMore than 600=3",{"v":0.3,"d":"30%"}]
[null,null,"Provide detail of existing electric locomotives fleets in SA and abroad of which you are the OEM of as well as the breakdown as original manufacturer of the Electrical, Electronic  and electric propulsion systems/components and the distribution of these fleet ?","Provide detail of existing fleets of which they are the OEM and the distribution of these fleets","Systems not in existing fleet=0\nSystems still under testing/trials=1\nSystems in existing fleet abroad = 2\nSystem in existing fleet in SA=3"]
["Electric locomotive Certification and licencing","Have certification to work on Electric locomotives, qualified technicians to perform power test, commissioning.","Do you have certification to manufacture Electrical, Electronic  and electric propulsion systems/components on Electric locomotives."," Provide the relevant evidence","No certificate/expired certificate = 0\nValid certificate =3",{"v":0.1,"d":"10%"}]
["Engineering Capacity","Have own skilled systems engineers, engineering specialists, technicians. ","Dooes your firm have systems engineers ","Supply a human resource plan, detailing skills level.","3 X CVs of systems engineers with more than 10 years experience? \n< 10 year = 0\n>10 years =3\n",{"v":0.1,"d":"10%"}]
["Procurement and Logistics Capability","Will have proven capability to procure and store material, parts and components to manufacture the subsystems and components where necessary.","Will have proven capability to procure and store material, parts and components to manufacture the subsystems and components where necessary.","Storage facilities (proof), previous experience on storage of parts and management of the warehouse.","No experience= 0\n2 years= 1\n4 years = 2\n>4 years= 3",{"v":0.05,"d":"5%"}]
["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. Alternatively supplier and its subcontractors have a Quality Management Policy in place. Submit a proof of quality management system.","Have ISO rating: The Contractor  has ISO rating 9001: 2015 as a basis for their Quality Management System or the latest version if applicable. ","Submit a proof of quality management system.","No QMS = 0\nQMS = 3",{"v":0.1,"d":"10%"}]
["Project Management","Have proven Project Management Capability; with evidence of similar locomotive systems design and manufacturing  projects delivered.","Typical design leadtimes/turn key project timelines","Provide the relevant References","No references provided = 0\n2 references provided = 1\n4 references provided = 2\n>4 provided = 3",{"v":0.05,"d":"5%"}]
[{"$nulls":5},{"$f":"SUM(F6:F17)","v":{"v":1,"d":"100%"}}]

{"sheet":"PHASE 2 ","index":2,"n_rows":7,"n_cols":4,"rows_kept":7,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,4]]}
["TO FIND ALTERNATIVE ORIGINAL EQUIPMENT MANUFACTURER(S) (OEM) TO SUPPORT THE RETURN TO SERVICE OF THE ESTIMATED 160 LONG-STANDING LOCOMOTIVES AND THE SUPPLY OF COMPONENTS FOR THE 20E, 21E AND 22E FLEETS"]
["RFP NUMBER: HOAC-HO-40346"]
["TECHNICAL EVALUATION CRITERIA - PHASE 2 [MANDATORY TECHNICAL DOCUMENTS]"]
["Bidder Notes:\n1. Bidders are to complete all three sheets for each phase of evaluation by indicating whether the required documents were submitted. Please indicate 'Yes' or 'No'.\n2. A Respondent must pass all three (3) phases to progress the next stage of evaluation.\n3. Respondents may utilise the comments section to reference where in their bd proposal the relevant documents/evidence may be located."]
["Item #","Documents Required","Submitted\nYes/No","Comments"]
[1,"Scope of work per locomotive completed and submitted for the required repairs. \n(Indicative timelines and cost to be provided for each locomotive repair)"]
[2,"Proposal for replacements/redesign, parts supply and drawings."]

{"sheet":"PHASE 3","index":3,"n_rows":6,"n_cols":4,"rows_kept":6,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,4]]}
["TO FIND ALTERNATIVE ORIGINAL EQUIPMENT MANUFACTURER(S) (OEM) TO SUPPORT THE RETURN TO SERVICE OF THE ESTIMATED 160 LONG-STANDING LOCOMOTIVES AND THE SUPPLY OF COMPONENTS FOR THE 20E, 21E AND 22E FLEETS"]
["RFP NUMBER: HOAC-HO-40346"]
["TECHNICAL EVALUATION CRITERIA - PHASE 3 [OPERATIONAL READINESS]"]
["Bidder Notes:\n1. Bidders are to complete all three sheets for each phase of evaluation by indicating whether the required documents were submitted. Please indicate 'Yes' or 'No'.\n2. A Respondent must pass all three (3) phases to progress the next stage of evaluation.\n3. Respondents may utilise the comments section to reference where in their bid proposal the relevant documents/evidence may be located."]
["Item #","Criteria/Capability and evidence required","Submitted?\nYes/No","Comments"]
[1,"Respondents to provide evidence of agreements or memorandum of understanding (MOU) relating to the proposed repair facilities.\nAlternative facilities for repairs/Existing facilities/Partnership or JV facilities location. \n\nEvidence must demonstrate the following at a minimum:\nStaff capacity and capability\nStorage facilities\nMachinery\nTooling\nCrane capacity, jacks, slings, etc.\nCertificates of authority to work under high voltage eg. Green, brown etc.\nSecurity"]