August 8

Excel’s Formatting Is Screwing Up Human Gene Research

Trends

0  comments

[ad_1]

If you’re looking to keep track of things like in a database, then using Microsoft Excel is one way to go about it. It is a great spreadsheet tool that can be useful when keeping track of things like names, phone numbers, finances, and more, but it seems that no thanks to Excel’s formatting, it is messing up the research on human genes.

According to a report from The Verge, it seems that the HUGO Gene Nomenclature Committee has issued a set of guidelines for naming human genes. The need for these guidelines comes on the heels of how Excel’s automatic date formatting feature accidentally ended up altering the data by interpreting the data wrongly.

For example, when researchers entered MARCH1 to indicate Membrane Associated Ring-CH-Type Finger 1, Excel thought it was a date and formatted it as such. As a result, the committee is asking researchers to rename some of the genes to prevent future similar accidents.

While it might seem a bit trivial, the implications could be huge. This is because working with corrupted data or data that has been formatted wrongly could set back the research done by the scientists. In fact, a study from 2016 actually found that out of 3,597 papers that were published, about a fifth of them have been affected by these Excel formatting errors.

Excel’s Formatting Is Screwing Up Human Gene Research

, original content from Ubergizmo. Read our Copyrights and terms of use.

[ad_2]

Source link

About the author 

administrateur

You may also like

Solar Orbiter captures Venus glare

Solar Orbiter captures Venus glare

Gasp, Wonder Woman 1984's Patty Jenkins Also Hates Seeing the Box Office Hit By Streaming

Gasp, Wonder Woman 1984's Patty Jenkins Also Hates Seeing the Box Office Hit By Streaming

Webb completes testing and prepares for trip to Europe's Spaceport

Webb completes testing and prepares for trip to Europe's Spaceport

Leave a Reply

Your email address will not be published. Required fields are marked

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Join The SPHERE / Rejoignez La SPHÈRE