Page 2 of 6 FirstFirst 1234 ... LastLast
Results 11 to 20 of 60

Thread: K25 calculator for G25 scaled spreadsheet

  1. #11
    Registered Users
    Posts
    899
    Sex
    Omitted
    Y-DNA
    Z372
    mtDNA
    J2b1a-T16311C!

    Cornwall New Zealand
    ,PC1,PC2,PC3,PC4,PC5,PC6,PC7,PC8,PC9,PC10,PC11,PC1 2,PC13,PC14,PC15,PC16,PC17,PC18,PC19,PC20,PC21,PC2 2,PC23,PC24,PC25
    Timberwolf_scaled,0.133173,0.138112,0.061471,0.039 729,0.048932,0.019243,0.00987,0.010153,0.007363,0. 005832,-0.008444,0.009891,-0.018434,-0.010046,0.024837,0.001856,-0.013951,0.00114,-0.000377,-0.003502,0.006364,0.005317,-0.00419,0.010483,-0.001676


    Many thanks.

  2. The Following User Says Thank You to timberwolf For This Useful Post:

     michal3141 (12-08-2018)

  3. #12
    Gold Member Class
    Posts
    538
    Location
    USA
    Ethnicity
    Bosnia & Herzegovina
    Y-DNA
    I1-Z63>Y6228
    mtDNA
    H5c

    distance%=2.5728"

    Username_scaled

    Balto_Slavic,45.2
    Central_European,22.4
    Greek+Albanian,19.2
    Finnish,3.4
    Maltese+European_Jewish,2.8
    Neolithic_Farmers,2.8
    Caucasian,1.8
    Semitic,1.6
    Arabic,0.4
    Brahui+Balochi,0.4

    pen=0,
    distance%=2.2331"

    Username_scaled

    Balto_Slavic,64.8
    Maltese+European_Jewish,14.4
    Greek+Albanian,12.4
    Caucasian,3.2
    Neolithic_Farmers,3.2
    Semitic,2

  4. The Following 4 Users Say Thank You to Username For This Useful Post:

     Просигој (12-11-2018),  Hurricane (12-08-2018),  JMcB (12-08-2018),  michal3141 (12-08-2018)

  5. #13
    Gold Member Class
    Posts
    358
    Sex
    Location
    Tennessee
    Ethnicity
    Anglo/British Isles
    Nationality
    American
    Y-DNA
    R1b>DF27
    mtDNA
    J1c5

    United States of America England Wales Northern Ireland Scotland Normandie
    Quote Originally Posted by timberwolf View Post
    ,PC1,PC2,PC3,PC4,PC5,PC6,PC7,PC8,PC9,PC10,PC11,PC1 2,PC13,PC14,PC15,PC16,PC17,PC18,PC19,PC20,PC21,PC2 2,PC23,PC24,PC25
    Timberwolf_scaled,0.133173,0.138112,0.061471,0.039 729,0.048932,0.019243,0.00987,0.010153,0.007363,0. 005832,-0.008444,0.009891,-0.018434,-0.010046,0.024837,0.001856,-0.013951,0.00114,-0.000377,-0.003502,0.006364,0.005317,-0.00419,0.010483,-0.001676


    Many thanks.
    [1] "distance%=2.3063"

    Timberwolf_scaled

    NW_European+Beakers,88.2
    Iberian+Basques,8.8
    Neolithic_Northern_Europe,2.6
    Neolithic_Farmers,0.4

  6. The Following 4 Users Say Thank You to Garimund For This Useful Post:

     JMcB (12-08-2018),  michal3141 (12-08-2018),  timberwolf (12-08-2018),  Trelvern (01-23-2019)

  7. #14
    Registered Users
    Posts
    720
    Sex
    Location
    Krakow
    Ethnicity
    Polish
    Nationality
    Pole
    Y-DNA
    R1a > M458 > Y23110
    mtDNA
    J1c1

    Poland
    Quote Originally Posted by poi View Post
    michal3141, do you want this in the online tool? Looks very interesting!
    Yes. That's a good idea.
    For K25 and other calculators by me you can send me you raw data to my email: Hidden Content

  8. The Following 3 Users Say Thank You to michal3141 For This Useful Post:

     Aroon1916 (01-09-2019),  JMcB (12-08-2018),  poi (12-08-2018)

  9. #15
    Registered Users
    Posts
    607
    Sex
    Location
    Iowa
    Nationality
    American
    Y-DNA
    Dad: I1-P109
    mtDNA
    T1a1

    Germany United Kingdom Czech Republic Canada Canada Quebec Netherlands
    [1] "penalty= 0"
    [1] "Ncycles= 1000"
    [1] "distance%=1.8537"

    PV_scaled

    NW_European+Beakers,63.4
    Balto_Slavic,17.8
    Iberian+Basques,16.8
    East_Asian,0.8
    Ethiopian+Somali+Iberomaurusian,0.6
    European_Hunters_Gatherers,0.4
    African,0.2


    [1] "penalty= 0.001"
    [1] "Ncycles= 1000"
    [1] "distance%=2.0192"

    PV_scaled

    NW_European+Beakers,69.2
    Central_European,10.4
    Balto_Slavic,7.8
    Iberian+Basques,6
    Finnish,3
    Neolithic_Northern_Europe,1.6
    European_Hunters_Gatherers,0.6
    Ethiopian+Somali+Iberomaurusian,0.4
    Neolithic_Farmers,0.4
    Arabic,0.2
    Maltese+European_Jewish,0.2
    Uralic,0.2
    Ancestry paper trail tally: 21.1% Colonial American (British Isles, German, Dutch, Swiss, French), 14.1% not traced past 19th Century United States (MD, NJ, NY, PA, VA), 7.8% Canadian (Ontario & Quebec), 40.6% German, 15.6% Czech, 0.8% British & Irish

    Hidden Content * Hidden Content * Hidden Content

  10. The Following 3 Users Say Thank You to PoxVoldius For This Useful Post:

     Hurricane (12-08-2018),  JMcB (12-08-2018),  michal3141 (12-08-2018)

  11. #16
    Registered Users
    Posts
    274
    Sex
    Location
    Australia
    Ethnicity
    British Islander
    Y-DNA
    R1b-M222 > DF109
    mtDNA
    K1a10

    Australia England Ireland
    Pen=0

    Me

    [1] "distance%=2.2878"

    NW_European+Beakers,96
    Iberian+Basques,2.6
    Neolithic_Northern_Europe,1.4

    Father

    [1] "distance%=2.7497"

    NW_European+Beakers,99.8
    Neolithic_Northern_Europe,0.2

    Mother

    [1] "distance%=1.6287"

    NW_European+Beakers,89.4
    Neolithic_Farmers,5.6
    Sintashta+Srubnaya+Kangju,4
    European_Hunters_Gatherers,1
    LivingDNA: 97.6% British Isles, 2.4% Scandinavia. 45.1% Central England related.
    AncestryDNA: 53% England/Wales/NW Euro, 47% Ireland/Scotland

  12. The Following 2 Users Say Thank You to Molfish For This Useful Post:

     JMcB (12-08-2018),  michal3141 (12-08-2018)

  13. #17
    Gold Member Class
    Posts
    2,094
    Sex
    Location
    Pennsylvania
    Ethnicity
    West European
    Nationality
    USA
    Y-DNA
    R1b-U152-Z36+FGC6511
    mtDNA
    H11a2a

    United States of America Germany England France Scotland Ireland
    pen=0 results:

    Me:

    [1] "distance%=1.7218"

    NW_European+Beakers,77.8
    Neolithic_Farmers,15
    Neolithic_Northern_Europe,5.8
    East_Asian,0.8
    NE_Asian,0.4
    Amerindian,0.2

    Dad:

    [1] "distance%=3.0036"

    NW_European+Beakers,63.2
    Neolithic_Farmers,20.6
    Sintashta+Srubnaya+Kangju,8.8
    Central_European,2.6
    NE_Asian,1.8
    Yamnaya+Afanasievo+EHG,1.6
    European_Hunters_Gatherers,0.8
    East_Asian,0.6

    Mom:

    [1] "distance%=1.9018"

    NW_European+Beakers,80.2
    Neolithic_Farmers,13.4
    Balto_Slavic,4.6
    Neolithic_Northern_Europe,1.8

    Wife:

    [1] "distance%=1.2605"

    NW_European+Beakers,85.8
    Neolithic_Farmers,11.6
    Arabic,2.6

    Father in law:

    [1] "distance%=2.9269"

    NW_European+Beakers,83
    Iberian+Basques,14.2
    Arabic,2
    African,0.6
    Ethiopian+Somali+Iberomaurusian,0.2

    Default penalty:

    Me:

    [1] "distance%=1.9277"

    Central_European,39.4
    NW_European+Beakers,34.4
    Iberian+Basques,19.2
    Neolithic_Northern_Europe,5.4
    Neolithic_Farmers,1.2
    NE_Asian,0.2
    Uralic,0.2

    Dad:

    [1] "distance%=3.136"

    Central_European,51.4
    NW_European+Beakers,28
    Neolithic_Northern_Europe,5.2
    Neolithic_Farmers,4.6
    Sintashta+Srubnaya+Kangju,3
    Greek+Albanian,2
    Yamnaya+Afanasievo+EHG,1.8
    Iberian+Basques,1.6
    Uralic,0.8
    NE_Asian,0.6
    Siberian_Turkic,0.4
    Amerindian,0.2
    Arabic,0.2
    East_Asian,0.2

    Mom:

    [1] "distance%=1.9675"

    Central_European,45.6
    NW_European+Beakers,44.4
    Neolithic_Northern_Europe,4.4
    Iberian+Basques,3.2
    Neolithic_Farmers,2.4

    Wife:

    [1] "distance%=1.5091"

    NW_European+Beakers,55.2
    Central_European,29.2
    Iberian+Basques,10.6
    Neolithic_Farmers,2.2
    Maltese+European_Jewish,1
    Neolithic_Northern_Europe,1
    Arabic,0.4
    Semitic,0.4

    Father in law:

    [1] "distance%=3.0663"

    NW_European+Beakers,80.4
    Iberian+Basques,9.2
    Central_European,8.6
    Greek+Albanian,1
    Maltese+European_Jewish,0.4
    Arabic,0.2
    Ethiopian+Somali+Iberomaurusian,0.2

  14. The Following 4 Users Say Thank You to randwulf For This Useful Post:

     Hurricane (12-08-2018),  JMcB (12-08-2018),  michal3141 (12-08-2018),  Trelvern (01-23-2019)

  15. #18
    Gold Member Class
    Posts
    1,245
    Sex
    Location
    Florida, USA.
    Ethnicity
    English, Scottish & Irish
    Nationality
    American
    Y-DNA
    I-A13243
    mtDNA
    H1e2

    England Scotland Ireland United States of America Vatican Germany Schleswig-Holstein
    Quote Originally Posted by michal3141 View Post
    with pen=0:

    [1] "distance%=1.379"

    JMcB_scaled

    NW_European+Beakers,84.4
    Neolithic_Northern_Europe,11.2
    Neolithic_Farmers,2.4
    Balto_Slavic,2

    with pen=0.001:

    [1] "distance%=1.4748"

    JMcB_scaled

    NW_European+Beakers,75.4
    Central_European,8.6
    Iberian+Basques,7.8
    Neolithic_Northern_Europe,5.4
    Neolithic_Farmers,1.8
    European_Hunters_Gatherers,1
    Thank you, Michal! Very interesting!
    Known Paper Trail: 45.3% English, 29.7% Scottish, 12.5% Irish, 6.25% German & 6.25% Italian. Or: 87.5% British Isles, 6.25% German & 6.25% Italian.
    LivingDNA: 88.1% British Isles (59.7% English, 27% Scottish & 1.3% Irish), 5.9% Europe South (Aegian 3.4%, Tuscany 1.3%, Sardinia 1.1%), 4.4% Europe NW (Scandinavia) & 1.6% Europe East, (Mordovia).
    FT Big Y: I1-Z140 branch I-F2642 >Y1966 >Y3649 >A13241 >Y3647 >A13248 (circa 930 AD) >A13242/YSEQ (circa 1075 AD) >A13243/YSEQ (circa 1660 AD).

  16. The Following 2 Users Say Thank You to JMcB For This Useful Post:

     Finn (12-13-2018),  michal3141 (12-08-2018)

  17. #19
    Gold Member Class
    Posts
    286
    Sex

    If someone has time could they run mine please?

    ,PC1,PC2,PC3,PC4,PC5,PC6,PC7,PC8,PC9,PC10,PC11,PC1 2,PC13,PC14,PC15,PC16,PC17,PC18,PC19,PC20,PC21,PC2 2,PC23,PC24,PC25
    Jackson_Devoni_scaled,0.124067188128046,0.12186353 0229515,0.0497799284852841,0.034561165634278,0.029 5439902518262,0.00948228242566103,0.00517023403725 595,0.00207683653665858,0,-0.000911180552909247,0.00308538004142115,-0.00164853268090141,-0.00713571299871288,-0.00302769879611562,0.00773605713525954,0.00570135 247112472,-0.00625843430899454,0.00557429816210077,-0.000754188305398592,-0.00287637966895888,0.00237081631511174,0.00284401 300981553,-0.000246495436063226,0.00602494813255683,0.0040714 9112733897

  18. #20
    Registered Users
    Posts
    305
    Sex
    Nationality
    Scottish
    mtDNA
    J1c8 / L1b

    Scotland England
    With pen=0

    distance%=1.422

    NW_European+Beakers,92.4
    Iberian+Basques,5
    Neolithic_Farmers,1.8
    Amerindian,0.8

    pen=0.001

    distance%=1.4804

    NW_European+Beakers,94.2
    Iberian+Basques,3.6
    Neolithic_Northern_Europe,1
    Neolithic_Farmers,0.8
    Amerindian,0.2
    Yamnaya+Afanasievo+EHG,0.2
    DNA Tribes
    Me
    92.1% European, 3.2% South Asian, 2.9% North African & Middle Eastern, 0.9% Siberian, 0.6% Amerindian, 0.2% Sub-Saharan African

    My mother
    95% European, 2.9% North African & Middle Eastern, 2.1% Amerindian

  19. The Following 4 Users Say Thank You to Ais For This Useful Post:

     Hurricane (12-08-2018),  JMcB (12-08-2018),  michal3141 (12-08-2018),  ph2ter (12-08-2018)

Page 2 of 6 FirstFirst 1234 ... LastLast

Similar Threads

  1. World K=8 calculator based on G25 scaled coordinates
    By michal3141 in forum Autosomal (auDNA)
    Replies: 69
    Last Post: 11-13-2018, 01:11 AM
  2. Comprehensive aDNA Spreadsheet
    By Kale in forum Ancient (aDNA)
    Replies: 9
    Last Post: 07-16-2017, 06:02 PM
  3. AIM: frequencies spreadsheet
    By anglesqueville in forum Inquiries Corner
    Replies: 8
    Last Post: 02-19-2016, 07:25 AM
  4. YFull.com Y-SNPs Spreadsheet.
    By MitchellSince1893 in forum Other
    Replies: 0
    Last Post: 01-11-2015, 01:55 PM
  5. R1b-L21 Haplotypes Spreadsheet
    By Mikewww in forum R1b-L21
    Replies: 54
    Last Post: 06-23-2014, 08:10 PM

Posting Permissions

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