Custom Column Calculation

[Jeff Ditty]

Hello-

I am looking for a solution to the following problem:

I need to have a calculation in a column that generates the number of days a
project is off schedule. I currently have one baseline Start & Finish date
for each task, and one actual Start & Finish date for each task. What I
want to do is calculate the difference between the Baseline & Actual Start
Date, the Baseline & Actual Finish Date, and then add the two values
together to generate a value for how many days a task is off schedule. The
column would then keep a running sum of each task so that as you review the
latest task in the project, you can determine the current amount of days the
entire project is off schedule.

Anyone have any thoughts or solutions to this inquiry?

Thanks,

Jeff

 

[Jan De Messemaeker]

Hi,

In a duration field [Start Variance] + [Finish Variance]
HTH

 

[John]

Hello-

I am looking for a solution to the following problem:

I need to have a calculation in a column that generates the number of days a
project is off schedule. I currently have one baseline Start & Finish date
for each task, and one actual Start & Finish date for each task. What I
want to do is calculate the difference between the Baseline & Actual Start
Date, the Baseline & Actual Finish Date, and then add the two values
together to generate a value for how many days a task is off schedule. The
column would then keep a running sum of each task so that as you review the
latest task in the project, you can determine the current amount of days the
entire project is off schedule.

Anyone have any thoughts or solutions to this inquiry?

Thanks,

Jeff

Jeff,
Take a look at the two fields, Start Variance and Finish Variance. They
give the difference in working time between the scheduled and baseline
values.

I would caution you however about your plan to add the two variance
values together to get a meaningful metric. For example, let's say a
bunch of tasks started early and they also finished late. The sum value
of the variance will be near zero indicating everything is hunky dory
when in fact, the plan is late and apparently either being inefficiently
executed or poorly planned from the get-go.

John
Project MVP