P6-Calculator and P6-Reporter Makes Power BI Reporting a Breeze

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

With CAPPS, weekly status updates were done by the project managers and submitted to the project controls team for approval in P6

Monthly cost updates and forecasting of EAC were done by the project managers and submitted to the project controls team for approval in P6

Key management milestone reporting was streamlined significantly

Project controls teams were freed up to deal with larger turnaround projects

Project controls teams were able to focus on P6 re-scheduling and critical path analysis

CAPPS was deployed to key project managers and suppliers

Weekly updates were prepared and reviewed in meetings prior to submission to keep the communication flowing smoothly

Used percent complete, resource usage and cost to date

Reporting improvement and better forecasting was achieved

P6-Loader was used to clean up project templates for some 500 projects in play to acquire consistency

CAPPS is used for weekly updates by over 150 PMs

The project controls teams review and approve all updates in P6 and discuss any anomalies with the PMs right away

CAPPS is allowing meeting updates to run more efficiently with the on-screen grid

Program management reporting is now being done with a lot less stress and overtime

P6-Calculator allows for flagging of variances and easy filtering of late and overdue items for the schedulers to find across hundreds of projects

Integrated daily costs from Discoverer into P6 and PCM Contract Management

Updated the external contract and PO costs into expenses

Integrated the internal detailed resource costs into resources and forecasted onto the budget resource

P6-Calculator did all the cost rollups and comparisons to the budget

P6-Calculator flagged integration errors, mismatches, and potential incorrect charges for the PM

BI Reporting was developed for cost to date, forecasting, earned value, CPI, SPI and changes to-date

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

Emerald's Turnaround Productivity Package - TAPS, P6-Loader, EP-dashboard, and EP-datawarehouse was implemented

Schedule updates are now completed in less than a quarter of the time. Updating takes a matter of minutes using TAPS, rather than several hours

P6-Loader streamlined the addition of found work to both the working schedule and the baseline schedule

EP-datawarehouse is used to store snapshotted data for multiple uses for EV and Trending

EP-dashboards utilize the snapshot data to create custom dashboards for management including Green-Ups, Inspections and S-Curves

Led design sessions for changes to global structures, stage gate templates, and consistent deliverables

Remapping and migration was done with P6-Loader after each working session so management could see the changes right away

Training was delivered by Emerald using custom developed UPK content and small working sessions for the different business leaders and then team project managers

Management Dashboard for timesheet submissions, project stage gate and milestones from templates were developed

Realtime updates from Oracle E-Business EAM into P6 for Projects, Work Orders, Tasks and Resources allowing for easier plan development for maintenance work, mini-outage work, turnaround work windows and capital programs across several plants

Implemented within 6 months including dev, test, QA, and production. P6-Loader was used to move the P6 coding structures, EPS, OBS, codes, UDFs, and resources in a matter of minutes and to maintain these environments.

Better analysis of planned resource requirements, spending planning and timeframes across the capital programs throughout the plants

Improved delivery on outage deadlines, timeframes and what-if capability particularly related to managing production capacity across the plants

Better understanding of mining equipment and productivity rates for improved forecasting. Reduced effort to build the schedules, allowing better management of the short 1-2 power outage windows.

P6-Calculator ensured auto-archiving of the projects and work orders to keep the P6 database clean and manageable and to produce rollup data for resources and flagging of integration changes

Implemented P6 for planning the drilling program

Migrated from SAP report into P6 - used the P6-Loader to load in projects, WBS, and costs

Easy visualization and comprehension of the plan in P6

Consistent templating of data across the portfolio

Saved weeks of data entry

Streamlined data imports by over 30%

Drastically reduced manual data entry by 50%

Improved standardized reporting during the planning stage and execution

Expanding P6-Loader’s use into other groups to improve the usage of P6

Emerald provided P6-Loader aaS

Enterprise Data: built and loaded for EPS, OBS, Users, User Profiles

Global Data: merged and cleaned up while loading over 400 Resources and 50 Calendars

Project Data: 756 projects, 455 Baselines, 265,802 activities. Activity codes, resource assignments, and relationships were all transferred.

Approach - used a combination of XER and P6-Loader functionality

Saved weeks of manually re-creating global data, users/profiles, and baseline management. Went live 1 week after getting files.

Streamlined the efforts of updating down from 4 person weeks to 2 person days. Data Imports by over 30%.

Errors and mismatches were reduced significantly

Several macros made this extract and upload much more reliable than manual inputs

Reloading every day during the update window was smooth

Integrated documents statuses from Aveva

Templated the different task types and package types with preset calculation methods

Documents planned, in progress, completed, deleted

Set the start dates of tasks in progress, updated the percent completes and flagged changes to the tasks

Updated the resources - actual labor units

Databases edited and cleaned up prior to migration. Including Security Profiles, User and Global Data, some of which were corrupt using P6-Loader tool

Archived old projects in place and moved over 400 projects and baselines to new environment with only one weekend of down time

Migrated data was validated and compared to previous database to ensure all data was moved accurately

Saved hundreds of hours of manual work