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

Data Entry Area
Month |  | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00
Injury Frequency Rate | [NAME] (-1) |  |  |  |  |  |  |  |  |  |  |  | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5
 | Total injuries in Airsweb (RIDDOR+LTI+NLTI)
 | Average No. of People  (Amey + Subcons)
 | Lower [NAME] (+1) |  |  |  |  |  |  |  |  |  |  |  | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6
Injury Severity | [NAME] (-1) |  |  |  |  |  |  |  |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
 | Days lost in month due to injuries as reported in Airsweb |  |  |  |  |  |  |  |  |  | 187 | 60 | 104 | 132 | 120 | 186 | 205 | 173 | 159 | 169 | 176 | 179
 | Lower [NAME] (+1) |  |  |  |  |  |  |  |  |  |  |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
VFL by Senior Management Team | Upper Trigger (+1) |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | No. of planned VFL visits by Senior Management Team |  |  |  |  |  |  |  |  |  | 3 | 4 | 6 | 9 | 7 | 9 | 8 | 7 | 9 | 7 | 7 | 10 | 8 | 8
 | No. of actual VFL visits by Senior Management Team |  |  |  |  |  |  |  |  |  | 3 | 4 | 1 | 9 | 7 | 10 | 9 | 5 | 8 | 4 | 4 | 7 | 5 | 8
 | Lower [NAME] (-1) |  |  |  |  |  |  |  |  |  |  |  |  | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 | 0.8
LATE ACTIONS | [NAME] (-1) |  |  |  |  |  |  |  |  |  |  |  | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5
 | Actions due this month in Airsweb (Incidents+NCRs+freestanding)
 | Actions due to be closed this month but were late or are overdue
 | Lower [NAME] (+1) |  |  |  |  |  |  |  |  |  |  |  | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25
INSPECTIONS | Upper Trigger (+1) |  |  |  |  |  |  |  |  |  |  |  | 0.85 | 0.85 | 0.85 | 0.85 | 0.85 | 0.85 | 0.85 | 0.85 | 0.85 | 0.85 | 0.85 | 0.85 | 0.85 | 0.85 | 0.85 | 0.85 | 0.85 | 0.85 | 0.85 | 0.85 | 0.85 | 0.85 | 0.85 | 0.85 | 0.85
 | Inspection Score of all site/office inspections in the month
 | Lower [NAME] (-1) |  |  |  |  |  |  |  |  |  |  |  | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7
AUDIT SCORE | Upper Trigger (+1) |  |  |  |  |  | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1
 | Rating of all audits carried out in the month |  |  |  |  |  |  |  | 4 |  | 2 | 3 | 3 | 2 |  | 3 |  | 3 | 4 | 4 |  | 4 |  | 3
 | Rating of all audits carried out in the month |  |  |  |  |  |  |  |  |  | 2 | 3 |  |  |  | 4 |  | 3 |  |  |  | 4 |  | 3
 | Rating of all audits carried out in the month |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 4 |  |  |  |  |  | 4
 | Rating of all audits carried out in the month |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | 4 |  | 2 |  |  |  |  |  | 4
 | Rating of all audits carried out in the month |  |  |  |  |  |  | 3 |  |  |  | 4 |  |  |  |  | 3 | 3 |  | 3 |  | 3 | 5 | 4
 | Rating of all audits carried out in the month |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  | 2 | 2 | 3
 | Rating of all audits carried out in the month |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  | 3 | 4 | 5
 | Rating of all audits carried out in the month |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 1 | 4
 | Rating of all audits carried out in the month |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  | 5
 | Rating of all audits carried out in the month |  |  |  |  |  |  | 2 |  |  |  |  |  |  | 4 |  |  |  | 4 |  | 5 | 4 | 4 | 4
 | Rating of all audits carried out in the month |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 5 |  |  | 3
 | Rating of all audits carried out in the month |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 4 |  |  | 4
 | Rating of all audits carried out in the month |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 4 |  |  | 2
 | Rating of all audits carried out in the month |  |  |  |  |  |  |  | 4 |  | 4 |  |  |  |  |  | 5 |  |  | 5 |  | 4
 | Rating of all audits carried out in the month |  |  |  |  |  |  |  | 5 |  | 4
 | Rating of all audits carried out in the month |  |  |  |  |  |  |  |  |  | 4 | 4 |  |  |  |  | 4 |  |  |  |  | 4
 | Rating of all audits carried out in the month |  |  |  |  |  |  |  |  |  | 4 | 2 |  |  |  |  | 4 |  |  |  |  | 3
 | Rating of all audits carried out in the month |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  | 3 |  |  |  |  | 4
 | Rating of all audits carried out in the month |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  | 3
 | Rating of all audits carried out in the month |  |  |  |  |  |  |  |  | 2 | 2 |  |  |  |  |  |  |  |  | 3 | 4 |  | 4
 | Rating of all audits carried out in the month |  |  |  |  |  |  |  |  |  | 4
 | Rating of all audits carried out in the month |  |  |  |  |  |  | 4 |  | 4 | 3 | 3 |  |  |  |  | 3 | 3 | 3 |  | 4 | 3
 | Rating of all audits carried out in the month |  |  |  |  |  |  | 4 |  |  | 3 | 3 |  |  |  |  |  | 3 | 4 |  | 3
 | Rating of all audits carried out in the month |  |  |  |  |  |  | 4 |  |  |  | 5 |  |  |  |  |  | 4 | 3
 | Rating of all audits carried out in the month |  |  |  |  |  |  | 4 |  | 4 |  | 4 |  | 5 |  | 4 | 4 | 5 | 4 | 3 | 4 | 3 | 4
 | Rating of all audits carried out in the month |  |  |  |  |  |  |  |  | 4 |  |  |  | 4 |  |  |  |  | 4 | 4 | 2 | 4 | 4
 | Rating of all audits carried out in the month |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  | 4 | 5 |  | 2
 | Rating of all audits carried out in the month |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  | 3
 | Rating of all audits carried out in the month |  |  |  |  |  |  |  | 3 | 2 | 2 | 4 |  |  |  | 1 |  | 3 | 3 |  |  | 2
 | Rating of all audits carried out in the month |  |  |  |  |  |  |  | 3 |  | 2 |  |  |  |  |  |  | 3
 | Rating of all audits carried out in the month |  |  |  |  |  |  |  | 3 |  | 2 |  |  |  |  |  |  | 3
 | Rating of all audits carried out in the month |  |  |  |  |  |  |  | 3 |  | 4 |  |  |  |  |  |  | 1
 | Rating of all audits carried out in the month |  |  |  |  |  |  |  | 3 |  | 4
 | Lower [NAME] (-1) |  |  |  |  | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9