Posts Tagged ‘Excel’

Something I’ve been pondering lately is how our species love puzzles of all kinds, (from crosswords to Sudoku, Connect 4, jigsaws, chess, cryptograms, you name it.) But so many of the general populous of puzzle solvers are terrified or oblivious to the fact that learning to write computer programs comes from the exact same place & passion. If you hunger for mental challenges, putting pieces together, figuring your way through a maze or connecting dots for fun, then you could apply this pastime & hunger to something that will have so much leverage in your life, it’s phenomenal. Learning how computers work, and then how to expand this understanding to make them do more, was by far the most powerful thing I ever directed my hunger towards. I went from being terrified of touching Excel (because it did things I didn’t understand) to learning how to get under the hood, break down the walls and limits and make that one program do virtually whatever I wanted it to do. But getting there was just another puzzle and series of basic steps, to which I applied my crossword-brain.

I took some classes and have a ton of books about everything and anything; I learned several languages from C to php to VB to VBA to whatever. But to this day, the most important 2 things in my entire learning arsenal were:

1. A basic class on how computers work, which essentially said: “they are dumb”. They follow steps, and only when told to do so. They don’t make assumptions, and they need explicit instructions, or they can’t do anything.

2. A language-independent class on the fundamentals of programming. It taught me how to drop my assumptions, think in smaller and smaller terms about how things come to be, how to forget what I thought I knew, and then how to reconstruct my knowledge whilst paying attention to the things we tend to overlook, due to their simplicity. “Otto the Robot” was the most important puzzle I ever solved, and this was before I allowed myself to even consider what a development environment was.

When you make a program which automates and simplifies someone’s life, they look at you like you’re an alchemist. You just turned lead into gold, you just wove magic out of thin air. The inevitable next question is: “How can I learn to do THAT?”

The unfortunate answer is, “by becoming obsessed, dedicated, single-minded and applying hundreds and thousands of hours into wanting to do it, never accepting no for an answer, never accepting that something is beyond you, and by so much patience and self-forgiveness that nothing will beat you into submission, no matter how hard it tries.” (We make it look easy so folks often assume it is.)

For the first time in my life, my twisted obsessive personality worked in my favor, because I HATE not knowing things, I hate when something won’t work when it should, and I especially can’t accept this when I know that every single thing is made of a system of steps and checks.

Bottom line: If you like puzzles, then learn how computers work, and apply that passion towards making the world a better and more efficient place. Contrary to popular belief, there is no magic involved.


Since I started back at work, various things have attempted to impinge upon my sanity, as well as any extra free time I was planning on claiming as my own. But that’s OK, stress is banned from my life, and so I don’t feel it too often. Weird how a mental pause & reflection can control this stuff. Peter Carroll calls it ‘Sleight of mind’, and this works for me on a surprisingly frequent basis.

This week a couple of Excel applications I built using VBA went beta-live, and there were only a handful of bugs reported, which were relatively easy fixes. One of my colleagues is leaving next Friday, and so I inherited another pile of work, but have no idea how or when I can break from my already over-maxed days to train in this stuff. And even under normal circumstances, two (one) weeks is grossly insufficient to train for that particular job.

Laguna Beach is getting closer, & while I’m out there I’m goin to be seein my friend Aurelio O’Brien, who incidentally is not only just an excellent author, but has just released his new novel “GENeration eXtra TERrestrial” in eBook format, which is A: Great writing, B: A great story, C: Available in bite-sized chunks for a very bite-sized price in all the popular formats. Highly recommended stuff.

So this weekend I’m going to be doing very little other than maxin and relaxin. Maybe write a little, maybe some sitebuilding, maybe even some beer…

First things first, I hope the link I just wrote in longhand html works…