| Author |
 Topic  |
|
|
FelixKrohn
Germany
6 Posts |
 Posted - 07/23/2021 : 07:25:12 AM
|
Dear Forum,
I'm currently searching for a way to approach the following issue:
I measured several heigth curves of one sample. The data is present in the following form:
X-data from 0 to 3000, there's about 500 on each side as the baseline.
Z-data is the corresponding height.
Y-data is corresponding to the interval between the measurements, i.e. always 0 for the first curve, always 50 for the second curve. All data is within one table.
I have a nice XYZ plot, however, for further processing I'd like to have the baseline at 0. Currently ut's rather -12. I'm looking for some function to be able to put the curves down to 0 with respect to the X-values being, say, 0 to 500 and 2500 to 3000, as that is my baseline.
As I have multiple curves in one table, this is not as easy is doing it for a single curve with X-Y only...
Is there any way to do it? |
|
|
YimingChen
1609 Posts |
Posted - 07/23/2021 : 09:06:17 AM
|
So all your curves have the baseline at y = -12, is that right? If so, you just need to subtract -12 from all your Z columns. You set This+12 in f(x) column header cell, then double click on the lower right corner of the cell to extend the formula to all columns. See below
James |
 |
|
|
FelixKrohn
Germany
6 Posts |
Posted - 07/23/2021 : 09:23:12 AM
|
Hi, thanks for your answer.
Well, if all curves had the same value that would be too simple. That's why I'd like to calculate the average value of a given set X-Y coordinates.
I attach an image of the plot so you can see how it looks like. In that case, the Z-average of 0<X<500 with any Y-value should give me a plane as well as the Z-average of 2500<X<3000 with any Y value. This would be the baseplane I'd like to subtract from all Z-values.
 |
|
|
|
YimingChen
1609 Posts |
Posted - 07/23/2021 : 10:36:02 AM
|
I would first extract the data with 0<x<500 and 2500<x<3000. Fit the extracted data with a plane function (meanu Analysis->Fitting->Nonlinear Surface Fit). Then subtract the plane from the original data.
James |
|
|
|
FelixKrohn
Germany
6 Posts |
Posted - 07/28/2021 : 05:42:42 AM
|
Sorry, it's been a few days. I can see where this is going now.
Is there anyway to automatically extract the data for these given X-values? I looked a bit but didn't find anything. I really don't want to manually do this with 21 single curves in one table and all for 30 samples that I have.
As I said, the curves are in a format where they are all below each other in one table.X from 0 - 3000 with Y = 0, then X from 0 - 3000 with Y = 500 and so on. |
|
|
| |
Topic |
|
Normalize in XYZ-diagram