Spreadsheet: 689847d1596704061-how-to-count-sum-average-first-x-active-cells-in-y-columns-count-last-4-events-sample
Sheet: Score Diff Field Avg

TOURNAMENT |  |  |  |  |  |  |  |  |  |  |  |  |  | 3M Open |  |  | Memorial |  |  | Workday Charity |  |  | Rocket Mortgage |  |  | Travelers Championship |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | Honda Classic |  |  | WGC Mexico |  |  | Genesis Inv |  |  | Pebble Beach |  |  | Phoenix |  |  | Farmers Insurance |  |  | Amex |  |  | Sony Open |  |  | Sentry ToC |  |  | [NAME] |  |  | [NAME] |  |  | WGC HSBC Champions |  |  | Zozo Championship |  |  | CJ Cup |  |  | Houston Open |  |  | Shriners |  |  | Safeway |  |  | Sanderson Farms |  |  | [NAME]
 | 4wks |  |  |  | 8wks |  |  |  | SEASON |  |  |  |  | July 23 - 26 |  |  | July 16 - 19 |  |  | July 9-12 |  |  | July 2-5 |  |  | June 25-28 |  |  | June 18-21 |  |  | [NAME] |  |  | [NAME] |  |  | Feb 27 - Mar 1 |  |  | Feb 20 - 23 |  |  | Feb 13 - 16 |  |  | Feb 6 - 9 |  |  | Jan 30 - Feb 2 |  |  | Jan 23 - 26 |  |  | Jan 16 - 19 |  |  | Jan 9 - 12 |  |  | Jan 2 - 5 |  |  | Nov 21 - 24 |  |  | Nov 14 - 17 |  |  | Oct 31 - Nov 3 |  |  | Oct 24 - 27 |  |  | Oct 17 - 20 |  |  | Oct 10 - 13 |  |  | Oct 3 - 6 |  |  | Sep 26 - 29 |  |  | Sep 19 - 22 |  |  | Sep 12 - 15
PLAYER | 4wk | Events | Average | 4wk Rank | 8wks | Events | Average | Rank | 4wk | Events | Average | Rank |  | Stroke Differential | Field Average | Rank | Stroke Differential | Field Average | Rank | Stroke Differential | Field Average | Rank | Stroke Differential | Field Average | Rank | Stroke Differential | Field Average | Rank | Stroke Differential | Field Average | Rank | Stroke Differential | Field Average | Rank | Stroke Differential | Field Average | Rank | Stroke Differential | Field Average | Rank | Stroke Differential | Field Average | Rank | Stroke Differential | Field Average | Rank | Stroke Differential | Field Average | Rank | Stroke Differential | Field Average | Rank | Stroke Differential | Field Average | Rank | Stroke Differential | Field Average | Rank | Stroke Differential | Field Average | Rank | Stroke Differential | Field Average | Rank | Stroke Differential | Field Average | Rank | Stroke Differential | Field Average | Rank | Stroke Differential | Field Average | Rank | Stroke Differential | Field Average | Rank | Stroke Differential | Field Average | Rank | Stroke Differential | Field Average | Rank | Stroke Differential | Field Average | Rank | Stroke Differential | Field Average | Rank | Stroke Differential | Field Average | Rank | Stroke Differential | Field Average | Rank
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.55 | 69.55 | T23 | 2.93 | 74.18 | T6 | 1.13 | 71.63 | T31 | 1.53 | 70.03 | T12 | 0.57 | 68.57 | T41 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.48 | 72.23 |  |  |  |  |  |  |  | -0.4 | 69.85 | 68 | 1.9 | 70.15 | 9 |  |  |  | 2.76 | 69.51 | 69.51 | 0.53 | 70.03 | 41 |  |  |  |  |  |  |  |  |  | 0.62 | 71.87 | 45
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.8 | 69.55 | T18 | -0.57 | 74.18 | 61 | 2.13 | 71.63 | T14 | 1.78 | 70.03 | T8 |  |  |  | 0.94 | 68.94 | T33 |  |  |  |  |  |  | 1.32 | 71.82 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.78 | 69.78 | 4 | 0.15 | 70.15 | 53 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.62 | 71.87 | 4
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.55 | 69.55 | T46 | 1.68 | 74.18 | T18 | -1.12 | 71.63 | 64 | 0.03 | 70.03 | T57 | 1.82 | 68.57 | T11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.49 | 71.24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01 | 69.51 | 37 | 0.84 | 70.84 | 26 |  |  |  | 0.27 | 68.77 | 55 | 0.14 | 71.14 | 49 | -0.71 | 70.79 | 61
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.05 | 69.55 | T12 | 1.43 | 74.18 | T22 |  |  |  | 3.03 | 70.03 | 2 |  |  |  |  |  |  | -0.06 | 69.44 | 54 | -0.1 | 74.4 | T52 | -0.43 | 71.82 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.42 | 71.92 | 21 | -0.02 | 69.73 | 61 |  |  |  | 0.98 | 72.23 | 11 |  |  |  |  |  |  |  |  |  | 1.51 | 69.51 | 13 | -3.91 | 70.84 | 74 |  |  |  | 1.52 | 68.77 | 18
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.55 | 69.55 | T3 | 2.68 | 74.18 | 8 |  |  |  | 0.28 | 70.03 | T53 |  |  |  | 0.94 | 68.94 | T33 | 1.44 | 69.44 | T23 |  |  |  |  |  |  |  |  |  | -0.26 | 71.24 |  |  |  |  | 3.47 | 70.22 | 1 | 2.42 | 71.92 | 6 | 1.98 | 69.73 | 16 |  |  |  |  |  |  |  |  |  |  |  |  | -1.07 | 71.43 | 52 | -1.24 | 69.51 | 59 |  |  |  |  |  |  | 2.27 | 68.77 | 9
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.68 | 74.18 | T18 | 4.38 | 71.63 | T1 |  |  |  |  |  |  | 2.19 | 68.94 | T8 | 2.19 | 69.44 | T10 |  |  |  |  |  |  | 2.75 | 70.5 |  |  |  |  |  |  |  | 2.72 | 70.22 | 3 |  |  |  |  |  |  |  |  |  | 2.73 | 72.23 | 1 |  |  |  |  |  |  |  |  |  | 1.26 | 69.51 | 17 | 3.84 | 70.84 | 1 |  |  |  |  |  |  | 2.39 | 71.14 | 4
Jon Rahm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.43 | 74.18 | 1 | 1.38 | 71.63 | T27 |  |  |  | 0.82 | 68.57 | T37 | 0.94 | 68.94 | T33 |  |  |  |  |  |  |  |  |  | 3.25 | 70.5 |  | 1.49 | 71.24 |  |  |  |  | 1.97 | 70.22 | 9 | 3.3 | 71.8 | 2 |  |  |  |  |  |  | 1.23 | 72.23 | 10
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.18 | 74.18 | T4 | 2.38 | 71.63 | T7 |  |  |  | 0.32 | 68.57 | T46 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.45 | 72.45 |  |  |  |  | 1.67 | 71.92 | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.01 | 69.51 | 22 | 0.59 | 70.84 | 31
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.43 | 74.18 | 3 | 1.38 | 71.63 | T27 |  |  |  |  |  |  | 1.94 | 68.94 | T14 | 0.94 | 69.44 | T32 | 2.15 | 74.4 | T9 |  |  |  | 0 | 70.5 |  | 0.74 | 71.24 |  | 0.23 | 72.23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.93 | 71.43 | 7 | -3.49 | 69.51 | 75
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.78 | 70.03 | 1 | 2.32 | 68.57 | T6 | 2.19 | 68.94 | T8 | 2.94 | 69.44 | T3 | 2.65 | 74.4 | 4 |  |  |  | 3.75 | 70.5 |  | 2.24 | 71.24 |  |  |  |  | -0.28 | 70.22 | 52 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.77 | 68.77 | 4 | 1.64 | 71.14 | 13
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.68 | 74.18 | 2 |  |  |  |  |  |  |  |  |  | 2.19 | 68.94 | T8 |  |  |  |  |  |  | 1.82 | 71.82 |  |  |  |  | -2.26 | 71.24 |  |  |  |  |  |  |  | 1.42 | 71.92 | 21 |  |  |  | 2.4 | 70.15 | 4 | -0.02 | 72.23 | 17 |  |  |  |  |  |  |  |  |  | 1.76 | 69.51 | 10 | 1.59 | 70.84 | 12 |  |  |  | 1.02 | 68.77 | 37
Chase Seiffert |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.13 | 71.63 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.73 | 72.23 |  |  |  |  | -0.95 | 71.8 | 72 | 1.6 | 69.85 | 21 | 0.65 | 70.15 | 38 |  |  |  | 1.51 | 69.51 | 69.51 | 0.53 | 70.03 | 41 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.96 | 70.79 | 65
[NAME] Poulter |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.63 | 71.63 | T5 |  |  |  | -0.93 | 68.57 | 64 | 1.94 | 68.94 | T14 | 1.19 | 69.44 | T29 | 0.9 | 74.4 | T32 | 1.32 | 71.82 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.51 | 69.51 | 13 | 1.34 | 70.84 | 16
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.55 | 69.55 | T3 |  |  |  |  |  |  |  |  |  |  |  |  | 0.69 | 68.94 | T41 |  |  |  | 1.15 | 74.4 | T24 |  |  |  |  |  |  | 2.24 | 71.24 |  | 1.58 | 71.83 |  | 2.47 | 70.22 | 6 | 2.17 | 71.92 | 9 | 0.6 | 69.85 | 48 |  |  |  | -0.77 | 72.23 | 25 |  |  |  |  |  |  |  |  |  | -0.49 | 69.51 | 46 | -1.91 | 70.84 | 65 |  |  |  |  |  |  | -0.86 | 71.14 | 62
initial data
[NAME] | 7.140000000000001 | 4 | 1.785 | 12 | 7.710000000000001 | 5 | 1.542 | 9 | 14.6 | 11 | 1.327272727272727 | 7
[NAME] | 5.14 | 4 | 1.285 | 13 | 6.08 | 5 | 1.216 | 12 | 12.95 | 9 | 1.438888888888889 | 5
[NAME] | 1.14 | 4 | 0.285 | 14 | 2.96 | 5 | 0.592 | 14 | 4 | 11 | 0.3636363636363636 | 14
[NAME] | 6.51 | 3 | 2.17 | 10 | 6.350000000000001 | 5 | 1.27 | 11 | 7.42 | 12 | 0.6183333333333333 | 13
[NAME] | 5.510000000000001 | 3 | 1.836666666666667 | 11 | 7.890000000000001 | 5 | 1.578 | 8 | 15.46 | 12 | 1.288333333333333 | 8
[NAME] | 6.06 | 2 | 3.03 | 4 | 10.44 | 4 | 2.61 | 4 | 26.13 | 10 | 2.613 | 1
Jon Rahm | 5.81 | 2 | 2.905 | 5 | 7.57 | 4 | 1.8925 | 7 | 18.81 | 9 | 2.09 | 3
[NAME] | 5.56 | 2 | 2.78 | 6 | 5.880000000000001 | 3 | 1.96 | 6 | 12.6 | 7 | 1.8 | 4
[NAME] | 4.81 | 2 | 2.405 | 9 | 9.84 | 5 | 1.968 | 5 | 10.25 | 10 | 1.025 | 10
[NAME] | 3.78 | 1 | 3.78 | 1 | 13.88 | 5 | 2.776 | 3 | 24 | 10 | 2.399999999999999 | 2
[NAME] | 3.68 | 1 | 3.68 | 2 | 5.87 | 2 | 2.935 | 2 | 13.6 | 10 | 1.36 | 6
Chase Seiffert | 3.13 | 1 | 3.13 | 3 | 3.13 | 1 | 3.13 | 1 | 6.24 | 8 | 0.78 | 12
[NAME] Poulter | 2.63 | 1 | 2.63 | 7 | 5.73 | 5 | 1.146 | 13 | 9.9 | 8 | 1.2375 | 9
[NAME] | 2.55 | 1 | 2.55 | 8 | 4.39 | 3 | 1.463333333333333 | 10 | 9.420000000000002 | 12 | 0.7850000000000001 | 11