These Excel tools have been superceded by the javascript based tools in the
Y-DNA Comparison Utility

 

 

DNA Analysis Software Tools

Excel Macros

A set of three Excel macros are provided to generate a table of genetic distances between selected haplotypes and to create an HTML representation of the genetic distance table.

  • GeneticDistanceOnly -- creates tight table of genetic distances
  • GeneticDistanceWithCount -- same as above but with number of common alleles for each calculated distance and number of alleles tested for each haplotype
  • HTMLGenDist_to_clipboard -- you can paste the table into your web page editor
Download the GenDist.xls Excel file.

Steps:

  1. Cut-and-paste haplotype grid from Ysearch DNA comparison page or from FTDNA generated surname project page into an Excel worksheet
  2. Select the entire rows for the haplotypes of interest
  3. Run one of the GeneticDistance macros and a genetic distance table will be displayed on a different worksheet
  4. Select the genetic distance table and run the HTMLGenDist_to_clipboard macro to copy a HTML representation of the table to the Windows clipboard
  5. Paste the clipboard into your web page editor, save and view with your web browser

    For more detailed instructions, please refer to the "Old macros" section at the bottom of this page

    The genetic distances displayed here are a snapshot of the state of the McGee DNA Surname Project when this page was created. See the latest at the McGee DNA Results page.

Genetic Distance
  J
o
h
n

M
c
G
e
e
-
T
N		 J
a
m
e
s

M
c
G
e
e

#
2		 J
a
m
e
s

M
c
G
e
e

#
1		 J
o
h
n

M
c
G
e
e
-
S
C		 B
a
r
c
l
a
y

M
c
G
h
e
e		 D
a
v
i
d

M
a
g
e
e		 J
o
h
n

C
.
M
c
G
e
e		 J
o
h
n

M
a
g
e
e		 W
i
l
l
i
a
m

M
a
g
e
e		 J
o
h
n

O
.

M
c
G
e
h
e
e		 J
o
s
e
p
h

M
c
G
e
e		 J
a
m
e
s

P
.

M
c
G
e
e		 E
l
i

M
c
G
e
h
e
e		 T
h
o
m
a
s

M
c
G
h
e
e
John McGee-TN - 1 1 3 4 4 11 5 8 9 10 17 10 16
James McGee #2 1 - 0 1 3 3 3 1 1 9 10 10 9 16
James McGee #1 1 0 - 1 3 3 3 1 1 9 10 10 9 16
John McGee-SC 3 1 1 - 2 2 6 4 7 7 8 13 9 17
Barclay McGhee 4 3 3 2 - 0 0 3 2 10 11 13 14 16
David Magee 4 3 3 2 0 - 0 3 2 10 11 13 14 16
John C.McGee 11 3 3 6 0 0 - 6 7 12 13 23 13 16
John Magee 5 1 1 4 3 3 6 - 7 7 8 13 10 17
William Magee 8 1 1 7 2 2 7 7 - 7 8 16 9 15
John O. McGehee 9 9 9 7 10 10 12 7 7 - 1 1 2 16
Joseph McGee 10 10 10 8 11 11 13 8 8 1 - 0 1 15
James P. McGee 17 10 10 13 13 13 23 13 16 1 0 - 2 15
Eli McGehee 10 9 9 9 14 14 13 10 9 2 1 2 - 16
Thomas McGhee 16 16 16 17 16 16 16 17 15 16 15 15 16 -
Example of GeneticDistanceOnly macro output

Genetic Distance
  J
o
h
n

M
c
G
e
e
-
T
N		 J
a
m
e
s

M
c
G
e
e

#
2		 J
a
m
e
s

M
c
G
e
e

#
1		 J
o
h
n

M
c
G
e
e
-
S
C		 B
a
r
c
l
a
y

M
c
G
h
e
e		 D
a
v
i
d

M
a
g
e
e		 J
o
h
n

C
.
M
c
G
e
e		 J
o
h
n

M
a
g
e
e		 W
i
l
l
i
a
m

M
a
g
e
e		 J
o
h
n

O
.

M
c
G
e
h
e
e		 J
o
s
e
p
h

M
c
G
e
e		 J
a
m
e
s

P
.

M
c
G
e
e		 E
l
i

M
c
G
e
h
e
e		 T
h
o
m
a
s

M
c
G
h
e
e
John McGee-TN [49] 1/25 1/25 3/24 4/31 4/31 11/37 5/24 8/24 9/25 10/25 17/37 10/31 16/12
James McGee #2 1/25 [25] 0/25 1/12 3/21 3/21 3/25 1/12 1/12 9/25 10/25 10/25 9/21 16/12
James McGee #1 1/25 0/25 [25] 1/12 3/21 3/21 3/25 1/12 1/12 9/25 10/25 10/25 9/21 16/12
John McGee-SC 3/24 1/12 1/12 [24] 2/17 2/17 6/24 4/24 7/24 7/12 8/12 13/24 9/17 17/12
Barclay McGhee 4/31 3/21 3/21 2/17 [31] 0/31 0/26 3/17 2/17 10/21 11/21 13/26 14/31 16/12
David Magee 4/31 3/21 3/21 2/17 0/31 [31] 0/26 3/17 2/17 10/21 11/21 13/26 14/31 16/12
John C.McGee 11/37 3/25 3/25 6/24 0/26 0/26 [37] 6/24 7/24 12/25 13/25 23/37 13/26 16/12
John Magee 5/24 1/12 1/12 4/24 3/17 3/17 6/24 [24] 7/24 7/12 8/12 13/24 10/17 17/12
William Magee 8/24 1/12 1/12 7/24 2/17 2/17 7/24 7/24 [24] 7/12 8/12 16/24 9/17 15/12
John O. McGehee 9/25 9/25 9/25 7/12 10/21 10/21 12/25 7/12 7/12 [25] 1/25 1/25 2/21 16/12
Joseph McGee 10/25 10/25 10/25 8/12 11/21 11/21 13/25 8/12 8/12 1/25 [25] 0/25 1/21 15/12
James P. McGee 17/37 10/25 10/25 13/24 13/26 13/26 23/37 13/24 16/24 1/25 0/25 [37] 2/26 15/12
Eli McGehee 10/31 9/21 9/21 9/17 14/31 14/31 13/26 10/17 9/17 2/21 1/21 2/26 [31] 16/12
Thomas McGhee 16/12 16/12 16/12 17/12 16/12 16/12 16/12 17/12 15/12 16/12 15/12 15/12 16/12 [12]
(Note: Number of total alleles tested is in brackets; number of common alleles tested is to the right of "/")
Example of GeneticDistanceWithCount macro output

Old unsupported macros are still available

  • Old Genetic Distance Calculator
  • Haplotype Difference Identifier
  • Miscellaneous related macros
Available on the Old DNA Analysis Software Tools page. This page includes detailed instructions for running Excel macros and creating genetic distance tables.

Dean McGee

McGee Surname DNA Project

Page last updated on September 25, 2004