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,05859 0,21484 0,00000 0,05859 0,23438 0,00000 0,10938 0,27734 0,00000 0,05859 0,40234 0,15234 0,60938 0,05859 0,00000 0,05859 0,18750 0,00000 0,05859 0,52734 0,00000 0,23438 0,00000 0,23438 0,23438 0,05859 0,00000 0,10938 0,10938 0,18359 0,60938 0,93750 1,12109 0,98438 0,37109 0,05859 0,05859 0,00000 0,00000 0,00000 0,00000 0,10938 0,00000 0,00000 0,21484 0,05859 0,00000 0,05859 0,10938 0,12500 0,23438 0,10938 0,00000 0,00000 0,00000 0,18359 0,05859 0,12500 0,18359 0,05859 0,00000 0,05859 0,00000 0,05859 0,00000 0,10938 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 19 142 0 26 104 0 497 58 0 113 166 19 462 44 0 366 71 0 43 63 0 41 0 41 58 28 0 89 15 45 60 119 32 28 115 107 158 0 0 0 0 192 0 0 140 46 0 29 54 39 808 608 0 0 0 57 11 51 50 140 0 60 0 172 0 126 Age in generations = ASD divided by rate 46 393 1 0 0 1 YCa 28 5 27 030 X Changed 1 recLOH from 23 to 21, count 2, reduced age to 7,834
Years 0 471 3 557 0 648 2 593 0 12 429 1 454 0 2 817 4 156 468 11 541 1 110 0 9 155 1 776 0 1 085 1 573 0 1 035 0 1 035 1 458 704 0 2 223 372 1 117 1 491 2 967 794 697 2 863 2 663 3 959 0 0 0 0 4 797 0 0 3 488 1 144 0 725 1 354 974 20 205 15 191 0 0 0 1 430 269 1 276 1 257 3 488 0 1 510 0 4 308 0 3 143 Years 42 390 2 1 471 2 395b 41 0 13 330 1 mutation;  very low rate;  statistically OK;  395a is zero, so they average out
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 16 3 557 3 464a 22 4 10 855 X recLOH issue
Average ASD;  all 67 markers 0,15264 0,11784 0,14141 0,22466 0,15264 Average ASD 46 391 4 16 0 4 426 7 1 10 667 1 mutation;  very low rate;  statistically OK
Chandler Mutation Rates Average 0,00335 0,00187 0,00278 0,00492 0,00335 Chandler Mutation Rates Average 41 385a 5 16 648 5 568 62 2 7 017 2 mutations;  very low rate;  statistically OK
Age in generations = ASD divided by rate 46 63 Generations 51 46 46 Age in generations = ASD divided by rate 18 385b 6 0 2 593 6 442 36 15 5 787 Not bimodal;  might be 3 subtypes, but not clear
Age in years 1 140 1 576 1 271 1 141 1 140 Years 46 426 7 0 0 7 565 67 3 5 700
Thomas: 1 2 3 4 5 Average of markers 13-25 Average of markers 26-37 Average of markers 38-67 3 388 8 2 12 429 8 YCb 29 0 5 011 X
Average ASD with the 6 Thomas markers 0,06641 (Compare to Thomas average = 0.2226) 0,16316 0,39811 0,06380 Average ASD 25 439 9 2 1 454 9 607 31 12 3 707
Thomas Rate 0,00210 0,00362 0,00938 0,00141 Chandler Mutation Rates Average 46 389-1 10 0 0 10 537 43 1 3 625
Age in generations = ASD divided by rate 32 45 42 45 Age in generations = ASD divided by rate 16 392 11 1 2 817 11 449 21 11 3 131
Age in years 791 (Compare to Thomas 2,650) 1 126 1 061 1 133 Years 8 389-2 12 4 4 156 12 444 57 5 2 961
Mask: 43 458 13 13 468 13 459b 15 0 2 788
Masks are explained in the Documentation Compound Markers;  Infinite Alleles 4 459a 14 3 11 541 14 385b 6 0 2 619
To specify which markers to use for ASD: Modal 0 = Not mutated;  1 - Mutated 32 459b 15 0 1 110 15 CDb 35 0 2 537
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 0 13 0 14 1 16 13 46 455 16 0 0 16 572 64 2 2 144
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 5 454 17 1 9 155 17 557 51 3 2 060
Number of Markers 59 1 0 1 1 1 0 0 20 447 18 16 1 776 18 413a 49 1 2 046
ASD 0 0,05859 0,21484 0 0 0,10938 0,27734 0 0,05859 0,40234 0,15234 0,60938 0,05859 0 0,05859 0,1875 0 0,05859 0,52734 0,23438 0,05859 0 0,10938 0,10938 0,18359 0,60938 0,9375 0,37109 0,05859 0,05859 0 0 0 0 0,10938 0 0 0,21484 0,05859 0 0,05859 0,10938 0,125 0,23438 0,10938 0 0 0 0,18359 0,05859 0,125 0,18359 0,05859 0 0,05859 0 0,05859 0 0,10938 1 0 1 1 1 0 0 46 437 19 0 0 19 389-2 12 6 1 884 Pa signature
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 1 0 1 0 0 0 0 33 448 20 1 1 085 20 570 33 9 1 840
Average ASD;  selected markers 0,12474 1 0 1 0 1 0 0 21 449 21 14 1 573 21 439 9 9 1 677 Pc signature
Average rate 0,00214 1 0 1 0 1 0 1 46 464a 22 16 0 22 576 32 14 1 627
Generations 58 1 0 1 0 1 0 0 34 464b 23 0 1 035 23 511 47 1 1 614
Years 1 454 1 0 1 0 1 0 0 46 464c 24 0 0 24 GATA 27 3 1 482
1 0 1 0 1 0 0 34 464d 25 0 1 035 25 464b 23 0 1 413
Mask Tool: Be sure to use "Paste Special, Values" when copying a mask to another location 1 0 1 0 1 0 0 24 460 26 10 1 458 26 393 1 1 1 263
5 000 < Set the limit for the number of years in the mask 1 0 1 0 1 0 0 39 GATA 27 16 704 27 458 13 11 1 229
Years Limit 1 0 1 0 1 0 0 46 YCa 28 2 0 28 460 26 4 993
Rank;  oldest = 1, 2, 3 … 46 42 10 46 41 18 46 3 25 46 16 8 43 4 32 46 5 20 46 33 21 46 34 46 34 24 39 46 19 44 31 23 14 37 40 15 17 9 46 46 46 46 6 46 46 11 30 46 38 27 36 1 2 46 46 46 26 45 28 29 12 46 22 46 7 46 13 1 1 1 0 1 0 0 19 YCb 29 0 2 223 29 389-1 10 2 989
Highlight > Limit - - - - - - - 12 429 - - - - - 11 541 - - 9 155 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 20 205 15 191 - - - - - - - - - - - - - - 1 0 1 0 1 0 1 44 456 30 14 372 30 437 19 1 970
Mask for all markers below the "Years Limit" 4 4 4 4 4 4 4 0 4 4 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 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 0 0 4 4 4 4 4 4 4 4 4 4 4 4 4 4 1 1 1 0 1 0 0 31 607 31 3 1 117 31 390 2 3 952
1 0 1 0 1 0 1 23 576 32 4 1 491 32 456 30 8 921
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 1 1 1 0 1 0 0 14 570 33 14 2 967 33 481 58 2 836
Infinite Alleles: 37 CDa 34 15 794 34 CDa 34 20 762
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) 40 CDb 35 0 697 35 534 55 5 745
Number of Samples 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 15 442 36 11 2 863 36 448 20 1 711
Number Mutated (not modal value) 0 1 16 16 16 0 2 2 0 1 4 13 3 0 1 16 0 1 14 16 10 16 2 14 3 4 14 15 11 1 16 0 0 0 2 0 0 11 1 0 3 2 1 2 0 0 0 15 16 15 3 1 0 1 16 1 0 2 17 438 37 1 2 663 37 464c 24 0 678
Fraction Mutated 0,00000 0,06250 1,00000 1,00000 0,93750 0,00000 0,12500 0,12500 0,00000 0,06250 0,25000 0,81250 0,12500 0,00000 0,06250 1,00000 0,00000 0,06250 0,87500 0,00000 0,62500 1,00000 0,00000 0,87500 0,18750 0,25000 0,87500 0,56250 0,68750 0,06250 1,00000 0,00000 0,00000 0,00000 0,12500 0,00000 0,00000 0,68750 0,06250 0,00000 0,06250 0,12500 0,06250 0,12500 0,00000 0,00000 0,00000 0,93750 1,00000 0,93750 0,18750 0,06250 0,00000 0,06250 1,00000 0,06250 0,00000 0,12500 9 531 38 16 3 959 37 464d 25 0 678
Generations 0 20 662 377 207 0 568 26 0 120 103 100 47 0 391 379 0 46 104 0 155 481 0 119 46 24 111 8 212 114 2703 0 0 0 219 0 0 446 49 0 15 39 216 694 0 0 0 292 184 383 51 149 0 64 472 184 0 144 46 578 39 0 0 39 446 60 1 566
Years 0 502 16556 9434 5185 0 14205 655 0 3005 2583 2495 1184 0 9766 9470 0 1157 2610 0 3887 12019 0 2976 1141 612 2769 199 5305 2841 67568 0 0 0 5482 0 0 11161 1221 0 387 974 5388 17361 0 0 0 7301 4596 9566 1284 3720 0 1611 11792 4596 0 3592 46 395a 40 0 0 40 447 18 1 364
Infinite Alleles / ASD 1,00 1,07 4,65 1,00 8,00 1,00 1,14 0,45 1,00 1,07 0,62 5,33 0,10 1,00 1,07 5,33 1,00 1,07 1,66 1,00 2,67 17,07 1,00 8,00 1,02 0,41 0,93 0,25 1,85 1,07 17,07 1,00 1,00 1,00 1,14 1,00 1,00 3,20 1,07 1,00 0,53 1,00 0,27 1,14 1,00 1,00 1,00 5,11 17,07 7,50 1,02 1,07 1,00 1,07 1,00 1,07 1,00 1,14 46 395b 41 0 0 41 391 4 1 362
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 - 46 590 42 0 0 42 19 3 0 0
Mask >>> Enter 1 to Exclude a Marker 6 537 43 2 4 797 42 385a 5 3 0
Mask >>> Enter 1 to Add a Marker 46 641 44 0 0 42 388 8 0 0
Net Mask 1 1 0 0 0 1 0 0 1 1 0 0 0 1 1 0 1 1 0 1 0 0 1 0 0 0 0 0 0 1 0 1 1 1 0 1 1 0 1 1 1 0 1 0 1 1 1 0 0 0 0 1 1 1 0 1 1 0 46 472 45 0 0 42 392 11 0 0
Mutations 0 1 0 0 0 0 0 0 0 1 0 0 0 0 1 0 0 1 0 16 0 0 2 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 3 0 1 0 0 0 0 0 0 0 0 1 0 1 0 1 0 0 11 406 46 11 3 488 42 459a 14 2 0
Total Mutations (values not modal) 31 30 511 47 1 1 144 42 455 16 0 0
Number of Markers 29 46 425 48 0 0 42 454 17 0 0
Fraction 0,00000 0,06250 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,06250 0,00000 0,00000 0,00000 0,00000 0,06250 0,00000 0,00000 0,06250 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,06250 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,06250 0,00000 0,12500 0,00000 0,06250 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,06250 0,00000 0,06250 0,00000 0,06250 0,00000 0,00000 38 413a 49 3 725 42 438 37 0 0
Average Fraction 0,02586 27 413b 50 0 1 354 42 531 38 0 0
Rate 0,00076 0,00311 0,00000 0,00000 0,00000 0,00009 0,00000 0,00000 0,00186 0,00052 0,00000 0,00000 0,00000 0,00016 0,00016 0,00000 0,00099 0,00135 0,00000 0,00566 0,00000 0,00000 0,00123 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00055 0,00000 0,00008 0,00031 0,00054 0,00000 0,00018 0,00001 0,00000 0,00128 0,00018 0,00202 0,00000 0,00029 0,00000 0,00019 0,00832 0,00020 0,00000 0,00000 0,00000 0,00000 0,00042 0,00053 0,00097 0,00000 0,00034 0,00042 0,00000 36 557 51 2 974 42 578 39 0 0
Average Rate 0,00113 1 594 52 1 20 205 42 395a 40 1 0
Generations 23 2 436 53 2 15 191 42 590 42 0 0
Years 573 46 490 54 0 0 42 641 44 0 0
46 534 55 0 0 42 472 45 0 0
46 450 56 0 0 42 406 46 0 0
26 444 57 15 1 430 42 425 48 0 0
45 481 58 16 269 42 413b 50 0 0
28 520 59 15 1 276 42 594 52 0 0
29 446 60 3 1 257 42 436 53 0 0
12 617 61 1 3 488 42 490 54 0 0
46 568 62 0 0 42 450 56 0 0
22 487 63 1 1 510 42 520 59 0 0
46 572 64 16 0 42 617 61 0 0
7 640 65 1 4 308 42 487 63 0 0
46 492 66 0 0 42 640 65 0 0
13 565 67 2 3 143 42 492 66 0 0