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

Labor Model Snapshots |  |  |  |  | Census = # of Rented Apartments and Budget Hours
Role | Shift Start | Shift End | Scheduled Break | Hours Per Day | 0-20 | 21-40 | 41-60 | 61-80 | 81-100 | 101-120 | 121-140 | 141-160
AM Server 1 | 07:30:00 | 13:30:00 | 0.5 |  | 33 | 33 | 33 | 38.5 | 38.5 | 38.5 | 38.5 | 38.5 |  |  |  |  |  |  | 3
AM Server 2 | 07:30:00 | 09:30:00 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | 4
Train Breakfast | 07:00:00 | 08:30:00 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | 5
Meal Delivery | 07:00:00 | 08:30:00 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | 6
Meal Delivery | 07:00:00 | 08:30:00 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | 7
Meal Delivery | 07:00:00 | 09:30:00 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | 8
Lead Server Sat | 11:00:00 | 19:30:00 | 0.5 |  | 0 | 0 | 0 | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  | 9
Noon Serv 1 | 11:30:00 | 14:00:00 | 0 |  | 3 | 3 | 3 | 0 | 0 | 12.5 | 12.5 | 12.5 |  |  |  |  |  |  | 10
Noon Serv 2 Sun | 11:00:00 | 14:00:00 | 0 |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 |  |  |  |  |  |  | 11
Noon Serv 3 Sun | 11:15:00 | 14:15:00 | 0 |  | 0 | 0 | 0 | 3 | 3 | 3 | 3 | 3 |  |  |  |  |  |  | 12
Noon Serv 4 Sun | 11:30:00 | 14:30:00 | 0 |  | 0 | 0 | 0 | 0 | 3 | 3 | 3 | 3 |  |  |  |  |  |  | 13
Noon Serv 5 Sun | 11:30:00 | 14:30:00 | 0 |  | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 3 |  |  |  |  |  |  | 14
Noon Serv 6 Sun | 11:30:00 | 14:30:00 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 |  |  |  |  |  |  | 15
Meal Delivery | 10:30:00 | 13:00:00 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | 16
Meal Delivery | 10:30:00 | 13:00:00 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | 17
Meal Delivery | 10:30:00 | 13:00:00 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | 18
Ice Cream Social | 13:00:00 | 14:30:00 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | 19
Train Lunch | 11:00:00 | 14:30:00 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | 20
Train Lunch | 11:30:00 | 14:00:00 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | 21
[NAME] | 14:30:00 | 19:00:00 | 0 |  | 0 | 0 | 0 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 |  |  |  |  |  |  | 22
Eve Serv 1 | 16:45:00 | 18:45:00 | 0 |  | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 |  |  |  |  |  |  | 23
[NAME] | 17:00:00 | 19:00:00 | 0 |  | 0 | 14 | 14 | 14 | 14 | 14 | 14 | 14 |  |  |  |  |  |  | 24
Eve Serv 3 | 17:30:00 | 19:30:00 | 0 |  | 0 | 0 | 14 | 12 | 12 | 12 | 12 | 14 |  |  |  |  |  |  | 25
[NAME] | 17:10:00 | 19:10:00 | 0 |  | 0 | 0 | 0 | 0 | 10 | 10 | 10 | 12 |  |  |  |  |  |  | 26
Eve Serv 5 | 17:30:00 | 19:30:00 | 0 |  | 0 | 0 | 0 | 0 | 0 | 10 | 12 | 12 |  |  |  |  |  |  | 27
Eve Serv 6 | 17:30:00 | 19:30:00 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 10 |  |  |  |  |  |  | 28
Eve Serv 7 | 16:30:00 | 19:00:00 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | 29
Meal Delivery | 16:30:00 | 19:00:00 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | 30
Meal Delivery | 16:30:00 | 19:00:00 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | 31
Meal Delivery | 16:30:00 | 19:00:00 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | 32
Wine & Dine Event | 15:00:00 | 17:00:00 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | 33
Bday Dinner Event | 16:45:00 | 19:00:00 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | 34
Train Dinner | 16:00:00 | 19:30:00 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | 35
Train Dinner | 17:00:00 | 19:00:00 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37
TOTAL BUDGETED HOURS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38
V 08.2020
a | b | c | d | e | f | g | h | i | j | k | l | m