FORECAST.ETS has been the same for the last few years. Does anyone actually use it for serious forecasting?
Been doing time series forecasting professionally for 5 years. Recently went back to look at Excel's built-in FORECAST.ETS out of curiosity and was surprised how little has changed — single algorithm, no outlier handling, no multivariate forecasting.
For anyone using it day-to-day I'm genuinely curious:
1) What do you actually use it for — one-off estimates, or is it baked into a real planning process?
2) Where does it break down most often for you?
3) Is the simplicity the point — i.e. you want something your whole team can understand and audit — or is it a limitation you've just learned to live with?
4) Has anyone layered external variables into their Excel forecasting (promo data, weather, macro indicators)? How'd you handle it?
Not trying to sell anything — just surprised this hasn't evolved and curious if others feel the same friction.
[link] [comments]
Want to read more?
Check out the full article on the original site