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 →

Advertisements

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. 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 Apply to the rest so we can see WBS level for each activity:  

What is the difference between Activity type: Task Dependent and Resource Dependent in Primavera P6

In Primavera P6, there are 2 popular activity type: Task Dependent and Resource Dependent. So what is the difference? By choosing Task Dependent or Resource Dependent, P6 will choose what calendar it will use for the activity: Choose Task Dependent: P6 use Activity calendar for the activity Choose Resource Dependent: P6 use Resource calendar for the activity... Continue Reading →

Primavera P6 Professional version 16.2.11 fully support Vietnamese using Unicode character set. Phần mềm Primavera P6 version 16.2.11 đã hỗ trợ đầy đủ Tiếng Việt Unicode

From version 16.2.11, Primavera P6 now fully support Vietnamese language using Unicode character set. If we don’t have Primavera in our laptop, we can install it following instruction here : https://doduykhuong.com/2016/06/11/how-to-install-primavera-p6-professional-16-1-stand-alone/ If we already had P6, we have to create a SQLite database. The above “How to install Primavera P6” article also show us how to create SQLite... Continue Reading →

How to type Chinese character in Primavera P6 Professional / 如何在Primavera P6 Professional中输入汉字

There're lots of way to use Chinese character in Primavera P6. But I will show you the easiest way. If we don't have Primavera in our laptop, we can install it following instruction here : https://doduykhuong.com/2016/06/11/how-to-install-primavera-p6-professional-16-1-stand-alone/ If we already had P6, we have to create a SQLite database. The above "How to install Primavera P6" article also... Continue Reading →

Create a website or blog at WordPress.com

Up ↑