Forum Discussion
Excel Shift Work Calendar Template editing
I would like to use the Shift Work Calendar Template in Excel, but it is only built for 3 jobs. I need to edit for 6 jobs, but can't figure out how to do it. I'm sure it's a simple solution, but I'm new to this.
If anyone can assist, it would be greatly appreciated.
I have attached the template I would like to use.
With such template it's a lot of manual work
- in Shift and Jobs copy one of jobs (e.g. #3) column into 3 new to the right
- define job data as needed
- check one by one which names are applied for the cells for job3 and apply similar for job4, etc. Copy/paste such names using name box on top left from the grid, just replace within them Job3 on Job4, etc.
- at the bottom of each month insert 3 empty rows
- copy/paste Job3 formula for the first date into first date for Job4
- replace within formula names with Job3 on names with Job4 and reference on cell C6 on reference on cell C6
- drag this cell to the right till end
- repeat for Job5, Job6
- repeat above for each month
- open Conditional Formatting box and adjust Apply To ranges; use F2 to edit within bar
In attached one job for one month is added
With such template it's a lot of manual work
- in Shift and Jobs copy one of jobs (e.g. #3) column into 3 new to the right
- define job data as needed
- check one by one which names are applied for the cells for job3 and apply similar for job4, etc. Copy/paste such names using name box on top left from the grid, just replace within them Job3 on Job4, etc.
- at the bottom of each month insert 3 empty rows
- copy/paste Job3 formula for the first date into first date for Job4
- replace within formula names with Job3 on names with Job4 and reference on cell C6 on reference on cell C6
- drag this cell to the right till end
- repeat for Job5, Job6
- repeat above for each month
- open Conditional Formatting box and adjust Apply To ranges; use F2 to edit within bar
In attached one job for one month is added
- Thanks for the help
NIcholas_Dube , glad to help
- SergeiBaklan
Is there a way to add a quarterly change in shift patterns?
I would like to see what the calendar would look like if I were to change the shifts from:
NNNNxxxxxDxxNNNxxDDxxxNNxDDxxx
to
MMxxxxMMxxxxMMMxxxMxxxxxxMMxxx
but on a quarterly basis.
- Using the Family Calendar excel template for Summer Activities for our family. Is there a way to include two different events occurring on the same day? Are dates only drawn form one line in the important dates sheet?
