Spreadsheet: 177227d1346237724-golf-scoring-pulling-values-to-new-cells-and-sorting-based-on-value-etc-copy-of-golf-pairing-example-with-cf
Sheet: Event 1

BEST BALL (NET)
 | GROSS |  | Hole | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | OUT | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | IN | TOT
 |  |  | Par | 4 | 4 | 4 | 5 | 3 | 4 | 5 | 3 | 4 | 36 | 5 | 3 | 4 | 5 | 3 | 4 | 4 | 3 | 5 | 36 | 72
 |  |  | [NAME] | 13 | 15 | 7 | 1 | 9 | 3 | 5 | 17 | 11 |  | 4 | 14 | 8 | 2 | 16 | 6 | 12 | 18 | 10
Player # | Name | Handicap | Adjusted
1a | [NAME] | 15.6 | 14 | 4 | 5 | 6 | 7 | 5 | 5 | 5 | 5 | 5 | 47 | 5 | 5 | 5 | 4 | 3 | 4 | 5 | 6 | 5 | 42 | 89
1b | [NAME] | 12.1 | 10 | 5 | 5 | 5 | 4 | 4 | 5 | 5 | 3 | 4 | 40 | 4 | 5 | 5 | 5 | 7 | 3 | 5 | 5 | 4 | 43 | 83
2a | [NAME] | 11.5 | 10 | 5 | 5 | 5 | 4 | 5 | 5 | 5 | 3 | 4 | 41 | 5 | 5 | 5 | 5 | 4 | 4 | 4 | 3 | 5 | 40 | 81
2b | [NAME] | 16.5 | 15 | 5 | 6 | 6 | 5 | 4 | 6 | 4 | 3 | 4 | 43 | 4 | 5 | 7 | 5 | 5 | 8 | 4 | 4 | 7 | 49 | 92
3a | Cliff | 19.2 | 17 | 4 | 5 | 6 | 7 | 5 | 5 | 5 | 5 | 5 | 47 | 4 | 5 | 6 | 7 | 5 | 5 | 5 | 5 | 5 | 47 | 94
3b | [NAME] | 13.4 | 11 | 5 | 5 | 5 | 4 | 4 | 5 | 5 | 3 | 4 | 40 | 5 | 5 | 5 | 4 | 4 | 5 | 5 | 3 | 4 | 40 | 80
4a | [NAME] | 19.1 | 17 | 5 | 5 | 5 | 4 | 5 | 5 | 5 | 3 | 4 | 41 | 5 | 5 | 5 | 4 | 5 | 5 | 5 | 3 | 4 | 41 | 82
4b | [NAME] | 2.1 | 0 | 4 | 5 | 4 | 7 | 5 | 5 | 5 | 5 | 5 | 45 | 5 | 6 | 6 | 5 | 4 | 6 | 4 | 3 | 4 | 43 | 88
5a | [NAME] | 14.3 | 12 | 5 | 5 | 5 | 4 | 4 | 5 | 5 | 3 | 4 | 40 | 4 | 5 | 6 | 7 | 5 | 5 | 5 | 5 | 5 | 47 | 87
5b | [NAME] | 20.2 | 18 | 5 | 5 | 8 | 5 | 5 | 5 | 5 | 3 | 4 | 45 | 5 | 5 | 5 | 4 | 4 | 5 | 5 | 3 | 4 | 40 | 85
6a | [NAME] | 6.9 | 5 | 4 | 8 | 6 | 7 | 5 | 7 | 5 | 5 | 5 | 52 | 4 | 5 | 6 | 7 | 5 | 5 | 5 | 5 | 5 | 47 | 99
6b | [NAME] | 14.7 | 13 | 5 | 6 | 5 | 4 | 2 | 5 | 5 | 3 | 4 | 39 | 5 | 5 | 7 | 4 | 4 | 5 | 5 | 7 | 7 | 49 | 88
7a | Adam | 7.1 | 5 | 5 | 5 | 5 | 4 | 5 | 5 | 5 | 3 | 7 | 44 | 6 | 6 | 5 | 4 | 6 | 5 | 5 | 6 | 6 | 49 | 93
7b | [NAME] | 6 | 4 | 5 | 6 | 6 | 5 | 4 | 6 | 4 | 3 | 4 | 43 | 5 | 6 | 6 | 5 | 4 | 6 | 4 | 3 | 4 | 43 | 86
 | NET |  | Hole | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | OUT | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | IN | TOT
 |  |  | Par | 4 | 4 | 4 | 5 | 3 | 4 | 5 | 3 | 4 | 36 | 5 | 3 | 4 | 5 | 3 | 4 | 4 | 3 | 5 | 36 | 72
 |  |  | [NAME] | 13 | 15 | 7 | 1 | 9 | 3 | 5 | 17 | 11 |  | 4 | 14 | 8 | 2 | 16 | 6 | 12 | 18 | 10 |  |  |  |  |  | Hole Index
Player # | Name | Handicap | Adjusted |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check |  | Tie Breaker | 1 | 2 | 3 | 4 | 5
1a | [NAME] | 15.6 | 14 | 3 | 5 | 5 | 6 | 4 | 4 | 4 | 5 | 4 | 40 | 4 | 4 | 4 | 3 | 3 | 3 | 4 | 6 | 4 | 35 | 75 | 89 |  | 75.63444 | 0.6 | 0.03 | 0.004 | 0.0004 | 4e-05
1b | [NAME] | 12.1 | 10 | 5 | 5 | 4 | 3 | 3 | 4 | 4 | 3 | 4 | 35 | 3 | 5 | 4 | 4 | 7 | 2 | 5 | 5 | 3 | 38 | 73 | 83 |  | 73.34434 | 0.3 | 0.04 | 0.004 | 0.0003 | 4e-05
2a | [NAME] | 11.5 | 10 | 5 | 5 | 4 | 3 | 4 | 4 | 4 | 3 | 4 | 36 | 4 | 5 | 4 | 4 | 4 | 3 | 4 | 3 | 4 | 35 | 71 | 81 |  | 71.34444 | 0.3 | 0.04 | 0.004 | 0.0004 | 4e-05
2b | [NAME] | 16.5 | 15 | 4 | 5 | 5 | 4 | 3 | 5 | 3 | 3 | 3 | 35 | 3 | 4 | 6 | 4 | 5 | 7 | 3 | 4 | 6 | 42 | 77 | 92 |  | 77.44533 | 0.4 | 0.04 | 0.005 | 0.0003 | 3e-05
3a | Cliff | 19.2 | 17 | 3 | 4 | 5 | 6 | 4 | 4 | 4 | 4 | 4 | 38 | 3 | 4 | 5 | 6 | 4 | 4 | 4 | 5 | 4 | 39 | 77 | 94 |  | 77.66434 | 0.6 | 0.06 | 0.004 | 0.0003 | 4e-05
3b | [NAME] | 13.4 | 11 | 5 | 5 | 4 | 3 | 3 | 4 | 4 | 3 | 3 | 34 | 4 | 5 | 4 | 3 | 4 | 4 | 5 | 3 | 3 | 35 | 69 | 80 |  | 69.33444 | 0.3 | 0.03 | 0.004 | 0.0004 | 4e-05
4a | [NAME] | 19.1 | 17 | 4 | 4 | 4 | 3 | 4 | 4 | 4 | 2 | 3 | 32 | 4 | 4 | 4 | 3 | 4 | 4 | 4 | 3 | 3 | 33 | 65 | 82 |  | 65.33444 | 0.3 | 0.03 | 0.004 | 0.0004 | 4e-05
4b | [NAME] | 2.1 | 0 | 4 | 5 | 4 | 7 | 5 | 5 | 5 | 5 | 5 | 45 | 5 | 6 | 6 | 5 | 4 | 6 | 4 | 3 | 4 | 43 | 88 | 88 |  | 88.75555 | 0.7 | 0.05 | 0.005 | 0.0005 | 5e-05
5a | [NAME] | 14.3 | 12 | 5 | 5 | 4 | 3 | 3 | 4 | 4 | 3 | 3 | 34 | 3 | 5 | 5 | 6 | 5 | 4 | 4 | 5 | 4 | 41 | 75 | 87 |  | 75.36434 | 0.3 | 0.06 | 0.004 | 0.0003 | 4e-05
5b | [NAME] | 20.2 | 18 | 4 | 4 | 7 | 4 | 4 | 4 | 4 | 2 | 3 | 36 | 4 | 4 | 4 | 3 | 3 | 4 | 4 | 2 | 3 | 31 | 67 | 85 |  | 67.43444000000001 | 0.4 | 0.03 | 0.004 | 0.0004 | 4e-05
6a | [NAME] | 6.9 | 5 | 4 | 8 | 6 | 6 | 5 | 6 | 4 | 5 | 5 | 49 | 3 | 5 | 6 | 6 | 5 | 5 | 5 | 5 | 5 | 45 | 94 | 99 |  | 94.66633999999999 | 0.6 | 0.06 | 0.006 | 0.0003 | 4e-05
6b | [NAME] | 14.7 | 13 | 4 | 6 | 4 | 3 | 1 | 4 | 4 | 3 | 3 | 32 | 4 | 5 | 6 | 3 | 4 | 4 | 4 | 7 | 6 | 43 | 75 | 88 |  | 75.33444 | 0.3 | 0.03 | 0.004 | 0.0004 | 4e-05
7a | Adam | 7.1 | 5 | 5 | 5 | 5 | 3 | 5 | 4 | 4 | 3 | 7 | 41 | 5 | 6 | 5 | 3 | 6 | 5 | 5 | 6 | 6 | 47 | 88 | 93 |  | 88.33454 | 0.3 | 0.03 | 0.004 | 0.0005 | 4e-05
7b | [NAME] | 6 | 4 | 5 | 6 | 6 | 4 | 4 | 5 | 4 | 3 | 4 | 41 | 4 | 6 | 6 | 4 | 4 | 6 | 4 | 3 | 4 | 41 | 82 | 86 |  | 82.44544 | 0.4 | 0.04 | 0.005 | 0.0004 | 4e-05
Combined Score Card
 | NET |  | Hole | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | OUT | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | IN | TOT
 |  |  | Par | 4 | 4 | 4 | 5 | 3 | 4 | 5 | 3 | 4 | 36 | 5 | 3 | 4 | 5 | 3 | 4 | 4 | 3 | 5 | 36 | 72
 |  |  | [NAME] | 13 | 15 | 7 | 1 | 9 | 3 | 5 | 17 | 11 |  | 4 | 14 | 8 | 2 | 16 | 6 | 12 | 18 | 10 |  |  |  |  |  | Hole Index
Team # | Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tie Breaker | 1 | 2 | 3 | 4 | 5
1 | [NAME] |  |  | 3 | 5 | 4 | 3 | 3 | 4 | 4 | 3 | 4 | 33 | 3 | 4 | 4 | 3 | 3 | 2 | 4 | 5 | 3 | 31 | 64 |  |  | 64.33434 | 0.3 | 0.03 | 0.004 | 0.0003 | 4e-05
2 | [NAME] |  |  | 4 | 5 | 4 | 3 | 3 | 4 | 3 | 3 | 3 | 32 | 3 | 4 | 4 | 4 | 4 | 3 | 3 | 3 | 4 | 32 | 64 |  |  | 64.34433 | 0.3 | 0.04 | 0.004 | 0.0003 | 3e-05
3 | Cliff  + [NAME] |  |  | 3 | 4 | 4 | 3 | 3 | 4 | 4 | 3 | 3 | 31 | 3 | 4 | 4 | 3 | 4 | 4 | 4 | 3 | 3 | 32 | 63 |  |  | 63.33434 | 0.3 | 0.03 | 0.004 | 0.0003 | 4e-05
4 | [NAME] |  |  | 4 | 4 | 4 | 3 | 4 | 4 | 4 | 2 | 3 | 32 | 4 | 4 | 4 | 3 | 4 | 4 | 4 | 3 | 3 | 33 | 65 |  |  | 65.33444 | 0.3 | 0.03 | 0.004 | 0.0004 | 4e-05
5 | [NAME] |  |  | 4 | 4 | 4 | 3 | 3 | 4 | 4 | 2 | 3 | 31 | 3 | 4 | 4 | 3 | 3 | 4 | 4 | 2 | 3 | 30 | 61 |  |  | 61.33434 | 0.3 | 0.03 | 0.004 | 0.0003 | 4e-05
6 | [NAME]  + Jarrod |  |  | 4 | 6 | 4 | 3 | 1 | 4 | 4 | 3 | 3 | 32 | 3 | 5 | 6 | 3 | 4 | 4 | 4 | 5 | 5 | 39 | 71 |  |  | 71.33434 | 0.3 | 0.03 | 0.004 | 0.0003 | 4e-05
7 | [NAME] |  |  | 5 | 5 | 5 | 3 | 4 | 4 | 4 | 3 | 4 | 37 | 4 | 6 | 5 | 3 | 4 | 5 | 4 | 3 | 4 | 38 | 75 |  |  | 75.33444 | 0.3 | 0.03 | 0.004 | 0.0004 | 4e-05