WashedOver@lemmy.ca 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@lemmy.ca to Lemmy Shitpost@lemmy.world · 1 year agomessage-square203fedilink
minus-squareYoorWeb@lemmy.worldlinkfedilinkarrow-up22·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-squaremartinblinkfedilinkarrow-up1·1 year agoCould that be classed as constraints programing? Or is it just a nasty hack 🤔
minus-squaredual_sport_dork 🐧🗡️@lemmy.worldlinkfedilinkarrow-up1·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.