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.

How it works

Import WBS structures from Primavera P6 to Excel with one click

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.

request a demo
pexcellent primavera p6 integratie oplossing importeren van een wbs

Click on the image to enlarge

voorbeeld pexcellent primavera p6 integratieoplossing voorbeeld van een succesvolle import uit p6 planning

Click on the image to enlarge

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.

request a demo

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!

request a demo
Printscreen met pexcellent voorbeeld van activiteiten validatie

Click on the image to enlarge

pexcellent integratie oplossing Primavera p6 scherm waarin resources worden gevalideerd

Click on the image to enlarge

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.

request a demo
What our Clients Say
Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.- Duxee Inc.
Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum.- Nnsatos
Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.- Strucks

Lean Oracle Primavera Integration

Pexcellent is the easiest way to transfer data from your Primavera P6 project planning to excel and vice versa.

Easy-to-use

No specialized knowledge is needed to work with Pexcellent. The user only needs to have knowledge about Microsoft Excel and Oracle Primavera P6.

Easy installation

The installation can be done without the need of an IT department.

Semi-automated

Pexcellent gives you the opportunity to rearrange your data before exporting it to Oracle Primavera because of its semi automated functionality.

Low costs

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.

Outstanding performance

Export 30.500 activities from Oracle Primavera P6 to Microsoft Excel within 15 seconds and validate 30.500 activities within the minute!

More information

Contact us

If you have any additional questions please feel free to contact us.

Manual

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

Contact us
Let one of our consultants help you get started with Pexcellent. Call us 010-2707000 or fill out the form and we will call you back. Do you need software support? Call us 010-2707017 of create a ticket at Aram support center.