After an analytical journal published in the field of Genome Biology, a staggering number of errors have been made by MS Excel related to genetics. These error-filled journals have been published by Nature, Science and PloS One; like any other journals, these also comprised of files listing the genes used in this process.
Approximately 3,600 journal articles have been inspected by a team of Australian analysts who also pinpointed errors, at least 1 in 5 of such papers contained errors after MS Excel converted these names into calendar dates or arbitrary digits.
Gene names are referred as “SEPT2” for “Septin 2”, and when these abbreviated names are typed, MS Excel has shown them as dates. Typing “SEPT2” takes to an empty cell that also becomes 2-Sep without any message. It has been programmed as 9/2/2016 by the software. To make things worse, there are no alternate ways of undoing this mistake and fiddling with any of it deletes the whole cell automatically.
According to these Australian analysts, who have reported picking the trails of these errors quite a long time ago, according to this paper. They also believe that such errors are also made by numerous open sourced programs called LibreOffice Calc and Apache OpenOffice Calc.
The harm has been done, for which the wisest thing to do for researchers is to avoid using MS Excel entirely, instead use Python that has been specifically designed for research.
For more information, click the link here.
Stay tuned to TTN for further information related to this and feel free to leave your thoughts behind under the comments section.