{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","Contextual Info","Risk Register","Rating Criteria","Manual Form","Complete Eskom Rating Scales","Risk Scoring"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":8,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Contextual Info","index":1,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[[36,0,36,1],[37,0,37,1],[33,1,33,2],[1,0,1,2],[19,1,19,2],[20,1,20,2],[34,1,34,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2]]}
["Project Info. / Background"]
["[Use to capture relevant information relating to the project and its objectives]"]
[]
["Stakeholder Analysis"]
["Stakeholder","Their Objective","Communication & Consultation Needs"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Internal and External Factors"]
["Factors","Implications"]

{"sheet":"Risk Register","index":2,"n_rows":45,"n_cols":15,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,0,4,2],[2,3,3,3],[6,11,6,14],[6,0,7,0],[6,8,6,10],[6,1,7,1],[6,2,7,2],[6,3,6,7],[2,12,2,14],[3,12,3,14],[0,3,1,10],[2,4,3,10],[4,8,4,10],[4,12,4,14]]}
[null,null,null,"Risk Register for Standard Projects",null,null,null,null,null,null,null,"Template Identifier","240-150388630","Rev",1]
[null,null,null,null,null,null,null,null,null,null,null,"Document Identifier","XXX-XXXXXXX","Rev","X"]
[null,null,null,"Project / Contract title:",null,null,null,null,null,null,null,"Effective Date","2020-07-01"]
[null,null,null,null,null,null,null,null,null,null,null,"Review Date","2025-07-01"]
[null,null,null,"Project / Contract No:",null,"Completed by:",null,"Contact No:",null,null,null,"Assessment Date"]
[]
["#","Notified by","Capture date","Risk Description",null,null,null,null,"Risk Rating",null,null,"Treatment Plan"]
[null,null,null,"Risk event","Possible outcome","Cause","Current Controls","RCE","Cons.","Lik.","Score","Further Action","Resp. person","Target date","Status"]
[1,"S. Nzama","08/07/2024","Scope addition","Cost and schedule overruns ( failure to meet target dates/ budget)","Addition of other areas, identified post scope authorisation","EoP reviews","Mostly Effective","Moderate","Not Anticipated",{"$f":"IFERROR(VLOOKUP((CONCATENATE(I9,\"/\",J9)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"III"},"Meeting with all internal stakholders to confrim all areas are covered.","Sbusiso Nzama"]
[2,"S. Nzama","08/07/2024","Fly Ash","Health - Damage to eyes and lungs","Inhalanation, ingestion and eye irritation of Fly Ash","Adeqaute PPE","Mostly Effective","Significant","Not Anticipated",{"$f":"IFERROR(VLOOKUP((CONCATENATE(I10,\"/\",J10)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"III"},"Adeqaute PPE","Sbusiso Nzama"]
[3,"S. Nzama","08/07/2024","Coal Dust","Health - Damage to eyes and lungs","Inhalanation, ingestion and eye irritation of Coal Dust","Adeqaute PPE","Mostly Effective","Significant","Not Anticipated",{"$f":"IFERROR(VLOOKUP((CONCATENATE(I11,\"/\",J11)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"III"},"Adeqaute PPE","Sbusiso Nzama"]
[4,"S. Nzama","08/07/2024","Slurry Fumes","Health - Damage to eyes and lungs","Inhalanation of Slurry Fumes","Adeqaute PPE","Mostly Effective","Significant","Not Anticipated",{"$f":"IFERROR(VLOOKUP((CONCATENATE(I12,\"/\",J12)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"III"},"Adeqaute PPE","Sbusiso Nzama"]
[5,"S. Nzama","08/07/2024","Elevated posistion","Safety - Fatality, serious injury requiring medical treatment ","Falling from heights","Adeqaute PPE and Life Line","Mostly Effective","Major","Not Anticipated",{"$f":"IFERROR(VLOOKUP((CONCATENATE(I13,\"/\",J13)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"II"},"Adeqaute PPE and Life Line","Sbusiso Nzama"]
[6,"S. Nzama","08/07/2024","Heavy winds","Safety - Fatality, serious injury requiring medical treatment ","Falling from heights","Measure wind speed","Mostly Effective","Major","Not Anticipated",{"$f":"IFERROR(VLOOKUP((CONCATENATE(I14,\"/\",J14)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"II"},"Measure wind speed","Sbusiso Nzama"]
[7,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP((CONCATENATE(I15,\"/\",J15)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"--"}]
[8,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP((CONCATENATE(I16,\"/\",J16)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"--"}]
[9,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP((CONCATENATE(I17,\"/\",J17)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"--"}]
[10,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP((CONCATENATE(I18,\"/\",J18)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"--"}]
[11,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP((CONCATENATE(I19,\"/\",J19)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"--"}]
[12,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP((CONCATENATE(I20,\"/\",J20)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"--"}]
[13,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP((CONCATENATE(I21,\"/\",J21)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"--"}]
[14,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP((CONCATENATE(I22,\"/\",J22)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"--"}]
[15,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP((CONCATENATE(I23,\"/\",J23)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"--"}]
[16,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP((CONCATENATE(I24,\"/\",J24)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"--"}]
[17,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP((CONCATENATE(I25,\"/\",J25)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"--"}]
[18,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP((CONCATENATE(I26,\"/\",J26)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"--"}]
[19,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP((CONCATENATE(I27,\"/\",J27)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"--"}]
[20,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP((CONCATENATE(I28,\"/\",J28)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"--"}]
[21,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP((CONCATENATE(I29,\"/\",J29)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"--"}]
[22,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP((CONCATENATE(I30,\"/\",J30)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"--"}]
[23,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP((CONCATENATE(I31,\"/\",J31)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"--"}]
[24,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP((CONCATENATE(I32,\"/\",J32)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"--"}]
[25,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP((CONCATENATE(I33,\"/\",J33)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"--"}]
[26,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP((CONCATENATE(I34,\"/\",J34)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"--"}]
[27,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP((CONCATENATE(I35,\"/\",J35)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"--"}]
[28,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP((CONCATENATE(I36,\"/\",J36)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"--"}]
[29,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP((CONCATENATE(I37,\"/\",J37)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"--"}]
[30,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP((CONCATENATE(I38,\"/\",J38)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"--"}]
[31,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP((CONCATENATE(I39,\"/\",J39)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"--"}]
[32,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP((CONCATENATE(I40,\"/\",J40)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"--"}]
[33,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP((CONCATENATE(I41,\"/\",J41)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"--"}]
[34,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP((CONCATENATE(I42,\"/\",J42)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"--"}]
[35,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP((CONCATENATE(I43,\"/\",J43)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"--"}]
[36,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP((CONCATENATE(I44,\"/\",J44)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"--"}]
[37,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP((CONCATENATE(I45,\"/\",J45)),'Risk Scoring'!$B$1:$C$30,2,FALSE),\"--\")","v":"--"}]

{"sheet":"Rating Criteria","index":3,"n_rows":15,"n_cols":16,"rows_kept":15,"cut":false,"hidden":false,"merged":[[11,2,11,9],[12,2,12,9],[13,2,13,9],[14,2,14,9],[10,2,10,9],[1,8,2,8],[1,10,2,15],[1,0,2,1],[0,0,0,15],[1,2,1,3],[1,4,1,5],[1,6,2,6],[1,7,2,7],[1,9,2,9],[10,11,12,11],[10,12,12,12],[10,13,12,13],[10,14,12,14],[10,15,12,15]]}
["Consequence Criteria:  without further treatment"]
["Consequence",null,"Cost Range, as\n    %   or      R_Millions",null,"Schedule Range, as\n %      or     Months",null,"Quality","Safety","Environmental","Legal & Compliance","Heat Map"]
[null,null,"Approved Budget",50,"Approved Duration",12]
[6,"Catastrophic","> 20%",{"$f":"IF(D3=\"\",\"-\",\">  R \"&D$3*20%&\" M\")","v":">  R 10 M"},"≥ 35%",{"$f":"IF(F3=\"\",\"-\",\">  \"&F$3*35%&\"m\")","v":">  4.2m"},"Major non-conformance:  project unusable","Single Fatality","Irreversible harm, community outrage, public enquiry","Damages and legal costs > R100m\nClosure across multiple sites / regions.",6,"I","I","I","I","I"]
[5,"Major","≥ 15% - 20%",{"$f":"IF(D3=\"\",\"-\",\"R \"&D$3*15%&\" M  to\"&CHAR(10)&\"R \"&D$3*20%&\" M\")","v":"R 7.5 M  to\nR 10 M"},"≥ 25% - 35%",{"$f":"IF(F3=\"\",\"-\",F$3*25%&\"m  to\"&CHAR(10)&F$3*35%&\"m\")","v":"3m  to\n4.2m"},"Major non-conformance: impacting project ","Fatality","Prolonged harm, high-profile concerns, regulatory enquiry","Damages and legal costs:  R50m - R100m\nClosure across at single site / region.",5,"II","III","II","I","I"]
[4,"Significant","≥ 10% - 15%",{"$f":"IF(D3=\"\",\"-\",\"R \"&D$3*10%&\" M  to\"&CHAR(10)&\"R \"&D$3*15%&\" M\")","v":"R 5 M  to\nR 7.5 M"},"≥ 15% - 25%",{"$f":"IF(F3=\"\",\"-\",F$3*15%&\"m  to\"&CHAR(10)&F$3*25%&\"m\")","v":"1.8m  to\n3m"},"Final product rejected","Multiple S24","Measurable Harm, Complaints","Damages and legal costs:  R10m - R50m. \nBreach: prosecution and/or moderate fine possible.\nDirectives:  < 6 month compliance period.",4,"III","III","II","I","I"]
[3,"Moderate","≥ 5% - 10%",{"$f":"IF(D3=\"\",\"-\",\"R \"&D$3*5%&\" M  to\"&CHAR(10)&\"R \"&D$3*10%&\" M\")","v":"R 2.5 M  to\nR 5 M"},"≥ 10% - 15%",{"$f":"IF(F3=\"\",\"-\",F$3*10%&\"m  to\"&CHAR(10)&F$3*15%&\"m\")","v":"1.2m  to\n1.8m"},"Functionality affected","Lost Time / S24","Immaterial effect","Damages and legal costs < R10m.\nBreach with punitive fine.\nDirectives:  > 6 month compliance period.",3,"IV","III","II","II","I"]
[2,"Minor","≥ 2% - 5%",{"$f":"IF(D3=\"\",\"-\",\"R \"&D$3*2%&\" M  to\"&CHAR(10)&\"R \"&D$3*5%&\" M\")","v":"R 1 M  to\nR 2.5 M"},"≥ 5% - 10%",{"$f":"IF(F3=\"\",\"-\",F$3*5%&\"m  to\"&CHAR(10)&F$3*10%&\"m\")","v":"0.6m  to\n1.2m"},"Concession required","Medical"," Some clean-up Costs","Minor legal issues, non-compliances and breaches.",2,"IV","IV","III","II","II"]
[1,"Insignificant"," < 2%",{"$f":"IF(D3=\"\",\"-\",\"<  R \"&D$3*2%&\" M\")","v":"<  R 1 M"},"< 5%",{"$f":"IF(F3=\"\",\"-\",\"<  \"&F$3*5%&\"m\")","v":"<  0.6m"},"No Impact","First Aid","Negligible","Very minor breaches.",1,"IV","IV","III","III","III"]
[null,null,null,null,null,null,null,null,null,null,null,"A","B","C","D","E"]
[null,"RCE","Risk Control Effectiveness Guide",null,null,null,null,null,null,null,null,"Unlikely","Not Anticipated","Possible","Probable","Imminent"]
[null,"Fully effective","Nothing more to be done except review and monitor the existing controls. Controls are well designed for the risk, are largely preventative and address the root causes and Management believes that they are effective and reliable at all times. Reactive controls only support preventative controls."]
[null,"Mostly effective","Most controls are designed correctly and are in place and effective. Some more work to be done to improve operating effectiveness or Management has doubts about operational effectiveness and reliability of the controls."]
[null,"Mostly ineffective","While the design of controls may be largely correct in that they treat most of the root causes of the risk, they are not currently operationally very effective. There may be an over-reliance on reactive controls, or Some of the controls do not seem correctly designed in that they do not treat root causes.",null,null,null,null,null,null,null,null,"<5%",">5%",">20%",">70%",">90%"]
[null,"None","Virtually no credible control. Management has no confidence that any degree of control is being achieved due to poor control design and/or very limited operational effectiveness."]

{"sheet":"Manual Form","index":4,"n_rows":185,"n_cols":7,"rows_kept":185,"cut":false,"hidden":false,"merged":[[29,5,29,6],[33,0,33,6],[34,0,34,6],[36,0,36,3],[40,5,40,6],[35,0,35,3],[40,0,40,4],[0,0,4,0],[17,5,17,6],[21,0,21,6],[22,0,22,6],[1,2,3,4],[0,1,0,4],[4,2,4,4],[6,0,6,4],[6,5,6,6],[10,0,10,6],[11,0,11,6],[1,1,3,1],[12,0,12,3],[13,0,13,3],[14,0,14,3],[15,0,15,3],[16,0,16,6],[44,0,44,6],[45,0,45,6],[52,5,52,6],[56,0,56,6],[57,0,57,6],[46,0,46,3],[52,0,52,4],[58,0,58,3],[69,0,69,3],[121,5,121,6],[125,0,125,6],[126,0,126,6],[115,0,115,3],[121,0,121,4],[127,0,127,3],[116,0,116,3],[117,0,117,3],[118,0,118,3],[178,5,178,6],[182,0,182,6],[183,0,183,6],[167,5,167,6],[148,0,148,6],[149,0,149,6],[171,0,171,6],[172,0,172,6],[155,5,155,6],[159,0,159,6],[160,0,160,6],[132,5,132,6],[136,0,136,6],[137,0,137,6],[144,5,144,6],[132,0,132,4],[138,0,138,3],[144,0,144,4],[139,0,139,3],[140,0,140,3],[141,0,141,3],[113,0,113,6],[114,0,114,6],[71,0,71,3],[72,0,72,3],[82,0,82,3],[83,0,83,3],[84,0,84,3],[105,0,105,3],[106,0,106,3],[107,0,107,3],[103,0,103,6],[109,5,109,6],[98,0,98,4],[104,0,104,3],[109,0,109,4],[79,0,79,6],[80,0,80,6],[86,5,86,6],[90,0,90,6],[91,0,91,6],[81,0,81,3],[86,0,86,4],[92,0,92,3],[75,0,75,4],[17,0,17,4],[23,0,23,3],[24,0,24,3],[25,0,25,3],[26,0,26,3],[29,0,29,4],[28,0,28,6],[98,5,98,6],[102,0,102,6],[93,0,93,3],[63,5,63,6],[67,0,67,6],[68,0,68,6],[75,5,75,6],[63,0,63,4],[37,0,37,3],[38,0,38,3],[47,0,47,3],[48,0,48,3],[49,0,49,3],[59,0,59,3],[60,0,60,3],[61,0,61,3],[70,0,70,3],[187,0,187,3],[94,0,94,3],[95,0,95,3],[128,0,128,3],[129,0,129,3],[130,0,130,3],[162,0,162,3],[163,0,163,3],[164,0,164,3],[151,0,151,3],[152,0,152,3],[153,0,153,3],[174,0,174,3],[175,0,175,3],[176,0,176,3],[185,0,185,3],[186,0,186,3],[150,0,150,3],[155,0,155,4],[161,0,161,3],[167,0,167,4],[173,0,173,3],[178,0,178,4],[184,0,184,3]]}
[null,"Manual Risk Capture Form for Site Meetings",null,null,null,"Template No.","240-150388630"]
[null,"Project / Contract title:",null,null,null,"Template Rev.","1"]
[null,null,null,null,null,"Completed by:"]
[null,null,null,null,null,"Contact No:"]
[null,"Project / Contract No:",null,null,null,"Date:"]
[]
["Risk Description",null,null,null,null,"Risk Rating"]
["Risk event","Possible outcome","Cause","Current Controls","Control Effectiveness","Consequence","Likelihood"]
["\"Something happens\"","\"leading to…\"","\"caused by…\"","\"controlled by…\"",null,"to objectives","of consequence"]
[]
[]
["Treatment Plan"]
["Further Action",null,null,null,"Responsible person","Target date","Status"]
[]
[]
[]
[]
["Risk Description",null,null,null,null,"Risk Rating"]
["Risk event","Possible outcome","Cause","Current Controls","Control Effectiveness","Consequence","Likelihood"]
["\"Something happens\"","\"leading to…\"","\"caused by…\"","\"controlled by…\"",null,"to objectives","of consequence"]
[]
[]
["Treatment Plan"]
["Further Action",null,null,null,"Responsible person","Target date","Status"]
[]
[]
[]
[]
[]
["Risk Description",null,null,null,null,"Risk Rating"]
["Risk event","Possible outcome","Cause","Current Controls","Control Effectiveness","Consequence","Likelihood"]
["\"Something happens\"","\"leading to…\"","\"caused by…\"","\"controlled by…\"",null,"to objectives","of consequence"]
[]
[]
["Treatment Plan"]
["Further Action",null,null,null,"Responsible person","Target date","Status"]
[]
[]
[]
[]
["Risk Description",null,null,null,null,"Risk Rating"]
["Risk event","Possible outcome","Cause","Current Controls","Control Effectiveness","Consequence","Likelihood"]
["\"Something happens\"","\"leading to…\"","\"caused by…\"","\"controlled by…\"",null,"to objectives","of consequence"]
[]
[]
["Treatment Plan"]
["Further Action",null,null,null,"Responsible person","Target date","Status"]
[]
[]
[]
[]
[]
["Risk Description",null,null,null,null,"Risk Rating"]
["Risk event","Possible outcome","Cause","Current Controls","Control Effectiveness","Consequence","Likelihood"]
["\"Something happens\"","\"leading to…\"","\"caused by…\"","\"controlled by…\"",null,"to objectives","of consequence"]
[]
[]
["Treatment Plan"]
["Further Action",null,null,null,"Responsible person","Target date","Status"]
[]
[]
[]
[]
["Risk Description",null,null,null,null,"Risk Rating"]
["Risk event","Possible outcome","Cause","Current Controls","Control Effectiveness","Consequence","Likelihood"]
["\"Something happens\"","\"leading to…\"","\"caused by…\"","\"controlled by…\"",null,"to objectives","of consequence"]
[]
[]
["Treatment Plan"]
["Further Action",null,null,null,"Responsible person","Target date","Status"]
[]
[]
[]
[]
[]
["Risk Description",null,null,null,null,"Risk Rating"]
["Risk event","Possible outcome","Cause","Current Controls","Control Effectiveness","Consequence","Likelihood"]
["\"Something happens\"","\"leading to…\"","\"caused by…\"","\"controlled by…\"",null,"to objectives","of consequence"]
[]
[]
["Treatment Plan"]
["Further Action",null,null,null,"Responsible person","Target date","Status"]
[]
[]
[]
[]
["Risk Description",null,null,null,null,"Risk Rating"]
["Risk event","Possible outcome","Cause","Current Controls","Control Effectiveness","Consequence","Likelihood"]
["\"Something happens\"","\"leading to…\"","\"caused by…\"","\"controlled by…\"",null,"to objectives","of consequence"]
[]
[]
["Treatment Plan"]
["Further Action",null,null,null,"Responsible person","Target date","Status"]
[]
[]
[]
[]
[]
["Risk Description",null,null,null,null,"Risk Rating"]
["Risk event","Possible outcome","Cause","Current Controls","Control Effectiveness","Consequence","Likelihood"]
["\"Something happens\"","\"leading to…\"","\"caused by…\"","\"controlled by…\"",null,"to objectives","of consequence"]
[]
[]
["Treatment Plan"]
["Further Action",null,null,null,"Responsible person","Target date","Status"]
[]
[]
[]
[]
["Risk Description",null,null,null,null,"Risk Rating"]
["Risk event","Possible outcome","Cause","Current Controls","Control Effectiveness","Consequence","Likelihood"]
["\"Something happens\"","\"leading to…\"","\"caused by…\"","\"controlled by…\"",null,"to objectives","of consequence"]
[]
[]
["Treatment Plan"]
["Further Action",null,null,null,"Responsible person","Target date","Status"]
[]
[]
[]
[]
[]
["Risk Description",null,null,null,null,"Risk Rating"]
["Risk event","Possible outcome","Cause","Current Controls","Control Effectiveness","Consequence","Likelihood"]
["\"Something happens\"","\"leading to…\"","\"caused by…\"","\"controlled by…\"",null,"to objectives","of consequence"]
[]
[]
["Treatment Plan"]
["Further Action",null,null,null,"Responsible person","Target date","Status"]
[]
[]
[]
[]
["Risk Description",null,null,null,null,"Risk Rating"]
["Risk event","Possible outcome","Cause","Current Controls","Control Effectiveness","Consequence","Likelihood"]
["\"Something happens\"","\"leading to…\"","\"caused by…\"","\"controlled by…\"",null,"to objectives","of consequence"]
[]
[]
["Treatment Plan"]
["Further Action",null,null,null,"Responsible person","Target date","Status"]
[]
[]
[]
[]
[]
["Risk Description",null,null,null,null,"Risk Rating"]
["Risk event","Possible outcome","Cause","Current Controls","Control Effectiveness","Consequence","Likelihood"]
["\"Something happens\"","\"leading to…\"","\"caused by…\"","\"controlled by…\"",null,"to objectives","of consequence"]
[]
[]
["Treatment Plan"]
["Further Action",null,null,null,"Responsible person","Target date","Status"]
[]
[]
[]
[]
["Risk Description",null,null,null,null,"Risk Rating"]
["Risk event","Possible outcome","Cause","Current Controls","Control Effectiveness","Consequence","Likelihood"]
["\"Something happens\"","\"leading to…\"","\"caused by…\"","\"controlled by…\"",null,"to objectives","of consequence"]
[]
[]
["Treatment Plan"]
["Further Action",null,null,null,"Responsible person","Target date","Status"]
[]
[]
[]
[]
[]
["Risk Description",null,null,null,null,"Risk Rating"]
["Risk event","Possible outcome","Cause","Current Controls","Control Effectiveness","Consequence","Likelihood"]
["\"Something happens\"","\"leading to…\"","\"caused by…\"","\"controlled by…\"",null,"to objectives","of consequence"]
[]
[]
["Treatment Plan"]
["Further Action",null,null,null,"Responsible person","Target date","Status"]
[]
[]
[]
[]
["Risk Description",null,null,null,null,"Risk Rating"]
["Risk event","Possible outcome","Cause","Current Controls","Control Effectiveness","Consequence","Likelihood"]
["\"Something happens\"","\"leading to…\"","\"caused by…\"","\"controlled by…\"",null,"to objectives","of consequence"]
[]
[]
["Treatment Plan"]
["Further Action",null,null,null,"Responsible person","Target date","Status"]

{"sheet":"Complete Eskom Rating Scales","index":5,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Consequence Criteria"]
[]
[null,"Criteria ","Financial Sustainability \nEBITDA = Revenue - Opex - PE","Operations","Sustainable Asset Creation","Environmental & Climate Change Sustainability","Legal & Compliance","Reputation ","Health and Safety","Information Management"]
[6,"Beyond Eskom Impact - National","Net position between Revenue and operational expenditure\n> R3Bn\nImpact:\nCatastrophic impact (financial and business operations) that threatens the existence of Eskom","GWh lost:\n>5000GWh (Unable to meet demand by equivalent of a PS unit for a period of 3 months)\nNational load shedding \n> six months.\nNational blackout: \nEnormous impact on country from image, economic, point of view.\n","Project Cost: \n> 20%\nSchedule deviate: \n> 35% delay\nQuality: \nCatastrophic - Major non-conformance that would result in a chain reaction that has huge negative impact on the plant. Project outcomes effectively unusable.","Community:\n* Irreversible long term environmental harm\n* Community outrage due to environmental harm in the area- potential large-scale class action (legal). e.g. greenhouse gas emissions, continued use of coal)\nRegulation and Legal:\n* Public inquiry by Government agency\n* Environmental licence revoked\n* Potential for significant legal sanctions against Eskom\n* Stringent carbon budgets and taxes imposed\nPhysical changes to the Climate:\n* Major generation and transmission infrastructure damage due to severe climate events\n* Inadequate water supply for power generation                                                                          ","Legal and Compliance:\n* Major litigation or prosecution with damages including costs in excess of R100m\n* Custodial sentence for Chief Executive.\n* Custodial sentence for multiple company Executives.\n* Closure of operations by authorities across multiple sites / regions.\n* Inability to meet suspensive conditions in multiple loan agreement","Reputation:\n* Sustained adverse international / national press reporting over several weeks\n* Prolonged loss of shareholder/ client confidence and community support\n* Critical event that the organisation would be forced to undergo significant change","Fatalities:\nMultiple Fatalities \n\n","Cyber-resiliency - Malicious damage to computer networks or systems resulting in widespread prolonged national supply interruptions and the ongoing inability to safely operate or restore supply to the country\nData confidentiality - Disclosure of sensitive and/or confidential data and information could lead to ongoing community unrest,  sabotage of operations, damage to Eskom's credit rating and reputation(nationally and abroad) plus result in litigation\nCritical System/Data Availability - Major loss of or unavailability of mission critical systems and/or data throughout Eskom could severely impact Eskom's revenue, profitability, license to operate, credit rating and reputation\nInformation/data governed as a corporate asset - Failure to fulfil Eskom's fiduciary duties pertaining to the treatment of data/information as a corporate asset, could result in investigations, liability and harm to Eskom's reputation"]
[5,"Beyond Eskom Impact - Regional","Net position between Revenue and operational expenditure\nBetween R1Bn and R3Bn\nImpact:\nSevere financial loss and  / or impairment impacting financial health and business operations","GWh lost:                       \n500 – 5000GWh (Unable to meet demand by equivalent of PS Unit for a period of 1 month)\nRegional blackout:\nLasting <60hrs\nNational load shedding: \nStage 2. Loss of critical supply to critical customer for an extended period (deep level mines, smelters etc.)  \n\n","Project cost deviate: \n> 15% and ≤ 20%\nSchedule deviate:\n> 25% and  ≤ 35% delay\nQuality: \nSevere – Major non-conformance that would results in a few chain reactions, negatively impacting project outcome.","Community:\n* Prolonged environmental impact\n* High-profile community concerns raised – requiring significant rectification measures\nRegulation and Legal:\n* Government agency inquiry\n* Environmental licences revoked and directives issued\n* Significant financial penalties due to non -compliance with carbon emission limits\nPhysical Changes to the Climate:\n* Significant impact on infrastructure - long lead times for repairs\n* Eskom's water allowance reduced due to inadequate supply of water","Legal and Compliance:\n* Major litigation or prosecution with damages including costs between R50m and R100m.\n* Custodial sentence for a company Executive.\n* Closure of operations by authorities at single sites / region.\n* Inability to meet sus pensive conditions in any loan agreement\n","Reputation:\n* Significant event that would require ongoing management and brings the organisation into the national / international spotlight\n* Sustained adverse national press reporting over several days\n* Sustained impact on the reputation of Eskom / Rotek / Roshcon\n* Loss of Government trust\n* Executive management restructure","Fatality:\nSingle fatality\n\n","Cyber-resiliency - Malicious damage to computer networks or systems resulting in prolonged regional supply interruptions and the inability to safely operate or restore supply to the region\nData confidentiality - The disclosure of confidential / sensitive data to unauthorised employees could result in labour unrest in specific regions\nCritical System/Data Availability - Major loss of or unavailability of mission critical systems and/or data throughout an Eskom region could severely impact on a region's revenue and profitability\nInformation/data governed as a corporate asset - Governance structures to be aligned across divisions in all regions ensuring protection and enhancement of data\nData integrity - Incorrect decisions based on corrupt regional data, resulting in regional inefficiencies"]
[4,"Divisional Impact across Eskom","Net position between Revenue and operational expenditure\nBetween R100m and R1Bn\nImpact:\nSignificant financial loss and  / or impairment impacting financial health and business operations","GWh lost:\n100 – 500GWh (Unable to meet demand by equivalent of PS Unit for a period of 1 month) \nRegional blackout:\nLasting <6hrs.\n National load shedding:\nStage 1. Loss of supply to major Centre or customer for >12 hrs.","Project cost deviate: \n> 10% and ≤ 15%\nSchedule deviate: \n> 15% and  ≤ 25% delay\nQuality: \nSubstantial - Major non-conformance resulting in scrapping of product.  Product that is not fit for the purpose.","Community:\n* Measurable environmental harm – medium term recovery\n* High potential for complaints from stakeholders and community\nRegulation and Legal:\n* Environmental directives issued by authorities\n* Carbon budgets imposed with grace period for compliance (5 years)\nPhysical changes to the Climate:\nSignificant climate events - plant unavailability or impact on coal supply (e.g. flooding) or unavailability of water","Legal and Compliance:\n* Litigation or prosecution with damages including costs between R10m and R50m. \n* Major breach of regulation with punitive fine.\n* Significant litigation involving many weeks of senior management time.\n* Legal / Regulatory directives issued by authorities with < 6 month compliance notice period\n","Reputation:\n* Major event that causes adverse national media reporting – over several days\n* Minister raises concerns","Section 24 injury\nMultiple Sect. 24 injured, irreversible disability or impairment cases due to single incident\n\n","Cyber-resiliency\nMalicious attempts to damage or disrupt computer networks or systems, could disrupt core operations in other divisions\nData confidentiality\nConfidential / sensitive data in a division could be leaked to unauthorised employees\nInformation/data governed as a corporate asset\nDivisional structures to be aligned across divisions ensuring protection and enhancement of data\nData integrity\nIncorrect decisions based on corrupt data from divisional sources, resulting in inefficiencies\nData availability\nInterdependency of data across divisions compromised "]
[3,"Divisional Impact ","\nNet position between Revenue and operational expenditure\nBetween R50m and R100m\nImpact:\nModerate financial loss and  / or impairment impacting financial health and business operations","\nGWh lost:\n10 – 100GWh (based on 1 month of up to 100 MW partial load loss) \nLocal loss of supply:\nEffecting >10,000 customers (<50MW) for >12hrs.              ","Project cost deviate: \n> 5% and ≤ 10%\nSchedule deviate: \n> 10% and  ≤ 15% delay\nQuality: \nSignificant - Standard requirements not met and rework needed. Significant elements of scope or functionality are affected.","Community:\nMedium term recovery, immaterial effect on environment / community\nRegulation and Legal:\n* Required to inform Government agency, (e.g.: noise, dust)\n* Carbon emission limits imposed but not linked to penalties\nPhysical changes to the Climate:\nMinor climate events that result in partial unavailability of plant (few hours as opposed to months - e.g. flash floods)","Legal and Compliance:\n* Litigation or prosecution with damages including costs less than R10m.\n* Breach of regulation with investigation or report to authority with prosecution and/or moderate fine possible.\n* Legal / Regulatory directives issued by authorities with > 6 month compliance notice period\n","Reputation:\n* Serious event that can be readily managed but management effort is still required to minimise impact locally\n* Adverse local media reporting\n* Disciplinary action likely","Lost time injury:\nMultiple Lost time injured and/or extensive injuries or irreversible disability or impairment to one person (Sect. 24)","Cyber-resiliency - Malicious attempts to damage or disrupt computer networks or systems, could disrupt core operations performed by BUs/departments within a division\nData confidentiality - Confidential / sensitive data in a division could be leaked to unauthorised employees within a division\nInformation/data governed as a corporate asset - BU structures to be aligned across different BUs ensuring protection and enhancement of data\nData integrity - Incorrect decisions based on corrupt data from BU sources, resulting in inefficiencies \nData availability - Interdependency of data across BUs compromised"]
[2,"Business Unit Impact ","Net position between Revenue and operational expenditure\nBetween R10m and R50m\nImpact:\nMinor financial loss and  / or impairment impacting financial health and business operations","GWh lost:\n1 – 10GWh (based on 1 month of 10 MW partial load loss)\nLocal loss of supply:\nLoss of supply to large customer or affecting >10,000 customers for <4hrs. Loss of large load Centre for <2 hours (typically between 0.1 and1 system minutes)    ","Project cost deviate: \n> 2% and ≤ 5%\nSchedule deviate: \n> 5% and  ≤ 10% delay\nQuality: \nModerate - Requirements not met but requires concession. Failure to include certain elements promised to stakeholders.","Community:\nShort term transient environmental or community impact- some clean-up costs\nRegulation and Legal:\nCarbon emission limits imposed but not linked to penalties                                 \nPhysical changes to the Climate:\nClimate events have minor impact on infrastructure performance ","Legal and Compliance:\nMinor legal issues, non-compliances and breaches of regulation.","Reputation:\n* Event that site management can readily manage internally\n* No press reporting or external interest\n* Disciplinary action may be taken","Medical Treatment:                                                                                                                                                                                      Medical treatment cases or single lost time injury \n","Cyber-resiliency - Malicious attempts to damage or disrupt computer networks or systems could disrupt core operations performed by departments/BU \nData confidentiality - Confidential / sensitive data in a BU could be leaked to unauthorised employees within a BU \nInformation/data governed as a corporate asset - BU structures to be aligned across different departments ensuring protection and enhancement of data\nData integrity - Incorrect decisions based on corrupt data from departmental sources, resulting in inefficiencies \nData availability - Interdependency of data across departments compromised "]
[1,"Departmental Impact ","Net position between Revenue and operational expenditure\nBetween R1m and R10m\nImpact:\nInsignificant – no apparent disruption","\nGWh lost:\n<1 GWh (based on 1 month of 1 MW partial load loss)\nLocal loss of supply:\nLoss of supply to some customers (normal interruption) effects 3,000 customers for <4hrs. <0.1 System minute incident","Project cost deviate:\n≤ 2%\nSchedule deviate:  \n≤ 5% delay\nQuality: \nMinor - Slight deviation from specified requirements. Has no overall impact on usability / standards.","Community:\nNegligible impact on the environment, little to no ecological effect and no measurable impact on human health \nPhysical changes to the Climate:\nMinor climate events that do not impact on infrastructure performance","Legal and Compliance:\nVery minor breaches.","Reputation:\n* Entirely an internal issue\n* Attention is confined to site","First Aid: \nFirst aid treatment or minor injuries requiring no treatment","Cyber-resiliency - Malicious attempts to damage or disrupt computer networks or systems that could disrupt core operations performed by specific departments\nData confidentiality - Confidential / sensitive data in a department could be leaked to unauthorised employees within a department \nInformation/data governed as a corporate asset - Departmental structures to be aligned across systems and data bases ensuring protection and enhancement of data\nData integrity - Incorrect decisions based on corrupt data from departmental sources, resulting in departmental inefficiencies\nData availability - Interdependency of data across department specific systems compromised "]
["Current Purpose",null,"The purpose of financial sustainability is to move the organisation towards a state where its rate of return on assets is equal to the cost of capital and to ensure that Eskom remains a going concern is able to meet its short-term liquidity requirements as well as service long-term debt and financial commitments.","Operations aims to deliver effective and efficient operations of all current assets of the value chain throughout their lifespan. This includes successful implementation of Generation Sustainability strategy (including the 80:10:10 plan) and improving current performance levels with Transmission, Distribution and Customer Services.","Effective execution of capital projects and real estate management enabled by a project management centre of excellence in support of reliability and security of power generation and supply to foster economic growth and social prosperity","Environmental and Climate Change sustainability aims to address the linkages between environmental management and operational sustainability. This includes environmental impact assessments, air quality, land and biodiversity, water and waste/ash management. Environmental compliance is critical to ensuring that Eskom maintains its licence to operate, keeps the lights on and meets its “zero harm” mandate.","The purpose of Legal and Compliance is to ensure that Eskom conducts its business within its “licence to operate” by ensuring good governance and compliance with current policy, regulatory and legal frameworks; and to influence the policy, regulatory and legal frameworks required for achieving Eskom’s strategic objectives.","Building a solid reputation aims to improve Eskom’s overarching current reputation and positions the organisation as a key driver for economic growth. Eskom is pursuing a number of specific actions to safeguard and improve its reputation. This is to protect existing customer bases (and ensure our sustainability) and to ensure stakeholder alignment."," Eskom is committed to ensuring occupational and health and safety across all line divisions and functions. The company’s safety principle is that no operating condition or urgency of service justifies exposing anyone to injury or safety or  environmental risks arising out of Eskom’s business. It follows that occupational health and safety of Eskom employees, contractors and the public at large, is of critical importance to Eskom.","Group IT is committed to lead the Eskom business in Digital Transformation and in doing so applying the established ICT principles to new digitised sources of business data/information and operating technology systems/applications in order to ensure Eskom's alignment to Cobit (as per King IV on Corporate Governance) and other applicable regulations and acts.  Furthermore, in light of the King IV separation of technology and information (data) as a corporate asset, Group IT will advise the Eskom business on the necessary business governance structures and enterprise information management roles needed at different levels of the organisation to protect and enhance Eskom data/information as a corporate asset."]

{"sheet":"Risk Scoring","index":6,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":true,"merged":[[20,0,24,0],[25,0,29,0],[0,0,4,0],[5,0,9,0],[10,0,14,0],[15,0,19,0]]}
[6,"Catastrophic/Imminent","I"]
[null,"Catastrophic/Probable","I"]
[null,"Catastrophic/Possible","I"]
[null,"Catastrophic/Not Anticipated","I"]
[null,"Catastrophic/Unlikely","I"]
[5,"Major/Imminent","I"]
[null,"Major/Probable","I"]
[null,"Major/Possible","II"]
[null,"Major/Not Anticipated","II"]
[null,"Major/Unlikely","II"]
[4,"Significant/Imminent","I"]
[null,"Significant/Probable","I"]
[null,"Significant/Possible","II"]
[null,"Significant/Not Anticipated","III"]
[null,"Significant/Unlikely","III"]
[3,"Moderate/Imminent","I"]
[null,"Moderate/Probable","II"]
[null,"Moderate/Possible","II"]
[null,"Moderate/Not Anticipated","III"]
[null,"Moderate/Unlikely","IV"]
[2,"Minor/Imminent","II"]
[null,"Minor/Probable","II"]
[null,"Minor/Possible","III"]
[null,"Minor/Not Anticipated","IV"]
[null,"Minor/Unlikely","IV"]
[1,"Insignificant/Imminent","III"]
[null,"Insignificant/Probable","III"]
[null,"Insignificant/Possible","III"]
[null,"Insignificant/Not Anticipated","IV"]
[null,"Insignificant/Unlikely","IV"]