smoothing data

Mikey_b

New Member
Joined
Dec 8, 2018
Messages
5
Hi.

Some background. I work on a vessel laying subsea cable on the bottom of the ocean.
Usually we need to draw this cable position in XY, and also in Z.
For the position in Z, we generate a profile view along the XY position. Giving the orange line in the attached screenshot.
However, since this is too spiky, we need to create a smooth line through the tops of this orange profile. Being the white line on the screenshot.
This is quite tedious to do, and I was thinking of doing it in excel.
First I was thinking of doing this in blocks of every 1mm and determining the max value in this block of 1m. But this does not work because over small sand dunes, you will have a line going wide then it should be.
Any smart people who know if something like this is possible with Excel? Would be extremely useful.
I have a text file with some sample data. Where the KP is the length along the line. Z is the height value. Is there a way to post it here?
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Ideally it is better not to have too many points. For example on more or less horizontal parts the number of points along the x-axis could be reduced. But where there is sand dunes more points are required
 
Upvote 0

Forum statistics

Threads
1,223,954
Messages
6,175,603
Members
452,658
Latest member
GStorm

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top