How many do you have in total, so percentage wise how are lineages represented? Would be interesting to see how they compare to averages in the British Isles.Quote:
Originally Posted by Graham
How many do you have in total, so percentage wise how are lineages represented? Would be interesting to see how they compare to averages in the British Isles.Quote:
Originally Posted by Graham
Quote:
Y-DNA
51 - E1b1b1a2*
47 - I2a2b
39 - R1a1a
25 - I1*
24 - J2
MtDNA
75 - H
50 - H1
21 - T2b
20 - H7
18 - J1c
Ironically neither my paternal or maternal line are among my top 5 matches.
Use google docs. Follow the instructions linked here, it doesn't take long at all.Quote:
Originally Posted by Jaxman
Dude no. Dowload the file - upload to google docs - click on it - data - pivot table report - rows - add field - maternal haplogroup - uncheck show totals - values - add field - maternal haplogroup - summarize by countAQuote:
Originally Posted by Longbowman
Repeat with Paternal haplogroup.
Seriously it's way easy.
My way is funnier. Perhaps Jaxman actually did it the hard way.Quote:
Originally Posted by Atlantic Islander
You are so mean omg, lol.Quote:
Originally Posted by Longbowman
MtDNA
H 64
H1 62
T2b 33
V 31
H3 25
Y-DNA
R1b1b2a1a2f* 106
R1b1b2a1a 53
I1* 35
R1b1b2a1a1* 34
R1b1b2a1a1 24
Will need to do it all again. But I'll try to copy what you've done.Quote:
Originally Posted by Jackson
Nah didn't do it.Quote:
Originally Posted by Longbowman
http://0.tqn.com/d/rubberstamping/1/...ou_words_1.pngQuote:
Originally Posted by Jaxman
Aye lad.Quote:
Originally Posted by Longbowman
Update:
YDNA:
1 R1a1a 49
2 E1b1ba2 43
3 I2a2b 22
4 I1 21
5 J2 15
mtDNA
1 H 62
2 H1 20
3 H7 15
J1c 15
4 T2b 14
H1c 14
5 H6a1 13
Update!
mtDNA
H - 78
H1 - 39
J1c - 23
T1a1 - 13
H7 - 12
U5a1a1 - 11
H1c - 10
Y-DNA
E1b1b1a2*(E-V13) - 75
I2a2b - 44
R1a1a - 42
R1b1b2a - 23
J2b2* - 20
R1b1b2a1a2f* - 18
I1 - 18
Mine:
mtDNA:
H- 74
H1- 69
T2b- 43
H3- 35
T1a1- 16
H7- 16
V- 16
y-DNA:
R1b1b2a1a2f*- 94
R1b1b2a1a- 59
Il*- 47
R1b1b2a1a2f2- 23
R1b1b2a1a1- 21
R1b1b2a1a1*- 21
Il- 19
My top haplogroups seem fairly similar to Robert's and Graham's. Trying to work Jackson's out but I think they are a little less similar. Am I right?
Quote:
Originally Posted by Caismeachd
Quote:
Originally Posted by Graham
Quote:
Originally Posted by Jackson
Self:
mtDNA (L2a1l2a1) top five:
K1a1b1a - 115
H - 52
H1 - 32
H7 - 31
J1c - 30
Y-DNA (J2) top five:
J1e [J-P58] - 75
R1a1a - 37
E1b1b1c1 - 34
T, R2 - 33
Grandmother:
mtDNA (L2a1l2a1) top five:
K1a1b1a - 185
N1b2 - 54
H - 46
K2a2a, H1 - 40
Y-DNA top five:
J1e -76
R1a1a - 37
E1b1b1c1 - 36
J2 - 33
E1b1b1c1a - 31
Grandfather:
mtDNA (H10a1a) top five:
-Still waiting for list-
Y-DNA (I2b1* / I2a2a*) top five:
-Still waiting for list-
Grandfather:
mtDNA (H10a1a) top five:
H1 - 49
H - 42
T2b - 30
H3 - 25
H7 - 23
Y-DNA (I2b1* / I2a2a*) top five:
R1b1b2a1a2f* - 68
I1* - 51
I1, R1b1b2a1a - 44
R1a1a - 43
Wasn't there a method to organizing these into order quickly and easily? Been a while since I've done it and google docs layout seems to have changed, anyone able to give me some advice on what to do?
I just downloaded the csv. file, opened it in Excel and sorted the paternal and maternal haplogroup columns by alphabetic order. Then, if you mark enough cells a small number pops up next to your coursor with the count. It was pretty easy to spot which halpogroups had the most instances since there is usually a vast variation in numbers.Quote:
Originally Posted by Jackson
Cheers, might do it that way then. I just remember there was a really quick and easy way to do it on google docs but i can't remember what it was.Quote:
Originally Posted by Skjaldemjøden
There should be a way to automatize pretty haplogroup diagrams out of the csv file. Excel vet requested at reception.
how do you do that?
bump - how do you see the ydna and mtdna of relatives?
Oh I see now
UPDATE: (I counted it wrong :D)
Y-DNA:
1. I2a2b
2. E-V13
3. R1a1a
4. R1b-U106
5. R1b-L21, I1
mt-DNA:
1. H
2. J1
3. U5
4. HV
5. K1
UK 420 38.7% K 362 33.4% K1a 301 27.7% K1a1b 222 20.5% K1a1b1 220 27.7% K1a1b1a 219 20.2% K1a1b1 1 0.1% K1a1b 1 0.1% K1a9 53 4.9% K1a* 18 1.7% K1a4 7 0.6% K1a4a 6 0.6% K1a4a* 5 0.5% K1a4a1 1 0.1% K1a4* 1 0.1% K1a7'8 1 0.1% K2 61 5.6% K2a 60 5.5% K2a2a 55 5.2% K2a* 5 0.5% K2b 1 0.1% H 321 29.6% H1 80 7.4% H1* 41 3.8% H1e 26 2.4% H1b 5 0.5% H1o 4 0.4% H1f 2 0.2% H1a 1 0.1% H1c1 1 0.1% H* 61 5.6% HV 55 5.1% HV1 39 3.6% HV1b2 37 3.4% HV1* 2 0.2% HV5 15 1.4% HV* 1 0.1% H7 38 3.5% H7* 37 3.4% H7a 1 0.1% H5 24 2.2% H5a 15 1.4% H5a* 13 1.2% H5a1 2 0.2% H5'36 6 0.6% H5* 3 0.3% H6a1 20 1.8% H6a1* 13 1.2% H6a1a1a 4 0.4% H6a1b 3 0.3% H6a1b* 2 0.2% H6a1b2 1 0.1% H3 15 1.4% H3* 14 1.3% H3g 1 0.1% H11 9 0.8% H11* 5 0.5% H11a 4 0.4% H10 5 0.5% H10a1 4 0.4% H10* 1 0.1% H2a 4 0.4% H2a1 2 0.2% H2a2b1 2 0.2% H4a1 4 0.4% H4a1* 3 0.3% H4a1b 1 0.1% H15 2 0.2% H15* 1 0.1% H15b 1 0.1% H13a1a1a 1 0.1% H24 1 0.1% H26 1 0.1% H39 1 0.1% N 87 8.0% N1b 80 7.4% N1b2 76 7.0% N1b1 4 0.4% N1b1b 3 0.3% N1b1* 1 0.1% N9a3 7 0.6% J 79 7.3% J1 76 7.0% J1c 63 5.8% J1c* 24 2.2% J1c7 20 1.8% J1c7a 19 1.7% J1c7* 1 0.1% J1c1 15 1.4% J1c3 3 0.3% J1c5 1 0.1% J1b1a 13 1.2% J2 3 0.3% J2b1 2 0.2% J2a1a 1 0.1% U 58 5.4% U5 27 2.5% U5a 20 1.8% U5a2 13 1.2% U5a2b 12 1.1% U5a2c 1 0.1% U5a1 7 0.6% U5a1a 4 0.4% U5a1b1 3 0.3% U7 11 1.0% U2e1a 6 0.6% U2a1 5 0.5% U1b 4 0.4% U6 4 0.4% U6a7 3 0.3% U6b1 1 0.1% U4b1b 1 0.1% T 50 4.6% T2 28 2.6% T2b 18 1.6% T2b* 16 1.5% T2b3 1 0.1% T2b4 1 0.1% T2g 4 0.4% T2e 3 0.3% T2a 2 0.2% T2c1 1 0.1% T1 22 2.0% T1a 16 1.5% T1a1 13 1.2% T1a* 2 0.2% T1a3 1 0.1% T1* 6 0.6% W 30 2.8% W3 21 1.9% W3a 11 1.0% W3* 10 0.9% W1 8 0.7% W* 1 0.1% V 25 2.3% V7 23 2.1% V7a 18 1.6% V7* 5 0.5% V1 4 0.4% V1a 3 0.3% V1* 1 0.1% R 22 2.0% R0a 21 1.9% R0a* 12 1.1% R0a2 9 0.8% R 1 0.1% L 12 1.1% L2a1 12 1.1% L2a1* 8 0.7% L2a1I 4 0.4% L2a1I* 3 0.3% L2a1I2 1 0.1% M 12 1.1% M33c 7 0.6% M1a 5 0.5% M1a1b 4 0.4% M1a* 1 0.1% I 11 1.0% I1 10 0.9% I1* 9 0.9% I1a1 1 0.1% I* 1 0.1% X 9 0.8% X2b 7 0.6% X2c1 1 0.1% X2e 1 0.1% B 2 0.2% B2 2 0.2% B2d 1 0.1% A 2 0.2% A2 1 0.1% A4 1 0.1% C 1 0.1% C1 1 0.1% D 1 0.1% D1 1 0.1%
J 213 32.2% J2 109 16.5% J2a 50 7.6% J2a1b 48 7.3% J2a1b* 28 4.2% J2a1b1 20 3.0% J2a1 1 0.2% J2a1h3 1 0.2% J2 35 5.3% J2b 24 3.6% J2b2 15 2.3% J2b* 9 1.4% J1 104 15.7% J1e 96 14.5% J1* 8 1.2% R 158 23.9% R1 149 22.5% R1b 76 11.5% R1b1b 75 11.3% R1b1b2a1a1d1 26 3.9% R1b1b2 20 3.0% R1b1b2a1a1d 15 2.3% R1b1b2a 13 2.0% R1b1b2a1a 10 1.5% R1b1b2a1a1f 4 0.6% R1b1b2a1a1 2 0.3% R1b1b2a1a1d 2 0.3% R1b1b2a1a2 2 0.3% R1b1b2a1a1f2 1 0.2% R1b1* 1 0.2% R1a1a 70 10.6% R1* 3 0.5% R2 9 1.4% E 146 22.0% E1 145 21.9% E1b1 140 21.1% E1b1b 138 20.8% E1b1b1 137 20.7% E1b1b1c 76 11.5% E1b1b1c1 64 9.7% E1b1b1c1* 43 6.5% E1b1b1c1a 21 3.2% E1b1b1c* 12 1.8% E1b1b1a 73 11.0% E1b1b1a* 54 8.1% E1b1b1a2 16 2.4% E1b1b1a4 3 0.5% E1b1b1* 33 5.0% E1b1a 2 0.3% E1b1a8a 1 0.2 E1b1a8a1 1 E1a1 5 0.8% E2 1 0.2% G 67 10.1% G2 55 8.3% G2c 37 5.6% G2a 15 2.3% G2a* 9 1.4% G2a4 4 0.6% G2a2 1 0.2% G2a5 1 0.2% G2* 3 0.5% G1 12 1.8% Q 30 4.5% Q1b 30 4.5% T 9 4.1% T* 9 4.1% I 19 2.9% I2 18 2.7% I2a 10 1.5% I2a2 5 0.8% I2a2b 4 0.6% I2a2 1 0.2% I2a1 4 0.6% I2a* 1 0.2% I2b1 7 1.1% I2* 1 0.2% I1 1 0.2% N 2 0.3% N1c1 2 0.3%
New update
YDNA:
R1a1a 76
E1b1b1a2 51
I1 33
J2 24
I2a2b 22
MtDNA:
H 80
H1 30
T2b 26
H1c 21
J1c 20