VBA Modules and Subroutines
The Web site also contains several VBA files that automate the creation of forecasts, quality control charts, and sales and marketing analyses.
Forecasting Modules
Chapter 9, “Forecasting and Projections,” describes how to use Excel to make forecasts of variables such as revenues and product demand. It also describes how to extend Excel's built-in functions to make your forecasts more accurate. These extensions depend on VBA modules that you can find on the Web site in the folder named Chap09:
Smooth.xls contains code that you can use to extend Excel's Exponential Smoothing add-in to take account of seasonality in a baseline, to make annual forecasts more accurate.
ARIMA.xls contains code that you can use to determine ...
Get Business Analysis with Microsoft® Excel, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
