Calculated Duration following productivity Rate

Question

Calculated Duration following productivity Rate

Anonymous

Hello

I need to force project to calculate following my own formula or following a certain productivity rate.

Example:

I have a task consisting of 1,000 sqm of tiling works.

I know that the average productivity rate of tiling is 2 sqm/hr

I will create to columns, one for qty, one for productivity and one for estimated Duration.

I need project to calcutale the estimated duration as (1000/2) = 500 hrs

I need to make project use this duration in he Grantt Chart.

Why we need this? well we have sometimes huge projetcs conataining lots of similar tasks related to the same productivity rate. If we are able to do so then we can change the productivity rate in one place and see how it will affect the whole project. We frequently do this on Primavera but I don't know how to do it in Project 2013.

That plan is not submitted to the client or consultants, it is internally used by our company to see various scenarios.

How can I do it?

Thank you for your support

Regards

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Answer 1

Hi,

The only way to do it is through a VBA procedure. It's simple enough but it is necessary.

Supposing the sqm are in Number1 and the sqm/hr in Number2, here's the code:

Sub TilingDuration

dim T as task

for each t in activeproject.tasks

if not t is nothing then

if not t.number2=0 then

t.duration=60*t.number1/t.number2

end if

next t

end sub

The website of fellow MVP Jack Dahlgren, masamiki.com, has the instruction on how to install and run macro's.

Greetings,

Share via

Calculated Duration following productivity Rate

1 answer