How do i add weight of hammer (WOH) when the blow counts only allow real numbers. i am using gINT Logs

I have a sample that had 0 blow counts due to weight of hammer. I don't know how to make it show up as weight of hammer instead of just 0 blows.

Parents
  • There are multiple approaches to this depending on how you want the data to be treated. I am guessing you are using the gint std us Library and data structure or a close derivative of it (unfortunately) so the examples below are based on this.  Also, I am using gINT pro so your screens may look a bit different in gINT logs but I believe gINT logs is capable of modifying log forms, data structures and user system data as described (I do not guarantee it though).

    Approach 1 - Retain existing data structure and modify logs to report WOH when an entry of 0-0-0 is made for blow counts.

    Open the report you wish to modify in the report design tab.  I selected the report GEOTECH BH COLUMNS as shown in the screenshot below.  Double click in the N value column to open the column properties dialog.  In the main tab of the dialog will be a text expression box.  I am guessing this will say <<User System Data.Blows and N value>> as shown in the picture below.  This means that the actual text expression is in the user system data.

    Go to the data design tab and select the user system data subtab.  In this subtab select the Blows and N value in the drop down.  This will pull up the actual text expression and is probably as shown below.

    Modify this expression as follows.  Modifications are shown in yellow highlight in the picture below

    So, for the following data where 0 is entered for each of blows 1, 2 and 3 as shown for sample 3 in the example data table below

    The result is

    Note that WOH is only displayed if 0 is entered for all 3 blow counts.  Entering 0 for just blow 1 and 2 as shown for sample 4 does not trigger the WOH text.  This behavior could be changed if you desire.

    Note that this solution will be applied to any log that uses the Blows and N Value user system data variable. If this is not what you want then you will have to place the complete modified text that is shown in the user system data variable directly in the text expression property for the column in the log.  This will break the link to the user system data so that it will only be applied to the log being edited.

    Also note that you will not be able to show 0-0-0 or 0-0-0-0 in the report after this change as it will automatically change it to display WOH

    Approach 2 - Change the data structure so that the field type for Blows 1, 2 , 3, and 4 is text rather than Integer.

    This is done by editing the data structure in the Data design tab.  Changing the field type will allow you to enter WOH or any other text in the blow count fields which will then appear in the report. However, you will then have to check all expressions in all the reports that use the blow count data to ensure that they properly handle both numbers and text.  This can be complex  but I can help you with it if this is the way you want to go,

    There are other approaches to this and others may have better suggestions.

    Answer Verified By: Felicia Bahr 

Reply
  • There are multiple approaches to this depending on how you want the data to be treated. I am guessing you are using the gint std us Library and data structure or a close derivative of it (unfortunately) so the examples below are based on this.  Also, I am using gINT pro so your screens may look a bit different in gINT logs but I believe gINT logs is capable of modifying log forms, data structures and user system data as described (I do not guarantee it though).

    Approach 1 - Retain existing data structure and modify logs to report WOH when an entry of 0-0-0 is made for blow counts.

    Open the report you wish to modify in the report design tab.  I selected the report GEOTECH BH COLUMNS as shown in the screenshot below.  Double click in the N value column to open the column properties dialog.  In the main tab of the dialog will be a text expression box.  I am guessing this will say <<User System Data.Blows and N value>> as shown in the picture below.  This means that the actual text expression is in the user system data.

    Go to the data design tab and select the user system data subtab.  In this subtab select the Blows and N value in the drop down.  This will pull up the actual text expression and is probably as shown below.

    Modify this expression as follows.  Modifications are shown in yellow highlight in the picture below

    So, for the following data where 0 is entered for each of blows 1, 2 and 3 as shown for sample 3 in the example data table below

    The result is

    Note that WOH is only displayed if 0 is entered for all 3 blow counts.  Entering 0 for just blow 1 and 2 as shown for sample 4 does not trigger the WOH text.  This behavior could be changed if you desire.

    Note that this solution will be applied to any log that uses the Blows and N Value user system data variable. If this is not what you want then you will have to place the complete modified text that is shown in the user system data variable directly in the text expression property for the column in the log.  This will break the link to the user system data so that it will only be applied to the log being edited.

    Also note that you will not be able to show 0-0-0 or 0-0-0-0 in the report after this change as it will automatically change it to display WOH

    Approach 2 - Change the data structure so that the field type for Blows 1, 2 , 3, and 4 is text rather than Integer.

    This is done by editing the data structure in the Data design tab.  Changing the field type will allow you to enter WOH or any other text in the blow count fields which will then appear in the report. However, you will then have to check all expressions in all the reports that use the blow count data to ensure that they properly handle both numbers and text.  This can be complex  but I can help you with it if this is the way you want to go,

    There are other approaches to this and others may have better suggestions.

    Answer Verified By: Felicia Bahr 

Children
No Data