You have made that spreadsheet?
Oracle Download:
https://drive.google.com/open?id=1b_...VzgLYMh0bcumC5
1. Siberian (k15) = Amerindian+Arctic+East_Siberian+Paleo_Siberian (k23b)
2. Northeast_Asian (k15) = Tungus_Altaic (k23b)
3. Southeast_Asian (k15) = Southest_Asian+Austronesian (k23b)
4. Ancestral_Altaic (k15) = Ancestral_Altaic (k23b)
5. South_Central_Asian (k15) = South_Central_Asian (23b)
6. South_Indian (k15) = South_Indian (k23b)
7. European_Hunter_Gatherer (k15) = European_Hunter_Gatherer (k23b)
8. Caucasian (k15) = Caucasus (k23b)
9. European_Early_Farmer (k15) = European_Early_Farmer (k23b)
10. Near_East (k15) = Near_East (k23b)
11. North_African (k15) = North_African (k23b)
12. Oceanian (k15) = Melano_Polynesian+Australoid (k23b)
13. East_African (k15) = East_African (k23b)
14. Sub_Saharan (k15) = Subsaharian+Arhaic_African+African_Pygmy+Khoisan (k23b)
15. Arhaic_Human (k15) = Arhaic_Human (k23b)
Example:
my unsorted score on MDLP 23b
Amerindian 1.04
Ancestral_Altaic 2.92
South_Central_Asian -
Arctic 0.57
South_Indian 1.63
Australoid -
Austronesian 0.60
Caucasian 28.02
Archaic_Human -
East_African -
East_Siberian 1.54
European_Early_Farmers 13.81
Khoisan -
Melano_Polynesian 0.29
Archaic_African -
Near_East 0.47
North_African -
Paleo_Siberian -
African_Pygmy 0.07
South_East_Asian -
Subsaharian -
Tungus-Altaic -
European_Hunters_Gatherers 49.04
transforms into k15
command in R:
Code:
MDLP_k15_from_k23b(c(3.15,0,0.60,2.92,0,1.63,49.04,28.02,13.81,0.47,0,0.29,0,0.07,0),k=30)
Code:
[1,] "Slovak" "4.6744"
[2,] "Ukrainian_West" "4.7392"
[3,] "Kashub" "5.5163"
[4,] "German" "5.9887"
[5,] "Sorb" "6.3579"
[6,] "Czech" "6.623"
[7,] "Ukrainian_Center" "7.2555"
[8,] "Russian_North" "7.5485"
[9,] "Belarusian_East" "7.6474"
[10,] "Russian_West" "7.8123"
[11,] "Belarusian_West" "7.8342"
[12,] "Russian_South" "8.1153"
[13,] "Ukrainian_East" "8.1298"
[14,] "Russian_Meshtchyora" "8.2214"
[15,] "Slovenian" "8.3509"
[16,] "Russian_Northwest" "8.462"
[17,] "Hungarian" "8.4756"
[18,] "Hungarian_Budapest" "9.0454"
[19,] "Russian_Upper_Volga" "9.0513"
[20,] "Finn_West" "9.1942"
[21,] "Cossack_Don" "9.5474"
[22,] "Ukrainian" "9.5698"
[23,] "Moksha" "10.5211"
[24,] "Scythian_Ukraine_scy009" "10.7308"
[25,] "Erzya" "10.8942"
[26,] "Mordovian" "12.2283"
[27,] "Austrian" "12.2936"
[28,] "Finnish_East" "12.4138"
[29,] "Croat" "12.4206"
[30,] "Polish" "12.4979"
Mixed mode:
Code:
MDLP_k15_from_k23b(c(3.15,0,0.60,2.92,0,1.63,49.04,28.02,13.81,0.47,0,0.29,0,0.07,0),k=100,mixedmode=T)
Code:
[1,] "32.3% Anatolia_Hellenistic_Period + 67.7% Estonian" "3.1225"
[2,] "84.7% Russian_Northwest + 15.3% Scythian_Moldova_scy197" "3.134"
[3,] "76.4% Balt + 23.6% Scythian_Moldova_scy197" "3.2719"
[4,] "72.1% Estonian + 27.9% Scythian_Moldova_scy197" "3.3053"
[5,] "91.3% Belarusian_East + 8.7% Sardinian" "3.3425"
[6,] "79.6% Russian_Center + 20.4% Scythian_Moldova_scy300" "3.3843"
[7,] "18% Anatolia_Hellenistic_Period + 82% Russian_Northwest" "3.3926"
[8,] "89.2% Belarusian_East + 10.8% Scythian_Moldova_scy300" "3.4603"
[9,] "81.1% Belarusian_South + 18.9% Scythian_Moldova_scy300" "3.4819"
[10,] "89% Russian_West + 11% Scythian_Moldova_scy300" "3.4849"
[11,] "90.8% Russian_South + 9.2% Sardinian" "3.4918"
[12,] "91.2% Russian_West + 8.8% Sardinian" "3.5016"
[13,] "86.1% Russian_West + 13.9% Scythian_Moldova_scy197" "3.5254"
[14,] "50% Hungarian + 50% Russian_Northwest" "3.5736"
[15,] "8.3% Basque_Spanish + 91.7% Ukrainian_Center" "3.5762"
[16,] "52.1% Russian_West + 47.9% Slovenian" "3.5784"
[17,] "47.5% Hungarian + 52.5% Russian_West" "3.5883"
[18,] "8.1% Basque_French + 91.9% Ukrainian_Center" "3.5897"
[19,] "77.3% Belarusian_South + 22.7% Scythian_Moldova_scy192" "3.5951"
[20,] "88% Russian_Northwest + 12% Scythian_Moldova_scy300" "3.6014"
[21,] "23.3% Scythian_Ukraine_scy009 + 76.7% Ukrainian_West" "3.6031"
[22,] "80.8% Belarusian + 19.2% Scythian_Moldova_scy300" "3.6173"
[23,] "46.4% Mordovian + 53.6% Scythian_Ukraine_scy009" "3.62"
[24,] "49.6% Russian_Northwest + 50.4% Slovenian" "3.6327"
[25,] "85.4% Russian_Northwest + 14.6% Scythian_Moldova_scy192" "3.6402"
[26,] "9.3% Spanish_Pais_Vasco_IBS + 90.7% Ukrainian_Center" "3.6418"
[27,] "88.6% Russian_South + 11.4% Scythian_Moldova_scy300" "3.6479"
[28,] "27.4% Anatolia_Hellenistic_Period + 72.6% Balt" "3.653"
[29,] "10.7% French_South + 89.3% Ukrainian_Center" "3.6737"
[30,] "16.7% Italian_Piedmont + 83.3% Russian_Northwest" "3.6793"
[31,] "88.6% Belarusian_East + 11.4% French_South" "3.6836"
[32,] "31.3% Estonian + 68.7% Hungarian" "3.6922"
[33,] "86.6% Russian_West + 13.4% Scythian_Moldova_scy192" "3.7078"
[34,] "87.6% Belarusian_East + 12.4% Spanish_Valencia_IBS" "3.7165"
[35,] "82.3% Belarusian_East + 17.7% French" "3.728"
[36,] "86.5% Belarusian_East + 13.5% Spanish_Cataluna_IBS" "3.7335"
[37,] "70.5% Slovenian + 29.5% Vepsa" "3.7373"
[38,] "36.5% Balt + 63.5% Hungarian" "3.7387"
[39,] "86.5% Cossack_Don + 13.5% Scythian_Moldova_scy300" "3.7413"
[40,] "16.4% Italian_Bergamo + 83.6% Russian_Northwest" "3.7424"
[41,] "87.9% Belarusian_East + 12.1% Spanish_Cantabria_IBS" "3.747"
[42,] "9.1% Sardinian + 90.9% Ukrainian_East" "3.7543"
[43,] "20.7% English_Kent_GBR + 79.3% Ukrainian_Center" "3.7586"
[44,] "88.1% Belarusian_East + 11.9% Spanish_Aragon_IBS" "3.7626"
[45,] "16.7% French + 83.3% Ukrainian_Center" "3.7632"
[46,] "75.7% Russian_Center + 24.3% Scythian_Moldova_scy192" "3.7737"
[47,] "88% Belarusian_East + 12% Spanish_Castilla_la_Mancha_IBS" "3.7738"
[48,] "8.7% Basque_Spanish + 91.3% Belarusian_East" "3.7775"
[49,] "11.3% Spanish_Cantabria_IBS + 88.7% Ukrainian_Center" "3.7777"
[50,] "23.4% Belgian + 76.6% Ukrainian_Center" "3.7891"
[51,] "53.3% Belarusian_East + 46.7% Hungarian" "3.7895"
[52,] "87% Belarusian_East + 13% Scythian_Moldova_scy192" "3.7901"
[53,] "86.2% Belarusian_East + 13.8% Spaniard" "3.792"
[54,] "36.5% Russian_Vologda + 63.5% Slovenian" "3.7939"
[55,] "58.3% Russian_South + 41.7% Scythian_Ukraine_scy009" "3.7939"
[56,] "86.1% Belarusian_East + 13.9% Spanish_Baleares_IBS" "3.7946"
[57,] "11.2% Spanish_Aragon_IBS + 88.8% Ukrainian_Center" "3.7988"
[58,] "76.8% Belarusian_South + 23.2% Scythian_Moldova_scy197" "3.8015"
[59,] "89.2% Cossack_Don + 10.8% Sardinian" "3.8042"
[60,] "15% Italian_Bergamo + 85% Russian_West" "3.8073"
[61,] "18.8% French + 81.2% Ukrainian_East" "3.8092"
[62,] "12.1% French_South + 87.9% Ukrainian_East" "3.8104"
[63,] "75.2% Russian_Center + 24.8% Scythian_Moldova_scy197" "3.8204"
[64,] "69.6% Estonian + 30.4% Italian_Piedmont" "3.8208"
[65,] "11.6% Spanish_Valencia_IBS + 88.4% Ukrainian_Center" "3.822"
[66,] "12.7% Spanish_Aragon_IBS + 87.3% Ukrainian_East" "3.8241"
[67,] "8.4% Basque_French + 91.6% Belarusian_East" "3.8257"
[68,] "12.9% Spanish_Cantabria_IBS + 87.1% Ukrainian_East" "3.8257"
[69,] "47.5% Russian_Upper_Volga + 52.5% Slovenian" "3.8267"
[70,] "30.8% Estonian + 69.2% Slovenian" "3.8274"
[71,] "7.9% Sardinian + 92.1% Ukrainian_Center" "3.8278"
[72,] "90.2% Belarusian_East + 9.8% Spanish_Pais_Vasco_IBS" "3.8313"
[73,] "52.9% Belarusian_East + 47.1% Slovenian" "3.8346"
[74,] "13.2% Spanish_Valencia_IBS + 86.8% Ukrainian_East" "3.836"
[75,] "10.9% Sardinian + 89.1% Ukrainian" "3.8377"
[76,] "9.3% Basque_Spanish + 90.7% Ukrainian_East" "3.8414"
[77,] "39% Croat + 61% Russian_Northwest" "3.8415"
[78,] "38% Scythian_Ukraine_scy009 + 62% Ukrainian_Center" "3.8448"
[79,] "35.9% Balt + 64.1% Slovenian" "3.8491"
[80,] "70.7% Latvian + 29.3% Scythian_Moldova_scy197" "3.8572"
[81,] "12.1% French_South + 87.9% Russian_South" "3.861"
[82,] "18.7% French + 81.3% Russian_South" "3.8652"
[83,] "12.5% Spanish_Cataluna_IBS + 87.5% Ukrainian_Center" "3.8655"
[84,] "9.1% Basque_French + 90.9% Ukrainian_East" "3.8662"
[85,] "86.8% Belarusian_East + 13.2% Scythian_Moldova_scy197" "3.8669"
[86,] "33.8% Anatolia_Hellenistic_Period + 66.2% Latvian" "3.8692"
[87,] "72.7% Belarusian_East + 27.3% German_South" "3.8717"
[88,] "11.3% Scythian_Moldova_scy300 + 88.7% Ukrainian_East" "3.8736"
[89,] "11.2% Spanish_Castilla_la_Mancha_IBS + 88.8% Ukrainian_Center" "3.8746"
[90,] "30.1% Belgian + 69.9% Cossack_Don" "3.8753"
[91,] "26.1% Belgian + 73.9% Ukrainian_East" "3.8771"
[92,] "10.5% Spanish_Pais_Vasco_IBS + 89.5% Ukrainian_East" "3.8776"
[93,] "78% Cossack_Don + 22% French" "3.8801"
[94,] "12.8% Spanish_Castilla_la_Mancha_IBS + 87.2% Ukrainian_East" "3.8877"
[95,] "14.3% Spanish_Cataluna_IBS + 85.7% Ukrainian_East" "3.8884"
[96,] "58.6% Croat + 41.4% Estonian" "3.8889"
[97,] "36.6% Belarusian_South + 63.4% Hungarian" "3.8925"
[98,] "18% Finnish_East + 82% Slovak" "3.8945"
[99,] "22% French + 78% Ukrainian" "3.8946"
[100,] "77% Belarusian + 23% Scythian_Moldova_scy192" "3.8967"
Also I made an Excel file where you fill in your MDLP k23b values and it automatically converts them into k15 ->>
https://drive.google.com/open?id=1fZ...50PLBT6vm4P2oU (edited new link)
datasheet:
https://drive.google.com/open?id=1wG...blaBvXoSAjh921