Primavera P6, Microsoft Project, Delay Analysis Tips & Tricks
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 →
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:
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 →
In Primavera P6, after finish creating the schedule, you may need to assign resource to activity to make the resource plan. I will show you how to do it. Let say you have a schedule like in below picture: To assign resource, first you need to create one. Go to menu Enterprise -> Resource. Click... Continue Reading →
