3.124 FAQ-709 How do I refer to fitting parameters in the Set Column Values dialog?

Last Update: 8/4/2021

Origin generates tables on a hierarchy result sheet to hold parameter values and other information.

To refer to cell values from such tables:

Origin 2021b and later

Use ReportCell() function in the Set Column Values dialog (F(x)= column header row).

Suppose you did a Gauss nonlinear curve fit and generated a report sheet named [Book1]FitNL1!. To access to Value of parameter xc' in the Parameters table, enter following formula in the Set Column Values dialog:

ReportCell("Book1", "FitNL1", "Parameters", "xc", "Value")

Create Copy As New Sheet.png

If you are not sure the row and column reference strings of the table cell, you can click this cell and the cell link will show in the status bar, something like the following:

where Parameters is the table name, xc is the row reference string and Value is the column string.

If input data changes, the fitting result and the set column value will update to reflect the change.

Origin 2021 and earlier

You will need to copy the report table as a new sheet can then refer to this new flat sheet cell in the Set Column Values dialog.

  1. Right-click the Parameters table and choose Create Copy as New Sheet. A flat worksheet is created.
    Created Sheet.png
  2. Select the column where you want to set the formula and open the Set Column Values dialog.
  3. Choose Variables: Add Range Variable by Selection... from dialog menu.
  4. Go to the newly created flat sheet and select the parameter xc Value cell.
    Hunt Cell.png
  5. Click Done button. The Insert Mode dialog will appear. Select option for your own need.
    Click OK button. A range variable will be defined in the Before Formula Scripts panel.
  6. Use r1 in the Formula edit box, such as:
    SCV Formula.png

    Keywords:fitting, parameter, formula