Global Software's News and Events

Case Studies

Philadelphia Gas Works

About the Company

Philadelphia Gas Works, more commonly referred to as “PGW,” was founded in 1836 by new employees who installed 46 natural gas lights along the streets of Philadelphia, PA. Now, PGW is the largest municipally owned gas utility in the United States managing over 6,000 miles of natural gas mains and pipes. They annually deliver roughly 78 billion cubic feet of natural gas and serve approximately 500,000 customers, 24 hours a day, 365 days a year. PGW found Spreadsheet Server as they were looking for an alternate, less time consuming way to keep records.

Situation & Strategy

Case Study Strategy: 

Prior to implementing Spreadsheet Server, PGW was required to manually import all data from multiple departments and various reports. The process of completing reports would take a minimum of two days and at least 24 hours to compile information for distribution. According to PGW, they were “spending too much time retrieving data and manually inputting information.” PGW wanted a more effective system that would speed up the reporting process and increase time for analytical work and daily tasks. Spreadsheet Server was the answer due to its compatibility with Oracle software and the ability to replace FSG reports.

Software Implementation

Case Study Software: 

Spreadsheet Server converts Excel into a tightly integrated analytical tool for any ERP system. Users can leverage the strength of their spreadsheets with seamless dynamic integration to their information, along with powerful drilldown capability to the lowest level of detail. It allows users to build a range of reports from simple ad hoc workbooks to complex dashboard-type views of critical business data.

Distribution Manager automates the distribution of reports from Microsoft® Excel.


Case Study Results: 
  • One-day implementation and training for intuitive, user-friendly products
  • Reporting process transformed from manual, time-consuming report generation to automated reporting and distrubtion
  • Eliminated manual data retrieval and input

In a Nutshell

Case Study Summary: 

Spreadsheet Server allows PGW to drastically cut back on the time it takes to compile variance reports, cost savings, payroll, appliance, revenue, interest, taxes, etc. The implementation process even saved PGW time— one hour to set up and one 30 minute training session was all that was necessary to begin using this new system. Spreadsheet Server is also currently being used for PGW’s annual Moak report.

Download PDF - 150.34 KB