How to use the Count macro:


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