| T O P I C R E V I E W |
| PolisTyrol |
Posted - 10/22/2015 : 09:22:12 AM
Dear all,
I have a set of data from which I create a stress-strain plot. Now all I want to do is to calculate the maximum stress, the strain at maximum stress, the integral up until there, the first "clear" stress maximum, the strain there and the integral up until there.
On Excel, that is not very difficult and I already managed that. However, I'd like to use Origin as it allows processing large data sets and multiple importing. Ideally, I'd create another Workbook within the same Worksheet, which has one column for each of the mentioned values with one line each.
So far, I managed to write the maximum stress in one cell, but now I'm stuck. How can I tell Origin to write the strain at maximum stress, i.e., the value in column A where column B is maximum?
Here is an example: https://www.dropbox.com/s/yzjw236pqhtk5cj/Book68.ogw?dl=0
Thanks in advance,
Dietmar
Origin Ver. and Service Release (Select Help-->About Origin): 9.1.0G Sr2
Operating System: Windows 7 |
| 1 L A T E S T R E P L I E S (Newest First) |
| AmandaLu |
Posted - 10/22/2015 : 11:06:05 PM
Hi Dietmar,
To find the corresponding value in another column of the same row, you can use function Table(vd, vref, d) in Set Column Values dialog.
http://www.originlab.com/doc/LabTalk/ref/Table-func
Or, you can use levelcrossing X-Function to find the corresponding X value. For example, if your Stress values are in col(B) and Strain in col(A), and you want to output the corresponding Strain value in col(D), you can use:
levelcrossing iy:=col(2) level:=max(col(2)) oy:=col(4);
See here for the detailed information of levelcrossing:
http://www.originlab.com/doc/X-Function/ref/levelcrossing
To integrate up to the maximum, use Analysis: Mathematics: Integrate tool:
http://www.originlab.com/doc/X-Function/ref/Integ1
Thanks,
Amanda
OriginLab Technical Service
|
|
|
