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!