Spreadsheet: 70158d1270845134-calculate-a-running-average-off-a-conditional-sum-discgolftracker
Sheet: DiscRounds

Player | Course | Date | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Front | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | Back | Round
[NAME] | MeyerBroadway | 2010-01-01 00:00:00 | 4 | 3 | 4 | 4 | 6 | 3 | 3 | 6 | 4 | 37 | 3 | 4 | 4 | 3 | 5 | 5 | 4 | 4 | 6 | 38 | 75
[NAME] | MeyerBroadway | 2010-01-01 00:00:00 | 4 | 3 | 4 | 3 | 4 | 3 | 3 | 3 | 4 | 31 | 3 | 4 | 5 | 3 | 4 | 5 | 5 | 7 | 6 | 42 | 73
[NAME] | OshtemoB | 2010-01-05 00:00:00 | 3 | 5 | 4 | 6 | 5 | 4 | 4 | 3 | 4 | 38 | 4 | 8 | 4 | 5 | 5 | 5 | 3 | 3 | 4 | 41 | 79
[NAME] | OshtemoB | 2010-01-05 00:00:00 | 4 | 4 | 4 | 4 | 6 | 3 | 4 | 3 | 4 | 36 | 4 | 4 | 6 | 4 | 4 | 5 | 4 | 6 | 3 | 40 | 76
[NAME] | OshtemoB | 2010-01-09 00:00:00 | 4 | 6 | 3 | 5 | 6 | 4 | 6 | 4 | 6 | 44 | 5 | 4 | 4 | 5 | 5 | 4 | 4 | 5 | 4 | 40 | 84
[NAME] | OshtemoB | 2010-01-09 00:00:00 | 4 | 3 | 4 | 5 | 4 | 4 | 6 | 3 | 5 | 38 | 5 | 5 | 5 | 4 | 4 | 5 | 4 | 4 | 3 | 39 | 77
[NAME] | Oshtemo | 2010-02-20 00:00:00 | 3 | 3 | 3 | 3 | 4 | 4 | 4 | 2 | 3 | 29 | 4 | 2 | 3 | 4 | 3 | 4 | 2 | 3 | 3 | 28 | 57
[NAME] | Oshtemo | 2010-02-20 00:00:00 | 6 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 31 | 3 | 3 | 3 | 4 | 2 | 4 | 3 | 4 | 4 | 30 | 61
Darin | Oshtemo | 2010-02-20 00:00:00 | 3 | 3 | 4 | 4 | 3 | 4 | 4 | 4 | 3 | 32 | 3 | 3 | 3 | 4 | 3 | 3 | 4 | 3 | 3 | 29 | 61
[NAME] | Oshtemo | 2010-02-20 00:00:00 | 4 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 29 | 3 | 3 | 3 | 4 | 3 | 2 | 4 | 4 | 3 | 29 | 58
[NAME] | OshtemoB | 2010-02-21 00:00:00 | 4 | 3 | 3 | 4 | 4 | 3 | 5 | 4 | 4 | 34 | 4 | 5 | 5 | 4 | 4 | 4 | 3 | 3 | 2 | 34 | 68
[NAME] | OshtemoB | 2010-02-21 00:00:00 | 4 | 4 | 4 | 4 | 6 | 3 | 5 | 3 | 4 | 37 | 4 | 7 | 5 | 4 | 4 | 6 | 4 | 5 | 4 | 43 | 80
[NAME] | OshtemoB | 2010-02-21 00:00:00 | 5 | 4 | 4 | 8 | 6 | 3 | 6 | 3 | 7 | 46 | 6 | 6 | 5 | 4 | 3 | 4 | 3 | 4 | 4 | 39 | 85
[NAME] | OshtemoB | 2010-02-26 00:00:00 | 4 | 4 | 3 | 4 | 5 | 4 | 7 | 5 | 5 | 41 | 3 | 6 | 5 | 5 | 4 | 4 | 4 | 3 | 6 | 40 | 81
[NAME] | OshtemoB | 2010-02-26 00:00:00 | 5 | 3 | 4 | 6 | 6 | 3 | 6 | 4 | 7 | 44 | 4 | 5 | 7 | 6 | 6 | 4 | 4 | 4 | 5 | 45 | 89
[NAME] | MeyerBroadway | 2010-02-27 00:00:00 | 3 | 3 | 4 | 3 | 5 | 3 | 3 | 4 | 3 | 31 | 3 | 4 | 4 | 4 | 7 | 7 | 4 | 4 | 4 | 41 | 72
[NAME] | MeyerBroadway | 2010-02-27 00:00:00 | 4 | 3 | 4 | 3 | 5 | 3 | 3 | 6 | 4 | 35 | 2 | 4 | 4 | 3 | 5 | 4 | 5 | 4 | 6 | 37 | 72
[NAME] | MeyerBroadway | 2010-02-27 00:00:00 | 5 | 4 | 5 | 3 | 4 | 4 | 4 | 4 | 5 | 38 | 3 | 5 | 5 | 4 | 5 | 6 | 5 | 4 | 5 | 42 | 80
[NAME] | MeyerBroadwayN | 2010-02-27 00:00:00 | 5 | 4 | 4 | 4 | 4 | 3 | 4 | 2 | 3 | 33 | 4 | 3 | 4 | 5 | 3 | 4 | 3 | 3 | 4 | 33 | 66
[NAME] | MeyerBroadwayN | 2010-02-27 00:00:00 | 4 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 6 | 32 | 3 | 4 | 4 | 4 | 3 | 4 | 4 | 3 | 4 | 33 | 65
[NAME] | MeyerBroadwayN | 2010-02-27 00:00:00 | 5 | 3 | 5 | 4 | 4 | 3 | 5 | 3 | 4 | 36 | 3 | 5 | 5 | 5 | 4 | 4 | 3 | 4 | 5 | 38 | 74
[NAME] | Knollwood | 2010-03-03 00:00:00 | 3 | 2 | 3 | 5 | 3 | 3 | 2 | 3 | 2 | 26 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 27 | 53
[NAME] | Knollwood | 2010-03-03 00:00:00 | 3 | 4 | 2 | 4 | 3 | 4 | 3 | 2 | 4 | 29 | 3 | 3 | 3 | 4 | 3 | 2 | 2 | 3 | 6 | 29 | 58
[NAME] | Oshtemo | 2010-03-05 00:00:00 | 5 | 3 | 4 | 5 | 5 | 3 | 4 | 3 | 3 | 35 | 4 | 3 | 5 | 4 | 5 | 3 | 3 | 3 | 3 | 33 | 68
[NAME] | Oshtemo | 2010-03-05 00:00:00 | 3 | 3 | 2 | 3 | 3 | 2 | 4 | 3 | 4 | 27 | 3 | 6 | 4 | 5 | 4 | 3 | 3 | 3 | 3 | 34 | 61
[NAME] | OshtemoB | 2010-03-13 00:00:00 | 3 | 5 | 4 | 4 | 5 | 3 | 5 | 5 | 5 | 39 | 5 | 4 | 3 | 4 | 4 | 5 | 4 | 4 | 3 | 36 | 75
[NAME] | OshtemoB | 2010-03-13 00:00:00 | 3 | 6 | 3 | 4 | 4 | 4 | 4 | 4 | 5 | 37 | 4 | 4 | 3 | 4 | 6 | 3 | 6 | 4 | 3 | 37 | 74
[NAME] | [NAME] | 2010-03-14 00:00:00 | 4 | 3 | 5 | 3 | 3 | 3 | 4 | 3 | 4 | 32 | 3 | 3 | 5 | 3 | 5 | 5 | 4 | 6 | 5 | 39 | 71
[NAME] | MeyerBroadway | 2010-03-14 00:00:00 | 5 | 3 | 4 | 4 | 3 | 5 | 3 | 4 | 3 | 34 | 4 | 5 | 4 | 3 | 4 | 3 | 3 | 5 | 4 | 35 | 69
[NAME] | OshtemoB | 2010-03-14 00:00:00 | 5 | 4 | 4 | 4 | 4 | 4 | 5 | 2 | 5 | 37 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 6 | 3 | 39 | 76
[NAME] | OshtemoB | 2010-03-14 00:00:00 | 4 | 5 | 4 | 5 | 4 | 3 | 5 | 4 | 4 | 38 | 6 | 4 | 4 | 4 | 5 | 4 | 4 | 3 | 4 | 38 | 76
[NAME] | Knollwood | 2010-03-19 00:00:00 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 27 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 26 | 53
[NAME] | Knollwood | 2010-03-19 00:00:00 | 3 | 3 | 3 | 4 | 3 | 4 | 3 | 3 | 2 | 28 | 4 | 3 | 3 | 3 | 3 | 2 | 2 | 3 | 3 | 26 | 54
[NAME] | Knollwood | 2010-03-19 00:00:00 | 4 | 3 | 4 | 2 | 3 | 3 | 2 | 2 | 2 | 25 | 4 | 3 | 4 | 3 | 3 | 2 | 3 | 2 | 3 | 27 | 52
[NAME] | Knollwood | 2010-03-19 00:00:00 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 2 | 4 | 28 | 3 | 2 | 2 | 3 | 2 | 2 | 3 | 3 | 3 | 23 | 51
[NAME] | [NAME] | 2010-03-21 00:00:00 | 5 | 6 | 4 | 4 | 2 | 4 | 3 | 3 | 4 | 35 | 5 | 4 | 4 | 4 | 4 | 3 | 2 | 6 | 4 | 36 | 71
[NAME] | [NAME] | 2010-03-21 00:00:00 | 5 | 3 | 3 | 4 | 3 | 3 | 4 | 3 | 3 | 31 | 4 | 5 | 4 | 3 | 4 | 3 | 3 | 8 | 3 | 37 | 68
[NAME] | OshtemoB | 2010-03-25 00:00:00 | 4 | 3 | 4 | 3 | 5 | 3 | 6 | 4 | 5 | 37 | 4 | 3 | 3 | 5 | 5 | 5 | 6 | 3 | 4 | 38 | 75
[NAME] | OshtemoB | 2010-03-25 00:00:00 | 3 | 4 | 4 | 5 | 5 | 3 | 6 | 3 | 4 | 37 | 5 | 4 | 3 | 4 | 7 | 6 | 4 | 3 | 3 | 39 | 76
[NAME] | Oshtemo | 2010-03-27 00:00:00 | 3 | 3 | 4 | 4 | 3 | 3 | 3 | 4 | 4 | 31 | 4 | 5 | 4 | 3 | 3 | 3 | 2 | 4 | 3 | 31 | 62
[NAME] | Oshtemo | 2010-03-27 00:00:00 | 3 | 5 | 6 | 5 | 5 | 3 | 5 | 6 | 5 | 43 | 5 | 4 | 6 | 5 | 5 | 4 | 5 | 4 | 4 | 42 | 85
[NAME] | Oshtemo | 2010-03-27 00:00:00 | 5 | 5 | 4 | 6 | 8 | 3 | 4 | 4 | 5 | 44 | 5 | 5 | 6 | 6 | 4 | 4 | 4 | 4 | 4 | 42 | 86
[NAME] | Oshtemo | 2010-03-27 00:00:00 | 4 | 4 | 2 | 5 | 4 | 3 | 4 | 3 | 4 | 33 | 3 | 3 | 3 | 2 | 4 | 3 | 4 | 2 | 3 | 27 | 60
[NAME] | Oshtemo | 2010-03-27 00:00:00 | 3 | 4 | 4 | 5 | 4 | 4 | 5 | 3 | 6 | 38 | 6 | 5 | 6 | 3 | 5 | 3 | 3 | 3 | 2 | 36 | 74
[NAME] | Oshtemo | 2010-03-27 00:00:00 | 6 | 5 | 3 | 7 | 5 | 3 | 5 | 5 | 5 | 44 | 8 | 7 | 4 | 4 | 7 | 5 | 4 | 4 | 3 | 46 | 90
[NAME] | Oshtemo | 2010-03-27 00:00:00 | 5 | 7 | 5 | 8 | 6 | 4 | 5 | 4 | 6 | 50 | 4 | 7 | 4 | 4 | 7 | 5 | 3 | 5 | 5 | 44 | 94
[NAME] | Oshtemo | 2010-03-28 00:00:00 | 3 | 4 | 3 | 3 | 5 | 3 | 4 | 7 | 5 | 37 | 4 | 4 | 5 | 3 | 4 | 3 | 3 | 3 | 3 | 32 | 69
[NAME] | Oshtemo | 2010-03-28 00:00:00 | 3 | 5 | 4 | 6 | 4 | 4 | 5 | 5 | 7 | 43 | 4 | 6 | 3 | 4 | 6 | 3 | 3 | 4 | 3 | 36 | 79
[NAME] | Oshtemo | 2010-03-29 00:00:00 | 3 | 4 | 3 | 6 | 4 | 2 | 5 | 4 | 4 | 35 | 4 | 5 | 3 | 3 | 4 | 3 | 3 | 3 | 4 | 32 | 67
[NAME] | Oshtemo | 2010-03-29 00:00:00 | 3 | 4 | 3 | 4 | 4 | 3 | 5 | 3 | 4 | 33 | 4 | 3 | 5 | 3 | 3 | 3 | 4 | 5 | 3 | 33 | 66
Spence | Oshtemo | 2010-03-29 00:00:00 | 6 | 5 | 6 | 8 | 7 | 4 | 6 | 5 | 7 | 54 | 6 | 6 | 6 | 3 | 6 | 6 | 6 | 4 | 4 | 47 | 101
[NAME] | OshtemoB | 2010-03-31 00:00:00 | 3 | 4 | 4 | 4 | 5 | 4 | 5 | 5 | 5 | 39 | 5 | 4 | 3 | 4 | 4 | 4 | 3 | 5 | 3 | 35 | 74
[NAME] | Oshtemo | 2010-04-02 00:00:00 | 4 | 3 | 3 | 4 | 3 | 2 | 4 | 3 | 4 | 30 | 4 | 3 | 4 | 3 | 6 | 3 | 3 | 3 | 3 | 32 | 62
[NAME] | Oshtemo | 2010-04-02 00:00:00 | 4 | 4 | 4 | 5 | 8 | 3 | 5 | 4 | 5 | 42 | 6 | 4 | 4 | 4 | 6 | 3 | 5 | 3 | 4 | 39 | 81
[NAME] | Oshtemo | 2010-04-02 00:00:00 | 2 | 3 | 3 | 3 | 5 | 3 | 3 | 3 | 6 | 31 | 4 | 3 | 3 | 4 | 3 | 4 | 3 | 3 | 4 | 31 | 62
[NAME] | Oshtemo | 2010-04-02 00:00:00 | 3 | 3 | 4 | 5 | 5 | 3 | 6 | 6 | 5 | 40 | 5 | 4 | 5 | 3 | 7 | 3 | 3 | 3 | 3 | 36 | 76
[NAME] | ColdBrook | 2010-04-03 00:00:00 | 3 | 4 | 4 | 3 | 4 | 4 | 5 | 3 | 5 | 35 | 3 | 2 | 3 | 2 | 3 | 3 | 4 | 3 | 3 | 26 | 61
[NAME] | ColdBrook | 2010-04-03 00:00:00 | 4 | 3 | 3 | 4 | 4 | 3 | 3 | 3 | 4 | 31 | 3 | 2 | 3 | 3 | 4 | 3 | 4 | 3 | 4 | 29 | 60
[NAME] | ColdBrook | 2010-04-03 00:00:00 | 4 | 3 | 7 | 3 | 7 | 3 | 4 | 7 | 4 | 42 | 4 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 4 | 38 | 80
[NAME] | Oshtemo | 2010-04-04 00:00:00 | 4 | 4 | 2 | 4 | 4 | 2 | 3 | 3 | 3 | 29 | 3 | 3 | 5 | 3 | 5 | 3 | 4 | 3 | 2 | 31 | 60
[NAME] | Oshtemo | 2010-04-04 00:00:00 | 5 | 3 | 4 | 6 | 5 | 3 | 4 | 3 | 4 | 37 | 3 | 4 | 6 | 3 | 4 | 3 | 3 | 4 | 4 | 34 | 71
[NAME] | OshtemoB | 2010-04-09 00:00:00 | 4 | 4 | 4 | 5 | 7 | 3 | 5 | 4 | 5 | 41 | 5 | 7 | 5 | 4 | 7 | 4 | 4 | 6 | 5 | 47 | 88