jmenche
06-16-2015, 05:24 AM
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!!
:beerchug:
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
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!!
:beerchug:
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