COVID-19
Re: COVID-19
Looks like local places had so many cases their file sizes were too big and the file transfer to the central adding up place were rejected.
Awarded gold star 4 November 2021
- shpalman
- Princess POW
- Posts: 8310
- Joined: Mon Nov 11, 2019 12:53 pm
- Location: One step beyond
- Contact:
Re: COVID-19
There were literally so many cases that the system couldn't handle it?
having that swing is a necessary but not sufficient condition for it meaning a thing
@shpalman@mastodon.me.uk
@shpalman@mastodon.me.uk
Re: COVID-19
It was viral case overload and the system didn't have a defence mechanism.
Awarded gold star 4 November 2021
Re: COVID-19
According to the Mail it's to do with data exceeding Excel's sheet size limits:
https://twitter.com/MaxCRoser/status/13 ... 06880?s=20
Which, if true, is incredible. There's no way that Excel should be anywhere near this kind of operation.
https://twitter.com/MaxCRoser/status/13 ... 06880?s=20
Which, if true, is incredible. There's no way that Excel should be anywhere near this kind of operation.
Re: COVID-19
You seem to be under the illusion that someone trained in data handling has been near this.RobS wrote: ↑Mon Oct 05, 2020 9:52 amAccording to the Mail it's to do with data exceeding Excel's sheet size limits:
https://twitter.com/MaxCRoser/status/13 ... 06880?s=20
Which, if true, is incredible. There's no way that Excel should be anywhere near this kind of operation.
where once I used to scintillate
now I sin till ten past three
now I sin till ten past three
Re: COVID-19
Surely they ran out of Rows, not Columns ?
-
- Catbabel
- Posts: 654
- Joined: Mon Nov 11, 2019 12:59 pm
- Location: Shropshire - Welsh Borders
Re: COVID-19
or even trained in anything vaguely related to science or technology. At least then they might recognise their lack of expertise.
WOULD CUSTOMERS PLEASE REFRAIN FROM SITTING ON THE COUNTER BY THE BACON SLICER - AS WE'RE GETTING A LITTLE BEHIND IN OUR ORDERS.
Re: COVID-19
Excel 2016 has 1,047,576 rows. I think they probably ran out of file size rather than sheet size.
where once I used to scintillate
now I sin till ten past three
now I sin till ten past three
Re: COVID-19
Guilty as chargedGrumble wrote: ↑Mon Oct 05, 2020 10:03 amYou seem to be under the illusion that someone trained in data handling has been near this.RobS wrote: ↑Mon Oct 05, 2020 9:52 amAccording to the Mail it's to do with data exceeding Excel's sheet size limits:
https://twitter.com/MaxCRoser/status/13 ... 06880?s=20
Which, if true, is incredible. There's no way that Excel should be anywhere near this kind of operation.
-
- Fuzzable
- Posts: 264
- Joined: Tue Nov 12, 2019 7:48 pm
Re: COVID-19
Ahhhh, after I heard about the missing data I was joking with my retired IT manager MrHuntingDog that somewhere there was an IT manager saying "I told you not to use Excel"RobS wrote: ↑Mon Oct 05, 2020 9:52 amAccording to the Mail it's to do with data exceeding Excel's sheet size limits:
https://twitter.com/MaxCRoser/status/13 ... 06880?s=20
Which, if true, is incredible. There's no way that Excel should be anywhere near this kind of operation.
apparently I'm psychic
Re: COVID-19
You're under the illusion that you're using such a modern version of Excel!
Re: COVID-19
My signature is apt for so much of this governmentHunting Dog wrote: ↑Mon Oct 05, 2020 10:46 amAhhhh, after I heard about the missing data I was joking with my retired IT manager MrHuntingDog that somewhere there was an IT manager saying "I told you not to use Excel"RobS wrote: ↑Mon Oct 05, 2020 9:52 amAccording to the Mail it's to do with data exceeding Excel's sheet size limits:
https://twitter.com/MaxCRoser/status/13 ... 06880?s=20
Which, if true, is incredible. There's no way that Excel should be anywhere near this kind of operation.
apparently I'm psychic
Have you considered stupidity as an explanation
Re: COVID-19
My work Windows 7 ecosystem is on Excel 2010.
Which I consider to be newfangled, even if you consider it oldfangled.
Lotus 1-2-3, now there was a spreadsheet.
Which I consider to be newfangled, even if you consider it oldfangled.
Lotus 1-2-3, now there was a spreadsheet.
Awarded gold star 4 November 2021
Re: COVID-19
If they're using Excel, then it's probably also changed approximately 10% of the cell contents into a date and dropped all the leading zeros from the test ids and phone numbers.
- Little waster
- After Pie
- Posts: 2385
- Joined: Tue Nov 12, 2019 12:35 am
- Location: About 1 inch behind my eyes
Re: COVID-19
It is like you've stared directly into my soul ...
This place is not a place of honor, no highly esteemed deed is commemorated here, nothing valued is here.
What is here was dangerous and repulsive to us.
This place is best shunned and left uninhabited.
What is here was dangerous and repulsive to us.
This place is best shunned and left uninhabited.
Re: COVID-19
Im baffled by Excel having 16k+ columns.
I mean, what dataset is detailed enough to require thousands of columns yet unimportant enough to be shoved in Excel ?
I mean, what dataset is detailed enough to require thousands of columns yet unimportant enough to be shoved in Excel ?
Re: COVID-19
Everyone knows you should use open office for critical data not excel
Have you considered stupidity as an explanation
- discovolante
- Stummy Beige
- Posts: 4105
- Joined: Fri Oct 11, 2019 5:10 pm
Re: COVID-19
And to think I remember being alarmed when I found out that one local authority relied entirely on Excel for its individual property repair records...
To defy the laws of tradition is a crusade only of the brave.
- TAFKAsoveda
- Clardic Fug
- Posts: 173
- Joined: Mon Nov 11, 2019 7:15 pm
- shpalman
- Princess POW
- Posts: 8310
- Joined: Mon Nov 11, 2019 12:53 pm
- Location: One step beyond
- Contact:
Re: COVID-19
I use LibreOffice where possible but our university has a deal with Microsoft.
having that swing is a necessary but not sufficient condition for it meaning a thing
@shpalman@mastodon.me.uk
@shpalman@mastodon.me.uk
Re: COVID-19
I rely on excel for all sorts of stuff that a database would be better for, but I can’t get training in databases and we keep going “how much” when we get quotes. So it never gets sorted. I’ve tried to teach myself Access but I can’t get my head round it. It’s like the instructions are written in a foreign language.
where once I used to scintillate
now I sin till ten past three
now I sin till ten past three
-
- Catbabel
- Posts: 654
- Joined: Mon Nov 11, 2019 12:59 pm
- Location: Shropshire - Welsh Borders
Re: COVID-19
I really loved Lotus Improv for dense multi-dimensional data. Never have come across anyone else who used it.
Also loved dbase (remember that) with an add-on that allowed not just simple values to be added - but instead, values with a range. Forecast graphs gave a line with a growing spread above and below.
/been retired for 25 years, so there's prob better around these days/
WOULD CUSTOMERS PLEASE REFRAIN FROM SITTING ON THE COUNTER BY THE BACON SLICER - AS WE'RE GETTING A LITTLE BEHIND IN OUR ORDERS.
Re: COVID-19
Awarded gold star 4 November 2021
- El Pollo Diablo
- Stummy Beige
- Posts: 3333
- Joined: Wed Sep 25, 2019 4:41 pm
- Location: FBPE
Re: COVID-19
It was excel, it was Excel 2003, it was 65,536 rows, and it was a bunch of dickheads.
https://news.sky.com/story/coronavirus- ... t-12090904
https://news.sky.com/story/coronavirus- ... t-12090904
If truth is many-sided, mendacity is many-tongued
Re: COVID-19
Wow. That’s a well written piece but the story itself is shocking.El Pollo Diablo wrote: ↑Mon Oct 05, 2020 3:14 pmIt was excel, it was Excel 2003, it was 65,536 rows, and it was a bunch of dickheads.
https://news.sky.com/story/coronavirus- ... t-12090904
where once I used to scintillate
now I sin till ten past three
now I sin till ten past three