DNA connections and record keeping

I look after 7 DNA kits from Ancestry and all are uploaded to Family Tree DNA, My Heritage DNA and GEDmatch DNA. How do I keep a record of my matches, chromosomes and common information?

I have a spreadsheet on my google drive  which synchronizes across all my devices. This means whether I am at home on my desktop PC, or in a library with my iPad or my laptop then I can always get to that spreadsheet to make any changes.

I mainly work on my father’s DNA connections or my mother’s as they will be one generation closer to the Most Common Recent  Ancestor (MCRA) than if I work with mine or my brother’s.

The main DNA spreadsheet has lots of sheets relating to Dad

The first sheet has a copy of the first 2000 links from GEDmatch using the one-to-many test. This is just a straight copy/paste. I have then gone through the first 100 people using the one-to-one test to find out the chromosomes shared with my dad.  I am starting to colour code people who match each other when using the share 2 kits test. At least once a moth I update this sheet by checking the people marked in green on the main GEDmatch page for Dad. These will be the recent people who share his DNA.

The second sheet is a copy of the share 2 kits test for Dad and Kevin (his half brother)  This is a straight copy/paste. This means everyone on that list is from dad’s paternal side as dad and Kevin share a father. This list includes names and emails of the matches as well as the amount of cM shared and the generations between the matches. I am in contact with 3 people on this list so far.

The third sheet is one I have to create from information on available trees from the people in the Dad/Kevin list. I find their trees on any of the DNA websites. On this sheet I list the name of the person, the surnames at 4 or more generations away and where and when those people were born and died.

The fourth sheet is the share 2 kits test for Dad and Ruby. Anyone on this list relates to my dad’s maternal grandmother.

Dad/Patrick is because Patrick is the closest unknown link on the GEDmatch list at 3.9 generations.

I just found a great video from Ancestry explaining shared cM, mirror trees and a lot more. The sound is not too great and sounds a bit tunnelly.

My future plans

I will be starting a new spreadsheet for Mum’s DNA at some stage to keep all her information there.

On Ancestry, I have lots of trees, one labelled DNA Dad’s tree. It is here that I use the information from dad and Kevin matches to create mirror trees to find out where they link. So far I have about 6 trees started but none link yet. This will certainly be an ongoing project.

I also keep a separate spreadsheet with all those people I have already found a match to with DNA from either Mum or Dad. But I also include matches with the other people whose kits I look after eg Ruby, Dorothy and Kevin. The information in this is then sent to Blaine Bettinger’s shared cM Project via this Google form. The MCRA is usually a grandparent couple rather than an individual except in the case of my father’s grandmother. Most of my dad’s matches are half relationships and in the note column I will mention if the match is double cousins as I have on one side of mum’s tree. As Ancestry doesn’t give the largest number of cMs, I just put Ancestry in this column. When I have uploaded data to the shared cM project I put the year in the Done column. Anything highlighted in yellow is dad’s side but more information needs to be included, green is same but mum’s side.

Readers: How do you record your matches for DNA from all the websites or do you just use one website?

Checking the DNA

Since my last post, I have been doing some more work on the DNA tests that my immediate family had done as well as those relatives I asked to test to prove or disprove some of Dad’s background. (He is my problem child with a paper trail not matching his DNA very well.)

They all tested with Ancestry but I had uploaded the raw DNA data from the immediate family to Family Tree and My Heritage as well. I found some different names at these websites that were not included on the Ancestry site.

The one site I had uploaded everyone to was Gedmatch – the site US police are now using with cold case files.  It is here that people who have tested with any site upload their data so it is a huge database of  DNA connections. Again I found some new connections.

But it is only this last week that I decided to upload the other  relatives DNA raw data to FTDNA and MyHeritage. Immediately this helped me work out a new connection with my father.

Below is a quick pedigree chart for my dad. Now you can see why he is my problem child. Very little proven paperwork for his father – not even a birth date and place. But at least having his half brother tested means anyone who matches them both must come from dad’s paternal side of the tree. Now to build lots of trees from his DNA hits to see where the links are in all these trees.

On his mum’s side we have an unknown 1st-2nd cousin which could only possibly mean her father is not who we thought. Through testing a so called relative and a cousin we proved dad’s mother didn’t descend from my whaling captain William Smith. Now to find who her father really was – I have quite a few DNA hits that must relate there.

Dad’s maternal great grandparents are also a problem with 5 possibilities as the father and the mother born to one person but then living with another person with half siblings.

 

It is a lot of work trying to prove the paper trail using DNA at least it is for dad. My mum’s paper trail and DNA match well so I spend little time on that. Most hits are easier to find as I have most of her ancestors back at least 4 or 5 generations.

Readers: Have you DNA tested? If yes, what are you finding most difficult? Where have you uploaded your DNA raw data to?

DNA update

A couple of months ago, Ancestry updated their DNA ethnicity results so I thought I might compare from my previous results.

Sue’s results

Sue in 2017
Sue in 2018

 

 

 

 

 

 

 

 

Mum’s results

Mum in 2017
Mum in 2018

 

 

 

 

 

 

 

 

Dad’s results

Dad in 2017
Dad in 2018

 

 

 

 

 

 

 

 

Philip (brother) only has results for 2018

Philip in 2018

 

 

 

 

 

 

 

 

As you can see, my family are virtually totally Western European but especially from Great Britain.  The paper trail I have for mum matches her DNA trail, but dad’s paper trail is changing every day due to the DNA  results.

Originally I had no Irish in dad’s paper trail but I have now found three possible lines back to that country.

Readers: When your results were updated, did you notice much of a change?

 

Will, will or will

For this post, week 9 in #52ancestors, I had to decide:

  • Will I research a relative named Will or William?
  • Will I look at a will from one of my relatives?
  • Or will I research a relative who was willing to do more than most?

My decision was to check out the wills of some of my relatives. We are very lucky here in Tasmania that the wills of many people are found online at the LINC Tasmanian names index.

What did I learn from these wills?

My grandmother Hannah ENGLAND had bequeathed 25 pound to each of her grandchildren when they attained the age of 16.

My grandfather Henry Lewis ENGLAND bequeathed his piano to me. I remember as a child learning and practicing those scales and even now, after many years of not using the piano, I can still play most of Fur Elise from memory.

It looks like my great great grandparents John and Annie DAVEY did not leave wills so the Supreme Court appointed some of their children to make an inventory and then to sell the goods and chattels and hand the money to the court to pay costs. I am not very good at reading all that legalese though so it might mean something else entirely.

My great great grandfather Francis COLGRAVE left everything to his two youngest sons, presumably as the older sons already had their own properties and the older sisters were all married with their own families.

I can’t find any more wills of my direct relatives but one of my indirect relatives (sister of my great great grandmother Caroline Chandler nee Bryant) named Esther Julia WINTER left many instructions on who was to receive what in her will.

Readers: What is the most interesting will you have read in your family or from collateral kin?

 

 

Heirlooms

Week 8 in the #52ancestors challenge is looking at heirlooms. I didn’t really think I had anything handed down to me from my grandparents but after chatting to my mum who has been in hospital and rehab over the last three months, I found out about these pieces of carnival glass that were from her parents. I actually thought a couple of pieces were from my father’s mother but maybe I was wrong about that.

I can’t find any makers marks on them but they all seem to be marigold colour.  The vases look like they are swung – started as a tumbler then stretched or swung while still hot. I found a website about carnival glass but as many manufacturers used the same patterns and colours it can be hard to distinguish who made what, especially if no makers marks.

The large basket or bowl in the second image has ball feet on it, but I have noticed some large cracks through the base probably when it has been put down on a table. This is extremely heavy which might have also caused cracks when put on a table.

One of the vases is a lot heavier than the other and both have different patterns.

Northwood glass usually has a makers mark, but Fenton glass only from the 1970s. These are probably the two companies my glass came from as far as I can work out.

Readers: Do any of you know how to easily check carnival glass to work out who made it, what pattern it is and when was it made?