# 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**:\
   ![](/files/RSLZQc70nvLsHdwcp4q8)
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:\
   ![](/files/AThuKX6nir3qVgbAmmVO)
4. Format the .csv file for import into GenomeStudio:
   1. Delete Row 2 and all columns except for **SampleID** and **LogRDev**:\
      ![](/files/YPTqMCZzNUXamFJc548X)
   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**:\
      ![](/files/i0LrEcyOZs0WqmkhHkVP)

5. Save the revised spreadsheet as a **Tab delimited text (.txt)** file.
6. In the GenomeStudio **Samples Table**, select the import icon:\
   ![](/files/KdfT86tNUPRnWoyidzjP)
7. In the **Import** window, **Browse** to and select the tab-delimited .txt file created, then select **OK**.\
   ![](/files/HRulbYSeON75mNykd7tO)
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.\
   ![](/files/UJodGlZQWYzEhnQWbvyw)

**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)*.* |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://knowledge.illumina.com/microarray/general/microarray-general-reference_material-list/000001476.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
