TEST File prepared August 14 2006

Using Word 2003

First chart – used cut and paste link option and pasted to WORD – then saved as htm.

Second chart – cut and paste to Word, then saved as htm.

DYS#

Kit	Name	* H a p l o	3 9 3	3 9 0	1 9	3 9 1	3 8 5 a	3 8 5 b	4 2 6	3 8 8	4 3 9	3 8 9 | 1	3 9 2	3 8 9 | 2	4 5 8	4 5 9 a	4 5 9 b	4 5 5	4 5 4	4 4 7	4 3 7	4 4 8	4 4 9	4 6 4 a	4 6 4 b	4 6 4 c	4 6 4 d	4 6 0	G A T A H 4	Y C A I I a	Y C A I I b	4 5 6	6 0 7	5 7 6	5 7 0	C D Y a	C D Y b	4 4 2	4 3 8	5 3 1	5 7 8	3 9 5 S 1 a	3 9 5 S 1 b	5 9 0	5 3 7	6 4 1	4 7 2	4 0 6 S 1	5 1 1	4 2 5	4 1 3 a	4 1 3 b	5 5 7	5 9 4	4 3 6	4 9 0	5 3 4	4 5 0	4 4 4	4 8 1	5 2 0	4 4 66 1 7 5 6 8 4 8 7 5 7 2 6 4 0 4 9 2 5 6 5
Group 1 JPL
16109		R1b1	13	22	14	11	12	13	12	12	12	13	13	30	20	9	10	11	11	26	14	19	28	15	15	17	18
23296		R1b1	13	22	14	11	12	13	12	12	12	13	13	30	20	9	10	11	11	26	15	19	28	15	15	17	18	11	11	19	23	17	15	18	17	37	38	11	12	11	9	15	16	8	10	10	8	10	10	12	20	25	16	10	12	12	16	8	13	22	20	1312 11 13 12 11 13 12
37780		R1b1	13	22	14	11	12	13	12	12	12	13	13	30	20	9	10	11	11	26	15	19	28	15	15	17	18	11	11	19	23	17	15	18	17	37	38	12	12
14935		R1b1	13	22	14	11	12	13	12	12	12	13	13	30	20	9	10	11	11	26	15	19	28	15	15	17	18	11	11	19	23	17	15	18	17	37	38	12	12	11	9	15	16	8	10	10	8	10	10	12	20	25	16	10	12	12	16	8	13	22	20	1312 11 13 12 11 13 12
19967		R1b1	13	22	14	11	12	13	12	12	12	13	13	30	21	9	10	11	11	26	15	19	28	15	15	17	18	11	11	19	23	17	15	18	18	37	38	12	12
15237		R1b1	13	22	14	11	12	13	12	12	12	13	13	31	20	9	10	11	11	26	15	19	28	15	15	17	18	11	11	19	23	17	15	17	17	37	37	12	12
Unassigned Members
22206		R1b1	13	24	14	11	10	14	12	12	13	13	13	29	17	9	10	11	11	25	15	19	29	14	15	17	18
22124		R1b1	13	24	14	11	11	14	12	12	11	13	13	31	17	9	10	11	11	24	14	19	29	15	15	15	18
N24916		-	13	25	13	11	17	17	10	12	13	12	11	29

DYS#

#	Kit	Last Name	* H a p l o	3 9 3	3 9 0	1 9	3 9 1	3 8 5 a	3 8 5 b	4 2 6	3 8 8	4 3 9	3 8 9 | 1	3 9 2	3 8 9 | 2	4 5 8	4 5 9 a	4 5 9 b	4 5 5	4 5 4	4 4 7	4 3 7	4 4 8	4 4 9	4 6 4 a	4 6 4 b	4 6 4 c	4 6 4 d	4 6 4 e	4 6 4 f	4 6 4 g	4 6 0	G A T A H 4	Y C A I I a	Y C A I I b	4 5 6	6 0 7	5 7 6	5 7 0	C D Y a	C D Y b	4 4 2	4 3 8	5 3 1	5 7 8	3 9 5 S 1 a	3 9 5 S 1 b	5 9 0	5 3 7	6 4 1	4 7 2	4 0 6 S 1	5 1 1	4 2 5	4 1 3 a	4 1 3 b	5 5 7	5 9 4	4 3 6	4 9 0	5 3 4	4 5 04 4 4 4 8 1 5 2 0 4 4 6 6 1 7 5 6 8 4 8 7 5 7 2 6 4 0 4 9 2 5 6 5
Group 1 JPL
Minimum				13	22	14	11	12	13	12	12	12	13	13	30	20	9	10	11	11	26	14	19	28	15	15	17	18	0	0	0	11	11	19	23	17	15	17	17	37	37	11	12	11	9	15	16	8	10	10	8	10	10	12	20	25	16	10	12	12	16	813 22 20 13 12 11 13 12 11 13 12
Mode				13	22	14	11	12	13	12	12	12	13	13	30	20	9	10	11	11	26	15	19	28	15	15	17	18	0	0	0	11	11	19	23	17	15	18	17	37	38	12	12	11	9	15	16	8	10	10	8	10	10	12	20	25	16	10	12	12	16	813 22 20 13 12 11 13 12 11 13 12
Median				13	22	14	11	12	13	12	12	12	13	13	30	20	9	10	11	11	26	15	19	28	15	15	17	18	0	0	0	11	11	19	23	17	15	18	17	37	38	12	12	11	9	15	16	8	10	10	8	10	10	12	20	25	16	10	12	12	16	813 22 20 13 12 11 13 12 11 13 12
Mean				13	22	14	11	12	13	12	12	12	13	13	30	20	9	10	11	11	26	15	19	28	15	15	17	18	0	0	0	11	11	19	23	17	15	18	17	37	38	12	12	11	9	15	16	8	10	10	8	10	10	12	20	25	16	10	12	12	16	813 22 20 13 12 11 13 12 11 13 12
Maximum				13	22	14	11	12	13	12	12	12	13	13	31	21	9	10	11	11	26	15	19	28	15	15	17	18	0	0	0	11	11	19	23	17	15	18	18	37	38	12	12	11	9	15	16	8	10	10	8	10	10	12	20	25	16	10	12	12	16	813 22 20 13 12 11 13 12 11 13 12
		Lenhart	R1b1	13	22	14	11	12	13	12	12	12	13	13	30	20	9	10	11	11	26	14	19	28	15	15	17	18
		Lenhart	R1b1	13	22	14	11	12	13	12	12	12	13	13	30	20	9	10	11	11	26	15	19	28	15	15	17	18				11	11	19	23	17	15	18	17	37	38	11	12	11	9	15	16	8	10	10	8	10	10	12	20	25	16	10	12	12	16	813 22 20 13 12 11 13 12 11 13
		Lenhart	R1b1	13	22	14	11	12	13	12	12	12	13	13	30	20	9	10	11	11	26	15	19	28	15	15	17	18				11	11	19	23	17	15	18	17	37	38	12	12
		Lenhart	R1b1	13	22	14	11	12	13	12	12	12	13	13	30	20	9	10	11	11	26	15	19	28	15	15	17	18				11	11	19	23	17	15	18	17	37	38	12	12	11	9	15	16	8	10	10	8	10	10	12	20	25	16	10	12	12	16	813 22 20 13 12 11 13 12 11 13
		Lenhart	R1b1	13	22	14	11	12	13	12	12	12	13	13	30	21	9	10	11	11	26	15	19	28	15	15	17	18				11	11	19	23	17	15	18	18	37	38	12	12
		Lenhart	R1b1	13	22	14	11	12	13	12	12	12	13	13	31	20	9	10	11	11	26	15	19	28	15	15	17	18				11	11	19	23	17	15	17	17	37	37	12	12
Not Grouped
		Lenhardt	-	13	25	13	11	17	17	10	12	13	12	11	29
		Linhart	R1b1	13	24	14	11	10	14	12	12	13	13	13	29	17	9	10	11	11	25	15	19	29	14	15	17	18
		Anon	R1b1	13	24	14	11	11	14	12	12	11	13	13	31	17	9	10	11	11	24	14	19	29	15	15	15	18

-10

-9

-8

-7

-6

-5

-4

-3

-2

-1

Color Key for Stepwise Deviation from Modal

+1

+2

+3

+4

+5

+6

+7

+8

+9

+10

The page display above was inspired by Jason Cleary who devised a colorization scheme to make observation of the differences between samples easy and efficient.  He graciously supplied Family Tree DNA his colorization code which was modified in house to support our sub grouping system.
Family Tree DNA thanks Jason for the time he spent pioneering this system for the benefit of our group administrators and project members.