Most of you must be familiar with Solver. It’s a built-in tool in Excel which helps you solve optimization problems like maximization of profit, minimizing cost of transportation, minimum cost staff scheduling etc. These problems are so widely encountered that people have made and taught specific samples to use when solving a specific type of problem with Solver. These samples ensure that you are working with the tool as efficiently as is possible. You might think “where can I find those samples?”. Or maybe you are an Excel enthusiast who wants to learn the use of Solver. All the help that you need is already there on your PC. And Daniel Fylstra is here to guide you!
If you already have Solver under your ‘Data’ tab, proceed to Step 1. If you are not sure how to access Solver, please follow the steps below:
You should be able to access the tool from the ‘Data’ tab on the ribbon under the ‘Analysis’ section.
Follow the steps below to access the samples:
And there you have it! This file contains samples and guidelines on different types of widely encountered Solver problems like Product Mix, Transportation Problem, Investment Problem, Scheduling Problem etc. Also, it teaches you how to use Solver.
Whenever you are working through a Solver problem, use this samples file. And, most importantly, do not forget to SHARE this post with your friends and colleagues!! Exercise your brain today by learning something new. Cheers!
Session expired
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.
Any ideas on where I can find out more on using solver and exactly how the implemented formulas work?
These are the guys that developed solver. They have the best resources. http://www.solver.com/excel-solver-help
just in case you dont find the file:
https://docs.google.com/file/d/0B_HCI9hn6GT-LWR4aFMtUmdWVVU/view