A natural gas utility provider relies on a critical forecasting application to predict gas usage and support scheduling and accounting decisions throughout the day. The system operates around the clock, combining weather forecasts, production information, and data from multiple external sources. CKC Automation helped transform the legacy forecasting system into a more reliable and scalable web-based application built to support ongoing operations and future growth.

CKC Automation transformed a legacy forecasting tool into a robust web-based application, improving reliability, data management, and long-term supportability for critical natural gas operations.

The Challenge

The forecasting application is used 24/7 and depends on information from numerous external data sources. Operators must submit updated gas usage forecasts multiple times each day to support scheduling and supply requirements. Missing or unavailable incoming data could disrupt the application, delay forecast submissions, or result in inaccurate forecasts

The solution

CKC Automation transformed the legacy system into a more robust ASP.NET Core web application hosted within the customer’s IT environment. The updated application consolidated data storage into fewer locations and moved portions of the system from spreadsheet-based storage into Microsoft SQL Server, making it easier to maintain, troubleshoot, and scale. CKC also provides ongoing support to resolve data outages, address software issues, and implement new functionality as operational needs evolve.

Before:

After: