• About
  • Contact
  • Disclaimer
  • Privacy & Policy
  • Home
  • Technology
  • Business
  • News
  • Health
  • Travel
  • Education
  • Food
  • Games
No Result
View All Result
CRAZY SPEED TECH
No Result
View All Result
Home Uncategorized

Human Genes Renamed To Stop Excel From Reading Them As Dates

in Uncategorized
Reading Time: 3 mins read
0
Human Genes Renamed To Stop Excel From Reading Them As Dates
Share on Twitter

Some of the most oft-used tools by scientists to create charts, lists and calculations include SQL, R, Python, Hadoop, LaTeX, and of course, Excel – which is a handy way to track work and even conduct clinical trials. However, genetic scientists in the past frequently encountered one problem that made Excel difficult to use – the fact that the program’s default system has been automatically renaming gene names into dates. A prime example is MARCH1 (membrane associated ring-CH-type finger 1). When scientists would type it into a cell, the Microsoft program would automatically convert it into the date 1-Mar. Thankfully, scientists have come up with the solution: renaming a total of 27 genes to avoid incompatibility with Excel.

How Big Was The Problem?

Without a doubt, the problem with official gene names is that they cannot simply be deleted or amended while still being useful for scientists searching for official names or abbreviations. Scientists working and using their sheets tried their best to get around it, for instance by adding comments and deleting them when they were no longer required (i.e. comments could indicate the fact that the date was in fact a gene). Subsequent deletion could be achieved easily with a right click and selection of Delete Note. Scientists could also simply amend their search, searching by date instead of by the correct genetic term. It is easy to see, however, how this system would be useless for documents needing continual or shared usage. Simply renaming birth month genes was therefore seen as an easy way to avoid meaningless or arbitrary shortcuts.

Help At Hand From The HUGO Gene Nomenclature Committee

One 2016 study by M Ziemann et al found that approximately one-fifth of all papers with Excel gene lists have erroneous gene name conversions, owing to Excel inadvertently converting gene symbols to dates. The researchers said, “the kind of errors we describe can be spotted by copying the column of gene names and pasting it into a new sheet, and then sorting the column. Any gene symbols converted to dates will appear as numbers at the top of the column.” The HUGO Gene Nomenclature Committee (HGNC) has changed the name of the 27 genes affected, additionally publishing new guidelines for naming genes, indicating the symbols that affect data handling and retrieval.

Genetic scientists need no longer fear that their data will be erroneously converted into dates. Potentially problematic gene names have been changed, and new guidelines have been published. This will enable data lists to remain unaffected by conversion, easing searches for the relevant genes.

Related Posts

What Is The Best Way To Choose Quality Delta 8 THC Carts Wholesale?

What Is The Best Way To Choose Quality Delta 8 THC Carts Wholesale?

June 13, 2022
When to Hire a Construction Attorney?

When to Hire a Construction Attorney?

March 11, 2022

Dogecoin Rally: What Should Investors Know?

April 1, 2022
Thethaobet Online Lottery

A Unique Gaming Experience with Thethaobet Online Lottery

January 10, 2022

Leave a Reply Cancel reply

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

Recommended.

The Harmful Effects of Alcohol on the Body and Mind

The Harmful Effects of Alcohol on the Body and Mind

January 14, 2021
Why forex and not crypto in 2021

Why forex and not crypto in 2021

March 4, 2021
Best Photoshop Alternatives.

Best Photoshop Alternatives.

January 14, 2021

Gas companies are now seeing an increasing number of registrations through online application forms.

January 1, 2021

About – CRAZY SPEDD TECH

CRAZY SPEED TECH

Crazy Speed Tech is a company that provides the latest news and updates on mobile, android, apps, health, business, tech and softwares. crazy speed tech's mission is to provide people with information that they can use in their everyday lives

Follow Us

Other Categories

  • Digital Marketting
  • Games
  • Home Appliances
  • Lifestyle
  • Marketing
  • Refer & Earn
  • Fashion
  • Android
  • Entertainment
  • Currency
  • GADGETS
  • Social
  • Education
Top Online Games to Make Money

Top Online Games to Make Money

June 22, 2022
Who invented the motorized unicycle?

Who invented the motorized unicycle?

June 18, 2022
Computer Science Features to Look for in the Best Colleges for CS

Computer Science Features to Look for in the Best Colleges for CS

June 17, 2022
What Should I Keep in Mind When Playing Live Games at a Polish Casino?

What Should I Keep in Mind When Playing Live Games at a Polish Casino?

June 17, 2022

Get more stuff

Subscribe to our mailing list and get interesting stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.

we respect your privacy and take protecting it seriously

  • About
  • Contact
  • Disclaimer
  • Privacy & Policy

Crazy Speed Tech Copyright © 2015-2021. All rights reserved.

No Result
View All Result
  • 4 Harmful Medical Cannabis Myths Debunked
  • 5 Best Backpacks To Buy – Read Before You Buy One
  • 6 Things You Should Know About Oral Drug Testing
  • Appvn APK Download for Android
  • Contact Us
  • CRAZY SPEED TECH – Latest News, Apps for PC, Windows, MOD APK, APK Download & Alternatives.
  • Disclaimer
  • Facejjang Apk Download | Facejjang App Foe Android
  • Google Pixel 3 and 3 XL coming in October 2018
  • Met deze accessoires laat je de moeder van de bruid schitteren
  • Newsletter
  • Privacy Policy
  • Skønne festkjoler som aldrig går af mode
  • Tästä näet kuinka paljon morsiamet käyttävät rahaa häihin
  • Things to See and Do in Maremma, Italy
  • Truth About CBD Gummies For Sleep, Calmness, And Exercise Recovery

Crazy Speed Tech Copyright © 2015-2021. All rights reserved.