Skip to content

Blog · Filed under

wbs

4 articles
wbs

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 clickhttps://youtu.be/1jByS22FXJY

13 Jun 2020 · Farooq shaik · 1 min read

wbs

Primavera P6 export to Excel. How to color WBS level automatically

After export activity table from Primavera P6 to Excel, it’s very hard to distinguish WBS level. I will show you how to color WBS level automatically so we can have report like in P6.Step 1:Follow this article to insert the "WBS Level" column :…

19 Nov 2018 · Khuong Do · 1 min read

wbs

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)/2Apply to the rest so we can see WBS level for each activity:

16 Aug 2018 · Khuong Do · 1 min read