{"id":26,"date":"2013-05-09T13:47:58","date_gmt":"2013-05-09T18:47:58","guid":{"rendered":"https:\/\/portfolio-perspectives.planview.com\/?p=2074"},"modified":"2016-09-27T16:42:29","modified_gmt":"2016-09-27T21:42:29","slug":"spreadsheet-complacency","status":"publish","type":"post","link":"https:\/\/blog.planview.com\/spreadsheet-complacency\/","title":{"rendered":"The Remarkable Reason Complacency for Spreadsheets May Reach Critical Mass"},"content":{"rendered":"

How One Cell Discredited the Way the World Measures the Ratio of Debt-to-GDP and What That Should Mean for\u00a0Using Spreadsheets for Finance<\/strong><\/p>\n

At every FP&A conference I have ever attended, the subject of spreadsheets comes up and those with a great argument for keeping them receive, what I perceive to be, the loudest applause. Usually the argument seems rather reasonable. For example, at the FP&A conference in San Diego earlier this year, a CFO of a Fortune 1000 company confessed that he still uses spreadsheets because it is the “ultimate ad hoc tool”. To paraphrase him: Spreadsheets are empowering; you can make them do amazing things, customize them to exactly what you want them to be, and keep massive amounts of valuable data consolidated for limited but somewhat immediate access.<\/p>\n

The problem is that whenever the groupthink has concluded that the discussion is closed, everyone returns to the modus operandi of convenience until something terrible happens.<\/p>\n

For All Countries That Manage Their Forecasts Based on the Reinhart\/Rogoff Model, That Terrible Thing Happened Last Week<\/h3>\n

According to scholars at the University of Massachusetts, the “most influential article cited in public policy and debates about debt stabilization” is wrong. Specifically, a spreadsheet error has been revealed to have excluded five countries that would have invalidated the theory that countries with a high debt: GDP ratio suffer from slow economic growth. According to Matthew Yglesias of the Slate: (Read more of the Slate article here<\/a>.)<\/p>\n

“At one point they set cell L51 equal to AVERAGE (L30:L44) when the correct procedure was AVERAGE (L30:L49). By typing wrong, they accidently left Denmark, Canada, Belgium, Austria, and Australia out of the average. When you fix the Excel error, a -0.1 percent growth rate turns into 0.2 percent growth.”<\/p><\/blockquote>\n

According to Gawker, “When other revisions were carried out, the scholars found that the true growth rate should have been 2 percent” thus disproving the politically-charged but unwavering position. (Read more of the Gawker article here<\/a>.)<\/p>\n

The Difference Between Politics and Sound Business Practices<\/h3>\n

The reason you may not have heard about this is because when economists and politicians make aberrant or incorrect public statements very little happens. As Yglesias explains, “\u2026naturally this is going to change everything. Or, rather, it will change nothing.” (Read more of the Slate article here<\/a>.)<\/p>\n

\"ExecutiveHowever, if a CFO makes an inaccurate public statement, far from little happens. The implications are massive. Stock prices and forecasts are implicated, lawyers get involved, fines assessed, and sometimes jail time is discussed.<\/p>\n

This is not to say that if you don’t move away from spreadsheets you should be worried about going to jail. Rather, it is to say that there are very important reasons to stand up to the cognitive dissonance that is especially real within the corporate financial planning community. According to Robert Kugel, CFA, SVP & Research Director of Ventana Research, new research reveals that those in leadership positions or are closest to C-level decisions will inaccurately describe their processes as effectual when they are actually not. During the Webcast of the New Benchmarks for Long-Range Planning, he cites that only 27% of study participants claim executive contributions to the long-range planning process align to corporate strategy and support process. Kugel continues:<\/p>\n

“We’ve done a good deal of research on a wide variety of core business processes so it didn’t surprise us to find that only about one-fourth of the participants in our research say that their executives communicate the company’s strategic objectives clearly and consistently. Since I’ll bet that about 100% of senior executives think that they are good communicators, there’s an obvious gap that a large majority of companies need to address.”<\/p>\n

“Another interesting point that came out of the research was that people who are in charge of running the long-range planning process are much more likely to say that their executives communicate strategy well \u2012\u2012 probably because they are closer to the informal channels of communication among senior executives.”<\/p><\/blockquote>\n

University scholars and industry analysts are in agreement by pointing out that the burden for individuals in leadership positions is fast becoming to illustrate a total confidence in their data.<\/p>\n

Gone are the days where an elaborate spreadsheet will be enough to make a business case; especially those responsible for accurately articulating corporate financials and long-term investment decisions. Economists have certainly taken this cue; and they are not worried about the threat of fines and even jail time.<\/p>\n

For more information:<\/p>\n

Watch the Webcast of the New Benchmarks for Long-Range Planning<\/p>\n

Download the Executive Summary of New Benchmarks for Long-Range Planning<\/a> by Ventana Research<\/p>\n

Related posts: Getting Your Executives Involved in Long-Range Planning<\/a> and How Last Year’s Benchmarks Compare to the Latest Research<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

How One Cell Discredited the Way the World Measures the Ratio of Debt-to-GDP and What That Should Mean for\u00a0Using Spreadsheets for Finance At every FP&A conference I have ever attended, the subject of spreadsheets comes up and those with a great argument for keeping them receive, what I perceive to be, the loudest applause. Usually…<\/p>\n","protected":false},"author":33,"featured_media":932,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_editorskit_title_hidden":false,"_editorskit_reading_time":0,"_editorskit_is_block_options_detached":false,"_editorskit_block_options_position":"{}","footnotes":""},"categories":[35],"tags":[60,206,487],"class_list":["post-26","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pmo-project-management-organizations","tag-articles","tag-long-range-planning","tag-strategic-cpm"],"acf":[],"yoast_head":"\nUsing Spreadsheets for Finance - Blog | Planview<\/title>\n<meta name=\"description\" content=\"Learn why a problem with one spreadsheet cell is the reason that complacency for using spreadsheets for finance may reach critical mass.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blog.planview.com\/spreadsheet-complacency\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Remarkable Reason Complacency for Spreadsheets May Reach Critical Mass\" \/>\n<meta property=\"og:description\" content=\"Learn why a problem with one spreadsheet cell is the reason that complacency for using spreadsheets for finance may reach critical mass.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.planview.com\/spreadsheet-complacency\/\" \/>\n<meta property=\"og:site_name\" content=\"Planview Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/pages\/Planview-Inc\/89422974772\" \/>\n<meta property=\"article:published_time\" content=\"2013-05-09T18:47:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-09-27T21:42:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blog.planview.com\/wp-content\/uploads\/2013\/05\/iStock_000019174878Small.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"849\" \/>\n\t<meta property=\"og:image:height\" content=\"565\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Kerry Raminiak\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SRPKerry\" \/>\n<meta name=\"twitter:site\" content=\"@Planview\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kerry Raminiak\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/blog.planview.com\\\/spreadsheet-complacency\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blog.planview.com\\\/spreadsheet-complacency\\\/\"},\"author\":{\"name\":\"Kerry Raminiak\",\"@id\":\"https:\\\/\\\/blog.planview.com\\\/#\\\/schema\\\/person\\\/47d2abe4661299df0e4b9aef721df188\"},\"headline\":\"The Remarkable Reason Complacency for Spreadsheets May Reach Critical Mass\",\"datePublished\":\"2013-05-09T18:47:58+00:00\",\"dateModified\":\"2016-09-27T21:42:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/blog.planview.com\\\/spreadsheet-complacency\\\/\"},\"wordCount\":795,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/blog.planview.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/blog.planview.com\\\/spreadsheet-complacency\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/blog.planview.com\\\/wp-content\\\/uploads\\\/2013\\\/05\\\/iStock_000019174878Small.jpg\",\"keywords\":[\"Articles\",\"Long-Range Planning\",\"Strategic CPM\"],\"articleSection\":[\"Project Portfolio Management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/blog.planview.com\\\/spreadsheet-complacency\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/blog.planview.com\\\/spreadsheet-complacency\\\/\",\"url\":\"https:\\\/\\\/blog.planview.com\\\/spreadsheet-complacency\\\/\",\"name\":\"Using Spreadsheets for Finance - Blog | Planview\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blog.planview.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/blog.planview.com\\\/spreadsheet-complacency\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/blog.planview.com\\\/spreadsheet-complacency\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/blog.planview.com\\\/wp-content\\\/uploads\\\/2013\\\/05\\\/iStock_000019174878Small.jpg\",\"datePublished\":\"2013-05-09T18:47:58+00:00\",\"dateModified\":\"2016-09-27T21:42:29+00:00\",\"description\":\"Learn why a problem with one spreadsheet cell is the reason that complacency for using spreadsheets for finance may reach critical mass.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/blog.planview.com\\\/spreadsheet-complacency\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/blog.planview.com\\\/spreadsheet-complacency\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/blog.planview.com\\\/spreadsheet-complacency\\\/#primaryimage\",\"url\":\"https:\\\/\\\/blog.planview.com\\\/wp-content\\\/uploads\\\/2013\\\/05\\\/iStock_000019174878Small.jpg\",\"contentUrl\":\"https:\\\/\\\/blog.planview.com\\\/wp-content\\\/uploads\\\/2013\\\/05\\\/iStock_000019174878Small.jpg\",\"width\":849,\"height\":565,\"caption\":\"spreadsheets for finance\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/blog.planview.com\\\/spreadsheet-complacency\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/blog.planview.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The Remarkable Reason Complacency for Spreadsheets May Reach Critical Mass\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/blog.planview.com\\\/#website\",\"url\":\"https:\\\/\\\/blog.planview.com\\\/\",\"name\":\"Planview Blog\",\"description\":\"Leading the conversation on digital connected work\",\"publisher\":{\"@id\":\"https:\\\/\\\/blog.planview.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/blog.planview.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/blog.planview.com\\\/#organization\",\"name\":\"Planview\",\"url\":\"https:\\\/\\\/blog.planview.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/blog.planview.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/blog.planview.com\\\/wp-content\\\/uploads\\\/2015\\\/06\\\/planview-logo-black.png\",\"contentUrl\":\"https:\\\/\\\/blog.planview.com\\\/wp-content\\\/uploads\\\/2015\\\/06\\\/planview-logo-black.png\",\"width\":280,\"height\":66,\"caption\":\"Planview\"},\"image\":{\"@id\":\"https:\\\/\\\/blog.planview.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"http:\\\/\\\/www.facebook.com\\\/pages\\\/Planview-Inc\\\/89422974772\",\"https:\\\/\\\/x.com\\\/Planview\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/blog.planview.com\\\/#\\\/schema\\\/person\\\/47d2abe4661299df0e4b9aef721df188\",\"name\":\"Kerry Raminiak\",\"description\":\"Kerry Doyle Raminiak writes and manages the development of thought leadership materials within the purview of project-based business operations and corporate financial long-range planning. Before joining Planview, Kerry owned and operated a marketing communications firm that specialized in developing messaging for software, web-based applications, and other technology niches. Kerry has a BS in Communications from Towson University Maryland, and an MA from Pepperdine University.\",\"sameAs\":[\"https:\\\/\\\/x.com\\\/SRPKerry\"],\"url\":\"https:\\\/\\\/blog.planview.com\\\/author\\\/kerry-raminiak\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Using Spreadsheets for Finance - Blog | Planview","description":"Learn why a problem with one spreadsheet cell is the reason that complacency for using spreadsheets for finance may reach critical mass.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blog.planview.com\/spreadsheet-complacency\/","og_locale":"en_US","og_type":"article","og_title":"The Remarkable Reason Complacency for Spreadsheets May Reach Critical Mass","og_description":"Learn why a problem with one spreadsheet cell is the reason that complacency for using spreadsheets for finance may reach critical mass.","og_url":"https:\/\/blog.planview.com\/spreadsheet-complacency\/","og_site_name":"Planview Blog","article_publisher":"http:\/\/www.facebook.com\/pages\/Planview-Inc\/89422974772","article_published_time":"2013-05-09T18:47:58+00:00","article_modified_time":"2016-09-27T21:42:29+00:00","og_image":[{"width":849,"height":565,"url":"https:\/\/blog.planview.com\/wp-content\/uploads\/2013\/05\/iStock_000019174878Small.jpg","type":"image\/jpeg"}],"author":"Kerry Raminiak","twitter_card":"summary_large_image","twitter_creator":"@SRPKerry","twitter_site":"@Planview","twitter_misc":{"Written by":"Kerry Raminiak","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.planview.com\/spreadsheet-complacency\/#article","isPartOf":{"@id":"https:\/\/blog.planview.com\/spreadsheet-complacency\/"},"author":{"name":"Kerry Raminiak","@id":"https:\/\/blog.planview.com\/#\/schema\/person\/47d2abe4661299df0e4b9aef721df188"},"headline":"The Remarkable Reason Complacency for Spreadsheets May Reach Critical Mass","datePublished":"2013-05-09T18:47:58+00:00","dateModified":"2016-09-27T21:42:29+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.planview.com\/spreadsheet-complacency\/"},"wordCount":795,"commentCount":0,"publisher":{"@id":"https:\/\/blog.planview.com\/#organization"},"image":{"@id":"https:\/\/blog.planview.com\/spreadsheet-complacency\/#primaryimage"},"thumbnailUrl":"https:\/\/blog.planview.com\/wp-content\/uploads\/2013\/05\/iStock_000019174878Small.jpg","keywords":["Articles","Long-Range Planning","Strategic CPM"],"articleSection":["Project Portfolio Management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.planview.com\/spreadsheet-complacency\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.planview.com\/spreadsheet-complacency\/","url":"https:\/\/blog.planview.com\/spreadsheet-complacency\/","name":"Using Spreadsheets for Finance - Blog | Planview","isPartOf":{"@id":"https:\/\/blog.planview.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/blog.planview.com\/spreadsheet-complacency\/#primaryimage"},"image":{"@id":"https:\/\/blog.planview.com\/spreadsheet-complacency\/#primaryimage"},"thumbnailUrl":"https:\/\/blog.planview.com\/wp-content\/uploads\/2013\/05\/iStock_000019174878Small.jpg","datePublished":"2013-05-09T18:47:58+00:00","dateModified":"2016-09-27T21:42:29+00:00","description":"Learn why a problem with one spreadsheet cell is the reason that complacency for using spreadsheets for finance may reach critical mass.","breadcrumb":{"@id":"https:\/\/blog.planview.com\/spreadsheet-complacency\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.planview.com\/spreadsheet-complacency\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/blog.planview.com\/spreadsheet-complacency\/#primaryimage","url":"https:\/\/blog.planview.com\/wp-content\/uploads\/2013\/05\/iStock_000019174878Small.jpg","contentUrl":"https:\/\/blog.planview.com\/wp-content\/uploads\/2013\/05\/iStock_000019174878Small.jpg","width":849,"height":565,"caption":"spreadsheets for finance"},{"@type":"BreadcrumbList","@id":"https:\/\/blog.planview.com\/spreadsheet-complacency\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/blog.planview.com\/"},{"@type":"ListItem","position":2,"name":"The Remarkable Reason Complacency for Spreadsheets May Reach Critical Mass"}]},{"@type":"WebSite","@id":"https:\/\/blog.planview.com\/#website","url":"https:\/\/blog.planview.com\/","name":"Planview Blog","description":"Leading the conversation on digital connected work","publisher":{"@id":"https:\/\/blog.planview.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.planview.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/blog.planview.com\/#organization","name":"Planview","url":"https:\/\/blog.planview.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/blog.planview.com\/#\/schema\/logo\/image\/","url":"https:\/\/blog.planview.com\/wp-content\/uploads\/2015\/06\/planview-logo-black.png","contentUrl":"https:\/\/blog.planview.com\/wp-content\/uploads\/2015\/06\/planview-logo-black.png","width":280,"height":66,"caption":"Planview"},"image":{"@id":"https:\/\/blog.planview.com\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/pages\/Planview-Inc\/89422974772","https:\/\/x.com\/Planview"]},{"@type":"Person","@id":"https:\/\/blog.planview.com\/#\/schema\/person\/47d2abe4661299df0e4b9aef721df188","name":"Kerry Raminiak","description":"Kerry Doyle Raminiak writes and manages the development of thought leadership materials within the purview of project-based business operations and corporate financial long-range planning. Before joining Planview, Kerry owned and operated a marketing communications firm that specialized in developing messaging for software, web-based applications, and other technology niches. Kerry has a BS in Communications from Towson University Maryland, and an MA from Pepperdine University.","sameAs":["https:\/\/x.com\/SRPKerry"],"url":"https:\/\/blog.planview.com\/author\/kerry-raminiak\/"}]}},"_links":{"self":[{"href":"https:\/\/blog.planview.com\/wp-json\/wp\/v2\/posts\/26","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.planview.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.planview.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.planview.com\/wp-json\/wp\/v2\/users\/33"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.planview.com\/wp-json\/wp\/v2\/comments?post=26"}],"version-history":[{"count":0,"href":"https:\/\/blog.planview.com\/wp-json\/wp\/v2\/posts\/26\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.planview.com\/wp-json\/wp\/v2\/media\/932"}],"wp:attachment":[{"href":"https:\/\/blog.planview.com\/wp-json\/wp\/v2\/media?parent=26"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.planview.com\/wp-json\/wp\/v2\/categories?post=26"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.planview.com\/wp-json\/wp\/v2\/tags?post=26"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}