Translate
  • Home
  • Erlang Calculator
  • Forecasting
  • Multi Channel Calculator
  • Articles
    • Hints and Tips
    • Customer Experience
    • Service Strategy
    • Management
    • Skills
    • WFM
    • Quality
  • Erlang
    • Erlang Calculator
    • Erlang Calculation
    • Erlang Formula
    • Excel Calculator
    • Online Calculator
    • What is an Erlang?
  • Tools
    • Erlang Calculator
    • Forecasting
    • Excel Calculator
    • Cheat Sheets
    • Call Monitoring Form
    • Jargon

Online Forecast Calculator (Beta Version 2.0)

This is the Call Centre Helper free online experimental forecasting tool for calculating and creating time series forecasts in contact centres and other applications.

It is at Beta Release 2.0 so may be a bit buggy.
image example output from the online forecasting tool
It takes a number of years of data and then by looking at trends and seasonality tries to predict the future.

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
AB
1MonthContacts
22021-01-0133106
32021-02-0135096
42021-03-0143479
52021-04-0135878
62021-05-0136487
72021-06-0138882
82021-07-0140962

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

Period Best format
Starting Date
(yyyy-mm-dd)
Alternative format Example
Day 2021-02-23 23-Feb-2021 excel file
Week 2021-02-23 23-Feb-2021 excel file
Month 2021-02-01 Feb-2021 excel file
Quarter 2021-01-01 Jan-2021 excel file
Year 2021-01-01 2021 excel file

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?

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.

Popular Tools
Thumbnail Erlang Calculator Online
Erlang Calculator
Thumbnail Erlang C Calculator Excel Including Shrinkage Download
Erlang C Calculator Excel Including Shrinkage
Thumbnail Free Call Monitoring and Coaching Form Download
Free Call Monitoring and Coaching Form
Thumbnail Monthly Forecasting Excel Spreadsheet Template Download
Monthly Forecasting Excel Spreadsheet Template
Thumbnail Multi-Channel Contact Centre Calculator Tool – Phone Email Chat Online
Multi-Channel Contact Centre Calculator Tool – Phone Email Chat
Thumbnail Contact Centre Dashboard Excel Template
Contact Centre Dashboard Excel Template
 
Call Centre Tools is a popular collection of Contact Centre and WFM tools. Widely used for Contact Centers, Customer Service, BPO and CX.
© Clearly Presented Ltd® 2025 | Terms | Cookies | Privacy | Contact | Advertise