Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need a program to make a work shift schedule that is staggerered
Hey I have 7 Service Techs I have 24 Shifts available each week right now.
Is there a program, template or spreadsheet that will do this for me |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need a program to make a work shift schedule that is staggerered
Hi,
The tool to use for this is the Solver add-in. Microsoft has provided a file with Office to demonstrate how this complex tool is used. Its usually in the Samples folder of office but you can do a Windows search for "SOLVSAMP". Solver is an Add-in you will have to attach via Tools, Add-ins... -- If this helps, please click the Yes button Cheers, Shane Devenshire "AHammer623" wrote: Hey I have 7 Service Techs I have 24 Shifts available each week right now. Is there a program, template or spreadsheet that will do this for me |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need a program to make a work shift schedule that is staggerered
AHammer623 wrote:
Hey I have 7 Service Techs I have 24 Shifts available each week right now. Is there a program, template or spreadsheet that will do this for me Don't know about a template, but with more information maybe someone could help. How are your 24 shifts distributed during a week? Any "rules" that need to be followed, like not scheduling the same tech for 4 consecutive days? Anything you can think of could be helpful. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need a program to make a work shift schedule that is staggerer
"Glenn" wrote: AHammer623 wrote: Hey I have 7 Service Techs I have 24 Shifts available each week right now. Is there a program, template or spreadsheet that will do this for me Don't know about a template, but with more information maybe someone could help. How are your 24 shifts distributed during a week? Any "rules" that need to be followed, like not scheduling the same tech for 4 consecutive days? Anything you can think of could be helpful. I was also looking for something similar. I work a 10-day shift pattern. I work an early shift on days 1&2, then an afternoon shift on 3&4, then night shift on 5&6 - followed by days off. Then it goes back to early shifts on day 11. Is there software, that can tell me when my days on, and days off are, for as long as I wish to know for? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using check boxes to make a shift schedule in excel | Excel Discussion (Misc queries) | |||
how do i create a work shift schedule | Excel Discussion (Misc queries) | |||
Shift Schedule Spreadsheet | Excel Discussion (Misc queries) | |||
Program for assigning work shift hours | Excel Discussion (Misc queries) | |||
monthly one shift work schedule | New Users to Excel |