Formula or else...
Hi,
Something alonge these lines
Hours to work
=2*12*7 which retuens 168
Divide by max hrs per employee
=2*12*7/36 returns 4.66
You can't have .66 of an employee so round to a multiple of 1 and the whole
formula becomes:-
=MROUND(2*12*7/36,1)
If the last formula produces a #NAME error then
Tools|Addins
Check the analysis toolpak
Mike
"computexcel" wrote:
This I do it very often and wondering if excel can help me either with
formula, function, permutation...
I need to schedule X amount of employees to work 3 shifts a day ( 8 hrs )
in a week.
Q how many employees do I need ?
taking in consideration that no more than 40 hours a week per employees.
Also if I do it different, lets say, How many employees for:
2 shifts a day (12hrs), 7 days, 36 hours per employee.
I think combination or permutation is the key, but how do I start?
THANKS.
|