Status of Common Ancestor Spreadsheet
I have a spreadsheet of all Matches with Common Ancestors with me. It includes my Ancestors and their children down to each Match. See more at https://segmentology.org/2021/12/19/segmentology-common-ancestor-spreadsheet/ It’s a lot of work, so feel free to adapt it suit your needs.
I have been reviewing all of these Matches and adding a LOT more using Pro Tools. I posted various ways to do this here, and I’ve gone down all those rabbit holes. I’m now on a march to review these Matches methodically – from closest Ancestors to more distant. I’ve found that it’s essential to have “known” Matches highlighted in Shared Match lists to speed the process of determining new Matches with CAs and forming family groups. So I’m adopting a two phase process. First: Recheck all Matches for firm relationships and having a clear set of Dots that will spotlight them in a Shared Match List – probably out to 5C level; Then: I’ll go back and use Pro Tools to tease out new Matches to add in.
Toward this end, I’m going to paste a Table below that shows my progress to date; and later I’ll update the Table to show the effect of Pro Tools. I’ve used Ahnentafel numbers (male of an ancestral couple) – their names are not needed for this exercise, although I did use given names for children for the first two generations. The comment column gives some reasons why the cMs deviate from the averages as when there are double Cousins or half Cousins, or Ancestors out of the US. You may also note the high number of Matches for Ahnentafel 70 – it’s because I jumped to that Ancestor, and used Pro Tools to find several key Matches to help with a burning question.
Here is where I stand now:
Note that this summary has 2477 Matches, through the 5C level (4XG grandparents). I have another 6,070 Matches in the 6C to 8C group. My total is 8,547 Matches from AncestryDNA, out of about 100,000 total – I wanted to see what impact Pro Tools will have. We’ll see how far I can get…
[22CU] Segment-ology: Pro Tools Part 13 – Status of Common Ancestor Spreadsheet by Jim Bartlett 20241117
segment-ology 
Do you use just the 2C, 3C, etc matches or do you track all the “removed” ones in your stats as well?
LikeLike
Good question, Linnea…. I’ve done both in the past. For this blog post I averaged ALL the cousins that shared an Ancestor pair. That includes the 3C for a 2xG grandparent couple, and the 3C1R and 3C2R and an occasional 2C1R. About a year ago, I sorted my spreadsheet by the CZN column, and ran the averages for 3C, 3C1R, Half3C2R, etc. This gave me a compilation equivalent to the Shared cM Project. (Blaine had more close cousins and I had more distant cousins.) Jim
LikeLike
Pingback: Friday’s Family History Finds | Empty Branches on the Family Tree
Did I read this correctly, and you have about 100,000 matches on AncestryDNA?
LikeLike
Mike. Yes – not unusual. Should be more, but my maternal grandmother was from a Ancestors who immigrate to US c1860 (and I have much fewer Matches on that 1/4 of my Ancestry). From Ancestry summary page I have 97,845 today. Jim
LikeLike
Very interesting! I typically work with match lists of British residents or recent immigrants who typically have around 20,000 matches. That will bump up to about 30,000 if one parent was North American.
LikeLike