Articles tagged with: P6-Reporter

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

Major North Eastern utility company uses P6-Reporter and P6-Calculator to improve their reporting.

regulatory metrics management

Client Overview

Major North Eastern utility using P6 to plan transmission and distribution maintenance and projects. The team needed to improve their ability to ensure that regulatory deliverables were being met while managing the deliverables in a more balanced and consistent manner.


  • With hundreds of projects on the go across several states with different regulatory reporting requirements, setting standards across the team for consolidated management reporting was needed

  • Ensuring that regulatory commitment dates are met within the month, quarter and year was critical but very time consuming to manage

  • Giving the P6 scheduling team a quick way to find missing P6 information for coding and tracking milestone commitment dates was needed


  • 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

Integrated Daily Cost Control - Discoverer -> P6, PCM

Integration allows PMs to manage 20 projects at once

PMs get on top of projects with daily integrated system

Written by Nicole Jardin

Client Overview

Calgary pre-fab manufacturer with international projects needed integration to accounting and purchasing system to get control over client commitments and internal and external spending for hundreds of simultaneous projects.


  • Tracking costs to date on hundreds of projects manually was too time consuming

  • Client forecasting was taking too long and overruns were being missed

  • Senior management was not getting the reporting done in a timely manner


  • 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

Large US Refinery Implements Emerald Tools

Learn how refinery used P6-Loader and TAPS to improve accuracy and speed when working with data in their P6 schedules and how they used EP-datawarehouse and custom dashboards to help with cost control and management visibility for their turnarounds.

Cost controls more effective and schedule updating more streamlined

Written by Sue Hopkins

Client Overview

Client is one of North America's largest integrated energy companies. Their Lima refinery was looking for a way to improve their turnarounds and create custom dashboards for better visibility for management.


  • Their Lima refinery was looking for a way to have more effective cost controls for their turnarounds.

  • They needed a way to streamline data entry and schedule updating and reporting.


  • 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

From Our Customer

"Coming in at 6am instead of 4am each day made a big difference to our team; not only on a daily basis but by not being exhausted at the end of the turnaround. TAPS saved 600 grueling hours.”

-Ken Admire, Lead Planner/Scheduler