Spreadsheet: 61811d1262728592-nested-ifs-sched-with-omm
Sheet: Schedule

Store: | Lancaster
Start Date: | 2009-12-20 00:00:00
End Date: | 2009-12-26 00:00:00
Week: | 52 |  |  |  |  |  |  |  |  |  | [NAME]
Day | Sun | Mon | Tue | Wed | Thu | Fri | Sat | WEEKLY TOTAL |  |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat
Date | 2009-12-20 00:00:00 | 2009-12-21 00:00:00 | 2009-12-22 00:00:00 | 2009-12-23 00:00:00 | 2009-12-24 00:00:00 | 2009-12-25 00:00:00 | 2009-12-26 00:00:00
Open | 11:00:00 | 10:00:00 | 10:00:00 | 10:00:00 | 10:00:00 | 10:00:00 | 10:00:00
Close | 17:00:00 | 20:00:00 | 20:00:00 | 20:00:00 | 17:00:00 | 20:00:00 | 20:00:00
Sales Goals | 779 | 1344 | 1381 | 614 | 577 | 0 | 819 | 5514
% of Week | 0.1412767500906783 | 0.2437431991294886 | 0.2504533913674284 | 0.1113529198404062 | 0.1046427276024664 | 0 | 0.1485310119695321
 |  |  |  |  |  | xmas
[NAME] |  | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 |  |  | 32.5 |  |  | 0 | 1 | 1 | 1 | 1 | 0 | 0
 |  | 17:00:00 | 17:00:00 | 17:00:00 | 17:30:00 |  |  |  |  |  | 0 | 1 | 1 | 1 | 1 | 0 | 0
 | 0 | 8 | 8 | 8 | 8.5 | 0 | 0 |  |  |  | 0 | 1 | 1 | 1 | 1 | 0 | 0
 |  |  |  |  |  | xmas | r/o |  |  |  | 0 | 1 | 1 | 1 | 1 | 0 | 0
[NAME] | 10:30:00 |  | 12:00:00 | 12:00:00 |  |  | 11:00:00 | 33.5 |  |  | 1 | 1 | 2 | 2 | 1 | 0 | 1
 | 17:30:00 |  | 20:30:00 | 20:30:00 |  |  | 20:30:00 |  |  |  | 1 | 1 | 2 | 2 | 1 | 0 | 1
 | 6.999999999999999 | 0 | 8.5 | 8.5 | 0 | 0 | 9.5 |  |  |  | 1 | 1 | 2 | 2 | 1 | 0 | 1
 |  |  |  |  |  | xmas |  |  |  |  | 1 | 1 | 2 | 2 | 1 | 0 | 1
[NAME] |  | 15:00:00 |  | 15:00:00 |  |  | 09:00:00 | 17 |  |  | 1 | 2 | 2 | 3 | 1 | 0 | 2
 |  | 20:30:00 |  | 20:30:00 |  |  | 15:00:00 |  |  |  | 1 | 2 | 2 | 3 | 1 | 0 | 2
 | 0 | 5.499999999999999 | 0 | 5.499999999999999 | 0 | 0 | 6 |  |  |  | 1 | 2 | 2 | 3 | 1 | 0 | 2
 |  |  |  |  |  | xmas |  |  |  |  | 1 | 2 | 2 | 3 | 1 | 0 | 2
Natasha | 11:00:00 |  |  |  |  |  | 09:30:00 | 12 |  |  | 2 | 2 | 2 | 3 | 1 | 0 | 3
 | 17:30:00 |  |  |  |  |  | 15:00:00 |  |  |  | 2 | 2 | 2 | 3 | 1 | 0 | 3
 | 6.5 | 0 | 0 | 0 | 0 | 0 | 5.5 |  |  |  | 2 | 2 | 2 | 3 | 1 | 0 | 3
 |  |  |  |  |  | xmas |  |  |  |  | 2 | 2 | 2 | 3 | 1 | 0 | 3
[NAME] |  | 15:00:00 | 15:00:00 |  |  |  | 15:00:00 | 16.5 |  |  | 2 | 3 | 3 | 3 | 1 | 0 | 4
 |  | 20:30:00 | 20:30:00 |  |  |  | 20:30:00 |  |  |  | 2 | 3 | 3 | 3 | 1 | 0 | 4
 | 0 | 5.499999999999999 | 5.499999999999999 | 0 | 0 | 0 | 5.499999999999999 |  |  |  | 2 | 3 | 3 | 3 | 1 | 0 | 4
 | r/o |  |  |  | r/o | xmas |  |  |  |  | 2 | 3 | 3 | 3 | 1 | 0 | 4
[NAME] |  |  |  |  |  |  |  | 0 |  |  | 2 | 3 | 3 | 3 | 1 | 0 | 4
 |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 3 | 3 | 1 | 0 | 4
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 2 | 3 | 3 | 3 | 1 | 0 | 4
 | n | n | n | n | n | xmas | n |  |  |  | 2 | 3 | 3 | 3 | 1 | 0 | 4
[NAME] | 12:00:00 | 09:30:00 | 09:30:00 |  |  |  | 11:00:00 | 20 |  |  | 3 | 4 | 4 | 3 | 1 | 0 | 5
 | 16:00:00 | 15:00:00 | 15:00:00 |  |  |  | 16:00:00 |  |  |  | 3 | 4 | 4 | 3 | 1 | 0 | 5
 | 3.999999999999999 | 5.5 | 5.5 | 0 | 0 | 0 | 5 |  |  |  | 3 | 4 | 4 | 3 | 1 | 0 | 5
 |  |  |  |  | r/o | xmas |  |  |  |  | 3 | 4 | 4 | 3 | 1 | 0 | 5
[NAME] |  |  |  | 09:30:00 | 09:30:00 |  |  | 13.5 |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
 |  |  |  | 15:00:00 | 17:30:00 |  |  |  |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
 | 0 | 0 | 0 | 5.5 | 8 | 0 | 0 |  |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
 |  |  |  |  |  | xmas |  |  |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
Name |  |  |  |  |  |  |  | 0 |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
 |  |  |  |  |  |  |  |  |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
 |  |  |  |  |  |  |  |  |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
Name |  |  |  |  |  |  |  | 0 |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
 |  |  |  |  |  |  |  |  |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
 |  |  |  |  |  |  |  |  |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
Name |  |  |  |  |  |  |  | 0 |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
 |  |  |  |  |  |  |  |  |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
 |  |  |  |  |  |  |  |  |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
Name |  |  |  |  |  |  |  | 0 |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
 |  |  |  |  |  |  |  |  |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
 |  |  |  |  |  |  |  |  |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
Name |  |  |  |  |  |  |  | 0 |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
 |  |  |  |  |  |  |  |  |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
 |  |  |  |  |  |  |  |  |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
Name |  |  |  |  |  |  |  | 0 |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
 |  |  |  |  |  |  |  |  |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
 |  |  |  |  |  |  |  |  |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
Name |  |  |  |  |  |  |  | 0 |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
 |  |  |  |  |  |  |  |  |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
 |  |  |  |  |  |  |  |  |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
Name |  |  |  |  |  |  |  | 0 |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
 |  |  |  |  |  |  |  |  |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 3 | 4 | 4 | 4 | 2 | 0 | 5
Daily Total | 17.5 | 24.5 | 27.5 | 27.5 | 16.5 | 0 | 31.5 | 145
Hours Open | 7 | 9 | 9 | 9 | 9 | 11 | 11
Training Hours | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Actual Hours | 17.5 | 24.5 | 27.5 | 27.5 | 16.5 | 0 | 31.5 | 145
SH/OH | 2.5 | 2.722222222222222 | 3.055555555555555 | 3.055555555555555 | 1.833333333333333 | 0 | 2.863636363636364 | 16.03030303030303
% of Hours | 0.1559546313799622 | 0.1698172652804033 | 0.1906112161310649 | 0.1906112161310649 | 0.1143667296786389 | 0 | 0.1786389413988658
Morning:
Mid:
Close: