{"id":375,"date":"2020-02-13T12:49:43","date_gmt":"2020-02-13T17:49:43","guid":{"rendered":"https:\/\/blogs.sw.siemens.com\/partners\/?p=375"},"modified":"2026-03-26T12:48:59","modified_gmt":"2026-03-26T16:48:59","slug":"why-do-production-planners-still-use-excel","status":"publish","type":"post","link":"https:\/\/blogs.sw.siemens.com\/partners\/why-do-production-planners-still-use-excel\/","title":{"rendered":"Why do production planners still use Excel?"},"content":{"rendered":"\n<p>It&#8217;s mind-boggling why so many manufacturing production planners still use Excel instead of software created specifically for scheduling. My work with production planners over the past 30 years suggests that while Excel doesn\u2019t fully meet their scheduling needs, it does solve the problem in the short-term &#8211; and quickly since production planners don\u2019t have the time to find and push for more sophisticated tools.&nbsp;And when they do, they are typically met with organizational resistance.&nbsp; <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">What about ERP?<\/h2>\n\n\n\n<p>The need to consolidate disparate systems led manufacturers to purchase enterprise resource planning (ERP) systems.&nbsp;As ERP systems were rolled out, the production planner, under the mandate that the old tools and disparate systems should disappear, would do their best to use the scheduling tool native to that ERP system. But because ERP scheduling tools typically can\u2019t model all the manufacturing constraints, the schedule would not be accurate which naturally caused the production planner to abandon the tool and return to using Excel or other manual processes.&nbsp;IT Executives don\u2019t want to believe or admit that their ERP selection isn\u2019t viable or able to solve production scheduling, so they frown on the production planner and rarely pursue finding the necessary tool to get the job done.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Bring on advanced scheduling experts<\/h2>\n\n\n\n<p>Sound familiar?&nbsp; I\u2019ve heard this story dozens of times across many industries as has my colleague, Joao Laner. In Laner\u2019s blog, <a href=\"https:\/\/blogs.sw.siemens.com\/siemens-opcenter\/improving-profitability-with-advanced-scheduling\/\"><em>Improving Profitability with Advanced Scheduling, <\/em><\/a>he talks about how using <a href=\"https:\/\/blogs.sw.siemens.com\/siemens-opcenter\/available-now-siemens-opcenter-aps-18\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"APS software (opens in a new tab)\">APS software<\/a> can help reap efficiency and profitability improvements from using the standard, functions without needing to create complex rules to start seeing an immediate return on investment<\/p>\n\n\n\n<p>Industry expert and author of <em>The Little Blue Book On\nScheduling<\/em>, Mike Liddell, <a href=\"https:\/\/lean-scheduling.com\/excel-vs-preactor-aps\/\" target=\"_blank\" rel=\"noopener\">provides his insights\non this topic<\/a> based on 20 years of work helping hundreds of manufacturing\nclients transition from Excel to advanced scheduling tools. <\/p>\n\n\n\n<p>It is curious why production planners still use Excel. Thanks to Smart Expert partners like <a href=\"https:\/\/lean-scheduling.com\/\" target=\"_blank\" rel=\"noopener\">Lean-Scheduling<\/a>, who specializes in APS, companies seeking help to get out of the manual processes and addiction to Excel can learn the value that dedicated software provides to support their advanced planning and scheduling requirements. <\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><a href=\"https:\/\/www.linkedin.com\/in\/strategicbusinessarchitect\/\" target=\"_blank\" rel=\"noopener\">Dave Snyder<\/a>\nis a Manufacturing Operations Management (MOM) Partner Sales Executive with\nSiemens Digital Industries Software.&nbsp; Dave has 30 years of experience\nbuilding, implementing and selling advanced planning and scheduling solutions\nin 22 countries.&nbsp; For him, advanced planning and scheduling are essential\nto achieving value from the MOM portfolio.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>It&#8217;s mind-boggling why so many manufacturing production planners still use Excel instead of software created specifically for scheduling. My work&#8230;<\/p>\n","protected":false},"author":19046,"featured_media":385,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spanish_translation":"","french_translation":"","german_translation":"","italian_translation":"","polish_translation":"","japanese_translation":"","chinese_translation":"","footnotes":""},"categories":[2,148],"tags":[63],"industry":[],"product":[],"coauthors":[],"class_list":["post-375","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news","category-partner-success","tag-siemens-partners"],"featured_image_url":"https:\/\/blogs.sw.siemens.com\/wp-content\/uploads\/sites\/21\/2020\/02\/Lean-Scheduling-900x450-1.png","_links":{"self":[{"href":"https:\/\/blogs.sw.siemens.com\/partners\/wp-json\/wp\/v2\/posts\/375","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.sw.siemens.com\/partners\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.sw.siemens.com\/partners\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.sw.siemens.com\/partners\/wp-json\/wp\/v2\/users\/19046"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.sw.siemens.com\/partners\/wp-json\/wp\/v2\/comments?post=375"}],"version-history":[{"count":5,"href":"https:\/\/blogs.sw.siemens.com\/partners\/wp-json\/wp\/v2\/posts\/375\/revisions"}],"predecessor-version":[{"id":886,"href":"https:\/\/blogs.sw.siemens.com\/partners\/wp-json\/wp\/v2\/posts\/375\/revisions\/886"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blogs.sw.siemens.com\/partners\/wp-json\/wp\/v2\/media\/385"}],"wp:attachment":[{"href":"https:\/\/blogs.sw.siemens.com\/partners\/wp-json\/wp\/v2\/media?parent=375"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.sw.siemens.com\/partners\/wp-json\/wp\/v2\/categories?post=375"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.sw.siemens.com\/partners\/wp-json\/wp\/v2\/tags?post=375"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/blogs.sw.siemens.com\/partners\/wp-json\/wp\/v2\/industry?post=375"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/blogs.sw.siemens.com\/partners\/wp-json\/wp\/v2\/product?post=375"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/blogs.sw.siemens.com\/partners\/wp-json\/wp\/v2\/coauthors?post=375"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}