Identify starting points

Forum|Forum|1 year ago
January 27, 2025
2 replies
3373 views

Hi there

I have some data of depth of 10 inputs but I need the calculation to start from single point in each input and ignore the one above : for example the starting point of first input is 1.31 but its depth starts from (0) ...so I need the program to ignore all the data from 0 to 1.31 and starts at 1.31.

the second input d2 has values from 0.5 I need the program to ignore this values and starts from 1.26

so basically it eliminates all the points before the starting points I decided

Prime 10 is attached

also the excel sheet

2_starting-points.zip

1_CPT-INPUT-M21.xlsx

Best answer by terryhendicott

T

terryhendicott

21-Topaz II

Can you answer one question:

In screen grab in post all values of starting point are positive

In your file there are some negative values

Which do we follow?

T

terryhendicott

21-Topaz II

2_CPT-INPUT-M21.xlsx

1_250128-starting-points.zip

T

terryhendicott

21-Topaz II

match as a function by default looks for equal values {you can change this}. This means the depth must be in the CPT to get a match.

I have changed some of your start values to match values in the CPT's. 4.27 for 4.26, 4.15 for 4.14, 4.13 for 4.12.

If you wish to keep starting;z subscript cpt.pos as the values you have that do not appear in CPT's you can add the "geq" greater than or equal in the match function.