Enhancing Forecasting Capability of Excel with User Defined Functions
We have developed seven user defined functions (UDF) related to forecasting. The first four functions are for exponential smoothing. These are simple exponential smoothing, Holt’s fit, Winter’s method and Holt-Winter method. The next three functions can be used to calculate forecasting errors. These...
| Main Author: | |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
McMaster University
2008-01-01
|
| Series: | Spreadsheets in Education |
| Online Access: | https://sie.scholasticahq.com/article/4549-enhancing-forecasting-capability-of-excel-with-user-defined-functions |