I have signed up and made a paste titled "Dodecad K12b". Just copied the entire spreadsheet from Vahaduo. What else do I need to do? Here it is: https://pastebin.com/pD1vFFRF. This is it?Quote:
Originally Posted by Lucas
Printable View
I have signed up and made a paste titled "Dodecad K12b". Just copied the entire spreadsheet from Vahaduo. What else do I need to do? Here it is: https://pastebin.com/pD1vFFRF. This is it?Quote:
Originally Posted by Lucas
If you created "paste" from that, check url of it and post here. Something like that https://pastebin.com/7cn4xK0CQuote:
Originally Posted by Leto
Done, see above.Quote:
Originally Posted by Lucas
Ok connected to website too.Quote:
Originally Posted by Leto
Cool. I may as well curate the K13 new world sheet, seeing as they're my averages. Here is the URL: https://pastebin.com/CzzGEH9DQuote:
Originally Posted by Lucas
Can we finally have two separate K13 updated sheets now, one more broad and one more specific?
Distance to: de_Burgh_II
2.97585282 Cornish
2.97852312 French_Brittany
3.20376341 English_Southwest
3.72997319 Welsh
3.97416658 English_Midlands
3.97743636 English
4.00293642 English_Southeast
4.24004717 Scottish_North-Highlands
4.43209883 Scottish_East
4.47172226 Irish_Leinster
4.49415176 English_North
4.72339920 Scottish
4.90598614 Scottish_Northeast
4.94657457 Scottish_Southwest
5.33571926 Irish
5.72546941 Orcadian
5.74159386 Dutch_South
5.85169206 Irish_Munster
5.86156976 Irish_Ulster
5.99555669 Flemish
6.03197314 Irish_Connacht
6.14320763 Scottish_Gaidhealtachd
6.16533049 French_Normandy
6.36392175 Dutch
6.38360400 Belgian
Colonial/World averages:
Distance to: de_Burgh_II
2.43417337 French_Brittany
2.96870342 Canada_Newfoundland
3.20376341 English_Southwest
3.23936722 Canada_Nova_Scotia
3.44393670 US_Maine
3.50141400 US_North_Carolina
3.56443544 US_Nebraska
3.56610432 US_Virginia
3.58188498 Australia_Tasmania
3.58375501 US_Kentucky
3.61708446 Australia_New_South_Wales
3.61865997 US_Georgia
3.63705925 US_South
3.64123605 Australia_Victoria
3.65417569 US_Mississippi
3.70178335 US_Alabama
3.72573483 New_Zealand
3.72997319 Welsh
3.79984210 NZ_Colonial
3.81131211 US_Tennessee
3.83804638 US_West_Virginia
3.86130807 English
3.87530644 Australia_Colonial
3.97416658 English_Midlands
4.01988806 English_Southeast
If you were to create a separate more detailed European regional sheet (in the custom calcs), I'd be happy to be responsible for the NW European averages (British Isles, Benelux, and French/Scandinavians I guess), if that's possible.Quote:
Originally Posted by Creoda
I think it'd be a nice feature if when the sheets on "Vahaduo tools for Gedmatch calculators" change, that there is a date associated with each so folks can tell versions or last updates for reference.
So please create "paste" for that sheet new detailed regional and I will create page for that later.Quote:
Originally Posted by Creoda
I connected New World sheet to your paste.
I want to do it automatically but must think.Quote:
Originally Posted by PLogan
Here is the URL with averages for those countries: https://pastebin.com/1H0TwEFm . My idea is not to have national averages for this sheet if there are smaller regional averages available, it is essentially for the smallest divisions necessary. I hope all the small German regional averages will be added to this sheet for example, and more condensed ones for the main sheet.Quote:
Originally Posted by Lucas
Please feel free to add all German/Austrian regional pops to your sheet. Meanwhile I will try to make broader (NW, SW, NE, SE) averages with rothaer for my sheet. We will update some averages as well.Quote:
Originally Posted by Creoda
I'll see if Lucas is able to divide the sheet up first like he said, otherwise I'll be fine with curating the whole thing.Quote:
Originally Posted by Stearsolina
OK so it is K13 Updated Smaller Regions Version https://vahaduo.genetics.ovh/k13-vah...l_regions.htmlQuote:
Originally Posted by Creoda
Now is only your "paste" for NW Euro but as Feiichy said you can add rest of averages and gradually replace bigger averages with smaller if they will be created.
OK, if that's the way we're doing it, I've added all the regional averages from around Europe. Now the main sheet can be simplified if necessary.Quote:
Originally Posted by Lucas
Did you also include Jews and Italians for your NYC average?Quote:
Originally Posted by Creoda
Spoiler!
Turkey is apparently a white country while Jewish groups and the Caucasus are not :DQuote:
Originally Posted by Creoda
Yes, clearly. I included them for any region, but multigenerational Jews/Italians didn't show up much in most areas, at least on gedmatch.Quote:
Originally Posted by Ajeje Brazorf
I was mainly just trying to limit it to groups from within Europe, but I couldn't be bothered working out which Turkish groups were in geographical Europe or not.Quote:
Originally Posted by Leto
Sure, that's what I was thinking. But I think without the non-Europeans modeling will be deficient in many cases, i.e. bigger distances.Quote:
Originally Posted by Creoda
That's what the main sheet is for. This sheet is more about modelling smaller European regions, distances to other regions, PCAs etc. The 2-way mechanism will also be faster with less data there.Quote:
Originally Posted by Leto
But I can add the non-Euro's below if people want. Or maybe just a few basic non-white racial averages - SSA, East Asian, Amerindian etc.
Also you can think of avering Greece avs, there are too many small islands there. Full list could stay in Creoda Small Regions.Quote:
Originally Posted by Stearsolina
sure!Quote:
Originally Posted by Lucas
do you want some labeling changed? I saw before complains about Serb_Republic_Srpska and some Polish regions.Quote:
Originally Posted by vbnetkhio
there many things that should be changed, but first, what will be the concept of the new sheets?Quote:
Originally Posted by Stearsolina
I think in your sheet, Serbs and Croats should have only one average, and more diverse ethnicites should have 4-5 averages at most, if you agree? Or do you think there should be a third sheet for that?
Could you say what would you want fixed?Quote:
Originally Posted by vbnetkhio
Yes, I agree with you. I think that's good idea. I would just have two averages for Croats (plus general), because we basically have two clusters (Kajkavian and the rest).
For Serbs maybe you can make one for most of Serbs and other for SE and Montenegrin Serbs for eg plus general average. Just an idea.
Yes, for nations without notable regional diversity like Albanians for eg I really agree to one average. For larger nations 4-5 max, true.
If you want to only have one or max two averages in K13 Updated then you can put all Hungarian regional averages to the expanded sheet and only leave the Transylvanian average, since it is pretty unique. Maybe leave North Hungarian too, since it has a distance of 3 to the Hungarian average, but I don't know if that is enough to make it that unique?Quote:
Originally Posted by Stearsolina
Also if you decide to make broader averages for Greece, Italy and other countries, try to weigh them based on how much people those averages represent. Some of them represent ca. 300.000 people, while others ca. 2 million.
in your sheet, remove the regional Serbian and Montenegrin averages, and update these:Quote:
Originally Posted by Stearsolina
also, some of the Greek averages are false (like the one for Western Thrace which is actually Pelpoponnesian), they should be replaced by these academic samples and proper averages before you group them into larger regions.Code:Serb,24.83,29.18,17.10,8.89,15.96,1.66,0.53,0.30,0.61,0.49,0.33,0.06,0.08
Montenegrin,23.78,26.42,18.93,9.56,17.29,1.64,0.53,0.31,0.61,0.56,0.28,0.04,0.06
Aromanian,21.38,19.84,19.71,11.24,23.23,2.94,0.15,0.36,0.51,0.30,0.27,0.06,0.00
Code:Greek_Athens,18,12.97,21.34,14.07,27.58,3.93,0.36,0.53,0.32,0.18,0.27,0.16,0.28
Greek_Cappadocia,6.02,3.11,16.96,28.66,37.29,5.82,1.07,0.15,0.63,0.08,0.21,0,0
Greek_Central,17.81,13.51,20.59,14.66,27.3,4.05,0.6,0.29,0.33,0.42,0.4,0.03,0.01
Greek_CentralMacedonia,18.75,18.2,20.84,12.78,24.45,2.69,0.61,0.32,0.41,0.43,0.26,0.15,0.12
Greek_Crete,13.27,8.94,19.48,18.05,32.46,5.55,0.55,0.35,0.27,0.16,0.33,0.39,0.19
Greek_Dodecanese,10.53,5.27,20.42,19.62,35.88,6.29,0.64,0.61,0.11,0.08,0.24,0.27,0.04
Greek_Kos,12.12,5.57,19.99,20.06,34.33,6.16,0.33,0.51,0.12,0.26,0.33,0.15,0.07
Greek_Peloponnese,18.52,15.57,20.38,12.29,27.35,4.01,0.16,0.28,0.42,0.24,0.50,0.10,0.18
Greek_Southeast_Laconia,15.8,12.55,21.4,13.1,28.83,5.25,0.15,0.43,0.11,0.38,0.04,1.17,0.78
Greek_Smyrna&Phokaia,16.63,11.89,20.53,15.6,29.3,4.24,0.1,0.62,0.28,0.19,0.37,0.2,0.06
Greek_Thessaly,20.57,16.87,20.64,11.95,24.54,3.49,0.45,0.4,0.37,0.53,0.31,0.04,0.11
Greek_Thrace,16.15,15.82,19.26,15.31,28.11,3.28,0.36,0.25,0.36,0.09,0.55,0.29,0.19
Greek_West,18.22,18.63,20.5,13.48,24.98,2.64,0,0.63,0.34,0.13,0.37,0.05,0.05
Greek_Pontus,2.31,1.6,15.84,37.71,36.38,3.88,1.29,0.32,0.22,0.04,0.36,0.01,0.03
Greek_Cyclades,17.87,9.96,20.68,15.25,28.66,4.63,0.1,0.57,0.5,0.54,0.53,0.16,0.08
Greek_Lefkada,20.6,11.93,21.04,9.4,31.18,3.6,0,0,0,0,0,0,0
Greek_Achaea,18.03,17.36,20.32,13.86,25.45,3.07,0.00,0.15,0.28,0.34,0.75,0.33,0.05
Greek_Andros,17.49,7.08,20.60,13.75,33.45,5.18,0.00,0.64,0.48,0.42,0.44,0.26,0.22
Greek_Arcadia,18.67,15.99,22.74,11.72,25.92,3.52,0.00,0.20,0.29,0.25,0.11,0.60,0.00
Greek_Chios,12.44,7.95,20.50,18.87,33.30,5.32,0.34,0.28,0.24,0.11,0.30,0.33,0.04
Greek_Cyprus,7.55,2.17,20.48,19.47,41.02,7.60,0.14,0.46,0.15,0.02,0.27,0.67,0.00
Greek_Deep_Mani,15.21,8.70,20.91,14.82,32.69,5.67,0.26,0.50,0.10,0.24,0.52,0.39,0.00
Greek_Epirus,20.37,17.42,19.60,13.54,25.79,1.85,0.00,0.00,0.93,0.00,0.44,0.00,0.06
Greek_Euboea_South,20.06,14.63,22.07,12.29,25.65,4.18,0.05,0.35,0.13,0.21,0.28,0.06,0.01
Greek_Florina,21.38,20.79,20.04,11.18,23.01,2.09,0.23,0.29,0.51,0.17,0.27,0.03,0.02
Greek_Ikaria,12.91,7.77,21.44,16.75,33.87,5.34,1.01,0.23,0.17,0.01,0.45,0.04,0.00
Greek_Kalymnos,11.96,6.79,20.84,18.43,35.00,5.30,0.61,0.28,0.02,0.06,0.27,0.40,0.04
Greek_Karpathos,10.68,5.74,20.58,19.19,34.18,7.47,0.86,0.64,0.14,0.09,0.00,0.30,0.13
Greek_Kastellorizo,9.57,3.93,19.32,20.10,40.03,5.21,0.04,0.53,0.11,0.04,0.49,0.52,0.11
Greek_Kefalonia,17.53,11.97,21.39,14.65,28.21,4.91,0.28,0.16,0.23,0.25,0.32,0.12,0.00
Greek_Konya,6.50,4.87,19.02,26.51,35.81,5.20,0.94,0.07,0.55,0.03,0.51,0.00,0.00
Greek_Kos,12.13,5.57,19.98,20.06,34.34,6.16,0.31,0.54,0.10,0.18,0.40,0.14,0.08
Greek_Kythera,14.77,9.49,19.93,15.93,32.13,5.74,0.74,0.07,0.30,0.46,0.14,0.30,0.00
Greek_Laconia,18.84,15.11,20.50,12.63,26.97,4.43,0.31,0.44,0.26,0.14,0.28,0.01,0.07
Greek_Laconia_Karitsa,20.99,14.91,20.66,13.09,24.68,4.27,0.07,0.21,0.29,0.40,0.10,0.31,0.01
Greek_Lesbos,14.61,9.99,18.42,18.44,31.50,4.87,0.06,0.72,0.64,0.15,0.49,0.11,0.02
Greek_Messenia,18.78,15.09,21.04,13.10,27.21,2.99,0.43,0.41,0.29,0.28,0.32,0.06,0.00
Greek_Nisyros,14.49,5.02,19.94,18.20,34.34,5.49,0.33,0.12,0.15,0.43,0.57,0.43,0.50
Greek_Rhodes,10.04,3.54,21.36,19.05,38.25,6.00,0.22,0.19,0.34,0.15,0.59,0.27,0.00
Greek_Samos,17.74,10.86,20.44,17.69,27.34,4.03,0.11,0.42,0.17,0.00,0.64,0.01,0.56
Greek_Symi,10.31,3.21,20.58,19.40,38.22,5.84,0.72,0.03,0.46,0.17,0.46,0.50,0.10
Greek_Tsakonia,16.73,11.60,21.69,13.28,31.37,3.87,0.14,0.33,0.00,0.34,0.63,0.03,0.00
Do I understand correctly that my current averages were pasted to "smaller regions" sheet and that's where they are expected to be updated moving forward?Quote:
Originally Posted by Stearsolina
And the usual old sheet is now meant for bigger regions? Perhaps that can be mentioned in the name of the sheet to make it clear.
If my usual averages are by region, then these will be geographic to avoid any confusion between similar names.
Here are averages for the bigger regions sheet. This is not enough to cover the diversity found in each region, but if you want to limit, then that's one way to do it and still have averages that capture the genetic profiles found in Romanians.
https://i.imgur.com/YFIqAWB.png
https://i.imgur.com/ge49XQ3.png
https://i.imgur.com/kDwzVld.png
For Republic of Moldova - North, Centre and South is enough as they are all distinct enough. You can remove the national average since it's close to Centre.Code:Romanian_North,25.18,30.90,15.24,8.99,14.12,1.63,0.84,0.55,1.29,0.54,0.44,0.16,0.11
Romanian_Centre,24.25,26.42,17.14,10.01,16.88,1.85,0.60,0.58,1.10,0.58,0.38,0.10,0.10
Romanian_South,22.69,24.72,17.67,10.97,18.57,2.05,0.63,0.64,1.03,0.49,0.34,0.11,0.10
I have no idea how to make Bulgaria into 3 parts so that it keeps the diversity of the Coast, Thrace, Sofia region, Northwest, Central Balkan mountains, etc. Ideas would be appreciated.
Also both have links to other one at the top.Quote:
Originally Posted by Ion Basescul
https://i.imgur.com/dQz7Qid.png
maybe west/central/east, or just west and east(+central)Quote:
Originally Posted by Ion Basescul
I was fearing that the difference between Northwest and Southwest is huge, but it's actually 2.7 so not that bad overall.Quote:
Originally Posted by vbnetkhio
I will give it a try.
I removed French Provence from the main sheet and renamed it as an outlier in the detailed sheet, as it plots deep into Italian territory (Stearsolina and I agreed to share editing access for both sheets). Also removed Cornish and Orcadian from the main sheet as they're unnecessary/unreliable.
That looks fine with me.
I had 6 regions before as in the NUTS-2 map below, and now they've been reduced to 3 for the "Bigger regions" sheet.
https://www.researchgate.net/profile...and-NUTS-3.png
Population: 2.8 million
https://i.imgur.com/D6ODOCn.png
Population: 2.2 million
https://i.imgur.com/RoeyAS3.png
Population: 2 million
https://i.imgur.com/D3lWDoE.png
Code:Bulgarian_Western,22.07,25.29,17.67,11.07,18.90,2.28,0.46,0.52,0.68,0.55,0.34,0.08,0.10
Bulgarian_Central,21.04,24.37,17.93,11.70,19.89,2.41,0.58,0.37,0.80,0.35,0.38,0.12,0.06
Bulgarian_Eastern,20.34,22.65,18.01,12.96,20.61,2.65,0.61,0.36,0.68,0.40,0.46,0.14,0.08
How do you get the US averages and why is Florida missing?
How do you get national averages anyway?
Why so many questions for the first post? ;)Quote:
Originally Posted by N-rg
Good, it will be community work. You can add someone trustful too.Quote:
Originally Posted by Creoda
done.Quote:
Originally Posted by vbnetkhio
Left Hungarian, Transylvanian and Hungarian_North for now. Let me know if you want any further changes. I think keeping Hun north is okay for Hungary which has medium-sized population for Euro standards, and they are notably more Slavic.Quote:
Originally Posted by Dunai
that way it shows continuity towards Slovaks in the north Hungarian average does not have.
-removed all Bosniak averages except general and Sandžak
-removed all Hungarian averages except general, Transylvania and northern
-removed all Croatian regions, except general, added northern and southern
-removed Serbian/Montenegrin regions and updated their averages
-Aromanian average was updated
-deleted Greek regions and added all regions Vbn posted
what to do with Greece now?