Since the COVID-19 pandemic, various "human confusing behaviors" have emerged one after another.
For example, in order to expel the new crown, the American pastor ran to the TV to "jump the gods" and boasted after praying that the United States has returned to its original state ↓ ↓
Everyone should know what happened later. Anyway, the President of the United States, Mr. "Reliable", has contracted the new crown. . .
每个人都应该知道以后发生了什么。无论如何，美国总统“可靠”先生签下了新皇冠。 。 。
Some people have declared that cow dung is a panacea, as long as you bathe in cow dung + cow urine to stay away from the new coronavirus.
Of course, Trump is the most irritating. He preached that drinking disinfectant can resist the new crown virus is just his basic operation. A while ago, he also said that he did not believe that he was infected with the new crown. .
In short, no one knows the new crown better than him.
Recently, there has been another case of misleadingly confusing behavior.
At the moment when the epidemic situation abroad is severe, the United Kingdom has missed the statistics of nearly 106,000 new crown cases due to technical problems. Because there are no statistics, it has not tracked these cases and people who have contacted them.
While Shi Chao was squeezing a cold sweat for the UK, he discovered a more puzzling place, this so-called technical failure, because their Excel "exploded".
The thing is like this. . .
事情就是这样。 。 。
The COVID-19 test in the UK is operated by a third-party organization. The third party submits the daily test results to PHE (UK Public Relations and Health Department). PHE aggregates the data into an Excel template and uploads it to the central system.
There is no problem with the process itself. The problem is that the developers of PHE chose the xls file format to perform this operation.
Huh? Isn't xls just the file format of Excel? Can there be any problems?
Both xls and xlsx are common formats for Excel files, but xls is the format generated by the old version from 1993 to 2003, and xlsx is the format generated after 2007.
In addition to the difference between the new and old versions, this buddy has many differences, such as the upper limit of the number of rows in the table.
The maximum number of rows of xlsx is more than 1.04 million rows.
The maximum number of rows in xls is only over 60,000.
(Tips for Super Brand: Open Excel, press ctrl + ↓ (down arrow key) to view the upper limit of the number of rows.)
When the data of each test case occupies multiple rows, the xls template can only hold a few thousand cases at most.
what is this concept? Let's look at the UK epidemic data on the 12th. . .
这个概念是什么？让我们看一下12日的英国流行数据。 。 。
In this way, xls is certainly not enough. . .
这样，xls当然是不够的。 。 。
Although PHE is already looking for a better alternative, this wave of real battles has really suffered a lot, and Excel has also inadvertently taken the blame.
However, this is not the first time Excel has been backed up. Let me show you a farce made by this guy.
Generally speaking, each gene has an official name and abbreviation. For example, there is a gene called Membrane Associated Ring-CH Type Finger 1, its abbreviation is MARCH1.
Simply put, MARCH is March in English, and the combination of month and number will be recognized as a date by Excel.
Shi Chao tried it, and found that this thing was really something.
If the number is small, such as march20, it will be recognized as 2020/03/20. If the number is large, it will exceed the upper limit of each month's date, such as march55, he will help you change it to the year!
Ordinary people may find this stuff quite convenient, but the mentality of the scientific researcher just collapsed. I just typed in a gene name and you changed it to the date. !
Not only input will bring such operations, if you export the data to a txt or csv file, and then use Excel to open the file, you will also encounter such automatic conversion, and then you don’t know before the conversion. What is it. . .
输入不仅会带来这样的操作，如果将数据导出到txt或csv文件，然后使用Excel打开文件，您还会遇到这种自动转换，然后在转换之前就不知道了。它是什么。 。 。
And this smart operation cannot be permanently disabled.
According to a report in The Wall Street Post, one-fifth of genetics papers in top scientific journals contain similar errors.
HGNC (Gene Nomenclature Committee) was directly forced to change the names of human genes. . .
HGNC（基因命名委员会）直接被迫更改人类基因的名称。 。 。
Everyone feels how bad Excel is. . .
每个人都觉得Excel有多糟糕。 。 。
Of course, these are all special cases, and Excel works well most of the time.
In addition to simple data statistics and analysis, you can also use Excel's own templates to count monthly income and expenditures, make Gantt charts, and so on.
You can also do daily planning. . .
您还可以进行日常计划。 。 。
These are all basic operations. When you are free, you can also use Excel to make a Tetris to play with~
The following is a relatively rudimentary version. The general way of operation is to call up the development tool in Excel, and then write the code through Visual Basic.
If you are more confident in yourself, you can also learn a wave of great gods and use Excel to remake a civilization 1. . .
Or use Excel to draw a picture~
Tatsuo Horiuchi in Japan, after retiring at the age of 60, feels more relaxed, so he started to create paintings with Excel at home.
Take everyone to enjoy his paintings.
Is it completely invisible that this is done with Excel?
In Shichao’s opinion, Excel is still very useful most of the time. If it can be more mature, it would be better to be able to process the data by itself.