Results 1 to 3 of 3

Thread: Michal's NEW K35 Calculator based on modern G25 spreadsheet

  1. #1
    Veteran Member Apricity Funding Member
    "Friend of Apricity"

    Slavic Italian's Avatar
    Join Date
    Oct 2016
    Last Online
    Yesterday @ 11:48 PM
    Meta-Ethnicity
    Germanic, Celtic, Slavic, and Romance
    Ethnicity
    Slavic, Germanic, Finnish, and Italian
    Ancestry
    Poland, Finnish, Russia, Belarus, Ukraine, Germany, Italy, and U.K.
    Country
    United States
    Y-DNA
    R-FTA11171
    mtDNA
    H1
    Hero
    Yeshua Ha Mashiach
    Religion
    Christian
    Gender
    Posts
    4,280
    Thumbs Up
    Received: 2,139
    Given: 2,862

    1 Not allowed!

    Default Michal's NEW K35 Calculator based on modern G25 spreadsheet

    Results with penalty=0:

    [1] "distance%=1.8843"

    Mixed_scaled

    North_West_European,33.6
    Balto_Slavic,27.2
    South_West_European,23.2
    Levantine,7.6
    Arabic,4
    South_Caucasian,4
    Amerindian,0.4


    Results with default penalty:
    [1] "distance%=2.1631"

    Mixed_scaled

    West_European,20.8
    North_West_European,18.8
    Central_European,14.4
    Balkan,12.2
    South_West_European,11.6
    Balto_Slavic,7.2
    South_East_European,4.2
    Levantine,3.2
    Finnic,2.6
    North_African,1.2
    Arabic,1
    Assyrian,1
    South_Caucasian,1
    Turkish_Persian,0.6
    South_Central_Asian,0.2

  2. #2
    Veteran Member michal3141's Avatar
    Join Date
    Feb 2018
    Last Online
    04-12-2024 @ 04:15 PM
    Location
    Kraków
    Meta-Ethnicity
    Balto-Slavic
    Ethnicity
    Polish
    Ancestry
    Polish
    Country
    Poland
    Region
    Lesser Poland
    Y-DNA
    R1a-Y23110
    mtDNA
    J1c1
    Taxonomy
    Alpinized East Nordid
    Gender
    Posts
    1,932
    Thumbs Up
    Received: 2,760
    Given: 5,256

    0 Not allowed!

    Default

    Full calculator for those of you who know how to use nMonte

    Code:
    ,PC1,PC2,PC3,PC4,PC5,PC6,PC7,PC8,PC9,PC10,PC11,PC12,PC13,PC14,PC15,PC16,PC17,PC18,PC19,PC20,PC21,PC22,PC23,PC24,PC25
    North_West_Indian,0.0717172519084,-0.00930252671756,-0.103509549618,0.0730744427481,-0.072058,0.0455677709924,0.00325951145038,0.00465219847328,-0.00435123664122,-0.00704600763359,-0.00714012977099,-8.81145038168e-05,-0.000177045801527,-0.00738226717557,0.00889638931298,0.0107387022901,-0.0010828778626,0.000472923664122,0.000880824427481,-0.00954367175573,-0.00206794656489,-0.00503197709924,0.00234829770992,-0.0018635648855,0.0025996870229
    Abyssinian,-0.299843975207,0.0921361983471,-0.027523553719,-0.0666020661157,0.00028994214876,-0.0323720661157,-0.00651042975207,-0.00429668595041,0.105877446281,-0.0741685867769,-0.0068055785124,-0.00812126446281,0.00422518181818,-0.000166074380165,0.022269338843,-0.0156882809917,0.0155329173554,0.00392942975207,0.00788054545455,-0.00282675206612,0.00214087603306,0.00555720661157,-0.00333683471074,0.0010117768595,-0.00131129752066
    Balto_Slavic,0.132235647059,0.12198302521,0.0742325798319,0.0664348571429,0.0391927310924,0.0246642605042,0.0100283445378,0.0122728991597,-0.00164820168067,-0.0242342941176,-0.00234439495798,-0.00851343697479,0.0168998655462,0.0236306386555,-0.00952093277311,-0.0017927394958,0.000425134453782,-0.000448218487395,0.00267875630252,0.00120648739496,-0.0031971092437,-0.00389142016807,0.00598109243697,-0.00488058823529,0.000638991596639
    Beringian,0.0418670434783,-0.389477652174,0.120859086957,0.0166696086957,-0.120517478261,-0.0559236956522,-0.0297646521739,-0.0297680869565,0.0107597391304,-0.00281282608696,0.0409572173913,0.00081452173913,0.00181634782609,-0.0196740869565,-0.0285189565217,-0.0164583913043,-0.001576,0.0157478695652,0.0362447391304,0.0187099565217,0.0376726956522,-0.057337173913,0.0104171304348,0.0209615652174,0.0305413913043
    West_European,0.127290759124,0.140009591241,0.0496670437956,0.0232913649635,0.0395176861314,0.00809394890511,0.00334326277372,0.00384879562044,0.00857506569343,0.0140347956204,-0.0037302189781,0.00549149635036,-0.0119384087591,-0.00836282481752,0.0106297518248,0.00342311678832,-0.00256296350365,0.000750905109489,0.00207723357664,0.000341372262774,0.00298008759124,0.00165260583942,-0.0014555620438,0.0067962189781,-0.000496430656934
    South_Indian,0.0173555384615,-0.144595735043,-0.183229068376,0.129427376068,-0.0565627435897,0.0587529316239,-0.0042721965812,0.0157960940171,0.0758311452991,0.0492582307692,0.000922948717949,0.000338145299145,-0.00102541025641,0.0102334188034,-0.017900042735,-0.0178032478632,0.010063008547,-0.00062152991453,-0.00196820512821,0.0190518974359,0.00577932478632,0.00832703418803,-0.0040598034188,0.00478893162393,-0.00592803418803
    South_East_European,0.109561670732,0.143623158537,0.00263523170732,-0.030917402439,0.0161754634146,-0.0115603902439,-6.02073170732e-05,-0.000509341463415,0.00431241463415,0.0169257317073,0.00173475609756,0.002067,-0.00356062195122,0.00216674390244,-0.00973869512195,-0.0014018902439,0.00288753658537,0.000624207317073,0.00299682926829,-0.0034452195122,-0.00416187804878,0.000254780487805,0.00118737804878,0.000659829268293,-8.1743902439e-05
    Balkan,0.125445035088,0.13292745614,0.0397100877193,0.0175043333333,0.0298516666667,0.00660042105263,0.00531436842105,0.00570824561404,-0.00016149122807,0.000975140350877,-0.00167235087719,-0.000817649122807,0.00279070175439,0.0112174210526,-0.011174245614,-0.00153524561404,0.00556757894737,9.10877192982e-05,0.00384368421053,-0.00278643859649,-0.00584931578947,-0.0013688245614,0.00446724561404,0.00049250877193,-0.000867666666667
    Inuit,0.0875402272727,-0.134557681818,0.0976228636364,0.0477159090909,-0.0459945454545,-0.0118275,-0.0368646363636,-0.03989,0.00512245454545,-0.0135020454545,0.0177003636364,-0.00362409090909,0.0062775,-0.00587404545455,-0.0136645909091,-0.00582790909091,-0.00129790909091,0.00533245454545,0.0134268181818,0.00788440909091,0.0129544090909,-0.0173113181818,0.00677859090909,0.0124222272727,0.0151701363636
    Andamanese,-0.00155712,-0.23077704,-0.163054888,0.109148848,0.002164128,0.047076768,-0.007085824,0.009876512,0.073132856,0.042856088,0.021925056,0.003650704,-0.004438416,0.012800064,-0.01838844,-0.021025488,0.011449832,-0.002919872,-0.00453624,0.02787736,-0.000766616,0.01606696,-0.007927328,0.007274144,0.00535416
    Volgan,0.107556252874,-0.021758045977,0.0788658850575,0.0584704252874,-0.0213018850575,0.00675429885057,0.00777147126437,0.0099597816092,-0.00811749425287,-0.0305256321839,0.0162108735632,-0.0071126091954,0.016826,-0.0217522413793,-0.0122850229885,-0.00836686206897,-0.00464282758621,-0.00160182758621,-0.0101742873563,-0.00939385057471,0.00226896551724,0.00230534482759,-0.00827032183908,0.00514118390805,-0.00123873563218
    South_Caucasian,0.108600705882,0.132227970588,-0.0537618529412,-0.052782,-0.0323499117647,-0.0113033529412,0.00898567647059,-0.00576232352941,-0.0497834705882,-0.0119899705882,0.00107473529412,0.00837929411765,-0.0172838823529,0.00539967647059,-0.00357667647059,-0.0173613823529,0.00813744117647,-0.00235120588235,-0.00411841176471,0.00969585294118,0.00810697058824,0.0022585,0.000170382352941,-0.00529473529412,-0.000517764705882
    Arabic,0.03833561,0.13955407,-0.05932487,-0.10934264,-0.00947556,-0.04581616,-0.01256843,-0.00725969,0.04945795,-0.00448661,0.01325897,-0.02575914,0.0519748,0.00394564,0.00340794,0.01958872,-0.01661746,0.00321157,-0.00034823,0.02041973,0.00902661,0.01197332,-0.00541675,0.00463666,-0.00546286
    Nepalese,0.0261379272727,-0.287284036364,-0.0752458909091,0.0304618363636,-0.00409572727273,0.0371634181818,0.00158090909091,0.00667103636364,0.0252754727273,0.0208213454545,-0.0386632727273,-0.0036976,0.0054626,-0.000245272727273,-0.0106677090909,-0.00725145454545,0.00563978181818,-0.00237021818182,-0.0059718,0.00703063636364,0.000887054545455,0.0182735636364,0.00407832727273,0.00227625454545,0.0218771272727
    Assyrian,0.0971791132075,0.133609207547,-0.0598696792453,-0.0637955471698,-0.0279296603774,-0.0175070188679,0.00257171698113,-0.0058299245283,-0.0195803018868,-0.00147852830189,0.00421290566038,-0.00156088679245,0.00523679245283,0.00189041509434,-0.00386933962264,0.00595658490566,-0.00179839622642,0.000960886792453,0.00300967924528,-0.00625535849057,0.000183641509434,0.000559924528302,-0.0016859245283,-0.00239622641509,0.00168549056604
    Balochistani,0.0644998,0.0539586,-0.100984466667,0.0274262888889,-0.0710628,0.0278828222222,0.004794,0.00162557777778,-0.0219931333333,-0.0201714666667,-0.00242504444444,-0.00337026666667,0.00520313333333,-0.00890564444444,0.0147814,0.0285303333333,-0.0101554888889,0.00417233333333,0.0061312,-0.0255206,0.000277266666667,-0.0142584888889,-0.000298444444444,-0.0164466888889,0.0124432
    Uralic,0.0784958148148,-0.216307666667,0.118283203704,0.0535222962963,-0.0951002962963,-0.0324907222222,0.010867037037,0.0171702592593,0.00365114814815,-0.028195962963,0.0611302407407,-0.00256159259259,0.0176190740741,-0.0727641666667,-0.0233665185185,-0.0129667407407,-0.00459242592593,0.00281292592593,0.00316575925926,-0.0087332962963,-0.00419853703704,0.0255869259259,0.0278585555556,-0.00684596296296,-0.00887474074074
    Finnic,0.126450322917,0.0756674791667,0.0860228229167,0.07450196875,0.0237447604167,0.0219365104167,0.00950561458333,0.0141171979167,-0.00074996875,-0.0281953125,0.00433545833333,-0.00901695833333,0.0177339583333,0.00830036458333,-0.00553764583333,-0.0007346875,-0.00207394791667,-0.000785197916667,-0.00101997916667,0.00107994791667,0.00341842708333,-0.000824291666667,0.00173957291667,0.000532197916667,0.0026331875
    North_Caucasian,0.109090421053,0.0896872631579,-0.0255301052632,-0.010863,-0.0337916052632,0.00321453947368,0.00869523684211,-0.00314264473684,-0.0489027368421,-0.0264793815789,-0.00253842105263,0.00614057894737,-0.0136533026316,-0.000505236842105,0.00692889473684,-0.0100924868421,0.00441588157895,-0.003729,-0.00795698684211,0.0115367894737,0.00414069736842,0.000898118421053,0.00164435526316,-0.00166947368421,-0.00162131578947
    Turkish_Persian,0.0919640218978,0.0933545693431,-0.0529867664234,-0.0302535474453,-0.0390841313869,-0.00289476642336,0.0041631459854,-0.00372752554745,-0.0267224525547,-0.0109554671533,6.87518248175e-05,-0.000114832116788,0.00152569343066,-0.000796591240876,0.00243505839416,0.0071404379562,-0.00266950364964,0.00188924087591,0.00256164963504,-0.00676415328467,-0.00113667153285,-0.00276818248175,-0.00060097810219,-0.00355862043796,0.00270961313869
    Siberian,0.0468053636364,-0.399380060606,0.136060484848,-0.00580421212121,-0.137843878788,-0.0793739090909,0.0261358787879,0.0378726060606,0.0267554242424,0.0163625454545,0.0698516969697,0.00802912121212,-0.0084196969697,-0.0011426969697,-0.010577969697,-0.00603078787879,0.00162384848485,0.00823475757576,0.0158265454545,-0.000852727272727,0.0350932727273,-0.0155389393939,0.0189054545455,0.00426854545455,0.00956903030303
    Central_European,0.12992905,0.13296324,0.06180256,0.04596613,0.03903183,0.01729965,0.00639687,0.00818503,0.00267107,-0.00727662,-0.00334519,-0.00322662,0.00346972,0.00825735,-0.00041395,0.00258948,0.00093482,0.00039652,0.00275406,0.00162573,-0.00042681,-0.00067518,0.00385638,0.00308836,-0.00039519
    African,-0.591486638298,0.0613260851064,0.012952462766,0.00714723404255,-0.000502526595745,0.00323396276596,0.0211459255319,-0.0101374414894,0.0127130851064,-0.0179211648936,-0.00309403191489,-0.000580319148936,-0.0101935212766,0.000508015957447,0.00473940425532,-0.00726631914894,0.0084777287234,0.0224569148936,-0.00383380319149,-0.00490328723404,-0.00262232446809,0.000556436170213,-0.000215026595745,-0.000677489361702,0.00119490957447
    South_West_European,0.117771302083,0.14881734375,0.0421942916667,-0.00269839583333,0.048008875,-0.00325664583333,-0.00211502083333,0.00231476041667,0.0264709166667,0.03764125,-0.00320210416667,0.0084830625,-0.01727409375,-0.0131243541667,0.0090819375,-0.0006491875,-0.00287389583333,0.000254677083333,-0.00161048958333,-0.00195272916667,0.00366411458333,-0.000740635416667,-0.00357160416667,-0.00518005208333,0.000303083333333
    East_Asian,0.0167248198198,-0.417675351351,-0.0385971126126,-0.0440356666667,0.0924967702703,0.0413838783784,6.66621621622e-05,-0.00509643693694,-0.00941636486486,-0.00520442342342,-0.00161804954955,-0.000880292792793,0.000764031531532,-0.00172898198198,-0.000669378378378,-0.000221027027027,0.000656671171171,0.000472513513514,-0.00136456306306,-0.00272707657658,0.00264058558559,0.00323388738739,0.00377847297297,-0.000198666666667,-0.000162378378378
    Levantine,0.0777233853211,0.142015779817,-0.0399159449541,-0.0716645137615,-0.00620291743119,-0.0261671100917,-0.00385276146789,-0.00376197247706,0.00921857798165,0.0108539357798,0.00600088073394,-0.00384150458716,0.00965478899083,0.000652816513761,-0.00481118348624,0.00314682568807,-0.00262683486239,-0.000663669724771,-0.000171825688073,-0.00103265137615,-0.00161180733945,-0.000878009174312,0.000767779816514,0.00097171559633,0.0011469266055
    Bengali,0.049579248062,-0.0649151627907,-0.14975196124,0.108295782946,-0.0717676744186,0.0612067674419,0.000209488372093,0.0110764108527,0.0366224341085,0.0217737054264,-0.00423591472868,0.000120821705426,-0.00175510852713,0.0011244496124,-0.00206944186047,-0.0026898372093,0.00147464341085,-0.000221976744186,-0.000414124031008,-0.00106548837209,0.0014615503876,-0.000637457364341,0.00101750387597,0.0020736124031,-0.0034949379845
    Turkic_Mongolic,0.0436122105263,-0.372506936842,0.0773930631579,-0.025109,-0.0638271894737,-0.0367078526316,0.0170296736842,0.0212347473684,0.00704645263158,0.0108881578947,-0.0136696842105,0.000615242105263,-0.00301544210526,0.00615390526316,0.00350733684211,0.00133428421053,-0.000868768421053,-0.000429431578947,0.00260125263158,0.00573561052632,-0.00879895789474,-0.00468967368421,-0.00778018947368,0.000257494736842,-0.00272398947368
    Eskimoic,0.04900085,-0.354292825,0.118368725,0.0434435,-0.1169909,-0.041310675,-0.101724425,-0.1170412,0.0053841,-0.0133305,0.0276994,-0.004705825,0.00913895,-0.0191364,-0.033170125,-0.014445625,-0.00199165,0.01538945,0.036109925,0.01914665,0.028583925,-0.049748675,0.009567125,0.028380525,0.0409574
    North_African,-0.0660553,0.133762066667,-0.00940291666667,-0.0744945666667,0.0223323166667,-0.0333367333333,-0.0264189666667,0.00886501666667,0.06108785,0.0257500166667,0.00745091666667,-0.00801283333333,0.0257232666667,-0.0139893833333,0.0163225666667,-0.0112568666667,-0.00282066666667,-0.01880695,-0.0392198833333,0.00899813333333,-0.0125361833333,-0.03138925,0.0224084833333,-0.00292201666667,0.0050753
    Amerindian,0.0547773977273,-0.305455113636,0.114858977273,0.0942243977273,-0.107785852273,-0.0166288181818,-0.285017113636,-0.340808295455,-0.0120994204545,-0.0157510227273,-0.00226973863636,-0.00252732954545,0.00140217045455,0.021866375,-0.00797821590909,0.00412684090909,0.00690592045455,0.000462136363636,0.00149698863636,-0.000497409090909,-0.00201488636364,0.00635544318182,-0.00133746590909,-0.000484693181818,-0.00184654545455
    North_Central_Asian,0.0695866666667,-0.187998320988,0.0384569753086,0.00671520987654,-0.0416068888889,-0.00594279012346,0.00798155555556,0.00870616049383,-0.00881466666667,-0.00797339506173,-0.0180391234568,-0.00239050617284,0.002619,-0.00990374074074,0.00294728395062,0.00169262962963,-0.00335617283951,-0.00013612345679,0.00220517283951,0.00505643209877,-0.0161043703704,-0.000344975308642,-0.00578956790123,-0.00115885185185,0.000101987654321
    North_West_European,0.131256426471,0.134027481618,0.0624703272059,0.0479655,0.0397245110294,0.0183288382353,0.00437522426471,0.00614651102941,0.00383029779412,0.00156105882353,-0.00587939705882,0.00505359191176,-0.0107396433824,-0.0101354852941,0.0206015367647,0.00455777573529,-0.00986748897059,0.00231347794118,0.00284116176471,0.00239908823529,0.00509669852941,0.00246440441176,-0.000158099264706,0.01409075,0.000460058823529
    Papuan,-0.0381306923077,-0.253608961538,-0.217975807692,0.236772461538,0.170078961538,-0.373177115385,0.00157269230769,0.00269815384615,-0.0243618846154,-0.0073805,-0.00244207692308,0.000293769230769,0.000291615384615,-0.00103211538462,-0.000751730769231,-0.00126980769231,0.00115842307692,0.000116961538462,0.000145076923077,0.00103903846154,0.0029515,-0.00182630769231,-0.00176811538462,-0.000153038461538,-0.00642030769231
    South_Central_Asian,0.0841096993007,0.0238755804196,-0.0749124895105,0.053758041958,-0.0623569090909,0.0338744825175,0.00321276923077,0.00134746153846,-0.0207212657343,-0.0180974335664,-0.00552802797203,-0.000581622377622,-0.000114391608392,-0.00954983216783,0.0124967202797,0.0127258251748,-0.00360695804196,0.00107904895105,0.00189425874126,-0.00956490909091,-0.0044886013986,-0.00517439160839,0.00141518881119,-0.00195067832168,0.00364768531469

  3. #3
    Veteran Member
    Apricity Funding Member
    "Friend of Apricity"

    Kaspias's Avatar
    Join Date
    Oct 2017
    Last Online
    @
    Location
    Ankara
    Meta-Ethnicity
    Rumelian
    Ethnicity
    Balkan Turkish, Pomak
    Country
    Turkey
    Y-DNA
    Q-F16045
    mtDNA
    K1a
    Gender
    Posts
    7,446
    Thumbs Up
    Received: 11,836
    Given: 7,303

    0 Not allowed!

    Default

    [1] "distance%=2.9943"

    Kaspias_scaled

    South_East_European,41.4
    Balkan,18.6
    Turkish_Persian,8.8
    North_Caucasian,6.8
    Finnic,2.8
    Assyrian,2.4
    Central_European,2.4
    Volgan,2.2
    Arabic,2
    Inuit,1.4
    Levantine,1.4
    Balto_Slavic,1.2
    Uralic,1.2
    North_Central_Asian,1
    South_Central_Asian,1
    Balochistani,0.8
    East_Asian,0.8
    Siberian,0.6
    Turkic_Mongolic,0.6
    Amerindian,0.4
    North_West_European,0.4
    North_West_Indian,0.4
    Abyssinian,0.2
    Andamanese,0.2
    Bengali,0.2
    Eskimoic,0.2
    Nepalese,0.2

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 107
    Last Post: 06-16-2023, 09:04 PM
  2. Replies: 366
    Last Post: 11-23-2022, 02:52 PM
  3. Replies: 68
    Last Post: 07-25-2020, 01:06 PM
  4. Replies: 4
    Last Post: 10-31-2018, 10:30 PM
  5. Replies: 0
    Last Post: 08-14-2017, 01:34 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •