Re:Microsoft fixes the Excel feature that was wrecking scien...
by janeway on Monday October 23, 2023 @09:27AM
(#37985284)
I just stop working with people who request or send me data as .xlsx
[ Parent
| on HN ]
Re:Microsoft fixes the Excel feature that was wrecking scien...
by pjmlp on Monday October 23, 2023 @09:43AM
(#37985504)
Speaking from experience, that would be most people in life sciences laboratories.
Re:Microsoft fixes the Excel feature that was wrecking scien...
by chromatin on Monday October 23, 2023 @09:53AM
(#37985659)
Perversely, this is almost the exact opposite of how to solve the problem.
Speaking from experience, the real problem with scientific data (genomics, in particular) is when it is exchanged in plain-text format and then loaded IN to Excel. Automatic type inference is what fails.
Data already in Excel format can be created/modified/exchanged without unintentional conversion if the column type is correctly specified as "TEXT".
Re:Microsoft fixes the Excel feature that was wrecking scien...
by rbanffy on Monday October 23, 2023 @06:19PM
(#37992371)
True, but how do you trust something that started as a CSV and was digested into Excel?
Re:Microsoft fixes the Excel feature that was wrecking scien...
by chromatin on Tuesday October 24, 2023 @07:46AM
(#37997731)
Unless you've done it yourself carefully, you can't
Re:Microsoft fixes the Excel feature that was wrecking scien...
by scrapcode on Monday October 23, 2023 @10:01AM
(#37985769)
Working in the enterprise tech world, I'd go completely broke.
Re:Microsoft fixes the Excel feature that was wrecking scien...
by rvba on Monday October 23, 2023 @10:04AM
(#37985821)
You arent in management, nor a very flexible person?
Businesses use Excel for a reason. Nice that MS finally gave that setting, but renaming genes to be able to use a popular tool also works.
Re:Microsoft fixes the Excel feature that was wrecking scien...
by chrisamiller on Monday October 23, 2023 @01:05PM
(#37988478)
Look, I get the impulse, and might have agreed with you 10 years ago. At the end of the day, though, we have to work with non-computationally savvy people who (reasonably) want to look at their data sometimes. Not every lab tech or PI can or should learn Python/R/your favorite scripting language, and frameworks like Galaxy take time to set up and maintain, etc etc. Our job is to meet the users where they are and push the biology forward. Any time that I can push them onto a better path, I'll do that, but sometimes the right move is to tell them: "Yeah, go ahead and play with the data in excel, then tell me what you find", and I'll code something proper up afterwards to verify it, get solid stats and a make a pretty visualization.
Re:Microsoft fixes the Excel feature that was wrecking scien...
by rbanffy on Monday October 23, 2023 @06:28PM
(#37992471)
> Not every lab tech or PI can or should learn Python/R/your favorite scripting language
The amount of learning required is minimal, even more when compared to the contortionist required to process data in Excel.