NV5 Geospatial: A live geospatial forecast merging data from 109 spreadsheets using Sheetgo

NV5 team

Using Sheetgo, NV5 Geospatial now saves 1481 hours per year, using the Merge feature to connect data from 109 spreadsheets for an accurate, real-time forecast.

As a result, the company saves around 14 days of work per month, while providing an even better service for their customers.

Creating a live forecast of geospatial intelligence

  • Complex forecast from 30+ operational spreadsheets
  • Difficulty integrating data from multiple locations globally
  • Struggle to maintain a live forecast manually

NV5’s customers use the company’s acquisition, processing, analytics, and visualization solutions in a range of technical and scientific disciplines. In order to give business leaders visibility, the finance team needed a way to create and maintain a live forecast. However, doing this required connecting data from multiple offices globally, including the United States, India, and Canada.

Manually doing this was simply not an option; it significantly increased the possibility of data loss or corruption, especially when dealing with 109 spreadsheets. Using Excel was also not an option, as version control could be a very serious problem.

“Manually updating our data from all of our offices simply wasn’t an option – we needed something that could do the job for us.” Jimmy Webb, Senior Finance Analyst | NV5 Geospatial

In order to create the necessary up-to-date reports, NV5 needed a solution where they could automatically merge their hundreds of spreadsheets, and also have the ability to update this data at a very high frequency.

The company’s research showed that Sheetgo provided a simple and robust way to connect multiple sheets, offering the intelligent features they need including smart automation to achieve the live forecast they need for their customers.

Automated forecast modelling and reporting with Sheetgo

  • Connections between 109 Google Sheets
  • Merge to create reports from all forecast models
  • Live forecast through automation schedule

Using Sheetgo, NV5 was able to create a custom workflow that connected their 109 Google Sheets worldwide into one place. Using the Connect feature, they were able to automate the data transferal between multiple spreadsheets to create their forecast models, preventing the need for manual input.

NV5 then used the Merge feature to combine their operational spreadsheets into one large master sheet, to create up-to-date, comprehensive reports.

“Combining Sheetgo’s connection features and data-transfer automation functionality is so powerful. It’s exactly what I need.” Jimmy Webb, Senior Finance Analyst | NV5 Geospatial

NV5 Geospatial now uses Alteryx to filter information from their database directly into Google Sheets, and Sheetgo takes over from there to automatically update and share data, connecting the data so that NV5 can create the latest forecasting reports for their customers.

Saving 14 days every month to focus on building solutions

  • 1481 hours saved every year
  • 14 days of work saved every month
  • 100% up-to-date forecast reports

With this solution, the company saves on average 14 days of work per month. That’s over a fortnight every month that NV5 can use to focus on other areas of the geospatial data firm.

Additionally, the automatic integration and consolidation of data help them avoid data loss or corruption, guaranteeing accurate, up-to-date forecasts that are always available.

“Sheetgo for teams helps us to be able to cover for each other, to check and share data saving the company a lot of time. Sheetgo is an invaluable part of our process.” Jimmy Webb | Senior Finance Analyst, NV5 Geospatial

NV5 Geospatial no longer have to worry about manually connecting their ever-changing data, or not giving their customers the latest geographic data.

With Sheetgo as a part of their solution, they have their operational spreadsheets in a single workflow, which has the flexibility to scale alongside the company.

NV5 logo

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

United States

Industry
Business services

Features used
Google Sheets
Connect
Merge
Automatic updates