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
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:
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.
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
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.
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).
