Stories
Slash Boxes
Comments

SoylentNews is people

posted by chromas on Friday August 07 2020, @04:20AM   Printer-friendly
from the ' dept.

Scientists rename genes because Microsoft Excel reads them as dates:

Microsoft Excel’s automatic formatting is normally helpful for finishing spreadsheets quickly, but it’s proving to be an agent of chaos for geneticists. The Verge has learned that the HUGO Gene Nomenclature Committee has issued guidelines for naming human genes to prevent Excel’s automatic date formatting from altering data. MARCH1 (Membrane Associated Ring-CH-Type Finger 1), for example, should now be labeled MARCHF1 to stop Excel from changing it to 1-Mar.

The names of 27 genes have been changed in the past year to avoid Excel-related errors, HGNC coordinator Elspeth Bruford said. This isn’t a rare error, either, as Excel had affected about a fifth of genetics-related papers examined in a 2016 study.

Journal Reference:
Mark Ziemann, Yotam Eren, Assam El-Osta. Gene name errors are widespread in the scientific literature [open], Genome Biology (DOI: 10.1186/s13059-016-1044-7)


Original Submission

 
This discussion has been archived. No new comments can be posted.
Display Options Threshold/Breakthrough Mark All as Read Mark All as Unread
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
  • (Score: 4, Informative) by Booga1 on Friday August 07 2020, @07:11PM (2 children)

    by Booga1 (6333) on Friday August 07 2020, @07:11PM (#1033099)

    What I think should have been done differently in my opinion would have been to talk to the team leads about why certain people had poor stats. Who did they consider to be the most trustworthy and skilled team members and why. I was one of about ten team leads and they did not talk to any of us about any part of the upcoming layoffs at all.

    Part of the problem was policy based. Management policy required ALL service outage cases to be assigned to one agent to do all the customer callbacks once service was restored. Team leads would pick the best sweet talking agents with nerves of steel to handle all those angry customers. That meant a single person called back dozens of angry customers and received all the negative feedback for it. People who handled outage cases were the first to be fired because "they had poor customer service skills."

    The "slow" agents were in the second round of layoffs. Difficult cases were given to people you could trust to solve them. Anyone can handle a password reset, but only a few could handle complex database issues requiring deep dives into corrupted mailboxes to save a customer's important business data. Someone who knocked out 100 password resets had awesome stats and looked great on paper, but would never be able to solve a single one of the toughest technical cases. As part of that, agents that did the hardest work looked like the slowest and they were let go.

    Now, all that said, cases were divided into somewhat rough but reasonable categories. To address the issues with the spreadsheet itself would have required management to assign a weight to those categories. Unfortunately they did not. It still would have only solved half the problem since categories weren't really detailed enough to tell the difference between "I can't access mail because my Outlook profile is messed up" and "I can't access mail because the database got messed up during a catastrophic server failure that required a restore from backup." Any grading for difficulty of a case would be somewhat arbitrary, but it still would have been better than treating all cases as equal.

    Starting Score:    1  point
    Moderation   +2  
       Insightful=1, Informative=1, Total=2
    Extra 'Informative' Modifier   0  
    Karma-Bonus Modifier   +1  

    Total Score:   4  
  • (Score: 0) by Anonymous Coward on Friday August 07 2020, @11:34PM (1 child)

    by Anonymous Coward on Friday August 07 2020, @11:34PM (#1033249)

    My wife worked at a small (100-ish) employee place where the owner cared about the employees (family picnics, etc.), but then he sold out to a huge company and retired. They then brought in a new CEO from halfway across the country who was cut right out of the shitty napolean complex MBA CEO types. She even brought her best friend along and put her as the HR head, but of course this person wasn't an actual employee, but she ran her own small company, so HR was suddenly run by a contractor. But my story isn't about the morally and legally corrupt goings on (you used to be able to see a lot of examples of that posted on Glassdoor, at least until they started requiring employees to post 5-star ratings), but when she came in, they clumsily did that 1-2-3 rating thing, where they would get rid of you if you got a 3, etc. It was all the rage about 10 years or more ago because "Jack Welch did it, so if I'm going to be recognized as a great CEO, I'm going to do it too". What was hilarious was that they made the managers rate everybody, but in the end there was confusion whether it was the "1" or the "3" that was bad. It was all just an excuse to get rid of people "legally" by claiming they were poor performers. It sounds like that is what was going on here. It didn't matter how well the spreadsheet reflected reality, they just needed a crutch to justify reducing headcount (which means reduced costs, which means bigger CEO bonus!).

    • (Score: 2) by Booga1 on Saturday August 08 2020, @12:22AM

      by Booga1 (6333) on Saturday August 08 2020, @12:22AM (#1033260)

      I could understand that being the case in a lot of situations. Ours was different. The problems were not due to a management change or corporate buyout. Our collapse was in no small part related to the economic downturn at the time. Getting rid of the highest paid people was probably part of it, as krishnoid mentioned above. It was definitely not about manager/CEO bonuses since eventually the whole contract was canceled and everyone on that contract was let go, managers included. So, everybody got the chopping block eventually, but the spreadsheet was just used to make the cuts in ways that made very little sense to any of us(as team leads).

      Only a couple of very small side contracts that had no overlap with ours survived.