WashedOver@lemmy.ca 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-square197fedilinkarrow-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@lemmy.ca to Lemmy Shitpost@lemmy.world · 7 months agomessage-square197fedilink
minus-squareYoorWeb@lemmy.worldlinkfedilinkarrow-up21·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-squaredual_sport_dork@lemmy.worldlinkfedilinkarrow-up1·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.”
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.