DMT Excel File - People Page

 
DMT Excel File - People Page
 
This page is an index of the people matching Person a. It lists every Person c who matches Person a, and that's whether or not they match Person b.
 
On each line except the line 2, this page shows match information for Person c with respect to Persons a and b. Line 2 is different and shows in yellow SIngle Match information between Person a and Person b.
 
1

Person a, b and c

1. Person a, b and c
 
Columns A (NAME-A), B (NAME-B) and C (NAME-C) give the names of Person a, Person b and Person c. 
 
Person a and Person b are always the same on this page, but are included for reference and in case you want merge several People pages together for analysis.
 
Line 2 will show NAME-C as and that line is different as it just summarizes the matches between Person a and Person b.
 
If NAME-C begins with ##, then that person has overlapping segments in Person a's Chromosome Browser Results file. Family Tree DNA produces the CBR file by sorting by the person's name. If two test kits have the same name, either because the same person was tested more than once, or more than one person used the same name, then segments can be duplicated or overlap. DMT will remove any duplicated and/or overlapping segments that it finds to avoid producing misleading results. Overlapping results mean there are two people combined as one, and are noted for you. If you use the matches of people beginning with ##, be aware that you may be dealing with more than one person. For more information on this problem, see my blog post: Misleading Double Entries in FamilyTreeDNA Data. The Log File will list the segments that were excluded from analysis, but doesn't solve this problem for you. If you need to use this person in your analysis, you should go to the Chromosome Browser in your FamilyTreeDNA, and you will be able to see and individually download the matches of each person with that name.
 
2

Status

2. Status
 
Column D (STATUS) indicates how Persons a, b and c match. The People are grouped by their Status and shown in the following order:
is on Line 2 and gives information about the match between Person a and Person b.
indicates that Person a, b and c Triangulate on at least one segment.
indicates that Person a, b and c Double Match on at least one segment, but don't Triangulate.
indicates that Person a, b and c do not Double Match, but Person b still Single Matches Person c
indicates that Person b does not even Single match Person c
 
The people who Triangulate will be of most interest because the three may share a segment from a common ancestor.
 
People who don't Triangulate, but still Double Match (designated as Missing a-b) may still be indicative of a common ancestor, but with two different sources of the segment (e.g. different chromosomes of a chromosome pair, or maybe one from the father and one from the mother). More research is needed into this. I give some thoughts in my blog post: Triangulation and Missing a-b Segments
 
The No Double Matches and No Match b-c are also of interest, They list people related to Person a who share no segments with Person b indicating that they are likely not related to Person a through any of Person b's ancestors. This negative information can be used to help disprove a relationship. Be aware though, that especially in more distant relationships (beyond 2rd cousins), that the lack of a match does not mean that two people are not related, but only that they did not both receive the same segment from a common ancestor.
 
3

Double Match and Triangulated Segments

3. Double Match and Triangulated Segments
 
Column E (DMNSEG) gives the number of segments that Double Match, meaning Person a and Person c's matching segments correspond to Person b and Person c's matching segments.
 
Column F (TRNSEG) gives the number of segments that Triangulate, which means that in addition to Double Matching, Person a also matches Person b on the segment When this number is greater than 0, it is shown in green to emphasize that there are Full Triangulations for Person c with a and b.
 
A Triangulation is also a Double Match, so the Triangulation number is included in the Double Match number.
 
4

a-c Single Matches

4. a-c Single Matches
 
Columns G (NUMAC), H (TOTAC), I (MAXAC) and J (XTOTAC) give the number of segments matching between Person a and Person c, their total match length in cM, the largest matching segment length in cM, and the total match length on the X Chromosome.
 
Within Status groups, the lines on the Map page are sorted by highest total match length (TOTAC) so that the presumably closer relatives of Person a will be listed first.
 
5

b-c Single Matches

5. b-c Single Matches
 
Columns K (NUMBC), L (TOTBC), M (MAXBC) and N (XTOTBC) give the number of segments matching between Person b and Person c, their total match length in cM, the largest matching segment length in cM, and the total match length on the X Chromosome.
 
6

a-c Single Matches by Chromosome

6. a-c Single Matches by Chromosome
 
Columns O through AK show the largest Single Matches between Person a and Person c on each Chromosome, 1 to 22 and X (sometimes referred to as 23)
 
If a-c Triangulate on that Chromosome, then the largest length in cM of any a-c segment that Triangulates is prefixed by the letter "T" and is shown in green so it can be easily picked out, e.g.
 
If a-c does not Triangulate on that Chromosome, but does Double Match, then the largest length in cM of any a-c segment that Double Matches is prefixed by the letter "D", e.g.
 
X matches will be shown in column AK with red text and the prefix after the letter "T" or "D" will be "X", e.g. or