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

Offline Mart 'n' Al

  • RootsChat Aristocrat
  • ******
  • Posts: 1,565
  • Martin H. Watson Gedmatch DNA Kit H062246
    • 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
Gedmatch DNA Kit H062246.
FT-DNA Kit B388093

Names:
Loughborough and Loughbrough, (London, Hull, Pirton, Durham & Hartlepool);
Watson, (Bedlington, Jarrow & Hartlepool);
Ballard & Glassop (E. London); 
Leggett (Corton, Scarborough, Hartlepool); 
Young, Adamson & Wilson, (Hartlepool). 

I use GRAMPS v5.0 software. 

My ancestors are probably turning in their graves, not that I can actually find any of them.

RootsChat is the busiest, largest free family history forum site in the country. It is completely free to use. Register now.
Also register instantly with Facebook or Twitter (and other social networks). Start your genealogy search now.


Offline davidft

  • RootsChat Marquessate
  • *******
  • Posts: 3,743
  • 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)?

RootsChat is the busiest, largest free family history forum site in the country. It is completely free to use. Register now.
Also register instantly with Facebook or Twitter (and other social networks). Start your genealogy search now.


Offline Ruskie

  • RootsChat Marquessate
  • *******
  • Posts: 22,855
  • 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 Aristocrat
  • ******
  • Posts: 1,565
  • Martin H. Watson Gedmatch DNA Kit H062246
    • 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
Gedmatch DNA Kit H062246.
FT-DNA Kit B388093

Names:
Loughborough and Loughbrough, (London, Hull, Pirton, Durham & Hartlepool);
Watson, (Bedlington, Jarrow & Hartlepool);
Ballard & Glassop (E. London); 
Leggett (Corton, Scarborough, Hartlepool); 
Young, Adamson & Wilson, (Hartlepool). 

I use GRAMPS v5.0 software. 

My ancestors are probably turning in their graves, not that I can actually find any of them.

Online Pheno

  • RootsChat Aristocrat
  • ******
  • Posts: 1,138
  • Census information Crown Copyright, from www.nationalarchives.gov.uk
    • 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: 47,523
    • 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

Offline Mart 'n' Al

  • RootsChat Aristocrat
  • ******
  • Posts: 1,565
  • Martin H. Watson Gedmatch DNA Kit H062246
    • 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
Gedmatch DNA Kit H062246.
FT-DNA Kit B388093

Names:
Loughborough and Loughbrough, (London, Hull, Pirton, Durham & Hartlepool);
Watson, (Bedlington, Jarrow & Hartlepool);
Ballard & Glassop (E. London); 
Leggett (Corton, Scarborough, Hartlepool); 
Young, Adamson & Wilson, (Hartlepool). 

I use GRAMPS v5.0 software. 

My ancestors are probably turning in their graves, not that I can actually find any of them.

Offline Mart 'n' Al

  • RootsChat Aristocrat
  • ******
  • Posts: 1,565
  • Martin H. Watson Gedmatch DNA Kit H062246
    • 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
Gedmatch DNA Kit H062246.
FT-DNA Kit B388093

Names:
Loughborough and Loughbrough, (London, Hull, Pirton, Durham & Hartlepool);
Watson, (Bedlington, Jarrow & Hartlepool);
Ballard & Glassop (E. London); 
Leggett (Corton, Scarborough, Hartlepool); 
Young, Adamson & Wilson, (Hartlepool). 

I use GRAMPS v5.0 software. 

My ancestors are probably turning in their graves, not that I can actually find any of them.