Spreadsheet: 131827d1323348078-recording-macros-over-serveral-workbooks-worksheet-2
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) | 3 | 2 | 4 | 4 | 1 | 3 | 5 | 5 | 4 | 2 | 9 | 5 | 6 | 2 | 7 | 4 | 4 | 3 | 4 | 3 | 2 | 4 | 7
 | Average No. of People  (Amey + Subcons) | 1168 | 1332 | 1188 | 1215 | 1072 | 1039 | 998 | 670 | 1150 | 1150 | 1150 | 1478 | 1101 | 767 | 778 | 810 | 1025 | 1025 | 1238 | 1193 | 1301 | 1424 | 1425
 | 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 | 14 | 24 | 2 | 3 | 0 | 0 | 0 | 2 | 30 | 60 | 44 | 52 | 61 | 63 | 101 | 103 | 47 | 82 | 21 | 25 | 52 | 25 | 49
 | 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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 6 | 6 | 9 | 6 | 6
 | No. of actual VFL visits by Senior Management Team |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 10 | 8 | 6 | 7 | 6
 | 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) | 6 | 7 | 2 | 0 | 1 | 1 | 0 | 0 | 0 | 6 | 19 | 46 | 4 | 9 | 12 | 11 | 3 | 11 | 11 | 14 | 1 | 0 | 1
 | Actions due to be closed this month but were late or are overdue | 6 | 5 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 11 | 44 | 3 | 8 | 11 | 9 | 2 | 5 | 10 | 11 | 1 | 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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 74 | 83 | 72 | 88 | 86 | 89
 | 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 |  |  |  |  |  |  |  | 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
 | 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