Spreadsheet: 131826d1323348067-recording-macros-over-serveral-workbooks-worksheet-1
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) | 5 | 1 | 2 | 0 | 4 | 2 | 3 | 6 | 5 | 0 | 3 | 3 | 1 | 3 | 6 | 0 | 2 | 1 | 1 | 2 | 2 | 0 | 2
 | Average No. of People  (Amey + Subcons) | 379 | 384 | 366 | 359 | 345 | 347 | 308 | 302 | 298 | 288 | 298 | 287 | 289 | 263 | 247 | 223 | 262 | 258 | 294 | 260 | 254 | 240 | 257
 | 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 |  |  |  |  |  | 0 | 24 | 55 | 74 | 50 | 0 | 0 | 0 | 7 | 16 | 0 | 0 | 0 | 0 | 0 | 34 | 12 | 0
 | 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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 6 | 9 | 17 | 0 | 1
 | No. of actual VFL visits by Senior Management Team |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | 6 | 9 | 18 | 0 | 1
 | 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) | 4 | 6 | 14 | 4 | 2 | 3 | 9 | 7 | 9 | 9 | 7 | 2 | 4 | 14 | 13 | 8 | 3 | 2 | 3 | 4 | 8 | 1 | 2
 | Actions due to be closed this month but were late or are overdue | 1 | 2 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | 0 | 1 | 0 | 4 | 5 | 0 | 0
 | 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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 86 | 87 | 89 | 84 | 86 | 78
 | 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
 | Rating of all audits carried out in the month |  |  |  |  |  |  | 2 |  |  |  |  |  |  | 4 |  |  |  | 4 |  | 5 | 4 | 4
 | Rating of all audits carried out in the month |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 5
 | Rating of all audits carried out in the month |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 4
 | 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