## 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, […]

Question: I need to setup a template to remove the largest available (Qty and denomination)bills and leave exactly $150 back […]

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 […]

### 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.

**Contact Oscar**

You can contact me through this contact form