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 ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ASD Do not sort this "TRANSPOSE" array Sort by Sequence to get back to standard order
Mutation Rates >>> Chandler Mutation Rates ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### Chandler Mutation Rates Rank DYS Sequence Mutations Years Rank DYS Sequence Mutations Years Mask Notes
Age in generations = ASD divided by rate 0 45 92 0 0 0 0 0 0 0 0 161 9 0 268 0 0 0 0 0 36 0 0 0 0 0 0 0 0 0 0 26 100 7 31 26 0 375 2778 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 97 0 43 26 0 38 0 0 0 0 0 0 160 Age in generations = ASD divided by rate 19 393 1 0 0
Years 0 1 116 2 299 0 0 0 0 0 0 0 0 4 017 235 0 6 708 0 0 0 0 0 912 0 0 0 0 0 0 0 0 0 0 647 2 511 187 772 638 0 9 384 69 444 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 421 0 1 082 638 0 951 0 0 0 0 0 0 3 991 Years 9 390 2 2 1 116
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 8 19 3 2 2 299
Average ASD;  all 67 markers ##### ##### ##### ##### ##### Average ASD 19 391 4 0 0
Chandler Mutation Rates Average ##### ##### ##### ##### ##### Chandler Mutation Rates Average 19 385a 5 0 0
Age in generations = ASD divided by rate 25 30 Generations 20 21 25 Age in generations = ASD divided by rate 19 385b 6 0 0
Age in years 626 743 504 535 626 Years 19 426 7 0 0
Thomas: 1 2 3 4 5 Average of markers 13-25 Average of markers 26-37 Average of markers 38-67 19 388 8 0 0
Average ASD with the 6 Thomas markers 0,056 (Compare to Thomas average = 0.2226) ##### ##### ##### Average ASD 19 439 9 0 0
Thomas Rate ##### ##### ##### ##### Chandler Mutation Rates Average 19 389-1 10 0 0
Age in generations = ASD divided by rate 26 16 22 41 Age in generations = ASD divided by rate 19 392 11 0 0
Age in years 661 (Compare to Thomas 2,650) 391 554 1 020 Years 4 389-2 12 3 4 017
Mask: 17 458 13 1 235
Masks are explained in the Documentation Compound Markers;  Infinite Alleles 19 459a 14 8 0
To specify which markers to use for ASD: Modal 0 = Not mutated;  1 - Mutated 3 459b 15 0 6 708
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 Count 12 4 12 11 5 6 6 19 455 16 0 0
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 385 459 464 YC CD 395 413 19 454 17 0 0
Number of Markers 57 0 0 0 0 1 0 0 19 447 18 0 0
ASD 0 0,139 0,139 0 0 0 0 0 0 0,389 0,076 0 0,354 0 0 0 0 0 0,306 0 0 0 0 0 0 0,264 0,793 0,083 0 0,139 0,222 0 0 0 0 0 0 0 0 0 0 0 0 0 0,806 0 0,139 0,139 0 0,139 0 0 0 0 0 0 0,139 0 1 0 0 0 0 0 19 437 19 0 0
Rate 8E-04 0,003 0,002 0,003 9E-05 2E-04 0,005 0,002 5E-04 0,002 0,008 0,001 0,001 2E-04 2E-04 0,003 1E-03 0,001 0,008 0,004 0,002 0,001 0,001 0,007 0,004 0,01 0,008 0,003 6E-04 4E-04 8E-05 3E-04 3E-04 5E-04 6E-04 2E-04 1E-05 0,002 0,001 2E-04 0,003 3E-04 2E-04 2E-04 0,008 2E-04 0,003 0,005 0,002 0,004 4E-04 5E-04 1E-03 0,002 3E-04 4E-04 9E-04 0 1 0 0 1 0 0 19 448 20 0 0
Average ASD;  selected markers ##### 0 0 0 0 1 0 0 12 449 21 4 912
Average rate ##### 0 0 0 0 0 0 0 19 464a 22 0 0
Generations 35 0 1 0 0 1 0 0 19 464b 23 0 0
Years 871 0 1 0 0 0 19 464c 24 0 0
0 1 0 0 0 19 464d 25 0 0
Mask Tool: Be sure to use "Paste Special, Values" when copying a mask to another location 0 1 0 0 1 19 460 26 0 0
#### < Set the limit for the number of years in the mask 0 1 0 0 0 19 GATA 27 0 0
Years Limit 0 1 0 0 1 19 YCa 28 0 0
Rank;  oldest = 1, 2, 3 … 19 9 8 19 19 19 19 19 19 19 19 4 17 19 3 19 19 19 19 19 12 19 19 19 19 19 19 19 19 19 19 14 6 18 13 16 19 2 1 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 7 19 10 15 19 11 19 19 19 19 19 19 5 0 0 0 19 YCb 29 0 0
Highlight > Limit - - - - - - - - - - - - - - 6 708 - - - - - - - - - - - - - - - - - - - - - - 9 384 69 444 - - - - - - - - - - - - - - - - - - - - - - - - - - - - 19 456 30 0 0
Mask for all markers below the "Years Limit" 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 0 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 19 607 31 0 0
14 576 32 3 647
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 6 570 33 5 2 511
Infinite Alleles: 18 CDa 34 6 187
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) 13 CDb 35 0 772
Number of Samples 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 11 11 11 11 11 11 11 11 11 11 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 16 442 36 1 638
Number Mutated (not modal value) 0 2 2 0 0 0 0 0 0 0 3 1 8 0 0 0 0 0 4 0 0 0 0 0 0 3 5 6 1 0 1 2 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 1 1 0 1 0 0 0 0 0 0 1 19 438 37 0 0
Fraction Mutated ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### 2 531 38 1 9 384
Generations 0 54 110 0 0 0 0 0 0 0 103 10 0 0 0 0 0 0 40 0 0 0 0 0 0 27 58 4 28 0 450 4167 0 0 0 0 0 0 0 0 0 0 0 0 0 40 0 52 31 0 46 0 0 0 0 0 0 192 1 578 39 2 69 444
Years 0 1340 2759 0 0 0 0 0 0 0 2583 256 0 0 0 0 0 0 994 0 0 0 0 0 0 667 1438 97 701 0 11261 ##### 0 0 0 0 0 0 0 0 0 0 0 0 0 1002 0 1298 766 0 1142 0 0 0 0 0 0 4789 19 395a 40 0 0
Infinite Alleles / ASD 1,00 1,20 1,20 1,00 1,00 1,00 1,00 1,00 1,00 1,00 0,64 1,09 1,00 1,00 1,00 1,00 1,00 1,00 1,09 1,00 1,00 1,00 1,00 1,00 1,00 1,03 0,57 0,52 1,10 1,00 1,20 1,50 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 0,41 1,00 1,20 1,20 1,00 1,20 1,00 1,00 1,00 1,00 1,00 1,00 1,20 19 395b 41 0 0
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 - 1 - - 1 - 1 1 1 1 1 1 - 19 590 42 0 0
Mask >>> Enter 1 to Exclude a Marker 19 537 43 0 0
Mask >>> Enter 1 to Add a Marker 19 641 44 0 0
Net Mask 1 0 0 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 0 1 1 1 1 1 1 0 0 0 1 1 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 0 0 1 0 1 1 1 1 1 1 0 19 472 45 0 0
Mutations 0 0 0 0 0 0 0 0 0 0 0 1 8 0 0 0 0 0 0 0 0 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 0 0 0 0 0 0 0 0 0 19 406 46 0 0
Total Mutations (values not modal) 10 19 511 47 0 0
Number of Markers 44 19 425 48 0 0
Fraction ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### 19 413a 49 0 0
Average Fraction 0,004 19 413b 50 0 0
Rate ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### ##### 19 557 51 0 0
Average Rate 0,002 19 594 52 0 0
Generations 2 19 436 53 0 0
Years 59 19 490 54 0 0
7 534 55 2 2 421
19 450 56 0 0
10 444 57 1 1 082
15 481 58 1 638
19 520 59 0 0
11 446 60 1 951
19 617 61 0 0
19 568 62 0 0
19 487 63 0 0
19 572 64 0 0
19 640 65 0 0
19 492 66 0 0
5 565 67 1 3 991