Science Scientists rename human genes to stop Microsoft Excel from misreading them as dates

tom_mai78101

The Helper Connoisseur / Ex-MineCraft Host
Staff member
There are tens of thousands of genes in the human genome: minuscule twists of DNA and RNA that combine to express all of the traits and characteristics that make each of us unique. Each gene is given a name and alphanumeric code, known as a symbol, which scientists use to coordinate research. But over the past year or so, some 27 human genes have been renamed, all because Microsoft Excel kept misreading their symbols as dates.


The problem isn’t as unexpected as it first sounds. Excel is a behemoth in the spreadsheet world and is regularly used by scientists to track their work and even conduct clinical trials. But its default settings were designed with more mundane applications in mind, so when a user inputs a gene’s alphanumeric symbol into a spreadsheet, like MARCH1 — short for “Membrane Associated Ring-CH-Type Finger 1” — Excel converts that into a date: 1-Mar.

This is extremely frustrating, even dangerous, corrupting data that scientists have to sort through by hand to restore. It’s also surprisingly widespread and affects even peer-reviewed scientific work. One study from 2016 examined genetic data shared alongside 3,597 published papers and found that roughly one-fifth had been affected by Excel errors.


“It’s really, really annoying,” Dezső Módos, a systems biologist at the Quadram Institute in the UK, told The Verge. Módos, whose job involves analyzing freshly sequenced genetic data, says Excel errors happen all the time, simply because the software is often the first thing to hand when scientists process numerical data. “It’s a widespread tool and if you are a bit computationally illiterate you will use it,” he says. “During my PhD studies I did as well!”


Read more here. (The Verge)
 
General chit-chat
Help Users
  • No one is chatting at the moment.
  • The Helper The Helper:
    what is up buddy
  • jonas jonas:
    thanks for the tip, that sounds cool. Never heard about the VCS before but seems like it should be a good match
  • tom_mai78101 tom_mai78101:
    The winter vacation left a toll on me. I missed staying up late and sleeping in late.
  • C Cherry.Grove:
    i haven't looked into it yet
  • C Cherry.Grove:
    If I could use something Python compatible it would save me some learning
  • C Cherry.Grove:
    But Unity might be easiest
  • C Cherry.Grove:
    looking at old posts here makes me happy. Makes me be all like "wow I was pretty smart in 2009"
  • C Cherry.Grove:
    mostly failing at life through adulthood really demotivated me for a while
  • C Cherry.Grove:
    ....what I don't get is why the fuck they would force us to permanently convert to a version of the game everyone fucking hated : \
  • C Cherry.Grove:
    Raid Shadow Legends texture pack smh
  • jonas jonas:
    Most people fail at life throughout their adulthood. Sometimes we get to learn from it. Usually it just feels like crap.
    +1
  • The Helper The Helper:
    What does not kill you makes you stronger is what they say
  • C Cherry.Grove:
    for real! :cool:
  • Varine Varine:
    Are we still on the topic of failing? I failed lots!
  • jonas jonas:
    If you ever want to talk about it we're here. The way I see it, you're still around. That required a few very difficult successes if you ask me:)
  • Varine Varine:
    I posted a thing here a while ago about my failures if it makes you feel better to hear about other people failing. Drugs and whatnot, I had a lot more fun than was healthy. I'm still a failure, but very few of us actually get to be the self made billionaire. Luck is the only thing that will take you as far as already having money a lot of the time, and the easiest way to get catch that is with a very wide net and the willingness to let other things loose.
  • Varine Varine:
    Have fun, do your best, something about Edison's light bulb not working until he stole it.
  • jonas jonas:
    Eh. Don't define success as being a billionaire or even millionaire. Success is about overcoming your personal challenges. And if you can get to a place in life where you can love yourself, that is winning it big time
  • jonas jonas:
    Being a billionaire probably sucks, you can't go out in public like a random person anymore and you always need a bunch of big guys following you around discreetly
  • jonas jonas:
    And you'll never know if anyone you know really likes you or is just seeing you as a big money sack
  • jonas jonas:
    Most of the best fun I've ever head was with a group of friends eating pizza or drinking a good 10$ bottle of wine, when I had maybe 100$ on my account. Or the time when I was so broke, my friends visited me with bags of ingredients and I cooked for us, because I didn't have money to buy ingredients anymore
  • jonas jonas:
    Or walking with my then-fiancee through the night until dawn, just talking
  • tom_mai78101 tom_mai78101:
    UGHHH, I truly missed the GameStop frenzy that's happening for the past 2 weeks.
  • tom_mai78101 tom_mai78101:
    I see someone invested $53K in $0.20/share, then get a 163000+% return of $43 million.

    Members online

    No members online now.

    Affiliates

    Hive Workshop NUON Dome
    Top