4 ms·
I have a similar story which I posted on HN before, here is the repost: A fair number of years ago I worked a non tech office job for a few months. Basically a
by jiggy2011 14y ago
I have a similar story which I posted on HN before, here is the repost:
A fair number of years ago I worked a non tech office job for a few months. Basically a large portion of the job was checking though a spreadsheet looking at figures and checking them against a corresponding row in another part of the sheet. Assuming the figures matched you would copy the figures elsewhere in the sheet, append some characters to them and mark ones that were wrong in red. The data I think came from some legacy database.
There were a few more steps that I don't quite recall but basically they provided a list of instructions on how to do this part of the job and I immediately recognized that this was basically psuedocode, there was nothing "human" required at all. They expected a human error rate of around 1% with this and sheets were often checked twice.
A few days into the job I decided to try writing a Macro to do this job, so that night at home I wrote my macro and emailed it to myself. Next day I loaded it up, ran it and then checked the results by hand. I did this until I was satisfied that the error rate was 0.
Next few days I just started running my macro instead of working by hand, meaning I got about 3 hours work done in under a second and could spend the rest of the day doing other (marginally less monotonous) work.
Now in this office they tracked people's productivity levels as well as their error rate, so naturally I end up with obscene performance stats and no errors.
So the team manager of course asks me to explain myself and I show her the macro and offer to show her how to set it up on other computers and explain how well I tested it etc. The response I got surprised me somewhat.
"You are cheating your stats!" was what I was told. Of course I explained that it wouldn't be "unfair" if everyone had the software. Now at the end of every month they had some (cheap) prize for the person with the highest productivity and lowest error rate and since other tasks were not so easily "scored" the spreadsheet task was a big part of the deal.
No matter how I tried to explain it was like hitting a brick wall, because in her eyes I was "cheating". They had been doing this monotonous work for so long and were so used to it that wasting probably hundreds of man months was preferable to questioning if there might be a better way.
Of course I offered to forfeit any "prize" I might win (despite potentially saving them thousands of pounds), but no we type figures and then somebody wins a prize at the end dammit!
- adamio 14y agoI did something similar, boil about 5 hours of work down to 15 seconds using an Excel macro. I was told to re-do it by hand, because my future replacement wouldn't understand how to use a macro.
- mindcrime 14y agoI had a similar experience, that was at least as groan inducing. I was working a low-level IT job, as an AS/400 operator / network tech. The "IT manager" was a complete fraud who knew about as much about technology as I know about the culture of ancient Mesopotamia, and she had some project she was trying to get done, involving moving some data from an old database into a new one. OK, easy enough, right? Well, a couple of her "pet" subordinates spent a couple of weeks trying to migrate this data and couldn't get it done, so they gave up. I came into work one evening and found a fracking HUGE stack of greenbar on my desk, and then she comes in and goes "we're going to rekey all this data into the new database over the next couple of weeks, so start chewing through as much of it as you can tonight." My first thought was "WTF?" My second and third thoughts were something like "Are you f%!#ng shitting me?" and "You are f%!#ng braindead." So, after everyone else left for the evening, I found the machine with the old database (running Paradox 4 for DOS), exported the data to dbaseIII format (because I knew it was a commonly used and widely supported format), put it on a floppy, took it to the machine with the Access database and loaded it up. Turns out I had to write one update query to populate one of the fields, but that took something like 5 minutes. 30 minutes into the whole thing and the entire database is finished. Next day I see the "IT Manager" and she's like "How much of that data did you key in last night?" I looked at her and said "none." She about blew a fuse and started yelling "Why not, I told you to <blah, blah, blah>?" Then I told her the whole thing was done and she's like "But.. wait, what? But..but... splutter cough splutter but, but... So-and-so and You-know-who spent TWO WHOLE WEEKS trying to migrate that data and you mean to tell me you did it in one night?" Of course she never forgave me for showing up her "pets" like that. Needless to say, I didn't work at this place very long. Edit: there's another fun story to tell about that place, and how this same IT manager used the AS/400 system message queue facility as a poor man's IM system, and - more to the point - used it to talk shit about anybody and everybody she worked with (myself included). Of course this dim-bulb didn't realize that when I was logged in as QSYSOPR I could read all her messages. So, on my last night there, I printed out copies of a few "choice" messages from her, and then sent a systemwide message saying something like: "Foo: You should probably be aware that a QSYSOPR can read all of your system messages, and knows what you've been saying about everybody in this company. You should probably hope that somebody doesn't take offense, and print out copies of some of these messages and distribute them so that certain other people can see what you've had to say about them." In the end, I decided not to leave the printouts to be found, but a co-worker told me a few months later that I nearly gave this "IT manager" a heart-attack and that she spent weeks doing damage control and trying not to get fired. That was like 13 years ago, and I'm guessing she hasn't forgiven me for that either. shrug