Spreadsheet: 692634d1598470513-formula-to-evaluate-two-criteria-and-pull-data-if-both-met-scheduling-dummy-file
Sheet: Scheduling INPUT

Start Date of Week (Sunday) |  | 2020-08-02 00:00:00 |  |  |  |  |  |  |  |  |  | Census: | 121-140 |  | Enter Average Deliveries Per Meal Period
Role | Shift Start | Shift End | Scheduled Break | Hours Per Shift | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Scheduled Hours | Budgeted Hours | [NAME]
AM Server 1 | 07:20:00 | 13:20:00 | 0.5 |  | Crystal |  |  |  |  |  |  |  |  |  |  |  | AM
Drink Delivery | 07:30:00 | 09:30:00 | 0 |  |  |  |  |  | Apiya |  |  |  |  |  |  |  | AM
AM Server 3 | 07:00:00 | 08:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | AM
Train Breakfast | 07:00:00 | 10:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | AM
Meal Delivery | 07:00:00 | 09:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  | Breakfast |  | AM
Meal Delivery | 07:00:00 | 09:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | AM
Lead Server Sat | 11:00:00 | 19:30:00 | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Noon Serv 1 | 11:30:00 | 14:00:00 | 0 |  |  |  |  |  | Apiya |  |  |  |  |  |  |  | MID
Noon Serv 2 Sun | 11:00:00 | 14:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Noon Serv 3 Sun | 11:15:00 | 14:15:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Noon Serv 4 Sun | 11:30:00 | 14:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Noon Serv 5 Sun | 11:30:00 | 14:30:00 | 0 |  |  |  | Apiya |  |  |  |  |  |  |  |  |  | MID
Noon Serv 6 Sun | 11:30:00 | 14:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Meal Delivery | 10:30:00 | 13:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Meal Delivery | 10:30:00 | 13:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  | Lunch |  | MID
Meal Delivery | 10:30:00 | 13:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Event | 13:00:00 | 14:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Train Lunch | 11:00:00 | 14:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Train Lunch | 11:30:00 | 14:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
[NAME] | 14:30:00 | 19:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Eve Serv 1 | 16:45:00 | 18:45:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
[NAME] | 17:00:00 | 19:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Eve Serv 3 | 17:30:00 | 19:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
[NAME] | 17:10:00 | 19:10:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Eve Serv 5 | 17:30:00 | 19:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Eve Serv 6 | 17:30:00 | 19:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Eve Serv 7 | 16:30:00 | 19:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Meal Delivery | 16:30:00 | 19:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Meal Delivery | 16:30:00 | 19:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  | Dinner |  | PM
Meal Delivery | 16:30:00 | 19:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Wine & Dine Event | 15:00:00 | 17:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Bday Dinner Event | 16:45:00 | 19:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Train Dinner | 16:00:00 | 19:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Train Dinner | 17:00:00 | 19:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Start Date of Week (Sunday)
Role | Shift Start | Shift End | Scheduled Break | Hours Per Shift | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Scheduled Hours | Budgeted Hours | [NAME]
AM Server 1 | 07:30:00 | 13:30:00 | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  | AM
AM Server 2 | 07:30:00 | 09:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | AM
AM Server 3 | 07:00:00 | 08:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | AM
Train Breakfast | 07:00:00 | 09:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | AM
Meal Delivery | 07:00:00 | 09:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  | Breakfast |  | AM
Meal Delivery | 07:00:00 | 09:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | AM
Lead Server Sat | 11:00:00 | 19:30:00 | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Noon Serv 1 | 11:30:00 | 14:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Noon Serv 2 Sun | 11:00:00 | 14:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Noon Serv 3 Sun | 11:15:00 | 14:15:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Noon Serv 4 Sun | 11:30:00 | 14:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Noon Serv 5 Sun | 11:30:00 | 14:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Noon Serv 6 Sun | 11:30:00 | 14:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Meal Delivery | 10:30:00 | 13:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Meal Delivery | 10:30:00 | 13:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  | Lunch |  | MID
Meal Delivery | 10:30:00 | 13:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Event | 13:00:00 | 14:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Train Lunch | 11:00:00 | 14:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Train Lunch | 11:30:00 | 14:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
[NAME] | 14:30:00 | 19:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Eve Serv 1 | 16:45:00 | 18:45:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
[NAME] | 17:00:00 | 19:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Eve Serv 3 | 17:30:00 | 19:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
[NAME] | 17:10:00 | 19:10:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Eve Serv 5 | 17:30:00 | 19:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Eve Serv 6 | 17:30:00 | 19:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Eve Serv 7 | 16:30:00 | 19:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Meal Delivery | 16:30:00 | 19:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Meal Delivery | 16:30:00 | 19:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  | Dinner |  | PM
Meal Delivery | 16:30:00 | 19:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Wine & Dine Event | 15:00:00 | 17:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Bday Dinner Event | 16:45:00 | 19:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Train Dinner | 16:00:00 | 19:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Train Dinner | 17:00:00 | 19:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Start Date of Week (Sunday)
Role | Shift Start | Shift End | Scheduled Break | Hours per Day | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Scheduled Hours | Budgeted Hours | [NAME]
AM Server 1 | 07:30:00 | 13:30:00 | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  | AM
AM Server 2 | 07:30:00 | 09:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | AM
AM Server 3 | 07:00:00 | 08:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | AM
Train Breakfast | 07:00:00 | 09:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | AM
Meal Delivery | 07:00:00 | 09:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  | Breakfast |  | AM
Meal Delivery | 07:00:00 | 09:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | AM
Lead Server Sat | 11:00:00 | 19:30:00 | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Noon Serv 1 | 11:30:00 | 14:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Noon Serv 2 Sun | 11:00:00 | 14:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Noon Serv 3 Sun | 11:15:00 | 14:15:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Noon Serv 4 Sun | 11:30:00 | 14:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Noon Serv 5 Sun | 11:30:00 | 14:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Noon Serv 6 Sun | 11:30:00 | 14:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Meal Delivery | 10:30:00 | 13:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Meal Delivery | 10:30:00 | 13:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  | Lunch |  | MID
Meal Delivery | 10:30:00 | 13:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Event | 13:00:00 | 14:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Train Lunch | 11:00:00 | 14:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Train Lunch | 11:30:00 | 14:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
[NAME] | 14:30:00 | 19:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Eve Serv 1 | 16:45:00 | 18:45:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
[NAME] | 17:00:00 | 19:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Eve Serv 3 | 17:30:00 | 19:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
[NAME] | 17:10:00 | 19:10:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Eve Serv 5 | 17:30:00 | 19:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Eve Serv 6 | 17:30:00 | 19:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Eve Serv 7 | 16:30:00 | 19:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Meal Delivery | 16:30:00 | 19:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Meal Delivery | 16:30:00 | 19:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  | Dinner |  | PM
Meal Delivery | 16:30:00 | 19:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Wine & Dine Event | 15:00:00 | 17:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Bday Dinner Event | 16:45:00 | 19:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Train Dinner | 16:00:00 | 19:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Train Dinner | 17:00:00 | 19:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Start Date of Week (Sunday)
Role | Shift Start | Shift End | Scheduled Break | Hours per Day | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Scheduled Hours | Budgeted Hours | [NAME]
AM Server 1 | 07:30:00 | 13:30:00 | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  | AM
AM Server 2 | 07:30:00 | 09:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | AM
AM Server 3 | 07:00:00 | 08:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | AM
Train Breakfast | 07:00:00 | 09:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | AM
Meal Delivery | 07:00:00 | 09:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  | Breakfast |  | AM
Meal Delivery | 07:00:00 | 09:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | AM
Lead Server Sat | 11:00:00 | 19:30:00 | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Noon Serv 1 | 11:30:00 | 14:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Noon Serv 2 Sun | 11:00:00 | 14:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Noon Serv 3 Sun | 11:15:00 | 14:15:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Noon Serv 4 Sun | 11:30:00 | 14:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Noon Serv 5 Sun | 11:30:00 | 14:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Noon Serv 6 Sun | 11:30:00 | 14:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Meal Delivery | 10:30:00 | 13:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Meal Delivery | 10:30:00 | 13:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  | Lunch |  | MID
Meal Delivery | 10:30:00 | 13:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Event | 13:00:00 | 14:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Train Lunch | 11:00:00 | 14:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
Train Lunch | 11:30:00 | 14:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MID
[NAME] | 14:30:00 | 19:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Eve Serv 1 | 16:45:00 | 18:45:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
[NAME] | 17:00:00 | 19:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Eve Serv 3 | 17:30:00 | 19:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
[NAME] | 17:10:00 | 19:10:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Eve Serv 5 | 17:30:00 | 19:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Eve Serv 6 | 17:30:00 | 19:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Eve Serv 7 | 16:30:00 | 19:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Meal Delivery | 16:30:00 | 19:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Meal Delivery | 16:30:00 | 19:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  | Dinner |  | PM
Meal Delivery | 16:30:00 | 19:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Wine & Dine Event | 15:00:00 | 17:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Bday Dinner Event | 16:45:00 | 19:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Train Dinner | 16:00:00 | 19:30:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Train Dinner | 17:00:00 | 19:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | PM