COVID-19

Covid-19 discussion, bring your own statistics
Post Reply
User avatar
lpm
After Pie
Posts: 1820
Joined: Mon Nov 11, 2019 1:05 pm
Location: INJECT HIM WITH BLEACH

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.
I'll miss him after he's died in the pandemic

User avatar
shpalman
After Pie
Posts: 1962
Joined: Mon Nov 11, 2019 12:53 pm
Location: One step beyond

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?
molto tricky

User avatar
lpm
After Pie
Posts: 1820
Joined: Mon Nov 11, 2019 1:05 pm
Location: INJECT HIM WITH BLEACH

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.
I'll miss him after he's died in the pandemic

RobS
Gray Pubic
Posts: 13
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
Dorkwood
Posts: 1146
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.
I know this is vitriol, no solution, spleen venting, but I feel better having screamed, don’t you?

noggins
Sindis Poop
Posts: 84
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
Clardic Fug
Posts: 204
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.
If you bring you kids up to think for themselves, you can't complain when they do

User avatar
Grumble
Dorkwood
Posts: 1146
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.
I know this is vitriol, no solution, spleen venting, but I feel better having screamed, don’t you?

RobS
Gray Pubic
Posts: 13
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
Stargoon
Posts: 90
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: 13
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
Dorkwood
Posts: 1594
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
After Pie
Posts: 1820
Joined: Mon Nov 11, 2019 1:05 pm
Location: INJECT HIM WITH BLEACH

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.
I'll miss him after he's died in the pandemic

bagpuss
Snowbonk
Posts: 450
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
Catbabel
Posts: 866
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:
People who use Godwin's Law are worse than Hitler.

noggins
Sindis Poop
Posts: 84
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
Dorkwood
Posts: 1594
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
After Pie
Posts: 1853
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...
don't get any big ideas, they're not gonna happen

User avatar
TAFKAsoveda
Sindis Poop
Posts: 74
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
After Pie
Posts: 1962
Joined: Mon Nov 11, 2019 12:53 pm
Location: One step beyond

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.
molto tricky

User avatar
Grumble
Dorkwood
Posts: 1146
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.
I know this is vitriol, no solution, spleen venting, but I feel better having screamed, don’t you?

Lew Dolby
Clardic Fug
Posts: 204
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/
If you bring you kids up to think for themselves, you can't complain when they do

User avatar
lpm
After Pie
Posts: 1820
Joined: Mon Nov 11, 2019 1:05 pm
Location: INJECT HIM WITH BLEACH

Re: COVID-19

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

Image
I'll miss him after he's died in the pandemic

User avatar
El Pollo Diablo
Dorkwood
Posts: 1377
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
Mike Patton wrote:"You overdo it sometimes. There I am, peeing on Axl Rose’s teleprompter." He looks rueful: "I didn’t really have to do that."

User avatar
Grumble
Dorkwood
Posts: 1146
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.
I know this is vitriol, no solution, spleen venting, but I feel better having screamed, don’t you?

Post Reply