Last Update: 6/2/2021
Origin generates tables on a hierarchy result sheet to hold parameter values and other information.
To refer to cell values from such tables:
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") + B
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.
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.
Keywords:fitting, parameter, formula