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.
Thanks Palisto,
ReplyDeletei 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.
Thanks for letting me know. It is a typo, just replace "CJX288" with "CX288" in the macro.
DeleteI 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.
This comment has been removed by the author.
DeleteThanks it's fixed now. It placed me on north of Gever now
Deletehttp://goo.gl/maps/IPb85
Do you plan something similar for Eurogenes tools such as K13 or K15?
Hi, I'm getting this error: http://img822.imageshack.us/img822/3715/3pyd.png
ReplyDeletehttp://img513.imageshack.us/img513/401/a43s.png
Ik had ook een error, maar de resultaten verschenen nog wel altijd in het 'Paste Here' tabblad.
DeleteThis comment has been removed by the author.
ReplyDeleteMy predicted location was 35.47; 42.97, which made me end up quite a bit south of Mosul.
ReplyDeleteRevised: 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.
Not sure why you got 35.47; 42.97 in your first run.
Delete38.65; 44.28 is the correct calculated location.
Where can I get my Globe13 component values?
ReplyDeletehttp://dodecad.blogspot.com/2012/10/globe13-participant-results.html
DeleteUse the calculator from the link above.
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.
ReplyDeleteI sent you a message.
DeleteYou can measure the distance between two locations using Google Maps. The instructions below are different depending on whether city distance calculator.
ReplyDeleteI 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