P6 vs MS Project vs Excel: The Great Schedule Tracking Dilemma in Construction

Walk into any site trailer across the Middle East, South Asia, or the UK, and you will witness an unspoken paradox: on the wall hangs a 4,000-activity Primavera P6 baseline schedule printed on a multi-page plotter sheet with vibrant critical paths and milestones. Yet on the Project Manager’s desk sits an open dual-monitor setup displaying an Excel spreadsheet with manual percentages, custom S-curves, and color-coded lookahead dates.

This is construction’s worst-kept secret: We plan in Primavera P6 to satisfy the client, but we track in Excel to survive the job.

Across small, mid-size, and even mega-projects, planning engineers are caught in a relentless cycle of double-entry work. They spend weeks negotiating baseline approval in P6, only to abandon live tracking inside the software and rebuild secondary progress trackers in Microsoft Excel.

Why does the world's most powerful enterprise project management tool fail to retain the trust of site execution teams, and what does this mean for project control, contractual claims, and site productivity?

---

STEP 011. The Tale of Three Tools: Where Each Truly Shines

To understand the tracking dilemma, we must dissect what each tool was genuinely engineered to accomplish.

---

STEP 022. The Baseline Submittal Trap

In commercial and infrastructure contracts worldwide—whether governed by FIDIC Red Book (Clause 8.3), NEC4, or Pakistan Engineering Council (PEC) standard bidding documents—contractors are contractually bound to submit an Enterprise CPM schedule within 28 to 42 days of the Commencement Date.

To achieve client and Consultant approval, the Planning Engineer must build an intricate network:

• Work Breakdown Structure (WBS) down to Level 4 or 5.
• Hundreds or thousands of logic ties (Finish-to-Start, Start-to-Start with lags).
• Resource loading (labor man-hours, heavy plant, major materials).
• Cost loading to generate contractual cash-flow curves.

The baseline gets approved after rounds of consultant comments. The contractual box is checked.

Then site execution begins—and the wheels fall off.

---

STEP 033. Why P6 Tracking Breaks Down on Ground

If Primavera P6 has the mathematical engine to calculate critical paths and floats down to the minute, why do teams stop tracking inside it?

A. The "Out-of-Sequence" Nightmare

Real construction rarely follows theoretical logic. Concrete pour happens before the lean concrete curing duration officially finishes in P6; blockwork starts on the first floor while ground floor beams are still curing because the mason subcontractor had an idle crew.

In P6, an activity starting out of sequence triggers broken logic warnings, negative floats, or phantom critical paths unless the scheduler carefully chooses between Retained Logic and Progress Override. For a busy site team, correcting hundreds of out-of-sequence logic errors every week feels like administrative punishment rather than productive control.

B. The Ambiguity of "% Complete" Types

P6 provides three distinct percent complete methods:

1. Duration % Complete: Driven strictly by remaining duration.
2. Physical % Complete: Independent of time, based purely on engineering judgment or field quantity survey.
3. Units % Complete: Driven strictly by resource consumption.

If a site engineer enters 50% physical progress but forgets to recalculate the Remaining Duration, P6 will not push the end date as expected. Conversely, advancing the Data Date without clean actuals often results in unstarted predecessor activities being pushed into the future, creating illogical floats that confuse the Project Manager.

C. The Executive Communication Gap

Project Directors and Site PMs do not want to navigate a 5,000-activity Gantt chart to answer three basic questions:

• Are we casting the 3rd-floor slab this Thursday or next Monday?
• Which trade is holding up the MEP rough-in?
• What is our physical progress variance versus the approved target?

P6 reports are text-heavy, font-dense, and difficult to format for instant visual clarity on WhatsApp, tablet screens, or A3 weekly site coordination meetings.

---

STEP 044. Why Project Managers and PMOs Retreat to Excel

Excel is not a scheduling tool, but it is construction’s ultimate operating system. When deadlines loom, old-school PMOs and practical Project Managers mandate Excel tracking sheets for three compelling reasons:

+-----------------------------------------------------------------+
|               THE EXCEL PROGRESS DASHBOARD REALITY              |
+-----------------------------------------------------------------+
| Activity Name     | Target % | Actual % | Variance | Status     |
| Substructure Rebar| 100%     | 100%     |   0%     | [ COMPL ]  |
| Retaining Wall CW |  80%     |  60%     | -20%     | [ BEHIND ] |
| Underground MEP   |  45%     |  50%     |  +5%     | [ AHEAD  ] |
+-----------------------------------------------------------------+
|  * Formula-driven S-Curve updates automatically                 |
|  * Conditional formatting instantly highlights delays           |
|  * Every site engineer can update their section in 2 minutes    |
+-----------------------------------------------------------------+