{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Risk Register","Generic risk prompt sheet","Template instructions","Version Control"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":31,"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":"Risk Register","index":0,"n_rows":105,"n_cols":144,"rows_kept":105,"cut":false,"hidden":false,"merged":[[29,0,29,3],[30,0,30,3],[31,0,31,3],[104,0,104,14],[46,0,47,4],[46,5,47,8],[103,9,103,10],[32,0,32,3],[18,8,18,14],[24,0,24,3],[25,0,25,3],[22,4,27,7],[26,0,26,3],[27,0,27,3],[22,0,23,3],[27,9,28,14],[9,0,9,12],[14,2,14,4],[12,0,12,1],[13,0,13,1],[13,2,13,4],[11,9,11,14],[13,6,13,7],[12,2,12,7],[14,6,14,7],[47,18,47,22],[11,0,11,1],[15,2,15,7],[17,2,17,7],[17,0,17,1],[14,0,14,1],[11,2,11,7],[46,9,47,14],[28,4,31,8],[16,3,16,4],[15,0,15,1],[16,0,16,1],[33,0,33,3],[28,0,28,3],[19,8,21,14],[18,0,19,7]]}
["HIDE ROW",null,null,null,null,null,null,null,null,null,null,"HIDE COL",null,"HIDE COL",null,"HIDE COL","HIDE COL","HIDE COL","HIDE COL","HIDE COL","HIDE COL","HIDE COL","HIDE COL","HIDE COL",null,{"$f":"Z104","v":104},null,"Recommended contingency  at Mean"]
["HIDE ROW",null,null,"Open",null,1,null,"Open",null,"Nil",0,"Nil",null,null,"Nil",null,null,null,null,null,null,null,null,null,null,null,null,"GRIP","1.01 RCS Signalling","1.01 RCS Level Crossings","1.02 Train Power systems","1.03 Electic Power & Plant","1.04 Permanent Way","1.05 Operational Telecoms","1.06 Buildings & Property","1.07 Civils","1.08 Enabling Works"]
["HIDE ROW",null,null,"Closed - Treated",null,2,null,"Closed",null,"Very Low",1,"Very Low",null,null,"Routine",null,null,null,null,null,null,null,null,null,null,null,null,1,0.4,0.4,0.33,0.33,0.35,0.35,0.4,0.35,0.4]
["HIDE ROW",null,null,"Closed - Impacted",null,3,null,null,null,"Low",2,"Low",null,null,"Minor",null,null,null,null,null,null,null,null,null,null,null,null,2,0.3,0.25,0.22,0.22,0.25,0.25,0.3,0.25,0.3]
["HIDE ROW",null,null,"Controlled",null,4,null,0,null,"Medium",3,"Medium",null,null,"Significant",null,null,null,null,null,null,null,null,null,null,null,null,3,0.2,0.2,0.12,0.12,0.15,0.15,0.2,0.15,0.2]
["HIDE ROW",null,null,null,null,5,null,0.03,null,"High",4,"High",null,null,"Major",null,null,null,null,null,null,null,null,null,null,null,null,4,0.1,0.15,0.08,0.08,0.1,0.08,0.1,0.1,0.15]
["HIDE ROW",null,null,null,null,6,null,0.04,null,"Very High",5,"Very High",null,null,"Critical",null,null,null,null,null,null,null,null,null,null,null,null,5,0.08,0.1,0.05,0.05,7.0000000000000007E-2,0.05,7.4999999999999997E-2,7.4999999999999997E-2,0.1]
["HIDE ROW",null,null,null,null,null,null,0.05,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05]
["HIDE ROW"]
["Project Manager's risk register template",null,null,null,null,null,null,null,null,null,null,null,null,null,"Version: 3.0"]
[]
["OP Code",null,"R-WLR",null,null,null,null,null,null,"Qualitative risk scoring scale",null,null,null,null,null,null,null,null,"SMALL","MEDIUM","SYRT","SMALL MIN","SMALL MAX","MED MIN","MED MAX","SYRT MIN","SYRT MAX"]
["Project Title",null,"Windsor Link Railway",null,null,null,null,null,null,"Rating","Probability",null,"Cost impact",null,"Time impact",null,"Warning message",null,null,null,null,null,null,null,null,null,null,null,"Contingency model selection by Asset Type and GRIP Stage"]
["GRIP Stage of Project",null,2,null,null,"Asset type","1.04 Permanent Way",null,null,"Very High","> 50%",null,{"$f":"IF($G$15=\"SEE YOUR RISK TEAM\",U14,IF($G$15=\"MEDIUM\",T14,S14))","v":"> £5m"},null,"> 6 months",null,{"$f":"ISBLANK(C14)","v":false},{"$f":"IF(Q14=FALSE,1,)","v":1},">£50k",">£500k","> £5m",50000,75000,500000,750000,5000000,7500000,null,{"$f":"IF($G$14=AC2,VLOOKUP($C$14,$AB3:$AK8,2),0)","v":0},{"$f":"IF($G$14=AD2,VLOOKUP($C$14,$AB3:$AK8,3),0)","v":0},{"$f":"IF($G$14=AE2,VLOOKUP($C$14,$AB3:$AK8,4),0)","v":0},{"$f":"IF($G$14=AF2,VLOOKUP($C$14,$AB3:$AK8,5),0)","v":0},{"$f":"IF($G$14=AG2,VLOOKUP($C$14,$AB3:$AK8,6),0)","v":0.25},{"$f":"IF($G$14=AH2,VLOOKUP($C$14,$AB3:$AK8,7),0)","v":0},{"$f":"IF($G$14=AI2,VLOOKUP($C$14,$AB3:$AK8,8),0)","v":0},{"$f":"IF($G$14=AJ2,VLOOKUP($C$14,$AB3:$AK8,9),0)","v":0},{"$f":"IF($G$14=AK2,VLOOKUP($C$14,$AB3:$AK8,10),0)","v":0},{"$f":"SUM(AC14:AK14)","v":0.25}]
["Estimate \"to go\" value in digits\ne.g. £800,000 and not £0.8m  ",null,375000000,null,null,"Project size",{"$f":"IF(C15=0,\"No input required - Project size is set by Estimate to go value\",IF(C15<1000001,\"SMALL\",IF(C15>10000000,\"SEE YOUR RISK TEAM\",\"MEDIUM\")))","v":"SEE YOUR RISK TEAM"},null,null,"High","25% to 50%",null,{"$f":"IF($G$15=\"SEE YOUR RISK TEAM\",U15,IF($G$15=\"MEDIUM\",T15,S15))","v":"£1m - £5m"},null,"3 to 6 months",null,{"$f":"ISBLANK(C15)","v":false},{"$f":"IF(Q15=FALSE,1,)","v":1},"£10k - £50k","£100k - £500k","£1m - £5m",10000,50000,100000,500000,1000000,5000000]
["Project Manager ",null,"Jon McPhee ",null,null,null,null,null,null,"Medium","10% to 25%",null,{"$f":"IF($G$15=\"SEE YOUR RISK TEAM\",U16,IF($G$15=\"MEDIUM\",T16,S16))","v":"£250k - £1m"},null,"1 to 3 months",null,{"$f":"ISBLANK(G14)","v":false},{"$f":"IF(Q16=FALSE,1,)","v":1},"£2.5k - £10k","£25k - £100k","£250k - £1m",2500,10000,25000,100000,250000,1000000]
["Generic Risks as a % of Estimate \"to go\"value (see Generic risk prompt sheet)",null,23,"Specific Risks (from below)",null,{"$f":"O104","v":22353750},"Total Risk @ mean",{"$f":"F17+C17","v":22353773},null,"Low","5% to 10%",null,{"$f":"IF($G$15=\"SEE YOUR RISK TEAM\",U17,IF($G$15=\"MEDIUM\",T17,S17))","v":"£50k - £250k"},null,"1 week to 1 month",null,null,{"$f":"SUM(R14:R16)","v":3},"£0.5k - £2.5k","£5k - £25k","£50k - £250k",500,2500,5000,25000,50000,250000]
["Status Date of Register",null,"2017-03-29",null,null,null,null,null,null,"Very Low","< 5%",null,{"$f":"IF($G$15=\"SEE YOUR RISK TEAM\",U18,IF($G$15=\"MEDIUM\",T18,S18))","v":"< £50k"},null,"< 1 week",null,null,null,"<£0.5k","<£5k","< £50k",0,500,0,5000,null,50000]
["The project will connect the two separate Windsor railway lines together and rationalise two separate railway stations in to one new station.  For the purposes of this GRIP 2 (feasibility) study, it is assumed that a sub-surface railway through Windsor is the best and only solution for this.  Refer to Client Requirements Document for a full description."]
[null,null,null,null,null,null,null,null,{"$f":"IF(R17<3,,IF(R17=3,IF(W47/C15<AL14,0,\"WARNING - your Risk Exposure is greater than the recommended contingency % for your Asset Type and GRIP Stage - consult the R&V Team for guidance\")))","v":0}]
[]
[]
["Identify your project objectives here",null,null,null,{"$f":"IF(Q25=TRUE,\"Make sure you have completed the project objectives before you add risks to the register.\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"Objectives message",null,"Small","Probability","Minimum",null,"Maximum"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Very High",0.625,{"$f":"IF($G$15=\"SEE YOUR RISK TEAM\",Z14,IF($G$15=\"MEDIUM\",X14,V14))","v":5000000},null,{"$f":"IF($G$15=\"SEE YOUR RISK TEAM\",AA14,IF($G$15=\"MEDIUM\",Y14,W14))","v":7500000}]
["4tph between Slough and Waterloo all stopping at Windsor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ISBLANK(A25)","v":false},null,"High",0.375,{"$f":"IF($G$15=\"SEE YOUR RISK TEAM\",Z15,IF($G$15=\"MEDIUM\",X15,V15))","v":1000000},null,{"$f":"IF($G$15=\"SEE YOUR RISK TEAM\",AA15,IF($G$15=\"MEDIUM\",Y15,W15))","v":5000000}]
["Efficient & Attractive Transport Interchange",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medium",0.17499999999999999,{"$f":"IF($G$15=\"SEE YOUR RISK TEAM\",Z16,IF($G$15=\"MEDIUM\",X16,V16))","v":250000},null,{"$f":"IF($G$15=\"SEE YOUR RISK TEAM\",AA16,IF($G$15=\"MEDIUM\",Y16,W16))","v":1000000}]
["Minimal disruption to surrounding buildings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Low",7.4999999999999997E-2,{"$f":"IF($G$15=\"SEE YOUR RISK TEAM\",Z17,IF($G$15=\"MEDIUM\",X17,V17))","v":50000},null,{"$f":"IF($G$15=\"SEE YOUR RISK TEAM\",AA17,IF($G$15=\"MEDIUM\",Y17,W17))","v":250000}]
["Affordable, Value for money scheme",null,null,null,null,null,null,null,null,"Categories of Qualitative risk assessment for specific risks identified (excluding Generic risk number)",null,null,null,null,null,null,null,null,"Very Low",2.5000000000000001E-2,0,null,{"$f":"IF($G$15=\"SEE YOUR RISK TEAM\",AA18,IF($G$15=\"MEDIUM\",Y18,W18))","v":50000}]
["Keeping Windsor operational before, during and after construction",null,null,null,"Entry into ARM\nAs a minimum a single line entry is required in ARM with a 100% probability to represent the project in accordance with the following. If specific risks are entered into ARM, the values need adjusting. Refer R&V Team for further advice.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Nil",0,0,null,0]
["Efficient low maintenance railcar system",null,null,null,null,null,null,null,null,"Routine",null,null,{"$f":"COUNTIF(Q$50:INDIRECT(P104),O3)","v":2}]
["Safe transport system",null,null,null,null,null,null,null,null,"Minor",null,null,{"$f":"COUNTIF(Q$50:INDIRECT(P104),O4)","v":6},null,"Scored risks"]
[null,null,null,null,null,null,null,null,null,"Significant",null,null,{"$f":"COUNTIF(Q$50:INDIRECT(P104),O5)","v":19},null,{"$f":"SUM(M30:M34)","v":51}]
[null,null,null,null,"ID","Title","Min","ML","Max","Major",null,null,{"$f":"COUNTIF(Q$50:INDIRECT(P104),O6)","v":9}]
[null,null,null,null,{"$f":"CONCATENATE(C12,\"-\",1)","v":"R-WLR-1"},{"$f":"CONCATENATE(C13,\" risk\")","v":"Windsor Link Railway risk"},{"$f":"H17*0.3","v":6706131.8999999994},{"$f":"H17*0.9","v":20118395.699999999},{"$f":"H17*1.8","v":40236791.399999999},"Critical",null,null,{"$f":"COUNTIF(Q$50:INDIRECT(P104),O7)","v":15}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HIDE ROW"]
[{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},null,{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},null,null,"HIDE ROW",{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Do not use\",\"- HIDE -\",\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HIDE ROW","Nil",null,"Nil",0,"Nil",null,"Nil",0,"Nil",null,"Nil",0,"Nil",null,"Nil",null,"Nil",0,"Nil",null,"Nil",0,"Nil",null,"Nil",0,"Nil",null,"Nil",0,"Nil",null,"Nil",0,"Nil",null,"Nil",0,"Nil",null,"Nil",0,"Nil",null,"Nil",0,"Nil",null,"Nil",0,"Nil",null,"Nil",0,"Nil",null,"Nil",0,"Nil",null,"Nil",0,"Nil",null,"Nil",0,"Nil",null,"Nil",0,"Nil",null,"Nil",0,"Nil",null,"Nil",0,"Nil",null,"Nil",0,"Nil",null,"Nil",0,"Nil",null,"Nil",0,"Nil",null,"Nil",0,"Nil",null,"Nil",0,"Nil",null,"Nil",0,"Nil",null,"Nil",0,"Nil",null,"Nil",0,"Nil",null,"Nil",0,"Nil",null,"Nil",0,"Nil",null,"Nil",0,"Nil",null,"Nil",0,"Nil"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J49=\"Do not use\",\"- HIDE -\",\"\")","v":""},null,null,null,null,null,"HIDE ROW","Very Low",null,"Very Low",1,"Very Low",null,"Very Low",1,"Very Low",null,"Very Low",1,"Very Low",null,"Very Low",null,"Very Low",1,"Very Low",null,"Very Low",1,"Very Low",null,"Very Low",1,"Very Low",null,"Very Low",1,"Very Low",null,"Very Low",1,"Very Low",null,"Very Low",1,"Very Low",null,"Very Low",1,"Very Low",null,"Very Low",1,"Very Low",null,"Very Low",1,"Very Low",null,"Very Low",1,"Very Low",null,"Very Low",1,"Very Low",null,"Very Low",1,"Very Low",null,"Very Low",1,"Very Low",null,"Very Low",1,"Very Low",null,"Very Low",1,"Very Low",null,"Very Low",1,"Very Low",null,"Very Low",1,"Very Low",null,"Very Low",1,"Very Low",null,"Very Low",1,"Very Low",null,"Very Low",1,"Very Low",null,"Very Low",1,"Very Low",null,"Very Low",1,"Very Low",null,"Very Low",1,"Very Low",null,"Very Low",1,"Very Low",null,"Very Low",1,"Very Low",null,"Very Low",1,"Very Low",null,"Very Low",1,"Very Low",null,"Very Low",1,"Very Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HIDE ROW","Low",null,"Low",2,"Low",null,"Low",2,"Low",null,"Low",2,"Low",null,"Low",null,"Low",2,"Low",null,"Low",2,"Low",null,"Low",2,"Low",null,"Low",2,"Low",null,"Low",2,"Low",null,"Low",2,"Low",null,"Low",2,"Low",null,"Low",2,"Low",null,"Low",2,"Low",null,"Low",2,"Low",null,"Low",2,"Low",null,"Low",2,"Low",null,"Low",2,"Low",null,"Low",2,"Low",null,"Low",2,"Low",null,"Low",2,"Low",null,"Low",2,"Low",null,"Low",2,"Low",null,"Low",2,"Low",null,"Low",2,"Low",null,"Low",2,"Low",null,"Low",2,"Low",null,"Low",2,"Low",null,"Low",2,"Low",null,"Low",2,"Low",null,"Low",2,"Low",null,"Low",2,"Low",null,"Low",2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HIDE ROW","Medium",null,"Medium",3,"Medium",null,"Medium",3,"Medium",null,"Medium",3,"Medium",null,"Medium",null,"Medium",3,"Medium",null,"Medium",3,"Medium",null,"Medium",3,"Medium",null,"Medium",3,"Medium",null,"Medium",3,"Medium",null,"Medium",3,"Medium",null,"Medium",3,"Medium",null,"Medium",3,"Medium",null,"Medium",3,"Medium",null,"Medium",3,"Medium",null,"Medium",3,"Medium",null,"Medium",3,"Medium",null,"Medium",3,"Medium",null,"Medium",3,"Medium",null,"Medium",3,"Medium",null,"Medium",3,"Medium",null,"Medium",3,"Medium",null,"Medium",3,"Medium",null,"Medium",3,"Medium",null,"Medium",3,"Medium",null,"Medium",3,"Medium",null,"Medium",3,"Medium",null,"Medium",3,"Medium",null,"Medium",3,"Medium",null,"Medium",3,"Medium",null,"Medium",3,"Medium",null,"Medium",3,"Medium",null,"Medium",3,"Medium"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HIDE ROW","High",null,"High",4,"High",null,"High",4,"High",null,"High",4,"High",null,"High",null,"High",4,"High",null,"High",4,"High",null,"High",4,"High",null,"High",4,"High",null,"High",4,"High",null,"High",4,"High",null,"High",4,"High",null,"High",4,"High",null,"High",4,"High",null,"High",4,"High",null,"High",4,"High",null,"High",4,"High",null,"High",4,"High",null,"High",4,"High",null,"High",4,"High",null,"High",4,"High",null,"High",4,"High",null,"High",4,"High",null,"High",4,"High",null,"High",4,"High",null,"High",4,"High",null,"High",4,"High",null,"High",4,"High",null,"High",4,"High",null,"High",4,"High",null,"High",4,"High",null,"High",4,"High",null,"High",4,"High"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HIDE ROW","Very High",null,"Very High",5,"Very High",null,"Very High",5,"Very High",null,"Very High",5,"Very High",null,"Very High",null,"Very High",5,"Very High",null,"Very High",5,"Very High",null,"Very High",5,"Very High",null,"Very High",5,"Very High",null,"Very High",5,"Very High",null,"Very High",5,"Very High",null,"Very High",5,"Very High",null,"Very High",5,"Very High",null,"Very High",5,"Very High",null,"Very High",5,"Very High",null,"Very High",5,"Very High",null,"Very High",5,"Very High",null,"Very High",5,"Very High",null,"Very High",5,"Very High",null,"Very High",5,"Very High",null,"Very High",5,"Very High",null,"Very High",5,"Very High",null,"Very High",5,"Very High",null,"Very High",5,"Very High",null,"Very High",5,"Very High",null,"Very High",5,"Very High",null,"Very High",5,"Very High",null,"Very High",5,"Very High",null,"Very High",5,"Very High",null,"Very High",5,"Very High",null,"Very High",5,"Very High",null,"Very High",5,"Very High",null,"Very High",5,"Very High"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HIDE ROW",null,null,"Qualitative",null,null,null,"Qualitative",null,null,null,"Qualitative",null,null,null,"Qualitative",null,"Qualitative",null,null,null,"Qualitative",null,null,null,"Qualitative",null,null,null,"Qualitative",null,null,null,"Qualitative",null,null,null,"Qualitative",null,null,null,"Qualitative",null,null,null,"Qualitative",null,null,null,"Qualitative",null,null,null,"Qualitative",null,null,null,"Qualitative",null,null,null,"Qualitative",null,null,null,"Qualitative",null,null,null,"Qualitative",null,null,null,"Qualitative",null,null,null,"Qualitative",null,null,null,"Qualitative",null,null,null,"Qualitative",null,null,null,"Qualitative",null,null,null,"Qualitative",null,null,null,"Qualitative",null,null,null,"Qualitative",null,null,null,"Qualitative",null,null,null,"Qualitative",null,null,null,"Qualitative",null,null,null,"Qualitative",null,null,null,"Qualitative",null,null,null,"Qualitative"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HIDE ROW","Cost impact ","Time","Probability","Cost","Cost impact ","Time","Probability","Cost","Cost impact ","Time","Probability","Cost","Cost impact ","Time","Probability","Time","Probability","Cost","Cost impact ","Time","Probability","Cost","Cost impact ","Time","Probability","Cost","Cost impact ","Time","Probability","Cost","Cost impact ","Time","Probability","Cost","Cost impact ","Time","Probability","Cost","Cost impact ","Time","Probability","Cost","Cost impact ","Time","Probability","Cost","Cost impact ","Time","Probability","Cost","Cost impact ","Time","Probability","Cost","Cost impact ","Time","Probability","Cost","Cost impact ","Time","Probability","Cost","Cost impact ","Time","Probability","Cost","Cost impact ","Time","Probability","Cost","Cost impact ","Time","Probability","Cost","Cost impact ","Time","Probability","Cost","Cost impact ","Time","Probability","Cost","Cost impact ","Time","Probability","Cost","Cost impact ","Time","Probability","Cost","Cost impact ","Time","Probability","Cost","Cost impact ","Time","Probability","Cost","Cost impact ","Time","Probability","Cost","Cost impact ","Time","Probability","Cost","Cost impact ","Time","Probability","Cost","Cost impact ","Time","Probability","Cost","Cost impact ","Time","Probability","Cost","Cost impact ","Time","Probability","Cost","Cost impact ","Time","Probability","Cost","Cost impact ","Time"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HIDE ROW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HIDE ROW"]
["Specific Risks (suggested by the Checklist or otherwise identified)",null,null,null,null,"Treatment Action",null,null,null,"Residual risk scores post treatment",null,null,null,null,null,null,null,null,null,null,null,"Mean Total",{"$f":"SUM(W49:INDIRECT(W104))","v":22353750},{"$f":"W47/C15","v":5.9610000000000003E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TODAYS DATE",{"$f":"TODAY()","v":"2017-08-22"},"Current quantitative cost impact (£)"]
["Objective","RiskID \n(OP code+nnn)","Risk description\n(Cause/Risk/Effect)","Status","Risk Owner\n(Surname, First name)","Action description","Action Owner\n(Surname, First name)","Action Status","Action due date","Probability","Cost",null,"Time",null,"Current Score","CALCS",null,null,"Probability","Minimum","Most Likely","Maximum","Output"]
["Affordable, Value for money scheme","WLR -001","Poor ground condition of Central Windsor and ability to form the route","Open","McPhee,Jon","Perform a suitable Phase 1 and 2 geological/geotechnical assessment to assess ground conditions.  Appropriate design","McPhee,Jon","Open","TBA","Medium","High",null,"High",{"$f":"IF(AND(J50<>$J$2,OR(K50<>$J$2,M50<>$J$2)),(VLOOKUP(J50,$J$2:$K$7,2,FALSE))+(IF(VLOOKUP(K50,$J$2:$K$7,2,FALSE)>VLOOKUP(M50,$J$2:$K$7,2,FALSE),VLOOKUP(K50,$J$2:$K$7,2,FALSE),VLOOKUP(M50,$J$2:$K$7,2,FALSE))),0)","v":7},{"$f":"IF(N50=0,$O$2,IF(OR(N50=1,N50=2),$O$3,IF(AND(N50>2,N50<5),$O$4,IF(AND(N50>4,N50<7),$O$5,IF(N50=7,$O$6,$O$7)))))","v":"Major"},{"$f":"IF(AND(OR(D50=$D$2,D50=$D$5)),CONCATENATE(J50,VLOOKUP(MAX(VLOOKUP(K50,$J$2:$K$7,2,FALSE),VLOOKUP(M50,$J$2:$K$7,2,FALSE)),$K$2:$L$7,2,FALSE)),CONCATENATE($J$2,$J$2))","v":"MediumHigh"},{"$f":"IF(AND(OR(D50=$D$2,D50=$D$5)),O50,$O$2)","v":"Major"},null,{"$f":"IF(D50=\"Open\",VLOOKUP($J50,$S$24:$EV$29,2,FALSE),)","v":0.17499999999999999},{"$f":"IF(D50=\"Open\",VLOOKUP($K50,$S$24:$U$29,3,FALSE),)","v":1000000},null,{"$f":"IF(D50=\"Open\",VLOOKUP($K50,$S$24:$W$29,5,FALSE),)","v":5000000},{"$f":"(T50+(V50-T50)/2)*S50","v":525000}]
["A new single station for Windsor","WLR -002","The proximity of the river to proposed route.","Open","McPhee,Jon","Acquire an enviromental study to inform the risk","McPhee,Jon","Open","TBA","Low","Medium",null,"Medium",5,{"$f":"IF(N51=0,$O$2,IF(OR(N51=1,N51=2),$O$3,IF(AND(N51>2,N51<5),$O$4,IF(AND(N51>4,N51<7),$O$5,IF(N51=7,$O$6,$O$7)))))","v":"Significant"},"LowMedium","Significant",null,{"$f":"IF(D51=\"Open\",VLOOKUP($J51,$S$24:$EV$29,2,FALSE),)","v":7.4999999999999997E-2},{"$f":"IF(D51=\"Open\",VLOOKUP($K51,$S$24:$U$29,3,FALSE),)","v":250000},null,{"$f":"IF(D51=\"Open\",VLOOKUP($K51,$S$24:$W$29,5,FALSE),)","v":1000000},{"$f":"(T51+(V51-T51)/2)*S51","v":46875}]
["Efficient & Attractive Transport Interchange","WLR -003","Planning and approvals risk","Open","McPhee,Jon","Early engagement with Stakeholders","Bathurst, George","Open","TBA","High","Low",null,"High",8,{"$f":"IF(N52=0,$O$2,IF(OR(N52=1,N52=2),$O$3,IF(AND(N52>2,N52<5),$O$4,IF(AND(N52>4,N52<7),$O$5,IF(N52=7,$O$6,$O$7)))))","v":"Critical"},"HighHigh","Critical",null,0.375,50000,null,250000,56250]
["Minimal disruption to surrounding buildings","WLR -004","Existign building stability and settlement during construction and operation","Open","McPhee,Jon","Reduce vibration and noise through appropriate construction methods and in track-slab design.","McPhee,Jon","Open","TBA","High","Medium",null,"Medium",7,"Major","HighMedium","Major",null,{"$f":"IF(D53=\"Open\",VLOOKUP($J53,$S$24:$EV$29,2,FALSE),)","v":0.375},{"$f":"IF(D53=\"Open\",VLOOKUP($K53,$S$24:$U$29,3,FALSE),)","v":250000},null,{"$f":"IF(D53=\"Open\",VLOOKUP($K53,$S$24:$W$29,5,FALSE),)","v":1000000},{"$f":"(T53+(V53-T53)/2)*S53","v":234375}]
["Minimal disruption to surrounding buildings","WLR -005","General noise during construction causing injunctions delaying works","Open","McPhee,Jon","Reduce vibration and noise through low vibration and noise installation methods","McPhee,Jon","Open","TBA","Medium","Low",null,"Very Low",5,"Significant",{"$f":"IF(AND(OR(D54=$D$2,D54=$D$5)),CONCATENATE(J54,VLOOKUP(MAX(VLOOKUP(K54,$J$2:$K$7,2,FALSE),VLOOKUP(M54,$J$2:$K$7,2,FALSE)),$K$2:$L$7,2,FALSE)),CONCATENATE($J$2,$J$2))","v":"MediumLow"},{"$f":"IF(AND(OR(D54=$D$2,D54=$D$5)),O54,$O$2)","v":"Significant"},null,{"$f":"IF(D54=\"Open\",VLOOKUP($J54,$S$24:$EV$29,2,FALSE),)","v":0.17499999999999999},{"$f":"IF(D54=\"Open\",VLOOKUP($K54,$S$24:$U$29,3,FALSE),)","v":50000},null,{"$f":"IF(D54=\"Open\",VLOOKUP($K54,$S$24:$W$29,5,FALSE),)","v":250000},{"$f":"(T54+(V54-T54)/2)*S54","v":26250}]
["Affordable, Value for money scheme","WLR -006","Ground contamination risks due to works","Open","McPhee,Jon","Undertake an environmental study of ground water and aquifers","McPhee,Jon","Open","TBA","Very Low","Very High",null,"High",6,"Significant","Very LowVery High","Significant",null,2.5000000000000001E-2,5000000,null,7500000,156250]
["Affordable, Value for money scheme","WLR -007","Stakeholder views cause disruption and delay","Open","McPhee,Jon","Early engagement with Stakeholders","Bathurst, George","Open","TBA","High","Medium",null,"High",8,"Critical","HighHigh","Critical",null,0.375,250000,null,1000000,234375]
["Affordable, Value for money scheme","WLR -008","Land acquisition strategy - Local Landowners","Open","McPhee,Jon","Early engagement with Stakeholders","Bathurst, George","Open","TBA","High","Medium",null,"High",8,"Critical"]
["Affordable, Value for money scheme","WLR -009","Land acquisition strategy -Council Land","Open","McPhee,Jon","Early engagement with Stakeholders","Bathurst, George","Open","TBA","High","Medium",null,"High",8,"Critical"]
["Affordable, Value for money scheme","WLR -010","Land acquisition strategy - National Trust","Open","McPhee,Jon","Early engagement with Stakeholders","Bathurst, George","Open","TBA","High","Medium",null,"High",8,"Critical","HighHigh","Critical",null,0.375,250000,null,1000000,234375]
["Affordable, Value for money scheme","WLR -011","Confirmation of ability to proceed with a signed off development agreement","Open","McPhee,Jon","Full engagement with Network Rail","Bathurst, George","Open","TBA","Very Low","Very High",null,"Very High",6,"Significant","Very LowVery High","Significant",null,2.5000000000000001E-2,5000000,null,7500000,156250]
["Keep Windsor operational","WLR -012","Utilities disruption / re-routing ","Open","McPhee,Jon","Acquire a detailed services study/report","McPhee,Jon","Open","TBA","Very High","Very High",null,"Medium",10,"Critical","Very HighVery High","Critical",null,0.625,5000000,null,7500000,3906250]
["Affordable, Value for money scheme","WLR -013","Archaeology remains discovered. ","Open","McPhee,Jon","Acquire an archaeological baseline report. ","McPhee,Jon","Open","TBA","High","Medium",null,"High",8,"Critical","HighHigh","Critical",null,{"$f":"IF(D62=\"Open\",VLOOKUP($J62,$S$24:$EV$29,2,FALSE),)","v":0.375},{"$f":"IF(D62=\"Open\",VLOOKUP($K62,$S$24:$U$29,3,FALSE),)","v":250000},null,{"$f":"IF(D62=\"Open\",VLOOKUP($K62,$S$24:$W$29,5,FALSE),)","v":1000000},{"$f":"(T62+(V62-T62)/2)*S62","v":234375}]
["4tph between Slough and Waterloo all stopping at Windsor","WLR -014","The rolling stock assumptions are proven incorrect or not possible, requiring additional infrastructure interventions outside of the immediate WLR area (eg Waterloo)","Open","McPhee,Jon","Approproate definition of the base case design envelope to exclude this","Bathurst, George","Open","TBA","Medium","Very High",null,"Very High",8,"Critical","MediumVery High","Critical",null,0.17499999999999999,5000000,null,7500000,1093750]
["4tph between Slough and Waterloo all stopping at Windsor","WLR -015","The proposed train specification proposed by Windsor Link Railway cannot operate on the infrastructure both within Windsor and beyond towards London. ","Open","McPhee,Jon","Approproate definition of the base case service to Staines and Train Model at GRIP 3","Bathurst, George","Open","TBA","Medium","Very High",null,"Very High",8,"Critical","MediumVery High","Critical",null,0.17499999999999999,5000000,null,7500000,1093750]
["Affordable, Value for money scheme","WLR -016","Risk of finding Unexploded Ordnance ","Open","McPhee,Jon","Acquire a UXO risk report/desk study.","McPhee,Jon","Open","TBA","Medium","Medium",null,"Low",6,"Significant","MediumMedium","Significant",null,0.17499999999999999,250000,null,1000000,109375]
["4tph between Slough and Waterloo all stopping at Windsor","WLR -017","A single track solution is adopted between the Thames River Crossing and East of Riverside Station with passing at the new Station which unacceptably limits the number of trains per hour.","Open","McPhee,Jon","A simple Train Model/ timetable analysis is required to evidence capacity","McPhee,Jon","Open","TBA","Low","Very High",null,"Very Low",7,"Major","LowVery High","Major",null,7.4999999999999997E-2,5000000,null,7500000,468750]
["A new single station for Windsor","WLR -018","The existing properties have basement structures within the highways being used for the new subsurface route.","Open","McPhee,Jon","A survey of all buildings is required to understand existing assets","McPhee,Jon","Open","TBA","Low","High",null,"High",6,"Significant","LowHigh","Significant",null,7.4999999999999997E-2,1000000,null,5000000,225000]
["4tph between Slough and Waterloo all stopping at Windsor","WLR -019","A double track solution is required to achieve four trains per hour and this is unaffordable or unnacceptable to the project.","Open","McPhee,Jon","Timetable and Comprehensive Cost Plan developed at GRIP 3","McPhee,Jon","Open","TBA","Medium","Very High",null,"Very High",8,"Critical","MediumVery High","Critical",null,0.17499999999999999,5000000,null,7500000,1093750]
["Minimal disruption to surrounding buildings","WLR -020","Concern over vibration levels for new developments, over the sub-surface length","Open","McPhee,Jon","Reduce vibration noice and motion throught isolated track-slab design.","McPhee,Jon","Open","TBA","Medium","High",null,"Low",7,"Major","MediumHigh","Major"]
["Efficient low maintenance railcar system","WLR -021","No room for error on design and build as level requirements are very tight for tunnel gradients and radii.","Open","McPhee,Jon","Early GRIP 3 Track design to ensure as much confidence is developed as possible","McPhee,Jon","Open","TBA","Medium","Medium",null,"Medium",6,"Significant","MediumMedium","Significant"]
["Efficient low maintenance railcar system","WLR -022","Safety of passengers needing to disembark if a train breaks down within the sub-surface length","Open","McPhee,Jon","Provision of safe cess walkway in tunnel ","McPhee,Jon","Open","TBA","Very Low","Medium",null,"Low",4,"Minor","Very LowMedium","Minor"]
["Keep Windsor operational","WLR -023","Disruption to local economy during implementation","Open","McPhee,Jon","Limit road closures where possible and employ good TM management providing advanced notice to drivers and businesses.","McPhee,Jon","Open","TBA","Very High","Low",null,"Very Low",7,"Major","Very HighLow","Major"]
["Keep Windsor operational","WLR -024","Disruption to existing railway during construction","Open","McPhee,Jon","Aim to keep the current railway operational for as long as possible during construction works.","McPhee,Jon","Open","TBA","Very High","Low",null,"Very Low",7,"Major","Very HighLow","Major"]
["Keep Windsor operational","WLR -025","Disruption to existing foot and cyle traffic during construction","Open","McPhee,Jon","Provide alternative safe walking and cycling routes","McPhee,Jon","Open","TBA","Very High","Very Low",null,"Very Low",6,"Significant","Very HighVery Low","Significant",null,0.625,0,null,50000,15625]
["Keep Windsor operational","WLR -026","State Visits and Funerals are carried out without notice and works need to be flexible.","Open","McPhee,Jon","Understand the typical scenario and include within the construction phasing.","McPhee,Jon","Open","TBA","Very High","Very Low",null,"Very Low",6,"Significant",{"$f":"IF(AND(OR(D75=$D$2,D75=$D$5)),CONCATENATE(J75,VLOOKUP(MAX(VLOOKUP(K75,$J$2:$K$7,2,FALSE),VLOOKUP(M75,$J$2:$K$7,2,FALSE)),$K$2:$L$7,2,FALSE)),CONCATENATE($J$2,$J$2))","v":"Very HighVery Low"},{"$f":"IF(AND(OR(D75=$D$2,D75=$D$5)),O75,$O$2)","v":"Significant"},null,{"$f":"IF(D75=\"Open\",VLOOKUP($J75,$S$24:$EV$29,2,FALSE),)","v":0.625},{"$f":"IF(D75=\"Open\",VLOOKUP($K75,$S$24:$U$29,3,FALSE),)","v":0},null,{"$f":"IF(D75=\"Open\",VLOOKUP($K75,$S$24:$W$29,5,FALSE),)","v":50000},{"$f":"(T75+(V75-T75)/2)*S75","v":15625}]
["4tph between Slough and Waterloo all stopping at Windsor","WLR -027","Franchise Process fails to include for WLR proposals","Open","McPhee,Jon","Early engagement with DfT regarding new franchise","Bathurst, George","Open","TBA","Very High","Medium",null,"Very Low",8,"Critical",{"$f":"IF(AND(OR(D76=$D$2,D76=$D$5)),CONCATENATE(J76,VLOOKUP(MAX(VLOOKUP(K76,$J$2:$K$7,2,FALSE),VLOOKUP(M76,$J$2:$K$7,2,FALSE)),$K$2:$L$7,2,FALSE)),CONCATENATE($J$2,$J$2))","v":"Very HighMedium"},{"$f":"IF(AND(OR(D76=$D$2,D76=$D$5)),O76,$O$2)","v":"Critical"},null,{"$f":"IF(D76=\"Open\",VLOOKUP($J76,$S$24:$EV$29,2,FALSE),)","v":0.625},{"$f":"IF(D76=\"Open\",VLOOKUP($K76,$S$24:$U$29,3,FALSE),)","v":250000},null,{"$f":"IF(D76=\"Open\",VLOOKUP($K76,$S$24:$W$29,5,FALSE),)","v":1000000},{"$f":"(T76+(V76-T76)/2)*S76","v":390625}]
["A new single station for Windsor","WLR -028","New platforms should not be on a curved track of less than 1000m radius.  WLR is 300m potentially.","Open","McPhee,Jon","Develop GRIP2 to maximise the straightest  length of platform possible","McPhee,Jon","Open","TBA","Medium","Low",null,"Low",5,"Significant","MediumLow","Significant",null,0.17499999999999999,50000,null,250000,26250]
["A new single station for Windsor","WLR -029","Track speed causes high cant values which are inappropriate for platforms","Open","McPhee,Jon","Limit track speed whilst keeping 4tph and all trains stopping","McPhee,Jon","Open","TBA","Low","Very Low",null,"Very Low",3,"Minor",{"$f":"IF(AND(OR(D78=$D$2,D78=$D$5)),CONCATENATE(J78,VLOOKUP(MAX(VLOOKUP(K78,$J$2:$K$7,2,FALSE),VLOOKUP(M78,$J$2:$K$7,2,FALSE)),$K$2:$L$7,2,FALSE)),CONCATENATE($J$2,$J$2))","v":"LowVery Low"},{"$f":"IF(AND(OR(D78=$D$2,D78=$D$5)),O78,$O$2)","v":"Minor"},null,{"$f":"IF(D78=\"Open\",VLOOKUP($J78,$S$24:$EV$29,2,FALSE),)","v":7.4999999999999997E-2},{"$f":"IF(D78=\"Open\",VLOOKUP($K78,$S$24:$U$29,3,FALSE),)","v":0},null,{"$f":"IF(D78=\"Open\",VLOOKUP($K78,$S$24:$W$29,5,FALSE),)","v":50000},{"$f":"(T78+(V78-T78)/2)*S78","v":1875}]
["Efficient low maintenance railcar system","WLR -030","Track speed causes high cant values which are inappropriate for switches","Open","McPhee,Jon","Develop GRIP2 to ensure track systems are functional","McPhee,Jon","Open","TBA","Low","Very Low",null,"Very Low",3,"Minor","LowVery Low","Minor",null,7.4999999999999997E-2,0,null,50000,1875]
["Efficient low maintenance railcar system","WLR -031","Gradients cause wheel slippage  when combined with tight radius","Open","McPhee,Jon","Develop GRIP2 to ensure rolling stock are functional","McPhee,Jon","Open","TBA","Medium","Low",null,"Very Low",5,"Significant","MediumLow","Significant",null,0.17499999999999999,50000,null,250000,26250]
["Efficient low maintenance railcar system","WLR -032","Broken down trains within the tunnel unrecoverable due to gradient","Open","McPhee,Jon","Ensure capacity of existing rolling stock to push broken down trains out","McPhee,Jon","Open","TBA","Very Low","Very Low",null,"Very Low",2,"Routine","Very LowVery Low","Routine",null,2.5000000000000001E-2,0,null,50000,625]
["Efficient low maintenance railcar system","WLR -033","Migration of curves at bottom of ramp approaches the switch","Open","McPhee,Jon","Use of track slab will prevent track profile changes","McPhee,Jon","Open","TBA","Very Low","Medium",null,"Low",4,"Minor","Very LowMedium","Minor",null,2.5000000000000001E-2,250000,null,1000000,15625]
["4tph between Slough and Waterloo all stopping at Windsor","WLR -034","Capacity of the existing track outside of the immediate WLR area can not support four trains per hour.","Open","McPhee,Jon","Approproate definition of the base case service to Waterloo and Train Model at GRIP 3","Bathurst, George","Open","TBA","Very Low","Very High",null,"Very High",6,"Significant",{"$f":"IF(AND(OR(D83=$D$2,D83=$D$5)),CONCATENATE(J83,VLOOKUP(MAX(VLOOKUP(K83,$J$2:$K$7,2,FALSE),VLOOKUP(M83,$J$2:$K$7,2,FALSE)),$K$2:$L$7,2,FALSE)),CONCATENATE($J$2,$J$2))","v":"Very LowVery High"},{"$f":"IF(AND(OR(D83=$D$2,D83=$D$5)),O83,$O$2)","v":"Significant"},null,{"$f":"IF(D83=\"Open\",VLOOKUP($J83,$S$24:$EV$29,2,FALSE),)","v":2.5000000000000001E-2},{"$f":"IF(D83=\"Open\",VLOOKUP($K83,$S$24:$U$29,3,FALSE),)","v":5000000},null,{"$f":"IF(D83=\"Open\",VLOOKUP($K83,$S$24:$W$29,5,FALSE),)","v":7500000},{"$f":"(T83+(V83-T83)/2)*S83","v":156250}]
["Affordable, Value for money scheme","WLR -035","A substantial upgrade to the signalling system is required","Open","McPhee,Jon","Review required at GRIP 3","McPhee,Jon","Open","TBA","High","High",null,"High",8,"Critical","HighHigh","Critical",null,0.375,1000000,null,5000000,1125000]
["Affordable, Value for money scheme","WLR -036","A substantial upgrade to the power system is required","Open","McPhee,Jon","Review required at GRIP 3","McPhee,Jon","Open","TBA","High","High",null,"High",8,"Critical",{"$f":"IF(AND(OR(D85=$D$2,D85=$D$5)),CONCATENATE(J85,VLOOKUP(MAX(VLOOKUP(K85,$J$2:$K$7,2,FALSE),VLOOKUP(M85,$J$2:$K$7,2,FALSE)),$K$2:$L$7,2,FALSE)),CONCATENATE($J$2,$J$2))","v":"HighHigh"},{"$f":"IF(AND(OR(D85=$D$2,D85=$D$5)),O85,$O$2)","v":"Critical"},null,{"$f":"IF(D85=\"Open\",VLOOKUP($J85,$S$24:$EV$29,2,FALSE),)","v":0.375},{"$f":"IF(D85=\"Open\",VLOOKUP($K85,$S$24:$U$29,3,FALSE),)","v":1000000},null,{"$f":"IF(D85=\"Open\",VLOOKUP($K85,$S$24:$W$29,5,FALSE),)","v":5000000},{"$f":"(T85+(V85-T85)/2)*S85","v":1125000}]
["Affordable, Value for money scheme","WLR -037","Thames River Crossing is the oldest iron rail bridge in operation and has listed building status.","Open","McPhee,Jon","Single track operation maintained","McPhee,Jon","Open","TBA","Very Low","Very Low",null,"Very Low",2,"Routine",{"$f":"IF(AND(OR(D86=$D$2,D86=$D$5)),CONCATENATE(J86,VLOOKUP(MAX(VLOOKUP(K86,$J$2:$K$7,2,FALSE),VLOOKUP(M86,$J$2:$K$7,2,FALSE)),$K$2:$L$7,2,FALSE)),CONCATENATE($J$2,$J$2))","v":"Very LowVery Low"},{"$f":"IF(AND(OR(D86=$D$2,D86=$D$5)),O86,$O$2)","v":"Routine"},null,{"$f":"IF(D86=\"Open\",VLOOKUP($J86,$S$24:$EV$29,2,FALSE),)","v":2.5000000000000001E-2},{"$f":"IF(D86=\"Open\",VLOOKUP($K86,$S$24:$U$29,3,FALSE),)","v":0},null,{"$f":"IF(D86=\"Open\",VLOOKUP($K86,$S$24:$W$29,5,FALSE),)","v":50000},{"$f":"(T86+(V86-T86)/2)*S86","v":625}]
["Minimal disruption to surrounding buildings","WLR -038","Risk of 'harm' to Listed Buildings","Open","McPhee,Jon","Care taken in design to avoid unecessary impacts","McPhee,Jon","Open","TBA","Low","High",null,"High",6,"Significant","LowHigh","Significant",null,7.4999999999999997E-2,1000000,null,5000000,225000]
["Affordable, Value for money scheme","WLR -039","Existing unknown sub-surface tunnels, culverts and features on the route","Open","McPhee,Jon","GPR to be undertaken as a part of a detailed survey at GRIP 3","McPhee,Jon","Open","TBA","Low","High",null,"High",6,"Significant","LowHigh","Significant",null,7.4999999999999997E-2,1000000,null,5000000,225000]
["Affordable, Value for money scheme","WLR -040","The criticality of further investigation and design work is not understood at senior level within WLR","Open","McPhee,Jon","Full engagement with Network Rail by Directors of WLR","Bathurst, George","Open","TBA","Low","Medium",null,"Low",{"$f":"IF(AND(J89<>$J$2,OR(K89<>$J$2,M89<>$J$2)),(VLOOKUP(J89,$J$2:$K$7,2,FALSE))+(IF(VLOOKUP(K89,$J$2:$K$7,2,FALSE)>VLOOKUP(M89,$J$2:$K$7,2,FALSE),VLOOKUP(K89,$J$2:$K$7,2,FALSE),VLOOKUP(M89,$J$2:$K$7,2,FALSE))),0)","v":5},{"$f":"IF(N89=0,$O$2,IF(OR(N89=1,N89=2),$O$3,IF(AND(N89>2,N89<5),$O$4,IF(AND(N89>4,N89<7),$O$5,IF(N89=7,$O$6,$O$7)))))","v":"Significant"},{"$f":"IF(AND(OR(D89=$D$2,D89=$D$5)),CONCATENATE(J89,VLOOKUP(MAX(VLOOKUP(K89,$J$2:$K$7,2,FALSE),VLOOKUP(M89,$J$2:$K$7,2,FALSE)),$K$2:$L$7,2,FALSE)),CONCATENATE($J$2,$J$2))","v":"LowMedium"},{"$f":"IF(AND(OR(D89=$D$2,D89=$D$5)),O89,$O$2)","v":"Significant"},null,{"$f":"IF(D89=\"Open\",VLOOKUP($J89,$S$24:$EV$29,2,FALSE),)","v":7.4999999999999997E-2},{"$f":"IF(D89=\"Open\",VLOOKUP($K89,$S$24:$U$29,3,FALSE),)","v":250000},null,{"$f":"IF(D89=\"Open\",VLOOKUP($K89,$S$24:$W$29,5,FALSE),)","v":1000000},{"$f":"(T89+(V89-T89)/2)*S89","v":46875}]
["4tph between Slough and Waterloo all stopping at Windsor","WLR -041","The track bed width from Windsor to Slough is no longer suitable for twin tracking to satisfy the timetable.","Open","McPhee,Jon","Full Asset inspections and surveys undertaken at the start of GRIP 3 and reviewed","McPhee,Jon","Open","TBA","Low","High",null,"High",6,"Significant","LowHigh","Significant",null,7.4999999999999997E-2,1000000,null,5000000,225000]
["Affordable, Value for money scheme","WLR -042","The risk to the business case of proceeding to GRIP 3 without detailed civils asset information from Network Rail and understanding of assets to be used in WLR","Open","McPhee,Jon","Full Asset inspections and surveys undertaken at the start of GRIP 3 and reviewed","McPhee,Jon","Open","TBA","Medium","High",null,"High",7,"Major","MediumHigh","Major",null,0.17499999999999999,1000000,null,5000000,525000]
["Affordable, Value for money scheme","WLR -043","The risk to the business case of proceeding to GRIP 3 without detailed signalling asset information from Network Rail and understanding of assets to be used in WLR","Open","McPhee,Jon","Full Asset inspections and surveys undertaken at the start of GRIP 3 and reviewed","McPhee,Jon","Open","TBA","High","High",null,"High",8,"Critical","HighHigh","Critical",null,0.375,1000000,null,5000000,1125000]
["Affordable, Value for money scheme","WLR -044","The risk to the business case of proceeding to GRIP 3 without detailed traction power asset information from Network Rail and understanding of assets to be used in WLR","Open","McPhee,Jon","Full Asset inspections and surveys undertaken at the start of GRIP 3 and reviewed","McPhee,Jon","Open","TBA","High","High",null,"High",8,"Critical","HighHigh","Critical",null,0.375,1000000,null,5000000,1125000]
["Safe transport system","WLR -045","The existing level crossing represent an unacceptable risk to WLR and needs to be closed","Open","McPhee,Jon","New Franchise requires 4tph through the same level crossings","McPhee,Jon","Open","TBA","Low","High",null,"High",6,"Significant","LowHigh","Significant",null,7.4999999999999997E-2,1000000,null,5000000,225000]
["Affordable, Value for money scheme","WLR -046","Risk that forecast increase in patronage will be insufficient to deliver adequate revenue to satisfy the business case","Open","McPhee,Jon","Detailed discussions with DfT required to agree funding","Bathurst, George","Open","TBA","Low","High",null,"High",6,"Significant","LowHigh","Significant",null,7.4999999999999997E-2,1000000,null,5000000,225000]
["Affordable, Value for money scheme","WLR -047","Risk that new franchise improvements to 4tph to Windsor removes large patronage growthupon which WLR relies for funding","Open","McPhee,Jon","Detailed discussions with DfT required to agree funding","Bathurst, George","Open","TBA","Low","High",null,"High",6,"Significant","LowHigh","Significant",null,7.4999999999999997E-2,1000000,null,5000000,225000]
["Affordable, Value for money scheme","WLR -048","Risk that combining complex projects in to a single programme causes undue risk within a small town","Open","McPhee,Jon","Careful phasing and appropriate solutions prioritised in GRIP 3 options","McPhee,Jon","Open","TBA","Medium","Medium",null,"High",7,"Major","MediumHigh","Major",null,0.17499999999999999,250000,null,1000000,109375]
["Affordable, Value for money scheme","WLR -049","Platform lengthening uncovers unknown cables and subsurface features","Open","McPhee,Jon","Full Asset inspections and surveys undertaken at the start of GRIP 3 and reviewed","McPhee,Jon","Open","TBA","Medium","High",null,"Medium",7,"Major","MediumHigh","Major",null,0.17499999999999999,1000000,null,5000000,525000]
["Affordable, Value for money scheme","WLR -050","Resources not available to meet the design programme in specialist areas","Open","McPhee,Jon","Appropriate allocation of resource through competent design chain","Bathurst, George","Open","TBA","Very Low","Low",null,"Low",3,"Minor","Very LowLow","Minor",null,2.5000000000000001E-2,50000,null,250000,3750]
["Efficient low maintenance railcar system","WLR -051","Resources not available to meet the construction programme in specialist areas","Open","McPhee,Jon","Appropriate allocation of resource through competent design chain","McPhee,Jon","Open","TBA","Very Low","Low",null,"Low",{"$f":"IF(AND(J100<>$J$2,OR(K100<>$J$2,M100<>$J$2)),(VLOOKUP(J100,$J$2:$K$7,2,FALSE))+(IF(VLOOKUP(K100,$J$2:$K$7,2,FALSE)>VLOOKUP(M100,$J$2:$K$7,2,FALSE),VLOOKUP(K100,$J$2:$K$7,2,FALSE),VLOOKUP(M100,$J$2:$K$7,2,FALSE))),0)","v":3},{"$f":"IF(N100=0,$O$2,IF(OR(N100=1,N100=2),$O$3,IF(AND(N100>2,N100<5),$O$4,IF(AND(N100>4,N100<7),$O$5,IF(N100=7,$O$6,$O$7)))))","v":"Minor"},"Very LowLow","Minor",null,2.5000000000000001E-2,50000,null,250000,3750]
["Efficient low maintenance railcar system","WLR -052","New Rolling Stock Requirements required to deliver the objectives present prohibitive costs to WLR","Open","McPhee,Jon","Selection of solutions which use existing rollin gstock from new franchise or modest interventions","Bathurst, George","Open","TBA","High","Very High",null,"Very High",{"$f":"IF(AND(J101<>$J$2,OR(K101<>$J$2,M101<>$J$2)),(VLOOKUP(J101,$J$2:$K$7,2,FALSE))+(IF(VLOOKUP(K101,$J$2:$K$7,2,FALSE)>VLOOKUP(M101,$J$2:$K$7,2,FALSE),VLOOKUP(K101,$J$2:$K$7,2,FALSE),VLOOKUP(M101,$J$2:$K$7,2,FALSE))),0)","v":9},{"$f":"IF(N101=0,$O$2,IF(OR(N101=1,N101=2),$O$3,IF(AND(N101>2,N101<5),$O$4,IF(AND(N101>4,N101<7),$O$5,IF(N101=7,$O$6,$O$7)))))","v":"Critical"},"HighVery High","Critical",null,0.375,5000000,null,7500000,2343750]
["Safe transport system","WLR -053","Electrification using third rail solution is not acceptable to ORR requiring alternative solutions for traction power","Open","McPhee,Jon","Detailed discussions and risk assessment with ORR required to agree extension of third rail system","McPhee,Jon","Open","TBA","Very High","High",null,"Medium",{"$f":"IF(AND(J102<>$J$2,OR(K102<>$J$2,M102<>$J$2)),(VLOOKUP(J102,$J$2:$K$7,2,FALSE))+(IF(VLOOKUP(K102,$J$2:$K$7,2,FALSE)>VLOOKUP(M102,$J$2:$K$7,2,FALSE),VLOOKUP(K102,$J$2:$K$7,2,FALSE),VLOOKUP(M102,$J$2:$K$7,2,FALSE))),0)","v":9},{"$f":"IF(N102=0,$O$2,IF(OR(N102=1,N102=2),$O$3,IF(AND(N102>2,N102<5),$O$4,IF(AND(N102>4,N102<7),$O$5,IF(N102=7,$O$6,$O$7)))))","v":"Critical"},"Very HighHigh","Critical",null,0.625,1000000,null,5000000,1875000]
["Keeping Windsor operational before, during and after construction","WLR -054","Local groundwater flooding caused by impermeability of subsurface solutions affecting hydrology in area.","Open","McPhee,Jon","GRIP 3 study to be undertaken to confirm subsurface water flows and mitigations required for Windsor","McPhee,Jon","Open","TBA","Medium","High",null,"Medium",{"$f":"IF(AND(J103<>$J$2,OR(K103<>$J$2,M103<>$J$2)),(VLOOKUP(J103,$J$2:$K$7,2,FALSE))+(IF(VLOOKUP(K103,$J$2:$K$7,2,FALSE)>VLOOKUP(M103,$J$2:$K$7,2,FALSE),VLOOKUP(K103,$J$2:$K$7,2,FALSE),VLOOKUP(M103,$J$2:$K$7,2,FALSE))),0)","v":7},{"$f":"IF(N103=0,$O$2,IF(OR(N103=1,N103=2),$O$3,IF(AND(N103>2,N103<5),$O$4,IF(AND(N103>4,N103<7),$O$5,IF(N103=7,$O$6,$O$7)))))","v":"Major"},{"$f":"IF(AND(OR(D103=$D$2,D103=$D$5)),CONCATENATE(J103,VLOOKUP(MAX(VLOOKUP(K103,$J$2:$K$7,2,FALSE),VLOOKUP(M103,$J$2:$K$7,2,FALSE)),$K$2:$L$7,2,FALSE)),CONCATENATE($J$2,$J$2))","v":"MediumHigh"},{"$f":"IF(AND(OR(D103=$D$2,D103=$D$5)),O103,$O$2)","v":"Major"},null,{"$f":"IF(D103=\"Open\",VLOOKUP($J103,$S$24:$EV$29,2,FALSE),)","v":0.17499999999999999},{"$f":"IF(D103=\"Open\",VLOOKUP($K103,$S$24:$U$29,3,FALSE),)","v":1000000},null,{"$f":"IF(D103=\"Open\",VLOOKUP($K103,$S$24:$W$29,5,FALSE),)","v":5000000},{"$f":"(T103+(V103-T103)/2)*S103","v":525000}]
[null,null,null,null,null,"Recommended contingency for GRIP Stage of register =",null,null,{"$f":"$AL$14","v":0.25},"Qualitative Mean contingency  =",null,null,{"$f":"IF(C15=0,,W47/C15)","v":5.9610000000000003E-2},{"$f":"M104*C15","v":22353750},{"$f":"M104*C15","v":22353750},{"$f":"\"Q\"&ROW()-2","v":"Q102"},{"$f":"IF(AND(OR(D104=$D$2,D104=$D$5)),M104,$O$2)","v":"Nil"},null,null,null,null,null,{"$f":"\"W\" &ROW()-1","v":"W103"},null,null,{"$f":"ROW()","v":104}]
["WARNING: Do not add or delete any rows beneath the \"Add New Row\" line"]

{"sheet":"Generic risk prompt sheet","index":1,"n_rows":50,"n_cols":256,"rows_kept":50,"cut":false,"hidden":false,"merged":[[45,2,45,4],[0,0,0,4],[2,0,5,4],[6,0,6,4],[7,0,7,4],[10,2,10,4],[9,3,9,4]]}
["Generic risk provision checklist"]
[]
["The generic risk checklist, shown below, is derived from experience of inherent project implementation risks. Due to the nature of the items noted below these may more accurately be termed 'issues' due to the almost certainty that they will occur in some form during the lifecycle of the project. It is for this reason that a likelihood of high is applied and the impact will be determined by the number of risk identified.\nThe Project Manager should note with a \"Y\" those generic risks that apply and/or note where a specific risk is worthy of recording in its own right for management purposes. These specifics shall be transferred to the risk register."]
[]
[]
[]
[]
["Cost allocation is derived from the number of generic items selected as being applicable to the type of works using the table also shown below with the addition of any specifics being assessed in the register."]
[]
["Project: ",{"$f":"'Risk Register'!C13","v":"Windsor Link Railway"},"OP Code:","WRL"]
["GRIP:",{"$f":"'Risk Register'!C14","v":2},"Mark \"Y\" as appropriate"]
[null,"Risk/Issue","Generic","N/A","Specific Risk",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[1,"Access: availability (track and general site access)","Y",null,"Y",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[2,"Accommodation issues - relocations or complex temporary","Y",null,"Y"]
[3,"Planning Approvals - complexity of securing agreement","Y",null,"Y"]
[4,"Availability of Records/ Drawings","Y",null,"Y"]
[5,"Potential for signficant change of Scope/ design development unknowns","Y",null,"Y"]
[6,"Disruption of train services","Y",null,"Y"]
[7,"Environmental impact: Environment Agency interests","Y",null,"Y"]
[8,"Reliance on Engineering trains","N",null,"N"]
[9,"Ground conditions - unknowns/ complexity","Y",null,"Y"]
[10,"Ground obstructions unknowns/ complexity","Y",null,"Y"]
[11,"Interfaces with other projects (in our outside NR)","Y",null,"Y"]
[12,"Local Issues / Events - potential to affect/be affected","Y",null,"Y"]
[13,"Noise disturbance - S106 constraints etc","Y",null,"Y"]
[14,"Overrun of Works - schedule confidence level","Y",null,"Y"]
[15,"Necessity for possessions","Y",null,"Y"]
[16,"Preservation Orders on vegetation/TPOs","Y",null,"Y"]
[17,"NR infrastructure - damage","Y",null,"Y"]
[18,"Plant Failure","Y",null,"Y"]
[19,"Theft/vandalism/trespass","Y",null,"Y"]
[20,"Recoveries/disposals","Y",null,"Y"]
[21,"Resources - design: availability/ capability","Y",null,"Y"]
[22,"Resources - development:  availability/ capability","Y",null,"Y"]
[23,"Resources - implementation:  availability/ capability including supply chain","Y",null,"Y"]
[24,"Road & footpath closures","Y",null,"Y"]
[25,"S&T Works","Y",null,"Y"]
[26,"Necessity for complex scaffolding","N",null,"N"]
[27,"Security","Y",null,"Y"]
[28,"NR/ Industry Standards – issues with compliance/ innovative solutions","Y",null,"N"]
[29,"Statutory services ( utilities, local authorities)","Y",null,"Y"]
[30,"Traffic Management Costs","Y",null,"Y"]
[31,"Weather","Y",null,"Y"]
[]
[null,"Total number of risks",{"$f":"COUNTIF(C13:C43,\"Y\")","v":29},null,{"$f":"COUNTIF(E13:E43,\"Y\")","v":28}]
[null,"Allowance for Generic Risks at mean (% of point estimate) range depending upon the number identified, the GRIP stage and Asset type",{"$f":"C45/31*'Risk Register'!AL14","v":0.23387096774193547}]
[]
[null,null,"Very Low","Low","Medium","High","Very High"]
[]
[null,"Number of generic risks identified","1 to 10"," 6 to 16 "," 10 to 20 "," 14 to 22 "," 22 to 31"]

{"sheet":"Template instructions","index":2,"n_rows":9,"n_cols":1,"rows_kept":9,"cut":false,"hidden":false,"merged":[[8,0,8,1],[0,0,0,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[1,0,2,1],[3,0,3,1],[7,0,7,1]]}
["Instructions for using this template"]
["Complete Project information - Complete project information at the top of the risk register, the required fields are OP code, Project Title, Current GRIP Stage (from drop down menu), Asset type (from drop down menu), Estimate \"to go\" value in digits (e.g. £800,000 and not £0.8m), Project Manager,  Status Date of register and Project Information. Note: Project size is derived from the Estimate \"to go\" value.\n\n"]
[]
["Consider Generic and Site Specific Risks\nGo to the Generic Risk Prompt List and select which generics and which project specifics are relevant to your works. The \"Generic Risk as a % of Estimate \"to go\" value\" will be calculated and will start to build the risk register - see below."]
["Objectives - Fill out the core objectives of your project, you may fill out as many as you need (five is recommended as a maximum).  The purpose of listing the objectives is to provide a context for identifying project threats and opportunities."]
["Adding risks - The risk items should come from the specific risks suggested by the generic risk prompt sheet.  Considering the items selected, the project team should add the key actual risks that are a threat or opportunity to their project.\n\nEach risk description should be documented as Cause-Risk-Effect, for example; \nCause - Late running passenger trains delay the start of the possession\nRisk - Due to the length of the delay the works will not be able to be completed within the possession limits\nEffect - Additional costs for abortive shifts and programme delay\n\nIt should be noted that risk ID codes will not be generated automatically, it is recommended that OP codes are used to code risks, for example 101659-001, 101659-002."]
["Completing the risk register - Each field must be completed.\nFields have been categorised into \"Risk\", \"Treatment\" and \"Impact\".  \n\nTo assist in the assessment of project risks the impact fields have qualitative drop downs fields for probability, cost and time, that once completed will automatically categorise the severity of each risk  using the scale provided in the risk register.  The severity scale will enable project team to highlight high profile risks.\n\nRisk Owner and Action Owner should be in the following format i.e. Surname, First Name.\n\nThe register has five risk lines visible. If more risks are required, click on the \"Add New Row\" button at the bottom of the template and excel will add a new risk line. Further clicks will add more lines."]
["Using the qualitative Mean calculation\nThe sheet has the functionality to generate a qualitative mean contingency as a % of the AFC value.  This is generated by using the probability and cost impact ratings from the drop down menu in each cell. The calculation values are derived from the qualitative risk scoring scale at the top right hand corner of the sheet to provide a qualitative mean contingency risk exposure.\n\nRecommended contingency (at mean) %\nThe spreadsheet provides a value based upon Asset type and current GRIP Stage and compares this to typical benchmarks. If you are notably outside these benchmarks you should double check that the input is valid and this will provide adequate substantation for the deviation."]
["Entry into ARM\nThe Register sheet will generate the values that need to be entered into ARM either under one line entry or if the specifics are included, the totals needs to reflect these numbers. For further advice, please contact a member of the R&V Team."]

{"sheet":"Version Control","index":3,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Version Control"]
[]
["Version","Description","Date","By Whom"]
[1,"Workshop with Network Rail & WLR","2016-11-29","Jon McPhee"]
[1.1000000000000001,"Internal Designer Development","2016-12-02","Jon McPhee"]
[1.2,"Internal Designer Development","2017-01-25","Jon McPhee"]
[1.3,"First formal Draft Issue to NR for review ","2017-03-29","Jon McPhee"]
[1.4]
[1.5]
[1.6]
[1.7]
[1.8]