![spreadshhet for my dna matches spreadshhet for my dna matches](http://www.genealogyjunkie.net/uploads/2/0/8/4/20849548/5778829_orig.jpg)
- #Spreadshhet for my dna matches for free
- #Spreadshhet for my dna matches how to
- #Spreadshhet for my dna matches download
This may provide clues on where to look if there is a connection. The next step will be to compare their family trees and their surnames if they have listed any. If only DNA could wave a national flag or sing an anthem, that would help a genealogist out. I can conclude that his DNA at chromosome 21 and those individuals who match us there will come from the Jones/Hayward (Welsh/Australian) or the Kelly/Dolan (Co. My new 3rd cousin does not come from those sides of the tree. The others are probably 5th cousins or further back.Īs I said yesterday, I eliminated the Jackson (England), Mazeres/Lassalle (France), and Pacheco/de Braga (Azores) lineages from this connection. I am more closely related to my new 3rd cousins than the others. The match on 21 hints that we all come from a certain line though are related at different degrees. The other two people do not have a match in chromosome 21. Of the 7 people who we have in common, 5 match my new cousins on one chromosome (21) in the same segment. My new 3rd cousin matches me on a few segments. I added a column to my spreadsheet for “chromosome match” and I entered the sequence numbers. I used the FTDNA chromosome browser for this. My next step was to identify which segments we match on. Without revealing the person’s name for privacy reasons, this is an example of what my spreadsheet looks like: I then imported the CSV file LibreCalc (spreadsheet program that is part of LibreOffice). I did this for the new 3rd cousin and our shared matches.
#Spreadshhet for my dna matches download
In FTDNA, you can download specific groups of matches to a CSV file and import it into a spreadsheet.
![spreadshhet for my dna matches spreadshhet for my dna matches](https://i.pinimg.com/736x/e4/27/64/e42764710352aa0012328c6fc368d580.jpg)
The first person was my new 3rd cousin that I figured out yesterday. I am starting with the people who I have the highest level of matches with. This could mean the difference between showing that we are related through the same line or simple share DNA with the same people. I needed to see which people match who and if those matches are on the same chromosome sequence or a different one. When my FTDNA results show that I match someone and we both match several other people, it does not necessary mean that we share the same chromosome sequences. How do I make sense of it all?Īfter working on the problem in this post, I decided it was time to organize my results into blocks that made more sense. I connect to different members at different degrees.
#Spreadshhet for my dna matches how to
But, I haven’t really been able to deal with the enormity of the data and how to organize it into chunks that made sense to me.įor instance, I know that I connect to two different families.
![spreadshhet for my dna matches spreadshhet for my dna matches](https://i.pinimg.com/originals/59/a3/7f/59a37f50daa00f0807891cbe9550dee3.png)
I’ve written many emails to possible new cousins. Since then, I have played with my results many times.
#Spreadshhet for my dna matches for free
When you click on these links and make a purchase, I earn a percentage of the sale which allows me to keep providing you great content for free on this website.Īs those who read this blog regularly know, I had an autosomal DNA test done in July 2014. PLEASE NOTE: Melody is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to.