2013.06.22 Spreadsheet of J. Wexler's Matches (Deviations)


1	R1a1a Ashkenazi Levite Spreadsheet - J. Wexler's Closest Matches - Markers with Deviations Only - 6.22.2013	Steps at 67	DYS393	DYS19**	DYS389II	DYS458	DYS459b	DYS449	DYS464a	DYS464b	DYS464c	DYS460	DYS607	DYS576	DYS570	CDYa	CDYb	DYS537	DYS557	DYS444	DYS481	DYS446	DYS487
2	Marker No.		1	3	12	13	15	21	22	23	24	26	31	32	33	34	35	43	51	57	58	60	63
3	Mode		13	16	30	14	10	30	12	12	15	11	16	19	20	35	38	12	15	14	23	12	13
4	Mutation Rates per gen. from Family Tree DNA*		0.00076	0.00151	0.00242	0.00814	0.00132	0.00838	0.00566	0.00566	0.00566	0.00402	0.00411	0.01022	0.0079	0.03531	0.03531	0.00057	0.00321	0.00321	0.00544	0.00365	0.00097
5	FTDNA Slow to Fast Rank Order		24	34	43	62	32	64	56	57	58	52	53	65	61	66	67	23	49	48	55	51	26
6	FTDNA Speed of Mutations		Slow	Medium	Medium	Fast	Medium	Fast	Fast	Fast	Fast	Fast	Fast	Fast	Fast	Fast	Fast	Slow	Medium	Medium	Fast	Fast	Slow
7	Mutation Rates per gen. from Burgarella et al.**		0.000368	0.00097	0.000767	0.001503		0.003254				0.000288	0.001481	0.001256	0.001264			0.000124	0.00126	0.000323	0.005272	0.000857	0.00021
8	Burgarella et al. Slow to Fast Rank Order		26	37	33	47		49				21	45	41	43			7	42	23	50	36	14	FTDNA TiP Reports			Y Utility			Janzen
9																								50%	75%	95%	50%	75%	95%
10	241703 - Wexler - Salamon Wexler (@1768 - @1845), Klobuck, Poland	0	13	16	30	15	10	31	12	12	15	12	17	20	21	35	38	11	15	14	23	13	13	--	--	--	--	--	--	--
11	220657 - Czerwick - Franciszek Czerwik, b.c. 1796, Bargly, Poland	3	13	16	30	14	10	30	12	12	15	12	17	20	21	34	38	11	15	14	23	13	13	7	10	15	8	10	23	<6.07
12	291 - Gann - Shloma Gen, ca 1800, Lithuania	4	13	16	30	14	10	30	12	12	15	12	17	19	21	35	38	11	15	14	23	13	13	9	11	17	10	13	27	<6.07
13	208320 - Bliss - Samuel Jaffe	4	13	16	30	14	10	30	12	12	15	11	17	19	21	35	38	11	15	15	23	13	13	9	12	17	10	13	27	<6.07
14	40651 - Phillips - Moses Phillips, b. abt 1787, London, England	5	12	16	30	14	10	30	12	12	15	11	17	19	21	35	38	11	15	14	23	13	13	11	14	20	12	15	31	6.07
15	9602 - Mordecai G.	5	13	16	31	14	10	30	12	12	15	11	17	19	21	35	38	11	15	15	23	13	13	11	14	20	12	15	31	6.07
16	175107 - Kowalsky - Itsik Kovalsky, Utena Lithuania abt. 1775	6	13	16	30	14	10	30	12	12	15	10	17	19	21	35	38	11	16	14	23	13	13	11	14	20	12	15	31	9.91
17	N107659 - Schiff - Yekutiel Zusia ha levy Schiff, b. 1850 and d. 1922	6	13	16	30	14	10	29	12	12	15	11	17	20	20	35	39	11	15	14	23	13	13	11	15	21	12	15	31	9.91
18	107789 - Graff - Emil Graff, b.1873, Miskolc, Hungary(Levite)	6	13	16	29	14	11	30	12	12	15	12	16	20	21	35	38	11	15	14	23	12	13	12	16	22	14	18	35	9.91
19	227160 - Muller - Hermann Muller, 1854-1927	7	13	16	30	14	11	30	12	12	15	11	16	19	21	35	38	11	15	14	23	12	13	15	19	>24	16	20	40	13.08
20	133746 - Marx - Wolf Marx,1745, Grosseicholzheim, Germany	7	13	16	30	14	10	31	12	12	15	11	16	19	20	35	38	11	15	14	23	12	12	15	19	>24	16	20	40	13.08
21	N55713 - Segil - Segal/Segil Tryskiai, Siauliai,Kaunas, Lith. c1790	7	13	16	30	15	10	30	12	12	15	12	16	20	19	35	38	12	15	14	24	12	13	12	16	22	14	18	35	13.08
22	63501 - Greenberg - Hirchel David Greenberg, Poland	7	13	16	30	14	11	31	12	12	15	11	16	20	20	35	38	12	15	14	23	12	13	14	18	>24	16	20	40	13.08
23	110775 - no ancestor identified - Unknown Origin	8	13	16	30	14	10	30	12	12	15	11	16	18	21	35	38	12	15	14	23	12	13	N/A		N/A	16	20	40	13.26
24	N103033 - Christmann - JP Christmann*1726 Silesia -1798	8	13	15	29	14	11	31	12	12	15	11	16	19	21	35	38	11	15	14	23	12	13	N/A		N/A	18	23	44	13.26
25	21282 - Howards - Unknown Origin	8	13	16	30	14	11	30	12	12	15	11	17	18	21	34	38	11	15	14	23	12	13	N/A		N/A	16	20	40	13.26
26	130105 - no ancestor or country identified	8	13	16	30	14	10	30	12	12	15	11	16	19	20	34	38	11	15	14	23	12	13	N/A		N/A	18	23	44	13.26
27	213421 - Sacks - Jurbarkas, Lithuania	8	13	16	29	14	11	30	12	12	15	11	16	19	21	35	38	11	15	14	23	12	13	N/A		N/A	18	20	44	13.26
28	139616 - Gordon - Yossel Halevi Gordon b 1871 Minsk, Belarus	8	13	16	30	14	11	31	12	12	15	11	16	19	21	35	39	11	15	13	23	12	13	N/A		N/A	18	23	44	13.26
29	190924 - Garbarz - Mejer Halevi Garbarz, born C1750	8	13	16	30	14	10	30	12	12	15	11	16	19	20	35	38	12	15	14	23	12	13	N/A		N/A	18	23	44	13.26
30	95663 - Cornbleet - Asher-Zelik Korenblit	8	13	16	30	14	10	30	12	12	15	11	16	19	21	36	38	12	15	14	23	12	13	N/A		N/A	18	23	44	13.26
31


1	J. Wexler TiP Reports -- matches at 67 markers	No. of Generations
2		4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24
3	241703 - Wexler - Salamon Wexler (@1768 - @1845), Klobuck, Poland	--		--		--		--		--		--		--		--		--		--		--
4	220657 - Czerwick - Franciszek Czerwik, b.c. 1796, Bargly, Poland	20.74%	32.01%	43.59%	54.53%	64.25%	72.48%	79.21%	84.55%	88.67%	91.80%	94.13%	95.84%	97.08%	97.96%	98.59%	99.03%	99.34%	99.55%	99.69%	99.79%	99.86%
5	291 - Gann - Shloma Gen, ca 1800, Lithuania	9.08%	16.64%	25.88%	36.01%	46.21%	55.87%	64.57%	72.10%	78.41%	83.55%	87.64%	90.83%	93.27%	95.11%	96.48%	97.49%	98.22%	98.75%	99.13%	99.40%	99.58%
6	208320 - Bliss - Samuel Jaffe	8.93%	16.38%	25.54%	35.59%	45.74%	55.39%	64.10%	71.66%	78.02%	83.21%	87.35%	90.59%	93.07%	94.96%	96.36%	97.40%	98.15%	98.70%	99.09%	99.37%	99.56%
7	40651 - Phillips - Moses Phillips, b. abt 1787, London, England	3.18%	7.03%	12.71%	20.01%	28.45%	37.48%	46.56%	55.25%	63.22%	70.29%	76.37%	81.48%	85.67%	89.05%	91.72%	93.81%	95.41%	96.62%	97.54%	98.22%	98.72%
8	Mordecai G.	3.11%	6.90%	12.50%	19.70%	28.06%	37.03%	46.08%	54.75%	62.73%	69.83%	75.95%	81.10%	85.35%	88.77%	91.49%	93.62%	95.26%	96.50%	97.44%	98.15%	98.66%
9	175107 - Kowalsky - Itsik Kovalsky, Utena Lithuania abt. 1775	3.17%	7.01%	12.69%	19.98%	28.41%	37.43%	46.51%	55.19%	63.17%	70.24%	76.33%	81.44%	85.64%	89.02%	91.70%	93.79%	95.39%	96.61%	97.53%	98.21%	98.71%
10	N107659 - Schiff - Yekutiel Zusia ha levy Schiff, b. 1850 and d. 1922	2.66%	5.98%	10.98%	17.54%	25.30%	33.77%	42.49%	51.00%	59.00%	66.25%	72.63%	78.11%	82.71%	86.50%	89.57%	92.02%	93.95%	95.45%	96.61%	97.49%	98.15%
11	107789 - Graff - Emil Graff, b.1873, Miskolc, Hungary(Levite)	1.10%	2.92%	6.12%	10.85%	17.05%	24.44%	32.60%	41.11%	49.53%	57.54%	64.88%	71.41%	77.07%	81.85%	85.82%	89.05%	91.64%	93.68%	95.26%	96.48%	97.41%
12	227160 - Muller - Hermann Muller, 1854-1927	0.25%	0.83%	2.07%	4.25%	7.57%	12.08%	17.73%	24.30%	31.53%	39.10%	46.71%	54.09%	61.03%	67.38%	73.05%	78.00%	82.25%	85.84%	88.81%	91.25%	93.21%
13	133746 - Marx - Wolf Marx,1745, Grosseicholzheim, Germany	0.26%	0.86%	2.14%	4.38%	7.77%	12.39%	18.13%	24.81%	32.12%	39.76%	47.41%	54.81%	61.74%	68.06%	73.68%	78.59%	82.78%	86.30%	89.21%	91.58%	93.49%
14	N55713 - Segil - Segal/Segil Tryskiai, Siauliai,Kaunas, Lith. c1790	1.06%	2.83%	5.95%	10.59%	16.67%	23.95%	32.02%	40.45%	48.83%	56.83%	64.19%	70.76%	76.47%	81.32%	85.36%	88.65%	91.30%	93.40%	95.04%	96.30%	97.26%
15	63501 - Greenberg - Hirchel David Greenberg, Poland	0.31%	1.01%	2.48%	5.01%	8.80%	13.88%	20.11%	27.23%	34.93%	42.84%	50.65%	58.08%	64.94%	71.11%	76.51%	81.14%	85.04%	88.27%	90.89%	93.00%	94.67%
16	110775 - no ancestor identified - Unknown Origin	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A		N/A		N/A		N/A		N/A		N/A
17	N103033 - Christmann - JP Christmann*1726 Silesia -1798	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A		N/A		N/A		N/A		N/A		N/A
18	21282 - Howards - Unknown Origin	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A		N/A		N/A		N/A		N/A		N/A
19	130105 - no ancestor or country identified	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A		N/A		N/A		N/A		N/A		N/A
20	213421 - Sacks - Jurbarkas, Lithuania	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A		N/A		N/A		N/A		N/A		N/A
21	139616 - Gordon - Yossel Halevi Gordon b 1871 Minsk, Belarus	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A		N/A		N/A		N/A		N/A		N/A
22	190924 - Garbarz - Mejer Halevi Garbarz, born C1750	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A		N/A		N/A		N/A		N/A		N/A
23	95663 - Cornbleet - Asher-Zelik Korenblit	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A		N/A		N/A		N/A		N/A		N/A
24


1	Janzen Spreadsheet Calculations for Time to MRCA for J. Wexler and All Matches
2			12 markers		37 markers		67 markers
3		No. compared	Gen	Years	Gen	Years	Gen	Years
4	5 steps or less	6	12.38	371.53	6.25	187.65	6.07	182.05
5	6 steps or less	9	14.31	429.32	10.17	305.12	9.91	297.22
6	7 steps or less	13	10.02	300.74	12.22	366.57	13.08	392.54
7	8 steps or less	20	12.13	363.94	12.53	375.85	13.26	397.91
8	9 steps or less	39	14.13	423.82	13.59	407.68	14.97	449.06
9	10 steps or less	64	21.32	639.69	16.17	485.12	16.96	508.81
10	11 steps or less	94	23.15	694.48	17.85	535.39	18.92	567.72
11	12 steps or less	116	24.7	740.91	19.97	598.97	20.86	625.76
12	13 steps or less	130	25.63	768.86	22.42	672.57	23.13	693.78
13	14 steps or less	147	25.93	777.9	24.16	724.91	25.03	751.05
14	15 steps or less	154	26.87	806.07	25.43	762.91	26.31	789.16
15	16 steps or less	158	26.33	789.94	26.64	799.31	27.54	826.02
16	17 steps or less	162	26.53	795.95	29.1	872.98	29.54	886.34
17	18 steps or less	164	26.96	808.93	30.42	912.68	30.7	920.98
18	19 steps or less	165	27.04	811.24	30.94	928.45	31.13	933.75
19	20 steps or less	165	27.04	811.24	30.94	928.45	31.13	933.75
20	21 steps or less	166	27.08	812.37	32.02	960.71	31.97	959.12
21
22	Results using Ken Nordtvedt's method and Chandler's mutation rates