Grave memorial Chart 

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].

00 - Chart - cemetery for Hanlon family name

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.

09c - Chart - cemetery for Hanlon family name - duplicate

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.

 

 

This slideshow requires JavaScript.


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.

example of list of tree people


Two tools on one blog post is my spring deal for my readers.

Thank You

Jose


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

owner: josemunoz2546

link: https://www.ancestry.com/family-tree/tree/159989349/family

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

By Jose A Munoz

Retired General Motors designer who now works on subjects dealing with genealogy. I create trees using items I find in old Google News Archive newspapers and I contact other tree owners notifying them about the news item concerning their relative and send them a link to the tree I created. I post a screen print of the news item on the tree for others to copy, so that my work will benefit others. Occasionally, I will post about the tree I created or the item that I found, always with a "how to" in-bedded in the post. I want my blog posts to help others with their family trees or with their genealogy experiences.

3 comments

      1. Thank you! Yes, just tired from lots of stuff going on the last couple of months. I’d like a little break now, please haha.

Leave a comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s