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. Another possibility is you may need to re-download the sheet and retry the above steps.
Last edited by MJC922; 11-14-2022 at 02:26 PM.
|