Revised 2021 Pennant draw

	A	B	C	D	E	F	G	I	J	L	M	N
1		Team 1	Team 2	Team 3	Team 4	Team 5	Team 6
2	Grade 2	KPY	NAM	SWR	PB			bow	2	saw	5
3	Grade 2.2	WP1	KEW	WAU	PC2	NH	PC1	hs	3	swr	3
4	Grade 3.1	KH	PB	HH	UBC	SAW	BYE	kew	3	ubc	4
5	Grade 3.2	HS	PC	LC	WP			kpy	4	wau	3
6	Grade 4.1	MKS	WLG	NB	SAW			kh	2	wlg	2
7	Grade 4.2	SWR	PC	NH	CH			lc	4	wp	4
8	Grade 5.1	SAW	PB	BOW	SH	NAM	UBC	mks	2		21
9	Grade 5.2	WAU	KEW	KPY	SP	PC	LC	nam	4		42
10	Grade 6.1	BOW	SAW	MKS	UBC	CEX	NAM	nb	2		63
12	Grade 6.2	COM	NH	BYE	LC	WP	PC	nh	4			69
13	Grade 7.1	LC	NH	WAU	KPY(a)	PC(a)	HS(a)	pb	4
14	Grade 7.2	SWR	WP	HS(b)	PC(b)	KEW	KPY(b)	pc	8
15	Grade 7.3	WLG	NB	SAW	NAM	PB	UBC		42
16		H/A/H/A/H	A/H/A/A/H	A/H/A/H/A	H/A/A/H/H	H/A/H/H/A	A/H/H/A/A
17	Teams	Enter teams into grades - columns 1/3, 2/5, 4/6 are exact opposites to assist with home/away.						HH, COM, CEX, CH, SH,SP
18		Maybe use columns 1/3 for single entry clubs - every second week at home
19	Drawtest	A draft draw is automatically completed
20	HnAway	Transfers the draft draw so you can see 'Home & Away' situation and any problems with clubs having too many grades at home
21		Should be no problems. If any then manually correct either by going to Teams and swapping one club for another or make changes in "Drawtest" only.
22		Changes in "Drawtest" will involve moving formula - not just names although that will work but loses the formula if you want to change back.
23	All clubs	Final draw copied automatically from completed HnAway spreadsheet in final format for website - overall draw
24	Gr 2 to Gr 7	Automatically copies from 'All clubs' to make individual weekly draw sheets for placement on website
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
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
101