{"text_format":"3","workbook":"xls","n_sheets":10,"sheets":["Guidance Notes","Overall","Schedule","SHEQ","Contract Management","Construction Management","Materials Management ","Finance ","Stakeholder Management","Sheet1"],"not_rendered":{"images":1,"external_links":1,"defined_names":9},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Guidance Notes","index":0,"n_rows":31,"n_cols":8,"rows_kept":31,"merged":[[1,1,3,2],[1,3,3,3],[2,5,2,7],[3,5,3,7],[5,0,5,5],[8,1,8,5],[9,1,9,5],[10,1,10,5],[11,1,11,5],[12,1,12,5],[13,1,13,5],[15,3,15,5],[16,3,16,5],[17,3,17,5],[18,3,18,5],[30,1,33,5]],"flags":["formulas_cached_only"]}
[]
[{"$nulls":3},"Supplier Evaluation Tool","Document Identifier","240-","Rev",1]
[{"$nulls":4},"Effective Date","2022-02-01"]
[{"$nulls":4},"Review Date","2025-02-01"]
[]
["Guidance Notes to the Project Manager"]
[]
[]
[null,"1. The Project Manager (PM) is required to study the whole document before completing each area on the tabs."]
[null,"2. The (PM) should note that the overall scoring is self-automated (you need not insert your own values)"]
[null,"3. In each tab, the PM should read the description and make the correct selection under the \"criteria tab\""]
[null,"4. The lower the scores, the unhealthy the contractor  status"]
[null,"5. A contract source of evidence must be utilised to support the selection (e.g. Signed Accepted Scheduled, SHEQ Stats)"]
[null,"6. The final completed appraisal must be reviewed and signed off by the Programme Manager and the Senior Manager"]
[]
[null,"Rating","%","Comment"]
[]
[null,"Pass","Equal or greater than 70%","The score suggests that the contractor meets the minimum contractual requirements set out by Eskom in all the contracts awarded to them"]
[null,"Fail","Less than 70%","The score suggests that the contractor will be submitted to the Eskom Supplier Review Committee for further assessment"]
{"$rows_empty":11}
[null,"CONTROLLED DISCLOSURE\n\nWhen downloaded from the document management system, this document is uncontrolled and the responsibility rests with the user to ensure it is in line with the authorized version on the system. No part of this document may be reproduced in any manner or form by third parties without the written consent of Eskom Holdings SOC Ltd,  © copyright Eskom Holdings SOC Ltd, Reg No 2002/015527/30"]

{"sheet":"Overall","index":1,"n_rows":21,"n_cols":5,"rows_kept":21,"merged":[[1,0,1,4],[16,0,16,2],[18,0,18,2],[20,0,20,2]],"flags":["formulas_cached_only"]}
[]
["CONTRACTOR'S PERFORMANCE APPRAISAL"]
["Contractor:   S",null,null,"Project: ","Contract Number: "]
["Start Date :                  Completion Date :             Contract Value (excl.VAT) :"]
[]
["No","Criteria","Weight","Comments","Score"]
[1,"Schedule",{"v":0.2,"d":"20.0%"},null,{"v":0,"d":"0.00%"}]
[2,"SHEQ",{"v":0.2,"d":"20.0%"},null,{"v":0.05,"d":"5.00%"}]
[3,"Contract Management",{"v":0.15,"d":"15.0%"},null,{"v":0.13333333333333333,"d":"13.33%"}]
[4,"Construction Management",{"v":0.1,"d":"10.0%"},null,{"v":0.05555555555555556,"d":"5.56%"}]
[5,"Material management",{"v":0.05,"d":"5.0%"},null,{"v":0.044444444444444446,"d":"4.44%"}]
[6,"Finance",{"v":0.2,"d":"20.0%"},null,{"v":0.08666666666666667,"d":"8.67%"}]
[7,"Stakeholder Management",{"v":0.1,"d":"10.0%"},null,{"v":0.06666666666666667,"d":"6.67%"}]
[null,"Total:",{"v":1.0000000000000002,"d":"100.0%"},null,{"v":0.43666666666666665,"d":"43.67%"}]
[]
["Names :",null,null,"Signatures :","Date :"]
["Project Manager: "]
[]
["Programme Manager: "]
[]
["Senior Manager:  "]

{"sheet":"Schedule","index":2,"n_rows":47,"n_cols":7,"rows_kept":47,"flags":["formulas_cached_only"]}
[null,"Description","Criteria","Score","PM Comments"]
[1,"Adherence to approved Milestones key dates","Contractor missed all milestones",0]
[2,"Baseline vs actual due to contractors delay","Contractor is behind schedule by more than 30 days",0]
[3,"Revised Schedule vs actual","Contractor is behind schedule by more than 30 days",0]
[null,"Total Score",null,0]
{"$rows_empty":19}
[{"$nulls":3},0]
[{"$nulls":3},0.13333333333333333]
{"$rows_empty":7}
[{"$nulls":4},"for item 1"]
[]
[{"$nulls":5},"Contractor missed all milestones",0]
[{"$nulls":5},"Contractor meets 50% or less of milestones",1]
[{"$nulls":5},"Contractor meets between 50% and 99% of milestones",2]
[{"$nulls":5},"Contractor meets all milestones",3]
[]
[]
[{"$nulls":4},"for item 2"]
[]
[{"$nulls":5},"Contractor is behind schedule by more than 30 days",0]
[{"$nulls":5},"Contractor is behind schedule by 30 days or less",1]
[{"$nulls":5},"Contractor is on schedule",2]
[{"$nulls":5},"Contractor is ahead of schedule",3]

{"sheet":"SHEQ","index":3,"n_rows":90,"n_cols":8,"rows_kept":90,"flags":["formulas_cached_only"]}
[null,"Health and Safety",null,null,"PM Comments"]
[null,"Description","Criteria","Score"]
[1,"Prohibition notices for Health and Safety (Legal notices from DoL Authorities).","Contractor received no statutory notices",3]
[2,"Contravention notices for Health and Safety (Legal notices from DoL Authorities).","Contractor received no legal contraventions",3]
[3,"Improvement notices for Health and Safety (Legal notices from DoL Authorities).","Contractor received 1 or more legal contraventions",0]
[4,"Audit findings - External/Internal to TPD","Contractor received more than 6 Contravention notices or 3 and more Prohibition Notices",0]
[5,"NCR not closed on time","Contractor has 3 or more NCRs not closed out",0]
[6,"Safety LTI since project inception","Contractor has 3 or more LTIs",0]
[7,"Fatality since project inception","Contractor had a fatality",0]
[]
[null,"Environment"]
[null,"Description","Criteria","Score"]
[1,"Statutory notices for Environmental (Legal notices from Environmental Authorities).","Contractor received 1 or more statutory notices",0]
[2,"Number of Legal contraventions","Contractor received 1 or more legal contraventions",0]
[3,"Number of Legal contraventions (Failure to Business Systems)","Contractor received 1 or more legal contraventions",0]
[4,"Audit findings - External/Internal to TPD","Contractor has received 4 and more Notice of intent or 3 and more Compliance",0]
[5,"NCR not closed on time","Contractor has 3 or more NCRs not closed out",0]
[]
[null,"Quality"]
[null,"Description","Criteria","Score"]
[1,"Number of reworks","NCR's not addressed timeously and corrections not executed as per required specification",2]
[2,"Inspection and Test Plans conformance\n","NCR's not addressed timeously and corrections not executed as per required specification",2]
[3,"Audit findings - External/Internal to TPD\n","Observations",2]
[4,"NCR not closed on time","Contractor has 3 or more NCRs not closed out",0]
[]
[null,"Total Score",null,12]
[]
[]
[]
[]
[]
[{"$nulls":3},0.25]
[{"$nulls":3},{"v":0.22857142857142856,"d":"0.23"}]
[]
[]
[{"$nulls":5},"Item 1"]
[{"$nulls":6},"Contractor received 1 or more statutory notices",0]
[{"$nulls":6},"Contractor received no statutory notices",3]
[]
[{"$nulls":5},"Item 2"]
[]
[{"$nulls":6},"Contractor received 1 or more legal contraventions",0]
[{"$nulls":6},"Contractor received no legal contraventions",3]
[]
[{"$nulls":5},"Item 3"]
[{"$nulls":6},"Contractor received more than 6 Contravention notices or 3 and more Prohibition Notices",0]
[{"$nulls":6},"Contractor received 5 and more Improvement notice or 3 to 6 Contravention notices or 2 Prohibition Notices",1]
[{"$nulls":6},"Contractor received less than 5 Improvement notice or less than 2 Contravention notices or 1 Prohibition Notice",3]
[]
[{"$nulls":5},"Item 4"]
[{"$nulls":6},"Contractor has 3 or more NCRs not closed out",0]
[{"$nulls":6},"Contractor has 2 NCRs not closed out",1]
[{"$nulls":6},"Contractor has one NCR not closed out.",2]
[{"$nulls":6},"Contractor closed out all NCR`s on time",3]
[]
[{"$nulls":5},"Item 5"]
[{"$nulls":6},"Contractor has 3 or more LTIs",0]
[{"$nulls":6},"Contractor has 2 LTIs",1]
[{"$nulls":6},"Contractor has 1 LTI",2]
[{"$nulls":6},"Contractor had no LTIs",3]
[]
[{"$nulls":5},"Item 6"]
[{"$nulls":6},"Contractor had a fatality",0]
[{"$nulls":6},"Contractor has no fatality",3]
[]
[]
[]
[{"$nulls":5},"En Item 3"]
[{"$nulls":6},"Contractor has received 4 and more Notice of intent or 3 and more Compliance",0]
[{"$nulls":6},"Contractor has received 3 Notice of intent or 2 Compliance notice",1]
[{"$nulls":6},"Contractor has received 2 Notice of intent or 1 Compliance notice",2]
[{"$nulls":6},"Contractor has received 1 Notice of intent or no Compliance notice",3]
[]
[{"$nulls":5},"Quality"]
[{"$nulls":6},"Failure to provide certificates and evidence to support technical requirements (Records)",0]
[{"$nulls":6},"Defects not corrected timeously",1]
[{"$nulls":6},"NCR's not addressed timeously and corrections not executed as per required specification",2]
[{"$nulls":6},"Full conformance to Eskom technical specification",3]
[]
[{"$nulls":6},"Inspection and Test Plans conformance"]
[{"$nulls":6},"Failure to provide certificates and evidence to support technical requirements (Records)",0]
[{"$nulls":6},"Defects not corrected timeously",1]
[{"$nulls":6},"NCR's not addressed timeously and corrections not executed as per required specification",2]
[{"$nulls":6},"Full conformance to Eskom technical specification",3]
[]
[{"$nulls":5},"Audit"]
[{"$nulls":6},"Major",0]
[{"$nulls":6},"Minor",1]
[{"$nulls":6},"Observations",2]
[{"$nulls":6},"None",3]

{"sheet":"Contract Management","index":4,"n_rows":34,"n_cols":8,"rows_kept":34,"flags":["formulas_cached_only"]}
[null,"Description","Criteria","Score","PM Comments"]
[1,"Adherence to contractual requirements and response times","Contractor defaults on 1 occasion on any contractual requirements within response times",2]
[2,"Any contract terminations (within the last 5 years) - If yes provide reasons","No",3]
[3,"Compensation events/ Modification due to contractor's default e.g. (E/W, Supporting Documents..)","1 CE due to Contractor's default",3]
[null,"Total Score",null,8]
{"$rows_empty":12}
[{"$nulls":3},{"v":0.8888888888888888,"d":"0.889"}]
[{"$nulls":3},{"v":0.11666666666666667,"d":"0.12"}]
[{"$nulls":5},"Item 1"]
[{"$nulls":6},"Contractor defaults on 3 or more occasions on any contractual requirements within response times",0]
[{"$nulls":6},"Contractor defaults on 2 occasions on any contractual requirements within response times",1]
[{"$nulls":6},"Contractor defaults on 1 occasion on any contractual requirements within response times",2]
[{"$nulls":6},"Contractor adheres to all contractual requirements within response times",3]
[]
[{"$nulls":5},"Item 2"]
[{"$nulls":6},"Yes",0]
[{"$nulls":6},"No",3]
[]
[{"$nulls":5},"Item 3"]
[{"$nulls":6},"10 or more CE`s due to Contractor's default",0]
[{"$nulls":6},"5 to 9 CE`s due to Contractor's default",1]
[{"$nulls":6},"2 to 4 CE`s due to Contractor's default",2]
[{"$nulls":6},"1 CE due to Contractor's default",3]

{"sheet":"Construction Management","index":5,"n_rows":40,"n_cols":8,"rows_kept":40,"flags":["formulas_cached_only"]}
[null,"Description","Criteria","Score","PM Comments"]
[1,"Contractor capacity: Human Resources, Equipment, Material","Contractor correctly resourced the project",3]
[2,"Sub-contractor Management","Contractor evaluates 80% to 99% of sub-contractors prior to work and conducts monthly audits against them",2]
[3,"Current work load","Contractor has three or more projects",0]
[null,"Total Score",null,5]
{"$rows_empty":12}
[{"$nulls":3},{"v":0.5555555555555556,"d":"0.56"}]
[{"$nulls":3},{"v":0.044444444444444446,"d":"0.04"}]
[]
[]
[{"$nulls":5},"Item 1"]
[{"$nulls":6},"Contractor only resourced the project by greater than 20%",0]
[{"$nulls":6},"Contractor under resourced the project by 10 to 20%",1]
[{"$nulls":6},"Contractor under resourced the project by up to 10%",2]
[{"$nulls":6},"Contractor correctly resourced the project",3]
[]
[]
[{"$nulls":5},"Item 2"]
[{"$nulls":6},"Contractor conducts no evaluations and no audits against subcontractors",0]
[{"$nulls":6},"Contractor evaluates less than 80% of sub-contractors prior to work and conducts monthly audits against them",1]
[{"$nulls":6},"Contractor evaluates 80% to 99% of sub-contractors prior to work and conducts monthly audits against them",2]
[{"$nulls":6},"Contractor evaluates all sub-contractors prior to work and conducts monthly audits against them",3]
[]
[]
[{"$nulls":5},"Item 3"]
[{"$nulls":6},"Contractor has three or more projects",0]
[{"$nulls":6},"Contractor has two projects",1]
[{"$nulls":6},"Contractor has one project",2]
[{"$nulls":6},"Contractor has no projects",3]

{"sheet":"Materials Management ","index":6,"n_rows":53,"n_cols":8,"rows_kept":53,"flags":["formulas_cached_only"]}
[null,"Materials Management"]
[null,"Description","Criteria","Score","PM Comments"]
[1,"Delivery on time (this should solicit a yes or no looking at the agreed lead time when the order was placed","Contractor delivered some of the material on time (Contractor supplied material)",2]
[2,"Was the correct quantity delivered?","Quantity delivered was correct  (Contractor supplied material)",3]
[3,"Inventory listing "," Inventory listing of material available but not up to  date",2]
[4,"Was the product properly preserved?","The material was  properly preserved",3]
[5,"Supporting documents delivered. (where data sheets and test certificates are required)","Supporting documents (where data sheets and test certificates are required) were  delivered",3]
[6,"Quality – was the correct item delivered?","Quality of the delivered material was accepted  (Contractor supplied material)",3]
[]
[]
[null,"Total Score",null,16]
[]
[]
[]
[]
[]
[{"$nulls":3},{"v":0.044444444444444446,"d":"0.04"}]
[]
[]
[]
[{"$nulls":5},"Item 1"]
[{"$nulls":6},"Contractor failed to deliver material on time (Contractor supplied material)",0]
[{"$nulls":6},"Contractor delivered some of the material on time (Contractor supplied material)",2]
[{"$nulls":6},"Contractor delivered material on time (Contractor supplied material)",3]
[]
[{"$nulls":5},"Item 2"]
[]
[{"$nulls":6},"Quantity delivered was incorrect (Contractor supplied material)",0]
[{"$nulls":6},"Quantity delivered was correct  (Contractor supplied material)",3]
[]
[{"$nulls":5},"Item 3"]
[{"$nulls":6},"There is no inventory listing of material available",0]
[{"$nulls":6}," Inventory listing of material available but not up to  date",2]
[{"$nulls":6}," Inventory listing is available and up to date",3]
[]
[]
[{"$nulls":5},"Item 4"]
[{"$nulls":6},"The material was not properly preserved (e.g. cable drums stored properly on a flat surface, Tower steel in storage shall be supported off the ground with a sufficient number of blocks to prevent bending or warping of individual member,  ",0]
[{"$nulls":6},"The material was somewhat preserved",2]
[{"$nulls":6},"The material was  properly preserved",3]
[]
[]
[{"$nulls":5},"Item 5"]
[{"$nulls":6},"Supporting documents (where data sheets and test certificates are required) were not delivered",0]
[{"$nulls":6},"Supporting documents (where data sheets and test certificates are required) were  delivered",3]
[]
[]
[]
[{"$nulls":5},"Item 6"]
[{"$nulls":6},"Quality of the delivered material was not accepted (Contractor supplied material)",0]
[{"$nulls":6},"Quality of the delivered material was accepted  (Contractor supplied material)",3]
[]
[{"$nulls":3},0.8888888888888888]

{"sheet":"Finance ","index":7,"n_rows":67,"n_cols":7,"rows_kept":67,"flags":["formulas_cached_only"]}
["Description","Criteria","Score","Comments","Weighting","PM Comments"]
["Rate of invoicing (FRI)","Deviation >10% and <30% ",2,null,{"v":0.2,"d":"20%"},null,0.4]
["Cashflow position","Cash&cash equivalents<10% of remaining contract value",0,"The criteria to be applied when interim and final financial statements for the company are provided",{"v":0.5,"d":"50%"},null,0]
["Commitment for the vendor ","Commitment  < 60% of revenue/sales ",3,"Can be conducted at anytime\nProfessional services vendors - revenue is more reliable\nConstruction works - Capital (Assets) more reliable ",{"v":0.3,"d":"30%"},null,0.8999999999999999]
[]
["Total Score",null,1.2999999999999998,{"$nulls":3},1.2999999999999998]
[]
[]
[null,null,0.4333333333333333]
[]
[]
[]
[{"$nulls":4},"Item 1"]
[{"$nulls":5},"Deviation=or <10%",3]
[{"$nulls":5},"Deviation >10% and <30% ",2]
[{"$nulls":5},"Deviation>30%",1]
[]
[]
[{"$nulls":4},"Item 2"]
[{"$nulls":5},"Cash&cash equivalents>10% of remaining contract value",3]
[{"$nulls":5},"Cash&cash equivalents=10% of remaining contract value",2]
[{"$nulls":5},"Cash&cash equivalents<10% of remaining contract value",0]
[]
[]
[{"$nulls":4},"Item 3"]
[{"$nulls":5},"Commitment  < 60% of revenue/sales ",3]
[{"$nulls":5},"Commitment  = or > 60% but not above 70% of revenue /sales ",2]
[{"$nulls":5},"Commitment  > 70% of revenue/sales ",1]
[{"$nulls":5},"Not Rated",0]
{"$rows_empty":24}
[null,"Total rating",3]
[null,"Financial sound",">1.5"]
[null,"Financial sound with recommendations",1.5]
[null,"Not financial sound","<1.5"]
[]
[]
["Include"]
["Rate of invoicing (Actual Technical performance vs FRI differences)"]
[]
[]
[]
[]
["Use audited financials. If not audited, use ITA 34C Income Tax assessment"]
["Contract>R300 million analysis is done by COE."]

{"sheet":"Stakeholder Management","index":8,"n_rows":29,"n_cols":7,"rows_kept":29,"flags":["formulas_cached_only"]}
[null,"Description","Criteria","Score","PM Comments"]
[1,"Compliance to Stakeholder Management/Communication plan","Non compliance to Stakeholder Management requirements",0]
[2,"Supplier Development  Localisation and Industrialisation Performance","Compliance to contractual requirements",3]
[3,"Corporate Social Investment Performance","Compliance to contractual requirements",3]
[null,"Total Score",null,6]
[]
[]
[]
[]
[]
[{"$nulls":3},{"v":0.6666666666666666,"d":"0.67"}]
[{"$nulls":3},{"v":0.07777777777777778,"d":"0.08"}]
[{"$nulls":4},"Item 1"]
[{"$nulls":5},"Non compliance to Stakeholder Management requirements",0]
[{"$nulls":5},"Partial compliance to Stakeholder Management requirements",1]
[{"$nulls":5},"Compliance to Stakeholder Management requirements",3]
[]
[]
[]
[{"$nulls":4},"Item 2"]
[{"$nulls":5},"Non compliance to contractual requirements",0]
[{"$nulls":5},"Partial compliance to contractual requirements",1]
[{"$nulls":5},"Compliance to contractual requirements",3]
[]
[]
[{"$nulls":4},"Item 3"]
[{"$nulls":5},"Non Compliance to contractual requirements",0]
[{"$nulls":5},"Partial compliance to contractual requirements",1]
[{"$nulls":5},"Compliance to contractual requirements",3]

{"sheet":"Sheet1","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}