Perhaps this post needs the subtitle , “My Perfect Cousin Goes to GEDmatch.”
Most of us can keep track of information in spreadsheets. So how to do that with DNA? Well, the idea is to keep a list of matching DNA segments so that a new match can be compared to your known family members. That way you may be able to see where they fit in.
If you have tested at 23andme, MyHeritage. or Family Tree DNA, you can download your list of matches with their matching DNA segments either directly from your testing company or by using the tools at DNAgedcom. However AncestryDNA does not provide a list of matching segments.
Extract from my Dad’s Master DNA Segment Spreadsheet (click for a larger version)
Why would you want those? The short answer is to figure out which line a new DNA cousin belongs to. For the long answer, read on. For more posts about DNA spreadsheets click here or in the tag cloud, lower right hand column.
AncestryDNA testers can make a DNA segment spreadsheet by using any of a number of utilities at the GEDmatch web site. Start by uploading your raw DNA data (click here for that “how to” post). Your results will usually be ready for full comparisons the next day. Then buy the tier 1 utilities for at least one month ($10).
My preference for making a first spreadsheet is to use the Tier 1 GEDmatchMatching Segment Search. Then I go through the top matches from the ‘One-to-many’ matches report with that spreadsheet as a reference. I add notes on what I discover to my new spreadsheet.
A week ago on Easter Sunday my 96 year old Dad died. He was ready, but I was not. He had a wonderful life and everyone in his assisted living facility adored him. I was told he was a real gentleman, he was sweet, he sang so beautifully … When mother died seven years ago, we did not expect Dad to last long after her. They were married for 62 years and were still very much in love.
But that Norwegian optimism kept him going. Some days he thought I was my mother, some days he thought I was his mother, but after about a year he was back to his charming self and usually knew I was his daughter. This is one of my favorite pictures of them taken when I was a toddler.
Larry Munson, baby Kitty Munson, Gretchen Munson 1951
On Thursday my 2nd cousin Karen, who moved back to Norway some time ago, had us to her house for a lovely late lunch.
She lives in a fairly unique house with seven gables that her grandfather Oscar Bie bought and enlarged, staying with the original style, creating a lovely sun porch among other enhancements. The ceiling is low in the old part as you can see; Karen is touching it.
She looked through her photo albums and I found two that included my grandmother and many other wonderful ones. I took photos of a number of her photos so we will see how well they turn out
One of my cousins (half Norwegian) on Dad’s side (all Norwegian) just got his results. So I made this chart comparing myself to my 1st, 2nd, and 3rd cousins on Dad’s side. Mind you, the 2nd cousin is on Dad’s paternal side while the third cousin is on his mom’s side.
Kitty’s DNA versus her cousins
My brother’s chart looks very similar except no X match of course. Notice the very large X match I have with my first cousin which would come from his mother and my Dad’s mother, 57.3 cM. Interesting to see this as compared to my Dad ….