COVID-19

Discussions about serious topics, for serious people
Locked
User avatar
lpm
Junior Mod
Posts: 5944
Joined: Mon Nov 11, 2019 1:05 pm

Re: COVID-19

Post by lpm » Mon Oct 05, 2020 6:50 am

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

User avatar
shpalman
Princess POW
Posts: 8244
Joined: Mon Nov 11, 2019 12:53 pm
Location: One step beyond
Contact:

Re: COVID-19

Post by shpalman » Mon Oct 05, 2020 7:16 am

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

User avatar
lpm
Junior Mod
Posts: 5944
Joined: Mon Nov 11, 2019 1:05 pm

Re: COVID-19

Post by lpm » Mon Oct 05, 2020 7:19 am

It was viral case overload and the system didn't have a defence mechanism.
⭐ Awarded gold star 4 November 2021

RobS
Gray Pubic
Posts: 18
Joined: Mon Nov 11, 2019 2:02 pm

Re: COVID-19

Post by RobS » Mon Oct 05, 2020 9:52 am

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.

User avatar
Grumble
Light of Blast
Posts: 4747
Joined: Mon Nov 11, 2019 1:03 pm

Re: COVID-19

Post by Grumble » Mon Oct 05, 2020 10:03 am

RobS wrote:
Mon Oct 05, 2020 9:52 am
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.
You seem to be under the illusion that someone trained in data handling has been near this.
where once I used to scintillate
now I sin till ten past three

noggins
Snowbonk
Posts: 572
Joined: Wed Nov 13, 2019 1:30 pm

Re: COVID-19

Post by noggins » Mon Oct 05, 2020 10:10 am

Surely they ran out of Rows, not Columns ?

Lew Dolby
Catbabel
Posts: 652
Joined: Mon Nov 11, 2019 12:59 pm
Location: Shropshire - Welsh Borders

Re: COVID-19

Post by Lew Dolby » Mon Oct 05, 2020 10:16 am

Grumble wrote:
Mon Oct 05, 2020 10:03 am
You seem to be under the illusion that someone trained in data handling has been near this.
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.

User avatar
Grumble
Light of Blast
Posts: 4747
Joined: Mon Nov 11, 2019 1:03 pm

Re: COVID-19

Post by Grumble » Mon Oct 05, 2020 10:23 am

noggins wrote:
Mon Oct 05, 2020 10:10 am
Surely they ran out of Rows, not Columns ?
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

RobS
Gray Pubic
Posts: 18
Joined: Mon Nov 11, 2019 2:02 pm

Re: COVID-19

Post by RobS » Mon Oct 05, 2020 10:38 am

Grumble wrote:
Mon Oct 05, 2020 10:03 am
RobS wrote:
Mon Oct 05, 2020 9:52 am
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.
You seem to be under the illusion that someone trained in data handling has been near this.
Guilty as charged

Hunting Dog
Fuzzable
Posts: 264
Joined: Tue Nov 12, 2019 7:48 pm

Re: COVID-19

Post by Hunting Dog » Mon Oct 05, 2020 10:46 am

RobS wrote:
Mon Oct 05, 2020 9:52 am
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.
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"

apparently I'm psychic :shock:

RobS
Gray Pubic
Posts: 18
Joined: Mon Nov 11, 2019 2:02 pm

Re: COVID-19

Post by RobS » Mon Oct 05, 2020 11:05 am

Grumble wrote:
Mon Oct 05, 2020 10:23 am
noggins wrote:
Mon Oct 05, 2020 10:10 am
Surely they ran out of Rows, not Columns ?
Excel 2016 has 1,047,576 rows. I think they probably ran out of file size rather than sheet size.
You're under the illusion that you're using such a modern version of Excel! ;)

User avatar
jimbob
Light of Blast
Posts: 5276
Joined: Mon Nov 11, 2019 4:04 pm
Location: High Peak/Manchester

Re: COVID-19

Post by jimbob » Mon Oct 05, 2020 11:10 am

Hunting Dog wrote:
Mon Oct 05, 2020 10:46 am
RobS wrote:
Mon Oct 05, 2020 9:52 am
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.
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"

apparently I'm psychic :shock:
My signature is apt for so much of this government
Have you considered stupidity as an explanation

User avatar
lpm
Junior Mod
Posts: 5944
Joined: Mon Nov 11, 2019 1:05 pm

Re: COVID-19

Post by lpm » Mon Oct 05, 2020 11:20 am

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.
⭐ Awarded gold star 4 November 2021

bagpuss
After Pie
Posts: 1695
Joined: Tue Nov 12, 2019 12:10 pm

Re: COVID-19

Post by bagpuss » Mon Oct 05, 2020 11:33 am

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.

User avatar
Little waster
After Pie
Posts: 2385
Joined: Tue Nov 12, 2019 12:35 am
Location: About 1 inch behind my eyes

Re: COVID-19

Post by Little waster » Mon Oct 05, 2020 11:35 am

bagpuss wrote:
Mon Oct 05, 2020 11:33 am
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.
It is like you've stared directly into my soul ... :shock:
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.

noggins
Snowbonk
Posts: 572
Joined: Wed Nov 13, 2019 1:30 pm

Re: COVID-19

Post by noggins » Mon Oct 05, 2020 11:41 am

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 ?

User avatar
jimbob
Light of Blast
Posts: 5276
Joined: Mon Nov 11, 2019 4:04 pm
Location: High Peak/Manchester

Re: COVID-19

Post by jimbob » Mon Oct 05, 2020 11:56 am

Everyone knows you should use open office for critical data not excel
Have you considered stupidity as an explanation

User avatar
discovolante
Stummy Beige
Posts: 4084
Joined: Fri Oct 11, 2019 5:10 pm

Re: COVID-19

Post by discovolante » Mon Oct 05, 2020 11:57 am

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.

User avatar
TAFKAsoveda
Clardic Fug
Posts: 173
Joined: Mon Nov 11, 2019 7:15 pm

Re: COVID-19

Post by TAFKAsoveda » Mon Oct 05, 2020 12:00 pm

jimbob wrote:
Mon Oct 05, 2020 11:56 am
Everyone knows you should use open office for critical data not excel
ISWYDT
I use Libre Office

User avatar
shpalman
Princess POW
Posts: 8244
Joined: Mon Nov 11, 2019 12:53 pm
Location: One step beyond
Contact:

Re: COVID-19

Post by shpalman » Mon Oct 05, 2020 12:08 pm

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

User avatar
Grumble
Light of Blast
Posts: 4747
Joined: Mon Nov 11, 2019 1:03 pm

Re: COVID-19

Post by Grumble » Mon Oct 05, 2020 12:19 pm

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

Lew Dolby
Catbabel
Posts: 652
Joined: Mon Nov 11, 2019 12:59 pm
Location: Shropshire - Welsh Borders

Re: COVID-19

Post by Lew Dolby » Mon Oct 05, 2020 12:24 pm

lpm wrote:
Mon Oct 05, 2020 11:20 am
Lotus 1-2-3, now there was a spreadsheet.
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.

User avatar
lpm
Junior Mod
Posts: 5944
Joined: Mon Nov 11, 2019 1:05 pm

Re: COVID-19

Post by lpm » Mon Oct 05, 2020 12:35 pm

Image
⭐ Awarded gold star 4 November 2021

User avatar
El Pollo Diablo
Stummy Beige
Posts: 3323
Joined: Wed Sep 25, 2019 4:41 pm
Location: FBPE

Re: COVID-19

Post by El Pollo Diablo » Mon Oct 05, 2020 3:14 pm

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
If truth is many-sided, mendacity is many-tongued

User avatar
Grumble
Light of Blast
Posts: 4747
Joined: Mon Nov 11, 2019 1:03 pm

Re: COVID-19

Post by Grumble » Mon Oct 05, 2020 3:19 pm

El Pollo Diablo wrote:
Mon Oct 05, 2020 3:14 pm
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
Wow. That’s a well written piece but the story itself is shocking.
where once I used to scintillate
now I sin till ten past three

Locked