Spreadsheet: 107236d1304445509-need-to-create-report-from-sheet-test-admin-field-time-2011
Sheet: Dave M. X

[NAME]
Field Time Calculator |  |  |  | "Every Person Going Home Safe and [NAME]" |  |  |  |  |  |  |  |  |  |  |  | "Coaching Contacts"
 | 2011 |  |  |  |  |  |  |  |  |  |  |  | YTD 2011 |  |  | 2011
 | Jan | Feb | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec | Avg |  |  | Jan | Feb | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec
1 |  | 2 | 3 |  |  | Vacation |  |  |  |  |  |  |  |  | 1 |  | 1 | 2
2 |  | 0.5 | 4 |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 1 | 1
3 | 3 | 6 | 1.5 |  |  |  |  |  |  |  |  |  |  |  | 3 | 1 | 1 | 1
4 | 3.5 |  |  | 4 |  |  |  |  |  |  |  |  |  |  | 4 | 1 |  |  | 1 |  |  | Holiday
5 | 1.5 |  |  | 2 |  |  |  |  | Holiday |  |  |  |  |  | 5 |  |  |  | 1 |  |  |  |  | Holiday
6 | 3 |  |  | 3.5 |  |  |  |  |  |  |  |  |  |  | 6 | 1 |  |  | 1
7 |  | 6.5 | 4.5 | 2 |  |  |  |  |  |  |  |  |  |  | 7 |  | 3 | 2 | 1
8 |  | 4 | 1 |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 1
9 |  | 5.5 | 7 |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 1 | 1
10 | 4 | 5 | 4 |  |  |  |  |  |  |  |  |  |  |  | 10 | 2 | 1
11 | 3 | 9 |  | 4 |  |  |  |  |  |  |  |  |  |  | 11 | 1 | 1
12 | 3 |  |  | 4.5 |  |  |  |  |  |  |  |  |  |  | 12 | 1 |  |  | 1
13 | 3.5 |  |  | 3.5 |  |  |  |  |  |  |  |  |  |  | 13 | 1
14 |  | 1.5 | 4.5 | 5.5 |  |  |  |  |  |  |  |  |  |  | 14
15 |  | 6 | 4 |  |  |  |  |  |  |  |  |  |  |  | 15
16 |  | 4.5 | 0.5 |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 1
17 | 4.5 | 1.5 | 8 |  |  |  |  |  |  |  |  |  |  |  | 17 | 1 | 2 | 1
18 | 5 |  |  | 4.5 |  |  |  |  |  |  |  |  |  |  | 18 | 1 |  |  | 1
19 | 5 |  |  | 2 |  |  |  |  | Vacation |  |  |  |  |  | 19 | 1
20 | 2 |  |  | 1.5 |  |  |  |  | Vacation |  |  |  |  |  | 20 | 1 |  |  | 1
21 |  | Holiday | 3 | 1 |  |  |  |  | Vacation |  | Vacation |  |  |  | 21 |  | Holiday | 1 | 1 |  |  |  |  |  |  | Vacation
22 |  | Vacation | 0.5 |  |  |  |  |  | Vacation |  | Vacation | Holiday |  |  | 22 |  | Vacation |  |  |  |  |  |  |  |  | Vacation | Holiday
23 |  | Vacation | Off-Site |  |  |  |  |  |  |  | Holiday |  |  |  | 23 |  | Vacation |  |  |  |  |  |  |  |  | Holiday
24 | 3.5 | Vacation | Off-Site |  |  |  |  |  |  | Vacation | Holiday |  |  |  | 24 | 1 | Vacation |  |  |  |  |  |  |  | Vacation | Holiday
25 | 6 |  |  | Vacation |  |  |  |  |  | Vacation |  |  |  |  | 25 |  |  |  |  | Vacation |  |  |  |  | Vacation
26 | 3.5 |  |  | 3.5 | Vacation |  |  |  |  | Vacation |  | Holiday |  |  | 26 |  |  |  |  | Vacation |  |  |  |  | Vacation |  | Holiday
27 | Holiday |  |  | 3.5 |  | Vacation |  |  |  | Vacation |  | Vacation |  |  | 27 | Holiday |  |  |  |  |  |  |  |  | Vacation |  | Vacation
28 |  | 3 | 3.5 | 3 |  | Holiday |  |  |  |  |  | Vacation |  |  | 28 |  |  | 1 | 2 |  |  |  |  |  |  |  | Vacation
29 |  | N/A | 3.5 |  |  |  |  |  |  |  |  | Vacation |  |  | 29 |  | N/A | 1 |  |  |  |  |  |  |  |  | Vacation
30 |  | N/A | 5 |  | Holiday |  |  |  |  |  |  |  |  |  | 30 |  | N/A | 1 |  | Holiday
31 | 1.5 | N/A | 0 | N/A | Vacation | N/A |  |  | N/A |  | N/A |  |  |  | 31 | 1 | N/A |  | N/A |  | N/A |  |  | N/A |  | N/A
Count | 16 | 13 | 17 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | Count | 14 | 13 | 12 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 49
Field Hrs | 55.5 | 55 | 57.5 | 48 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 216 | FLRA Coaching |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
Total Hrs | 160 | 130 | 170 | 150 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 610 |  | FLRA var. | -9 | -8 | -7 | -5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
Percent | 0.346875 | 0.4230769230769231 | 0.3382352941176471 | 0.32 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 0.3540983606557377
Days on Site with field time = 2
Days on Site W/O field time=NT
H=Holidays
V=Vacation
O=Off Site
S=Sick/Personal
Attended EH&S mtgs
Schd/Missed EH&S mtgs