Return to Index
Operations Research Models and Methods
excel head
Subunit Operations Management/Industrial Engineering
  - Forecasting
  The add-in implements several forecasting methods for data series including: moving average, exponential smoothing, regression and double exponential smoothing. The add-in constructs a form that holds the data and uses functions to compute forecasts and forecast errors. Several data series can be analyzed on a single worksheet page. An option allows comparison of several methods for a single time series. A simulation option creates data simulated with the Monte Carlo technique. A portfolio option evaluates and forecasts a portfolio of investments. Adjustments are provided for series with seasonality.
Add-in - Click the add-in name to download a zipped .xla file.
Add-in Name


Demonstration Files - Click the demo name to download a .xls file.
Demo Name
File Name
gray line
Return to Top

tree roots

Operations Research Models and Methods
by Paul A. Jensen
Copyright 2010 - All rights reserved