Comment on Microsoft Fixes Excel Feature That Forced Scientists to Rename Human Genes
MrScottyTay@sh.itjust.works 1 year agoI think scientists would use Excel more for finding out information with their data, not for storing it. You know like looking for trends and plotting graphs and whatnot.
lolcatnip@reddthat.com 1 year ago
I think they use it for both. They end up using it as a database because they’re familiar with it from doing data analysis. I’ve also heard of much more egregious examples, like a school using a giant Excel spreadsheet to track the applications of potential students. Need to track up to three references for each student? Make three of each column related to a reference! It’s a really gross way of storing denormalized data without any of the ACID properties databases guarantee.