RootsChat.Com
General => The Common Room => Topic started by: Mart 'n' Al on Wednesday 03 July 19 12:21 BST (UK)
-
I don't know if this is more appropriate here, or in the DNA area or in the technical area.
If you and a cousin share MyHeritage DNA matches, you can subscribe to MyHeritage and you will be given details of the Shared matches. I think an alternative would be for each of you to download the Shared match data or even all of your data and create an intermediate spreadsheet to compare the two sets of data. I can do this myself and will do, but I thought I'd first of all ask if anyone else has already done this and would be prepared to make it available to me.
If nobody has done this, when I have done it I will make it available to you.
Martin
-
I might be missing something here (not unheard of!) but doesn't the AutoClusters tool on MyHeritage do this already (or most of it)?
-
Martin, did either you or your cousin not pay to "unlock" the additional features on My Heritage after uploading your raw data from another company? If so, it might be easier for you to just pay to see those (now) extra features such as Auto Clusters and Chromosome Browser.
I can't help with a spreadsheet though sorry. :)
-
Ah, but I like the challenge, and saving money. Thanks for the ideas though.
Martin
-
Yes somebody has compiled a spreadsheet to compare matches (although may not be My Heritage matches) and there is a thread about it but can't remember who.
Did you search for 'spreadsheet' or 'match comparison' or something similar.
Pheno
-
The MH auto cluster facility, that David referred to, produces an Excel spreadsheet:
https://www.rootschat.com/forum/index.php?topic=809139.0
-
It all does sound enticing, but I am trying to restrain myself. I am currently working on a spreadsheet comparison that will match names in my heritage to my matches. Next I will try to compare all names in my database to my matches. I found a good tutorial on YouTube, and I am quite good at data manipulation.
https://www.youtube.com/watch?v=SdAHOMgutfU
Martin
-
I have found that comparing a list of 7,800 with another person's list is very simple, using the MATCH command. I am also looking through these for more ideas:
https://www.cyndislist.com/dna/templates/
Martin