Spreadsheet: 751422d1634107752-get-top-10-items-from-a-list-and-corresponding-item-no-book2
Sheet: Sheet2

 |  |  | Estimated cost of residual risk |  |  |  |  | Top 10
Item No | Cause, trigger or issue | Potential consequences | Minimum $ | Most Likely $ | Maximum $ |  |  | Most Likely Value | Item No | Helper
1 | Rain/ poor weather | Flooding resulting in result in damage and delays to construction | 200000 | 500000 | 1000000
2 | 1:100 flood | Damage to road and properties | 500000 | 1000000 | 2000000
3 | Flooding | Damage to existing properties during construction | 200000 | 600000 | 1000000
4 | Changes in environment due to climate change | Extreme weather events causing damage to road infrastructure property and impacting surrounding environments/habitats and people | 1200000 | 6000000 | 18000000
5 | Lack of planning and coordination | Development may cause road geometry to be changed; land rezoning leading to acquisition delays and additional costs | 500000 | 1000000 | 2000000
6 | Design/ project management failures | Damage to road and properties. Additional cost and time delays. | 500000 | 750000 | 1000000
7 | Lack of design control/review | Increased construction staging, inefficiencies, substantial temporary works, time delays and added costs | 500000 | 2000000 | 4000000
8 | Poor design planning and investigation | Inadequate road alignment design | 250000 | 500000 | 1000000
9 | Design failure | Increased construction staging, inefficiencies, substantial temporary works, time delays and added costs | 2000000 | 6000000 | 10000000
10 | Utility requirement variations | Design changes causing time delays, additional resourcing requirements, additional costs to project budget | 50000 | 100000 | 200000
11 | Utility requirement variations | Significant additional costs and time delays to accommodate changes | 150000 | 300000 | 600000
12 | Construction clashes | Time delays and additional costs | 50000 | 100000 | 200000
13 | Poor design integration with existing utilities | Need for redesign. Constructability implications . Program delays | 250000 | 500000 | 2000000
14 | Non-consideration of design requirements | impacts to construction program and time delays | 250000 | 500000 | 2000000
15 | Lack of  management and enforcement of clearance requirements for design and construction | Very serious damage and danger to workers' and public safety. WHS risk | 10000000 | 20000000 | 50000000
16 | Soil failures/ poor earthwork management and control | Very serious damage and danger to workers and public safety. WHS risk.  Project delays due to need for additional approvals.  Additional costs for mechanical protection works | 10000000 | 20000000 | 50000000
17 | Lack of utility capacity planning for future demand | Inadequate utility capacity for future growth | 50000 | 100000 | 200000
18 | Poor utility planning and investigation | Inadequate utility design does not meet requirements/needs | 50000 | 100000 | 200000
19 | Poor design consideration | Inadequate design of utilities tie-ins.  Serious damage and danger to workers and public safety. WHS risk.  Project delays due to need for additional approvals.  Additional costs for mechanical protection works | 250000 | 500000 | 2000000
20 | Contamination | Project delays due to need for additional approvals. Additional costs | 100000 | 300000 | 1000000
21 | Landfill contamination |  | 50000 | 150000 | 300000
22 | Lack of environmental considerations during construction | Destruction and damage to riparian habitat/ wildlife. Additional remediation costs | 100000 | 25000000 | 35000000
23 | Lack of consideration and control for environmental impacts of construction | Adverse impacts to creek habitat, and wildlife. Resultant fines and legal ramifications. | 100000 | 200000 | 400000
24 | Ignorance, lack of control and enforcement of WHS practices | Injury/harm to workers, public. | 100000 | 200000 | 500000
25 | Unforeseen contamination from petrol station | Leakages contaminating surrounding environment | 100000 | 200000 | 500000
26 | Variety of possible geotechnical failures, pile damage and/or inadequate investigation/classification | Safety risk: injury/ harm to workers. Delays and additional costs | 50000 | 100000 | 200000
27 | Latent geotechnical conditions | Soil failures, unknown compositions and water table levels, soft soils, unexpected finds causing additional costs and time delays | 100000 | 200000 | 500000
28 | Ground water contamination | Contamination of drinking groundwater can cause serious illness and harm to humans and wildlife | 50000 | 100000 | 200000
29 | Need for creek realignment | Design implications. Possible damage to aquatic life and riparian environment | 200000 | 400000 | 800000
30 | Adjacent project works | Timing and project program issues. Public backlash | 600000 | 1000000 | 1500000
31 | Poor design and construction integration | Additional costs and contractor-client disputes | 500000 | 2000000 | 4000000
32 | Changing land classification and zoning | Time delays and increased costs of property acquisition | 10000000 | 25000000 | 50000000
33 | Design complexities | Construction difficulties | 300000 | 600000 | 1200000