Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

export resource usage spread sheet in p5

8 replies [Last post]
Wed, 2008-06-11 08:13
Mubashir wani
User offline. Last seen 10 years 38 weeks ago. Offline
Joined: 6 May 2007
Posts: 12
Groups: None
Can anybody help me to know how can we export resource usage spread sheet in p5
Top

Replies

Tue, 2008-06-17 01:38
#1
Ameen Pasha
User offline. Last seen 10 years 10 weeks ago. Offline
Joined: 17 Jun 2008
Posts: 21
Groups: Civil Engineering, GPC Qatar
can u do the favour the same to me,...

with regards,

Mr. Ameen N Pasha,
ameen_pasha10@yahoo.com
Top
Thu, 2008-06-12 06:33
#2
Mubashir wani
User offline. Last seen 10 years 38 weeks ago. Offline
Joined: 6 May 2007
Posts: 12
Groups: None
I am really thankful to both of you.
I am able to do it now.
Thank you once again
Top
Thu, 2008-06-12 06:04
#3
Alex Wong
User offline. Last seen 11 years 4 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
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
Top
Thu, 2008-06-12 05:52
#4
Dieter Wambach
User offline. Last seen 6 years 52 weeks ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
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
Top
Thu, 2008-06-12 02:48
#5
Mubashir wani
User offline. Last seen 10 years 38 weeks ago. Offline
Joined: 6 May 2007
Posts: 12
Groups: None
i still unable to do it, one more query sir: how to print resource usage profile??
Top
Thu, 2008-06-12 00:56
#6
Dieter Wambach
User offline. Last seen 6 years 52 weeks ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
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 don’t miss the P3 ability.
Just try it.
Regards
Dieter
Top
Wed, 2008-06-11 23:38
#7
Mubashir wani
User offline. Last seen 10 years 38 weeks ago. Offline
Joined: 6 May 2007
Posts: 12
Groups: None
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
Top
Wed, 2008-06-11 13:40
#8
Dieter Wambach
User offline. Last seen 6 years 52 weeks ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
Mubashir
You’ll create a report with "Time Distributed Data" marked from the group Resource Assignments (or a similiar name). Then you’ll be guided by the wizzard. As output format you’ll select text/ASCII-file.
Regards
Dieter
Top