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,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,25000 0,00000 0,00000 0,18750 0,00000 0,00000 0,00000 0,00000 0,18750 0,00000 0,00000 0,00000 0,00000 0,00000 0,18750 0,00000 0,00000 0,00000 0,00000 0,00000 0,18750 0,00000 0,25000 0,00000 0,00000 0,18750 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,25000 0,00000 0,00000 0,00000 0,00000 0,18750 0,00000 0,00000 0,00000 0,18750 0,00000 0,18750 0,00000 0,00000 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 0 0 0 0 0 0 0 0 0 134 0 0 23 0 0 0 0 71 0 0 0 0 0 33 0 0 0 0 0 26 0 24 0 0 5 0 0 0 0 0 0 0 0 0 0 162 0 0 0 0 58 0 0 0 23 0 58 0 0 0 0 0 193 0 0 0 0 Age in generations = ASD divided by rate 13 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 0 0 0 0 0 0 0 0 3 360 0 0 576 0 0 0 0 1 776 0 0 0 0 0 828 0 0 0 0 0 638 0 612 0 0 133 0 0 0 0 0 0 0 0 0 0 4 058 0 0 0 0 1 460 0 0 0 563 0 1 460 0 0 0 0 0 4 832 0 0 0 0 Years 13 390 2 4 0 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 13 19 3 4 0 3 464a 22 4 10 855 X recLOH issue
Average ASD;  all 67 markers 0,03638 0,02083 0,03250 0,03885 0,03638 Average ASD 13 391 4 4 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 13 385a 5 4 0 5 568 62 2 7 017 2 mutations;  very low rate;  statistically OK
Age in generations = ASD divided by rate 11 11 Generations 12 8 11 Age in generations = ASD divided by rate 13 385b 6 0 0 6 442 36 15 5 787 Not bimodal;  might be 3 subtypes, but not clear
Age in years 272 279 292 197 272 Years 13 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 13 388 8 0 0 8 YCb 29 0 5 011 X
Average ASD with the 6 Thomas markers 0 (Compare to Thomas average = 0.2226) 0,04327 0,05208 0,03333 Average ASD 13 439 9 4 0 9 607 31 12 3 707
Thomas Rate 0,00210 0,00362 0,00938 0,00141 Chandler Mutation Rates Average 3 389-1 10 2 3 360 10 537 43 1 3 625
Age in generations = ASD divided by rate 0 12 6 24 Age in generations = ASD divided by rate 13 392 11 4 0 11 449 21 11 3 131
Age in years 0 (Compare to Thomas 2,650) 299 139 592 Years 13 389-2 12 4 0 12 444 57 5 2 961
Mask: 10 458 13 3 576 13 459b 15 0 2 788
Masks are explained in the Documentation Compound Markers;  Infinite Alleles 13 459a 14 0 0 14 385b 6 0 2 619
To specify which markers to use for ASD: Modal 0 = Not mutated;  1 - Mutated 13 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 13 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 13 454 17 0 0 17 557 51 3 2 060
Number of Markers 59 1 0 1 0 1 1 1 4 447 18 4 1 776 18 413a 49 1 2 046
ASD 0 0 0 0 0 0 0 0,25 0 0 0,1875 0 0 0 0 0,1875 0 0 0 0 0 0 0 0,1875 0 0,25 0 0 0 0 0 0 0 0 0 0 0 0,25 0 0 0 0 0,1875 0 0 0 0,1875 0 0,1875 0 0 0 0 0 0,1875 0 0 0 0 1 0 1 0 1 1 1 13 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 13 448 20 4 0 20 570 33 9 1 840
Average ASD;  selected markers 0,03496 1 0 1 0 1 1 1 13 449 21 4 0 21 439 9 9 1 677 Pc signature
Average rate 0,00214 13 464a 22 4 0 22 576 32 14 1 627
Generations 16 13 464b 23 0 0 23 511 47 1 1 614
Years 408 7 464c 24 0 828 24 GATA 27 3 1 482
13 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 13 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 0 0 27 458 13 11 1 229
Years Limit 13 YCa 28 0 0 28 460 26 4 993
Rank;  oldest = 1, 2, 3 … 13 13 13 13 13 13 13 13 13 3 13 13 10 13 13 13 13 4 13 13 13 13 13 7 13 13 13 13 13 8 13 9 13 13 12 13 13 13 13 13 13 13 13 13 13 2 13 13 13 13 5 13 13 13 11 13 5 13 13 13 13 13 1 13 13 13 13 13 YCb 29 0 0 29 389-1 10 2 989
Highlight > Limit - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 8 456 30 1 638 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 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 607 31 4 0 31 390 2 3 952
9 576 32 2 612 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 13 570 33 0 0 33 481 58 2 836
Infinite Alleles: 13 CDa 34 4 0 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) 12 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 0 36 448 20 1 711
Number Mutated (not modal value) 0 4 4 4 4 0 0 4 2 4 4 3 0 0 0 4 4 4 4 4 0 0 0 1 4 2 0 4 4 0 0 4 4 0 4 0 0 4 0 0 4 4 0 0 0 4 0 4 4 0 4 0 0 1 4 0 4 4 13 438 37 0 0 37 464c 24 0 678
Fraction Mutated 0,00000 1,00000 1,00000 1,00000 1,00000 0,00000 0,00000 1,00000 0,50000 1,00000 1,00000 0,75000 0,00000 0,00000 0,00000 1,00000 1,00000 1,00000 1,00000 1,00000 0,00000 0,00000 0,00000 0,25000 1,00000 0,50000 0,00000 1,00000 1,00000 0,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,00000 1,00000 0,00000 0,00000 0,25000 1,00000 0,00000 1,00000 1,00000 13 531 38 0 0 37 464d 25 0 678
Generations 0 322 662 377 221 0 0 210 269 1923 413 92 0 0 0 379 1010 741 119 44 0 0 0 34 243 49 0 14 309 0 0 12500 1613 0 1754 0 0 649 0 0 248 312 0 0 0 120 0 312 184 0 274 0 0 258 472 0 2381 1149 13 578 39 4 0 39 446 60 1 566
Years 0 8039 16556 9434 5531 0 0 5241 6720 48077 10331 2303 0 0 0 9470 25253 18519 2983 1104 0 0 0 850 6083 1223 0 354 7716 0 0 312500 40323 0 43860 0 0 16234 0 0 6188 7788 0 0 0 3005 0 7788 4596 0 6849 0 0 6443 11792 0 59524 28736 13 395a 40 4 0 40 447 18 1 364
Infinite Alleles / ASD 1,00 1,00 1,00 1,00 1,00 1,00 1,00 1,00 2,00 1,00 1,00 4,00 1,00 1,00 1,00 5,33 1,00 1,00 1,00 1,00 1,00 1,00 1,00 1,33 1,00 2,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 5,33 1,00 1,00 1,00 5,33 1,00 5,33 1,00 1,00 1,00 1,00 1,00 1,33 1,00 1,00 1,00 1,00 13 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 - - 13 590 42 0 0 42 19 3 0 0
Mask >>> Enter 1 to Exclude a Marker 13 537 43 4 0 42 385a 5 3 0
Mask >>> Enter 1 to Add a Marker 13 641 44 0 0 42 388 8 0 0
Net Mask 1 0 0 0 0 1 1 0 0 0 0 0 1 1 1 0 0 0 0 0 1 1 1 0 0 0 1 0 0 1 1 0 0 1 0 1 1 0 1 1 0 0 1 1 1 0 1 0 0 1 0 1 1 0 0 1 0 0 13 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 2 406 46 4 4 058 42 459a 14 2 0
Total Mutations (values not modal) 0 13 511 47 0 0 42 455 16 0 0
Number of Markers 25 13 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 13 413a 49 4 0 42 438 37 0 0
Average Fraction 0 13 413b 50 0 0 42 531 38 0 0
Rate 0,00076 0,00000 0,00000 0,00000 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,00402 0,00208 0,00123 0,00000 0,00000 0,00000 0,00790 0,00000 0,00000 0,00055 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,00245 0,00000 0,00042 0,00053 0,00000 0,00000 0,00034 0,00000 0,00000 5 557 51 4 1 460 42 578 39 0 0
Average Rate 0,00103 13 594 52 0 0 42 395a 40 1 0
Generations 0 13 436 53 0 0 42 590 42 0 0
Years 0 13 490 54 0 0 42 641 44 0 0
11 534 55 4 563 42 472 45 0 0
13 450 56 0 0 42 406 46 0 0
5 444 57 4 1 460 42 425 48 0 0
13 481 58 4 0 42 413b 50 0 0
13 520 59 0 0 42 594 52 0 0
13 446 60 4 0 42 436 53 0 0
13 617 61 0 0 42 490 54 0 0
13 568 62 0 0 42 450 56 0 0
1 487 63 1 4 832 42 520 59 0 0
13 572 64 4 0 42 617 61 0 0
13 640 65 0 0 42 487 63 0 0
13 492 66 4 0 42 640 65 0 0
13 565 67 4 0 42 492 66 0 0