symbol not showing the specified depth on logs

Hello,

I converted the boring logs from english system to metric system.

When i generate the log, i noticed GINT doesn't  show the proper SPT or SS symbol depth. Please refer to the file attached. 

In this case, each sampling is 0.45 m, however, GINT is showing a very thin symbol for SPT. 

Please let me know.

.PDF

Parents
  • Hi Pelelo,

     

    It is likely your bottom depth expression is incorrect for the changes you made. Depending on what standard file set you started from the <<User System Data. Sample Bottom Depth>> was an equation that expected sample length to be in inches and converted it to feet or cm to meters etc….. If all of the reports in your library are now in metric then you can change the user system data item and it will update all reports in your current library that use that expression for sample bottom depth. Goto Data Design…User System Data and pick sample bottom depth from the yellow dropdown. Modify the expression to be

    <<Calc(<<SAMPLE.Depth>> + <<SAMPLE.Length>>)>>

     

    CAUTION !!!

     

    This will modify every report in the library referencing that User System Data Item to the new equation. This will not work if you have other reports in your library that output in feet and you have entered Sample Length in inches.

     

    If you are unsure then the safest thing to do is modify the individual entities in the specific report.

    Goto Report design ..pick the report..double click on the column you want to modify and replace

    <<User System Data.Sample Bottom Depth>>

    with

    <<Calc(<<SAMPLE.Depth>> + <<SAMPLE.Length>>)>>

     

    You will need to do this in each column that uses sample bottom depth in depth / bottom expressions and Boundary lines etc..

     

    Alternatively you could use one of our standard file sets (library , project , and datatemplate) that are already setup for Metric input and Metric output (IE gINT std Canada, gINT std Espana  and others) They can be found here. You would need to enter your data in the project structure provided in these file sets for it to output correctly

    Available gINT Standard Reports Each set of files contains a library with report templates, a sample project and a data template. The report templates in these libraries have been designed to support…
    Last edited in OpenGround | gINT | Keynetix > gINT | Keynetix Wiki

  • Hello Kirk,

    Thanks a lot for your response. After following you comments, I prefered to use <<Calc(<<SAMPLE.Depth>> + <<SAMPLE.Length>>)>> in individual entities.

    I noticed GINT prints the logs shifted down. Please refer to the file attached. The very first sample has not blow count information and the very last one is out of the gint form.

    Another question is, since I am using only 3 blow readings per sample (instead of 4), I want GINT to get rid of the last dash line. For example if the blow counts were "3-8-9-", I noticed GINT shows the last dash as if there were a 4th blow reading, when there is not.

    please let me knowSymbols not showing the specified depth in logs.pdf

Reply
  • Hello Kirk,

    Thanks a lot for your response. After following you comments, I prefered to use <<Calc(<<SAMPLE.Depth>> + <<SAMPLE.Length>>)>> in individual entities.

    I noticed GINT prints the logs shifted down. Please refer to the file attached. The very first sample has not blow count information and the very last one is out of the gint form.

    Another question is, since I am using only 3 blow readings per sample (instead of 4), I want GINT to get rid of the last dash line. For example if the blow counts were "3-8-9-", I noticed GINT shows the last dash as if there were a 4th blow reading, when there is not.

    please let me knowSymbols not showing the specified depth in logs.pdf

Children
  • Hi Pelelo,

     

    For the three columns to the right of your Sample Graphic column they like have incorrect depth and/or bottom depth expressions, similar to your other issue.

     

    I would check each one of those columns to verify

     

    If you want the values to just show at the depth of the Sample you only need a depth expression and set it to top align With the Depth expression to be <<SAMPLE.Depth>>

     

     

    If you want the text to show in the center of the sample range then align it center, middle , check block align and your depth expression would calculate the middle

    Something like

     

    <<Calc(<<Depth>> + <<Val(<<Lookup(<<SAMPLE.Length>>,<<Depth>>)>>)>> / 2)>>

     

     

    For the issue about the dash , it is probably the syntax on the expression you have written. Your output looks like the report and expressions have been customized.

    Here is a standard shipped expression for info purposes only. It is unlikely it will work if you have modified things but will give you an idea of syntax. Notice the Delimitied carriage return , before the calculation of n value there will still be a dash before refusal.

    FOR INFO ONLY

    <<Let(Refusal Pen = <<User System Data.Refusal Penetration>>)>>_

    <<ListBuildSepTrim(_

      -,_

      <<SAMPLE.Blows 1st>>,_

      <<SAMPLE.Blows 2nd>>,_

      <<SAMPLE.Blows 3rd>>,_

      <<SAMPLE.Blows 4th>>_

    )>>_

    <<HasData(<<Get(Refusal Pen)>>,_

      /<<Get(Refusal Pen)>>,_

      <<DelimitData(_

        <<cr>>(,_

        <<Calc(<<SAMPLE.Blows 2nd>> + <<SAMPLE.Blows 3rd>>)>>,_

        )_

      )>>_

    )>>

    and here is a refusal penetration expression where length is in meters. It is likely setup for english units originally so it may be refusal calc issue

    <<Let(Pen Meters = <<SAMPLE.Length>>)>>_
    <<Let(Max Blows Pen Meters = _
    <<Calc(_
    <<DataCount(<<SAMPLE.Blows 1st>>,_
    <<SAMPLE.Blows 2nd>>,_
    <<SAMPLE.Blows 3rd>>,_
    <<SAMPLE.Blows 4th>>_
    )>> * 0.15_
    )>>_
    )>>_
    _
    <<IIf(<<HasData(<<Get(Pen Meters)>>)>> And _
    <<HasData(<<SAMPLE.Blows 1st>>)>>,_
    <<IIf(<<Get(Pen Meters)>> < <<Get(Max Blows Pen Meters)>>,_
    <<Format(_
    <<Calc(0.15 - (<<Get(Max Blows Pen Meters)>> - <<Get(Pen Meters)>>))>>,_
    0.00_
    )>>_
    )>>_
    )>>

    This is why I was suggesting originally that you may want to go with a file set predesigned for metric input and output

    Here is a completely exploded out expression that may work for you NO GUARANTEES replace the text expression in the individual report in the Blows column with this and give it a try. You might want to make another copy of the report before trying these items

    <<Let(Refusal Pen = <<Let(Pen Meters = <<SAMPLE.Length>>)>>_
    <<Let(Max Blows Pen Meters = _
    <<Calc(_
    <<DataCount(<<SAMPLE.Blows 1st>>,_
    <<SAMPLE.Blows 2nd>>,_
    <<SAMPLE.Blows 3rd>>,_
    <<SAMPLE.Blows 4th>>_
    )>> * 0.15_
    )>>_
    )>>_
    _
    <<IIf(<<HasData(<<Get(Pen Meters)>>)>> And _
    <<HasData(<<SAMPLE.Blows 1st>>)>>,_
    <<IIf(<<Get(Pen Meters)>> < <<Get(Max Blows Pen Meters)>>,_
    <<Format(_
    <<Calc(0.15 - (<<Get(Max Blows Pen Meters)>> - <<Get(Pen Meters)>>))>>,_
    0.00_
    )>>_
    )>>_
    )>>)>>_
    <<ListBuildSepTrim(_
    -,_
    <<SAMPLE.Blows 1st>>,_
    <<SAMPLE.Blows 2nd>>,_
    <<SAMPLE.Blows 3rd>>,_
    <<SAMPLE.Blows 4th>>_
    )>>_
    <<HasData(<<Get(Refusal Pen)>>,_
    /<<Get(Refusal Pen)>>,_
    <<DelimitData(_
    <<cr>>(,_
    <<Calc(<<SAMPLE.Blows 2nd>> + <<SAMPLE.Blows 3rd>>)>>,_
    )_
    )>>_
    )>>

  • Thanks Kirk,

    After following your directions, I noticed that using either <<SAMPLE.Depth>> or 

    <<Calc(<<Depth>> + <<Val(<<Lookup(<<SAMPLE.Length>>,<<Depth>>)>>)>> / 2)>>

    the only column that DOES NOT align is the blow count column. The rest of the column works with 

    <<Calc(<<Depth>> + <<Val(<<Lookup(<<SAMPLE.Length>>,<<Depth>>)>>)>> / 2)>> expression.

    Refer to the file attached. Please let me know your thoughts. 

    ThanksPDF

  • Hi Pelelo,

    It looks like for that column there may be additional issue in the "Text Expression". I can't see the entire expression but it looks to have  blank lines

    That will push down text.

    if you have 

    <<Some Text expression>>

    <<Another text expression>>

    it will push the text down.  There could be other syntax issues as well. I can't see the entire expression

    needs to be more like this format no blank lines. 

    <<Let(Refusal Pen = <<Let(Pen Meters = <<SAMPLE.Length>>)>>_
    <<Let(Max Blows Pen Meters = _
    <<Calc(_
    <<DataCount(<<SAMPLE.Blows 1st>>,_
    <<SAMPLE.Blows 2nd>>,_
    <<SAMPLE.Blows 3rd>>,_
    <<SAMPLE.Blows 4th>>_
    )>> * 0.15_
    )>>_
    )>>_
    _
    <<IIf(<<HasData(<<Get(Pen Meters)>>)>> And _
    <<HasData(<<SAMPLE.Blows 1st>>)>>,_
    <<IIf(<<Get(Pen Meters)>> < <<Get(Max Blows Pen Meters)>>,_
    <<Format(_
    <<Calc(0.15 - (<<Get(Max Blows Pen Meters)>> - <<Get(Pen Meters)>>))>>,_
    0.00_
    )>>_
    )>>_
    )>>)>>_
    <<ListBuildSepTrim(_
    -,_
    <<SAMPLE.Blows 1st>>,_
    <<SAMPLE.Blows 2nd>>,_
    <<SAMPLE.Blows 3rd>>,_
    <<SAMPLE.Blows 4th>>_
    )>>_
    <<HasData(<<Get(Refusal Pen)>>,_
    /<<Get(Refusal Pen)>>,_
    <<DelimitData(_
    <<cr>>(,_
    <<Calc(<<SAMPLE.Blows 2nd>> + <<SAMPLE.Blows 3rd>>)>>,_
    )_
    )>>_
    )>>

    It might be easier if you send us the gINT files. Library and project. If you would like to do that securely click on my name and send me a message with your contact info