Providing practical, down-to-earth advice for family historians since 1995, online since 1985.


1995-2009 Pat Richley HOME | Ask | Blog Right-click to copy RSS feed URL. Add to My Yahoo BookShelf | ContactLessons | Listen to Podcast media RSS feed
Read most 1995-2006 articles | Search | Subscribe

US Census Spreadsheets

Date: 01/24/2001 7:14:31 AM Eastern Standard Time
From: ehgaulin@worldnet.att.net  (Edward H. Gaulin)
DearMYRTLE,
Here's something to take a peek at - a very useful US Census spreadsheet. See URL and explanation below.


*******************
Subject: [GM-L] Census Spreadsheet Website
Date: 
Mon, 22 Jan 2001 20:32:19 -0000
From: "Gary Minder" sdkhaki@hotmail.com 
To: GenMassachusetts-L@rootsweb.com 

Last week I posted a note offering to share a U.S. census spreadsheet that I developed so that I could get out from under my unruly mountain of census data paperwork. The response was overwhelming. 

To date I have e-mailed over 600 copies of my spreadsheet and I can't keep my inbox empty for more than a few minutes! I have also received scores of kind e-mails with glowing praise of the spreadsheet. I knew I was tired of not having a good way of organizing census records but I had no idea that so many others were in the same boat.

To reduce the load and to allow me to get the word out to more genealogists, I have created a web site where anyone can go to download the  spreadsheet. The URL is:
http://homepages.rootsweb.com/~minder/  
and you can also get look at some screen shots of the spreadsheet and read a Frequently Asked Questions list that I created to answer common questions. To top it off I created a discussion forum where users can ask questions and get answers (a much more efficient way of getting info out than answering individual e-mails.)

In less than 24 hours online, the website has gotten over 900 visits. If you missed my notice the first time, please stop by the website and take a look.
Gary Minder sdkhaki@hotmail.com
 


DearED,
I checked out the web site, and clicked to view the Microsoft Excel workbook:
http://homepages.rootsweb.com/~minder/census.xls 

Note the worksheet tabs for each of the US Federal Census years. As you can see from these two screen shots, Gary has provided CLEAR, accurate census extraction forms. 



The forms for other census years are clearly labeled at the bottom of the first Excel worksheet as shown below:

You may RIGHT CLICK on the web screen to save the census worksheet, though you'll need Excel97 or greater to view and use the file. 

I recommend when opening the file (worksheet) that you IMMEDIATELY rename the file to preserve the original blank worksheets. You can rename by clicking FILE on the Excel menu bar, then selecting SAVE AS, and providing a new name for the file. If I were doing the work on Ferd GOERING's family throughout the four census years I've discovered him, I'd call the file GOERINGf.  Where I have an entry for his son as head of household, I save the file as GOERINGch for Charles Henry GOERING. 

Those new to Excel will recall that to see other worksheet tabs (1840-1920), you'll want to click the "NEXT" button found in the extreme lower left of the Excel workbook (circled in red above.)

Happy family tree climbing!
Myrt     :)
DearMYRTLE,
Your friend in genealogy

 

1995-2009 Pat Richley HOME | Ask | Blog Right-click to copy RSS feed URL. Add to My Yahoo BookShelf | ContactLessons | Listen to Podcast media RSS feed
Read most 1995-2006 articles | Search | Subscribe

Google
www DearMYRTLE.com