Case Study: Philadelphia Gas Works achieves automated reporting and cuts report time from days to minutes with Global Software, Inc.'s Spreadsheet Server

Philadelphia Gas Works - Customer Case Study

Philadelphia Gas Works (PGW), founded in 1836, is the largest municipally owned gas utility in the U.S., managing over 6,000 miles of mains and serving about 500,000 customers while delivering roughly 78 billion cubic feet of natural gas annually. PGW faced slow, manual reporting—staff had to import data from multiple departments and compile reports that could take a full day or more, leaving little time for analysis.

PGW implemented Spreadsheet Server (with Distribution Manager) to connect Excel directly to their Oracle ERP, enabling automated data retrieval, drill-down reporting and automated distribution. The solution required minimal deployment and training, eliminated manual data entry and distribution, reduced report generation from hours or days to minutes, and freed finance staff to focus on analysis.

Philadelphia Gas Works

Carita Council

Senior Budget Analyst