Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Excel spread sheet to read XER files

5 replies [Last post]
Ron Beechey
User offline. Last seen 4 years 4 weeks ago. Offline
Joined: 13 Apr 2016
Posts: 28
Groups: None

Looking for excel spread sheets or the likes to read xer files and produce curves and any other helpful information.   I have one "01-XER-READER" which I found very good but wondered if there was a actual curve that could be added.  There may be also an update which I have not been able to find.   Always good to not reinvent the wheel if someone has already worked on something.

Replies

Joel Roberts
User offline. Last seen 13 weeks 6 days ago. Offline
Joined: 17 Mar 2017
Posts: 37
Groups: None

Hi Ron.

You can use ScheduleReader to read XER, XML or XLS files.

You can see S-Curves, Histograms, compare baselines, trace predecessors and succesors, filter, group, sort through data and even create reports from the data inside the schedule.

A free 15-day trial of the application can be downloaded through the website mentioned above.

Zoltan Palffy
User offline. Last seen 3 weeks 3 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

yes project tracker can do that 

David Kelly
User offline. Last seen 1 year 37 weeks ago. Offline
Joined: 19 Oct 2004
Posts: 630

Bryc,

 

Easy. Use Project Tracker.  Reads the database, lets you take baselines, makes "s" curves with the data range table underneath.

bryc ali
User offline. Last seen 1 year 28 weeks ago. Offline
Joined: 3 Nov 2009
Posts: 43

How we can read the data base directly to produce S curve ?

David Kelly
User offline. Last seen 1 year 37 weeks ago. Offline
Joined: 19 Oct 2004
Posts: 630

Project Tracker does everything for a couple of hundred pounds. Even reads the database directly so you can produce real "S" curves without creating a second data source.