Tuesday, March 10, 2015

AncestryDNA Helper extension for the Chrome browser

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.


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.