P3 and P5/P6 are different programs, not just two different versions of the same one. So, many algorithms and procedures are different.
The way to produce and then save a report for export to EXCEL is rather easy. The produced format is csv and you can set a parameter that Excel automatically opens after the data was produced - the report ran. We produce most of our s-curves this way - just run the report. I dont miss the P3 ability.
Just try it.
Regards
Dieter
Member for
18 years 6 months
Member for18 years6 months
Submitted by Mubashir wani on Thu, 2008-06-12 00:38
Thanks for your reply, you are right but i guess in P5 we can not export "Resource Usage Spread sheet" in excel format. Where as in P3 we can get such outputs in formats like csv or wk1.There it used to help me in production of S-Curves with lot of flexibility.
Please Comment
Member for
18 years 9 months
Member for18 years10 months
Submitted by Dieter Wambach on Wed, 2008-06-11 14:40
Youll create a report with "Time Distributed Data" marked from the group Resource Assignments (or a similiar name). Then youll be guided by the wizzard. As output format youll select text/ASCII-file.
Member for
17 years 4 monthsRE: export resource usage spread sheet in p5
can u do the favour the same to me,...
with regards,
Mr. Ameen N Pasha,
ameen_pasha10@yahoo.com
Member for
18 years 6 monthsRE: export resource usage spread sheet in p5
I am really thankful to both of you.
I am able to do it now.
Thank you once again
Member for
22 years 8 monthsRE: export resource usage spread sheet in p5
Mubashir
I try to give you a step by step guide. HTH
1. Open Your project
2. Then Click assignment
3. Change Timescale @ the spreadsheet to month or week
4. Highlight the activity
5. Click Ctrl C
6. Open Excel
7. Click Ctrl V
That should work
ALex
Member for
18 years 9 monthsRE: export resource usage spread sheet in p5
Mubashir
reporting in P5 is very easy. Try it.
Print resource usage profile:
View "Activities" --> "resource usage profile" --> File --> "Print Preview" --> "Page Set-up (The Icon upper left corner) --> walk through the detail tabs --> "Options" mark "Resource Usage Profile"
Regards
Dieter
Member for
18 years 6 monthsRE: export resource usage spread sheet in p5
i still unable to do it, one more query sir: how to print resource usage profile??
Member for
18 years 9 monthsRE: export resource usage spread sheet in p5
Mubashir
P3 and P5/P6 are different programs, not just two different versions of the same one. So, many algorithms and procedures are different.
The way to produce and then save a report for export to EXCEL is rather easy. The produced format is csv and you can set a parameter that Excel automatically opens after the data was produced - the report ran. We produce most of our s-curves this way - just run the report. I dont miss the P3 ability.
Just try it.
Regards
Dieter
Member for
18 years 6 monthsRE: export resource usage spread sheet in p5
Dieter Wambach
Thanks for your reply, you are right but i guess in P5 we can not export "Resource Usage Spread sheet" in excel format. Where as in P3 we can get such outputs in formats like csv or wk1.There it used to help me in production of S-Curves with lot of flexibility.
Please Comment
Member for
18 years 9 monthsRE: export resource usage spread sheet in p5
Mubashir
Youll create a report with "Time Distributed Data" marked from the group Resource Assignments (or a similiar name). Then youll be guided by the wizzard. As output format youll select text/ASCII-file.
Regards
Dieter