WhatTheyThink

Premium Commentary & Analysis

Excel, PDFs, Paper, and More People (automation-less)

We apply tools from our toolset to solve business challenges, often those tools create silos of data and processes inside our company that prevent us from becoming a truly data-driven organization.

Wednesday, April 12, 2017

When we are faced with a challenge in our business, we apply solutions from the toolset we are comfortable with, hence Excel is the number one business application on the planet. When we have a problem that requires keeping track of stuff, Excel is the go-to-solution. There is nothing wrong with Excel spreadsheets. The issue really comes back to where this data you’re tracking in an Excel spreadsheet really belongs; and if this data needs to be shared, collaborated on, distributed, then Excel isn’t the ideal solution. Excel is selected because it is an available and comfortable tool of most people working in business today. Excel is a beginner relational database, most challenges that are solved by Excel belong in a real relational database (aka a software application which is really just a relational database with a user interface and user security wrapped around it).

In printers of all sizes, I see a common theme. When core technologies (e.g. Print MIS solutions, production management solutions, and web-to-print solutions) are not fully adopted or fully functional there are leaks in the form of processes and data storage. What does a leaky Print MIS look like? In the conference room you talk about how you use your Print MIS but if you take the time to really follow jobs around the shop, you’ll find all kinds of “other” data repositories and processes that are done outside the Print MIS. These are leaks.

This is why when we go on-site at a printer, we never like to meet with people in a conference room. Our strong preference is to meet people where they work. I don’t want to hear the story of how you work, I want to watch you work. In just a few minutes of sitting with someone in their cubicle we can start to get a sense of where the leaks are. Some have obvious physical characteristics (case boxes of printed job tickets under desk), others take a little more questioning. We were walking through the order entry workflow at a printer recently. As we were hearing the story of the CSR who gets notified of an order via email, goes into their web-to-print solution, copy and pastes into another solution, and then copy and pastes into a third solution to give the customer status; my colleague noticed an Excel file opened on a third monitor. This is where the CSR kept track of their jobs “just to make sure” – thus establishing a fourth system that he was copying and pasting into. You don’t find these things out in a conference room.


Continue reading your article
with a WhatTheyThink membership.

WhatTheyThink Annual Membership

Less than $4/week.

Get unlimited access to in-depth commentary and analysis covering the latest trends, emerging technologies, operational strategies, and key events across every segment of today's printing industry.

Stay informed. Stay competitive. Stay ahead.
WhatTheyThink Day Pass

$5 for 24 hours

Unlimited access to all of WhatTheyThink. Get your Day Pass

Already a member?
Sign In

About Jennifer Matt

Jennifer Matt is the managing editor of WhatTheyThink’s Print Software section as well as President of Web2Print Experts, Inc. a technology-independent print software consulting firm helping printers with web-to-print and print MIS solutions.

Recent Articles from Jennifer Matt

Utilizing CRM Tools to Sell Print

A CRM tool needs to deliver value to your sales team in the form of time savings or differentiation in how fast they can get quotes out to their customers. Read More

Manual Steps are Piling Up in Customer Service

When the power dynamic is uneven across the functional areas of your print business, more powerful areas (production and sales) tend to shift manual steps to the less powerful areas (customer service). Read More

Stepping Over Dollars to Pick Up Pennies

We tend to discount the time of our full-time employees because we are paying for it already—looking at them like sunk costs. So, when we ask them to do things that are non-value add (aka a complete waste of their time), we don’t see it as a cost. Well, it has real costs. Read More

Deciding What’s Important

In a print plant, it is easy to come to work and fall into the drama of getting jobs out the door. There is always something you can focus on in your day-to-day work life. The art of moving your business forward happens when you direct your focus to areas of your business that you can impact the most. Read More

This Plant Wouldn’t Run Without Me

In conversations with a label converter recently, the General Manager told me that more than once in the last few years key employees had voiced the core belief that “this plant wouldn’t run without me.” Now, you can take this statement a lot of different ways. My initial reaction is concern for the business because the employee that says this is both likely a key player and potentially a risk. Read More