https://timewise-analytics.com

I have used many add-ons in Excel over the years that allowed manipulation of time series (and other non-simple structured data) but have never seen anything similar for Google Sheets.

The idea is that you can hold references to time series data represented in a single spreadsheet cell and pass these as parameters to functions that themselves return a time series reference. This allows function chains to be built using references to single cells. These references can be expanded or charted (via a menu) at any point in the chain.

Here is a simple demo video: https://www.youtube.com/watch?v=pcoK-VlmtcI

I have just built this so it is still in early stages and required a few workarounds to get it to work with Google Sheets.

Would be very interested to learn if this is something interesting for doing quick and ad-hoc time series analysis in Google Sheets, and if I should pursue this further.

Docs are here: https://timewise-analytics.com/docs/

The add-on itself is available on Google Workspace Marketplace https://workspace.google.com/marketplace/app/timewise_analyt...

(Note: after installation or when using in a new Sheets session you may have to call “Activate Addon” from the menu. This is due to Sheets not loading custom functions unless a menu item has been interacted with)

Any feedback appreciated!