# How to calculate and import LogRDev into a GenomeStudio Project

In an existing GenomeStudio genotyping project:

1. Under the **Analysis** menu, select **Reports**, then **Compute CN Metrics**:\
   ![](https://761066130-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGM9W2DuBTgEXv1ClCm8H%2Fuploads%2Fgit-blob-dd73817335f3042416bfbcec40b4f45173ed0c12%2Fimage1.jpg?alt=media)
2. In the **Save CN Metrics Report** window, select a destination folder, enter a name for the CN Metrics file, then select **Save**.
3. A .csv file is created, which includes LogRDev calculations. Open the file in Microsoft Excel:\
   ![](https://761066130-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGM9W2DuBTgEXv1ClCm8H%2Fuploads%2Fgit-blob-e51fed53986c370ccda4098d9b2ddf609750f2d3%2Fimage2.jpg?alt=media)
4. Format the .csv file for import into GenomeStudio:
   1. Delete Row 2 and all columns except for **SampleID** and **LogRDev**:\
      ![](https://761066130-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGM9W2DuBTgEXv1ClCm8H%2Fuploads%2Fgit-blob-076fcd0a41bf2584b593050cf0031d4cc0ce124b%2Fimage3.jpg?alt=media)
   2. Note that the **SampleID** column header has no space.

* * This is the key column that GenomeStudio will use to import the LogRDev values into the project.
    * Add a space between **Sample** and **ID** to match the GenomeStudio column header in the Samples Table: **Sample ID**:\
      ![](https://761066130-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGM9W2DuBTgEXv1ClCm8H%2Fuploads%2Fgit-blob-3994a88663b1ac7d5a0bc69a8d89fcdba8740762%2Fimage4.png?alt=media)

5. Save the revised spreadsheet as a **Tab delimited text (.txt)** file.
6. In the GenomeStudio **Samples Table**, select the import icon:\
   ![](https://761066130-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGM9W2DuBTgEXv1ClCm8H%2Fuploads%2Fgit-blob-6f12160de3d0dc18ea0a8dc50399ffde6b8392e3%2Fimage5.jpg?alt=media)
7. In the **Import** window, **Browse** to and select the tab-delimited .txt file created, then select **OK**.\
   ![](https://761066130-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGM9W2DuBTgEXv1ClCm8H%2Fuploads%2Fgit-blob-27403ea75925eaf1cf0adbd474ba85db146d337e%2Fimage6.jpg?alt=media)
8. The **LogRDev** column will be imported into the **Samples Table**. If needed, click and drag the column from the far left of the table to the desired position.\
   ![](https://761066130-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGM9W2DuBTgEXv1ClCm8H%2Fuploads%2Fgit-blob-277f427ea46e2d3a5cb6fba50d768bd89343a1d6%2Fimage7.png?alt=media)

**Resource:** [GenomeStudio 2008.1 Framework User Guide](https://support.illumina.com/content/dam/illumina-support/documents/documentation/software_documentation/genomestudio/genomestudio-2-0/genomestudio-2008-1-framework-user-guide-11318815-a.pdf) (page 29, 'Importing a Column')

\
\
\ <br>

|                                                                                                                                                                                                                                                                                                                                                                   |
| :---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------: |
| *For any feedback or questions regarding this article (Illumina Knowledge Article #1476), contact Illumina Technical Support* [*techsupport@illumina.com*](mailto:techsupport@illumina.com?subject=Question%2FFeedback%20Regarding%20Illumina%20Knowledge%20Article%20#000001476%20-%20Microarray%20\&body=Dear%20Illumina%20Technical%20Support,%0D%0A%0D%0A)*.* |