Docstoc

Callaway Score Golf Spreadsheet A B C D E

Document Sample
Callaway Score Golf Spreadsheet A B C D E Powered By Docstoc
					                 A          B      C       D      E       F      G      H      I     J      K       L        M             N      O       P      Q            R
 1                                                 HSBC 9 Hole challenge Golf Conversion Table
 2   Host Club            e.g. Whitford Park
                                                                                                     This is a generic spreadsheet to be used for the
 3
                                                                                                                  non-member division
 4                        Gross (using double par max.)        Holes for deduction
 5                           35 (par)            34       35   Scratch
 6                                       36                    1/2 of worst hole         1. Enter the par of your 9 hole course (B5)
 7                                       37      38       39   Worst Hole                2. Enter the hole by hole par (D22 to L22)
 8                                       40      41            1 1/2 Worst Holes         3. Enter the stroke hole numbers (D23 to L23)
 9                                       42      43       44   2 Worst Holes             4. Enter Players name (Column A)
10                                       45      46            2 1/2 Worst Holes         5. Enter Players scores (same row as name, D to L)
11                                       47      48       49   3 Worst Holes                NOTE: Maximum score is double the par
12                                       50      51            3 1/2 Worst Holes         6. Take the total gross in column M & determine in red zone the deduction
13                                       52      53       54   4 Worst Holes             7. Add number of worst holes to deduct to column N
14                                       55      56            4 1/2 Worst Holes         8. Add the worst and insert total to column O
15                                       57      58       59   5 Worst Holes             9. Based on red zone column, add adjustment to column P
16                                       60      61            5 1/2 Worst Holes         10. The formulas should then calculate the final nett score (column R)
17                                       62      63       64   6 Worst Holes
18                                       -1       0       +1   Handicap Adjustment
19                                                                                       NOTE: Stableford row included if required.
20
21                                       Hole 1 Hole 2 Hole 3 Hole 4 Hole 5 Hole 6 Hole 7 Hole 8 Hole 9     Total        Worst                Half
22                        Par              4      4      3      4      4      5      4      4      3         35          Holes Total          Deduct Nett
23                        Stroke Index     3      4      9      2      7      8      6      1      5                     Deduct Deduct Adjust (H'cap) Score
24
25   Name of non-handicap player
26   Example Player 1     Hole score       8      8       5      8      7      9     6      6       3               60    5.5     43     -1     21                39.00
27                        Stablefords      0      2       2      0      1      1     2      2       4               14
28   Example Player 2     Hole score       5      4       4      5      5      4     5      5       5               42     2      10     -1     4.5               37.50
29                        Stablefords      2      3       1      2      1      3     1      2       1               16
30                        Hole score       0      0       0      0      0      0     0      0       0                0                           0                 0.00
31                        Stablefords      0      0       0      0      0      0     0      0       0                0
32                        Hole score       0      0       0      0      0      0     0      0       0                0                           0                 0.00
33                        Stablefords      0      0       0      0      0      0     0      0       0                0
34                        Hole score       0      0       0      0      0      0     0      0       0                0                           0                 0.00
35                        Stablefords      0      0       0      0      0      0     0      0       0                0
36                        Hole score       0      0       0      0      0      0     0      0       0                0                           0                 0.00
37                        Stablefords      0      0       0      0      0      0     0      0       0                0
     A     B      C    D   E   F   G   H   I   J   K   L   M       N   O   P   Q   R
38       Hole score    0   0   0   0   0   0   0   0   0       0               0       0.00
39       Stablefords   0   0   0   0   0   0   0   0   0       0
40       Hole score    0   0   0   0   0   0   0   0   0       0               0       0.00
41       Stablefords   0   0   0   0   0   0   0   0   0       0
42       Hole score    0   0   0   0   0   0   0   0   0       0               0       0.00
43       Stablefords   0   0   0   0   0   0   0   0   0       0
44       Hole score    0   0   0   0   0   0   0   0   0       0               0       0.00
45       Stablefords   0   0   0   0   0   0   0   0   0       0
46       Hole score    0   0   0   0   0   0   0   0   0       0               0       0.00
47       Stablefords   0   0   0   0   0   0   0   0   0       0
48       Hole score    0   0   0   0   0   0   0   0   0       0               0       0.00
49       Stablefords   0   0   0   0   0   0   0   0   0       0
50       Hole score    0   0   0   0   0   0   0   0   0       0               0       0.00
51       Stablefords   0   0   0   0   0   0   0   0   0       0
52       Hole score    0   0   0   0   0   0   0   0   0       0               0       0.00
53       Stablefords   0   0   0   0   0   0   0   0   0       0
54       Hole score    0   0   0   0   0   0   0   0   0       0               0       0.00
55       Stablefords   0   0   0   0   0   0   0   0   0       0
56       Hole score    0   0   0   0   0   0   0   0   0       0               0       0.00
57       Stablefords   0   0   0   0   0   0   0   0   0       0
58       Hole score    0   0   0   0   0   0   0   0   0       0               0       0.00
59       Stablefords   0   0   0   0   0   0   0   0   0       0
60       Hole score    0   0   0   0   0   0   0   0   0       0               0       0.00
61       Stablefords   0   0   0   0   0   0   0   0   0       0
62       Hole score    0   0   0   0   0   0   0   0   0       0               0       0.00
63       Stablefords   0   0   0   0   0   0   0   0   0       0
64       Hole score    0   0   0   0   0   0   0   0   0       0               0       0.00
65       Stablefords   0   0   0   0   0   0   0   0   0       0
66       Hole score    0   0   0   0   0   0   0   0   0       0               0       0.00
67       Stablefords   0   0   0   0   0   0   0   0   0       0
68       Hole score    0   0   0   0   0   0   0   0   0       0               0       0.00
69       Stablefords   0   0   0   0   0   0   0   0   0       0
70       Hole score    0   0   0   0   0   0   0   0   0       0               0       0.00
71       Stablefords   0   0   0   0   0   0   0   0   0       0
72       Hole score    0   0   0   0   0   0   0   0   0       0               0       0.00
73       Stablefords   0   0   0   0   0   0   0   0   0       0
74       Hole score    0   0   0   0   0   0   0   0   0       0               0       0.00
     A     B      C    D   E   F   G   H   I   J   K   L   M       N   O   P   Q   R
75       Stablefords   0   0   0   0   0   0   0   0   0       0
76       Hole score    0   0   0   0   0   0   0   0   0       0               0       0.00
77       Stablefords   0   0   0   0   0   0   0   0   0       0
78       Hole score    0   0   0   0   0   0   0   0   0       0               0       0.00
79       Stablefords   0   0   0   0   0   0   0   0   0       0
80       Hole score    0   0   0   0   0   0   0   0   0       0               0       0.00
81       Stablefords   0   0   0   0   0   0   0   0   0       0
82       Hole score    0   0   0   0   0   0   0   0   0       0               0       0.00
83       Stablefords   0   0   0   0   0   0   0   0   0       0
84       Hole score    0   0   0   0   0   0   0   0   0       0               0       0.00
85       Stablefords   0   0   0   0   0   0   0   0   0       0
86       Hole score    0   0   0   0   0   0   0   0   0       0               0       0.00
87       Stablefords   0   0   0   0   0   0   0   0   0       0
88       Hole score    0   0   0   0   0   0   0   0   0       0               0       0.00
89       Stablefords   0   0   0   0   0   0   0   0   0       0
90       Hole score    0   0   0   0   0   0   0   0   0       0               0       0.00
91       Stablefords   0   0   0   0   0   0   0   0   0       0
92       Hole score    0   0   0   0   0   0   0   0   0       0               0       0.00
93       Stablefords   0   0   0   0   0   0   0   0   0       0
94       Hole score    0   0   0   0   0   0   0   0   0       0               0       0.00
95       Stablefords   0   0   0   0   0   0   0   0   0       0
96       Hole score    0   0   0   0   0   0   0   0   0       0               0       0.00
97       Stablefords   0   0   0   0   0   0   0   0   0       0
98

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:544
posted:11/15/2010
language:English
pages:3
Description: Callaway Score Golf Spreadsheet document sample