suppressing data in "plot vd depth"

I have a plot vs depth for shear strength and would like to include the correlation to shear strength from an SPT N-value. Is there a way to suppress the result if say the lithology symbol/classification = or("XX", "YY", ...)? or some similar expression?

Parents
  • The post here has a duscusion on how to do this. It offers 5 different methods and discusses advantages and disadvantages.

    communities.bentley.com/.../dependant-columns-in-log-template

    If you only have one column and not a lot if data you can simply place an expression in the suppress body data output property  similar to

    <<Calc(_

      <<lithology.symbol>> In ("xx","yy","zz")_

    )>>

    I do not have gINT available to me right now so have not tested the above. I am sure I don't have the syntax right but basically all you need is an expression that evaluates to true for the condition that you want to suppress.

    I can provide more info and an example in a few days if you want. In that case it would be helpful if you provided a specific example including a sample output, a picture of the data used to generate it and any relevant data tables, and a picture of the entity tab you want to modify. 

  • Thank you for your response. First i will start with a few examples of what i have tried so far. Everything has been attempted within the "output condition" section of the plot vs depth properties:

    1)

    <<IIf( _
    <<Lithology.Depth>> >= <<SAMPLE.Depth>> And <<SAMPLE.Depth>> >= <<Lithology.Bottom DEPTH>> And _
    <<LITHOLOGY.CLASSIFICATION>> = "CL" Or _
    <<LITHOLOGY.CLASSIFICATION>> = "CH" Or _
    <<LITHOLOGY.CLASSIFICATION>> = "CLS" Or _
    <<LITHOLOGY.CLASSIFICATION>> = "Pt" Or _
    <<LITHOLOGY.CLASSIFICATION>> = "OH", True, False _
    )>>

    2)

    <<IIf( _
    <<Calc( <<Lithology.Depth>> >= <<SAMPLE.Depth>> )>> And <<Calc(<<SAMPLE.Depth>> >= <<Lithology.Bottom DEPTH>> )>> And _
    <<LITHOLOGY.CLASSIFICATION>> = "CL" Or _
    <<LITHOLOGY.CLASSIFICATION>> = "CH" Or _
    <<LITHOLOGY.CLASSIFICATION>> = "CLS" Or _
    <<LITHOLOGY.CLASSIFICATION>> = "Pt" Or _
    <<LITHOLOGY.CLASSIFICATION>> = "OH", True, False _
    )>>

    3)

    <<IIf(<<LITHOLOGY.CLASSIFICATION>> = "CL" Or "CH" Or "CLS" Or "Pt" Or "OH", True, False )>>

    So far either nothing plots or everything plots. Below you will see a screenshot of the report with all the data (nothing suppressed):

    the image quality is bad, but the third plot is the SPT N-value versus depth. on the second plot i have included a crude estimate of the shear strength based on the N-value, however, i wish to only include this estimate if the strata is cohesive ("CL" Or "CH" Or "CLS" Or "Pt" Or "OH", etc.).

    The simplest thing i can think of is to check the lithology at that depth. so for example, in the plot above, i would like to suppress the "shear strength" estimate from the N-value for the first and third layers (MLS and SM).

    hope this helps, and that i made my question a bit clearer. Please let me know if you need any additional information.

Reply
  • Thank you for your response. First i will start with a few examples of what i have tried so far. Everything has been attempted within the "output condition" section of the plot vs depth properties:

    1)

    <<IIf( _
    <<Lithology.Depth>> >= <<SAMPLE.Depth>> And <<SAMPLE.Depth>> >= <<Lithology.Bottom DEPTH>> And _
    <<LITHOLOGY.CLASSIFICATION>> = "CL" Or _
    <<LITHOLOGY.CLASSIFICATION>> = "CH" Or _
    <<LITHOLOGY.CLASSIFICATION>> = "CLS" Or _
    <<LITHOLOGY.CLASSIFICATION>> = "Pt" Or _
    <<LITHOLOGY.CLASSIFICATION>> = "OH", True, False _
    )>>

    2)

    <<IIf( _
    <<Calc( <<Lithology.Depth>> >= <<SAMPLE.Depth>> )>> And <<Calc(<<SAMPLE.Depth>> >= <<Lithology.Bottom DEPTH>> )>> And _
    <<LITHOLOGY.CLASSIFICATION>> = "CL" Or _
    <<LITHOLOGY.CLASSIFICATION>> = "CH" Or _
    <<LITHOLOGY.CLASSIFICATION>> = "CLS" Or _
    <<LITHOLOGY.CLASSIFICATION>> = "Pt" Or _
    <<LITHOLOGY.CLASSIFICATION>> = "OH", True, False _
    )>>

    3)

    <<IIf(<<LITHOLOGY.CLASSIFICATION>> = "CL" Or "CH" Or "CLS" Or "Pt" Or "OH", True, False )>>

    So far either nothing plots or everything plots. Below you will see a screenshot of the report with all the data (nothing suppressed):

    the image quality is bad, but the third plot is the SPT N-value versus depth. on the second plot i have included a crude estimate of the shear strength based on the N-value, however, i wish to only include this estimate if the strata is cohesive ("CL" Or "CH" Or "CLS" Or "Pt" Or "OH", etc.).

    The simplest thing i can think of is to check the lithology at that depth. so for example, in the plot above, i would like to suppress the "shear strength" estimate from the N-value for the first and third layers (MLS and SM).

    hope this helps, and that i made my question a bit clearer. Please let me know if you need any additional information.

Children