Spreadsheet: 107236d1304445509-need-to-create-report-from-sheet-test-admin-field-time-2011
Sheet: Josh S. 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.5 |  |  |  |  |  |  |  |  |  |  |  | 1
2 |  | 2 | 1 |  | RH |  |  |  |  |  |  |  |  |  | 2
3 |  | Interviews | Interviews |  | RH |  |  |  |  |  |  |  |  |  | 3
4 |  |  |  | 2 | RH |  | Holiday |  |  |  |  |  |  |  | 4 |  |  |  | 2 |  |  | Holiday
5 |  |  |  | 4 | RH |  |  |  | Holiday |  |  |  |  |  | 5 |  |  |  | 7 |  |  |  |  | Holiday
6 |  |  |  | Vac |  |  |  |  |  |  |  |  |  |  | 6
7 |  | 2 | 1 | Vac |  |  |  |  |  |  |  |  |  |  | 7 |  | 1
8 |  | 1.5 | 3 |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  | 5
9 |  | 4 | 2 |  |  |  |  |  |  |  |  |  |  |  | 9
10 |  | Interviews | Interviews |  | CLT-Elko |  |  |  |  |  |  |  |  |  | 10
11 |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  | 11
12 |  |  |  | CLT-Elko |  |  |  |  |  |  |  |  |  |  | 12 |  |  |  | XX - CLT
13 |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  | 13
14 |  | 3 | 3.5 | Interviews |  |  |  |  |  |  |  |  |  |  | 14 |  | 2 | 1
15 |  | 3 | 1.5 |  |  |  |  |  |  |  |  |  |  |  | 15 |  |  | 1
16 |  | 4 | 3 |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 2 | 2
17 |  | Interviews | Interviews |  |  |  |  |  |  |  |  |  |  |  | 17 | 1
18 |  |  |  | 2 | CLT-Elko |  |  |  |  |  |  |  |  |  | 18
19 |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  | 19
20 |  |  |  | CLT-Elko |  |  |  |  |  |  |  |  |  |  | 20 |  |  |  | XX - CLT
21 |  | Holiday | 2 | 5 |  |  |  |  |  |  |  |  |  |  | 21 |  | Holiday
22 |  | 2.5 | Recruiting |  |  |  |  |  |  |  |  | Holiday |  |  | 22 |  |  |  |  |  |  |  |  |  |  |  | Holiday
23 |  | ART | Recruiting |  |  |  |  |  |  |  | Holiday |  |  |  | 23 |  |  |  |  |  |  |  |  |  |  | Holiday
24 | 2 | Interviews | Recruiting |  |  |  |  |  |  |  | Holiday |  |  |  | 24 |  |  |  |  |  |  |  |  |  |  | Holiday
25 | 1 |  |  | 4.5 |  |  |  |  |  |  |  |  |  |  | 25
26 |  |  |  | RH |  |  |  |  |  |  |  | Holiday |  |  | 26 |  |  |  |  |  |  |  |  |  |  |  | Holiday
27 | Interviews |  |  | 3 |  |  |  |  |  |  |  |  |  |  | 27 |  |  |  |  |  |  |  |  |  |  |  | Vacation
28 |  | 4 | 1 | 4 |  |  |  |  |  |  |  |  |  |  | 28 |  | 2 | 1 |  |  |  |  |  |  |  |  | Vacation
29 |  | N/A | Interviews |  |  |  |  |  |  |  |  |  |  |  | 29 |  | N/A |  |  |  |  |  |  |  |  |  | Vacation
30 |  | N/A | 6 |  | Holiday |  |  |  |  |  |  |  |  |  | 30 |  | N/A | 5 |  | Holiday
31 | 2 | N/A | Interviews | N/A |  | N/A |  |  | N/A |  | N/A |  |  |  | 31 | 1 | N/A |  | N/A |  | N/A |  |  | N/A |  | N/A
Count | 3 | 9 | 11 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | Count | 2 | 7 | 15 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 33
Field Hrs | 5 | 26 | 26.5 | 33.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 91 | FLRA Coaching |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
Total Hrs | 30 | 90 | 110 | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 330 |  | FLRA var. | 3 | -2 | -10 | -4 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
Percent | 0.1666666666666667 | 0.2888888888888889 | 0.2409090909090909 | 0.335 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 0.2757575757575758
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