Legacy Family Tree, Sunday afternoon Genealogy Fun

Finding source citation statistics in Legacy Family Tree

This week in Saturday Night Genealogy Fun on Randy Seaver’s Genea-Musings blog, the topic is source citations – Saturday Night Genealogy Fun – Which Source Have You Used the Most?

The questions asked were:
1) Have you done a good job of citing your sources in your genealogy management program or online family tree?  How are you doing?  How many source citations do you have, and how many people are in your tree?  What is the sources to persons ratio?

2)  Which master source (e.g., 1900 U.S. census, Find A Grave, specific book, etc.) do you have the most citations for?  How many?  How did you figure this out?

These are my answers:

1) Since I’ve been researching for quite a while now, and I’ve been using a computer for over 15 years, my source citations aren’t very consistent.   This has been compounded by moving my file between genealogy programs, and restoring my file from gedcoms, and has resulted in multiple master sources for the same master source.   Rather than try and fix up my existing tree (actually, I have two trees, one for all my research, and another to share on the internet), I have decided to start over.  This way I will be able to set up the sources properly. In the meantime, I need to work of the trees, I have.  Since I have two trees. I’ve decided to base my answers on the tree I share on the internet.  I have 23,343 source citations from 3260 master sources, and I have 10,965 individuals in my tree.  My source to persons ratio is 1.841404.  I use Legacy Family Tree Version 8 Deluxe Edition, and to find this information I selected File from the top menu, and then File Properties.

Family File Information
Family File Information

2) The master source I have the most citations for is the Death Index Victoria 1921-1985 CD, with a total of 1832 source citations. The next highest was the Pioneer Index Victoria 1836-1888 with 1347. I use Legacy as my family tree program, so to find this information, I went to Report, Other Reports, Source Citations, and then checked the box Master Sources and Citation Summary Counts.

Source Citation Report
Source Citation Report

Since I didn’t want to search through over 3000 master source citations to find the ones with the highest counts, I found another way of finding this information. I saved the report as a PDF file, and then selected the whole PDF file, copied it to the clipboard and pasted it into Microsoft Excel.

Copy from PDF
Copy from PDF

I then sorted the information alphabetically, to bring all the individual counts together.

Sorting in Excel
Sorting in Excel

I then went to Data on the top men and chose Text to columns from the ribbon to separate the number from the word Individuals.  Since the Individuals: section was all the same length, I chose fixed width, and then next.

Text to Columns in Excel
Text to Columns in Excel

In the next step the divider line was in the correct position, I was able to click finish.

I then sorted this section by column B, from smallest to largest.


Then I scrolled down to the end of the list to find the highest number.  In order to find the master source that this individual count belonged to, I went back to my PDF file, and selected in the Edit menu Find


I then typed in the highest number from my individual counts, to find the master source it belonged to


Since I had more than one master source set up for these two sources, I then added together the count from each of these master sources to get the totals listed.

This may seem a complicated system, but it was easier than manually checking the report.

Leave a Reply

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