Double Match Triangulator Main Window

 
Double Match Triangulator Main Window
 

Sample Files:
 

If you don't use FamilyTreeDNA and/or don't have more than one Chromosome Browser Results (CBR) file to test DMT with, you can download a set of test files to try it out. They are available in zipped form at:
 
Once unzipped, you'll get 5 CBR files for:
1. Harry B00000 who is my uncle
2. Joel S00001 who is my confirmed 3rd cousin (2c1r to my uncle).
3. Erika B00002 who is a genetic cousin whose relationship we have not yet determined
4. Sandra G00003 who is another genetic cousin whose relationship we also have not yet determined
5. Jeff G00004 who is not a genetic match to my uncle, but is a first cousin to Sandra G00003 and Double Matches my uncle on significant segments.
 
There are tens of thousands of other people these 5 people match to in these files. For privacy reasons, they have been renamed so that their surname contains a letter and 5 digit number, but Thomas K18014 will be the same person in all files.  Numbers from 10000 to 19999 indicate people who match to Harry B00000. Numbers 20000 or more are people who do not match to Harry B0000 and will not show up in DMT's output because they don't double match.
 
If you try to run these sample files against your own CBR file, you will not get any matches because Double Match Triangulator uses the person's name to do the matching and you likely won't match to any of these contrived names.
 
 

Getting Started with Double Match Triangulator:

 
  • You need at least 2 Chromosome Browser Results files from FamilyTreeDNA. If you administer more than one kit, you can use the file from each kit. If you only have one kit, you need to contact one of your matches and ask them to download their Chromosome Browser Results file and see if they would be willing to send it to you.
     
  • Open DMT. Use the "Select Person a" button to find one of the Chromosome Browser Results files.
     
  • Use the "Select Person b" button to find the other.
     
  • Press the "Run Button".
     
  • Press the "Folder a" button and open the Excel file with the name: DMT_nnnnn_yyyymmdd__nnnnn_yyyymmdd.xlsx
 
 

Matching Person a with Multiple People:

 
  • Once you've accumulated Chromosome Browser Results files from multiple relatives, you may want to organize them into folders based on who you got the files from. Then you can build DMT files for any one person with all the other people.
     
  • Open DMT. "Select Person a" button to find one of the Chromosome Browser Results files.
     
  • Use the "Select Folder b" button to choose a folder containing the people to match to. Optionally you can:
     
  • Press the "Run Button".
     
  • Press the "Folder a" button and you will see all the Excel files with the name: DMT_nnnnn_yyyymmdd__nnnnn_yyyymmdd.xlsx and you can open the ones you want.
 
 

Matching Person a with Multiple People and Combining the Results:

 
  • You may want to separate the CBR files of your paternal relatives from your maternal relatives before you do this. Otherwise, results may be harder to interpret as matching groups will be from both halves of each Chromosome pair and will overlap.
     
  • Open DMT. "Select Person a" button to find one of the Chromosome Browser Results files.
     
  • Use the "Select Folder b" button to choose a folder containing the people to match to. Optionally you can:
     
  • Select the box: 
     
  • Press the "Run Button".
     
  • Press the "Folder a" button and you will see all the Excel files with the name: DMT_nnnnn_yyyymmdd__Chromosome_nn.xlsx and you can open the ones you want.
     
 
1

CBR file for Person a

1. CBR file for Person a
The Chromosome Browser Results file for Person a is shown here. There is a dropdown at the right that allows fast selection of previously used files. Person a is normally the person you are interested in, often yourself, whose ancestors you want to find.
 
2

Select and display Person a

2. Select and display Person a
Pressing the ... button will bring up a file dialog that allows you to select the Person a file. When a Person a file is selected, the first few lines of the file are read and the name of Person a is obtained and displayed here, to make it easy for you to verify that it is the correct file. The name is shown in green if this is a valid Chromosome Browser Results file. A message is shown in red if this is not a valid CBR file.
 
3

CBR file for Person b

3. CBR file for Person b
The Chromosome Browser Results file for Person b is shown here. There is a dropdown at the right that allows fast selection of previously used files. Person b people are those who you've obtained Chromosome Browser Results files from. You will want to find all the double matches between your Person a and all of the Person b's that you have.
 
4

Select and display Person b

4. Select and display Person b
Pressing the ... button will bring up a file dialog that allows you to select the Person b file. When a Person b file is selected, the first few lines of the file are read and the name of Person b is obtained and displayed here, to make it easy for you to verify that it is the correct file. The name is shown in green if File b is selected and this file will be used in the DMT run. The name is shown in black if Folder b is selected. If the file is not a valid Chromosome Browser Results file, a message in red will be shown.
 
5

File b or Folder b

5. File b or Folder b
Choose File b to use the Person b selection and to compare Person a with just Person b. Choose Folder b to use every Chromosome Browser Results file that is in Folder b and compare Person a with all the people represented by the CBR files in Folder b.
 
6

Folder b

6. Folder b
The folder containing the Chromosome Browser Results files to be matched with Person a is shown here. There is a dropdown at the right that allows fast selection of previously used folders.
 
7

Select Folder b and count files

7. Select Folder b and count files
Displays the number of Chromosome Browser Results files in Folder b (and subfolders if that is selected). The line is shown in green if Folder b is selected and the files in this folder (and subfolders if selected) will be used in the DMT run. The line is shown in black if File b is selected.  The line is shown in red if there are no Chromosome Browser Results in the folder.
 
8

Subfolders

8. Subfolders
If checked, then the file in the folder and all its subfolders will be used and the count of files will reflect the total number of CBR files. If not checked, then only files in the specified folder with be used.
 
9

Combine Results

9. Combine Results
If Folder b is selected and this box is unchecked, then a DMT file will be created for Person a and each Person b in Folder b (and optionally the subfolders).
 
If Folder b is selected and this box is checked, then the results of Person a with each Person b in Folder b (and optionally the subfolders) are combined together. Since the combined file could become very large, it is produced as 24 files, one for each of 23 Chromosomes and a People file. This option is not available and is unnecessary if File b is selected since all the results will be in the single DMT file produced.
 
10

Run button

10. Run button
Press this button to build the DMT files
 
11

Cancel button

11. Cancel button
This will cancel the building of the DMT files, after the current DMT file is completed.
 
12

Rebuild DMT files checkbox

12. Rebuild DMT files checkbox
If the DMT files for some of the selections were already built, then the text would indicate how many. If you then check this box, then these files will be rebuilt when the Run button is pressed. This button will hide when Analysis By Chromosome (Combine Results) is checked since Person a will always be run with every Person b to produce the combined results.
 
13

Run Projection

13. Run Projection
Displays a message stating the number of Double Match Triangulation (DMT) files that will be created when the run button is pressed. When File b is selected, then only the 1 DMT file will be produced. When Folder b is selected, then multiple DMT files will be produced as specified. The number is shown in green if the Run will result in at least 1 DMT file, A message will be shown in red if the a and b selections will not result in any DMT files. Person a will not be Double Matched against itself so its CBR file will not be included in the count.
 
14

Folder a button

14. Folder a button
All the DMT files produced for a run, as well as the log file for the run, are put in Folder a, the folder where Person a's CBR file is. Press this button to open a Windows Explorer window to the folder so you can then view the files produced. This button is very convenient to get you to your data. I use it all the time.
 
15

FamilyTreeDNA Link

15. FamilyTreeDNA Link
This is a link that will open the FamilyTreeDNA website in your web browser, where you can go to download the Chromosome Browser Results file for the kits you administer, or where you can go to order more DNA tests.
 
Disclaimer: This is my affliate link to FamilyTreeDNA. If you use this link and purchase a product from FamilyTreeDNA soon after using it, I will receive a small commission.  If you think DMT is a useful tool and wish to give me some additional thanks, using this link to go to FamilyTreeDNA prior to your next product purchase would be a nice way to do so.
 
16

Help button

16. Help button
This button will open the DMT Help file.
 
17

Messages Area

17. Messages Area
This is where runtime messages are displayed so that you can monitor the progress of your DMT runs. Most of these messages are also included in the log file that is produced.
 
18

License information

18. License information
This area shows who purchased the license to be the user of this program. If the program is not licensed, then a registration area appears instead, allowing you to enter your license information.