Health and Safety Gap Analysis Tool

Do you need a gap analysis tool to review and analyze the current state of your health and safety management system against the standard criteria in order to implement improvement actions needed to establish an adequate management system?

The Health and Safety Gap Analysis Tool is a turnkey template with precise gap analysis questions on the relevant standard criteria to identify gaps in a current Health and Safety Management System with a great graphical representation of the gap analysis result.

The tool is made up of;

The Gap Analysis Scoring Criteria outlines the scoring criteria and definitions for yes, no, partial, and not applicable responses, where yes or partial indicates that the standard requirement has been fully or partially implemented and/or can be verified by available documented information or an established process, and no or not applicable indicates otherwise.

The Gap Analysis Checklist is a series of health and safety questions with emphasis on occupational health populated in the form of a checklist to address the requirements of an advanced health and safety management system, such as policy and organization, health and safety training, risk assessment, monitoring, work equipment, accident reporting, fire and emergency, contractor control, site inspection, occupational health, and claim defensibility.

The Gap Analysis Summary is a summary of the standard requirements, gap analysis findings, and the respective scores and gaps, which automatically populates from validated reference numbers. This sheet is protected and locked as it is built with sensitive Excel formulas to automate the population of the report. There is no need for users to tamper with this sheet due to the automation.

The Improvement Action Plan is the sheet for logging all no and partial responses to respective gap analysis questions with their root causes, actions needed, action status, and action plan. This sheet automatically populates the negative responses as users complete the gap analysis. The sheet has a slicer for filtering out the blanks, columns for assigning a responsible person to close the action, and action priority and action deadlines to automatically estimate days due or overdue. It is also conditionally formatted with color codes for action priority, action open or closed, and days due or overdue.

The Dashboard is dynamic and beautifully made of clattered column chart to represent the various scores and gaps for each section of the management system and a stacked column chart representing the extent of conformity with the standard, with two progress charts representing the overall level of implementation and gaps

The Health and Safety Implementation sheet shows the main sections of the standard criteria and an organization’s levels of implementation to provide an overview of how an organization has implemented the main clauses of the standard.

The Scores and Gaps are presented in unique counts on a table to give an overview of the findings of the scores and gaps for all the requirements of the standard

The Gap Analysis Findings give the sum of yes and no responses in the graphical representation to give an overview of the current state of the management system.

The Sub-section % Implementation gives a more detailed summary of all the sub-sections and their levels of implementation to give an overview of an organization’s current state of management system.

This is a Microsoft Excel file, hence no installation is required, and can run on both Windows and Mac with Microsoft Excel 2013 (+ Later Versions)