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 →

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:  

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 →

Primavera P6 Professional : “Unable to connect to the database” error

When connect SQL database in Primavera P6 Professional, we usually have problem like: Error Message:  Bad public user Name or password. SQL Server Error: [DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied. Error message: Bad public user name or password. SQL Server Error: [DBNETLIB][ConnectionOpen (Invalid Instance()).] Invalid connection.;" Error Message:  Bad public user name or password. Database Server... Continue Reading →

Create a website or blog at WordPress.com

Up ↑