Bioequivalence and Bioavailability Forum

OT: Spreadsheet addiction [Software]

posted by Shuanghe  – Spain, 2019-07-19 14:41 (1908 d 17:41 ago) – Posting: # 20400
Views: 16,142

Hi Helmut,

❝ Yep. I wrote a package for this stuff.

Well, you're always several steps ahead of me. I just wrote some lousy function that serves the educational purpose (for myself). My output is for 4 methods only (Z-distribution, homo- and hetero-scedastic and pragmatic) since I'm still struggling with Chow and Shao/Liu's methods. By the way, I didn't see the package in your Github page. Any plan to put it there so we can have a peek?

❝ If you want to reproduce Excel’s wacky “commercial rounding”:

❝ ...

I doubt I'll very use it but nice to know that it can be done.

❝ Well, my version is Excel 2000. BTW, navigate up to my OP and hit ctrlF5 to clear the browser’s cache / reload. Is it possible in Excel to have the color dependent on the value (the lower, the darker)?

No way. Now you just want to piss off those Excel lovers

❝

---

• Gwaza L. Adjusted Indirect Treatment Comparisons of Bioequivalence Studies. PhD Thesis: Utrecht. 2016. free resource.

Thanks. I have many articles but I didn't know about the thesis. I'll take a look at it later.

ElMaestro, apology for the off-topic posting.

Complete thread:

• Spreadsheet failures, any recent examples? ElMaestro 2019-07-18 13:43 [Software] 
  • Spreadsheet failures, any recent examples? Ohlbe 2019-07-18 14:32
    • Spreadsheet addiction Helmut 2019-07-18 16:12
      • Nasty beast Ohlbe 2019-07-18 17:30
        • Nasty beast Helmut 2019-07-18 20:26
          • Nasty beast Ohlbe 2019-07-19 11:32
            • Nasty beast ElMaestro 2019-07-19 12:32
              • Decidedly off topic Ohlbe 2019-07-19 13:38
            • OT: R limbo 101 Helmut 2019-07-19 13:00
      • Spreadsheet addiction Shuanghe 2019-07-18 18:59
        • Spreadsheet addiction Helmut 2019-07-18 20:04
          • OT: Spreadsheet addictionShuanghe 2019-07-19 12:41
            • OT: Spreadsheet addiction Helmut 2019-07-19 14:29
              • OT: Spreadsheet addiction nobody 2019-07-19 15:53
                • OT: Spreadsheet addiction Helmut 2019-07-19 19:32
    • Spreadsheet etc. failures zizou 2019-07-20 00:18
      • As designed ☺ Helmut 2019-07-20 02:12
        • As designed ☺ ElMaestro 2019-07-20 09:08
          • To round or not to round… Helmut 2019-07-20 12:53
            • To round or not to round… ElMaestro 2019-07-20 19:59
              • floating-point math is always more complex than you think it is mittyri 2019-07-20 22:43
  • Spreadsheet failures, any recent examples? Ohlbe 2020-12-10 18:43
    • Floating point arithmetic, again Helmut 2020-12-10 19:12
      • Floating point arithmetic, again ElMaestro 2020-12-10 19:40
        • Floating point arithmetic, again Ohlbe 2020-12-10 20:18
          • Floating point arithmetic, again ElMaestro 2020-12-10 21:38
            • Floating point arithmetic, again Ohlbe 2020-12-10 21:46
              • Floating point arithmetic, again ElMaestro 2020-12-10 22:05
                • Depressed Ohlbe 2020-12-10 23:35
                  • Depressed ElMaestro 2020-12-11 07:59
      • Floating point arithmetic, again Ohlbe 2020-12-10 20:13
    • From bad to worse Ohlbe 2020-12-10 22:11
      • From bad to worse mittyri 2020-12-11 00:22
      • All is good Helmut 2020-12-11 00:36
        • Float is float PharmCat 2020-12-18 20:53
          • Float is float! Helmut 2020-12-20 23:27
            • rational solution in R mittyri 2020-12-21 13:49
              • related stuff Helmut 2021-01-14 12:53
                • related stuff SDavis 2021-02-09 12:02
                  • related stuff ElMaestro 2021-02-09 19:55