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.

summarise for weightages

10 replies [Last post]
sudheesh TR
User offline. Last seen 11 years 28 weeks ago. Offline
Joined: 26 Jul 2008
Posts: 8
Groups: None
Hai Guyzz,
I have assigned man days for different categories as resouces. Now i need to summarize the progress percentsge
based on these weightages, also i need to show the same on the summary bar. What i have been doing is, first export the weightages to excel then calculate the percentage in exel itself but i was not able to show it in the P3 layout. So i will highly appreciate, if anyone could advise me in this.

Replies

Pranab Kumar Deb
User offline. Last seen 3 years 17 weeks ago. Offline
Joined: 23 Jan 2007
Posts: 291
Dear sudheesh,

Without deleting the resources you cannot have the effect that you want.
Maybe you should see
View>resource profile
select the "Manhours" resource from there .

Hope this helps
regards
pranab
sudheesh TR
User offline. Last seen 11 years 28 weeks ago. Offline
Joined: 26 Jul 2008
Posts: 8
Groups: None
Dear exofo,

i believe i m not clear to u.
exofo Ng
User offline. Last seen 16 years 8 weeks ago. Offline
Joined: 30 Jul 2008
Posts: 9
Just modify and select the resource u want.. that it and run..
sudheesh TR
User offline. Last seen 11 years 28 weeks ago. Offline
Joined: 26 Jul 2008
Posts: 8
Groups: None

I have many resources in my dictionary. also i cant delete any one of these resources. Can i make a layout based on some particular resources and summarize the same. Please explain if u know...

Cheers
Sudheesh
sudheesh TR
User offline. Last seen 11 years 28 weeks ago. Offline
Joined: 26 Jul 2008
Posts: 8
Groups: None

I have many resources in my dictionary. also i cant delete any one of these resources. Can i make a layout based on some particular resources and summarize the same. Please explain if u know...

Cheers
Sudheesh
exofo Ng
User offline. Last seen 16 years 8 weeks ago. Offline
Joined: 30 Jul 2008
Posts: 9
layout by resource mean u need to assign a unique resource name or ID. these could be in term of disciple work or system works. then just use a summary by resource, then run it.. eg Mechanical works, Piping works, electrical works etc..
sudheesh TR
User offline. Last seen 11 years 28 weeks ago. Offline
Joined: 26 Jul 2008
Posts: 8
Groups: None
Thanks,
But i dint underastand what u mean by create a layout by resources, Thankful if u could explain it to me. I can use excel but i wana know is there any method to do it.

Cheers,
sudheesh
Christian Adrian ...
User offline. Last seen 5 years 9 weeks ago. Offline
Joined: 3 Jun 2003
Posts: 193
Groups: None
Sudheesh

I would suggest that you create a layout by resources and then summarize it, perhaps that is what you have in mind otherwise just use the excel...
sudheesh TR
User offline. Last seen 11 years 28 weeks ago. Offline
Joined: 26 Jul 2008
Posts: 8
Groups: None
Thanks for ur reply. But i hope u dint get me. If i summarize by resources it will take all the resources including material without considering their units. Instead i need to summarize based on some specific category of resources only, like man hours..
exofo Ng
User offline. Last seen 16 years 8 weeks ago. Offline
Joined: 30 Jul 2008
Posts: 9
Have u try using summary by resource report? At least it give you a layout of waht u are doing in excel.. save time