Entry
In the first sheet you have the dataset for which estimations can be calculated.Notice that sumOf(QUANTITY) is fixed as your only data source and rows are fixed as your only row source... However you have the ability to modify which columns appear(from the columns box) and which sums are included at the columns(from the page source filter)

In the second sheet you have to define dates that constitute your training set and periods(of length increment repeating every period)for calculating backwards of the data set (not oftenly used) and forward of the data set(for future estimates).Finally you set significance for confidence intervals(How sure are we(%) that the central tendency of the forecast lies within upper and lowerbounds-lower P means wider range).Also incorporated an amplifier for season variation. This is a manual adjustment and should be tweaked at the risk of the decissionmaker.

Finally you are ready to calculate your estimates for all columns: Click calculate estimation

And then the other button to launch a form that will display your data either as a graph (clicking graph) OR as entries in a sheet(clicking paste)...You may then proceed to doing correlations and/or aggregations

Let's see at the available curves
Trend
Lowebound for trend
Upperbound for trend
Your data(updateable for comparison with forecast)
Trend and seasonality
Lowerbound and seasonality
Upperbound and seasonality
Curvature comparison(a good way to hint correlation,leading indicators,ratios behavior for two or more columns)


