Spreadsheet: 539810d1506374360-pulling-daily-averages-help-pulling-daily-averages-help-ot-tracking-sheet-example
Sheet: Tracking Sheet

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 $
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Weekly Totals
 | 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]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME] |  |  |  |  |  |  | 6.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Hardeman, [NAME] |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME] |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Price, [NAME] |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Hickman, Laquisha |  |  |  |  |  |  | 4
 | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $ |  |  |  |  |  | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $
 | Weekly Totals
 | 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], [NAME] |  |  |  |  |  |  | 8
 | Price, [NAME] |  |  |  |  |  |  | 6.3
 | [NAME], [NAME] |  |  |  |  |  |  | 4.5
 | Burt, [NAME] |  |  |  |  |  |  | 4.5
 | 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
 | Hickman, Laquisha |  |  |  |  |  |  | 8
 | Sierra, [NAME] |  |  |  |  |  |  | 8
 | [NAME], [NAME] |  |  |  |  |  |  | 4
 | [NAME], [NAME] |  |  |  |  |  |  | 1
 | 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
 | Petton, Elvira |  |  |  |  |  |  | 7
 | Herrera, Nathan |  |  |  |  |  |  | 7
 | Hickman, Laquisha |  |  |  |  |  |  | 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
 | Price, [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
 | 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
 | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $ |  |  |  |  |  | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Weekly Totals
 | 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] |  |  |  |  |  |  | 6.5
 | Sierra, [NAME] |  |  |  |  |  |  | 8
 | [NAME], [NAME] |  |  |  |  |  |  | 4
 | Guillory, [NAME] |  |  |  |  |  |  | 1
 | [NAME], Tenetrice |  |  |  |  |  |  | 1
 | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $ |  |  |  |  |  | Total # People Worked |  |  |  | Total OT Hours |  |  | Total OT $
 | Weekly Totals
 | 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
 | 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