Folks, I'm new to designing / creating spreadsheets, so please be gentle.
Here's a question that I would like a suggestion on:
Scenario:
I have 1000 software modules to migrate to another language.
I've been asked to group the 1000 modules into three buckets (Hard, moderate, easy). The current distribution is about 30% hard, 50% moderate, and 20% easy.
The project has a funded period of performance of 1 year 2080 hours
We're wondering if EXCEL and determine the average hours of time, each of the modules in the various group will take (based completely on estimation).
I realize I can balance the hours per modules per group to hit the target of 2080, but, was wondering if there exists an algorithmic method to get close.
Then apply a standard deviation to apply a Max, average, min for each group of modules.
So, we would see something like:
Hard as 30% of the 1000 modules or 300, how much of the 2080 will it used.
Moderate has 50 of the remaining 500 module and will take how many hours per module
Easy has 20% of the remaining 200 modules and will take how many hours per module
Then to validate you multiple hard-modulers*hours per module, moderate-modulers*number of hours per module ...etc for easy....
The grand total should equal very close to 2080... and give an idea as people migrate each module, be able to project /budget the number of hours that "should" be allocated to the completion of the module based on the category....
Hopefully this was clear.....
AL
Here's a question that I would like a suggestion on:
Scenario:
I have 1000 software modules to migrate to another language.
I've been asked to group the 1000 modules into three buckets (Hard, moderate, easy). The current distribution is about 30% hard, 50% moderate, and 20% easy.
The project has a funded period of performance of 1 year 2080 hours
We're wondering if EXCEL and determine the average hours of time, each of the modules in the various group will take (based completely on estimation).
I realize I can balance the hours per modules per group to hit the target of 2080, but, was wondering if there exists an algorithmic method to get close.
Then apply a standard deviation to apply a Max, average, min for each group of modules.
So, we would see something like:
Hard as 30% of the 1000 modules or 300, how much of the 2080 will it used.
Moderate has 50 of the remaining 500 module and will take how many hours per module
Easy has 20% of the remaining 200 modules and will take how many hours per module
Then to validate you multiple hard-modulers*hours per module, moderate-modulers*number of hours per module ...etc for easy....
The grand total should equal very close to 2080... and give an idea as people migrate each module, be able to project /budget the number of hours that "should" be allocated to the completion of the module based on the category....
Hopefully this was clear.....
AL
