Haplotypes User does not adjust these cells.  Adjust the number of markers on the Calculator sheet
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 62 Number of markers to consider
13 25 17 11 11 14 12 12 10 13 11 31 14 9 10 11 11 24 14 20 32 13 15 15 16 11 12 19 23 15 16 18 19 35 40 14 11 11 9 17 17 8 12 10 8 11 10 12 22 22 15 10 12 12 13 8 14 23 21 12 12 11 13 11 11 12 13 0 0 0 Current Modal from "Calculator" 62 Ranking actually used for the mask
13 57 3 37 55 5 19 25 10 6 25 62 2 25 52 25 19 43 25 44 56 4 38 39 24 18 - 13 50 - 49 - - 59 - 53 25 45 1 11 19 46 61 25 25 58 41 25 8 25 41 19 46 46 51 25 60 9 6 40 13 13 19 12 13 25 54 Rank 62 Net mask after adjustment
13 25 17 11 11 14 12 12 10 13 11 31 14 9 10 11 11 24 14 20 32 13 15 15 16 11 - 19 23 - 16 - - 35 - 14 11 11 9 17 17 8 12 10 8 11 10 12 22 22 15 10 12 12 13 8 14 23 21 12 12 11 13 11 11 12 13 Modal based on current actual rank
13 25 17 11 11 14 12 12 10 13 11 31 14 9 10 11 11 24 14 20 32 13 15 15 16 11 - 19 23 - 16 - - 35 - 14 11 11 9 17 17 8 12 10 8 11 10 12 22 22 15 10 12 12 13 8 14 23 21 12 12 11 13 11 11 12 13 0 0 0 Modal based on net rank, row 12 on the "Calculator" sheet
Either modal from the 2 rows above can be copied elsewhere;  use "Edit, Paste Special, Values" and delete the dashes
To compare the current modal haplotype to another, copy that other into the following row;  the differences are highlighted on the next row:
14 25 17 10 10 13 12 12 10 13 11 30 16 9 10 11 11 23 14 20 31 12 15 16 16 11 11 19 23 16 16 18 19 34 39 13 11 11 8 17 17 8 12 10 8 12 10 12 22 22 15 10 12 12 13 8 14 25 21 12 12 11 13 12 11 12 13 Another modal
13 11 11 14 31 14 24 32 13 15 12 15 35 40 14 9 11 23 11 Markers from row 3 that differ
Reference Haplotype Archive: Delete the following examples and store your reference haplotypes here Reference Haplotype Archive: Markers
13 25 17 11 11 14 12 12 10 13 11 30 14 9 10 11 11 24 14 20 33 13 15 15 16 11 12 19 23 15 16 19 19 35 38 14 11 11 9 17 17 8 12 10 8 11 10 12 22 22 15 10 12 12 13 8 13 23 21 12 12 11 13 11 11 12 13 I type from 2009 67
13 17 11 11 12 12 10 13 11 14 9 10 11 11 24 14 20 13 15 15 16 11 12 19 23 15 16 19 14 11 11 9 17 17 8 12 10 8 11 10 12 22 22 15 10 12 12 13 8 23 21 12 12 11 13 11 11 12 13 I59 Definition 59
13 25 16 11 11 15 12 12 10 14 11 31 15 9 9 11 11 24 14 20 33 13 15 15 16 11 12 19 23 15 16 13 19 34 38 14 11 11 8 16 17 8 12 10 8 11 10 12 22 22 15 10 12 12 14 8 14 23 21 12 12 11 13 11 11 12 13 Ia type and Ia67 Definition 67
13 26 17 11 11 13 12 12 11 13 11 30 15 9 10 11 11 24 14 20 33 13 15 15 16 11 12 19 23 16 16 17 19 36 37 15 11 11 8 17 17 8 12 10 8 11 10 12 22 22 15 10 12 12 13 8 14 23 20 12 12 11 13 11 11 12 13 Ib type 67
13 26 17 11 13 12 12 11 13 11 15 9 10 11 11 14 20 11 19 23 16 19 36 15 11 11 8 17 8 12 10 8 11 10 12 22 22 10 12 12 13 8 20 12 12 11 13 11 11 12 13 Ib51 Definition 51
13 25 17 11 11 14 12 12 10 13 11 31 14 9 10 11 11 24 14 20 32 13 15 15 16 11 12 19 23 15 16 18 19 35 40 14 11 11 9 17 17 8 12 10 8 11 10 12 22 22 15 10 12 12 13 8 14 23 21 12 12 11 13 11 11 12 13 I type new Aug 2011 67
13 25 17 11 11 14 12 12 10 13 11 31 14 9 10 11 11 24 14 20 32 13 15 15 16 11 19 23 16 35 14 11 11 9 17 17 8 12 10 8 11 10 12 22 22 15 10 12 12 13 8 14 23 21 12 12 11 13 11 11 12 13 New I62 Definition Aug 2011 62
Masks
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
Any mask can be copied elsewhere;  use "Edit, Paste Special, Values" and delete the dashes 3 < Mask value for all markers
3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 0 3 3 0 3 0 0 3 0 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 ^  Mask with all net markers using this value
13 25 16 11 11 14 12 12 10 13 11 30 15 9 10 11 11 24 14 20 32 13 15 15 16 11 11 19 23 16 16 18 19 35 38 14 11 11 8 17 17 8 12 10 8 11 10 12 22 22 15 10 12 12 13 8 14 23 21 12 12 11 13 11 11 12 13 Modal for the Database on the Calculator sheet
= = 17 = = = = = = = = 31 14 = = = = = = = = = = = = = - = = - = = = = - = = = 9 = = = = = = = = = = = = = = = = = = = = = = = = = = = = Signature - Nonmodal markers (ranked) for the current modal in row 3 of the Calculator
Haplotype with high ranked non modal markers is in the row above.  Equal values have equal =, comparing database modal (previous row) to the proposed type modal in Row 3 (a copy from the Calculator).  Ranking from TypeRank.  Low ranked non modals have dash -.
0 0 3 0 0 0 0 0 0 0 0 3 3 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 3 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 Mask for the signature, using the value above
Reference Mask Archive: Delete the following examples and store your reference masks here Reference Mask Archive: Markers
4 4 4 4 4 4 4 4 4 4 4 4 M12 12
4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 6 4 4 4 4 M25 25
4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 6 4 4 4 4 4 4 4 4 4 4 5 4 6 6 4 4 M37 37
4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 6 4 4 4 4 4 4 4 4 4 4 5 4 6 6 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 6 4 4 4 4 4 4 4 4 4 4 4 4 M67 My default mask 67