Getting data from next row in gINT/ Graphic Table designs

Hello,

Currently, I have <<Design Boring>> table in <<HoleID, Depth>> format to aid plotting design lines for Jackup Leg Penetration Analysis purpose as enclosed.

The input table is so messy because I need using duplicated bottom depth to make the plotted design line uncontinuously through sand/ silt layer.

My trouble is to make Graphic table showing the design parameter from mentioned <<Design Boring>> without creating additional table, please see as below:

The desired table is in From-To format, I can get most of parameters using function like: 

<<IIF(<<DESIGN_BORING.TOP_BOTTOM>>="TOP",<<Format(<<DESIGN_BORING.SU_DESIGN_LOWER_BOUND>>,0.0)>>)>>

but I'm unable to find the way getting data from next row (i.e. the Shear strength at the bottom depth of layer which value store in the next line of "TOP" depth).

Thanks for spend your time reading my Question, please help me on the problem.

Parents Reply Children
No Data