Primavera P6 export to Excel. How to identify WBS level for activity
![](http://www.planningplanet.com/sites/default/files/imagecache/wysiwyg_half_page/user/blog/primavera-p6-export-to-excel-how-to-identify-wbs-level-for-activity-5.png)
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.jpg 5917](http://www.planningplanet.com/sites/default/files/imagecache/wysiwyg_full_page/wysiwyg_imageupload/33012/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
![primavera-p6-export-to-excel-how-to-identify-wbs-level-for-activity-2.jpg 5918](http://www.planningplanet.com/sites/default/files/imagecache/wysiwyg_full_page/wysiwyg_imageupload/33012/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:
![primavera-p6-export-to-excel-how-to-identify-wbs-level-for-activity-3.jpg 5919](http://www.planningplanet.com/sites/default/files/imagecache/wysiwyg_full_page/wysiwyg_imageupload/33012/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
Printer-friendly version
- Login or register to post comments
Send to friend