World Families Forums - Posting a combined R-L21 data Excel spreadsheet

Welcome, Guest. Please login or register.
September 03, 2014, 12:56:40 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)
| | |-+  Posting a combined R-L21 data Excel spreadsheet
« previous next »
Pages: 1 [2] Go Down Print
Author Topic: Posting a combined R-L21 data Excel spreadsheet  (Read 2358 times)
cmblandford
Senior Member
***
Offline Offline

Posts: 85


« Reply #25 on: February 26, 2010, 03:08:55 PM »

How about 25 years/generation which yields 3265 years to coalescence?  30 years seems appropriate for the present but given the total time span perhaps it should be less.  I don’t know the actual generational data.
Logged

Y-DNA:  R-DF13*


Surname Project:  Blandford

Kit:  ft115893   Ysearch:  EYSPZ


Earliest Known Ancestor:  Thomas Blanford; Dorset, England; born 1648


Jdean
Old Hand
****
Offline Offline

Posts: 678


« Reply #26 on: February 26, 2010, 09:23:56 PM »

How about 25 years/generation which yields 3265 years to coalescence?  30 years seems appropriate for the present but given the total time span perhaps it should be less.  I don’t know the actual generational data.

There have been several discussions on this, but I read somewhere (sorry can't remember the source) of a study that included all cultural societies ,including nomadic and hunter gather, which came up with an average age per generations of 32.5 yrs. Apparently this was fairly consistent throughout all the groups looked at.
Logged

Y-DNA R-DF49*
MtDNA J1c2e
Kit No. 117897
Ysearch 3BMC9

Mike Walsh
Guru
*****
Offline Offline

Posts: 2964


WWW
« Reply #27 on: April 04, 2010, 09:07:47 PM »

I've just uploaded a new  R-L21+ Haplotypes file under the FILES section.  This file includes people from the R-L21Plus and R-M222 (R1b1c7) Projects and also some surname projects that I've found.  This all inclusive file includes all known L21+ regardless of whether they are true R-L21* or are instead L21+ along with M222+, L159.2+, L193+ or L226+, etc.  However, only confirmed deep clade SNP tested people are included... none are just "predicted".

http://tech.groups.yahoo.com/group/RL21Project/files/

There are 1326 haplotypes, including:
254  M222+
41   L159.2+
8    L193+
47   L226+
62   true R-L21** by which I mean they are confirmed
     L130- L144- L159.2- L192- L193- L195- L226- L96- M222- M37- P66-

The modal for R-L21+ is exactly the same as WAMH for all 67 markers except one.  The exception is 449=30 for L21+ instead of 449=29.  The R-M222+ folks have a heavy bias to 449=30 and that tips the modal for all of L21+ up one.

Shortly, I will upload a "lite" version of this file with just 67 length haplotypes and without the bells and whistles.

If you know any R-L21+ people, including those that are by default because they M222+, L159.2+, L193+ or L226+, please have them join.

http://www.familytreedna.com/group-join-request.aspx?group=R-L21Plus

I've got a system where I can upload and check for upgrades (downstream testing, etc.) from the L21+ Project whereas I can't keep up with the the haplotypes I've gleaned from surname and geographical projects and Ysearch.
Logged

R1b-L21>L513(DF1)>S6365>L705.2(&CTS11744,CTS6621)
Mike Walsh
Guru
*****
Offline Offline

Posts: 2964


WWW
« Reply #28 on: April 05, 2010, 09:21:56 AM »

I've uploaded a 2nd version "lite" version of the spreadsheet. http://tech.groups.yahoo.com/group/RL21Project/files/

The file name is R-L21_Haplotypes_67.xls

The lite version has 887 haplotypes that are all 67 or greater in length only.

The spreadsheet bells and whistles (off-modal and GD columns, etc.) are removed so it is a smaller spreadsheet.  I also have 389-2 set to the normal FTDNA usage rather that 389ii-i. 

The intent of this is to have a spreadsheet that is easier to work with if you have a mid-memory/speed PC and easier to import into other tools. 

All 67 length R-L21+ (R-L21*  and R-M222+, etc.) confirmed deep clade haplotypes that I can find are included, whatever the source.

The big spreadsheet with 1326 haplotypes is named R-L21_Haplotypes.xls
Logged

R1b-L21>L513(DF1)>S6365>L705.2(&CTS11744,CTS6621)
Pages: 1 [2] 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.08 seconds with 17 queries.