Spreadsheet: 76895d1277374546-help-with-a-running-average-formula-book1
Sheet: Sheet1

Attendance 2010
 |  |  | Total In | Total Meals |  | Running Average
Week 1 beginning January 4th
Monday |  |  | 51 | 35
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 51 | 35
Week 1 average |  |  | 51 | 35 |  |  |  | 51 | 35
Week 2 beginning January 11th
Monday |  |  | 39 | 28
Tuesday |  |  | 33 | 21
Wednesday
Thursday
Friday |  |  | 35 | 24
Total for week |  |  | 107 | 73
week 2 average |  |  | 35.66666666666666 | 24.33333333333333 |  |  |  | 39.5 | 27
Week3 beginning January 18th
Monday |  |  | 39 | 23
Tuesday |  |  | 43 | 21
Wednesday |  |  | 37
Thursday |  |  | 31
Friday |  |  |  | 24
Total for week |  |  | 150 | 68
week 3 average |  |  | 37.5 | 22.66666666666667 |  |  |  | 38.5 | 25.14285714285714
Week 4 beginning January 25th
Monday |  |  | 49 | 32
Tuesday |  |  | 41 | 29
Wednesday |  |  | 36 | 24
Thursday |  |  | 38 | 30
Friday |  |  | 41 | 27
Total for week |  |  | 205 | 142
week 4 average |  |  | 41 | 28.4 |  |  |  | 39.46153846153846 | 26.5
Week 5 beginning February 1st
Monday |  |  | 41 | 30
Tuesday |  |  | 46 | 34
Wednesday |  |  | 45 | 31
Thursday |  |  | 47 | 34
Friday |  |  | 51 | 37
Total for week |  |  | 230 | 166
Week 5 average |  |  | 46 | 33.2 |  |  |  | 41.27777777777778 | 28.47058823529412
Week 6 beginning February 8th
Monday |  |  | 62 | 44
Tuesday |  |  | 45 | 31
Wednesday |  |  | 40 | 28
Thursday |  |  | 50 | 40
Friday |  |  | 50 | 30
Total for week |  |  | 247 | 173
week 6 average |  |  | 49.4 | 34.6 |  |  |  | 43.04347826086956 | 29.86363636363636
Week 7 beginning February 15th
Monday |  |  | 41 | 32
Tuesday |  |  | 50 | 39
Wednesday |  |  | 37 | 30
Thursday |  |  | 39 | 25
Friday
Total for week |  |  | 167 | 126
week 7 average |  |  | 41.75 | 31.5 |  |  |  | 42.85185185185185 | 30.11538461538462
Week 8 beginning February 22nd
Monday |  |  | 41 | 34
Tuesday |  |  | 55 | 45
Wednesday |  |  | 45 | 32
Thursday |  |  | 49 | 31
Friday |  |  | 44 | 37
Total for week |  |  | 234 | 179
week 8 average |  |  | 46.8 | 35.8 |  |  |  | 43.46875 | 31.03225806451613
Week 9 beginning March 1st
Monday |  |  | 52 | 42
Tuesday |  |  | 44 | 32
Wednesday |  |  | 44 | 29
Thursday |  |  | 47 | 27
Friday |  |  | 46 | 29
Total for week |  |  | 233 | 159
week 9 average |  |  | 46.6 | 31.8 |  |  |  | 43.89189189189189 | 31.13888888888889
Week 10 beginning March 8th
Monday |  |  | 50 | 32
Tuesday |  |  | 50 | 35
Wednesday |  |  | 49 | 35
Thursday |  |  | 57 | 44
Friday |  |  | 53 | 40
Total for week |  |  | 259 | 186
week 10 average |  |  | 51.8 | 37.2 |  |  |  | 44.83333333333334 | 31.87804878048781
Week 11 beginning March 15th
Monday |  |  | 58 | 42
Tuesday |  |  | 53 | 43
Wednesday |  |  | 42 | 32
Thursday |  |  | 43 | 34
Friday |  |  | 44 | 34
Total for week |  |  | 240 | 185
week 11 average |  |  | 48 | 37 |  |  |  | 45.17021276595744 | 32.43478260869565
Week 12 beginning March 22nd
Monday |  |  | 47 | 36
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 47 | 36
week 12 average |  |  | 47 | 36 |  |  |  | 45.20833333333334 | 32.51063829787234
Week 13 beginning March 29th
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 13 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 14 beginning April 5th
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 14 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 15 beginning April 12th
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 15 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 16 beginning April 19th
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 16 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 17 Beginning April 26th
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 17 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 18 beginning May 3rd
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 18 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 19 beginning May 10th
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 19 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 20 beginning May 17th
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 20 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 21 beginning May 24th
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 21 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 22 beginning May 31st
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 22 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 23 Beginning June 7th
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 23 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 24 Beginning June 14th
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 24 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 25 beginning June 21st
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 25 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 26 beginning June 28th
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 26 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 27 beginning July 5th
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 27 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 28 beginning July 12th
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 28 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week29 beginning July 19th
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 29 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 30 beginning July 26th
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 30 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 31 beginning August 2nd
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 31 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 32 Beginning August 9th
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 32 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 33 beginning August 16th
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 33 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 34 beginning August 23rd
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 34 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 35 beginning August 30th
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 35 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 36 beginning September 6th
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 36 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 37 beginning September 13th
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 37 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 38 beginning September 20th
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 38 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 39 beginning September 27th
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 39 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 40 beginning October 4th
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 40 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 41 beginning October 11th
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 41 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 42 beginning October 18th
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 42 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 43 beginning October 25th
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 43 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 44 beginning November 1st
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 44 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 45 beginning November 8th
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 45 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 46 beginning November 15th
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 46 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 47 beginning Novemmber 22nd
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 47 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 48 beginning November 29th
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 48 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 49 beginning December 6th
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 49 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 50 beginning December 13th
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 50 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 51 beginning December 20th
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 51 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234
Week 52 beginning December 27th
Monday
Tuesday
Wednesday
Thursday
Friday
Total for week |  |  | 0 | 0
week 52 average |  |  | #N/A | #N/A |  |  |  | 45.20833333333334 | 32.51063829787234