How to Use Solver in Microsoft Excel
To understand the Solver, it’s important to understand the basic concept of what it does and how it works.
Step-by-Step Guide
-
Step 1: To understand the Solver
There are 3 primary components you should be familiar with.
Target Cell.
This is the cell that represents the goal or objective of the problem.
In our example, we will be attempting to have a schedule that has no shortfall in staffing.
The cell that reports any shortfall will be our Target Cell.
Variable Cells are the cells that can be modified to arrive at the desired outcome.
In our example, that will be work hours from Monday through Friday for all employees.
Constraints.
This are restrictions or limitations to what Solver can do to solve the problem.
For example, if Employee X cannot work Tuesdays, Solver is restricted from assigning an employee work on Tuesdays.; -
Step 2: it’s important to understand the basic concept of what it does and how it works.
Detailed Guide
There are 3 primary components you should be familiar with.
Target Cell.
This is the cell that represents the goal or objective of the problem.
In our example, we will be attempting to have a schedule that has no shortfall in staffing.
The cell that reports any shortfall will be our Target Cell.
Variable Cells are the cells that can be modified to arrive at the desired outcome.
In our example, that will be work hours from Monday through Friday for all employees.
Constraints.
This are restrictions or limitations to what Solver can do to solve the problem.
For example, if Employee X cannot work Tuesdays, Solver is restricted from assigning an employee work on Tuesdays.;
About the Author
Judith Reed
A passionate writer with expertise in pet care topics. Loves sharing practical knowledge.
Rate This Guide
How helpful was this guide? Click to rate: