{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Read ME","Risk Register","Dashboard","Definitions","Validation"],"not_rendered":{"charts":4,"images":1,"external_links":1,"defined_names":15},"read":"whole","date_system":"1900"}

{"sheet":"Read ME","index":0,"n_rows":15,"n_cols":1,"rows_kept":15}
["Please Read"]
[]
["Dear User, thank you for using my template."]
[]
["You downloaded this Excel template free of charge from "]
["http://project-management.magt.biz"]
["You may use it for your personal use and the projects you manage. However, selling the template or offering it for download on your own website are strictly prohibited.\nI hope you like my templates and would be happy if you would share my website link on Facebook, Twitter etc. and return to my website to check for further templates and leave a comment with your improvement suggestions."]
[]
["The Risk Register containa a few sample entries. Please delete/overwrite those entries."]
[]
["Make entries only in cells with blue font-color / italic font"]
[]
["If you want to add rows to the register mark any cell in the last line and press the \"TAB\" key repeatedly until a new line is added. Alternatively you can just start typing in the first column of the first empty row under the last register entry.\nFormulas and formats are copied down automatically. The dashboard updates automatically."]
[]
["Entries to some register columns are limited. Please check/update the sheet \"Validation\" prior to using the register for the first time. Later changes to the Validation sheet while the register is actually in use should be avoided, or otherwise entries to the Validation tables may be added, but existing values shouldn't be deleted or altered."]

{"sheet":"Risk Register","index":1,"n_rows":23,"n_cols":17,"rows_kept":23,"merged":[[0,0,0,1],[0,2,0,4],[0,14,0,15],[1,0,1,1],[1,2,1,4],[1,14,1,15],[2,0,2,5],[2,6,2,10],[2,11,2,13],[2,14,2,16]]}
["Project Name:",null,"[Project Name]",{"$nulls":11},"Last Updated Date:",null,"[last updated]"]
["Project Manager:",null,"[Project Manager]",{"$nulls":11},"Last Updated by:",null,"[updated by]"]
["Identification",{"$nulls":5},"Assessment",{"$nulls":4},"Strategy",null,null,"Monitoring"]
["#","Category","Opportunity or Threat","Risk Name","Risk Description","Risk Related to Activity","Probability","Impact","Severity","Estimated Monetary Value - EMV (USD)","Schedule Impact (WD)","Response Strategy","Strategy Description","Risk Owner","Status","Lat Update","Comments"]
[{"v":1,"d":"001"},"Design","Threat (T)","Design Risk","Inadequate design or wrong assumptions, could make the product fail and unsuitable for intended purpose.","all",1,5,{"$f":"Risk_Register[[#This Row],[Probability]]*Risk_Register[[#This Row],[Impact]]*(ROW()/(ROW()-0.01))","v":{"v":5.0100200400801596,"d":"5.010"}},{"v":10000,"d":"10,000"},2,"Accept (T&O)","[company] is not the product designer nor the reviewer and thus has little influence on the risk.",null,"Inactive","2017-09-14"]
[{"v":2,"d":"002"},"Construction","Threat (T)","Supplier or Sub-Contractor incapable","Contractor, sub-contractor or supplier incapable to follow construction specifications, requirements or expectations resulting in delays and consequently cost overruns.","all",1,3,{"$f":"Risk_Register[[#This Row],[Probability]]*Risk_Register[[#This Row],[Impact]]*(ROW()/(ROW()-0.01))","v":{"v":3.005008347245409,"d":"3.005"}},{"v":20000,"d":"20,000"},3,"Mitigate (T)","Monitor performance and have alternative solution (plan B).","PM, Procurement","Inactive","2017-09-14"]
[{"v":3,"d":"003"},"Construction","Threat (T)","Technical Factors","Changes in work process or work package sequence, gaps between theory and actual work QTYs, could lead to schedule and consequently cost impacts.","all",2,4,{"$f":"Risk_Register[[#This Row],[Probability]]*Risk_Register[[#This Row],[Impact]]*(ROW()/(ROW()-0.01))","v":{"v":8.011444921316166,"d":"8.011"}},{"v":30000,"d":"30,000"},4,"Mitigate (T)","It is a matter of fact that many locations cannot be worked on due to pending community compensation by KETRACO). Thus the risk became rather an issue. [company] tracks and records the impact and claims for it.\nQTYs are not a risk due to type of contract (measurable).","PM, Constr. Mngr.","Active","2017-09-14"]
[{"v":4,"d":"004"},"Construction","Threat (T)","Site and layout conditions","Interruptions in site access and interference in the flow of work could result in delays and consequently additional cost.","all",2,2,{"$f":"Risk_Register[[#This Row],[Probability]]*Risk_Register[[#This Row],[Impact]]*(ROW()/(ROW()-0.01))","v":{"v":4.005006257822278,"d":"4.005"}},{"v":40000,"d":"40,000"},5,"Mitigate (T)","Similar to risk no. 3 above this is not anymore a risk, but rather an issue and triggered severally when communities blocked access to the work site. [company] has very little influence and can only track and record the impact in order to claim the extra cost.\n[company] on their site are in contact with the communities and keep them informed about the ongoing works.","PM, HSSE Mngr., Constr. Mngr.","Active","2017-09-14"]
[{"v":5,"d":"005"},"Construction","Threat (T)","Physical Factors","Topography, unforeseen subsurface conditions, ground water, rocks, material unsuitability and other conditions could require extra effort and would consequently have cost and probably time impact.","Excavating, backfilling",1,2,{"$f":"Risk_Register[[#This Row],[Probability]]*Risk_Register[[#This Row],[Impact]]*(ROW()/(ROW()-0.01))","v":{"v":2.0022246941045605,"d":"2.002"}},{"v":50000,"d":"50,000"},6,"Mitigate (T)","Similar to risk no. 3 above this is not anymore a risk, but rather an issue.\nIn accordance with pre-contract information only a small number foundations would require rock excavating. The reality proves different. Extra rates apply.","PM, Constr. Mngr.","Active","2017-09-14"]
[{"v":6,"d":"006"},"Construction","Threat (T)","Security factors","Corruption, theft, vandalism, sabotage, can cause extra cost and may have schedule impact.","all",4,3,{"$f":"Risk_Register[[#This Row],[Probability]]*Risk_Register[[#This Row],[Impact]]*(ROW()/(ROW()-0.01))","v":{"v":12.012012012012013,"d":"12.012"}},{"v":60000,"d":"60,000"},7,"Transfer (T)","Similar to risk no. 3 above this is not anymore a risk, but rather an issue an triggered severally.\n[company] employed security personal to safe guard material and equipment at site.\nInsurrances are in place.","PM, HSSE Mngr., Constr. Mngr.","Active","2017-09-14"]
[{"v":7,"d":"007"},"Construction","Threat (T)","Procurement Factors","Insolvency of a party or inadequate change introduction can impact the schedule and cost of works execution.","all",1,5,{"$f":"Risk_Register[[#This Row],[Probability]]*Risk_Register[[#This Row],[Impact]]*(ROW()/(ROW()-0.01))","v":{"v":5.004549590536852,"d":"5.005"}},{"v":70000,"d":"70,000"},8,"Accept (T&O)","Similar to risk no. 3 above this is not anymore a risk, but rather an issue an triggered.\n[company] has no influence on other party insolvency and henceforth can only accept the risk.","PM, Project Sponsor","Active","2017-09-14","It seems recommendable to check for availability of insurance that covers this particular risk in the future."]
[{"v":8,"d":"008"},"Construction","Threat (T)","Performance factors","Defective works, labor disputes, inefficient productivity, can hinder the progress and thus have schedule and consequently cost impact.","all",2,1,{"$f":"Risk_Register[[#This Row],[Probability]]*Risk_Register[[#This Row],[Impact]]*(ROW()/(ROW()-0.01))","v":{"v":2.0016680567139282,"d":"2.002"}},{"v":80000,"d":"80,000"},9,"Mitigate (T)","Defects are unavoidalbe given the number of 1160 foundations. Inspection prior concreteing and supervision while executing activities mitigates the probability.\nLabour disputes have arisen already and where hard to forecast since such disputes in the particular work environment arise from nothing and are usually unreasonable and unlegal. HR department is aware and is in contact with the workers on the ground and communicates changes and the like timely and frequently in advance.","PM, HR Deptm.","Active","2017-09-14"]
[{"v":9,"d":"009"},"External","Threat (T)","Contractual factors","Client’s requirements and expectations higher than documented and weak definition of objectives, can result in extra effort and consequently have cost and possibly schedule impact.","all",1,4,{"$f":"Risk_Register[[#This Row],[Probability]]*Risk_Register[[#This Row],[Impact]]*(ROW()/(ROW()-0.01))","v":{"v":4.003079291762894,"d":"4.003"}},{"v":90000,"d":"90,000"},10,"Mitigate (T)","Changes to requirements, expetations as well as scope of works shall be analyzed and transferred to the change control board for decision and may rsult in change request(s).","PM","Inactive","2017-09-14"]
[{"v":10,"d":"010"},"External","Threat (T)","Force majeure factors","Unforeseen market changes, economic and political instability, adverse weather conditions, and similar unforeseeable events could lead to disruptions, delays and consequently cost impact.","all",1,5,{"$f":"Risk_Register[[#This Row],[Probability]]*Risk_Register[[#This Row],[Impact]]*(ROW()/(ROW()-0.01))","v":{"v":5.003573981415297,"d":"5.004"}},{"v":100000,"d":"100,000"},11,"Accept (T&O)","There is literaly nothing that can be done to mitigate force majeur events and [company] therefore only can accept the risk.","PM, Project Sponsor","Inactive","2017-09-14"]
[{"v":11,"d":"011"},"External","Threat (T)","Social factors","Competing interests between project and community, culture and habits, citizens rejecting the project, and similar root causes could have an impact on the project including schedule and cost.","all",1,3,{"$f":"Risk_Register[[#This Row],[Probability]]*Risk_Register[[#This Row],[Impact]]*(ROW()/(ROW()-0.01))","v":{"v":3.0020013342228156,"d":"3.002"}},{"v":110000,"d":"110,000"},12,"Accept (T&O)","It is the responisbility of the client to deal with the communities ('expanded' shareholder) in this regard and to find solutions to their demands, to compensate them for the negative impact the project may have to their land, culture and the like.\n[company] on their part are in contact with the community leaders and keeps them informed about their works.","PM, HR Deptm.","Active","2017-09-14"]
[{"v":12,"d":"012"},"External","Threat (T)","Environmental factors","Unexpected additional environmental regulations and accidental discovery of  historical and archaeological  meaningful items, as well as accidental discovery of valuable minerals could interrupt ao stop the project works.","Excavating",1,3,{"$f":"Risk_Register[[#This Row],[Probability]]*Risk_Register[[#This Row],[Impact]]*(ROW()/(ROW()-0.01))","v":{"v":3.0018761726078798,"d":"3.002"}},{"v":120000,"d":"120,000"},13,"Accept (T&O)","The likelihood of such a discovery seems rather low and prevention seems impossible.","PM, Constr. Mngr.","Inactive","2017-09-14"]
[{"v":13,"d":"013"},"External","Threat (T)","Political and regulatory factors","Changes in law, complex administrative approval procedures, political sensitivity, obstruction of approvals, and similar events may cause disruption and delays and may result in cost impact.","all",1,3,{"$f":"Risk_Register[[#This Row],[Probability]]*Risk_Register[[#This Row],[Impact]]*(ROW()/(ROW()-0.01))","v":{"v":3.0017657445556214,"d":"3.002"}},{"v":130000,"d":"130,000"},14,"Accept (T&O)","It is a matter of fact that the recent elections have caused delays and cost. It seems further obvious that the repetition of presidential elections have impact on the client's (government agency) decision making processes. Cost is tracked and to be invoiced accordingly.","PM, Finance Mngr.","Active","2017-09-14"]
[{"v":14,"d":"014"},"Organizational","Threat (T)","Organizational and structural factors","Disagreement about objectives or inconsistent objectives, unclear roles and responsibilities among employees and departments and similar organizational problems can cause schedule and cost impact.","all",1,1,{"$f":"Risk_Register[[#This Row],[Probability]]*Risk_Register[[#This Row],[Impact]]*(ROW()/(ROW()-0.01))","v":{"v":1.000555864369094,"d":"1.001"}},{"v":140000,"d":"140,000"},15,"Mitigate (T)","Objectives must be defined clearly and communicated to all concerned staffs and roles and responsibilities need to be clear and unambiguous.","PM, Project Sponsor","Active","2017-09-14"]
[{"v":15,"d":"015"},"Project Management","Threat (T)","Stakeholder Engagement","Incomplete stakeholder identification, overloaded team, project team instability (rotation) may result into dissatisfaction, and may impact productivity rates and may consequently have time and cost impact.","all",1,1,{"$f":"Risk_Register[[#This Row],[Probability]]*Risk_Register[[#This Row],[Impact]]*(ROW()/(ROW()-0.01))","v":{"v":1.0005265929436546,"d":"1.001"}},{"v":150000,"d":"150,000"},16,"Mitigate (T)","At the beginning of the project life cycle a proper resource and duration estimates shall be performed and verified in the course of the ongoing project.\nIt is desired that resources that resources stay on the project as long as reasonably needed and shall then be returned.","PM, HR Mngr., Constr. Mngr., Proc. & Logisitcs Officer","Accelerating","2017-09-14"]
[{"v":16,"d":"016"},"Business","Threat (T)","Financial and economical","Funding, inflation rate volatility, exchange rate fluctuations and comperable events may cause project failure.","all",1,5,{"$f":"Risk_Register[[#This Row],[Probability]]*Risk_Register[[#This Row],[Impact]]*(ROW()/(ROW()-0.01))","v":{"v":5.002501250625313,"d":"5.003"}},{"v":160000,"d":"160,000"},17,"Mitigate (T)","Providing the funds for the project execution is a main responsibility of the project sponsor through the finance manager.\nThe finance manager will provide detailed planning prior to contract signature in this regards.","Finance Mngr., Project Sponsor","Active","2017-09-14"]
[{"v":17,"d":"017"},"Business","Threat (T)","Planning, monitoring, and controlling","Project prioritization, contract selection procedures and the like are likely to impact any project and are may cause disruption and extra cost.","all",1,1,{"$f":"Risk_Register[[#This Row],[Probability]]*Risk_Register[[#This Row],[Impact]]*(ROW()/(ROW()-0.01))","v":{"v":1.0004764173415912,"d":"1.000"}},{"v":170000,"d":"170,000"},18,"Mitigate (T)","It is very likely that more than one project compete for resources. It is therefore very important that the business case for any new project is well defined and communicated prior to the commencement of a project.\nBased on the business case \"competing\" project managers can analyse the impact of resuorce sharing and decide accordingly.","Project Sponsor","Inactive","2017-09-14"]
[{"v":18,"d":"018"},"Business","Threat (T)","Land and property, statutory clearance","Land acquisition difficulties and rights of way can cause schedule and cost impact.","all",1,2,{"$f":"Risk_Register[[#This Row],[Probability]]*Risk_Register[[#This Row],[Impact]]*(ROW()/(ROW()-0.01))","v":{"v":2.0009095043201457,"d":"2.001"}},{"v":180000,"d":"180,000"},19,"Accept (T&O)","The risk already triggered. However, land acquisition and granting access right to the land are the responsibility of the client and [company] has no influence.","PM","active","2017-09-14"]
[{"v":19,"d":"019"},"Business","Threat (T)","Property damage","Damage to neighboring and other  properties are a high probability risk in any construction project and can result in extra cost and even court cases.","all",1,1,{"$f":"Risk_Register[[#This Row],[Probability]]*Risk_Register[[#This Row],[Impact]]*(ROW()/(ROW()-0.01))","v":{"v":1.000434971726838,"d":"1.000"}},{"v":190000,"d":"190,000"},20,"Transfer (T)","Due to the high likelihood this risk should be always transferred to an insurance company. However, the impact in the remote area of Samburu & Turkana is small.","PM, HSSE Mngr., Constr. Mngr.","Inactive","2017-09-14"]

{"sheet":"Dashboard","index":2,"n_rows":26,"n_cols":13,"rows_kept":26,"merged":[[0,0,0,1],[0,4,0,7],[0,10,0,11],[14,6,14,12],[15,7,15,10]]}
["Entries in Register",null,{"$f":"COUNT(Risk_Register['#])","v":19},null,{"$f":"Risk_Register[[#Headers],[Estimated Monetary Value - EMV (USD)]]","v":"Estimated Monetary Value - EMV (USD)"},{"$nulls":3},{"$f":"SUM(Risk_Register[Estimated Monetary Value - EMV (USD)])","v":{"v":1900000,"d":"1,900,000"}},null,{"$f":"Risk_Register[[#Headers],[Schedule Impact (WD)]]","v":"Schedule Impact (WD)"},null,{"$f":"SUM([1]Register!H:H)","v":25}]
[]
[{"$f":"IF(Validation!I2=\"\",\"\",Validation!I2)","v":"Inactive"},{"$f":"IFERROR(COUNTIF(Risk_Register[Status],Dashboard!A3),\"\")","v":7},null,null,{"$f":"IF(Validation!A2=\"\",\"\",Validation!A2)","v":"Business"},null,null,{"$f":"IFERROR(COUNTIF(Risk_Register[Category],Dashboard!E3),\"\")","v":4},null,null,{"$f":"IF(Validation!C2=\"\",\"\",Validation!C2)","v":"Opportunity (O)"},{"$f":"COUNTIF(Risk_Register[Opportunity or Threat],Dashboard!K3)","v":0}]
[{"$f":"IF(Validation!I3=\"\",\"\",Validation!I3)","v":"Accelerating"},{"$f":"IFERROR(COUNTIF(Risk_Register[Status],Dashboard!A4),\"\")","v":1},null,null,{"$f":"IF(Validation!A3=\"\",\"\",Validation!A3)","v":"Community"},null,null,{"$f":"IFERROR(COUNTIF(Risk_Register[Category],Dashboard!E4),\"\")","v":0},null,null,{"$f":"IF(Validation!C3=\"\",\"\",Validation!C3)","v":"Threat (T)"},{"$f":"COUNTIF(Risk_Register[Opportunity or Threat],Dashboard!K4)","v":19}]
[{"$f":"IF(Validation!I4=\"\",\"\",Validation!I4)","v":"Active"},{"$f":"IFERROR(COUNTIF(Risk_Register[Status],Dashboard!A5),\"\")","v":11},null,null,{"$f":"IF(Validation!A4=\"\",\"\",Validation!A4)","v":"Construction"},null,null,{"$f":"IFERROR(COUNTIF(Risk_Register[Category],Dashboard!E5),\"\")","v":7},null,null,{"$f":"IF(Validation!C4=\"\",\"\",Validation!C4)","v":"Both (T&O)"},{"$f":"COUNTIF(Risk_Register[Opportunity or Threat],Dashboard!K5)","v":0}]
[{"$f":"IF(Validation!I5=\"\",\"\",Validation!I5)","v":"Ceased"},{"$f":"IFERROR(COUNTIF(Risk_Register[Status],Dashboard!A6),\"\")","v":0},null,null,{"$f":"IF(Validation!A5=\"\",\"\",Validation!A5)","v":"Design"},null,null,{"$f":"IFERROR(COUNTIF(Risk_Register[Category],Dashboard!E6),\"\")","v":1},null,null,{"$f":"IF(Validation!C5=\"\",\"\",Validation!C5)","v":""},{"$f":"COUNTIF(Risk_Register[Opportunity or Threat],Dashboard!K6)","v":0}]
[{"$f":"IF(Validation!I6=\"\",\"\",Validation!I6)","v":""},{"$f":"IFERROR(COUNTIF(Risk_Register[Status],Dashboard!A7),\"\")","v":0},null,null,{"$f":"IF(Validation!A6=\"\",\"\",Validation!A6)","v":"Environment"},null,null,{"$f":"IFERROR(COUNTIF(Risk_Register[Category],Dashboard!E7),\"\")","v":0},null,null,{"$f":"IF(Validation!C6=\"\",\"\",Validation!C6)","v":""},{"$f":"COUNTIF(Risk_Register[Opportunity or Threat],Dashboard!K7)","v":0}]
[{"$f":"IF(Validation!I7=\"\",\"\",Validation!I7)","v":""},{"$f":"IFERROR(COUNTIF(Risk_Register[Status],Dashboard!A8),\"\")","v":0},null,null,{"$f":"IF(Validation!A7=\"\",\"\",Validation!A7)","v":"External"},null,null,{"$f":"IFERROR(COUNTIF(Risk_Register[Category],Dashboard!E8),\"\")","v":5},null,null,{"$f":"IF(Validation!C7=\"\",\"\",Validation!C7)","v":""},{"$f":"COUNTIF(Risk_Register[Opportunity or Threat],Dashboard!K8)","v":0}]
[{"$f":"IF(Validation!I8=\"\",\"\",Validation!I8)","v":""},{"$f":"IFERROR(COUNTIF(Risk_Register[Status],Dashboard!A9),\"\")","v":0},null,null,{"$f":"IF(Validation!A8=\"\",\"\",Validation!A8)","v":"Health & Safety"},null,null,{"$f":"IFERROR(COUNTIF(Risk_Register[Category],Dashboard!E9),\"\")","v":0},null,null,{"$f":"IF(Validation!C8=\"\",\"\",Validation!C8)","v":""},{"$f":"COUNTIF(Risk_Register[Opportunity or Threat],Dashboard!K9)","v":0}]
[{"$f":"IF(Validation!I9=\"\",\"\",Validation!I9)","v":""},{"$f":"IFERROR(COUNTIF(Risk_Register[Status],Dashboard!A10),\"\")","v":0},null,null,{"$f":"IF(Validation!A9=\"\",\"\",Validation!A9)","v":"Logistics"},null,null,{"$f":"IFERROR(COUNTIF(Risk_Register[Category],Dashboard!E10),\"\")","v":0},null,null,{"$f":"IF(Validation!C9=\"\",\"\",Validation!C9)","v":""},{"$f":"COUNTIF(Risk_Register[Opportunity or Threat],Dashboard!K10)","v":0}]
[{"$f":"IF(Validation!I10=\"\",\"\",Validation!I10)","v":""},{"$f":"IFERROR(COUNTIF(Risk_Register[Status],Dashboard!A11),\"\")","v":0},null,null,{"$f":"IF(Validation!A10=\"\",\"\",Validation!A10)","v":"Organizational"},null,null,{"$f":"IFERROR(COUNTIF(Risk_Register[Category],Dashboard!E11),\"\")","v":1},null,null,{"$f":"IF(Validation!C10=\"\",\"\",Validation!C10)","v":""},{"$f":"COUNTIF(Risk_Register[Opportunity or Threat],Dashboard!K11)","v":0}]
[{"$f":"IF(Validation!I11=\"\",\"\",Validation!I11)","v":""},{"$f":"IFERROR(COUNTIF(Risk_Register[Status],Dashboard!A12),\"\")","v":0},null,null,{"$f":"IF(Validation!A11=\"\",\"\",Validation!A11)","v":"Project Management"},null,null,{"$f":"IFERROR(COUNTIF(Risk_Register[Category],Dashboard!E12),\"\")","v":1},null,null,{"$f":"IF(Validation!C11=\"\",\"\",Validation!C11)","v":""},{"$f":"COUNTIF(Risk_Register[Opportunity or Threat],Dashboard!K12)","v":0}]
[]
[]
[{"$f":"Definitions!B2","v":"Low (1 / -1)"},{"$f":"COUNTIF(Risk_Register[Probability],1)+COUNTIF(Risk_Register[Probability],-1)","v":15},{"$f":"COUNTIF(Risk_Register[Impact],1)+COUNTIF(Risk_Register[Impact],-1)","v":5},{"$nulls":3},"10 Risks with Highest Severity Ranking"]
[{"$f":"Definitions!C2","v":"Med.-Low (2 / -2)"},{"$f":"COUNTIF(Risk_Register[Probability],2)+COUNTIF(Risk_Register[Probability],-2)","v":3},{"$f":"COUNTIF(Risk_Register[Impact],1)+COUNTIF(Risk_Register[Impact],-1)","v":5},{"$nulls":3},"Severity","Risk Name",{"$nulls":3},"EMV (USD","Schedule Impact (WD)"]
[{"$f":"Definitions!D2","v":"Medium (3 / -3)"},{"$f":"COUNTIF(Risk_Register[Probability],3)+COUNTIF(Risk_Register[Probability],-3)","v":0},{"$f":"COUNTIF(Risk_Register[Impact],1)+COUNTIF(Risk_Register[Impact],-1)","v":5},{"$nulls":3},{"$f":"IFERROR(IF(LARGE(Risk_Register[Severity],ROW(A1))<0,\"\",LARGE(Risk_Register[Severity],ROW(A1))),\"\")","v":{"v":12.012012012012013,"d":"12"}},{"$f":"IF(G17=\"\",\"\",INDEX(Risk_Register['#],_xlfn.AGGREGATE(15,6,(ROW(Risk_Register[Severity])-4)/(FIND($G17,Risk_Register[Severity],1)>0),ROW($A$1))))","v":6},{"$f":"IF(G17=\"\",\"\",INDEX(Risk_Register[Risk Name],_xlfn.AGGREGATE(15,6,(ROW(Risk_Register[Severity])-4)/(FIND($G17,Risk_Register[Severity],1)>0),ROW($A$1))))","v":"Security factors"},null,null,{"$f":"IFERROR(VLOOKUP(I17,Risk_Register[[Risk Name]:[Schedule Impact (WD)]],7,FALSE),\"\")","v":{"v":60000,"d":"60,000"}},{"$f":"IFERROR(VLOOKUP(I17,Risk_Register[[Risk Name]:[Schedule Impact (WD)]],8,FALSE),\"\")","v":7}]
[{"$f":"Definitions!E2","v":"Med.-High (4 / -4"},{"$f":"COUNTIF(Risk_Register[Probability],4)+COUNTIF(Risk_Register[Probability],-4)","v":1},{"$f":"COUNTIF(Risk_Register[Impact],1)+COUNTIF(Risk_Register[Impact],-1)","v":5},{"$nulls":3},{"$f":"IFERROR(IF(LARGE(Risk_Register[Severity],ROW(A2))<0,\"\",LARGE(Risk_Register[Severity],ROW(A2))),\"\")","v":{"v":8.011444921316166,"d":"8"}},{"$f":"IF(G18=\"\",\"\",INDEX(Risk_Register['#],_xlfn.AGGREGATE(15,6,(ROW(Risk_Register[Severity])-4)/(FIND($G18,Risk_Register[Severity],1)>0),ROW($A$1))))","v":3},{"$f":"IF(G18=\"\",\"\",INDEX(Risk_Register[Risk Name],_xlfn.AGGREGATE(15,6,(ROW(Risk_Register[Severity])-4)/(FIND($G18,Risk_Register[Severity],1)>0),ROW($A$1))))","v":"Technical Factors"},null,null,{"$f":"IFERROR(VLOOKUP(I18,Risk_Register[[Risk Name]:[Schedule Impact (WD)]],7,FALSE),\"\")","v":{"v":30000,"d":"30,000"}},{"$f":"IFERROR(VLOOKUP(I18,Risk_Register[[Risk Name]:[Schedule Impact (WD)]],8,FALSE),\"\")","v":4}]
[{"$f":"Definitions!F2","v":"High (5 / -5)"},{"$f":"COUNTIF(Risk_Register[Probability],5)+COUNTIF(Risk_Register[Probability],-5)","v":0},{"$f":"COUNTIF(Risk_Register[Impact],1)+COUNTIF(Risk_Register[Impact],-1)","v":5},{"$nulls":3},{"$f":"IFERROR(IF(LARGE(Risk_Register[Severity],ROW(A3))<0,\"\",LARGE(Risk_Register[Severity],ROW(A3))),\"\")","v":{"v":5.0100200400801596,"d":"5"}},{"$f":"IF(G19=\"\",\"\",INDEX(Risk_Register['#],_xlfn.AGGREGATE(15,6,(ROW(Risk_Register[Severity])-4)/(FIND($G19,Risk_Register[Severity],1)>0),ROW($A$1))))","v":1},{"$f":"IF(G19=\"\",\"\",INDEX(Risk_Register[Risk Name],_xlfn.AGGREGATE(15,6,(ROW(Risk_Register[Severity])-4)/(FIND($G19,Risk_Register[Severity],1)>0),ROW($A$1))))","v":"Design Risk"},null,null,{"$f":"IFERROR(VLOOKUP(I19,Risk_Register[[Risk Name]:[Schedule Impact (WD)]],7,FALSE),\"\")","v":{"v":10000,"d":"10,000"}},{"$f":"IFERROR(VLOOKUP(I19,Risk_Register[[Risk Name]:[Schedule Impact (WD)]],8,FALSE),\"\")","v":2}]
[{"$nulls":6},{"$f":"IFERROR(IF(LARGE(Risk_Register[Severity],ROW(A4))<0,\"\",LARGE(Risk_Register[Severity],ROW(A4))),\"\")","v":{"v":5.004549590536852,"d":"5"}},{"$f":"IF(G20=\"\",\"\",INDEX(Risk_Register['#],_xlfn.AGGREGATE(15,6,(ROW(Risk_Register[Severity])-4)/(FIND($G20,Risk_Register[Severity],1)>0),ROW($A$1))))","v":7},{"$f":"IF(G20=\"\",\"\",INDEX(Risk_Register[Risk Name],_xlfn.AGGREGATE(15,6,(ROW(Risk_Register[Severity])-4)/(FIND($G20,Risk_Register[Severity],1)>0),ROW($A$1))))","v":"Procurement Factors"},null,null,{"$f":"IFERROR(VLOOKUP(I20,Risk_Register[[Risk Name]:[Schedule Impact (WD)]],7,FALSE),\"\")","v":{"v":70000,"d":"70,000"}},{"$f":"IFERROR(VLOOKUP(I20,Risk_Register[[Risk Name]:[Schedule Impact (WD)]],8,FALSE),\"\")","v":8}]
[{"$nulls":6},{"$f":"IFERROR(IF(LARGE(Risk_Register[Severity],ROW(A5))<0,\"\",LARGE(Risk_Register[Severity],ROW(A5))),\"\")","v":{"v":5.003573981415297,"d":"5"}},{"$f":"IF(G21=\"\",\"\",INDEX(Risk_Register['#],_xlfn.AGGREGATE(15,6,(ROW(Risk_Register[Severity])-4)/(FIND($G21,Risk_Register[Severity],1)>0),ROW($A$1))))","v":10},{"$f":"IF(G21=\"\",\"\",INDEX(Risk_Register[Risk Name],_xlfn.AGGREGATE(15,6,(ROW(Risk_Register[Severity])-4)/(FIND($G21,Risk_Register[Severity],1)>0),ROW($A$1))))","v":"Force majeure factors"},null,null,{"$f":"IFERROR(VLOOKUP(I21,Risk_Register[[Risk Name]:[Schedule Impact (WD)]],7,FALSE),\"\")","v":{"v":100000,"d":"100,000"}},{"$f":"IFERROR(VLOOKUP(I21,Risk_Register[[Risk Name]:[Schedule Impact (WD)]],8,FALSE),\"\")","v":11}]
[{"$nulls":6},{"$f":"IFERROR(IF(LARGE(Risk_Register[Severity],ROW(A6))<0,\"\",LARGE(Risk_Register[Severity],ROW(A6))),\"\")","v":{"v":5.002501250625313,"d":"5"}},{"$f":"IF(G22=\"\",\"\",INDEX(Risk_Register['#],_xlfn.AGGREGATE(15,6,(ROW(Risk_Register[Severity])-4)/(FIND($G22,Risk_Register[Severity],1)>0),ROW($A$1))))","v":16},{"$f":"IF(G22=\"\",\"\",INDEX(Risk_Register[Risk Name],_xlfn.AGGREGATE(15,6,(ROW(Risk_Register[Severity])-4)/(FIND($G22,Risk_Register[Severity],1)>0),ROW($A$1))))","v":"Financial and economical"},null,null,{"$f":"IFERROR(VLOOKUP(I22,Risk_Register[[Risk Name]:[Schedule Impact (WD)]],7,FALSE),\"\")","v":{"v":160000,"d":"160,000"}},{"$f":"IFERROR(VLOOKUP(I22,Risk_Register[[Risk Name]:[Schedule Impact (WD)]],8,FALSE),\"\")","v":17}]
[{"$nulls":6},{"$f":"IFERROR(IF(LARGE(Risk_Register[Severity],ROW(A7))<0,\"\",LARGE(Risk_Register[Severity],ROW(A7))),\"\")","v":{"v":4.005006257822278,"d":"4"}},{"$f":"IF(G23=\"\",\"\",INDEX(Risk_Register['#],_xlfn.AGGREGATE(15,6,(ROW(Risk_Register[Severity])-4)/(FIND($G23,Risk_Register[Severity],1)>0),ROW($A$1))))","v":4},{"$f":"IF(G23=\"\",\"\",INDEX(Risk_Register[Risk Name],_xlfn.AGGREGATE(15,6,(ROW(Risk_Register[Severity])-4)/(FIND($G23,Risk_Register[Severity],1)>0),ROW($A$1))))","v":"Site and layout conditions"},null,null,{"$f":"IFERROR(VLOOKUP(I23,Risk_Register[[Risk Name]:[Schedule Impact (WD)]],7,FALSE),\"\")","v":{"v":40000,"d":"40,000"}},{"$f":"IFERROR(VLOOKUP(I23,Risk_Register[[Risk Name]:[Schedule Impact (WD)]],8,FALSE),\"\")","v":5}]
[{"$nulls":6},{"$f":"IFERROR(IF(LARGE(Risk_Register[Severity],ROW(A8))<0,\"\",LARGE(Risk_Register[Severity],ROW(A8))),\"\")","v":{"v":4.003079291762894,"d":"4"}},{"$f":"IF(G24=\"\",\"\",INDEX(Risk_Register['#],_xlfn.AGGREGATE(15,6,(ROW(Risk_Register[Severity])-4)/(FIND($G24,Risk_Register[Severity],1)>0),ROW($A$1))))","v":9},{"$f":"IF(G24=\"\",\"\",INDEX(Risk_Register[Risk Name],_xlfn.AGGREGATE(15,6,(ROW(Risk_Register[Severity])-4)/(FIND($G24,Risk_Register[Severity],1)>0),ROW($A$1))))","v":"Contractual factors"},null,null,{"$f":"IFERROR(VLOOKUP(I24,Risk_Register[[Risk Name]:[Schedule Impact (WD)]],7,FALSE),\"\")","v":{"v":90000,"d":"90,000"}},{"$f":"IFERROR(VLOOKUP(I24,Risk_Register[[Risk Name]:[Schedule Impact (WD)]],8,FALSE),\"\")","v":10}]
[{"$nulls":6},{"$f":"IFERROR(IF(LARGE(Risk_Register[Severity],ROW(A9))<0,\"\",LARGE(Risk_Register[Severity],ROW(A9))),\"\")","v":{"v":3.005008347245409,"d":"3"}},{"$f":"IF(G25=\"\",\"\",INDEX(Risk_Register['#],_xlfn.AGGREGATE(15,6,(ROW(Risk_Register[Severity])-4)/(FIND($G25,Risk_Register[Severity],1)>0),ROW($A$1))))","v":2},{"$f":"IF(G25=\"\",\"\",INDEX(Risk_Register[Risk Name],_xlfn.AGGREGATE(15,6,(ROW(Risk_Register[Severity])-4)/(FIND($G25,Risk_Register[Severity],1)>0),ROW($A$1))))","v":"Supplier or Sub-Contractor incapable"},null,null,{"$f":"IFERROR(VLOOKUP(I25,Risk_Register[[Risk Name]:[Schedule Impact (WD)]],7,FALSE),\"\")","v":{"v":20000,"d":"20,000"}},{"$f":"IFERROR(VLOOKUP(I25,Risk_Register[[Risk Name]:[Schedule Impact (WD)]],8,FALSE),\"\")","v":3}]
[{"$nulls":6},{"$f":"IFERROR(IF(LARGE(Risk_Register[Severity],ROW(A10))<0,\"\",LARGE(Risk_Register[Severity],ROW(A10))),\"\")","v":{"v":3.0020013342228156,"d":"3"}},{"$f":"IF(G26=\"\",\"\",INDEX(Risk_Register['#],_xlfn.AGGREGATE(15,6,(ROW(Risk_Register[Severity])-4)/(FIND($G26,Risk_Register[Severity],1)>0),ROW($A$1))))","v":11},{"$f":"IF(G26=\"\",\"\",INDEX(Risk_Register[Risk Name],_xlfn.AGGREGATE(15,6,(ROW(Risk_Register[Severity])-4)/(FIND($G26,Risk_Register[Severity],1)>0),ROW($A$1))))","v":"Social factors"},null,null,{"$f":"IFERROR(VLOOKUP(I26,Risk_Register[[Risk Name]:[Schedule Impact (WD)]],7,FALSE),\"\")","v":{"v":110000,"d":"110,000"}},{"$f":"IFERROR(VLOOKUP(I26,Risk_Register[[Risk Name]:[Schedule Impact (WD)]],8,FALSE),\"\")","v":12}]

{"sheet":"Definitions","index":3,"n_rows":30,"n_cols":6,"rows_kept":30,"merged":[[0,0,0,5],[4,0,4,5],[11,0,11,5],[12,1,12,5],[13,1,13,5],[14,1,14,5],[15,1,15,5],[16,1,16,5],[17,1,17,5],[18,1,18,5],[19,1,19,5],[20,1,20,5],[21,1,21,5],[22,1,22,5],[23,1,23,5],[25,0,25,5],[26,1,26,5],[27,1,27,5],[28,1,28,5],[29,1,29,5]]}
["Probability Rating"]
[null,"Low (1 / -1)","Med.-Low (2 / -2)","Medium (3 / -3)","Med.-High (4 / -4","High (5 / -5)"]
["Probability of occurrence","1-20%","21-40%","41-60%","61-80%","81-99%"]
[]
["Impact Rating"]
[null,{"$f":"B2","v":"Low (1 / -1)"},{"$f":"C2","v":"Med.-Low (2 / -2)"},"Medium (3 / -3)","Med.-High (4 / -4","High (5 / -5)"]
["Quality","- Negligible impacts to design quality\n- Negligible impacts to long-term maintenance\n- Barely noticeable","- Requires Design Variance,\n- Minor impacts to long-term maintenance,\n- Minor scope reduction","- Requires Design waiver,\n- Significant impacts to long-term maintenance,\n- Major scope reduction","- Does not meet acceptable standards and requires Design Exception,\n- Major impacts to long-term maintenance,\n- Changes unacceptable to stakeholders,","- Does not meet acceptable standards and Design Exception not likely,\n- Unacceptable impacts to long-term maintenance,\n- Project does not meet need and purpose"]
["Cost\n(% of total project cost)","cost increase = 1%"," cost increase = 2%","cost increase = 3%","cost increase = 4%","cost increase > 5%"]
["Schedule\n(% of of total project duration)","delay = 1%","delay = 2%","delay = 3%","delay = 4%","delay > 5%"]
["Safety","First Aid","Restricted Duty / Doctor Visit","Recordable","Lost Time","Major injury or death"]
[]
["Risk Response Strategies"]
["Threat Response","Description"]
["Escalate","Escalation is appropriate if the project sponsor agrees that a threat is outside the scope of the project or that the proposed response would exceed the PM's authority."]
["Avoid","Risk avoidance is when the team eliminates the threat or protects the project against its impact."]
["Transfer","Transfer involves shifting the ownership of a threat to a third party to manage the risk and to bear the impact if the threat occurs."]
["Mitigate","In mitigation, action is taken to reduce the probability of occurrence and/or impact of a threat."]
["Accept","Risk acceptance acknowledges the existence of a threat, but no proactive action is taken."]
["Opportunity Response","Description"]
["Escalate","Escalation is appropriate if the project sponsor agrees that an opportunity is outside the scope of the project or that the proposed response would exceed the PM's authority."]
["Exploit","The exploit strategy is selected where the organization wants to ensure that the opportunity is realized. "]
["Share","Sharing involves transferring the ownership of an opportunity to a third party so that it shares a portion of the benefit if the opportunity occurs."]
["Enhance","The enhance strategy is used to increase the probability and/or impact of an opportunity."]
["Accept","accepting an oppoprtunity acknowledges its existence, but no proactive action is taken."]
[]
["Risk Status"]
["Inactive","An inactive risk didn't trigger and its probability is currently not increasing. But it has the ability to increase or become active at a later time."]
["Accelerating","The risk probability is increasing."]
["Active","The risk triggered and is creating results."]
["Ceased","The risk probability reduced to 0 and therefore the risk stopped existing."]

{"sheet":"Validation","index":4,"n_rows":11,"n_cols":9,"rows_kept":11}
["Category",null,"Classification",null,"Rank",null,"Strategy",null,"Status"]
["Business",null,"Opportunity (O)",null,-5,null,"Escalate (T&O)",null,"Inactive"]
["Community",null,"Threat (T)",null,-4,null,"Avoid (T)",null,"Accelerating"]
["Construction",null,"Both (T&O)",null,-3,null,"Transfer (T)",null,"Active"]
["Design",{"$nulls":3},-2,null,"Mitigate (T)",null,"Ceased"]
["Environment",{"$nulls":3},-1,null,"Accept (T&O)"]
["External",{"$nulls":3},1,null,"Exploit (O)"]
["Health & Safety",{"$nulls":3},2,null,"Share (O)"]
["Logistics",{"$nulls":3},3,null,"Enhance (O)"]
["Organizational",{"$nulls":3},4]
["Project Management",{"$nulls":3},5]