Spreadsheet: 110806d1307398620-dynamic-rota-pattern-rota2
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 |  |  | Current |  |  |  | Sun |  | Mon |  | Tue |  | Wed |  | Thu |  | Fri |  | Sat
2011-01-16 00:00:00 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  | Code | Weeks | Week | W/C Date | Start | Finish | Start | Finish | Start | Finish | Start | Finish | Start | Finish | Start | Finish | Start | Finish
2011-01-23 00:00:00 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |  |  | ROT | 6 | 1 | 2011-01-02 00:00:00 | OFF | OFF | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | OFF | OFF
2011-01-30 00:00:00 | 1 | 1 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 |  |  | [NAME] | [NAME] | 2 | 2011-01-09 00:00:00 | 06:00:00 | 14:00:00 | OFF | OFF | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | OFF | OFF
2011-02-06 00:00:00 | 1 | 2 | 1 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 |  |  | 06:00:00 | 14:00:00 | 3 | 2011-01-16 00:00:00 | OFF | OFF | 06:00:00 | 14:00:00 | OFF | OFF | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | OFF | OFF
2011-02-13 00:00:00 | 1 | 1 | 2 | 1 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 |  |  |  |  | 4 | 2011-01-23 00:00:00 | OFF | OFF | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | OFF | OFF | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | OFF | OFF
2011-02-20 00:00:00 | 1 | 2 | 3 | 2 | 1 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 |  |  |  |  | 5 | 2011-01-30 00:00:00 | OFF | OFF | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | OFF | OFF | 06:00:00 | 14:00:00 | OFF | OFF
2011-02-27 00:00:00 | 1 | 1 | 1 | 3 | 2 | 1 | 7 | 7 | 7 | 7 | 7 | 7 | 7 |  |  |  |  | 6 | 2011-02-06 00:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | OFF | OFF | OFF | OFF
2011-03-06 00:00:00 | 1 | 2 | 2 | 4 | 3 | 2 | 1 | 8 | 8 | 8 | 8 | 8 | 8
2011-03-13 00:00:00 | 1 | 1 | 3 | 1 | 4 | 3 | 2 | 1 | 9 | 9 | 9 | 9 | 9
2011-03-20 00:00:00 | 1 | 2 | 1 | 2 | 5 | 4 | 3 | 2 | 1 | 10 | 10 | 10 | 10
2011-03-27 00:00:00 | 1 | 1 | 2 | 3 | 1 | 5 | 4 | 3 | 2 | 1 | 11 | 11 | 11
2011-04-03 00:00:00 | 1 | 2 | 3 | 4 | 2 | 6 | 5 | 4 | 3 | 2 | 1 | 12 | 12
2011-04-10 00:00:00 | 1 | 1 | 1 | 1 | 3 | 1 | 6 | 5 | 4 | 3 | 2 | 1 | 13
2011-04-17 00:00:00 | 1 | 2 | 2 | 2 | 4 | 2 | 7 | 6 | 5 | 4 | 3 | 2 | 1
2011-04-24 00:00:00 | 1 | 1 | 3 | 3 | 5 | 3 | 1 | 7 | 6 | 5 | 4 | 3 | 2
2011-05-01 00:00:00 | 1 | 2 | 1 | 4 | 1 | 4 | 2 | 8 | 7 | 6 | 5 | 4 | 3
2011-05-08 00:00:00 | 1 | 1 | 2 | 1 | 2 | 5 | 3 | 1 | 8 | 7 | 6 | 5 | 4 |  |  |  |  |  | Days Worked in Year | 17 |  | 43 |  | 43 |  | 43 |  | 44 |  | 44 |  | 0
2011-05-15 00:00:00 | 1 | 2 | 3 | 2 | 3 | 6 | 4 | 2 | 9 | 8 | 7 | 6 | 5
2011-05-22 00:00:00 | 1 | 1 | 1 | 3 | 4 | 1 | 5 | 3 | 1 | 9 | 8 | 7 | 6
2011-05-29 00:00:00 | 1 | 2 | 2 | 4 | 5 | 2 | 6 | 4 | 2 | 10 | 9 | 8 | 7
2011-06-05 00:00:00 | 1 | 1 | 3 | 1 | 1 | 3 | 7 | 5 | 3 | 1 | 10 | 9 | 8
2011-06-12 00:00:00 | 1 | 2 | 1 | 2 | 2 | 4 | 1 | 6 | 4 | 2 | 11 | 10 | 9
2011-06-19 00:00:00 | 1 | 1 | 2 | 3 | 3 | 5 | 2 | 7 | 5 | 3 | 1 | 11 | 10
2011-06-26 00:00:00 | 1 | 2 | 3 | 4 | 4 | 6 | 3 | 8 | 6 | 4 | 2 | 12 | 11
2011-07-03 00:00:00 | 1 | 1 | 1 | 1 | 5 | 1 | 4 | 1 | 7 | 5 | 3 | 1 | 12
2011-07-10 00:00:00 | 1 | 2 | 2 | 2 | 1 | 2 | 5 | 2 | 8 | 6 | 4 | 2 | 13
2011-07-17 00:00:00 | 1 | 1 | 3 | 3 | 2 | 3 | 6 | 3 | 9 | 7 | 5 | 3 | 1
2011-07-24 00:00:00 | 1 | 2 | 1 | 4 | 3 | 4 | 7 | 4 | 1 | 8 | 6 | 4 | 2
2011-07-31 00:00:00 | 1 | 1 | 2 | 1 | 4 | 5 | 1 | 5 | 2 | 9 | 7 | 5 | 3
2011-08-07 00:00:00 | 1 | 2 | 3 | 2 | 5 | 6 | 2 | 6 | 3 | 10 | 8 | 6 | 4
2011-08-14 00:00:00 | 1 | 1 | 1 | 3 | 1 | 1 | 3 | 7 | 4 | 1 | 9 | 7 | 5
2011-08-21 00:00:00 | 1 | 2 | 2 | 4 | 2 | 2 | 4 | 8 | 5 | 2 | 10 | 8 | 6
2011-08-28 00:00:00 | 1 | 1 | 3 | 1 | 3 | 3 | 5 | 1 | 6 | 3 | 11 | 9 | 7
2011-09-04 00:00:00 | 1 | 2 | 1 | 2 | 4 | 4 | 6 | 2 | 7 | 4 | 1 | 10 | 8
2011-09-11 00:00:00 | 1 | 1 | 2 | 3 | 5 | 5 | 7 | 3 | 8 | 5 | 2 | 11 | 9
2011-09-18 00:00:00 | 1 | 2 | 3 | 4 | 1 | 6 | 1 | 4 | 9 | 6 | 3 | 12 | 10
2011-09-25 00:00:00 | 1 | 1 | 1 | 1 | 2 | 1 | 2 | 5 | 1 | 7 | 4 | 1 | 11
2011-10-02 00:00:00 | 1 | 2 | 2 | 2 | 3 | 2 | 3 | 6 | 2 | 8 | 5 | 2 | 12
2011-10-09 00:00:00 | 1 | 1 | 3 | 3 | 4 | 3 | 4 | 7 | 3 | 9 | 6 | 3 | 13
2011-10-16 00:00:00 | 1 | 2 | 1 | 4 | 5 | 4 | 5 | 8 | 4 | 10 | 7 | 4 | 1
2011-10-23 00:00:00 | 1 | 1 | 2 | 1 | 1 | 5 | 6 | 1 | 5 | 1 | 8 | 5 | 2
2011-10-30 00:00:00 | 1 | 2 | 3 | 2 | 2 | 6 | 7 | 2 | 6 | 2 | 9 | 6 | 3
2011-11-06 00:00:00 | 1 | 1 | 1 | 3 | 3 | 1 | 1 | 3 | 7 | 3 | 10 | 7 | 4
2011-11-13 00:00:00 | 1 | 2 | 2 | 4 | 4 | 2 | 2 | 4 | 8 | 4 | 11 | 8 | 5
2011-11-20 00:00:00 | 1 | 1 | 3 | 1 | 5 | 3 | 3 | 5 | 9 | 5 | 1 | 9 | 6
2011-11-27 00:00:00 | 1 | 2 | 1 | 2 | 1 | 4 | 4 | 6 | 1 | 6 | 2 | 10 | 7
2011-12-04 00:00:00 | 1 | 1 | 2 | 3 | 2 | 5 | 5 | 7 | 2 | 7 | 3 | 11 | 8
2011-12-11 00:00:00 | 1 | 2 | 3 | 4 | 3 | 6 | 6 | 8 | 3 | 8 | 4 | 12 | 9
2011-12-18 00:00:00 | 1 | 1 | 1 | 1 | 4 | 1 | 7 | 1 | 4 | 9 | 5 | 1 | 10
2011-12-25 00:00:00 | 1 | 2 | 2 | 2 | 5 | 2 | 1 | 2 | 5 | 10 | 6 | 2 | 11
2012-01-01 00:00:00 | 1 | 1 | 3 | 3 | 1 | 3 | 2 | 3 | 6 | 1 | 7 | 3 | 12
2012-01-08 00:00:00 | 1 | 2 | 1 | 4 | 2 | 4 | 3 | 4 | 7 | 2 | 8 | 4 | 13