data exchange format [Bioanalytics]
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
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:
- Excel sheet usage in bioanalytical calculations chbs 2009-01-19 10:35 [Bioanalytics]
- do not use excel martin 2009-01-19 11:52
- do not use excel ? Ohlbe 2009-01-19 23:54
- Never martin 2009-01-20 14:52
- Mathematical wizard Helmut 2009-01-20 17:03
- Do not trust in computers d_labes 2009-01-21 11:00
- Do not trust in computers Helmut 2009-01-21 13:00
- Do not trust in computers Ohlbe 2009-01-21 14:03
- Do not trust in Excelence d_labes 2009-01-21 15:42
- Do not trust in computers Helmut 2009-01-22 02:49
- Do not trust in computers Ohlbe 2009-01-22 10:33
- Even my calculator... Ohlbe 2009-01-22 22:06
- Even my calculator... Helmut 2009-01-22 23:26
- Even my calculator... ElMaestro 2009-01-23 12:12
- Even my calculator... Ohlbe 2009-01-24 19:44
- Even my calculator... ElMaestro 2009-01-23 12:12
- Even my calculator... Helmut 2009-01-22 23:26
- Do not trust in computers Ohlbe 2009-01-21 14:03
- Do not trust in computers Helmut 2009-01-21 13:00
- data exchange formatmartin 2009-01-21 12:16
- Raw data (paper vs. electronic) Helmut 2009-01-21 12:31
- Mathematical wizard - use WinNonlin Tools menu instead SDavis 2009-01-22 11:56
- Do not trust in computers d_labes 2009-01-21 11:00
- Mathematical wizard Helmut 2009-01-20 17:03
- Why not use R? Helmut 2009-01-21 01:02
- Why not use R? ElMaestro 2009-01-22 19:32
- Why not use R? ElMaestro 2009-01-23 22:45
- Why not use R? Aceto81 2009-01-26 16:15
- Why not use R? d_labes 2009-01-26 16:35
- Why not use R? Aceto81 2009-01-26 16:15
- Never martin 2009-01-20 14:52
- do not use excel ? Ohlbe 2009-01-19 23:54
- do not use excel martin 2009-01-19 11:52