'Using Randbetween With Conditions In Excel
A round-robin schedule generated with even distribution of each of 21 teams playing approximately equal games in 14 given locations (no less than 1 game in each location, no more than 3 for each team).
The end product will be a table with Week, Home Team, Away Team, Location Home vs Away balance is not important, I have a template with everything populated except the location.
Any condition I could add?
=RANDBETWEEN(1,14)
Solution 1:[1]
Try using the solver add-in, which is designed specially to solve logical models such as this.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | SIE_Vict0ria |