It's been twelve months since I first received my DNA results from Ancestry. Since then five more members of my immediate family have tested. Many close results have been people I have met or corresponded with over the years. Another has provided me with evidence that we may have found a descendants from a sibling missing in the late 1800s. However, there are some close matches who we can't accurately place in our family. After a couple of months I decided I needed to work out a system to visualise these results for myself. (I can't remember if I got this idea from someone or not). I decided to enter details in a spreadsheet with columns headed Match Name, Relationship, MCRA, My ancestor in the next generation, Match's ancestor next generation, Shared CM, Segments and a contact address if I had one. I then had pages for each of my grandparents and their ancestors. As further members of my family tested I also started pages for them. It got very messy! I needed anothe...