wbs

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)

Definitions of WBS Schedule Levels

"Definitions of WBS Schedule Levels" By Tom Reichner

Preface

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

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