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
[TABLE="width: 438"]
<colgroup><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD]Day[/TD]
[TD]Date[/TD]
[TD]Phones[/TD]
[TD]Lunch[/TD]
[TD]Meetings[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD="align: right"]8/6/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Tuesday[/TD]
[TD="align: right"]8/7/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Wednesday[/TD]
[TD="align: right"]8/8/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Thursday[/TD]
[TD="align: right"]8/9/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Friday[/TD]
[TD="align: right"]8/10/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Saturday[/TD]
[TD="align: right"]8/11/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Sunday[/TD]
[TD="align: right"]8/12/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
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
[TABLE="width: 2321"]
<colgroup><col><col span="35"></colgroup><tbody>[TR]
[TD]Person[/TD]
[TD]8:00 AM[/TD]
[TD]8:15 AM[/TD]
[TD]8:30 AM[/TD]
[TD]8:45 AM[/TD]
[TD]9:00 AM[/TD]
[TD]9:15 AM[/TD]
[TD]9:30 AM[/TD]
[TD]9:45 AM[/TD]
[TD]10:00 AM[/TD]
[TD]10:15 AM[/TD]
[TD]10:30 AM[/TD]
[TD]10:45 AM[/TD]
[TD]11:00 AM[/TD]
[TD]11:15 AM[/TD]
[TD]11:30 AM[/TD]
[TD]11:45 AM[/TD]
[TD]12:00 PM[/TD]
[TD]12:15 PM[/TD]
[TD]12:30 PM[/TD]
[TD]12:45 PM[/TD]
[TD]1:00 PM[/TD]
[TD]1:15 PM[/TD]
[TD]1:30 PM[/TD]
[TD]1:45 PM[/TD]
[TD]2:00 PM[/TD]
[TD]2:15 PM[/TD]
[TD]2:30 PM[/TD]
[TD]2:45 PM[/TD]
[TD]3:00 PM[/TD]
[TD]3:15 PM[/TD]
[TD]3:30 PM[/TD]
[TD]3:45 PM[/TD]
[TD]4:00 PM[/TD]
[TD]4:15 PM[/TD]
[TD]4:30 PM[/TD]
[/TR]
[TR]
[TD]John Smith[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]L[/TD]
[TD]L[/TD]
[TD]L[/TD]
[TD]L[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Jane Smith[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD] [/TD]
[TD]M[/TD]
[TD]M[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]L[/TD]
[TD]L[/TD]
[TD]L[/TD]
[TD]L[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
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
[TABLE="width: 438"]
<colgroup><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD]Day[/TD]
[TD]Date[/TD]
[TD]Phones[/TD]
[TD]Lunch[/TD]
[TD]Meetings[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD="align: right"]8/6/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Tuesday[/TD]
[TD="align: right"]8/7/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Wednesday[/TD]
[TD="align: right"]8/8/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Thursday[/TD]
[TD="align: right"]8/9/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Friday[/TD]
[TD="align: right"]8/10/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Saturday[/TD]
[TD="align: right"]8/11/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Sunday[/TD]
[TD="align: right"]8/12/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
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
[TABLE="width: 2321"]
<colgroup><col><col span="35"></colgroup><tbody>[TR]
[TD]Person[/TD]
[TD]8:00 AM[/TD]
[TD]8:15 AM[/TD]
[TD]8:30 AM[/TD]
[TD]8:45 AM[/TD]
[TD]9:00 AM[/TD]
[TD]9:15 AM[/TD]
[TD]9:30 AM[/TD]
[TD]9:45 AM[/TD]
[TD]10:00 AM[/TD]
[TD]10:15 AM[/TD]
[TD]10:30 AM[/TD]
[TD]10:45 AM[/TD]
[TD]11:00 AM[/TD]
[TD]11:15 AM[/TD]
[TD]11:30 AM[/TD]
[TD]11:45 AM[/TD]
[TD]12:00 PM[/TD]
[TD]12:15 PM[/TD]
[TD]12:30 PM[/TD]
[TD]12:45 PM[/TD]
[TD]1:00 PM[/TD]
[TD]1:15 PM[/TD]
[TD]1:30 PM[/TD]
[TD]1:45 PM[/TD]
[TD]2:00 PM[/TD]
[TD]2:15 PM[/TD]
[TD]2:30 PM[/TD]
[TD]2:45 PM[/TD]
[TD]3:00 PM[/TD]
[TD]3:15 PM[/TD]
[TD]3:30 PM[/TD]
[TD]3:45 PM[/TD]
[TD]4:00 PM[/TD]
[TD]4:15 PM[/TD]
[TD]4:30 PM[/TD]
[/TR]
[TR]
[TD]John Smith[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]L[/TD]
[TD]L[/TD]
[TD]L[/TD]
[TD]L[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Jane Smith[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD] [/TD]
[TD]M[/TD]
[TD]M[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]L[/TD]
[TD]L[/TD]
[TD]L[/TD]
[TD]L[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]