Plot the undulation curve and find the rate of undulation

[2226]

I'm working in an excel sheet in which I need to plot a ground profile graph
from the input "Distance (along x-axis) and elevation (along y-axis) which
has 30 measured points (30 points on a graph to draw the curve).

Now I need to give this information to my boss which must include the
stating point distance and elevation, end point distance and elevation and
the rate of undulation. From this data my boss will analys the profile to
mark certain parameters as critical.

Do anybody have an idea how to do it.

 

[Shane Devenshire]

I have no idea. But in general a rate of change (in this case undulation) is
calculated using calculus, something that is not directly available in Excel
although you can write VBA routines to do it.

 

[MartinW]

Hi,

What you are talking about is called a "long section".
That is by far easier to achieve in a CAD program.

I could achieve some sort of approximation
of one in Excel, but I would need to be sitting next to you
with your actual data and knowing what your actual requirements are.

It's a bit hard to try and explain the process through a newsgroup.

Sorry I can't be more helpful, but you really need the
help of a draftsman with access to a CAD program.

Regards
Martin