TGL.pairings

	A	B
1	What is this workbook
2		The TGL Pairings spreadsheet
3
4		It contains the actual pairing assignments specifying where and when each player is to Tee Off.
5
6		All the information in these pairing sheets are automaticalluy derived from the corresponding sheets in the TGL.signup spreadsheet.
7
8		You shouild not edit any cells or values in the sheets in this spreadsheet
9
10		Instead, edit the corresponding round sheet in the signup spreadsheet.
11
12
13
14	HOW TO use this workbook
15		The rounds are named in YYYYRR format, as in 202301 for round1
16		There is a Tuesday and Thursday sheet for each round.
17		Use the template sheet named YYYYRR to create new pairing sheets.
18		Duplicate the template sheet named YYYYRR sheet and rename the copy 202301.tue, for example.
19		In the new duplicate sheet, renamed the sheet to the desired round, as in: 202403.wed
20		Change the round number and day of week in the upped left corner (eg: round is 3, day of ween is Wed
21
22		There should be 3 separate sheets for each round with day of week suffix for tue,wed, and thu
23
24
25		The following sheet will need to be updated each week, as new handicaps are calculated:
26		TNHI
27		What will happen is Larry will get the scores from Joel, and Larry will post them to the master workbook (TGL2015.N.xlsm), and re-calculate handicaps for that round.
28
29		Larry will email Joel and Jeff a workbook containing ONLY the new TNHI sheet.
30		Joel can COPY/Paste-Special Values the TNCH sheet to his copy of the TNCH sheet in his workbook.
31		Jeff can COPY/Paste-Special Values the TNCH sheet to his copy of the TNCH sheet in this parings workbook.
32
33		Note that the TNCH sheet is cumulative with ALL course handicap data for all rounds, all years.
34
35		The following sheets in this Pairing workbook will change less frequently, and if it does, should be updated:
36		Members - Roster of all teams and members
37		Pairings - This is a TEMPLATE sheet that is used to create new round sheets for a new round.
38		GolfNG - list of member of Golf NG club
39		rounds - list of each round, its Tuesday and Thursday dates, and form
40		courses - List of courses at Poppy Ridge and their handicapping data for each Tee.
41
42		Larry will notify Jeff if any of these change. Jeff can email Larry his TGL.pairings.xlsx workbook. Larry will update and return.
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100