Search found 2 matches

by gerreilly
Wed Nov 18, 2009 12:43 pm
Forum: Suggestions/Questions
Topic: Automatic integration and Interrogation of Curves
Replies: 2
Views: 10375

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.
by gerreilly
Wed Nov 18, 2009 11:55 am
Forum: Suggestions/Questions
Topic: Automatic integration and Interrogation of Curves
Replies: 2
Views: 10375

Automatic integration and Interrogation of Curves

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 ...