4 ms·
This is how and, more importantly, why I learned to program. My office uses a horribly unintuitive centralized database from which employees 'pull reports' to p
by chrisdroukas 15y ago
This is how and, more importantly, why I learned to program. My office uses a horribly unintuitive centralized database from which employees 'pull reports' to prove to supervisors the work they've done.
One of the guys in the office was maintaining a monthly report that involved him burning 3 hours a week pulling and compiling reports into a needlessly complex Excel spreadsheet. I offered to help out, and wrote an Excel macro that did the job for him.
From there, I figured 'hell, why should everyone have to spend time doing this?' So I downloaded a copy of VB and learned enough of it to turn the Excel macro into a simple deployable application that turned an absolute waste of manpower into an easy-to-use desktop app.
In hindsight, a native application wasn't the best way to do it. Our office has a strictly controlled internet/intranet policy, and the people maintaining the database are likely too busy doing just that — maintenance — to build a more robust data reporting system. That might be the beauty of learning on your own, you quickly gain insight into how things should and could work.
It wasn't his point, but simonw is right: building things IS fun. I got started and I haven't looked back.
- mseebach 15y agoPerfect is the enemy of good. If innovation had to sit around and wait for the "best solution" or be overly concerned with how things "should" work, you'd be cooking your dinner by pounding it with a rock and we'd all be in awe of enterprise software architecture. Innovation is about solving problems with the tools and resources that are available, and kudos to you for doing just that. If more people would be bothered (and, indeed, allowed) to learn a little programming, even in something like VB, the productivity of an average office worker would explode.