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.
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.
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.
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.
What’s stopping you from using a proper python script?
I haven’t even thought of that. I might just try this for fun.