Adjusting Hours Globally

[cdebracy]

I'm using Project 2003 and have a task list estimate for development work. I'd like to add an X factor (%) to the number of hours given me to more accurately reflect the real world time that this project will take.

Any suggestions?

Thanks.

 

[John]

C,
There are several ways to add a "fudge factor" to estimated Durations.
If there are only a few tasks you might want to simply make the change
manually. Another method would be to copy the Duration field into Excel,
eliminate the "d" and apply the factor to the data. Then copy the result
back to the Duration field in Project. That takes a little more effort
but will work well for a large number of tasks. If I were doing it
myself, I would use a simple VBA macro such as the one below. With a few
minor modifications, it can be used on the whole file or just for
selected tasks.

Sub FudgeDur()
For Each t In ActiveProject.Tasks
If Not t Is Nothing Then
If t.Summary <> True Then
t.Duration = t.Duration * 1.1
End If
End If
Next t
End Sub

Hope this helps.
John

 

[cdebracy]

John,

Thanks. While waiting for a reply, I played with the PERT stuff a bit. Created an expected duration that was 50% higher than what I was given and weighted the Optimistic and Expected durations equally.

Having a global function would be nice, though at least with the PERT stuff I can save the original times. Your way is probably better if I have to juggle several different percentages.

Appreciate the response. I'll hang on to your macro.

Chris

 

[Guest]

use primavera

-----Original Message-----
I'm using Project 2003 and have a task list estimate for

development work. I'd like to add an X factor (%) to the
number of hours given me to more accurately reflect the
real world time that this project will take.