When using Solver for the alpha, I am getting the message that the objective cell contents has to be a formula. Has anyone run into this problem?

If you think about it, Solver is doing nothing more than running many iterations of the equations that calculate the objective. For forecasts, this is MAPE or MSE, etc. You have to have links from your objective cell back to the cells you want Solver to change. Inspect the following graphic that shows the linkage from MAPE back through the forecast model to alpha. The linkages from MAPE goes back to the actual values, but we cannot change them. That’s why you select MAPE as the objective and Alpha as the cell to change:
MAPE precedents

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.