Page 1 of 5 123 ... LastLast
Results 1 to 10 of 47

Thread: Are there updated G25 modern scaled and unscaled spreadsheets?

  1. #1
    Gold Class Member
    Posts
    3,114
    Sex
    Location
    Calne,England
    Ethnicity
    British and Irish
    Nationality
    Great Britain
    Y-DNA
    E-Y45878
    mtDNA
    H67

    United Kingdom Scotland England Ireland

    Are there updated G25 modern scaled and unscaled spreadsheets?

    Question in post title.
    Please support Mental health research and world community grid

    Hidden Content
    Hidden Content
    Hidden Content
    Hidden Content

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

     Defski (07-07-2019)

  3. #2
    Moderator
    Posts
    1,470
    Sex
    Location
    Viseu
    Ethnicity
    Romanised Paesuri
    Nationality
    Portuguese
    Y-DNA
    E-Y168273
    mtDNA
    H20 (H20c?)

    Asturias Portugal 1143 Portugal 1485 Portugal Order of Christ
    I think David just updated his sheets

    http://eurogenes.blogspot.com/2018/0...est-drive.html
    YDNA - E-Y31991>PF4428>E-Y134097>E-Y168273 (probably Scythian-Sarmatian). Domingos Rodrigues, b. circa 1680 Hidden Content , Viana do Castelo, Portugal
    mtDNA - H20. Maria Josefa de Almeida, b. circa 1750 Hidden Content , Porto, Portugal

    Global25 PCA West Eurasia dataset Hidden Content
    Hidden Content


    [1] "distance%=1.7726"

    Ruderico

    Celtiberian,77.6
    Roman_Imperial_proxy,13.6
    Guanche,8.8

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

     Defski (07-07-2019),  firemonkey (07-01-2019),  JMcB (07-01-2019)

  5. #3
    Gold Class Member
    Posts
    3,114
    Sex
    Location
    Calne,England
    Ethnicity
    British and Irish
    Nationality
    Great Britain
    Y-DNA
    E-Y45878
    mtDNA
    H67

    United Kingdom Scotland England Ireland
    ^ I've checked those they're a mix of ancient and modern populations .
    Please support Mental health research and world community grid

    Hidden Content
    Hidden Content
    Hidden Content
    Hidden Content

  6. The Following 2 Users Say Thank You to firemonkey For This Useful Post:

     JMcB (07-01-2019),  Ruderico (07-01-2019)

  7. #4
    Moderator
    Posts
    1,470
    Sex
    Location
    Viseu
    Ethnicity
    Romanised Paesuri
    Nationality
    Portuguese
    Y-DNA
    E-Y168273
    mtDNA
    H20 (H20c?)

    Asturias Portugal 1143 Portugal 1485 Portugal Order of Christ
    Oh you mean separated. I don't think there is, unless someone did it by themselves
    YDNA - E-Y31991>PF4428>E-Y134097>E-Y168273 (probably Scythian-Sarmatian). Domingos Rodrigues, b. circa 1680 Hidden Content , Viana do Castelo, Portugal
    mtDNA - H20. Maria Josefa de Almeida, b. circa 1750 Hidden Content , Porto, Portugal

    Global25 PCA West Eurasia dataset Hidden Content
    Hidden Content


    [1] "distance%=1.7726"

    Ruderico

    Celtiberian,77.6
    Roman_Imperial_proxy,13.6
    Guanche,8.8

  8. The Following User Says Thank You to Ruderico For This Useful Post:

     JMcB (07-01-2019)

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

    England Scotland Ireland Prussia Italy Two Sicilies United States of America
    Quote Originally Posted by firemonkey View Post
    ^ I've checked those they're a mix of ancient and modern populations .

    You can find the scaled Moderns, separated from the Ancients here:

    https://anthrogenica.com/showthread....l=1#post578698

    Note: these are the population averages.

    I not sure if he has the Ancients too, but you can always ask.
    Last edited by JMcB; 07-02-2019 at 12:14 AM.
    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 830 AD) >A13242/YSEQ (circa 975 AD) >A13243/YSEQ (circa 1550 AD).

  10. The Following 5 Users Say Thank You to JMcB For This Useful Post:

     firemonkey (07-01-2019),  JonikW (07-02-2019),  Ruderico (07-02-2019),  StillWater (07-02-2019),  Trelvern (07-01-2019)

  11. #6
    Registered Users
    Posts
    941
    Sex
    Location
    Brittany
    Nationality
    French
    Y-DNA
    R-U106>DF98>BY650
    mtDNA
    K1a

    France Bretagne Trégor France Bretagne Kroaz Du
    Quote Originally Posted by JMcB View Post
    You can find the scaled Moderns separate from the Ancients here:

    https://anthrogenica.com/showthread....l=1#post578698

    Note: these are the population averages.

    I not sure if he has the Ancients separated too, but you can always ask.
    Yes
    from ph2ter (05/27/2019)
    https://www.dropbox.com/s/gn73m6cifr...caled.txt?dl=0
    https://www.dropbox.com/s/od6lgb12rj...caled.txt?dl=0

    too old i presume
    Last edited by Trelvern; 07-01-2019 at 09:45 PM.

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

     firemonkey (07-01-2019),  JMcB (07-01-2019),  JonikW (07-02-2019),  StillWater (07-02-2019)

  13. #7
    Registered Users
    Posts
    381
    Sex

    Quote Originally Posted by JMcB View Post
    You can find the scaled Moderns separate from the Ancients here:

    https://anthrogenica.com/showthread....l=1#post578698

    Note: these are the population averages.

    I not sure if he has the Ancients separated too, but you can always ask.
    I have them. In the following link there are 4 spreadsheets: scaled coordinates divided in modern, ancients, individuals and averages. Updated as of July 1, 2019.

    https://we.tl/t-VWPDfj0bTU
    Last edited by Ajeje Brazorf; 07-01-2019 at 09:56 PM.

  14. The Following 9 Users Say Thank You to Ajeje Brazorf For This Useful Post:

     fabrice E (07-03-2019),  firemonkey (07-01-2019),  Hurricane (07-05-2019),  Jessie (07-02-2019),  JMcB (07-01-2019),  ph2ter (07-02-2019),  Ruderico (07-02-2019),  StillWater (07-02-2019),  Trelvern (07-01-2019)

  15. #8
    Gold Class Member
    Posts
    3,114
    Sex
    Location
    Calne,England
    Ethnicity
    British and Irish
    Nationality
    Great Britain
    Y-DNA
    E-Y45878
    mtDNA
    H67

    United Kingdom Scotland England Ireland
    Quote Originally Posted by JMcB View Post
    You can find the scaled Moderns separate from the Ancients here:

    https://anthrogenica.com/showthread....l=1#post578698

    Note: these are the population averages.

    I not sure if he has the Ancients separated too, but you can always ask.
    Using unscaled data

    [1] "distance%=3.5761"

    Tim_G

    Tatar_Lipka,20
    Turkmen,5.6
    Turkish_Balikesir,3.2
    Maori,3
    Tatar,2.6

    Using scaled data

    [1] "distance%=1.4464"

    Tim_G_scaled

    Orcadian,90.8
    Icelandic,3
    Scottish,2.4
    English_Cornwall,1.4
    Irish,1.2
    Finnish,0.4
    Finnish_East,0.4
    Russian_Pinega,0.2
    Swedish,0.2
    Please support Mental health research and world community grid

    Hidden Content
    Hidden Content
    Hidden Content
    Hidden Content

  16. The Following User Says Thank You to firemonkey For This Useful Post:

     JMcB (07-02-2019)

  17. #9
    Registered Users
    Posts
    941
    Sex
    Location
    Brittany
    Nationality
    French
    Y-DNA
    R-U106>DF98>BY650
    mtDNA
    K1a

    France Bretagne Trégor France Bretagne Kroaz Du
    Using the "Pastebin" spreadsheet i get:


    "1. CLOSEST SINGLE ITEM DISTANCE%"
    English_Cornwall Belgian French_Brittany English
    2.312409 2.315099 2.338748 2.461122
    Scottish Welsh Orcadian Irish
    2.629482 2.632177 2.771466 2.776520


    "distance%=1.6536"

    Trelvern_scaled

    Welsh,33.8
    English_Cornwall,19.2
    Irish,6.2
    Scottish,6.2
    French,5.2
    French_Brittany,4.8
    Belgian,3.4
    Spanish_Pais_Vasco,2.6
    Basque_Spanish,2.2
    Norwegian,2
    Spanish_Castilla_La_Mancha,1.6
    Spanish_Valencia,1.4
    Spanish_Aragon,1.2
    Basque_French,1
    Shetlandic,1
    Spanish_Andalucia,1
    Spanish_Baleares,1
    ....

  18. The Following 2 Users Say Thank You to Trelvern For This Useful Post:

     JMcB (07-02-2019),  JonikW (07-02-2019)

  19. #10
    Registered Users
    Posts
    941
    Sex
    Location
    Brittany
    Nationality
    French
    Y-DNA
    R-U106>DF98>BY650
    mtDNA
    K1a

    France Bretagne Trégor France Bretagne Kroaz Du
    And now the individuals

    "1. CLOSEST SINGLE ITEM DISTANCE%"
    French_French41 English_Cornwall_HG00255
    2.157339 2.581358
    English_HG01791 English_Cornwall_HG00264
    2.612424 2.612692
    English_Cornwall_HG00259 French_French16
    2.622630 2.652919
    Scottish_Scottish24 English_Cornwall_HG00243
    2.710594 2.719655

    "distance%=1.1436"

    Trelvern_scaled

    French_French41,11.2
    French_French16,6
    French_French17,5.4
    French_French6,5.4
    Dutch_Netherlands43,4.2
    English_England15,3.8
    English_Cornwall_HG00232,3.2
    English_England13,3
    French_French37,3
    Irish_Irish41,2.8
    French_East_French24118,2.4
    Irish_Irish27,2.4
    Welsh_WAL001,2.4
    Orcadian_HGDP00804,2.2
    Scottish_Scottish11,2.2
    Austrian_Austria4,2
    French_Brittany_French23830,1.6
    French_French66,1.2
    Scottish_Scottish2,1.2
    Welsh_WAL004,1.2
    English_Cornwall_HG00264,1
    Scottish_Scottish24,1
    Scottish_Scottish25,1
    .......

  20. The Following 2 Users Say Thank You to Trelvern For This Useful Post:

     JMcB (07-02-2019),  JonikW (07-02-2019)

Page 1 of 5 123 ... LastLast

Similar Threads

  1. A personal comparison of scaled and unscaled nMonte
    By firemonkey in forum Autosomal (auDNA)
    Replies: 0
    Last Post: 05-31-2019, 07:57 PM
  2. Scaled modern G25 distances to K=42 clusters
    By michal3141 in forum Autosomal (auDNA)
    Replies: 130
    Last Post: 05-15-2019, 07:44 PM
  3. Ultimate Modern World K=50 Calculator for G25 Scaled Spreadsheet
    By michal3141 in forum Autosomal (auDNA)
    Replies: 135
    Last Post: 05-03-2019, 09:54 AM
  4. Replies: 0
    Last Post: 02-24-2019, 04:36 PM
  5. Scaled or unscaled,penalty on or off
    By firemonkey in forum Autosomal (auDNA)
    Replies: 19
    Last Post: 01-11-2019, 09:21 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
  •