Hi
Could someone advice on any excel functions I could use that would help in designing a shift rota, any help with this would be greatly appreciated.
Thanks
Toddp2
Hi
Could someone advice on any excel functions I could use that would help in designing a shift rota, any help with this would be greatly appreciated.
Thanks
Toddp2
In Excel 2003 to 2010 there is a folder named "Samples"(a subfolder in the Office folder). In this folder there is a file "SOLVSAMP.XLS". Open this file and click tab "Staff Scheduling". There you will find an example on how to use the excel add-in Solver for staff scheduling.
Be warned that the solver included in excel is not that powerful (by design) so the number of persons and the number of weeks will be limited.
Alf
Last edited by Alf; 02-20-2018 at 09:42 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks