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

Download

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

OTHER RECENT BLOGS

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 »
Marty Fuentes May 17, 2026
Project planning and scheduling practices comparison across the USA, UAE, and Australia featuring construction project controls, Primavera P6 scheduling, global infrastructure, and international project management concepts.

How Planning and Scheduling Practices Differ Across the USA, UAE, and Australia

Explore the key differences in project planning, scheduling, and project controls practices across the USA, UAE, and Australia based on real industry experience. This article shares firsthand insights into USACE and NAVFAC scheduling requirements, the fast-paced construction environment of the Middle East, and the contrasting project controls culture in Australia. Learn how schedule management, delay analysis, reporting standards, cost loading, and contractual expectations vary across regions, and discover practical lessons for planners and schedulers looking to work internationally in construction and infrastructure projects.

Read More »
Marty Fuentes May 15, 2026
MLR Project Management & Consultancy | planning engineer vs scheduler comparison

Planning Engineer vs Scheduler: Key Differences Explained from Real Experience

What is the difference between a planning engineer and a scheduler? This article explains the key differences between a planning engineer vs scheduler based on real-world construction project experience. Learn how their roles, responsibilities, and skills differ, from schedule development and progress tracking to forecasting, delay analysis, and project planning strategy. If you’re a planner, project manager, or construction professional, this guide will help you clearly understand where scheduling ends and planning begins.

Read More »
Marty Fuentes April 24, 2026

Where to send the file?

Build Better Projects With Expert Guidance

MLR Subscription - Browsing

Where to send the file?