User Profile
Arend_M
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
Re: 'Duration given by percentage of Base value'
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.455Views0likes1Comment'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. Is it possible to define the duration in MS Project as a formula for different tasks ? Like Task1=0.1*10, Task2=0.05*10 and so on. We would like to create a template for our standard tasks where only the base value needs to be changed. Thank you in advance.501Views0likes4Comments
Groups
Recent Blog Articles
No content to show