Activity Codes
Design a coding structure that lets you group, sort, filter and summarise thousands of activities by discipline, area, phase or contractor.
In practice: Build a code dictionary and use it to slice a large schedule.Advanced levelPage 04 / 07
Advanced level.
Work smarter. Control better. Deliver more. Move from building a schedule to interrogating it, comparing it and turning it into the numbers a project board asks for.
07 modulesExcel integrationCash flow & S-CurveFor working planners
Advanced / 07 modulesSEC / 01The curriculum
Control the programme.
The functions experienced planners use to keep a large, changing schedule under control — and prove what moved.
Global Change
Make controlled, project-wide edits to activity data in one pass — the safe way to shift calendars, durations, codes and custom fields at scale.
In practice: Apply a global change, preview the impact, then roll it back.Comparison of Schedules
Compare a revised programme against the baseline or a previous submission, and isolate exactly what moved, why, and by how much.
In practice: Run a claim-ready comparison and document the variances.Rename ID's
Re-sequence and standardise activity IDs across a programme without breaking logic — essential when merging schedules from multiple parties.
In practice: Renumber a merged schedule and verify the integrity of relationships.Review Progress Status
Move beyond percent complete: use status, remaining duration, actual dates and stored period performance to see the true position of the works.
In practice: Audit a partially progressed schedule and flag inconsistencies.Excel Integration
Move structured data between Excel and Primavera P6 cleanly, using import templates and field mapping instead of slow manual entry.
- Import activities from Excel
- Resource loading from Excel
- Cost loading from Excel
Cash Flow, Histogram & S-Curve
Turn the schedule into the numbers a project board asks for: resource histograms, cost profiles, cash flow and the cumulative S-Curve.
In practice: Generate a monthly cash flow profile and read the S-Curve.SEC / 02From schedule to decision
Numbers the board can read.
Cash flow & S-Curve
Monthly cost Actual S-Curve Baseline
Resource histogram · Cost loading from ExcelBaseline 01 · Data date M07
Cash flow, histogram & S-Curve
A schedule is also a financial forecast.
Once activities carry resources and cost, Primavera P6 can show how the work translates into monthly spend — and how the cumulative curve is tracking against the approved baseline.
In this module you generate the resource histogram, build the cash flow profile and read the S-Curve: where the project is front-loaded, where it flattens, and what a deviation actually means.
Resource histograms from assigned resources
Monthly and cumulative cost profiles
Baseline vs actual variance at data date
SEC / 03Excel integration
Move data, not deadlines.
Three workflows that turn hours of manual entry into a repeatable import — taught with real templates and real error checks.
Import activities
Build large schedules from a structured Excel sheet with clean field mapping — instead of typing activity after activity.
Resource loading
Push resource assignments into the programme in bulk, then check the effect on durations and the histogram.
Cost loading
Load cost data from Excel and turn it into a cash flow profile the project team can plan against.
SEC / 04Level details
The essentials.
| Level | Advanced — for planners already comfortable with the basics. |
|---|---|
| Tagline | Work smarter. Control better. Deliver more. |
| Prerequisite | Foundation level or equivalent working knowledge of P6. |
| Modules | 07 — including Excel integration (activities, resources, cost) and cash flow, histogram & S-Curve. |
| Format | Accelerated, practical and hands-on. Confirm schedule and venue with admissions. |
| Pathway | Take Foundation and Advanced together for the complete programme. |
Advanced / limited seats