WashedOver to Lemmy Shitpost@lemmy.world • 7 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-square203fedilinkarrow-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@lemmy.world • 7 months agomessage-square203fedilink
minus-square@YoorWeb@lemmy.worldlinkfedilink22•edit-27 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-square@martinblink1•7 months agoCould that be classed as constraints programing? Or is it just a nasty hack 🤔
minus-square@dual_sport_dork@lemmy.worldlinkfedilink1•7 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.”
Could that be classed as constraints programing? Or is it just a nasty hack 🤔
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.