Forum Discussion
'Duration given by percentage of Base value'
My company uses a "Effort Estimation Template" which uses a base value (estimated time) to calculate the duration for different tasks. Example: Base value 10 Days, Analysis needs 0.4 * 10 = 4 days. I...
Hi John-project thanks for the answer.
I have expressed myself a bit misleadingly. The base value is an estimate of working days (8 hours) for a project (different for each project). Depending on the task, these are extrapolated with a multiplyer 5%, 10%, etc. including buffer etc.. These are experience values that are needed in the company for certain processes. Different tasks different resources you are right.
I would now like to create a template in MS Project where I have my standard tasks, where the duration is specified on the basis of the "base value". BSP. base value 10, Task Analysis = 10*0.4 = 4 days for a Business Analyst, Task Test Automation = 10*0.2 = 2 days Test team member, etc.
I want a field where I can enter my base value and then all standard tasks durations should be scaled up automatically based on the base value.
Is there VBA for MS Project?
We use excel so far but it would be nice to have something like that in project so you don't have to transfer anything.
Sorry but my head is still spinning about your "base value". And what is "BSP"?
You give an example of Task Analysis equals 4 days (computed) for a Business Analyst and Task Test Automation equals 2 days for a Test team member. I still can't tell if that is time span (duration) or effort (work).
One thing I can answer for sure. Project does include VBA but of course the object model is quite different from the Excel object model. That tends to "trip up" (i.e. frustrate) a number of Excel users who attempt writing Project based macros.
Can you get there from here with Project, and some VBA? Yeah, probably, but in order to provide more help I need a clearer understanding (i.e. explaining to a 3rd party not familiar with your "company processes") of your intent with respect to Project's definition of duration and work. Maybe a simple screen shot of a Gantt Chart example would help. You know, a picture is worth 1k words kinda thing.
John