Spreadsheet: 153258d1335831411-weird-re-appearing-formula-shift-multipliers
Sheet: Sheet1

 |  |  | Mulitiplier
Day | Date | Shift | 1 | 1.5 | 1.9 | 2 |  |  |  |  |  |  |  |  | Shifts | Hours | Book
Sat | 2012-04-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | E | 06:00-13:30 | 7
Sun | 2012-04-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | L | 13:10-20:40 | 7
Mon | 2012-04-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | N | 20:15-06:15 | 9.5
Tue | 2012-04-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6N | 20:00-02:00 | 6
Wed | 2012-04-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6D | 06:00-12:00 | 6
Thu | 2012-04-26 00:00:00
Fri | 2012-04-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:00-06:30 | 06:30-18:30 | 18:30-01:00
Sat | 2012-04-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | Mon | 1.9 | 1 | 1.9
Sun | 2012-04-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | Tue | 1.9 | 1 | 1.9
Mon | 2012-04-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | Wed | 1.9 | 1 | 1.9
Tue | 2012-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | Thu | 1.9 | 1 | 1.9
Wed | 2012-05-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | Fri | 2 | 1 | 2
Thu | 2012-05-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | Sat | 2 | 1.5 | 2
Fri | 2012-05-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | Sun | 1.9 | 2 | 2
Sat | 2012-05-05 00:00:00
Sun | 2012-05-06 00:00:00
Mon | 2012-05-07 00:00:00
Tue | 2012-05-08 00:00:00
Wed | 2012-05-09 00:00:00
Thu | 2012-05-10 00:00:00
Fri | 2012-05-11 00:00:00
Sat | 2012-05-12 00:00:00
Sun | 2012-05-13 00:00:00
Mon | 2012-05-14 00:00:00
Tue | 2012-05-15 00:00:00
Wed | 2012-05-16 00:00:00
Thu | 2012-05-17 00:00:00
Fri | 2012-05-18 00:00:00
Sat | 2012-05-19 00:00:00
Sun | 2012-05-20 00:00:00
Mon | 2012-05-21 00:00:00
Tue | 2012-05-22 00:00:00
Wed | 2012-05-23 00:00:00
Thu | 2012-05-24 00:00:00
Fri | 2012-05-25 00:00:00
Sat | 2012-05-26 00:00:00
Sun | 2012-05-27 00:00:00
Mon | 2012-05-28 00:00:00
Tue | 2012-05-29 00:00:00
Wed | 2012-05-30 00:00:00
Thu | 2012-05-31 00:00:00
Fri | 2012-06-01 00:00:00
Sat | 2012-06-02 00:00:00
Sun | 2012-06-03 00:00:00
Mon | 2012-06-04 00:00:00
Tue | 2012-06-05 00:00:00
Wed | 2012-06-06 00:00:00
Thu | 2012-06-07 00:00:00
Fri | 2012-06-08 00:00:00
Sat | 2012-06-09 00:00:00
Sun | 2012-06-10 00:00:00
Mon | 2012-06-11 00:00:00
Tue | 2012-06-12 00:00:00
Wed | 2012-06-13 00:00:00
Thu | 2012-06-14 00:00:00
Fri | 2012-06-15 00:00:00
Sat | 2012-06-16 00:00:00
Sun | 2012-06-17 00:00:00
Mon | 2012-06-18 00:00:00
Tue | 2012-06-19 00:00:00
Wed | 2012-06-20 00:00:00
Thu | 2012-06-21 00:00:00
Fri | 2012-06-22 00:00:00
Sat | 2012-06-23 00:00:00
Sun | 2012-06-24 00:00:00
Mon | 2012-06-25 00:00:00
Tue | 2012-06-26 00:00:00
Wed | 2012-06-27 00:00:00
Thu | 2012-06-28 00:00:00
Fri | 2012-06-29 00:00:00
Sat | 2012-06-30 00:00:00
Sun | 2012-07-01 00:00:00
Mon | 2012-07-02 00:00:00
Tue | 2012-07-03 00:00:00
Wed | 2012-07-04 00:00:00
Thu | 2012-07-05 00:00:00
Fri | 2012-07-06 00:00:00
Sat | 2012-07-07 00:00:00
Sun | 2012-07-08 00:00:00
Mon | 2012-07-09 00:00:00
Tue | 2012-07-10 00:00:00
Wed | 2012-07-11 00:00:00
Thu | 2012-07-12 00:00:00
Fri | 2012-07-13 00:00:00
Sat | 2012-07-14 00:00:00
Sun | 2012-07-15 00:00:00
Mon | 2012-07-16 00:00:00
Tue | 2012-07-17 00:00:00
Wed | 2012-07-18 00:00:00
Thu | 2012-07-19 00:00:00
Fri | 2012-07-20 00:00:00
Sat | 2012-07-21 00:00:00
Sun | 2012-07-22 00:00:00
Mon | 2012-07-23 00:00:00
Tue | 2012-07-24 00:00:00
Wed | 2012-07-25 00:00:00
Thu | 2012-07-26 00:00:00
Fri | 2012-07-27 00:00:00