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,10938 0,00000 0,10938 0,10938 0,48438 0,10938 0,00000 0,00000 0,00000 0,10938 0,00000 0,10938 0,25000 0,00000 0,10938 0,00000 0,00000 0,25000 0,00000 0,00000 0,25000 0,43750 0,00000 0,10938 0,35938 0,00000 0,35938 0,00000 0,00000 0,43750 0,10938 0,48438 0,25000 0,68750 3,75000 0,00000 0,00000 0,00000 0,10938 0,10938 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 1,18750 0,00000 0,00000 0,00000 0,10938 0,00000 0,60938 0,00000 0,00000 0,10938 0,00000 0,00000 0,00000 0,10938 0,00000 0,00000 0,18750 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 144 0 72 41 214 48 0 0 0 59 0 45 31 0 83 0 0 95 0 0 30 77 0 19 63 0 173 0 0 60 27 47 32 19 106 0 0 0 1367 353 0 0 0 0 0 0 0 0 0 0 370 0 0 0 13 0 190 0 0 30 0 0 0 52 0 0 216 Age in generations = ASD divided by rate 8 393 1 1 3 598 1 578 39 1 34 180
Years 3 598 0 1 811 1 032 5 358 1 210 0 0 0 1 470 0 1 130 768 0 2 071 0 0 2 367 0 0 746 1 932 0 483 1 587 0 4 319 0 0 1 488 665 1 185 791 487 2 655 0 0 0 34 180 8 821 0 0 0 0 0 0 0 0 0 0 9 248 0 0 0 329 0 4 746 0 0 749 0 0 0 1 290 0 0 5 388 Years 30 390 2 0 0 2 557 51 2 9 248
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 7 1 811 3 395a 40 1 8 821
Average ASD;  all 67 markers 0,17188 0,09505 0,11625 0,24282 0,17188 Average ASD 21 391 4 1 1 032 4 565 67 2 5 388
Chandler Mutation Rates Average 0,00335 0,00187 0,00278 0,00492 0,00335 Chandler Mutation Rates Average 5 385a 5 7 5 358 5 385a 5 7 5 358
Age in generations = ASD divided by rate 51 51 Generations 42 49 51 Age in generations = ASD divided by rate 18 385b 6 0 1 210 6 444 57 5 4 746
Age in years 1 284 1 271 1 045 1 234 1 284 Years 30 426 7 0 0 7 GATA 27 3 4 319
Thomas: 1 2 3 4 5 Average of markers 13-25 Average of markers 26-37 Average of markers 38-67 30 388 8 0 0 8 393 1 1 3 598
Average ASD with the 6 Thomas markers 0,06563 (Compare to Thomas average = 0.2226) 0,13582 0,50651 0,08438 Average ASD 30 439 9 0 0 9 CDb 35 0 2 655
Thomas Rate 0,00210 0,00362 0,00938 0,00141 Chandler Mutation Rates Average 16 389-1 10 1 1 470 10 447 18 7 2 367
Age in generations = ASD divided by rate 31 37 54 60 Age in generations = ASD divided by rate 30 392 11 0 0 11 459b 15 0 2 071
Age in years 781 (Compare to Thomas 2,650) 937 1 350 1 499 Years 20 389-2 12 1 1 130 12 464a 22 8 1 932
Mask: 23 458 13 4 768 13 19 3 7 1 811
Masks are explained in the Documentation Compound Markers;  Infinite Alleles 30 459a 14 1 0 14 464d 25 0 1 587
To specify which markers to use for ASD: Modal 0 = Not mutated;  1 - Mutated 11 459b 15 0 2 071 15 456 30 5 1 488
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 1 7 0 8 0 7 8 30 455 16 0 0 16 389-1 10 1 1 470
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 30 454 17 0 0 17 572 64 8 1 290
Number of Markers 59 1 0 1 0 1 0 0 10 447 18 7 2 367 18 385b 6 0 1 210
ASD 0,10938 0 0,10938 0,10938 0,48438 0,10938 0 0 0 0,10938 0 0,10938 0,25 0 0,10938 0 0 0,25 0 0 0,25 0 0,35938 0 0 0,4375 0,10938 0,48438 0,25 0 0 0 0,10938 0 0 0 0 0 0 0 0 0 0 0 0 0 0,10938 0 0,60938 0 0 0,10938 0 0 0 0,10938 0 0 0,1875 1 0 1 0 1 0 0 30 437 19 0 0 19 576 32 7 1 185
Rate 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,00402 0,00208 0,00123 0,00123 0,00735 0,00411 0,01022 0,0079 0,00324 0,00055 0,00037 0,00031 0,00031 0,00054 0,00057 0,00018 0,00001 0,00154 0,00128 0,00018 0,00202 0,00202 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 0 0 30 448 20 0 0 20 389-2 12 1 1 130
Average ASD;  selected markers 0,08263 1 1 1 0 1 0 0 25 449 21 7 746 21 391 4 1 1 032
Average rate 0,00217 1 0 1 0 1 0 0 12 464a 22 8 1 932 22 570 33 8 791
Generations 38 0 0 1 0 1 1 0 30 464b 23 0 0 23 458 13 4 768
Years 954 2 1 0 1 0 1 0 0 28 464c 24 0 483 24 446 60 1 749
1 0 1 0 1 0 0 14 464d 25 0 1 587 25 449 21 7 746
Mask Tool: Be sure to use "Paste Special, Values" when copying a mask to another location 30 460 26 8 0 26 607 31 1 665
5 000 < Set the limit for the number of years in the mask 7 GATA 27 3 4 319 27 CDa 34 8 487
Years Limit 30 YCa 28 0 0 28 464c 24 0 483
Rank;  oldest = 1, 2, 3 … 8 30 13 21 5 18 30 30 30 16 30 20 23 30 11 30 30 10 30 30 25 12 30 28 14 30 7 30 30 15 26 19 22 27 9 30 30 30 1 3 30 30 30 30 30 30 30 30 30 30 2 30 30 30 29 30 6 30 30 24 30 30 30 17 30 30 4 30 YCb 29 0 0 29 534 55 1 329
Highlight > Limit - - - - 5 358 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 34 180 8 821 - - - - - - - - - - 9 248 - - - - - - - - - - - - - - - 5 388 15 456 30 5 1 488 30 390 2 0 0
Mask for all markers below the "Years Limit" 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 0 0 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 0 26 607 31 1 665 30 426 7 0 0
19 576 32 7 1 185 30 388 8 0 0
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 22 570 33 8 791 30 439 9 0 0
Infinite Alleles: 27 CDa 34 8 487 30 392 11 0 0
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) 9 CDb 35 0 2 655 30 459a 14 1 0
Number of Samples 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 30 442 36 8 0 30 455 16 0 0
Number Mutated (not modal value) 1 0 7 1 7 0 0 0 1 0 1 4 1 0 0 7 0 0 7 8 8 3 0 5 1 7 8 8 8 0 0 1 1 0 0 0 0 8 0 0 0 2 0 0 0 1 0 5 8 0 1 0 0 0 8 0 0 2 30 438 37 0 0 30 454 17 0 0
Fraction Mutated 0,12500 0,00000 0,87500 0,12500 0,87500 0,00000 0,00000 0,00000 0,12500 0,00000 0,12500 0,50000 0,00000 0,00000 0,00000 0,87500 0,00000 0,00000 0,87500 1,00000 1,00000 0,37500 0,00000 0,62500 0,12500 0,87500 1,00000 0,37500 1,00000 0,00000 0,00000 0,12500 0,12500 0,00000 0,00000 0,00000 0,00000 1,00000 0,00000 0,00000 0,00000 0,25000 0,00000 0,00000 0,00000 0,12500 0,00000 0,62500 1,00000 0,00000 0,12500 0,00000 0,00000 0,00000 1,00000 0,00000 0,00000 0,25000 30 531 38 0 0 30 437 19 0 0
Generations 164 0 579 47 194 0 0 0 67 0 52 61 0 0 0 331 0 0 104 44 249 180 0 85 30 86 127 5 309 0 0 1563 202 0 0 0 0 649 0 0 0 78 0 0 0 15 0 195 184 0 34 0 0 0 472 0 0 287 1 578 39 1 34 180 30 448 20 0 0
Years 4112 0 14487 1179 4840 0 0 0 1680 0 1291 1536 0 0 0 8286 0 0 2610 1104 6219 4507 0 2126 760 2140 3165 133 7716 0 0 39063 5040 0 0 0 0 16234 0 0 0 1947 0 0 0 376 0 4868 4596 0 856 0 0 0 11792 0 0 7184 3 395a 40 1 8 821 30 464b 23 0 0
Infinite Alleles / ASD 1,14 1,00 8,00 1,14 0,90 1,00 1,00 1,00 1,14 1,00 1,14 2,00 1,00 1,00 1,00 3,50 1,00 1,00 3,50 0,57 1,00 1,04 1,00 1,43 1,14 1,81 4,00 0,27 1,00 1,00 1,00 1,14 0,57 1,00 1,00 1,00 1,00 1,00 1,00 1,00 1,00 0,21 1,00 1,00 1,00 1,14 1,00 1,03 1,00 1,00 1,14 1,00 1,00 1,00 9,14 1,00 1,00 1,33 30 395b 41 0 0 30 460 26 8 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 - 30 590 42 0 0 30 YCa 28 0 0
Mask >>> Enter 1 to Exclude a Marker 30 537 43 0 0 30 YCb 29 0 0
Mask >>> Enter 1 to Add a Marker 30 641 44 0 0 30 442 36 8 0
Net Mask 0 1 0 0 0 1 1 1 0 1 0 0 1 1 1 0 1 1 0 0 0 0 1 0 0 0 0 0 0 1 1 0 0 1 1 1 1 0 1 1 1 0 1 1 1 0 1 0 0 1 0 1 1 1 0 1 1 0 30 472 45 0 0 30 438 37 0 0
Mutations 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 30 406 46 8 0 30 531 38 0 0
Total Mutations (values not modal) 1 30 511 47 0 0 30 395b 41 0 0
Number of Markers 30 30 425 48 0 0 30 590 42 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 30 413a 49 0 0 30 537 43 0 0
Average Fraction 0 30 413b 50 0 0 30 641 44 0 0
Rate 0,00000 0,00311 0,00000 0,00000 0,00000 0,00009 0,00022 0,00477 0,00000 0,00052 0,00000 0,00000 0,00132 0,00016 0,00016 0,00000 0,00099 0,00135 0,00000 0,00000 0,00000 0,00000 0,00123 0,00000 0,00000 0,00000 0,00000 0,00000 0,00000 0,00055 0,00037 0,00000 0,00000 0,00054 0,00057 0,00018 0,00001 0,00000 0,00128 0,00018 0,00202 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,00097 0,00000 0,00034 0,00042 0,00000 2 557 51 2 9 248 30 472 45 0 0
Average Rate 0,00085 30 594 52 0 0 30 406 46 8 0
Generations 0 30 436 53 0 0 30 511 47 0 0
Years 0 30 490 54 0 0 30 425 48 0 0
29 534 55 1 329 30 413a 49 0 0
30 450 56 0 0 30 413b 50 0 0
6 444 57 5 4 746 30 594 52 0 0
30 481 58 8 0 30 436 53 0 0
30 520 59 0 0 30 490 54 0 0
24 446 60 1 749 30 450 56 0 0
30 617 61 0 0 30 481 58 8 0
30 568 62 0 0 30 520 59 0 0
30 487 63 0 0 30 617 61 0 0
17 572 64 8 1 290 30 568 62 0 0
30 640 65 0 0 30 487 63 0 0
30 492 66 0 0 30 640 65 0 0
4 565 67 2 5 388 30 492 66 0 0