Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

export

Export from Microsoft Project to Excel

Posted Sun, 2020-01-12 20:56 by Jerome Odeh
 

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 Table for any data analysis you might want to carryout but with Microsoft Project, you still need to format the Excel properly prior to any Excel Table data analysis.

Primavera P6 export to Excel. How to identify WBS level for activity

Posted Thu, 2018-08-16 04:56 by Khuong Do

After export activity table from Primavera P6 to Excel, it's very hard to tell this activity belong to what WBS.

5917
primavera-p6-export-to-excel-how-to-identify-wbs-level-for-activity-1.jpg

 

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

5918
primavera-p6-export-to-excel-how-to-identify-wbs-level-for-activity-2.jpg

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

5919
primavera-p6-export-to-excel-how-to-identify-wbs-level-for-activity-3.jpg

 

Market Place

Eastwood Harris Pty
Primavera P6 and Microsoft Project books, on-line video training courses and training material available from an internationally recognised publisher. Teach yourself using on-line or book based learning or run your own in-house or public courses.
http://www.eh.com.au/
Syndicate content