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


Last Update: 2/2/2018

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.

Scv result table.gif

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.
    Copy As New Sheet.png
  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:
    Select Cell Value.png
  5. Click the Return Selection Button.png 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.
    Set Values with R1.png
Note: Keep in mind that the value that you insert using this procedure is a variable and if input data are changed, the column values will update to reflect the change.

Minimum Origin Version Required: 9.1 SR0


Keywords:fitting, parameter, formula