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 : “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 →
How to assign resource / resource loading / make resource plan in Primavera P6
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 →