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,18750 0,50000 0,25000 0,00000 0,00000 0,18750 0,00000 0,00000 0,00000 0,18750 0,00000 0,00000 0,68750 0,00000 0,00000 0,00000 0,00000 0,18750 0,00000 0,18750 0,18750 0,00000 0,00000 0,00000 0,00000 1,18750 0,00000 0,00000 0,00000 0,00000 0,00000 0,68750 0,00000 0,50000 0,18750 0,18750 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,18750 0,00000 0,00000 0,00000 0,18750 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 247 161 166 0 0 83 0 0 0 101 0 0 84 0 0 0 0 71 0 139 22 0 0 0 0 295 0 0 0 0 0 67 0 14 5 58 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 77 0 0 0 193 0 0 0 0 Age in generations = ASD divided by rate 2 393 1 1 6 168 1 YCa 28 5 27 030 X Changed 1 recLOH from 23 to 21, count 2, reduced age to 7,834
Years 6 168 4 019 4 139 0 0 2 074 0 0 0 2 520 0 0 2 111 0 0 0 0 1 776 0 3 472 559 0 0 0 0 7 385 0 0 0 0 0 1 682 0 354 133 1 447 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 913 0 0 0 4 832 0 0 0 0 Years 5 390 2 4 4 019 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 4 19 3 4 4 139 3 464a 22 4 10 855 X recLOH issue
Average ASD;  all 67 markers 0,08489 0,10938 0,10250 0,14358 0,08489 Average ASD 17 391 4 0 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 17 385a 5 4 0 5 568 62 2 7 017 2 mutations;  very low rate;  statistically OK
Age in generations = ASD divided by rate 25 59 Generations 37 29 25 Age in generations = ASD divided by rate 9 385b 6 0 2 074 6 442 36 15 5 787 Not bimodal;  might be 3 subtypes, but not clear
Age in years 634 1 463 921 729 634 Years 17 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 17 388 8 0 0 8 YCb 29 0 5 011 X
Average ASD with the 6 Thomas markers 0,1875 (Compare to Thomas average = 0.2226) 0,09615 0,22917 0,01250 Average ASD 17 439 9 4 0 9 607 31 12 3 707
Thomas Rate 0,00210 0,00362 0,00938 0,00141 Chandler Mutation Rates Average 7 389-1 10 1 2 520 10 537 43 1 3 625
Age in generations = ASD divided by rate 89 27 24 9 Age in generations = ASD divided by rate 17 392 11 4 0 11 449 21 11 3 131
Age in years 2 232 (Compare to Thomas 2,650) 663 611 222 Years 17 389-2 12 4 0 12 444 57 5 2 961
Mask: 8 458 13 3 2 111 13 459b 15 0 2 788
Masks are explained in the Documentation Compound Markers;  Infinite Alleles 17 459a 14 0 0 14 385b 6 0 2 619
To specify which markers to use for ASD: Modal 0 = Not mutated;  1 - Mutated 17 459b 15 0 0 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 4 0 4 0 0 0 17 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 17 454 17 0 0 17 557 51 3 2 060
Number of Markers 59 1 0 1 0 1 1 1 11 447 18 4 1 776 18 413a 49 1 2 046
ASD 0,1875 0,5 0,25 0 0 0 0 0,1875 0 0 0,6875 0 0 0 0 0,1875 0 0,1875 0,1875 1,1875 0 0 0 0 0 0,6875 0 0,1875 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0,1875 0 0 0 0,1875 0 0 0 0 1 0 1 0 1 1 1 17 437 19 4 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 1 1 1 6 448 20 4 3 472 20 570 33 9 1 840
Average ASD;  selected markers 0,08157 1 0 1 0 1 1 1 14 449 21 4 559 21 439 9 9 1 677 Pc signature
Average rate 0,00214 17 464a 22 4 0 22 576 32 14 1 627
Generations 38 17 464b 23 0 0 23 511 47 1 1 614
Years 951 17 464c 24 0 0 24 GATA 27 3 1 482
17 464d 25 0 0 25 464b 23 0 1 413
Mask Tool: Be sure to use "Paste Special, Values" when copying a mask to another location 1 460 26 2 7 385 26 393 1 1 1 263
5 000 < Set the limit for the number of years in the mask 17 GATA 27 0 0 27 458 13 11 1 229
Years Limit 17 YCa 28 0 0 28 460 26 4 993
Rank;  oldest = 1, 2, 3 … 2 5 4 17 17 9 17 17 17 7 17 17 8 17 17 17 17 11 17 6 14 17 17 17 17 1 17 17 17 17 17 12 17 15 16 13 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 10 17 17 17 3 17 17 17 17 17 YCb 29 0 0 29 389-1 10 2 989
Highlight > Limit 6 168 - - - - - - - - - - - - - - - - - - - - - - - - 7 385 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 17 456 30 0 0 30 437 19 1 970
Mask for all markers below the "Years Limit" 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 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 4 4 4 4 4 4 4 17 607 31 4 0 31 390 2 3 952
12 576 32 2 1 682 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 17 570 33 4 0 33 481 58 2 836
Infinite Alleles: 15 CDa 34 4 354 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) 16 CDb 35 0 133 35 534 55 5 745
Number of Samples 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 13 442 36 4 1 447 36 448 20 1 711
Number Mutated (not modal value) 1 4 4 0 4 0 0 4 1 4 4 3 0 0 0 4 4 4 4 4 2 0 0 0 4 2 4 4 4 4 0 4 4 0 4 0 0 4 0 0 4 4 0 0 0 4 0 4 4 3 4 0 0 1 0 0 4 4 17 438 37 4 0 37 464c 24 0 678
Fraction Mutated 0,25000 1,00000 1,00000 0,00000 1,00000 0,00000 0,00000 1,00000 0,25000 1,00000 1,00000 0,75000 0,00000 0,00000 0,00000 1,00000 1,00000 1,00000 1,00000 1,00000 0,50000 0,00000 0,00000 0,00000 1,00000 0,50000 1,00000 0,75000 1,00000 1,00000 0,00000 1,00000 1,00000 0,00000 1,00000 0,00000 0,00000 1,00000 0,00000 0,00000 1,00000 1,00000 0,00000 0,00000 0,00000 1,00000 0,00000 1,00000 1,00000 0,75000 1,00000 0,00000 0,00000 0,25000 0,00000 0,00000 1,00000 1,00000 17 531 38 0 0 37 464d 25 0 678
Generations 329 322 662 0 221 0 0 210 134 1923 413 92 0 0 0 379 1010 741 119 44 124 0 0 0 243 49 127 11 309 1818 0 12500 1613 0 1754 0 0 649 0 0 248 312 0 0 0 120 0 312 184 306 274 0 0 258 0 0 2381 1149 17 578 39 4 0 39 446 60 1 566
Years 8224 8039 16556 0 5531 0 0 5241 3360 48077 10331 2303 0 0 0 9470 25253 18519 2983 1104 3109 0 0 0 6083 1223 3165 266 7716 45455 0 312500 40323 0 43860 0 0 16234 0 0 6188 7788 0 0 0 3005 0 7788 4596 7653 6849 0 0 6443 0 0 59524 28736 17 395a 40 4 0 40 447 18 1 364
Infinite Alleles / ASD 1,33 2,00 4,00 1,00 1,00 1,00 1,00 1,00 1,33 1,00 1,00 1,09 1,00 1,00 1,00 5,33 1,00 5,33 5,33 1,00 0,42 1,00 1,00 1,00 1,00 0,73 1,00 0,75 5,33 1,00 1,00 1,00 1,00 1,00 1,00 1,00 1,00 1,00 1,00 1,00 1,00 1,00 1,00 1,00 1,00 1,00 1,00 1,00 1,00 4,00 1,00 1,00 1,00 1,33 1,00 1,00 1,00 1,00 17 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 - - 17 590 42 0 0 42 19 3 0 0
Mask >>> Enter 1 to Exclude a Marker 17 537 43 4 0 42 385a 5 3 0
Mask >>> Enter 1 to Add a Marker 17 641 44 0 0 42 388 8 0 0
Net Mask 0 0 0 1 0 1 1 0 0 0 0 0 1 1 1 0 0 0 0 0 0 1 1 1 0 0 0 0 0 0 1 0 0 1 0 1 1 0 1 1 0 0 1 1 1 0 1 0 0 0 0 1 1 0 1 1 0 0 17 472 45 0 0 42 392 11 0 0
Mutations 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 17 406 46 4 0 42 459a 14 2 0
Total Mutations (values not modal) 0 17 511 47 0 0 42 455 16 0 0
Number of Markers 23 17 425 48 0 0 42 454 17 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 17 413a 49 4 0 42 438 37 0 0
Average Fraction 0 17 413b 50 0 0 42 531 38 0 0
Rate 0,00000 0,00000 0,00000 0,00265 0,00000 0,00009 0,00022 0,00000 0,00000 0,00000 0,00000 0,00000 0,00132 0,00016 0,00016 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00208 0,00123 0,00735 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00037 0,00000 0,00000 0,00054 0,00000 0,00018 0,00001 0,00000 0,00128 0,00018 0,00000 0,00000 0,00029 0,00018 0,00019 0,00000 0,00020 0,00000 0,00000 0,00000 0,00000 0,00042 0,00053 0,00000 0,00212 0,00034 0,00000 0,00000 17 557 51 4 0 42 578 39 0 0
Average Rate 0,00096 17 594 52 0 0 42 395a 40 1 0
Generations 0 17 436 53 0 0 42 590 42 0 0
Years 0 17 490 54 0 0 42 641 44 0 0
17 534 55 4 0 42 472 45 0 0
17 450 56 0 0 42 406 46 0 0
17 444 57 4 0 42 425 48 0 0
17 481 58 4 0 42 413b 50 0 0
10 520 59 3 1 913 42 594 52 0 0
17 446 60 4 0 42 436 53 0 0
17 617 61 0 0 42 490 54 0 0
17 568 62 0 0 42 450 56 0 0
3 487 63 1 4 832 42 520 59 0 0
17 572 64 0 0 42 617 61 0 0
17 640 65 0 0 42 487 63 0 0
17 492 66 4 0 42 640 65 0 0
17 565 67 4 0 42 492 66 0 0