I love how they try and pretend this is somehow due to a flaw in Excel, when in fact it's simply that the inept government workers who are responsible for covid reporting are not using the tool correctly.
According to Public Health England, 15,841 cases between Sept. 25 and Oct. 2 weren’t uploaded to the government dashboard, because the column limits on an Excel spreadsheet reached its maximum size.
sounds like a design issue, not an Excel issue (hint: use rows for individual records and columns for fields next time)
Correct. It is best to use Excel as a visualization tool with a database such as Access. For a system on a country level of this importance SQL with some reporting tool, maybe MS reporting services would be better. Pathetic to be excel only and doing it wrong in any case. And then the socialists want to enlarge the goverment take more responsibility for service delivery from the private sector. This is a great example of why socialism DOES NOT WORK!
I love how they try and pretend this is somehow due to a flaw in Excel, when in fact it's simply that the inept government workers who are responsible for covid reporting are not using the tool correctly.
It's hard to trust any of the covid numbers.
macros and functions are oh so hard hahahaha
And you have to be a Rocket Surgeon to use a real database!
Bingo!
And Andy Macdonald gets it, from a Tweet in the source article:
unfortunately most people treat it like it is
Govment werkers r not top notch. Govment werkers r not top notch. Govment werkers r not top notch...
That's what happens when you hire diversity over qualified.
sounds like a design issue, not an Excel issue (hint: use rows for individual records and columns for fields next time)
what fffing moron did that?
I'm speculating, but I honestly can't think of another scenario where one would run out of columns.
I used Excel in conjunction with Access, though, and both can store millions of records. Maybe a power user could chime in.
Correct. It is best to use Excel as a visualization tool with a database such as Access. For a system on a country level of this importance SQL with some reporting tool, maybe MS reporting services would be better. Pathetic to be excel only and doing it wrong in any case. And then the socialists want to enlarge the goverment take more responsibility for service delivery from the private sector. This is a great example of why socialism DOES NOT WORK!
Your likely not wrong..
Pre-97 you could legitimately run out of rows, current versions I'm not sure there is a limit?
They distributed cases accross columns instead of rows.
Concur; have also seen self-proclaimed experts set up one math function ( not even formula! Function!) per column or row, in between data 🤪
Oh no, some of the made up numbers are missing from the made up list!
Now my faith in the UK government has dropped from 0% to...well, still 0% actually.
Now if they got something right, that would be news.