Re:Autocorrect errors in Excel still creating genomics headache
by SonicScrub on Tuesday August 17, 2021 @04:40PM
(#28214588)
The process I had to deal with was filling out spreadsheets with data from a python-driven 3D inspection program that exported out data files in CSV format. Needless to say, these errors were inevitable for exactly the reasons you've stated. Why we didn't bypass the large, poorly formatted cumbersome spreadsheets and just directly export data via pandas? All the inspection was done by Python anyways. You tell me! Also, it did not help that the spreadsheets were not created by me, or any colleagues in my department.
God I hated working in old-school engineering/manufacturing. "That's not how we do things" is the answer to everything. I
Re:Autocorrect errors in Excel still creating genomics headache
by dragonwriter on Tuesday August 17, 2021 @07:57PM
(#28216180)
Sorry about the misplaced quote. Meant to be a quote from the immediate upthread comment. Looking back, it probably wasn't even needed, the response works fine against the comment as a whole.
If you stay in spreadsheets these problems mostly don’t occur (that is, once data entry is squared away so that the initial spreadsheet has what you want it doesn't tend to get lost), its when you move in and out of spreadsheets via text and take the path of least resistance [0] to do the transition that the problem occurs.
[0] and to be fair, there is a lot of resistance off that path.