{"id":19941,"date":"2013-04-22T08:02:00","date_gmt":"2013-04-22T13:02:00","guid":{"rendered":"http:\/\/quotulatiousness.ca\/blog\/?p=19941"},"modified":"2013-04-22T08:02:00","modified_gmt":"2013-04-22T13:02:00","slug":"not-news-nearly-90-of-all-spreadsheets-have-errors","status":"publish","type":"post","link":"https:\/\/quotulatiousness.ca\/blog\/2013\/04\/22\/not-news-nearly-90-of-all-spreadsheets-have-errors\/","title":{"rendered":"Not news: nearly 90% of all spreadsheets have errors"},"content":{"rendered":"<p>I&#8217;ve said it before, spreadsheets are great organizing tools and provide opportunities for both financial whizzes and ordinary folks to make <a href=\"http:\/\/articles.marketwatch.com\/2013-04-20\/finance\/38603587_1_harvard-cells-family-budgets\" target=\"_blank\">splashy, expensive errors<\/a>:<\/p>\n<blockquote><p>Microsoft Excel makes it easy for anyone to do the kind of number crunching once reserved for accountants and statisticians. But the world\u2019s best-selling spreadsheet software has also contributed to the proliferation of bad math.<\/p>\n<p>Close to 90% of spreadsheet documents contain errors, a 2008 analysis of multiple studies suggests. \u201cSpreadsheets, even after careful development, contain errors in 1% or more of all formula cells,\u201d writes Ray Panko, a professor of IT management at the University of Hawaii and an authority on bad spreadsheet practices. \u201cIn large spreadsheets with thousands of formulas, there will be dozens of undetected errors.\u201d<\/p>\n<p>Given that Microsoft says there are close to 1 billion Office users worldwide, \u201cerrors in spreadsheets are pandemic,\u201d Panko says.<\/p>\n<p>Such mistakes not only can lead to miscalculations in family budgets and distorted balance sheets at small businesses, but also might result in questionable rationales for global fiscal policy, as indicated by the case of a math error in a Harvard economics study. By failing to include certain spreadsheet cells in its calculations, the study by Harvard economists Carmen Reinhart and Kenneth Rogoff may have overstated the impact that debt burdens have on a nation\u2019s economic growth.<\/p><\/blockquote>\n<p>There&#8217;s a reason I nominated Microsoft Excel as &#8220;<a href=\"http:\/\/quotulatiousness.ca\/blog\/2013\/02\/14\/microsoft-excel-the-most-dangerous-software-on-earth\/\" target=\"_blank\">The Most Dangerous Software on Earth<\/a>&#8220;.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve said it before, spreadsheets are great organizing tools and provide opportunities for both financial whizzes and ordinary folks to make splashy, expensive errors: Microsoft Excel makes it easy for anyone to do the kind of number crunching once reserved for accountants and statisticians. But the world\u2019s best-selling spreadsheet software has also contributed to the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[831,25,15],"tags":[436,94,92],"class_list":["post-19941","post","type-post","status-publish","format-standard","hentry","category-business","category-economics","category-technology","tag-banking","tag-microsoft","tag-software"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p2hpV6-5bD","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/quotulatiousness.ca\/blog\/wp-json\/wp\/v2\/posts\/19941","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/quotulatiousness.ca\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/quotulatiousness.ca\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/quotulatiousness.ca\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/quotulatiousness.ca\/blog\/wp-json\/wp\/v2\/comments?post=19941"}],"version-history":[{"count":2,"href":"https:\/\/quotulatiousness.ca\/blog\/wp-json\/wp\/v2\/posts\/19941\/revisions"}],"predecessor-version":[{"id":19943,"href":"https:\/\/quotulatiousness.ca\/blog\/wp-json\/wp\/v2\/posts\/19941\/revisions\/19943"}],"wp:attachment":[{"href":"https:\/\/quotulatiousness.ca\/blog\/wp-json\/wp\/v2\/media?parent=19941"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quotulatiousness.ca\/blog\/wp-json\/wp\/v2\/categories?post=19941"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quotulatiousness.ca\/blog\/wp-json\/wp\/v2\/tags?post=19941"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}