Genealogy Junkie
www.genealogyjunkie.net
  • HOME
    • Copyright Statement
  • FAMILY HISTORY
    • Names/Places Summary >
      • Ancestor Surnames & Locations
      • List of All Surnames
    • Pedigree Charts
    • Skinny Branches
    • My Brick Walls
  • GENETIC GENEALOGY
    • ADSA Tool: No Spreadsheets Required!
    • Centromeres & Excessive IBS
    • Lines of Interest >
      • Haplogroup Pedigree Chart
      • Griffith Line Y-DNA
      • Corlett-Dumbell-Aspinall-Mason Line mtDNA
      • Grieve-Coulthard-Hetherington-Dixon Line mtDNA
      • X-DNA Inheritance Charts
    • DNA Tips, Tools & Managing Matches
    • Miscellaneous Notes
  • LINKS
    • Regional Links
    • Miscellaneous Links
    • Useful Family Search URLs
  • DOWNLOADS
  • BLOG
    • List of Blog Postings >
      • DNA & Genetic Genealogy Blog Postings
      • Family History Blog Postings
      • Blog Postings: Miscellaneous Topics
    • Subscribe to Blog
  • CONTACT
    • About Me

Template for Y-DNA and mtDNA Haplogroup Trees

5/14/2014

1 Comment

 
The formatting of the blog posting may be odd if you are reading this in a Feed Reader or via e-mail distribution, so click on the title above (which is an active link) to view the website version.
Template for Y-DNA and mtDNA Haplogroup Tree
Template for Y-DNA and mtDNA Haplogroup Tree
Thanks to a second cousin having undergone DNA testing, including full sequence mitochondrial DNA (mtDNA), her haplogroup enables me to fill in the haplogroups for some of my ancestors (Ahnentafel numbers 4, 9, 19, and beyond). Adding this to my own mtDNA haplogroup, together with my father's Y-DNA and mtDNA haplogroups, I now know the haplogroups for 4 of my 16 2nd great-grandparents. So I created a haplogroup tree in Excel and from that have created templates.

The templates, which have been created under a Creative Commons license (CC BY-NC 4.0), are available in two Excel formats, as well as a blank PDF, which can be filled in by hand if you don't have Excel. In one worksheet, you just add (or paste) a list of your ancestors and the known Y-DNA and mtDNA haplogroups (at the 2nd great-grandparent level). The haplogroup tree is then produced in separate worksheets (males and females on different tabs – the male version is shown in the image above, and my own female version below). Here are the links to download the templates:
  • Haplogroup Tree Template (.xlsx) – for Excel 2007 and 2010 
  • Haplogroup Tree Template (.xls) – for Excel 97-2003
  • Blank Haplogroup Tree (.pdf) – to print off and fill-in by hand

These are also available on the Downloads tab on my website – and other templates there are a 7-generation Pedigree Chart and X-DNA Inheritance Charts.

I have protected the worksheets (without using a password), to prevent inadvertent changes from being made, but have included instructions for how to remove the protection (see the first tab, "Information & Help"), so you can make whatever changes you like.

UPDATE (1 Jun 2014): I had inadvertently missed out the mtDNA haplogroup beneath "Self" in the male template (figure above), but the templates have now been updated and the Template Version date now shows as 1 Jun 2014. The links to the templates remain the same.

My Haplogroup Tree

My Haplogroup Tree
My Haplogroup Tree
Based on my test results and those of my father and 2nd cousin, I know the Y-DNA haplogroup of one branch of my tree (R-P312) and mtDNA haplogroups of three branches (H5e1, T2b, and HV0d). In addition, I've identified individuals who could fill in an additional 6 branches (shown with asterisks). So if you are a direct paternal- or maternal-line descendant of any of these ancestors (or any earlier ancestors; also check out Do You Have the Right DNA?) and would be interested in having your DNA tested, please Contact Me – and I may be prepared to pay for your DNA testing.

See the link for my other blog postings relating to DNA and Genetic Genealogy.

What's New on Genealogy Junkie?

  • Buyer Beware Links – NEW webpage (5 May 2014), with some DNA-related and genealogy companies where others have reported issues. You may want to do some background research on them before spending any money.
  • I've added all the YouTube links I could find to the AncestryDNA section on Presentations on DNA Testing (updated 3 May 2014).

Sitemap / Blogmap
Subscribe to Blog
Copyright Statement
Disclosure Statement
only search Genealogy Junkie
1 Comment
Phillip Neal
5/15/2014 02:30:06

Hi Sue,

Your blog brought to my attention by 2 cousins...we're all active on 23andMe, FT-DNA and Ancestry. This is a great tool and well-implemented approach to not only display hap results but also for enforcing the rules. Thanks for your efforts.

Reply

Your comment will be posted after it is approved.


Leave a Reply.

    Author

    See About Me
     

    Contact Me

    or via Contact Page

    Subscribe to Blog

     Subscribe to Genealogy Junkie Blog (it's free) in an RSS Feed Reader
    or
    via e-mail:

    Enter your email address:

    Powered by FeedBurner

    Blog Categories

    - List of All Blog Postings
    - DNA & Genetic Genealogy
    - Family History
    - Miscellaneous Topics

    Archives

    August 2019
    December 2016
    November 2016
    August 2016
    June 2016
    September 2015
    April 2015
    February 2015
    December 2014
    August 2014
    June 2014
    May 2014
    April 2014
    March 2014
    February 2014
    January 2014
    December 2013
    November 2013
    August 2013
    July 2013
    June 2013


    Copyright Statement
    Disclosure Policy
Tree

Disclosure Policy
Copyright © 2013-2022 www.genealogyjunkie.net 
Copyright Statement
Tree