today I'm thinking about the "don't use floating point for money" advice I hear all the time. It obviously has a lot of truth to it.

But -- Excel/Google Sheets uses floating point for all of its calculations, people use spreadsheets for money calculations all the time, and it generally seems to work just fine -- the results get rounded for display.

So I'm trying to figure out if there's a more nuanced guideline than "never use floating point for money".

@b0rk "never use floating point for money, and never use Excel for processing data where the stakes matter"

@kwf @b0rk I'd like to add more to it: Never use #Excel for anything - period!

#LibreOffice #Calc does the same but better...

@kkarhan @kwf @b0rk
When in doubt use CSV and Jupyter/Pandas/(Matplotlib).
@mrgl @kwf @b0rk I prefer TSV's (using tabs instead of commas) because I follow Genevan Nomenclature on Mathematics and that standardizes the use of comma instead of dot as seperator for non-intregers 1st decimal.
@kwf @b0rk
This post being boosted by @soatok made me assume it was about cryptography for a second