I don't often find a product that I love so much that I have to sing it praises but for the AncestryDNA Helper extension, I am making the exception.
Why do I love this product, basically because it took a task that I was trying to do manually and made it automatic. PLUS ... it added another aspect to the project that I didn't know how to do but wanted to do.
First of all, let me explain what I was trying to do with my AncestryDNA results. I was trying to figure out my mother's heritage. My mother died back in 2002 and a few years after her death, I confirmed that she was born before her parent's married and thus I questioned if her father was her biological father. I end up contacting the State of Wisconsin Child Services and confirmed that she was adopted by her step father (her mother's husband) but not until after she turned 18 years old and needed to submit her birth certificate to enroll in College. This is when my mother first found out and she never breathed a word of it to any of her nine children. Wisconsin is a closed adoption state and will not release her father's name without due cause. It is kind of silly since all the parties involved are deceased and it would be nice to know my heritage since I have been doing my genealogy for over 30 years.
Anyway, my mother was married twice, her first husband died and left her a widow with six children, she later married my father and had three more, with me being the youngest. Therefore I thought I would compare some of my siblings DNA with my DNA. I tested my oldest half brother and my youngest-older half sister along with one of my full sisters. I was inputting the results of our matches into a spreadsheet and then running a formula that compared my results against my siblings. It would compare the two columns and produce a report of all the matches in a third column. I ran this report as follows: ME vs my full sister, ME vs my half brother, ME vs my half sister, my full sister vs my half brother, my full sister vs my half sister and finally my half brother vs my half sister.
I was doing this all manually and you can see where there is room for data entry errors, because if I didn't type in the name of the tester exactly the same, it would not match. AncestryDNA Helper now can do that list for me and compare my list against my siblings. It does all the names, not just the few pages I was doing because it was such a big project.
Conclusions I came across are as follows: Matches of ME vs my half-siblings are probably my mother's ancestors. Matches of my full sister vs my half-siblings are probably my mother's ancestors. Matches of ME vs my full sister that don't match my half-siblings are more likely my father's ancestors but still could be my mother's ancestors and matches of half-siblings that don't match me or my full sister are more likely their father's ancestors but sill could be my mother's ancestors.
At least this gave me a spot to start my looking at the matches between ME and my full sisters vs my half-siblings. However, the hard part was to determine what might be my mother's biological family line. I was able to determine some of the lines through my mother's mother's family and that was real exciting. However, there were so many tree's that I didn't recognize names and wondered if they had any common names among all these trees that lead me to my mother's father's family. This is were AncestryDNA Helper has taken these matches one step further. It has a feature called "Ancestors of Matches". It has an Incidence Score which is the number of times the exact same name with a similar birth year from different DNA matches occurs in this ancestors list. This can help you discover clusters of matches who all share the same common ancestors. Maybe you link up to those people somewhere in that same family or maybe it's just a coincidence but this might open up branches of your tree you haven't discovered yet.
To find out more information about this FREE extension, you read this correct, it is FREE at the following websites: http://www.itstime.com/AncestryDNAHelper.htm and http://www.itstime.com/download/AncestryDNAHelper_HowToUse.pdf
Now the scan can take a while, it took about 3 hours for each tester, but considering the time I was spending keying in all the names, running the excel matching formulas myself and it was only on a few pages of matches, I will take the computer doing the work over me any day. Plus for those of you who want to thank the creator for this wonderful tool, you can via PayPal. I am sending him a thank you contribution too, something I have never done before either.
This blog is a way for me to record my own research efforts with my family history plus any genealogy finds related to technology or genealogy websites.
Tuesday, March 10, 2015
Sunday, July 20, 2014
So many AncestryDNA matches.
I had my DNA test done through Ancestry and managed to get
my half-sister to also get her DNA test done. So now I have 277 pages of
matches and she has 168 pages of matches. With 50 hits per page, that is a lot of
matches.
So how do I go about comparing my matches with my sister’s
matches? Reason I want to compare is the fact that we only share one parent,
our Mother, this means these are her ancestors. Plus my mother was adopted by
her step-father and we have no idea of who her biological father is and I was
hoping to see some sort of common denominator.
Anyway, the problem to compare our matches, since Ancestry
doesn’t have a way to “Export” the list of matches; I had to manually key in
the names of the matches into an Excel Spreadsheet. Next problem, how many
names will I really going to compare? 168 pages is a lot of names. So I decided
I would go until my matches switched to a confidence level of low. This meant
13 pages of names. Therefore, I did the
first 13 pages of matches for my sister too, even though her confidence level
of low started around page 10. I wanted our list to be the same length.
Next, I did a search on the web to find a formula that would
compare the list of matches and I was lucky to find the formula. So my sister’s
matches were in column A and my matches were in column C. I keyed the formula
of =IF(ISERROR(MATCH(A3,$C$3:$C$651,0)),"",A3) in Column B3. I copied
the formula down until line 651.
As you can see it worked great to identify the matches and I
can see exactly which page the match was from too. Since I keyed in the
matches, starting with page 1 and working to page 13; I went into each of her
matches, and Starred the match and recorded a note.
However, I wanted to record the matches for me too. So I had
to modify the formula for Column D and thus used
=IF(ISERROR(MATCH(C3,$A$3:$A$651,0)),"",C3). I placed that formula in
D3 and copied it down to line 651. This allowed me to identify the same
matches, but now I know what page the results could be found for my results. I
Starred my matches and recorded a similar note.
I am not sure if all this work is going to help me much, but
it makes me feel as if I am trying to discover our common matches.
On my wish list from AncestryDNA is as follows: The minimum is
to be able to export a list of our DNA matches such as all our matches, or only
those we have starred, or just the new matches. My big dream wish is that there
would be a way to compare my matches with any other match from my list. For
example, I would like to know if I have any common matches with kathyval. By comparing our common matches, I might be
able to figure out what branch we have in common by checking out all our common
matches.
Subscribe to:
Posts (Atom)