"Our Loose Ends" Genealogy Column
by Lynna Kay Shuffield
Houston, Texas

red, white & blue line


Printed in the Taylor Daily Press & Thorndale Champion
28 August 2003

Organize Your Census Research

Gary Minder of El Cajon, CA has created spreadsheets to use in MS EXCEL to help you to manage the mountain of census data you have on paper. To download FREE copies of the "Census Tools" form, visit his website: http://censustools.com/.

Electronic copies of your census data will allow you to manipulation, transport and backup the information. The census spreadsheets are also useful for those of you who take a laptop to the library or LDS Family History Center.

The census spreadsheets have a separate page for each census year from 1790-1930, the file also has forms for the Soundex (1880-1920), Slave Schedules (1850 & 1860), Mortality Schedules (1850-1880), etc.

This is a remarkable tool for tracking a single family through the years. The spreadsheets are blank except for the formatting on each page to match the particular census year data-fields, no actual census data is included.

Point of personal adaptation of these forms: I have added a column to allow for separation of the names to allow for two "name" columns, one for surnames and one for first names. When abstracting entire counties, it is sometimes very useful to be able to sort the census by first name.

Often, I have known the wife's maiden name and not the married surname. By sorting the census information in first name order; I have found a number of ladies and now know their married names!

Overall, I have found the forms to be a great benefit to organizing my research as well as various census projects to abstract information for counties of interest.

The spreadsheets were created using Microsoft Excel 97, however, I use Microsoft Excel 2000 and the forms worked well. The 1790-1870 census forms print on standard 8.5" x 11" paper and the 1880-1930 census forms print on 8.5" x 14" paper.

He offers census spreadsheets for Canada (1851-1901); English 91841-1891); Irish (1821-1911) and Scottish (1841-1891) which are similar to the U.S. Census forms.

Montgomery County, Texas History Published

"Historic Montgomery County: An Illustrated History of Montgomery County, Texas" by Dr. Robin Navarro Montgomery and illustrated by South Texas artist, Russell Cushman, will soon be released by the Montgomery County Genealogical & Historical Society (MCGHS). The society is are currently accepting orders, the price is $43.00, including shipping. Send your check to: MCG&HS P. O. Box 867, Conroe, Texas 77305-0867. For more information email: < mcghs@yahoo.com > or visit their website: http://www.rootsweb.com/~txmcghs/.

POW & MIA Symposium in Houston

On Saturday, Sept. 20, 2003, the Dept. of Mexican-American Studies at the University of Houston will present a "POW-MIA Military History Symposium" from 11 a.m. to 4 p.m. at the University Center, Houston Room. Attendance is free and open to the public.

Lynna Kay Shuffield will be one of the workshop presenters and will speak on "20th Century Military & War Dead Research."

The program will include presentations by: LTC Gordon Fowkes on "The Role of the Royal Army in the USA;" LTC John Perkowski on "The Defenders of Bataan and Corregidor;" Gary Rodgers on "Special Operations Group Missions;" Carter Hydrick on "Atomic Bomb Shell Games." Workshops will be held Researching your Military Records; Researching POW and MIA Records; Homeland Security and the Civil Air Patrol in the 21st Century; as well as how to obtain loans by the Texas Veterans Land Board.

For more information contact Elias Sanchez, e-mail < Elias.Sanchez@mail.uh.edu > or telephone AMVETS at 1-877-838-7999.

In this column, I will be glad to highlight and review any family history, genealogy, county history, or similar book, free of charge, if you donate a copy of the book or item. After it has been highlighted and reviewed, on a space available basis, it will be donated to the genealogy section of a library. You will receive an acknowledgment of the donation from the library. Mail item or book to me at the below address.

Lynna Kay Shuffield has written several books related to Texas genealogy and military history. She has spoken before numerous genealogy and veterans groups. Also, is a County Coordinator for the Texas GenWeb Project. Regretfully, she cannot help with individual genealogical research. Please visit the website for this column at: http://www.geocities.com/lks_friday/COLUMN-001.htm or if you have any questions, comments, suggestions for column topics, genealogy or historical society announcements, please contact her at: P. O. Box 16604, Houston, Texas 77222-6604 or e-mail: lksfriday@sbcglobal.net

red, white & blue line

Return to Main Page

This webpage was last created on 26 Dec 2003 and was last revised on __________

Copyright 1999, 2001, 2002, 2003 Lynna Kay Shuffield - All rights reserved.
P. O. Box 16604
Houston, Texas 77222-6604