Gedmatch calculators on Vahaduo

**vbnetkhio** · 10-07-2020, 02:08 PM

Lucas, i hope i'm not asking for too much but i think this would improve the sheet greatly:

could you delete the "North_Macedonian" and Danish , because they are duplicates.

also remove these duplicates:

Code:

Tuscan,27.18,10.01,23.79,8.83,24.59,4.29,0.24,0.01,0.29,0.00,0.50,0.17,0.09
Tuscany,28.25,11.86,24.70,8.95,21.95,3.29,0.19,0.27,0.00,0.15,0.25,0.10,0.01
East_German,37.34,32.19,14.57,6.15,6.42,0.96,1.46,0.02,0.19,0.38,0.05,0.13,0.14
German_east,36.93,36.50,12.59,5.57,4.79,0.78,0.69,0.09,0.30,0.78,0.55,0.15,0.20
German_West,45.37,25.20,13.22,7.02,5.78,0.85,0.30,0.58,0.39,0.37,0.11,0.35,0.14
West_German,43.14,22.44,14.78,6.85,8.54,0.86,0.94,0.13,0.40,0.60,0.64,0.47,0.22

and replace them with these:

Code:

Italy_Tuscan,27.72,10.94,24.25,8.89,23.27,3.79,0.22,0.14,0.15,0.08,0.38,0.14,0.05
German_East,37.14,34.35,13.58,5.86,5.61,0.87,1.08,0.06,0.25,0.58,0.30,0.14,0.17
German_West,44.26,23.82,14.00,6.94,7.16,0.86,0.62,0.36,0.40,0.49,0.38,0.41,0.18

and if it's not too much work rename these averages:

Code:

MMacedonian -> Macedonian
North-Dutch -> Dutch_North
North-Swedish -> Swedish_North
North_German -> German_North
East_Finnish -> Finnish_East
Estonian_Polish -> Polish_Estonia
Kargopol_Russian -> Russian_Kargopol
Masurian -> Polish_Masurian
Abruzzo -> Italy_Abruzzo
AostaValley -> Italy_AostaValley
Apulia -> Italy_Apulia
Basilicata -> Italy_Basilicata
South_Dutch -> Dutch_South
South_Polish -> Polish_South
Southeast_English -> English_Southeast
Southwest_English -> English_Southwest
Southwest_Finnish -> Finnish_Southwest
Southwest_French -> French_Southwest
Southwest_Russian -> Russian_Southwest
RU_Pinega -> Russian_Pinega
West_Scottish -> Scottish_West
Calabria -> Italy_Calabria
Campania -> Italy_Campania
East_Sicilian -> Italy_East_Sicilian
Emilia -> Italy_Emilia
Friuli-VG -> Italy_Friuli-VG
Lazio -> Italy_Lazio
Marche -> Italy_Marche
Lombardy -> Italy_Lombardy
Liguria -> Italy_Liguria
Molise -> Italy_Molise
Piedmont -> Italy_Piedmont
Romagna -> Italy_Romagna
Trentino -> Italy_Trentino
Umbria -> Italy_Umbria
Veneto -> Italy_Veneto
West_Sicilian -> Italy_West_Sicilian

**J. Ketch** · 10-07-2020, 02:23 PM

Is the Gedmatch Southeast English average from Kent alone? And Southwest English from Cornwall? Anyone know?

**Aren** · 10-07-2020, 03:28 PM

Originally Posted by vbnetkhio

Lucas, i hope i'm not asking for too much but i think this would improve the sheet greatly:

could you delete the "North_Macedonian" average , because it's the same as Macedonian.

also remove these duplicates:

Code:

Tuscan,27.18,10.01,23.79,8.83,24.59,4.29,0.24,0.01,0.29,0.00,0.50,0.17,0.09
Tuscany,28.25,11.86,24.70,8.95,21.95,3.29,0.19,0.27,0.00,0.15,0.25,0.10,0.01
Danish,48.13,28.42,11.20,4.88,3.64,0.68,1.07,0.07,0.93,0.45,0.25,0.16,0.10
Denmark,50.61,28.70,10.19,5.00,2.12,0.52,0.99,0.19,0.42,0.59,0.23,0.12,0.17
East_German,37.34,32.19,14.57,6.15,6.42,0.96,1.46,0.02,0.19,0.38,0.05,0.13,0.14
German_east,36.93,36.50,12.59,5.57,4.79,0.78,0.69,0.09,0.30,0.78,0.55,0.15,0.20
German_West,45.37,25.20,13.22,7.02,5.78,0.85,0.30,0.58,0.39,0.37,0.11,0.35,0.14
West_German,43.14,22.44,14.78,6.85,8.54,0.86,0.94,0.13,0.40,0.60,0.64,0.47,0.22

and replace them with these:

Code:

Italy_Tuscan,27.72,10.94,24.25,8.89,23.27,3.79,0.22,0.14,0.15,0.08,0.38,0.14,0.05
Danish,49.37,28.56,10.70,4.94,2.88,0.60,1.03,0.13,0.68,0.52,0.24,0.14,0.14
German_East,37.14,34.35,13.58,5.86,5.61,0.87,1.08,0.06,0.25,0.58,0.30,0.14,0.17
German_West,44.26,23.82,14.00,6.94,7.16,0.86,0.62,0.36,0.40,0.49,0.38,0.41,0.18

and if it's not too much work rename these averages:

Code:

MMacedonian -> Macedonian
North-Dutch -> Dutch_North
North-Swedish -> Swedish_North
North_German -> German_North
East_Finnish -> Finnish_East
Estonian_Polish -> Polish_Estonia
Kargopol_Russian -> Russian_Kargopol
Masurian -> Polish_Masurian
Abruzzo -> Italy_Abruzzo
AostaValley -> Italy_AostaValley
Apulia -> Italy_Apulia
Basilicata -> Italy_Basilicata
South_Dutch -> Dutch_South
South_Polish -> Polish_South
Southeast_English -> English_Southeast
Southwest_English -> English_Southwest
Southwest_Finnish -> Finnish_Southwest
Southwest_French -> French_Southwest
Southwest_Russian -> Russian_Southwest
RU_Pinega -> Russian_Pinega
West_Scottish -> Scottish_West
Calabria -> Italy_Calabria
Campania -> Italy_Campania
East_Sicilian -> Italy_East_Sicilian
Emilia -> Italy_Emilia
Friuli-VG -> Italy_Friuli-VG
Lazio -> Italy_Lazio
Marche -> Italy_Marche
Lombardy -> Italy_Lombardy
Liguria -> Italy_Liguria
Molise -> Italy_Molise
Piedmont -> Italy_Piedmont
Romagna -> Italy_Romagna
Trentino -> Italy_Trentino
Umbria -> Italy_Umbria
Veneto -> Italy_Veneto
West_Sicilian -> Italy_West_Sicilian

Uhmm why are you telling him to remove averages not created by you? I created the Denmark average and I don’t want Lucas to remove it.

**vbnetkhio** · 10-07-2020, 03:34 PM

Originally Posted by Aren

Uhmm why are you telling him to remove averages not created by you? I created the Denmark average and I don’t want Lucas to remove it.

sorry, it was there as long as i remember, i thought it was a duplicate from the original sheet or something.
then "Danish" should be removed. i edited my post.

**Leto** · 10-07-2020, 03:44 PM

Originally Posted by vbnetkhio

sorry, it was there as long as i remember, i thought it was a duplicate from the original sheet or something.
then "Danish" should be removed. i edited my post.

"Danish" is the better term than "Denmark". This guy is from Denmark for example

**~~Ion Basescul~~** · 10-07-2020, 03:52 PM

Originally Posted by vbnetkhio

Lucas,

could you update these:

and add these:

Code:

Vlach(Aromanian)_average,22.79,20.37,18.82,11.31,21.00,3.85,0.00,0.13,0.49,0.51,0.40,0.07,0.00

What is the source for the Aromanian average? There are 3 Vlachs on K13 only and they are more Southern than that.

Code:

Vlach_Central-Macedonia,21.16,16.34,21.87,11.20,23.99,4.14,0.06,0.43,0,0,0.81,0,0
Vlach_North-Macedonia,22.21,19.88,20.33,11.84,19.73,4.68,0,0.66,0,0,0.67,0,0
Vlach_North-Macedonia-Highlander,21.34,21.03,18.47,10.96,22.05,4.71,0,0,0,1.06,0.25,0.12,0

Also, I'm personally making monthly backups of the sheet, so I have all the Serb averages so far. I'm noticing an interesting trend, but I won't mention it for now. Let's just say that I won't be surprised to see the average have 40% Baltic in two years.

**Leto** · 10-07-2020, 03:56 PM

Originally Posted by Ion Basescul

Also, I'm personally making monthly backups of the sheet, so I have all the Serb averages so far. I'm noticing an interesting trend, but I won't mention it for now. Let's just say that I won't be surprised to see the average have 40% Baltic in two years.

Serbia is returning to its Slavic roots and removing the Albanian influence

**vbnetkhio** · 10-07-2020, 04:03 PM

Originally Posted by Ion Basescul

What is the source for the Aromanian average? There are 3 Vlachs on K13 only and they are more Southern than that.

Code:

Vlach_Central-Macedonia,21.16,16.34,21.87,11.20,23.99,4.14,0.06,0.43,0,0,0.81,0,0
Vlach_North-Macedonia,22.21,19.88,20.33,11.84,19.73,4.68,0,0.66,0,0,0.67,0,0
Vlach_North-Macedonia-Highlander,21.34,21.03,18.47,10.96,22.05,4.71,0,0,0,1.06,0.25,0.12,0

Also, I'm personally making monthly backups of the sheet, so I have all the Serb averages so far. I'm noticing an interesting trend, but I won't mention it for now. Let's just say that I won't be surprised to see the average have 40% Baltic in two years.

these 3 (they are individual results, not averages) + 2 additional results.

it's not supposed to be a super accurate average.
it should just be there so people can remove the individual results and keep the average when doing nMonte modelling, because these individual averages really get too much into every Balkanian's results.

the same goes for the Pomak, Torbesh and Balkan Turk averages. i think every Serb gets some Pomak Xanthi and Pomak Kavala whn running a full sheet nMonte, that's not very informative.

**~~Ion Basescul~~** · 10-07-2020, 04:11 PM

Originally Posted by vbnetkhio

these 3 (they are individual results, not averages) + 2 additional results.

it's not supposed to be a super accurate average.
it should just be there so people can remove the individual results and keep the average when doing nMonte modelling, because these individual averages really get too much into every Balkanian's results.

the same goes for the Pomak, Torbesh and Balkan Turk averages. i think every Serb gets some Pomak Xanthi and Pomak Kavala whn running a full sheet nMonte, that's not very informative.

So, can you share the individual results that made your Vlach(Aromanian)_average? It can't be the average of these 3.

**vbnetkhio** · 10-07-2020, 04:15 PM

Originally Posted by Ion Basescul

So, can you share the individual results that made your Vlach(Aromanian)_average? It can't be the average of these 3.

yes, as i said i used these 3, and 2 additional samples.

here:

gr_mac_vlach	25.95	23.56	16.11	9.72	19.35	3.09	0	0	1.2	0.27	0.53	0.21	0
vlach bulgaria	23.28	21.03	17.32	12.84	19.86	2.64	0.01	0	1.26	1.24	0.54	0	0
Vlach_North-Macedonia-Highlander	21.34	21.03	18.47	10.96	22.05	4.71	0	0	0	1.06	0.25	0.12	0
vlach bitola	22.21	19.88	20.33	11.84	19.73	4.68	0	0.66	0	0	0.67	0	0
Vlach_Central-Macedonia	21.16	16.34	21.87	11.2	23.99	4.14	0.06	0.43	0	0	0.81	0	0
vlach_avg	22.79	20.37	18.82	11.31	21.00	3.85	0.01	0.22	0.49	0.51	0.56	0.07	0.00