Quote:
Originally Posted by MJC922
No worries, that's fine. Just set them all back to zero manually. Then keep in mind you have to have the Solver add-in installed. That's included with Excel but needs to be enabled first. Once you have it enabled go to the Data tab > Analysis, click on Solver. That should open up the Solver Parameters dialog box. This will I hope still have retained the original parameters that I applied to this excel sheet. Here is where you should see the objective to maximize T2 by Changing the Variable Cell range of G2:J6, those are the yellow shaded cells you were manually playing around with. Click the Solve button at the bottom and those will start changing automatically.
|
I must have solver installed already because as I change the values in those cells, the ROI and Win% changes and the spreadsheet reacts in a way that makes sense.
But I don't know exactly what I am asking when I change those numbers.
Let's say I put a "1" in cell G2, what am I asking?
If I put a 99 in there I get the same result.
What if I put a "1" in G2 and H2?
What if I put a "1" in G2 and G3?