* Census Record Summary By Household

News and Announcements from the Family Historian World
Post Reply
avatar
admin
Famous
Posts: 245
Joined: 30 Aug 2013 07:52
Family Historian: V6
Contact:

Census Record Summary By Household

Post by admin » 23 Nov 2004 13:11

I store all my census copies alphabetically by Head of Household in one multi-ring plastic pocket per household. At the front of each pocket is my Census Record Summary By Household. This is in Excel format, which volunteers certain repetitive data, and makes it easy to change font size by individual cell where necessary.

I find the sheet invaluable for highlighting 'missing persons' between one decade and the next, and for giving a 'consensus view' of recorded ages when there are inconsistencies across the decades. When the younger generation marry, it is easy to cross-reference them to their new household Record Summary. Notes of this nature can be entered by dragging across a number of cells, and hitting the 'merge and centre' icon on the toolbar.

I put names in bold, where members of the household are ancestors (as distinct from relatives).
Sample Sheet
Image
The sheet has coloured lozenges, representing Birth, Marriage and Death certificates. These can be copied and placed against the respective members of the household, as a useful reminder that their certificates are on file. To use these, place your cursor over the appropriate lozenge until the 'cross-arrows' appear, then right click and select 'Copy' from the pop-up menu. Then right click next to the name of the appropriate person on you sheet, and select paste. You can drag the copied lozenge around to wherever you want it.

The blank 'Master' is in 'Read Only' format (to avoid inadvertently corrupting it), and should be filed as such. If you want to try filling one in, call up the Master, and then 'Save As' (say) 'Census Record Summary, Joe Bloggs, ID 43,' I find it useful to include the ID number that is created within FH, to avoid confusion where there are two or three people of the same name. In such circumstances, I also include the year of birth in the file name. The new file is no longer 'write-protected' and can be altered in any way you choose. For example, I went for six years in order not to be too cramped for width, but of course you may want to enter some 1841 data or, if we live long enough, some 1911 data. You can edit the column headings to suit the circumstances (e.g. 1841 to 1891), on the basis that the longevity of most households (as distinct from individuals) can be accommodated.

You can only enter the recorded occupations of the head of household over the decades, but of course the occupations of other members of the household are on the individual census records.

If anything isn't clear, just drop an email to paul.baines1@virgin.net, and I'll try to help.
Download the file

avatar
ireneblackburn
Superstar
Posts: 289
Joined: 07 Apr 2005 13:40
Family Historian: V6
Location: Newcastle upon Tyne

Census Record Summary By Household

Post by ireneblackburn » 02 Jun 2005 19:43

This is excellent. I only wish you had included 1841. I have created several records and it has made me realise that I had a few more gaps than I thought.

A wonderful aid!

avatar
Yasmin
Silver
Posts: 5
Joined: 30 Sep 2003 18:01
Family Historian: None

Census Record Summary By Household

Post by Yasmin » 12 Feb 2006 20:16

This is a great way to track any missing census details
A great idea and really helpful

avatar
suzygirl101
Silver
Posts: 9
Joined: 06 Jan 2006 02:41
Family Historian: None

Census Record Summary By Household

Post by suzygirl101 » 27 Feb 2006 23:09

I have been unable to use the link to download this spreadsheet. Is someone able to email it to me please?

SuzanneC@chemcolour.co.nz

Many thanks!

Suzanne
Auckland, NZ

avatar
MarkA
Silver
Posts: 6
Joined: 09 Jun 2006 01:12
Family Historian: None

Census Record Summary By Household

Post by MarkA » 04 Sep 2006 04:51

This link points to:

http://www.fhug.org.uk/programs/FHPageN ... ss-Ref.pdf

Could someone please relink the file so I could get a copy?

Thanks in advance.

avatar
admin
Famous
Posts: 245
Joined: 30 Aug 2013 07:52
Family Historian: V6
Contact:

Census Record Summary By Household

Post by admin » 04 Sep 2006 08:44

The numbers change as new items are added, link should work now.

User avatar
gerrynuk
Megastar
Posts: 565
Joined: 25 Apr 2007 09:21
Family Historian: V6
Location: Welwyn Garden City
Contact:

Census Record Summary By Household

Post by gerrynuk » 25 Apr 2007 09:33

If you save it as an Excel Template you don't have to make it read only and it will always be available.

Post Reply