Smoothing data

[jmenche]

Howdy,

This is not a programming issue but an advanced formula one (I think). I have A LOT of weekly data by A LOT of stores. I want to calculate a "smooth" number for each week by using the value from a fitted trend line. It is easy to do for 1 store but I cannot create 2,000 charts to find 2,000 trend line formulas.

Is there an easier way?

Here is some sample data from one store.

Thanks!!

Jeff

Week	Sales
1	167
2	138
3	151
4	191
5	169
6	170
7	162
8	169
9	157
10	170
11	138
12	134
13	163
14	137
15	161
16	143
17	159
18	171
19	160
20	149
21	190
22	156
23	189
24	185
25	188
26	196
27	152
28	169
29	155
30	133
31	155
32	136
33	140
34	157
35	147
36	113
37	146
38	148
39	170
40	145
41	154
42	154
43	191
44	153
45	170
46	170
47	149
48	143
49	148
50	169
51	155
52	146

[jmenche]

Alright....I figured out how to use the TREND function. However, it only calculates a straight line. Can I estimate a polynomial line??