Excel Hunter Incident Awards

Although the operator just fills the numbers and text into the form, Excel software always seems to have his own ideas.

Automatically convert the ID number into a scientific counting method, and a large number of numbers of numbers into dates ... Not to mention the difficult movement of copying and paste form. Every error of Excel seemed to be full of "rebellion".

You will never know what the content of the cells that just fill in the cell after pressing the car.

Excel, thank you for your own passionate cleverness

Just search on the Internet, you can see various Excel answering questions and learning data packages. Maybe you once felt that "isn't it just filling in a form", but when you see these Excel incidents below, you may really want to report to a class.

Excel's use philosophy

Automatic conversion, it is better not to switch

Excel always wants to help you, the kind of help.

Microsoft's official website wrote that in order to make you easier, Excel has made some pre -programming. This makes Excel have some "thoughts" that can help us automatically correct or predict text. For example, automatically change the number or letters to the date, or delete the 0 front of the number directly. Adhering to the automatic conversion attitude of "the mountain does not turn water, the water does not turn to me", Excel helped a lot of users.

No one can stop Excel's cleverness 丨 Microsoft

But sometimes, these automatic conversion will only make users feel "rotary".

Many genethers have suffered from Excel's loss. A papers in 2016 mentioned that in the top genome school journal, 1/5 papers supplemented the genetic name in the data is wrong. In a larger scale, people collected 11,000 papers from 2014 to 2020, and found that the names of genes in almost 1/3 of the papers were written wrong.

These errors have to blame Excel's "enthusiastic intestines."

Genetic name change date ｜ The ver

In the table, when you enter the MARCH1 gene and press Enter, the genetic name will become the wrong 1-MAR (March 1). Excel "intimately" automatically identifies March1 as a date and converts it to the date standard format. Gene SEPT1 and DEC1 were not spared, thus transformed into September 1st and December 1st.

Scientists discovered this problem as early as 2004 and called on Excel to provide options to turn off automatic filling and correction. But this did not bring changes, Excel pitted more and more scientists. By 2017, HGNC, who specializes in the name of the gene, had to be changed to 27 "Excel victim genes", including SEPT4 (now SEPTIN4) and March1 (now Marchf1).

The fake news website The Allium also ironically said: The scientific community decided to surrender to Microsoft! Formally change all genetic names to date!

Since 2021, researchers Mark Ziemann has decided to release a monthly illegal journal ranking list to count the problem of genetic name errors in well-known journals 丨 ziemannn- lab.net/public/gene_name_error

Excel sowing this error is enough, because it will give the collapsed error fruit to the whole world. The five places in Britain were also pitted by Excel. In 2010, because of the data errors in the form, British military sentiment was eavesdropped by hundreds of people. Excel will automatically change the last three of the user's mobile phone number to 000, which causes 134 ordinary people who have nothing to do with the investigation, but the suspect escaped. The military situation had to be manually checked manually before each processing data.

Excel's automatic filling intelligence is probably ⬆️ 丨@meme.xlsx/twitte

Fortunately, in the Microsoft Office preview version (version number 2207) released this year, users can finally manually turn off the unnecessary automatic data conversion function, and the world -class problem is finally resolved!

Can't use functions,

You can only lose to death

Among all Excel victims, Morgan Chase should have the worst loss. In 2021, they caused 6 billion losses due to errors. They investigated the root cause behind: the function in Excel was wrong.

Morgan Chase Bank's report wrote that these advanced models and data must be manually copied to Excel. If you do not check whether the function is valid after copying errors, it may cause very serious errors in subsequent use.

Kodak has also suffered painful losses. In 2005, a employee hit a few more 0 more when using EXCEL to calculate the dismissal. As a result, the loss of the dedication fee of Kodaka reached $ 11 million. And this can be worse for Kodak, which loses $ 100 million a quarter at that time.

Whether it is EXCEL's stupidity or the user's hand trembling, the widespread application of electronic tables in data work also lays a large number of errors. In the vast cell, it is not so easy to find the problem with problems.

In order to record these serious errors, an organization that specializes in electronic meter errors appears: European electronic watch risk interest organizations (EUSPRIG). On the EUSPRIG website, we can see that many companies have used Excel because they are not skilled, and we have been a loss of millions of dollars. Studies recorded on the website show that more than 90%of the electronic tables have errors due to personal pen errors, and almost half of the electronic table models in large enterprises have "major defects". Law professor James Kwak commented on this: Even if the bank's experts are smarter and the technology is complicated, but when the number in the excel table is wrong, the form will not tell you the wrong. After all, software is software, let alone excel without threshold?

Excel use guide,

Not learning is not a civil servant

However, Excel has no threshold, which may be the biggest misunderstanding of it.

Without data review, testing, and training, even the British government officials lost their faces because they could not use Excel. In 2020, the COVID-19 case tracking system developed by the United Kingdom (12 billion pounds) (12 billion pounds) developed information about 16,000 new crown-positive cases due to errors in the form. In 2012, the financial model in Excel, the British Ministry of Communications, made an error, causing a contract of 9 billion pounds to be withdrawn and losing 300 million pounds. In 2010, EXCEL computing errors in a paper led to a sharp reduction in British public services and benefits.

After this series of incidents, Britain may really train their civil servants to learn and use Excel.

There are people who do not use tables, as well as people who play Excel. In the hands of some great gods, the Excel table draws a pixel painting can only be regarded as the basic operation. Use Excel data to draw a cowherd and weaver girl to give it to others. According to the functions and plugins in Excel, people have designed "2048" and "Selda Legend" that can play in the table.

And developers transplanted Zelda into Excel, named Excelda 丨 GameSexcel/YouTube

Even more powerful is the "Excel Championship". Financial people can solve Excel's high problems in the financial modeling World Cup (FMWC). However, in this year's game, some final players have lost the championship because of the format of the formula or copying. It seems that even the form experts cannot be spared to be tricked by Excel.

There is still a long way to learn Excel. However, thank you for asking the publisher to publish more books: 30 days to quickly give up Excel.

references

[1] 'Scientists rename human genes to stop Microsoft Excel from misreading them as dates', https://www.theverge.com/2020/8/6/21355674/human-genes-rename-microsoft-excel-misreading-dates '

[2] 'Excel autocorrect errors still plague genetic research, raising concerns over scientific rigour', https://theconversation.com/excel-autocorrect-errors-still-plague-genetic-research-raising-concerns-over-scientific-rigour -166554 '

[3] ‘AutoCorrect Errrs in Excel Still Creating Genomics Headache’,

[4] Ziemann, M., ELEN, Y., El-OSTA, a. (2016). Gene name errors are widespread in the scientific liticture. GENOME BIOLOGY, 17 (1), 1-3.

[5] Zeeberg, Barry R., Et Al. "Mistaken Identifiers: Gene name errors can be intranuced inadvertently where in bioinformatics.

[6] 'Escape Gene name-mangling with' escape excel ', https://blogs.nature.com/naturejobs/2017/02/27/escape-tene- mangling-Escape-Excel/ [7]] 'Mi5 Makes 1,061 bugging Error', https://www.theguardian.com/government- computing-network/2011/jul/01/data- errors

[8] ‘Report Details Missteps in Trading at JPMorgan’, https://archive.nytimes.com/dealbook.nytimes.com/2013/01/16/report-details-missteps-in-trading-at-jpmorgan/

[9] ’The Importance of Excel’, https://baseLineSCenario.com/2013/02/09/the- Importance- OF-Excel/

[10] http://www.eusprig.org/orror-stories.htm

[11] ‘Kodak Restates, ADDS $ 9 miss to loss’, https://www.marketwatch.com/story/kodak-earnings-dds-million-laatest-loss

[12] 'Excel errors: the UK government has an embarrassingly long history of spreadsheet horror stories'https://theconversation.com/excel-errors-the-uk-government-has-an-embarrassingly-long-history-of- SpreadSheet-Horror-Stories-147606

[13] 'Excel ESports on ESPN Show World The Pain of Format Error', https://arsestechnica.com/gaming/2022/08/excel-espn-show-the-the-format -ERRORS/

Author: Chen Moss

Edit: OWL, window knock rain

- END -