Hi All - have a relatively beginner question here having to do with the solver addin.
Problem: I have a model in excel that projects total points scored. To get to this projected number, I have a set of weights that are input-able, and drive how much of a teams historical stats get weight in the calculation. This is shown in image 1.
After the total points are projected, I am back testing the total versus actual results and comparing how my projection did with the actual result. Essentially, after the total is projected, there is a long chain of other cells that change, and then ultimately I have a Win % to see how I did with my projections. I am trying to use solver to find the optimal weightings of each stat to maximize the Win %. Image 2 has the settings I am using in solver.
When I click solve, Solver runs in like 1 second and come back with weights of 1 and 1 (ie 100% and 100%) for each stat. I know that this is not optimal based on manually inputting different percents and seeing a higher Win %.
Am I doing something wrong? Is the fact that after the input cells are input to, theres a long chain of other cells that need to update a problem?
Thanks in advance for your help!
Bookmarks