Skip Navigational Links
LISTSERV email list manager
LISTSERV - LIST.UVM.EDU
LISTSERV Menu
Log In
Log In
LISTSERV 17.5 Help - ISOGEOCHEM Archives
LISTSERV Archives
LISTSERV Archives
Search Archives
Search Archives
Register
Register
Log In
Log In

ISOGEOCHEM Archives

Stable Isotope Geochemistry

ISOGEOCHEM@LIST.UVM.EDU

Menu
LISTSERV Archives LISTSERV Archives
ISOGEOCHEM Home ISOGEOCHEM Home

Log In Log In
Register Register

Subscribe or Unsubscribe Subscribe or Unsubscribe

Search Archives Search Archives
Options: Use Forum View

Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Microsoft Excel precision
From:
"Thomas L. Millican" <[log in to unmask]>
Reply To:
Stable Isotope Geochemistry <[log in to unmask]>
Date:
Sat, 3 Mar 2007 09:56:13 -0600
Content-Type:
text/plain
Parts/Attachments:
text/plain (10 lines)
Hello All,
We've been asked recently to provide results for a project in atom percent instead of the usual delta per mil notation. It took a little while to find the equations for this, so I decided to add one more place online where this could be done. What I found in the process is that if I convert delta per mil to atom percent using Excel, I get one result. If I use my old TI-30, I get a slightly different result. If I use php (http://localhost/uasil/black/isotopes/delta_to_atom_percent.php), I get the same result as with the TI-30. The results of the calculator and php are different from what I get with Excel starting with the 3rd to 5th decimal place, depending on the standard and isotope used. This degree of precision is normally adequate, but I'd expect better; particularly if I'm making a number of calculations. I'm assuming all three tools have adequate floating point precision to produce similar results for more than just a couple of decimal places. 
Why would there be differences after the 2nd decimal place with only a few calculations (in the case of delta per mil to atom percent)? I'm a little curious (concerned) as we use Excel daily for much more complicated calculations.
Thanks,
-Tom

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
University of Arkansas Stable Isotope Laboratory
http://www.uark.edu/ua/isotope/

ATOM RSS1 RSS2

LIST.UVM.EDU CataList Email List Search Powered by LISTSERV