The Excel sample sheet i provided only adapts correctly is you change the values in the Qty column. A change in the E3 column would also have to be reflected in the E4 column. When your sales are more sporadic, the three data sets result in more diverse figures between the them (LY, last 13 periods * 12/13, & projected sales based on ytd * 365/#day of the year ). I used these three sets of data because they are what's available in Gridview, if I could use sales from further back I would have worked them into the equation as well. All of this is besides the point though, the main question is whether or not gridview has a statistical function to rule out unusually high figures in the datasets to further increase the accuracy of projected sales. If not in gridview, is projected sales something that could be incorporated into sales analysis or inventory control as a report? My formula is just what I cobbled together myself with what was available to me, I'm sure there are better algorithms out there that could be incorporated into the adagio software.