Spreadsheet: 110777d1307384220-dynamic-rota-pattern-rota
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
W/C | Current | Rota | Rota | Rota | Start | Rota | Rota | Core |  |  | Sun |  | Mon |  | Tue |  | Wed |  | Thu |  | Fri |  | Sat
Date | Rota | Group | Row | Cycle | Week | Weeks | Offset | Dept |  |  | Start | Finish | Start | Finish | Start | Finish | Start | Finish | Start | Finish | Start | Finish | Start | Finish
2011-01-02 00:00:00 | ROT1 | ROT | 3 | 1 | 1 | 6 | 0 |  |  |  | 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-09 00:00:00 | ROT1 | ROT | 3 | 2 | 1 | 6 | 1 |  |  |  | 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-01-16 00:00:00 | ROT1 | ROT | 3 | 3 | 1 | 6 | 2 |  |  |  | 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 | 06:00:00 | 14:00:00 | OFF | OFF
2011-01-23 00:00:00 | ROT1 | ROT | 3 | 4 | 1 | 6 | 3 |  |  |  | 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 | 06:00:00 | 14:00:00 | OFF | OFF
2011-01-30 00:00:00 | ROT1 | ROT | 3 | 5 | 1 | 6 | 4 |  |  |  | 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 | 06:00:00 | 14:00:00 | OFF | OFF
2011-02-06 00:00:00 | ROT1 | ROT | 3 | 6 | 1 | 6 | 5 |  |  |  | 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-02-13 00:00:00 | ROT1 | ROT | 3 | 1 | 1 | 6 | 0 |  |  |  | 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-02-20 00:00:00 | ROT1 | ROT | 3 | 2 | 1 | 6 | 1 |  |  |  | 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-27 00:00:00 | ROT1 | ROT | 3 | 3 | 1 | 6 | 2 |  |  |  | 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 | 06:00:00 | 14:00:00 | OFF | OFF
2011-03-06 00:00:00 | ROT1 | ROT | 3 | 4 | 1 | 6 | 3 |  |  |  | 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 | 06:00:00 | 14:00:00 | OFF | OFF
2011-03-13 00:00:00 | ROT1 | ROT | 3 | 5 | 1 | 6 | 4 |  |  |  | 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 | 06:00:00 | 14:00:00 | OFF | OFF
2011-03-20 00:00:00 | ROT1 | ROT | 3 | 6 | 1 | 6 | 5 |  |  |  | 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-27 00:00:00 | ROT1 | ROT | 3 | 1 | 1 | 6 | 0 |  |  |  | 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-04-03 00:00:00 | ROT1 | ROT | 3 | 2 | 1 | 6 | 1 |  |  |  | 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-04-10 00:00:00 | ROT1 | ROT | 3 | 3 | 1 | 6 | 2 |  |  |  | 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 | 06:00:00 | 14:00:00 | OFF | OFF
2011-04-17 00:00:00 | ROT1 | ROT | 3 | 4 | 1 | 6 | 3 |  |  |  | 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 | 06:00:00 | 14:00:00 | OFF | OFF
2011-04-24 00:00:00 | ROT1 | ROT | 3 | 5 | 1 | 6 | 4 |  |  |  | 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 | 06:00:00 | 14:00:00 | OFF | OFF
2011-05-01 00:00:00 | ROT1 | ROT | 3 | 6 | 1 | 6 | 5 |  |  |  | 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-05-08 00:00:00 | ROT1 | ROT | 3 | 1 | 1 | 6 | 0 |  |  |  | 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-05-15 00:00:00 | ROT1 | ROT | 3 | 2 | 1 | 6 | 1 |  |  |  | 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-05-22 00:00:00 | ROT1 | ROT | 3 | 3 | 1 | 6 | 2 |  |  |  | 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 | 06:00:00 | 14:00:00 | OFF | OFF
2011-05-29 00:00:00 | ROT1 | ROT | 3 | 4 | 1 | 6 | 3 |  |  |  | 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 | 06:00:00 | 14:00:00 | OFF | OFF
2011-06-05 00:00:00 | ROT1 | ROT | 3 | 5 | 1 | 6 | 4 |  |  |  | 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 | 06:00:00 | 14:00:00 | OFF | OFF
2011-06-12 00:00:00 | ROT1 | ROT | 3 | 6 | 1 | 6 | 5 |  |  |  | 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-06-19 00:00:00 | ROT1 | ROT | 3 | 1 | 1 | 6 | 0 |  |  |  | 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-06-26 00:00:00 | ROT1 | ROT | 3 | 2 | 1 | 6 | 1 |  |  |  | 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-07-03 00:00:00 | ROT1 | ROT | 3 | 3 | 1 | 6 | 2 |  |  |  | 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 | 06:00:00 | 14:00:00 | OFF | OFF
2011-07-10 00:00:00 | ROT1 | ROT | 3 | 4 | 1 | 6 | 3 |  |  |  | 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 | 06:00:00 | 14:00:00 | OFF | OFF
2011-07-17 00:00:00 | ROT1 | ROT | 3 | 5 | 1 | 6 | 4 |  |  |  | 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 | 06:00:00 | 14:00:00 | OFF | OFF
2011-07-24 00:00:00 | ROT1 | ROT | 3 | 6 | 1 | 6 | 5 |  |  |  | 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-07-31 00:00:00 | ROT1 | ROT | 3 | 1 | 1 | 6 | 0 |  |  |  | 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-08-07 00:00:00 | ROT1 | ROT | 3 | 2 | 1 | 6 | 1 |  |  |  | 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-08-14 00:00:00 | ROT1 | ROT | 3 | 3 | 1 | 6 | 2 |  |  |  | 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 | 06:00:00 | 14:00:00 | OFF | OFF
2011-08-21 00:00:00 | ROT1 | ROT | 3 | 4 | 1 | 6 | 3 |  |  |  | 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 | 06:00:00 | 14:00:00 | OFF | OFF
2011-08-28 00:00:00 | ROT1 | ROT | 3 | 5 | 1 | 6 | 4 |  |  |  | 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 | 06:00:00 | 14:00:00 | OFF | OFF
2011-09-04 00:00:00 | ROT1 | ROT | 3 | 6 | 1 | 6 | 5 |  |  |  | 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-09-11 00:00:00 | ROT1 | ROT | 3 | 1 | 1 | 6 | 0 |  |  |  | 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-09-18 00:00:00 | ROT1 | ROT | 3 | 2 | 1 | 6 | 1 |  |  |  | 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-09-25 00:00:00 | ROT1 | ROT | 3 | 3 | 1 | 6 | 2 |  |  |  | 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 | 06:00:00 | 14:00:00 | OFF | OFF
2011-10-02 00:00:00 | ROT1 | ROT | 3 | 4 | 1 | 6 | 3 |  |  |  | 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 | 06:00:00 | 14:00:00 | OFF | OFF
2011-10-09 00:00:00 | ROT1 | ROT | 3 | 5 | 1 | 6 | 4 |  |  |  | 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 | 06:00:00 | 14:00:00 | OFF | OFF
2011-10-16 00:00:00 | ROT1 | ROT | 3 | 6 | 1 | 6 | 5 |  |  |  | 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-10-23 00:00:00 | ROT1 | ROT | 3 | 1 | 1 | 6 | 0 |  |  |  | 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-10-30 00:00:00 | ROT1 | ROT | 3 | 2 | 1 | 6 | 1 |  |  |  | 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-11-06 00:00:00 | ROT1 | ROT | 3 | 3 | 1 | 6 | 2 |  |  |  | 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 | 06:00:00 | 14:00:00 | OFF | OFF
2011-11-13 00:00:00 | ROT1 | ROT | 3 | 4 | 1 | 6 | 3 |  |  |  | 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 | 06:00:00 | 14:00:00 | OFF | OFF
2011-11-20 00:00:00 | ROT1 | ROT | 3 | 5 | 1 | 6 | 4 |  |  |  | 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 | 06:00:00 | 14:00:00 | OFF | OFF
2011-11-27 00:00:00 | ROT1 | ROT | 3 | 6 | 1 | 6 | 5 |  |  |  | 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-12-04 00:00:00 | ROT1 | ROT | 3 | 1 | 1 | 6 | 0 |  |  |  | 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-12-11 00:00:00 | ROT1 | ROT | 3 | 2 | 1 | 6 | 1 |  |  |  | 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-12-18 00:00:00 | ROT1 | ROT | 3 | 3 | 1 | 6 | 2 |  |  |  | 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 | 06:00:00 | 14:00:00 | OFF | OFF
2011-12-25 00:00:00 | ROT1 | ROT | 3 | 4 | 1 | 6 | 3 |  |  |  | 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 | 06:00:00 | 14:00:00 | OFF | OFF
 |  |  |  |  |  |  |  |  | Total Days Off |  | 9 |  | 9 |  | 9 |  | 9 |  | 8 |  | 8 |  | 52