|
Type
Data for ASD |
|
|
Peter
Gwozdz |
|
|
For
instructions, see file "Type.xls", sheet "ASD Doc" |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
` |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
389-2
calculation column |
|
|
|
Type or copy the modal
haplotype into row 3 |
|
|
Be careful not to paste anything
over this |
| 13 |
25 |
17 |
10 |
10 |
14 |
12 |
12 |
11 |
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 |
14 |
11 |
11 |
8 |
17 |
17 |
8 |
12 |
10 |
8 |
12 |
10 |
12 |
22 |
22 |
15 |
10 |
12 |
12 |
14 |
8 |
15 |
25 |
21 |
12 |
12 |
11 |
13 |
12 |
11 |
12 |
12 |
|
Current modal - a copy
from the "Calculator" sheet |
|
17 |
|
|
|
|
|
Copy the Type data below
row 20 |
|
|
|
17 |
|
|
|
17 |
| Red
Bold STR edits restored to their original values for this ASD calculation |
|
|
|
17 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
16 |
0 |
0 |
Count of samples that
have this marker, this sheet |
|
|
| 16 |
9 |
8 |
15 |
16 |
12 |
16 |
16 |
13 |
14 |
16 |
14 |
8 |
14 |
16 |
16 |
16 |
14 |
15 |
15 |
7 |
14 |
15 |
14 |
16 |
15 |
14 |
16 |
16 |
11 |
12 |
8 |
8 |
6 |
5 |
8 |
16 |
16 |
16 |
15 |
15 |
16 |
12 |
16 |
16 |
16 |
14 |
16 |
12 |
13 |
12 |
16 |
16 |
16 |
15 |
16 |
9 |
8 |
16 |
15 |
15 |
15 |
15 |
16 |
16 |
16 |
14 |
0 |
0 |
Count of this modal value
, this sheet |
|
|
| 1,0 |
0,6 |
0,5 |
0,9 |
1,0 |
0,8 |
1,0 |
1,0 |
0,8 |
0,9 |
1,0 |
0,9 |
0,5 |
0,9 |
1,0 |
1,0 |
1,0 |
0,9 |
0,9 |
0,9 |
0,4 |
0,9 |
0,9 |
0,9 |
1,0 |
0,9 |
0,9 |
1,0 |
1,0 |
0,7 |
0,8 |
0,5 |
0,5 |
0,4 |
0,3 |
0,5 |
1,0 |
1,0 |
1,0 |
0,9 |
0,9 |
1,0 |
0,8 |
1,0 |
1,0 |
1,0 |
0,9 |
1,0 |
0,8 |
0,8 |
0,8 |
1,0 |
1,0 |
1,0 |
0,9 |
1,0 |
0,6 |
0,5 |
1,0 |
0,9 |
0,9 |
0,9 |
0,9 |
1,0 |
1,0 |
1,0 |
0,9 |
0,0 |
0,0 |
Fraction |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
|
|
Country ↓ |
|
|
|
|
|
|
|
389b |
| 13 |
23 |
16 |
10 |
10 |
10 |
12 |
12 |
11 |
13 |
11 |
30 |
15 |
9 |
10 |
11 |
11 |
23 |
14 |
20 |
31 |
12 |
15 |
16 |
16 |
11 |
11 |
19 |
23 |
17 |
15 |
18 |
18 |
34 |
38 |
14 |
11 |
11 |
8 |
17 |
17 |
8 |
12 |
10 |
8 |
12 |
10 |
12 |
20 |
22 |
15 |
10 |
12 |
12 |
14 |
8 |
15 |
24 |
21 |
12 |
12 |
11 |
13 |
12 |
11 |
12 |
12 |
|
1533 |
101885 |
Stpan Lytwin, 1723 - 1820 |
Ukraine |
|
|
|
|
|
17 |
| 13 |
23 |
16 |
10 |
10 |
10 |
12 |
12 |
11 |
13 |
11 |
30 |
17 |
9 |
10 |
11 |
11 |
23 |
14 |
20 |
31 |
12 |
15 |
16 |
16 |
11 |
11 |
19 |
23 |
17 |
15 |
18 |
18 |
34 |
38 |
14 |
11 |
11 |
8 |
17 |
17 |
8 |
12 |
10 |
8 |
12 |
10 |
12 |
20 |
22 |
15 |
10 |
12 |
12 |
14 |
8 |
15 |
24 |
21 |
12 |
12 |
11 |
13 |
12 |
11 |
12 |
12 |
|
1534 |
106656 |
Stepan Lytwin, 1723-1820 |
Russian Federation |
|
|
|
17 |
| 13 |
26 |
17 |
10 |
10 |
14 |
12 |
12 |
11 |
13 |
11 |
30 |
16 |
9 |
10 |
11 |
11 |
23 |
14 |
20 |
32 |
12 |
15 |
16 |
16 |
11 |
11 |
19 |
23 |
15 |
16 |
19 |
20 |
36 |
38 |
14 |
11 |
11 |
8 |
17 |
17 |
8 |
11 |
10 |
8 |
12 |
10 |
12 |
22 |
22 |
16 |
10 |
12 |
12 |
14 |
8 |
15 |
25 |
21 |
12 |
12 |
11 |
13 |
12 |
11 |
12 |
12 |
|
1662 |
76637 |
Jan Duke, Dobrzankowo, Poland |
Poland |
|
|
|
|
|
17 |
| 13 |
25 |
16 |
10 |
10 |
14 |
12 |
12 |
11 |
13 |
11 |
31 |
16 |
9 |
10 |
11 |
11 |
23 |
14 |
20 |
31 |
12 |
15 |
16 |
16 |
11 |
10 |
19 |
23 |
16 |
16 |
18 |
21 |
34 |
39 |
14 |
11 |
11 |
8 |
17 |
17 |
8 |
12 |
10 |
8 |
12 |
10 |
12 |
22 |
24 |
16 |
10 |
12 |
12 |
14 |
8 |
15 |
24 |
21 |
12 |
12 |
11 |
13 |
12 |
11 |
12 |
12 |
|
1572 |
12044 |
Caspar Höhnl 1629 Mastov, Czech
Republic |
Czech Republic |
|
|
|
18 |
| 13 |
25 |
15 |
10 |
10 |
14 |
12 |
12 |
11 |
13 |
11 |
29 |
17 |
9 |
10 |
11 |
11 |
24 |
14 |
20 |
32 |
12 |
15 |
16 |
16 |
11 |
11 |
19 |
23 |
16 |
16 |
19 |
19 |
35 |
41 |
14 |
11 |
11 |
8 |
17 |
17 |
8 |
12 |
10 |
8 |
12 |
10 |
12 |
22 |
22 |
15 |
10 |
12 |
12 |
15 |
8 |
15 |
24 |
21 |
12 |
13 |
11 |
13 |
12 |
11 |
12 |
12 |
|
1548 |
189283 |
Steblin |
Ukraine |
|
|
|
|
|
16 |
| 13 |
25 |
17 |
11 |
10 |
10 |
12 |
12 |
11 |
13 |
11 |
30 |
17 |
10 |
10 |
11 |
11 |
23 |
14 |
20 |
31 |
12 |
15 |
15 |
16 |
11 |
11 |
19 |
23 |
16 |
16 |
18 |
20 |
35 |
39 |
15 |
11 |
11 |
8 |
17 |
17 |
8 |
11 |
10 |
8 |
12 |
11 |
12 |
22 |
23 |
15 |
10 |
12 |
12 |
14 |
8 |
16 |
25 |
21 |
12 |
12 |
11 |
13 |
12 |
11 |
12 |
12 |
|
1652 |
N38633 |
Combik, Poland |
Poland |
|
|
|
|
|
17 |
| 13 |
25 |
17 |
10 |
10 |
14 |
12 |
12 |
11 |
13 |
11 |
30 |
17 |
9 |
10 |
11 |
11 |
23 |
14 |
20 |
32 |
12 |
15 |
16 |
16 |
11 |
11 |
19 |
23 |
15 |
16 |
18 |
20 |
35 |
38 |
14 |
11 |
11 |
8 |
17 |
17 |
8 |
12 |
10 |
8 |
12 |
10 |
12 |
22 |
22 |
14 |
10 |
12 |
12 |
14 |
8 |
14 |
25 |
21 |
12 |
12 |
10 |
13 |
12 |
11 |
12 |
12 |
|
1642 |
N3646 |
Dmytro Pylypiv, b.1849, Verkhnya
Rozhanka, Ukraine |
Ukraine |
|
|
|
|
|
17 |
| 13 |
25 |
17 |
10 |
10 |
14 |
12 |
12 |
11 |
13 |
11 |
30 |
15 |
9 |
10 |
11 |
11 |
23 |
15 |
20 |
30 |
12 |
15 |
16 |
16 |
12 |
11 |
19 |
23 |
16 |
16 |
19 |
19 |
36 |
39 |
15 |
11 |
11 |
8 |
17 |
17 |
8 |
12 |
10 |
8 |
12 |
10 |
12 |
22 |
22 |
15 |
10 |
12 |
12 |
14 |
8 |
14 |
26 |
21 |
12 |
12 |
11 |
13 |
12 |
11 |
12 |
12 |
|
1638 |
74282 |
Wawrzyniec Bajur, b.1865, Wólka
Swiatkowa, Poland |
Poland |
|
|
|
|
|
17 |
| 13 |
25 |
17 |
10 |
10 |
15 |
12 |
12 |
12 |
13 |
11 |
30 |
16 |
9 |
10 |
11 |
11 |
23 |
14 |
19 |
31 |
12 |
15 |
16 |
16 |
11 |
10 |
19 |
23 |
15 |
16 |
17 |
19 |
35 |
40 |
14 |
11 |
11 |
8 |
17 |
18 |
8 |
12 |
10 |
8 |
12 |
10 |
12 |
22 |
22 |
15 |
10 |
12 |
12 |
14 |
8 |
14 |
26 |
21 |
12 |
12 |
11 |
13 |
12 |
11 |
12 |
12 |
|
1651 |
100432 |
Florian Minakowski, d. 1788-1790,
Poznan, Poland |
Poland |
|
|
|
|
|
17 |
| 13 |
25 |
17 |
10 |
10 |
14 |
12 |
12 |
11 |
13 |
11 |
30 |
16 |
9 |
10 |
11 |
11 |
24 |
14 |
20 |
30 |
12 |
15 |
16 |
16 |
11 |
11 |
19 |
23 |
16 |
15 |
17 |
18 |
35 |
40 |
13 |
11 |
11 |
8 |
17 |
17 |
8 |
11 |
10 |
8 |
12 |
10 |
12 |
22 |
22 |
15 |
10 |
12 |
12 |
14 |
8 |
15 |
25 |
21 |
12 |
12 |
11 |
13 |
12 |
11 |
12 |
12 |
|
1641 |
38686 |
Walenty SZCZESNY b. 10 Dec 1880,
Bronowo, Poland |
Poland |
|
|
|
|
|
17 |
| 13 |
26 |
17 |
10 |
10 |
14 |
12 |
12 |
11 |
13 |
11 |
30 |
16 |
10 |
10 |
11 |
11 |
23 |
14 |
20 |
31 |
16 |
16 |
16 |
16 |
11 |
11 |
19 |
23 |
16 |
15 |
18 |
19 |
39 |
39 |
13 |
11 |
11 |
8 |
15 |
17 |
8 |
12 |
10 |
8 |
12 |
10 |
12 |
22 |
22 |
15 |
10 |
12 |
12 |
14 |
8 |
15 |
25 |
21 |
12 |
12 |
11 |
13 |
12 |
11 |
12 |
12 |
|
1661 |
152662 |
Trofim Lamonov, 1650-1690, Kromski
uezd |
Russian Federation |
|
|
|
17 |
| 13 |
26 |
16 |
10 |
10 |
14 |
12 |
12 |
12 |
13 |
11 |
30 |
16 |
9 |
10 |
11 |
11 |
23 |
14 |
20 |
32 |
12 |
15 |
16 |
16 |
11 |
11 |
19 |
23 |
16 |
16 |
17 |
19 |
35 |
40 |
13 |
11 |
11 |
8 |
17 |
17 |
8 |
12 |
10 |
8 |
12 |
10 |
12 |
22 |
22 |
15 |
10 |
12 |
12 |
14 |
8 |
15 |
27 |
21 |
12 |
12 |
11 |
14 |
12 |
11 |
12 |
12 |
|
1657 |
116518 |
Kazimierz Nowicki, b.c.1890,
Mulawicze, Poland |
Poland |
|
|
|
|
|
17 |
| 13 |
25 |
17 |
10 |
10 |
14 |
12 |
12 |
11 |
14 |
11 |
31 |
18 |
9 |
10 |
11 |
11 |
23 |
14 |
20 |
32 |
12 |
15 |
16 |
16 |
11 |
11 |
19 |
23 |
16 |
16 |
18 |
18 |
34 |
39 |
14 |
11 |
11 |
8 |
17 |
17 |
8 |
12 |
10 |
8 |
12 |
10 |
12 |
21 |
22 |
15 |
10 |
12 |
12 |
14 |
8 |
14 |
25 |
21 |
13 |
12 |
11 |
13 |
12 |
11 |
12 |
13 |
|
1646 |
80813 |
Kocan, Przybyszówka, Poland |
Poland |
|
|
|
|
|
|
17 |
| 13 |
26 |
16 |
10 |
10 |
14 |
12 |
12 |
11 |
14 |
11 |
31 |
16 |
9 |
10 |
11 |
11 |
23 |
14 |
20 |
31 |
12 |
15 |
15 |
16 |
11 |
11 |
19 |
23 |
16 |
16 |
18 |
19 |
36 |
42 |
13 |
11 |
11 |
8 |
17 |
17 |
8 |
11 |
10 |
8 |
12 |
10 |
12 |
23 |
23 |
16 |
10 |
12 |
12 |
14 |
8 |
14 |
25 |
21 |
12 |
12 |
11 |
13 |
12 |
11 |
12 |
12 |
|
1656 |
192317 |
|
Russian Federation |
|
|
|
|
17 |
| 13 |
25 |
16 |
10 |
10 |
14 |
12 |
12 |
11 |
13 |
11 |
30 |
17 |
9 |
10 |
11 |
11 |
23 |
14 |
20 |
29 |
13 |
15 |
16 |
16 |
11 |
11 |
19 |
23 |
16 |
16 |
20 |
19 |
34 |
40 |
15 |
11 |
11 |
8 |
17 |
17 |
8 |
12 |
10 |
8 |
12 |
10 |
12 |
22 |
22 |
15 |
10 |
12 |
12 |
14 |
8 |
14 |
24 |
21 |
12 |
12 |
11 |
13 |
12 |
11 |
12 |
13 |
|
1569 |
N35891 |
Matthew Mamajek, b.1780, Sul,
Poland |
Poland |
|
|
|
|
|
17 |
| 13 |
24 |
16 |
10 |
10 |
14 |
12 |
12 |
12 |
13 |
11 |
30 |
16 |
9 |
10 |
11 |
11 |
23 |
14 |
20 |
32 |
12 |
15 |
16 |
16 |
11 |
11 |
19 |
23 |
16 |
16 |
19 |
19 |
34 |
42 |
12 |
11 |
11 |
8 |
17 |
17 |
8 |
12 |
10 |
8 |
12 |
11 |
12 |
22 |
22 |
15 |
10 |
12 |
12 |
14 |
8 |
15 |
25 |
21 |
12 |
12 |
11 |
13 |
12 |
11 |
12 |
12 |
|
1539 |
200042 |
Antoni Szulecki, *~1850 +~1910,
Zdolbunow, Wolyn |
Poland |
|
|
|
|
|
17 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|