I'd be interested to see how this is done please Di, as I need to think about how to progress.

Di, I would be interested too for when my results come back in a few weeks time.

Me too.

Hi Jill

Here is my Excel spreadsheet of the Leeds Colour Chart. It has three pages, my Dad, my daughter and my sister-in-law.

You will see they are slightly different as I tried out different ideas.
Lorraine's is only partly done, so I have not yet grouped the families together.

My daughters grandparent families are COLLIS, ECCLES, COLE and LANGLEY.
Dads are COLLIS, MARTIN, PAGE and DAWSON. Lorraine's are COLE, LANGLEY, TANNER and PARSONS.

You will see that COLE, PAGE and PARSONS DNA samples are very sparse.

Some of the family links were made by looking at the various family trees, others just by common matches. I should have put another column for MRCA (Most recent common ancestor) and added them as I found them, as this would help with the many COLLIS and TANNER samples.

A couple of lines are marked in special colours as they are of special interest to me. Very few of the COLLIS samples match to the TUPPER and BISHOP lines, so I am especially interested to find more matches for them.

I also tried out using our GEDMatch comparisons, but its a lot harder to set up.


Di

I'd love to have a look but I can't open it! I'm running Windows 10, I'm sure there must be a way but I don't know it :(

Thanks Di, you have given me plenty to think about!

If you're the same as me,(I'm also on Windows 10) it doesn't come with Excel so you will have to either buy it or find some other way of reading it. (I'm still trying to work it out, if I find a solution will let you know)

I will try and post it in another format. It may not work like Excel but you will be able to how it works.


Di

I have changed them to Word Docs, so you may be able to open these.

If not send me a pm and I can email them directly to you

Di

Thanks, Di. Very interesting!

Hope this might help somebody else. On my iMac I do not have Excel, nor even the Mac version, Numbers. But I have
downloaded your first (Excel) zip file,
double-clicked to unzip it, then
right-clicked on the unzipped file with extension .xlsx and
chose "Open With"
Preview.app.
Of course it no longer functions as a spreadsheet but it is big and beautiful with all the colors visible.