Page 1 of 1
Are there any incredible clever peeps on here?
Posted: Thu Dec 11, 2008 11:37 pm
by BikerGran
Ha, that got your attention!
I'm looking for someone who knows how to work out a rotating shift pattern for an office of 8 people!
Was trying to help my boss do it the other day and I feel there must be a better way! Does anyone know of a program that does it for you?
Posted: Fri Dec 12, 2008 12:25 am
by Samray
I happened across a template for just that sorta thing t'other day.
Woulda been MS and prolly Excel.
Cant even remember what I was looking for at the time.
Not a lot of help am I?
Posted: Fri Dec 12, 2008 12:48 am
by BikerGran
Erm, the template is the least of our problems!
It's working out the pattern that's the problem!
Acksherly, I've just been summarising what we need for someone else, and I'm not sure it can be done - think we have a 'bums on seats' problem - think my boss has taken on too many bums for the number of seats!
Posted: Fri Dec 12, 2008 2:17 pm
by joecrx
thats easy draw a vertical line , put everybodys name down the line draw a horizontal line and put the days / weeks etc and now draw a diagonal line from the top left to bottom right , you now pick a name scroll across untill it hits diag. line scroll down till it hits that day , and thats when their shift starts , works fo me
Posted: Fri Dec 12, 2008 3:47 pm
by BikerGran
Yeah Joe - it's working out the pattern that's the difficult bit - fitting people into it is even simpler than your way of doing it!
Posted: Fri Dec 12, 2008 4:02 pm
by Aladinsaneuk
give a blank rota to the people themselves and ask what they would like to do pattern wise
then put in the replies into a new sheet - then see what shortfalls you have and who needs to be moved etc
worked for me when i ran my own units
Posted: Fri Dec 12, 2008 5:36 pm
by Kwackerz
I dont believe they get a choice!?
Make a Rota. Do it with no favouritism and ignore what the Day is (They all end in Y.) Tell them if they need to change, they are responsible for finding a replacement and for that replacement turning up. First one that whinges. Punch them.
Works fine for me
Posted: Fri Dec 12, 2008 6:37 pm
by joecrx
dont forget to add holidays , sick days, into the equation
Posted: Sat Dec 13, 2008 2:48 am
by D-Rider
Worrk out which are the favourite slots and auction them
Posted: Sun Dec 14, 2008 12:10 pm
by lazarus
how many shifts? do you need the same number of people on each shift? does it include weekends? how do you account for the missing hour (ie working 39 hours in a 40 hour week etc). do you have restrictions on women working night shifts?
let me know the answers and I will have a go.
Posted: Sun Dec 14, 2008 4:13 pm
by snapdragon
BG i sent you a pm - but looks like laz might have it covered for you already