Page 1 of 1

Automatic integration and Interrogation of Curves

Posted: Wed Nov 18, 2009 11:55 am
by gerreilly
I need to create a set of curves by integrating a number of curves imported from Excel. Can I create a macro or script to do this and how.

Then I need to be able to extract a value from the curves that are generated by differentiating the simple XY curves in DPlot.

The value I want is plotted on the Secondary Y2 Axis, and is the value on the differentiated curve that occurs for the Maximum Y value on its corresponding XY curve.

Posted: Wed Nov 18, 2009 12:43 pm
by gerreilly
I may have found a way to do this in Excel by creating a simple formula to calculate the cumulative area under the curve for each XY value using the trapezoidal rule and then using using the VLOOKUP function to find the value that corresponds to the maximum force value in the adjacent cell.

Posted: Wed Nov 18, 2009 1:12 pm
by DPlotAdmin
Glad you found that, as it saves me some time :-)

You can integrate a curve in DPlot with the Integrate() macro command. However, there is no way to report the Y value of that curve at the maximum Y value of the first curve.