14
Reading the complainings about yesterdays spreadsheet, i updated it and i got better results using better references:
Again, better with x0.25:Code:North_Greece,0.118376,0.136081,0.018102,-0.001938,0.025851,-0.012829,-0.00094,0.009461,-0.008999,0.011663,-0.001949,0.002398,-0.00669,0.015551,-0.02158,-0.015778,-0.008866,0.007855,0.013073,-0.016508,-0.007487,0.003833,0.00493,-0.010001,-0.001916 South_Greece,0.1070972,0.1463285,-0.0168335,-0.0466295,0.0057632,-0.0153645,0.0022005,-0.0013009,-0.0029936,0.0129388,0.0013876,0.0027794,-0.0009596,0.0043915,-0.0122765,-0.0038692,0.001529,0.0008983,0.0040565,-0.0055482,-0.0050935,0.0014165,-0.0007506,-0.0012051,-0.0019595 Arabia,0.0494498,0.1411588,-0.0646136,-0.1161014,-0.0115919,-0.0481242,-0.0133696,-0.008179,0.0516537,-0.0058923,0.016293,-0.0318551,0.063346,0.0021408,0.0031818,0.0271809,-0.0220493,0.0042931,-0.0003213,0.0302646,0.0130601,0.0168853,-0.0072031,0.0082741,-0.0097528 West_Iberia,0.1061741,0.1446114,0.0360075,-0.0044316,0.042137,-0.0040494,-0.0037412,0.0027598,0.0255982,0.029741,-0.000734,0.0074214,-0.0127373,-0.0112631,0.0125568,-0.0003978,-0.0011316,-0.0008869,-0.005762,-0.0002452,0.0011379,-0.002572,0.0013015,-0.0011326,-0.0001053 Basque_Country,0.128241,0.1516523,0.0563163,0.008075,0.052112,0.0024173,0.000235,0.002923,0.0277467,0.039849,-0.0059003,0.0093417,-0.02106,-0.012065,0.0184127,-0.002475,-0.0123433,0.0028713,0.0022207,-0.0065867,0.0077363,-0.002432,-0.006532,-0.006748,0.003672 South_Italy,0.112685,0.146744,0.00132,-0.0334305,0.0155415,-0.0132475,0.004465,-0.003,0.00225,0.019408,0.003735,0.003372,-0.008102,-0.002684,-0.0071255,-0.0031155,0.005085,0.001837,0.0023255,-0.0080035,-0.0013725,0.0045135,-0.000801,0.0035545,0.0001195 North_Italy,0.1245224,0.147861,0.0279822,-0.0137598,0.0327446,-0.007753,0.000658,0,0.0103898,0.0299232,-0.0025008,0.008932,-0.0143606,-0.0047066,-0.0008686,-0.0078758,-0.0083448,0.0017738,0.0034442,-0.004102,-0.002246,0.0012366,-0.0006656,0.0030602,0.0008382 Central_Italy,0.1126848,0.1488017,-0.0006749,-0.034765,0.0161163,-0.0125501,0.0007792,-0.0022834,0.0037891,0.0208133,0.0005128,0.0036677,-0.0056336,-0.0039041,-0.0061502,-0.0014655,0.0018596,0.0002667,0.0033608,-0.0036926,-0.003809,0.001334,0.0008886,0.001706,-0.0009642 Sardinian,0.1206524,0.1679686,0.0276806,-0.0515508,0.0603188,-0.0224786,-0.003478,0.004292,0.0427048,0.0798558,-0.0020784,0.0158856,-0.0270266,-0.0131842,-0.0132192,-0.004614,0.0120476,-0.0013176,0.0017596,-0.012931,-0.0050908,-0.0042044,-0.0097122,-0.021087,0.0008382 North_France,0.1282752,0.1405432,0.0513571,0.0256051,0.0382728,0.0088906,0.0010967,0.0044194,0.008373,0.0120166,-0.003484,0.0040328,-0.0108613,-0.0081823,0.0111991,0.0025432,-0.0046069,0.0022266,0.0040947,0.0010308,0.0021327,0.0015249,-0.0015724,0.0074707,1.45e-05 South_France,0.1270391,0.1448823,0.048879,0.0179086,0.0433756,0.0034164,0.0005222,0.0038909,0.0148564,0.0235894,-0.0032883,0.0065816,-0.0150436,-0.0094578,0.010737,0.0025671,-0.0037088,0.0024846,0.0014247,4.52e-05,0.0036706,0.0024456,-0.0025505,0.0017673,0.0004224 Germany,0.1302626,0.1373792,0.0579811,0.0387068,0.0400035,0.0156461,0.0040665,0.0057865,0.003526,0.00188,-0.0044133,0.0023732,-0.0053706,-0.0025417,0.0085125,0.0032913,-0.0032728,0.0016631,0.0033669,0.0017191,0.00314,0.002005,7.18e-05,0.0083052,0.0002774 Northwest_Africa,-0.0299735,0.1373221,-0.0030378,-0.0673993,0.0280564,-0.0319174,-0.0244542,0.0050512,0.0609822,0.0327317,0.0059091,-0.0065526,0.0185908,-0.0147102,0.0151403,-0.0105629,0.0012604,-0.0179828,-0.040747,0.0092961,-0.0121937,-0.0346297,0.0214382,-0.0055763,0.0043974 Levant,0.075744,0.1347885,-0.0450488,-0.0672721,-0.0164783,-0.0223113,-0.0007905,-0.00579,0.0005764,0.0036448,0.0045911,-0.0038285,0.0120145,0.0028025,-0.008649,0.0038692,-0.0023587,0.0004147,0.0016226,0.0007048,-0.0016902,-0.0011465,-0.0030812,0.0017638,-0.0006749 Caucasus,0.1079422,0.0986757,-0.0370835,-0.0265937,-0.0358017,-0.002138,0.008656,-0.0023847,-0.0621072,-0.0284895,-0.0026797,0.0096667,-0.0220513,0.0044497,0.0042073,-0.0212585,0.003868,-0.0057853,-0.0130307,0.0169038,0.0091712,0.0001853,-0.0021568,-0.0102825,-0.0001397 Northeast_Africa,-0.01548,0.1341176,-0.042778,-0.0872208,-0.0044008,-0.0333553,-0.0137874,0.0005691,0.037605,0.0011968,0.0069772,-0.0087772,0.0229334,0.0018258,-0.0005202,-6.19e-05,-0.003303,-0.0026182,-0.0034861,0.0032432,-0.0005781,-0.0022875,0.0008381,0.0008636,-0.0004072 Finland,0.1305931,0.0918715,0.0899057,0.0766156,0.0317187,0.0232595,0.0087265,0.013184,0.0031769,-0.023071,0.0036809,-0.0060345,0.0119227,0.0058077,0.0021081,-0.0012815,-0.008136,0.0006589,0.0012905,0.0027597,0.0070458,0.0011706,0.0027937,0.0056955,0.0021076 Great_Britain,0.1301962,0.1397525,0.0613546,0.0431826,0.0419013,0.0164115,0.0034346,0.0063902,0.0064819,0.0069669,-0.0046342,0.0064788,-0.0137455,-0.0102476,0.0207548,0.003172,-0.012527,0.0021146,0.0037613,0.0032419,0.0048088,0.0038712,-0.0007584,0.0143671,0.0006909 Poland,0.1318405,0.1292694,0.0698685,0.0577382,0.0406754,0.0217127,0.0086781,0.0108626,-0.0009329,-0.0185524,-0.0043488,-0.0064187,0.013093,0.0186295,-0.0070244,-0.0005595,0.0015455,-7.41e-05,0.0026948,0.0012872,-0.0031286,-0.0031185,0.0056063,-0.0033328,-8.76e-05 East_Europe,0.131181,0.1155162,0.069673,0.065892,0.0326215,0.0221718,0.0107517,0.0129802,-0.0040395,-0.0257865,-0.0018675,-0.0072685,0.0188058,0.0195768,-0.013097,0.0020885,0.0036507,0.0008865,0.0025453,0.0006252,-0.0037432,-0.0080992,0.005854,-0.0047598,-0.001377 Scandinavia,0.1338234,0.1279567,0.0679357,0.0534334,0.0386443,0.0210366,0.0041964,0.0062964,0.0057267,0.0003906,-0.0037349,0.0036823,-0.007518,-0.011698,0.0210754,0.0093949,-0.0054203,0.0026061,0.0006823,0.0007503,0.005633,0.0055643,0.0042784,0.0177304,0.0010947 Ireland,0.1334042,0.134875,0.0610876,0.0482532,0.0383388,0.0188992,0.003,0.0047738,0.0031318,0.002725,-0.00714,0.005606,-0.0143759,-0.0139278,0.0253478,0.0048208,-0.0110725,0.0022052,0.0007502,0.0013385,0.0051745,0.0012249,-0.0003563,0.0147667,0.0010665 Balkans,0.1265712,0.137706,0.0370332,0.0138244,0.0298516,0.003012,0.003854,0.006,0.0011862,0.0026242,-0.0010716,-0.0006894,0.0042816,0.0120556,-0.0128932,-0.005489,0.0062582,-0.0002786,0.004676,-0.0049274,-0.007836,-0.00183,0.0053492,0.00094,-0.0028502 North_America,0.0529278,-0.328016,0.1120048,0.0774392,-0.1061738,-0.0184068,-0.1983488,-0.2347978,-0.0037325,-0.020137,0.0082817,-0.0034098,0.0063925,6.87e-05,-0.0151328,-0.004508,-0.0005215,0.0032622,0.0115015,0.0073472,0.0038682,-0.0107578,0.0027115,0.0062055,0.0092805 South_America,0.052359,-0.271146,0.111628,0.088825,-0.096633,-0.022311,-0.275667,-0.323986,-0.010635,-0.014761,-0.004547,0.003897,-0.002379,0.020231,-0.004886,0.002254,0.002347,-0.000127,-0.006913,-0.003502,0.004866,0.009274,-0.006039,-0.002289,0.00467 Central_America,0.0539522,-0.2983626,0.1125328,0.0919258,-0.1038348,-0.0159524,-0.267254,-0.3242634,-0.0066264,-0.0142508,-0.0050014,-0.0057552,0.0030028,0.0200376,-0.0058362,0.0001592,0.0028166,-0.0007856,0.0026146,0.0012506,-0.0024708,0.0052428,9.86e-05,0.0003858,-0.0012694 West_Africa,-0.6226124,0.064486,0.022863,0.0170382,0.0029622,0.009273,-0.0229135,0.0268834,-0.0388084,0.0279276,0.0057446,-0.0050392,0.0177835,0.0005161,0.0102468,-0.0072759,0.0094202,0.0066352,0.001037,-0.0003909,0.0030572,0.0013138,-0.003374,-0.0002561,-0.0001798 East_Africa,-0.2966229,0.0934288,-0.0268511,-0.0697357,0.0009541,-0.0340804,-0.020493,0.0057689,0.1153923,-0.0796737,-0.0089475,-0.006669,0.0052179,-0.0016653,0.0247283,-0.0186156,0.0148637,-0.0019764,0.0099803,-0.0038392,0.0005991,0.004946,-0.0027362,-0.0012411,-0.00279 Turkey,0.097275,0.0841327,-0.0305758,-0.0405241,-0.0228443,-0.0133439,0.0035069,-0.0019525,-0.021066,-0.0021728,-0.0002998,0.0027898,-0.0036708,0.0009528,-0.0056584,-0.0015502,0.0006519,0.0011109,0.0010635,-0.0017988,-0.0013438,0.0018834,-0.0018203,-0.0004636,0.0004421 West_Asia,0.1028676,0.1379851,-0.0581239,-0.0608451,-0.0286976,-0.0158969,0.0046413,-0.0057114,-0.0304485,-0.0043964,0.0012991,-0.0002249,-0.003029,0.0024773,-0.0046145,-0.0014582,0.0004075,0.0008232,0.0025769,-0.0027984,0.0001561,0.0024885,-0.0022492,-0.0021838,-1.51e-05 East_Asia,0.0227267,-0.4546526,0.0184538,-0.0641155,0.0393303,0.0116484,0.0054755,0.0033615,-0.0087399,0.0063599,-0.0745742,-0.008947,0.0103418,-0.0051105,-0.0085052,-0.002559,0.0012865,0.0022087,-0.0005237,-0.0077496,0.0169077,-0.0043938,0.0076947,0.0005381,-0.0173996 Central_Asia,0.0806659,0.0675989,-0.0894431,0.0025138,-0.0527991,0.0133626,0.0017778,0.0001404,-0.0112576,-0.0088979,-0.0006072,-0.0026846,0.0063213,-0.0018788,0.0045613,0.0089297,-0.0044275,0.0016801,0.0024373,-0.008515,0,-0.0043332,-0.0015807,-0.0021585,0.0018795 Baltic_States,0.1354494,0.122473,0.0887742,0.089471,0.043208,0.0340246,0.0125966,0.0140762,-0.002168,-0.0368842,-0.0035728,-0.0138178,0.0232208,0.031378,-0.010559,0.0040572,0.0027118,-0.0003802,0.0016088,0.0043022,-0.0027952,-0.0057128,0.0090708,-0.0093264,0.0026346 East_Iberia,0.114582,0.1462363,0.0458833,0.0023687,0.0471883,0,-0.0020367,0.0023843,0.0223613,0.0304943,-0.0018947,0.0085923,-0.016006,-0.0106427,0.0088673,0.001591,-0.000652,-0.001647,-0.001131,-0.0009587,0.0061973,-0.005729,-0.0039027,-0.001928,0.0009577 Karelia,0.1273094,0.0768108,0.093286,0.0808381,0.0275575,0.0224719,0.0102478,0.0152161,0.0017601,-0.0294117,0.0052308,-0.0110312,0.0189294,0.0089496,-0.00445,0.0013259,-0.0023746,-0.0014089,-0.0018435,0.0037822,0.0064659,-0.0009743,0.001154,0.0006975,0.0038138 India,0.0662308,-0.0119959,-0.1247796,0.0851711,-0.0769759,0.0505314,0.0026291,0.0083362,0.0064552,-0.0010593,-0.0048717,-0.0012364,0.0010592,-0.0041717,0.0077021,0.0109138,-0.0036019,0.0018845,0.0026631,-0.0099658,-0.0013024,-0.0072259,0.0020028,-0.0022743,0.0017364 Oceania,0.046667,-0.11577,-0.010559,0.031654,0.090478,-0.01506,-0.001645,-0.001846,-0.016157,-0.013668,0.009419,0.003597,-0.002825,-0.007569,0.016422,0.005171,-0.006128,0.006461,0.004148,-0.003877,0.007362,-0.005688,-0.004067,-0.00253,-0.022513 Hungary,0.1270753,0.1296252,0.0553559,0.0364298,0.0363804,0.0119326,0.0066138,0.0075326,0.0020597,-0.0046731,-0.0014731,-0.0027191,0.0038544,0.0087488,-0.0043722,0.0001231,-8.4e-05,-0.0003891,0.0026486,-0.0013221,-0.003378,0.0013865,0.0055286,0.0026939,0.0004789 South_Africa,-0.6222873,0.0658643,0.018425,0.0160116,0.0006156,0.0075699,0.0014437,0.0089336,-0.0274354,0.0172863,0.0028534,-0.0046459,-0.0030369,0.001966,-0.0051573,0.004887,-0.0033901,0.0217903,-0.0106846,0.0037876,-0.0011764,0.0004591,0.0014964,0.0002411,-0.0005471
Distance: 2.5515% / 0.02551466 | ADC: 0.25x
63.6 West_Iberia
15.8 South_Italy
5.6 Northwest_Africa
5.4 Balkans
5.2 East_Europe
2.6 Central_Italy
1.8 East_Iberia
Smooth results.
Bookmarks