Spreadsheet: 744666d1629373903-how-can-i-get-averages-for-multiple-ranges-sugar-forum-aligw
Sheet: Export

Date | mmol /L | Time | Rolling Average | Before breakfast average | After breakfast average | Before lunch average | After lunch average | Before tea average | After tea average | Bed average
2021-08-01 00:00:00 | 7.9 | Before breakfast
2021-08-01 00:00:00 | 9.2 | After breakfast
2021-08-01 00:00:00 | 8.4 | Before lunch
2021-08-01 00:00:00 | 10 | After lunch
2021-08-01 00:00:00 | 8.2 | Before tea
2021-08-01 00:00:00 | 9 | After tea
2021-08-01 00:00:00 | 8.5 | Bed
2021-08-02 00:00:00 | 8.4 | Before breakfast
2021-08-02 00:00:00 | 10 | After breakfast
2021-08-02 00:00:00 | 8.9 | Before lunch
2021-08-02 00:00:00 | 10.8 | After lunch
2021-08-02 00:00:00 | 9 | Before tea
2021-08-02 00:00:00 | 9.9 | After tea
2021-08-02 00:00:00 | 9 | Bed
2021-08-03 00:00:00 | 10.8 | Before breakfast
2021-08-03 00:00:00 | 10.4 | After breakfast
2021-08-03 00:00:00 | 8.7 | Before lunch
2021-08-03 00:00:00 | 8.4 | After lunch
2021-08-03 00:00:00 | 6.7 | Before tea
2021-08-03 00:00:00 | 12.3 | After tea
2021-08-03 00:00:00 | 11 | Bed
2021-08-04 00:00:00 | 9.9 | Before breakfast
2021-08-04 00:00:00 | 11.8 | After breakfast
2021-08-04 00:00:00 | 10.2 | Before lunch
2021-08-04 00:00:00 | 10.4 | After lunch
2021-08-04 00:00:00 | 9 | Before tea
2021-08-04 00:00:00 | 9.8 | After tea
2021-08-04 00:00:00 | 9 | Bed
2021-08-05 00:00:00 | 11.8 | Before breakfast
2021-08-05 00:00:00 | 10.6 | After breakfast
2021-08-05 00:00:00 | 8.5 | Before lunch
2021-08-05 00:00:00 | 9.3 | After lunch
2021-08-05 00:00:00 | 8.6 | Before tea
2021-08-05 00:00:00 | 9.2 | After tea
2021-08-05 00:00:00 | 8.9 | Bed
2021-08-06 00:00:00 | 10.4 | Before breakfast
2021-08-06 00:00:00 | 10.9 | After breakfast
2021-08-06 00:00:00 | 9.7 | Before lunch
2021-08-06 00:00:00 | 10.4 | After lunch
2021-08-06 00:00:00 | 8.4 | Before tea
2021-08-06 00:00:00 | 9.1 | After tea
2021-08-06 00:00:00 | 8.4 | Bed
2021-08-07 00:00:00 | 9.2 | Before breakfast
2021-08-07 00:00:00 | 10.4 | After breakfast
2021-08-07 00:00:00 | 8.3 | Before lunch
2021-08-07 00:00:00 | 8.9 | After lunch
2021-08-07 00:00:00 | 8.8 | Before tea
2021-08-07 00:00:00 | 9 | After tea
2021-08-07 00:00:00 | 8.2 | Bed
2021-08-08 00:00:00 | 10.4 | Before breakfast
2021-08-08 00:00:00 | 10.9 | After breakfast
2021-08-08 00:00:00 | 8.7 | Before lunch
2021-08-08 00:00:00 | 9 | After lunch
2021-08-08 00:00:00 | 7.9 | Before tea
2021-08-08 00:00:00 | 10.2 | After tea
2021-08-08 00:00:00 | 9 | Bed
2021-08-09 00:00:00 | 9.9 | Before breakfast
2021-08-09 00:00:00 | 10.7 | After breakfast
2021-08-09 00:00:00 | 8.5 | Before lunch
2021-08-09 00:00:00 | 9.5 | After lunch
2021-08-09 00:00:00 | 8.4 | Before tea
2021-08-09 00:00:00 | 8.9 | After tea
2021-08-09 00:00:00 | 7.4 | Bed
2021-08-10 00:00:00 | 10.6 | Before breakfast
2021-08-10 00:00:00 | 10 | After breakfast
2021-08-10 00:00:00 | 8.9 | Before lunch
2021-08-10 00:00:00 | 9 | After lunch
2021-08-10 00:00:00 | 9.2 | Before tea
2021-08-10 00:00:00 | 9.4 | After tea
2021-08-10 00:00:00 | 8.2 | Bed
2021-08-11 00:00:00 | 9.8 | Before breakfast
2021-08-11 00:00:00 | 10.4 | After breakfast
2021-08-11 00:00:00 | 9.8 | Before lunch
2021-08-11 00:00:00 | 9.9 | After lunch
2021-08-11 00:00:00 | 7.9 | Before tea
2021-08-11 00:00:00 | 8.1 | After tea
2021-08-11 00:00:00 | 8.4 | Bed
2021-08-12 00:00:00 | 8.9 | Before breakfast
2021-08-12 00:00:00 | 9.4 | After breakfast
2021-08-12 00:00:00 | 8.8 | Before lunch
2021-08-12 00:00:00 | 9 | After lunch
2021-08-12 00:00:00 | 8.1 | Before tea
2021-08-12 00:00:00 | 9.8 | After tea
2021-08-12 00:00:00 | 9.6 | Bed
2021-08-13 00:00:00 | 10.4 | Before breakfast
2021-08-13 00:00:00 | 10.8 | After breakfast
2021-08-13 00:00:00 | 7.9 | Before lunch
2021-08-13 00:00:00 | 8.4 | After lunch
2021-08-13 00:00:00 | 7.6 | Before tea
2021-08-13 00:00:00 | 8.9 | After tea
2021-08-13 00:00:00 | 8.4 | Bed
2021-08-14 00:00:00 | 9.8 | Before breakfast
2021-08-14 00:00:00 | 10.4 | After breakfast
2021-08-14 00:00:00 | 8.4 | Before lunch
2021-08-14 00:00:00 | 8.9 | After lunch
2021-08-14 00:00:00 | 7.8 | Before tea
2021-08-14 00:00:00 | 9 | After tea
2021-08-14 00:00:00 | 8.4 | Bed
2021-08-15 00:00:00 | 11 | Before breakfast
2021-08-15 00:00:00 | 11.8 | After breakfast
2021-08-15 00:00:00 | 9 | Before lunch
2021-08-15 00:00:00 | 9.1 | After lunch
2021-08-15 00:00:00 | 8 | Before tea
2021-08-15 00:00:00 | 9 | After tea
2021-08-15 00:00:00 | 8.3 | Bed
2021-08-16 00:00:00 | 10.4 | Before breakfast
2021-08-16 00:00:00 | 10.9 | After breakfast
2021-08-16 00:00:00 | 8 | Before lunch
2021-08-16 00:00:00 | 9.1 | After lunch
2021-08-16 00:00:00 | 9 | Before tea
2021-08-16 00:00:00 | 9 | After tea
2021-08-16 00:00:00 | 8.2 | Bed
2021-08-17 00:00:00 | 9.8 | Before breakfast
2021-08-17 00:00:00 | 10.4 | After breakfast
2021-08-17 00:00:00 | 8.9 | Before lunch
2021-08-17 00:00:00 | 9.4 | After lunch
2021-08-17 00:00:00 | 8.9 | Before tea
2021-08-17 00:00:00 | 9.6 | After tea
2021-08-17 00:00:00 | 9.1 | Bed
 | 10.4 | Before breakfast
 | 11 | After breakfast
 | 9 | Before lunch
 | 9.2 | After lunch
 | 7.6 | Before tea
 | 8.9 | After tea
 | 7.8 | Bed