Blog · Filed under

export

2 articles

export

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

export

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