Thursday, August 24, 2017

How Do You Keep Track of Your DNA Results?

I started my DNA journey in 2011, the same year I found my birth mother. I have tested at the three major companies and have uploaded my results to all conceivable sites. However, I am completely overwhelmed with trying to keep up with all the different sites and results! 

I have been keeping a log in a notebook but it is no longer working for me now that I am managing more kits than I was a year ago. I am trying to keep up with the results and to find a way that is easy for me but also productive at the same time. I want to be able to see "the results" all in one place without having to pull out multiple notebooks. 

DNA Locator Log

As more companies allow for us to upload our DNA results to their website I have found that the easiest way for me to keep track is with a DNA Locator Log. It is simple and uncomplicated and gives me a brief overview of the DNA results. Here is a shareable link.



Here is a screen capture of my DNA Locator Log. I have columns for the following information:
  • Name of Test Take
  • Name of Testing Company 
  • Type of DNA Test (at, mt, y)
  • Year Test Was Take n
  • Ethnicity Results
  • Ethnicity Breakdown
  • Gedmatch Upload/Kit Number
  • FTDNA Upload/Kit Number
  • My Heritage Upload/Kit Number
  • Comments
DNA Match Log

Again, using Google Sheets I have come up with a spreadsheet for my DNA matches and the results generated from all of the sites. I have designed some spreadsheets based on the information that is generated by the different testing companies and at Gedmatch. I feel like I am really overthinking this but the key is in the details! Not all columns are applicable and can be removed if desired. Here is the sharable link.


This capture does not include all of the columns but I have made columns for the following information:

  • Testing Company/Website
  • Kit Number (Gedmatch/FTDNA)
  • Test Taker Name or Alias
  • Managed By
  • User Name (Ancestry)
  • Contact Information, (if known)
  • Date of Match, if applicable
  • Shared cM's
  • Gedmatch Autosomal DNA (Total cM's/Largest cM's)
  • Gedmatch X-DNA o r FTDNA X-Match (Total cM 's/Longest  Block)
  • Predicated or Estimated Relationship
  • Shared DNA Percentage (23 & Me)
  • # of Segments Shared (23 & Me)
  • mt-DNA haplogroup, (if known)
  • y-DNA haplogroup, (if known)
  • MCRA, (if known)
  • Shared Surnames
  • Shared Ancestral Places
  • Other Relatives with that Surname & Relationship to User/Testee
  • Shared Ethnicity
  • Correspondence Method (Direct email or via the testing company)
  • Date of First Correspondence
  • Was A Response Received
  •  # of Attempts Tried
  • Is the Testee an Adoptee
  • Paternal or Maternal Match, (if known)
  • Notes About Test Results
  • Questions
  • Comments
  • Ancestry Tree (Public, Private or No Tree)
  • Gedcom Available (Gedmatch, FTDNA, 23 & Me)
Feedback

I know that many of you are much more experienced with DNA and I would greatly appreciate your feedback on whether you find these spreadsheets helpful, too detailed or heaven help me not detailed enough. Thank you in advance!


7 comments:

  1. I have slightly fewer columns but incorporate most of the information in my notes field. I keep track of the shared matches in a separate column, they are often key in unravelling the connection. As well as MRCA when known I have a separate column for line which is useful when I don't know the MRCA but can say predict the line based on shared matches. Regards Anne https://ayfamilyhistory.com/2017/07/13/dna-testing-results-one-year-on/

    ReplyDelete
    Replies
    1. Thank you, Anne! I am sure I will be making adjustments and fine tuning as I start inputting the data.

      Delete
  2. I downloaded free software named Genome Mate. It is very helpful. There is a bit of a learning curve but there are youtube videos to help. Once you get the hang of it, it's much easier.

    ReplyDelete
  3. I'm finding that both a spreadsheet such as yours and Genome Mate Pro are essential to gain control of what can become DNA data overload. Thank you for your post as you've given me a couple ideas for additional spreadsheet columns.

    ReplyDelete
  4. I love your spreadsheet! I kept most columns and moved some around. I deleted a couple since they aren't pertinent yet to the groups I'm working with right now. I'm setting the information up according to triangulated groups. As I contact other members within the pileup on the particular chromosome, I add their information to the spreadsheet or I add those folks with whom I share the most dna within that triangulated group. This is so much easier than having to always look certain basic information up!

    ReplyDelete
  5. That is very interesting I love reading and I am always searching for informative information like this.I am very happy to your post about on. Great information, I would like to say your post is very informative.
    Genome testing kit

    ReplyDelete