Skip to main content
Best answer by LucMeekes

Surely not. the lookup function requires an array as its second and third arguments, you are feeding it scalar numbers. That does not work.

Given your data matrix CPT, that (as it appears) contains depths in its first column, and (associated?) pressures in its second column, what do you want the function layers to give you? Or is it just:

LucMeekes_0-1712698295652.png

LucMeekes_1-1712698304450.png

(Note that your Layer_Classification function does not address the q sca values between 2 and 5 MPa, and gravel and Peat share the same pressure range, so gravel will never be found.

 

Success!
Luc

 

1 reply

L
LucMeekes23-Emerald IV
23-Emerald IV
April 9, 2024

You should look up the information on the lookup function in the help:

lookup(z, A, B, [modifier | f])—Looks in a vector or matrix A for a given value z, subject to the conditions of the optional modifier, and returns the value(s) in the same position(s) (that is, with the same row and column numbers) in matrix B. When the value(s) are returned, they appear in a vector in column-wise order, starting with the top left corner of B and sweeping down.

 

With that information: is your q cza m

an array?

 

Success!
Luc

Y
YA_1096379814-AlexandriteAuthor
14-Alexandrite
April 9, 2024

qcza is in MPa and z is in m , 

Do you suggest any other function can do what I want: 

I want to say if the value of qcza is between 5 and 25 MPa then the sand layer is in the depth that gives this range , 

Terms & ConditionsCookie settingsAccessibility statement