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:
Which Fields can be imported into Primavera P6 from Excel (XLS) Spreadsheet?
When we look at Excel file exported from Primavera P6, there are some columns have an asterisk (*). What does it mean? I will explain in this article. All the columns which have the asterisk mean they can not be imported into P6, i.e. we can not change their value and import into P6. There is... Continue Reading →
Primavera SDK Excel File to import / export data
Even Oracle stop supporting the Excel File to import / export data, sometimes we still need to use it. The latest version it can support is P6 version 8.3 You can download it here: https://drive.google.com/open?id=0ByHnieTJNwKGRGpoMnJBS25HU28