Primavera P6 export to Excel. How to identify WBS level for activity

After export activity table from Primavera P6 to Excel, it’s very hard to tell this activity belong to what WBS.

Primavera P6 export to Excel. How to identify WBS level for activity-1

We can add 1 column to show the WBS level for each activity.

The formula for the column is : =((FIND(TRIM(B2),B2))-1)/2

Primavera P6 export to Excel. How to identify WBS level for activity-2

Apply to the rest so we can see WBS level for each activity:

Primavera P6 export to Excel. How to identify WBS level for activity-3

 

Advertisements

9 thoughts on “Primavera P6 export to Excel. How to identify WBS level for activity

Add yours

  1. Hi all,

    can anyone help me?
    very strange..excel gives out formula issue as follow:

    We found a problem with this formula. Try clicking Insert Function on the Formulas tab to fix it, or click Help for more info on common formula problems.

    Not trying to type a formula?
    When the first character is an equal (=) or minus (-) sign, Excel thinks it`s a formula:

    you type =1+1, cell shows : 2

    To get arround this, type an apostrophe (`) first:

    you type: `=1+1, cell shows =1+1

    Thanks

    Like

Leave a Reply to Mohamed Raouf Cancel reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a website or blog at WordPress.com

Up ↑