Weekly Moving average

[#1]

Hi Experts,

I am trying to calculate weekly moving average but not been able to get it right. I have attached the spreadhseet with my data. My requirement is,

1) Calculate weekly moving average of avg(CYCLE_LENGTH) over next 26 weeks on every Mondays(PROD_DATE). NOTE : PROD_DATE has multiple recs for the same day and multiple recs within the same week. This needs to be aggregated to weekstart MONDAY.

Below is the snapshot of the data .

Your help is highly appreciated . Kind Regards...CM

CYCLE_LENGTH	ITEM	LOC	OBS_ID	PROD_DATE
13	5153321	W21P	1	6/2/2012
1	5153321	W21P	2	6/15/2012
3	5153321	W21P	3	6/15/2012
1	5153321	W21P	4	6/18/2012
1	5153321	W21P	5	6/18/2012
1	5153321	W21P	6	6/18/2012
1	5153321	W21P	7	6/18/2012
1	5153321	W21P	8	6/19/2012
1	5153321	W21P	9	6/19/2012
1	5153321	W21P	10	6/19/2012
1	5153321	W21P	11	6/19/2012
1	5153321	W21P	12	6/20/2012
2	5153321	W21P	13	6/20/2012
1	5153321	W21P	14	6/22/2012
1	5153321	W21P	15	6/22/2012
2	5153321	W21P	16	6/23/2012
3	5153321	W21P	17	6/25/2012
1	5153321	W21P	18	6/28/2012
1	5153321	W21P	19	6/29/2012
3	5153321	W21P	20	6/29/2012
1	5153321	W21P	21	7/2/2012
1	5153321	W21P	22	7/2/2012
1	5153321	W21P	23	7/2/2012
2	5153321	W21P	24	7/3/2012
1	5153321	W21P	25	7/5/2012
2	5153321	W21P	26	7/5/2012
1	5153321	W21P	27	7/7/2012
2	5153321	W21P	28	7/7/2012
1	5153321	W21P	29	7/9/2012
1	5153321	W21P	30	7/10/2012
1	5153321	W21P	31	7/10/2012
2	5153321	W21P	32	7/11/2012
1	5153321	W21P	33	7/13/2012
2	5153321	W21P	34	7/14/2012
1	5153321	W21P	35	7/16/2012
1	5153321	W21P	36	7/17/2012
1	5153321	W21P	37	7/18/2012
1	5153321	W21P	38	7/18/2012
1	5153321	W21P	39	7/18/2012
2	5153321	W21P	40	7/19/2012
2	5153321	W21P	41	7/21/2012
1	5153321	W21P	42	7/23/2012
2	5153321	W21P	43	7/24/2012
1	5153321	W21P	44	7/26/2012
2	5153321	W21P	45	7/26/2012
2	5153321	W21P	46	7/28/2012
3	5153321	W21P	47	7/30/2012
1	5153321	W21P	48	8/2/2012
11	5153321	W21P	49	8/3/2012
21	5153321	W21P	50	8/14/2012
1	5153321	W21P	51	9/4/2012
7	5153321	W21P	52	9/5/2012
1	5153321	W21P	53	9/12/2012
6	5153321	W21P	54	9/13/2012
1	5153321	W21P	55	9/19/2012
1	5153321	W21P	56	9/20/2012
8	5153321	W21P	57	9/20/2012
1	5153321	W21P	58	9/28/2012
3	5153321	W21P	59	9/28/2012
2	5153321	W21P	60	10/1/2012
5	5153321	W21P	61	10/3/2012
1	5153321	W21P	62	10/8/2012
1	5153321	W21P	63	10/9/2012
1	5153321	W21P	64	10/10/2012
1	5153321	W21P	65	10/11/2012
1	5153321	W21P	66	10/11/2012
4	5153321	W21P	67	10/12/2012
1	5153321	W21P	68	10/16/2012
1	5153321	W21P	69	10/17/2012
1	5153321	W21P	70	10/18/2012
1	5153321	W21P	71	10/19/2012
1	5153321	W21P	72	10/19/2012