Random Driver Chart, Never Same Vehicle or Passenger

[Toyo613]

Hey All,

So we have an event coming up that requires us to build a completely random chart of drivers, vehicles and legs. We have been struggling with how we should do this and honestly don't even know where to start.

I've attached a file that should give an idea of what we need to do but there are three random variables.

Variable 1: Driver's and Passenger should rotate every leg.
Example: if you were a Driver in Leg 1, then you should be a Passenger in Leg 2. If you were A Passenger in Leg 1, then you would drive in Leg 2... So on and so forth.

Variable 2: The same two people should never end up a pair again.
Example: If person number 1 and 7 were together in leg 1, then they should never be together again.

Variable 3: You should never been in the same vehicle again.
Example: If you were either and Driver or Passenger in Car 1, then you should never been a Driver or Passenger in Car 1 again.


I assume this is possible in excel but like I said, not sure where to start so any help is useful.