Hello,
I'm trying to build an excel report showing all of the shear strength parameters, grouped by geology code. For many of the tables (Pocket Pen, Triaxial, Lab PP, etc.), there is a way to reference in the Field Geological Descriptions table and group by geology code, solving the problem. When I try to include insitu vane shear test data, however, the only parent tables I can access are the Location Details Table, meaning the in situ vane shear are always going to show all data regardless of geological code grouping presented.
I'm sure I could write a very fancy excel formula to filter manually against the known stratum layers, but it's hurting my brain in the case where there is more than one, instance of a geological code in a layer.
I've noticed SPT data can be grouped by geology code, but insitu vane shear can't. both are insitu tests. Is there any logic as to why this is?
Hi Chris, I believe it should be possible to depth link the table.
If you go to System>Configuration Packs>Select the pack>Manage Model>Select the table>Edit.
You should then see an option for "Depth Link Header", edit this and select "Depth".
Select Save.
You then want to select Manage Grids, change the Group to "Field Geological Descriptions" and move over the fields you want to include.
After this you can save the changes and should have the table linked.
Usually, the only tables you cannot depth link are ones that don't have a depth field to link.
Martyn
Answer Verified By: Christopher Schaal