ASD Peter Gwozdz 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,14876 0,26446 0,14876 0,00000 0,08264 0,00000 0,00000 0,08264 0,19835 0,00000 0,08264 0,08264 0,00000 0,08264 0,00000 0,08264 0,00000 0,00000 0,08264 0,44628 0,00000 0,08264 0,24793 0,00000 0,08264 0,08264 0,00000 0,00000 0,56198 0,08264 0,38017 0,99174 0,26446 0,61157 0,19835 0,33058 0,00000 0,00000 0,00000 0,00000 0,00000 0,23140 0,00000 0,00000 0,00000 0,00000 0,00000 0,18182 0,00000 0,00000 0,00000 0,00000 0,00000 0,18182 0,00000 0,18182 0,18182 0,14876 0,08264 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,08264 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 48 175 56 0 37 0 0 17 107 0 34 10 0 63 0 517 0 0 61 53 0 15 44 0 21 40 0 0 76 20 37 126 7 17 61 601 0 0 0 0 0 406 0 0 0 0 0 90 0 0 0 0 0 22 0 57 33 61 23 0 0 0 0 0 0 95 Age in generations = ASD divided by rate 33 393 1 0 0 1 385b 6 0 21 835 X recLOH
Years 0 1 196 4 379 1 403 0 914 0 0 433 2 666 0 854 254 0 1 565 0 12 913 0 0 1 530 1 331 0 365 1 095 0 514 993 0 0 1 912 503 930 3 138 187 433 1 530 15 026 0 0 0 0 0 10 149 0 0 0 0 0 2 250 0 0 0 0 0 546 0 1 416 836 1 518 566 0 0 0 0 0 0 2 375 Years 17 390 2 2 1 196 2 426 7 1 9 248 single mutation;  very slow mutator
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 4 19 3 9 4 379 3 565 67 8 6 697 Pc signature
Average ASD;  all 67 markers 0,10411 0,08402 0,08463 0,15412 0,10411 Average ASD 15 391 4 9 1 403 4 442 36 15 6 055 Pc signature
Chandler Mutation Rates Average 0,00335 0,00187 0,00278 0,00492 0,00335 Chandler Mutation Rates Average 33 385a 5 11 0 5 537 43 4 5 215
Age in generations = ASD divided by rate 31 45 Generations 30 31 31 Age in generations = ASD divided by rate 21 385b 6 0 914 6 395a 40 3 5 178
Age in years 777 1 124 761 783 777 Years 33 426 7 0 0 7 464a 22 13 4 695 X recLOH
Thomas: 1 2 3 4 5 Average of markers 13-25 Average of markers 26-37 Average of markers 38-67 33 388 8 0 0 8 444 57 12 4 019
Average ASD with the 6 Thomas markers 0,1124 (Compare to Thomas average = 0.2226) 0,08519 0,29890 0,04242 Average ASD 28 439 9 1 433 9 413a 49 5 3 738 X
Thomas Rate 0,00210 0,00362 0,00938 0,00141 Chandler Mutation Rates Average 6 389-1 10 8 2 666 10 19 3 8 3 307
Age in generations = ASD divided by rate 54 24 32 30 Age in generations = ASD divided by rate 33 392 11 0 0 11 568 62 2 3 029
Age in years 1 338 (Compare to Thomas 2,650) 588 797 754 Years 22 389-2 12 1 854 12 395b 41 0 2 685
Mask: 31 458 13 10 254 13 449 21 12 2 554
Masks are explained in the Documentation Compound Markers;  Infinite Alleles 33 459a 14 1 0 14 607 31 9 2 517
To specify which markers to use for ASD: Modal 0 = Not mutated;  1 - Mutated 10 459b 15 0 1 565 15 CDb 35 0 2 416 X
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 Count 0 10 4 11 0 11 1 33 455 16 0 0 16 531 38 1 2 250
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 385 459 464 YC CD 395 413 2 454 17 1 12 913 17 572 64 6 2 215
Number of Markers 58 1 0 1 0 1 0 0 33 447 18 11 0 18 390 2 5 2 179
ASD 0 0,14876 0,26446 0,14876 0 0 0 0,08264 0,19835 0 0,08264 0,08264 0 0,08264 0 0,08264 0 0 0,08264 0,44628 0,08264 0,08264 0 0 0,56198 0,08264 0,38017 0,99174 0,19835 0,33058 0 0 0 0 0 0,2314 0 0 0 0 0 0 0 0 0 0,18182 0 0,18182 0,18182 0,14876 0,08264 0 0 0 0 0 0 0,08264 1 0 1 0 1 0 1 33 437 19 0 0 19 464b 23 0 2 132 X
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,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,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 1 0 0 0 1 0 1 11 448 20 1 1 530 20 439 9 10 1 994
Average ASD;  selected markers 0,09490 1 1 0 0 1 0 1 16 449 21 10 1 331 21 570 33 12 1 949
Average rate 0,00215 1 0 1 0 1 0 1 33 464a 22 7 0 22 511 47 3 1 811
Generations 44 1 0 1 0 1 0 1 30 464b 23 0 365 23 459a 14 5 1 757
Years 1 103 1 0 1 0 1 0 1 18 464c 24 0 1 095 24 487 63 2 1 655
1 0 0 0 1 0 1 33 464d 25 0 0 25 389-1 10 4 1 598
Mask Tool: Be sure to use "Paste Special, Values" when copying a mask to another location 1 0 0 0 1 0 1 26 460 26 1 514 26 557 51 6 1 574
5 000 < Set the limit for the number of years in the mask 1 0 1 0 1 0 1 19 GATA 27 1 993 27 481 58 6 1 421
Years Limit 1 0 1 0 1 0 1 33 YCa 28 0 0 28 458 13 15 1 380
Rank;  oldest = 1, 2, 3 … 33 17 4 15 33 21 33 33 28 6 33 22 31 33 10 33 2 33 33 11 16 33 30 18 33 26 19 33 33 9 27 20 5 32 29 11 1 33 33 33 33 33 3 33 33 33 33 33 8 33 33 33 33 33 25 33 14 23 13 24 33 33 33 33 33 33 7 33 YCb 29 0 0 29 576 32 13 1 338
Highlight > Limit - - - - - - - - - - - - - - - - 12 913 - - - - - - - - - - - - - - - - - - - 15 026 - - - - - 10 149 - - - - - - - - - - - - - - - - - - - - - - - - 9 456 30 6 1 912 30 389-2 12 4 1 228
Mask for all markers below the "Years Limit" 4 4 4 4 4 4 4 4 4 4 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 0 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 4 4 4 4 27 607 31 10 503 31 459b 15 0 1 216
20 576 32 10 930 32 448 20 2 1 189
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 5 570 33 6 3 138 33 393 1 1 1 095
Infinite Alleles: 32 CDa 34 11 187 34 CDa 34 27 1 078 X
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) 29 CDb 35 0 433 35 456 30 11 963
Number of Samples 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 442 36 11 1 530 36 464c 24 0 935 X
Number Mutated (not modal value) 0 2 9 9 11 0 0 1 8 0 1 10 1 0 1 11 0 1 10 7 1 1 0 6 10 10 6 11 11 1 0 0 0 0 4 0 0 11 0 0 10 0 0 0 0 2 0 2 11 2 1 0 0 0 11 0 0 1 1 438 37 1 15 026 37 460 26 4 858
Fraction Mutated 0,00000 0,18182 0,81818 0,81818 1,00000 0,00000 0,00000 0,09091 0,72727 0,00000 0,09091 0,90909 0,00000 0,00000 0,09091 1,00000 0,00000 0,09091 0,90909 0,00000 0,09091 0,09091 0,00000 0,54545 0,90909 0,90909 0,54545 1,00000 1,00000 0,09091 0,00000 0,00000 0,00000 0,00000 0,36364 0,00000 0,00000 1,00000 0,00000 0,00000 0,90909 0,00000 0,00000 0,00000 0,00000 0,18182 0,00000 0,18182 1,00000 0,18182 0,09091 0,00000 0,00000 0,00000 1,00000 0,00000 0,00000 0,09091 33 531 38 0 0 38 437 19 1 841
Generations 0 58 542 309 221 0 0 19 391 0 38 112 0 0 568 379 0 67 108 0 23 44 0 74 221 89 69 14 309 165 0 0 0 0 638 0 0 649 0 0 225 0 0 0 0 22 0 57 184 74 25 0 0 0 472 0 0 104 33 578 39 0 0 39 534 55 12 729
Years 0 1462 13546 7719 5531 0 0 476 9775 0 939 2792 0 0 14205 9470 0 1684 2712 0 565 1093 0 1855 5530 2224 1726 354 7716 4132 0 0 0 0 15949 0 0 16234 0 0 5626 0 0 0 0 546 0 1416 4596 1855 623 0 0 0 11792 0 0 2612 33 395a 40 0 0 40 YCa 28 2 677
Infinite Alleles / ASD 1,00 1,22 3,09 5,50 1,00 1,00 1,00 1,10 3,67 1,00 1,10 11,00 1,00 1,00 1,10 1,00 1,00 1,10 2,04 1,00 1,10 1,10 1,00 0,97 11,00 2,39 0,55 1,89 5,04 0,28 1,00 1,00 1,00 1,00 1,57 1,00 1,00 1,00 1,00 1,00 2,50 1,00 1,00 1,00 1,00 1,00 1,00 1,00 5,50 1,22 1,10 1,00 1,00 1,00 1,00 1,00 1,00 1,10 33 395b 41 0 0 40 YCb 29 0 677
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 1 1 33 590 42 0 0 42 391 4 2 651
Mask >>> Enter 1 to Exclude a Marker 3 537 43 4 10 149 43 446 60 3 635
Mask >>> Enter 1 to Add a Marker 33 641 44 0 0 44 406 46 1 540
Net Mask 1 0 0 0 0 1 1 1 0 1 1 0 1 1 1 0 1 1 0 1 1 1 1 0 0 0 0 0 0 1 1 1 1 1 0 1 1 0 1 1 0 1 1 1 1 0 1 0 0 0 1 1 1 1 0 1 1 1 33 472 45 0 0 45 464d 25 0 452 X
Mutations 0 0 0 0 0 0 0 1 0 0 1 0 1 0 1 0 0 1 0 7 1 1 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 1 33 406 46 11 0 46 413b 50 0 412 X
Total Mutations (values not modal) 17 33 511 47 0 0 47 GATA 27 1 400
Number of Markers 36 33 425 48 0 0 48 520 59 1 340
Fraction 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,09091 0,00000 0,00000 0,09091 0,00000 0,00000 0,00000 0,09091 0,00000 0,00000 0,09091 0,00000 0,00000 0,09091 0,09091 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,09091 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,09091 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,09091 8 413a 49 10 2 250 49 385a 5 5 0
Average Fraction 0,02273 33 413b 50 0 0 49 388 8 0 0
Rate 0,00076 0,00000 0,00000 0,00000 0,00000 0,00009 0,00022 0,00477 0,00000 0,00052 0,00242 0,00000 0,00132 0,00016 0,00016 0,00000 0,00099 0,00135 0,00000 0,00566 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,00128 0,00018 0,00000 0,00321 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,00087 33 557 51 0 0 49 392 11 0 0
Average Rate 0,00113 33 594 52 0 0 49 455 16 0 0
Generations 20 33 436 53 0 0 49 454 17 0 0
Years 505 33 490 54 0 0 49 447 18 0 0
25 534 55 2 546 49 438 37 0 0
33 450 56 0 0 49 578 39 0 0
14 444 57 2 1 416 49 590 42 0 0
23 481 58 11 836 49 641 44 0 0
13 520 59 2 1 518 49 472 45 0 0
24 446 60 1 566 49 425 48 0 0
33 617 61 0 0 49 594 52 0 0
33 568 62 0 0 49 436 53 0 0
33 487 63 0 0 49 490 54 0 0
33 572 64 11 0 49 450 56 0 0
33 640 65 0 0 49 617 61 0 0
33 492 66 0 0 49 640 65 0 0
7 565 67 1 2 375 49 492 66 0 0