I want to get the ASTM soil description name based on Atterberg Limits only. I'm not sure how to modify the ASTM_Name function to get this.
This code gives me the ASTM Group Name when I have both SIEVE and ATTERBERG results:
<<ASTM_Name(<<SV READINGS.Reading>><<#>>,<<SV READINGS.Percent_Finer>>,_ <<ATTERBERG.Plastic_Limit>>,<<ATTERBERG.Liquid_Limit>>,_ <<ATTERBERG.Organic>>)>>
This code gives me the ASTM Group Name for soils that are visually-manually estimated to be nonplastic, where we have SIEVE but no ATTERBERG:
<<ASTM_Name(<<SV READINGS.Reading>><<#>>,<<SV READINGS.Percent_Finer>>,0,0,0)>>
What I need is the code that will give me ASTM Group Name for a soil that is visually-manually estimated to have less than 15% coarse grained soil (size larger than 0.075mm) where we have ATTERBERG but no SIEVE
Thank you.
When you say ASTM Name. Are you meaning the USCS Group Symbol. eg CH, CL, etc ??
No. The ASTM group name (i.e., Elastic Silt, Fat Clay, Silt, Lean Clay). I will revise my post above to be more descriptive.
Interesting inquiry - I can see from the practical standpoint that a reasonable question could be "Why run a sieve, if based on engineering knowledge and judgement etc, and years of lab experience, we can make our engineering recommendations based on a visual estimation without running a sieve.?" You are wanting to flow thru the graphic shown without running the sieve. Cool practical thinking. IMOIf giNT cant handle this, could you make another field on one of the tables where you could put in your estimated data as if you ran the sieve, and that field would be manually entered to say that the data is estimated?? We do something like this regarding Plasticity. We have a field called "Plasticity String" in the Atterberg table that gets populated on an import of our raw electronic lab data with the indication of "Non_Plastic" for those specimens that were non-plastic. This lets the gINT operator doing the imports know that Yes the AL was run, and the result was NP and that is why there is no number in the gINT Table, and no they did not forget to run it.
I'm sure I'm not the only person who has wanted to do this. Unfortunately I'm working with a database that my organization has indicated cannot have fields added at the moment, so I need to figure out a programming way to do it.
Seems like what you are trying to do is logically impossible. If you do not have sieve but gave atterburg limits, there are multiple ASTM names that could satisfy the data you have. For example if limits are below A line and there is less than 15 % fines then could be silty gravel (GM) or Silry Sand (SM). Could also conceivably be SP, SW, GP, GW or dual classification Also, you are mixing two different ASTM procedures. One for laboratory classification where you have limits and sieve results and one for visual manual description where you have neither. They have different percentages and criteria.