GMT Tutorial Exercise 23 - Workflow 1 - Step 10

Using the macro - the SAMPLE File

Below is a screenshot of the SAMPLE file that is saved when clicking on the Generate Sample File button on the DNA Samples worksheet of the "Automated Designer for Genetic Analysis, standard edition".
The macro creates a name for this file by appending _sampleFILE.txt to the experiment name or to the file name entry made on the DNA Samples worksheet, as applicable.
The file is automatically saved in the same directory where the "Automated Designer for Genetic Analysis" is saved.
Update the entries under column header "Panel", as described below, and include the Sample File when submitting samples for electrophoretic separation on the ABI3730.

Find the sample file and open it with a spreadsheet viewer, e.g. Microsoft Excel.
Compare entries under the "Panel" column heading of the "sample submission file" with the panel names in the "panel file" (generated by the PANEL File worksheet of the macro), as highlighted in the screenshot below:
If the panel names used in the "sample submission file" and in the "panel file" differ, use the Find / Replace option of the spreadsheet viewer to update the entries in the "sample submission file" with those in the "panel file". In the example shown in the screenshot above, panel name "A" would have to be replaced with "Eae.A", "B" with "Eae.B", etc.
Background explanations:
- The panel file and the panel names in it are imported into GeneMapper, which requires unique panel names are used. The macro assigns a 3-letter prefix, derived from the experiment name, to each panel name, to reduce the likelihood of two identical panel names being used.
- If the panel names in the sample submission file are not identical to these panel names, GeneMapper will not be able to automatically correlate samples with their panels when samples are imported into GeneMapper, requiring that the correct panels are manually assigned for the samples.