tag:blogger.com,1999:blog-10655356625610110142024-03-27T00:37:07.992-06:00Sorting Dna CousinsA method of sorting through your atDNA matches to find matches related to a specific branch of your family tree. Freely, view TUTORIAL VIDEOS or DOWNLOAD MATCHCOMPARE, an EXCEL macro, that sorts through thousands of matches to provide you with a list of matches that are in common with (ICW) or not in common with (NOTICW) two lists of matches.
Click on below on MatchCompare to download the macro or click on VideoTutorials to see the videos.Kent Jhttp://www.blogger.com/profile/12356187245661856343noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-1065535662561011014.post-58147904720904945692017-05-10T19:18:00.002-06:002023-11-29T18:15:08.395-07:00<h3>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3;"><span style="color: #cc0000; font-family: "times new roman" , serif; font-size: 13.5pt;">Note: A new version, MatchCompare v3.03, is now available
for download. This version was rewritten by Dermot Balson. With this version, it does not matter which column the input data begins in.</span><br />
<span style="color: #3d85c6; font-family: "times new roman" , "serif"; font-size: 13.5pt;"><br /></span>
<span style="color: #3d85c6; font-family: "times new roman" , "serif"; font-size: 13.5pt;"><div style="color: black; font-family: "Times New Roman"; font-size: medium; font-weight: 400;"><span style="font-size: large;">To download the macro, click on the above menu button that says "<b>MATCHCOMPARE</b>." </span></div><div style="color: black; font-family: "Times New Roman"; font-size: medium; font-weight: 400;"><span style="font-size: large;"><br /></span></div><div style="color: black; font-family: "Times New Roman"; font-size: medium; font-weight: 400;"><span style="font-size: large;">To view the video, click on the menu button that says "<b>VIDEO TUTORIALS</b>."</span></div><div style="color: black; font-family: "Times New Roman"; font-size: medium; font-weight: 400;"><span style="font-size: large;"><br /></span></div></span></div>
</h3>
<h3>
<b><span style="font-size: large;">About MatchCompare and What It Does</span></b></h3><div><a href="https://1drv.ms/b/s!ApujAd7-eCHxjEf6rmSwN9M2tgk8" style="font-size: 18.72px; font-weight: 700;" target="_blank">Link to BYU Presentation</a></div>
<div>
<b><span style="font-size: large;"><br /></span></b></div>
<span style="font-size: large;">The object of this method is to find those matches that are in common with (ICW) and not ICW you match list. Depending on which match lists you compare, you can narrow down your match list to a group of matches that are likely to be related to a specific line of your family.</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhHxp6vUorOOQLKEMykgl_OkkWBfWAOJUg66mRW0Yuo_OgLGlKRIwajBBTqsGyiaImgRiRz0QBlVCz3xM80wJLHiUDCruNL-2FRnLosVhKqGV-nrNHYdHBtTD0IXqO-PqTfSqvdsK_4y1bb/s1600/Venn+2.png" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="313" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhHxp6vUorOOQLKEMykgl_OkkWBfWAOJUg66mRW0Yuo_OgLGlKRIwajBBTqsGyiaImgRiRz0QBlVCz3xM80wJLHiUDCruNL-2FRnLosVhKqGV-nrNHYdHBtTD0IXqO-PqTfSqvdsK_4y1bb/s640/Venn+2.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div>
<span style="font-size: large;">For example, if the first match (red) list represents you and the second match list represents your maternal first cousin (green), then the ICW area (green), which matches in both lists, will consist of people that are likely to be related to you on your maternal line. The red Not ICW area will consist of matches that are likely to be on your paternal line with a smaller number of matches that are also on your maternal line, but just were not one the matches that you first cousin had. You can make this analysis more accurate by adding sibling matches to the your list of matches and by also adding maternal cousins to the green match list.</span></div>
<div>
<span style="font-size: large;"><br /></span></div>
<div>
<span style="font-size: large;">MatchCompare can relatively quickly compare to large match lists and give you a list of matches that represent your paternal, maternal or uncle family lines. </span></div>
<div>
<span style="font-size: large;"><br /></span></div>
<div>
<span style="font-size: large;">Additional comparisons can be made to narrow down your match list as shown in the video if you know of matches that are 2nd, 3rd or 4th cousins.</span></div>
<div>
<br /></div>
<h3><br /></h3>
<div><br /></div>
<div>
<span style="font-size: large;"><br /></span></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
</div>
Kent Jhttp://www.blogger.com/profile/12356187245661856343noreply@blogger.com0tag:blogger.com,1999:blog-1065535662561011014.post-58007239233165972432017-05-10T19:13:00.001-06:002017-12-17T17:09:26.188-07:00<div style="font-family: georgia, serif;">
<h2>
Welcome</h2>
<div>
<br /></div>
<div style="font-family: georgia, serif;">
<span style="font-size: large;">The whole idea of genetic genealogy is to find those who can help you advance your genealogical research. After getting your autosomal DNA (atDNA) tested, you are given a large list of matches. For example, I downloaded my matches from the testing companies and got a list of anywhere between 1,400 to over 10,000 matches. You may have wondered like me --- how can I narrow down all of these matches to those who might help me solve my genealogical question?</span></div>
</div>
<div style="font-family: georgia, serif;">
<span style="font-family: "; font-size: large;"><br /></span></div>
<div style="font-family: georgia, serif;">
<span style="font-family: "; font-size: large;">You can begin to sort out the matches are of most interest if you know of at least another cousin on either side of your family. Matches, which are in common with (ICW) this other person, will also be ICW with your most recent common ancestor (MRCA). Matches, which are not ICW with this other person, will generally not be related to your MRCA. If you have 2,000 matches and the other person has 4,000 matches, it could, however, take a very long time to figure out which matches are ICW or not ICW with this person; unless you can automate the process.</span></div>
<div style="font-family: georgia, serif;">
<span style="font-family: "; font-size: large;"><br /></span></div>
<div style="font-family: georgia, serif;">
<span style="font-family: "; font-size: large;">MatchCompare is a macro made for EXCEL that will quickly do this sorting for you and it is free! Just click on the MatchCompare tab, download the macro and begin narrowing your matches down to a more manageable list of those you want to contact to find your MRCA and who may know about your family so you can extend your research.</span></div>
<div style="font-family: georgia, serif;">
<span style="font-family: "; font-size: large;"><br /></span></div>
<div style="font-family: georgia, serif;">
<span style="font-family: "; font-size: large;">For those less experienced in knowing how this tool can be used to narrow down your list of matches to a specific family line, then I have created a tutorial video. I hope to add to more videos explaining some of the aspects of this methodology in more detail. These videos will explain how to obtain your match data and how to create match groups to compare with your matches in further detail.</span></div>
Kent Jhttp://www.blogger.com/profile/12356187245661856343noreply@blogger.com0