Spreadsheet: 220079d1363048454-finding-golf-handicaps-using-best-2-out-of-3-last-rounds-played-golf2012
Sheet: STATS

 | TEAM # | GOLFER | HAND.# | HDCP | HANDICAP |  | 2012-04-26 00:00:00 | 2012-05-03 00:00:00 | 2012-05-10 00:00:00 | 2012-05-17 00:00:00 | 2012-05-24 00:00:00 | 2012-05-31 00:00:00 | 2012-06-07 00:00:00 | 2012-06-14 00:00:00 | 2012-06-21 00:00:00 | 2012-06-28 00:00:00 | 2012-07-05 00:00:00 | 2012-07-12 00:00:00 | 2012-07-19 00:00:00 | 2012-07-26 00:00:00 | 2012-08-02 00:00:00 | 2012-08-09 00:00:00 | 2012-08-16 00:00:00 | 2012-08-23 00:00:00 | Last Year
A1 | 1 | [NAME] | 86 | 6 | 6 | 6.72 | 50 | I | 46 | 46 | 42 | I | 47 | 46 |  | 40 | 41 | 39 | I | 44 | 45 | 41 | 50 | 45 | 40 | 41 | 47
A2 | 1 | [NAME] | 88 | 7 | 7 | 7.68 | 57 | I | 56 | 49 | 49 | I | 51 | 52 |  | 45 | 51 | 53 | I | 50 | 46 | 42 | 48 | 54 | 49 | 52 | 56
B1 | 2 | [NAME] | 114 | 20 | 20 | 20.16 | 53 | I | 57 | 54 | 55 | I | 59 | 53 |  | 51 | 56 | 58 | I | 52 | 55 | 59 | 64 | 55 | 47 | 51 | 57
B2 | 2 | [NAME] | 120 | 23 | 23 | 23.04 | 66 | I | 71 | 61 | 59 | I | 66 | 66 |  | 61 | 52 | 58 | I | 63 | 62 | 59 | 61 | 58 | 66 | 67 | 62
C1 | 3 | [NAME] | 100 | 13 | 13 | 13.44 | 52 | I | 54 | 45 | 46 | I | 49 | 50 |  | 47 | 50 | 52 | F | 48 | 52 | I | 52 | 54 | 47 | 51 | 49
C2 | 3 | Amber Lucas | 119 | 22 | 22 | 22.56 | 57 | I | 62 | 58 | 60 | I | 65 | 62 |  | 54 | 60 | 55 | F | 60 | 60 | I | 59 | 58 | 59 | 59 | 63
D1 | 4 | [NAME] | 108 | 17 | 17 | 17.28 | 59 | I | 64 | 54 | 61 | I | 56 | 56 |  | 54 | 55 | 60 | I | F | 64 | 53 | 55 | 60 | 68 | 55 | 58
D2 | 4 | [NAME] | 106 | 16 | 16 | 16.32 | 59 | I | 61 | 58 | 55 | I | 57 | 54 |  | 52 | 51 | 53 | I | F | 59 | 54 | 52 | 65 | 54 | 60 | 57
E1 | 5 | [NAME] | 122 | 24 | 24 | 24 | 60 | 66 | 63 | 59 | 61 | I | S | 64 |  | 61 | 62 | 61 | I | 60 | 66 | 62 | 60 | 58 | 64 | 62 | 65
E2 | 5 | [NAME] | 101 | 13 | 13 | 13.92 | 65 | 61 | 64 | 58 | 60 | I | 50 | 51 |  | 52 | 55 | S | I | 58 | 51 | 62 | 50 | 52 | 51 | 43 | 59
F1 | 6 | [NAME] | 108 | 17 | 17 | 17.28 | 65 | I | 67 | 54 | 62 | I | 65 | 60 |  | 56 | 57 | 55 | I | 53 | 55 | F | 59 |  | 62 | 59 | 64
F2 | 6 | [NAME] | 79 | 3 | 3 | 3.36 | 43 | I | S | 40 | 44 | I | 40 | 38 |  | 40 | 36 | 43 | I | 41 | 38 | F | 41
[NAME] | 7 | [NAME] | 108 | 17 | 17 | 17.28 | 58 | 57 | 60 | 58 | 53 | I | S | 50 |  | 53 | F | 58 | I | 53 | 56 | 52 | 61 | 64 | 58 | 57 | 57
G2 | 7 | Pam Morris | 124 | 24 | 24 | 24.96 | 69 | 69 | 64 | 52 | 61 | I | 59 | 57 |  | 56 | F | 52 | I | 53 | 58 | 68 | 66 | 57 | 58 | 59 | 69
H1 | 8 | [NAME] | 94 | 10 | 10 | 10.56 | 48 | I | 46 | 50 | 48 | I | S | 44 |  | 44 | 47 | 45 | I | 43 | 44 | 51 | 50 | 49 | 48 | 50 | 47
H2 | 8 | Jan Keen | 78 | 2 | 2 | 2.88 | F | I | 42 | 43 | S | I | 41 | F |  | 45 | S | 40 | I | 47 | 39 | S | 39 | 39 | 38 | 46 | 42
I1 | 9 | [NAME] | 102 | 14 | 14 | 14.4 | F | F | S | F | 55 | I | 52 | 50 |  | 57 | 56 | 55 | I | 50 | 52 | I | 56 |  | 58 | 52 | 48
I2 | 9 | Heather Weberling | 107 | 16 | 16 | 16.8 | F | F | 57 | S | 64 | I | 51 | 49 |  | 63 | 56 | S | I | 56 | 51 | I | 63 | 63 | 54 | 57 | 51
J1 | 10 | [NAME] | 123 | 24 | 24 | 24.48 | 62 | 60 | 62 | 71 | 60 | I | 57 | 60 |  | 56 | F | 55 | I | 66 | 60 | I | 63 | 67 | 64 | 61 | 60
J2 | 10 | [NAME] | 116 | 21 | 21 | 21.12 | 65 | 64 | 63 | 58 | 64 | I | 61 | 59 |  | 64 | F | S | I | 57 | 59 | I | 64 | 59 | 63 | 59 | 60
K1 | 11 | [NAME] | 117 | 21 | 21 | 21.6 | 67 | S | 58 | 60 | F | I | S | 57 |  | 58 | 59 | S | F | 59 | S | F | S |  | 53 | 61 | 57
K2 | 11 | [NAME] | 110 | 18 | 18 | 18.24 | S | 56 | S | 60 | 65 | I | 64 | S |  | 55 | S | 54 | F | S | 70 | F | 56 |  | 63 | 56 | 65
L1 | 12 | [NAME] | 105 | 15 | 15 | 15.84 | 60 | I | 54 | 57 | 52 | I | 58 | 52 |  | 54 | S | 59 | I | 52 | 56 | I | 53 | 62 | 61 | 57 | 54
L2 | 12 | Dixie Easterday | 123 | 24 | 24 | 24.48 | 57 | I | 62 | 62 | 60 | I | 65 | 69 |  | 63 | 54 | 59 | I | 62 | 66 | I | 61 | 57 | 63 | 55 | 63
M1 | 13 | Crystal Elliott | 121 | 23 | 23 | 23.52 | 56 | 58 | 59 | 67 | 57 | I | 52 | 64 |  | 53 | F | 52 | I | 54 | 61 | 61 | 60 | 53 | 56 | 58 | 53
M2 | 13 | [NAME] | 102 | 14 | 14 | 14.4 | 59 | 59 | 59 | S | 51 | I | 54 | 52 |  | 57 | 53 | 59 | I | 50 | 52 | 50 | 52 | 59 | 50 | 59 | 55
N1 | 14 | [NAME] | 124 | 24 | 24 | 24.96 | 62 | I | 68 | 63 | 64 | I | 62 | 62 |  | 59 | F | 56 | F | 62 | 66 | 59 | 65 | 64 | 62 | 67 | 64
N2 | 14 | [NAME] | 100 | 13 | 13 | 13.44 | 59 | I | 60 | 48 | 53 | I | 57 | 48 |  | 52 | 56 | 49 | F | 57 | 53 | 48 | 52 | 55 | 49 | 48 | 48
O1 | 15 | [NAME] | 100 | 13 | 13 | 13.44 | S | 58 | S | 56 | 55 | I | 53 | 53 |  | 46 | F | F | F | 48 | F | 52 | 55 |  | 52 | 48 | 55
O2 | 15 | [NAME] | 99 | 12 | 12 | 12.96 | 46 | 50 | 46 | S | 48 | I | 54 | 45 |  | 47 | 51 | 51 | I | 52 | 50 | 49 | S |  | 52 | 48 | 51
P1 | 16 | [NAME] | 137 | 31 | 31 | 31.2 | 66 | I | 67 | 71 | 63 | I | 69 | 72 |  | 66 | 64 | 65 | I | 75 | 68 | 69 | 71 | 69 | 75 | 65 | 75
P2 | 16 | [NAME] | 90 | 8 | 8 | 8.64 | 48 | I | 49 | 45 | 48 | I | 49 | 47 |  | 47 | 49 | 45 | I | S | 45 | 52 | S | 50
Q1 | 17 | [NAME] | 118 | 22 | 22 | 22.08 | 70 | 67 | 72 | 55 | 64 | I | 60 | 59 |  | 61 | 59 | 61 | I | 57 | 58 | 63 | 60 | 62 | 60 | 60 | 57
Q2 | 17 | [NAME] | 100 | 13 | 13 | 13.44 | 61 | 55 | 58 | 51 | 55 | I | 54 | 50 |  | 53 | 57 | 51 | I | 54 | 49 | 51 | 55 | 49 | 56 | 59 | 63
R1 | 18 | [NAME] | 126 | 25 | 25 | 25.92 | 70 | F | 60 | 59 | 55 | I | 54 | S |  | 65 | F | S | F | 69 | 62 | I | 64 | 56 | 49 | 56 | 61
R2 | 18 | [NAME] | 90 | 8 | 8 | 8.64 | 55 | I | S | 45 | 49 | I | 46 | 51 |  | F | 42 | 44 | I | 53 | S | I | 46 |  | 47 | 48 | 52
S1 | 19 | [NAME] | 93 | 10 | 10 | 10.08 | 53 | 53 | 56 | F | 58 | I | 48 | 48 |  | 55 | 52 | 47 | F | 45 | 47 | 46 | 50 | 50 | 51 | 52 | 52
S2 | 19 | [NAME] | 104 | 15 | 15 | 15.36 | 60 | 58 | 52 | F | 61 | I | 57 | 57 |  | 58 | F | 58 | I | 55 | 55 | 51 | 53 | 47 | 64 | 61 | 60
T1 | 20 | [NAME] | 86 | 6 | 6 | 6.72 | 52 | 53 | 52 | 51 | S | S | 53 | 42 |  | 44 | 46 | 48 | 44 | 43 | 47 | I | 43 | 49 | 39 | 46 | 42
T2 | 20 | Pam MacQuaig | 117 | 21 | 21 | 21.6 | 67 | 63 | 61 | 60 | 69 | I | 58 | 70 |  | 64 | S | 59 | 57 | 58 | 59 | I | 62 | 58 | 63 | 69 | 58
U1 | 21 | Pam MacQuaig | 0 | -34 | -34 | -34.56
U2 | 21 | Pam MacQuaig | 0 | -34 | -34 | -34.56
V1 | 22 | Pam MacQuaig | 0 | -34 | -34 | -34.56
V2 | 22 | Pam MacQuaig | 0 | -34 | -34 | -34.56
 |  | SUBS
 |  | [NAME] | 120 | 23 | 23 | 23.04 |  |  |  |  |  |  |  |  |  |  |  | 60
 |  | [NAME] | 96 | 11 | 11 | 11.52 |  |  |  |  |  |  |  |  |  |  | 46 |  |  |  |  | 50 |  |  | 49 | 63 | 59
 |  | [NAME] | 109 | 17 | 17 | 17.76 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49 | 63 | 59
 |  | [NAME] | 75 | 1 | 1 | 1.44 |  |  |  | 35 |  |  |  |  |  |  |  |  |  |  |  |  | 40
 |  | [NAME] | 124 | 20 | 20 | 24.96 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60 | 76 | 64
 |  | [NAME] | 125 | 20 | 20 | 25.44 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59 | 66
 |  | [NAME] | 109 | 17 | 17 | 17.76 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56 | 53
 |  | [NAME] | 106 | 16 | 16 | 16.32 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 54 | 58 | 52
 |  | [NAME] | 99 | 12 | 12 | 12.96 |  |  | 55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 55 | 57 | 44
 |  | [NAME] | 90 | 8 | 8 | 8.64 |  |  |  |  |  |  | 50 |  |  |  |  | 48 |  |  |  |  |  |  | 53 | 56 | 42
 |  | [NAME] | 138 | 31 | 31 | 31.68 |  |  |  |  |  |  |  | 69 |  |  |  | 69 |  |  | 75 |  |  |  | 73 | 72 | 78
 |  | [NAME] | 126 | 25 | 25 | 25.92 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 63
 |  | [NAME] | 98 | 12 | 12 | 12.48 |  |  | 49
 |  | [NAME] | 121 | 23 | 23 | 23.52 |  |  |  |  |  |  |  |  |  |  |  |  |  | 58 |  |  | 63
 |  | [NAME] | 115 | 20 | 20 | 20.64 |  | 62 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 58 | 57 | 58
 |  | [NAME] | 94 | 10 | 10 | 10.56 |  | 62 |  |  | 47
 |  | [NAME] | 111 | 18 | 18 | 18.72 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57 | 54 | 57
 |  | [NAME] | 128 | 26 | 26 | 26.88 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 66 | 62 | 67
 |  | [NAME] | 112 | 19 | 19 | 19.2 |  |  |  |  | 64 |  | 61 |  |  |  | 55 | 57 |  |  |  |  |  |  |  | 60 | 63
 |  | [NAME] | 108 | 17 | 17 | 17.28 |  |  |  | 54
 |  | [NAME] | 135 | 30 | 30 | 30.24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70 | 65 | 72
 |  | Paulette Sykora | 91 | 9 | 9 | 9.12 |  |  |  |  |  |  |  |  |  |  | 47 |  |  |  |  |  |  |  |  |  | 44
 |  | [NAME] | 110 | 18 | 18 | 18.24 |  |  |  | 55
 |  | [NAME] | 91 | 9 | 9 | 9.12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46 | 49 | 45
 |  | [NAME] | 118 | 22 | 22 | 22.08 |  |  | 59 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 53 | 60
 |  | [NAME] | 130 | 27 | 27 | 27.84 | 70 |  |  |  |  |  | 59 | 63 |  |  | 61 | 65 |  | 65 | 70 |  |  |  | 65 | 64 | 60
 |  | [NAME] | 149 | 35 | 36 | 36.96 | 69 |  | 80
 |  | [NAME] | 104 | 15 | 15 | 15.36 |  |  |  |  |  |  | 52