ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Need a program to make a work shift schedule that is staggerered (https://www.excelbanter.com/excel-worksheet-functions/221457-need-program-make-work-shift-schedule-staggerered.html)

AHammer623

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

Shane Devenshire[_2_]

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


Glenn

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.

mrwoodz511

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?


All times are GMT +1. The time now is 02:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com