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,25000 0,13889 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,33333 0,88889 0,00000 0,00000 0,22222 0,00000 0,22222 0,00000 0,00000 0,13889 0,88889 0,13889 0,00000 0,00000 0,00000 0,13889 0,00000 0,00000 0,55556 0,00000 0,22222 0,00000 0,13889 0,33333 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,22222 0,00000 0,00000 0,00000 0,00000 0,00000 0,22222 0,00000 0,00000 0,13889 0,00000 0,00000 0,47222 0,00000 0,13889 0,00000 0,13889 0,13889 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,13889 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 80 92 0 0 0 0 0 0 0 0 138 109 0 0 1389 0 84 0 0 17 157 25 0 0 0 67 0 0 76 0 22 0 4 9 0 0 0 0 0 0 0 390 0 0 0 0 0 110 0 0 479 0 0 57 0 43 0 57 38 0 0 0 0 0 0 160 Age in generations = ASD divided by rate 23 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 2 010 2 299 0 0 0 0 0 0 0 0 3 444 2 730 0 0 34 722 0 2 104 0 0 414 3 926 613 0 0 0 1 669 0 0 1 890 0 544 0 98 236 0 0 0 0 0 0 0 9 747 0 0 0 0 0 2 750 0 0 11 973 0 0 1 419 0 1 082 0 1 417 951 0 0 0 0 0 0 3 991 Years 11 390 2 3 2 010 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 9 19 3 6 2 299 3 464a 22 4 10 855 X recLOH issue
Average ASD;  all 67 markers 0,09287 0,06019 0,12889 0,12462 0,09287 Average ASD 23 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 23 385a 5 6 0 5 568 62 2 7 017 2 mutations;  very low rate;  statistically OK
Age in generations = ASD divided by rate 28 32 Generations 46 25 28 Age in generations = ASD divided by rate 23 385b 6 0 0 6 442 36 15 5 787 Not bimodal;  might be 3 subtypes, but not clear
Age in years 694 805 1 159 633 694 Years 23 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 23 388 8 0 0 8 YCb 29 0 5 011 X
Average ASD with the 6 Thomas markers 0,07778 (Compare to Thomas average = 0.2226) 0,19231 0,11574 0,05370 Average ASD 23 439 9 0 0 9 607 31 12 3 707
Thomas Rate 0,00210 0,00362 0,00938 0,00141 Chandler Mutation Rates Average 23 389-1 10 0 0 10 537 43 1 3 625
Age in generations = ASD divided by rate 37 53 12 38 Age in generations = ASD divided by rate 23 392 11 0 0 11 449 21 11 3 131
Age in years 926 (Compare to Thomas 2,650) 1 327 309 954 Years 6 389-2 12 2 3 444 12 444 57 5 2 961
Mask: 8 458 13 6 2 730 13 459b 15 0 2 788
Masks are explained in the Documentation Compound Markers;  Infinite Alleles 23 459a 14 0 0 14 385b 6 0 2 619
To specify which markers to use for ASD: Modal 0 = Not mutated;  1 - Mutated 23 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 6 0 6 4 6 4 1 455 16 2 34 722 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 23 454 17 0 0 17 557 51 3 2 060
Number of Markers 59 1 0 1 0 1 0 0 10 447 18 2 2 104 18 413a 49 1 2 046
ASD 0 0,25 0,13889 0 0 0 0 0 0 0,33333 0,88889 0 0 0,22222 0 0,22222 0 0 0,13889 0 0,13889 0 0 0,55556 0 0,22222 0 0 0 0 0 0 0 0 0,22222 0 0 0 0 0 0,22222 0 0 0,13889 0 0 0,47222 0 0,13889 0 0,13889 0,13889 0 0 0 0 0 0 0,13889 1 0 1 0 0 0 0 23 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 23 448 20 0 0 20 570 33 9 1 840
Average ASD;  selected markers 0,08004 1 0 1 0 0 0 1 20 449 21 1 414 21 439 9 9 1 677 Pc signature
Average rate 0,00214 1 0 1 0 1 0 0 5 464a 22 6 3 926 22 576 32 14 1 627
Generations 37 1 0 1 0 0 0 1 18 464b 23 0 613 23 511 47 1 1 614
Years 933 23 464c 24 0 0 24 GATA 27 3 1 482
23 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 23 460 26 0 0 26 393 1 1 1 263
5 000 < Set the limit for the number of years in the mask 13 GATA 27 5 1 669 27 458 13 11 1 229
Years Limit 23 YCa 28 0 0 28 460 26 4 993
Rank;  oldest = 1, 2, 3 … 23 11 9 23 23 23 23 23 23 23 23 6 8 23 23 1 23 10 23 23 20 5 18 23 23 23 13 23 23 12 23 19 23 22 21 23 23 23 23 23 23 23 3 23 23 23 23 23 7 23 23 2 23 23 14 23 16 23 15 17 23 23 23 23 23 23 4 23 YCb 29 0 0 29 389-1 10 2 989
Highlight > Limit - - - - - - - - - - - - - - - 34 722 - - - - - - - - - - - - - - - - - - - - - - - - - - 9 747 - - - - - - - - 11 973 - - - - - - - - - - - - - - - 12 456 30 4 1 890 30 437 19 1 970
Mask for all markers below the "Years Limit" 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 0 4 4 4 4 4 4 4 4 0 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 23 607 31 6 0 31 390 2 3 952
19 576 32 4 544 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 23 570 33 6 0 33 481 58 2 836
Infinite Alleles: 22 CDa 34 2 98 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) 21 CDb 35 0 236 35 534 55 5 745
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 23 442 36 6 0 36 448 20 1 711
Number Mutated (not modal value) 0 3 6 0 6 0 0 0 0 0 2 6 0 2 0 2 0 0 1 6 0 5 0 4 6 4 6 2 6 0 0 0 0 0 2 0 0 6 0 0 2 0 1 0 0 3 0 1 6 1 1 0 0 0 6 0 0 1 23 438 37 0 0 37 464c 24 0 678
Fraction Mutated 0,00000 0,50000 1,00000 0,00000 1,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,33333 1,00000 0,00000 0,33333 0,00000 0,33333 0,00000 0,00000 0,16667 1,00000 0,00000 0,83333 0,00000 0,66667 1,00000 0,66667 1,00000 0,16667 1,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,33333 0,00000 0,00000 1,00000 0,00000 0,00000 0,33333 0,00000 0,16667 0,00000 0,00000 0,50000 0,00000 0,16667 1,00000 0,16667 0,16667 0,00000 0,00000 0,00000 1,00000 0,00000 0,00000 0,16667 23 531 38 0 0 37 464d 25 0 678
Generations 0 161 662 0 221 0 0 0 0 0 138 123 0 2083 0 126 0 0 20 44 0 401 0 91 243 65 127 2 309 0 0 0 0 0 585 0 0 649 0 0 83 0 575 0 0 60 0 52 184 68 46 0 0 0 472 0 0 192 23 578 39 0 0 39 446 60 1 566
Years 0 4019 16556 0 5531 0 0 0 0 0 3444 3071 0 52083 0 3157 0 0 497 1104 0 10016 0 2268 6083 1631 3165 59 7716 0 0 0 0 0 14620 0 0 16234 0 0 2063 0 14368 0 0 1502 0 1298 4596 1701 1142 0 0 0 11792 0 0 4789 23 395a 40 0 0 40 447 18 1 364
Infinite Alleles / ASD 1,00 2,00 7,20 1,00 1,00 1,00 1,00 1,00 1,00 1,00 1,00 1,13 1,00 1,50 1,00 1,50 1,00 1,00 1,20 0,28 1,00 6,00 1,00 1,20 1,00 3,00 1,00 0,60 1,00 1,00 1,00 1,00 1,00 1,00 1,50 1,00 1,00 1,00 1,00 1,00 0,75 1,00 1,20 1,00 1,00 1,06 1,00 1,20 1,00 1,20 1,20 1,00 1,00 1,00 1,00 1,00 1,00 1,20 23 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 - 1 1 - 23 590 42 0 0 42 19 3 0 0
Mask >>> Enter 1 to Exclude a Marker 3 537 43 2 9 747 42 385a 5 3 0
Mask >>> Enter 1 to Add a Marker 23 641 44 0 0 42 388 8 0 0
Net Mask 1 0 0 1 0 1 1 1 1 1 0 0 1 0 1 0 1 1 0 0 1 0 1 0 0 0 0 0 0 1 1 1 1 1 0 1 1 0 1 1 0 1 0 1 1 0 1 0 0 0 0 1 1 1 0 1 1 0 23 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 23 406 46 6 0 42 459a 14 2 0
Total Mutations (values not modal) 0 23 511 47 0 0 42 455 16 0 0
Number of Markers 31 23 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 7 413a 49 2 2 750 42 438 37 0 0
Average Fraction 0 23 413b 50 0 0 42 531 38 0 0
Rate 0,00076 0,00000 0,00000 0,00265 0,00000 0,00009 0,00022 0,00477 0,00186 0,00052 0,00000 0,00000 0,00132 0,00000 0,00016 0,00000 0,00099 0,00135 0,00000 0,00000 0,00402 0,00000 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,00000 0,00018 0,00019 0,00000 0,00020 0,00000 0,00000 0,00000 0,00000 0,00042 0,00053 0,00097 0,00000 0,00034 0,00042 0,00000 23 557 51 0 0 42 578 39 0 0
Average Rate 0,00096 2 594 52 1 11 973 42 395a 40 1 0
Generations 0 23 436 53 0 0 42 590 42 0 0
Years 0 23 490 54 0 0 42 641 44 0 0
14 534 55 3 1 419 42 472 45 0 0
23 450 56 0 0 42 406 46 0 0
16 444 57 1 1 082 42 425 48 0 0
23 481 58 6 0 42 413b 50 0 0
15 520 59 1 1 417 42 594 52 0 0
17 446 60 1 951 42 436 53 0 0
23 617 61 0 0 42 490 54 0 0
23 568 62 0 0 42 450 56 0 0
23 487 63 0 0 42 520 59 0 0
23 572 64 6 0 42 617 61 0 0
23 640 65 0 0 42 487 63 0 0
23 492 66 0 0 42 640 65 0 0
4 565 67 1 3 991 42 492 66 0 0