×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Are you an
Engineering professional?
Join Eng-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• 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.

# Here is a puzzle that I've worked a

## Here is a puzzle that I've worked a

(OP)
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.

Skip,

Just traded in my OLD subtlety...
for a NUance!

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

Skip,

Just traded in my OLD subtlety...
for a NUance!

### 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
http://newtonexcelbach.wordpress.com/

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

#### Resources

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:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!