Google Sheets to a driver-based forecast
Plenty of good data lives in Google Sheets: a sales pipeline, a pricing table, a forecast another team maintains. Timshal can read a sheet as a data source, so that data feeds your model without anyone copying and pasting it.
Pick the sheet, pick the tab
You choose the file through Google's own file picker, and Timshal can read only the files you pick. Then you choose the tab and the header row.
Three shapes of data
For each column you say whether it is a value, a dimension such as region or product, a date, or something to skip. New dimension members that appear in the sheet are added to the model automatically.
- Table: one row per item, such as a list of customers or products
- Transactions: one row per event with a date, summed by month
- Time series: dates across the columns, the way most spreadsheet forecasts are laid out
Actuals or forecast
A sheet can supply actuals, or it can supply future periods too: a sales team's own forecast, for example, can fill the forecast months while QuickBooks fills the closed ones.
Refreshing
The first sync runs as soon as you save the connection. After that, sync on a daily, weekly or monthly schedule, or on demand. If someone changes a column's type in the sheet, the sync stops and tells you why instead of importing bad numbers.