World Families Forums - Haplotype tracking for P312 et al, including U152, L21 and DF27

Welcome, Guest. Please login or register.
July 10, 2014, 01:01:30 AM
Home Help Search Login Register

+  World Families Forums
|-+  General Forums - Note: You must Be Logged In to post. Anyone can browse.
| |-+  R1b General (Moderator: rms2)
| | |-+  Haplotype tracking for P312 et al, including U152, L21 and DF27
« previous next »
Pages: [1] Go Down Print
Author Topic: Haplotype tracking for P312 et al, including U152, L21 and DF27  (Read 1087 times)
Mike Walsh
Guru
*****
Offline Offline

Posts: 2963


WWW
« on: June 07, 2012, 12:02:53 PM »

As most of you know, I keep track of all the P312 (S116) confirmed haplotypes I can. I keep them in two large spreadsheet files.

All P312 xL21 haplotypes are in the Files section of this P312 Yahoo Group. You can access this file at the URL:
http://groups.yahoo.com/group/R-P312Project/files/Haplotype_Data_R-P312xL21.zip 

All L21 haplotypes are in the Files section of this L21 Yahoo Group. There are quite a few of these so I separate them out. You can access this file at the URL:
http://groups.yahoo.com/group/RL21Project//files/Haplotype_Data_R-L21All.zip
The 111 STR versions of the L21 haplotypes along with the supplementary tables are in a similar file that ends with L21Ext.zip.

If you see errors or have suggestions, please make them on either the P312 or L21 Yahoo Group forums as is appropriate.

Regards,
Mike W
Logged

R1b-L21>L513(DF1)>L705.2
Mike Walsh
Guru
*****
Offline Offline

Posts: 2963


WWW
« Reply #1 on: June 07, 2012, 12:04:32 PM »

All P312 xL21 haplotypes are in the Files section of this P312 Yahoo Group. You can access this file at the URL:
http://groups.yahoo.com/group/R-P312Project/files/Haplotype_Data_R-P312xL21.zip 

I've just updated the P313xL21 file. The overnight SNP results are included in the Downstream SNPs column and the Hg (Haplogroup) column. I use the table in the Clades tab to automatically designate the SNP based Hg labels. I've done quite a bit of relabeling of STR-signature based varieties (clusters) to make the sort by Variety more logical.

It is important to let me know if you see errors, particularly in the Clades tab. Occasionally, I'm a little uncertain on the positioning of new SNPs.

Below is the asterisk / double asterisk scheme I'm using.

P312 .... * = U152- L21- .... ** = U152- L21- DF27- DF19- L617- L238-

DF27 .... * = Z196- .... ** = Z196- Z225-

Z196 .... * = Z209- L176.2- ....  ** = Z209- L176.2- DF17-

L176.2 .. * = SRY2627- .... ** = SRY2627- L165-
Logged

R1b-L21>L513(DF1)>L705.2
chris1
Senior Member
***
Offline Offline

Posts: 66


« Reply #2 on: June 07, 2012, 01:22:21 PM »

Does anyone have any advice for 'Microsoftically challenged' Mac users? Open Office won't open it..
Logged
Mike Walsh
Guru
*****
Offline Offline

Posts: 2963


WWW
« Reply #3 on: June 07, 2012, 04:21:43 PM »

Does anyone have any advice for 'Microsoftically challenged' Mac users? Open Office won't open it..

The file is zipped (compressed) from a MS Excel 2010 .xlsm format.  I haven't tried it for a while this way, but people were unzipping it, opening it with OpenOffice(.org) 3.3 and saving it as an older version of Excel.

The other option is an education price. I take some classes but also fund two college students.  I think they buy MS Office at their college store for less than $40.
« Last Edit: June 07, 2012, 04:22:40 PM by Mikewww » Logged

R1b-L21>L513(DF1)>L705.2
razyn
Old Hand
****
Offline Offline

Posts: 405


« Reply #4 on: June 07, 2012, 05:09:39 PM »

Office for Macs was $150 when I bought the 2008 version (new) in the summer of 2009.  It was obsolete the next year, and won't read your Excel 2010 macros.  I can, however, unzip the file (with a different Mac program), tell it to kill the macros, and then read the data.  With a big magnifying glass.
Logged

R1b Z196*
chris1
Senior Member
***
Offline Offline

Posts: 66


« Reply #5 on: June 08, 2012, 07:11:12 AM »

Does anyone have any advice for 'Microsoftically challenged' Mac users? Open Office won't open it..
Thanks for the replys. The file would not open in OpenOffice at all, it just hangs. I have managed to find another way of viewing the file by signing in to Microsoft's SkyDrive. You can then view it online (just) with their ExcelWebApp.
Logged
Pages: [1] Go Up Print 
« previous next »
Jump to:  


SEO light theme by © Mustang forums. Powered by SMF 1.1.13 | SMF © 2006-2011, Simple Machines LLC

Page created in 0.146 seconds with 18 queries.