This is the worksheet referenced in Arun Konanur's presentation at the Ontario Genealogical Society's 2021 Conference — DNA: Cracking the Code and Discovering New Ancestors Download the Discovering New Ancestors Pedigree Worksheet here. Download a PDF of the presentation materials in essay format here. The Pedigree Worksheet will run under any version of Microsoft Excel that supports VBA Macros. When opening the sheet, Excel will ask if you want to enable these macros or will tell you they aren’t supported. Click Open to enable automated scripts which allow the Worksheet to do what it does.

Excel 2008 or earlier on the Macintosh platform does not support VBA macros, but all other users should be able to use the Pedigree Worksheet without issue. Look for a large field to the right of the word “Self” (click to enlarge any example on this page).

Enter the surname at birth of the person who took the DNA test, and you’ll see the same name populate the subject’s paternal line, as in the example below, where we haves used the surname "Hayes":

Enter the test subject's Mother's family name in the shaded field above and to the right of where you started, as we have done with "Shaw":

I’m a paragraph. Drag me to add paragraph to your block, write your own text and edit me.

When clustering using our method, select an ancestor common to your match and read the family lines which comprise that ancestor's pedigree from the field at the bottom of the Worksheet. In this case, selecting "Great-Grandparent Hoshal" instructs the user to assign the match to the "Hoshal, Everingham, and Garricy" custom groups.

Follow the instructions in our presentation to assign Custom Groups for the purpose of clustering your AncestryDNA member matches!

Can Discovering New Ancestors solve your genealogy mysteries? Read what our clients say — or download our Intake Form!