Among my duties around the office at a former job, I helped to streamline the various spreadsheets that are used by different departments. Most of them really should have been converted into proper databases, but that was an ‘unnecessary complication’, so I had to make do with what the bosses would sign off on.
Thankfully, I know quite a bit about spreadsheets, so I managed to streamline many of the processes. Some people, however, are just married to the old ways that they’ve “always done things”.
The following exchange happened while I was showing a coworker the updates that had been made to a report that he had to update each month.
Coworker: *Defensive.* “You know, I’ve been using Excel for thirty years. I think I know this better than you do.”
Me: *Struggling to stay polite.* “Maybe so. It’s just my job to keep up to date when Microsoft changes things, so I see the various improvements they make that aren’t obvious.”
Coworker: “Kids these days keep rushing around, and that just leads to mistakes! You can’t just trust computers to get things right.”
Me: “Okay… tell you what. How about this month, you run the old report, I’ll run the new one, and we can sit down to compare them. We can do that for a couple of months to make sure it all lines up. Would that help prove the new way works for you?”
Coworker: *Very grumpily.* “Fine.”
So, at the end of the month, I downloaded the data file, plugged it into the spreadsheet, hit refresh, and the whole thing populated across the various pages that needed to be calculated.
[Coworker], on the other hand, sat down for his day-long process of manually copying the data to various sheets, and then manually highlighting rows, punching in calculations, and deleting unneeded rows.
We sat down and started to go through the reports side-by-side.
On my side of things… There was one issue where a misspelled name in the original data set caused a row to get skipped during the calculations.
On his side… There were nine spots where he had either deleted a row he shouldn’t have, or left one in that should have been removed. Two columns of calculations where he divided when he should have multiplied, resulting in obviously too-small values. One calculated page that he had missed preparing entirely. And he also left out the row with the misspelled name.
We did the same thing the following month, this time with no errors on my part and a similar spread of errors on his. Which, naturally, led to… him refusing to use my report and continuing to calculate the report manually.
Sadly, his boss ‘trusted’ him and his numbers, and so believed him when he claimed that my report couldn’t be trusted. And thus, his reports would be off, I’d get pulled in when other reports I helped other departments with didn’t line up with his, and it’d always end up tracing back to a ‘slip up’ on his part, where he edited something wrong. But, somehow, that never translated to his judgment not being trustworthy, just him ‘being human’.
I am so glad to have seen the back of that company and working at a place that doesn’t reward neophobia.