Spreadsheet: 111010d1307536942-formula-for-grouping-the-average-of-daily-values-by-julian-week-testdocumentpivot
Sheet: Sheet1

Name | Date | Week | Score |  | Row Labels | Date | Average of Score |  | Row Labels | Week | Average of Score
[NAME] | 2011-05-02 00:00:00 |  | 100 |  | [NAME] | 2011-05-02 00:00:00 | 70 |  | [NAME] | 19 | 87.5
[NAME] | 2011-05-02 00:00:00 |  | 100 |  |  | 2011-05-03 00:00:00 | 87.5 |  |  | 20 | 97.91666666666667
[NAME] | 2011-05-02 00:00:00 |  | 100 |  |  | 2011-05-04 00:00:00 | 100 |  |  | 21 | 100
[NAME] | 2011-05-02 00:00:00 |  | 15 |  |  | 2011-05-05 00:00:00 | 92.5 |  |  | 22 | 94.44444444444444
[NAME] | 2011-05-02 00:00:00 |  | 75 |  |  | 2011-05-06 00:00:00 | 87.5 |  | [NAME] |  | 95.34883720930233
[NAME] | 2011-05-02 00:00:00 |  | 100 |  |  | 2011-05-09 00:00:00 | 100 |  | [NAME] | 19 | 88.57142857142857
[NAME] | 2011-05-02 00:00:00 |  | 100 |  |  | 2011-05-10 00:00:00 | 87.5 |  |  | 20 | 86.27450980392157
[NAME] | 2011-05-02 00:00:00 |  | 100 |  |  | 2011-05-11 00:00:00 | 100 |  |  | 21 | 98
[NAME] | 2011-05-02 00:00:00 |  | 100 |  |  | 2011-05-12 00:00:00 | 100 |  |  | 22 | 100
[NAME] | 2011-05-02 00:00:00 |  | 75 |  |  | 2011-05-13 00:00:00 | 100 |  | [NAME] |  | 90.15037593984962
[NAME] | 2011-05-02 00:00:00 |  | 100 |  |  | 2011-05-17 00:00:00 | 100 |  | [NAME] | 19 | 87.5
[NAME] | 2011-05-02 00:00:00 |  | 100 |  |  | 2011-05-18 00:00:00 | 100 |  | Karen Total |  | 87.5
[NAME] | 2011-05-02 00:00:00 |  | 100 |  |  | 2011-05-19 00:00:00 | 100 |  | [NAME] | 19 | 97.91666666666667
[NAME] | 2011-05-02 00:00:00 |  | 100 |  |  | 2011-05-20 00:00:00 | 100 |  |  | 20 | 100
[NAME] | 2011-05-02 00:00:00 |  | 100 |  |  | 2011-05-23 00:00:00 | 100 |  |  | 21 | 90.66666666666667
[NAME] | 2011-05-02 00:00:00 |  | 100 |  |  | 2011-05-24 00:00:00 | 100 |  |  | 22 | 83.33333333333333
[NAME] | 2011-05-02 00:00:00 |  | 75 |  |  | 2011-05-25 00:00:00 | 83.33333333333333 |  | [NAME] |  | 94.02777777777777
[NAME] | 2011-05-02 00:00:00 |  | 40 |  | [NAME] |  | 95.34883720930233 |  | Grand Total |  | 91.82242990654206
[NAME] | 2011-05-02 00:00:00 |  | 100 |  | [NAME] | 2011-05-02 00:00:00 | 90.58823529411765
[NAME] | 2011-05-02 00:00:00 |  | 75 |  |  | 2011-05-03 00:00:00 | 96.92307692307692
[NAME] | 2011-05-02 00:00:00 |  | 100 |  |  | 2011-05-04 00:00:00 | 100
[NAME] | 2011-05-03 00:00:00 |  | 100 |  |  | 2011-05-05 00:00:00 | 100
[NAME] | 2011-05-03 00:00:00 |  | 100 |  |  | 2011-05-06 00:00:00 | 40
[NAME] | 2011-05-03 00:00:00 |  | 100 |  |  | 2011-05-09 00:00:00 | 75.55555555555556
[NAME] | 2011-05-03 00:00:00 |  | 100 |  |  | 2011-05-10 00:00:00 | 76.36363636363636
[NAME] | 2011-05-03 00:00:00 |  |  |  |  | 2011-05-11 00:00:00 | 100
[NAME] | 2011-05-03 00:00:00 |  | 85 |  |  | 2011-05-12 00:00:00 | 100
[NAME] | 2011-05-03 00:00:00 |  | 100 |  |  | 2011-05-13 00:00:00 | 100
[NAME] | 2011-05-03 00:00:00 |  | 100 |  |  | 2011-05-16 00:00:00 | 93.75
[NAME] | 2011-05-03 00:00:00 |  |  |  |  | 2011-05-17 00:00:00 | 100
[NAME] | 2011-05-03 00:00:00 |  | 100 |  |  | 2011-05-18 00:00:00 | 100
[NAME] | 2011-05-03 00:00:00 |  | 100 |  |  | 2011-05-19 00:00:00 | 100
[NAME] | 2011-05-03 00:00:00 |  | 75 |  |  | 2011-05-20 00:00:00 | 95
[NAME] | 2011-05-03 00:00:00 |  | 100 |  |  | 2011-05-25 00:00:00 | 100
[NAME] | 2011-05-03 00:00:00 |  | 100 |  | [NAME] |  | 90.15037593984962
[NAME] | 2011-05-03 00:00:00 |  | 100 |  | [NAME] | 2011-05-02 00:00:00 | 87.5
[NAME] | 2011-05-03 00:00:00 |  | 100 |  | Karen Total |  | 87.5
[NAME] | 2011-05-03 00:00:00 |  | 75 |  | [NAME] | 2011-05-03 00:00:00 | 100
[NAME] | 2011-05-03 00:00:00 |  | 100 |  |  | 2011-05-04 00:00:00 | 100
[NAME] | 2011-05-03 00:00:00 |  | 100 |  |  | 2011-05-05 00:00:00 | 91.66666666666667
[NAME] | 2011-05-03 00:00:00 |  | 100 |  |  | 2011-05-06 00:00:00 | 100
[NAME] | 2011-05-04 00:00:00 |  | 100 |  |  | 2011-05-09 00:00:00
[NAME] | 2011-05-04 00:00:00 |  | 100 |  |  | 2011-05-10 00:00:00 | 100
[NAME] | 2011-05-04 00:00:00 |  | 100 |  |  | 2011-05-12 00:00:00 | 100
[NAME] | 2011-05-04 00:00:00 |  | 100 |  |  | 2011-05-16 00:00:00 | 100
[NAME] | 2011-05-04 00:00:00 |  | 100 |  |  | 2011-05-17 00:00:00 | 100
[NAME] | 2011-05-04 00:00:00 |  | 100 |  |  | 2011-05-18 00:00:00 | 80
[NAME] | 2011-05-04 00:00:00 |  | 100 |  |  | 2011-05-19 00:00:00 | 81.66666666666667
[NAME] | 2011-05-04 00:00:00 |  |  |  |  | 2011-05-20 00:00:00 | 91.66666666666667
[NAME] | 2011-05-04 00:00:00 |  |  |  |  | 2011-05-25 00:00:00 | 83.33333333333333
[NAME] | 2011-05-04 00:00:00 |  | 100 |  | [NAME] |  | 94.02777777777777
[NAME] | 2011-05-04 00:00:00 |  | 100 |  | Grand Total |  | 91.82242990654206
[NAME] | 2011-05-04 00:00:00 |  | 100
[NAME] | 2011-05-05 00:00:00 |  | 100
[NAME] | 2011-05-05 00:00:00 |  | 100
[NAME] | 2011-05-05 00:00:00 |  | 100
[NAME] | 2011-05-05 00:00:00 |  | 100
[NAME] | 2011-05-05 00:00:00 |  | 100
[NAME] | 2011-05-05 00:00:00 |  | 100
[NAME] | 2011-05-04 00:00:00 |  | 100
[NAME] | 2011-05-04 00:00:00 |  | 100
[NAME] | 2011-05-05 00:00:00 |  | 75
[NAME] | 2011-05-05 00:00:00 |  | 100
[NAME] | 2011-05-05 00:00:00 |  | 75
[NAME] | 2011-05-05 00:00:00 |  | 110
[NAME] | 2011-05-05 00:00:00 |  | 100
[NAME] | 2011-05-06 00:00:00 |  | 0
[NAME] | 2011-05-06 00:00:00 |  | 0
[NAME] | 2011-05-06 00:00:00 |  | 100
[NAME] | 2011-05-06 00:00:00 |  | 40
[NAME] | 2011-05-06 00:00:00 |  | 100
[NAME] | 2011-05-06 00:00:00 |  | 0
[NAME] | 2011-05-06 00:00:00 |  | 75
[NAME] | 2011-05-06 00:00:00 |  | 100
[NAME] | 2011-05-06 00:00:00 |  | 100
[NAME] | 2011-05-06 00:00:00 |  | 100
[NAME] | 2011-05-06 00:00:00 |  | 100
[NAME] | 2011-05-09 00:00:00 |  | 0
[NAME] | 2011-05-09 00:00:00 |  | 100
[NAME] | 2011-05-09 00:00:00 |  | 100
[NAME] | 2011-05-09 00:00:00 |  | 100
[NAME] | 2011-05-09 00:00:00 |  | 100
[NAME] | 2011-05-09 00:00:00 |  | 0
[NAME] | 2011-05-09 00:00:00 |  | 100
[NAME] | 2011-05-09 00:00:00 |  | 100
[NAME] | 2011-05-09 00:00:00 |  | 100
[NAME] | 2011-05-09 00:00:00 |  | 100
[NAME] | 2011-05-09 00:00:00 |  | 0
[NAME] | 2011-05-09 00:00:00 |  | 0
[NAME] | 2011-05-09 00:00:00 |  | 85
[NAME] | 2011-05-09 00:00:00 |  | 100
[NAME] | 2011-05-09 00:00:00 |  | 100
[NAME] | 2011-05-09 00:00:00 |  | 100
[NAME] | 2011-05-09 00:00:00 |  | 100
[NAME] | 2011-05-09 00:00:00 |  | 75
[NAME] | 2011-05-09 00:00:00 |  | 100
[NAME] | 2011-05-09 00:00:00 |  | 100
[NAME] | 2011-05-09 00:00:00
[NAME] | 2011-05-09 00:00:00
[NAME] | 2011-05-09 00:00:00
[NAME] | 2011-05-10 00:00:00 |  | 100
[NAME] | 2011-05-10 00:00:00 |  | 100
[NAME] | 2011-05-10 00:00:00 |  | 100
[NAME] | 2011-05-10 00:00:00 |  | 100
[NAME] | 2011-05-10 00:00:00 |  | 100
[NAME] | 2011-05-10 00:00:00 |  | 0
[NAME] | 2011-05-10 00:00:00 |  | 0
[NAME] | 2011-05-10 00:00:00 |  | 40
[NAME] | 2011-05-10 00:00:00 |  | 100
[NAME] | 2011-05-10 00:00:00 |  | 100
[NAME] | 2011-05-10 00:00:00
[NAME] | 2011-05-10 00:00:00 |  | 100
[NAME] | 2011-05-10 00:00:00 |  | 100
[NAME] | 2011-05-10 00:00:00 |  | 75
[NAME] | 2011-05-10 00:00:00 |  | 100
[NAME] | 2011-05-10 00:00:00 |  | 100
[NAME] | 2011-05-10 00:00:00 |  | 100
[NAME] | 2011-05-11 00:00:00 |  | 100
[NAME] | 2011-05-11 00:00:00 |  | 100
[NAME] | 2011-05-11 00:00:00
[NAME] | 2011-05-11 00:00:00 |  | 100
[NAME] | 2011-05-11 00:00:00 |  | 100
[NAME] | 2011-05-11 00:00:00 |  | 100
[NAME] | 2011-05-11 00:00:00 |  | 100
[NAME] | 2011-05-11 00:00:00 |  | 100
[NAME] | 2011-05-12 00:00:00 |  | 100
[NAME] | 2011-05-12 00:00:00
[NAME] | 2011-05-12 00:00:00 |  | 100
[NAME] | 2011-05-12 00:00:00 |  | 100
[NAME] | 2011-05-12 00:00:00 |  | 100
[NAME] | 2011-05-12 00:00:00 |  | 100
[NAME] | 2011-05-12 00:00:00
[NAME] | 2011-05-12 00:00:00 |  | 100
[NAME] | 2011-05-12 00:00:00
[NAME] | 2011-05-12 00:00:00 |  | 100
[NAME] | 2011-05-12 00:00:00 |  | 100
[NAME] | 2011-05-12 00:00:00 |  | 100
[NAME] | 2011-05-12 00:00:00 |  | 100
[NAME] | 2011-05-12 00:00:00 |  | 100
[NAME] | 2011-05-12 00:00:00 |  | 100
[NAME] | 2011-05-12 00:00:00 |  | 100
[NAME] | 2011-05-12 00:00:00 |  | 100
[NAME] | 2011-05-12 00:00:00 |  | 100
[NAME] | 2011-05-13 00:00:00 |  | 100
[NAME] | 2011-05-13 00:00:00 |  | 100
[NAME] | 2011-05-13 00:00:00 |  | 100
[NAME] | 2011-05-13 00:00:00 |  | 100
[NAME] | 2011-05-13 00:00:00 |  | 100
[NAME] | 2011-05-13 00:00:00 |  | 100
[NAME] | 2011-05-13 00:00:00 |  | 100
[NAME] | 2011-05-13 00:00:00
[NAME] | 2011-05-13 00:00:00 |  | 100
[NAME] | 2011-05-13 00:00:00 |  | 100
[NAME] | 2011-05-13 00:00:00 |  | 100
[NAME] | 2011-05-13 00:00:00 |  | 100
[NAME] | 2011-05-16 00:00:00 |  | 75
[NAME] | 2011-05-16 00:00:00 |  | 100
[NAME] | 2011-05-16 00:00:00 |  | 100
[NAME] | 2011-05-16 00:00:00 |  | 100
[NAME] | 2011-05-16 00:00:00 |  | 100
[NAME] | 2011-05-16 00:00:00 |  | 100
[NAME] | 2011-05-16 00:00:00 |  | 100
[NAME] | 2011-05-17 00:00:00 |  | 100
[NAME] | 2011-05-17 00:00:00 |  | 100
[NAME] | 2011-05-17 00:00:00
[NAME] | 2011-05-17 00:00:00 |  | 100
[NAME] | 2011-05-17 00:00:00
[NAME] | 2011-05-17 00:00:00 |  | 100
[NAME] | 2011-05-17 00:00:00 |  | 100
[NAME] | 2011-05-17 00:00:00 |  | 100
[NAME] | 2011-05-17 00:00:00 |  | 100
[NAME] | 2011-05-17 00:00:00
[NAME] | 2011-05-17 00:00:00 |  | 100
[NAME] | 2011-05-17 00:00:00
[NAME] | 2011-05-17 00:00:00
[NAME] | 2011-05-17 00:00:00 |  | 100
[NAME] | 2011-05-17 00:00:00 |  | 100
[NAME] | 2011-05-17 00:00:00 |  | 100
[NAME] | 2011-05-17 00:00:00 |  | 100
[NAME] | 2011-05-17 00:00:00 |  | 100
[NAME] | 2011-05-17 00:00:00 |  | 100
[NAME] | 2011-05-18 00:00:00
[NAME] | 2011-05-18 00:00:00 |  | 100
[NAME] | 2011-05-18 00:00:00 |  | 100
[NAME] | 2011-05-18 00:00:00 |  | 100
[NAME] | 2011-05-18 00:00:00
[NAME] | 2011-05-18 00:00:00 |  | 100
[NAME] | 2011-05-18 00:00:00 |  | 100
[NAME] | 2011-05-18 00:00:00 |  | 40
[NAME] | 2011-05-18 00:00:00 |  | 100
[NAME] | 2011-05-18 00:00:00 |  | 100
[NAME] | 2011-05-18 00:00:00 |  | 100
[NAME] | 2011-05-18 00:00:00 |  | 100
[NAME] | 2011-05-18 00:00:00 |  | 100
[NAME] | 2011-05-19 00:00:00 |  | 100
[NAME] | 2011-05-19 00:00:00 |  | 100
[NAME] | 2011-05-19 00:00:00 |  | 100
[NAME] | 2011-05-19 00:00:00
[NAME] | 2011-05-19 00:00:00 |  | 45
[NAME] | 2011-05-19 00:00:00 |  | 100
[NAME] | 2011-05-19 00:00:00 |  | 100
[NAME] | 2011-05-19 00:00:00 |  | 100
[NAME] | 2011-05-19 00:00:00 |  | 100
[NAME] | 2011-05-19 00:00:00 |  | 100
[NAME] | 2011-05-20 00:00:00 |  | 100
[NAME] | 2011-05-20 00:00:00 |  | 100
[NAME] | 2011-05-20 00:00:00 |  | 75
[NAME] | 2011-05-20 00:00:00 |  | 100
[NAME] | 2011-05-20 00:00:00 |  | 100
[NAME] | 2011-05-20 00:00:00 |  | 100
[NAME] | 2011-05-20 00:00:00 |  | 100
[NAME] | 2011-05-20 00:00:00 |  | 75
[NAME] | 2011-05-20 00:00:00 |  | 100
[NAME] | 2011-05-20 00:00:00 |  | 100
[NAME] | 2011-05-20 00:00:00 |  | 100
[NAME] | 2011-05-23 00:00:00 |  | 100
[NAME] | 2011-05-23 00:00:00 |  | 100
[NAME] | 2011-05-23 00:00:00 |  | 100
[NAME] | 2011-05-24 00:00:00 |  | 100
[NAME] | 2011-05-24 00:00:00 |  | 100
[NAME] | 2011-05-24 00:00:00 |  | 100
[NAME] | 2011-05-25 00:00:00 |  | 100
[NAME] | 2011-05-25 00:00:00 |  | 75
[NAME] | 2011-05-25 00:00:00 |  | 75
[NAME] | 2011-05-25 00:00:00 |  | 100
[NAME] | 2011-05-25 00:00:00 |  | 100
[NAME] | 2011-05-25 00:00:00 |  | 100
[NAME] | 2011-05-25 00:00:00 |  | 100
[NAME] | 2011-05-25 00:00:00 |  | 100
[NAME] | 2011-05-25 00:00:00 |  | 100
[NAME] | 2011-05-25 00:00:00 |  | 100
[NAME] | 2011-05-25 00:00:00 |  | 100
[NAME] | 2011-05-25 00:00:00 |  | 100
[NAME] | 2011-05-25 00:00:00 |  | 75
[NAME] | 2011-05-25 00:00:00 |  | 75