Using Excel Solver to schedule employees
This is a question I found at the bottom of this page Using Solver to schedule your workforce
Suppose our bank had 22 employees, and that their goal was to schedule employees so that they would have the maximum number of weekend days off. How should the workers be scheduled?
Here is the setup:
I created a new formula in C17.
All other formulas are created in the initial setup, see xls file found here: Using Solver to schedule your workforce
How to schedule employees so that they would have the maximum number of weekend days off
- Press with left mouse button on Data on the Ribbon
- Press with left mouse button on Solver
- Press with left mouse button on "Start Target Cell" button and select C17
- Press with left mouse button on Min in "Equal To:"
- Press with left mouse button on "By Changing Cells:" button and select A5:A11
- Press with left mouse button on Add button
- Press with left mouse button on "Cell Reference:" button and select A3
- Press with left mouse button on triangle and select "="
- Type 22 in "Constraint:" window
- Press with left mouse button on Add
- Press with left mouse button on "Cell Reference:" button and select A5:A11
- Press with left mouse button on triangle and select "integer"
- Press with left mouse button on Add
- Press with left mouse button on "Cell Reference:" button and select C12:I12
- Press with left mouse button on triangle and select ">="
- Press with left mouse button on "Constraint:" button and select C14:I14
- Press with left mouse button on OK!
- Press with left mouse button on Solve.
Get excel sample file for this article.
bank24_1.xls
(Excel 97-2003 Workbook *.xls)
As you probably already are aware of I have shown you earlier a vba macro I made that finds the […]
I found this excel question: I am a Controller in a multinational company. We have many transactions (sales, credits, debits, […]
This article demonstrates how to solve simultaneous linear equations using formulas and Solver. The variables have the same value in […]
Leave a Reply
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.