In the next two sections, we’ll cover how to include additional constraints as well as a simple way to automate the Solver.īy enhancing our constraints setup, we can create better models and in turn, create better solutions. Feel free to skim those to build a stronger foundation if you feel the need or get stuck along the way. This read will be a decent length journey so don’t forget to bring a towel.Īre you comfortable with solving for a new budget allocation based on a max spend? If not, you can check out two previous posts that cover reallocation during budget cuts. At the very least you’ll build a strong grasp of the reasoning and initial setup. We’ll skip some of the finer details to better establish why and how to set up.
The post focuses on the more technical aspects of Excel but will remain fully accessible.
0 kommentar(er)
