Comparing Baseline to Current Work Effort

[axw99]

I have baselined my project and have been updating the Actual Work field as
work has progressed. However, we are about 25% of the way through the project
and have a change request which extends our timeline, adds some new tasks,
etc. If I want to see the variance between the Baseline and the new work as a
result of these changes, what's the easiest way to do that? Right now, I'm
running multiple reports (like the Who Does What When or Resource Usage
reports) but my numbers are off and I can't figure out where the problem lies
because I'm having to search through multiple reports.

Thoughts?
Thanks!

 

[JulieS]

Hi axw99,

MS Project has a number of "Variance" fields that compare baseline data
against actual and scheduled data. The Variance Table (View Table >
Variance) shows the Start and Finish Variance. The Work Table shows
Work Variance, the Cost table shows Cost variance.

You may make a custom table by adding any or all of the Variance fields
(Cost, Work, Duration, Start, Finish) as needed.

--
I hope this helps. Let us know how you get along.

Julie

Visit http://project.mvps.org/ for FAQs and more information about
Microsoft Project.

 

[John]

I have baselined my project and have been updating the Actual Work field as
work has progressed. However, we are about 25% of the way through the project
and have a change request which extends our timeline, adds some new tasks,
etc. If I want to see the variance between the Baseline and the new work as a
result of these changes, what's the easiest way to do that? Right now, I'm
running multiple reports (like the Who Does What When or Resource Usage
reports) but my numbers are off and I can't figure out where the problem lies
because I'm having to search through multiple reports.

Thoughts?
Thanks!

axw99,
Probably the easiest quick-look approach is to display the Start
Variance, Finish Variance and/or Cost Variance fields. There are also a
couple of earned value metrics (i.e. SV and CV) that might be useful.
You should also be aware that Project provides for multiple baselines to
help track change requests like yours.

For more information on each of the above fields, check the Project Help
file. One quick way to do that is to insert the fields in you view and
then hover the mouse over the column header. When you do that, a small
help box will appear and you can select the help topic directly.

Hope this helps.
John
Project MVP