I think this link is a better source - and the title isn't editorialised as in the other, though this is one occasion where the journos seem to be missing the main point, perhaps waiting for an authoritative source and confirmation?
Nope! Actually going off better info now it looks like they WERE using rows, but it was in the old .xls format instead of .xlsx which limits to 2^16 rows
When I read that, I wondered what clowns built it. Now to hear that it was done in Excel I am shocked. I mean, Excel has its place, but in an operational system in which lives may depend?
16,384 column limit, even in the newer versions according to Microsoft! Mind you, for when things get really bad, it does support "Colors in a workbook: 16 million colors".
A global emergency and the biggest news is one country missed a daily record because their futuristic computerized logging system wasn't as optimal as possible.
Like sure, yeah its funny to us that they aren't using some nice GUI over SQL with a memcache, automatically synced with all hospitals via REST and JSON and the tacked on ability to export to excel.
But I mean, think about it. Its awesome what we have too and how accessible all that is.
One of the hard things about computers is that things often work perfectly right up until they don't.
If you're driving a car a little bit too far between maintenance checkups, it might start making some concerning noises, feel off, etc.
But no one not intimately familiar with spreadsheets would think anything is near failure when they have 65534 rows (showing my age, it's a bit higher now, right? :) ).
For that amount of money I think standards should be way higher than for Bob from accounting who built a clever Excel sheet. I don't expect perfection, but there are ways and techniques to build and run software in a way that minimizes the likelihood of such problems, and this really doesn't make the impression that they followed any best practices at all. They should (but of course won't) be held accountable for that.
It's serco. Them, alongside, for example, Crapita are one of the big corporate disaster companies the government inevitably gives software contracts to and inevitably they fail.
Given their track records it is beyond incompetence, I honestly believe they only care about profits and barely disguise that fact.
33 comments
[ 2.6 ms ] story [ 74.0 ms ] threadI've hidden it so that people use the other one (also on the front page.)
I think hide will only hide it for you, I just searched on it?
Also being reported in various local news items like that in the other discussion linked.
It's very odd though, as the numbers aren't high enough to hit any common thresholds, right?
Anyone have any thoughts on what could have gone wrong here?
https://twitter.com/standupmaths/status/1313149987707072512?...
Row limit is over 1 million.
"It was caused by some data files reporting positive test results exceeding the maximum file size."
https://www.bbc.co.uk/news/uk-54412581
Still not too clear.
A global emergency and the biggest news is one country missed a daily record because their futuristic computerized logging system wasn't as optimal as possible.
Like sure, yeah its funny to us that they aren't using some nice GUI over SQL with a memcache, automatically synced with all hospitals via REST and JSON and the tacked on ability to export to excel.
But I mean, think about it. Its awesome what we have too and how accessible all that is.
If you're driving a car a little bit too far between maintenance checkups, it might start making some concerning noises, feel off, etc.
But no one not intimately familiar with spreadsheets would think anything is near failure when they have 65534 rows (showing my age, it's a bit higher now, right? :) ).
This has happened to lots of people that "should know better", like when Slashdot hit a 16M comment limit in 2006: https://slashdot.org/story/06/11/09/1534204/slashdot-posting...
...should be given £345M to run a vital data intensive response to a pandemic?
Given their track records it is beyond incompetence, I honestly believe they only care about profits and barely disguise that fact.