| Instructions | |||||||
| This macro is used to generate input files for software in which genotypes must be numbers instead of letters. | |||||||
| Please check here the input file format: | |||||||
| Input File | |||||||
| You can seehere the output files formats: | |||||||
| Output File | |||||||
| Haploview Output File | |||||||
| TagSNPs Output File | |||||||
| According the output file you've requested, your translation will be written in a new sheet called /"Haploview"/"TagSNPs"/"Translation". | |||||||
| The convention used for the translation is the following: (code 2 for TagSNPs users) | |||||||
| A = 1 | |||||||
| C = 2 | |||||||
| G = 3 | |||||||
| T = 4 | |||||||
| "-" = O O | |||||||
| So for example : "A/G" will be translated by "1 3" | |||||||
| Compatibility | |||||||
| This macro has been found to work with Excel 97 and 2000 under various flavors | |||||||
| of Windows (English versions) and with Excel 98 of MacOS 9 and Excel X of MacOS X (English versions). | |||||||
| The authors take no responsibility for malfunctioning on other versions of Excel and/or other OSs. | |||||||
| Contact | |||||||
| If you have comments, questions and suggestions for improvement and further functions, please contact | |||||||
| Federico Canzian | or | Stéphanie Monnier | |||||
| Back | |||||||