’S’ curve form P5 to Excel query
In the Open Standard
Glenn DouglasMember for 20 years 5 months
- Created
- 2
- 3
0
Any ideas?
The ’S’ curve i’m trying to create is still giving me some problems.
All I want is cumulative resourse over the duration.
I created a report with a filter than picked up all the resourse codes and then put it into Excel, however all the data has come out as days (e.g. 5.0d) I can’t seem to change the format to read just a number so that I can total all the resourse for any given day (and so on).
Am I collecting the correct data in the first place or can I change the format in excel?
Any help would be appreciated.
Glenn
The ’S’ curve i’m trying to create is still giving me some problems.
All I want is cumulative resourse over the duration.
I created a report with a filter than picked up all the resourse codes and then put it into Excel, however all the data has come out as days (e.g. 5.0d) I can’t seem to change the format to read just a number so that I can total all the resourse for any given day (and so on).
Am I collecting the correct data in the first place or can I change the format in excel?
Any help would be appreciated.
Glenn
2 replies
Oldest first- 0Dieter Wambach ·Hi Glenn
You’ll create a report out of the group activity resource assignments and with "time distributed data" switched on. Then group by "Ressource ID name", "show sumaries only"; --> Timescale: by days or by months, --> Time interval fields: Planned units, actual units, at completion units (check if single or cumulative values fit better) --> Create ASCII file
This should work.
Regards
Dieter - 0Dieter Wambach ·Hi John
As you know, P6 can produce S-curves and has EV capabilities as well. The reason for exports is different. Rather frequently you find situations, where certain layouts are agreed. If you’ll modify the tinyest detail, this will be recognized and the contents doubted. So it’s easier to export and to contunue with absolutely the same layout, produced with the same software as usual.
Regards
Dieter
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?