While watching today’s Ancestry.com webinar and seeing Crista Cowan‘s census table, I noodled around on the Google and created a quick version for download. Just enter names, birth and death years and it will calculate the persons age during each census from 1850 to 1940.
Act now and it will also gray out cells for censuses in which the person was not around!
Below is a static version – apparently you can embed Google spreadsheets, but they aren’t editable. Visit this link to use a live version of it.
Until relatively recently, there was no way to lock particular cells in a Google Docs spreadsheet. They have reported that cell protection now has been implemented – but I have found it doesn’t really work properly, thusly I am leaving the whole sheet editable for now.
So, Please be sure just to change the data in the green cells if you try it out!
(Don’t worry, I’ve got copies in case the sheet gets borked. And hey you – YES YOU, we all know you don’t have any Walter Melons in you tree so no funny names, Mister Smartypants.)
You can also download a copy to use in your own Excel or Open Office software by clicking File… Download As… and saving it to your computer.
Makes a great stocking stuffer!