Spreadsheet: 55403d1255526392-drop-down-boxes-main
Sheet: Mon

week1
Date | CORE TASKS |  |  |  |  |  | NON CORE TASKS |  |  |  |  |  | Consolidated MI
2009-10-19 00:00:00 | Secondary Investigation |  |  |  |  |  | AYIC | Administration and Development
Investigator | Absence | Volume/Time | Inwards | Outwards | Mail Box | Queries | Reg Reading/Viewing | Training / Coaching | Team Meetings | PEF / 1to1 | Workouts | Other | Total Time / Alerts Core Tasks | Total Time Non Core Tasks | Total Hours Day | Overtime | % Non Core Time
Bijal Dosani | Holiday | Alerts handled | 10 | 10 | 10 | 2 |  |  |  |  |  |  | 32
 |  | Time      Spent | 30 | 90 | 25 | 55 | 15 | 15 | 15 | 15 | 30 | 120 | 3.333333333333333 | 3.5 | 6.833333333333334 | -0.1666666666666661 | 51.21951219512194
[NAME] |  | Alerts handled | 10 | 15 | 20 | 25 |  |  |  |  |  |  | 70
 |  | Time      Spent | 60 | 30 | 60 | 60 | 15 | 15 | 15 | 15 | 30 | 120 | 3.5 | 3.5 | 7 | 0 | 50
[NAME] |  | Alerts handled | 10 | 15 | 20 | 25 |  |  |  |  |  |  | 70
 |  | Time      Spent | 60 | 30 | 60 | 60 | 15 | 15 | 15 | 15 | 30 | 120 | 3.5 | 3.5 | 7 | 0 | 50
[NAME] |  | Alerts handled | 10 | 15 | 20 | 25 |  |  |  |  |  |  | 70
 |  | Time      Spent | 60 | 30 | 60 | 60 | 15 | 15 | 15 | 15 | 30 | 120 | 3.5 | 3.5 | 7 | 0 | 50
[NAME] |  | Alerts handled | 10 | 15 | 20 | 25 |  |  |  |  |  |  | 70
 |  | Time      Spent | 60 | 30 | 60 | 60 | 15 | 15 | 15 | 15 | 30 | 120 | 3.5 | 3.5 | 7 | 0 | 50
Claudia Parisi |  | Alerts handled | 10 | 15 | 20 | 25 |  |  |  |  |  |  | 70
 |  | Time      Spent | 60 | 30 | 60 | 60 | 15 | 15 | 15 | 15 | 30 | 120 | 3.5 | 3.5 | 7 | 0 | 50
[NAME] |  | Alerts handled | 10 | 15 | 20 | 25 |  |  |  |  |  |  | 70
 |  | Time      Spent | 60 | 30 | 60 | 60 | 15 | 15 | 15 | 15 | 30 | 120 | 3.5 | 3.5 | 7 | 0 | 50
[NAME] |  | Alerts handled | 10 | 15 | 20 | 25 |  |  |  |  |  |  | 70
 |  | Time      Spent | 60 | 30 | 60 | 60 | 15 | 15 | 15 | 15 | 30 | 120 | 3.5 | 3.5 | 7 | 0 | 50
[NAME] |  | Alerts handled | 10 | 15 | 20 | 25 |  |  |  |  |  |  | 70
 |  | Time      Spent | 60 | 30 | 60 | 60 | 15 | 15 | 15 | 15 | 30 | 120 | 3.5 | 3.5 | 7 | 0 | 50
[NAME] |  | Alerts handled | 10 | 15 | 20 | 25 |  |  |  |  |  |  | 70
 |  | Time      Spent | 60 | 30 | 60 | 60 | 15 | 15 | 15 | 15 | 30 | 120 | 3.5 | 3.5 | 7 | 0 | 50
[NAME] |  | Alerts handled | 10 | 15 | 20 | 25 |  |  |  |  |  |  | 70
 |  | Time      Spent | 60 | 30 | 60 | 60 | 15 | 15 | 15 | 15 | 30 | 120 | 3.5 | 3.5 | 7 | 0 | 50
[NAME] |  | Alerts handled | 10 | 15 | 20 | 25 |  |  |  |  |  |  | 70
 |  | Time      Spent | 60 | 30 | 60 | 60 | 15 | 15 | 15 | 15 | 30 | 120 | 3.5 | 3.5 | 7 | 0 | 50
[NAME] |  | Alerts handled | 10 | 15 | 20 | 25 |  |  |  |  |  |  | 70
 |  | Time      Spent | 60 | 30 | 60 | 60 | 15 | 15 | 15 | 15 | 30 | 120 | 3.5 | 3.5 | 7 | 0 | 50
[NAME] |  | Alerts handled | 10 | 15 | 20 | 25 |  |  |  |  |  |  | 70
 |  | Time      Spent | 60 | 30 | 60 | 60 | 15 | 15 | 15 | 15 | 30 | 120 | 3.5 | 3.5 | 7 | 0 | 50
[NAME] |  | Alerts handled | 10 | 15 | 20 | 25 |  |  |  |  |  |  | 70
 |  | Time      Spent | 60 | 30 | 60 | 60 | 15 | 15 | 15 | 15 | 30 | 120 | 3.5 | 3.5 | 7 | 0 | 50
[NAME] |  | Alerts handled | 10 | 15 | 20 | 25 |  |  |  |  |  |  | 70
 |  | Time      Spent | 60 | 30 | 60 | 60 | 15 | 15 | 15 | 15 | 30 | 120 | 3.5 | 3.5 | 7 | 0 | 50
[NAME] |  | Alerts handled | 10 | 15 | 20 | 25 |  |  |  |  |  |  | 70
 |  | Time      Spent | 60 | 30 | 60 | 60 | 15 | 15 | 15 | 15 | 30 | 120 | 3.5 | 3.5 | 7 | 0 | 50
Marios Panayi |  | Alerts handled | 10 | 15 | 20 | 25 |  |  |  |  |  |  | 70
 |  | Time      Spent | 60 | 30 | 60 | 60 | 15 | 15 | 15 | 15 | 30 | 120 | 3.5 | 3.5 | 7 | 0 | 50
Marlon Moise |  | Alerts handled | 10 | 15 | 20 | 25 |  |  |  |  |  |  | 70
 |  | Time      Spent | 60 | 30 | 60 | 60 | 15 | 15 | 15 | 15 | 30 | 120 | 3.5 | 3.5 | 7 | 0 | 50
[NAME] |  | Alerts handled | 10 | 15 | 20 | 25 |  |  |  |  |  |  | 70
 |  | Time      Spent | 60 | 30 | 60 | 60 | 15 | 15 | 15 | 15 | 30 | 120 | 3.5 | 3.5 | 7 | 0 | 50
[NAME] |  | Alerts handled | 10 | 15 | 20 | 25 |  |  |  |  |  |  | 70
 |  | Time      Spent | 60 | 30 | 60 | 60 | 15 | 15 | 15 | 15 | 30 | 120 | 3.5 | 3.5 | 7 | 0 | 50
[NAME] |  | Alerts handled | 10 | 15 | 20 | 25 |  |  |  |  |  |  | 70
 |  | Time      Spent | 60 | 30 | 60 | 60 | 15 | 15 | 15 | 15 | 30 | 120 | 3.5 | 3.5 | 7 | 0 | 50
[NAME] |  | Alerts handled | 10 | 15 | 20 | 25 |  |  |  |  |  |  | 70
 |  | Time      Spent | 60 | 30 | 60 | 60 | 15 | 15 | 15 | 15 | 30 | 120 | 3.5 | 3.5 | 7 | 0 | 50
[NAME] |  | Alerts handled | 10 | 15 | 20 | 25 |  |  |  |  |  |  | 70
 |  | Time      Spent | 60 | 30 | 60 | 60 | 15 | 15 | 15 | 15 | 30 | 120 | 3.5 | 3.5 | 7 | 0 | 50
[NAME] |  | Alerts handled | 10 | 15 | 20 | 25 |  |  |  |  |  |  | 70
 |  | Time      Spent | 60 | 30 | 60 | 60 | 15 | 15 | 15 | 15 | 30 | 120 | 3.5 | 3.5 | 7 | 0 | 50
[NAME] |  | Alerts handled | 10 | 15 | 20 | 25 |  |  |  |  |  |  | 70
 |  | Time      Spent | 60 | 30 | 60 | 60 | 15 | 15 | 15 | 15 | 30 | 120 | 3.5 | 3.5 | 7 | 0 | 50
[NAME] |  | Alerts handled | 10 | 15 | 20 | 25 |  |  |  |  |  |  | 70
 |  | Time      Spent | 60 | 30 | 60 | 60 | 15 | 15 | 15 | 15 | 30 | 120 | 3.5 | 3.5 | 7 | 0 | 50
[NAME] |  | Alerts handled | 10 | 15 | 20 | 25 |  |  |  |  |  |  | 70
 |  | Time      Spent | 60 | 30 | 60 | 60 | 15 | 15 | 15 | 15 | 30 | 120 | 3.5 | 3.5 | 7 | 0 | 50
[NAME] |  | Alerts handled | 10 | 15 | 20 | 25 |  |  |  |  |  |  | 70
 |  | Time      Spent | 60 | 30 | 60 | 60 | 15 | 15 | 15 | 15 | 30 | 120 | 3.5 | 3.5 | 7 | 0 | 50
[NAME] |  | Alerts handled | 10 | 15 | 20 | 25 |  |  |  |  |  |  | 70
 |  | Time      Spent | 60 | 30 | 60 | 60 | 15 | 15 | 15 | 15 | 30 | 120 | 3.5 | 3.5 | 7 | 0 | 50
[NAME] |  | Alerts handled | 10 | 15 | 20 | 25 |  |  |  |  |  |  | 70
 |  | Time      Spent | 60 | 30 | 60 | 60 | 15 | 15 | 15 | 15 | 30 | 120 | 3.5 | 3.5 | 7 | 0 | 50
Troy Attride |  | Alerts handled | 10 | 15 | 20 | 25 |  |  |  |  |  |  | 70
 |  | Time      Spent | 60 | 30 | 60 | 60 | 15 | 15 | 15 | 15 | 30 | 120 | 3.5 | 3.5 | 7 | 0 | 50