Scheduling

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]
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Forum statistics

Threads
1,223,891
Messages
6,175,229
Members
452,621
Latest member
Laura_PinksBTHFT

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top