DNA survey - please respond

OK, will have a go but don't have time today, I'm afraid.

 

I wasn't sure about this either. I went from very light yellow all the way to dark orange but I saw your example had blue in there also - before I try the new sheet with Wales added please can you clarify what blue vs. yellow means?

Thanks.

 

Here is my spreadsheet - with Welsh ancestry showing up well. Carmarthenshire and Pembrokeshire at the top of the list include a great many north American matches.

Just to note an anomaly - I have far more than 50 matches with Anglesey born ancestors but Ancestry doesn't seem to be handling Anglesey place names properly.

 

Attached new spreadsheets for myself (no known Welsh ancestry) and my husband (half Welsh). All the Welsh counties come at the bottom of my spreadsheet as expected. They are further up in my husband's list but not as high as I thought they would be, with his main county (Montgomeryshire) only mid-table.

In going through my English counties again I realised I'd previously given too many pages to Oxfordshire giving it a falsely high position - now corrected so that anomaly removed. My dominant county Lancashire has moved down from top to 4th but this is probably a result of hitting the Ancestry limit of 40 pages of matches, as only another 4 would put Lancs on top again. Many of my ancestors come from Manchester so that maybe explains why nearby Cheshire is so high (top!) in my list.

 

Updated to the Wales version.
With a Jones 3x GG (birth location not known but only known descendent born in Staffs) I was hoping for a hit from the Welsh counties but they are all at the bottom of the list :-(
Staffs has been pushed back down to 2nd place by Wilts (no known connection)
Yorks has been pushed down to #7 from #4
Durham now down to #33 from #8
These new calculations appear to be less accurate compared to the last as far as I am concerned.

 

Just returned from a break but picked up there is a revised version including Wales. I attach my updated Spreadsheet. I have shown the numbers of 3xG ancestors as requested to explain my highlighting. I personally think it is not as good prediction wise for me as the 1801 version but not really had time to digest its overall impact.

 

Here is my updated version, and I have also now done my husband's. So far, all his ancestry is from 5 adjoining counties.
Neither of us appear to have Welsh ancestry.

 

Here is my updated version including Wales. There doesn't appear to be much difference between this and the 1801 version. Glamorganshire was a surprise, given that my two known ancestors from Wales were from Flintshire and Denbighshire in the north. Possibly relates to my Hughes family in Wiltshire?

 

Here are my two updated versions - version 1 (with updated colour shades) and version 2 - Version 2 doesn't feel as accurate as version 1 however.

Neither of my paternal lines have any Welsh ancestry and I added a smaller addition of the number of ancestors (on appropriate sheets) born outside of either England or Wales.
I have included myself, my two brothers (B1 and B2), my mother (maternal), my father (paternal) and my paternal grandmother (PG). We each have a sheet at the bottom of the spreadsheet so that I don't clutter the place up with too many different documents.

 

Here is the spreadsheet with my results for the Wales counties added and I also adjusted the weightings for the 3G Grandparents - Previously I just using 1 for each county regardless of whether the ancestry was split between 2 or more counties.

I don't have any "direct ancestors" born in Wales that I know of but they lived very close to the border in Shropshire/Cheshire and some of them did cross over to Denbighshire/Flintshire at some point so I have known "Blood relatives" born there although I Haven't traced all the lines down to see if they remained there. If they did I would have expected more pages.

I definitely think Yorkshire would be higher up on the list if it wasn't for the 40 page limit.

 

my results on the new version spreadsheet

 

My updated sheet is attached. I have left some "calculation" data which may be of use - columA is the old county order (England only), columnG are the old columnB county results for comparison with columnF. ColumnI was calculated from the data to the right (formula in I53).

Note that this is a Libreoffice output in .xls format.

Phil

 

Can't remember if I sent my wife's spreadsheet previously although I do recall a separate analysis highlighted a heavy Northamptonshire element as well it should considering some 60% of her ancestry springs from that County. Here is her updated Spreadsheet with the Wales contingent added. Wiltshire appears an anomaly at the top as is Worcestershire but for the opposite reason; I believe it should be higher based on ancestry numbers.

 

Here are my results for the new spread sheet, and I've added a bit more variation to the highlighting as well. My four main counties are towards the top but Gloucestershire still seems to me lower than it should be, as does Leicestershire.