Create an ’S’ curve from P5 into Excel
Forum Sponsor
Top Posters
Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
Im 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.
Otherway round, how to create s- curve for a EPC project in P3, your help is appreciated.
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.