CensusTools

Free Genealogy Spreadsheets!

Archive Census, Cemetery and Manifest Data

CensusTools Newsletter

October 2004

A Great Census Analysis Tool

If you have compiled census data from the early 19th century then you know how confusing it can be to make sense of the age bracket information. It would be great to have a way to automate the analysis of the age range data in the 1790-1840 records to pin down birth years of your ancestors.

Look no further than CensusMate, a very clever and useful spreadsheet tool from John Haynes. Using CensusMate, a researcher can enter census data from multiple census years into a single worksheet and then see the range of possible birth years narrowed down to a relatively narrow span. That might sound simple, but doing it manually is very complicated mental gymnastics, especially considering that the census age ranges vary in the years 1810-1830.

If you visit Censusmate you can see an interesting example with real data showing how a person identified as being born between 1765 and 1784 in the 1810 census is shown to have been born between 1765 and 1770 when data from 1820 and 1830 are analyzed in an easy to view graphical format.

John Haynes offers his CensusMate spreadsheet tool as a free download from his website.

1. Greetings from CensusTools - Change of Mailing Address
2. New Spreadsheets!
3. The Rhode Island State Census
4. Dawes Roll
5. Taking Requests
6. A Great Census Analysis Tool
7. Do you Use CensusTools Professionally?
8. A Request for Your Support