Sales Forecasting Pro

Step 1

Two columns: date + sales. At least 12 periods for best accuracy.

Example:

Period	Sales
01.01.2020	4211613
01.02.2020	4514849

Step 2

Upload, pick frequency, horizon, confidence and models.

📤 Upload Excel File

Choose file No file chosen

📅 Data Frequency

📈 Forecast Horizon: 24

🎯 Confidence Intervals

80% 95%

🤖 Models to Use

Step 3

Run forecast, view chart & table, download Excel.

Type	Period	Actual	Ensemble	Best Model	Best Forecast	80% Low	80% High	95% Low	95% High

Model	MAPE (%)

💡 How to Use

Data Frequency: Choose your data interval
- Daily: For daily sales data
- Weekly: For weekly reports
- Monthly: For monthly sales (most common)
- Quarterly: For quarterly reports
- Yearly: For annual data
Forecast Horizon: How many periods to predict
Confidence Intervals: Prediction uncertainty ranges
- 80%: Narrower range, 80% confident
- 95%: Wider range, 95% confident
Models: Select which AI algorithms to use
- AutoARIMA: Best for trends
- AutoETS: Weights recent data more
- MSTL: Best for strong seasonality
- AutoCES: Complex patterns
- Prophet: Business forecasting (slower)

Click "Generate Forecast" button
Watch progress: Data loading → Validation → Cross-validation → Forecast → Visualization
Process takes 5-15 seconds depending on data size

Chart tab: Visual forecast with confidence bands
Data tab: Forecast table + Download Excel
Performance tab: Model accuracy comparison
Best Model: Most accurate model (lowest MAPE)
MAPE: Mean Absolute Percentage Error
- <5% = Excellent
- 5-10% = Good
- >10% = Fair