2.55 FAQ-498 How do I use analysis results in the Set Values dialog?

Last Update: 2/2/2018

use-link-cell-SCV-dlg

For many analysis operations, Origin generates a hierarchical Analysis Report Sheet to hold parameter values and other information. To refer to a parameter value from such tables, you must first create a flat sheet and then refer to the value on flat sheet in calculation.

Since Origin 2017 we introduced spreadsheet cell notation you can directly call column and cells from other sheets or books.

Below are different steps in different versions.

In Origin 2017 and later

1. On result sheet, right click the table that contains the cell value you want to use and choose Create Copy as New Sheet to create a new flat sheet.
2. In Set Column Values dialog, you can refer to cell in the newly created sheet by using sheet index and cell location, e.g. 4!C1 refers to the 1st cell of column C on 4th sheet.

In Origin 2016 and earlier

1. On result sheet, right click the table that contains the cell value you want to use and choose Create Copy as New Sheet to create a new flat sheet.

   

2. Open the Set Values dialog for the desired column (click the column header to select the column, then right-click and choose Set Column Values).
3. In the Set Values dialog, choose Variables: Add Range Variable by Selection.... The Select from Worksheet dialog opens.
4. Go to the newly-created flat sheet and click on the cell holding the value you want to use, for example the intercept:

   

5. Click the to confirm the selection and return to the Set Values dialog. In the Before Formula Scripts panel, you will see that a range variable r1 is defined for the cell value holding the intercept. You can now use r1 in the column values formula in the top panel.

   

Minimum Origin Version Required: 9.1 SR0

Keywords:fitting, parameter, formula