problems with Solver

Hunters17

New Member
Joined
Jun 6, 2011
Messages
1
Hi. I'm trying to use Solver to calculate the least number staff to cover a specified Required staff at half hour intervals. I'm probably using solver incorrectly (!) but the answer it provides is way off being optimized.

The data I have is quite simple:

Column A: time of day in half hour intervals
Column B: Required number of staff in each half hour interval
Column C: Number of new staff provided in each half hour interval (this is the column that solver can change)
Column D: Coverage (accumulated FTE) for that half hour interval (ie 8 hour shift so if you have 1 person in column C at 09:00 and 2 new people at 09:30 in column C then column D would have 1 FTE at 09:00 and 3 at 09:30)
Column E: is the Error squared (Column D less Column B squared)

I am trying to optimise the sum of column E so specify it as minimise, and the constraints are Column D should be >=1 and Column C should be an integer.

I'm sure this is fairly basic - but could really do with some help!


Thanks
 

Forum statistics

Threads
1,084,859
Messages
5,380,329
Members
401,665
Latest member
iahmad

Some videos you may like

This Week's Hot Topics

Top