1. Prepare Your Data in 2 Columns in a Spreadsheet

Using Excel or Google Sheets prepare your data in two columns. - Date in the left hand column, Value in the Right Hand Column.

Data needs to be entered in two columns

• Date (YYYY-MM-DD) e.g. 2021-12-01
• Values (Without symbols or commas) e.g. 33100

Example Spreadsheet
	A	B
1	Month	Contacts
2	2021-01-01	33106
3	2021-02-01	35096
4	2021-03-01	43479
5	2021-04-01	35878
6	2021-05-01	36487
7	2021-06-01	38882
8	2021-07-01	40962

This forecasting calculator needs at least 13 months of data (ideally 2 years or more) to generate a reasonable forecast.
(The more data you enter the better the forecast).

2. Make sure you have the correct Date Format

If in doubt about weeks, months, quarters or years, use the first day of the period.

Important Information

1. The date format needs to be either yyyy-mm-dd or mmm-yyyy e.g. 21-Dec-2021 or Dec-2021.
2. Make sure you don't have any commas in the values e.g. 33,100 should be entered as 33100.
3. If you are unsure on how to have your CSV formatted, please download this example - Online Forecast Excel Date Input Example

3. Select the type of data are you trying to forecast?

Choose one option:

• Number of calls or contacts
• Sales figures
• Prices or currency
• Orders
• Temperature
• Other

4. Please select your input method

Cut & Paste from Excel

OR

  

Use Example Data

Upload Your Data.

Cut & Paste from Excel:

If no header row has been inserted, default values will be used.

Terms and Conditions - Use of the Forecasting Tool is subject to our standard terms and conditions.

If you experience any issues, please email newsdesk@callcentrehelper.com.