#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,346
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Text Box Rotation Garyw Excel Discussion (Misc queries) 11 February 9th 10 05:09 AM
Text rotation in Excel2007 Don Excel Discussion (Misc queries) 1 November 13th 08 02:42 AM
Chart Rotation GatorGirl Charts and Charting in Excel 8 March 20th 07 02:46 AM
How do I set up a euchre rotation schedule Mark Schweitzer Excel Worksheet Functions 0 March 26th 06 11:51 PM
Schedule Rotation Question Bob Excel Worksheet Functions 4 November 24th 04 07:54 AM


All times are GMT +1. The time now is 10:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"