So, coronavirus...
- tabascoboy
- Posts: 6474
- Joined: Tue Jun 30, 2020 8:22 am
- Location: 曇りの街
Excel error
"The extraordinary meltdown is believed to have been caused by an Excel spreadsheet containing lab results reaching its maximum size, and failing to update.”
Blame Bill Gates
"The extraordinary meltdown is believed to have been caused by an Excel spreadsheet containing lab results reaching its maximum size, and failing to update.”
Blame Bill Gates
Last edited by Glaston on Mon Oct 05, 2020 11:57 am, edited 1 time in total.
- Insane_Homer
- Posts: 5389
- Joined: Tue Jun 30, 2020 3:14 pm
- Location: Leafy Surrey
Well this should balance out the 'false postives'
https://www.bbc.co.uk/news/uk-54412581
https://www.bbc.co.uk/news/uk-54412581
A technical glitch that meant nearly 16,000 cases of coronavirus went unreported has delayed efforts to trace contacts of people who tested positive.
Public Health England said 15,841 cases between 25 September and 2 October were left out of the UK daily case figures.
“Facts are meaningless. You could use facts to prove anything that's even remotely true.”
- Uncle fester
- Posts: 4192
- Joined: Mon Jun 29, 2020 9:42 pm
How are the various countries managing in terms of getting people to practice social distancing?
We were doing okay in Ireland but the number of people giving up seems to be on the increase.
This was yesterday.
We were doing okay in Ireland but the number of people giving up seems to be on the increase.
This was yesterday.
-
- Posts: 1731
- Joined: Tue Jun 30, 2020 2:49 pm
Insane_Homer wrote: ↑Mon Oct 05, 2020 11:57 am Well this should balance out the 'false postives'
https://www.bbc.co.uk/news/uk-54412581
A technical glitch that meant nearly 16,000 cases of coronavirus went unreported has delayed efforts to trace contacts of people who tested positive.
Public Health England said 15,841 cases between 25 September and 2 October were left out of the UK daily case figures.
Not even close on the numbers balancing out false positives, you’ve not responded to the posts about that yet, I’d keep your head down.
-
- Posts: 1731
- Joined: Tue Jun 30, 2020 2:49 pm
- Insane_Homer
- Posts: 5389
- Joined: Tue Jun 30, 2020 3:14 pm
- Location: Leafy Surrey
22,961, Daily number of new people with a lab-confirmed positive test result reported on Sunday, 4 October 2020
https://coronavirus.data.gov.uk/?_ga=2. ... 1586367656
Patients in Hospital for the last 31 days to 1/10 as per https://coronavirus.data.gov.uk/healthcare
https://coronavirus.data.gov.uk/?_ga=2. ... 1586367656
Patients in Hospital for the last 31 days to 1/10 as per https://coronavirus.data.gov.uk/healthcare
“Facts are meaningless. You could use facts to prove anything that's even remotely true.”
-
- Posts: 1731
- Joined: Tue Jun 30, 2020 2:49 pm
Insane_Homer wrote: ↑Mon Oct 05, 2020 1:33 pm 22,961, Daily number of new people with a lab-confirmed positive test result reported on Sunday, 4 October 2020
https://coronavirus.data.gov.uk/?_ga=2. ... 1586367656
Patients in Hospital for the last 31 days to 1/10 as per https://coronavirus.data.gov.uk/healthcare
Again, it’s like the whole discussion about the numbers, excel spreadsheet etc haven’t happened.
Just post numbers Forrest just post numbers.
- Insane_Homer
- Posts: 5389
- Joined: Tue Jun 30, 2020 3:14 pm
- Location: Leafy Surrey
When you can't argue the point resort to ad hominem again.
For someone who claims he and his child are on the spectrum, I find this line of attack very odd. But that's the type of relentless tasteless cunt that you are. for shame.
“Facts are meaningless. You could use facts to prove anything that's even remotely true.”
Yep!!!!!
https://www.theguardian.com/politics/2 ... n-englandIn this case, the Guardian understands, one lab had sent its daily test report to PHE in the form of a CSV file – the simplest possible database format, just a list of values separated by commas. That report was then loaded into Microsoft Excel, and the new tests at the bottom were added to the main database.
But while CSV files can be any size, Microsoft Excel files can only be 1,048,576 rows long. When a CSV file longer than that is opened, the bottom rows get cut off and are no longer displayed. That means that, once the lab had performed more than a million tests, it was only a matter of time before its reports failed to be read by PHE.
-
- Posts: 1731
- Joined: Tue Jun 30, 2020 2:49 pm
Insane_Homer wrote: ↑Mon Oct 05, 2020 2:15 pmWhen you can't argue the point resort to ad hominem again.
For someone who claims he and his child are on the spectrum, I find this line of attack very odd. But that's the type of relentless tasteless cunt that you are. for shame.
“Ad hominem”
“Relentless tasteless cunt”.
You’re certainly special. And of course ignoring that I didn’t just post the ad hominem I posted the point that the numbers you’d posted from yesterday were discussed and quite clearly had issue, again you chose to ignore that because you want to “post numbers”
Oh, and how about you take the advice regarding false positive and stop just posting numbers it’s stupid, you don’t understand the basics of them.
-
- Posts: 1731
- Joined: Tue Jun 30, 2020 2:49 pm
SaintK wrote: ↑Mon Oct 05, 2020 2:37 pmYep!!!!!https://www.theguardian.com/politics/2 ... n-englandIn this case, the Guardian understands, one lab had sent its daily test report to PHE in the form of a CSV file – the simplest possible database format, just a list of values separated by commas. That report was then loaded into Microsoft Excel, and the new tests at the bottom were added to the main database.
But while CSV files can be any size, Microsoft Excel files can only be 1,048,576 rows long. When a CSV file longer than that is opened, the bottom rows get cut off and are no longer displayed. That means that, once the lab had performed more than a million tests, it was only a matter of time before its reports failed to be read by PHE.
It might be a good time to ask where the billions are being spent, cause it ain’t on IT.
Fuck me a simple SQL table would ensure this never happenned, so many brainless fucks trying to do something on the cheap.SaintK wrote: ↑Mon Oct 05, 2020 2:37 pmYep!!!!!https://www.theguardian.com/politics/2 ... n-englandIn this case, the Guardian understands, one lab had sent its daily test report to PHE in the form of a CSV file – the simplest possible database format, just a list of values separated by commas. That report was then loaded into Microsoft Excel, and the new tests at the bottom were added to the main database.
But while CSV files can be any size, Microsoft Excel files can only be 1,048,576 rows long. When a CSV file longer than that is opened, the bottom rows get cut off and are no longer displayed. That means that, once the lab had performed more than a million tests, it was only a matter of time before its reports failed to be read by PHE.
- Insane_Homer
- Posts: 5389
- Joined: Tue Jun 30, 2020 3:14 pm
- Location: Leafy Surrey
“Facts are meaningless. You could use facts to prove anything that's even remotely true.”
Anyone who has worked in any public sector IT job is not surprised by this.ASMO wrote: ↑Mon Oct 05, 2020 3:16 pmFuck me a simple SQL table would ensure this never happenned, so many brainless fucks trying to do something on the cheap.SaintK wrote: ↑Mon Oct 05, 2020 2:37 pmYep!!!!!https://www.theguardian.com/politics/2 ... n-englandIn this case, the Guardian understands, one lab had sent its daily test report to PHE in the form of a CSV file – the simplest possible database format, just a list of values separated by commas. That report was then loaded into Microsoft Excel, and the new tests at the bottom were added to the main database.
But while CSV files can be any size, Microsoft Excel files can only be 1,048,576 rows long. When a CSV file longer than that is opened, the bottom rows get cut off and are no longer displayed. That means that, once the lab had performed more than a million tests, it was only a matter of time before its reports failed to be read by PHE.
tc27 wrote: ↑Mon Oct 05, 2020 3:23 pmAnyone who has worked in any public sector IT job is not surprised by this.ASMO wrote: ↑Mon Oct 05, 2020 3:16 pmFuck me a simple SQL table would ensure this never happenned, so many brainless fucks trying to do something on the cheap.SaintK wrote: ↑Mon Oct 05, 2020 2:37 pm
Yep!!!!!
https://www.theguardian.com/politics/2 ... n-england
you mean like me
- ScarfaceClaw
- Posts: 2623
- Joined: Mon Jun 29, 2020 7:11 pm
£12bn is on the cheap? I’m expecting big things from the £15bn budget for free NotPR.ASMO wrote: ↑Mon Oct 05, 2020 3:16 pmFuck me a simple SQL table would ensure this never happenned, so many brainless fucks trying to do something on the cheap.SaintK wrote: ↑Mon Oct 05, 2020 2:37 pmYep!!!!!https://www.theguardian.com/politics/2 ... n-englandIn this case, the Guardian understands, one lab had sent its daily test report to PHE in the form of a CSV file – the simplest possible database format, just a list of values separated by commas. That report was then loaded into Microsoft Excel, and the new tests at the bottom were added to the main database.
But while CSV files can be any size, Microsoft Excel files can only be 1,048,576 rows long. When a CSV file longer than that is opened, the bottom rows get cut off and are no longer displayed. That means that, once the lab had performed more than a million tests, it was only a matter of time before its reports failed to be read by PHE.
Only it's not cheap! They're pissing squillions away on thisASMO wrote: ↑Mon Oct 05, 2020 3:16 pmFuck me a simple SQL table would ensure this never happenned, so many brainless fucks trying to do something on the cheap.SaintK wrote: ↑Mon Oct 05, 2020 2:37 pmYep!!!!!https://www.theguardian.com/politics/2 ... n-englandIn this case, the Guardian understands, one lab had sent its daily test report to PHE in the form of a CSV file – the simplest possible database format, just a list of values separated by commas. That report was then loaded into Microsoft Excel, and the new tests at the bottom were added to the main database.
But while CSV files can be any size, Microsoft Excel files can only be 1,048,576 rows long. When a CSV file longer than that is opened, the bottom rows get cut off and are no longer displayed. That means that, once the lab had performed more than a million tests, it was only a matter of time before its reports failed to be read by PHE.
But it's ok as Hancock is telling Parliament that it's PHE's computer system that's to blame not his pals at Serco, Deloittes and all the others he's handed contracts to
Thought he has ultimate responsibility for PHE still.
I'm sure Baroness Hiding will sort all out
-
- Posts: 1731
- Joined: Tue Jun 30, 2020 2:49 pm
I’m starting to grasp why HS2 is so expensive.
10 billion on actual structures and rails n stuff.
90 billion on the canteen rota spreadsheet and weekly Euro millions syndicate.
10 billion on actual structures and rails n stuff.
90 billion on the canteen rota spreadsheet and weekly Euro millions syndicate.
-
- Posts: 1731
- Joined: Tue Jun 30, 2020 2:49 pm
Insane_Homer wrote: ↑Mon Oct 05, 2020 3:20 pm https://coronavirus.data.gov.uk/healthcare
England Only - Patients in Hospital for the last month
Doubling every 15 days or so.
Have none at all been sent home though?
-
- Posts: 1731
- Joined: Tue Jun 30, 2020 2:49 pm
SaintK wrote: ↑Mon Oct 05, 2020 3:57 pmOnly it's not cheap! They're pissing squillions away on thisASMO wrote: ↑Mon Oct 05, 2020 3:16 pmFuck me a simple SQL table would ensure this never happenned, so many brainless fucks trying to do something on the cheap.SaintK wrote: ↑Mon Oct 05, 2020 2:37 pm
Yep!!!!!
https://www.theguardian.com/politics/2 ... n-england
But it's ok as Hancock is telling Parliament that it's PHE's computer system that's to blame not his pals at Serco, Deloittes and all the others he's handed contracts to
Thought he has ultimate responsibility for PHE still.
I'm sure Baroness Hiding will sort all out
In fairness to the consultants even Deloittes wouldn’t just do it on excel.
Bimbowomxn wrote: ↑Mon Oct 05, 2020 4:13 pm I’m starting to grasp why HS2 is so expensive.
10 billion on actual structures and rails n stuff.
90 billion on the canteen rota spreadsheet and weekly Euro millions syndicate.
That’s daily numbers “in” hospital. The link says it is the total number as at midnight each day. So yes, people will have been discharged but that is being outstripped by new admissions.*Bimbowomxn wrote: ↑Mon Oct 05, 2020 4:15 pmInsane_Homer wrote: ↑Mon Oct 05, 2020 3:20 pm https://coronavirus.data.gov.uk/healthcare
England Only - Patients in Hospital for the last month
Doubling every 15 days or so.
Have none at all been sent home though?
* unless a formula in the spreadsheet is wrong etc
Public sector costs are massively inflated (i would estimate by at least 50%) by being forced to buy off approved frameworks such as GCLOUD. Approved suppliers on there charge rates that no private sector business would ever dream of paying. 2k a day for a consultant 1k a day for a Project Manager is not unusual, £1500 for a bolt standard laptop that can be bought for about £500.00 from PC world. Because the rates are fixed, there is no competition to drive down prices, they all charge the maximum possible on the ratecard, it is an utter joke.Bimbowomxn wrote: ↑Mon Oct 05, 2020 4:13 pm I’m starting to grasp why HS2 is so expensive.
10 billion on actual structures and rails n stuff.
90 billion on the canteen rota spreadsheet and weekly Euro millions syndicate.
If you want to save a lot of money very quickly, get rid of closed frameworks and allow public sector to go out to open market, i can guarantee bilions will be saved annually, but it will never happeen because those at the top are deeply in bed with companies on those frameworks.
-
- Posts: 1731
- Joined: Tue Jun 30, 2020 2:49 pm
I hear you ASMO, well sold
Seriously though “Excel”?
Seriously though “Excel”?
Procurement and approved suppliers in the public sector are huge topics, I get the reasoning, that it acts as a kind of quality control and that it saves masses of time in terms of not having to sort through gazzillions of bids across the entire sector, but there does seem to be an element of private sector companies troughing it up when the public is paying.
My wife had to go through these procedures in order to secure services, but the consultants themselves don't make £2K per day, the big firms charge that or more, yes, but the consultants don't get paid that.
A tiny anecdote, and this was a while ago - my brother was forced to buy in a component (a small circuit board) for a control system, it cost almost £1600, he estimates he could have made it himself for under twenty quid plus his time, but it would have invalidated all insurance policies as it wouldn't have been from an approved source.
edit, I know this is off topic so I'll keep it brief, a report on procurement in the UK https://www.instituteforgovernment.org. ... _WEB_4.pdf
My wife had to go through these procedures in order to secure services, but the consultants themselves don't make £2K per day, the big firms charge that or more, yes, but the consultants don't get paid that.
A tiny anecdote, and this was a while ago - my brother was forced to buy in a component (a small circuit board) for a control system, it cost almost £1600, he estimates he could have made it himself for under twenty quid plus his time, but it would have invalidated all insurance policies as it wouldn't have been from an approved source.
edit, I know this is off topic so I'll keep it brief, a report on procurement in the UK https://www.instituteforgovernment.org. ... _WEB_4.pdf
Last edited by Tichtheid on Tue Oct 06, 2020 9:30 am, edited 1 time in total.
-
- Posts: 1731
- Joined: Tue Jun 30, 2020 2:49 pm
Depends on 1/2 term is the rumour here , circuit breaker planned for 11th Oct
Neanderthal genes make you more susceptible to Covid.
Thats kind of weird, that something from 30000 years ago has an effect today.
Also interesting to read that 90 % of all infections happen indoors.
This is all from some stuff the Germans are putting out.
Thats kind of weird, that something from 30000 years ago has an effect today.
Also interesting to read that 90 % of all infections happen indoors.
This is all from some stuff the Germans are putting out.
Yeah, my wife said at the time of the BLM rallies that if there were no spikes after 14 days it would help to show that outdoors was much safer than indoors - it's not exactly conclusive, but you'd think it was an indication.
- Insane_Homer
- Posts: 5389
- Joined: Tue Jun 30, 2020 3:14 pm
- Location: Leafy Surrey
When the twunt's father's a twunt, what hope do we have?
“Facts are meaningless. You could use facts to prove anything that's even remotely true.”
The Guardian are reporting that the SNP MP Margaret Ferrier also attended a church service and gave a reading to the congregation the day after she took a test for coronavirus.
So we now know that on the day she developed symptoms and took a test, she visited a gift shop, a beauty salon and a leisure centre in her constituency. She then attended mass at St Mungo’s Church in Townhead on the following day and gave a bible reading from the altar, before traveling to London on public transport, and speaking in the House. Finally, after receiving a positive test result, she returned to Glasgow by public transport, before finally deciding it might be a good idea to start self-isolating a mere four days after developing symptoms.
Just how stupid is she? And why hasn’t she resigned yet?
So we now know that on the day she developed symptoms and took a test, she visited a gift shop, a beauty salon and a leisure centre in her constituency. She then attended mass at St Mungo’s Church in Townhead on the following day and gave a bible reading from the altar, before traveling to London on public transport, and speaking in the House. Finally, after receiving a positive test result, she returned to Glasgow by public transport, before finally deciding it might be a good idea to start self-isolating a mere four days after developing symptoms.
Just how stupid is she? And why hasn’t she resigned yet?
You mean the uber twunt Stanley Johnson the well known wife beater?Insane_Homer wrote: ↑Tue Oct 06, 2020 11:54 am When the twunt's father's a twunt, what hope do we have?
- Northern Lights
- Posts: 524
- Joined: Tue Jun 30, 2020 7:32 am
As super-spreaders go she gave it a damn good shot, not sure how much more she could have chucked it around. As to not resigning i reckon she is hunkering down and hoping it will all blow over, only suspended from the SNP at the moment not expelled, same as Derek Mackay for that matter he is still a card carrier and that is now 6 months old.Lobby wrote: ↑Tue Oct 06, 2020 12:25 pm The Guardian are reporting that the SNP MP Margaret Ferrier also attended a church service and gave a reading to the congregation the day after she took a test for coronavirus.
So we now know that on the day she developed symptoms and took a test, she visited a gift shop, a beauty salon and a leisure centre in her constituency. She then attended mass at St Mungo’s Church in Townhead on the following day and gave a bible reading from the altar, before traveling to London on public transport, and speaking in the House. Finally, after receiving a positive test result, she returned to Glasgow by public transport, before finally deciding it might be a good idea to start self-isolating a mere four days after developing symptoms.
Just how stupid is she? And why hasn’t she resigned yet?
- Insane_Homer
- Posts: 5389
- Joined: Tue Jun 30, 2020 3:14 pm
- Location: Leafy Surrey
Probably waiting for the offer from the Tories to cross the floor and get a cabinet post?Lobby wrote: ↑Tue Oct 06, 2020 12:25 pm The Guardian are reporting that the SNP MP Margaret Ferrier also attended a church service and gave a reading to the congregation the day after she took a test for coronavirus.
So we now know that on the day she developed symptoms and took a test, she visited a gift shop, a beauty salon and a leisure centre in her constituency. She then attended mass at St Mungo’s Church in Townhead on the following day and gave a bible reading from the altar, before traveling to London on public transport, and speaking in the House. Finally, after receiving a positive test result, she returned to Glasgow by public transport, before finally deciding it might be a good idea to start self-isolating a mere four days after developing symptoms.
Just how stupid is she? And why hasn’t she resigned yet?
“Facts are meaningless. You could use facts to prove anything that's even remotely true.”
Northern Lights wrote: ↑Tue Oct 06, 2020 12:38 pmAs super-spreaders go she gave it a damn good shot, not sure how much more she could have chucked it around. As to not resigning i reckon she is hunkering down and hoping it will all blow over, only suspended from the SNP at the moment not expelled, same as Derek Mackay for that matter he is still a card carrier and that is now 6 months old.Lobby wrote: ↑Tue Oct 06, 2020 12:25 pm The Guardian are reporting that the SNP MP Margaret Ferrier also attended a church service and gave a reading to the congregation the day after she took a test for coronavirus.
So we now know that on the day she developed symptoms and took a test, she visited a gift shop, a beauty salon and a leisure centre in her constituency. She then attended mass at St Mungo’s Church in Townhead on the following day and gave a bible reading from the altar, before traveling to London on public transport, and speaking in the House. Finally, after receiving a positive test result, she returned to Glasgow by public transport, before finally deciding it might be a good idea to start self-isolating a mere four days after developing symptoms.
Just how stupid is she? And why hasn’t she resigned yet?
The last I read the SNP were drawing up an all-woman shortlist to stand for the Renfrewshire N&W seat.Welcome to Derek Mackay MSP's biography pages
Derek Mackay MSP
Here you can find out about your MSPs' political activities and how to get in touch with them.
Member for: Renfrewshire North and West
Region: West Scotland
Party: Independent
- Northern Lights
- Posts: 524
- Joined: Tue Jun 30, 2020 7:32 am
I’m sure they are, as that’s what they’ve been doing in a load of seats, whether that’s a good policy or not is open to debate, I personally would prefer strongest candidate irrespective of sex.Tichtheid wrote: ↑Tue Oct 06, 2020 12:49 pmNorthern Lights wrote: ↑Tue Oct 06, 2020 12:38 pmAs super-spreaders go she gave it a damn good shot, not sure how much more she could have chucked it around. As to not resigning i reckon she is hunkering down and hoping it will all blow over, only suspended from the SNP at the moment not expelled, same as Derek Mackay for that matter he is still a card carrier and that is now 6 months old.Lobby wrote: ↑Tue Oct 06, 2020 12:25 pm The Guardian are reporting that the SNP MP Margaret Ferrier also attended a church service and gave a reading to the congregation the day after she took a test for coronavirus.
So we now know that on the day she developed symptoms and took a test, she visited a gift shop, a beauty salon and a leisure centre in her constituency. She then attended mass at St Mungo’s Church in Townhead on the following day and gave a bible reading from the altar, before traveling to London on public transport, and speaking in the House. Finally, after receiving a positive test result, she returned to Glasgow by public transport, before finally deciding it might be a good idea to start self-isolating a mere four days after developing symptoms.
Just how stupid is she? And why hasn’t she resigned yet?
The last I read the SNP were drawing up an all-woman shortlist to stand for the Renfrewshire N&W seat.Welcome to Derek Mackay MSP's biography pages
Derek Mackay MSP
Here you can find out about your MSPs' political activities and how to get in touch with them.
Member for: Renfrewshire North and West
Region: West Scotland
Party: Independent
Mackay has been suspended not expelled, whip removed so will be listed as Independent.