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

excel

Primavera p6 WBS grouping bands in excel

Posted Sat, 2020-06-13 16:47 by Farooq shaik

PLeae find the below Youtube link for the video how to prepare color bands of WBS in excel with one click

https://youtu.be/1jByS22FXJY

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 color WBS level automatically

Posted Mon, 2018-11-19 11:07 by Khuong Do

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.

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

 

How to achieve rapid feedback progress through integrated EXCEL?

Posted Fri, 2018-04-27 14:22 by Frank Zhang

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

Author: "Deyi.zhang/张德义"

Generating P6 S-Curves via Excel

Posted Sat, 2014-08-30 04:09 by Gary Whitehead

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

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