Excel add-in for Primavera P6 XER files

Your P6 schedule.
A clearer report.

Organized schedules, earned value reports and a one-page Level 1, built from any Primavera P6 XER, inside Excel.

Start your 14-day free trial See how it works

Excel add-in for WindowsEVM in hours & dollarsLevel 1 in minutesDCMA 14-point checks

What it does

From a P6 XER to finished reports

XER EVM Code Organizer Pro reads an XER exported from Primavera P6 and builds ordinary Excel sheets you can filter, print and share.

ImportRead the XER, grouped by WBS or any activity code
OrganizeOutline levels, roll-ups and a Gantt on the sheet
AssessDCMA 14-point schedule checks
Earned valuePV, EV, AC and indices in hours and dollars
Level 1A one-page executive Gantt
ShareA clean .xlsx, or back to P6 as an XER

P6 does not need to be open or installed to work with the reports. Everything lives in Excel, where your team already works.

The problems it solves

Schedule data is locked in P6, and reports are rebuilt by hand

Locked in P6

An XER is hard to read without P6, and many people who need the data have no license.

Rebuilt every period

EVM and progress reports are often rebuilt by hand in Excel each month.

Level 1 takes hours

Cutting a one-page executive schedule from a detailed P6 schedule is slow.

Static PDFs

Sharing outside P6 usually means PDFs that nobody can filter.

Inside the reports

Real screens from a sample EPC schedule

Every image below comes from the add-in running on the Onshore EPC sample XER: 226 activities, status date 04-Aug-19.

Organize

A clean, filterable schedule in Excel

Import the XER grouped by WBS or by any activity codes, in the order you choose.

Outline levels and summary roll-ups
Gantt bars and milestones on the sheet
Collapse to any level with one click

Schedule sheet with colored WBS bands, roll-up dates, total float and a Gantt chart — Schedule sheet with outline levels and Gantt

Earned value

EVM in hours and in dollars, at every level

PV, EV, AC and the performance indices, rolled up by WBS or activity code.

SV, CV, SPI, CPI, ETC, EAC and VAC on every row
Level column and filters for any summary
Totals recalculate from their own sums, never added up from rows

EVM by WBS in labor hours, with Level column, BAC, PV, EV, AC and indices — EVM by WBS – labor hours

Reporting

A print-ready EVM Summary Report

The progress and performance report your team already expects, built in seconds.

Pick the section, subtotal and row codes
Performance factors, TCPI and remaining hours
ANSI-748 formula key on the page

PROGRESS and PERFORMANCE REPORT – EVM Summary Report with SPI, CSI, EAC, VAC and TCPI columns — PROGRESS and PERFORMANCE REPORT – EVM Summary Report

Planning

Cost curves and a time-phased budget

Budget spread over Monday–Friday working days, with early and late cumulative curves.

Monthly cost on early dates
Cumulative % early versus late
Planned cash flow at a glance

Cost distribution table and chart of monthly cost with cumulative early and late percentages — Cost Curve – monthly cost and cumulative %

Quality

Schedule Assessment before you issue

The DCMA 14-point checks with thresholds, counts and the first activities to fix.

Logic, leads, lags and relationship types
High float, negative float and high duration
Critical and Driving flags follow the P6 method

Schedule Assessment sheet with DCMA 14-point checks marked PASS, FAIL or N/A — Schedule Assessment – DCMA 14-point

Level 1

A one-page Level 1 in minutes, built three ways

Choose the lines, refine them on the L1 Map – rename, reorder, recolor or switch off – then build.

Way A

Pick activities

Mark them on the L1 Picker, using filters on WBS, status or any activity code.

Way B

Roll up a code

One line per activity-code value, from its earliest start to its latest finish.

Way C

Filter by a code

Each activity tagged with the code becomes its own line with its own dates.

One-page Level 1 schedule with construction milestones and FEED bars — One-page Level 1 schedule

Prints on 11x17LetterLegalA3A4

Who it is for

Built for the people who live in the schedule

Planners and schedulers

Project controls and EVM analysts

Project managers, CMs and owner's reps

Consultants reviewing contractor schedules

Capital projects · EPC · oil and gas · LNG · petrochemical · refining · power · data centers

Works in Excel

The tool your team already knows and owns.

Matches P6 logic

Critical and Driving flags follow P6's own method, so reviews line up.

Shares anywhere

Recipients need Excel only, not the add-in and not P6.

Groups your way

WBS, any activity code, or both, at any level.

Built by practitioners. Developed by EVM Controls Consulting LLC, led by Cesar Ramos, with 26+ years in schedule analysis and earned value on capital projects.

Start your 14-day free trial

Import your first XER and see your schedule, EVM and Level 1 in Excel today.

evmcs.com/xer_evm_pro_l1 info@evmcs.com Get started

Your P6 schedule.A clearer report.