Spreadsheet: 110959d1307500719-formula-for-grouping-the-average-of-daily-values-by-julian-week-test-document
Sheet: Sheet1

Name | Date | Week | Score
[NAME] | 2011-05-02 00:00:00 |  | 100
[NAME] | 2011-05-02 00:00:00 |  | 100
[NAME] | 2011-05-02 00:00:00 |  | 100
[NAME] | 2011-05-02 00:00:00 |  | 15
[NAME] | 2011-05-02 00:00:00 |  | 75
[NAME] | 2011-05-02 00:00:00 |  | 100
[NAME] | 2011-05-02 00:00:00 |  | 100
[NAME] | 2011-05-02 00:00:00 |  | 100
[NAME] | 2011-05-02 00:00:00 |  | 100
[NAME] | 2011-05-02 00:00:00 |  | 75
[NAME] | 2011-05-02 00:00:00 |  | 100
[NAME] | 2011-05-02 00:00:00 |  | 100
[NAME] | 2011-05-02 00:00:00 |  | 100
[NAME] | 2011-05-02 00:00:00 |  | 100
[NAME] | 2011-05-02 00:00:00 |  | 100
[NAME] | 2011-05-02 00:00:00 |  | 100
[NAME] | 2011-05-02 00:00:00 |  | 75
[NAME] | 2011-05-02 00:00:00 |  | 40
[NAME] | 2011-05-02 00:00:00 |  | 100
[NAME] | 2011-05-02 00:00:00 |  | 75
[NAME] | 2011-05-02 00:00:00 |  | 100
[NAME] | 2011-05-03 00:00:00 |  | 100
[NAME] | 2011-05-03 00:00:00 |  | 100
[NAME] | 2011-05-03 00:00:00 |  | 100
[NAME] | 2011-05-03 00:00:00 |  | 100
[NAME] | 2011-05-03 00:00:00
[NAME] | 2011-05-03 00:00:00 |  | 85
[NAME] | 2011-05-03 00:00:00 |  | 100
[NAME] | 2011-05-03 00:00:00 |  | 100
[NAME] | 2011-05-03 00:00:00
[NAME] | 2011-05-03 00:00:00 |  | 100
[NAME] | 2011-05-03 00:00:00 |  | 100
[NAME] | 2011-05-03 00:00:00 |  | 75
[NAME] | 2011-05-03 00:00:00 |  | 100
[NAME] | 2011-05-03 00:00:00 |  | 100
[NAME] | 2011-05-03 00:00:00 |  | 100
[NAME] | 2011-05-03 00:00:00 |  | 100
[NAME] | 2011-05-03 00:00:00 |  | 75
[NAME] | 2011-05-03 00:00:00 |  | 100
[NAME] | 2011-05-03 00:00:00 |  | 100
[NAME] | 2011-05-03 00:00:00 |  | 100
[NAME] | 2011-05-04 00:00:00 |  | 100
[NAME] | 2011-05-04 00:00:00 |  | 100
[NAME] | 2011-05-04 00:00:00 |  | 100
[NAME] | 2011-05-04 00:00:00 |  | 100
[NAME] | 2011-05-04 00:00:00 |  | 100
[NAME] | 2011-05-04 00:00:00 |  | 100
[NAME] | 2011-05-04 00:00:00 |  | 100
[NAME] | 2011-05-04 00:00:00
[NAME] | 2011-05-04 00:00:00
[NAME] | 2011-05-04 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 |  | 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