Bioequivalence and Bioavailability Forum

Raw data (paper vs. electronic) [Bioanalytics]

posted by Helmut  – Vienna, Austria, 2009-01-21 13:31 (5992 d 05:10 ago) – Posting: # 3085
Views: 29,061

Dear Martin!

❝ […] 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).

Electronic flies?

See one of my lectures (slides 65-66) concerning rounding. If results have to be recalculated from printouts, results may differ if the original evaluation was based on full precision data - which may lead to avoidable discussions…

❝ I personally prefer to use CSV (ASCII) files which is an open format […]

Wonderful! This is exactly what I want from my clients. Additionally an MD5-checksum should be used to maintain data integrity. If data-files are attached to an e-mail, the checksum should be sent in a separate e-mail.

—
Dif-tor heh smusma 🖖🏼 Довге життя Україна! 
Helmut Schütz


The quality of responses received is directly proportional to the quality of the question asked. 🚮
Science Quotes

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
          • data exchange format martin 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
      • 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