June 29, 2013
I guess everyone appreciates a compliment - and we at WorldFamilies are no different. I'd like to share this one that came in today:
I just wanted to send you a HUGE thank you for the work that you do on the _______ Surname Project spreadsheets.
They are SO fantastic!!!! I love the way you do the groupings with the row above that has the common markers with "?" for the markers where there are differences. You set the bar for project spreadsheets!
I can't tell you how many times I've gone crazy reading Project spreadsheets (and I love spreadsheets and am very experienced with using them....), trying to figure out the differences between the data on people near mine (i.e., my cousins') without getting lost on the row.
Again, a big thank you for the time you take from your own family history research and family-dna research to give us the benefit of your knowledge and experience with genealogy DNA.
Comments - added June 30, 2013
Our presentation of results has evolved over 11 years of use. First, we group men by general Haplogroup, then we identify "Lineages" - which are the men who share a recent common ancestor with each orther. We present each Lineage separately, comparing against the apparent ancestral haplotype of the common ancestor of that Lineage. Men without a match in the project are grouped within their haplogroup into a category that we call "Haplogroup ___ - No match yet in the project".
Note: our Lineage matching assessments are the same as FTDNA - as long as there are only two men in the Lineage. With three or more men in a Lineage, we compare against the apparent ancestral haplotype - which is also the Lineage Haplotype (shown in the first row of a Lineage). This can cause us to group some men together who are not reported as a match at FTDNA becasue each has differing mutations from the Lineage Haplotype.
We use a reference haplotype for each Haplogroup - which is the basis for all colorizing within that haplogroup's Lineages. We report the info in each kit's "Most Distant Ancestor" field for our "Earliest Known Ancestor" field.
Men who are only tested at 12 markers who are matching a Lineage go into a category called "Possible Lineage __". Men with 25 or more markers who just miss the matching parameters also go into the "Possible Lineage" category.
You can see the spreadsheets that Lucy is talking about at project sites supported by WorldFamilies awhere our Results Tool is used.. Here are several examples: