ESdat Forums
»
Forums
»
ESdat
»
exporting < values as 0.5 of LOR
 Rank: Newbie
Groups: Registered
Posts: 8  Location: Brisbane Thanks: 2 times
|
How do i export chemistry data but substitute 0.5 *LOR for the < values. We are currently posting data to dashboard and do this usign a clunky pythion interface that i want to get rid of.
|
|
|
|
|
|
 Rank: Administration
Groups: Registered, Administrators Posts: 64 Location: Sydney Thanks: 1 times
Was thanked: 7 time(s) in 7 post(s)
|
Hi Andrew - there are a few options available to you for the export. Option 1 is to open the chemistry list view, apply your filter and export to excel. The < prefix is in a separate field so applying a formula to convert the result to 0.5xLOR is much easier.  MicrosoftTeams-image (3).png (20kb) downloaded 1 time(s).
Option 2 is to use the ProUCL export option from your data migration module. This gives the results a "detect flag" so results below LOR can be converted. (see columns C, E and G below) MicrosoftTeams-image (5).png (12kb) downloaded 1 time(s).
If you are actually exporting graphs there is an option in the result display settings MicrosoftTeams-image (4).png (18kb) downloaded 0 time(s).
Regards Kimberley
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Posts: 8 Location: Brisbane Thanks: 2 times
|
Kimberly, Thanks, i am sure this used to be a function in the desktop version for output to Grapher and models. Is this not suported in the Online version ?
If not, can i please a Big request that it goes into the next Sprint.
Thanks
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Posts: 8 Location: Brisbane Thanks: 2 times
|
Kimberly, I cannot work out how to use the ProUCL option, I do not have the other formats option (see image).
I have downloaded ProUCL, the help file does not provide any guidance.
Can you pelase help?
"ProUCL is a free application produced by the USEPA. At the time of writing it can be downloaded from here. The export to ProUCL is available for chemistry data. A chemistry profile can be applied to the export, any unit conversions defined in the profile will be applied to the exported data. It is possible to include sample information such as Area, Zone, or Monitoring Unit in the export for use in ProUCL. The data is exported to excel in a format compatible for import to ProUCL. Data is sorted in the order of the selected fields."
|
|
|
|
|
|
ESdat Forums
»
Forums
»
ESdat
»
exporting < values as 0.5 of LOR
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.