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.

wbs resource loading

13 replies [Last post]
Tue, 2004-08-17 23:53
Zq qz
User offline. Last seen 12 years 14 weeks ago. Offline
Joined: 6 Jun 2003
Posts: 163
Groups: None
Hello experts,
How to make resource loading using WBS codes as grouping " thesame as using activity codes".
Top

Replies

Wed, 2004-10-20 01:49
#1
Richard Brodit
User offline. Last seen 16 years 22 weeks ago. Offline
Joined: 1 Feb 2002
Posts: 9
Groups: None
Dear Mm Don,

Mr. Ming Tse gave you a definite answer and yes, Alex is right in saying that if your WBS is only 2 level, you can make a global change.

Another thing to add as well is maybe you also check your activity ID coding so you can have more options in organizing your resources.

More power too.Don

PS:Hi Ming, been a long time since we see each other in the HK Airport. Hope you’re doing OK

Regards,

Richard
Top
Tue, 2004-10-19 21:54
#2
Alex Wong
User offline. Last seen 11 years 4 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
If you WBS is only 2-3 level use global change is good enough
Top
Tue, 2004-10-19 21:13
#3
MK TSE
User offline. Last seen 3 years 46 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
Export the WBS code by RA onto Excel, re-value the description to fit the classification, then import as resources dictionary.

Hope help and save time.
Top
Tue, 2004-10-19 10:08
#4
Zq qz
User offline. Last seen 12 years 14 weeks ago. Offline
Joined: 6 Jun 2003
Posts: 163
Groups: None
Richard,
Can you explain how you can make resource loading using WBS to organize or sub total.
More Power
Top
Tue, 2004-10-19 04:02
#5
Richard Brodit
User offline. Last seen 16 years 22 weeks ago. Offline
Joined: 1 Feb 2002
Posts: 9
Groups: None
Paul,

I agree somehow with you. I don’t know why you will have to copy activity codes into WBS

As far as the question is concerned,Resource loading from both WBS or Activity Code can be done,
but the difference I see (since ’m using both systems at work) is that I find WBS to be more rigid and Activity Codes to be more flexible.

Anyway, each system has its advantages over the other on a case to case basis.

Example:

If you want to see clearly the contents of your programme in one list: WBS is good

00 Project Name
00.01 Excavation
00.01.02 Area 1
00.02 Piling
00.02.01 Area 1

But as you can notice, in WBS you have to duplicate typing "Area 1" , In Activity Code. You can type "Area 1" in LOCATION and use it in Excavation and Piling. But as your activity code grows in nos. , sometimes, it is confusing to find "where you put which codes where?" Unless of course, you have a very good structured coding, which goes back to WBS structure. JUST A THOUGHT

Richard
Top
Tue, 2004-09-28 07:31
#6
BEEPEE PAUL
User offline. Last seen 19 years 18 weeks ago. Offline
Joined: 6 Jan 2004
Posts: 16
Groups: None
What is the utilisaion of copying activity codes into WBS.........Why is it required?????
Top
Thu, 2004-08-19 11:46
#7
Brennan Westworth
User offline. Last seen 6 years 50 weeks ago. Offline
Joined: 23 Feb 2003
Posts: 150
Groups: None
hmmm.... i read it back and im still convinced he wants to turn activity codes into WBS ?

if you want to turn WBS into activity codes just reverse my procedure (you will need to define the activity codes with a string length the same as your WBS structure) and use the Mid() function in excel instead of concatenate :D

One thing to look out for tho when transfering WBS to Activity codes is that WBS levels are not always uniform enough... Level 1 will usually be the project, however level 2, 3, 4... may contain mixed data types within the one level
Top
Thu, 2004-08-19 04:58
#8
Forum Guest
User offline. Last seen 2 years 27 weeks ago. Offline
Joined: 28 Jan 2009
Posts: 1
Groups: None
Well done Brennan but it is exactly the reverse of what Donato is asking... Anyhow, I think Donato got your idea.

Cheers.
Top
Thu, 2004-08-19 01:47
#9
Brennan Westworth
User offline. Last seen 6 years 50 weeks ago. Offline
Joined: 23 Feb 2003
Posts: 150
Groups: None
that was me btw
Top
Thu, 2004-08-19 00:49
#10
Forum Guest
User offline. Last seen 2 years 27 weeks ago. Offline
Joined: 28 Jan 2009
Posts: 1
Groups: None
the best way to do it would be to use export / import

here is an example:

Firstly set up your WBS structure. For example if you want to duplicate the activity codes "Project Number" and "Phase" then set up your WBS structure so that level one is the string length of your "Project Number" Activity Code and level two is the string length of your "Phase" activity code.

Next create an export specification with Activity ID, Activity codes and WBS code. Run the export and open it in excel. Use the "concatenate" function to join the two activity codes in the WBS code feild and save the file.

Back in P3 set up an import specification to import this file.

Finally populate the WBS dictionary with the code titles (you may use batch to do this but it would only be worth it if the data entry of this information would be too painful)

Hope this helps
Brennan
Top
Thu, 2004-08-19 00:30
#11
Forum Guest
User offline. Last seen 2 years 27 weeks ago. Offline
Joined: 28 Jan 2009
Posts: 1
Groups: None
There is no automatic way but you can use export/import, modifying the exported file (splitting the codes) with a bit of imagination particularly on the structure. You also have to re-type the descriptions in the activity codes definition. The problem you may encounter is that there may not be enough fields in the activity codes. If that is the case, since this operation is not routine, you can duplicate the project and delete some of the activity codes to produce the desired report. This is a little tedious at the first but once the activity codes are defined and the export file are correctly structured, the next time would be much easier (by "transfer" activity codes and direct export/import to the duplicated schedule). This is just a suggestion for an immediate solution. Maybe others out there may suggest a more simple solution.
Top
Wed, 2004-08-18 05:39
#12
Zq qz
User offline. Last seen 12 years 14 weeks ago. Offline
Joined: 6 Jun 2003
Posts: 163
Groups: None
Is there any command to duplicate this automatically in the p3 menu?
Top
Wed, 2004-08-18 00:13
#13
Forum Guest
User offline. Last seen 2 years 27 weeks ago. Offline
Joined: 28 Jan 2009
Posts: 1
Groups: None
Duplicate the WBS codes in the Activity codes.
Top