
DMT Combined People Excel File
The Combined People file shows how every Person C who matches with Person A, also matches with all the Person B people.
This file is sort of like the "In Common With" information that Family Tree DNA and other DNA services provide. But it tells you a lot more, including whether or not there are double matches and triangulations and on which chromosome. If you find other good ways to use this data, please let me know and I'll document it here.
AB and AC Matches
Person A is shown in column A (NAMEA).
All the Person C people that Person A matches to are shown in Column B (NAMEC).
The first lines contain the people used as the Person B people for the double matches. In the above example, Person A was double matched with the first 3 people. These people are designated by having an entry in column C (COLB) highlighted in yellow which gives the column number where that person B's match information is shown.
These lines are followed by a thick black horizontal line.
Then all the other C people are listed, ordered by Status (Full Triangulation first, Missing AB Matches second, then No Double Matches), and then within Status type, by highest triangulation, missing AB, or AC match that is shown in column E (DMMAX).
 
Status
Column D (STATUS) indicates how Persons A and C match with the B people. The Status can be:
indicates that Person A, C and at least one of the B people triangulate on at least one segment.
indicates that Person A, C and at least on of the B people double match on at least one segment, but don't triangulate.
indicates that Person A and C do not double match with any of the C people.
 
Double Match and Triangulated Segments
Column E (DMMAX) gives the maximum cM of any triangulating segments and is shown in green. If there are no triangulating segments, then if gives the maximum cM of any double match segments and is shown in grey. If there are no double match segments, then the value is 0.
Column F (TRNSEG) gives the number of segments that triangulate, where Person A matches Person C, Person B matches Person C, and Person A matches Person B. When this number is greater than 0, it is shown in green to emphasize that there are triangulations.
Column G (MABSEG) gives the number of segments that double match, but don't triangulate and are missing AB matches, where Person A matches Person C, Person B matches Person C, but Person A does not match Person B. When this number is greater than 0, it is shown in grey to emphasize that there are missing AB matches.
Double matches are either triangulations or missing AB matches. The total of columns F and G is the total number of double matches.
 
AC Match Information
Columns H through AH contains single match information for Person A and Person C.
Columns H (NUMAC), I (TOTAC), J (MAXAC) and K (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. If the match length on the X Chromosome is greater than zero, it is shown in red just for emphasis.
Columns L (AC1) through AH (ACX) show the largest single matches between Person A and Person C on each chromosome, 1 to 22 and X.
If AC triangulate on that chromosome with any of the B People, then the largest length in cM of any AC segment that triangulates is what is shown and it is highlighted in green, e.g.
If AC does not triangulate on that chromosome, but does double match, then the largest length in cM of any AC segment that double matches (meaning it is a missing AB match) is what is shown and it is highlighted in grey, e.g.
If no segment double matches on that chromosome, then the largest length in cM of any single matching AC segment is what is shown unhighlighted, e.g.
X matches will be shown in column AH with red text, e.g. or or
 
Double Match Info with each Person B
Columns AI and on contain all the Person B's who were each double matched with person A. The columns show how they match with each row's Person C.
If Person B triangulates with Persons A and C, then the largest cM that triangulates is shown in green, e.g.
If Person B does not triangulte with Person A and C but has a missing AB match, then the largest cM of any missing AB match is shown in grey, e.g.
If Person B does not double match with Person A and C, then the largest cM of any single AC match is shown unhighlighted, e.g.
If Person B triangulates on X, then the largest cM that triangulates is shown in green with red text, e.g. . Similarly, no triangulations but a missing AB match with a missing AB match on X is shown in grey with red text, e.g. . Also no double matches but an AC match on the X will be shown unhighlighted in red text, e.g. . In all cases, then number shown is the largest cM on all segments and the X cM may be less than that.
 

