Spreadsheet: 147370d1332774035-locating-information-on-1-spreadsheet-and-then-exporting-it-to-another-work-sheet-duties-again
Sheet: department duty sheet

skill | name | duty
 |  | 2012-04-01 00:00:00 | 2012-04-02 00:00:00 | 2012-04-03 00:00:00 | 2012-04-04 00:00:00 | 2012-04-05 00:00:00 | 2012-04-06 00:00:00 | 2012-04-07 00:00:00
Call Taker - Part Time C | name 1 | 18:30-23:00 | Rest Days | 17:00-23:00 | 17:00-23:00 | Rest Days | Rest Days | 17:00-23:00
Call Taker - Part Time D | name 2 | Leave | Leave | Leave | 09:00-15:00 | Rest Days | Rest Days | Rest Days
Call Taker - Part Time E | name 3 | Rest Days | 17:00-23:00 | 17:00-23:00 | 17:00-23:00 | 10:00-20:00 | Leave | Rest Days
Call Taker - Part Time F | name 4 | 09:00-15:00 | 09:00-15:00 | 17:00-23:00 | 17:00-23:00 | 20:00-04:00 | Rest Days | Rest Days
Call Taker - Part Time G | name 5 | 07:30-15:00 | 17:00-23:00 | 17:00-23:00 | 17:00-23:00 | Rest Days | Rest Days | Rest Days
Call Taker - Part Time H | name 6 | 08:00-19:00 | Rest Days | Rest Days | Rest Days | 09:00-15:00 | Rest Days | Rest Days
Call Taker - Part Time J | name 7 | Sickness | Sickness | Sickness | Sickness | Sickness | Sickness | Sickness
Call Taker - Part Time K | name 8 | Rest Days | 18:30-23:00 | Rest Days | Rest Days | Rest Days | Rest Days | 09:00-15:00
Call Taker - Part Time L | name 9 | Rest Days | Rest Days | 17:00-23:00 | 17:00-23:00 | Rest Days | Rest Days | Rest Days
Call Taker - Part Time M | name 10 | 09:00-15:00 | 09:00-15:00 | 09:00-15:00 | 09:00-15:00 | Rest Days | Rest Days | Rest Days
Call Taker - Part Time N | name 11 | Rest Days | Rest Days | Rest Days | Rest Days | 09:00-15:00 | 07:00-15:30 | 09:00-15:00
Call Taker - Part Time O | name 12 | 17:00-23:00 | Rest Days | 09:00-15:00 | 09:00-15:00 | Rest Days | Rest Days | Rest Days
Call Taker - Part Time P | name 13 | Rest Days | 09:00-15:00 | Rest Days | Rest Days | 20:00-04:00 | Rest Days | 17:00-23:00
Call Taker - Part Time Q | name 14 | Rest Days | Rest Days | Rest Days | 09:00-15:00 | 09:00-15:00 | 10:00-20:00 | 17:00-23:00
Call Taker - Part Time R | name 15 | Rest Days | Rest Days | Rest Days | Rest Days | 13:30-21:45 | 13:30-21:45 | 13:30-21:30
Call Taker - Part Time S | name 16 | Rest Days | Rest Days | 07:00-17:00 | Rest Days | 07:00-17:00 | Rest Days | Rest Days
Call Taker - Part Time T | name 17 | Rest Days | Rest Days | Rest Days | Rest Days | 20:00-04:00 | Rest Days | 17:00-23:00
Call Taker - Part Time U | name 18 | 18:00-00:00 | Rest Days | 09:00-17:00 | 18:00-00:00 | Rest Days | Rest Days | 17:00-23:00
Call Taker - Part Time V | name 19 | 07:00-18:00 | Rest Days | 19:00-01:00 | 18:30-03:00 | Rest Days | Rest Days | Rest Days
Communications - Flexi Worker | name 20 | 09:00-17:00 | 09:00-17:00 | 09:00-17:00 | 09:00-17:00 | 09:00-17:00 | Rest Days | Rest Days
Communications - Flexi Worker | name 21 | 09:00-17:00 | 09:00-17:00 | 09:00-17:00 | 09:00-17:00 | 09:00-17:00 | Rest Days | Rest Days
Communications - Flexi Worker | name 22 | 09:00-17:00 | 09:00-17:00 | 09:00-17:00 | 09:00-17:00 | 09:00-17:00 | Rest Days | Rest Days
Communications - Part Time A | name 23 | Jury Duty | Jury Duty | Jury Duty | Jury Duty | Jury Duty | Rest Days | Rest Days
Communications - Part Time B | name 24 | Leave | Leave | Rest Days | Leave | Leave | Rest Days | Rest Days
Controller - Flexible A | name 25 | Leave | Leave | Leave | Rest Days | Rest Days | 07:00-17:00 | 07:00-17:00
Controller - PC - Tues to Fri 7-5 | name 26 | Rest Days | 07:00-17:00 | 07:00-17:00 | 07:00-17:00 | 07:00-17:00 | Rest Days | Rest Days
Controller - Part Time A | name 27 | 09:00-15:00 | 09:00-15:00 | Rest Days | 09:00-19:00 | Rest Days | Rest Days | Rest Days
Controller - Part Time B | name 28 | 09:00-15:00 | 09:00-19:00 | 09:00-19:00 | Rest Days | Rest Days | Rest Days | 09:00-19:00
Controller - Part Time C | name 29 | 18:00-01:00 | 18:00-01:00 | Rest Days | Rest Days | Rest Days | Rest Days | 17:00-23:00
Controller - Part Time D | name 30 | 18:00-01:00 | 18:00-01:00 | Rest Days | 18:00-01:00 | Rest Days | Rest Days | Rest Days
Controller - Part Time E | name 31 | Rest Days | Rest Days | 18:00-23:00 | 19:00-01:00 | Rest Days | Rest Days | 18:00-01:00
Controller - Part Time J | name 32 | 17:00-23:00 | 17:00-23:00 | 17:00-23:00 | 17:00-23:00 | Rest Days | Rest Days | Rest Days
Controller - Part Time L | name 33 | Rest Days | Rest Days | 09:00-18:00 | 09:00-18:00 | 09:00-18:00 | Rest Days | Rest Days
Controller - Part Time M | name 34 | 17:00-01:00 | Rest Days | Rest Days | 09:00-15:00 | 09:00-15:00 | Rest Days | Rest Days
Controller - Part Time N | name 35 | 09:00-15:00 | 17:00-23:00 | 17:00-01:00 | Rest Days | Rest Days | Rest Days | Rest Days
Controller - Part Time O | name 36 | Rest Days | Rest Days | Rest Days | 08:30-17:30 | 08:30-17:30 | Rest Days | 08:30-17:30
Controller - Part Time P | name 37 | 17:00-01:00 | Rest Days | Rest Days | Rest Days | 09:00-15:00 | Rest Days | Rest Days
Controller - Part Time Q | name 38 | Leave | Leave | Leave | Leave | Rest Days | Rest Days | Leave
Controller - Part Time R | name 39 | Rest Days | 09:30-15:00 | Rest Days | 19:00-01:00 | Rest Days | 19:00-01:00 | Rest Days
FOR Zero Hours - Call Taker | name 40 | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days
FOR Zero Hours - Call Taker | name 41 | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days
FOR Zero Hours - Call Taker | name 42 | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days
FOR Zero Hours - Call Taker | name 43 | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days
FOR Zero Hours - Call Taker | name 44 | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days
FOR Zero Hours - Call Taker | name 45 | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days
FOR Zero Hours - Call Taker | name 46 | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days
FOR Zero Hours - Call Taker | name 47 | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days
FOR Zero Hours - Call Taker | name 48 | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days
FOR Zero Hours - Call Taker | name 49 | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days
FOR Zero Hours - Call Taker | name 50 | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days
FOR Zero Hours - Call Taker | name 51 | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days
FOR Zero Hours - Call Taker | name 52 | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days
FOR Zero Hours - Call Taker | name 53 | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days
FOR Zero Hours - Controller | name 54 | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days
FOR Zero Hours - Controller | name 55 | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days
FOR Zero Hours - Controller | name 56 | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days
FOR Zero Hours - Controller | name 57 | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days
FOR Zero Hours - Controller | name 58 | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days | Rest Days
FOR Zero Hours - Controller | name 59 | Rest Days | Rest Days | Rest Days | Rest Days | 13:30-21:30 | Rest Days | Rest Days
[NAME] | name 60 | 09:00-17:00 | 09:00-17:00 | 09:00-17:00 | 09:00-17:00 | 09:00-17:00 | Rest Days | Rest Days
Monday to Friday 8-4 | name 61 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | Rest Days | Rest Days
Police Direct - Flexible A | name 62 | 12:00-20:00 | 10:00-18:00 | Rest Days | 12:00-20:00 | 09:30-17:30 | Rest Days | Rest Days
Police Direct - Flexible B | name 63 | Leave | Leave | Leave | Leave | Rest Days | Leave | Leave
Police Direct - Part Time A | name 64 | 08:00-14:00 | 08:00-14:00 | 08:00-14:00 | 08:00-14:00 | 08:00-14:00 | Rest Days | Rest Days
Section 1 - Call Taker A | name 65 | Rest Days | Rest Days | Rest Days | 13:30-21:30 | 13:30-21:45 | Leave | Leave
Section 1 - Call Taker A | name 66 | Rest Days | Rest Days | Rest Days | 13:30-21:30 | 13:30-21:45 | 13:30-21:45 | 13:30-21:30
Section 1 - Call Taker B | name 67 | Rest Days | Rest Days | Rest Days | 13:30-21:30 | 13:30-21:45 | 13:30-21:45 | 13:30-21:30
Section 1 - Call Taker B | name 68 | Rest Days | Rest Days | Rest Days | 13:30-21:30 | 13:30-21:45 | 13:30-21:45 | 13:30-21:30
Section 1 - Call Taker B | name 69 | Rest Days | Rest Days | Rest Days | 13:30-21:30 | 13:30-21:45 | 13:30-21:45 | 13:30-21:30
Section 1 - Call Taker Supervisor | name 70 | Rest Days | Rest Days | Rest Days | 13:30-21:30 | 13:30-22:00 | 13:30-21:45 | 13:30-21:30
Section 1 - Controller A | name 71 | Rest Days | Rest Days | Rest Days | 13:30-21:30 | 17:00-01:30 | 17:00-01:30 | 13:30-21:30
Section 1 - Controller A | name 72 | Rest Days | Rest Days | Rest Days | 13:30-21:30 | 17:00-01:30 | 17:00-01:30 | 13:30-21:30
Section 1 - Controller A | name 73 | Rest Days | Rest Days | Rest Days | 13:30-21:30 | 17:00-01:30 | 17:00-01:30 | 13:30-21:30
Section 1 - Controller B | name 74 | Rest Days | Rest Days | Rest Days | 13:30-21:30 | 13:30-21:45 | 13:30-21:45 | 13:30-21:30
Section 1 - Controller B | name 75 | Rest Days | Rest Days | Rest Days | 13:30-21:30 | Operation | 13:30-21:45 | 13:30-21:30
Section 1 - Controller B | name 76 | Rest Days | Rest Days | Rest Days | 13:30-21:30 | 13:30-21:45 | 13:30-21:45 | 13:30-21:30
Section 1 - Controller B | name 77 | Rest Days | Rest Days | Rest Days | 13:30-21:30 | 13:30-21:45 | 13:30-21:45 | 13:30-21:30
Section 1 - Controller B | name 78 | Rest Days | Rest Days | Rest Days | 13:30-21:30 | 13:30-21:45 | 13:30-21:45 | 13:30-21:30
Section 1 - Controller B | name 79 | Rest Days | Rest Days | Rest Days | 13:30-21:30 | 13:30-21:45 | 13:30-21:45 | 13:30-21:30
Section 1 - Controller Supervisor | name 80 | Rest Days | Rest Days | Rest Days | 13:30-21:30 | 17:00-01:30 | 17:00-01:15 | 13:30-21:30
Section 1 - Inspector | name 81 | Rest Days | Rest Days | Rest Days | 13:30-21:30 | 17:00-01:00 | 17:00-01:00 | 13:30-21:30
Section 2 - Call Taker A | name 82 | Rest Days | Rest Days | Leave | Leave | Leave | Rest Days | Rest Days
Section 2 - Call Taker A | name 83 | Rest Days | Rest Days | 07:00-17:00 | 07:00-17:00 | 07:00-17:00 | Rest Days | Rest Days
Section 2 - Call Taker A | name 84 | Rest Days | Rest Days | 07:00-17:00 | 07:00-17:00 | 07:00-17:00 | Rest Days | Rest Days
Section 2 - Call Taker B | name 85 | Rest Days | Rest Days | 07:00-17:00 | 07:00-17:00 | 07:00-17:00 | Rest Days | Rest Days
Section 2 - Call Taker B | name 86 | Rest Days | Rest Days | 07:00-17:00 | 07:00-17:00 | 07:00-17:00 | Rest Days | Rest Days
Section 2 - Call Taker B | name 87 | Rest Days | Rest Days | 07:00-17:00 | 07:00-17:00 | 07:00-17:00 | Rest Days | Rest Days
Section 2 - Controller - Part Time A | name 88 | Rest Days | Rest Days | 07:00-17:00 | 07:00-17:00 | 07:00-17:00 | Rest Days | Rest Days
Section 2 - Controller A | name 89 | Rest Days | Rest Days | 07:00-17:00 | 07:00-17:00 | 07:00-17:00 | Rest Days | Rest Days
Section 2 - Controller A | name 90 | Rest Days | Rest Days | Leave | Leave | Leave | Rest Days | Rest Days
Section 2 - Controller A | name 91 | Rest Days | Rest Days | 07:00-17:00 | 07:00-17:00 | 07:00-17:00 | Rest Days | Rest Days
Section 2 - Controller B | name 92 | Rest Days | Rest Days | 07:00-17:00 | 07:00-17:00 | 07:00-17:00 | Rest Days | Rest Days
Section 2 - Controller B | name 93 | Rest Days | Rest Days | 07:00-17:00 | 07:00-17:00 | 07:00-17:00 | Rest Days | Rest Days
Section 2 - Controller B | name 94 | Rest Days | Rest Days | 07:00-17:00 | 07:00-17:00 | 07:00-17:00 | Rest Days | Rest Days
Section 2 - Controller B | name 95 | Rest Days | Rest Days | 07:00-17:00 | 07:00-17:00 | 07:00-17:00 | Rest Days | Rest Days
Section 2 - Controller Supervisor | name 96 | Rest Days | Rest Days | 07:00-17:00 | 07:00-17:00 | 07:00-17:00 | Rest Days | Rest Days
Section 2 - Inspector | name 97 | Rest Days | Rest Days | 07:00-17:00 | 07:00-17:00 | 07:00-17:00 | Rest Days | Rest Days
Section 2 - Sgt | name 98 | Rest Days | Rest Days | 07:00-17:00 | 07:00-17:00 | 07:00-17:00 | Rest Days | Rest Days
Section 3 - Call Taker - Flexible A | name 99 | 14:00-00:00 | 14:00-00:00 | 14:00-00:00 | 14:00-00:00 | Rest Days | Rest Days | Rest Days
Section 3 - Call Taker A | name 100 | 17:00-03:00 | 17:00-03:00 | 17:00-03:00 | 17:00-03:00 | Rest Days | Rest Days | Rest Days
Section 3 - Call Taker A | name 101 | 17:00-03:00 | 17:00-03:00 | Leave | Leave | Rest Days | Rest Days | Rest Days
Section 3 - Call Taker A | name 102 | 17:00-03:00 | 17:00-03:00 | 17:00-03:00 | Leave | Rest Days | Rest Days | Rest Days
Section 3 - Call Taker B | name 103 | Leave | Leave | Leave | Leave | Rest Days | Rest Days | Rest Days
Section 3 - Call Taker B | name 104 | 21:00-07:00 | 21:00-07:00 | 21:00-07:00 | 21:00-07:00 | Rest Days | Rest Days | Rest Days
Section 3 - Call Taker Supervisor | name 105 | 17:00-03:00 | 17:00-03:00 | 17:00-03:00 | 17:00-03:00 | Rest Days | Rest Days | Rest Days
Section 3 - Controller A | name 106 | 21:00-07:00 | 21:00-07:00 | 21:00-07:00 | 21:00-07:00 | Rest Days | Rest Days | Rest Days
Section 3 - Controller A | name 107 | 21:00-07:00 | 21:00-07:00 | 21:00-07:00 | 21:00-07:00 | Rest Days | Rest Days | Rest Days
Section 3 - Controller A | name 108 | 21:00-07:00 | 21:00-07:00 | 21:00-07:00 | 21:00-07:00 | Rest Days | Rest Days | Rest Days
Section 3 - Controller A | name 109 | 21:00-07:00 | 21:00-07:00 | 21:00-07:00 | 21:00-07:00 | Rest Days | Rest Days | Rest Days
Section 3 - Controller A | name 110 | 21:00-07:00 | 21:00-07:00 | 21:00-07:00 | 21:00-07:00 | Rest Days | Rest Days | Rest Days
Section 3 - Controller B | name 111 | 21:00-07:00 | 21:00-07:00 | 21:00-07:00 | 21:00-07:00 | Rest Days | Rest Days | Rest Days
Section 3 - Controller B | name 112 | 21:00-07:00 | 21:00-07:00 | 21:00-07:00 | 21:00-07:00 | Rest Days