Schedule Variance

James Pflueger

How can I copy columns from one template and add them to a different template? I want to add the date variance column from the Project Gantt and budget template and add them to the Project plan template. I just want a way to baseline and track schedule variance.

Paul Newcome

You would need your Projected Date column(s) and your Actual Date column(s). Then you would use a basic formula of

=[Projected Date]@row - [Actual Date]@row

This will give you your variance(s)

Paul Newcome

You would need to add the columns themselves, but then you can copy/paste the data.

James Pflueger

How do I add the capability to add schedule variance? That is what I am trying to add.

Paul Newcome

You would need your Projected Date column(s) and your Actual Date column(s). Then you would use a basic formula of

=[Projected Date]@row - [Actual Date]@row

This will give you your variance(s)

James Pflueger

Thanks that worked.

Paul Newcome

Happy to help! 👍️

Robert Gibbs

Hey...so maybe you can also help me...I have done what is described above...

Actual Start, Actual End, Actual Duration and Task Schedule Variance. (I even have the Actual Duration skipping weekends.)

Problem now is getting the PROJECT level Schedule Variance for right now.

So that would be the sum of the Task Schedule Variance...but (and here is the trick) NOT including any Parent Rows where this is calculated. I'm creating a template for my organization and don't want to have to worry about making sure people don't copy a particular formula into Parent rows.

I'm attempting to use the "Sheet Summary" function. When I try to use "SumIF" as follows:

=SUMIF([Task Schedule Variance]:[Task Schedule Variance], COUNT(CHILDREN()) = 0)

It parses but just gives me zero. If I change it to <> 0 it also gives me zero.

When I try putting @Cell or @Row in CHILDREN() it becomes unparseable.

Thanks for any help...

Rob

Paul Newcome

@Robert Gibbs Try adding in a helper column of the text/number type. In that column you would use a formula along the lines of

=IF(COUNT(CHILDREN([Task Name]@row)) = 0, [Task Schedule Variance]@row)

Then you can use a basic SUM function in your Sheet Summary and add up this helper column.

Robert Gibbs

So the @row reference doesn't work in a Sheet Summary Field? Doing it this way creates issues with making sure formulas are copied down correctly...

But I suppose I already have that problem with the Task Schedule Variance Column...

Rob

Paul Newcome

@row does not work in Sheet Summary fields.

Autofill will work to pull the formulas into new rows as long as there are at least two rows above or below the new row that contains the formula.

Robert Gibbs

Forgot to say THANK YOU for looking at this...

Also, instead of a helper row...I just put the "Children check" into the variance calcuation...

=IF(COUNT(CHILDREN([Task Name]@row)) = 0, IF((ISBLANK([Actual Start]3)), 0, Duration3 - [Actual Duration]3))

Rob

SPK

Trying to calculate Duration on task With column titles of Punchlist Signed by Ops - Punchlist Walk w/GC-Ops using

=[Projected Date]@row - [Actual Date]@row as the baseline using exact column heading in lieu of Projected and Actual date. Does not seem to take this. Also is row the row number of the calculation or just @row?

Any suggestions?