When working on large projects with multiple subcontractors, it happens often that Work Breakdown Structures are provided in Microsoft Excel. It is a time consuming and frustrating job to retype all the WBS elements from Excel to P6. Pexcellent helps by providing you an easy accessible interface to import this WBS structure in one shot.
Pexcellent enables lean Oracle Primavera integration
Pexcellent helps you importing and exporting large volumes of data from Microsoft Excel to Oracle Primavera P6 and vica versa. This saves you time, prevents errors, finds inconsistencies by validations, and prevents frustration.
Import WBS structures from Primavera P6 to Excel with one click
Importing and exporting Activity Code Structures
A subcontractor has delivered a project in Primavera P6 and you would like to use its Activity Codes, but not in the global scope, but in the project scope. You can use Pexcellent first to transfer all the global Activity Codes to Excel. You manipulate the information by removing rows, adding rows and fixing a couple of typo’s. Then you change the scope from Global to Project, provide the project you want to use and press Import.
Importing exporting and validating of Activity data
When your company uses multiple systems to track progress of different activities you can import this information into Primavera P6. Key users of those systems need to export their progress and remaining duration to Excel, by providing at least the Project ID, Activity ID, Progress and Remaining Duration. This information is collected and validated in the Pexcellent sheet called Activity. It gives you the opportunity to review all the information before updating it in your P6 project. Once the necessary correction are made you are ready to update!
Importing actual hours into financial periods of Primavera P6
To have a good overview of the actual spend budget of your P6 project planning, it would be great if the actual hours from systems such as SAP IFS could be imported into your planning.
Start with the export of the written hours of the ERP system, where it is mandatory to have the following information: Project ID, Activity ID, Resource ID, Year, Week, and Actual hours. Before updating the actual hours in P6, Pexcellent has the ability to perform a validation and report per cell if there is a possible issue. If all seems well, the update will overwrite your P6 project planning with the new values in each financial period (for example per week), for each resource, for each activity, for each project.
Lean Oracle Primavera Integration
No specialized knowledge is needed to work with Pexcellent. The user only needs to have knowledge about Microsoft Excel and Oracle Primavera P6.
The installation can be done without the need of an IT department.
Pexcellent gives you the opportunity to rearrange your data before exporting it to Oracle Primavera because of its semi automated functionality.
Pexcellent is a very low cost solution to import and export data from Oracle Primavera P6 to Microsoft Excel. Thus, no major investments are needed.
Trusted Expert Support
We offer you expert support if needed. Aram is is gold partner of oracle. We are therefore are experienced and trained with troubleshooting and problem solving.
Export 30.500 activities from Oracle Primavera P6 to Microsoft Excel within 15 seconds and validate 30.500 activities within the minute!
If you have any additional questions please feel free to contact us.
Download the latest version of the Pexcellent manual
Request a demo
Would you like to see more? We are happy to give you a live demo.
Start a 30-day trial
Get an hands on experience with Pexcellent with our 30-day trial