Hourly work schedule with Solver

Upsoul

New Member
Joined
Jul 1, 2015
Messages
3
Hello,

In my company, we are trying to find a way to better schedule peoples working times. As it is a call center, we need different amounts of people at different times, so that makes it more difficult. Im trying to figure out whether it would be possible to use solver to generate a monthly (30 day) work schedule (would it take too long to find the solution?). In the schedule 1s represent work time and 2s represent lunch break. There would be some restrictions about maximum working time, but that shouldnt be too hard with constraints. I would like to know if this is possible to do with solver or open solver or are there any other options you would reccomend. Im attaching a basic version just to show what the layout is.

HTML:
http://www.filedropper.com/schedule1
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Upsoul

New Member
Joined
Jul 1, 2015
Messages
3
Could anyone take a look?
I also have one more question:
How can I make solver make continous streaks of 1s instead of scattering them all over?
 

Upsoul

New Member
Joined
Jul 1, 2015
Messages
3
Would there be anyone willing to answer at least some of my questions?
 

Watch MrExcel Video

Forum statistics

Threads
1,123,271
Messages
5,600,650
Members
414,399
Latest member
Ninjee

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top