Home ›Videos ›Collaboration ›Spreadsheet analytics
CollaborationSpreadsheet analytics
Ask the numbers. Forecast the spend. Spreadsheets on the ERP's own data, with statistics and forecasts.
This film could not be played. The connection may have dropped.
Back to the video libraryRead the transcript47 words
Introduction
A contractor's fuel, power and concrete, analysed where the numbers already are.
Forecast: Spend to date, projected to the year end
Spend to date, forecast to the year end.
Regression: What makes the concrete strong
The water-cement ratio explains the strength.
ANOVA: A question asked live
A one-way ANOVA, asked live.
Model: Published, and projected
A forecast published as a model.
The grid: The books' figures, by week
Every figure straight from the books.
Wrap-up
I.S ERP Spreadsheet.
More from Collaboration
All Collaboration filmsSee Spreadsheet analytics on your own data.
Book a 30-minute demo and we walk through the modules you need, on data shaped like yours.