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.

Converting WBS into OBS(Activity Codes)

12 replies [Last post]
Tue, 2005-11-15 06:03
MUHAMMAD IQBAL
User offline. Last seen 6 years 50 weeks ago. Offline
Joined: 29 Aug 2005
Posts: 34
Groups: Planning, Claims & Contracting, TILOS


Hi
i have developed a schedule on p3 using WBS

now i want to change/convert it into Activity Codes so that while organizing it in OBS(Activity Codes) the presentation/Layout should look like same as in WBS.

can it be done by Global change or any other quick technique

thanks



Top

Replies

Mon, 2005-11-21 02:36
#1
Jorge Taguinod
User offline. Last seen 2 years 41 weeks ago. Offline
Joined: 8 Jul 2003
Posts: 139
Groups: P6-IAP Jedis, Petro-Chem / Oil & Gas, Pinoy Planning Planet Community
Hi MUHAMMAD IQBAL,

WBS and Activity Coding work different ways.
- Use WBS when you want to decompose (breakdown) your project into smaller units (scope definition).

- Use Activity Coding if you want to categorize activities so that you may be able to organize them from different perspectives.

With these in mind, you can come up with varying levels of detail using WBS. For example, subscope 1 can have 5 levels, while the next subscope could only have 2 levels.

If you use WBS, then your structure (how activities are grouped) is fixed -- simply because a WBS is supposed to be fixed.

On the other hand, if you want to slice and dice project information from different perspectives, (by responsibility, by contractor, by phase, etc. or a combination of these), then what you would do is use activity coding. However, some activities would have blank activity code values simply because some levels of detail may not be applicable to some activities.

This would leave you with blank title bands. With activity coding, you can easily organize activities and view the project from different perspectives, but you would have to contend with a consistent number of level of details.

You may be inquiring how to convert a WBS to activity codes because your structure is basically similar and would like to do the conversion faster. Global change may take longer because you will have to keep on modifying a definition before you’re able to convert all the values.

I’d advise that you either:
1. Use Excel - organize by wbs and copy and act code values; or
2. Use P3 - organize by wbs and "fill cell" the proper act code values per WBS.

Best regards,

Jorge
Top
Sun, 2005-11-20 11:06
#2
Milind Pandhare
User offline. Last seen 8 years 29 weeks ago. Offline
Joined: 29 Aug 2005
Posts: 54
Groups: None
hi neeraj [Englisk only, please. - The Moderator.]
Top
Sun, 2005-11-20 02:05
#3
Neeraj Agarkar
User offline. Last seen 5 years 37 weeks ago. Offline
Joined: 25 Jul 2003
Posts: 61
Groups: None
which script?
Top
Sat, 2005-11-19 01:33
#4
MUHAMMAD IQBAL
User offline. Last seen 6 years 50 weeks ago. Offline
Joined: 29 Aug 2005
Posts: 34
Groups: Planning, Claims & Contracting, TILOS
Hi

Neeraj

Yes you can Make Macro in XLS

I was interested in if any body have done such kind of Excerise.

the TERM MANUAL Very clear

I mean to say the lengthy process are same like manual


For your kind information P3 have given all of the scripts

now it one`s job how to use them at wat level.

have fun



Top
Fri, 2005-11-18 11:24
#5
Neeraj Agarkar
User offline. Last seen 5 years 37 weeks ago. Offline
Joined: 25 Jul 2003
Posts: 61
Groups: None
Is it possible to make Excel macro talk to P3? I think you have to do export / import manually.
Top
Fri, 2005-11-18 06:52
#6
MUHAMMAD IQBAL
User offline. Last seen 6 years 50 weeks ago. Offline
Joined: 29 Aug 2005
Posts: 34
Groups: Planning, Claims & Contracting, TILOS
hi guys

thanks for all you for all ’MANUAL METHODS"

have any BODY did like this

i was intrested in making some marco in excel

and let xls will do it


try it

Top
Thu, 2005-11-17 08:39
#7
Emre Bayrak
User offline. Last seen 9 years 27 weeks ago. Offline
Joined: 23 Apr 2003
Posts: 18
Groups: GPC Qatar
As everybody says send it to excel, if you use ’text to columns ’ feature of excel from data menu you will see it will be very practical to convert it to activity codes.

Regards

Emre
Top
Wed, 2005-11-16 05:52
#8
Neeraj Agarkar
User offline. Last seen 5 years 37 weeks ago. Offline
Joined: 25 Jul 2003
Posts: 61
Groups: None
I think this should be possible.
Create activity code structure matching WBS (with length field same as WBS for your project). Do not assign it to any activity. Export to Excel (include activity codes and wbs in export fields).
Once in Excel, you can use functions to separate WBS into the Activity code columns.
Import it back into P3.
try this.
Neeraj
Top
Wed, 2005-11-16 05:15
#9
MUHAMMAD IQBAL
User offline. Last seen 6 years 50 weeks ago. Offline
Joined: 29 Aug 2005
Posts: 34
Groups: Planning, Claims & Contracting, TILOS


Hi
Sen Moc
Your Method may work if WBS is comprises of Level 1

But My WBS is going up to level 4 how it will work???

my second Question was how Activity Code Structure will be Developed from already made WBS Structure.




Top
Wed, 2005-11-16 00:15
#10
Zhang Haixiang
User offline. Last seen 3 years 50 weeks ago. Offline
Joined: 14 Apr 2005
Posts: 250
Groups: None
First define your coding structure, then try global change to assign code for each activity.

I haven’t tried it before. Good luck.

If this does not work. try export to Excel, assign code there, then import back to P3
Top
Wed, 2005-11-16 00:15
#11
sunil kumar
User offline. Last seen 14 years 42 weeks ago. Offline
Joined: 18 Oct 2005
Posts: 47
Groups: None
WBS and activity codes is to organize your project .... i didnot get what u wanted to convert......


i u want to see your project in activity codes ...
just go to organize activity codes highliht it and organise accordingly


sunil
Top
Wed, 2005-11-16 00:14
#12
Sen Moc
User offline. Last seen 18 years 38 weeks ago. Offline
Joined: 30 Aug 2005
Posts: 123
Groups: Petro-Chem / Oil & Gas
First, organize your layout by WBS (Format/Organize). In your tabulated part of the layout, show WBS in one column and beside it show an empty dummy column for your OBS. Fill-in the dummy column with your required OBS using COPY and FILL CELL function.

Goodluck.
Top