Exponential Smoothing for each Plant and Material

[uwish7]

I have over 800 lines of data. I am trying to create a forecast for each material based on the plant. I have consumption for two years. I want the forecast to be automatic so when someone enters the plant and material, the forecast is auto populated. Currently the issue I am having is how to use Excel to create exponential smoothing for each plant and material combination. Currently the information is in the format below. If there is a formula to do exponential smoothing with seasonality, that will be wonderful.

Plant Material Year Total Jan Feb Mar Apr May Jun Jul Aug Oct Nov Dec

 

[DRSteele]

If you've got Excel 2016 or later, this function will help.

https://support.office.com/en-us/ar...pId=xlmain11.chm60648&ui=en-US&rs=en-US&ad=US