▲ 212 ▼ Microsoft Fixes Excel Feature That Forced Scientists to Rename Human Genes (gizmodo.com) submitted 3 years ago by L4s@lemmy.world [M, B] to c/technology@lemmy.world 24 comments fedilink hide all child comments Microsoft Fixes Excel Feature That Forced Scientists to Rename Human Genes::Microsoft now allows users to disable automatic date conversion, which means scientists no longer have to worry about using alternative names for genes.
[–] lolcatnip@reddthat.com 74 points 3 years ago (9 children) permalink fedilink source hideshow 9 child comments replies: [–] NoSpiritAnimal@lemmy.world 17 points 3 years ago* I have a spreadsheet that has been going for 20 years, across 2 companies, and hundreds of people. Thousands and thousands of lines, going back like an ice core sample. Zooming out is wild. "What's this layer?" "Oh that's when Terry worked here" permalink fedilink source parent [–] SatyrSack@lemmy.one 10 points 3 years ago (5 children) Nowhere here is it implied that they were using it instead of a database. They could run into this issue whether or not they were properly using Excel for what it is for. permalink fedilink source parent hideshow 5 child comments replies: [–] lolcatnip@reddthat.com 5 points 3 years ago (4 children) It's a well known phenomenon. The title of the article even alludes to it. permalink fedilink source parent hideshow 4 child comments replies: [–] SatyrSack@lemmy.one 2 points 3 years ago (3 children) What about the title? permalink fedilink source parent hideshow 3 child comments replies: [–] lolcatnip@reddthat.com 1 point 3 years ago (2 children) Read the article. IMHO scientists were having problems because they were using it for a task it is ill suited for. The kind of program that is designed for storing large amounts of data and preventing accidental corruption of it is a database. permalink fedilink source parent hideshow 2 child comments replies: [–] MrScottyTay@sh.itjust.works 3 points 3 years ago (1 child) I 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. permalink fedilink source parent hideshow 1 child comment replies: [–] lolcatnip@reddthat.com 1 point 3 years 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. permalink fedilink source parent [+] prole@sh.itjust.works -57 points 3 years ago* (last edited 3 years ago) (1 child) I read this meme several times trying to figure out what is supposed to be funny about it... Then I realized it's from Friends and based on a "joke" from that show. No wonder it wasn't funny. Edit: mmm yes, your downvotes only strengthen my resolve. Friends is shit and has always been shit. So unbelievably unfunny. permalink fedilink source parent hideshow 1 child comment replies: [–] Pottsunami@lemmy.world 23 points 3 years ago Who shit in your cheerios? permalink fedilink source parent
[–] NoSpiritAnimal@lemmy.world 17 points 3 years ago* I have a spreadsheet that has been going for 20 years, across 2 companies, and hundreds of people. Thousands and thousands of lines, going back like an ice core sample. Zooming out is wild. "What's this layer?" "Oh that's when Terry worked here" permalink fedilink source parent
[–] SatyrSack@lemmy.one 10 points 3 years ago (5 children) Nowhere here is it implied that they were using it instead of a database. They could run into this issue whether or not they were properly using Excel for what it is for. permalink fedilink source parent hideshow 5 child comments replies: [–] lolcatnip@reddthat.com 5 points 3 years ago (4 children) It's a well known phenomenon. The title of the article even alludes to it. permalink fedilink source parent hideshow 4 child comments replies: [–] SatyrSack@lemmy.one 2 points 3 years ago (3 children) What about the title? permalink fedilink source parent hideshow 3 child comments replies: [–] lolcatnip@reddthat.com 1 point 3 years ago (2 children) Read the article. IMHO scientists were having problems because they were using it for a task it is ill suited for. The kind of program that is designed for storing large amounts of data and preventing accidental corruption of it is a database. permalink fedilink source parent hideshow 2 child comments replies: [–] MrScottyTay@sh.itjust.works 3 points 3 years ago (1 child) I 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. permalink fedilink source parent hideshow 1 child comment replies: [–] lolcatnip@reddthat.com 1 point 3 years 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. permalink fedilink source parent
[–] lolcatnip@reddthat.com 5 points 3 years ago (4 children) It's a well known phenomenon. The title of the article even alludes to it. permalink fedilink source parent hideshow 4 child comments replies: [–] SatyrSack@lemmy.one 2 points 3 years ago (3 children) What about the title? permalink fedilink source parent hideshow 3 child comments replies: [–] lolcatnip@reddthat.com 1 point 3 years ago (2 children) Read the article. IMHO scientists were having problems because they were using it for a task it is ill suited for. The kind of program that is designed for storing large amounts of data and preventing accidental corruption of it is a database. permalink fedilink source parent hideshow 2 child comments replies: [–] MrScottyTay@sh.itjust.works 3 points 3 years ago (1 child) I 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. permalink fedilink source parent hideshow 1 child comment replies: [–] lolcatnip@reddthat.com 1 point 3 years 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. permalink fedilink source parent
[–] SatyrSack@lemmy.one 2 points 3 years ago (3 children) What about the title? permalink fedilink source parent hideshow 3 child comments replies: [–] lolcatnip@reddthat.com 1 point 3 years ago (2 children) Read the article. IMHO scientists were having problems because they were using it for a task it is ill suited for. The kind of program that is designed for storing large amounts of data and preventing accidental corruption of it is a database. permalink fedilink source parent hideshow 2 child comments replies: [–] MrScottyTay@sh.itjust.works 3 points 3 years ago (1 child) I 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. permalink fedilink source parent hideshow 1 child comment replies: [–] lolcatnip@reddthat.com 1 point 3 years 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. permalink fedilink source parent
[–] lolcatnip@reddthat.com 1 point 3 years ago (2 children) Read the article. IMHO scientists were having problems because they were using it for a task it is ill suited for. The kind of program that is designed for storing large amounts of data and preventing accidental corruption of it is a database. permalink fedilink source parent hideshow 2 child comments replies: [–] MrScottyTay@sh.itjust.works 3 points 3 years ago (1 child) I 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. permalink fedilink source parent hideshow 1 child comment replies: [–] lolcatnip@reddthat.com 1 point 3 years 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. permalink fedilink source parent
[–] MrScottyTay@sh.itjust.works 3 points 3 years ago (1 child) I 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. permalink fedilink source parent hideshow 1 child comment replies: [–] lolcatnip@reddthat.com 1 point 3 years 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. permalink fedilink source parent
[–] lolcatnip@reddthat.com 1 point 3 years 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. permalink fedilink source parent
[+] prole@sh.itjust.works -57 points 3 years ago* (last edited 3 years ago) (1 child) I read this meme several times trying to figure out what is supposed to be funny about it... Then I realized it's from Friends and based on a "joke" from that show. No wonder it wasn't funny. Edit: mmm yes, your downvotes only strengthen my resolve. Friends is shit and has always been shit. So unbelievably unfunny. permalink fedilink source parent hideshow 1 child comment replies: [–] Pottsunami@lemmy.world 23 points 3 years ago Who shit in your cheerios? permalink fedilink source parent
[–] Pottsunami@lemmy.world 23 points 3 years ago Who shit in your cheerios? permalink fedilink source parent