RootsChat.Com
General => Ancestral Family Tree DNA Testing => Topic started by: Kerrill on Thursday 27 May 21 09:02 BST (UK)
-
Hi , I am attempting to do a Leeds Method chart to try and sort my dna matches but as I am not all that clued up on how to make a spread sheet I am hoping someone can point me in the right direction so I could obtain a blank copy of one.
-
The Leeds Method spreadsheet at https://memoriesintime.co.nz/collections/family-history/products/dna-match-leeds-method-worksheet is apparently free, albeit others at same site are chargeable.
It is very easy to make your own on programmes like Microsoft Excel or equivalent. You could even draw up a basic one using good old pencil, paper and some colouring pencils.
-
It amazes me that Ancestry don’t provide any colourful matching tools like the other companies do. ;D
You could upload your raw data to My Heritage and FTDNA and pay a one off fee to allow you to access their nice tools.
The minus is that the databases are a lot smaller with other companies, but you might get lucky. :)
-
Thanks very much for the replies, I just might do that Ruskie.
-
There is a great video on this subject on the Facebook group -DNA help for Genealogy (UK), which covers the method, and a few other topics. Otherwise find it on Youtube:-
https://www.youtube.com/watch?v=5yfAfpANktg
-
You can use the Ancestry groups in a similar fashion. Create four groups. (or more) using their color dot codes. Leeds stresses that you work with 2nd cousins matching between 70cM to 200 cM. Go to your first match, select the match, and then shared matches. Use the group 1 color and add all these shared matches to the group. Go back to dna matches and look for the next match that is not in group 1. Repeat the process with the new match using group 2.
Dana has a blog and website and you should be able to watch a video on her method, perhaps on Youtube also Good luck