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,00000 0,22222 0,13889 0,13889 0,00000 0,00000 0,00000 0,13889 0,00000 0,00000 0,00000 0,00000 0,22222 0,00000 0,33333 0,00000 0,00000 0,13889 0,00000 0,00000 0,13889 0,00000 0,22222 0,00000 0,00000 0,13889 0,25000 0,00000 0,00000 0,13889 0,00000 0,00000 0,47222 0,33333 0,55556 0,66667 0,00000 0,00000 0,00000 0,13889 0,00000 0,00000 0,13889 0,00000 0,00000 0,13889 0,00000 0,00000 0,33333 0,00000 0,00000 0,00000 0,00000 0,00000 0,13889 0,00000 0,13889 0,25000 0,13889 0,13889 0,00000 0,13889 0,55556 0,00000 0,00000 0,00000 0,00000 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 Notes
Age in generations = ASD divided by rate 0 71 92 52 0 0 0 631 0 0 0 0 27 0 253 0 0 53 0 0 17 0 39 0 0 35 120 0 0 19 0 0 60 9 16 206 0 0 0 448 0 0 244 0 0 90 0 0 165 0 0 0 0 0 17 0 43 46 57 38 0 262 573 0 0 0 0 Age in generations = ASD divided by rate 28 393 1 0 0 1 388 8 1 15 783 M One mutation out of 6 samples in this slow mutating marker provides a very old age estimate
Years 0 1 786 2 299 1 310 0 0 0 15 783 0 0 0 0 683 0 6 313 0 0 1 315 0 0 414 0 982 0 0 864 3 005 0 0 472 0 0 1 494 236 393 5 144 0 0 0 11 201 0 0 6 092 0 0 2 255 0 0 4 125 0 0 0 0 0 417 0 1 082 1 149 1 417 951 0 6 551 14 318 0 0 0 0 Years 12 390 2 2 1 786 2 487 63 1 14 318 M One mutation out of 6 samples in this slow mutating marker provides a very old age estimate
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 10 19 3 1 2 299 3 395a 40 1 11 201 M One mutation out of 6 samples in this slow mutating marker provides a very old age estimate
Average ASD;  all 67 markers 0,09701 0,05324 0,06778 0,11486 0,09701 Average ASD 16 391 4 1 1 310 4 568 62 1 6 551 One mutation out of 6 samples in this slow mutating marker provides a very old age estimate
Chandler Mutation Rates Average 0,00335 0,00187 0,00278 0,00492 0,00335 Chandler Mutation Rates Average 28 385a 5 0 0 5 459b 15 0 6 313 M Mutations are counted at 459a, but age is indepedently calculated here
Age in generations = ASD divided by rate 29 28 Generations 24 23 29 Age in generations = ASD divided by rate 28 385b 6 0 0 6 537 43 1 6 092
Age in years 724 712 609 584 724 Years 28 426 7 0 0 7 442 36 4 5 144
Thomas: 1 2 3 4 5 Average of markers 13-25 Average of markers 26-37 Average of markers 38-67 1 388 8 1 15 783 8 413a 49 2 4 125
Average ASD with the 5 Thomas markers 0,1 (Compare to Thomas average = 0.2226) 0,08120 0,21296 0,07500 Average ASD 28 439 9 0 0 9 GATA 27 3 3 005
Thomas Rate 0,00210 0,00362 0,00938 0,00141 Chandler Mutation Rates Average 28 389-1 10 0 0 10 19 3 1 2 299
Age in generations = ASD divided by rate 48 22 23 53 Age in generations = ASD divided by rate 28 392 11 0 0 11 406 46 1 2 255
Age in years 1 190 (Compare to Thomas 2,650) 560 568 1 332 Years 28 389-2 12 0 0 12 390 2 2 1 786
Mask: 22 458 13 2 683 13 570 33 3 1 494
Masks are explained in the Documentation Compound Markers;  Infinite Alleles 28 459a 14 2 0 14 520 59 1 1 417 M
To specify which markers to use for ASD: Modal 0 = Not mutated;  1 - Mutated 5 459b 15 0 6 313 15 447 18 1 1 315
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 Count 6 4 4 6 2 5 4 28 455 16 0 0 16 391 4 1 1 310
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 385 459 464 YC CD 395 413 28 454 17 0 0 17 481 58 3 1 149
Number of Markers 59 0 0 0 0 0 0 0 15 447 18 1 1 315 18 444 57 1 1 082
ASD 0 0,22222 0,13889 0,13889 0 0,13889 0 0 0 0 0,22222 0 0,33333 0 0 0,13889 0 0 0,13889 0,13889 0,25 0 0 0,13889 0 0 0,47222 0,66667 0 0 0 0,13889 0 0 0,13889 0 0 0,13889 0 0 0,33333 0 0 0 0 0 0,13889 0 0,13889 0,25 0,13889 0,13889 0 0,13889 0,55556 0 0 0 0 0 1 1 0 1 1 0 28 437 19 0 0 19 464b 23 0 982
Rate 0,00076 0,00311 0,00151 0,00265 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,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 0 0 0 0 0 28 448 20 0 0 20 446 60 1 951
Average ASD;  selected markers 0,09134 0 1 1 0 1 0 0 25 449 21 1 414 21 460 26 1 864
Average rate 0,00214 0 0 0 0 1 0 1 28 464a 22 2 0 22 458 13 2 683
Generations 43 0 0 0 0 1 0 1 19 464b 23 0 982 23 456 30 1 472
Years 1 065 28 464c 24 0 0 24 534 55 1 417
28 464d 25 0 0 25 449 21 1 414
Mask Tool: Be sure to use "Paste Special, Values" when copying a mask to another location 21 460 26 1 864 26 CDb 35 0 393 M
5 000 < Set the limit for the number of years in the mask 9 GATA 27 3 3 005 27 CDa 34 4 236 M
Years Limit 28 YCa 28 0 0 28 393 1 0 0
Rank;  oldest = 1, 2, 3 … 28 12 10 16 28 28 28 1 28 28 28 28 22 28 5 28 28 15 28 28 25 28 19 28 28 21 9 28 28 23 28 28 13 27 26 7 28 28 28 3 28 28 6 28 28 11 28 28 8 28 28 28 28 28 24 28 18 17 14 20 28 4 2 28 28 28 28 28 YCb 29 0 0 28 385a 5 0 0
Highlight > Limit - - - - - - - 15 783 - - - - - - 6 313 - - - - - - - - - - - - - - - - - - - - 5 144 - - - 11 201 - - 6 092 - - - - - - - - - - - - - - - - - - 6 551 14 318 - - - - 23 456 30 1 472 28 385b 6 0 0
Mask for all markers below the "Years Limit" 4 4 4 4 4 4 4 0 4 4 4 4 4 4 0 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 0 4 4 4 0 4 4 0 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 0 0 4 4 4 4 28 607 31 0 0 28 426 7 0 0
28 576 32 0 0 28 439 9 0 0
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 13 570 33 3 1 494 28 389-1 10 0 0
Infinite Alleles: 27 CDa 34 4 236 28 392 11 0 0
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) 26 CDb 35 0 393 28 389-2 12 0 0
Number of Samples 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 7 442 36 4 5 144 28 459a 14 2 0
Number Mutated (not modal value) 0 2 1 1 0 0 1 0 0 0 0 2 2 0 0 1 0 0 1 2 1 3 0 1 0 0 3 4 4 0 0 0 1 0 1 0 0 1 0 0 2 0 0 0 0 1 0 1 3 1 1 0 1 1 0 0 0 0 28 438 37 0 0 28 455 16 0 0
Fraction Mutated 0,00000 0,33333 0,16667 0,16667 0,00000 0,00000 0,16667 0,00000 0,00000 0,00000 0,00000 0,33333 0,00000 0,00000 0,00000 0,16667 0,00000 0,00000 0,16667 0,00000 0,16667 0,50000 0,00000 0,16667 0,00000 0,00000 0,50000 0,33333 0,66667 0,00000 0,00000 0,00000 0,16667 0,00000 0,16667 0,00000 0,00000 0,16667 0,00000 0,00000 0,33333 0,00000 0,00000 0,00000 0,00000 0,16667 0,00000 0,16667 0,50000 0,16667 0,16667 0,00000 0,16667 0,16667 0,00000 0,00000 0,00000 0,00000 28 531 38 0 0 28 454 17 0 0
Generations 0 107 110 63 0 0 758 0 0 0 0 41 0 0 0 63 0 0 20 0 41 240 0 23 0 0 63 5 206 0 0 0 269 0 292 0 0 108 0 0 83 0 0 0 0 20 0 52 92 68 46 0 314 172 0 0 0 0 28 578 39 0 0 28 437 19 0 0
Years 0 2680 2759 1572 0 0 18939 0 0 0 0 1024 0 0 0 1578 0 0 497 0 1036 6010 0 567 0 0 1582 118 5144 0 0 0 6720 0 7310 0 0 2706 0 0 2063 0 0 0 0 501 0 1298 2298 1701 1142 0 7862 4296 0 0 0 0 3 395a 40 1 11 201 28 448 20 0 0
Infinite Alleles / ASD 1,00 1,50 1,20 1,20 1,00 1,00 1,20 1,00 1,00 1,00 1,00 1,50 1,00 1,00 1,00 1,20 1,00 1,00 1,20 1,00 1,20 2,00 1,00 1,20 1,00 1,00 1,06 0,50 1,00 1,00 1,00 1,00 0,60 1,00 1,20 1,00 1,00 1,20 1,00 1,00 0,50 1,00 1,00 1,00 1,00 1,20 1,00 1,20 2,00 1,20 1,20 1,00 1,20 0,30 1,00 1,00 1,00 1,00 28 395b 41 0 0 28 464a 22 2 0
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 28 590 42 0 0 28 464c 24 0 0
Mask >>> Enter 1 to Exclude a Marker 6 537 43 1 6 092 28 464d 25 0 0
Mask >>> Enter 1 to Add a Marker 28 641 44 0 0 28 YCa 28 0 0
Net Mask 1 0 0 0 1 1 0 1 1 1 1 0 1 1 1 0 1 1 0 1 0 0 1 0 1 1 0 0 0 1 1 1 0 1 0 1 1 0 1 1 0 1 1 1 1 0 1 0 0 0 0 1 0 0 1 1 1 1 28 472 45 0 0 28 YCb 29 0 0
Mutations 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11 406 46 1 2 255 28 607 31 0 0
Total Mutations (values not modal) 4 28 511 47 0 0 28 576 32 0 0
Number of Markers 34 28 425 48 0 0 28 438 37 0 0
Fraction 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 8 413a 49 2 4 125 28 531 38 0 0
Average Fraction 0 28 413b 50 0 0 28 578 39 0 0
Rate 0,00076 0,00000 0,00000 0,00000 0,00226 0,00009 0,00000 0,00477 0,00186 0,00052 0,00242 0,00000 0,00132 0,00016 0,00016 0,00000 0,00099 0,00135 0,00000 0,00566 0,00000 0,00000 0,00123 0,00000 0,00411 0,01022 0,00000 0,00000 0,00000 0,00055 0,00037 0,00008 0,00000 0,00054 0,00000 0,00018 0,00001 0,00000 0,00128 0,00018 0,00000 0,00321 0,00029 0,00018 0,00019 0,00000 0,00020 0,00000 0,00000 0,00000 0,00000 0,00042 0,00000 0,00000 0,00212 0,00034 0,00042 0,00087 28 557 51 0 0 28 395b 41 0 0
Average Rate 0,00145 28 594 52 0 0 28 590 42 0 0
Generations 0 28 436 53 0 0 28 641 44 0 0
Years 0 28 490 54 0 0 28 472 45 0 0
24 534 55 1 417 28 511 47 0 0
28 450 56 0 0 28 425 48 0 0
18 444 57 1 1 082 28 413b 50 0 0
17 481 58 3 1 149 28 557 51 0 0
14 520 59 1 1 417 28 594 52 0 0
20 446 60 1 951 28 436 53 0 0
28 617 61 0 0 28 490 54 0 0
4 568 62 1 6 551 28 450 56 0 0
2 487 63 1 14 318 28 617 61 0 0
28 572 64 0 0 28 572 64 0 0
28 640 65 0 0 28 640 65 0 0
28 492 66 0 0 28 492 66 0 0
28 565 67 0 0 28 565 67 0 0