Original post: social.coop (Mastodon)

you are viewing a single comment's thread
view the rest of the comments
[–] 25 points 1 year ago* (last edited 1 year ago) (2 children)

The precarious stack of macros and formulae that you also can't version control properly because it's a superficially-XML-ified memory dump, not textual source code.

Almost every nontrivial use of Excel would be better off as, if not a database, at least something like a Jupyter notebook with pandas.

  • source
  • parent
  • hideshow 2 child comments
  • [–] 2 points 1 year ago (1 child)

    I do bioanalysis without a sample management system. I recently had a 1000+ sample project with 6 analytes, all samples needing a few reanalyses due to everything in this whole project being complete shit.

    I spent probably three weeks of time just tracking samples to figure out what needed what analysis through excel. It's so painful knowing that a proper python script could do it in a few seconds.

  • source
  • parent
  • hideshow 1 child comment