Skip to content

Create an ’S’ curve from P5 into Excel

Glenn DouglasMember for 20 years 5 months
Created
3
1
0
Hi everyone,

i would like to create an S curve from my fully resoursed plan, but in excel (managers request) rather than P3e.

I’ve done it before but have had complete brain fade and need a step by step reminder.

Hope someone can help.

3 replies

Oldest first
  1. 0
    David Podmore ·
    No worries - was all had those...

    Run (or create) a report that will deliver the data you want. EV, Budget, Actual etc. I would suggest just getting the report to do Grand Totals as this is all you will need for a graph.

    When you run the report, send it to an ASCII CSV file which will be saved in a default folder which you can change. If selected, Excel will open this file the moment it is saved and you can do your thing.

    Any more detail just PM me.


  2. 0
    Nar Thap ·
    Otherway round, how to create s- curve for a EPC project in P3, your help is appreciated.
  3. 0
    David Podmore ·
    I’m a bit rusty on P3 but as I recall you can run a report under Tools, Tabular Report, Costs and send the result to screen, printer or in your case, a CSV file for Excel to use.
    You can also display data on the screen in columns as you do normally to administer/modify your programme and use Ctrl-A to select all cells/data, followed by Ctrl-C to copy it and Ctrl-V to paste it into an Excel spreadsheet. You do loose the grouping etc but keep the order. Try it and see.

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?