I'm pretty sure it's possible and saw it somewhere here. How do I put this in a single matrix, along with the descriptors like "roof angle, "1", "2E",...etc. and use it for interpolation. Well I can get by using a single column matrix as a work around but I guess I want a more compact looking solution, if that makes sense.

Look for InterpBilinear() function.
You can find more info in Reference Book.

Regards

InterpBilinear.sm (8,04 KiB) scaricato 1576 volta(e).

ohh didn't know about that. big thanks.

Surface plot is especially coded for your request.
Jean

Interpolate [Linterp, Spline2D] Copy.sm (201,25 KiB) scaricato 1374 volta(e).

Using linterp() with a function is another way.
Function selects column according to input.

Regards

linterp_select.sm (8,1 KiB) scaricato 1563 volta(e).

I'm quite satisfied with the InterpBilinear function. I'm exploring Jean's and overlord's additional suggestion but still it was already solved for me. Another question is that would that still work if I had to do interpolation in both the column values and row values such as in case below.



From what I understand, InterBilinear() seems incapable of doing what I aim to do. Do you have any suggestions?

Wrote

From what I understand, InterBilinear() seems incapable of doing what I aim to do. Do you have any suggestions ?

If, I understand your request,
ForLoop algo style will do ... last example page 10.
Jean

Interpolate [Linterp, Spline2D].sm (212,07 KiB) scaricato 1471 volta(e).

Wrote

From what I understand, InterBilinear() seems incapable of doing what I aim to do. Do you have any suggestions?

On the contrary, InterpBilinear() does exactly what you seek.
It interpolates both row and column values.
PS: I added extra values to accommodate ≤ and ≥ boundaries.

Regards

Wrote

I want a more compact looking solution, if that makes sense.

Visit Samples for bidirectional interpolating Matrix.
Jean