Bioequivalence and Bioavailability Forum 20:06 CEST

Main page Policy/Terms of Use Abbreviations Latest Posts

 Log in |  Register |  Search

data exchange format [Bioanalytics]

posted by martin - Austria, 2009-01-21 12:16  - Posting: # 3084
Views: 16,576

dear all !

a note on data exchange formats. in general data are used as they appear on the page but with electronic flies the situation is less obvious. some electronic file format is ambiguous concerning correct interpretation and presentation of the file contents. in MS excel, numbers may rounded internally (for example you see 2.35 but the correct number is 2.354324).

additionally, the file content is unclear and may differ from one computer system to other (or between different versions of MS excel). there is also the potential risk of macro viruses with MS excel.

for this reasons, file formats that do not suffer from these aliments should be used. I personally prefer to use CSV (ASCII) files which is an open format and you will be able to read this file error-free in 10 or more years - which may not be the case with the current or older excel (MS proprietary) format.

Best regards

Martin

Complete thread:

Activity
 Mix view
Bioequivalence and Bioavailability Forum |  Admin contact
18,783 posts in 4,003 threads, 1,258 registered users;
online 15 (0 registered, 15 guests [including 10 identified bots]).

To propose that poor design can be corrected by subtle analysis techniques
is contrary to good scientific thinking.    Stuart J. Pocock

The BIOEQUIVALENCE / BIOAVAILABILITY FORUM is hosted by
BEBAC Ing. Helmut Schütz
HTML5 RSS Feed