On: Coders Programming Themselves Out of a Job (2018)

[buzzkillington]

I had one job which could at best be described as 'Excel VBA DevOps' it was in a bank. Someone had cost the company millions when yahoo finance changed the end point for currency conversion and no one noticed it was using stale data for a few months.

[WalterBright → buzzkillington]

I have to rewrite my accounting code every year to deal with Paypal CSV files because they change the way they work. A constant nuisance.

[pintxo → buzzkillington]

I‘d argue using yahoo finance in the first place as data source is the issue here.

[buzzkillington → pintxo]

Excel is the issue because it hid that dependency in the right most column (ABB) on the 4th sheet of the excel file.

[bencollier49 → buzzkillington]

Excel didn't do that, the person who wrote the spreadsheet did that!

[kimjongtrill → buzzkillington]

this is staggeringly hilarious. wow.