Type Rank, Mode, etc Peter Gwozdz Click Sheet "TypeDoc" for instructions Be careful not to delete column DE when deleting old data below row 20 on this sheet ` Be careful not to delete column DE when deleting old data below row 20 on this sheet 389-2 calculation column
Enter the type data below row 20.  If no type data is available, enter the initial modal in row 21, and delete all data below row 21.  The modal function fails if a marker has no value with at least 2 samples at that value. Be careful not to paste anything over this
13 25 16 10 11 14 12 12 11 13 11 29 16 9 10 11 11 23 14 20 32 12 12 15 15 11 11 19 23 17 16 18 18 35 40 13 11 12 8 17 17 8 11 10 8 12 10 12 21 22 15 10 12 12 13 8 14 25 21 12 12 11 13 11 11 12 13 15 16 0 Current modal - a copy from the "Calculator" sheet 16
Use this row to construct a new modal with adjustments.  Do not type in the rows with formulae
13 25 16 10 11 14 12 12 11 13 11 29 16 9 10 11 11 23 14 20 32 12 12 15 15 11 11 19 23 18 16 18 18 35 40 13 11 12 8 17 17 8 11 10 8 12 10 12 21 22 15 10 12 12 13 8 14 25 21 12 12 11 13 11 11 12 13 15 16 0 Modal - from data below on this sheet 16
13 25 16 10 11 14 12 12 11 13 11 29 16 9 10 11 11 23 14 20 32 12 12 15 15 11 11 19 22 17 16 18 18 35 40 13 11 12 8 17 17 8 11 10 8 12 10 12 21 22 15 10 12 12 13 8 14 25 21 12 12 11 13 11 11 12 13 15 16 0 Average 16
13 25 16 10 11 14 12 12 11 13 11 29 16 9 10 11 11 23 14 20 32 12 12 15 15 11 11 19 23 17 16 18 18 35 40 13 11 12 8 17 17 8 11 10 8 12 10 12 21 22 15 10 12 12 13 8 14 25 21 12 12 11 13 11 11 12 13 15 16 0 Median 16
- - - - - - - - - - - - - - - - - - - - - - - - - - - - 0,7 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Discrepancies - Current vs Average if all 4 are not the same
1 0 0 1 1 1 1 0 0 1 1 1 0 1 1 1 0 0 1 1 0 1 1 1 1 0 0 0 0 0 1 1 1 0 0 1 1 1 1 0 1 1 1 1 1 0 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 0 Net mask markers after adjustment
87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 87 54 52 2 Count of samples that have this marker, from "Calculator" data
81 70 55 82 80 79 86 85 70 76 85 71 68 81 65 86 82 72 87 82 44 74 41 71 54 64 68 86 77 51 68 49 29 30 20 22 84 10 87 85 86 87 78 84 87 73 81 85 75 81 73 82 87 86 73 87 66 62 80 9 86 85 82 84 87 84 74 44 46 0 Count of this modal value, "Calculator"
0,9 0,8 0,6 0,9 0,9 0,9 1,0 1,0 0,8 0,9 1,0 0,8 0,8 0,9 0,7 1,0 0,9 0,8 1,0 0,9 0,5 0,9 0,5 0,8 0,6 0,7 0,8 1,0 0,9 0,6 0,8 0,6 0,3 0,3 0,2 0,3 1,0 0,1 1,0 1,0 1,0 1,0 0,9 1,0 1,0 0,8 0,9 1,0 0,9 0,9 0,8 0,9 1,0 1,0 0,8 1,0 0,8 0,7 0,9 0,1 1,0 1,0 0,9 1,0 1,0 1,0 0,9 0,8 0,9 2,0 Fraction
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 6 6 6 6 6 6 6 6 6 6 6 0 Count of samples that have this marker, this sheet
6 5 4 6 6 6 6 5 4 6 6 6 5 6 6 6 4 5 6 6 3 6 6 6 6 5 5 6 4 2 6 6 6 4 2 5 6 4 6 5 6 6 6 6 6 5 6 6 6 5 6 6 6 6 6 6 6 6 6 6 6 6 5 6 6 6 4 6 6 0 Count of this modal value , this sheet
1,0 0,8 0,7 1,0 1,0 1,0 1,0 0,8 0,7 1,0 1,0 1,0 0,8 1,0 1,0 1,0 0,7 0,8 1,0 1,0 0,5 1,0 1,0 1,0 1,0 0,8 0,8 1,0 0,7 0,3 1,0 1,0 1,0 0,7 0,3 0,8 1,0 0,7 1,0 0,8 1,0 1,0 1,0 1,0 1,0 0,8 1,0 1,0 1,0 0,8 1,0 1,0 1,0 1,0 1,0 1,0 1,0 1,0 1,0 1,0 1,0 1,0 0,8 1,0 1,0 1,0 0,7 1,0 1,0 0,0 Fraction User does not adjust these cells.  Adjust the number of markers on the Calculator sheet
1,1 0,7 0,5 1,1 1,1 1,1 1,0 0,6 0,4 1,1 1,0 1,2 0,7 1,1 1,3 1,0 0,3 0,7 1,0 1,1 0,2 1,2 2,1 1,2 1,6 0,8 0,7 1,0 0,3 0,1 1,3 1,8 3,0 0,9 0,2 2,3 1,0 2,6 1,0 0,6 1,0 1,0 1,1 1,0 1,0 0,7 1,1 1,0 1,2 0,6 1,2 1,1 1,0 1,0 1,2 1,0 1,3 1,4 1,1 9,7 1,0 1,0 0,6 1,0 1,0 1,0 0,3 1,2 1,1 0,0 Concentration 47 Number of markers to consider
23 53 60 26 21 20 36 58 61 18 33 12 51 23 9 36 64 54 42 26 65 16 5 12 7 50 51 36 63 67 11 6 2 49 66 4 29 3 42 58 36 42 19 29 42 55 23 33 17 56 14 26 42 36 14 42 10 8 21 1 36 33 57 29 42 29 62 Rank 48 Ranking actually used for the mask
23 - - 26 21 20 36 - - 18 33 12 - 23 9 36 - - 42 26 - 16 5 12 7 - - 36 - - 11 6 2 - - 4 29 3 42 - 36 42 19 29 42 - 23 33 17 - 14 26 42 36 14 42 10 8 21 1 36 33 - 29 42 29 - Best Ranked Signature 47 Net mask after adjustment
1 0 0 1 1 1 1 0 0 1 1 1 0 1 1 1 0 0 1 1 0 1 1 1 1 0 0 1 0 0 1 1 1 0 0 1 1 1 1 0 1 1 1 1 1 0 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 0 Mask markers with ranking Be careful not to delete this column
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 464e 464f 464g < DYS Prior Assignment ↓ M458 L260 67 53 48 47 389b
13 25 16 10 11 14 12 12 11 13 11 29 16 9 10 11 12 23 14 20 32 12 12 15 15 11 11 19 21 18 16 18 18 35 40 13 11 12 8 17 17 8 11 10 8 12 10 12 21 22 15 10 12 12 13 8 14 25 21 12 12 11 13 11 11 12 13 15 16 1363 169127 Hendrik Venter,ca 1663-1713, Hamel, France France N 3 0 0 0 16
13 25 16 10 11 14 12 12 11 13 11 29 16 9 10 11 12 23 14 20 32 12 12 15 15 11 11 19 21 18 16 18 18 35 40 13 11 12 8 16 17 8 11 10 8 12 10 12 21 22 15 10 12 12 13 8 14 25 21 12 12 11 13 11 11 12 13 15 16 1362 73298 Heinrich Conrad von Dempter, b.1663, Hamelin, Germ Germany N + 4 0 0 0 16
13 26 16 10 11 14 12 13 11 13 11 29 16 9 10 11 11 23 14 20 31 12 12 15 15 12 11 19 23 16 16 18 18 34 41 13 11 12 8 17 17 8 11 10 8 12 10 12 21 22 15 10 12 12 13 8 14 25 21 12 12 11 13 11 11 12 13 15 16 1304 128709 Adam Roeder, 1841, Bavaria, Germany Germany NB 7 3 1 0 16
13 25 16 10 11 14 12 12 11 13 11 29 16 9 10 11 11 23 14 20 31 12 12 15 15 11 11 19 23 17 16 18 18 34 41 13 11 11 8 17 17 8 11 10 8 12 10 12 21 22 15 10 12 12 13 8 14 25 21 12 12 11 13 11 11 12 13 15 16 1354 206664 Lithuania N 4 2 2 1 16
13 25 17 10 11 14 12 12 12 13 11 29 16 9 10 11 11 23 14 20 32 12 12 15 15 11 10 19 23 16 16 18 18 35 39 13 11 11 8 17 17 8 11 10 8 12 10 12 21 21 15 10 12 12 13 8 14 25 21 12 12 11 14 11 11 12 12 15 16 1385 N61170 Piotr z Kleczkowa Kleczkowski, ca. 1340-1422, Klec Poland N + - 9 2 1 1 16
13 25 15 10 11 14 12 12 12 13 11 29 17 9 10 11 11 24 14 20 33 12 12 15 15 11 11 19 23 17 16 18 18 35 38 12 11 12 8 17 17 8 11 10 8 14 10 12 21 22 15 10 12 12 13 8 14 25 21 12 12 11 13 11 11 12 12 15 16 1340 N54385 Edward Bauml, b.c.1830, Raj/Ray, Ukraine Ukraine N + 11 3 1 1 16
1328 122983 Piotr Wasowski, b.c. 1858, Sablino, St. Petersburg Poland N 7 4 4 4  
1331 152733 Ukraine Ukraine N 8 6 5 5  
1329 128120 Wladyslaw Leszczynski Roy, 1682-1762, Lesznia Poland N + 10 6 6 5  
1376 81980 William August Selke, Bialogard/Belgaard, Pommern Poland N + 11 5 5 5  
1380 N84792 Michael Wawrzyniak 9/29/1864 - 6/27/1940, Poland Poland N 12 7 6 5  
1389 147315 Truszkowski, Truszki Kucze, PL Poland N + 12 7 5 5  
1291 137561 Poland Poland NB 14 8 7 5