Originally Posted by
gamblingisfun
I have a sports model that has many inputs for statistics, and various weightings for the importance of each one. I also have a point differential threshold that can be changed that makes it qualify as a bet. Each day of bets is on its own sheet that's connected to the weightings that are on one page. Each page does many calculations all based on those weightings. I can use goal seek to find the optimal weighting number to find what would make for the highest winning percentage for each individual weighting. Problem is goal seek seems to be for one at a time, and not all other ones connected to it. I'm wondering if there's a way to connect all the variables to find the optimal numbers for each one. Also if there's a limit to what excel can do since for each number changed it'll have to do many calculations on each page on like 100 different pages all at once. Thanks for the help in advance.