Improve Business

Breaking Up With Your Software

Make your life easier! Say "Good-bye" to your over-dependence on spreadsheets!

picture of todd hermanWe've all done it — kept seeing someone we knew was not right for a long-term relationship, yet was still "good enough" for the short-term. "I admit it — I'll never end up taking my relationship with Ann to the next level, yet she's fun to be around and someone to do things with." If you think about seeing who else might be on the market, you know doing so takes time and effort — and you know you will end up feeling at least a wee bit guilty if you do. Still, there will come a time to break up with Ann, yet ... not right now.

I've seen people have the same sort of relationship with the software they use. It starts out innocently enough —"QuickBooks doesn't provide such-and-such capability, but if I export sales data from it, and import it into Excel, I can massage the data to get the figures I need." You bring the analysis into a meeting, and people are impressed! In fact, your boss wants you to produce it each week for the Monday morning staff meeting — and meet this week with Betty and Charlie to help them prepare better analyses for next week's monthly management meeting.

You're in deep with Excel now — you ask your boss for some training on its advanced features, and she approves the class. It's a great class, and you learn all about using advanced functions, scripting in VBA for Excel, fetching data from external sources, and more. Back at work, you apply your newfound Excel knowledge and even use it to connect to a Microsoft Access database maintained by Dave in Payroll.

Meanwhile, the business is growing AND getting more complex, so you end up running a larger and more complicated company on shrinkwrap software totaling less than $1,000. You know this is not sustainable, yet it's "good enough" for now. Oh, and Microsoft is going to have some REALLY useful features in the next version of Excel!

So the business' computing infrastructure is "good enough" ... until it's not.

  • Until the QuickBooks database gets so large it requires repairs every 3 or 4 days.
  • Until someone quotes a big new customer using an old price list on the share drive, and you can't back out of the contract.
  • Until the ten nearly identical Access databases;you have for each of your ten branch locations — which all began life from the same source — need to updating to add some new capabilities, and you're stuck making ten slightly different sets of changes.
  • Until you take stock and find running your business depends on 100+ Excel worksheets and Word documents to supplement QuickBooks.
  • Until you want to use barcodes and scanners to help you better keep track of huge bundles of second and third quality products, stacked to the ceiling of three warehouses totaling about two acres of floor space, and you learn Sage 50 (formerly, Peachtree Accounting) won't accommodate that.
  • Until your biggest customer wants you to produce a daily status report on projects they've sent to you via Excel — and, of course, the four persons sending you these have each created their own Excel sheet to launch and manage the projects.

People use the tools they've been provided, and these are frequently the "bloatware" products commonly known as Microsoft Office. Of all the Office applications, I only love one — Excel. (Of course, I hate the ribbon interface on Excel and all its siblings.) It is the Office product which has stayed closest to its rows-and-columns roots, and which typically correctly guesses what you want to achieve and actually HELPS you. (Don't get me started on Word ... )

The problem with Office is that Microsoft has added or enhanced the features of all the products over the years, to entice users to upgrade. The upgrades also typically improve performance, so the combination of better features and performance pushes "good enough" out another one to two years. Intuit is just as guilty, pushing "good enough" for QuickBooks out another two or three years.

So you end up with ...

  • A spreadsheet straining to do database-like tasks ...
  • A word processor stretching to perform report writer-type work (don't laugh — one ERP package I've recently worked with actually DOES use Microsoft Word to print pallet labels for outgoing shipments and similar high-volume labels, which eats away at the server's memory throughout the day because exiting Word doesn't fully release all the memory it occupied) ...
  • A database appropriate for one or two users running cost sheet calculations for a nearly billion dollar division of a large company, and corrupting frequently ...
  • An entry-level accounting solution appropriate for a startup stage now groaning to serve the needs of a larger and more sophisticated company ...
  • And users thinking there MUST be better tools and processes than these to run the business.

Any of these situations seem familiar? If so,"good enough" no longer is. Todd Herman Associates can likely help you. Give me a call or shoot me an email — I am happy to talk with you, understand your pains, and suggest some options for you to consider. I can't help you break up with Ann or Andy, yet I can help you break up with software which is no longer working for you.

Sincerely,

toddsig
Todd L. Herman

PS — I'm not making any of this up! All the examples I described are real-life situations I've seen at prospects or clients over the last 18 months.

Save

Improve Business

"Culture" is a Verb

Redefining "The Hottest Topic in Business Today"

Category: Leadership Relationships

 

Start transforming your business and yourself by signing up here:

captcha 

SEVEN TIME WINNER OF THE
APEX AWARD FOR WRITING EXCELLENCE!

2017 winnerApex 2016 winner Apex 2015 winner Apex 2014 winner Apex 2013 winner Apex 2012 winner Apex 2011 winner

Business Book Reviews

Need more resources for growing your business? Get great business book suggestions from Todd.

A Picture Is Worth a Thousand Words - 2017 Summer Book Reviews

thebackofthenapIs a picture truly worth a thousand words?Todd's annual summer book reviews cover four books that have helped either hone thinking skills by using doodles and simple drawings, or spark ideas for improving doodles or other visuals.

 

Nothing Changes Until Somebody Feels Something

Whoever Tells The Best Story Wins(June 2016)  Hugh MacLeod Of Gapingvoid Art Gave Todd Inspiration For This Summer's Book Reviews When He Said "Attach Emotion To Logic And Anything Is Possible" — A Common Thread In The Four Books Todd Reviews.

 

 

 

 

Todd describes his idea of how to develop "Free Range Staff" — Employees who can take an idea, develop and run with it with little
or no supervision — as he reviews four books he uses to teach and develop his staff.

 

 

 

Todd's review on books that can help you and your business see around corners better.

3 Ways to Grow Your Bottom Line

Can three different clients, with three different needs, have the same overall goal? Absolutely! 

Category:  Improve Business   

Breaking Up With Your Software!

Make Your Life Easier!  Say "Good-bye" to Your Over-Dependence on Spreadsheets!

Category:  Improve Business  Think Differently 

Combining Force and Finesse: Case Study - Applying Technology to Reduce Unbilled Charges

Sometimes, brute force gets a job done.  Sometimes, a little finesse is all it takes.  Other times, you need to combine the two to accomplish your goal!  Take a look at this Case Study

Category:  Improve Business  Solve Problems

 

Todd Herman Associates

336.297.4200

620 Green Valley Road
Suite 104
Greensboro, NC 27408

About Todd Herman Associates

Todd Herman Associates is a business technology consulting firm focused on non-routine technology issues such as replacing QuickBooks, getting two systems to "talk" to each other, shrinking process cycle time, and taming large volumes of data.