Easy time series forecasting in Google Sheets
ForecastSheets is a Google Sheets add-on which enables you to quickly generate forecasts on time series data directly inside your spreadsheet.
>> Try it out
Why use this add-on?
Let's say you have a time series dataset in a Google Sheets spreadsheet. And this dataset has some seasonality - monthly, annual, or maybe of another frequency.
There's currently no easy way to generate reliable predictions on that data. Existing solutions can't handle seasonal trends. So you have to export the data to another application, which is very time consuming!
That's where ForecastSheets comes in. Within 2 minutes, you can make accurate forecasts directly in the spreadsheet.
How does it work?
- Install the ForecastSheets add-on from the Google Workspace Marketplace
- Go to your Google Sheets spreadsheet that has the time series data, and open up the add-on from the Extensions menu
- Select the range of cells that contain the time series data, the range of cells where you want the projections to be populated, and the model settings
- In less than a minute, the extension will send the data to our forecasting model and render the results in your spreadsheet
The prediction model is based on the Holt-Winters exponential smoothing method, with an additive trend component and an additive seasonal component.
Who made it?
Hi there! My name is Mihail and I'm a software engineer based in the most boring place in the world. I came up with the idea after a friend of mine asked me to create a forecast for some time series data that he had in Google Sheets.
I thought "how hard can it be?", so I said yes. And then I spent a whole week trying to figure out how to do it -_-
I sat on the idea for more than a year; I was working on other projects. None of them were successful, so here I am (°ー°〃)
Contact
Have issues, questions, or feedback? Send me a message using this contact form and I'll get back to you within 24 hours.
Alternatively, you can contact me on LinkedIn. Make sure you include a message in your connection request.