Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Page 1 of 2 1 2 LastLast
Results 1 to 10 of 11

Thread: Creating Work Rota

  1. #1
    Join Date
    4th August 2006
    Posts
    5

    Creating Work Rota

    I am a novice Excel user so please bear with me.

    Can anyone help me with my work rota.

    What i would like to do is, create a random weekly work rota, so I just have to go in every week and let excel randomly but fairly creat a rota the employees so that they don't argue about whose doing what and just get on with the work. : D

    Please see the attachment to see what i mean.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    9th June 2006
    Location
    The best city, in the best state, in the best country, in the known inhabited universe, Houston, TX
    Posts
    966

    Re: Creating Work Rota

    Really? The employees think complete random chance is better than schedules that rotate?

    Random means that Name1 could end up being the cashier four times in a week. Is that what you mean?

    Jim

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    17th May 2005
    Location
    St. Louis, MO
    Posts
    85

    Re: Creating Work Rota

    Here's my best shot at it...

    Experts, what can I code better?
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    4th August 2006
    Posts
    5

    Re: Creating Work Rota

    Quote Originally Posted by JimFuller1
    Really? The employees think complete random chance is better than schedules that rotate?

    Random means that Name1 could end up being the cashier four times in a week. Is that what you mean?

    Jim
    Yes they will be happier if they are not working with each other all the time as i have problems with NAME1 wants to be with NAME2, and complaints about favouritism etc.., so i can solve that problem with this random rotation so that they can't argue.

    No i don't mean that, can I not do it so that the percentages are the same, is that possible?

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    4th August 2006
    Posts
    5

    Re: Creating Work Rota

    Quote Originally Posted by Joebbshop
    Here's my best shot at it...

    Experts, what can I code better?
    Thanks Man

    Is there any way to get everyone doing tasks equally?

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,716

  7. #7
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,716

  8. #8
    Join Date
    9th June 2006
    Location
    The best city, in the best state, in the best country, in the known inhabited universe, Houston, TX
    Posts
    966

    Re: Creating Work Rota

    beater,

    Dave is right. At first you said you wanted a random schedule. Now you say not completely random - you want all names to get the same number of shifts at each position? It's becoming a policy question more than an Excel question (no offense). And your solution needs to include the people element not just some Excel code. Not to worry though. I've got plenty of opinions too.

    Opinion 1 - Pick the first name at random. Let them draw names from a hat or something so they can see it is random. The first name picked gets to choose from a set of fixed schedules. Pick the second name and let them pick a schedule, etc.

    Opinion 2 - Pick the first name at random. Let the first name picked pick a day of the week at random. The first person gets to pick what position to work on that day of the week. Pick the second name and let them fill in what position they want to work on the same day as the first person picked. Continue until the first day is completely scheduled. Repeat for the second day, etc.

    Opinion 3 - Fire the next person to walk into your office. Continue until they are afraid to talk to you so you don't have any more complainers. LOL. Just kidding.

    Well, this doesn't have much to do with Excel so, if Dave doesn't delete this and ban me, post back and let us know how it goes.

    Jim

    Excel Video Tutorials / Excel Dashboards Reports


  9. #9
    Join Date
    4th August 2006
    Posts
    5

    Re: Creating Work Rota

    Quote Originally Posted by JimFuller1
    beater,

    Dave is right. At first you said you wanted a random schedule. Now you say not completely random - you want all names to get the same number of shifts at each position? It's becoming a policy question more than an Excel question (no offense). And your solution needs to include the people element not just some Excel code. Not to worry though. I've got plenty of opinions too.

    Jim
    When i said random but fair i thought i was clear in what i wanted but still it's my fault i should've been more clear in what i wanted.

    Quote Originally Posted by JimFuller1
    beater,

    Opinion 1 - Pick the first name at random. Let them draw names from a hat or something so they can see it is random. The first name picked gets to choose from a set of fixed schedules. Pick the second name and let them pick a schedule, etc.

    Opinion 2 - Pick the first name at random. Let the first name picked pick a day of the week at random. The first person gets to pick what position to work on that day of the week. Pick the second name and let them fill in what position they want to work on the same day as the first person picked. Continue until the first day is completely scheduled. Repeat for the second day, etc.

    Opinion 3 - Fire the next person to walk into your office. Continue until they are afraid to talk to you so you don't have any more complainers. LOL. Just kidding.

    Well, this doesn't have much to do with Excel so, if Dave doesn't delete this and ban me, post back and let us know how it goes.

    Jim
    Thanks for your advice man I'll try that and lets see what happens heh

    Excel Video Tutorials / Excel Dashboards Reports


  10. #10
    Join Date
    4th August 2006
    Posts
    5

    Re: Creating Work Rota

    Quote Originally Posted by beater
    When i said random but fair i thought i was clear in what i wanted but still it's my fault i should've been more clear in what i wanted.
    Doesn't make sense sorry I meant it's my fault for not explaining clearly what exactly i wanted and no offence taken.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Calculate Work Rota Hours
    By skycom in forum EXCEL HELP
    Replies: 1
    Last Post: May 31st, 2007, 18:52
  2. Work Rota/Roster Calculating Hours
    By groceryuk in forum EXCEL HELP
    Replies: 7
    Last Post: December 7th, 2006, 06:14
  3. creating a spreadsheet for use as a duty rota
    By steve adams in forum EXCEL HELP
    Replies: 2
    Last Post: November 17th, 2005, 11:37
  4. Replies: 2
    Last Post: April 20th, 2005, 21:15
  5. Creating rota in excel - urgent help needed
    By webdw in forum EXCEL HELP
    Replies: 5
    Last Post: September 23rd, 2003, 23:22

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno