Case Study: City of Farmington saves time and improves reporting with Spreadsheet Server

Financial Analyst Was Able to Save Time on Report Creation, Enabling Her to Spend More Time on Learning and Providing Insights to Senior Management

The City of Farmington, New Mexico, used Spreadsheet Server to help its finance team overcome a highly manual reporting process. Before implementation, analysts were pulling data from an AS/400 system with EZ-Pickin’s, dumping it into Excel, and spending days cleaning and reformatting large reports, making it difficult to get timely insights or catch issues in the data.

With Spreadsheet Server, the City of Farmington gained live, direct ERP-connected reporting in Excel, self-service drill-downs, and easier report distribution. The result was dramatic: Olena Erickson created more than 200 reports, 42 reports that previously took two weeks now take about two hours, and the team reduced dependence on IT while improving confidence in the data and freeing time for deeper analysis and skill-building.

City of Farmington

Olena Erickson

Financial Analyst