Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula or else...
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula or else...
I have some 20 hours a week employees, but I think I can work with this
simple formula you gave me very well. Thanks Mike. "Mike H" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|