Karla My point was that CoA has your own spreadsheet and a spreadsheet for each person you share genomes with. The people in each of these spreadsheets are folks who have completed the survey - many of them have are not sharing genomes with you, and are thus not included in FI:A. But in your CoA spreadsheet they are there - with segment data. They help flesh out your map, and you can message them about Common Ancestors. When I open a CoA spreadsheet for someone who is sharing genomes with me, I sort the spreadsheet on Chr and Start and search for me! I then highlight everyone above and below me with an overlapping segment. I then look at this same segment area of my master spreadsheet, and bold the folks who are also on overlapping segments with me - these are all in a Triangulated Group for me. Thus me and my Match and all of these bolded folks will share the same Common Ancestor. The ones on my Match's spreadsheet who are not bolded, are probably cousins on his/her other side. Jim - Sent from my iPhone - FaceTime! On Sep 25, 2013, at 9:23 PM, Karla Huebner <calypsospots@gmail.com> wrote: > Jim is right that using one or more spreadsheets is good (although I keep > thinking that surely a database would be better--perhaps because I'm more > familiar with databases than spreadsheets, but also because most of the > data doesn't require calculations but one does want to see different > portions of it for different purposes). > > Countries of Ancestry may be useful for some people, but thus far it has > been pretty much a waste of time for me. <snip>

Jim, OK, I see what you're getting at. That could be helpful despite the small number of people (especially people identified as more than "your relative" in my CoA. Thanks for explaining this more fully. Karla On Sat, Sep 28, 2013 at 11:32 AM, Jim Bartlett <jim4bartletts@verizon.net>wrote: > Karla > > My point was that CoA has your own spreadsheet and a spreadsheet for each > person you share genomes with. The people in each of these spreadsheets are > folks who have completed the survey - many of them have are not sharing > genomes with you, and are thus not included in FI:A. But in your CoA > spreadsheet they are there - with segment data. They help flesh out your > map, and you can message them about Common Ancestors. > > When I open a CoA spreadsheet for someone who is sharing genomes with me, > I sort the spreadsheet on Chr and Start and search for me! I then highlight > everyone above and below me with an overlapping segment. I then look at > this same segment area of my master spreadsheet, and bold the folks who are > also on overlapping segments with me - these are all in a Triangulated > Group for me. Thus me and my Match and all of these bolded folks will share > the same Common Ancestor. The ones on my Match's spreadsheet who are not > bolded, are probably cousins on his/her other side. > > Jim - Sent from my iPhone - FaceTime! > > >