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

### Solver category

Here is a useful feature I recently found googling for Excel solver examples. I have summed some random values from […]

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

The COMBIN function returns the number of combinations for a specific number of elements out of a larger number of […]

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

## Functions in this article

More than 1300 Excel formulas

## Excel categories

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