Sunday, December 29, 2013

Globe13 Calculator for genetic distance, biogeographical ancestry, and Oracle

Today, I am presenting a quite big Excel file (93 MB) that I generated to calculate genetic distances, biogeographical ancestry, and Oracle.
The file can be found in KurdishDNA.blogspot.com Data Sink.
Here is the direct link.

How to use it:
1. Open file in Excel; enable Macro.
2. Go to sheet "Paste here!" and add your Globe13 component values in cells B2 - N2.
3. Go to "Tools", then "Macro", then run Macro "Sort".
4. You are done. The results appear on sheet "Paste here!". Based on your computer the calculations can take up to one minute.

Example: results for Kurd_D

1. Top100 matches for Kurd_D (all samples)
 2. Top100 matches for Kurd_D (reference populations only)
3. Oracle TOP500 combinations for Kurd_D (reference populations only)
4. OracleTOP500 combinations for Kurd_D (all samples)
5. Predicted location for biogeographical ancestry of Kurd_D

The calculated latitude and longitude numbers can be directly pasted into maps.google.com


Previously, I used this Excel file to generate some phylogenetic trees and a map.


at

15 comments:

  1. MfADecember 29, 2013 at 4:09 AM

    Thanks Palisto,
    i have a problem here
    >http://abload.de/img/desktop_2013_12_29_14rhck9.png
    >debug screen http://abload.de/img/erretav4e14.png

    I don't have this problem with your K12b tool.

    ReplyDelete
    Replies
    1. PalistoDecember 29, 2013 at 4:27 AM

      Thanks for letting me know. It is a typo, just replace "CJX288" with "CX288" in the macro.

      I think you are using an older version of Excel, it cannot handle that many columns, with my Excel I don't get this error message.

      Delete
    2. MfADecember 29, 2013 at 5:13 AM

      This comment has been removed by the author.

      Delete
    3. MfADecember 29, 2013 at 5:16 AM

      Thanks it's fixed now. It placed me on north of Gever now
      http://goo.gl/maps/IPb85

      Do you plan something similar for Eurogenes tools such as K13 or K15?

      Delete
  2. tempelier33December 30, 2013 at 8:24 AM

    Hi, I'm getting this error: http://img822.imageshack.us/img822/3715/3pyd.png

    http://img513.imageshack.us/img513/401/a43s.png

    ReplyDelete
    Replies
    1. ZertDecember 31, 2013 at 5:39 AM

      Ik had ook een error, maar de resultaten verschenen nog wel altijd in het 'Paste Here' tabblad.

      Delete
  3. ZertDecember 31, 2013 at 5:57 AM

    This comment has been removed by the author.

    ReplyDelete
  4. ZertDecember 31, 2013 at 6:05 AM

    My predicted location was 35.47; 42.97, which made me end up quite a bit south of Mosul.
    Revised: I changed CJX288 to CX288, and it made all my results change. How can this be? It recognized my DOD number in both cases, yet the population sets as well as the location changed.
    New location: 38.65; 44.28, Bakur-Rojhelat border, at the height of Van.

    ReplyDelete
    Replies
    1. PalistoDecember 31, 2013 at 1:09 PM

      Not sure why you got 35.47; 42.97 in your first run.
      38.65; 44.28 is the correct calculated location.

      Delete
  5. beywFebruary 2, 2014 at 5:10 AM

    Where can I get my Globe13 component values?

    ReplyDelete
    Replies
    1. PalistoFebruary 2, 2014 at 8:19 PM

      http://dodecad.blogspot.com/2012/10/globe13-participant-results.html
      Use the calculator from the link above.

      Delete
  6. KurtiFebruary 4, 2014 at 2:24 AM

    Palisto can I have your E-Mail adress. I recently got my first results and wanted to send you my y and mtDNA. I have allot of questions about it. My yDNA says R1a1a* and I seem to not fit the either of the R1a1a1/R1a1a2,/R1a1a3/R1a1a4/R1a1a5 sub clades.

    ReplyDelete
  7. Abdul bariApril 9, 2014 at 7:40 AM

    You can measure the distance between two locations using Google Maps. The instructions below are different depending on whether city distance calculator.

    ReplyDelete
  8. albina N muroSeptember 2, 2014 at 6:12 AM

    I recently had a need to calculate distance between a large number of latitude/longitude coordinate pairs. USA city distances There are many options available if you want to import these in a GIS and run analysis. But there is a simpler and much more accesible way if you aren't doing very high accuracy calculations.

    ReplyDelete