WashedOver to Lemmy Shitpost • 10 months agoit always interesting when multi billion dollar company's costing system is a 63 tab excel 97 spreadsheet at it's core...lemmy.caimagemessage-square199fedilinkarrow-up11.07Karrow-down112
arrow-up11.06Karrow-down1imageit always interesting when multi billion dollar company's costing system is a 63 tab excel 97 spreadsheet at it's core...lemmy.caWashedOver to Lemmy Shitpost • 10 months agomessage-square199fedilink
minus-square@YoorWeblink21•edit-210 months agoIt is according to UK’s National Health Service: https://www.bbc.com/news/technology-54423988 I love this part: “To handle the problem, PHE is now breaking down the test result data into smaller batches to create a larger number of Excel templates. That should ensure none hit their cap.”
minus-squaredual_sport_dork 🐧🗡️link1•10 months agoThere is an ODBC driver for Excel. Not to put data into Excel – To get it back out, treating it as if it were a database. This is exactly as bad an idea as it sounds.
It is according to UK’s National Health Service: https://www.bbc.com/news/technology-54423988
I love this part: “To handle the problem, PHE is now breaking down the test result data into smaller batches to create a larger number of Excel templates. That should ensure none hit their cap.”
There is an ODBC driver for Excel. Not to put data into Excel – To get it back out, treating it as if it were a database.
This is exactly as bad an idea as it sounds.