G25 Post Your Breakdown Using Scaled Moderns Spreadsheet

**Grace O'Malley** · 03-23-2020, 11:00 AM

Not sure if there is already a thread on here about this. I don't know if the G25 spreadsheet has been updated because mine seems slightly different.

Anyway you get the G25 Moderns spreadsheet from Eurogenes but I'll post it here.

https://drive.google.com/file/d/1wZr...CQncZWb8y/view

Target: Grace_scaled
Distance: 1.6937% / 0.01693745
48.4 Icelandic
47.8 Irish
2.6 Swedish
1.2 Adygei

What do you get using the full spreadsheet?

**SUPREEEEEME** · 03-23-2020, 11:09 AM

With Jewish populations:

Code:

Target: SUPREEEEEME_scaled
Distance: 1.6217% / 0.01621666
27.0	Italian_Liguria
20.2	Sephardic_Jew
11.0	Tunisian_Jew
9.8	Moroccan_Jew
9.6	Samaritan
9.0	Shetlandic
4.8	Iranian_Mazandarani
3.8	Mari
2.0	Iraqi_Jew
1.4	Spanish_Asturias
0.8	Russian_Smolensk
0.4	Icelandic
0.2	Iranian_Jew

Without Jewish populations:

Code:

Target: SUPREEEEEME_scaled
Distance: 1.7218% / 0.01721832
31.0	Italian_Liguria
27.2	Samaritan
12.0	Swiss_Italian
9.4	Iranian_Mazandarani
7.2	Spanish_Asturias
4.8	Berber_Tunisia_Chen
4.2	Shetlandic
3.6	Mari
0.6	Italian_Lombardy

**~~JamesBond007~~** · 03-23-2020, 11:11 AM

Originally Posted by Grace O'Malley

Not sure if there is already a thread on here about this. I don't know if the G25 spreadsheet has been updated because mine seems slightly different.

Anyway you get the G25 Moderns spreadsheet from Eurogenes but I'll post it here.

https://drive.google.com/file/d/1wZr...CQncZWb8y/view

Target: Grace_scaled
Distance: 1.6937% / 0.01693745
48.4 Icelandic
47.8 Irish
2.6 Swedish
1.2 Adygei

What do you get using the full spreadsheet?

For me I don't find this very accurate :

Target: Kevin_scaled
Distance: 2.3973% / 0.02397250 | ADC: 0.25x
72.6 Norwegian
14.2 Spanish_Soria
11.0 Dutch
1.4 Tajik_Shugnan
0.6 Biaka
0.2 Kosipe

Distance to: Kevin_scaled
0.02865262 Dutch
0.02966312 Norwegian
0.03097093 Welsh
0.03128912 Irish
0.03153596 Scottish
0.03173767 English
0.03264251 Orcadian
0.03323573 French_Brittany
0.03424261 English_Cornwall
0.03434002 Shetlandic
0.03554655 Icelandic
0.03738947 German
0.03825792 Swedish
0.03928185 Belgian
0.04385265 French_Nord
0.04392491 French_Paris
0.04724802 French_Alsace
0.04744540 Austrian
0.04923277 Swiss_German

What is more accurate for me is combining politically incorrect ancient racist Nazi like anthropology to modern Genetics. I've been classified as North-Atlantid :

GEDmatch calculators :

puntDNAL K12 Modern 4 :
Using 1 population approximation:
1 English_South @ 2.522990

Eurogenes K15 :
1 Southwest_English @ 4.227181
2 Southeast_English @ 4.311458

MDLP K16 modern :

Using 1 population approximation:
1 English_Cornwall @ 2.193833

**Gallop** · 03-23-2020, 11:15 AM

I get this

**~~Nomansman~~** · 03-23-2020, 11:17 AM

Target: Nomansman_scaled
Distance: 1.5467% / 0.01546733
34.6 Balochi
28.8 Kaitag
16.2 Jatt_Pathak
9.6 Kalash
9.2 Gujar_Pakistan
0.6 Evenk
0.6 Lak
0.4 Papuan

Imputed data:

Target: Nomansman2_scaled
Distance: 1.3608% / 0.01360843
29.8 Kalash
26.6 Balochi
15.6 Lak
10.4 Avar
9.4 Jatt_Pathak
2.2 Gujar_Pakistan
2.0 Iranian_Mazandarani
1.8 Ket
1.0 Gupta
0.8 Berber_Tunisia_Chen
0.2 Lithuanian_VZ
0.2 Nganassan

**Grace O'Malley** · 03-23-2020, 11:23 AM

Originally Posted by JamesBond007

For me I don't find this very accurate :

Target: Kevin_scaled
Distance: 2.3973% / 0.02397250 | ADC: 0.25x
72.6 Norwegian
14.2 Spanish_Soria
11.0 Dutch
1.4 Tajik_Shugnan
0.6 Biaka
0.2 Kosipe

Distance to: Kevin_scaled
0.02865262 Dutch
0.02966312 Norwegian
0.03097093 Welsh
0.03128912 Irish
0.03153596 Scottish
0.03173767 English
0.03264251 Orcadian
0.03323573 French_Brittany
0.03424261 English_Cornwall
0.03434002 Shetlandic
0.03554655 Icelandic
0.03738947 German
0.03825792 Swedish
0.03928185 Belgian
0.04385265 French_Nord
0.04392491 French_Paris
0.04724802 French_Alsace
0.04744540 Austrian
0.04923277 Swiss_German

What is more accurate for me is combining politically incorrect ancient racist Nazi like anthropology to modern Genetics. I've been classified as North-Atlantid :

GEDmatch calculators :

puntDNAL K12 Modern 4 :
Using 1 population approximation:
1 English_South @ 2.522990

Eurogenes K15 :
1 Southwest_English @ 4.227181
2 Southeast_English @ 4.311458

MDLP K16 modern :

Using 1 population approximation:
1 English_Cornwall @ 2.193833

It's just interesting to see what people get. You have to use more targeted populations to get a more accurate result but even with the complete spreadsheet I don't get a very varied result.

You used the x25 but thanks for posting anyway.

**Pedro Ruben** · 03-23-2020, 03:31 PM

Target: Pedro_scaled
Distance: 1.3050% / 0.01305030
25.2 Spanish_Castilla_Y_Leon
21.0 Italian_Liguria
8.8 Basque_French
8.8 Spanish_Asturias
8.8 Spanish_Pais_Vasco
7.0 Orcadian
6.2 Mozabite
5.6 Shetlandic
2.2 Yemenite_Jew
1.6 Fulani
1.4 German_East
1.2 Ethiopian_Afar
0.6 Mari
0.6 Somali
0.6 Surui
0.4 Gambian

Distance to: Pedro_scaled
0.02862657 Spanish_Canarias
0.02912641 Spanish_Castilla_Y_Leon
0.03123799 Portuguese
0.03125604 Spanish_Galicia
0.03277686 Spanish_Andalucia
0.03331998 Spanish_Extremadura
0.03534517 Spanish_Murcia
0.03827585 Spanish_Eivissa
0.03852568 Spanish_Asturias
0.03854111 Spanish_Castilla_La_Mancha
0.03860717 Spanish_Alacant
0.04009266 Spanish_Menorca
0.04093771 Spanish_Valencia
0.04096807 Spanish_Baleares
0.04156539 Spanish_Cataluna
0.04180951 Spanish_Camp_de_Tarragona
0.04217697 Spanish_Mallorca
0.04383451 Italian_Liguria
0.04398211 Spanish_Barcelones
0.04416265 Spanish_Aragon
0.04419919 Spanish_Terres_de_l'Ebre
0.04467602 Spanish_Peri-Barcelona
0.04525240 Spanish_Penedes
0.04548542 Spanish_Lleida
0.04550371 Spanish_Girona

mitalit · 03-23-2020, 03:35 PM

Target: Xabier_scaled
Distance: 1.8030% / 0.01802988
36.6 Spanish_Soria
18.8 Swiss_French
15.6 Shetlandic
12.8 Italian_Liguria
3.8 Berber_Tunisia_Chen
3.2 Sardinian
3.2 Spanish_Asturias
2.2 Abkhasian
1.6 Spanish_Aragon
1.2 Berber_MAR_TIZ
0.8 Todzin
0.2 Koinanbe

**~~JamesBond007~~** · 03-23-2020, 03:41 PM

Originally Posted by Grace O'Malley

It's just interesting to see what people get. You have to use more targeted populations to get a more accurate result but even with the complete spreadsheet I don't get a very varied result.

You used the x25 but thanks for posting anyway.

I dunno, I tend to think it is called global for a reason. Generally, on GEDmatch global calculators are only good for the big picture and you are supposed to use more pin-pointed GEDmatch calculators for more specific results. I tend to think that this global is not as accurate as pin-pointed Celtic vs Germanic PCA for me. As you can see I just fall within the British and Dutch ranges but I don't look physically Dutch so it is a no brainer to go with the British :

Pubiczar · 03-23-2020, 03:42 PM

Target: *****_scaled
Distance: 1.6533% / 0.01653344
50.0 Greek_Peloponnese
35.6 Montenegrin
8.8 Sorb_Niederlausitz
2.8 BedouinB
2.6 Spanish_La_Rioja
0.2 Surui