Scientists had to rename a lot of genes, which confounded Microsoft Excel

As shown, familiar to all Microsoft Excel is a serious headache for geneticists. The fact is that many of the genes are remarkably similar to the calendar date that Excel willingly and without asking puts in its own format.

And since Microsoft, for obvious reasons, not going to upgrade their product specifically for the needs of geneticists, scientists had to rename 27 human genes (for example, MARCH1). The work took about a year and recently in the scientific community was published the memo on the new names.

Excel is an important tool in any company or research lab, but he is famous for his very aggressive formatting. And since all the entered data have to be adjusted twice: first, it should make the scientist, who introduces them to the program and then the user who downloaded the data and accidentally launched a formatting – some errors slip by unnoticed. In 2016, the journal Genome Biology conducted an investigation and reported that approximately 20% of 3597 studied articles on the genetics contain errors Excel.

According to scientists developed rules, all the found genes will now get names that are unable to run the AutoCorrect feature in Microsoft Excel – for example, the gene MARCH1 now called MARCHF1 and SEPT1 – SEPTIN1.

Leave a Reply

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

Releated

Physicists have learned to turn plastic bottles in supercapacitors

Scientists from the University of California, riverside have developed a technology to produce components for supercapacitors from regular waste. We are talking about polyethylene terephthalate or PET, which is made most of plastic bottles. This material is from an economic point of view is significantly superior to high-tech raw materials, like graphene or carbon nanotubes. […]

Looks like a screwdriver of the XXI century

Recently Techcult wrote about the drill of the XXI century with a touchscreen and lasers. But the screwdriver is traditionally considered to be more simple, reliable and very straightforward tool. What similar high-tech screwdriver advanced Italian production? And it is similar to the Kinetic device Driver. Kinetic Driver designed by the Italian designer Giacomo Di […]

Our Solar system is most similar to space croissant

The sun emits powerful electromagnetic winds that envelop the planet in our solar system like a giant bubble. This magnetic bubble is called the heliosphere and protects the planet from dangerous space radiation. Scientists have long believed that the heliosphere is in the form of a comet – with a distinct nose and long flowing […]

Some homemade masks turned out to be more dangerous than no

Despite the fact that the industry has recovered from the shock of the first days of the pandemic COVID-19 and now produces enough facial masks of different types, most people in the world due to various reasons use homemade versions. Everyone understands that they are less effective than professional medical model, but the question is: […]