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 60 Number of markers to consider
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 from "Calculator" 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 Rank 58 Net mask after adjustment
13 25 15 10 12 - 12 12 11 13 11 - 16 9 - 11 11 23 14 20 32 12 15 15 16 11 - 19 23 17 16 18 19 35 41 - 11 11 8 17 17 8 11 10 8 12 10 12 21 22 - 11 12 12 13 8 - 25 21 13 12 11 13 11 11 12 13 Modal based on current actual rank
13 25 15 10 12 - 12 12 11 13 11 - 16 9 - 11 11 23 14 20 32 12 15 15 16 11 - 19 23 17 16 18 19 - - - 11 11 8 17 17 8 11 10 8 12 10 12 21 22 - 11 12 12 13 8 - 25 21 13 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:
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 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 Another modal
13 Markers from row 3 that differ Gap
Cutoff
Reference Haplotype Archive: Delete the following examples and store your reference haplotypes here Reference Haplotype Archive: Markers
13 25 17 10 10 14 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 P Sep 2010 67
13 17 10 10 12 12 13 11 30 9 11 11 23 14 20 12 15 16 16 11 19 23 17 17 8 12 10 8 12 12 15 10 12 12 8 25 21 12 12 11 12 11 12 New P43 Definition Aug 2011 43 7 1
13 25 16 10 11 14 12 12 10 13 11 30 16 9 10 11 11 24 14 20 32 12 15 15 16 11 11 19 23 16 16 18 19 34 39 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 K Apr 2009 67
13 11 12 10 13 11 9 11 11 24 14 20 19 23 11 17 8 12 10 8 11 12 22 15 10 12 8 23 12 12 11 13 11 12 K34 34 4 1
13 25 16 10 11 14 12 12 11 13 11 29 16 9 10 11 11 23 14 20 32 12 13 15 15 11 11 19 23 17 16 18 19 35 39 14 11 11 8 17 17 8 11 10 8 12 10 12 21 22 15 10 12 12 13 8 14 25 21 13 12 11 13 11 11 12 13 N Jan 2011 67
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 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 N-Ashk Jan 2011 67
14 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 15 16 18 20 34 39 14 11 11 8 17 17 8 10 10 8 12 10 12 21 22 15 10 12 12 13 8 14 24 21 13 12 11 13 11 11 14 13 15 16 Ng Jan 2011 67
25 10 11 14 12 12 11 13 11 29 16 11 23 14 11 19 23 17 16 14 11 8 17 17 8 11 10 8 12 10 12 21 10 12 12 13 8 14 21 13 12 11 11 11 13 N45 Jan 2011 45 7 2
13 25 15 10 12 14 12 12 11 13 11 16 9 10 11 11 23 14 20 12 15 15 16 11 11 19 23 16 18 41 11 11 8 17 17 8 11 10 8 12 10 12 21 22 15 11 12 12 13 8 25 13 12 11 13 11 11 12 13 Nashk59 Jan 2011 59 5 3
14 25 10 11 14 12 12 11 13 29 16 11 11 14 20 31 12 12 15 15 11 19 23 15 18 20 34 39 14 11 8 17 17 8 10 8 12 10 12 21 15 10 12 12 13 8 14 24 21 13 12 11 13 11 11 14 15 16 Ng56 Jan 2011 56 4 9
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 N-Ashk Aug 2011 67
13 25 15 10 12 12 12 11 13 11 16 9 11 11 23 14 20 32 12 15 15 16 11 19 23 17 16 18 19 11 11 8 17 17 8 11 10 8 12 10 12 21 22 11 12 12 13 8 25 21 13 12 11 13 11 11 12 13 Nashk58 Aug 2011 58 3 2
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 0 3 3 3 3 3 0 3 3 0 3 3 3 3 3 3 3 3 3 3 3 0 3 3 3 3 3 3 0 0 0 3 3 3 3 3 3 3 3 3 3 3 3 3 3 0 3 3 3 3 3 0 3 3 3 3 3 3 3 3 3 3 3 3 3 ^  Mask with all net markers using this value
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 19 34 40 14 11 11 8 17 17 8 11 10 8 12 10 12 21 22 15 10 12 12 13 8 14 25 21 13 12 11 13 11 11 12 13 Modal for the Database on the Calculator sheet
= = 15 = 12 = = = = = = = = = = = = = = = = = 15 = 16 = = = = = = = = 35 41 - = = = = = = = = = = = = = = = 11 = = = = = = = = = = = = = = = 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 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 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 3 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