| T O P I C R E V I E W |
| cal@force. |
Posted - 06/10/2009 : 08:01:12 AM
Origin Ver. and Service Release (Select Help-->About Origin): 8 SR 5
Operating System: Win XP
Hi,
I have a dataset with 7 columns, time and 6 measurement channels.
I apply a Boltzmanns fit to the data. So far so good.
I have a worksheet with extra columns for normalized data.
Now I want to normalize the y-range of each channel to 0..1
This is done as this in "set column values":
(Col(Ch 1)-41.9)/(88.9-41.9)
-I have typed in the constants which I read from the Parameters table in sheet:FitNL1
It takes S O O L O N G T I M E to do.
I need to read and type these 3 constants in each of the 6 columns for all the measurement.
How can I refer to the data in the table instead of reading and typing? |
| 3 L A T E S T R E P L I E S (Newest First) |
| greg |
Posted - 06/11/2009 : 4:14:23 PM
I updated this item to demonstrate the case where multiple datasets are involved (which seems to be your case) and I illustrated both naming conventions. |
| cal@force. |
Posted - 06/11/2009 : 05:16:17 AM
Thank you Greg.
I had to try a few times until i understood how to use the data from the results table.
The first two are myfit.p1 and myfit.p2
The next column uses myfit.p5 and myfit.p6 and so on...
Carsten |
| greg |
Posted - 06/10/2009 : 3:00:50 PM
I updated this Wiki item
http://wiki.originlab.com/~originla/howto/index.php?title=QuickHelp:How_do_I_access_analysis_result_table_values_from_script
which explains how to access the Report Sheet tree which contains fit results.
After a fit, you can use the __REPORT$ variable to find the most recent Report Sheet, but your use in Set Column Values can directly reference the Report Sheet by name. |
