Risk assessment of high-risk industrial operations using Excel software to improve accuracy in decision-making and risk management
Risk assessment of high-risk industrial operations using Excel software to improve accuracy in decision-making and risk management
Ali Rafizadeh1
1) Health, Safety and Health Technology Engineering (HSE)
IOI Code
:
ABGG-ABKBKB
Publication :
11th.International Conference on Researches in Science & Engineering & 8th.International Congress on Civil, Architecture and Urbanism in Asia(11icrsie.ir)
Abstract :
High-risk industrial operations—such as construction, port, and infrastructure activities—face a wide range of safety, health, and environmental hazards that require accurate, accessible, and understandable tools for managers to effectively manage. Traditional risk assessment methods, due to their reliance on manual recording and scattered processing of information, often face limitations in providing rapid, integrated, and auditable analysis. Drawing on the experience of implementing a Microsoft Excel-based risk assessment system in several high-risk industrial and construction projects, this study presents a practical approach to simultaneously implementing Hazard Identification (HAZID), Failure Mode and Effects Analysis (FMEA), Human Error Analysis (HEART), and Event-Consequence Tree Analysis (Bow Tie) in Excel. In this system, standard assessment forms, automatic calculation of risk priority number (RPN), conditional coloring of risk levels, and comparative graphs before and after control measures are made available to decision makers without the need for specialized software or expensive infrastructure. Findings based on real data from several operational and headquarters units show that the use of this system has produced a significant average reduction (about 40 to 60 percent) in the risk number of the units examined after the implementation of control measures. The results of this study show that Excel, despite its simplicity, can act as an effective, low-cost, and scalable platform for increasing the accuracy, transparency, and speed of decision-making in risk and crisis management of high-risk industrial and construction projects.
Keywords : risk assessment crisis management excel hazid fmea bow tie