User Tools

Site Tools


Go to GMDH home page

Video Tutorials

User Guide

1. Streamline Client

2.Streamline Server

3. Starting Up

4. Connecting data

5. Demand and Sales Forecasting

6. Inventory Planning

7. Reference


5.4. Exporting Forecasts to Excel

Streamline has a number of reports. One of them is the Final forecast report. This report contains statistical forecasts and all of the manual forecasts overrides you have made. So that is our demand plan.

The Final forecast report is on the Reports tab. It is displayed by default (see figure below).

All of the forecast overrides are in blue.

You can aggregate the report by item, location or channel, ABC analysis, any item category, or all of the columns at once using the Aggregate by control before exporting it from Streamline (see figure below).

You can also sum the forecasts by quarter or year using the Sum by control (see figure below).

Any report from the Select report list can be exported to Excel.

Let’s export our Final forecast report to Excel by clicking the Export report button found in the Reports toolbar.

Streamline automatically creates an Excel file with the report table, saves it on the hard drive, and opens in Excel (see figure below).

Next: Manual Adjustments

Download PDF

exporting-forecasts.txt · Last modified: 2021/10/27 10:25 by admin