• Hi Grasshopper,

    I do not have any examples of weighted averages, but you may considering looking at exponential smoothing which weights, more heavily, recent periods.

    I do suggest making sure that you prepare the data before forecasting on it. By using a moving median, you can eliminate a lot of the outliers.

    Also, it's worth looking at the forecasting datamining algorithm in SSAS, which is a great tool.

    Good luck,

    Mark