Author Topic: Excel spreadsheet to compare shared MyHeritage matches  (Read 667 times)

Offline Mart 'n' Al

  • RootsChat Leaver
  • RootsChat Pioneer
  • *
  • Posts: 0
    • View Profile
Excel spreadsheet to compare shared MyHeritage matches
« 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

Offline davidft

  • RootsChat Marquessate
  • *******
  • Posts: 4,209
  • Census information Crown Copyright, from www.nationalarchives.gov.uk
    • View Profile
Re: Excel spreadsheet to compare shared MyHeritage matches
« Reply #1 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)?
James Stott c1775-1850. James was born in Yorkshire but where? He was a stonemason and married Elizabeth Archer (nee Nicholson) in 1794 at Ripon. They lived thereafter in Masham. If anyone has any suggestions or leads as to his birthplace I would be interested to know. I have searched for it for years without success. Thank you.

Offline Ruskie

  • RootsChat Marquessate
  • *******
  • Posts: 26,196
  • Census information Crown Copyright, from www.nationalarchives.gov.uk
    • View Profile
Re: Excel spreadsheet to compare shared MyHeritage matches
« Reply #2 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.  :)

Offline Mart 'n' Al

  • RootsChat Leaver
  • RootsChat Pioneer
  • *
  • Posts: 0
    • View Profile
Re: Excel spreadsheet to compare shared MyHeritage matches
« Reply #3 on: Wednesday 03 July 19 15:13 BST (UK) »
Ah, but I like the challenge, and saving money.  Thanks for the ideas though.

Martin


Online Pheno

  • RootsChat Aristocrat
  • ******
  • Posts: 1,991
    • View Profile
Re: Excel spreadsheet to compare shared MyHeritage matches
« Reply #4 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
Austin/Austen - Sussex & London
Bond - Berkshire & London
Bishop - Sussex & Kent
Holland - Essex
Nevitt - Cheshire & Staffordshire
Wray - Yorkshire

Offline Gadget

  • RootsChat Marquessate
  • *******
  • Posts: 57,131
    • View Profile
Re: Excel spreadsheet to compare shared MyHeritage matches
« Reply #5 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
Census &  BMD information Crown Copyright www.nationalarchives.gov.uk and GROS - www.scotlandspeople.gov.uk

***Restorers - Please do not use my restores without my permission. Thanks***

Offline Mart 'n' Al

  • RootsChat Leaver
  • RootsChat Pioneer
  • *
  • Posts: 0
    • View Profile
Re: Excel spreadsheet to compare shared MyHeritage matches
« Reply #6 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

Offline Mart 'n' Al

  • RootsChat Leaver
  • RootsChat Pioneer
  • *
  • Posts: 0
    • View Profile
Re: Excel spreadsheet to compare shared MyHeritage matches
« Reply #7 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