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: |
Bond University
|
| Series: | Spreadsheets in Education |
| Online Access: | http://sie.scholasticahq.com/article/4549-enhancing-forecasting-capability-of-excel-with-user-defined-functions.pdf |