Spreadsheet: 540160d1506553211-pulling-daily-averages-help-3rd-watch-calltake-ot-tracking-sheet-working-sept-2017-
Sheet: Sept 17

3rd Watch Overtime For |  |  |  |  |  |  |  |  |  |  |  | 2017-09-01 00:00:00
2017-09-01 00:00:00
 | Name: |  |  | Type | Hour Rate | Half | OT Rate | # Hours | Total | Location | Reason |  |  | Name: |  |  | Type | Hour Rate | Half | OT Rate | # Hours | Total | Location | Reason
 | Hickman, Laquisha |  |  |  |  |  |  | 4 |  |  |  |  |  | [NAME], [NAME] |  |  |  |  |  |  | 7
 | [NAME], [NAME] |  |  |  |  |  |  | 4 |  |  |  |  |  | Burt, [NAME] |  |  |  |  |  |  | 7.5
 | Petton, Elvira |  |  |  |  |  |  | 4 |  |  |  |  |  | Harland, [NAME] |  |  |  |  |  |  | 4
 | Herrera, Nathan |  |  |  |  |  |  | 4 |  |  |  |  |  | Camacho, [NAME] |  |  |  |  |  |  | 4
 | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $ |  |  |  |  |  | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $
 | Name: |  |  | Type | Hour Rate | Half | OT Rate | # Hours | Total | Location | Reason |  |  | Name: |  |  | Type | Hour Rate | Half | OT Rate | # Hours | Total | Location | Reason
 | [NAME], [NAME] |  |  |  |  |  |  | 6 |  |  |  |  |  | [NAME], [NAME] |  |  |  |  |  |  | 4
 | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $ |  |  |  |  |  | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $
 | Name: |  |  | Type | Hour Rate | Half | OT Rate | # Hours | Total | Location | Reason |  |  | Name: |  |  | Type | Hour Rate | Half | OT Rate | # Hours | Total | Location | Reason
 | Sierra, [NAME] |  |  |  |  |  |  | 8
 | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $ |  |  |  |  |  | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $
 | Name: |  |  | Type | Hour Rate | Half | OT Rate | # Hours | Total | Location | Reason |  |  | Name: |  |  | Type | Hour Rate | Half | OT Rate | # Hours | Total | Location | Reason
 | Sierra, [NAME] |  |  |  |  |  |  | 8 |  |  |  |  |  | Sierra, [NAME] |  |  |  |  |  |  | 8
 | Bargy, [NAME] |  |  |  |  |  |  | 8
 | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $ |  |  |  |  |  | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $
 | Name: |  |  | Type | Hour Rate | Half | OT Rate | # Hours | Total | Location | Reason |  |  | Name: |  |  | Type | Hour Rate | Half | OT Rate | # Hours | Total | Location | Reason
 | [NAME], [NAME] |  |  |  |  |  |  | 5 |  |  |  |  |  | Rucker, [NAME] |  |  |  |  |  |  | 4
 | Espinoza, Llarghem |  |  |  |  |  |  | 1.5 |  |  |  |  |  | Sierra, [NAME] |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Burt, [NAME] |  |  |  |  |  |  | 7.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Gardner, [NAME] |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME] |  |  |  |  |  |  | 6.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Hardeman, [NAME] |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME] |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Price, [NAME] |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Hickman, Laquisha |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME] |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Guillory, [NAME] |  |  |  |  |  |  | 1
 | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $ |  |  |  |  |  | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $
 | Name: |  |  | Type | Hour Rate | Half | OT Rate | # Hours | Total | Location | Reason |  |  | Name: |  |  | Type | Hour Rate | Half | OT Rate | # Hours | Total | Location | Reason
 | Sierra, [NAME] |  |  |  |  |  |  | 8 |  |  |  |  |  | Rucker, [NAME] |  |  |  |  |  |  | 4
 | Price, [NAME] |  |  |  |  |  |  | 6.3 |  |  |  |  |  | [NAME], Tenetrice |  |  |  |  |  |  | 8
 | [NAME], [NAME] |  |  |  |  |  |  | 4.5 |  |  |  |  |  | Sierra, [NAME] |  |  |  |  |  |  | 8
 | Burt, [NAME] |  |  |  |  |  |  | 4.5 |  |  |  |  |  | Hickman, Laquisha |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Harn, [NAME] |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME] |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME] |  |  |  |  |  |  | 1
 | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $ |  |  |  |  |  | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $
 | Name: |  |  | Type | Hour Rate | Half | OT Rate | # Hours | Total | Location | Reason |  |  | Name: |  |  | Type | Hour Rate | Half | OT Rate | # Hours | Total | Location | Reason
 | Rucker, [NAME] |  |  |  |  |  |  | 4 |  |  |  |  |  | Rucker, [NAME] |  |  |  |  |  |  | 4
 | Hickman, Laquisha |  |  |  |  |  |  | 8 |  |  |  |  |  | [NAME], [NAME] |  |  |  |  |  |  | 7
 | Sierra, [NAME] |  |  |  |  |  |  | 8 |  |  |  |  |  | Price, [NAME] |  |  |  |  |  |  | 3.8
 | [NAME], [NAME] |  |  |  |  |  |  | 4 |  |  |  |  |  | Burt, [NAME] |  |  |  |  |  |  | 4.3
 | [NAME], [NAME] |  |  |  |  |  |  | 1 |  |  |  |  |  | Espinoza, Llarghem |  |  |  |  |  |  | 4
 | Guillory, [NAME] |  |  |  |  |  |  | 1
 | [NAME], [NAME] |  |  |  |  |  |  | 1
 | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $ |  |  |  |  |  | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $
 | Name: |  |  | Type | Hour Rate | Half | OT Rate | # Hours | Total | Location | Reason |  |  | Name: |  |  | Type | Hour Rate | Half | OT Rate | # Hours | Total | Location | Reason
 | Rucker, [NAME] |  |  |  |  |  |  | 4 |  |  |  |  |  | [NAME], [NAME] |  |  |  |  |  |  | 7
 | Petton, Elvira |  |  |  |  |  |  | 7 |  |  |  |  |  | Sierra, [NAME] |  |  |  |  |  |  | 8
 | Herrera, Nathan |  |  |  |  |  |  | 7 |  |  |  |  |  | Hickman, Laquisha |  |  |  |  |  |  | 8
 | Hickman, Laquisha |  |  |  |  |  |  | 4 |  |  |  |  |  | Petton, Elvira |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME] |  |  |  |  |  |  | 4
 | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $ |  |  |  |  |  | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $
 | Name: |  |  | Type | Hour Rate | Half | OT Rate | # Hours | Total | Location | Reason |  |  | Name: |  |  | Type | Hour Rate | Half | OT Rate | # Hours | Total | Location | Reason
 | Sierra, [NAME] |  |  |  |  |  |  | 8 |  |  |  |  |  | Elias, [NAME] |  |  |  |  |  |  | 8
 | Price, [NAME] |  |  |  |  |  |  | 8 |  |  |  |  |  | [NAME], [NAME] |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME] |  |  |  |  |  |  | 5.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Camacho, [NAME] |  |  |  |  |  |  | 6
 | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $ |  |  |  |  |  | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $
 | Name: |  |  | Type | Hour Rate | Half | OT Rate | # Hours | Total | Location | Reason |  |  | Name: |  |  | Type | Hour Rate | Half | OT Rate | # Hours | Total | Location | Reason
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sierra, [NAME] |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], Christine |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Bargy, [NAME] |  |  |  |  |  |  | 8
 | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $ |  |  |  |  |  | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $
 | Name: |  |  | Type | Hour Rate | Half | OT Rate | # Hours | Total | Location | Reason |  |  | Name: |  |  | Type | Hour Rate | Half | OT Rate | # Hours | Total | Location | Reason
 | [NAME], [NAME] |  |  |  |  |  |  | 4 |  |  |  |  |  | Sierra, [NAME] |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Salas, [NAME] |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME] |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Bargy, [NAME] |  |  |  |  |  |  | 4.2
 | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $ |  |  |  |  |  | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $
 | Name: |  |  | Type | Hour Rate | Half | OT Rate | # Hours | Total | Location | Reason |  |  | Name: |  |  | Type | Hour Rate | Half | OT Rate | # Hours | Total | Location | Reason
 | Rucker, [NAME] |  |  |  |  |  |  | 4 |  |  |  |  |  | Rucker, [NAME] |  |  |  |  |  |  | 4
 | [NAME], [NAME] |  |  |  |  |  |  | 6.5 |  |  |  |  |  | Sierra, [NAME] |  |  |  |  |  |  | 8
 | Sierra, [NAME] |  |  |  |  |  |  | 8 |  |  |  |  |  | Salas, [NAME] |  |  |  |  |  |  | 8
 | [NAME], [NAME] |  |  |  |  |  |  | 4 |  |  |  |  |  | [NAME], [NAME] |  |  |  |  |  |  | 2
 | Guillory, [NAME] |  |  |  |  |  |  | 1
 | [NAME], Tenetrice |  |  |  |  |  |  | 1
 | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $ |  |  |  |  |  | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $
 | Name: |  |  | Type | Hour Rate | Half | OT Rate | # Hours | Total | Location | Reason |  |  | Name: |  |  | Type | Hour Rate | Half | OT Rate | # Hours | Total | Location | Reason
 | Rucker, [NAME] |  |  |  |  |  |  | 4
 | Sierra, [NAME] |  |  |  |  |  |  | 8
 | Cox-gutierrez, [NAME] |  |  |  |  |  |  | 8
 | Petton, Elvira |  |  |  |  |  |  | 4
 | Bailey, [NAME] |  |  |  |  |  |  | 2
 | McWhirter, Amanda |  |  |  |  |  |  | 5
 | [NAME], [NAME] |  |  |  |  |  |  | 2
 | Price, [NAME] |  |  |  |  |  |  | 7
 | Camacho, [NAME] |  |  |  |  |  |  | 7.5
 | [NAME], [NAME] |  |  |  |  |  |  | 4
 | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $ |  |  |  |  |  | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $
 | Name: |  |  | Type | Hour Rate | Half | OT Rate | # Hours | Total | Location | Reason |  |  | Name: |  |  | Type | Hour Rate | Half | OT Rate | # Hours | Total | Location | Reason
 | Sierra, [NAME] |  |  |  |  |  |  | 8
 | [NAME], Tenetrice |  |  |  |  |  |  | 4
 | [NAME], [NAME] |  |  |  |  |  |  | 7
 | Cordray, [NAME] |  |  |  |  |  |  | 8
 | [NAME], [NAME] |  |  |  |  |  |  | 2
 | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $ |  |  |  |  |  | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $
 | Name: |  |  | Type | Hour Rate | Half | OT Rate | # Hours | Total | Location | Reason |  |  | Name: |  |  | Type | Hour Rate | Half | OT Rate | # Hours | Total | Location | Reason
 | Harland, [NAME] |  |  |  |  |  |  | 2
 | Cordray, [NAME] |  |  |  |  |  |  | 4
 | Espinoza, Llarghem |  |  |  |  |  |  | 2
 | [NAME], [NAME] |  |  |  |  |  |  | 1.5
 | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $ |  |  |  |  |  | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly Totals