Sorry to disappoint, but I use option 1 -- project has built in comparisons through the calculation of variance. I would not be creating an Excel spreadsheet to do what is built in.
If you want to use option two, have you considered using the Compare Project add-in to compare the two versions of the file? Again, it's built in to Project and avoids having to create the additional Excel file.
|