Primavera p6 WBS grouping bands in excel
PLeae find the below Youtube link for the video how to prepare color bands of WBS in excel with one click
PLeae find the below Youtube link for the video how to prepare color bands of WBS in excel with one click
After export activity table from Primavera P6 to Excel, it’s very hard to distinguish WBS level.
After export activity table from Primavera P6 to Excel, it's very hard to tell this activity belong to what WBS.

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

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

Title: "How do ETO projects build WBS, CBS, and CA?"
Author: "Deyi.zhang/张德义"
Project fails because of ineffective Work Breakdown Structure.
"WBS Dictionary Sample" by Alexander Cartwright
Description: sample Work Breakdown Structure
"Work Breakdown Structure - National Cybersecurity Center of Excellence" by Alexander Cartwright
Description:
This is a sample Sortable Work Breakdown Structure and Resource Allocation Matrix (WBSRAM)
"INDUSTRIAL TURN-AROUND WBS"
Planning and Scheduling Considerations and Scheduling Risk Analysis to prepare for an Industrial Turn-Round
By Anthony (Tony) L. Lowery
All projects regardless of size or complexity have a specific sequence for completing the component tasks. Most sequences require that certain activities be started, and in some cases, completed before other tasks may begin.
All projects regardless of size or complexity have a specific sequence for completing the component tasks. Most sequences require that certain activities be started, and in some cases, completed before other tasks may begin.