ESdat Forums
»
Forums
»
ESdat
»
Leachate Units
Rank: Advanced Member
Groups: Registered
Posts: 78
Thanks: 1 times
|
All of our TCLP or leachable soil results are reported in mg/L. In ESdat this ends up getting reported as a water and converted to ug/L. I know that you can change your output units to reflect this but then all of the water results get reported in mg/L (when they should be in ug/L). Is there an easier way to do this?
|
|
|
|
Rank: Administration
Groups: Registered, Administrators Posts: 498 Location: Byron Bay Was thanked: 19 time(s) in 19 post(s)
|
You are correct, leachate results are typically reported against a Soil Sample (Chemistry_Samples.Matrix_Type = Soil), and have a Chemistry_Results.Result_Type = 'Leached_Reg'. The output units for leached results use the "liquid" output units specified in the zRef_Chemistry_Lookup table (or in SQL Server version zRef_Chemistry_Lookup_Profiles). This is the same output unit that is used for all liquid outputs (ie Water). There is no way of setting different units for leached results and water, but it is a good suggestion, and we will look at addressing in a future release. In the meantime, a possible workaround in the SQL Server version of ESdat is to use the "Chem Profiles" feature, which allows different output units to be used depending on the Chem Profile selected. Users can switch between chem profles on the fly. Using this you could generate a Chem Profile specifically for outputting leached soil results (ie Liquid units of mg/L), and then switch to that Profile when outputting leached data. See http://www.ESdat.net/ESdathelp/index.html?chemistry_profiles.htm For Access versions there is no equivalent workaround, other than to change your output units, do the output, then change them back, but that isn't very satisfactory.
|
|
|
|
ESdat Forums
»
Forums
»
ESdat
»
Leachate Units
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.