{"id":8547,"date":"2014-10-28T10:00:38","date_gmt":"2014-10-28T15:00:38","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/blog\/?p=8547"},"modified":"2015-05-18T11:33:07","modified_gmt":"2015-05-18T16:33:07","slug":"5-more-dangers-of-spreadsheet-overuse-part-2","status":"publish","type":"post","link":"https:\/\/www.mrc-productivity.com\/blog\/2014\/10\/5-more-dangers-of-spreadsheet-overuse-part-2\/","title":{"rendered":"5 more dangers of spreadsheet overuse (part 2)"},"content":{"rendered":"

\"Education\"Summary: While harmless if used correctly, spreadsheets can create all types of business problems when misused. The bad news: Spreadsheets are often misused. Learn how businesses unknowingly misuse spreadsheets, and the risks they face as a result.<\/em><\/span>
\n<\/a>
\nWhat if I told you that dangerous software has crept into your company? It\u2019s infiltrated your employee\u2019s computers. It drains productivity, leads to data errors, and could even put your entire business at risk. It\u2019s almost impossible to control.<\/p>\n

\"photo
photo credit: Eelffica<\/a> via pixabay<\/a> cc<\/a><\/figcaption><\/figure>\n

What is this dangerous software? Spreadsheets.<\/p>\n

When misused, spreadsheets open businesses up to a host of problems. The bad news: Spreadsheets are regularly misused.<\/p>\n

You see, spreadsheets were designed as single-user tools. They let business users easily alter and analyze small data sets. When used in this way, spreadsheets are harmless.<\/p>\n

The problem is, this isn’t how spreadsheets are used. Companies turn them into multi-user and multi-department tools. Some even run their businesses off of spreadsheets. They use spreadsheets in ways they were never meant to be used.<\/p>\n

What happens? These companies face problems. Big problems. So many problems, in fact, that we had to split this topic up into two articles. You can find the first 7 dangers of spreadsheet overuse in this article<\/span><\/a>, and 5 more dangers listed below:<\/p>\n

1. Spreadsheets don\u2019t allow for data concurrency<\/h3>\n

When storing data in a database, you create separate tables for each type of data. For instance, you create a product database for your product information, and customer database for customer info. <\/p>\n

Why is this so important? You don\u2019t want the same piece of data stored in two separate tables. Otherwise, you run into all sorts of problems. For instance, what happens if you change one table, but not the other? How do you know which one is accurate? <\/p>\n

Spreadsheets make these types of problems nearly unavoidable. There\u2019s no way to know how many spreadsheets contain the same data, or where those spreadsheets live. As explained below, this creates inaccuracies, and even costly errors.<\/p>\n

\n\u201cIn any business scenario there will probably be a case in which you need to access the same bit of information in two different places,\u201d says Graham Cleven, Spreadsheet Expert. \u201cLets use a customer\u2019s telephone number for example. This telephone number could exist in the normal customer spreadsheet and it could also exist in the customer telephone order database. Now, let\u2019s say the customer changes their telephone number and it is updated in the customer database but the callback number in the customer telephone order database is not updated. Now let\u2019s say the company needs to notify the customer of something. The most logical thing for the phone order handling department is to call back using the callback number on their spreadsheet which is now outdated so the information will never reach the customer.\u201d\n<\/p><\/blockquote>\n

2. Spreadsheet data exists in a vacuum<\/h3>\n
\"photo<\/a>
photo credit: PublicDomainPictures<\/a> via pixabay<\/a> cc<\/a><\/figcaption><\/figure>\n

Because spreadsheets often live in different locations, there\u2019s no way to track related data. For instance, suppose different departments rely on separate spreadsheets. Each spreadsheet might contain a different aspect of the same type of data. When combined, those different views may create some valuable insight.<\/p>\n

The problem: As explained below, spreadsheets make this type of analysis is nearly impossible. <\/p>\n

\n\u201cOften, data on spreadsheets exists in a vacuum,\u201d says Shelly Collins, Professional Organizer at Clutter Contained<\/span><\/a>. \u201cMany of my clients have a variety of spreadsheets to track various individual data points about their business. The danger here is that there is no easy way to pull various types of data together to create a more comprehensive analysis. For example, a spreadsheet that tracks income by client useful in determining which clients generated the most revenue – but other important pieces of data such as the source of the client and the types of products or services that were purchased might not be accounted for, or might be kept in another spreadsheet. This makes this type of tracking useless, as you know who your current revenue generating clients are but you have no relevant data as to how to market to and obtain similar clients.\u201d\n<\/p><\/blockquote>\n

3. Spreadsheets make collaboration difficult<\/h3>\n

\n\u201cI did a study last year on marketing analytics, looking at several aspects of the process including the tools in use,\u201d says Jerry Rackley Chief Analyst at Demand Metric Research Corporation<\/span><\/a>. \u201cFor the marketing analytics process to work well, there must be collaboration around the process and sharing of results. The more of both that occur, the more likely it is that the marketing analytics process will deliver results. What I learned in the study is that of all the tools an organization could use to facilitate marketing analytics, there was one tool choice whose use actually lowered collaboration and sharing of data: spreadsheets. And yet, spreadsheets are the most widely used tool for marketing analytics. I counsel my clients to avoid using spreadsheets in favor of tools that help, not inhibit the process.\u201d\n<\/p><\/blockquote>\n

I\u2019d guess that you could apply those findings across all aspects of business. Proper collaboration can improve business results in any department. <\/p>\n

The problem: Spreadsheets aren\u2019t built for collaboration. They\u2019re not easily distributed. Multiple users can\u2019t edit the same spreadsheet at the same time. They\u2019re single-user tools…yet too many businesses hurt their collaboration trying to turn spreadsheets into something they\u2019re not.<\/p>\n

4. Workflows are hard to define and enforce<\/h3>\n

Rather than complete each step manually, companies use workflow processes to automate business functions. For instance, purchase order forms often require separate approvals from managers across multiple departments. With a workflow application, that purchase order form will move from manager to manager for approval automatically.<\/p>\n

The problem is, spreadsheets don\u2019t offer workflow capabilities. When businesses rely on spreadsheets, they must complete every business process manually. They lose the productivity benefits of workflow automation. And as explained below, spreadsheets can stall a business process altogether.<\/p>\n

\n\u201cWorkflows are hard to define and enforce,\u201d says John Peebles, CEO of Administrate<\/span><\/a>. \u201cIf something needs to happen after a bit of data is filled in, there\u2019s no way to see if that\u2019s happened or remind the person they still have some work to do!\u201d\n<\/p><\/blockquote>\n

5. \u2018Spreadsheet Accounting\u2019 can put your business at risk<\/h3>\n

Throughout this article, and the previous article<\/span><\/a>, we\u2019ve explored ways that spreadsheets can harm your business. But, can they actually put your company in danger of going under? Yes. As explained below, when used for accounting purposes, spreadsheets can endanger companies.<\/p>\n

\n\u201cHave you ever been audited by the IRS?\u201d asks Allan Madan, CA, CPA at Madan Chartered Accountant<\/span><\/a>. \u201cIt’s a scary experience, which most small businesses are ill-equipped to handle, because of their reliance on ‘spreadsheet accounting’. Upon a tax audit, the IRS will demand to see financial reports and statements of a business, that can only be generated by an Accounting Software. So when a business owner presents a tax auditor with a spreadsheet of expenses and revenues, an ugly outcome is almost certain. I have seen businesses go ‘belly-up’ because tax auditors have disallowed thousands of dollars of expense deductions, resulting in a huge tax bill. This could have been prevented if a proper accounting system was used, and not simply a ‘collection of spreadsheets.’\u201d\n<\/p><\/blockquote>\n

Solution<\/h3>\n

In the past two articles, we\u2019ve explored 12 dangers of spreadsheet overuse. All of these problems can arise as a result of using spreadsheets as multi-user or multi-department tools. <\/p>\n

The big question: What\u2019s the solution? How can businesses break their spreadsheet dependence and insulate themselves from these problems? As explained below, the solution is simple: Move your data to a database.<\/p>\n

\n\u201cAn alternate, much better solution to using many spreadsheet files is to use one database,\u201d says Graham Cleven, Spreadsheet Expert. \u201cA database uses multiple tables and data mappings to link data. Since all your information is now at one accessible location on a database server there are no issues with losing files and no issues with files being out of date with each other. Now also, when information needs to be shown in different ways the database can be used to generate dynamic reports that show information which will constantly update from the database itself. Also, because databases can have easy-to-use front ends interfaced with data validation unlike spreadsheets there is a much lower chance of either entering wrong data, entering data that is incorrectly formatted or accidentally changing \/ deleting data that doesn’t need to be changed. Also, because the database can export itself to one file backing it up is extremely easy and many database programs \/ servers have automatic backup systems built in. Spreadsheets can also be generated from databases for business meetings or especially detailed reports that need a large amount of aggregated data shown in an organized manner.\u201d\n<\/p><\/blockquote>\n

So, what do you think? Is there anything you would add to this list? If so, please share your thoughts in the comments.<\/p>\n","protected":false},"excerpt":{"rendered":"

Summary: While harmless if used correctly, spreadsheets can create all types of business problems when misused. The bad news: Spreadsheets are often misused. Learn how businesses unknowingly misuse spreadsheets, and the risks they face as a result.<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","slim_seo":{"title":"5 more dangers of spreadsheet overuse (part 2) - mrc's Cup of Joe Blog","description":"Summary: While harmless if used correctly, spreadsheets can create all types of business problems when misused. The bad news: Spreadsheets are often misused. Le"},"footnotes":""},"categories":[8],"tags":[44],"class_list":["post-8547","post","type-post","status-publish","format-standard","hentry","category-education","tag-spreadsheets"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/posts\/8547","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/comments?post=8547"}],"version-history":[{"count":7,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/posts\/8547\/revisions"}],"predecessor-version":[{"id":9141,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/posts\/8547\/revisions\/9141"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/media?parent=8547"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/categories?post=8547"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/tags?post=8547"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}