News for hackers. Stuff that matters.
Re:Ask HN: What are your favorite examples of elegant software? by anthk on Monday May 02, 2022 @04:03PM (#31240174)
Excel crapped out bioinformatics. It's a turd. Period.
Re:Ask HN: What are your favorite examples of elegant software? by Closi on Tuesday May 03, 2022 @06:29AM (#31246663)
Excel has an unrealistic barrier to performance to meet if we point to the fact that a desktop spreadsheet package is not good at being used for DNA and amino acid analysis.

We don't expect any other off-the-shelf technology to meet such a wide variety of use-cases, and somehow I think the statement 'excel is bad at processing bioinformatics data' speaks a large amount about how pervasive and flexible it is.

Besides, in reality Excel actually can handle the data perfectly fine if the data is brought in correctly (i.e. Data -> Get Data and using PowerQuery rather than just importing a file and hoping Excel works out the types correctly).