1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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.

submitted by /u/TheSavage1996
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#Excel compatibility
#real-time data collaboration
#Excel alternatives
#real-time collaboration
#rows.com
#big data management in spreadsheets
#conversational data analysis
#financial modeling with spreadsheets
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#FORECAST.ETS
#time series forecasting
#Excel