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.  This version is the most up-to-date version available and the more simple to access and read, but it cannot be edited further to include sub-groups or the much detailed data that can be associated with each participant's test results that are included in our Study's Main Results Tables. 

1.  There are two versions of FTDNA's Public pages tables, one that includes all project members and one that excludes those who have not opted in to sharing.  You will find the more comprehensive version if you first sign in to your FTDNA account at

2.  Similarly, there are similarly two versions of our Study's Main Results Tables, the public one posted on this website that excludes details of participants who have not opted in to sharing, and a members-only version available to all Study participants on request that includes the test results of all participants.

3.  There are some minor differences between FTDNA's Public pages and our Study's main results table in how the results are grouped into genetic families and sub-groups.  The groupings/genetic families used in the "Latest Analysis Update" are those shown in our Main Results table, not those shown in the Public Pages.  Apologies for any confusion the discrepancies may cause. 

4.  The autosomal/Family Finder and mitochondrial test results of individuals who have not taken a y-DNA test do not appear in either FTDNA's public results tables or the Study's Main Results Tables.   

2.     Main Results Table

Click here to download an Excel spreadsheet version of these results.*   It is now very large so you have to scroll both horizontally and vertically to grasp its full extent. Do not attempt to print out a hard copy - it would run to at least 9 sheets!

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 results of Study participants.  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 over 160 columns and 600 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- 11 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:
Genetic 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

columns C, AA, AP, EO, GV  Test kit number

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

Earliest confirmed paternal ancestor details
column E*      Surname
column F*       Forename

column G*      Residence before migration

column H*      Residence after migration

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

column J*       Died (                                                                   )

Genealogical relationship to other participants

column K*      Relationship known before DNA test

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

column M#     Relationship identified by yDNA testing

SNP test data

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

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

column Q#     basis for inclusion in haplotree if not SNP test

column R       column in Big Tree format L555 haplotree
columns S-X  most significant SNPs (8 digit numbers are locations of SNPs not yet named)

column Y#      Identified branches

column Z        Downstream SNPs

Family Finder Test data

column AB      Family Finder test taken

column AC     Suggested relationships 

STR test data

column AD#   Genetic family (as column A)

column AE#   “Old sub-group” (e.g. "B9"; Note that these groupings have now been found to be misleading)

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

columns AG-AK GD (Genetic Distance) from Borders mode at 12, 25, 37, 67 & 111 markers respectively

column AL      FTDNA TiP% from Borders mode at 24 generations (former value)

column AM     FTDNA TiP% from Borders mode at 24 generations (current value)

column AN     FTDNA TiP% from Family mode  from family mode at 37 markers

column AO     GD from Family mode at 37 markers

columns AQ-EN  STR marker counts, Panels 1-5.

columns EP-FS  STR marker counts for Panel 6 that show variability from L555 modal counts.

columns FT-GU  STR marker counts for Panel 7 that show variability from L555 modal counts. 

Sources of participants' details

Data in this table is derived from FTDNA sources, or other testing company as indicated, except as follows:

#: Data supplied by Study Administrator.  Data in lines 8-17 has also been supplied by Study Administrator, who has also extrapolated the colour coding and other annotations in the STR marker cells as below. 

*:  Data that has been volunteered the individual participant, either directly or via FTDNA.  Consent for publishing the data in columns E and G-L is not required under GDPR, but this and all other data in this table will be updated or removed as quickly as is practicable on receipt of an e-mail request by the participant concerned

"not shared in public" indicates participants who have not ticked the box "Opt in to sharing": see "Manage your FTDNA Account" for details.  All participants may request the Study Administrator to e-mail them a members-only version of the complete main results table at any time. 

Participants may e-mail the Study Administrator at any time to ask for their details to be deleted from the public version of our main results table, or to leave our Study.  Details will be deleted as quickly as is practical on receipt of such requests. 


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 20, 2020, 5:51 PM