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.

Assign WBS faster

11 replies [Last post]
Thu, 2007-11-15 05:15
K D
User offline. Last seen 15 years 30 weeks ago. Offline
Joined: 25 Sep 2007
Posts: 247
Groups: None
Hi all.
We need to assign WBS to 10000 activity.
We show on activity table the WBS column. Each time we have to click and choose a value. But the WBS assignment window can not stay still like Resource assignment window. Choose value and must close it. Very uncomfortable.

Can anyone suggest a new way for assignment?

Thanks so much.
Top

Replies

Sun, 2007-12-09 22:47
#1
K D
User offline. Last seen 15 years 30 weeks ago. Offline
Joined: 25 Sep 2007
Posts: 247
Groups: None
Hi David.
Yeah,it quite complicated but I’ll try it soon.
THanks
Top
Fri, 2007-11-30 09:40
#2
David Podmore
User offline. Last seen 12 years 17 weeks ago. Offline
Joined: 26 Apr 2006
Posts: 74
Groups: None
Set the following up in an Excel spreadsheet and you’ll see how you can use the import/export to Excel to load your WBS into your activities.

Create a blank workbook.
In cells B3 to B6 enter A to D.
In cells C3 to C6 enter a WBS Code as used in your prog.
In cells D3 to D6 enter a WBS Description (ditto).
In cells B10 to B20 enter a series of Activity IDs (any!).
In cells C10 to C20 enter a code from your list in B3 to B6.
In cells D10 enter the formula =LOOKUP(C10,$B$3:$B$6:$C$3:$C$6)
Copy the above down to D20.
In cells E10 enter the formula =LOOKUP(C10,$B$3:$B$6:$D$3:$D$6)
Copy the above down to E20.
NOTE: You may need to edit (F2) each formual cell and press ENTER to refresh the lookup.

Once you’ve done this you can see how you can apply it to your tasks and WBS.

A bit "wordy" but I hope it helps.
Top
Fri, 2007-11-30 05:18
#3
Rodel Marasigan
User offline. Last seen 11 hours 35 sec ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
KD,

It’s easier to manipulate data in Excel especially if you have advance knowledge in Excel. You can use look up functions and filters to make it easier when assigning WBS to each activity. You can build a table of WBS code and WBS description so you know what to look and what to assign. You can copy direct WBS from P5/P6 and paste it to spreadsheet.

Hope this help
Rodel
Top
Thu, 2007-11-29 22:21
#4
K D
User offline. Last seen 15 years 30 weeks ago. Offline
Joined: 25 Sep 2007
Posts: 247
Groups: None
Hi all.
Global change function is useful when we assign big number of activities to small number of WBS. So you do have to create lots of condition .
In my case there are over 1000 WBS. If using Global change I have to create over 1000 condition.

Hi Rodel.
When export to excel , it’s harder to find a WBS to assign. Do you think so? I have not found a solution by exporting to excel yet.

Thanks
Top
Thu, 2007-11-29 21:05
#5
Rodel Marasigan
User offline. Last seen 11 hours 35 sec ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
KD,

You can use export/import excel function. It’s another quick way of assigning WBS.

HTH,
Rodel
Top
Thu, 2007-11-29 04:36
#6
Dieter Wambach
User offline. Last seen 7 years 2 weeks ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
KD
Do you have any criteria to say if A then WBS X, if B then WBS Y?
Then the global change would be the easist way.
Dieter
Top
Thu, 2007-11-29 02:41
#7
Ronald Romero
User offline. Last seen 38 weeks 5 days ago. Offline
Joined: 13 Nov 2006
Posts: 63
Groups: Civil Engineering
Hi KD,

Your an IT guy why not do it by global change and filters . I dont know how to make dialog boxes but ask here in PP if they can make a programs that we can use it in primavera so it can be done with the mouse.

Regards,

Ronald
Top
Mon, 2007-11-26 22:16
#8
K D
User offline. Last seen 15 years 30 weeks ago. Offline
Joined: 25 Sep 2007
Posts: 247
Groups: None
Hi all.
Thanks for your update.
Ofcourse we can use fill down function. But problem i mean is assign WBS for the first activity in the group, then we can fill down. Normally we have 10 activity for each WBS ,so that mean we have over thousand of WBS to assign. It’ll take time to assign WBS , even for the first activity.
Do you know how to make the WBS assignment dialog box stay still like Relationship assignment dialog. We can assign faster.

Thanks
Top
Tue, 2007-11-20 07:08
#9
Mark Chapman
User offline. Last seen 8 years 12 weeks ago. Offline
Joined: 18 May 2006
Posts: 183
Groups: None
Ctrl E are my favourite keys in P5!
Top
Mon, 2007-11-19 14:20
#10
Ahmet Cetin
User offline. Last seen 9 years 4 weeks ago. Offline
Joined: 8 Feb 2005
Posts: 84
Groups: None
Yeah, I suggest to every Primavera users to learn fill-down feature. It is a BIG time saver. Another way might be using Global Change, but using fill down is much simpler and easier.

Ahmet Cetin

Visit PrimaveraTools.com
Primavera Tools, Forum, Tutorials, Outlook Plugin


Top
Thu, 2007-11-15 05:25
#11
Steven Oliver
User offline. Last seen 11 years 24 weeks ago. Offline
Joined: 8 Nov 2002
Posts: 313
Groups: None
Select your range of activities and use "Fill Down"
Top