hey guys, this is probably a very basic thing to do in excel.. i have very little experience with IF statements so please bear with me
Lets say that i have a variation of minutes i'd expect a player to play, i understand that i could use the RANDBETWEEN function to get a variation in minutes played..
the problem i have is that I want the total minutes played for the entire team to equal a fixed number (say 240 minutes)... how would I go about this
If you know how many minutes you expect from each player, then it's as simple as summing them up and normalizing them. That would just be taking 240/your total and then multiplying each players minutes by the result. That's probably the easiest way, assuming that the % each player plays of available minutes is relatively consistent from game to game.