Geek by Day

While usually my inner geek comes out in the evening, the last couple weeks have seen it spring to life during the day while at work!

My primary responsibility is calculating sales commissions. At my company, that means I spend the better part of my day in Microsoft Excel. First off, let me say that I "heart" Excel 2003. However, lately I've been trying to minimize the mindless time I spend using it.

By mindless, I mean doing repetitious tasks that could be just as easily performed by your common college intern or even a trained chimp. Some things aren't that bad, but they just take a long time. The answer, I've found, is to delve completely into the wonderful world of VBA: Visual Basic for Applications.

So for the last several days I've been programming my brains out, to automate - as much as possible - part of our commission calculations. To the large extent, I've been successful. I'd say we're at Beta stage now. It pretty much works, but things like bug squashing and fine tuning what little GUI there needs to be.

I'm such a l33t haXor with my mad Excel skillz. Or just a geek. Yep, that'll do.

-Kal