Lisa, one of the members in the FaceBook group; “Otsego County, New York, History and Genealogy”, asked for help with her tree.
I created a tree on Ancestry dot com to help find records through hints.
I was able to find obits on the Hanlon family FindAGrave memorial pages and in order to keep track of who had an obit and who didn’t have an obit, I created an Excel chart [See slide show below, that takes the viewer to each column, to help identify the various area].
The creation of the chart and filling out the columns showed me some extra information:
1. there are duplicate or possible duplicate memorial pages
2. family members are buried in different cemetery or states.
I thought the chart might help my blog readers organize their own family tree records.
In order to figure out which member of the Hanlon family had an obit on a FindAGrave page, I created a chart that helps organize the information and helped identify duplicate FindAGrave memorial pages.
Chart for the family of the “Hanlon” name
showing birth and death dates, memorial #
shows also if there is or is no obit on the memorial page
shows also cemetery name, location and link to memorial page
columns on the MS Excel page:
A = Name
B = birth date
C = death date
D = FindAGrave memorial number
E = has an obit on memorial page
F = NO obit on memorial page
G = cemetery name
H = -space-
I = state where the cemetery is located
J = -space-
K = LINK
S = full name of cemetery and location
[Note this column is not shown on screen prints]
below the names and information on the chart
there are lines in column B
containing the full name of cemetery and location
This format is used so that all information will fit on one screen print.
The following slide show will identify the column to make it easier to understand.
I hope this blog post, about this Excel chart, will help you organize your tree.
Another use of Excel is to organize the list of people on a tree:
You can easily copy the list of people on the tree through the Ancestry dot com tree view and top left corner button “List of People”. Once you copy the list, paste it onto the first box “a1” in a blank Excel file and the information will fall into place in individual columns. Once the information is on the page you can move the width of the column to allow more information per box.
Two tools on one blog post is my spring deal for my readers.
PS. If you would like to see the tree, here is the 0 – a tree created file:
name: Joseph A P Bailey – FB query – New York – Family Tree
30 names on tree:
Albertson, Bailey, Brazda, Clark, Connell, Cross, Fern, Freese, Freeze, Frees, Frese, Graham, Hanlan, Hanlon, OHanlon, Harvey, Holland, Hutton, Jones, McDonough, McEwan, Nevins, O Hanlon, Reynolds, Stafford, Telfer, Ten Broeck, Ten Brook, TenBroeck, Willsey