Primavera P6: Summarize/Roll up activity duration at WBS level using duration value, not earliest and latest date

By default, Primavera P6 summarizes/rolls up activity duration at the WBS level by calculating the period from the earliest Start Date to the latest Finish Date of all activities in that WBS. In case we want to calculate the summary duration by simply adding up the duration of all activities, below are the steps. Go... Continue Reading →

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. 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/ Step 2: Go to Conditional Formatting -> Manage Rules Create... Continue Reading →

Create a website or blog at WordPress.com

Up ↑