Instructions
This macro is used to generate input files for software in wich genotypes must
be written with numbers instead of letters.
Your input file should look like this:
MyStudy | Plate | Row | Column | A 529 | SNP002-AG | SNP003-TC |
MyStudy | - | - | T/G | A/G | T/C | |
24600915 | CCB001 | A | 1 | T/T | A/A | T/T |
21008259 | CCB001 | A | 2 | T/G | A/G | T/C |
41008284 | CCB001 | A | 3 | T/T | A/G | T/C |
52500700 | CCB001 | A | 4 | T/G | A/A | T/T |
52508700 | CCB001 | A | 5 | G/G | A/G | C/C |
42404740 | CCB001 | A | 6 | G/G | A/A | C/C |
24609550 | CCB001 | A | 7 | - | A/A | T/C |
24611323 | CCB001 | A | 8 | G/G | G/G | T/T |
52520520 | CCB001 | B | 1 | T/G | A/G | T/C |
23407869 | CCB001 | B | 2 | T/T | G/G | C/C |
31008687 | CCB001 | B | 3 | T/G | A/A | T/C |
AND SO ON... | ||||||
Your output file will look like this for the Translation output for instance:
MyStudy | Plate | Row | Column | A 529 | SNP002-AG | SNP003-TC |
MyStudy | - | - | T/G | A/G | T/C | |
24600915 | CCB001 | A | 1 | 4 4 | 1 1 | 4 4 |
21008259 | CCB001 | A | 2 | 4 3 | 1 3 | 4 2 |
41008284 | CCB001 | A | 3 | 4 4 | 1 3 | 4 2 |
52500700 | CCB001 | A | 4 | 4 3 | 1 1 | 4 4 |
52508700 | CCB001 | A | 5 | 3 3 | 1 3 | 2 2 |
42404740 | CCB001 | A | 6 | 3 3 | 1 1 | 2 2 |
24609550 | CCB001 | A | 7 | 0 0 | 1 1 | 4 2 |
24611323 | CCB001 | A | 8 | 3 3 | 3 3 | 4 4 |
52520520 | CCB001 | B | 1 | 4 3 | 1 3 | 4 2 |
23407869 | CCB001 | B | 2 | 4 4 | 3 3 | 2 2 |
31008687 | CCB001 | B | 3 | 4 3 | 1 1 | 4 2 |
AND SO ON... | ||||||
Description of the macro.
Download the macro.
Back to the program list.
This page was last updated on: July 08, 2005 by Stéphanie Monnier