Powell River Scotties Pool 2020
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQ
1
ALBERTABCCANADAMANITOBANBNLNORTH ONTNSNWTNUNONTPEIQUESASKYUKONWILDCARD
2
NamePlaceTotalRankPointsRankPointsRankPointsRankPointsRankPointsRankPointsRankPointsRankPointsRankPointsRankPointsRankPointsRankPointsRankPointsRankPointsRankPointsRankPoints
3
TEMPLATE10
4
5
6
To Configure Wook book for Competition:
7
Define the Teams on the "Teams and Wins" work sheet.
8
Define the Point scoring on the "Points for Each Rank" work sheet.
9
10
11
To add new Entry:
12
Copy ALL of Row 3 above and paste on next empty row on the 'Ranking' Work sheet.
13
Replace "Template" with entry's name and fill out ranking value for each team.
14
Only enter values in cells with GREEN backgrounds.
15
Do not Modify cells with RED backgronds. These cells contain formulas.
16
Highlighting will disappear as the entry is completed.
17
Do not modify Total or Point Columns
18
19
20
To Print Results:
21
Highlight/Select Only needed cells (Eliminate Blank Space at far right and bottom).
22
Click print
23
Under options:
24
select "Selection"
25
Check "Repeat Row Headers on each page", "No gridlines" and, "Include Documnet Title"
26
27
Under Layout select "Fit to Width" and "Landscape"
28
29
Click Print
30
31
SORTING
32
Select Cell A2
33
Hold down <Ctrl><Shift><Dn Arrow> to select all column A down to last used row
34
Hold down <Ctrl><Shift><Rt Arrow> to select all columns to last used column
35
Select Menu: Data|Sort the Range
36
37
Select following options
38
- check "Data has a header row"
39
- Sort by "Total"
40
- check Sort Z->A
41
42
Or just click on the entire Pts column "C" and right click to Sort Z-> A
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
Loading...