{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["STP","WTP","Bulk chem"],"read":"whole","date_system":"1900"}

{"sheet":"STP","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"merged":[[1,0,1,2]]}
[]
["Technical Criteria: Sewage Treatment Plant\n"]
["KPI'S","Proof to be Submitted","Weight "]
["Contractor must have atleast 5 years of proven work experience on sewage treatment plant operation","The Contractor must provide a Min of 3(Three) Reference/Contract Numbers /Testiminial letter of similar scope done previously indicating Period .",{"v":0.4,"d":"40%"}]
["Proven work experience on sequential batch reactors","Testiminial letter from atleast 2 plants",{"v":0.15,"d":"15%"}]
["Compliance to IRIS requirements from previous Sewage Treatment Plant contracts","A minimum of two(2) IRIS annual assessments by DWS, signed Waste water risk abatement plan & Incident management Protocol, Proof of compliance programme",{"v":0.05,"d":"5%"}]
["The Contractor must have a SANAS accredited Laboratory to carry out both micro & chemical analysis as stated in the General Authorization","ISO 17025 SANAS Accreditation Letter for all method listed in the GA",{"v":0.1,"d":"10%"}]
["The contractor must have proven experience to establish and operate the micro laboratory","Recommendation Letters from previous clients ",{"v":0.05,"d":"5%"}]
["Plant supervisor must be registered in the IRIS system ,atleast be classisified as class V or proof provided of planned training to boost the classification","Certified certificate or qualifications",{"v":0.15,"d":"15%"}]
["Plant operators must be registered in the IRIS system, atleast be classisified as class II or proof provided of planned training to boost the classification","Certified certificate or qualifications ",{"v":0.1,"d":"10%"}]
[]
["Threshold = 85%"]

{"sheet":"WTP","index":1,"n_rows":11,"n_cols":7,"rows_kept":11,"hidden":true}
[]
[{"$nulls":3},"Scoring",null,"Actual Score","Final Score"]
["KPI'S","Proof to be Submitted","Weight ",0,100]
["A qualified Plant Chemist or Chemical Engineer with a minimum; BSc Chem/BEng Chemical as a minimum qulification, with atleast seven years(7) of experience in Power Plant Chemistry environment as a key person on the contract","CV and proof of academic qualification(s)",{"v":0.4,"d":"40%"}]
["The key person must have a proven experience on commissioning, decommisioning, and operation of the following systems; Ultra filtration, Reverse osmosis, Gas transfer membranes, Continuous Electrodeionisation, Pressure swing adsorption, Condensate polishing plant, Cycle chemistry, Cooling water treatment, and Sewage treatment plant ","Testiminial letter from A min of 2 plants",{"v":0.4,"d":"40%"}]
["The key person must have experience in providing theoretical and on job training in Power Plant Chemistry systems outlined point number three above","Training provision experience report",{"v":0.1,"d":"10%"}]
["Plant technicians must have a minimum of Dipl. in Chemistry or Chemical Engineering, and atleast two years of experience in the Power Plant Chemistry Environment","CV and proof of academic qualification(s)",{"v":0.1,"d":"10%"}]
[]
["Threshold = 75%"]
[0,"Not Met"]
[100,"Did Meet"]

{"sheet":"Bulk chem","index":2,"n_rows":12,"n_cols":8,"rows_kept":12,"hidden":true,"merged":[[1,3,1,5],[1,6,2,6],[1,7,2,7]]}
[]
[{"$nulls":3},"Scoring",null,null,"Actual Score","Final Score"]
["KPI'S","Proof to be Submitted","Weight ",0,50,100]
["Chemical Manufacturer  IS0 9001 Accredited and ISO 14001 Certified /Accredited ","Certified certificate copies",{"v":0.45,"d":"45%"},"Nothing Submitted","ISO 9001 Accredited","ISO 9001 And 14001 Accredited "]
["Chemical Supplier must be IS0 14001 Accredited/Certified ","Certified certificate copies",{"v":0.2,"d":"20%"},"Nothing Submitted","ISO 14001 Certified ","ISO 14001 Accredited"]
["The supplier must have at least five years of Eskom power station related experience on the supply of bulk and semi bulk chemicals.","The Supplier must provide a Min of 3(Three) Reference/Contract Numbers /Testiminial letter of similar scope done previously indicating Period .",{"v":0.2,"d":"20%"},"NO References","Submitted CV with 2 Reference letters","The Supplier provided a Min of 3(Three) Reference/Contract Numbers /Testiminial letter of similar scope done previously indicating Period ."]
["99.9% On-time deliveries","Certified history of delivery data ,Customer Surveys and/or recommendation letter (letter to reflect on-time delivery customer experience)",{"v":0.05,"d":"5%"},"Nothing submited ","2 Customer Survey submitted ","3 or more customer survey submitted reflecting on time deliveries"]
["0% chemical delivery return rate (due to poor chemical quality specification)","Return certificates and list of all previous and current customers and their contact details",{"v":0.05,"d":"5%"},"List not submitted ","Provided 2 customers details indicating zero percentage poor chemical quality","Provided 3 or more Previous customers details indicating zero percentage poor chemical quality"]
["100% order and invoicing accuracy","A package of history of invoicing data including COAs and list of all previous and current customers and their contact details",{"v":0.05,"d":"5%"},"List not submitted ","Package history  with 2 previous customers details ","Package history with 3 or more Previous customers details "]
[]
[]
["Threshold = 80%"]