excel
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
Blog · Filed under
excel
4 articles
excel
Export from Microsoft Project to Excel
If you have ever used Primavera P6, you would be surprised that exporting from Microsoft Project to Microsoft Excel does not provide you with a ready to be used data considering that both products are from the Royal House of Microsoft. In Primavera P6, exports to Excel come formatted as an Excel…
12 Jan 2020 · Jerome Odeh · 3 min read
excel
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
excel
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