T O P I C R E V I E W |
Clairekun |
Posted - 05/14/2020 : 06:55:20 AM Origin Ver. and Service Release (Select Help-->About Origin): 2018b Operating System: Windows 10
Hello,
I would like to know whether it was possible to relate user-defined parameters in a worksheet column among themselves.
My worksheet is basically an X column with different species, and several Y columns with the amount of each species (%) in different mediums.
There is a constant corresponding to each medium; I need to define a formula using that constant to obtain a correction factor. I would create a new column set where the amounts are multiplied by that correction factor.
What I wanted to do is use a first User-defined parameter for the medium constant, and a second user-defined parameter to calculate the correction factor. This way, the new columns would follow a formula which would be First set * correction factor. This does not seem to work.
I need both the constant and the correction factor to show somewhere, so I can't simply include the correction calculation in new column formulas.
How could I do this? |
4 L A T E S T R E P L I E S (Newest First) |
Clairekun |
Posted - 05/14/2020 : 5:06:13 PM Great, got it working now! Thanks!
If anyone is interested, wcol(j) is a predefined variable meaning "this column", see here: https://www.originlab.com/doc/Origin-Help/Wks-SetColVal-MenuOpt-Dialog#Variables_Menu |
YimingChen |
Posted - 05/14/2020 : 2:48:49 PM Well. That is because your Origin version is old. Please use the following script instead:
=5*(%(wcol(j)[D1]$))
James |
Clairekun |
Posted - 05/14/2020 : 10:46:06 AM That is a solution I had already tried, sorry for not saying it before. Still not working; only -- is showing in the cell. I checked the format for user parameters cells, which is set to text & numeric, so I'm assuming that's not the problem. |
YimingChen |
Posted - 05/14/2020 : 09:37:31 AM Hi,
See below simple example on setting a column parameter as function of another column parameter.
James |