SMEP CPL Reporting

Introduction
The Current Potential Level (CPL) is a monthly report that provides a forecast of field production of each hub for the following month + 90days and to derive the monthly Gas Delivery Schedule (GDS) as Gas Sales commitment to downstream LNG customer.. The CPL Report has multiple data points that sit in different. The report also involves calculations that were done manually for the datapoints like Forecast, Well Potential, Constraint And IPSC.

Solution: The process of collecting and streamlining of the data is automated using automated excel upload interface - EC Integration Service(ECIS) and SQL Server Integration Services (SSIS) Populating the data in the report and generating the report is done with a reporting tool - BO Universe. The calculations on the data is handled by EC Database packages and views. PACE provides a platform for generation of APC “applications” that have:

Business Impact

40 days/year saved / 90% efficiency gain

Automated and streamlined Data collection

Saving 15k USD in collecting, QA/QC, verifying and consolidating all data by implementing WRFM&O PHEA RP01 best practice.

Data Source Integration

Singular data source Energy Components

Saving 10k USD to generate the CPL report in Excel and Documented Work Instructions to sustain the process.

Improving the Existing Data in EC (FTHP-CITHP)

Integration of Data Tools like Sample Manager

The total efficiency gain in automating the manual data scavenging and manual data population is around USD 23500. Acclaiming Akhil, Bram and Pavithra for delivering the project and as well improving the numbers from ~300 hrs of saving to ~680 hrs by suggesting multiple other enhancements (ECIS, Sample Manager etc) and ensuring performance by managing all complexity in a view.