P6-Loader was deployed to schedulers, which significantly reduced the time to create and edit project information in P6

Administrators are able to analyze global data usage and clean up obsolete information using the Usage Sheets available in P6-Loader

Users are being added much more efficiently, using copy and paste features in Excel to quickly set user permissions from already existing users

Deploy a test server for version 21

Migrate project data into the new version 21 server

Use Emerald's P6-Loader to help clean up old versions

Reworked master P6 resource dictionary to cleanup labour, equipment and material resources for standardization

Ongoing loading from estimating for task level resources and expenses to bring a consistent and repeatable approach to estimating

Cleanup of activity coding to ensure phase, area, and discipline type reporting could be done with ease

Multi-currency development and data tracking using P6-Loader

The agreed database clean up and incorporation of the second database was carried out. The database was then upgraded and loaded to the cloud.

In addition to the clean-up and upgrade, training on the new version of P6 was presented.

Emerald used P6-Loader as a service to identify activity codes and UDFs currently not assigned to any activity IDs to facilitate dictionary cleanup.

The P6-Loader was also used to move schedule files and reformat EPS and OBS structure.

Emerald created additional databases in the hosted environment to add an archive and sandbox environment.

Emerald assisted with creation of a security structure to ease user access management.

Emerald worked with their team to address taking advantage of P6 coding, UDFs, and WBS structures for best reporting and EV results.

Emerald upgraded P6 and presented P6 training.

P6-Loader, P6-Auditor & P6-Reporter (previously EP-datawarehouse) were added to the tools available to P6 users for enhanced functionality and efficiency.

Emerald sent two implementation specialists four months before the TA started. They set up P6 and created a resource-loaded CPM schedule.

Used P6-Loader to automate grabbing simple Work Order, Task, and Resource sheets from Excel to create the P6 schedule. More packages were being developed and loaded right throughout the turnaround.

A full critical path schedule was built, resource leveling was developed, and reporting and metrics were standardized.

Emerald helped run their three subsequent TAs.

Utilized TAPS for updating progress of the activities.

EPS caching of the list of projects shown during an extraction operation.

Fixes to some UI issues with the scrollbar disappearing.

New UI - The P6-Loader is now a React application with a completely redesigned look and feel

Uses the Emerald Cloud API for better controls of business functions

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.

Moved hosting of four databases to the Emerald Cloud.

Decreased supported response time from days to hours

Able to bring their DOT client online with their environment in less than two months, including upgrade of P6 and rollout of new business processes.

Added a second DOT client to Emerald's hosting environment two years later.

TAPS was initially used at the Ferndale Refinery and saved so much time, it is used on turnarounds at all the company’s refineries now.

After using P6-Loader at the Ferndale refinery, the tool was purchased company-wide for use with all P6 databases.

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