|
Example of a Spreadsheet
using SSCENS |
FreeCEN
Index Page
Notts
1891 Status Page
Notts
News Letter
FreeCEN
Home Page
Middlesex News Letter
Middlesex 1891 Status Page
Notts 1861 Census Status Page
Lancashire
1891 Project Page
Spreadsheet
Instructions
Example of a Spreadsheet
| RG12/2642 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Civil
Parish |
ED |
Folio |
Page |
Schd |
House |
Address |
X |
Surname |
Forenames |
X |
Rel. |
C |
Sex |
Age |
X |
Occupation |
E |
X |
CHP |
Place
of birth |
X |
Dis. |
W |
Notes |
| abcdefghijklmnopqrst |
###a |
####a |
#### |
###a |
####a |
abcdefghijklmnopqrstuvwxyzabcd |
X |
abcdefghijklmnopqrstuvwx |
abcdefghijklmnopqrstuvwx |
X |
abcdef |
C |
S |
###a |
X |
abcdefghijklmnopqrstuvwxyzabcd |
E |
X |
abc |
abcdefghijklmnopqrst |
X |
abcdef |
W |
abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqr |
| Tuxford |
1 |
5 |
1 |
1 |
|
Eldon
Street Mill Mang |
- |
LONGBOTTOM |
Hugh
L |
- |
Head |
M |
M |
46y |
- |
Miller |
R |
- |
LIN |
Claypole |
- |
|
|
|
| |
|
|
|
|
|
|
|
LONGBOTTOM |
Annie |
- |
Wife |
M |
F |
41y |
- |
|
|
- |
NTT |
Edingley |
- |
|
|
|
| |
|
|
|
|
|
|
|
LONGBOTTOM |
Arthur
E |
- |
Son |
S |
M |
22y |
- |
Miller |
E |
- |
NTT |
Farnsfield |
- |
|
|
|
| |
|
|
|
|
|
|
|
LONGBOTTOM |
Albert
K |
- |
Son |
S |
M |
21y |
- |
Miller |
E |
- |
NTT |
Tuxford |
- |
|
|
|
| |
|
|
|
|
|
|
|
LONGBOTTOM |
Bertha |
- |
Dau |
S |
F |
18y |
- |
Mothers
Help |
|
- |
NTT |
Tuxford |
- |
|
|
|
| |
|
|
|
|
|
|
|
LONGBOTTOM |
Herbert
E |
- |
Son |
S |
M |
17y |
- |
Draper |
E |
- |
NTT |
Tuxford |
- |
|
|
|
| |
|
|
|
|
|
|
|
LONGBOTTOM |
Sydney |
- |
Son |
S |
M |
15y |
- |
Miller |
E |
- |
NTT |
Tuxford |
- |
|
|
|
| |
|
|
|
|
|
|
|
LONGBOTTOM |
Clara |
- |
Dau |
S |
F |
14y |
- |
Domestic
Nurse |
|
- |
NTT |
Tuxford |
- |
|
|
|
| |
|
|
|
|
|
|
|
LONGBOTTOM |
Walter
H |
- |
Son |
- |
M |
13y |
- |
Scholar |
|
- |
NTT |
Tuxford |
- |
|
|
|
| |
|
|
|
|
|
|
|
LONGBOTTOM |
Ethel |
- |
Dau |
- |
F |
8y |
- |
Scholar |
|
- |
NTT |
Tuxford |
- |
|
|
|
| |
|
|
|
|
|
|
|
LONGBOTTOM |
Lilian |
- |
Dau |
- |
F |
1y |
- |
|
|
- |
NTT |
Tuxford |
- |
|
|
|
| |
|
|
|
2 |
|
Eldon
Street Mill Mang |
u |
|
|
|
|
|
|
|
|
|
|
- |
|
|
- |
|
|
|
| |
|
|
|
3 |
|
Eldon
Street Mill Mang |
- |
STORY |
Mary |
- |
Head |
W |
F |
55y |
- |
Living
On Own Means |
|
- |
NTT |
Retford |
- |
|
|
|
| |
|
|
|
|
|
|
|
STORY |
James |
- |
Son |
S |
M |
34y |
- |
|
|
- |
NTT |
Retford |
- |
|
|
|
| |
|
|
|
|
|
|
|
STORY |
Annie |
- |
Dau |
S |
F |
20y |
- |
Mothers
Help |
|
- |
NTT |
Tuxford |
- |
|
|
|
| |
|
|
|
4 |
|
Eldon
Street Scotland Bank |
- |
SMITH |
John |
- |
Head |
M |
M |
40y |
- |
Agricultural
Labourer |
E |
- |
NTT |
Tuxford |
- |
|
|
|
| |
|
|
|
|
|
|
|
SMITH |
William |
- |
Son |
- |
M |
11y |
- |
Scholar |
|
- |
NTT |
East
Markham |
- |
|
|
|
| |
|
|
|
|
|
|
|
SMITH |
Harriett |
- |
Dau |
- |
F |
6y |
- |
Scholar |
|
- |
NTT |
East
Markham |
- |
|
|
|
| |
|
|
|
5 |
|
Eldon
Street Scotland Bank |
- |
MITCHELL |
William |
- |
Head |
M |
M |
43y |
- |
Brickmakeer |
E |
- |
NTT |
Tuxford |
- |
|
|
|
| |
|
|
|
|
|
|
|
MITCHELL |
Maria |
- |
Wife |
M |
F |
41y |
- |
|
|
- |
NTT |
Sutton
In Trent |
- |
|
|
|
| |
|
|
|
6 |
|
Eldon
Street Scotland Bank |
- |
COLTON |
John |
- |
Head |
M |
M |
47y |
- |
Agricultural
Labourer |
E |
- |
NTT |
Egmanton |
- |
|
|
|
| |
|
|
|
|
|
|
|
COLTON |
Annie |
- |
Wife |
M |
F |
62y |
- |
|
|
- |
NTT |
Collingham |
- |
|
|
|
| |
|
|
|
7 |
|
Eldon
Street Scotland Bank |
- |
HANDLEY |
Sarah
Ann |
- |
Head |
M |
M |
45y |
- |
|
|
- |
NTT |
Retford |
- |
|
|
|
| |
|
|
|
|
|
|
|
HANDLEY |
Frederick |
- |
Son |
- |
M |
11y |
- |
Scholar |
|
- |
NTT |
Tuxford |
- |
|
|
|
| |
|
|
|
|
|
|
|
HANDLEY |
Robert |
- |
Son |
- |
M |
9y |
- |
Scholar |
|
- |
NTT |
Tuxford |
- |
|
|
|
| |
|
|
|
|
|
|
|
HANDLEY |
Susan |
- |
Dau |
- |
F |
7y |
- |
Scholar |
|
- |
NTT |
Tuxford |
- |
|
|
|
| |
|
|
|
8 |
|
Eldon
Street |
u |
|
|
|
|
|
|
|
- |
|
|
- |
|
|
- |
|
|
|
| |
|
|
|
9 |
|
Eldon
Street |
- |
JONES |
Thomas |
- |
Head |
M |
M |
56y |
- |
Bricklayers
Labourer |
E |
- |
MON |
Chepstow |
- |
|
|
|
| |
|
|
|
|
|
|
|
JONES |
Emma |
- |
Wife |
M |
F |
57y |
- |
|
|
- |
LND |
City
Road |
- |
|
|
|
| Tuxford |
1 |
5 |
2 |
10 |
|
Eldon
Street |
- |
LANGHTON |
Joseph |
- |
Head |
M |
M |
40y |
- |
Pig
Killer |
E |
- |
NTT |
Tuxford |
- |
|
|
|
| |
|
|
|
|
|
|
|
LANGHTON |
Martha |
- |
Wife |
M |
F |
50y |
- |
|
|
- |
LIN |
Martin |
- |
|
|
|
| |
|
|
|
|
|
|
|
WOODTHOP |
Rachel |
x |
Niece |
S |
F |
22y |
- |
Domestic
Servant |
|
- |
LIN |
Horncastle |
- |
|
|
Query
Spelling of urname |
| |
|
|
|
11 |
|
"the
Cut" Cottages |
- |
BILLYARD |
John
Thomas |
- |
Head |
M |
M |
38y |
- |
Bricklayers
Labourer |
E |
- |
NTT |
Markham
Moor |
- |
|
|
|
| |
|
|
|
|
|
|
|
BILLYARD |
George
W |
- |
Son |
- |
M |
9y |
- |
Scholar |
|
- |
DBY |
Masbro |
- |
|
|
|
| |
|
|
|
|
|
|
|
BILLYARD |
Annie
E |
- |
Dau |
- |
F |
6y |
- |
Scholar |
|
- |
NTT |
Tuxford |
- |
|
|
|
| |
|
|
|
|
|
|
|
DUNLEVEY |
Louisa |
- |
Servnt |
M |
F |
42y |
- |
Housekeeper |
|
- |
LIN |
Lincoln |
- |
|
|
|
| |
|
|
|
12 |
|
"the
Cut" Cottages |
- |
THOMPSON |
Mary |
- |
Head |
W |
F |
75y |
- |
Retired
Publican |
|
- |
NTT |
Boughten |
- |
|
|
|
| |
|
|
|
13 |
|
"the
Cut" Cottages |
- |
TURNER |
Thomas |
- |
Head |
M |
M |
49y |
- |
Agricultural
Labourer |
E |
- |
NTT |
Blidworth |
- |
|
|
|
Please note the following.
- If there is no Schedule number for the Un-occupied
premises please use a 0 (zero) Then enter a u in Column H.
- Please enter a line for each un-occupied. So if the
Census page say 3u, then
repeat the entry 3 times on 3 rows.etc etc.
- If there is no relationship
shown , Column L, on the Census page, always use the 'DEFAULT'
. This is always a hyphen.
It is always entered on the spreadsheet as '-.
the ' will disappear after you press enter.
This will stop the 'Cell' becoming a calculation.
- If there is no Forename
shown, Column J, on the Census page, always use the 'DEFAULT'
. This is always a hyphen.
It is always entered on the spreadsheet as '-. the ' will
disappear after you press enter.
This will stop the 'Cell' becoming a calculation.
- If there is no SEX
shown , column N ,on the Census page, always use the 'DEFAULT' .
This is always a hyphen.
It is always entered on the spreadsheet as '-. the ' will
disappear after you press enter.
This will stop the 'Cell' becoming a calculation.
- The DEFAULT for the age column is always 999.
So if no age is given please always type 999.
- Please DO NOT USE the ? mark in ANY
COLUMN other than the last Column. The NOTES column.
- Please remember that for the 1891 Census we
have to fill in the Occupational Status. i.e. Column R
Return to the top of the Page
|