The Spreadsheet
By popular request, below is a section of my Common Ancestor Spreadsheet. Shown are most of the essential columns, In order to fit the space I have in this blog, I’ve deleted a number of columns that I use to record, emails, TGs, Notes, Y or mtDNA possibilities, etc. – they are not pertinent to point of this post. On the far right are 3 columns for cMs between a Match and the *Match for that column.
Common Ancestor Spreadsheet with columns for Shared cM between Matches
Note this part of the spreadsheet is for DNA cousins on my Ancestor John H BARTLETT b 1804 (married to Sarah FLEMING). For each Match, I have their Name, any Admin, cM (with me), # segs, Ahnentafel of MRCA couple (all are 16 in this section), Cousinship; and then the given name and birth year of the child of the MRCA through which they descend; same for grandchild; and Great grandchild; and then a column for more descendants if desired (all in one cell – and I usually run this out – down to the Match). The ** in green means that Match (and the path) is in my Tree. The next columns are for entering an * for a Key *Match and the amount of shared cM between the other Matches and that *Match. You’ll note near the bottom of the spreadsheet, child James b 1836 is listed – he is the child that I descend from (and cousin on him would be under Ahnentafel 8). Hundreds of other MRCA couples, thousands of Match cousin, are in other sections – all sorted by Ahnentafel # and birth year columns.
To do a perfect matrix, I’d need to have 67 columns to show all of the pair-wise relationships. I think I can get a pretty good picture from only one Match for grandchild. And, of course, as I find Shared cMs over about 100, I usually go down each of those rabbit holes and wind up adding most of those Matches to my spreadsheet.
Please feel free to use as much of this format as you link, AND to add/delete/shift columns to suit your own style of research and analysis.
[22CL] Segment-ology: ProTools Part 4 The Spreadsheet; by Jim Bartlett 20240705a
segment-ology 
Ho il test di mia madre ma ha lei non corrispondono adesso e rimasto il mio test.e ho 2 triangolazioni separate stesso chr 16 stessa posizione ma triangola ognuno da parte.e alcuni match del primo gruppi hanno stessi numeri iniziali e finali con altro gruppo e strano ma quando li metto insieme stessa posizione stesso chr 16 non triangolano.insomma ho 2 TG sullo stesso chr 16 stesse posizione e strano che vuol dire kevin.
LikeLike
Kevin – remind me – are you using MyHeritage? If so, I would combine them all into one TG – as long as most segments Triangulate with most others in one-on-one camparisons. Jim
LikeLike
Kevin.si jim e su mhyeritage due tg stessa posizione alcuni match stessi numeri inziali e finali con me e con quel altro gruppo.ma insomma ho 2 tg stessa posizione ma tg separati.adesso sono rimasto io come test un gruppo non so se e da parte nonni paterno ho nonna paterna e poi quel tg sconosciuto e strano perche questo tg sconosciuto diciamo tra loro sono certi piu vicini di parentela tra loro.
LikeLike
Kevin, Thanks for confirming you are using MyHeritage. First,: the same start and end positions usually mark the start and end of a segment of your DNA from one Ancestor (on one side). Second: MyHeritage “imputes” some SNPs, and because of that, it has some issues in declaring a TG with larger groups of segments. So the Triangulation process at MyHeritage is to work in pairs. If you and A and B have a TG, OK. If you and A and C have a TG in the same area, OK. If you try to test for you and A and B and C for a TG, it sometimes fails (at MyHeritage), but you can still count it as a single TG. Jim
LikeLike