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. 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:  

How to filter based on WBS date in Primavera P6

We have a project which contain 4 building like below picture: Now we need to filter which Building will start in next 3 month (Dec, Jan, Feb). We can create a filter like this based on Activity: And P6 will show this result: Building 1 and 3 will start. However the Finish date of Building... Continue Reading →

Create a website or blog at

Up ↑