Monthly Archives: June 2011

CSI: Spreadsheet

As part of supporting customers, I often have the opportunity to review, audit, and revise customer spreadsheets.    Stepping inside the mindset of another Excel User can employ a lot of sleuthing skills, so be ready to put on your CSI glasses. Why is … Continue reading

Posted in Commissions and Metrics | Leave a comment

Ideas waiting for their time again….

Walk into any megaplex movie theater, and you will notice two older technologies that have  come back in a HUGE way.  First there is 3-D, the formerly short lived horror flick gimmick from the 1950′s.  And then there is IMAX, the uber wide, uber fidelity, film format developed in the … Continue reading

Posted in Tech Flashbacks | Leave a comment

The Next Wave: Cloudsheets & Embedding

They may be the next wave for spreadsheets, but we hope you haven’t been holding your breath. Some trends take years and years to take hold, and this one has already been 10+ years in the making. And so have … Continue reading

Posted in Excel a la Mode | Leave a comment

Never trust a spreadsheet over 30 (cells, rows, or columns).

Here’s a scary, yet unsurprising, statistic — 94% of all spreadsheets contain errors. That’s more a testimony to anything as it grows in size and complexity, as I’m certain 100% of books, websites, applications, and DNA have errors too. A … Continue reading

Posted in Excel a la Mode | 1 Comment

Live long and prosper, my spreadsheet

If applications were Star Trek characters, it might come out something like this: Kirk is the Browser (think of Go Boldly, and Green Women) Spock is Spreadsheets (with a dash of Spellcheck & SQL) McCoy is AntiVirus Scotty is Defrag and PHP Uhura is email, … Continue reading

Posted in Excel a la Mode | Leave a comment

Knowledge Silos in the information age.

We’ve all had it happen. Some one suddenly leaves your organization, and all of a sudden, you now own one or more responsibilities that you know precious little about. It could be a set of accounts you now have to … Continue reading

Posted in Tech Musings | Leave a comment

The importance of Verkaufsprovision

Most sales people scrutinize their gehaltsscheck each pay period.   Of key importance is the entry for verkaufsprovision.   Most of you don’t mind if it’s zu groß, but what do you do if it’s zu klein?  “Das ist schlecht” you say … Continue reading

Posted in Commissions and Metrics | 1 Comment

Why do I have to abandon Excel?

I admit that I really like cool and new technologies.  However, from a pragmatic business point of view, I’m constantly asking myself why am I required to abandon the tools I’ve come to love to use new technology?   Lots of … Continue reading

Posted in Commissions and Metrics | Leave a comment

A Simple Sales Commission Plan is Actually Complicated!

When a small company wants to create a sales team, it usually requires a sales operations director, sales manager, payroll person, and maybe 3-4 sales representatives.  Sounds simple, right?   The sales operations director needs to evaluate the plan closely to … Continue reading

Posted in Commissions and Metrics | Leave a comment

Long Live Shortcut Keys

Back in the day, there was a very popular word processor called WordStar.    It dominated the market as it existed in the early 1980′s.  The WordStar ctrl keys were a defacto standard, and mandatory knowledge for any touch typist in the workforce.   These keys … Continue reading

Posted in Tech Flashbacks | 2 Comments