djouallah/xer-reader

Excel VBA Macro to read Primavera XER files.

Download xer-reader

XER READER , a free Primavera viewer, is an Excel Macro that reads an xer and :

• Generate Project statistics.

• Draw a Gantt chart grouped by WBS

• Generate S curve Based on Duration (Actual and Forecast) ( experimental )

• Print Calendars.

• Print a WBS split by level.

• Generate Some DCMA 14 metrics.

I added a new file, it is using only PowerQuery, it is slower compared to VBA when parsing the XER but once the data is loaded into the data Model, the rest is very easy. works only with Excel 2013

I am trying now to redo the whole thing in PowerBI