My tip sheet, Using Excel to Move Your Research Forward is now available on Lulu.com.
As I think about things to write for my blog, it reminds me to go back to my research and recheck data, see where I am on my goals, what letters I need to write to obtain new information, and find out what is still missing that I want to discover.
My latest project idea came about after I wrote about Naturalization and Women last week. I thought it would be a good idea to make an Excel file with the names of the people in my main lines (to start), their date of birth, date of immigration, date of Declaration, date of Naturalization, and occupation.
As I look at the data, I have 24 people in my main lines who immigrated. Of those I have dates of immigration for 22. Of those, I have iffy dates, meaning I put Abt. 1880 as a date, for two. Looking more at the data I see I have very few Declaration and Naturalization dates recorded. Why is that? Did I not enter them in my database? Did I only have a Naturalization date and no Declaration date? I think I need to go back through my paper files and try to answer some of these questions. If I do not have a record, it is time to search for one or see if I have a letter from IRAD (Illinois Regional Archives Depository) stating no record was found.
I listed occupation in my file because I would like to expand this and add children to the immigrants and trace the occupations of those children. Did most of the male children follow in the footsteps of their father, or choose a different trade? Did the women follow in their mother’s footsteps and become wives and mothers?
I love Excel sheets, can you tell since this is my second post about them and I am using them for several purposes? I have another file specifically for Burial listings. I created a Burial report in my Family Tree Maker software and exported it to Excel. The file contains the person’s first and last names, date of death, cemetery name, location of grave. This of course is an ongoing project to find as many grave sites as I can to fill in the gaps. I have 2,336 people in my database so far and grave sites for only about 95 of them. Time to start researching more death certificates and obituaries and asking the family about some of the more recent people who have died.
What is your latest project for your research? Are you filling in gaps with different data than I am looking at? Have you created other types of reports and spreadsheets to capture missing data? I would love to hear about it. I’m always looking for new ways to add information to the lives of my ancestors.