Optimal Staff Scheduling - Number of Staff Required - Free Software?

I have tried to开发者_StackOverflow use Excel Solver already..

What I have?

Point A

00:00, 01:00,...23:00

58, 79, 81, 35, 55, ... (staff required for each hour).

--

Point B

Available Shifts

0600 - 1500
1400 - 2100
2300 - 0700
...

..

Point C Result

I want an optimal roster generator that generates..

say.. I need

50 staff on 0600-1500
20 staff on 1400-2100
0 staff on 2300 - 0700
35 staff on 2330 - 0730
..
etc.

Total Staff Required 135.

This is the optimal solution, say. you can't go any more below than 135 without losing a few additional heads on an hourly basis.

--

Yes. I know about Solver Can do this partly... but surely that is not optimal enough.

Is there some free software.. or online.. when I plugin Point A & Point B, it generates Point C with minimal overhead (or wastage).

---

Lets Start with Point B

Available Shifts 0600 - 1500

0600-1500 in this shift if you want to track information about your employees you have two options either you create an excel sheet for tracking log in and log out timings for your staff and other options is to use eworks online staff scheduling app that will help you track your employees shift timings, breaks, Clock-In, clock-Out, reports and so on.

---

If you're looking for a programming library, try Drools Planner. If you're looking for an end-user application, try TimeFinder.