Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
Daft newbie question - formatting output tables in Excel
Options
Go to last post Go to first unread
Previous Topic Next Topic
Babbage_new  
#1 Posted : Thursday, March 17, 2011 10:53:55 PM(UTC)
Babbage_new
Rank: Newbie

Reputation:

Groups: Registered
Posts: 1
Location: Auckland, NZ

Ok, so I have the Chemistry table output and there are typically 4-6 decimal places on each of the results and that is way to much.

But the output cells are either 1. not classed as numbers so they can't be formatted in the normal way and even when changing the format to a number the tools still don't work; or 2. have text characters in the cell (such as < and >).

I just want to reduce the number of decimal places but the normal tools in Excel make no difference. I really don't want to have to re-type each cell manually so some guidance would be appreciated. Thanks

Edited by moderator Friday, October 28, 2011 3:53:05 AM(UTC)  | Reason: Not specified
Back to top
WWW

Wanna join the discussion?! Login to your ESdat Forums forum accountor Register a new forum account.
Back to top  
Support  
#2 Posted : Friday, March 25, 2011 3:47:44 AM(UTC)
Support
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 259
Location: Ballina

Was thanked: 8 time(s) in 8 post(s)

Hello,

If you have version 4.2 or higher you can change the number of significant figures to be output through the Setup - Chemistry - Significant Figures menu.  Earlier versions you can do this by modifying the query in Access or SQL Server.

If the issue is that different units would be appropiate you can modify that in the zRef_Chemistry_Lookup table.

Alex.

Edited by user Friday, October 28, 2011 3:54:17 AM(UTC)  | Reason: Not specified
Back to top
B.Clay  
#3 Posted : Tuesday, October 25, 2011 7:47:52 PM(UTC)
B.Clay
Rank: Advanced Member

Reputation:

Groups: Registered
Posts: 54
Location: Melbourne

Hi Alex,

 

I am having a similar problem. For some OCP we are having reported values of 0.10 mg/kg exported by ESdat as 0.1 mg.kg. Would changing the Significant Figures menu to 0.00 (or equvalent) also change other analytes that already export properly (ie. heavy metals = 0 mg/kg, BaP = 0.0 mg/kg)

 

Cheers

Brad 
Back to top
WWW
Support  
#4 Posted : Wednesday, October 26, 2011 12:38:50 PM(UTC)
Support
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 259
Location: Ballina

Was thanked: 8 time(s) in 8 post(s)

Hello Brad,

Trailing zeros are not reported, irrespective of the significant figures reporting.  This is because trailing zeros dont get stored in numeric fields in databases and ESdat stores the results as numeric.

Alex
Back to top
AnthonyK  
#5 Posted : Monday, May 13, 2013 4:53:20 PM(UTC)
AnthonyK
Rank: Newbie

Reputation:

Groups: Registered
Posts: 1
Location: Auckland

Hi

We're using version 4.4.14 and are having similar problems with significant figures. However, there's no Setup - Chemistry - Significant Figures menu!!

Has this been moved or is there another way of reducing the number of significnat figures? (don't really want to go to ug/kg)
Back to top
Warwick Wood  
#6 Posted : Wednesday, May 15, 2013 3:46:01 AM(UTC)
Warwick Wood
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 498
Man
Location: Byron Bay

Was thanked: 19 time(s) in 19 post(s)

Hi Anthony,

ESdat should be outputting the same number of significant figures that the data is input in?  There is no way to override that, in the SQL Server version at least (which is what URS are using).

Warwick

 
Back to top
WWW
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.

Powered by YAF.NET | YAF.NET © 2003-2024, Yet Another Forum.NET