“One thing that caught my attention from the beginning was how the combination of Sheetgo’s Connection features and data-transfer automation functionality could be so powerful. It’s exactly what I was looking for.”

Jimmy Webb

Senior Finance Analyst, Quantum Spatial

connected spreadsheets

hours saved each week

Industry

Business Support Services

Country

USA

Client

Quantum Spatial Incorporated (QSI), is a geospatial data firm, and provides geographic insights to the largest government and corporate organizations that need geospatial intelligence to mitigate risk, plan for growth, better manage resources and advance scientific understanding.

Customers use the company’s acquisition, processing, analytics and visualization solutions in a range of technical and scientific disciplines. Quantum Spatial is the go-to partner for organizations that want to map, model and better manage their world.

 

Challenge

3D surface of bare-earth ground model and stream channel bathymetry of Kootenai River, derived from aerial survey of topo-bathy LiDAR survey.

Their business process operates on a frequent cadence. In order to give business leaders visibility, the finance team needed a way to create and maintain a live forecast. Doing this with offices across the United States, India and Canada, would have required significant manual effort to integrate and process information from over 30 operational spreadsheets.

Manual integration also significantly increased the possibility of data loss or corruption. Another risk to data quality that is common with Excel usage is version control.

Solution

The company’s research showed that Sheetgo provided a simple and robust way to connect multiple sheets. Today, Quantum Spatial uses Alteryx to filter information from their database directly into Google Sheets with Sheetgo doing everything else from there to get the reports updated automatically.

The team also uses the Consolidate feature at the end to create a master sheet out of all the forecast models.

“Sheetgo for teams helps the company to be able to cover for each other, to check and share information which saves the company a lot of time. Sheetgo is an invaluable part of our process.” said Jimmy.

Photo of Quantum Spatial’s autonomous robot performing a substation inspection, equipped with custom sensor package to detect thermal anomalies, physical changes to the environment, and material degradation.

Get started with Sheetgo today