Earlier this month, I wrote an article for TechRepublic on How to use project data to develop a better estimation matrix.

The article introduces the concept of comparing your baseline project data to your actual project duration and work effort based on the key tasks or deliverables in your project schedule.  The end goal is to provide better estimates so you can update your own project estimation matrix for future analgous estimating.  The second part of this article demonstrates how to customize Microsoft Project to track key areas of your estimation matrix as well as export date from Microsoft Project into Excel.

I'll update this article with the second half of the TechRepublic article once it is published.

In the meantime, you can download the sample MS-Project schedule with the myEstimateComparison table and myEstimates export map.

Attachments:

File	Description	File size
Sample Schedule with myEstimates.mpp	Includes sample table, map and custom fields for the TechRepublic Effort Estimation article	855 Kb