Woolverstonehall List
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
£
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
It might be useful to read these first
3
4
Here are some notes relating to the use of the workbook. They provide some explanation of the rationale behind the data and, for those not au fait with MS Excel, some tips on how to access and manipulate the data.
5
6
Introduction:
7
1There ten active worksheets in the workbook - 'INDEX', one for each House, 'Unknown', 'Staff, etc' and 'Charts' - these can be accessed by left clicking on the tabs at the foot of this Window. The 'Distribution' worksheet is merely a record of who has received a copy of this workbook and when.
8
2Boys are entered on the 'Unknown' worksheet where there is no definite evidence of which house they lived in.
9
3In the early days of the school first and second year boys went into Headmaster's House (also known as Junior House). This later became two junior houses, Berners and Orwell, and later still they became senior houses in their own right. Consequently a lot of boys were in two houses (Junior/Berners or Junior/Orwell and their 'senior' house) and some boys were in two senior houses (having transferred from one of the older houses to Berners or Orwell when they became senior houses to make up their numbers). Generally, a boy's allegiance is to his (last) senior house and if both are quoted then it is that house under which he is entered. There should only be one entry per boy throughout this workbook.
10
11
The 'INDEX' worksheet:
12
1As its name implies, this provides an index of all the boys entered in the workbook. It is generated automatically when the 'CREATE INDEX' button on the Toolbar is selected.
13
2The data is sorted in ascending order of Surname then Firstname(s) then House.
14
3Note that, where a cell in the 'Comments' column is filled pink, thus: it denotes that the boy's name does not appear in Ian Thompson's database and that it may need further corroboration.
15
16
The 'Houses' worksheets:
17
1These worksheets contain data for boys where there is a fair degree of certainty about which house they were in.
18
2The data in the 'Houses' worksheets is sorted in the following ascending alphabetical order:
a) House, then
b) Surname, then
c) First name
19
3The data in most of the columns is self explanatory but the "Attendance (inc)" column (column E) contains the inclusive dates (calendar years) that the person was at WHS. Some of these dates are uncorroborated and in some instances are accompanied by an Excel Comment. These can be identified by a small red triangle in the top right hand corner of the cell and can be made visible by hovering the cursor over the cell. Generally, this gives provenance to the dates used. If you can't see all of the comment either move the scroll bar to the extreme left or right click on the cell and select 'Edit Comment' and use the box 'handles' to adjust it's size.
20
4Column G was used by the author in the construction of the worksheet to highlight where date data was missing.
21
5Columns H through AS are used to identify the years that the person attended the school
22
6Column AT identifies where no date information is available
23
7The title row at the head of each column contains a filter arrow. Note that, due to the quantity of data on these worksheets, this is not a reliable method of ascertaining the presence of a boy's name - it is more reliable to interogate the 'Index' worksheet first. Click on the filter arrow to see a dropdown list of unique items of data in the column. By left clicking on an item in the list Excel will filter out all but those items. Thus all members of Halls House, or all boys present in 1976, can be filtered, for example. To remove a filter either select 'All' in the dropdown list or Data -> Filter -> Show All.
24
8The 'Totals' data at the foot of the sheet is used to produce the graphics on the 'Charts' worksheet.
25
26
The 'Unknown' worksheet:
27
1This worksheet contains data for boys where there is some uncertainty about which house they were in. They will be moved to the 'House' worksheet when the doubts have been resolved.
28
2The data in the 'Unknown' worksheet is sorted in the following ascending alphabetical order:
a) Surname, then
c) First name
29
3The rest of the worksheet is formatted in the same way as the 'Houses' worksheets.
30
31
The 'Staff, etc' worksheet:
32
1This is largely self explanatory.
33
2This worksheet also contains information about people who have connections with WH but were not on the Staff.
34
35
The 'Charts' worksheet:
36
1This provides a graphical representations of the Totals data contained on the 'Houses' worksheet.
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
Loading...
 
 
 
READ ME
INDEX
Berners
Halls
Corners
Sheet1
Hansons
Johnstons
Orwell
Unknown
Staff, etc
Charts
Distribution
 
 
Main menu