North Wiltshire Online Census Project
“ Bringing YOUR ancestors to YOU, free of charge ! ”
Project Details
Pope's Website
Roll of Honour


Structure of the Spreadsheet

Looking at the sample CENSDEMO file, opened in your Spreadsheet routine:-
It will be seen that the Standard requires 25 Columns (A to Y), and some Census Pieces may contain over 5000 Rows.
First Row: Only TWO cells are used:
A1   In this example contains "RG121798"
This identifies the Census Piece being worked and is empty on the "BLANK" Set-Up file.
You will need to enter here (without any spaces) the Code for the Census Year (RG12 = 1891) and the Number of the Piece being Transcribed. This essential information is determined from the fiche supplied. Do not include any extra characters, as in RG12/1798!.
The resulting entry will be the name you must use for your transcription work; for example, this sample file would be "RG121798.CSV"
When the Piece is fully transcribed you will be required to forward a copy of this file, saved specifically as "Comma Separated" format (.CSV) to be converted.

B1   Should record the Registration District Number if this is known, but may be left blank if you have doubts.
After entering the required data into A1 and B1, Save the file, under its new name, in the natural format of your Spreadsheet routine. This will avoid the need to re-structure the file each time you re-start work.
Second Row: Within the limitations of "cell width" imposed by FreeCEN each cell names the type of information to be entered in each column.
The Standards necessary for each field are described in detail in "Field Descriptions" .
Third Row: Each cell is filled with spacing characters to establish the Maximum capacity of each field.
Any extra characters entered beyond these limits will be truncated at the conversion stage, possibly resulting in loss of important information.
As a rough guide, the # sign denotes that a numeric input is expected, although letters do not necessarily exclude the use of numerals in certain fields. (See "Field Descriptions")
Subsequent Rows: NOTE that the FOURTH Row represents the first row of data that you will enter and
IT IS IMPORTANT that this row is correctly established before proceeding to other rows.

Here is a detailed explanation of the example file "CENSDEMO.CSV"
Colums A-D will (at conversion) be copied as a Header to subsequent records from this initial setting, changing only when any cell in these columns is changed.
Thus whatever is entered in A4 and B4 will be repeated down the list until a new Enumerator or District is started; similarly C4 will be repeated until a new Folio Number is Entered, and D4 repeats until a new Page...
It will be considered a good habit (although not essential) if cells A to D are typed in full for the start of each New Census Page - thus proving that you have checked that this data has not changed from the previous page.

A value must be entered at the start (but only at the start) of each New Household. (See Row 90)
This will normally be from the "Schedule" column of the census page. If there is no Schedule Number on the census then we enter zero, as in Row 87, or Row 90

The 1841 Census did not use Schedule Numbers; therefore a zero must be entered at the start of each New Household.

COLUMNS F to H comprise the Street Address information and will be copied downward (at conversion) for the relevant Household.
A change in Schedule No (column E) determines whether a new address should be entered or that these cells should be left empty (according the the Census film).

Columns I to Y must be completed individually where appropriate, for every member of the household. There will be many empty cells.

If you decide to "Cut & Paste" or "Fill Down" for repeated entries within a Household (such as Surname or Birthplace) - do this with care!

Now please load "Field Descriptions" and examine it with CENSDEMO still on the background....

Comments regarding the example file CENSDEMO.CSV
Column Row No Comment/
A1 Contains the Year Code and Piece Number. This will be the filename under which you save and forward your work
B1 Contains, for identification purposes, the Registration District Number or Name (can be found on the microfiche typewritten heading, or on the first page of an Enumerator's book.
A - D4 These columns MUST be entered on Row 4 and, ideally, at the start of each new Census Page
E87,91,23 Must contain an entry for each New Household or Premises.
Note the use of 0 (zero) in rows 87 and 91 where the enumerator did not allocate a Schedule Number.
Note also row 92: Schedule No 23 has not been used by the enumerator, but must be accounted for
E - F68,74 House numbers are often omitted. Note rows 68 & 74 for ways of dealing with non-standard house identification.
G76 The Address may be a "normal" street name, or the name of a farm or building, or even of a whole hamlet or village. At the start of each Household: enter the Address provided (ditto marks to be written out in full), or leave blank (row 76)
H87,92 The use of column H is discussed at length under "Field Descriptions"
If column H contains u,b,v,or n then all other columns I - X should be left empty!
I. Option:You may type everything in lower case letters; the conversion routine will provide Capitals where needed.
K, P, S, V. Use to indicate any doubts about what has been entered. Enter only an 'x' or leave empty.
L, M, N. Note the use of "standard abbreviations".
O65 - 75 See "Field Descriptions" for details of age unit requirements.
You do not need to enter 'y' for age in years
U52,78 Birthplace: A - (hyphen/dash) is required if there is no information present.
Row 52 The enumerator had written only "London"; we do not know whether he meant "London City" or the "London County".
Row 78 The only information available is born "Cornwall".
Y4,23 Use this limited space for short notes to explain why you have set any "Query Flags"
Any message longer that 44 characters and spaces will be clipped at conversion - valuable comments could become not understandable!

If larger notes need to be passed to the Checker: Open (e.g. in 'NotePad') a text file to which you can progressively add comments about the work. SAVE this file regularly in text format as "MYNOTES.TXT"

Now please load
"Field Descriptions" and examine it with CENSDEMO still on the background....


© 2006 - 2009 North Wiltshire Online Census Project