Excel Tool for Milestone Trend Analysis

Milestone Trend Analysis (MTA)

This Excel-based milestone trend analysis is an efficient graphical tool for tracking project milestones. It visualizes the trend of milestones and provides the possibility to identify resulting impact on the project completion date, so that, where appropriate, countermeasures may be taken timely. Due to their high information density and clarity it is suitable for reports to the higher level of decision. Since it keeps records of the milestones’ trend it can give clues for wide detailed analyses at the end of the project (lessons learned).

Significant precondition is the thorough definition of appropriate project milestones with dates, goals and responsibilities at the beginning of the project. Up to 20 milestones can be recorded and tracked in this template.

During the project, milestones regularly (usually in project meetings) will undergo an assessment and a forecast for their finish dates will be issued. These forecasts or - if milestones are completed - actual dates will be recorded. The template is set up for up to 60 report dates.

Based on the collected data, the tool automatically generates a MTA chart, and a short report, that are optimized for printing in A4 format.

In a separate sheet the template contains some detailed explanation of how to interpret MTA charts.

The template is created for Excel version 2010 and contains no VBA (macro code).

It might not be compatible with MAC.

Milestones

Dates

Settings

20,00 EUR inkl. 19 % MwSt. |