The 1891 Nottinghamshire Census Project

Example of a Spreadsheet using SSCENS

Please click on one of the following Links to go to that Page

FreeCEN Home Page

Notts 1861 Census Status Page

Spreadsheet SSCENS Instructions

FLN & DEN 1861 STATUS

FLN & DEN 1871 STATUS

FLN & DEN 1891 STATUS

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 (= 3 unoccupied) 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 Y.
Please remember that for the 1891 Census we have to fill in the Occupational Status. i.e. Column R
It is rare to find entries written in Welsh but it does happen and for the correct handling of those entries please refer to the Coordinator.
The first 3 rows are essential and should not be removed or altered
It is not necessary to type in lower-case, but it is faster, and the conversion process prior to checking will insert uppercase letters wherever necessary. Feel free to use whichever mix you prefer.
It recommend the use of a full-stop after abbreviations such as Robt., Eliz. or Llanfair D. C. and U.S.A.
The first rule of transcription for us is "as is" - complete with misspelled names and places.
If there is room for doubt you could offer an alternative in the Notes field (Column Y).
Remember that each transcript goes through the processes of checking, validation and post-validation prior to upload.
If you want to leave longer notes a simple text file RG######.TXT with the piece number as the filename can be sent on with the data file. These notes will not be uploaded but will be available to the checker and Validator.
The Spreadsheet needs to be saved as a CSV file to enable you to use the CSVCHECK programme.
However, to enable you to use the FORMATS and keep the columns in the correct widths while Transcribing, saving the file as an XLS (Or whatever spreadsheet application you use) is most beneficial. You can save it again as a csv when you want to use CSVCHECK at any stage.

Return to the top of the Page