I want to create a lab test text column on my log report. The results in that column could be water content, fines, LL/PL, or UCS. In the column text vs. depth property I can only do 2 of these 4. I could create a 2nd column text vs depth entity, but then how do I prevent text overwriting the previous text vs. depth property when it might vary log, to log as to what is present. If everything is related to the sample depth, it would be easy, but sometimes multiple water contents are done within a sample at different depths, for example.
Basically, in my column, I want to print:
WC=12
FC=55
LL=25
PL=40
UCS=2.5
But any combination of the above may be present or not. And the hangup would be if there was a 2nd water content done halfway through the sample. Each of these has a unique depth assigned to it that is not always the sample top depth.
Hi Monique,
You can do this all in one column using a "Component Description" Library Table and Function.
Please see Help>Index>Component Descriptions for a detailed overview of how to implement this. In particular, look at the "Setting up Component Structures" article and the "Mixing Tables in the Library Tables" article.
There is also good example in the gINT Standard US Lab files in the GENERAL BH / TP / WELL report. Look at the "Tests and Remarks" column, which has these Properties:
You would need to set up the Text & Depth Expressions slightly different.
For the Text Expression, you would not need to include the ListBuildSepTrim() Function or the reference to the Remarks table.
For the Depth Expression, you could just use <<Depth>> to include data for tests not at the sample top depth.
So, your column properties would be like this:
You'd also have to set up the "TESTS" Component Description Library Table. You can create the TESTS table in Data Design>Library Tables under Tables>New Component Description Table. When prompted, you can select all the "Fields to Merge", although you probably won't use them all.
Then you have to go to Data Design>Library Data to set up the formatting for each component in your Test column. Again, see the TESTS table in gINT STandard US Lab.glb for a good example, as well as the Help articles:
Please let me know if anything doesn't work or is unclear
Jesse