Numerical implementations

[nickapos]

(08-22-2023 08:31 PM)pier4r Wrote:  Regarding "know the limit of your tools" , "how X does Y" and reliance on Excel (and similar software); humany ends up with a lot of untestable science (and thus science that is less scientific) or lots of business waste.

Biology and Excel: https://genomebiology.biomedcentral.com/...016-1044-7
Excel messing up if the user is not attentive: https://www.youtube.com/watch?v=yb2zkxHDfUE
Enron's errors in Excel: https://figshare.com/articles/journal_co...is/1222882

and surely there are more.

Yeah, for years I used to work in the banking sector. I never treated excel as a serious package. I always had a calculator at hand to double check results (a sharp back then) and we always used certified banking software to calculate the official numbers.
The examples where excel failed to produce accurate results are just too many.