Milestones Tracker: An interactive project monitoring and reporting tool

Share
Tweet
Share
Project Dashboards with Milestones Tracker by MLR

Having reliable reporting tools are vital in properly managing construction projects.  One such instrument is the Milestone Tracker as developed by this author.  The tracker provides comprehensive information about the overall status of the projects.  Details are configured in such as  way that they can readily be conveyed and easily understood by various stakeholders.

About

The Milestones Tracker provides a comprehensive and cohesive array of information to better control and monitor the progress of projects.  Specifically designed to handle multiple projects or contracts, the Milestones Tracker is embedded with VBA codes (Macros) for ease in navigating through various reports in the file and for a more dynamic utilization of various project stakeholders.

The Milestones Tracker features interactive and dynamic dashboards.  It also includes reports generated from progress information in Primavera P6 schedules.  It contains function buttons to select tabs to display, automatically generate an outlook e-mail, instantly convert the report to PDF, etc.

Updating of the Milestones Tracker is simple by “copy-and-paste.”  After the Primavera P6 schedules are updated, the list of activities is copied from it and pasted to the tracker (click here to download Milestones Tracker Users’ Guide for more information).

If used and maintained properly, the Milestones Tracker is a powerful tool for an effective and efficient management and overall control of projects or a portfolio of projects.  The tracker has been helpful in managing a number of contracts for Sydney Metro’s City and Southwest Project and is also now being developed for the upcoming West Project.

Features

Command Center
Control what you want to see and work on
Project Dashboard
See everything about the project and the portfolio with this dynamic and interactive dashboard
Project Dashboard (Managers)
Dissect information with this interactive dashboard especially useful for managers
Project Dashboard (All Activities)
Want to see all activities in the Primavera Schedule? This dashboard is the right spot
Project Dashboard (Interface Matrix)
How do different projects and contracts affect each other? This interactive and dynamic dashboard let's you know that
Reports
Of course, reports do come handy with the use of the Milestones Tracker
Convert Reports to PDF
How about this? Instantly convert reports to PDF with a click of a button!!!

What sets this Milestones Tracker apart from your typical project dashboards?  Well, it has everything and way more!

  • Dashboards are dynamic and interactive (meaning, you can configure what you want to look at).
  • Actually, the whole workbook is interactive with the function buttons set up in the Command Center.
  • Reports are accurate to the single source of how the Primavera P6 schedules are updated.
  • Updating of the Milestones Tracker is as easily as the literal “copy-and-paste” steps.

Get the feel on what Milestones Tracker can bring you by downloading it for free!  (NOTE: Password for protected buttons is 1234.  Since the file is loaded with Macros, it’s better to run it in a computer).

Milestones Tracker

Updating The Milestone Tracker

Activities and milestones details are sourced from the Primavera P6 schedules.  As such, updating the Milestones Tracker is only possible after the schedules are updated.  Assuming that no milestones or key activities are added into the Milestones Tracker, this can be updated by direct copying of the schedule from P6 and pasting it in the Milestones Tracker’s P6Raw tab (click here to download Milestones Tracker Users’ Guide for more information).

Below are the steps in updating the tracker:

  1. Update the Primavera P6 schedules.
  2. Arrange the Primavera P6 columns as shown in Figure 14 below.  Select all activities (Ctrl + A) then copy (Ctrl + C).
  3. Open the Milestones Tracker.  In the Work Mode in the CommandCenter, toggle “Update Schedule from P6” button and enter the password.
  4. In tab “P6Raw,” select cell “K5” and paste (Ctrl + V) the copied Primavera P6 activities.
  5. Refresh the PivotTables in the Dashboard (Managers), Dashboard (All Activities), and Dashboard (Interface Matrix).
  6. That’s it!  All dashboards and reports are now completed updated.
Share
Tweet
Share
Mitigation vs acceleration in construction scheduling, illustrating how recovery terminology affects delay analysis, cost and contractual entitlement.

Mitigation vs Acceleration: The Scheduling Terms That Shape Delay Analysis and Contractual Entitlement

Understand the critical difference between mitigation and acceleration in construction scheduling and why terminology can affect delay analysis, recovery programmes, cost responsibility, and contractual entitlement. This article explains how mitigation typically involves reasonable steps to reduce delay impacts, while acceleration may require additional labour, overtime, equipment, or shifts to recover time. It also explores how planners, contract managers, and project controls professionals should frame Primavera P6 updates, schedule narratives, and client instructions to protect entitlement and support defensible delay claims.

Read More »
Interactive project planning and controls dashboard using Power BI and Primavera P6 for construction schedule tracking, earned value analysis, Gantt charts, and project performance monitoring.

The Ultimate Project Planning and Controls Dashboard Using Power BI and Primavera P6

Explore a fully interactive Project Planning and Controls Dashboard built using Power BI and Primavera P6. This article demonstrates how modern construction project controls can integrate earned value management, schedule performance tracking, Gantt chart visualization, progress photos, historical schedule submissions, and Window Analysis-based delay analysis into one centralized digital reporting environment. Discover how dynamic dashboards improve project visibility, stakeholder communication, forensic schedule analysis, and decision-making while simplifying monthly reporting workflows for complex construction and infrastructure projects.

Read More »

Where to send the file?

Build Better Projects With Expert Guidance

MLR Subscription - Browsing

Where to send the file?