{"id":81949,"date":"2020-10-05T13:52:00","date_gmt":"2020-10-05T10:52:00","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/microsoft-excel-coding-issue-drives-big-spike-in-u-k-covid-tally\/"},"modified":"2020-10-05T13:52:00","modified_gmt":"2020-10-05T10:52:00","slug":"microsoft-excel-coding-issue-drives-big-spike-in-u-k-covid-tally","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/microsoft-excel-coding-issue-drives-big-spike-in-u-k-covid-tally\/","title":{"rendered":"#\n  Microsoft Excel coding issue drives big spike in U.K. COVID tally"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a2f168c2f025\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a2f168c2f025\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/microsoft-excel-coding-issue-drives-big-spike-in-u-k-covid-tally\/#The_Twitter_feed_of_Public_Health_England_an_executive_agency_of_the_Department_of_Health_and_Social_Care_in_the_UK\" >The Twitter feed of Public Health England, an executive agency of the Department of Health and Social Care in the U.K.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/microsoft-excel-coding-issue-drives-big-spike-in-u-k-covid-tally\/#Steve_Goldstein\" >Steve Goldstein<\/a><\/li><\/ul><\/nav><\/div>\n<p>&#8220;<strong>#<br \/>\n  Microsoft Excel coding issue drives big spike in U.K. COVID tally<br \/>\n<\/strong>&#8221;<\/p>\n<h2 class=\"article__subhead\" itemprop=\"alternativeHeadline\">\n<\/h2>\n<p><\/p>\n<div class=\"column column--full article__content\">\n<div id=\"js-article__body\" class=\"article__body article-wrap at16-col16 barrons-article-wrap\" itemprop=\"articleBody\" data-sbid=\"WP-MKTW-0000025634\">\n<div class=\"barrons-article-ad-wrapper\">\n<div data-track=\"barrons-article-ad-wrap\" class=\"barrons-article-ad sticky_item\">\n<div class=\"barrons-main-article-ad-target sticky_target body_ad\" aria-hidden=\"true\"><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div data-layout=\"inline\n              \" data-layout-mobile=\"\" class=\"\n        media-object\n        type-InsetMediaIllustration\n          inline\n  article__inset\n        article__inset--type-InsetMediaIllustration\n          article__inset--inline\n  \"><\/p>\n<figure class=\"\n        media-object-image\n        enlarge-image\n        renoImageFormat-\n        img-inline\n        article__inset__image\n      \" itemscope itemtype=\"http:\/\/schema.org\/ImageObject\"><\/p>\n<div style=\"padding-bottom:66.640625%;\" data-mobile-ratio=\"66.640625%\" data-layout-ratio=\"66.640625%\" data-subtype=\"\" class=\"image-container  responsive-media article__inset__image__image\">\n        <img decoding=\"async\" srcset=\"https:\/\/images.mktw.net\/im-240568?width=140&amp;size=1.5005861664712778 140w,\nhttps:\/\/images.mktw.net\/im-240568?width=540&amp;size=1.5005861664712778 540w,\nhttps:\/\/images.mktw.net\/im-240568?width=620&amp;size=1.5005861664712778 620w,\nhttps:\/\/images.mktw.net\/im-240568?width=700&amp;size=1.5005861664712778 700w,\nhttps:\/\/images.mktw.net\/im-240568?width=860&amp;size=1.5005861664712778 860w,\nhttps:\/\/images.mktw.net\/im-240568?width=1260&amp;size=1.5005861664712778 1260w\" sizes=\"(max-width: 140px) 100px,\n(max-width: 540px) 500px,\n(max-width: 620px) 580px,\n(max-width: 700px) 660px,\n(max-width: 860px) 820px,\n1260px\" src=\"https:\/\/images.mktw.net\/im-240568?width=620&amp;size=1.5005861664712778\" data-enlarge=\"https:\/\/images.mktw.net\/im-240568?width=1260&amp;size=1.5005861664712778\" alt=\"\" title=\"The Twitter feed of Public Health England, an executive agency of the Department of Health...\"><\/div><figcaption class=\"wsj-article-caption article__inset__image__caption\" itemprop=\"caption\">\n<h4 class=\"wsj-article-caption-content\"><span class=\"ez-toc-section\" id=\"The_Twitter_feed_of_Public_Health_England_an_executive_agency_of_the_Department_of_Health_and_Social_Care_in_the_UK\"><\/span>The Twitter feed of Public Health England, an executive agency of the Department of Health and Social Care in the U.K.<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>      <span class=\"wsj-article-credit article__inset__image__caption__credit\" itemprop=\"creator\"><br \/>\n            justin tallis\/Agence France-Presse\/Getty Images<br \/>\n          <\/span><br \/>\n  <\/figcaption><\/figure>\n<\/div>\n<p>       The official U.K. COVID-19 tally spiked this weekend \u2014 because of a backlog caused by a Microsoft Excel error.<\/p>\n<p> <a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"https:\/\/www.gov.uk\/government\/news\/phe-statement-on-delayed-reporting-of-covid-19-cases\" class=\"icon none\">According to Public Health England<\/a>, 15,841 cases between Sept. 25 and Oct. 2 weren\u2019t uploaded to the government dashboard, because the column limits on an Excel spreadsheet reached its maximum size.<\/p>\n<div class=\"paywall\">\n<div data-layout=\"inline\n              \" data-layout-mobile=\"\" class=\"\n        media-object\n        type-InsetMediaIllustration\n          inline\n  article__inset\n        article__inset--type-InsetMediaIllustration\n          article__inset--inline\n  \"><\/p>\n<figure class=\"\n        media-object-image\n        enlarge-image\n        renoImageFormat-\n        img-inline\n        article__inset__image\n      \" itemscope itemtype=\"http:\/\/schema.org\/ImageObject\"><\/p>\n<div style=\"padding-bottom:69.609375%;\" data-mobile-ratio=\"69.609375%\" data-layout-ratio=\"69.609375%\" data-subtype=\"\" class=\"image-container  responsive-media article__inset__image__image\">\n        <img decoding=\"async\" srcset=\"https:\/\/images.mktw.net\/im-240567?width=140&amp;size=1.4365881032547698 140w,\nhttps:\/\/images.mktw.net\/im-240567?width=540&amp;size=1.4365881032547698 540w,\nhttps:\/\/images.mktw.net\/im-240567?width=620&amp;size=1.4365881032547698 620w,\nhttps:\/\/images.mktw.net\/im-240567?width=700&amp;size=1.4365881032547698 700w,\nhttps:\/\/images.mktw.net\/im-240567?width=860&amp;size=1.4365881032547698 860w,\nhttps:\/\/images.mktw.net\/im-240567?width=1260&amp;size=1.4365881032547698 1260w\" sizes=\"(max-width: 140px) 100px,\n(max-width: 540px) 500px,\n(max-width: 620px) 580px,\n(max-width: 700px) 660px,\n(max-width: 860px) 820px,\n1260px\" src=\"https:\/\/images.mktw.net\/im-240567?width=620&amp;size=1.4365881032547698\" data-enlarge=\"https:\/\/images.mktw.net\/im-240567?width=1260&amp;size=1.4365881032547698\" alt=\"\" title=\"\"><\/div><figcaption class=\"wsj-article-caption article__inset__image__caption\" itemprop=\"caption\"><span class=\"wsj-article-credit article__inset__image__caption__credit\" itemprop=\"creator\"><br \/>\n             The U.K. COVID-19 dashboard showed a spike.<br \/>\n          <\/span><br \/>\n  <\/figcaption><\/figure>\n<\/div>\n<p>       The mistake was made worse because those details weren\u2019t passed to the country\u2019s test-and-trace operations. The issue has been solved by splitting the Excel files into batches, according to the Daily Mail.<\/p>\n<p>The error sent the word \u201cExcel\u201d trending on <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/social-mediaa\/\" data-internallinksmanager029f6b8e52c=\"1\" title=\"Social Media\" target=\"_blank\" rel=\"noopener\">Twitter<\/a> in the U.K.<\/p>\n<div data-layout=\"inline\n              \" data-layout-mobile=\"\" class=\"\n        media-object\n        type-InsetDynamic\n          inline\n    scope-web|mobileapps\n  article__inset\n        article__inset--type-InsetDynamic\n          article__inset--inline\n  \"><\/p>\n<div class=\"dynamic-inset-container article__inset__dynamic\">\n<style>\n        iframe.twitter-tweet {\n            width: 100% !important;\n        }\n    <\/style>\n<blockquote class=\"twitter-tweet\" lang=\"en\"><p>\n        <a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"https:\/\/twitter.com\/petertimmins3\/status\/1313042888364822528\"><\/a>\n        <\/p><\/blockquote>\n<p>    <script async src=\"https:\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script><\/div>\n<\/p><\/div>\n<div data-layout=\"inline\n              \" data-layout-mobile=\"\" class=\"\n        media-object\n        type-InsetDynamic\n          inline\n    scope-web|mobileapps\n  article__inset\n        article__inset--type-InsetDynamic\n          article__inset--inline\n  \"><\/p>\n<div class=\"dynamic-inset-container article__inset__dynamic\">\n<style>\n        iframe.twitter-tweet {\n            width: 100% !important;\n        }\n    <\/style>\n<blockquote class=\"twitter-tweet\" lang=\"en\"><p>\n        <a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"https:\/\/twitter.com\/AndyMacDroo\/status\/1313048639573499904\"><\/a>\n        <\/p><\/blockquote>\n<p>    <script async src=\"https:\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script><\/div>\n<\/p><\/div>\n<div data-layout=\"inline\n              \" data-layout-mobile=\"\" class=\"\n        media-object\n        type-InsetDynamic\n          inline\n    scope-web|mobileapps\n  article__inset\n        article__inset--type-InsetDynamic\n          article__inset--inline\n  \"><\/p>\n<div class=\"dynamic-inset-container article__inset__dynamic\">\n<style>\n        iframe.twitter-tweet {\n            width: 100% !important;\n        }\n    <\/style>\n<blockquote class=\"twitter-tweet\" lang=\"en\"><p>\n        <a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"https:\/\/twitter.com\/standupmaths\/status\/1313055411285774336\"><\/a>\n        <\/p><\/blockquote>\n<p>    <script async src=\"https:\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script><\/div>\n<\/p><\/div>\n<p>       It is, of course, not the first major error caused by Microsoft Excel miscoding. A study by economists Carmen Reinhart and Kenneth Rogoff overstated the impact debt burdens have on a nation\u2019s economic growth.<\/p>\n<p><strong>See earlier story:<\/strong> 88% of spreadsheets have errors<\/p><\/div>\n<\/div><\/div>\n<p><\/p>\n<div class=\"byline article__byline\">\n<p>      <span>By<\/span><\/p>\n<div class=\"author  hasMenu\" data-scrim='{\"type\":\"author\",\"header\":\"Steve Goldstein\",\"subhead\":\"The Wall Street Journal\",\"list\":[]}' itemscope itemprop=\"author\" itemtype=\"http:\/\/schema.org\/Person\">\n<h4 itemprop=\"name\"><span class=\"ez-toc-section\" id=\"Steve_Goldstein\"><\/span>Steve Goldstein<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<\/p><\/div>\n<\/div>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/news\/\" data-internallinksmanager029f6b8e52c=\"2\" title=\"News\" target=\"_blank\" rel=\"noopener\">News<\/a> articles, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/news\/\" target=\"_blank\" rel=\"noopener noreferrer\">News category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"http:\/\/www.marketwatch.com\/news\/story.asp?guid=%7B21004575-02D4-D4B5-4572-D6422E3AED64%7D&#038;siteid=rss&#038;rss=1\" target=\"_blank\" rel=\"noopener noreferrer\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;# Microsoft Excel coding issue drives big spike in U.K. COVID tally &#8221; The Twitter feed of Public Health England, an executive agency of the Department of Health and Social Care in the U.K. justin tallis\/Agence France-Presse\/Getty Images The official U.K. COVID-19 tally spiked this weekend \u2014 because of a backlog caused by a Microsoft&#8230;<\/p>\n","protected":false},"author":1,"featured_media":81950,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[70897],"tags":[],"class_list":["post-81949","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/81949","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=81949"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/81949\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/81950"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=81949"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=81949"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=81949"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}