{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["NTA Contingency Matrix"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":1,"comments":0,"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":"NTA Contingency Matrix","index":0,"n_rows":61,"n_cols":17,"rows_kept":61,"cut":false,"hidden":false,"merged":[[1,13,1,18],[2,16,2,21],[7,13,7,23],[8,13,14,13],[38,5,45,10],[36,9,36,10],[24,9,24,10],[20,9,20,10],[21,9,21,10],[22,9,22,10],[23,9,23,10],[26,1,27,1],[26,9,26,10],[27,9,27,10],[28,9,28,10],[35,9,35,10],[26,2,26,6],[27,2,27,6],[33,9,33,10],[34,9,34,10],[29,9,29,10],[24,1,25,1],[22,2,22,6],[23,2,23,6],[24,2,24,6],[25,2,25,6],[18,1,20,1],[21,1,23,1],[1,1,1,11],[34,1,35,1],[33,2,33,6],[35,2,35,6],[34,2,34,6],[29,2,29,6],[30,2,30,6],[31,2,31,6],[32,2,32,6],[31,1,32,1],[3,2,3,10],[6,2,6,3],[6,7,6,8],[8,5,8,6],[8,2,8,3],[30,9,30,10],[4,2,4,10],[31,9,31,10],[32,9,32,10],[25,9,25,10],[8,7,8,10],[28,2,28,6],[18,2,18,6],[20,2,20,6],[21,2,21,6],[17,2,17,6],[19,2,19,6],[17,9,17,10],[18,9,18,10],[19,9,19,10]]}
[]
[null,"Contingency Calculator"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Guidance Notes",null,null,"* All cells in purple - input is required"]
[null,"Project Title:","R5*** Navan Road - Dublin",null,null,null,null,null,null,null,null,null,null,"Sponoring Agency (SA) to list out the project title"]
[null,"Project / Contract Code:","DLR/22/0015G",null,null,null,null,null,null,null,null,null,null,"SA confirm the project code"]
[]
[null,"NTA Project Phase:","Phase 5 - Detailed Design and Procurement",null,null,"Work Classification:",null,"'Standard' project",null,null,null,null,null,"SA to confirm the project phase (see drop when you click on the cell C7)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"SA to confirm the classification (see drop when you click on the cell H7) - non standard would be working in a City centre"]
[null,"Contingency Factors:","'Non-standard' project",null,null,"'Standard' project",null,"Quantitative Risk Assessment (QRA)",null,null,null,null,null,"This section is guidance only "]
[null,"NTA Project Phase","Upper bound \nContingency (%)","Lower bound\n Contingency (%)",null,"Upper bound \nContingency (%)","Lower bound\n Contingency (%)","QRA Required","Band 1","Band 2","Band 3"]
[null,"Phase 1 - Scope and Purpose",66,50,null,44,30,"No","N/A","N/A","N/A"]
[null,"Phase 2 - Concept Development and Option Selection",66,50,null,44,30,"No","N/A","N/A","N/A"]
[null,"Phase 3 - Preliminary Design",50,30,null,35,20,"Yes","004_B1_QRA_CMG","013_B23_QRA_CMG","013_B23_QRA_CMG"]
[null,"Phase 4 - Statutory Processes",50,30,null,30,20,"Yes","004_B1_QRA_CMG","013_B23_QRA_CMG","013_B23_QRA_CMG"]
[null,"Phase 5 - Detailed Design and Procurement",30,10,null,20,10,"Yes","004_B1_QRA_CMG","013_B23_QRA_CMG","013_B23_QRA_CMG"]
[]
[]
[null,"Contributory Factors","Mitigation Action",null,null,null,null,"% Weighting","% Completed","% Mitigation",null,null,null,"SA to confirm the % complete"]
[null,"Land / Planning ","Proposed works confined to land within NTA ownership / control",null,null,null,null,0.05,100,{"$f":"H19*I19/100","v":0.05}]
[null,null,"Additional land values confirmed / land acquired",null,null,null,null,2.5000000000000001E-2,100,2.5000000000000001E-2]
[null,null,"Liaison with Planning Authority / Planning commenced or awarded",null,null,null,null,2.5000000000000001E-2,100,2.5000000000000001E-2]
[null,"Design development / complexity","Design developed beyond stated NTA Project Phase",null,null,null,null,0.05,100,0.05]
[null,null,"Design comprises standard construction elements",null,null,null,null,2.5000000000000001E-2,100,2.5000000000000001E-2]
[null,null,"NTA / Contractor has a proven track record of delivering similar solutions",null,null,null,null,2.5000000000000001E-2,100,2.5000000000000001E-2]
[null,"Risk management","Key Project risks identified and mitigation measures defined",null,null,null,null,2.5000000000000001E-2,100,2.5000000000000001E-2]
[null,null,"Key Project risks allocated appropriate cost and time allowances / QRA produced",null,null,null,null,0.2,100,0.2]
[null,"Estimates / costs independently verified","Cost build-up independently checked and verified",null,null,null,null,0.05,100,0.05]
[null,null,"Alignment of costs with NTA benchmarks",null,null,null,null,7.4999999999999997E-2,100,7.4999999999999997E-2]
[null,"Scope of Proposal","Scope of works is well defined and robust",null,null,null,null,0.05,100,0.05]
[null,"Project intelligence / surveys and investigations","Surveys and investigations undertaken to inform the design",null,null,null,null,0.05,100,0.05]
[null,"Stakeholders","Affected stakeholders identified, consulted and key requirements documented",null,null,null,null,0.15,100,0.15]
[null,"Environmental impact","Proposed solution has minimal environmental impact",null,null,null,null,2.5000000000000001E-2,100,2.5000000000000001E-2]
[null,null,"Base price and delivery programme includes appropriate allowance for environmental / ecological mitigation",null,null,null,null,0.05,100,0.05]
[null,"Health & Safety","Methodology mitigates serious incident occurrence",null,null,null,null,0.05,100,0.05]
[null,"Procurement","Procurement strategy concluded / tried and tested solution recommended",null,null,null,null,2.5000000000000001E-2,100,2.5000000000000001E-2]
[null,null,"Procurement successfully completed",null,null,null,null,0.05,100,0.05]
[null,null,null,null,null,null,null,{"$f":"SUM(H19:H36)","v":1.0000000000000002},null,{"$f":"SUM(J19:K36)","v":1.0000000000000002}]
[null,"Mitigated Contingency Calculation"]
[null,"Upper Bound =",{"$f":"INDEX(IF($H$7=$C$9,$C$11:$C$15,$F$11:$F$15),MATCH($C$7,$B$11:$B$15,0))/100","v":0.2},null,null,"Example of Applying Percentage Completion of Mitigating Action\n\nContingency Calculator Categories\nContributory Factor: Estimates / costs independently verified\nMitigation Action: Cost build-up independently checked and verified\n\nExample of Using the Calculator:  \n% Completed: 100% \nWhy: A peer review was undertaken on all projects costs (not just construction related costs). Comments from the peer review were incorporated where deemed appropriate. \n"]
[null,"Lower Bound = ",{"$f":"INDEX(IF($H$7=$C$9,$D$11:$D$15,$G$11:$G$15),MATCH($C$7,$B$11:$B$15,0))/100","v":0.1}]
[null,"Difference = ",{"$f":"C39-C40","v":0.1}]
[null,"Mitigation % = ",{"$f":"J37","v":1.0000000000000002}]
[null,"Mitigation Value =",{"$f":"C41*C42","v":0.10000000000000003}]
[null,"Applicable Contingency Percentage",{"$f":"C39-C43","v":9.9999999999999978E-2},null,null,null,null,null,null,null,null,null,null,"Sponsoring Agency note - a contingency allowance should always be used"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"SA note - the % allowance reduces when you select above the phase (in this case - Phase 5 - refer to excel cell C7 above)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"'Standard' project"]
[null,"'Non-standard' project"]