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.

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

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 : https://doduykhuong.com/2018/04/01/primavera-p6-export-to-excel-how-to-identify-wbs-level-for-activity/

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.

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

 

How to achieve rapid feedback progress through integrated EXCEL?

Title: "How to achieve rapid feedback progress through integrated EXCEL?"

Author: "Deyi.zhang/张德义"

Generating P6 S-Curves via Excel

A step-by-step procedure for extracting data out of Primavera to enable the generation of S-curves within Excel. Covers generating curves for planned value, earned value and actual expenditure, both in terms of manpower and cost.

Market Place

Primavera P6 and Microsoft Project books, on-line video training courses and training material available from an internationally recognised publisher and PMI accredited REP. Teach yourself using on-line or book based learning or run your own in-house or public PMI accredited courses.
For 25+ years, APMX has been providing competency based project management training to Fortune 500 companies around the world, applying the principles of project based learning, designed to produce measurable results, generating a favorable “return on training investment”.
See how the TIME - LOCATION - VIEW brings clearness to your work programmes
Syndicate content