World Families Forums - TMRCA Estimator Excel spreadsheet

Welcome, Guest. Please login or register.
August 01, 2014, 10:12:52 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)
| | |-+  TMRCA Estimator Excel spreadsheet
« previous next »
Pages: [1] 2 Go Down Print
Author Topic: TMRCA Estimator Excel spreadsheet  (Read 3045 times)
Mark Jost
Old Hand
****
Offline Offline

Posts: 707


« on: January 14, 2013, 11:37:48 AM »

Updated my TRMCA estimator spreadsheet to V2.3 which is located directly from this link.

https://docs.google.com/file/d/0By9Y3jb2fORNSU9Lbi1rYXl4NUU/edit

This current file is loaded with all current R1b-L21 111 Markers from MikeW's
latest spreadsheet.

The TMRCA Estimator Excel spreadsheet using the Ken N's Gen111t Engine modified
by me and uses Excel 2003 or newer built in functions such a Var etc enhancing
the precision. This spreadsheet is in a Zipped file to make the file size small.
Click download under the file menu and save and unzip to your desktop or
document storage. I have added some new Dashboard features. Whole population
matches Kens original Coalescence (whole (n) population) variance results. Added
sample population (n-1) Coalescence and InterClade Coalescence (n-1) Age.
Filtering inside clade sheets integrated and Recalculate Filter button with
Modal, rounded Mean and Median STR data. Replaced original Founders Model
Interclade Age using a Pooled SD replacing the Iterate task which is no longer
needed. Can import 67 and 111 marker(added ExtHts Vlookup to provide full data
columns) Haplotypes directly from an "Open" MikeW R1b-L21 or 67 markers from
R1b-Early spreadsheet. Modified Graphical Time Line sheet shows all forms of
YBP's. Read instruction at the bottom of Results Tab. V2.3

MJost
TMRCA Estimator Excel spreadsheet
Logged

148326
Pos: Z245 L459 L21 DF13**
Neg: DF23 L513 L96 L144 Z255 Z253 DF21 DF41 (Z254 P66 P314.2 M37 M222  L563 L526 L226 L195 L193 L192.1 L159.2 L130 DF63 DF5 DF49)
WTYNeg: L555 L371 (L9/L10 L370 L302/L319.1 L554 L564 L577 P69 L626 L627 L643 L679)
Mark Jost
Old Hand
****
Offline Offline

Posts: 707


« Reply #1 on: April 09, 2013, 10:39:58 PM »

My TRMCA Variance Estimator V5 is released.
 
Loaded with MikeW's latest R1b-L21 111 and 67 marker Haplotypes with all major subclades included and their zzzunknown haplogroup Hts included. R1b-early xL21 67 marker HTs in Backup tab.
 
http://tinyurl.com/TMRCA-Gen111T-Estimator-L21
 
Please read the notes at the bottom of the Results-Gen111t worksheet.

MJost
Logged

148326
Pos: Z245 L459 L21 DF13**
Neg: DF23 L513 L96 L144 Z255 Z253 DF21 DF41 (Z254 P66 P314.2 M37 M222  L563 L526 L226 L195 L193 L192.1 L159.2 L130 DF63 DF5 DF49)
WTYNeg: L555 L371 (L9/L10 L370 L302/L319.1 L554 L564 L577 P69 L626 L627 L643 L679)
Mark Jost
Old Hand
****
Offline Offline

Posts: 707


« Reply #2 on: April 11, 2013, 03:57:00 PM »

My TRMCA Variance Estimator V5.1 is up.

Loaded with MikeW's latest R1b-L21 111 and 67 marker Haplotypes with all major subclades included and their zzzunknown haplogroup Hts included. R1b-early xL21 67 marker HTs in Backup tab.

Fixed: Results-Gen111t cells m9 & 10   for CI SD Gen Coal(n-1) to actually sample, changed count of n-1 from n. Added SetGeo and DelGeo and Clear Work Data from sheets for compaction saving size. Standardize Macro button colors. Restore missing CladeB K/N and Mutation Counting routine for CladeB.

http://tinyurl.com/TMRCA-Gen111T-Estimator-L21

MJost
Logged

148326
Pos: Z245 L459 L21 DF13**
Neg: DF23 L513 L96 L144 Z255 Z253 DF21 DF41 (Z254 P66 P314.2 M37 M222  L563 L526 L226 L195 L193 L192.1 L159.2 L130 DF63 DF5 DF49)
WTYNeg: L555 L371 (L9/L10 L370 L302/L319.1 L554 L564 L577 P69 L626 L627 L643 L679)
Mark Jost
Old Hand
****
Offline Offline

Posts: 707


« Reply #3 on: April 24, 2013, 02:12:09 AM »

My TRMCA Estimator V7 is released.
 
Loaded with MikeW's latest 04/19/2013 R1b-L21 111 and 67 marker Haplotypes with all major subclades included and their zzzunknown haplogroup Hts included. R1b-early xL21 67 marker HTs in Backup tab.
 
I implemented a major change which will now allow the user to specify the exact STRs to be entered enhancing the ability to emulate various published studies. Prior, I had to remove unused STRs' mutation rate(s) and other cell data that was used for various functions in calculating a TMRCA. The spreadsheet is automated to use only the STRs entered but if the user will have to select the incremental increasing size panel to cover all STRs. Example, if DYS434 is used, the sheet will need to be "Set to 111 marker" option selected.
 
http://tinyurl.com/TMRCA-Gen111T-Estimator-L21
 
MJost
Logged

148326
Pos: Z245 L459 L21 DF13**
Neg: DF23 L513 L96 L144 Z255 Z253 DF21 DF41 (Z254 P66 P314.2 M37 M222  L563 L526 L226 L195 L193 L192.1 L159.2 L130 DF63 DF5 DF49)
WTYNeg: L555 L371 (L9/L10 L370 L302/L319.1 L554 L564 L577 P69 L626 L627 L643 L679)
Mark Jost
Old Hand
****
Offline Offline

Posts: 707


« Reply #4 on: April 29, 2013, 02:57:11 AM »

TRMCA Estimator V7.2 is released.
 
Loaded with MikeW's latest 04/27/2013 R1b-L21 111 and 67 marker Haplotypes with all major subclades included and their zzzunknown haplogroup Hts included. R1b-early xL21 67 marker HTs in Backup tab.


In V7.1, I re-enable GeoMean feature for 25 markers and left the GeoMean results calculation engine fully setup that is created by the Setup GEO button. It will stay intact unless you run the Clear Wrk or Del GEO Button. The GeoMean require the use of Filtering and 25 marker option. And I update with the L21 haplotypes, removing entire HTs that had single Nuls or replacing it with the modal of the entire Clade for the 21-n922-A1 guys, ect. 
 
In V7,2 I fixed GeoMean when taking the sum of all the STR's squared GeoMean difference results but counted empty Haplotype rows due to a zero entry.
 
http://tinyurl.com/TMRCA-Gen111T-Estimator-L21
 
MJost
Logged

148326
Pos: Z245 L459 L21 DF13**
Neg: DF23 L513 L96 L144 Z255 Z253 DF21 DF41 (Z254 P66 P314.2 M37 M222  L563 L526 L226 L195 L193 L192.1 L159.2 L130 DF63 DF5 DF49)
WTYNeg: L555 L371 (L9/L10 L370 L302/L319.1 L554 L564 L577 P69 L626 L627 L643 L679)
Mark Jost
Old Hand
****
Offline Offline

Posts: 707


« Reply #5 on: May 05, 2013, 03:52:58 PM »

TRMCA Estimator V7.7 is released.
 
Loaded with MikeW's latest 05/05/2013 R1b-L21 111 and 67 marker Haplotypes with all major subclades included and their zzzunknown haplogroup Hts included. R1b-early xL21 67 marker HTs in Backup tab. Fix several items as documented in the notes since V7.2
 
http://tinyurl.com/TMRCA-Gen111T-Estimator-L21
 
MJost
Logged

148326
Pos: Z245 L459 L21 DF13**
Neg: DF23 L513 L96 L144 Z255 Z253 DF21 DF41 (Z254 P66 P314.2 M37 M222  L563 L526 L226 L195 L193 L192.1 L159.2 L130 DF63 DF5 DF49)
WTYNeg: L555 L371 (L9/L10 L370 L302/L319.1 L554 L564 L577 P69 L626 L627 L643 L679)
Webb
Old Hand
****
Offline Offline

Posts: 109


« Reply #6 on: May 06, 2013, 10:27:23 PM »

TRMCA Estimator V7.7 is released.
 
Loaded with MikeW's latest 05/05/2013 R1b-L21 111 and 67 marker Haplotypes with all major subclades included and their zzzunknown haplogroup Hts included. R1b-early xL21 67 marker HTs in Backup tab. Fix several items as documented in the notes since V7.2
 
http://tinyurl.com/TMRCA-Gen111T-Estimator-L21
 
MJost
Mark, I have a favor to ask of you.  I have a 67 marker step 10 match that is outside the FTDNA genealogical time frame, which is 1 to 15 generations.  I suspect I share a common ancestor of this group at around 1300 give or take.  If I post my string and the other string, could you look at them and tell me what you think?
Thanks,
Logged

William B. Webb
P312>DF27>Z220
Mark Jost
Old Hand
****
Offline Offline

Posts: 707


« Reply #7 on: May 07, 2013, 11:29:04 AM »


 Mark, I have a favor to ask of you.  I have a 67 marker step 10 match that is outside the FTDNA genealogical time frame, which is 1 to 15 generations.  I suspect I share a common ancestor of this group at around 1300 give or take.  If I post my string and the other string, could you look at them and tell me what you think?
Thanks,
Yes I can, assuming you both are in the same HG?

MJost
Logged

148326
Pos: Z245 L459 L21 DF13**
Neg: DF23 L513 L96 L144 Z255 Z253 DF21 DF41 (Z254 P66 P314.2 M37 M222  L563 L526 L226 L195 L193 L192.1 L159.2 L130 DF63 DF5 DF49)
WTYNeg: L555 L371 (L9/L10 L370 L302/L319.1 L554 L564 L577 P69 L626 L627 L643 L679)
Webb
Old Hand
****
Offline Offline

Posts: 109


« Reply #8 on: May 07, 2013, 04:30:35 PM »


 Mark, I have a favor to ask of you.  I have a 67 marker step 10 match that is outside the FTDNA genealogical time frame, which is 1 to 15 generations.  I suspect I share a common ancestor of this group at around 1300 give or take.  If I post my string and the other string, could you look at them and tell me what you think?
Thanks,
Yes I can, assuming you both are in the same HG?

MJost

Yes, we are both Z220 and we are 37 step 4 matches and we jump up to a step 10 match at 67 markers.  I will post both strings.  Thanks so much.

Vanderhoof Modal   13   24   14   11   11   14   12   12   12   13   13   30   17   9   10   11   11   25   14   18   29   15   15   17   17   11   10   19   23   15   15   19   17   35   37   12   12   11   9   15   16   8   10   10   8   10   10   12   22   23   16   10   12   12   15   8   12   22   20   13   12   11   13   11   11   12   12


Webb/Wilder   13   24   14   11   11   14   12   12   11   13   13   30   17   9   10   11   11   24   14   18   28   15   15   17   17   11   10   19   23   15   15   19   17   37   39   12   12   11   9   15   16   8   10   10   8   11   10   12   21   23   18   10   12   12   16   8   14   22   20   13   12   11   13   11   11   12   12
« Last Edit: May 07, 2013, 04:31:21 PM by Webb » Logged

William B. Webb
P312>DF27>Z220
Mark Jost
Old Hand
****
Offline Offline

Posts: 707


« Reply #9 on: May 08, 2013, 12:23:34 AM »


 Mark, I have a favor to ask of you.  I have a 67 marker step 10 match that is outside the FTDNA genealogical time frame, which is 1 to 15 generations.  I suspect I share a common ancestor of this group at around 1300 give or take.  If I post my string and the other string, could you look at them and tell me what you think?
Thanks,

Ok, I have checked and realize that there is only two haplotypes, your 30 year per generator IntraClade Coalescence (n-1) Age is:
Bird's q stable STRs at 67 (25 used) (recommened)
MeanGenerations   StdDevInGen   YBP    +OR-YBP
34.3  +-19.0   1,029.5   +-571.1

Using 67(50)Markers No Multicopy Markers
29.2  +-16.2   877.4   +-486.7

Using All 67 markers
31.8  +-13.6   954.6   +-407.1

Average of all three is
(1029.5 + 877.4 + 954.6)/3
= 953.8   +- 488.3

The GD between these two HTs are 14 or 11(MCM IAM).


MJost
Logged

148326
Pos: Z245 L459 L21 DF13**
Neg: DF23 L513 L96 L144 Z255 Z253 DF21 DF41 (Z254 P66 P314.2 M37 M222  L563 L526 L226 L195 L193 L192.1 L159.2 L130 DF63 DF5 DF49)
WTYNeg: L555 L371 (L9/L10 L370 L302/L319.1 L554 L564 L577 P69 L626 L627 L643 L679)
Adrian Ballard
Member
**
Offline Offline

Posts: 42


« Reply #10 on: May 09, 2013, 12:45:49 PM »

Mark

I have a similar problem could you do a newbe a big favour and do the same for me

Just in case you can TIA & posted below


P-310 - R1b1a2a1a1 - 13 24 14 10 11 14 12 12 11 13 13 29 17 9 10 11 11 25 15 19 30 16 16 16 17 10 11 19 23 16 15 18 15 36 37 12 12

P-310 - R1b1a2a1a1 - 13 24 14 10 11 14 12 12 11 13 13 29 17 9 10 11 11 25 15 19 28 16 17 17 17 10 11 19 23 17 15 18 16 36 37 12 12


Best wishes
Adrian

Logged

Mark Jost
Old Hand
****
Offline Offline

Posts: 707


« Reply #11 on: May 09, 2013, 04:56:10 PM »

At 30 year per generator IntraClade Coalescence (n-1) Age is:
(Note I am not a fan of 37 markers and would suggest upgrading to at least 67 markers if you want a much better TMRCA)

Bird's q stable STRs at 37 (14 used) (recommened)
MeanGenerations   StdDevInGen   YBP    +OR-YBP
23.4   +-19.1   700.8   +-572.2
(there is no Bird's q at 25 markers)


Using 37(24) Markers No Multicopy Markers
20.0   +-16.3   598.7   +-488.9
(Using 25 markers: 26.4   +-26.4   793.2   +-793.2)


Using All 37 markers
15.1   +-10.7   453.5   +-320.7
(Using 25 markers: 24.8   +-20.2   743.5   +-607.0)


The 37 marker GD between these two HTs are 6 or 5(MCM IAM).


MJost
Logged

148326
Pos: Z245 L459 L21 DF13**
Neg: DF23 L513 L96 L144 Z255 Z253 DF21 DF41 (Z254 P66 P314.2 M37 M222  L563 L526 L226 L195 L193 L192.1 L159.2 L130 DF63 DF5 DF49)
WTYNeg: L555 L371 (L9/L10 L370 L302/L319.1 L554 L564 L577 P69 L626 L627 L643 L679)
Adrian Ballard
Member
**
Offline Offline

Posts: 42


« Reply #12 on: May 09, 2013, 06:46:49 PM »

Mark your an absolute star !!!

Think I understand all that

Regards Adrian ;-)
« Last Edit: May 09, 2013, 07:03:14 PM by ballardgen » Logged

Mark Jost
Old Hand
****
Offline Offline

Posts: 707


« Reply #13 on: May 09, 2013, 08:05:12 PM »

Gr8. Hope it helps.

MJost
Logged

148326
Pos: Z245 L459 L21 DF13**
Neg: DF23 L513 L96 L144 Z255 Z253 DF21 DF41 (Z254 P66 P314.2 M37 M222  L563 L526 L226 L195 L193 L192.1 L159.2 L130 DF63 DF5 DF49)
WTYNeg: L555 L371 (L9/L10 L370 L302/L319.1 L554 L564 L577 P69 L626 L627 L643 L679)
Webb
Old Hand
****
Offline Offline

Posts: 109


« Reply #14 on: May 10, 2013, 10:43:38 AM »


 Mark, I have a favor to ask of you.  I have a 67 marker step 10 match that is outside the FTDNA genealogical time frame, which is 1 to 15 generations.  I suspect I share a common ancestor of this group at around 1300 give or take.  If I post my string and the other string, could you look at them and tell me what you think?
Thanks,

Ok, I have checked and realize that there is only two haplotypes, your 30 year per generator IntraClade Coalescence (n-1) Age is:
Bird's q stable STRs at 67 (25 used) (recommened)
MeanGenerations   StdDevInGen   YBP    +OR-YBP
34.3  +-19.0   1,029.5   +-571.1

Using 67(50)Markers No Multicopy Markers
29.2  +-16.2   877.4   +-486.7

Using All 67 markers
31.8  +-13.6   954.6   +-407.1

Average of all three is
(1029.5 + 877.4 + 954.6)/3
= 953.8   +- 488.3

The GD between these two HTs are 14 or 11(MCM IAM).


MJost

Thank you for doing that.  I match two families at 37 markers, Wilders and Vanderhoof's.  The Wilders are my closest match as I match them at at 67, but I loose the Vanderhoof's at that point.  This could help answer some of the questions about how and when Z220, a subclade of DF27 entered the isles.  My line could have entered as early as the Viking era through the Flemish migration in 1300, since this distant family match is from the Netherlands.
Logged

William B. Webb
P312>DF27>Z220
Mark Jost
Old Hand
****
Offline Offline

Posts: 707


« Reply #15 on: May 10, 2013, 11:24:05 PM »

What's the old saying? Ignorance is bliss! Now the more SNPs we find it only asks more questions.

MJost
Logged

148326
Pos: Z245 L459 L21 DF13**
Neg: DF23 L513 L96 L144 Z255 Z253 DF21 DF41 (Z254 P66 P314.2 M37 M222  L563 L526 L226 L195 L193 L192.1 L159.2 L130 DF63 DF5 DF49)
WTYNeg: L555 L371 (L9/L10 L370 L302/L319.1 L554 L564 L577 P69 L626 L627 L643 L679)
rocketman
Member
**
Offline Offline

Posts: 12


« Reply #16 on: May 11, 2013, 11:44:07 AM »

Using a computer simulation to estimate the TMRCA for the Vanderhoof/Webb/Wilder 67 marker data yields two possible solutions.  The first solution assumes 10 mutations and 14 GDs.  It yields a time of 971 ybp plus or minus 243 years.  The second solution assumes 12 mutations and 14 GDs.  It yields a time of 1188 ybp plus or minus 310 years.

 Two-step mutations are indicated at Loci 34, 35, 51 and 57.  Loci 34 (CDYa) and 35 (CDYb) have the highest mutation rates of the 67 markers.  Loci 51 (DYS557) and Loci 57 (DYS444) have average mutation rates.  Four two-step mutations in 67 markers for two haplotypes in the given time span is unrealistic. The expected frequency would be one and at the most two two-step mutations. Two of the two-step mutations are at Loci 34 and 35  which are high mutation rate markers.  However, the R1b modals for Loci 34 and 35 are 36 and 38 respectively.  For Loci 34 and 35 the Vanderhoof allele values are 35 and 37 while the Webb/Wilder allele values are 37 and 39 respectively.  This leads to a possible conclusion that there were four one-step mutations rather than two two-step mutations at Loci 34 and 35.  Consequently, the new counts would be 12 mutations and 14 GDs which would lead to the second solution of 1188 ybp.  This is one example of the type of anomalies to be resolved in the analysis of DNA results.

The Ballard 37 marker data with 5 mutations and 6 GDs yields a solution of 614 ybp plus or minus 240 years.
Logged

CED
R-U106**
Webb
Old Hand
****
Offline Offline

Posts: 109


« Reply #17 on: May 11, 2013, 12:45:31 PM »

Using a computer simulation to estimate the TMRCA for the Vanderhoof/Webb/Wilder 67 marker data yields two possible solutions.  The first solution assumes 10 mutations and 14 GDs.  It yields a time of 971 ybp plus or minus 243 years.  The second solution assumes 12 mutations and 14 GDs.  It yields a time of 1188 ybp plus or minus 310 years.

 Two-step mutations are indicated at Loci 34, 35, 51 and 57.  Loci 34 (CDYa) and 35 (CDYb) have the highest mutation rates of the 67 markers.  Loci 51 (DYS557) and Loci 57 (DYS444) have average mutation rates.  Four two-step mutations in 67 markers for two haplotypes in the given time span is unrealistic. The expected frequency would be one and at the most two two-step mutations. Two of the two-step mutations are at Loci 34 and 35  which are high mutation rate markers.  However, the R1b modals for Loci 34 and 35 are 36 and 38 respectively.  For Loci 34 and 35 the Vanderhoof allele values are 35 and 37 while the Webb/Wilder allele values are 37 and 39 respectively.  This leads to a possible conclusion that there were four one-step mutations rather than two two-step mutations at Loci 34 and 35.  Consequently, the new counts would be 12 mutations and 14 GDs which would lead to the second solution of 1188 ybp.  This is one example of the type of anomalies to be resolved in the analysis of DNA results.

The Ballard 37 marker data with 5 mutations and 6 GDs yields a solution of 614 ybp plus or minus 240 years.


That's what piqued my interest.  I matched them at 37 step four but not at 67, yet they share the same snp, Z220.  It gives a chance for a probable wider circle of matches.
Logged

William B. Webb
P312>DF27>Z220
Mark Jost
Old Hand
****
Offline Offline

Posts: 707


« Reply #18 on: May 11, 2013, 02:47:38 PM »

Using a computer simulation to estimate the TMRCA for the Vanderhoof/Webb/Wilder 67 marker data yields two possible solutions.  The first solution assumes 10 mutations and 14 GDs.  It yields a time of 971 ybp plus or minus 243 years.  The second solution assumes 12 mutations and 14 GDs.  It yields a time of 1188 ybp plus or minus 310 years.

 Two-step mutations are indicated at Loci 34, 35, 51 and 57.  Loci 34 (CDYa) and 35 (CDYb) have the highest mutation rates of the 67 markers.  Loci 51 (DYS557) and Loci 57 (DYS444) have average mutation rates.  Four two-step mutations in 67 markers for two haplotypes in the given time span is unrealistic. The expected frequency would be one and at the most two two-step mutations. Two of the two-step mutations are at Loci 34 and 35  which are high mutation rate markers.  However, the R1b modals for Loci 34 and 35 are 36 and 38 respectively.  For Loci 34 and 35 the Vanderhoof allele values are 35 and 37 while the Webb/Wilder allele values are 37 and 39 respectively.  This leads to a possible conclusion that there were four one-step mutations rather than two two-step mutations at Loci 34 and 35.  Consequently, the new counts would be 12 mutations and 14 GDs which would lead to the second solution of 1188 ybp.  This is one example of the type of anomalies to be resolved in the analysis of DNA results.

The Ballard 37 marker data with 5 mutations and 6 GDs yields a solution of 614 ybp plus or minus 240 years.


Nice analysis. I don't assume to know your computer Sim. mythology though. My other simple method using my birth event factor I calculated using MarkoH's average mutation rate for 67 markers with simple GD count of 14 equals 1,218 ybp approximately. This is larger than just using all 67 markers that produced:  Gen: 31.8  +-13.6   YBP: 954.6    +-407.1  which I posted earlier. So I prefer to use specific each STR mutation rate and variance, and taking the total sum to calculate a generation number.

MJost
Logged

148326
Pos: Z245 L459 L21 DF13**
Neg: DF23 L513 L96 L144 Z255 Z253 DF21 DF41 (Z254 P66 P314.2 M37 M222  L563 L526 L226 L195 L193 L192.1 L159.2 L130 DF63 DF5 DF49)
WTYNeg: L555 L371 (L9/L10 L370 L302/L319.1 L554 L564 L577 P69 L626 L627 L643 L679)
Adrian Ballard
Member
**
Offline Offline

Posts: 42


« Reply #19 on: May 19, 2013, 02:44:31 PM »

Hi Mark

Its me again on the scrounge - The last comparison you did for me will be very useful when the donor replies to my mails !

Anyway I think I am on the way to firming up the people of P-310 - if you could compare these 2 for me that would help in this quest
has I have discovered a paper trail between these families.

Ballard - P-310 -    R1b1a2a1a1 - 13 24 14 10 11 14 12 12 11 13 13 29 17 9 10 11 11 25 15 19 30 16 16 16 17 10 11 19 23 16 15 18 15 36 37 12 12
St.Clair- P-310 -    R1b1a2a1a1 - 13 24 14 10 11-16 12 12 13 13 14 29 17 9 10 11 11 25 15 19 29 14 15 16 16 10 11 19 23 17 15 19 17 36 37 12 12

TIA hope you don't mind me asking it could be very useful to everyone.

Adrian.
Logged

Mark Jost
Old Hand
****
Offline Offline

Posts: 707


« Reply #20 on: June 12, 2013, 10:31:32 AM »

TRMCA Estimator V7.9 is released.

Loaded with MikeW's latest 06/09/2013 R1b-L21 111 and 67 marker Haplotypes with all major subclades included and their zzzunknown haplogroup Hts included. R1b-early xL21 67 marker HTs in Backup tab. Fix several items as documented in the Results-TMRCA worksheet notes.

The data can be easily Cleared and any other haplotypes can be used, but for interclade work, place the ancestral clade HTs in Clade B work sheet.

 http://tinyurl.com/TMRCA-Gen111T-Estimator-L21

 MJost
Logged

148326
Pos: Z245 L459 L21 DF13**
Neg: DF23 L513 L96 L144 Z255 Z253 DF21 DF41 (Z254 P66 P314.2 M37 M222  L563 L526 L226 L195 L193 L192.1 L159.2 L130 DF63 DF5 DF49)
WTYNeg: L555 L371 (L9/L10 L370 L302/L319.1 L554 L564 L577 P69 L626 L627 L643 L679)
Mark Jost
Old Hand
****
Offline Offline

Posts: 707


« Reply #21 on: July 01, 2013, 01:32:52 AM »

TRMCA Estimator V8.1 is released.
 

This url is no long valid>> http://tinyurl.com/TMRCA-Gen111T-Estimator-L21

Use the replacement below.
 
http://tinyurl.com/TMRCA-Estimator

Loaded with MikeW's latest 06/22/2013 R1b-L21 111 and 67 marker Haplotypes with all major subclades included and their zzzunknown haplogroup Hts included. R1b-early xL21 67 marker HTs in Backup tab. Fix several items as documented in the Results-TMRCA worksheet notes.
 
The data can be easily Cleared and any other haplotypes can be used, but for interclade work, place the ancestral clade HTs in Clade B work sheet.
 
Added Anatole Klyosov's method of comparing both Linear and logarithmic Audit for one common ancestor using 25 or less STR panel haplotypes that have at least four base ancestral modals.
 
MJost
Logged

148326
Pos: Z245 L459 L21 DF13**
Neg: DF23 L513 L96 L144 Z255 Z253 DF21 DF41 (Z254 P66 P314.2 M37 M222  L563 L526 L226 L195 L193 L192.1 L159.2 L130 DF63 DF5 DF49)
WTYNeg: L555 L371 (L9/L10 L370 L302/L319.1 L554 L564 L577 P69 L626 L627 L643 L679)
Mark Jost
Old Hand
****
Offline Offline

Posts: 707


« Reply #22 on: July 25, 2013, 10:39:24 PM »

Uploaded my v8.2 TRMCA Estimator spreadsheet with MikeW's July 25th  L21 Haplotypes, 67 markers in CladeA and 111Markers in CladeB. MikeW just recategorized the CTS4466's today (n=481 including Suspects) and I have them loaded in my TRMCA Estimator today.

http://tinyurl.com/TMRCA-Estimator

I added a STR allele value alert when their are any Haplotypes have any STR with allele values GD greater than plus or minus TWO  from the Filtered modal. Look at TMRCA- Results row 38 and 39 for a '1' or more shown under each STR for each Clade. I got bit by a DYS 446 that out of 20 haplotypes, 19 had 23 and one had an 18 causing the number of generation to almost triple when using the smaller 25 marker panel size. As one would increase to 37, 67 or 111 that STR variance smoothed out to a smaller and smaller number of generations. Now its a standard tool that should be used as I have not implement a Infinite Allele Mutation Model option for any other STRs except Multi-copy Markers via Ken N's formula in the spread sheet.

Also resolved the issue by running a Macro when one wishes to edit any cells in columns A thru G that previously may have been set to validate mode after having copied cells pasted into my sheets. (MikeW you might want that macro code for you own Haplotype Spreadsheet as it has the same issue.)


MJost
« Last Edit: July 25, 2013, 10:44:52 PM by Mark Jost » Logged

148326
Pos: Z245 L459 L21 DF13**
Neg: DF23 L513 L96 L144 Z255 Z253 DF21 DF41 (Z254 P66 P314.2 M37 M222  L563 L526 L226 L195 L193 L192.1 L159.2 L130 DF63 DF5 DF49)
WTYNeg: L555 L371 (L9/L10 L370 L302/L319.1 L554 L564 L577 P69 L626 L627 L643 L679)
Mark Jost
Old Hand
****
Offline Offline

Posts: 707


« Reply #23 on: August 08, 2013, 10:35:26 PM »

Added a macro in V8.5 to import MikeW's P312xL21 haplotypes. I ended up removing all the suspects to be able to combine the 67 lists and had plenty of rows for the 111 but again I only keep those HTs with Positive P312 or better Results. I ended up with a little over 1,900 111 marker HTs and 5,535 with the 67 length. I also removed Ysearch HTs. I left out the L21 duplicate HTs but did not check P312's list as it didnt seem to affect the the entire picture much.


http://tinyurl.com/TMRCA-Estimator



MJost

Logged

148326
Pos: Z245 L459 L21 DF13**
Neg: DF23 L513 L96 L144 Z255 Z253 DF21 DF41 (Z254 P66 P314.2 M37 M222  L563 L526 L226 L195 L193 L192.1 L159.2 L130 DF63 DF5 DF49)
WTYNeg: L555 L371 (L9/L10 L370 L302/L319.1 L554 L564 L577 P69 L626 L627 L643 L679)
Mark Jost
Old Hand
****
Offline Offline

Posts: 707


« Reply #24 on: October 27, 2013, 05:59:55 PM »

TMRCA_Estimator Loaded with the latest MIkeW's L21 with subclades 67 and 111 Markers Ver8.7d MJost 10/26/2013
 

http://tinyurl.com/TMRCA-Estimator
 


MJost
Logged

148326
Pos: Z245 L459 L21 DF13**
Neg: DF23 L513 L96 L144 Z255 Z253 DF21 DF41 (Z254 P66 P314.2 M37 M222  L563 L526 L226 L195 L193 L192.1 L159.2 L130 DF63 DF5 DF49)
WTYNeg: L555 L371 (L9/L10 L370 L302/L319.1 L554 L564 L577 P69 L626 L627 L643 L679)
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.138 seconds with 17 queries.