Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

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

Posted Thu, 2018-08-16 04:56 by Khuong Do

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

5917
primavera-p6-export-to-excel-how-to-identify-wbs-level-for-activity-1.jpg

 

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

5918
primavera-p6-export-to-excel-how-to-identify-wbs-level-for-activity-2.jpg

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

5919
primavera-p6-export-to-excel-how-to-identify-wbs-level-for-activity-3.jpg

 

About the Author : Khuong Do

Khuong Do is a Project Planner / Scheduler in Civil Engineering, Transportation, and Oil & Gas Industry. He has worked as a Primavera Consultant Specialist since 2006 and willing to share his passion for Primavera through lots of Tips & Trick on his personal blog : https://doduykhuong.com

Market Place

Eastwood Harris Pty
Primavera P6 and Microsoft Project books, on-line video training courses and training material available from an internationally recognised publisher. Teach yourself using on-line or book based learning or run your own in-house or public courses.
http://www.eh.com.au/