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

wbs

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 click

https://youtu.be/1jByS22FXJY

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.

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 do ETO projects build WBS, CBS, and CA?

Title: "How do ETO projects build WBS, CBS, and CA?"

Author: "Deyi.zhang/张德义"

Project fails because of ineffective Work Breakdown Structure.

Project fails because of ineffective Work Breakdown Structure.  

WBS Dictionary Sample

"WBS Dictionary Sample" by Alexander Cartwright

Description: sample Work Breakdown Structure

Work Breakdown Structure - National Cybersecurity Center of Excellence

"Work Breakdown Structure - National Cybersecurity Center of Excellence" by Alexander Cartwright

Description:

This is a sample Sortable Work Breakdown Structure and Resource Allocation Matrix (WBSRAM)

Industrial Turn-Round Work Breakdown Structure

"INDUSTRIAL TURN-AROUND WBS"

Planning and Scheduling Considerations and Scheduling Risk Analysis to prepare for an Industrial Turn-Round

By Anthony (Tony) L. Lowery

The Values of Scheduling - An Integrated Consulting Article

All projects regardless of size or complexity have a specific sequence for completing the component tasks. Most sequences require that certain activities be started, and in some cases, completed before other tasks may begin.

The Values of Scheduling - An Integrated Consulting Article

All projects regardless of size or complexity have a specific sequence for completing the component tasks. Most sequences require that certain activities be started, and in some cases, completed before other tasks may begin.

Market Place

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.
Syndicate content