Spreadsheet addiction [Software]

posted by Helmut Homepage – Vienna, Austria, 2019-07-18 22:04 (1348 d 19:05 ago) – Posting: # 20395
Views: 12,230

Hi Shuanghe,

❝ I was interested in the method so several weeks back I played with R using data from EPAR (none of the articles gives sample size of the BE study so without going to the EPAR for this additional information you can not reproduce/validate their results at all) …

Yep. I wrote a package for this stuff. I think they were using Excel cause (a) everybody has it (b) of its flat learning curve and (c) – most important – Luther Gwaza* gave his “template” to the others.

❝ … and the difference in some comparison is 0.01% due to different rounding method used in Excel and R.

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

cround <- function(x, d) ((trunc(abs(x) * 10^d + 0.5)) / 10^d) * sign(x)
x      <- c(79.994, 79.995, 125.004, 125.005)
comp   <- data.frame(x = x, R = round(x, 2), Excel = cround(x, 2))
print(comp, row.names = FALSE)
       x      R  Excel
  79.994  79.99  79.99
  79.995  80.00  80.00
 125.004 125.00 125.00
 125.005 125.00

❝ ❝ Semitransparent colors in Excel? I don’t think that’s possible. ;-)

❝ Haha, this is where you err... :-D Actually you can do that in Excel (not that you should). At least I can in my 2013. It's ugly, but semi-transparent it is. :cool:

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)? :smoke:

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

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

Complete thread:

UA Flag
 Admin contact
22,557 posts in 4,724 threads, 1,607 registered users;
14 visitors (0 registered, 14 guests [including 6 identified bots]).
Forum time: 17:09 CEST (Europe/Vienna)

Science is wonderfully equipped to answer the question “How?”
but it gets terribly confused when you ask the question “Why?”    Erwin Chargaff

The Bioequivalence and Bioavailability Forum is hosted by
BEBAC Ing. Helmut Schütz