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.

Resources - P3 or Excel

8 replies [Last post]
Mon, 2005-09-12 10:15
Allison Robb
User offline. Last seen 18 years 10 weeks ago. Offline
Joined: 15 Aug 2005
Posts: 9
Groups: None
I have a question about resources and the reports P3 is able to generate.

Our requirement is to show resources required for each work package with number of days per month. Is this achievable in P3
Top

Replies

Thu, 2005-12-15 07:30
#1
manulal inasu
User offline. Last seen 18 years 15 weeks ago. Offline
Joined: 15 Oct 2005
Posts: 52
Groups: None
Hi Oscar,

If your question is about graphs in excel, it is quite possible. Go to Chart options> Datalabels > and check values. you will have the values also on the bar.

Regards,

manu.
Top
Sat, 2005-10-15 07:02
#2
Oscar Wilde
User offline. Last seen 16 years 10 weeks ago. Offline
Joined: 7 Oct 2005
Posts: 166
Groups: None
Is there any way when you have a long duration for your resources say 18 months to print the resources on the graph per day I know you can point and get the number but any other way

Oscar
Top
Thu, 2005-09-15 15:00
#3
Charleston-Joseph...
User offline. Last seen 2 years 39 weeks ago. Offline
Joined: 10 Jul 2005
Posts: 1347
Groups: None
Hi Allison,

correction from my previous post

"... I can imagine ..." should be "... I can’t imagine ..."

Im sorry for the inconvenience.

Cheers

Charlie
Top
Thu, 2005-09-15 14:57
#4
Charleston-Joseph...
User offline. Last seen 2 years 39 weeks ago. Offline
Joined: 10 Jul 2005
Posts: 1347
Groups: None
Hi Allison,

Please take note the PPeers that response to your thread comes from an environment outside IT.

Im not from IT and I can imagine the resources required in IT will be that big as that in building works, heavy civils or petrochemical/oil & gas.

I would suggest generate your resources using excel. It is simple and it is not complicated.

Regards,

Charlie
Top
Thu, 2005-09-15 06:44
#5
MARTIN EMMANUEL RAJ
User offline. Last seen 12 years 39 weeks ago. Offline
Joined: 26 Feb 2004
Posts: 5
Groups: Petro-Chem / Oil & Gas
Allison,

Try this...

In the Resource Loading Report, In Tab Timescale - choose unit as "DAY"

your output will be in days which is your requirement.

Additionally In Tab Format - choose export to csv format. The output file created can be easily handled through Excel.

Hope this helps!!!

found any other way? pl. have your say.....

Good Luck,

Martin
Top
Tue, 2005-09-13 21:51
#6
Sukumaran Subaram...
User offline. Last seen 8 years 40 weeks ago. Offline
Joined: 2 Mar 2005
Posts: 229
Groups: GPC Malaysia
Allison,

Else, go to Resource Table. Use the Resource Profile/Table dialog box to specify the requirement and filter the resources according to you preference.

Regards.
Top
Mon, 2005-09-12 11:17
#7
Raja Izat Raja Ib...
User offline. Last seen 12 years 48 weeks ago. Offline
Joined: 2 Jun 2005
Posts: 299
Groups: GPC Malaysia, Petro-Chem / Oil & Gas
Hi
U can use - "Tubular report > resource > loading" from there u can see distribution resource by month day hrs etc and u can roll up as per WBS or detail activities. Its will show as per schedule
Top
Mon, 2005-09-12 10:54
#8
Steven Oliver
User offline. Last seen 11 years 22 weeks ago. Offline
Joined: 8 Nov 2002
Posts: 313
Groups: None
How have you loaded the resource quantity ? Hours or days ?

As far as I recall, P3 will generate a distribution based on this value.
Top