Grain Size Distribution Not adding up to 100

I've been encountering issues with some of my Borehole logs whether it's adding to 99 or 101 so there's a rounding issue with the numbers. How do I go about correcting this in gINT? 

FYI - relatively new user to the software.

Thanks.

Parents
  • Hi Mark,

    Individual users gINT file sets determine how both data is entered and then reported. For example some users may have gINT files set up where they are manually entering these percentages in separate columns and then rounding them on the report output.

     

    So just as an example you may have individual columns where you enter each percentage data  

     

    Gravel = 20.3 Sand = 60.2 Silt = 10.3 Clay = 9.2  

    But if you rounded those as whole numbers on the report output you get

    20+60+10+9 = 99

     

    So in order to be sure to add up to 100 when rounding to a whole number one of the values would need to be 100- the other 3 rounded numbers

    IE Clay would be (100-Gravel-Sand-Silt)

    You would need to write your own equation in gINT to match the data structure you are using in gINT. 

     

    If you are using some of the standard gINT file sets (IE gINT US LAB) you may be using some of the built – in equations, but the same as above would apply.

    Each of the values is independently calculated, so unless you compare each value with the other values there will be some cases where the numbers do not add up to 100.0%, because you are either rounding to a whole number or one decimal place for readability on the report.

     

     

    The easiest and quickest way to help you is to get your gINT files and then help you write the appropriate expressions for your files.

    Please send me a private e-mail to kirk.johnson@bentley.com With your library file (.glb) and your project file (.gpj) 

     

    Here are posts from other users, but keep in mind it was based on their custom files and not something built into the program. Your file may be (and most likely are) different.

    Hi all, I've been thinking about a problem for a while and thought that some of you might be able to help. On our logs, we show a column of %GR | SA | SI | CL on the far right side, when we have grain…
    By in OpenGround | gINT | Keynetix > gINT Forum
    9 replies

    If you would rather see a cumulative graph on your report, in gINT goto help search for Particle Size Data Represented as Bars - Logs (how-to guide)

    It provides example expressions based on gINT standard file sets (IE gINT US Lab) for a bar chart entity.

Reply
  • Hi Mark,

    Individual users gINT file sets determine how both data is entered and then reported. For example some users may have gINT files set up where they are manually entering these percentages in separate columns and then rounding them on the report output.

     

    So just as an example you may have individual columns where you enter each percentage data  

     

    Gravel = 20.3 Sand = 60.2 Silt = 10.3 Clay = 9.2  

    But if you rounded those as whole numbers on the report output you get

    20+60+10+9 = 99

     

    So in order to be sure to add up to 100 when rounding to a whole number one of the values would need to be 100- the other 3 rounded numbers

    IE Clay would be (100-Gravel-Sand-Silt)

    You would need to write your own equation in gINT to match the data structure you are using in gINT. 

     

    If you are using some of the standard gINT file sets (IE gINT US LAB) you may be using some of the built – in equations, but the same as above would apply.

    Each of the values is independently calculated, so unless you compare each value with the other values there will be some cases where the numbers do not add up to 100.0%, because you are either rounding to a whole number or one decimal place for readability on the report.

     

     

    The easiest and quickest way to help you is to get your gINT files and then help you write the appropriate expressions for your files.

    Please send me a private e-mail to kirk.johnson@bentley.com With your library file (.glb) and your project file (.gpj) 

     

    Here are posts from other users, but keep in mind it was based on their custom files and not something built into the program. Your file may be (and most likely are) different.

    Hi all, I've been thinking about a problem for a while and thought that some of you might be able to help. On our logs, we show a column of %GR | SA | SI | CL on the far right side, when we have grain…
    By in OpenGround | gINT | Keynetix > gINT Forum
    9 replies

    If you would rather see a cumulative graph on your report, in gINT goto help search for Particle Size Data Represented as Bars - Logs (how-to guide)

    It provides example expressions based on gINT standard file sets (IE gINT US Lab) for a bar chart entity.

Children
No Data