P6-Scrubber was deployed for the team to make the cleaning effort easier, more reliable and faster to handle.

The users setup the scrubbing definitions for the contractor and consultant loads, import an XER/XML file into P6-Scrubber, run P6-Scrubber which does the cleanups and then import the projects into P6 Production after the P6-Scrubber has done the cleanups

Emerald analyzed the different databases and proposed business rules and clean up recommendations for each business unit and then consolidated the P6 databases into one database.

Business unit and user security rules were implemented to ensure data was secure and accessible to only the users who needed to access the schedules within each business unit.

Implemented schedule templates for each business unit that followed the corporate CDM requirements and provided consistency across the company for data analysis and reporting.

Analyzed each business unit requirement. Created naming conventions for individual requirements and consolidated shared attributes for corporate wide data.

Emerald used their P6-Loader tool to make the necessary adjustments for security and data changes that allowed the implementation to take much less time than manually entering the new and updated data in P6.

After going live, Emerald continues to provide Primavera support in the Oracle Cloud to the client adding new users and maintaining their environment.

PCM-Archiver extracted all record data, attachments, and PDFs of the default form into an archive location on the filesystem that doesn't need Primavera Contract Management, or any other special software, to access.

PCM-Archiver extracted an Excel spreadsheet for each document that includes custom fields, as well as all other fields, on both the header and line item levels.

PCM-Archiver included a tab in the extracted spreadsheet for each document with attachments that includes information about who attached each file and when.

One administrator is able to handle all user and codes maintenance for 10+ databases.

P6-Loader allows the team to continue to cost load much more quickly each month.

Handling cross project relationships is much less error prone now after receiving XERs from contractors on each update; it is a simple extract logic, change the project reference and reload!

The project controls team is able to tackle problems that they could not prior.

P6-Auditor has allowed them to keep a finger on the pulse of their schedules and gives them a means for disaster recovery.

Using P6-Calculator to flag and count key in-service milestones within P6 and then snapshotted for use within Power BI

P6-Loader was used to cleanup manually created data that was used in the reporting to set up standards

P6-Reporter automatically snapshotted the reports every Monday at 8am to give management current reports for the weekly status meeting

P6-Calculator did automatic quarterly and monthly flagging for easy data validation across P6 and Power BI

Produced overall project metrics, in-service monitoring, construction readiness, and scheduling team production reporting

P6-Auditor allows for ongoing metrics for schedule performance on update counts to avoid bottlenecks and back dating tasks

Tracing project deletes easily and rollbacks if required

Reporting on update frequencies - actual starts, actual finishes, and percent completes

Edits to the resource dictionary that were not expected including deletes and cut and pastes

Verifying changes to activity codes and who made them as well as when they were made

Tracing EPS moves that no user admitted to

Finding logic changes that should not have been made as well as task deletes

Integrated to PIMS key milestones for stage gates

Ensured consistent reporting - and reduced errors significantly

Automatic integration on project creation with templates with estimate dates

Within 4 weeks system was running

Cloud and on-premise integration