Spreadsheet: 131825d1323348057-recording-macros-over-serveral-workbooks-overall-results
Sheet: User Instructions

Header |  | Step | [NAME] | Row | Action | When
1 | Set Triggers for Lagging and Leading Indicators | 1.1 | Data | 3, 6 | Review and if required adjust upper and lower trigger values for Injury Frequency Rate | Annually or following a mid-year review
 |  | 1.2 | Data | 7, 9 | Review and if required adjust upper and lower trigger value for Injury Severity Rate
 |  | 1.3 | Data | 10, 13 | Review and if required adjust upper and lower trigger value for VFL Planned versus Actual
 |  | 1.4 | Data | 14, 17 | Review and if required adjust upper and lower trigger value for Late Actions %
 |  | 1.5 | Data | 18, 20 | Review and if required adjust upper and lower trigger value for Average Inspection Score %
 |  | 1.6 | Data | 21,23 | Review and if required adjust upper and lower trigger value for Average Audit Score
2 | Input Performance Data | 2.1 | Data | 4, 5 | Manually enter monthly values for total injuries reported in Airsweb and the headcount | Monthly
 |  | 2.2 | Data | 8 | Manually enter the number of days lost in the month due to accidents, as shown in Airsweb
 |  | 2.3 | Data | 11, 12 | Manually enter monthly values for planned and actual VFL visits by the management team
 |  | 2.4 | Data | 15, 16 | Manually enter monthly values for actions raised this month in Airsweb (incident + audit + freestanding) plus the number that were planned to be completed this month but were late or are overdue
 |  | 2.5 | Data | 19 | Manually enter monthly value for average inspection score
 |  | 2.6 | Data | 22 | Manually enter monthly value for average audit score
3 | Force a recalculation | 2.7 | Data | 27-60 | Highlight the last month with formulae, and drag sideways to replicate formulae to current month | Monthly
4 | Run the Report | 2.8 | Report | 95 | If this is a Work stream or Division level scorecard, it will automatically update and insert the score from subsidiary scorecards. | Auto
The Indicators |  | Explanation and Metrics |  |  |  | Data Source
Injury Frequency Rate |  | This lagging indicator looks at the number of times people are injured at work.  It measures the trend over the last 12 months to see if performance getting better.  It counts all injuries (RIDDOR, lost time and no lost time) that have been entered into Airsweb in the last 12 months and divides this by the average headcount ([NAME] + subcontractors) to give the frequency that people have been injured.  The calculation is adjusted to give the % of people that have been injured in the last 12 months. Calculation is:  Total injuries in last 12 months x 100 / Average headcount |  |  |  | [NAME]
Injury Severity |  | This lagging indicator looks at the severity of the injuries that have occurred, i.e. the average number of days are people off work following an injury.  It measures the trend over the last 12 months to see if the injuries are becoming less severe.  It takes all the calendar days lost (start of sick leave to return to work dates entered in Airsweb) and divides by the number of injuries. Calculation is:  Total number of calendar days off work in last 12 months / Total number of injuries |  |  |  | [NAME]
VFL by Senior Management Team |  | This leading indicator measures the proactive input from the management team by way of VFL visits.  The visible leadership raises awareness of potential hazards (to the workforce and to the manager) and helps create an interdependent culture.  It measure % compliance with the pre-determined VFL Visit programme for a calendar year. Calculation is: Number of visits planned year to date / Number completed. |  |  |  | Airsweb audit module
LATE ACTIONS |  | This leading indicator whether we complete actions by their planned date, both resolve a current problem and to prevent an similar event in the future.  The key element is the preventive actions taken - the sooner we complete them, the sooner we improve and reduce future risk.  It measure the trend over the last 12 months.  The measure looks at actions following incidents, audits and any free-standing actions that need to be resolved Calculation is:  No. of actions not closed by planned date in the last 12 months / Total number of actions |  |  |  | [NAME] action tracking module
INSPECTIONS |  | Inspections identify issues before an incident occurs and also act as an education for the future.  This leading indicator measure the average score given at the safety inspections during the last 3 months.  The arithmetic average has to be calculated locally each month and entered as a whole number.  i.e 76% is entered as 76. Calculation is: Average score over last 3 months (expressed as %) |  |  |  | Local inspection reports
AUDIT SCORE |  | Audits can identify issues before an an incident occurs and also act as an education for the future.  This leading indicator measures the average audit score (on a scale of 1 to 5) given during the last 12 months.  The arithmetic average of internal audit scores has to be calculated locally each month, if there have been no audits then a score of 0 is entered. Calculation is: Average score over last 12 months |  |  |  | Airsweb audit module