WashedOver to Lemmy Shitpost@lemmy.world • 1 year 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.08Karrow-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 • 1 year agomessage-square203fedilink
minus-square@YoorWeb@lemmy.worldlinkfedilink22•edit-21 year 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•1 year agoCould that be classed as constraints programing? Or is it just a nasty hack 🤔
minus-squaredual_sport_dork 🐧🗡️linkfedilink1•1 year 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.