randbetween()

Good afternoon,

 

I am trying to create a randbetween formula. I have a schedule for the waiters for 7 days.

Monday 4 server AM and 6 server PM | 4 servers = 4 section, 5 server = 5 section… 10 servers=10 section.

The amount of server changes for each am or pm shift as well everyday.

I need the formula to randomly choose the station based on the amount of waiters working that day. 

I please also need the station to randomly rotate evry day.

For last I would love to have the station also rotating from a week to another once I do the next week schedule.

 

I hope it is not too confusing, but this is the best way I can explain it.

 

Thank you for the help

 

Events              
Day Monday Tuesday Wednesday Thursday Friday Saturday Sunday
Date 31-Jul 1-Aug 2-Aug 3-Aug 4-Aug 5-Aug 6-Aug
SERVER 4 6 4 6 4 6 4 7 5 8 7 9 8 6
1 0 0   1   1   1   1 1 1
                           
2   1 0 0   1   1   1 1 1
                           
3 1   1 1 0 0 1   1   1  
1                          
4 1   1   1   0 0 1 1 1  
3                          
5 1   1   1   1   0 0 1 1
3                          
6   1   1 1   1   1 1 0 0
                           
7 0   1   1 1   1   1 1 0
                           
8 0 0   1   1   1   1 1 1
                           
9   1 0 0   1 1 1   1   1
                           
10   1   1 0 0   1 1 1   1
                           
11   1 1   1 1 0 0 1 1    
                           
12 1 1   1   1   1 0 0 1  
1                          
13 0 0 0 1 1 1 1 1   1  
                           
14 0   1   1   1   1 1 1 0
                           
15                            
                           

By: Pascal Pinault

Leave a Reply

Your email address will not be published. Required fields are marked *