[新聞] Excel問題恐致英國遺漏16000例

看板Gossiping作者 (超級扇子)時間3年前 (2020/10/06 11:21), 3年前編輯推噓59(69推 10噓 26→)
留言105則, 100人參與, 3年前最新討論串1/1
1.媒體來源: 英國衛報 2.記者署名: Alex Hern 3.完整新聞標題: How Excel may have caused loss of 16,000 Covid tests in England 4.完整新聞內文: Public Health England data error blamed on limitations of Microsoft spreadsheet 英國公衛資料缺漏錯誤歸咎於微軟試算表長度限制 A million-row limit on Microsoft’s Excel spreadsheet software may have led to Public Health England misplacing nearly 16,000 Covid test results, it is understood. The data error, which led to 15,841 positive tests being left off the official daily figures, means than 50,000 potentially infectious people may have been missed by contact tracers and not told to self-isolate. PHE was responsible for collating the test results from public and private labs, and publishing the daily updates on case count and tests performed. But the rapid development of the testing programme has meant that much of the work is still done manually, with individual labs sending PHE spreadsheets containing their results. Although the system has improved from the early days of the pandemic, when some of the work was performed with phone calls, pens and paper, it is still far from automated. In this case, the Guardian understands, one lab had sent its daily test report to PHE in the form of a CSV file – the simplest possible database format, just a list of values separated by commas. That report was then loaded into Microsoft Excel, and the new tests at the bottom were added to the main database. But while CSV files can be any size, Microsoft Excel files can only be 1,048,576 rows long – or, in older versions which PHE may have still been using, a mere 65,536. When a CSV file longer than that is opened, the bottom rows get cut off and are no longer displayed. That means that, once the lab had performed more than a million tests, it was only a matter of time before its reports failed to be read by PHE. Microsoft’s spreadsheet software is one of the world’s most popular business tools, but it is regularly implicated in errors which can be costly, or even dangerous, because of the ease with which it can be used in situations it was not designed for. In 2013, an Excel error at JPMorgan masked the loss of almost $6bn (4.6bn), after a cell mistakenly divided by the sum of two interest rates, rather than the average. The news led James Kwak, a professor of law at the University of Connecticut, to warn that Excel is “incredibly fragile”. “There is no way to trace where your data comes from, there’s no audit trail (so you can overtype numbers and not know it), and there’s no easy way to test spreadsheets, for starters. The biggest problem is that anyone can create Excel spreadsheets – badly. Because it’s so easy to use, the creation of even important spreadsheets is not restricted to people who understand programming and do it in a methodical, well-documented way,” Kwak wrote. Errors from the spreadsheet software have even changed the very foundations of human genetics. The names of 27 genes have been changed over the past year by the Human Gene Nomenclature Committee, after Microsoft’s program continually misformatted them. The genes SEPT1 and MARCH1, for instance, have been changed to SEPTIN1 and MARCHF1 after they were repeatedly turned into dates, while symbols that were common words have been altered so that grammar tools didn’t autocorrect them: WARS is now WARS1, for instance. 5.完整新聞連結 (或短網址): https://reurl.cc/7odK0l 6.備註: *修正 簡言之就是 英國使用excel表單紀錄病例資料 因為用csv傳遞數據再匯入excel檔案 csv沒有檔案大小限制但excel有列數跟欄位上限(1048576列,16384欄) 導致9/25-10/2新增的15841確診病例未上傳到總數據表 甚至有超過五萬人潛在傳染者如接觸者並未被告知居家隔離 這兩天才有人發現這個問題 讓英國新冠疫情數據飆升 -- ※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 114.43.151.199 (臺灣) ※ 文章網址: https://www.ptt.cc/bbs/Gossiping/M.1601954498.A.028.html
推
10/06 11:22, 3年前 , 1F
微軟:怪我囉==
10/06 11:22, 1F
推
10/06 11:22, 3年前 , 2F
蓋茲:關我屁事 不買新的 怪我囉
10/06 11:22, 2F
→
10/06 11:22, 3年前 , 3F
英國人連EXCEL都不會用
10/06 11:22, 3F
推
10/06 11:22, 3年前 , 4F
還在用office 2003?!
10/06 11:22, 4F
→
10/06 11:22, 3年前 , 5F
不檢驗就沒陽性啊~ 母豬政績+8+9!
10/06 11:22, 5F
噓
10/06 11:23, 3年前 , 6F
不會買access嗎?
10/06 11:23, 6F
推
10/06 11:23, 3年前 , 7F
你已成為舊版軟體的受害者
10/06 11:23, 7F
推
10/06 11:23, 3年前 , 8F
舊版軟體的受害者 讓我們繼續用xp
10/06 11:23, 8F
→
10/06 11:23, 3年前 , 9F
直接試驗集體免疫？
10/06 11:23, 9F
噓
10/06 11:23, 3年前 , 10F
啊我就怕被罵阿
10/06 11:23, 10F
推
10/06 11:24, 3年前 , 11F
不去下載OFFICE 2007版，怪我囉？
10/06 11:24, 11F
推
10/06 11:24, 3年前 , 12F
舊版最多才65535列而已
10/06 11:24, 12F
推
10/06 11:25, 3年前 , 13F
你已成為舊版軟體的受害者
10/06 11:25, 13F
推
10/06 11:25, 3年前 , 14F
英國人太廢了吧
10/06 11:25, 14F
推
10/06 11:26, 3年前 , 15F
.....不會用資料庫?
10/06 11:26, 15F
推
10/06 11:26, 3年前 , 16F
英國是多窮...買不起最新版喔
10/06 11:26, 16F
推
10/06 11:27, 3年前 , 17F
廢到爆..這也能當理由
10/06 11:27, 17F
→
10/06 11:27, 3年前 , 18F
不要邊喝下午茶邊編輯excel好嗎
10/06 11:27, 18F
→
10/06 11:27, 3年前 , 19F
這種不是要用資料庫嗎？
10/06 11:27, 19F
推
10/06 11:27, 3年前 , 20F
32/64位元的好像也有差
10/06 11:27, 20F
推
10/06 11:28, 3年前 , 21F
不會裝 office 97 嗎？還有迴紋針小幫手
10/06 11:28, 21F
推
10/06 11:28, 3年前 , 22F
還在用舊版?
10/06 11:28, 22F
噓
10/06 11:29, 3年前 , 23F
可憐 這過保了怪誰??
10/06 11:29, 23F
推
10/06 11:29, 3年前 , 24F
天才
10/06 11:29, 24F
→
10/06 11:29, 3年前 , 25F
CSV file 一直都很難用啊
10/06 11:29, 25F
推
10/06 11:30, 3年前 , 26F
應隔離未隔離 包有點大
10/06 11:30, 26F
噓
10/06 11:30, 3年前 , 27F
正版軟體的受害者
10/06 11:30, 27F
推
10/06 11:30, 3年前 , 28F
CSV那裡難用了 簡單又有效率
10/06 11:30, 28F
→
10/06 11:30, 3年前 , 29F
笑死
10/06 11:30, 29F
推
10/06 11:31, 3年前 , 30F
英式老派 讚啦
10/06 11:31, 30F
推
10/06 11:31, 3年前 , 31F
用excel笑死，沒DB team請文組的管資料嗎
10/06 11:31, 31F
推
10/06 11:31, 3年前 , 32F
還在excel 沒錢寫軟體？
10/06 11:31, 32F
→
10/06 11:32, 3年前 , 33F
EXCEL問題????哈哈哈哈ㄏ哈哈哈哈哈哈哈哈
10/06 11:32, 33F
推
10/06 11:33, 3年前 , 34F
人多必有白痴，疫情過後會好轉的<--對地球來說。
10/06 11:33, 34F
推
10/06 11:33, 3年前 , 35F
用舊版的 怪我羅
10/06 11:33, 35F
推
10/06 11:33, 3年前 , 36F
廢到笑
10/06 11:33, 36F
推
10/06 11:35, 3年前 , 37F
這個夠廢
10/06 11:35, 37F
推
10/06 11:35, 3年前 , 38F
都0202了不更新怪誰
10/06 11:35, 38F
推
10/06 11:35, 3年前 , 39F
2003才有這限制,2007以後就大很多
10/06 11:35, 39F
還有 27 則推文
還有 2 段內文
※ 編輯: xFANx (114.43.151.199 臺灣), 10/06/2020 12:07:37
推
10/06 12:05, 3年前 , 67F
還好我都用記事本
10/06 12:05, 67F
噓
10/06 12:06, 3年前 , 68F
你在偷洗產地
10/06 12:06, 68F
推
10/06 12:14, 3年前 , 69F
推7樓XD
10/06 12:14, 69F
推
10/06 12:16, 3年前 , 70F
還真的很多人把 excel 當 access 使用
10/06 12:16, 70F
→
10/06 12:16, 3年前 , 71F
怪微軟囉
10/06 12:16, 71F
推
10/06 12:19, 3年前 , 72F
英國也漠落了
10/06 12:19, 72F
推
10/06 12:24, 3年前 , 73F
一開始就不該拿excel當資料庫…
10/06 12:24, 73F
推
10/06 12:27, 3年前 , 74F
哇靠 這波夠猛
10/06 12:27, 74F
推
10/06 12:27, 3年前 , 75F
代表他們沒IT負責這塊，那些病歷是由苦命的公務員手動
10/06 12:27, 75F
→
10/06 12:28, 3年前 , 76F
複製貼上，全國的資料就在一張試算表裡，中毒就完了…
10/06 12:28, 76F
→
10/06 12:36, 3年前 , 77F
2007也有限制是 1048576 吧？
10/06 12:36, 77F
推
10/06 12:39, 3年前 , 78F
北七
10/06 12:39, 78F
推
10/06 12:40, 3年前 , 79F
竟然沒有用SQL
10/06 12:40, 79F
推
10/06 12:42, 3年前 , 80F
用excel??
10/06 12:42, 80F
→
10/06 12:46, 3年前 , 81F
CSV怪excel?
10/06 12:46, 81F
推
10/06 12:48, 3年前 , 82F
XDDDDDD 智障嗎
10/06 12:48, 82F
→
10/06 12:48, 3年前 , 83F
這樣開起來不會很慢嗎 弄個軟體很難嗎
10/06 12:48, 83F
噓
10/06 12:48, 3年前 , 84F
這招習包子早會了 不要被拉清單
10/06 12:48, 84F
推
10/06 12:56, 3年前 , 85F
2016版的也還是1048576
10/06 12:56, 85F
→
10/06 13:07, 3年前 , 86F
可以 這很英國
10/06 13:07, 86F
推
10/06 13:08, 3年前 , 87F
.....是不是窮到聘不起DBA?!
10/06 13:08, 87F
→
10/06 13:24, 3年前 , 88F
有夠智障
10/06 13:24, 88F
噓
10/06 13:50, 3年前 , 89F
微軟都0202年了還有104萬限制。連64bit版都一樣
10/06 13:50, 89F
推
10/06 13:52, 3年前 , 90F
用CSV ????
10/06 13:52, 90F
推
10/06 14:00, 3年前 , 91F
XD 其實這種事情很常發生在沒有IT支援的辦公室
10/06 14:00, 91F
推
10/06 14:09, 3年前 , 92F
這麼大的紕漏推給Excel？
10/06 14:09, 92F
推
10/06 14:41, 3年前 , 93F
......
10/06 14:41, 93F
推
10/06 15:21, 3年前 , 94F
超過10萬筆不要用excel不是常識嗎……
10/06 15:21, 94F
→
10/06 15:22, 3年前 , 95F
寫錯104萬筆
10/06 15:22, 95F
推
10/06 15:53, 3年前 , 96F
Excel:這鍋我不背哦
10/06 15:53, 96F
推
10/06 16:20, 3年前 , 97F
Excel新版64位元 上限也是百萬筆 超過請用Access或DB
10/06 16:20, 97F
推
10/06 16:40, 3年前 , 98F
超過10萬筆檔案根本打不開吧
10/06 16:40, 98F
→
10/06 17:25, 3年前 , 99F
是多窮
10/06 17:25, 99F
推
10/06 19:32, 3年前 , 100F
......慘
10/06 19:32, 100F
推
10/06 20:11, 3年前 , 101F
還敢扣死當啊不更新程式也不請專業的做
10/06 20:11, 101F
→
10/06 20:39, 3年前 , 102F
真的有廢到
10/06 20:39, 102F
推
10/06 20:53, 3年前 , 103F
高調
10/06 20:53, 103F
推
10/06 21:37, 3年前 , 104F
超過100萬行，用 excel 開的了嗎...？
10/06 21:37, 104F
推
10/06 21:55, 3年前 , 105F
3小阿
10/06 21:55, 105F
‣ 更多 xFANx 的文章
文章代碼(AID): #1VU-B20e (Gossiping)