Create an ’S’ curve from P5 into Excel

D
David Podmore 👤 Member for 20 years 3 months

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.

N
Nar Thap 👤 Member for 18 years 10 months

Otherway round, how to create s- curve for a EPC project in P3, your help is appreciated.

D
David Podmore 👤 Member for 20 years 3 months

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.




Featured Partner

Top Posters

Mattvtek
0 posts
Gareth Evans
3 posts
PP Admin
3, 129 posts
Rajkamal Tangirala
5 posts
Rahul Kumar
1 posts
blake333_
0 posts
Jeamiell Ostrovsky
2 posts
Hamzah Ahmed
0 posts
Quinton van Eeden
3 posts
Sunchana Johnston
12 posts