FanofExcel18
Board Regular
- Joined
- Jun 7, 2018
- Messages
- 65
Ok this one, in my mind is complex. I'm hoping someone can tell me I'm wrong.
Scenario:
Creating a weekly schedule breaking out each Day as its own sheet with at least 30 users listed.
Breakdown:
1. Each sheet has 15 min increments for scheduling
2. Each cell within those 15 min increments has a letter associated to it
3. Each letter signify's something that needs to be read
4. Timeframe is 24 hour days
What I am trying to do:
1. I used Data Validation to make a listing of names for those on the schedule
2. I've made a simple table, each line is a day representing that tab
3. I would like to provide a simple view to those scheduled
4. The below table can be changed
<colgroup><col><col><col><col span="2"></colgroup><tbody>
</tbody>
Problems:
1. Those letter's above under breakdown (3), they signify the start/end times for coverage.
1a. They could have breaks in between those times. Example: Shift is 8am-430pm, Letter A is in cells corresponding to 8:00 AM to 10:15 AM and 2:00 PM to 3:30 PM. I want to show the start and end times for each breakdown
<colgroup><col><col span="35"></colgroup><tbody>
</tbody>
Scenario:
Creating a weekly schedule breaking out each Day as its own sheet with at least 30 users listed.
Breakdown:
1. Each sheet has 15 min increments for scheduling
2. Each cell within those 15 min increments has a letter associated to it
3. Each letter signify's something that needs to be read
4. Timeframe is 24 hour days
What I am trying to do:
1. I used Data Validation to make a listing of names for those on the schedule
2. I've made a simple table, each line is a day representing that tab
3. I would like to provide a simple view to those scheduled
4. The below table can be changed
| Day | Date | Phones | Lunch | Meetings |
| Monday | 8/6/2018 | |||
| Tuesday | 8/7/2018 | |||
| Wednesday | 8/8/2018 | |||
| Thursday | 8/9/2018 | |||
| Friday | 8/10/2018 | |||
| Saturday | 8/11/2018 | |||
| Sunday | 8/12/2018 |
<colgroup><col><col><col><col span="2"></colgroup><tbody>
</tbody>
Problems:
1. Those letter's above under breakdown (3), they signify the start/end times for coverage.
1a. They could have breaks in between those times. Example: Shift is 8am-430pm, Letter A is in cells corresponding to 8:00 AM to 10:15 AM and 2:00 PM to 3:30 PM. I want to show the start and end times for each breakdown
| Person | 8:00 AM | 8:15 AM | 8:30 AM | 8:45 AM | 9:00 AM | 9:15 AM | 9:30 AM | 9:45 AM | 10:00 AM | 10:15 AM | 10:30 AM | 10:45 AM | 11:00 AM | 11:15 AM | 11:30 AM | 11:45 AM | 12:00 PM | 12:15 PM | 12:30 PM | 12:45 PM | 1:00 PM | 1:15 PM | 1:30 PM | 1:45 PM | 2:00 PM | 2:15 PM | 2:30 PM | 2:45 PM | 3:00 PM | 3:15 PM | 3:30 PM | 3:45 PM | 4:00 PM | 4:15 PM | 4:30 PM |
| John Smith | A | A | A | A | A | A | A | A | A | L | L | L | L | A | A | A | A | A | A | ||||||||||||||||
| Jane Smith | B | B | B | B | B | B | B | B | B | M | M | L | L | L | L | D | D | D | D | D | D | D | D |
<colgroup><col><col span="35"></colgroup><tbody>
</tbody>
