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.
Without getting into specific details of what you are trying to accomplish, the "Next" and "Previous" functions are specifically provided to help with from - to type situations when you only have a top depth or a bottom depth. See if these will help your situation.
Thank you very much Szang, you completely solve my problem. Thanks again