Skip to content
ProjectControls.com
Microsoft Project

Comparing two projects

In the Open Standard
Mary JoAnnMember for 23 years 7 months
Created
3
3
0
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
Save Follow Follow forum Report
Reply New topic

3 replies

Oldest first
  1. 0
    Paul Harris ·
    #1
    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
    Report
  2. 0
    Martin Sweeney ·
    #2
    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,
    Report
  3. 0
    Mohamed Hegab ·
    #3

    I tried "schedule Cracker"

    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.

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?