Forum Discussion
Creating a Schedule That’s Filled From a List of Names
Hello Everyone,
I’m trying to create a schedule for work. I need 2-3 people per shift which are on Wednesday and Saturday. I have a list of employees that I want to randomly select from to fill in the schedule, but can’t figure out a good way to do this. I tried using =randbetween to randomly generate numbers beside the names, but it seemed to create too many duplicates, and overall didn’t seem like a great solution.
If any of you are able to help me out it would be greatly appreciated!
2 Replies
Zac6Smith You're in luck. I created something I think may work for you. in the attached i have 2 tabs. The first is the 'registration' tab where you enter names, unique ID#s (must be a number) and then for each date if they are available. There is also a "Level" column that you can ignore or enter the same value for all (this was set up for something like a tennis league so that the 'top' players stay grouped near the top and bottom near bottom but allows some level of mixing).
The second sheet has a RNG level that doesn't matter in this case (again works with that 'Level' column) and the a Date input (drop down in B6). When you select a date it will give you a pseudoRandomized list unique for that date. You can then use the top X number as the employees to work. It is (IMHO) much better than just using RAND functions because it is repeatable. The "seed" is based on a combination of ID# and Date so as long as the ID doesn't change their pRNG for that date won't change either.
- That’s great! Thank you very much, I’ll give it a try and see how it works!
