D
Damian Ouch
Dear Helpers...
I have an area problem.
I need to calculate the area under a curve between any two
limits for which I do not know the equation. Further, the
curve does not exactly obey any standard funtion type
unless its the sum of many and varied restricted functions.
To help you understand my dilema, the problem is in
dealing with physical values related to my materials
behaviour assignement for the Victorian (Australia) year
12 Physics course.
I tested fishing line (2 different lengths), by adding
calibrated masses and measuring the resulting extension
through until failing point.
I have hence tabulated in Excel a lovely sheet of results
for each length of line that gives me instantaneous spring
constant values, stress values, strain values,
instantanous Youngs modulous values and of course the
mass, resulting force and extension values.
From here I was able to plot, for each line length, force
Vs extension and stress vs strain. As you probably know I
now want to be able to find varioius areas under the force
vs extension graphs in order to find elastic potential
energy and various areas under the stress vs strain graphs
in order to find strain energy per unit volume of material.
If I can do this, the assignement is done. I can email to
you the workbook so you can see exactly what I am dealing
with. I am not an excel wizard so anything that is
exceedingly technical may find a brick wall in my
brain...hehe
Please help...
Damian.
I have an area problem.
I need to calculate the area under a curve between any two
limits for which I do not know the equation. Further, the
curve does not exactly obey any standard funtion type
unless its the sum of many and varied restricted functions.
To help you understand my dilema, the problem is in
dealing with physical values related to my materials
behaviour assignement for the Victorian (Australia) year
12 Physics course.
I tested fishing line (2 different lengths), by adding
calibrated masses and measuring the resulting extension
through until failing point.
I have hence tabulated in Excel a lovely sheet of results
for each length of line that gives me instantaneous spring
constant values, stress values, strain values,
instantanous Youngs modulous values and of course the
mass, resulting force and extension values.
From here I was able to plot, for each line length, force
Vs extension and stress vs strain. As you probably know I
now want to be able to find varioius areas under the force
vs extension graphs in order to find elastic potential
energy and various areas under the stress vs strain graphs
in order to find strain energy per unit volume of material.
If I can do this, the assignement is done. I can email to
you the workbook so you can see exactly what I am dealing
with. I am not an excel wizard so anything that is
exceedingly technical may find a brick wall in my
brain...hehe
Please help...
Damian.
21