RootsChat.Com

General => The Common Room => Topic started by: Mart 'n' Al on Wednesday 03 July 19 12:21 BST (UK)

Title: Excel spreadsheet to compare shared MyHeritage matches
Post 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
Title: Re: Excel spreadsheet to compare shared MyHeritage matches
Post by: davidft on Wednesday 03 July 19 14:51 BST (UK)
I might be missing something here (not unheard of!) but doesn't the AutoClusters tool on MyHeritage do this already (or most of it)?
Title: Re: Excel spreadsheet to compare shared MyHeritage matches
Post by: Ruskie on Wednesday 03 July 19 14:58 BST (UK)
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.  :)
Title: Re: Excel spreadsheet to compare shared MyHeritage matches
Post by: Mart 'n' Al on Wednesday 03 July 19 15:13 BST (UK)
Ah, but I like the challenge, and saving money.  Thanks for the ideas though.

Martin
Title: Re: Excel spreadsheet to compare shared MyHeritage matches
Post by: Pheno on Wednesday 03 July 19 15:47 BST (UK)
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
Title: Re: Excel spreadsheet to compare shared MyHeritage matches
Post by: Gadget on Wednesday 03 July 19 15:53 BST (UK)
The MH auto cluster facility, that David referred to, produces an Excel spreadsheet:

https://www.rootschat.com/forum/index.php?topic=809139.0
Title: Re: Excel spreadsheet to compare shared MyHeritage matches
Post by: Mart 'n' Al on Wednesday 03 July 19 15:58 BST (UK)
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
Title: Re: Excel spreadsheet to compare shared MyHeritage matches
Post by: Mart 'n' Al on Sunday 07 July 19 17:03 BST (UK)
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