ASD Peter Gwozdz Click sheet "ASD Doc" for instructions In this TRANSPOSE array, the "Years" are figured with ASD, copied from row 7, treating compound markers as individuals
Column A is input data But the "Mutations" are figured using "Infinite Alleles",  copied from row 42;  for compound markers the mutations are totaled in the "a" marker only
25 < Years per generation;  may be changed DYS 393 390 19 391 385a 385b 426 388 439 389-1 392 389-2 458 459a 459b 455 454 447 437 448 449 464a 464b 464c 464d 460 GATA YCa YCb 456 607 576 570 CDa CDb 442 438 531 578 395a 395b 590 537 641 472 406 511 425 413a 413b 557 594 436 490 534 450 444 481 520 446 617 568 487 572 640 492 565 DYS Copy this array over to the right;  use Paste, Special, Values The copy over here can be sorted by Rank
ASD 0,05444 0,30667 0,27025 0,04395 0,01099 0,99506 0,02173 0,00000 0,22333 0,12889 0,01099 0,22025 0,44210 0,07469 0,08099 0,00000 0,01099 0,06617 0,01099 0,08840 0,98778 0,64556 0,83321 0,23951 0,17728 0,08840 0,08889 0,01099 0,06617 0,37284 0,73840 0,85000 0,53099 1,13444 2,37580 0,55506 0,01099 0,04444 0,02222 0,06469 0,01099 0,01099 0,17889 0,00000 0,00000 0,14136 0,10667 0,00000 0,29988 0,06469 0,24210 0,00000 0,00000 0,01099 0,28840 0,00000 0,46469 0,37728 0,17580 0,06222 0,01099 0,03222 0,08444 0,24988 0,00000 0,01099 0,22667 ASD Do not sort this "TRANSPOSE" array Sort by Sequence to get back to standard order
Mutation Rates >>> Chandler Mutation Rates 0,00076 0,00311 0,00151 0,00265 0,00226 0,00226 0,00009 0,00022 0,00477 0,00186 0,00052 0,00242 0,00814 0,00132 0,00132 0,00016 0,00016 0,00264 0,00099 0,00135 0,00838 0,00566 0,00566 0,00566 0,00566 0,00402 0,00208 0,00123 0,00123 0,00735 0,00411 0,01022 0,00790 0,03531 0,03531 0,00324 0,00055 0,00037 0,00008 0,00031 0,00031 0,00054 0,00057 0,00018 0,00001 0,00154 0,00128 0,00018 0,00202 0,00202 0,00321 0,00029 0,00018 0,00019 0,00832 0,00020 0,00321 0,00544 0,00245 0,00365 0,00042 0,00053 0,00097 0,00212 0,00034 0,00042 0,00087 Chandler Mutation Rates Rank DYS Sequence Mutations Years Rank DYS Sequence Mutations Years Mask Sub Notes
Age in generations = ASD divided by rate 72 99 179 17 5 440 241 0 47 69 21 91 54 57 61 0 69 25 11 65 118 114 147 42 31 22 43 9 54 51 180 83 67 32 67 171 20 120 278 209 35 20 314 0 0 92 83 0 148 32 75 0 0 58 35 0 145 69 72 17 26 61 87 118 0 26 261 Age in generations = ASD divided by rate 25 393 1 2 1 791 1 385b 6 0 11 007 Yes Px 5 samples have recLOH from 14 to 10
Years 1 791 2 465 4 474 415 122 11 007 6 036 0 1 171 1 732 528 2 275 1 358 1 415 1 534 0 1 717 627 277 1 637 2 947 2 851 3 680 1 058 783 550 1 068 223 1 345 1 268 4 491 2 079 1 680 803 1 682 4 283 499 3 003 6 944 5 217 886 509 7 846 0 0 2 295 2 083 0 3 711 801 1 886 0 0 1 446 867 0 3 619 1 734 1 794 426 654 1 520 2 176 2 947 0 654 6 513 Years 17 390 2 16 2 465 2 537 43 11 7 846 Ps 23rd rank in Chandler;  9 samples have 11
Averages by various sets of markers: Average of first 12 markers Average of first 25 markers Average of first 37 markers Average of all 67 markers 8 19 3 29 4 474 3 578 39 2 6 944  - Only 2 mutations (one 7 and one 9) out of 90 samples in this 2nd slowest mutating marker provides a very old age estimate
Average ASD;  all 67 markers 0,23804 0,19055 0,23777 0,34506 0,23804 Average ASD 55 391 4 4 415 4 565 67 22 6 513 Pt 17 mutations to 12;  correlates with either Pa or Pc but not both
Chandler Mutation Rates Average 0,00335 0,00187 0,00278 0,00492 0,00335 Chandler Mutation Rates Average 58 385a 5 12 122 5 426 7 2 6 036  - Only 2 mutations (both to 11) out of 90 samples in this 3rd slowest mutating marker provides a very old age estimate
Age in generations = ASD divided by rate 71 102 Generations 85 70 71 Age in generations = ASD divided by rate 1 385b 6 0 11 007 6 395a 40 4 5 217  - Only 4 mutations (two 16 and a double 15) out of 90 samples in this 13rd slowest mutating marker provides an old age estimate
Age in years 1 778 2 549 2 137 1 753 1 778 Years 5 426 7 2 6 036 7 607 31 47 4 491 Pr Bimodal 16 vs 17
Thomas: 1 2 3 4 5 Average of markers 13-25 Average of markers 26-37 Average of markers 38-67 59 388 8 0 0 8 19 3 29 4 474 Pb 16 is ancestral to 17
Average ASD with the 5 Thomas markers 0,13726 (Compare to Thomas average = 0.2226) 0,28136 0,56858 0,10605 Average ASD 39 439 9 19 1 171 9 442 36 38 4 283 Pf, Pw 13 modal;  12 and 14 about equal in number
Thomas Rate 0,00210 0,00362 0,00938 0,00141 Chandler Mutation Rates Average 27 389-1 10 12 1 732 10 413a 49 16 3 711 16 mutations total 413 a & b;  7 are 413a=21
Age in generations = ASD divided by rate 65 78 61 75 Age in generations = ASD divided by rate 51 392 11 1 528 11 464b 23 0 3 680 Yes recLOH;  see 464a;  age from variance at this one marker
Age in years 1 634 (Compare to Thomas 2,650) 1 941 1 516 1 884 Years 19 389-2 12 22 2 275 12 444 57 30 3 619
Mask: 36 458 13 43 1 358 13 531 38 4 3 003
Masks are explained in the Documentation Compound Markers;  Infinite Alleles 35 459a 14 15 1 415 14 449 21 47 2 947
To specify which markers to use for ASD: Modal 0 = Not mutated;  1 - Mutated 32 459b 15 0 1 534 15 572 64 27 2 947
Mask >>> Type or copy a mask into this row >> 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 Count 78 75 53 83 17 86 74 59 455 16 0 0 16 464a 22 37 2 851 Yes Includes recLOH;  all 464 mutations are counted here although age is figured using only variance at 464a here
Count 1 1 1 1 1 - 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 - - - - 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 385 459 464 YC CD 395 413 28 454 17 1 1 717 17 390 2 16 2 465
Number of Markers 62 0 0 0 0 1 0 0 49 447 18 6 627 18 406 46 10 2 295
ASD 0,05444 0,30667 0,27025 0,04395 0,01099 0,02173 0 0,22333 0,12889 0,01099 0,22025 0,4421 0,07469 0,08099 0 0,01099 0,06617 0,01099 0,0884 0,98778 0,0884 0,08889 0,01099 0,06617 0,37284 0,7384 0,85 0,53099 1,13444 2,3758 0,55506 0,01099 0,04444 0,02222 0,06469 0,01099 0,01099 0,17889 0 0 0,14136 0,10667 0 0,29988 0,06469 0,2421 0 0 0,01099 0,2884 0 0,46469 0,37728 0,1758 0,06222 0,01099 0,03222 0,08444 0,24988 0 0,01099 0,22667 0 0 0 0 0 0 0 56 437 19 1 277 19 389-2 12 22 2 275 Pa This is variance of the delta
Rate 0,00076 0,00311 0,00151 0,00265 0,00226 0,00009 0,00022 0,00477 0,00186 0,00052 0,00242 0,00814 0,00132 0,00132 0,00016 0,00016 0,00264 0,00099 0,00135 0,00838 0,00402 0,00208 0,00123 0,00123 0,00735 0,00411 0,01022 0,0079 0,03531 0,03531 0,00324 0,00055 0,00037 0,00008 0,00031 0,00031 0,00054 0,00057 0,00018 0,00001 0,00154 0,00128 0,00018 0,00202 0,00202 0,00321 0,00029 0,00018 0,00019 0,00832 0,0002 0,00321 0,00544 0,00245 0,00365 0,00042 0,00053 0,00097 0,00212 0,00034 0,00042 0,00087 0 0 1 0 1 0 0 31 448 20 8 1 637 20 487 63 8 2 176
Average ASD;  selected markers 0,21061 0 0 1 0 1 0 0 14 449 21 47 2 947 21 511 47 10 2 083
Average rate 0,00322 0 0 0 0 1 0 0 16 464a 22 37 2 851 22 576 32 46 2 079
Generations 65 1 0 0 0 1 0 0 11 464b 23 0 3 680 23 557 51 22 1 886
Years 1 637 0 0 1 0 0 0 0 41 464c 24 0 1 058 24 520 59 10 1 794
0 0 0 0 1 0 0 46 464d 25 0 783 25 393 1 2 1 791
Mask Tool: Be sure to use "Paste Special, Values" when copying a mask to another location 0 0 0 0 0 0 1 50 460 26 8 550 26 481 58 28 1 734
5 000 < Set the limit for the number of years in the mask 0 0 1 0 0 0 0 40 GATA 27 8 1 068 27 389-1 10 12 1 732
Years Limit 1 0 0 0 1 0 1 57 YCa 28 7 223 28 454 17 1 1 717
Rank;  oldest = 1, 2, 3 … 25 17 8 55 58 1 5 59 39 27 51 19 36 35 32 59 28 49 56 31 14 16 11 41 46 50 40 57 37 38 7 22 30 44 29 9 53 13 3 6 42 52 2 59 59 18 21 59 10 45 23 59 59 34 43 59 12 26 24 54 47 33 20 15 59 47 4 0 0 0 0 1 0 0 37 YCb 29 0 1 345 29 CDb 35 0 1 682 see a
Highlight > Limit - - - - - 11 007 6 036 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 6 944 5 217 - - 7 846 - - - - - - - - - - - - - - - - - - - - - - - 6 513 0 0 1 0 1 0 0 38 456 30 35 1 268 30 570 33 36 1 680
Mask for all markers below the "Years Limit" 4 4 4 4 4 0 0 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 0 0 4 4 0 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 0 0 0 1 0 1 0 0 7 607 31 47 4 491 31 448 20 8 1 637
0 0 1 0 1 0 0 22 576 32 46 2 079 32 459b 15 0 1 534
DYS 393 390 19 391 385a 385b 426 388 439 389-1 392 389-2 458 459a 459b 455 454 447 437 448 449 464a 464b 464c 464d 460 GATA YCa YCb 456 607 576 570 CDa CDb 442 438 531 578 395a 395b 590 537 641 472 406 511 425 413a 413b 557 594 436 490 534 450 444 481 520 446 617 568 487 572 640 492 565 DYS 0 0 1 0 1 0 0 30 570 33 36 1 680 33 568 62 3 1 520
Infinite Alleles: 0 1 0 0 1 0 0 44 CDa 34 73 803 34 490 54 1 1 446
10% < Limit for Fraction Mutated Set the limit in the red cell to the left  for the percent of samples mutated (not the modal value) 0 0 0 0 1 0 0 29 CDb 35 0 1 682 35 459a 14 15 1 415
Number of Samples 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 0 0 0 1 1 0 0 9 442 36 38 4 283 36 458 13 43 1 358
Number Mutated (not modal value) 2 16 29 4 12 2 0 19 12 1 22 43 15 0 1 6 1 8 47 37 8 8 7 35 47 46 36 73 38 1 4 2 4 1 11 0 0 10 10 0 16 22 0 0 1 36 0 30 28 10 6 1 3 8 27 0 1 22 0 0 0 0 1 0 0 53 438 37 1 499 37 YCb 29 0 1 345 see a
Fraction Mutated 0,02222 0,17778 0,32222 0,04444 0,01111 0,02222 0,00000 0,21111 0,13333 0,01111 0,24444 0,47778 0,07778 0,00000 0,01111 0,06667 0,01111 0,08889 0,52222 0,11111 0,08889 0,08889 0,01111 0,38889 0,52222 0,51111 0,40000 0,53333 0,42222 0,01111 0,04444 0,02222 0,03333 0,01111 0,12222 0,00000 0,00000 0,11111 0,11111 0,00000 0,14444 0,24444 0,00000 0,00000 0,01111 0,40000 0,00000 0,33333 0,31111 0,11111 0,06667 0,01111 0,03333 0,08889 0,30000 0,00000 0,01111 0,24444 0 0 0 0 1 0 1 13 531 38 4 3 003 38 456 30 35 1 268
Generations 29 57 213 17 2 247 0 44 72 21 101 59 29 0 69 25 11 66 62 5 22 43 5 53 127 50 51 8 130 20 120 278 54 21 214 0 0 72 87 0 36 76 0 0 58 48 0 104 57 45 18 26 63 92 142 0 26 281 0 0 0 0 1 0 0 3 578 39 2 6 944 39 439 9 19 1 171
Years 731 1429 5335 419 61 6173 0 1106 1792 534 2525 1467 737 0 1736 631 281 1646 1558 123 553 1068 113 1323 3177 1250 1266 189 3258 505 3003 6944 1344 514 5361 0 0 1804 2170 0 894 1904 0 0 1462 1202 0 2596 1430 1134 457 661 1572 2291 3538 0 661 7024 0 0 1 0 1 0 0 6 395a 40 4 5 217 40 GATA 27 8 1 068
Infinite Alleles / ASD 0,41 0,58 1,19 1,01 0,51 1,02 1,00 0,95 1,03 1,01 1,11 1,08 0,52 1,00 1,01 1,01 1,01 1,01 0,53 0,04 1,01 1,00 0,51 1,04 0,71 0,60 0,75 0,24 0,76 1,01 1,00 1,00 0,26 1,01 0,68 1,00 1,00 0,79 1,04 1,00 0,24 1,01 1,00 1,00 1,01 1,39 1,00 0,72 0,82 0,63 1,07 1,01 1,03 1,05 1,20 1,00 1,01 1,08 0 1 0 0 1 0 1 42 395b 41 0 886 41 464c 24 0 1 058 Yes
Markers Less Than Limit 1 - - 1 1 1 1 - - 1 - - 1 1 1 1 1 1 - - 1 1 1 - - - - - - 1 1 1 1 1 - 1 1 - - 1 - - 1 1 1 - 1 - - - 1 1 1 1 - 1 1 - 1 0 0 0 1 0 1 52 590 42 1 509 42 395b 41 0 886
Mask >>> Enter 1 to Exclude a Marker 1 0 0 0 1 0 0 2 537 43 11 7 846 43 534 55 36 867
Mask >>> Enter 1 to Add a Marker 0 0 1 0 1 0 0 59 641 44 0 0 44 CDa 34 73 803
Net Mask 1 0 0 1 1 1 1 0 0 1 0 0 1 1 1 1 1 1 0 0 1 1 1 0 0 0 0 0 0 1 1 1 1 1 0 1 1 0 0 1 0 0 1 1 1 0 1 0 0 0 1 1 1 1 0 1 1 0 0 0 1 0 1 0 0 59 472 45 0 0 45 413b 50 0 801 see a
Mutations 2 0 0 4 12 2 0 0 0 1 0 0 15 0 1 6 1 8 0 0 8 8 7 0 0 0 0 0 0 1 4 2 4 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 6 1 3 8 0 0 1 0 0 0 0 0 1 0 0 18 406 46 10 2 295 46 464d 25 0 783 Yes see a
Total Mutations (values not modal) 107 0 0 0 0 1 0 0 21 511 47 10 2 083 47 617 61 1 654
Number of Markers 33 0 0 1 0 1 0 0 59 425 48 0 0 47 492 66 1 654
Fraction 0,02222 0,00000 0,00000 0,04444 0,02222 0,02222 0,00000 0,00000 0,00000 0,01111 0,00000 0,00000 0,15556 0,00000 0,01111 0,06667 0,01111 0,08889 0,00000 0,00000 0,08889 0,08889 0,02222 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,01111 0,04444 0,02222 0,06667 0,01111 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,01111 0,00000 0,00000 0,00000 0,00000 0,00000 0,06667 0,01111 0,03333 0,08889 0,00000 0,00000 0,01111 0,00000 0 0 1 0 1 0 0 10 413a 49 16 3 711 49 447 18 6 627
Average Fraction 0,03131 0 0 1 0 1 0 1 45 413b 50 0 801 50 460 26 8 550
Rate 0,00076 0,00000 0,00000 0,00265 0,00226 0,00009 0,00022 0,00000 0,00000 0,00052 0,00000 0,00000 0,00132 0,00016 0,00016 0,00264 0,00099 0,00135 0,00000 0,00000 0,00402 0,00208 0,00123 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00055 0,00037 0,00008 0,00031 0,00054 0,00000 0,00018 0,00001 0,00000 0,00000 0,00018 0,00000 0,00000 0,00029 0,00018 0,00019 0,00000 0,00020 0,00000 0,00000 0,00000 0,00365 0,00042 0,00053 0,00097 0,00000 0,00034 0,00042 0,00000 0 0 0 0 0 0 0 23 557 51 22 1 886 51 392 11 1 528
Average Rate 0,0009 0 0 0 0 1 0 0 59 594 52 0 0 52 590 42 1 509
Generations 35 0 0 1 0 0 0 0 59 436 53 0 0 53 438 37 1 499
Years 865 0 0 1 0 1 0 0 34 490 54 1 1 446 54 446 60 6 426
0 0 0 1 1 0 0 43 534 55 36 867 55 391 4 4 415
0 0 0 0 0 0 0 59 450 56 0 0 56 437 19 1 277
0 0 0 0 0 0 0 12 444 57 30 3 619 57 YCa 28 7 223
0 1 0 0 1 0 1 26 481 58 28 1 734 58 385a 5 12 122
0 0 0 1 1 0 0 24 520 59 10 1 794 59 388 8 0 0
0 0 1 0 1 0 1 54 446 60 6 426 59 455 16 0 0
1 1 0 0 0 0 0 47 617 61 1 654 59 641 44 0 0
0 0 1 0 0 0 1 33 568 62 3 1 520 59 472 45 0 0
1 0 1 0 1 0 0 20 487 63 8 2 176 59 425 48 0 0
0 0 0 0 1 0 0 15 572 64 27 2 947 59 594 52 0 0
0 0 0 0 0 0 1 59 640 65 0 0 59 436 53 0 0
0 0 0 0 1 0 0 47 492 66 1 654 59 450 56 0 0
0 0 0 0 1 0 0 4 565 67 22 6 513 59 640 65 0 0
0 0 0 0 1 1 0
0 1 1 0 0 0 0
0 0 0 1 1 0 0
0 0 0 0 1 0 0
0 0 0 0 1 0 0
0 1 0 0 1 0 0
1 0 0 0 1 1 0
0 0 0 0 1 0 0
0 0 1 0 0 0 0
0 0 0 1 1 0 0
0 0 0 1 1 0 0
0 0 0 0 1 0 0
0 0 1 0 0 0 0
1 0 0 0 1 0 0
1 0 1 0 1 0 0
0 1 0 0 1 0 0
0 0 0 0 1 0 0
0 1 1 0 1 1 0
0 1 0 0 1 0 0
0 0 0 0 1 0 1
0 0 0 0 1 0 0
0 0 0 0 1 0 1
1 1 1 0 1 0 0
1 1 1 0 1 0 1
0 0 1 0 1 0 0
0 1 1 0 1 0 0
0 0 0 0 1 0 0
0 0 1 0 1 0 0
0 0 0 0 1 0 0
0 0 1 0 1 0 0
0 0 1 0 1 0 0
0 0 1 0 1 0 0
0 1 1 0 1 0 0
1 0 0 0 1 0 0
0 0 1 0 1 1 1
0 0 0 1 0 0 1
0 1 1 0 1 0 0
0 0 0 0 0 0 1
0 1 1 0 0 0 0
0 0 1 0 1 0 0