Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Comparing two projects

3 replies [Last post]
Wed, 2004-02-25 06:24
Mary JoAnn
User offline. Last seen 17 years 25 weeks ago. Offline
Joined: 3 Mar 2003
Posts: 35
Groups: None
Any ideas on how to compare two different update versions of a MS Project file to get variance in start & finish dates of each activity.. (the project has not been saved as baseline)

As in P3, two projects can be compared by simply selecting one project as target of other.

Thanks
Top

Replies

Mon, 2010-10-11 21:25
#1
Mohamed Hegab
User offline. Last seen 3 years 25 weeks ago. Offline
Joined: 4 Feb 2009
Posts: 38
Groups: None

I tried "schedule Cracker" (www.schedulecracker.com) and it has all what you want.  They offer DCMA, GAO, EVM, Comparison, analysis, and even trend.  They offer it for Primavera.  I communicated with them and they said that MS Project is coming soon.  They offer 14 day free full functional trial. They told me that I can load any schedule size I want and it should be fine. Give it a try.

Top
Wed, 2004-03-10 11:05
#2
Martin Sweeney
User offline. Last seen 19 years 21 weeks ago. Offline
Joined: 10 Mar 2004
Posts: 3
Groups: None
Microsoft provide a Add In for MSP 2000 so that you can compare two versions of the same project, works well, available from the microsoft website,
Top
Wed, 2004-02-25 18:30
#3
Paul Harris
User offline. Last seen 1 year 20 weeks ago. Offline
Joined: 11 Apr 2001
Posts: 618
Groups: Content Moderators, GPCCAR Editors
There are several Methods of comparing MSP schedules.

MSP 2000 introduced a new function titled Compare Project Versions which is activated by displaying the "Compare Project Versions" toolbar by selecting View, Toolbars. This will highlight changes between open projects.

If you have MSP 98, you may also cut and paste data into an Excel spread sheet and using the MSP "Unique ID" number you will be able to compare projects with deleted or added tasks using functions like VLOOKUP and dropdown filters. Or should you have good MS Access skills you may save the files in Access format and compare them with MS Access.

For completeness of this topic there are several software packages on the market for comparing project files. I have come accross the following:

Claim Digger http://www.primavera.com/products/claim_digger.html
Project Investigator http://www.primaplan.com
Ron Winters Schedule Analyzer http://www.ronwinterconsulting.com

But I think they all only work with Primavera schedules, I am sure someone else will correct me if I am incorrect.

Paul E Harris
Eastwood Harris Pty Ltd
Planning and Scheduling Book Publishers
www.eh.com.au
Top