{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Introduction","Gate Keepers","Technical Evaluation Criteria","TET 1"," TET 2.","TET 2","TET 3","Final Technical Score"],"not_rendered":{"images":1,"defined_names":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":49,"n_cols":4,"rows_kept":49,"merged":[[0,0,2,2],[0,3,2,8],[4,0,4,8],[6,0,9,8],[11,0,11,8],[12,0,14,8],[16,0,17,8],[19,0,20,8],[22,0,23,8],[25,0,26,8],[28,0,29,8],[33,0,34,8],[36,0,36,8],[38,0,39,8],[41,0,43,8],[45,0,46,8],[48,0,49,3],[48,4,49,8]]}
[{"$nulls":3},"Medupi Power Station Sootblowing Tender Technical Evaluation "]
[]
[]
[]
["Introduction"]
[]
["Accurate oxygen measurement assists in achieving efficient combustion in the boiler and also determining the leakage across the GAH. Oxygen content in the exhaust flue gases from the boiler combustion process varies in the duct cross-section due to the effect of stratification creating lower and higher oxygen regions resulting in poor online measurement of oxygen. \n\nOxygen concentration at boiler loads more than 38% BMCR shall not be less than 2.5% nor more than 9% as per FFFR 3.3.4 section (b). Lower oxygen content results in high concentration of Carbon Monoxide and possible flame instability in the furnace whereas higher oxygen concentration may result in high boiler tubes erosion and dilution of oxygen content and flue gas temperature which in turn affects the downstream plants such as the PJFF, GAH and the ID fans.\n\nThus having an accurate and reliable measuring instruments across the duct reduces the error caused by the stratification when measuring oxygen concentration, offering a better representation of a reliable combustion performance."]
[]
[]
[]
[]
["Contents"]
["1. Gate Keepers - The mandatory requirements which must be met by the tenderer, failure of which will deem the tenderer incompetent in terms of the tender technical evaluation."]
[]
[]
[]
["2. Technical Evaluation Criteria - The qualitative requirements of the tenderer in terms of the technical evaluation catagorised with specified weighting."]
[]
[]
["3. Technical Evaluation Team (TET) Members - A multi-disciplinary team appointed to score the tenderer on the technical evaluation criteria."]
[]
[]
["4. TET 1 - Technical Evaluation Team Member 1 - System Engineer for the Oxygen Analysers at Medupi Power Station"]
[]
[]
["5. TET 2 - Technical Evaluation Team Member 2 - Maintenance Supervisor for Oxygen Analysers at Medupi Power Station"]
[]
[]
["6. TET 3 - Technical Evaluation Team Member 3 - Senior Advisor Maintenance Support at Medupi Power Station"]
[]
[]
[]
[]
["8. Final Technical Score - The calculated final technical score of the tenderer where the tenderer will be deemed competent or incompetent in terms of the tender technical evaluation."]
[]
[]
["Tender Technical Evaluation"]
[]
["1. The gate keepers of the tenderer must be completed first. Once the tenderer is deemed competent in terms of the gate keepers, the tender technical evaluation may proceed."]
[]
[]
["2. Each TET member fills in their details in the 'TET Members' tab and proceeds to complete their evaluation as per the technical evaluation criteria for their specified TET number, System Engineer will populate TET 1, etc."]
[]
[]
[]
["3. The final technical score is calculated and the tenderer will be deemed competent in terms of the tender technical evaluation if a final score of 4 or above is achieved."]
[]
[]
["Tenderer to be evaluated:"]

{"sheet":"Gate Keepers","index":1,"n_rows":8,"n_cols":15,"rows_kept":8,"merged":[[0,0,0,15],[1,0,2,6],[1,7,2,13],[1,14,2,15],[3,0,5,6],[3,7,5,13],[3,14,5,15],[6,0,6,6],[6,7,6,13],[6,14,6,15],[7,13,12,15]]}
["To evaluate the tenderer for competency of the gate keepers in terms of the tender technical evaluation, insert either a 1 for component if the tenderer meets the specific criteria, or insert a 0 if the tenderer does not meet the criteria. "]
["Mandatory Technical Criteria Description",{"$nulls":6},"Reference to Technical Specification / Tender Returnable",{"$nulls":6},"Competent = 1\nIncompetent = 0"]
[]
["Completed technical evaluation sheet by the service provider with specific reference for all the scores",{"$nulls":6},"Proof of completed technical evaluation.",{"$nulls":6},1]
[]
[]
[{"$nulls":7},"Competency = ",{"$nulls":6},{"$f":"IF(O4=1,\"Competent\",\"Not Competent\")","v":"Competent"}]
[{"$nulls":13},{"$f":"IF(O7=\"Compotent\",\"The tenderer has met the requirements of the gate keepers. The tender technical evaluation may proceed.\",IF(O7=\"Incompotent\",\"The tenderer has not met the gate keeper requirements. The tender technical evaluation process is terminated.\",\"Input required\"))","v":"Input required"}]

{"sheet":"Technical Evaluation Criteria","index":2,"n_rows":53,"n_cols":9,"rows_kept":53,"merged":[[0,0,2,9],[3,0,3,9],[4,0,4,7],[4,8,4,9],[5,0,5,5],[5,8,5,9],[6,0,6,9],[7,1,10,7],[7,8,10,9],[11,1,14,7],[11,8,14,9],[15,1,18,7],[15,8,18,9],[19,0,19,9],[20,0,20,5],[20,6,20,7],[20,8,20,9],[21,0,21,9],[22,1,22,7],[22,8,22,9],[23,0,23,9],[24,0,24,5],[24,6,24,7],[24,8,24,9],[25,0,26,9],[27,1,28,7],[27,8,28,9],[29,0,29,9],[30,0,30,5],[30,6,30,7],[30,8,30,9],[31,0,32,9],[33,1,34,7],[33,8,34,9],[35,1,35,7],[35,8,35,9],[36,1,36,7],[36,8,36,9],[37,1,37,7],[37,8,37,9],[38,1,38,7],[38,8,38,9],[39,0,39,9],[40,0,40,5],[40,6,40,7],[40,8,40,9],[41,0,41,9],[42,1,42,7],[42,8,42,9],[43,1,43,7],[43,8,43,9],[44,0,44,9],[45,0,45,5],[45,6,45,7],[45,8,45,9],[46,0,46,9],[47,1,47,7],[47,8,47,9],[48,0,48,9],[49,0,49,5],[49,6,49,7],[49,8,49,9],[50,0,50,9],[51,1,51,7],[51,8,51,9],[52,1,52,7],[52,8,52,9]]}
["The technical evaluation criteria against which the qualitative competency of the tenderer will be scored. Each main criterion has a weighting towards the final technical score calculation. Each sub-criteria has a weighting towards the calculation of the main criterion. "]
[]
[]
["Technical Evaluation Criteria"]
["Technical Criteria Description",{"$nulls":7},"Sub-criteria weighting (%)"]
["1.  Company Profile",{"$nulls":5},"Weighting  =",null,{"v":0.2,"d":"20%"}]
["General measure in line with the Works instruction scope of work"]
["1.1 ","The tenderer submits a company profile that is current and detailed to be in line with the Works. An organogram is included, demonstrating how the organisational structure and chain of command supports the requirements of the scope of work.",{"$nulls":6},{"v":0.25,"d":"25%"}]
[]
[]
[]
["1.2","The Service Provider must have a risk identification and management process related to the complete process of installation & maintenance of O2 analysers and its components. The risk identification and management process must be in line with the works.",{"$nulls":6},{"v":0.3,"d":"30%"}]
[]
[]
[]
["1.3","The Service Provider must have a method statement that indicates how the installation activities will be carried out, what resources will be required and what measures will be put in place to execute the task. The method and activities must be in line with the works.",{"$nulls":6},{"v":0.45,"d":"45%"}]
[]
[]
[]
["Company Profile Score:"]
["2. Experience",{"$nulls":5},"Weighting  =",null,{"v":0.1,"d":"10%"}]
["Reference list of Purchase/Task Orders completed of previous similar work."]
["2.1","The service provider needs to have done similar work in the industry. A traceable record (Orders, contracts etc.) is required.",{"$nulls":6},{"v":1,"d":"100%"}]
["Experience:"]
["3.  Quality Control Plans",{"$nulls":5},"Weighting  =",null,{"v":0.05,"d":"5%"}]
["Example of completed QCP of previous similar work."]
[]
["3.1","The Service Provider submits a draft Quality Control Plan in line with the Works instruction scope of work",{"$nulls":6},{"v":1,"d":"100%"}]
[]
["Quality Control Plans: "]
["4.  Key Personnel",{"$nulls":5},"Weighting  =",null,{"v":0.4,"d":"40%"}]
["Key resources CV containing qualification and proof of similar work conducted on a power station or similar work environment as well as a reference list."]
[]
["4.1","Site Manager – well experienced in analytic instruments or O2 analysers works on a power station or similar work environment for a period of at least 5 years in a managerial position; minimum qualification of N6 Process Instrumentation/Electronic Engineering; two contactable references provided.",{"$nulls":6},{"v":0.25,"d":"25%"}]
[]
["4.2","Supervisor – well experienced in analytic instruments or O2 analysers works on a power station or similar work environment for a period of at least 5 years in a supervisory position; minimum qualification of N6 Process Instrumentation/Electronic Engineering and Trade Test Certificate; two contactable references provided. (2 or more)",{"$nulls":6},{"v":0.25,"d":"25%"}]
["4.3","Quality Controller – well experienced in quality control of O2 analyser works with at least 2 years experience.",{"$nulls":6},{"v":0.15,"d":"15%"}]
["4.4","Artisans – has had previous experience with O2 analysers on a power station or similar work environment for at least 2 years; minimum qualification of N3 Process InstrumentatioProcess Instrumentation/Electronic Engineering and Trade Test Certificate; qualifications and experience provided for at least 3 artisans.",{"$nulls":6},{"v":0.1,"d":"10%"}]
["4.5","SHE Officer – has had previous experience in line with the scope of work; minimum NQF Level 4 and SAMTRAC/SHEMTRAC certificate; valid registration as a candidate or professional with an OHS professional body such as SIOSH, SAIOH or SACPMP.",{"$nulls":6},{"v":0.25,"d":"25%"}]
["Key Personnel: "]
["5. Training",{"$nulls":5},"Weighting  =",null,{"v":0.1,"d":"10%"}]
["Training and Development"]
["5.1","Does the Service Provider have Responsible Persons in terms of PSR",{"$nulls":6},{"v":0.5,"d":"50%"}]
["5.1","The service provider must have a O2 analyser maintenance specific training program that includes safety, task method, quality management and describes tasks and sub tasks. Proof of training completed must be recorded for each employee and indicated on the personnel database.",{"$nulls":6},{"v":0.5,"d":"50%"}]
["Training: "]
["6. Tools and Equipment",{"$nulls":5},"Weighting  =",null,{"v":0.1,"d":"10%"}]
["Asset List (Tools and Equipment)"]
["6.1","The service provider has an asset list describing the tools and equipment it has available to carry out the required installation work.",{"$nulls":6},{"v":1,"d":"100%"}]
["Tools and Equipment:"]
["7. Guarantee",{"$nulls":5},"Weighting  =",null,{"v":0.05,"d":"5%"}]
["Works gaurantee"]
["7.1","The Service Provider guarantee for a minimum of 52 weeks or as specified in the specific enquiry for the quality of the installation work carried out.",{"$nulls":6},{"v":0.5,"d":"50%"}]
["7.2","The Service Provider guarantee any product or spare component it supplies, for a minimum of 52 weeks or as specified in the specific enquiry.",{"$nulls":6},{"v":0.5,"d":"50%"}]

{"sheet":"TET 1","index":3,"n_rows":57,"n_cols":13,"rows_kept":57,"merged":[[0,0,0,2],[0,3,0,7],[0,10,4,10],[0,11,4,11],[0,12,4,12],[1,0,1,2],[1,3,1,5],[2,1,3,5],[5,0,5,9],[5,10,6,10],[5,11,6,11],[5,12,6,12],[6,0,6,7],[6,8,6,9],[7,0,7,5],[7,8,7,9],[8,0,8,9],[9,1,12,7],[9,8,12,9],[9,10,12,10],[9,11,12,11],[9,12,12,12],[13,1,16,7],[13,8,16,9],[13,10,16,10],[13,11,16,11],[13,12,16,12],[17,1,20,7],[17,8,20,9],[17,10,20,10],[17,11,20,11],[17,12,20,12],[21,0,21,9],[22,0,22,5],[22,6,22,7],[22,8,22,9],[23,0,23,9],[24,1,24,7],[24,8,24,9],[25,0,25,9],[26,0,26,5],[26,6,26,7],[26,8,26,9],[27,0,28,9],[27,10,28,10],[27,11,28,11],[27,12,28,12],[29,1,30,7],[29,8,30,9],[29,10,30,10],[29,11,30,11],[29,12,30,12],[31,0,31,9],[32,0,32,5],[32,6,32,7],[32,8,32,9],[33,0,34,9],[33,10,34,10],[33,11,34,11],[33,12,34,12],[35,1,36,7],[35,8,36,9],[35,10,36,10],[35,11,36,11],[35,12,36,12],[37,1,37,7],[37,8,37,9],[38,1,38,7],[38,8,38,9],[39,1,39,7],[39,8,39,9],[40,1,40,7],[40,8,40,9],[41,0,41,9],[42,0,42,5],[42,6,42,7],[42,8,42,9],[42,16,43,22],[42,23,43,24],[42,25,43,25],[42,26,43,26],[42,27,43,27],[43,0,43,9],[44,1,44,7],[44,8,44,9],[45,1,45,7],[45,8,45,9],[46,0,46,9],[47,0,47,5],[47,6,47,7],[47,8,47,9],[48,0,48,9],[49,1,49,7],[49,8,49,9],[50,0,50,9],[51,0,51,5],[51,6,51,7],[51,8,51,9],[52,0,52,9],[53,1,53,7],[53,8,53,9],[54,1,54,7],[54,8,54,9],[55,0,55,9],[56,0,57,9],[56,10,57,10],[56,11,57,11]]}
["TET 1 Name and Surname:",null,null,{"$f":"LEFT(#REF!,LEN(#REF!))","v":{"$error":"#REF!"}},{"$nulls":6},"Use this column to complete the technical evaluation.The scores entered will be used to calculate the final technical calculation.","Provide specific file with proper indexing for your evaluation","Use guidelines / notes in this column to score in column K."]
["Date of Evaluation:",null,null,{"$f":"TODAY()","v":"2023-04-03"}]
[]
["Signature:"]
[]
["Technical Evaluation Criteria",{"$nulls":9},"TET 1 Evaluation Scores","File referance for the score","Guideline / Notes"]
["Technical Criteria Description",{"$nulls":7},"Sub-criteria weighting (%)"]
["1.  Company Profile",{"$nulls":5},"Weighting  =",null,{"v":0.2,"d":"20%"},null,{"$f":"K22*I8","v":0}]
["General measure in line with the Works instruction scope of work"]
["1.1 ","The tenderer submits a company profile that is current and detailed to be in line with the Works. An organogram is included, demonstrating how the organisational structure and chain of command supports the requirements of the scope of work.",{"$nulls":6},{"v":0.25,"d":"25%"},{"$nulls":3},"Scoring:\n5 - Full organogram submitted indicating chain of command, including Site Manager, Supervisor, Quality Controller, Electrical Artisans and SHE officer with an explanation of the role of each personnel.\n4 - Organogram submitted with no detail for the role of each personnel.\n2 - Organogram submitted with no detail for the role of each personnel and required personnel omitted.\n1 - Personnel listed with no indication of organisational structure."]
[]
[]
[]
["1.2","The Service Provider must have a risk identification and management process related to the complete process of installation & maintenance of O2 analysers and its components. The risk identification and management process must be in line with the works.",{"$nulls":6},{"v":0.3,"d":"30%"},{"$nulls":3},"Scoring:\n5 - Detail list of risk areas identified with action plan to mitigate them.\n4 - List of risk areas identified with action plan.\n2 - List of risk areas identified and no action plan.\n1 - No list of risk areas identified and no action plan"]
[]
[]
[]
["1.3","The Service Provider must have a method statement that indicates how the installation activities will be carried out, what resources will be required and what measures will be put in place to execute the task. The method and activities must be in line with the works.",{"$nulls":6},{"v":0.45,"d":"45%"},{"$nulls":3},"Scoring:\n5 - Method statement with measures and resources for installation activities.\n4 - Method statement with measures but no resources for installation activities.\n2 - Method statement with no measures and no resources for installation activities.\n1 - No method statement, measures and resources for installation activities"]
[]
[]
[]
["Company Profile Score:"]
["2. Experience",{"$nulls":5},"Weighting  =",null,{"v":0.1,"d":"10%"},null,{"$f":"K26*I23","v":0}]
["Reference list of Purchase/Task Orders completed of previous similar work."]
["2.1","The service provider needs to have done similar work in the industry. A traceable record (Orders, contracts etc.) is required.",{"$nulls":6},{"v":1,"d":"100%"},{"$nulls":3},"5 - A reference list with 3 or more completed Purchase/Task Orders provided.\n4 - A reference list with 2 completed Purchase/Task Orders provided.\n2 - A reference list with 1 completed Purchase/Task Orders provided.\n1 - No reference of completed Purchase/Task Orders provided."]
["Experience:"]
["3.  Quality Control Plans",{"$nulls":5},"Weighting  =",null,{"v":0.05,"d":"5%"},null,{"$f":"K32*I27","v":0}]
["Example of completed QCP of previous similar work."]
[]
["3.1","The Service Provider submits a draft Quality Control Plan in line with the Works instruction scope of work",{"$nulls":6},{"v":1,"d":"100%"},{"$nulls":3},"5 - QCP layout submitted including all scope of work items, Eskom intervention points and sign-off.\n4 - Some scope of work items and some Eskom intervention points omitted.\n2 - Many scope of work items and many Eskom intervention points omitted.\n1 - No QCP layout submitted."]
[]
["Quality Control Plans: "]
["4.  Key Personnel",{"$nulls":5},"Weighting  =",null,{"v":0.4,"d":"40%"},null,{"$f":"K42*I33","v":0}]
["Key resources CV containing qualification and proof of similar work conducted on a power station or similar work environment as well as a reference list."]
[]
["4.1","Site Manager – well experienced in analytic instruments or O2 analysers works on a power station or similar work environment for a period of at least 5 years in a managerial position; minimum qualification of N6 Process Instrumentation/Electronic Engineering; two contactable references provided.",{"$nulls":6},{"v":0.25,"d":"25%"},{"$nulls":3},"5 - 5 years or more experience in O2 analyser works on a power station or similar work environment; N6 Electrical Engineering qualification or higher; two contactable references provided.\n4 - 3 years or more experience in O2 analyser works on a power station or similar work environment; N6 Electrical Engineering qualification or higher; two contactable references provided.\n2 - Less than 3 years experience in O2 analyser works on a power station or similar work environment; N6 Electrical Engineering qualification; no contactable references provided.\n1 - No experience in O2 analyser works on a power station or similar work environment; no N6 Electrical Engineering qualification or higher; no contactable references provided."]
[]
["4.2","Supervisor – well experienced in analytic instruments or O2 analysers works on a power station or similar work environment for a period of at least 5 years in a supervisory position; minimum qualification of N6 Process Instrumentation/Electronic Engineering and Trade Test Certificate; two contactable references provided. (2 or more)",{"$nulls":6},{"v":0.25,"d":"25%"},{"$nulls":3},"5 - 5 years or more experience in O2 analyser works on a power station or similar work environment; N6 Electrical Engineering qualification or higher; Trade Test Certificate provided;two contactable references provided.\n4 - 3 years or more experience in O2 analyser works on a power station or similar work environment; N6 Electrical Engineering qualification or higher;Trade Test Certificate provided; two contactable references provided.\n2 - Less than 3 years experience in O2 analyser works on a power station or similar work environment; N6 Electrical Engineering qualification; Trade Test Certificate provided; no contactable references provided.\n1 - No experience in O2 analyser works on a power station or similar work environment; no N6 Electrical Engineering qualification or higher; no Trade Test Certificate provided; no contactable references provided."]
["4.3","Quality Controller – well experienced in quality control of O2 analyser works with at least 2 years experience.",{"$nulls":6},{"v":0.15,"d":"15%"},{"$nulls":3},"5 - 2 years or more experience in quality control of O2 analyser works on a power station or similar work environment; \n4 - less than 2 years experience in quality control of O2 analyser  works on a power station or similar work environment; \n2 - 2 years or more experience in quality control of O2 analyser  works on a power station or similar work environment; \n1 - less than 2 years experience in quality control of O2 analyser  works on a power station or similar work environment; "]
["4.4","Artisans – has had previous experience with O2 analysers on a power station or similar work environment for at least 2 years; minimum qualification of N3 Process InstrumentatioProcess Instrumentation/Electronic Engineering and Trade Test Certificate; qualifications and experience provided for at least 3 artisans.",{"$nulls":6},{"v":0.1,"d":"10%"},{"$nulls":3},"5 - 3 years or more experience in O2 analyser works on a power station or similar work environment; N3 Electrical Engineering qualification or higher; Trade Test Certificate provided;two contactable references provided.\n4 - 2 years or more experience in O2 analyser works on a power station or similar work environment; N3 Electrical Engineering qualification or higher;Trade Test Certificate provided; two contactable references provided.\n2 - Less than 2 years experience in O2 analyser works on a power station or similar work environment; N3 Electrical Engineering qualification; Trade Test Certificate provided; no contactable references provided.\n1 - No experience in O2 analyser works on a power station or similar work environment; no N3 Electrical Engineering qualification or higher; no Trade Test Certificate provided; no contactable references provided."]
["4.5","SHE Officer – has had previous experience in line with the scope of work; minimum NQF Level 4 and SAMTRAC/SHEMTRAC certificate; valid registration as a candidate or professional with an OHS professional body such as SIOSH, SAIOH or SACPMP.",{"$nulls":6},{"v":0.25,"d":"25%"},{"$nulls":3},"5 - proof of similar work conducted; NQF Level 4 and SAMTRAC/SHEMTRAC certified; registered as a professional with an OHS professional body.\n4 - proof of similar work conducted; NQF Level 4 and SAMTRAC/SHEMTRAC certified; registered as a candidate with an OHS professional body.\n2 - no proof of similar work conducted; NQF Level 4 and SAMTRAC/SHEMTRAC certified; registered as a candidate with an OHS professional body.\n1 - no proof of similar work conducted; NQF Level 4 and SAMTRAC/SHEMTRAC certified; not registered with an OHS professional body."]
["Key Personnel: ",{"$nulls":9},{"$f":"K36*I36+K38*I38+K39*I39+K40*I40+K41*I41","v":0}]
["5. Training",{"$nulls":5},"Weighting  =",null,{"v":0.1,"d":"10%"},null,{"$f":"K47*I43","v":0}]
["Training and Development"]
["5.1","Does the Service Provider have Responsible Persons in terms of PSR",{"$nulls":6},{"v":0.5,"d":"50%"},{"$nulls":3},"5 - 3 RP\n4 - 2 RP\n2 - 1 RP\n1 - no RP"]
["5.1","The service provider must have a O2 analyser specific training program that includes safety, task method, quality management and describes tasks and sub tasks. Proof of training completed must be recorded for each employee and indicated on the personnel database.",{"$nulls":6},{"v":0.5,"d":"50%"},{"$nulls":3},"5 - Training program that includes safety; task method; quality control and  have database for trainees\n4 - Training program that includes safety; task method; quality control; no database for trainees                                                                                                                                                                                                                                                                                          2 - Training program that includes safety; task method; no quality control; no database for trainees\n1 - Training program that includes safety; no task method; no quality control; no database for trainees"]
["Training: ",{"$nulls":9},{"$f":"K45*I45+K46*I46","v":0}]
["6. Tools and Equipment",{"$nulls":5},"Weighting  =",null,{"v":0.1,"d":"10%"},null,{"$f":"K51*I48","v":0}]
["Asset List (Tools and Equipment)"]
["6.1","The service provider has an asset list describing the tools and equipment it has available to carry out the required installation work.",{"$nulls":6},{"v":1,"d":"100%"},{"$nulls":3},"5 - Tool list for 0.9m and 1.8m probes, analyser with local display, cell, temperature sensor, filter\n4 - Tool list for 0.9m and 1.8m probes, analyser with local display, cell, temperature sensor, without filter\n2 - Tool list for 0.9m and 1.8m probes, analyser without local display, cell, temperature sensor, without filter \n1 - No Tool list"]
["Tools and Equipment:",{"$nulls":9},{"$f":"K50*I50","v":0}]
["7. Guarantee",{"$nulls":5},"Weighting  =",null,{"v":0.05,"d":"5%"},null,{"$f":"K56*I52","v":0}]
["Works gaurantee"]
["7.1","The Service Provider guarantee for a minimum of 52 weeks or as specified in the specific enquiry for the quality of the maintenance work carried out.",{"$nulls":6},{"v":0.5,"d":"50%"},{"$nulls":3},"5 - Letter indicating 100% refund for failures within 52 weeks after maintenance work \n4 - Letter indicating 100% refund for failures within 52 weeks with conditions specified on the tender                                                                                                                                                                                                                                                                                          2 - Letter indicating refund policy based on investigation by both employer and service provider for failures within 52 weeks \n1 - Letter indicating 0% refund for failures within 52 weeks"]
["7.2","The Service Provider guarantee any product or spare component it supplies, for a minimum of 52 weeks or as specified in the specific enquiry.",{"$nulls":6},{"v":0.5,"d":"50%"},{"$nulls":3},"5 - Letter indicating 100% refund for failures within 52 weeks \n4 - Letter indicating 100% refund for failures within 52 weeks with conditions specified on the tender                                                                                                                                                                                                                                                                                          2 -  Letter indicating refund policy based on investigation by both employer and service provider for failures within 52 weeks after spares supplied\n1 - Letter indicating 0% refund for failures within 52 weeks"]
["Garantee:"]
["Final score for TET 1:",{"$nulls":9},{"$f":"SUM(K8,K23,K27,K33,K43,K48,K52)","v":0}]

{"sheet":" TET 2.","index":4,"n_rows":57,"n_cols":13,"rows_kept":57,"hidden":true,"merged":[[0,0,0,2],[0,3,0,7],[0,10,4,10],[0,11,4,11],[0,12,4,12],[1,0,1,2],[1,3,1,5],[2,1,3,5],[5,0,5,9],[5,10,6,10],[5,11,6,11],[5,12,6,12],[6,0,6,7],[6,8,6,9],[7,0,7,5],[7,8,7,9],[8,0,8,9],[9,1,12,7],[9,8,12,9],[9,10,12,10],[9,11,12,11],[9,12,12,12],[13,1,16,7],[13,8,16,9],[13,10,16,10],[13,11,16,11],[13,12,16,12],[17,1,20,7],[17,8,20,9],[17,10,20,10],[17,11,20,11],[17,12,20,12],[21,0,21,9],[22,0,22,5],[22,6,22,7],[22,8,22,9],[23,0,23,9],[24,1,24,7],[24,8,24,9],[25,0,25,9],[26,0,26,5],[26,6,26,7],[26,8,26,9],[27,0,28,9],[27,10,28,10],[27,11,28,11],[27,12,28,12],[29,1,30,7],[29,8,30,9],[29,10,30,10],[29,11,30,11],[29,12,30,12],[31,0,31,9],[32,0,32,5],[32,6,32,7],[32,8,32,9],[33,0,34,9],[33,10,34,10],[33,11,34,11],[33,12,34,12],[35,1,36,7],[35,8,36,9],[35,10,36,10],[35,11,36,11],[35,12,36,12],[37,1,37,7],[37,8,37,9],[38,1,38,7],[38,8,38,9],[39,1,39,7],[39,8,39,9],[40,1,40,7],[40,8,40,9],[41,0,41,9],[42,0,42,5],[42,6,42,7],[42,8,42,9],[42,16,43,22],[42,23,43,24],[42,25,43,25],[42,26,43,26],[42,27,43,27],[43,0,43,9],[44,1,44,7],[44,8,44,9],[45,1,45,7],[45,8,45,9],[46,0,46,9],[47,0,47,5],[47,6,47,7],[47,8,47,9],[48,0,48,9],[49,1,49,7],[49,8,49,9],[50,0,50,9],[51,0,51,5],[51,6,51,7],[51,8,51,9],[52,0,52,9],[53,1,53,7],[53,8,53,9],[54,1,54,7],[54,8,54,9],[55,0,55,9],[56,0,57,9],[56,10,57,10],[56,11,57,11]]}
["TET 1 Name and Surname:",null,null,{"$f":"LEFT(#REF!,LEN(#REF!))","v":{"$error":"#REF!"}},{"$nulls":6},"Use this column to complete the technical evaluation.The scores entered will be used to calculate the final technical calculation.","Provide specific file with proper indexing for your evaluation","Use guidelines / notes in this column to score in column K."]
["Date of Evaluation:",null,null,{"$f":"TODAY()","v":"2023-04-03"}]
[]
["Signature:"]
[]
["Technical Evaluation Criteria",{"$nulls":9},"TET 1 Evaluation Scores","File referance for the score","Guideline / Notes"]
["Technical Criteria Description",{"$nulls":7},"Sub-criteria weighting (%)"]
["1.  Company Profile",{"$nulls":5},"Weighting  =",null,{"v":0.2,"d":"20%"},null,{"$f":"K22*I8","v":1}]
["General measure in line with the Works instruction scope of work"]
["1.1 ","The tenderer submits a company profile that is current and detailed to be in line with the Works. An organogram is included, demonstrating how the organisational structure and chain of command supports the requirements of the scope of work.",{"$nulls":6},{"v":0.25,"d":"25%"},null,5,null,"Scoring:\n5 - Full organogram submitted indicating chain of command, including Site Manager, Supervisor, Quality Controller, Electrical Artisans and SHE officer with an explanation of the role of each personnel.\n4 - Organogram submitted with no detail for the role of each personnel.\n2 - Organogram submitted with no detail for the role of each personnel and required personnel omitted.\n1 - Personnel listed with no indication of organisational structure."]
[]
[]
[]
["1.2","The Service Provider must have a risk identification and management process related to the complete process of installation & maintenance of O2 analysers and its components. The risk identification and management process must be in line with the works.",{"$nulls":6},{"v":0.3,"d":"30%"},null,5,null,"Scoring:\n5 - Detail list of risk areas identified with action plan to mitigate them.\n4 - List of risk areas identified with action plan.\n2 - List of risk areas identified and no action plan.\n1 - No list of risk areas identified and no action plan"]
[]
[]
[]
["1.3","The Service Provider must have a method statement that indicates how the installation activities will be carried out, what resources will be required and what measures will be put in place to execute the task. The method and activities must be in line with the works.",{"$nulls":6},{"v":0.45,"d":"45%"},null,5,null,"Scoring:\n5 - Method statement with measures and resources for installation activities.\n4 - Method statement with measures but no resources for installation activities.\n2 - Method statement with no measures and no resources for installation activities.\n1 - No method statement, measures and resources for installation activities"]
[]
[]
[]
["Company Profile Score:",{"$nulls":9},{"$f":"(K10*I10+K14*I14+K18*I18)","v":5}]
["2. Experience",{"$nulls":5},"Weighting  =",null,{"v":0.1,"d":"10%"},null,{"$f":"K26*I23","v":0.5}]
["Reference list of Purchase/Task Orders completed of previous similar work."]
["2.1","The service provider needs to have done similar work in the industry. A traceable record (Orders, contracts etc.) is required.",{"$nulls":6},{"v":1,"d":"100%"},null,5,null,"5 - A reference list with 3 or more completed Purchase/Task Orders provided.\n4 - A reference list with 2 completed Purchase/Task Orders provided.\n2 - A reference list with 1 completed Purchase/Task Orders provided.\n1 - No reference of completed Purchase/Task Orders provided."]
["Experience:",{"$nulls":9},{"$f":"K25*I25","v":5}]
["3.  Quality Control Plans",{"$nulls":5},"Weighting  =",null,{"v":0.05,"d":"5%"},null,{"$f":"K32*I27","v":0.25}]
["Example of completed QCP of previous similar work."]
[]
["3.1","The Service Provider submits a draft Quality Control Plan in line with the Works instruction scope of work",{"$nulls":6},{"v":1,"d":"100%"},null,5,null,"5 - QCP layout submitted including all scope of work items, Eskom intervention points and sign-off.\n4 - Some scope of work items and some Eskom intervention points omitted.\n2 - Many scope of work items and many Eskom intervention points omitted.\n1 - No QCP layout submitted."]
[]
["Quality Control Plans: ",{"$nulls":9},{"$f":"K30*I30","v":5}]
["4.  Key Personnel",{"$nulls":5},"Weighting  =",null,{"v":0.4,"d":"40%"},null,{"$f":"K42*I33","v":2}]
["Key resources CV containing qualification and proof of similar work conducted on a power station or similar work environment as well as a reference list."]
[]
["4.1","Site Manager – well experienced in analytic instruments or O2 analysers works on a power station or similar work environment for a period of at least 5 years in a managerial position; minimum qualification of N6 Process Instrumentation/Electronic Engineering; two contactable references provided.",{"$nulls":6},{"v":0.25,"d":"25%"},null,5,null,"5 - 5 years or more experience in O2 analyser works on a power station or similar work environment; N6 Electrical Engineering qualification or higher; two contactable references provided.\n4 - 3 years or more experience in O2 analyser works on a power station or similar work environment; N6 Electrical Engineering qualification or higher; two contactable references provided.\n2 - Less than 3 years experience in O2 analyser works on a power station or similar work environment; N6 Electrical Engineering qualification; no contactable references provided.\n1 - No experience in O2 analyser works on a power station or similar work environment; no N6 Electrical Engineering qualification or higher; no contactable references provided."]
[]
["4.2","Supervisor – well experienced in analytic instruments or O2 analysers works on a power station or similar work environment for a period of at least 5 years in a supervisory position; minimum qualification of N6 Process Instrumentation/Electronic Engineering and Trade Test Certificate; two contactable references provided. (2 or more)",{"$nulls":6},{"v":0.25,"d":"25%"},null,5,null,"5 - 5 years or more experience in O2 analyser works on a power station or similar work environment; N6 Electrical Engineering qualification or higher; Trade Test Certificate provided;two contactable references provided.\n4 - 3 years or more experience in O2 analyser works on a power station or similar work environment; N6 Electrical Engineering qualification or higher;Trade Test Certificate provided; two contactable references provided.\n2 - Less than 3 years experience in O2 analyser works on a power station or similar work environment; N6 Electrical Engineering qualification; Trade Test Certificate provided; no contactable references provided.\n1 - No experience in O2 analyser works on a power station or similar work environment; no N6 Electrical Engineering qualification or higher; no Trade Test Certificate provided; no contactable references provided."]
["4.3","Quality Controller – well experienced in quality control of O2 analyser works with at least 2 years experience.",{"$nulls":6},{"v":0.15,"d":"15%"},null,5,null,"5 - 2 years or more experience in quality control of O2 analyser works on a power station or similar work environment; \n4 - less than 2 years experience in quality control of O2 analyser  works on a power station or similar work environment; \n2 - 2 years or more experience in quality control of O2 analyser  works on a power station or similar work environment; \n1 - less than 2 years experience in quality control of O2 analyser  works on a power station or similar work environment; "]
["4.4","Artisans – has had previous experience with O2 analysers on a power station or similar work environment for at least 2 years; minimum qualification of N3 Process InstrumentatioProcess Instrumentation/Electronic Engineering and Trade Test Certificate; qualifications and experience provided for at least 3 artisans.",{"$nulls":6},{"v":0.1,"d":"10%"},null,5,null,"5 - 3 years or more experience in O2 analyser works on a power station or similar work environment; N3 Electrical Engineering qualification or higher; Trade Test Certificate provided;two contactable references provided.\n4 - 2 years or more experience in O2 analyser works on a power station or similar work environment; N3 Electrical Engineering qualification or higher;Trade Test Certificate provided; two contactable references provided.\n2 - Less than 2 years experience in O2 analyser works on a power station or similar work environment; N3 Electrical Engineering qualification; Trade Test Certificate provided; no contactable references provided.\n1 - No experience in O2 analyser works on a power station or similar work environment; no N3 Electrical Engineering qualification or higher; no Trade Test Certificate provided; no contactable references provided."]
["4.5","SHE Officer – has had previous experience in line with the scope of work; minimum NQF Level 4 and SAMTRAC/SHEMTRAC certificate; valid registration as a candidate or professional with an OHS professional body such as SIOSH, SAIOH or SACPMP.",{"$nulls":6},{"v":0.25,"d":"25%"},null,5,null,"5 - proof of similar work conducted; NQF Level 4 and SAMTRAC/SHEMTRAC certified; registered as a professional with an OHS professional body.\n4 - proof of similar work conducted; NQF Level 4 and SAMTRAC/SHEMTRAC certified; registered as a candidate with an OHS professional body.\n2 - no proof of similar work conducted; NQF Level 4 and SAMTRAC/SHEMTRAC certified; registered as a candidate with an OHS professional body.\n1 - no proof of similar work conducted; NQF Level 4 and SAMTRAC/SHEMTRAC certified; not registered with an OHS professional body."]
["Key Personnel: ",{"$nulls":9},{"$f":"K36*I36+K38*I38+K39*I39+K40*I40+K41*I41","v":5}]
["5. Training",{"$nulls":5},"Weighting  =",null,{"v":0.1,"d":"10%"},null,{"$f":"K47*I43","v":0.5}]
["Training and Development"]
["5.1","Does the Service Provider have Responsible Persons in terms of PSR",{"$nulls":6},{"v":0.5,"d":"50%"},null,5,null,"5 - 3 RP\n4 - 2 RP\n2 - 1 RP\n1 - no RP"]
["5.1","The service provider must have a O2 analyser specific training program that includes safety, task method, quality management and describes tasks and sub tasks. Proof of training completed must be recorded for each employee and indicated on the personnel database.",{"$nulls":6},{"v":0.5,"d":"50%"},null,5,null,"5 - Training program that includes safety; task method; quality control and  have database for trainees\n4 - Training program that includes safety; task method; quality control; no database for trainees                                                                                                                                                                                                                                                                                          2 - Training program that includes safety; task method; no quality control; no database for trainees\n1 - Training program that includes safety; no task method; no quality control; no database for trainees"]
["Training: ",{"$nulls":9},{"$f":"K45*I45+K46*I46","v":5}]
["6. Tools and Equipment",{"$nulls":5},"Weighting  =",null,{"v":0.1,"d":"10%"},null,{"$f":"K51*I48","v":0.5}]
["Asset List (Tools and Equipment)"]
["6.1","The service provider has an asset list describing the tools and equipment it has available to carry out the required installation work.",{"$nulls":6},{"v":1,"d":"100%"},null,5,null,"5 - Tool list for 0.9m and 1.8m probes, analyser with local display, cell, temperature sensor, filter\n4 - Tool list for 0.9m and 1.8m probes, analyser with local display, cell, temperature sensor, without filter\n2 - Tool list for 0.9m and 1.8m probes, analyser without local display, cell, temperature sensor, without filter \n1 - No Tool list"]
["Tools and Equipment:",{"$nulls":9},{"$f":"K50*I50","v":5}]
["7. Guarantee",{"$nulls":5},"Weighting  =",null,{"v":0.05,"d":"5%"},null,{"$f":"K56*I52","v":0.25}]
["Works gaurantee"]
["7.1","The Service Provider guarantee for a minimum of 52 weeks or as specified in the specific enquiry for the quality of the maintenance work carried out.",{"$nulls":6},{"v":0.5,"d":"50%"},null,5,null,"5 - Letter indicating 100% refund for failures within 52 weeks after maintenance work \n4 - Letter indicating 100% refund for failures within 52 weeks with conditions specified on the tender                                                                                                                                                                                                                                                                                          2 - Letter indicating refund policy based on investigation by both employer and service provider for failures within 52 weeks \n1 - Letter indicating 0% refund for failures within 52 weeks"]
["7.2","The Service Provider guarantee any product or spare component it supplies, for a minimum of 52 weeks or as specified in the specific enquiry.",{"$nulls":6},{"v":0.5,"d":"50%"},null,5,null,"5 - Letter indicating 100% refund for failures within 52 weeks \n4 - Letter indicating 100% refund for failures within 52 weeks with conditions specified on the tender                                                                                                                                                                                                                                                                                          2 -  Letter indicating refund policy based on investigation by both employer and service provider for failures within 52 weeks after spares supplied\n1 - Letter indicating 0% refund for failures within 52 weeks"]
["Garantee:",{"$nulls":9},{"$f":"K54*I54+K55*I55","v":5}]
["Final score for TET 1:",{"$nulls":9},{"$f":"SUM(K8,K23,K27,K33,K43,K48,K52)","v":5}]

{"sheet":"TET 2","index":5,"n_rows":57,"n_cols":13,"rows_kept":57,"merged":[[0,0,0,2],[0,3,0,7],[0,10,4,10],[0,11,4,11],[0,12,4,12],[1,0,1,2],[1,3,1,5],[2,1,3,5],[5,0,5,9],[5,10,6,10],[5,11,6,11],[5,12,6,12],[6,0,6,7],[6,8,6,9],[7,0,7,5],[7,8,7,9],[8,0,8,9],[9,1,12,7],[9,8,12,9],[9,10,12,10],[9,11,12,11],[9,12,12,12],[13,1,16,7],[13,8,16,9],[13,10,16,10],[13,11,16,11],[13,12,16,12],[17,1,20,7],[17,8,20,9],[17,10,20,10],[17,11,20,11],[17,12,20,12],[21,0,21,9],[22,0,22,5],[22,6,22,7],[22,8,22,9],[23,0,23,9],[24,1,24,7],[24,8,24,9],[25,0,25,9],[26,0,26,5],[26,6,26,7],[26,8,26,9],[27,0,28,9],[27,10,28,10],[27,11,28,11],[27,12,28,12],[29,1,30,7],[29,8,30,9],[29,10,30,10],[29,11,30,11],[29,12,30,12],[31,0,31,9],[32,0,32,5],[32,6,32,7],[32,8,32,9],[33,0,34,9],[33,10,34,10],[33,11,34,11],[33,12,34,12],[35,1,36,7],[35,8,36,9],[35,10,36,10],[35,11,36,11],[35,12,36,12],[37,1,37,7],[37,8,37,9],[38,1,38,7],[38,8,38,9],[39,1,39,7],[39,8,39,9],[40,1,40,7],[40,8,40,9],[41,0,41,9],[42,0,42,5],[42,6,42,7],[42,8,42,9],[42,16,43,22],[42,23,43,24],[42,25,43,25],[42,26,43,26],[42,27,43,27],[43,0,43,9],[44,1,44,7],[44,8,44,9],[45,1,45,7],[45,8,45,9],[46,0,46,9],[47,0,47,5],[47,6,47,7],[47,8,47,9],[48,0,48,9],[49,1,49,7],[49,8,49,9],[50,0,50,9],[51,0,51,5],[51,6,51,7],[51,8,51,9],[52,0,52,9],[53,1,53,7],[53,8,53,9],[54,1,54,7],[54,8,54,9],[55,0,55,9],[56,0,57,9],[56,10,57,10],[56,11,57,11]]}
["TET 1 Name and Surname:",null,null,"Tankiso Mpebe",{"$nulls":6},"Use this column to complete the technical evaluation.The scores entered will be used to calculate the final technical calculation.","Provide specific file with proper indexing for your evaluation","Use guidelines / notes in this column to score in column K."]
["Date of Evaluation:",null,null,{"$f":"TODAY()","v":"2023-04-03"}]
[]
["Signature:"]
[]
["Technical Evaluation Criteria",{"$nulls":9},"TET 2 Evaluation Scores","File referance for the score","Guideline / Notes"]
["Technical Criteria Description",{"$nulls":7},"Sub-criteria weighting (%)"]
["1.  Company Profile",{"$nulls":5},"Weighting  =",null,{"v":0.2,"d":"20%"},null,{"$f":"K22*I8","v":0}]
["General measure in line with the Works instruction scope of work"]
["1.1 ","The tenderer submits a company profile that is current and detailed to be in line with the Works. An organogram is included, demonstrating how the organisational structure and chain of command supports the requirements of the scope of work.",{"$nulls":6},{"v":0.25,"d":"25%"},{"$nulls":3},"Scoring:\n5 - Full organogram submitted indicating chain of command, including Site Manager, Supervisor, Quality Controller, Electrical Artisans and SHE officer with an explanation of the role of each personnel.\n4 - Organogram submitted with no detail for the role of each personnel.\n2 - Organogram submitted with no detail for the role of each personnel and required personnel omitted.\n1 - Personnel listed with no indication of organisational structure."]
[]
[]
[]
["1.2","The Service Provider must have a risk identification and management process related to the complete process of installation & maintenance of O2 analysers and its components. The risk identification and management process must be in line with the works.",{"$nulls":6},{"v":0.3,"d":"30%"},{"$nulls":3},"Scoring:\n5 - Detail list of risk areas identified with action plan to mitigate them.\n4 - List of risk areas identified with action plan.\n2 - List of risk areas identified and no action plan.\n1 - No list of risk areas identified and no action plan"]
[]
[]
[]
["1.3","The Service Provider must have a method statement that indicates how the installation activities will be carried out, what resources will be required and what measures will be put in place to execute the task. The method and activities must be in line with the works.",{"$nulls":6},{"v":0.45,"d":"45%"},{"$nulls":3},"Scoring:\n5 - Method statement with measures and resources for installation activities.\n4 - Method statement with measures but no resources for installation activities.\n2 - Method statement with no measures and no resources for installation activities.\n1 - No method statement, measures and resources for installation activities"]
[]
[]
[]
["Company Profile Score:"]
["2. Experience",{"$nulls":5},"Weighting  =",null,{"v":0.1,"d":"10%"},null,{"$f":"K26*I23","v":0}]
["Reference list of Purchase/Task Orders completed of previous similar work."]
["2.1","The service provider needs to have done similar work in the industry. A traceable record (Orders, contracts etc.) is required.",{"$nulls":6},{"v":1,"d":"100%"},{"$nulls":3},"5 - A reference list with 3 or more completed Purchase/Task Orders provided.\n4 - A reference list with 2 completed Purchase/Task Orders provided.\n2 - A reference list with 1 completed Purchase/Task Orders provided.\n1 - No reference of completed Purchase/Task Orders provided."]
["Experience:",{"$nulls":9},{"$f":"K25*I25","v":0}]
["3.  Quality Control Plans",{"$nulls":5},"Weighting  =",null,{"v":0.05,"d":"5%"},null,{"$f":"K32*I27","v":0}]
["Example of completed QCP of previous similar work."]
[]
["3.1","The Service Provider submits a draft Quality Control Plan in line with the Works instruction scope of work",{"$nulls":6},{"v":1,"d":"100%"},{"$nulls":3},"5 - QCP layout submitted including all scope of work items, Eskom intervention points and sign-off.\n4 - Some scope of work items and some Eskom intervention points omitted.\n2 - Many scope of work items and many Eskom intervention points omitted.\n1 - No QCP layout submitted."]
[]
["Quality Control Plans: "]
["4.  Key Personnel",{"$nulls":5},"Weighting  =",null,{"v":0.4,"d":"40%"},null,{"$f":"K42*I33","v":0}]
["Key resources CV containing qualification and proof of similar work conducted on a power station or similar work environment as well as a reference list."]
[]
["4.1","Site Manager – well experienced in analytic instruments or O2 analysers works on a power station or similar work environment for a period of at least 5 years in a managerial position; minimum qualification of N6 Process Instrumentation/Electronic Engineering; two contactable references provided.",{"$nulls":6},{"v":0.25,"d":"25%"},{"$nulls":3},"5 - 5 years or more experience in O2 analyser works on a power station or similar work environment; N6 Electrical Engineering qualification or higher; two contactable references provided.\n4 - 3 years or more experience in O2 analyser works on a power station or similar work environment; N6 Electrical Engineering qualification or higher; two contactable references provided.\n2 - Less than 3 years experience in O2 analyser works on a power station or similar work environment; N6 Electrical Engineering qualification; no contactable references provided.\n1 - No experience in O2 analyser works on a power station or similar work environment; no N6 Electrical Engineering qualification or higher; no contactable references provided."]
[]
["4.2","Supervisor – well experienced in analytic instruments or O2 analysers works on a power station or similar work environment for a period of at least 5 years in a supervisory position; minimum qualification of N6 Process Instrumentation/Electronic Engineering and Trade Test Certificate; two contactable references provided. (2 or more)",{"$nulls":6},{"v":0.25,"d":"25%"},{"$nulls":3},"5 - 5 years or more experience in O2 analyser works on a power station or similar work environment; N6 Electrical Engineering qualification or higher; Trade Test Certificate provided;two contactable references provided.\n4 - 3 years or more experience in O2 analyser works on a power station or similar work environment; N6 Electrical Engineering qualification or higher;Trade Test Certificate provided; two contactable references provided.\n2 - Less than 3 years experience in O2 analyser works on a power station or similar work environment; N6 Electrical Engineering qualification; Trade Test Certificate provided; no contactable references provided.\n1 - No experience in O2 analyser works on a power station or similar work environment; no N6 Electrical Engineering qualification or higher; no Trade Test Certificate provided; no contactable references provided."]
["4.3","Quality Controller – well experienced in quality control of O2 analyser works with at least 2 years experience.",{"$nulls":6},{"v":0.15,"d":"15%"},{"$nulls":3},"5 - 2 years or more experience in quality control of O2 analyser works on a power station or similar work environment; \n4 - less than 2 years experience in quality control of O2 analyser  works on a power station or similar work environment; \n2 - 2 years or more experience in quality control of O2 analyser  works on a power station or similar work environment; \n1 - less than 2 years experience in quality control of O2 analyser  works on a power station or similar work environment; "]
["4.4","Artisans – has had previous experience with O2 analysers on a power station or similar work environment for at least 2 years; minimum qualification of N3 Process InstrumentatioProcess Instrumentation/Electronic Engineering and Trade Test Certificate; qualifications and experience provided for at least 3 artisans.",{"$nulls":6},{"v":0.1,"d":"10%"},{"$nulls":3},"5 - 3 years or more experience in O2 analyser works on a power station or similar work environment; N3 Electrical Engineering qualification or higher; Trade Test Certificate provided;two contactable references provided.\n4 - 2 years or more experience in O2 analyser works on a power station or similar work environment; N3 Electrical Engineering qualification or higher;Trade Test Certificate provided; two contactable references provided.\n2 - Less than 2 years experience in O2 analyser works on a power station or similar work environment; N3 Electrical Engineering qualification; Trade Test Certificate provided; no contactable references provided.\n1 - No experience in O2 analyser works on a power station or similar work environment; no N3 Electrical Engineering qualification or higher; no Trade Test Certificate provided; no contactable references provided."]
["4.5","SHE Officer – has had previous experience in line with the scope of work; minimum NQF Level 4 and SAMTRAC/SHEMTRAC certificate; valid registration as a candidate or professional with an OHS professional body such as SIOSH, SAIOH or SACPMP.",{"$nulls":6},{"v":0.25,"d":"25%"},{"$nulls":3},"5 - proof of similar work conducted; NQF Level 4 and SAMTRAC/SHEMTRAC certified; registered as a professional with an OHS professional body.\n4 - proof of similar work conducted; NQF Level 4 and SAMTRAC/SHEMTRAC certified; registered as a candidate with an OHS professional body.\n2 - no proof of similar work conducted; NQF Level 4 and SAMTRAC/SHEMTRAC certified; registered as a candidate with an OHS professional body.\n1 - no proof of similar work conducted; NQF Level 4 and SAMTRAC/SHEMTRAC certified; not registered with an OHS professional body."]
["Key Personnel: ",{"$nulls":9},{"$f":"K36*I36+K38*I38+K39*I39+K40*I40+K41*I41","v":0}]
["5. Training",{"$nulls":5},"Weighting  =",null,{"v":0.1,"d":"10%"},null,{"$f":"K47*I43","v":0}]
["Training and Development"]
["5.1","Does the Service Provider have Responsible Persons in terms of PSR",{"$nulls":6},{"v":0.5,"d":"50%"},{"$nulls":3},"5 - 3 RP\n4 - 2 RP\n2 - 1 RP\n1 - no RP"]
["5.1","The service provider must have a O2 analyser specific training program that includes safety, task method, quality management and describes tasks and sub tasks. Proof of training completed must be recorded for each employee and indicated on the personnel database.",{"$nulls":6},{"v":0.5,"d":"50%"},{"$nulls":3},"5 - Training program that includes safety; task method; quality control and  have database for trainees\n4 - Training program that includes safety; task method; quality control; no database for trainees                                                                                                                                                                                                                                                                                          2 - Training program that includes safety; task method; no quality control; no database for trainees\n1 - Training program that includes safety; no task method; no quality control; no database for trainees"]
["Training: "]
["6. Tools and Equipment",{"$nulls":5},"Weighting  =",null,{"v":0.1,"d":"10%"},null,{"$f":"K51*I48","v":0}]
["Asset List (Tools and Equipment)"]
["6.1","The service provider has an asset list describing the tools and equipment it has available to carry out the required installation work.",{"$nulls":6},{"v":1,"d":"100%"},{"$nulls":3},"5 - Tool list for 0.9m and 1.8m probes, analyser with local display, cell, temperature sensor, filter\n4 - Tool list for 0.9m and 1.8m probes, analyser with local display, cell, temperature sensor, without filter\n2 - Tool list for 0.9m and 1.8m probes, analyser without local display, cell, temperature sensor, without filter \n1 - No Tool list"]
["Tools and Equipment:",{"$nulls":9},{"$f":"K50*I50","v":0}]
["7. Guarantee",{"$nulls":5},"Weighting  =",null,{"v":0.05,"d":"5%"},null,{"$f":"K56*I52","v":0}]
["Works gaurantee"]
["7.1","The Service Provider guarantee for a minimum of 52 weeks or as specified in the specific enquiry for the quality of the maintenance work carried out.",{"$nulls":6},{"v":0.5,"d":"50%"},{"$nulls":3},"5 - Letter indicating 100% refund for failures within 52 weeks after maintenance work \n4 - Letter indicating 100% refund for failures within 52 weeks with conditions specified on the tender                                                                                                                                                                                                                                                                                          2 - Letter indicating refund policy based on investigation by both employer and service provider for failures within 52 weeks \n1 - Letter indicating 0% refund for failures within 52 weeks"]
["7.2","The Service Provider guarantee any product or spare component it supplies, for a minimum of 52 weeks or as specified in the specific enquiry.",{"$nulls":6},{"v":0.5,"d":"50%"},{"$nulls":3},"5 - Letter indicating 100% refund for failures within 52 weeks \n4 - Letter indicating 100% refund for failures within 52 weeks with conditions specified on the tender                                                                                                                                                                                                                                                                                          2 -  Letter indicating refund policy based on investigation by both employer and service provider for failures within 52 weeks after spares supplied\n1 - Letter indicating 0% refund for failures within 52 weeks"]
["Garantee:"]
["Final score for TET 2:",{"$nulls":9},{"$f":"SUM(K8,K23,K27,K33,K43,K48,K52)","v":0}]

{"sheet":"TET 3","index":6,"n_rows":57,"n_cols":13,"rows_kept":57,"merged":[[0,0,0,2],[0,3,0,7],[0,10,4,10],[0,11,4,11],[0,12,4,12],[1,0,1,2],[1,3,1,5],[2,1,3,5],[5,0,5,9],[5,10,6,10],[5,11,6,11],[5,12,6,12],[6,0,6,7],[6,8,6,9],[7,0,7,5],[7,8,7,9],[8,0,8,9],[9,1,12,7],[9,8,12,9],[9,10,12,10],[9,11,12,11],[9,12,12,12],[13,1,16,7],[13,8,16,9],[13,10,16,10],[13,11,16,11],[13,12,16,12],[17,1,20,7],[17,8,20,9],[17,10,20,10],[17,11,20,11],[17,12,20,12],[21,0,21,9],[22,0,22,5],[22,6,22,7],[22,8,22,9],[23,0,23,9],[24,1,24,7],[24,8,24,9],[25,0,25,9],[26,0,26,5],[26,6,26,7],[26,8,26,9],[27,0,28,9],[27,10,28,10],[27,11,28,11],[27,12,28,12],[29,1,30,7],[29,8,30,9],[29,10,30,10],[29,11,30,11],[29,12,30,12],[31,0,31,9],[32,0,32,5],[32,6,32,7],[32,8,32,9],[33,0,34,9],[33,10,34,10],[33,11,34,11],[33,12,34,12],[35,1,36,7],[35,8,36,9],[35,10,36,10],[35,11,36,11],[35,12,36,12],[37,1,37,7],[37,8,37,9],[38,1,38,7],[38,8,38,9],[39,1,39,7],[39,8,39,9],[40,1,40,7],[40,8,40,9],[41,0,41,9],[42,0,42,5],[42,6,42,7],[42,8,42,9],[42,16,43,22],[42,23,43,24],[42,25,43,25],[42,26,43,26],[42,27,43,27],[43,0,43,9],[44,1,44,7],[44,8,44,9],[45,1,45,7],[45,8,45,9],[46,0,46,9],[47,0,47,5],[47,6,47,7],[47,8,47,9],[48,0,48,9],[49,1,49,7],[49,8,49,9],[50,0,50,9],[51,0,51,5],[51,6,51,7],[51,8,51,9],[52,0,52,9],[53,1,53,7],[53,8,53,9],[54,1,54,7],[54,8,54,9],[55,0,55,9],[56,0,57,9],[56,10,57,10],[56,11,57,11]]}
["TET 1 Name and Surname:",null,null,"Sibonelo Khanyile",{"$nulls":6},"Use this column to complete the technical evaluation.The scores entered will be used to calculate the final technical calculation.","Provide specific file with proper indexing for your evaluation","Use guidelines / notes in this column to score in column K."]
["Date of Evaluation:",null,null,{"$f":"TODAY()","v":"2023-04-03"}]
[]
["Signature:"]
[]
["Technical Evaluation Criteria",{"$nulls":9},"TET 3 Evaluation Scores","File referance for the score","Guideline / Notes"]
["Technical Criteria Description",{"$nulls":7},"Sub-criteria weighting (%)"]
["1.  Company Profile",{"$nulls":5},"Weighting  =",null,{"v":0.2,"d":"20%"},null,{"$f":"K22*I8","v":0}]
["General measure in line with the Works instruction scope of work"]
["1.1 ","The tenderer submits a company profile that is current and detailed to be in line with the Works. An organogram is included, demonstrating how the organisational structure and chain of command supports the requirements of the scope of work.",{"$nulls":6},{"v":0.25,"d":"25%"},{"$nulls":3},"Scoring:\n5 - Full organogram submitted indicating chain of command, including Site Manager, Supervisor, Quality Controller, Electrical Artisans and SHE officer with an explanation of the role of each personnel.\n4 - Organogram submitted with no detail for the role of each personnel.\n2 - Organogram submitted with no detail for the role of each personnel and required personnel omitted.\n1 - Personnel listed with no indication of organisational structure."]
[]
[]
[]
["1.2","The Service Provider must have a risk identification and management process related to the complete process of installation & maintenance of O2 analysers and its components. The risk identification and management process must be in line with the works.",{"$nulls":6},{"v":0.3,"d":"30%"},{"$nulls":3},"Scoring:\n5 - Detail list of risk areas identified with action plan to mitigate them.\n4 - List of risk areas identified with action plan.\n2 - List of risk areas identified and no action plan.\n1 - No list of risk areas identified and no action plan"]
[]
[]
[]
["1.3","The Service Provider must have a method statement that indicates how the installation activities will be carried out, what resources will be required and what measures will be put in place to execute the task. The method and activities must be in line with the works.",{"$nulls":6},{"v":0.45,"d":"45%"},{"$nulls":3},"Scoring:\n5 - Method statement with measures and resources for installation activities.\n4 - Method statement with measures but no resources for installation activities.\n2 - Method statement with no measures and no resources for installation activities.\n1 - No method statement, measures and resources for installation activities"]
[]
[]
[]
["Company Profile Score:"]
["2. Experience",{"$nulls":5},"Weighting  =",null,{"v":0.1,"d":"10%"},null,{"$f":"K26*I23","v":0}]
["Reference list of Purchase/Task Orders completed of previous similar work."]
["2.1","The service provider needs to have done similar work in the industry. A traceable record (Orders, contracts etc.) is required.",{"$nulls":6},{"v":1,"d":"100%"},{"$nulls":3},"5 - A reference list with 3 or more completed Purchase/Task Orders provided.\n4 - A reference list with 2 completed Purchase/Task Orders provided.\n2 - A reference list with 1 completed Purchase/Task Orders provided.\n1 - No reference of completed Purchase/Task Orders provided."]
["Experience:"]
["3.  Quality Control Plans",{"$nulls":5},"Weighting  =",null,{"v":0.05,"d":"5%"},null,{"$f":"K32*I27","v":0}]
["Example of completed QCP of previous similar work."]
[]
["3.1","The Service Provider submits a draft Quality Control Plan in line with the Works instruction scope of work",{"$nulls":6},{"v":1,"d":"100%"},{"$nulls":3},"5 - QCP layout submitted including all scope of work items, Eskom intervention points and sign-off.\n4 - Some scope of work items and some Eskom intervention points omitted.\n2 - Many scope of work items and many Eskom intervention points omitted.\n1 - No QCP layout submitted."]
[]
["Quality Control Plans: "]
["4.  Key Personnel",{"$nulls":5},"Weighting  =",null,{"v":0.4,"d":"40%"},null,{"$f":"K42*I33","v":0}]
["Key resources CV containing qualification and proof of similar work conducted on a power station or similar work environment as well as a reference list."]
[]
["4.1","Site Manager – well experienced in analytic instruments or O2 analysers works on a power station or similar work environment for a period of at least 5 years in a managerial position; minimum qualification of N6 Process Instrumentation/Electronic Engineering; two contactable references provided.",{"$nulls":6},{"v":0.25,"d":"25%"},{"$nulls":3},"5 - 5 years or more experience in O2 analyser works on a power station or similar work environment; N6 Electrical Engineering qualification or higher; two contactable references provided.\n4 - 3 years or more experience in O2 analyser works on a power station or similar work environment; N6 Electrical Engineering qualification or higher; two contactable references provided.\n2 - Less than 3 years experience in O2 analyser works on a power station or similar work environment; N6 Electrical Engineering qualification; no contactable references provided.\n1 - No experience in O2 analyser works on a power station or similar work environment; no N6 Electrical Engineering qualification or higher; no contactable references provided."]
[]
["4.2","Supervisor – well experienced in analytic instruments or O2 analysers works on a power station or similar work environment for a period of at least 5 years in a supervisory position; minimum qualification of N6 Process Instrumentation/Electronic Engineering and Trade Test Certificate; two contactable references provided. (2 or more)",{"$nulls":6},{"v":0.25,"d":"25%"},{"$nulls":3},"5 - 5 years or more experience in O2 analyser works on a power station or similar work environment; N6 Electrical Engineering qualification or higher; Trade Test Certificate provided;two contactable references provided.\n4 - 3 years or more experience in O2 analyser works on a power station or similar work environment; N6 Electrical Engineering qualification or higher;Trade Test Certificate provided; two contactable references provided.\n2 - Less than 3 years experience in O2 analyser works on a power station or similar work environment; N6 Electrical Engineering qualification; Trade Test Certificate provided; no contactable references provided.\n1 - No experience in O2 analyser works on a power station or similar work environment; no N6 Electrical Engineering qualification or higher; no Trade Test Certificate provided; no contactable references provided."]
["4.3","Quality Controller – well experienced in quality control of O2 analyser works with at least 2 years experience.",{"$nulls":6},{"v":0.15,"d":"15%"},{"$nulls":3},"5 - 2 years or more experience in quality control of O2 analyser works on a power station or similar work environment; \n4 - less than 2 years experience in quality control of O2 analyser  works on a power station or similar work environment; \n2 - 2 years or more experience in quality control of O2 analyser  works on a power station or similar work environment; \n1 - less than 2 years experience in quality control of O2 analyser  works on a power station or similar work environment; "]
["4.4","Artisans – has had previous experience with O2 analysers on a power station or similar work environment for at least 2 years; minimum qualification of N3 Process InstrumentatioProcess Instrumentation/Electronic Engineering and Trade Test Certificate; qualifications and experience provided for at least 3 artisans.",{"$nulls":6},{"v":0.1,"d":"10%"},{"$nulls":3},"5 - 3 years or more experience in O2 analyser works on a power station or similar work environment; N3 Electrical Engineering qualification or higher; Trade Test Certificate provided;two contactable references provided.\n4 - 2 years or more experience in O2 analyser works on a power station or similar work environment; N3 Electrical Engineering qualification or higher;Trade Test Certificate provided; two contactable references provided.\n2 - Less than 2 years experience in O2 analyser works on a power station or similar work environment; N3 Electrical Engineering qualification; Trade Test Certificate provided; no contactable references provided.\n1 - No experience in O2 analyser works on a power station or similar work environment; no N3 Electrical Engineering qualification or higher; no Trade Test Certificate provided; no contactable references provided."]
["4.5","SHE Officer – has had previous experience in line with the scope of work; minimum NQF Level 4 and SAMTRAC/SHEMTRAC certificate; valid registration as a candidate or professional with an OHS professional body such as SIOSH, SAIOH or SACPMP.",{"$nulls":6},{"v":0.25,"d":"25%"},{"$nulls":3},"5 - proof of similar work conducted; NQF Level 4 and SAMTRAC/SHEMTRAC certified; registered as a professional with an OHS professional body.\n4 - proof of similar work conducted; NQF Level 4 and SAMTRAC/SHEMTRAC certified; registered as a candidate with an OHS professional body.\n2 - no proof of similar work conducted; NQF Level 4 and SAMTRAC/SHEMTRAC certified; registered as a candidate with an OHS professional body.\n1 - no proof of similar work conducted; NQF Level 4 and SAMTRAC/SHEMTRAC certified; not registered with an OHS professional body."]
["Key Personnel: ",{"$nulls":9},{"$f":"K36*I36+K38*I38+K39*I39+K40*I40+K41*I41","v":0}]
["5. Training",{"$nulls":5},"Weighting  =",null,{"v":0.1,"d":"10%"},null,{"$f":"K47*I43","v":0}]
["Training and Development"]
["5.1","Does the Service Provider have Responsible Persons in terms of PSR",{"$nulls":6},{"v":0.5,"d":"50%"},{"$nulls":3},"5 - 3 RP\n4 - 2 RP\n2 - 1 RP\n1 - no RP"]
["5.1","The service provider must have a O2 analyser specific training program that includes safety, task method, quality management and describes tasks and sub tasks. Proof of training completed must be recorded for each employee and indicated on the personnel database.",{"$nulls":6},{"v":0.5,"d":"50%"},{"$nulls":3},"5 - Training program that includes safety; task method; quality control and  have database for trainees\n4 - Training program that includes safety; task method; quality control; no database for trainees                                                                                                                                                                                                                                                                                          2 - Training program that includes safety; task method; no quality control; no database for trainees\n1 - Training program that includes safety; no task method; no quality control; no database for trainees"]
["Training: "]
["6. Tools and Equipment",{"$nulls":5},"Weighting  =",null,{"v":0.1,"d":"10%"},null,{"$f":"K51*I48","v":0}]
["Asset List (Tools and Equipment)"]
["6.1","The service provider has an asset list describing the tools and equipment it has available to carry out the required installation work.",{"$nulls":6},{"v":1,"d":"100%"},{"$nulls":3},"5 - Tool list for 0.9m and 1.8m probes, analyser with local display, cell, temperature sensor, filter\n4 - Tool list for 0.9m and 1.8m probes, analyser with local display, cell, temperature sensor, without filter\n2 - Tool list for 0.9m and 1.8m probes, analyser without local display, cell, temperature sensor, without filter \n1 - No Tool list"]
["Tools and Equipment:",{"$nulls":9},{"$f":"K50*I50","v":0}]
["7. Guarantee",{"$nulls":5},"Weighting  =",null,{"v":0.05,"d":"5%"},null,{"$f":"K56*I52","v":0}]
["Works gaurantee"]
["7.1","The Service Provider guarantee for a minimum of 52 weeks or as specified in the specific enquiry for the quality of the maintenance work carried out.",{"$nulls":6},{"v":0.5,"d":"50%"},{"$nulls":3},"5 - Letter indicating 100% refund for failures within 52 weeks after maintenance work \n4 - Letter indicating 100% refund for failures within 52 weeks with conditions specified on the tender                                                                                                                                                                                                                                                                                          2 - Letter indicating refund policy based on investigation by both employer and service provider for failures within 52 weeks \n1 - Letter indicating 0% refund for failures within 52 weeks"]
["7.2","The Service Provider guarantee any product or spare component it supplies, for a minimum of 52 weeks or as specified in the specific enquiry.",{"$nulls":6},{"v":0.5,"d":"50%"},{"$nulls":3},"5 - Letter indicating 100% refund for failures within 52 weeks \n4 - Letter indicating 100% refund for failures within 52 weeks with conditions specified on the tender                                                                                                                                                                                                                                                                                          2 -  Letter indicating refund policy based on investigation by both employer and service provider for failures within 52 weeks after spares supplied\n1 - Letter indicating 0% refund for failures within 52 weeks"]
["Garantee:"]
["Final score for TET 3:",{"$nulls":9},{"$f":"SUM(K8,K23,K27,K33,K43,K48,K52)","v":0}]

{"sheet":"Final Technical Score","index":7,"n_rows":14,"n_cols":4,"rows_kept":14,"merged":[[0,0,0,3]]}
["Final Technical Score Summary"]
["TET Member","TET 1","TET 2","TET 3"]
["1.  Company Profile (%)"]
["2.  Experience (%)"]
["3.  Quality Control Plans (%)"]
["4.  Key Personnel (%)"]
["5.  Training (%)"]
["6.  Tools and Equipment (%)"]
["7. Guarantee (%)"]
[]
[]
[]
["Final Score (%)"]
["Competency"]