{"id":776,"date":"2012-07-12T12:02:50","date_gmt":"2012-07-12T17:02:50","guid":{"rendered":"https:\/\/portfolio-perspectives.planview.com\/?p=1705"},"modified":"2016-09-28T17:06:15","modified_gmt":"2016-09-28T22:06:15","slug":"spreadsheets-long-range-planning","status":"publish","type":"post","link":"https:\/\/blog.planview.com\/spreadsheets-long-range-planning\/","title":{"rendered":"The Role of Spreadsheets in a Long-Range Planning Process\u2014Part 2"},"content":{"rendered":"

Part one of this series<\/a> notes that 1) there are appropriate uses for spreadsheets in the planning process<\/strong>, 2) there is a key point at which spreadsheets fall short (alignment)<\/strong>, and 3) an appropriate planning tool is one that makes the most of the strengths of spreadsheets in the data gathering process<\/strong>. In this blog, I’d like to focus on another positive feature of spreadsheets, and discuss why it’s important to select a planning tool that maximizes this key strength. Learn more about spreadsheets and long-range planning.<\/p>\n

We love spreadsheets because of their flexibility to create different tables, graphs, reports, and charts. In the planning process, trying to use spreadsheets to create a multi-faced view of different tables and graphs while attempting to optimize a portfolio is a bit like asking a mason to do wood frame construction. While it is possible to rig multiple spreadsheets to create various views, spreadsheets have no built-in optimization capability.<\/p>\n

Further, managing tables, graphs, reports, and charts becomes cumbersome as numbers and requirements change. Frequently, broken links and nonsensical charts are the result. This is what prompts some companies to look for an automated solution.<\/p>\n

Many planning tools tout their reporting and analytic capabilities. In fact, so many vendors offer these features that choosing a planning package without them would be a mistake. When looking for a planning tool, I always instruct clients to look for two key analytic capabilities, both of which are strong compliments to spreadsheets. The first of these features is portfolio optimization — identifying the most efficient application of available resources (affordability). This can be achieved through a central repository that allows prioritization, working with targets, and efficient frontier capabilities. The second is the ability to create data “cubes” that are accessible through Excel. These cubes create the capability to store queries, create pivot tables, and generate output.<\/p>\n

The combination of these capabilities is particularly compelling. Envision a planning tool that allows the creation of several potential optimal scenarios which can be accessed through Excel to populate desired tables, graphs, reports, and charts. Adopting a planning tool that will maximize your use of spreadsheets, both in data gathering and analysis, will turbo charge your long-range planning process.<\/p>\n

For more information on this subject, I invite you to read the 15 Pitfalls of Long-Range Planning<\/a> white paper.<\/p>\n

How do you use spreadsheets in your long-range planning process? Are they working well or are they falling short? Share your experiences by posting a comment below.<\/p>\n

Related post: The Role of Spreadsheets in a Long-Range Planning Process — Part 1<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Part one of this series notes that 1) there are appropriate uses for spreadsheets in the planning process, 2) there is a key point at which spreadsheets fall short (alignment), and 3) an appropriate planning tool is one that makes the most of the strengths of spreadsheets in the data gathering process. In this blog,…<\/p>\n","protected":false},"author":24,"featured_media":1110,"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":[206,487],"class_list":["post-776","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pmo-project-management-organizations","tag-long-range-planning","tag-strategic-cpm"],"acf":[],"yoast_head":"\nSpreadsheets and Long-Range Planning - Blog | Planview<\/title>\n<meta name=\"description\" content=\"Are spreadsheets in your long-range planning process working well or falling short? Consider these thoughts on spreadsheets and long-range planning.\" \/>\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\/spreadsheets-long-range-planning\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Role of Spreadsheets in a Long-Range Planning Process\u2014Part 2\" \/>\n<meta property=\"og:description\" content=\"Are spreadsheets in your long-range planning process working well or falling short? Consider these thoughts on spreadsheets and long-range planning.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.planview.com\/spreadsheets-long-range-planning\/\" \/>\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=\"2012-07-12T17:02:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-09-28T22:06:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blog.planview.com\/wp-content\/uploads\/2012\/07\/shutterstock_131767742.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"360\" \/>\n\t<meta property=\"og:image:height\" content=\"240\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Madison Laird\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@madisonlaird\" \/>\n<meta name=\"twitter:site\" content=\"@Planview\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Madison Laird\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/blog.planview.com\/spreadsheets-long-range-planning\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/blog.planview.com\/spreadsheets-long-range-planning\/\"},\"author\":{\"name\":\"Madison Laird\",\"@id\":\"https:\/\/blog.planview.com\/#\/schema\/person\/939aca46bdd16f7671913bc9e7320da3\"},\"headline\":\"The Role of Spreadsheets in a Long-Range Planning Process\u2014Part 2\",\"datePublished\":\"2012-07-12T17:02:50+00:00\",\"dateModified\":\"2016-09-28T22:06:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blog.planview.com\/spreadsheets-long-range-planning\/\"},\"wordCount\":432,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/blog.planview.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/blog.planview.com\/spreadsheets-long-range-planning\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/blog.planview.com\/wp-content\/uploads\/2012\/07\/shutterstock_131767742.jpg\",\"keywords\":[\"Long-Range Planning\",\"Strategic CPM\"],\"articleSection\":[\"Project Portfolio Management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blog.planview.com\/spreadsheets-long-range-planning\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.planview.com\/spreadsheets-long-range-planning\/\",\"url\":\"https:\/\/blog.planview.com\/spreadsheets-long-range-planning\/\",\"name\":\"Spreadsheets and Long-Range Planning - Blog | Planview\",\"isPartOf\":{\"@id\":\"https:\/\/blog.planview.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/blog.planview.com\/spreadsheets-long-range-planning\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/blog.planview.com\/spreadsheets-long-range-planning\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/blog.planview.com\/wp-content\/uploads\/2012\/07\/shutterstock_131767742.jpg\",\"datePublished\":\"2012-07-12T17:02:50+00:00\",\"dateModified\":\"2016-09-28T22:06:15+00:00\",\"description\":\"Are spreadsheets in your long-range planning process working well or falling short? Consider these thoughts on spreadsheets and long-range planning.\",\"breadcrumb\":{\"@id\":\"https:\/\/blog.planview.com\/spreadsheets-long-range-planning\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.planview.com\/spreadsheets-long-range-planning\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/blog.planview.com\/spreadsheets-long-range-planning\/#primaryimage\",\"url\":\"https:\/\/blog.planview.com\/wp-content\/uploads\/2012\/07\/shutterstock_131767742.jpg\",\"contentUrl\":\"https:\/\/blog.planview.com\/wp-content\/uploads\/2012\/07\/shutterstock_131767742.jpg\",\"width\":360,\"height\":240,\"caption\":\"use of spreadsheets in the planning process\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.planview.com\/spreadsheets-long-range-planning\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/blog.planview.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The Role of Spreadsheets in a Long-Range Planning Process\u2014Part 2\"}]},{\"@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\/939aca46bdd16f7671913bc9e7320da3\",\"name\":\"Madison Laird\",\"description\":\"Madison Laird is a veteran of corporate portfolio management and has joined Planview as an Executive-in-Residence. Madison\u2019s experience in portfolio management and strategic planning includes perspectives from large companies like IBM and Cisco, GM roles at mid-sized companies, and CEO roles at small companies. Madison has received numerous honors throughout his career, including a Catalyst Challenge award from the CFO at Cisco and a nomination by AT&T for Ernst & Young\u2019s Entrepreneur of the Year award.\",\"sameAs\":[\"https:\/\/x.com\/madisonlaird\"],\"url\":\"https:\/\/blog.planview.com\/author\/madison-laird\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Spreadsheets and Long-Range Planning - Blog | Planview","description":"Are spreadsheets in your long-range planning process working well or falling short? Consider these thoughts on spreadsheets and long-range planning.","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\/spreadsheets-long-range-planning\/","og_locale":"en_US","og_type":"article","og_title":"The Role of Spreadsheets in a Long-Range Planning Process\u2014Part 2","og_description":"Are spreadsheets in your long-range planning process working well or falling short? Consider these thoughts on spreadsheets and long-range planning.","og_url":"https:\/\/blog.planview.com\/spreadsheets-long-range-planning\/","og_site_name":"Planview Blog","article_publisher":"http:\/\/www.facebook.com\/pages\/Planview-Inc\/89422974772","article_published_time":"2012-07-12T17:02:50+00:00","article_modified_time":"2016-09-28T22:06:15+00:00","og_image":[{"width":360,"height":240,"url":"https:\/\/blog.planview.com\/wp-content\/uploads\/2012\/07\/shutterstock_131767742.jpg","type":"image\/jpeg"}],"author":"Madison Laird","twitter_card":"summary_large_image","twitter_creator":"@madisonlaird","twitter_site":"@Planview","twitter_misc":{"Written by":"Madison Laird","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.planview.com\/spreadsheets-long-range-planning\/#article","isPartOf":{"@id":"https:\/\/blog.planview.com\/spreadsheets-long-range-planning\/"},"author":{"name":"Madison Laird","@id":"https:\/\/blog.planview.com\/#\/schema\/person\/939aca46bdd16f7671913bc9e7320da3"},"headline":"The Role of Spreadsheets in a Long-Range Planning Process\u2014Part 2","datePublished":"2012-07-12T17:02:50+00:00","dateModified":"2016-09-28T22:06:15+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.planview.com\/spreadsheets-long-range-planning\/"},"wordCount":432,"commentCount":0,"publisher":{"@id":"https:\/\/blog.planview.com\/#organization"},"image":{"@id":"https:\/\/blog.planview.com\/spreadsheets-long-range-planning\/#primaryimage"},"thumbnailUrl":"https:\/\/blog.planview.com\/wp-content\/uploads\/2012\/07\/shutterstock_131767742.jpg","keywords":["Long-Range Planning","Strategic CPM"],"articleSection":["Project Portfolio Management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.planview.com\/spreadsheets-long-range-planning\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.planview.com\/spreadsheets-long-range-planning\/","url":"https:\/\/blog.planview.com\/spreadsheets-long-range-planning\/","name":"Spreadsheets and Long-Range Planning - Blog | Planview","isPartOf":{"@id":"https:\/\/blog.planview.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/blog.planview.com\/spreadsheets-long-range-planning\/#primaryimage"},"image":{"@id":"https:\/\/blog.planview.com\/spreadsheets-long-range-planning\/#primaryimage"},"thumbnailUrl":"https:\/\/blog.planview.com\/wp-content\/uploads\/2012\/07\/shutterstock_131767742.jpg","datePublished":"2012-07-12T17:02:50+00:00","dateModified":"2016-09-28T22:06:15+00:00","description":"Are spreadsheets in your long-range planning process working well or falling short? Consider these thoughts on spreadsheets and long-range planning.","breadcrumb":{"@id":"https:\/\/blog.planview.com\/spreadsheets-long-range-planning\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.planview.com\/spreadsheets-long-range-planning\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/blog.planview.com\/spreadsheets-long-range-planning\/#primaryimage","url":"https:\/\/blog.planview.com\/wp-content\/uploads\/2012\/07\/shutterstock_131767742.jpg","contentUrl":"https:\/\/blog.planview.com\/wp-content\/uploads\/2012\/07\/shutterstock_131767742.jpg","width":360,"height":240,"caption":"use of spreadsheets in the planning process"},{"@type":"BreadcrumbList","@id":"https:\/\/blog.planview.com\/spreadsheets-long-range-planning\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/blog.planview.com\/"},{"@type":"ListItem","position":2,"name":"The Role of Spreadsheets in a Long-Range Planning Process\u2014Part 2"}]},{"@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\/939aca46bdd16f7671913bc9e7320da3","name":"Madison Laird","description":"Madison Laird is a veteran of corporate portfolio management and has joined Planview as an Executive-in-Residence. Madison\u2019s experience in portfolio management and strategic planning includes perspectives from large companies like IBM and Cisco, GM roles at mid-sized companies, and CEO roles at small companies. Madison has received numerous honors throughout his career, including a Catalyst Challenge award from the CFO at Cisco and a nomination by AT&T for Ernst & Young\u2019s Entrepreneur of the Year award.","sameAs":["https:\/\/x.com\/madisonlaird"],"url":"https:\/\/blog.planview.com\/author\/madison-laird\/"}]}},"_links":{"self":[{"href":"https:\/\/blog.planview.com\/wp-json\/wp\/v2\/posts\/776","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\/24"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.planview.com\/wp-json\/wp\/v2\/comments?post=776"}],"version-history":[{"count":0,"href":"https:\/\/blog.planview.com\/wp-json\/wp\/v2\/posts\/776\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.planview.com\/wp-json\/wp\/v2\/media\/1110"}],"wp:attachment":[{"href":"https:\/\/blog.planview.com\/wp-json\/wp\/v2\/media?parent=776"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.planview.com\/wp-json\/wp\/v2\/categories?post=776"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.planview.com\/wp-json\/wp\/v2\/tags?post=776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}