Before using the macro, please check that your results file is in readable format. 99% of bugs occur because users do not format their files properly! Here is an example of how your results file should be formatted:
Here is an example:
CCB Plate Row Column A0529 A0530 A0531 CCB - - - A/G G/A C/T 21001701 CCB001 A 1 G/G A/G C/T 33406949 CCB001 B 1 A/G A/G C/T 21001747 CCB001 C 1 A/G A/G T/T 35848192 CCB001 D 1 G/G G/G C/T 21002264 CCB001 E 1 A/G A/G C/T 35848245 CCB001 F 1 A/A A/A C/C 21002317 CCB001 G 1 A/G A/G C/T 33417071 CCB001 H 1 A/A A/A C/C 21003003 CCB001 I 1 A/G A/G C/T 33417722 CCB001 J 1 G/G G/G C/C 21003030 CCB001 K 1 A/G A/G C/T 33417884 CCB001 L 1 A/G A/G C/T
And so on...
Any character can be used to separate the
genotypes. In addition,
you can an
character to represent the genotypes. Bear in mind,
however, that Excel likes to "guess" what type of data you
are
using, so if you use numbers, it might change
them into dates!
For the moment, this won't work with polymorphisms that
have more
than two alleles.... If you
really want it, send an email through the
project.
To see the results of the run, please look at the output file. Here is an example of the format your results file will have after Count has worked on it:
CCB Plate Row Column A0529 A0530 A0531 CCB - - - A/G G/A C/T 21001701 CCB001 A 1 G/G A/G C/T 33406949 CCB001 B 1 A/G A/G C/T 21001747 CCB001 C 1 A/G A/G T/T 35848192 CCB001 D 1 G/G G/G C/T 21002264 CCB001 E 1 A/G A/G C/T 35848245 CCB001 F 1 A/A A/A C/C 21002317 CCB001 G 1 A/G A/G C/T 33417071 CCB001 H 1 A/A A/A C/C 21003003 CCB001 I 1 A/G A/G C/T 33417722 CCB001 J 1 G/G G/G C/C 21003030 CCB001 K 1 A/G A/G C/T 33417884 CCB001 L 1 A/G A/G C/T
.......................
Total Subjects: 32 32 32 Missing (%): 1 (3.12%) 0 (0%) 0 (0%) Total Subjects with Genotypes: 31 32 32
Observed Allele 1 Counts (%): 31 (50%) 32 (50%) 38 (59.37%) Observed Allele 2 Counts (%): 31 (50%) 32 (50%) 26 (40.62%)
Observed Homo 1 Subjects (%): 6 (19.35%) 6 (18.75%) 9 (28.12%) Observed Hetero Subjects (%): 19 (61.29%) 20 (62.5%) 20 (62.5%) Observed Homo 2 Subjects (%): 6 (19.35%) 6 (18.75%) 3 (9.37%)
Expected Homo 1 Subjects (%): 8 (25%) 8 (25%) 11 (35.25%) Expected Hetero Subjects (%): 16 (50%) 16 (50%) 15 (48.24%) Expected Homo 2 Subjects (%): 8 (25%) 8 (25%) 5 (16.5%)
H-W p-value: 0.20866791 0.157299265 0.094551205
Description of the macro.
Download the macro.
Back to the program list.
This page was last updated on: December 23, 2004 by Stéphanie Monnier