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

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.

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.

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.

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.