1.  FTDNA Public pages
2.  Main results table

1.  FTDNA Public pages

For the latest available FTDNA Y-STR results of our Study see < Y-DNA Results < Classic.  This version is the most up-to-date version available and the more simple to access and read.  However this table cannot be edited further to include the much detailed data that can be associated with each participant's test results that is included in our Main Resuklts Table. 

Note that there are some minor diffferences between FTDNA's Public Pages and our Main Results table in how the results are grouped into genetic families.  The latter groupings/genetic families are those used in the Latest Analysis Update.

2.     Main Results Table

Click here to download an Excel spreadsheet version of these results.*  Although this table is not as up-to-date as the table on FTDNA's public pages it is much more detailed, and now also includes some SNP and Family Finder data; .  The STR data includes the basic test results, Genetic Distances, TiPs, and non-FTDNA test data.  The SNP data includes the Border Irwin L555 haplotree.  The Family Finder data is restricted to Irwin relatives.  This on-line results table is updated at least every six months when the "Latest Analysis Update" is compiled.  More up-to-date versions are available on e-mail request from the Study Administrator. 

This table is more detailed than FTDNA's table, and now includes ySTR, ySNP and autosomal test data.  The STR data includes the basic test results, Genetic Distances, TiPs, and non-FTDNA test data.  The SNP data includes data from BigY tests, SNP Pack test and single SNP tests and the Border Irwin L555 haplotree.  This on-line results table is updated at least every six months when the "Latest Analysis Update" is compiled.  More up-to-date versions are available on e-mail request from the Study Administrator.  


The Excel spreadsheet is now very large, with 160 columns and over 560 rows, so don't try to "Zoom" it to get it all on one screen!  Instead you will find scrolling left & right and up & down is straightforwardTo find the entry of a particular participant, place the cursor on the letter "D" at the top of column (3), select "Find" (or Control and F), and enter the participant's Kit No. 


Arrangement of rows:

Rows 1- 9 are headers.  Thereafter participant's results are grouped in their relevant genetic family, starting with our Borders genetic family.  The results for this large family are now divided into two sections; section B1 contains first those participants who have taken BigY tests, L555 Pack tests or equivalent, or who are related to such participants by genealogy or autosomal tests; section B2 contains those who have not yet taken L555 Pack tests, arranged by the "old" STR sub-groups.  Within each genetic family and sub-group (other than the SNP sequenced Border Irwins) individual participants’ data on each line are sequenced by their TiP Score from the Study's modal, BA.  Finally come our Singletons, with a few "False Positives" at the end.


Arrangement of columns:  For each participant:
Gentic family details

column a    Genetic family indicator and full name

column b    Item (sequential number) Note this numbering is liable to change are new participants join

Participant details

column c    Test kit number

column d    ySearch ID

column e    Residence (A: Australia; C: Canada: E: England; F: France; I: Ireland; S: Scotland; U: USA; Z: New Zealand)

column f     G indicates participant has submitted a Gedcom family tree

Earliest confirmed paternal ancestor details

column g    Surname

column h    Forename

column i     Residence before migration

column j     Residence after migration

column k    Born (c: circa, about; fl.: flourished; p: post, after)

column l     Died (                                                                   )

Genealogical relationship to other participants

column m   Relationship known before DNA test

column n    Pedigree name (“*”: entry in Burkes Landed Gentry)

column o    Relationship identified by yDNA testing

SNP test data

column p    Haplogroup (red: as predicted by FTDNA; green: as tested)

column q    SNP tests taken (italics: on order; bold: paid for or subsidized by General Fund)

column r     No. of SNPs since L555 (use smaller no. for age, larger no. for matching)

column s    basis for inclusion in haplotree if not SNP test

columns t-x  most significant SNPs (8 digit numbers are locations of SNPs not yet named)

column x    Names of SNP branches that have been identified

column y    Downstream SNPs

column z  Test Kit number (as column c)

Family Finder test data

column aa   F indicates Family Finder test taken (italics: on order)

column ab  Summary of relationships identified

STR test data

column ac  Genetic family (as column a)

column ad  “Old sub-group” (e.g. B9; NB These groupings are now recognised to be misleading)

column ae No. of markers tested (italics: on order)

columns af-aj  GD (Genetic Distance) from mode BA at 12, 25, 37, 67 & 111 markers respectively; (bold indicates paid for or subsidized by General Fund)

column ak  FTDNA TiP% from BA at 24 generations

column al   FTDNA TiP% from BA at   8 generations

columns am-be  FTDNA TiP% at 24 generations from modal signatures of other genetic families

The next 111 columns have participant’s counts for each STR marker (if tested).

The penultimate column is the Test Kit number (as column c).

Further Family Finder test data

The final column is as column ac, but includes relationships in italics with testees who are not in surname Study.


Coding in individual STR marker cells:
red         : >2 more than the modal value of BA
orange   :   2 more than the modal value of BA
yellow    :   1 more than the modal value of BA
no colour:        same as the modal value of BA
lt. blue    :   1 less  than the modal value of BA
emerald  :   2 less  than the modal value of BA
        : >2 less  than the modal value of BA

italics:         rare marker values

bold:          fast moving markers

small:           different rule for GD      

underlined:  back mutation (count has changed twice during surname era)

heavy box:  significant matches

* If you don't have Microsoft Excel, you can download a free viewer for Windows here

Rick Byers,
Nov 7, 2017, 9:00 PM