quick links
Nov. 18th, 2020 11:25 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
kaberettWith gratitude to vass, courtesy of mentioning that during teaching this week I'd had to explain some of Excel's... less helpful... proclivities: Scientists rename human genes to stop Microsoft Excel from misreading them as dates.
With gratitude tome_and: perpetualBrownian motion machine.
vass, courtesy of mentioning that during teaching this week I'd had to explain some of Excel's... less helpful... proclivities: Scientists rename human genes to stop Microsoft Excel from misreading them as dates.With gratitude to
me_and:
(no subject)
Date: 2020-11-19 02:33 pm (UTC)(no subject)
Date: 2020-11-19 04:10 pm (UTC)CSVs from my banks go into a spreadsheet (specifically LibreOffice but that's not really any better than Excel), but bank accounts are one of the few things where spreadsheets actually make some sense; they have dates in weird formats that I'm glad the spreadsheet can turn into ISO8601, and otherwise very simple text and numbers, and are structured in a way that the 2D nature of a spreadsheet works nicely with.
Otherwise, in my life, structured data tends to end up in a database, or a data structure in a Python script, or something like that. (For any given user and application there might be better choices, those are just the easiest tools for me specifically to reach for.)
I appreciate that not everyone wants to deal with programming languages for managing data, leaving a gap for "simple data processing that doesn't suck".
(no subject)
Date: 2020-11-20 04:31 pm (UTC)and it'd be really nice to have software that could guarantee I could do that *without changing the data in any way*
AND YET!