Ann I've downloaded all the COA spreadsheets over the years. Everyone who shares genomes gets one. I sort them by Chr & Start; find my name on their list; highlight the overlapping area on their list around my segment; then compare those names (in the highlighted area) with the same area on my spreadsheet. The Matches in common Triangulate! I match the COA person, and we both have the same Match on overlapping segments. This Triangulates my 23andMe Matches who have taken the COA survey (some of them haven't shared genomes with me.) I also offer to send this sorted spreadsheet to the Match, in exchange for their email;>j Jim - www.segmentology.org > On Nov 1, 2015, at 4:42 AM, Ann Turner via <genealogy-dna@rootsweb.com> wrote: > > For people who are downloading hundreds of files, what are your plans for > using them? I used Countries of Ancestry very heavily to triangulate people > who appear on the lists of known cousins (e.g. John Smith is on my list and > also on the list of my second cousin), so I'm just downloading the > pertinent lists. > > Ann Turner > > On Sat, Oct 31, 2015 at 10:56 PM, Marilyn Bess via < > genealogy-dna@rootsweb.com> wrote: > >> Thanks everyone. I have over 2000 in my COA. I started downloading them >> but only one of my computers has a spread sheet program on it. I am also >> hampered by remodeling on my home and the needs of family member. I gave >> up on re-inviting because it is too time consuming.Then I have had >> acceptance come four year later. My biggest success has been with public >> matches. I have had a few first time acceptance. now back to inviting. >> Several of my profiles have almost two thousand relatives. Thanks again. >> Marilyn

I also download CoA lists for people I share with as they come in, but I'm not planning to download an update for everyone, just for my known cousins. Ann Turner On Sun, Nov 1, 2015 at 5:12 AM, Jim Bartlett <jim4bartletts@verizon.net> wrote: > Ann > > I've downloaded all the COA spreadsheets over the years. Everyone who > shares genomes gets one. I sort them by Chr & Start; find my name on their > list; highlight the overlapping area on their list around my segment; then > compare those names (in the highlighted area) with the same area on my > spreadsheet. The Matches in common Triangulate! I match the COA person, and > we both have the same Match on overlapping segments. This Triangulates my > 23andMe Matches who have taken the COA survey (some of them haven't shared > genomes with me.) I also offer to send this sorted spreadsheet to the > Match, in exchange for their email;>j > > Jim - www.segmentology.org > > > On Nov 1, 2015, at 4:42 AM, Ann Turner via <genealogy-dna@rootsweb.com> > wrote: > > > > For people who are downloading hundreds of files, what are your plans for > > using them? I used Countries of Ancestry very heavily to triangulate > people > > who appear on the lists of known cousins (e.g. John Smith is on my list > and > > also on the list of my second cousin), so I'm just downloading the > > pertinent lists. > > > > Ann Turner > > > > On Sat, Oct 31, 2015 at 10:56 PM, Marilyn Bess via < > > genealogy-dna@rootsweb.com> wrote: > > > >> Thanks everyone. I have over 2000 in my COA. I started downloading them > >> but only one of my computers has a spread sheet program on it. I am also > >> hampered by remodeling on my home and the needs of family member. I > gave > >> up on re-inviting because it is too time consuming.Then I have had > >> acceptance come four year later. My biggest success has been with > public > >> matches. I have had a few first time acceptance. now back to inviting. > >> Several of my profiles have almost two thousand relatives. Thanks again. > >> Marilyn >