Excel Tool for Milestone Trend Analysis

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 target 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 forecast dates 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. You can copy the automatically generated MTA diagram to self defined reports (Excel, Word, Power Point, etc.) as a graph.

The user interface is multilingual. English and German languages are pre-installed. Three further languages can be added by the user by editing the integrated match table.

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

Features:

• Up to 20 milestones can be recorded
• Maximum 60 reporting periods available for tracking
• Largely robust against faulty input
• Later adding of originally not planned milestones possible
• focusing on essential possible by hiding and unhiding inpidual milestones 
• magnification function for highlighting details
• multilingual user interface: German and English installed, the user can define three more

15,00 EUR inkl. 19 % MwSt. |