Search for content in message boards

Spreadsheets for autosomal DNA

Replies: 11

Re: Spreadsheets for autosomal DNA

Posted: 17 Jan 2014 7:20PM GMT
Classification: Query
My spreadsheet is up to column AC now! It has pretty much everything that can be downloaded at DNAGedcom as well as hyperlinks to ancestry's family tree and their webpage, if they have one, as well as y and x haplogroup, if known and available, whether they match my mom as well, and their GEDMatch kit number. I manage three kits, my mom, my brother and myself, all at FTDNA and GEDMatch and all combined into the same spreadsheet. I can sort by chrome and segment and determine at a glance whether the match is maternal or paternal.

Here, you can convert FTDNA trees to gedcoms in seconds, and you get a lot more information than FTDNA's trees display: http://kelleyllc.com/ftdna-gedcom/

With this tool, I was able to retrieve trees for 4 people within 3-5 cousin range that all match the same segment on Chrome 13. I'm building a private dummy tree on ancestry with these trees. Eventually, I hope to find our common ancestor, and ultimately my Dad's birth parents.
SubjectAuthorDate Posted
jimbartlett1 4 Jan 2014 2:34PM GMT 
Dan Stone 7 Jan 2014 7:03PM GMT 
jimbartlett1 7 Jan 2014 7:18PM GMT 
MJ782 10 Jan 2014 5:24AM GMT 
joyecho 10 Jan 2014 3:24PM GMT 
jbarry6899 10 Jan 2014 3:33PM GMT 
MJ782 10 Jan 2014 9:31PM GMT 
Smilebird 18 Jan 2014 5:08PM GMT 
joyecho 11 Jan 2014 12:13AM GMT 
allycat113 18 Jan 2014 2:20AM GMT 
per page

Find a board about a specific topic