Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Job Rotation app?
I run a warehouse of 900+ staff, there are 7 functions/jobs that they do,
they have a mix of skills (some have all skills, some have only 1 or 2) I need an application, either excel or access based that will ensure that each person gets a fair share of the easier jobs. Does anyone know of an application that does this already? Or a developer/software house based in Uk who can provide this? This question is very simplistic. If you think you might know of a package/Developer who could provide this but would need further info, please respond and I'll send more details... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Job Rotation app?
Hi,
There is a feature in Excel called Solver which can be set up to address these types of problems. How difficult this is I don't know. However, there is a sample file on how to use solver which is installed when you install Excel, it includes an example sheet called Staff Scheduling. The file name is SOLVSAMP.XLS. It is usually found in C:\Program Files\Microsoft Office 12\Samples -- If this helps, please click the Yes button. Cheers, Shane Devenshire "PPM at Brackmills" wrote: I run a warehouse of 900+ staff, there are 7 functions/jobs that they do, they have a mix of skills (some have all skills, some have only 1 or 2) I need an application, either excel or access based that will ensure that each person gets a fair share of the easier jobs. Does anyone know of an application that does this already? Or a developer/software house based in Uk who can provide this? This question is very simplistic. If you think you might know of a package/Developer who could provide this but would need further info, please respond and I'll send more details... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text Box Rotation | Excel Discussion (Misc queries) | |||
Text rotation in Excel2007 | Excel Discussion (Misc queries) | |||
Chart Rotation | Charts and Charting in Excel | |||
How do I set up a euchre rotation schedule | Excel Worksheet Functions | |||
Schedule Rotation Question | Excel Worksheet Functions |