{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Risk Register","Definitions","Validation"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Risk Register","index":0,"n_rows":24,"n_cols":17,"rows_kept":24,"merged":[[0,0,0,1],[0,2,0,4],[0,9,0,10],[0,11,0,13],[1,0,1,1],[1,2,1,4],[1,9,1,10],[1,11,1,13],[2,0,2,5],[2,6,2,10],[2,11,2,13],[2,14,2,16]]}
["Project Name:",{"$nulls":8},"Last Updated Date:"]
["Project Manager:",{"$nulls":8},"Last 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 (days)","Response Strategy","Strategy Description","Risk Owner","Status","Lat Update","Comments"]
[{"v":1,"d":"001"},"Design","Threat","Design Risk","Inadequate design or wrong assumptions, could make the product fail and unsuitable for intended purpose.","all",null,null,{"$f":"G5*H5","v":0},null,null,"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","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",null,null,0,null,null,"Mitigate (T)","Monitor performance and have alternative solution (plan B).","PM, Procurement","Inactive","2017-09-14"]
[{"v":3,"d":"003"},"Construction","Threat","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",null,null,0,null,null,"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","Site and layout conditions","Interruptions in site access and interference in the flow of work could result in delays and consequently additional cost.","all",null,null,0,null,null,"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","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",null,null,0,null,null,"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","Security factors","Corruption, theft, vandalism, sabotage, can cause extra cost and may have schedule impact.","all",null,null,0,null,null,"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","Contractual factors","Insolvency of a party or inadequate change introduction can impact the schedule and cost of works execution.","all",null,null,0,null,null,"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","Performance factors","Defective works, labor disputes, inefficient productivity, can hinder the progress and thus have schedule and consequently cost impact.","all",null,null,0,null,null,"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","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",null,null,{"$f":"G13*H13","v":0},null,null,"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","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",null,null,0,null,null,"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","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",null,null,0,null,null,"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","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",null,null,0,null,null,"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","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",null,null,0,null,null,"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","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",null,null,0,null,null,"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",null,"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",null,null,0,null,null,"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","Financial and economical","Funding, inflation rate volatility, exchange rate fluctuations and comperable events may cause project failure.","all",null,null,0,null,null,"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","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",null,null,0,null,null,"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","Land and property, statutory clearance","Land acquisition difficulties and rights of way can cause schedule and cost impact.","all",null,null,0,null,null,"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","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",null,null,0,null,null,"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"]
[{"v":20,"d":"020"},{"$nulls":7},{"$f":"G24*H24","v":0}]

{"sheet":"Definitions","index":1,"n_rows":31,"n_cols":6,"rows_kept":31,"merged":[[0,0,0,5],[4,0,4,5],[12,0,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],[24,1,24,5],[26,0,26,5],[27,1,27,5],[28,1,28,5],[29,1,29,5],[30,1,30,5]]}
["Probability Rating"]
[null,"1\nLow","2\nMedium-Low","3\nMedium","4\nMedium-High","5\nHigh"]
["Probability of occurrence","1-20%","21-40%","41-60%","61-80%","81-99%"]
[]
["Impact Rating"]
[null,"1\nLow","2\nMedium-Low","3\nMedium","4\nMedium-High","5\nHigh"]
["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":2,"n_rows":11,"n_cols":9,"rows_kept":11}
["Category",null,"Classification",null,"Rank",null,"Strategy",null,"Status"]
["Business",null,"Opportunity",null,-5,null,"Escalate (T&O)",null,"Inactive"]
["Community",null,"Threat",null,-4,null,"Avoid (T)",null,"Accelerating"]
["Construction",null,"Both",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)"]
["Logistics",{"$nulls":3},2,null,"Share (O)"]
["Organizational",{"$nulls":3},3,null,"Enhance (O)"]
["Project Management",{"$nulls":3},4]
[{"$nulls":4},5]