Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Here is a puzzle that I've worked a

Here is a puzzle that I've worked a

Here is a puzzle that I've worked a

Here is a puzzle that I've worked at for a while with out much result. Take profile station-elevation data, in this case stream profile data cut from a less than perfect LiDAR source, and filter the data such that only local minimum ordinances are left resulting in a station-elevation series that "drapes" on the minimum values. See the example attached. In this case the original data is plotted in blue, and I want to filter the data to result in something that resembles the red line. Any thoughts?

RE: Here is a puzzle that I've worked a

@JG, only blank for the first 94 rows.


glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Here is a puzzle that I've worked a

skip, ok I see now. I was wondering why the line still showed up with no data there ;)

RE: Here is a puzzle that I've worked a

OPs red line seemed to start around 620, hence the empty cells.


glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Here is a puzzle that I've worked a

Skip - What is the second range in the Min function for? =MIN($C$2:C94) seems to give the same (or almost same) results.

JG - Your formula and Skip's work with descending data, but if the line starts to rise they will both return a horizontal line at the minimum value.

If you use =MIN($C2:C94) (remove the $ before the 2) the line will give the minimum over a range of 93 rows, so the line will rise if the data starts to rise, but with your data that range is too small, and gives a very jagged line. Extending the line to 200 rows seems to give reasonable results.

You could also add another column with a moving average which will smooth out the steps:
In Column D, starting at row 202: =Min(C2:C201)
In Column E, starting at row 302: =Average(D202:D401)

Doug Jenkins
Interactive Design Services

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


White Paper - Reshoring Prototyping and Production
In this whitepaper, we'll provide insight into why and when it makes sense for U.S. manufacturers to reshore prototyping and production, and how companies can leverage the benefits of working with local design, prototype, and manufacturing partners during the pandemic and beyond. Download Now
Engineering Report - Top 10 Defect Types in Production
This 22-page report from Instrumental identifies the most common production defect types discovered in 2020, showcases trends from 2019 to 2020, and provides insights on how to prevent potential downtime in 2021. Unlike other methods, Instrumental drives correlations between a variety of data sources to help engineers find and fix root causes. Download Now
White Paper - Addressing Tooling and Casting Requirements at the Design Stage
Several of the tooling and casting requirements of a part can be addressed at the design stage. If these requirements are not addressed at the design stage, lot of time is spent in design iteration when the design reaches the die caster. These design issues lead to increase in time and cost of production leading to delay in time to market and reduced profits for the organization. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close