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

Week 1
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 |  | Alerts handled | 50 | 70 | 90 | 102 |  |  |  |  |  |  | 312
 |  | Time    Spent | 270 | 210 | 265 | 295 | 75 | 75 | 75 | 75 | 150 | 600 | 17.33333333333333 | 17.5 | 34.83333333333333 | 27.83333333333333 | 50.23923444976077
[NAME] |  | Alerts handled | 50 | 75 | 100 | 125 |  |  |  |  |  |  | 350
 |  | Time      Spent | 300 | 150 | 300 | 300 | 75 | 75 | 75 | 75 | 150 | 600 | 1125 | 1050 | 36.25 | 29.25 | 2896.551724137931
[NAME] |  | Alerts handled | 50 | 75 | 100 | 125 |  |  |  |  |  |  | 350
 |  | Time      Spent | 300 | 150 | 300 | 300 | 75 | 75 | 75 | 75 | 150 | 600 | 1050 | 1050 | 35 | 28 | 3000
[NAME] |  | Alerts handled | 50 | 75 | 100 | 125 |  |  |  |  |  |  | 350
 |  | Time      Spent | 300 | 150 | 300 | 300 | 75 | 75 | 75 | 75 | 150 | 600 | 1050 | 1050 | 35 | 28 | 3000
[NAME] |  | Alerts handled | 50 | 75 | 100 | 125 |  |  |  |  |  |  | 350
 |  | Time      Spent | 300 | 150 | 300 | 300 | 75 | 75 | 75 | 75 | 150 | 600 | 1050 | 1050 | 35 | 28 | 3000
Claudia Parisi |  | Alerts handled | 50 | 75 | 100 | 125 |  |  |  |  |  |  | 350
 |  | Time      Spent | 300 | 150 | 300 | 300 | 75 | 75 | 75 | 75 | 150 | 600 | 1050 | 1050 | 35 | 28 | 3000
[NAME] |  | Alerts handled | 50 | 75 | 100 | 125 |  |  |  |  |  |  | 350
 |  | Time      Spent | 300 | 150 | 300 | 300 | 75 | 75 | 75 | 75 | 150 | 600 | 1050 | 1050 | 35 | 28 | 3000
[NAME] |  | Alerts handled | 50 | 75 | 100 | 125 |  |  |  |  |  |  | 350
 |  | Time      Spent | 300 | 150 | 300 | 300 | 75 | 75 | 75 | 75 | 150 | 600 | 1050 | 1050 | 35 | 28 | 3000
[NAME] |  | Alerts handled | 50 | 75 | 100 | 125 |  |  |  |  |  |  | 350
 |  | Time      Spent | 300 | 150 | 300 | 300 | 75 | 75 | 75 | 75 | 150 | 600 | 1050 | 1050 | 35 | 28 | 3000
[NAME] |  | Alerts handled | 50 | 75 | 100 | 125 |  |  |  |  |  |  | 350
 |  | Time      Spent | 300 | 150 | 300 | 300 | 75 | 75 | 75 | 75 | 150 | 600 | 1050 | 1050 | 35 | 28 | 3000
[NAME] |  | Alerts handled | 50 | 75 | 100 | 125 |  |  |  |  |  |  | 350
 |  | Time      Spent | 300 | 150 | 300 | 300 | 75 | 75 | 75 | 75 | 150 | 600 | 1050 | 1050 | 35 | 28 | 3000
[NAME] |  | Alerts handled | 50 | 75 | 100 | 125 |  |  |  |  |  |  | 350
 |  | Time      Spent | 300 | 150 | 300 | 300 | 75 | 75 | 75 | 75 | 150 | 600 | 1050 | 1050 | 35 | 28 | 3000
[NAME] |  | Alerts handled | 50 | 75 | 100 | 125 |  |  |  |  |  |  | 350
 |  | Time      Spent | 300 | 150 | 300 | 300 | 75 | 75 | 75 | 75 | 150 | 600 | 1050 | 1050 | 35 | 28 | 3000
[NAME] |  | Alerts handled | 50 | 75 | 100 | 125 |  |  |  |  |  |  | 350
 |  | Time      Spent | 300 | 150 | 300 | 300 | 75 | 75 | 75 | 75 | 150 | 600 | 1050 | 1050 | 35 | 28 | 3000
[NAME] |  | Alerts handled | 50 | 75 | 100 | 125 |  |  |  |  |  |  | 350
 |  | Time      Spent | 300 | 150 | 300 | 300 | 75 | 75 | 75 | 75 | 150 | 600 | 1050 | 1050 | 35 | 28 | 3000
[NAME] |  | Alerts handled | 50 | 75 | 100 | 125 |  |  |  |  |  |  | 350
 |  | Time      Spent | 300 | 150 | 300 | 300 | 75 | 75 | 75 | 75 | 150 | 600 | 1050 | 1050 | 35 | 28 | 3000
[NAME] |  | Alerts handled | 50 | 75 | 100 | 125 |  |  |  |  |  |  | 350
 |  | Time      Spent | 300 | 150 | 300 | 300 | 75 | 75 | 75 | 75 | 150 | 600 | 1050 | 1050 | 35 | 28 | 3000
Marios Panayi |  | Alerts handled | 50 | 75 | 100 | 125 |  |  |  |  |  |  | 350
 |  | Time      Spent | 300 | 150 | 300 | 300 | 75 | 75 | 75 | 75 | 150 | 600 | 1050 | 1050 | 35 | 28 | 3000
Marlon Moise |  | Alerts handled | 50 | 75 | 100 | 125 |  |  |  |  |  |  | 350
 |  | Time      Spent | 300 | 150 | 300 | 300 | 75 | 75 | 75 | 75 | 150 | 600 | 1050 | 1050 | 35 | 28 | 3000
[NAME] |  | Alerts handled | 50 | 75 | 100 | 125 |  |  |  |  |  |  | 350
 |  | Time      Spent | 300 | 150 | 300 | 300 | 75 | 75 | 75 | 75 | 150 | 600 | 1050 | 1050 | 35 | 28 | 3000
[NAME] |  | Alerts handled | 50 | 75 | 100 | 125 |  |  |  |  |  |  | 350
 |  | Time      Spent | 300 | 150 | 300 | 300 | 75 | 75 | 75 | 75 | 150 | 600 | 1050 | 1050 | 35 | 28 | 3000
[NAME] |  | Alerts handled | 50 | 75 | 100 | 125 |  |  |  |  |  |  | 350
 |  | Time      Spent | 300 | 150 | 300 | 300 | 75 | 75 | 75 | 75 | 150 | 600 | 1050 | 1050 | 35 | 28 | 3000
[NAME] |  | Alerts handled | 50 | 75 | 100 | 125 |  |  |  |  |  |  | 350
 |  | Time      Spent | 300 | 150 | 300 | 300 | 75 | 75 | 75 | 75 | 150 | 600 | 1050 | 1050 | 35 | 28 | 3000
[NAME] |  | Alerts handled | 50 | 75 | 100 | 125 |  |  |  |  |  |  | 350
 |  | Time      Spent | 300 | 150 | 300 | 300 | 75 | 75 | 75 | 75 | 150 | 600 | 1050 | 1050 | 35 | 28 | 3000
[NAME] |  | Alerts handled | 50 | 75 | 100 | 125 |  |  |  |  |  |  | 350
 |  | Time      Spent | 300 | 150 | 300 | 300 | 75 | 75 | 75 | 75 | 150 | 600 | 1050 | 1050 | 35 | 28 | 3000
[NAME] |  | Alerts handled | 50 | 75 | 100 | 125 |  |  |  |  |  |  | 350
 |  | Time      Spent | 300 | 150 | 300 | 300 | 75 | 75 | 75 | 75 | 150 | 600 | 1050 | 1050 | 35 | 28 | 3000
[NAME] |  | Alerts handled | 50 | 75 | 100 | 125 |  |  |  |  |  |  | 350
 |  | Time      Spent | 300 | 150 | 300 | 300 | 75 | 75 | 75 | 75 | 150 | 600 | 1050 | 1050 | 35 | 28 | 3000
[NAME] |  | Alerts handled | 50 | 75 | 100 | 125 |  |  |  |  |  |  | 350
 |  | Time      Spent | 300 | 150 | 300 | 300 | 75 | 75 | 75 | 75 | 150 | 600 | 1050 | 1050 | 35 | 28 | 3000
[NAME] |  | Alerts handled | 50 | 75 | 100 | 125 |  |  |  |  |  |  | 350
 |  | Time      Spent | 300 | 150 | 300 | 300 | 75 | 75 | 75 | 75 | 150 | 600 | 1050 | 1050 | 35 | 28 | 3000
[NAME] |  | Alerts handled | 50 | 75 | 100 | 125 |  |  |  |  |  |  | 350
 |  | Time      Spent | 300 | 150 | 300 | 300 | 75 | 75 | 75 | 75 | 150 | 600 | 1050 | 1050 | 35 | 28 | 3000
[NAME] |  | Alerts handled | 50 | 75 | 100 | 125 |  |  |  |  |  |  | 350
 |  | Time      Spent | 300 | 150 | 300 | 300 | 75 | 75 | 75 | 75 | 150 | 600 | 1050 | 1050 | 35 | 28 | 3000
Troy Attride |  | Alerts handled | 50 | 75 | 100 | 125 |  |  |  |  |  |  | 350
 |  | Time      Spent | 300 | 150 | 300 | 300 | 75 | 75 | 75 | 75 | 150 | 600 | 1050 | 1050 | 35 | 28 | 3000