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

Last Update: 1/24/2023

Origin generates tables on a hierarchy result sheet to hold parameter values and other information.
The table uses auto display digits so it's not showing full precision parameter values. (Right click the table and choose Digits... to change display digits).
If you directly use it Set Column Values, the result will not be accurate, especially for formula with higher exponential power.

To refer to true 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

Note: ReportCell can only be used as the pure expression. If you want to write other expressions with it, e.g. ReportCell("Book1", "FitNL1", "Parameters", "xc", "Value")*A, please set system variable @RCL=0 first and then use it.

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:

cell://Parameters.xc.Value
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