Sales Pattern / Forecast

[RIZVI]

I have a data of sales as below:

Table is from ED3 till EP3. ED3 till EO3 are months starting from April, till March, while EP3 is the heading "Total".

Sales data is automattically entered in cells ED7 till EO7 for the given months thru a formula against each customer name and month.

Column EC7 till EC101 are Customer names.

Row 102 of ths table calculates the monthly total sales.

Now I need help so as to find the patern or be able to forecats depending upon the sales / purchase pattern of a particulr customer for the next month.
Say for a customer names xyz, in row 30, he has been buying a certain value in April, certtian value in May, NIL in June , then a certin Value in July, ....till October. Now based on his pattern can I make a safe prediction as to what are his chances of buying in November and of what value.

I am using Excell 2007, and the sheet has many tables, formulas, protections, conditional formatting etc. Beisdes this is linked to other sheets etc.

Let me know what more information will be required.

Thanking in advance.

With regards,

Rizvi.M.H.

 

[jberwald]

See if this might help

http://office.microsoft.com/en-us/e...d-forecast-sales-with-charts-HA001087785.aspx

 

[RIZVI]

No the stated link was not of much use. What I amy be requireing is a simple formua that I enter, and it shall calculate the data and give me.

Hope if some one can provide me with that formula.

RGDS,

Rizvi