3 ms·

It doesn't matter the version, if 2003 or 2020, I would never do life-threatening computations in Excel. It's just too painful and dangerous (look at how it tre

by kfk 14y ago

It doesn't matter the version, if 2003 or 2020, I would never do life-threatening computations in Excel. It's just too painful and dangerous (look at how it treates dates). But unfurtunately I don't do this much, I do mostly finance-accounting. Yet, if I did, be sure I would have to put the results in a nicely formatted Excel file.

christopheraden 14y ago
We got around the inaccuracy problems where I'm at by doing all the sensitive calculations in a more capable program (SAS where I'm at now--R when I consult), then exporting the results to Excel. It avoids most of the problems faced by the poor statistical tools in Excel. It's frustrating to think how difficult it is to cut Excel from the pipeline, but such is the dilemma with Excel being as virulent as it is.
- pseut 14y ago
  IIRC there's a plugin that lets you call R functions within excel.
  - kfk 14y ago
    I always found much easier to do all the work in R or Python and then put the results in Excel. Excel is really not a good tool for things that go beyond additions and vlookups.