Frequently asked questions
  ⊲Back to FAQs

  ⊲Buy ezForecaster

How should worksheets be formatted for ezForecaster?

 ezForecaster has a few rules on how you should best format your data, but there's also a lot of freedom too. Your data series can be anywhere on a worksheet, and in any worksheet in any workbook. Remember that in ezForecaster, you are usually forecasting something over time. You have historical or base data by some time 'bucket' like week, month, year.
Examples of how ezForecaster likes to see your data

You can forecast a series of numbers in a column:


Or a row:


Naturally, you can forecast multiple series at the same time, and this example below could be 12 series of 3 data points, or, more probably, 3 series of 12 data points.




However, in order to clarify the format of the data, it's best to put labels and headings on it:

Notice that when labels and headings are used, they are directly to the left or directly above your data, without any blank columns or rows between them and the data.

Of course, blank data is allowed, because it may represent that a product was unavailable for sale, or that data was unrecorded:

Examples of Data that can't be forecasted as easily

Make sure your block of data is contiguous, don't leave blank rows or columns, like this:

And don't leave blank rows or columns between the labels/headings and the data like this:

ezForecaster cannot forecast data that is in a PivotTable format:

ezForecaster needs data in consecutive time buckets, so that it can correctly determine seasonality and time order. In the example below the months are not in date order...


and in this example, one month (Jul-09) is missing completely.


TIP: If your time labels/headings are formatted as a date type in Excel (rather than plain text or general format), ezForecaster can detect it and project those time periods forwards. For example, if your data stops at July 2016, ezForecaster knows the first forecast period will be August 2016.

Home | ezForecaster | Services | Support | About Us Copyright 1997-2016. All rights reserved.