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 15 10 12 14 12 12 11 13 11 29 16 9 10 11 11 23 14 20 32 12 15 15 16 11 11 19 23 17 16 18 19 35 41 13 11 11 8 17 17 8 11 10 8 12 10 12 21 22 15 11 12 12 13 8 14 25 21 13 12 11 13 11 11 12 13 0 0 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 15 10 12 14 12 12 11 13 11 29 16 9 10 11 11 23 14 20 32 12 15 15 16 11 11 19 23 17 16 18 19 35 41 12 11 11 8 17 17 8 11 10 8 12 10 12 21 22 15 11 12 12 13 8 14 25 21 13 12 11 13 11 11 12 13 0 0 0 Modal - from data below on this sheet 16
13 25 15 10 12 14 12 12 11 13 11 29 16 9 9,8 11 11 23 14 20 32 12 15 15 16 11 11 19 23 17 16 18 19 35 40 13 11 11 8 17 17 8 11 10 8 12 10 12 21 22 15 11 12 12 13 8 14 25 21 13 12 11 13 11 11 12 13 0 0 0 Average 16
13 25 15 10 12 14 12 12 11 13 11 29 16 9 10 11 11 23 14 20 32 12 15 15 16 11 11 19 23 17 16 18 19 35 41 13 11 11 8 17 17 8 11 10 8 12 10 12 21 22 15 11 12 12 13 8 14 25 21 13 12 11 13 11 11 12 13 0 0 0 Median 16
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 1 0,3 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Discrepancies - Current vs Average if all 4 are not the same
1 1 1 1 1 0 1 1 1 1 1 0 1 1 0 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 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 28 82 6 79 86 85 70 76 85 71 68 81 65 86 82 72 87 82 44 74 30 71 28 64 68 86 77 51 68 49 35 30 8 22 84 76 87 85 86 87 78 84 87 73 81 85 75 81 73 4 87 86 73 87 66 62 80 74 86 85 82 84 87 84 74 0 0 0 Count of this modal value, "Calculator"
0,9 0,8 0,3 0,9 0,1 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,3 0,8 0,3 0,7 0,8 1,0 0,9 0,6 0,8 0,6 0,4 0,3 0,1 0,3 1,0 0,9 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,0 1,0 1,0 0,8 1,0 0,8 0,7 0,9 0,9 1,0 1,0 0,9 1,0 1,0 1,0 0,9 2,0 2,0 2,0 Fraction
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 0 0 0 Count of samples that have this marker, this sheet
4 4 3 4 4 3 4 4 4 4 4 3 4 4 3 4 4 4 4 4 3 4 4 4 4 4 3 4 4 3 4 3 3 3 2 1 4 4 4 4 4 4 4 4 4 4 4 4 4 4 3 4 4 4 4 4 3 3 4 4 4 4 4 4 4 4 4 0 0 0 Count of this modal value , this sheet
1,0 1,0 0,8 1,0 1,0 0,8 1,0 1,0 1,0 1,0 1,0 0,8 1,0 1,0 0,8 1,0 1,0 1,0 1,0 1,0 0,8 1,0 1,0 1,0 1,0 1,0 0,8 1,0 1,0 0,8 1,0 0,8 0,8 0,8 0,5 0,3 1,0 1,0 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 1,0 1,0 0,8 0,8 1,0 1,0 1,0 1,0 1,0 1,0 1,0 1,0 1,0 0,0 0,0 0,0 Fraction User does not adjust these cells.  Adjust the number of markers on the Calculator sheet
1,1 1,2 1,3 1,1 14,5 0,5 1,0 1,0 1,2 1,1 1,0 0,5 1,3 1,1 0,6 1,0 1,1 1,2 1,0 1,1 0,8 1,2 2,9 1,2 3,1 1,4 0,5 1,0 1,1 0,7 1,3 0,7 1,0 1,2 1,4 0,1 1,0 1,1 1,0 1,0 1,0 1,0 1,1 1,0 1,0 1,2 1,1 1,0 1,2 1,1 0,5 21,8 1,0 1,0 1,2 1,0 0,6 0,6 1,1 1,2 1,0 1,0 1,1 1,0 1,0 1,0 1,2 0,0 0,0 0,0 Concentration 60 Number of markers to consider
26 10 7 30 2 66 44 39 10 21 39 64 8 26 61 44 30 14 50 30 57 17 4 12 3 5 63 44 23 59 8 58 34 13 5 67 35 21 50 39 44 50 24 35 50 15 26 39 20 26 65 1 50 44 15 50 62 60 25 17 44 39 30 35 50 35 17 Rank 60 Ranking actually used for the mask
26 10 7 30 2 - 44 39 10 21 39 - 8 26 - 44 30 14 50 30 57 17 4 12 3 5 - 44 23 59 8 58 34 13 5 - 35 21 50 39 44 50 24 35 50 15 26 39 20 26 - 1 50 44 15 50 - 60 25 17 44 39 30 35 50 35 17 Best Ranked Signature 58 Net mask after adjustment
1 1 1 1 1 0 1 1 1 1 1 0 1 1 0 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 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 Assignment ↓ M458 59 67 60 59 58 389b
13 25 15 10 12 14 12 12 11 13 11 29 16 9 10 11 11 23 14 20 32 12 15 15 16 11 11 19 23 17 16 18 18 35 41 14 11 11 8 17 17 8 11 10 8 12 10 12 21 22 15 11 12 12 13 8 14 25 21 13 12 11 13 11 11 12 13 1310 N11424 Yosel Mikhel Light, b.c.1817, Lithuania Lithuania Nca 0 2 1 1 1 16
13 25 15 10 12 14 12 12 11 13 11 29 16 9 10 11 11 23 14 20 32 12 15 15 16 11 11 19 23 16 16 17 19 35 41 12 11 11 8 17 17 8 11 10 8 12 10 12 21 22 15 11 12 12 13 8 14 25 21 13 12 11 13 11 11 12 13 1309 N37111 Michal Tuszynski, b.1933, Srem, Poland Poland Nca 1 3 2 2 2 16
13 25 16 10 12 14 12 12 11 13 11 30 16 9 10 11 11 23 14 20 31 12 15 15 16 11 10 19 23 17 16 18 19 34 42 13 11 11 8 17 17 8 11 10 8 12 10 12 21 22 15 11 12 12 13 8 13 25 21 13 12 11 13 11 11 12 13 1311 171767 Mordechai Birnbach, 1856 - 1915, Sokolow Malopolsk Poland Nca 3 7 3 2 2 17
13 25 15 10 12 15 12 12 11 13 11 29 16 9 9 11 11 23 14 20 32 12 15 15 16 11 11 19 23 17 16 18 19 35 36 12 11 11 8 17 17 8 11 10 8 12 10 12 21 22 16 11 12 12 13 8 14 23 21 13 12 11 13 11 11 12 13 1344 N91823 Harry Zvi Margolis, ca 1913, Luchinets, Ukraine Ukraine Nca + 10 11 3 3 2 16
1306 109321 Feodor Holodilov, b.c. abt 1855, Perm, Russia Russian Federation N + 4 7 6 5 5  
1305 64924 Anton Antiporuk, b. 1888, Kobryn, Belarus Belarus N + 4 8 5 5 5  
1361 51291 Stephen Kosowsky, b.c.1887, Galicia, Ukraine Ukraine N 10 11 5 5 5  
1328 122983 Piotr Wasowski, b.c. 1858, Sablino, St. Petersburg Poland N 8 8 6 6 6  
1333 183255 Lithuania N + 10 12 6 6 6  
1338 5693 Hudak c 1722 Slovakia N + 9 12 6 6 6