Spreadsheet: 47204d1246134605-conditional-golf-handicap-formula-based-on-and-date-of-entries-iannew
Sheet: DATA

Player
Handicap At Time Played | 27.6 | 27.6 | 27.4 | 27.3 | 27.1 | 26.9 | 26.9 | 26.7 | 25.7
Date | 2009-03-28 00:00:00 | 2009-04-05 00:00:00 | 2009-04-10 00:00:00 | 2009-04-11 00:00:00 | 2009-04-18 00:00:00 | 2009-05-02 00:00:00 | 2009-05-09 00:00:00 | 2009-05-30 00:00:00 | 2009-06-06 00:00:00
Course | Esmerelda | Meadow Wood | Downriver | Esmerelda | Indian Cannon | [NAME] | Downriver | Meadow Wood | Esmerelda
Rating
Slope
Fairways Possible
Score
Hole 1 | 6 | 8 | 5 | 5 | 6 | 7 | 6 | 5 | 4
2 | 5 | 8 | 5 | 4 | 4 | 5 | 5 | 5 | 4
3 | 6 | 6 | 6 | 5 | 7 | 7 | 5 | 6 | 6
4 | 6 | 5 | 7 | 4 | 7 | 4 | 4 | 5 | 6
5 | 6 | 5 | 5 | 7 | 6 | 8 | 7 | 9 | 6
6 | 6 | 4 | 3 | 6 | 5 | 7 | 3 | 5 | 5
7 | 6 | 7 | 6 | 6 | 6 | 5 | 8 | 5 | 5
8 | 4 | 3 | 5 | 4 | 4 | 5 | 7 | 4 | 4
9 | 5 | 5 | 5 | 5 | 7 | 5 | 6 | 4 | 6
Out
10 | 7 | 8 | 6 | 5 | 7 | 8 | 7 | 7 | 5
11 | 5 | 4 | 5 | 6 | 7 | 4 | 5 | 4 | 9
12 | 4 | 6 | 7 | 4 | 7 | 6 | 5 | 7 | 5
13 | 4 | 4 | 7 | 3 | 5 | 8 | 7 | 5 | 4
14 | 5 | 4 | 5 | 6 | 5 | 4 | 8 | 5 | 5
15 | 6 | 5 | 6 | 8 | 5 | 8 | 5 | 4 | 6
16 | 6 | 6 | 4 | 5 | 7 | 8 | 4 | 8 | 6
17 | 4 | 5 | 5 | 5 | 7 | 5 | 3 | 5 | 4
18 | 7 | 7 | 4 | 6 | 6 | 7 | 8 | 6 | 6
In
TOT
GIR
Hole 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
2 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0
3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
8 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0
9 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0
Out
10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
13 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1
14 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
17 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
18 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1
In
TOT
% GIR Hit
FH
Hole 1 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1
2 | n/a | 0 | n/a | n/a | n/a | 1 | n/a | 0 | n/a
3 | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 0
4 | 1 | 1 | 1 | 0 | n/a | 1 | 0 | 1 | 0
5 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 1
6 | 1 | n/a | n/a | 0 | 1 | 0 | n/a | n/a | 0
7 | 0 | 0 | 0 | 1 | 0 | n/a | 0 | 0 | 1
8 | n/a | n/a | n/a | n/a | 1 | 1 | n/a | n/a | n/a
9 | 0 | 0 | 1 | 0 | 0 | n/a | 0 | 1 | 0
Out
10 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1
11 | 0 | n/a | 0 | 0 | 1 | n/a | 0 | n/a | 0
12 | n/a | 1 | n/a | n/a | 1 | 1 | n/a | 0 | n/a
13 | 1 | 1 | 1 | 0 | n/a | 0 | 1 | 0 | 0
14 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 1
15 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0
16 | 0 | 1 | n/a | 0 | 0 | 0 | n/a | 0 | 0
17 | n/a | n/a | 0 | n/a | n/a | n/a | 0 | n/a | n/a
18 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0
In
TOT
% FH
Putts
Hole 1 | 3 | 2 | 1 | 2 | 2 | 1 | 2 | 1 | 2
2 | 3 | 1 | 3 | 2 | 3 | 2 | 3 | 2 | 2
3 | 1 | 2 | 1 | 1 | 1 | 2 | 1 | 3 | 1
4 | 3 | 2 | 2 | 1 | 2 | 1 | 2 | 2 | 2
5 | 2 | 2 | 2 | 4 | 1 | 3 | 3 | 3 | 2
6 | 2 | 2 | 1 | 3 | 2 | 2 | 1 | 2 | 1
7 | 3 | 2 | 2 | 3 | 2 | 3 | 2 | 1 | 2
8 | 2 | 1 | 2 | 1 | 2 | 2 | 5 | 2 | 2
9 | 2 | 1 | 3 | 2 | 4 | 3 | 1 | 2 | 3
Out
10 | 3 | 2 | 2 | 2 | 3 | 3 | 2 | 1 | 3
11 | 2 | 1 | 2 | 2 | 3 | 2 | 2 | 2 | 3
12 | 2 | 1 | 2 | 1 | 4 | 2 | 2 | 2 | 2
13 | 2 | 2 | 3 | 1 | 1 | 1 | 3 | 1 | 2
14 | 2 | 2 | 1 | 1 | 1 | 1 | 4 | 2 | 2
15 | 2 | 1 | 1 | 2 | 2 | 3 | 2 | 1 | 2
16 | 3 | 2 | 1 | 1 | 2 | 4 | 2 | 2 | 2
17 | 2 | 2 | 2 | 2 | 2 | 3 | 1 | 2 | 2
18 | 3 | 3 | 2 | 2 | 3 | 3 | 3 | 2 | 4
In
TOT
Average Per Hole
Course Par Rating
Hole 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
TOT
GIR/PAR OR BETTER
Hole 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
TOT
GIR/PAR %
GIR/PAR Par 3
Hole 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
TOT
GIR/PAR Par 4
Hole 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
TOT
GIR/PAR Par 5
Hole 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
TOT
Par 3 Pars
Hole 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
TOT
Par 4 Pars
Hole 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
TOT
Par 5 Pars
Hole 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
TOT
TOTAL Pars
Par 3 Birdies
Hole 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
TOT
Par 4 Birdies
Hole 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
TOT
Par 5 Birdies
Hole 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
TOT
TOTAL Birdies
Par 4 Eagles
Hole 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
TOT
Par 5 Eagles
Hole 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
TOT
TOTAL Eagles
Hole In Ones
Hole 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
TOT
Putts Per GIR
Hole 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
TOT
Putts Per GIR
Course Handicap Rating
Hole 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
Adjusted Handicap Score
Hole 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
TOT