Get more out of Primavera P6 in less time.
PlanIQ is an Excel add-in that reads your XER or P6 database and turns it into health checks, lookaheads, baseline variance and EVM curves — the analysis you'd otherwise rebuild by hand every update cycle - and, where you choose, writes progress and fixes back to a P6 database with a backup.
PlanIQ for Excel
Pick a source — an XER export or your P6 Professional database — and every tool works off the same data. Generic by design: no project-specific templates, no hardcoded codes.
Schedule Health Check
27 configurable checks with saved rule profiles: logic, lags and float, relationship types, resources and cost, constraints, dangling and out-of-sequence logic, calendars and invalid dates.
Guide →Compare Schedules
Baseline against update across 21 change categories - added and deleted activities, dates, durations, float, critical path, calendars, constraints and relationships.
Guide →OOS Scan and Solve OOS
Finds out-of-sequence logic in five cases, with the proof dates, then repairs it and re-tests the network.
Guide →Delay Analysis
Window analysis between two updates, or a whole series: which activities slipped by their own duration and what it did to the finish.
Guide →Look-Ahead
A 1 to 12 week look-ahead from the data date, by float band, with late starts and resource units per day.
Guide →Progress Update
Writes progress from an Excel sheet into a P6 database - previewed first, written to a new copy or to the original after a backup.
Guide →Split Revision
Splits in-progress activities at the data date into actual and remaining parts, with smart logic routing and a proof report, and writes a new XER.
Guide →EVM and S-curve
Earned value from P6 (KPIs, Earned Schedule, EAC range, WBS roll-up, drivers, trend) and S-curves for cost, labour, non-labour and material.
Guide →Float and Critical Path
Float bands and the critical and near-critical activities from the P6 database, in working days on each activity calendar.
Guide →Gantt, WBS styling and reports
Colour and group by WBS level, build Gantt charts in Excel, WBS and activity-code charts, an activity tracker and a Power BI export.
Guide →Resource control
Resource match, at-completion, assign, remove and solve resource issues in a P6 database, with preview and backup.
Guide →Sheet utilities and AutoCAD progress
Paste visible only, split text, WBS to levels, field mapping and fix tools - plus reading an AutoCAD drawing and marking progress on it.
Guide →Project Vault and database tools
Import and export XER, duplicate and delete projects, remove shared-user locks, reset a database password, clean and repair a P6 database.
Guide →Update Manager
PlanIQ checks this site for new releases, shows what changed and installs the verified download. Check for Updates is in the Help group.
Guide →Latest PlanIQ release
The same feed the in-tool Update Manager reads. Install from here or from PlanIQ › Help › Check for Updates.
Loading release notes…
P6 From Zero to Professional
Series 1 · Primavera P6 fundamentals, Level 1–2 · 20 episodes, free on YouTube
One skill per video, all built on the same course project. Follow along and you finish with a complete schedule that is baselined, resource-loaded and updated.
- EPS, calendars and a WBS set up the way live projects need them
- Activities, relationships, constraints and the critical path after F9
- Layouts, activity codes, roles and resource loading
- Baselines, progress updates, XER exchange and printing
Level 1 · Foundations EP01–EP10
- EP01What is Primavera P6?
- EP02P6 Interface Explained
- EP03EPS and OBS
- EP04Creating a New Project
- EP05Calendars
- EP06WBS – Work Breakdown Structure
- EP07Activities
- EP08Activity IDs
- EP09Activity Types
- EP10Milestones
Level 2 · Scheduling and control EP11–EP20
- EP11Relationships
- EP12Constraints
- EP13Scheduling (F9) & Critical Path
- EP14Layouts, Filters & Grouping
- EP15Activity Codes
- EP16Roles
- EP17Resources
- EP18Baselines
- EP19Updating a Schedule
- EP20XER Export, Import & Printing
Planning guides on YouTube
Practical videos on Primavera P6, planning and project controls, and using PlanIQ on real updates. Series 1 starts with the episodes below.
Damith Priyankara
Planning Engineer · Abu Dhabi, UAE
PlanIQ is built by a planning engineer working with Primavera P6, delay analysis and EVM on construction projects in the UAE. Every feature started as a spreadsheet that got rebuilt one update cycle too many.
Help centre
Step-by-step guides for every PlanIQ window — the Help button in the tool lands here.
Open help →Release notes
Every version, every change, with links to the guide for each new feature.
See updates →Ready for your next update cycle?
Free to download. Works with your existing XER exports.