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
- Click Data on the Ribbon
- Click Solver
- Click "Start Target Cell" button and select C17
- Click Min in "Equal To:"
- Click "By Changing Cells:" button and select A5:A11
- Click Add button
- Click "Cell Reference:" button and select A3
- Click triangle and select "="
- Type 22 in "Constraint:" window
- Click Add
- Click "Cell Reference:" button and select A5:A11
- Click triangle and select "integer"
- Click Add
- Click "Cell Reference:" button and select C12:I12
- Click triangle and select ">="
- Click "Constraint:" button and select C14:I14
- Click OK!
- Click Solve.
Download excel sample file for this article.
bank24_1.xls
(Excel 97-2003 Workbook *.xls)
Identify numbers in sum using Excel solver
Here is a useful feature I recently found googling for Excel solver examples. I have summed some random values from […]
Optimize pick path in a warehouse
As you probably already are aware of I have shown you earlier a vba macro I made that finds the […]
Find positive and negative amounts that net to zero
I found this excel question: I am a Controller in a multinational company. We have many transactions (sales, credits, debits, […]
How to solve simultaneous linear equations in Excel
This article demonstrates how to solve simultaneous linear equations using formulas and Solver. The variables have the same value in […]
Question: I need to setup a template to remove the largest available (Qty and denomination)bills and leave exactly $150 back […]
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.