Adding SPT Graph to Fence Report

Hi All

I am new in gINT ,  i was wondering how to add SPT or CPT graph in the fence report , something similar to the below screenshot  , Thanks

  • Why an SPT graph? Just put the N-value as a Text vs Depth entity.

  • Hi Amir,

    We have a Fence Report with CPT Graphs dataset published on our Bentley Communities with their specific project, library, data template files and a text file.  You can download these CPT dataset from here

    FENCES Fence reports require gINT Professional or gINT Professional Plus. They are not available with gINT Logs. See Using gINT Downloaded Examples for instructions. Description Preview…
    Last edited in OpenGround | gINT | Keynetix > gINT | Keynetix Wiki

  • Hi Amir

    The example was made with a gINT report in the Datgel CPT Tool, you could buy a license.

    https://www.datgel.com/datgel-cpt-fence-diagram

    regards

    Phil Wade

    Phil Wade
    Datgel
    Bentley Channel Partner and Developer Partner
    E: phil.wade@datgel.com | T: +61 2 8202 8600 & +65 6631 9780

    Get the most out of gINT with Datgel Tools.

  • Hi Aparna

    I cannot open those gINT files in the new version , i am using V 10 , refer to the below screenshoot , could you advise please ?

  • Adding a graph to a fence report is a fairly straightforward task but it does involve specifying a lot of parameters to get it to look how you want and plot the data how you want.  It involves the following general steps:

    1. Start the report editor and select the fence you want to edit.  It is usually desirable to make a copy of the page first before editing so that if you screw something up you can always go back.

    2. In the report editor add a plot vs depth fence entity to the left or right of the fence post and set the width as you desire.

    3. enter an expression for the data to plot.  For SPT this could be as simple as Blows2 + blows3 or much more complex to deal with refusal, convert to N60, handle other special values etc.

    4. Enter an expression for the the depth you wish to plot the data at.  For SPT I typically use the sample bottom depth but others use the midpoint of the sample or the sample top depth.

    5. Set the symbol that you want to use on the plot.

    6. Set other options as you desire.  Look in the help file for information on all the options.

    An example plot is shown below.  It shows N60 as round dots, Moisture content as triangles, sample lengths and recoveries as hashed bars, and RQD as solid bars.  This is a complicated plot and is presented just to give you an idea of what can be done.

    The report design window that produces this plot is shown below

    Note that it uses 5 separate plot and bar graph entities all placed at the same x coordinate to built the plot by layering each plot on top of the others. The plot order of each [lot is set so that correct items are on top.

    Just looking at the N60 plot vs depth of the above and simplifying some of the inputs greatly (ie the below will not produce the example exactly but is close and is just for illustration purposes)

    The main tab looks like this:

    The data expression ads the 2nd and third blow to come up with SPT.  I actually use a much more complex expression to correct for hammer energy and deal with refusal conditions so this is just an example

    The column is left aligned because it is placed just to the right of the strata column.

    The scale is set from 0 to 50

    The overflow option is set to >>. This generates the little ">>" marks in the plot if the value exceeds the range of the plot (0-50).

    The data marker tab looks like this:

    The data marker is set to symbol 1 which is a solid circle.

    I have included an expression for data marker override expression to change the symbol to symbol 64 ( an open circle) if the user has entered WOH for the third blow count.  Again my actual expression is much more complex to deal with refusal conditions and hammer energy corrections but this just gives you an idea.

    I also use the data posting tab with fairly complex expressions to post the actual value when it is out of range of the graph but I will not show that here.

    The lines, clipping, plot fill, double plot, and plot groups tabs are all empty.

    The dashed plot lines and scales are created separately in the report. but you could use the plot entity to create them.

    The configuration tab just controls how it looks during report design.

    This gives you a very rough idea of what can be done and how to do it.  Again the help file contains a lot of information on what all the properties of the plot entities do.