Today at work I impressed the hell out of my superiors – and not for the first time.
That sounds boastful, doesn’t it? It’s really not. I can’t really brag about it, because I distinguished myself by being… adequate.
Here’s the deal: When I started this job, I was told that one of my monthly duties was to prepare a report on copier usage. The way I was shown to do this was this: Get raw reports from our two copiers. (Five pages listing client #'s and the copies/scans/prints charged to their account.) Then, using a pocket calculator add the numbers from each report together, and then enter them into a table. In Excel. Me: “What?” (We’re talking about close to a thousand operations.) This was complicated by the fact that the table I was supposed to enter everything into was organized differently than the source reports – so each operation involved hunting around trying to find numbers from all over the damned place.
So instead I spend a little time and prepare a spreadsheet with a printable area in the expected format and a data-entry area so I can just copy directly from the lists, bang-bang-bang. No, “Uh, Wall Centre is 42023,” flipflipflip "Umm… okay, 815. " flipflipflip “And, over here we have 1705.” “815 + 1705 is…” taptaptaptaptaptaptaptaptap “2520. Got it… okay, now for the scans…” Just a speedy data-entry task. (I will boast that my keyboarding skills make grown men tremble.)
So I did that. Great, yay me. Flash forward one month: I’m ready to turn in my lightning-prepared report by noon on the first of the month. (Unheard of! I am truly a god among clerks, everyone agrees.) As directed, I save it in the specified network directory for the A/R dept. to work with.
…and then I poke around in there. What do I find?
Only other spreadsheets. These ones do the actual calculation of what our clients should pay us for print services. You’ve got a list of our clients, the rates we charge for impression, etc, and whatnot. An accountant referred to my spreadsheet, and manually entered 500 line items into hers. And… this spreadsheet was presented in a third order, so again, you’re hunting all over the damned place trying to find the numbers you’re after. Usually took her a couple of days to get it done, with all of her other tasks. :smack:
I mentioned that I might be able to save the accountant a bit of time, next time.
I copied her spreadsheet, spoojed my data entry area into it, and edited it to take all its references from the appropriate cells.
So this month the Controller had the finished report she was used to hoping materialized sometime before the first week of the month was over – before lunch on the first day. And she will forever more.
Wow, I am awesome! Spectacular! Frigging brilliant!
Well, no. I just had the advantage of coming into a situation that was incomprehensibly stupid. You can’t say that out loud though, so I guess I’ll just have to bear the praise.
What I like about this situation is that the fella that held my job before me was promoted out of it. The guy that shrugged and spent all fecking day using a pocket calculator.
I will rule them, for I am of median intelligence.
This is common, isn’t it?
Please, people: Tell me your tales of basking in the Relative Glory of being a jingle-bell on a carillon of dumb-bells.