Johnson gets negative satisfaction ratings from Tory party members – politicalbetting.com
Comments
-
A tee total party of fit, young athletes who did temperature tests on the door...TheScreamingEagles said:Ban them from ever playing for England.
Tammy Abraham, Ben Chilwell and Jadon Sancho will not join up with the England squad for this month’s games against Wales, Belgium and Denmark until the Football Association has investigated the trio’s attendance at a party that allegedly breached Covid-19 regulations.
The FA has decided to take precautions and ensure there is no risk to the wider group after footage emerged which appeared to show Abraham, Chilwell and Sancho at a party in London with more than six people – breaking the government’s “rule of six” coronavirus guidelines – on Saturday evening. Abraham has apologised and Chelsea are to remind the striker and Chilwell of their responsibilities.
https://www.theguardian.com/football/2020/oct/05/abraham-chilwell-and-sancho-pictured-at-party-in-apparent-covid-breach-england-fa
Move over Georgie Best and Diego Armando Maradona!
0 -
An option but it's a long timeframe and with Betfair I can close to flat when it's down to 1.3 next Spring.isam said:
Or do it privately on here and save the comm/tying up the moneykinabalu said:On topic and betting post -
I think Johnson is an absurdity as PM but I also consider the view he is likely to be gone soon to be wildly off beam. Just 10 months ago he won a general election by 80 seats. The best majority for the Conservatives since 1980s Thatcher in her pomp. He did so from a position 6 months prior on assuming the leadership where the party looked to be - was - in a hole. It was a personal triumph. A complete vindication of the ghastly man and his ghastly methods.
He will not be stepping down voluntarily. People in top jobs do not relinquish power and status except for health reasons and there is no reason to expect that here. He does not have long Covid. Neither will he be forced out by his party for the foreseeable future. The earliest it could happen is 2023 and only then if (i) he has become a clear electoral liability and (ii) there is a replacement guaranteed to be more popular.
So, there is a Betfair market, Boris Johnson exit date, and "July 2022 or later" can be backed at 1.8. I think that is outstanding value. It should be more like 1.33.
If any of the punters here take the opposite view and think it should be longer and the value is in the other direction - the lay - I have money there at 1.85 looking for a match. £50 for starters but with appetite for more. Just hit me.0 -
HS ?Alistair said:
I've been pretty brutal in my polling analysis. Anyone who isn't reporting clear education breakdowns is binned.Peter_the_Punter said:
I haven't missed it. It's distinctly possible. There's not a lot of point discussing it though because the consequences are so obvious (one of these being I become a good deal better off.)Alistair said:
There's a companion "why did we get it wrong" piece to go with the one from the weekend. The how did we miss Biden sweeping to one of the largest victories ever. Taking the entire west and east coast as well as TexasPeter_the_Punter said:
Maybe the locals have heard Trump's planning to have his ugly mug carved into Mount Rushmore and are piling in to make sure it doesn't happen?Richard_Nabavi said:
Dunno why it's high there, but it's a tiny electorate in a big place, so maybe it's just convenience.Peter_the_Punter said:
SD = South Dakota? Why so high there? It's solid Republican anyway.Richard_Nabavi said:
Anyone with comically low HS or less figures is binned.
But that still leaves a lot of polls and those polls have - based on historic turnout - very, very high HS or less weighting. It is non trivial to the end result, worth a couple of percentage points to Trump and a couple off Biden.
If, in a state where HS or less turnout was less than 20% in 2018 and 2016 it seems rather..... aggressive to me to weight your sample to 34% HS or less for 2020.0 -
Summary of the three forecasting models where I can download or derive the full ECV probability distribution (538 and Economist as at just a moment ago, YouGov as at 3rd October):
538 Economist YouGov
---------------------------------------------------
Probability of Biden win 81% 89% 83%
Probability of Trump win 19% 11% 17%
Median of probability distribution
(i.e. 50% of the distribution is above/below this value):
Biden ECVs: 338 339 342
Trump ECVs: 200 199 196
Expected value of probability distribution
(i.e. fair value for spread bets):
Biden ECVs: 335 334 337
Trump ECVs: 203 204 201
Probability by Ladbrokes band
Biden 400+ 22% 8% 19%
Biden 350-399 23% 35% 27%
Biden 300-349 23% 33% 24%
Biden 270-299 13% 12% 13%
Trump 270-299 8% 6% 9%
Trump 300-349 9% 5% 7%
Trump 350-399 1% 0% 0%
Trump 400+ 0% 0% 0%2 -
Not sure much can be inferred from what is happening in SD.0
-
Biden is on drugs has worked out well.FrancisUrquhart said:The thing that convinces me Trump is dead in the water for re-election. Last time he got himself the 3-4 slogans, make America great, build the wall, lock her up, and they resonanced, even if people didn't really quite believe how he would achieve them or want clinton locked up (it just reinforced opinion that some shifty stuff about Clintons).
This time he has got nothing going. Sleepy Joe doesn't really go anywhere, does keep America great. He has tried getting the Harris is a far leftist, Biden is on drugs, but we aren't seeing people really going for them.
0 -
If you look at 538s analysis you'll see 400+ for Biden is now one of the more probable outcomes, so you and I are not alone it considering it.Alistair said:
I've been pretty brutal in my polling analysis. Anyone who isn't reporting clear education breakdowns is binned.Peter_the_Punter said:
I haven't missed it. It's distinctly possible. There's not a lot of point discussing it though because the consequences are so obvious (one of these being I become a good deal better off.)Alistair said:
There's a companion "why did we get it wrong" piece to go with the one from the weekend. The how did we miss Biden sweeping to one of the largest victories ever. Taking the entire west and east coast as well as TexasPeter_the_Punter said:
Maybe the locals have heard Trump's planning to have his ugly mug carved into Mount Rushmore and are piling in to make sure it doesn't happen?Richard_Nabavi said:
Dunno why it's high there, but it's a tiny electorate in a big place, so maybe it's just convenience.Peter_the_Punter said:
SD = South Dakota? Why so high there? It's solid Republican anyway.Richard_Nabavi said:
Anyone with comically low HS or less figures is binned.
But that still leaves a lot of polls and those polls have - based on historic turnout - very, very high HS or less weighting. It is non trivial to the end result, worth a couple of percentage points to Trump and a couple off Biden.
If, in a state where HS or less turnout was less than 20% in 2018 and 2016 it seems rather..... aggressive to me to weight your sample to 34% HS or less for 2020.
Incidentally I see Nate has just tweaked Trump down to 18% - or 9/2 in traditional bookies fractions. Other models are available, mostly suggesting bigger prices.0 -
You can still do that if you've had the original bet on here cant you?kinabalu said:
An option but it's a long timeframe and with Betfair I can close to flat when it's down to 1.3 next Spring.isam said:
Or do it privately on here and save the comm/tying up the moneykinabalu said:On topic and betting post -
I think Johnson is an absurdity as PM but I also consider the view he is likely to be gone soon to be wildly off beam. Just 10 months ago he won a general election by 80 seats. The best majority for the Conservatives since 1980s Thatcher in her pomp. He did so from a position 6 months prior on assuming the leadership where the party looked to be - was - in a hole. It was a personal triumph. A complete vindication of the ghastly man and his ghastly methods.
He will not be stepping down voluntarily. People in top jobs do not relinquish power and status except for health reasons and there is no reason to expect that here. He does not have long Covid. Neither will he be forced out by his party for the foreseeable future. The earliest it could happen is 2023 and only then if (i) he has become a clear electoral liability and (ii) there is a replacement guaranteed to be more popular.
So, there is a Betfair market, Boris Johnson exit date, and "July 2022 or later" can be backed at 1.8. I think that is outstanding value. It should be more like 1.33.
If any of the punters here take the opposite view and think it should be longer and the value is in the other direction - the lay - I have money there at 1.85 looking for a match. £50 for starters but with appetite for more. Just hit me.0 -
Guardian article on the Excel error.
https://www.theguardian.com/politics/2020/oct/05/how-excel-may-have-caused-loss-of-16000-covid-tests-in-england0 -
Good point on the broken promises -FrancisUrquhart said:The thing that convinces me Trump is dead in the water for re-election. Last time he got himself the 3-4 slogans, make America great, build the wall, lock her up, and they resonanced, even if people didn't really quite believe how he would achieve them or want clinton locked up (it just reinforced opinion that some shifty stuff about Clintons).
This time he has got nothing going. Sleepy Joe doesn't really go anywhere, does keep America great. He has tried getting the Harris is a far leftist, Biden is on drugs, but we aren't seeing people really going for them.
He hasn't made America great again.
He hasn't built the Wall.
He hasn't locked her up.
Only people locked up are his 2016 campaign team.1 -
The true horror was always the application that the company totally relies on which was built using vb3 over access using crystal reports by the accountant that left 5 years ago and could you add a few features please....what do you mean source code and spec?Malmesbury said:
The banks got there first. I think I have spent more than half my life trying to remove Excel from the financial operations chain.....Selebian said:
It's common to refer to said hammer as the [insert name of city to be dissed, e.g. Birmingham] screwdriver - perhaps we should all start referring to Excel as the 'Whitehall Database'?eristdoof said:Caught out be the new thread problem again...
If a tradesman comes to your house to repair your fridge and has nothing but a hammer with him, it is obvious to everyone, even Boris, that he is unfit to be a fridge repairman, professional or amateur.
If a data scientist tries to compile the official government SARS-COV2 data and has nothing but Excel, it is obvious ....
Thank god we managed to kill Access. That was a stake-through-the-heart-with-garlix-and-silver-hollowpoints-just-in-case thing.....0 -
Every time the finance team updates their spreadsheet, the IPS complains that they are trying to do SQL injection on the finance database!Pagan2 said:The true horror was always the application that the company totally relies on which was built using vb3 over access using crystal reports by the accountant that left 5 years ago and could you add a few features please....what do you mean source code and spec?
Yes, that's exactly what they are doing...0 -
Agreed.kinabalu said:
Good point on the broken promises -FrancisUrquhart said:The thing that convinces me Trump is dead in the water for re-election. Last time he got himself the 3-4 slogans, make America great, build the wall, lock her up, and they resonanced, even if people didn't really quite believe how he would achieve them or want clinton locked up (it just reinforced opinion that some shifty stuff about Clintons).
This time he has got nothing going. Sleepy Joe doesn't really go anywhere, does keep America great. He has tried getting the Harris is a far leftist, Biden is on drugs, but we aren't seeing people really going for them.
He hasn't made America great again.
He hasn't built the Wall.
He hasn't locked her up.
Only people locked up are his 2016 campaign team.
Drain the Swamp is also a corker!1 -
I would point out that pollsters got 2012 wrong because they assumed some reversion to the mean for African American turnout.
What is HS turnout not only doesn't mean revert, but instead becomes even greater?0 -
So columns weren't the issue after all?LostPassword said:Guardian article on the Excel error.
https://www.theguardian.com/politics/2020/oct/05/how-excel-may-have-caused-loss-of-16000-covid-tests-in-england0 -
It's my 30% expectation. I'll be a bit disappointed with a 'solid but not spectacular' outcome.Peter_the_Punter said:
I haven't missed it. It's distinctly possible. There's not a lot of point discussing it though because the consequences are so obvious (one of these being I become a good deal better off.)Alistair said:
There's a companion "why did we get it wrong" piece to go with the one from the weekend. The how did we miss Biden sweeping to one of the largest victories ever. Taking the entire west and east coast as well as TexasPeter_the_Punter said:
Maybe the locals have heard Trump's planning to have his ugly mug carved into Mount Rushmore and are piling in to make sure it doesn't happen?Richard_Nabavi said:
Dunno why it's high there, but it's a tiny electorate in a big place, so maybe it's just convenience.Peter_the_Punter said:
SD = South Dakota? Why so high there? It's solid Republican anyway.Richard_Nabavi said:0 -
Twenty years back, one of my contracts was with a large, well known sportswear manufacturer (many of you will own their products) in which the whole design and ordering dept ran on MS-Access. I was on a 12 month contract there, I lasted 6 months. Their Head of IT was a throwback of the worst type and would have had them accepting orders on punched cards if he could have managed it.Malmesbury said:
The banks got there first. I think I have spent more than half my life trying to remove Excel from the financial operations chain.....Selebian said:
It's common to refer to said hammer as the [insert name of city to be dissed, e.g. Birmingham] screwdriver - perhaps we should all start referring to Excel as the 'Whitehall Database'?eristdoof said:Caught out be the new thread problem again...
If a tradesman comes to your house to repair your fridge and has nothing but a hammer with him, it is obvious to everyone, even Boris, that he is unfit to be a fridge repairman, professional or amateur.
If a data scientist tries to compile the official government SARS-COV2 data and has nothing but Excel, it is obvious ....
Thank god we managed to kill Access. That was a stake-through-the-heart-with-garlix-and-silver-hollowpoints-just-in-case thing.....0 -
That is a genius idea.Scott_xP said:
Put Ozil in the suit.TheScreamingEagles said:This is the club that pays Mesut Özil £350,000 per week to not play and recently gave Pierre-Emerick Aubameyang a similar salary, as John W Henry famously tweeted
'What do you think they're smoking over there at The Emirates?'
Problem solved0 -
The Labour Party has nothing to do with me, Mr Wales, and still less does Corbyn. I have no responsibility for either of them.Big_G_NorthWales said:
And did you take the responsibility for Corbyn destroying labourClippP said:
Why on earth are you calling for a Government of National Unity? "We have an 80 seat majority and we can do whatever we like" - remember?Big_G_NorthWales said:Boris does not have the skill set to deal with covid and I assume most conservatives are appalled at the way he has locked down the economy
It is not getting better anytime soon as covid takes hold again and brexit looking touch and go
Rishi's endorsement of Boris today is no doubt an attempt to shore him up but it is not going to work
I hope he sees the writing on the wall and decides to stand down, or the MP's send in the 40 letters to the 1922 Committee
Having said that Macron has plummeted in the polls even more than Boris and Ireland is looking at a new full lockdown
The time must be coming for a GNU and if the politicians were putting the country first they would do it now.
And at the same time do a deal (any deal) with the EU and get a six month implementation extension
The present outfit is not short of votes. It is short of rational policies and of competent politicians. The problem is that any rational policy would not be acceptable to Johnson and his gang of incompetents. And they would not be happy at being obliged to move out and maake way for some competent Lib Dem miinisters (and even some Labour ones too, if their party bosses let them).
Come on, Mr Wales. You voted for them (I think). You must take the responsibility.
And I do think that on covid they have not done unreasonably compared to governments elsewhere
But the current shambolic government and its handing of covid..... They do not have a policy which lasts from one day to the next.... And they didn´t even try to stop the import of the virus through the airports. Quarentining is entirely voluntary. And the rules they have made up all apply to us, not to them. To say that Johnson´s government is useless is a understatement - and still you seem to support them.0 -
Assuming they have fixed the excel spreadsheet, more than 10k positives for today?0
-
Still why they had a spreadsheet with all the tests in defies all reason. Get the files daily feed them to the database, Get your report from the database. At best the daily spreadsheets should have been an interim measure. Someone at the PHE lacks a clueRobD said:
So columns weren't the issue after all?LostPassword said:Guardian article on the Excel error.
https://www.theguardian.com/politics/2020/oct/05/how-excel-may-have-caused-loss-of-16000-covid-tests-in-england0 -
Have the mods banned him from posting the original tweets?tlg86 said:
That is a genius idea.Scott_xP said:
Put Ozil in the suit.TheScreamingEagles said:This is the club that pays Mesut Özil £350,000 per week to not play and recently gave Pierre-Emerick Aubameyang a similar salary, as John W Henry famously tweeted
'What do you think they're smoking over there at The Emirates?'
Problem solved0 -
Yep, but certainly not as incompetent as using columns instead of rows.Pagan2 said:
Still why they had a spreadsheet with all the tests in defies all reason. Get the files daily feed them to the database, Get your report from the database. At best the daily spreadsheets should have been an interim measure. Someone at the PHE lacks a clueRobD said:
So columns weren't the issue after all?LostPassword said:Guardian article on the Excel error.
https://www.theguardian.com/politics/2020/oct/05/how-excel-may-have-caused-loss-of-16000-covid-tests-in-england1 -
Not that surprising he'd say England, he's a legend playing for England, and spent his life involved with England, not the UK.Theuniondivvie said:Lord Beefy of Almeria speaking for the people of England..er..UK.
https://twitter.com/Stoviesplz/status/1313120602094526464?s=200 -
This whack it all in a massive spreadsheet...makes you wonder how they are handling data security.0
-
Technically he was playing for England & Wales.Philip_Thompson said:
Not that surprising he'd say England, he's a legend playing for England, and spent his life involved with England, not the UK.Theuniondivvie said:Lord Beefy of Almeria speaking for the people of England..er..UK.
https://twitter.com/Stoviesplz/status/1313120602094526464?s=200 -
https://twitter.com/EdConwaySky/status/1313125283936038914
Is this like the case of the NHS using an unsupported version of Windows OS which was hacked?0 -
It reminds me of that police video show of boy racers, minor felons etc – Police Stop or whatever it was called.kinabalu said:
Good point on the broken promises -FrancisUrquhart said:The thing that convinces me Trump is dead in the water for re-election. Last time he got himself the 3-4 slogans, make America great, build the wall, lock her up, and they resonanced, even if people didn't really quite believe how he would achieve them or want clinton locked up (it just reinforced opinion that some shifty stuff about Clintons).
This time he has got nothing going. Sleepy Joe doesn't really go anywhere, does keep America great. He has tried getting the Harris is a far leftist, Biden is on drugs, but we aren't seeing people really going for them.
He hasn't made America great again.
He hasn't built the Wall.
He hasn't locked her up.
Only people locked up are his 2016 campaign team.
"The only place this guy is going is County Jail"1 -
Don't even go there.FrancisUrquhart said:This whack it all in a massive spreadsheet...makes you wonder how they are handling data security.
Edit: pretty sure I saw a tweet earlier from someone in IT who had refered PHE to information commissioner for this very reason.0 -
High SchoolBenpointer said:
HS ?Alistair said:
I've been pretty brutal in my polling analysis. Anyone who isn't reporting clear education breakdowns is binned.Peter_the_Punter said:
I haven't missed it. It's distinctly possible. There's not a lot of point discussing it though because the consequences are so obvious (one of these being I become a good deal better off.)Alistair said:
There's a companion "why did we get it wrong" piece to go with the one from the weekend. The how did we miss Biden sweeping to one of the largest victories ever. Taking the entire west and east coast as well as TexasPeter_the_Punter said:
Maybe the locals have heard Trump's planning to have his ugly mug carved into Mount Rushmore and are piling in to make sure it doesn't happen?Richard_Nabavi said:
Dunno why it's high there, but it's a tiny electorate in a big place, so maybe it's just convenience.Peter_the_Punter said:
SD = South Dakota? Why so high there? It's solid Republican anyway.Richard_Nabavi said:
Anyone with comically low HS or less figures is binned.
But that still leaves a lot of polls and those polls have - based on historic turnout - very, very high HS or less weighting. It is non trivial to the end result, worth a couple of percentage points to Trump and a couple off Biden.
If, in a state where HS or less turnout was less than 20% in 2018 and 2016 it seems rather..... aggressive to me to weight your sample to 34% HS or less for 2020.
0 -
rcs1000 said:
I would point out that pollsters got 2012 wrong because they assumed some reversion to the mean for African American turnout.
What is HS turnout not only doesn't mean revert, but instead becomes even greater?
What is HS?0 -
Problem is that his supporters believe he's done the first two. I saw an interview the other day with a Trump voter who said, inter alia "He's built the wall, and he's even fixed healthcare which the Democrats tried to do for years and failed." How do you deal with this level of delusion?kinabalu said:
Good point on the broken promises -FrancisUrquhart said:The thing that convinces me Trump is dead in the water for re-election. Last time he got himself the 3-4 slogans, make America great, build the wall, lock her up, and they resonanced, even if people didn't really quite believe how he would achieve them or want clinton locked up (it just reinforced opinion that some shifty stuff about Clintons).
This time he has got nothing going. Sleepy Joe doesn't really go anywhere, does keep America great. He has tried getting the Harris is a far leftist, Biden is on drugs, but we aren't seeing people really going for them.
He hasn't made America great again.
He hasn't built the Wall.
He hasn't locked her up.
Only people locked up are his 2016 campaign team.0 -
But the row limit that caused the issue was a million, so they are using the latest version. What is he on about?rottenborough said:https://twitter.com/EdConwaySky/status/1313125283936038914
Is this like the case of the NHS using an unsupported version of Windows OS which was hacked?0 -
The data is kept on a USB memory stick in the manager's desk at night. Totally securerottenborough said:
Don't even go there.FrancisUrquhart said:This whack it all in a massive spreadsheet...makes you wonder how they are handling data security.
Edit: pretty sure I saw a tweet earlier from someone in IT who had refered PHE to information commissioner for this very reason.
0 -
Indeed but does anyone ever actually say "England and Wales"?tlg86 said:
Technically he was playing for England & Wales.Philip_Thompson said:
Not that surprising he'd say England, he's a legend playing for England, and spent his life involved with England, not the UK.Theuniondivvie said:Lord Beefy of Almeria speaking for the people of England..er..UK.
https://twitter.com/Stoviesplz/status/1313120602094526464?s=20
During his time commenting and everything else he does how many times do you think he's had to say "England", how often "England and Wales", and how often "UK"?
I'd guess "England" a literal order of magnitude more than any others. It would naturally be what he'd think to say first.0 -
Floppy disk.Beibheirli_C said:
The data is kept on a USB memory stick in the manager's desk at night. Totally securerottenborough said:
Don't even go there.FrancisUrquhart said:This whack it all in a massive spreadsheet...makes you wonder how they are handling data security.
Edit: pretty sure I saw a tweet earlier from someone in IT who had refered PHE to information commissioner for this very reason.0 -
Word in Ireland is that the government will not follow the public health advice. Will only make a relatively modest tightening of restrictions. Big moment for a European government to publicly break with public health advice.
https://www.irishtimes.com/news/ireland/irish-news/coronavirus-coalition-will-not-sanction-level-5-for-entire-country-1.43723150 -
https://twitter.com/Aiannucci/status/1313024880636497921Beibheirli_C said:The data is kept on a USB memory stick in the manager's desk at night. Totally secure
0 -
Lets see....for competencyRobD said:
Yep, but certainly not as incompetent as using columns instead of rows.Pagan2 said:
Still why they had a spreadsheet with all the tests in defies all reason. Get the files daily feed them to the database, Get your report from the database. At best the daily spreadsheets should have been an interim measure. Someone at the PHE lacks a clueRobD said:
So columns weren't the issue after all?LostPassword said:Guardian article on the Excel error.
https://www.theguardian.com/politics/2020/oct/05/how-excel-may-have-caused-loss-of-16000-covid-tests-in-england
level 1) Automating data entry directly from the labs to remove as much human error as possible from the system
level 2) Having the labs software export a csv which is then scripted straight to the database on receipt automatically
Level 3) Have someone manually upload CSV's to the database as they come in
Level 4) Use a spreadsheet to collate the CSV's for the day then export one csv to the DB
Level 5) Use an excel spreadsheet to collate all tests ever and introduce the human error of only copying the latest results from the bottom
Level 6) Use excel to collate all csvs ever, export the latest to the db but use the spreadsheet to generate your report data which is what they appear to have been upto....bonus incompetence marks for using excel without checking limitations, lose a few incompetence marks for at least using rows not columns.0 -
He's wrong because PHE use Office 365 from what I understand and interfaces I've seen. It has the million rows already. I don't think Excel has been limited to 65k rows for about 15 years.rottenborough said:https://twitter.com/EdConwaySky/status/1313125283936038914
Is this like the case of the NHS using an unsupported version of Windows OS which was hacked?1 -
From your previous posting that might seem to be a good thing from your POVBeibheirli_C said:
The GNU is necessary to help spread the blame and protect his beloved Party from the oncoming disaster that it created.ClippP said:
Why on earth are you calling for a Government of National Unity? "We have an 80 seat majority and we can do whatever we like" - remember?Big_G_NorthWales said:Boris does not have the skill set to deal with covid and I assume most conservatives are appalled at the way he has locked down the economy
It is not getting better anytime soon as covid takes hold again and brexit looking touch and go
Rishi's endorsement of Boris today is no doubt an attempt to shore him up but it is not going to work
I hope he sees the writing on the wall and decides to stand down, or the MP's send in the 40 letters to the 1922 Committee
Having said that Macron has plummeted in the polls even more than Boris and Ireland is looking at a new full lockdown
The time must be coming for a GNU and if the politicians were putting the country first they would do it now.
And at the same time do a deal (any deal) with the EU and get a six month implementation extension
The present outfit is not short of votes. It is short of rational policies and of competent politicians. The problem is that any rational policy would not be acceptable to Johnson and his gang of incompetents. And they would not be happy at being obliged to move out and maake way for some competent Lib Dem miinisters (and even some Labour ones too, if their party bosses let them).
Come on, Mr Wales. You voted for them (I think). You must take the responsibility.
The truth of the matter is that the Conservatives have been out of power since 2019. The current shower are even remotely Conservative.
1 -
Ed Conway is clueless when it comes to data. He doesn't even fully understand what the Z score he sticks on his charts mean....how did a guy with an English degree become the stats guy on Sky? Its like Mason the music teacher being the economics editor on Newsnight.RobD said:
But the row limit that caused the issue was a million, so they are using the latest version. What is he on about?rottenborough said:https://twitter.com/EdConwaySky/status/1313125283936038914
Is this like the case of the NHS using an unsupported version of Windows OS which was hacked?0 -
High School i.e. no college educationAnabobazina said:rcs1000 said:I would point out that pollsters got 2012 wrong because they assumed some reversion to the mean for African American turnout.
What is HS turnout not only doesn't mean revert, but instead becomes even greater?
What is HS?1 -
Actually prior to 1992 he was playing for England, Wales, and Scotland.tlg86 said:
Technically he was playing for England & Wales.Philip_Thompson said:
Not that surprising he'd say England, he's a legend playing for England, and spent his life involved with England, not the UK.Theuniondivvie said:Lord Beefy of Almeria speaking for the people of England..er..UK.
https://twitter.com/Stoviesplz/status/1313120602094526464?s=200 -
The media showing again they are as clueless as PHE....MaxPB said:
He's wrong because PHE use Office 365 from what I understand and interfaces I've seen. It has the million rows already. I don't think Excel has been limited to 65k rows for about 15 years.rottenborough said:https://twitter.com/EdConwaySky/status/1313125283936038914
Is this like the case of the NHS using an unsupported version of Windows OS which was hacked?0 -
The home office used to email unecrypted spreadsheets full of this sort of personal info to a company I worked for. The email wasnt encrypted either. So my guess is data security is just as tight and this spreadsheet probably gets routinely emailed aroundFrancisUrquhart said:This whack it all in a massive spreadsheet...makes you wonder how they are handling data security.
0 -
We used to do this for some clients. The CSV was uploaded into a MySQL database in a holding table where verifications and checks could be run. If there was an error, an entire upload could be removed even if it was mixed with other uploads. Once verified the data could be migrated into the main database tables.Pagan2 said:
Still why they had a spreadsheet with all the tests in defies all reason. Get the files daily feed them to the database, Get your report from the database. At best the daily spreadsheets should have been an interim measure. Someone at the PHE lacks a clueRobD said:
So columns weren't the issue after all?LostPassword said:Guardian article on the Excel error.
https://www.theguardian.com/politics/2020/oct/05/how-excel-may-have-caused-loss-of-16000-covid-tests-in-england
It was not rocket science and it worked very well. It may possibly have been "World beating"....
0 -
Fun fact : The entire accounting system of RBT Connect was run on excel
http://www.rothbiz.co.uk/2017/05/news-5571-former-rotherham-council-boss.html0 -
I wish I knew what "going back to being England" meant. I sense a real yearning there but it's impossible to turn the clock back. Is this just the political equivalent of a misty eyed old man indulging in wistful memories of his vigorous youth? Understandable if so - and poignant - but not a viable option.Theuniondivvie said:Lord Beefy of Almeria speaking for the people of England..er..UK.
https://twitter.com/Stoviesplz/status/1313120602094526464?s=200 -
Nothing surprises me, we all remember that they used to stick CDs full of uncrypted personal data in the post....Pagan2 said:
The home office used to email unecrypted spreadsheets full of this sort of personal info to a company I worked for. The email wasnt encrypted either. So my guess is data security is just as tight and this spreadsheet probably gets routinely emailed aroundFrancisUrquhart said:This whack it all in a massive spreadsheet...makes you wonder how they are handling data security.
0 -
By the way, thanks to everyone from the previous post to replies to the queries about the composition of the NYT / Siena poll and whether there are any odds on buzzwords for the VP debate. @Dura_Ace is right, "Californication" would be the obvious word for Pence to ask but given, as Dura said, his cultural references are stuck in the 50s, I think there is more chance of the Queen's Christmas Speech mentioning the word "rimming"3
-
If you were a data person would you either work in the city or tech or make bank or work for Sky (or other media) with a bunch of data illiterates and ask questions to politicians who are also as data illiterate.FrancisUrquhart said:
Ed Conway is clueless when it comes to data. He doesn't even fully understand what the Z score he sticks on his charts mean....how did a guy with an English degree become the stats guy on Sky? Its like Mason the music teacher being the economics editor on Newsnight.RobD said:
But the row limit that caused the issue was a million, so they are using the latest version. What is he on about?rottenborough said:https://twitter.com/EdConwaySky/status/1313125283936038914
Is this like the case of the NHS using an unsupported version of Windows OS which was hacked?
I can't imagine any situation that would make me want to work news media, it seems like a truly terrible industry.0 -
So, to be clear: Excel (even in modern versions) has a million-row limit.... OK, pretty naff in this day and age, but OK, given that it's not meant to be a serious software system...
But it doesn't give an error if you append a CSV file which would take you over the limit, but just silently truncates it? Really? I knew Excel was bad, but that bad?0 -
I watch the England cricket team a lot. I'm in my forties and I don't think I have ever heard them called the England & Wales cricket team.Philip_Thompson said:
Indeed but does anyone ever actually say "England and Wales"?tlg86 said:
Technically he was playing for England & Wales.Philip_Thompson said:
Not that surprising he'd say England, he's a legend playing for England, and spent his life involved with England, not the UK.Theuniondivvie said:Lord Beefy of Almeria speaking for the people of England..er..UK.
https://twitter.com/Stoviesplz/status/1313120602094526464?s=20
During his time commenting and everything else he does how many times do you think he's had to say "England", how often "England and Wales", and how often "UK"?
I'd guess "England" a literal order of magnitude more than any others. It would naturally be what he'd think to say first.
In fact, it's bonkers that Wales don't have their own team. Such a team might well be better than Scotland and Ireland.1 -
We're still waiting for our absentee ballots here in Westchester County, NY. Word is the county mailed them at the end of last week.Peter_the_Punter said:
It may be that some core supporters are switching. I think Yokes suggested as much yesterday when reporting on some polling from PPP. I wouldn't labour the point here though because it just play to the pro-Biden betting consensus and there's a risk that I personally start talking up my book.NickPalmer said:
What I think is striking is how few people who requested postal ballots have sent them in so far. We're told that America is deeply polarised and nearly everyone is sure how they'll vote. Why don't they get on with it, like postal voters in the UK generally do?Peter_the_Punter said:
SD = South Dakota? Why so high there? It's solid Republican anyway.Richard_Nabavi said:0 -
12,594 new positive cases i believe.0
-
Masters of the Universe! ☺rcs1000 said:
In my old, old life, whenever I was passed someone else's Excel file I would do a quick search for INDIRECT.Malmesbury said:
The banks got there first. I think I have spent more than half my life trying to remove Excel from the financial operations chain.....Selebian said:
It's common to refer to said hammer as the [insert name of city to be dissed, e.g. Birmingham] screwdriver - perhaps we should all start referring to Excel as the 'Whitehall Database'?eristdoof said:Caught out be the new thread problem again...
If a tradesman comes to your house to repair your fridge and has nothing but a hammer with him, it is obvious to everyone, even Boris, that he is unfit to be a fridge repairman, professional or amateur.
If a data scientist tries to compile the official government SARS-COV2 data and has nothing but Excel, it is obvious ....
Thank god we managed to kill Access. That was a stake-through-the-heart-with-garlix-and-silver-hollowpoints-just-in-case thing.....
If it was in there, you could be 99.9% sure than the spreadsheet would contain major errors.
(True story time. Back in the early 1990s, the most profitable desk at Goldman Sachs London office was Japanese Warrants trading. Every year, it raked up ridiculous, insane profits, despite Japanese warrants only being a pretty small market. Eventually someone worked out why. There was an Excel spreadsheet that calculated how much they needed to hedge their positions. That is, if Goldman Sachs owned lots of Japanese equity warrants, they needed to sell equity futures to balance their risk. And if they were short warrants, then they had to be long the market. Due to an error in the spreadsheet, it was always telling the traders they needed to have massive short positions in the Japanese equity market. As Nikkei was in a serious bear market, this error resulted in the desk making enormous profits.)0 -
Well maybe travel writer that does seem to be being paid to take lots of holidaysMaxPB said:
If you were a data person would you either work in the city or tech or make bank or work for Sky (or other media) with a bunch of data illiterates and ask questions to politicians who are also as data illiterate.FrancisUrquhart said:
Ed Conway is clueless when it comes to data. He doesn't even fully understand what the Z score he sticks on his charts mean....how did a guy with an English degree become the stats guy on Sky? Its like Mason the music teacher being the economics editor on Newsnight.RobD said:
But the row limit that caused the issue was a million, so they are using the latest version. What is he on about?rottenborough said:https://twitter.com/EdConwaySky/status/1313125283936038914
Is this like the case of the NHS using an unsupported version of Windows OS which was hacked?
I can't imagine any situation that would make me want to work news media, it seems like a truly terrible industry.0 -
Unfortunately, you are correct. It is not something that I thought I would ever say. Myself, from 10 years ago, would never have believed it.Floater said:
From your previous posting that might seem to be a good thing from your POVBeibheirli_C said:
The GNU is necessary to help spread the blame and protect his beloved Party from the oncoming disaster that it created.ClippP said:
Why on earth are you calling for a Government of National Unity? "We have an 80 seat majority and we can do whatever we like" - remember?Big_G_NorthWales said:Boris does not have the skill set to deal with covid and I assume most conservatives are appalled at the way he has locked down the economy
It is not getting better anytime soon as covid takes hold again and brexit looking touch and go
Rishi's endorsement of Boris today is no doubt an attempt to shore him up but it is not going to work
I hope he sees the writing on the wall and decides to stand down, or the MP's send in the 40 letters to the 1922 Committee
Having said that Macron has plummeted in the polls even more than Boris and Ireland is looking at a new full lockdown
The time must be coming for a GNU and if the politicians were putting the country first they would do it now.
And at the same time do a deal (any deal) with the EU and get a six month implementation extension
The present outfit is not short of votes. It is short of rational policies and of competent politicians. The problem is that any rational policy would not be acceptable to Johnson and his gang of incompetents. And they would not be happy at being obliged to move out and maake way for some competent Lib Dem miinisters (and even some Labour ones too, if their party bosses let them).
Come on, Mr Wales. You voted for them (I think). You must take the responsibility.
The truth of the matter is that the Conservatives have been out of power since 2019. The current shower are even remotely Conservative.0 -
Ooo yes please. The Rust Belt AND Sun Belt path.rcs1000 said:
Yes, I'm considering writing one of those too...Alistair said:
There's a companion "why did we get it wrong" piece to go with the one from the weekend. The how did we miss Biden sweeping to one of the largest victories ever. Taking the entire west and east coast as well as TexasPeter_the_Punter said:
Maybe the locals have heard Trump's planning to have his ugly mug carved into Mount Rushmore and are piling in to make sure it doesn't happen?Richard_Nabavi said:
Dunno why it's high there, but it's a tiny electorate in a big place, so maybe it's just convenience.Peter_the_Punter said:
SD = South Dakota? Why so high there? It's solid Republican anyway.Richard_Nabavi said:0 -
It should give you an error, "file not loaded completely", or something similar.Richard_Nabavi said:So, to be clear: Excel (even in modern versions) has a million-row limit.... OK, pretty naff in this day and age, but OK, given that it's not meant to be a serious software system...
But it doesn't give an error if you append a CSV file which would take you over the limit, but just silently truncates it? Really? I knew Excel was bad, but that bad?0 -
And in a mixed-race team IIRC.TheScreamingEagles said:
Actually prior to 1992 he was playing for England, Wales, and Scotland.tlg86 said:
Technically he was playing for England & Wales.Philip_Thompson said:
Not that surprising he'd say England, he's a legend playing for England, and spent his life involved with England, not the UK.Theuniondivvie said:Lord Beefy of Almeria speaking for the people of England..er..UK.
https://twitter.com/Stoviesplz/status/1313120602094526464?s=200 -
If its all automated then entirely possible.Richard_Nabavi said:So, to be clear: Excel (even in modern versions) has a million-row limit.... OK, pretty naff in this day and age, but OK, given that it's not meant to be a serious software system...
But it doesn't give an error if you append a CSV file which would take you over the limit, but just silently truncates it? Really? I knew Excel was bad, but that bad?
Years ago I built a macro in Excel to analyse data from CSVs and I hit the 65k limit. From memory it did indeed continue to work but with the data truncated rather than bugging out. I realised what had happened when the results were wrong.0 -
-
0
-
I'll settle for getting rid of the bastard. Some things are more important even than my bank balance. As it happens, I think Biden just about has it so I can start daydreaming about scenarios involving a Democrat win in Taxas and Alaska but if you offered 270 ECVs right now I'd take it.kinabalu said:
It's my 30% expectation. I'll be a bit disappointed with a 'solid but not spectacular' outcome.Peter_the_Punter said:
I haven't missed it. It's distinctly possible. There's not a lot of point discussing it though because the consequences are so obvious (one of these being I become a good deal better off.)Alistair said:
There's a companion "why did we get it wrong" piece to go with the one from the weekend. The how did we miss Biden sweeping to one of the largest victories ever. Taking the entire west and east coast as well as TexasPeter_the_Punter said:
Maybe the locals have heard Trump's planning to have his ugly mug carved into Mount Rushmore and are piling in to make sure it doesn't happen?Richard_Nabavi said:
Dunno why it's high there, but it's a tiny electorate in a big place, so maybe it's just convenience.Peter_the_Punter said:
SD = South Dakota? Why so high there? It's solid Republican anyway.Richard_Nabavi said:1 -
Only if the people are still around and we can agree on a close price. Otherwise I get exposure in different places and it's a bit messy.isam said:
You can still do that if you've had the original bet on here cant you?kinabalu said:
An option but it's a long timeframe and with Betfair I can close to flat when it's down to 1.3 next Spring.isam said:
Or do it privately on here and save the comm/tying up the moneykinabalu said:On topic and betting post -
I think Johnson is an absurdity as PM but I also consider the view he is likely to be gone soon to be wildly off beam. Just 10 months ago he won a general election by 80 seats. The best majority for the Conservatives since 1980s Thatcher in her pomp. He did so from a position 6 months prior on assuming the leadership where the party looked to be - was - in a hole. It was a personal triumph. A complete vindication of the ghastly man and his ghastly methods.
He will not be stepping down voluntarily. People in top jobs do not relinquish power and status except for health reasons and there is no reason to expect that here. He does not have long Covid. Neither will he be forced out by his party for the foreseeable future. The earliest it could happen is 2023 and only then if (i) he has become a clear electoral liability and (ii) there is a replacement guaranteed to be more popular.
So, there is a Betfair market, Boris Johnson exit date, and "July 2022 or later" can be backed at 1.8. I think that is outstanding value. It should be more like 1.33.
If any of the punters here take the opposite view and think it should be longer and the value is in the other direction - the lay - I have money there at 1.85 looking for a match. £50 for starters but with appetite for more. Just hit me.0 -
Hmm, from memory it does simply truncate the file.RobD said:
It should give you an error, "file not loaded completely", or something similar.Richard_Nabavi said:So, to be clear: Excel (even in modern versions) has a million-row limit.... OK, pretty naff in this day and age, but OK, given that it's not meant to be a serious software system...
But it doesn't give an error if you append a CSV file which would take you over the limit, but just silently truncates it? Really? I knew Excel was bad, but that bad?0 -
It has just struck me that those who think the virus lockdown rules are too strict are similar, very similar, to those who think immigration problems are exaggerated.FrancisUrquhart said:12,594 new positive cases i believe.
They say the numbers wont be as high as predicted, then, when they are, or almost are, they say the number doesn't really matter because it's not that bad anyway.
Noteworthy, I think, because it is not the same people doing it0 -
-
Hang on, I've got an open buy at 284...Peter_the_Punter said:... As it happens, I think Biden just about has it so I can start daydreaming about scenarios involving a Democrat win in Taxas and Alaska but if you offered 270 ECVs right now I'd take it.
1 -
Just tested it and got a dialog up with an exclamation and the message file not loaded completely which you have to ok awayRichard_Nabavi said:So, to be clear: Excel (even in modern versions) has a million-row limit.... OK, pretty naff in this day and age, but OK, given that it's not meant to be a serious software system...
But it doesn't give an error if you append a CSV file which would take you over the limit, but just silently truncates it? Really? I knew Excel was bad, but that bad?0 -
At least on the Mac you get a warning you are being stupid (2million csv import):MaxPB said:
Hmm, from memory it does simply truncate the file.RobD said:
It should give you an error, "file not loaded completely", or something similar.Richard_Nabavi said:So, to be clear: Excel (even in modern versions) has a million-row limit.... OK, pretty naff in this day and age, but OK, given that it's not meant to be a serious software system...
But it doesn't give an error if you append a CSV file which would take you over the limit, but just silently truncates it? Really? I knew Excel was bad, but that bad?
https://i.imgur.com/ucq6g0R.png0 -
It's not necessarily the same people no.isam said:
It has just struck me that those who think the virus lockdown rules are too strict are similar, very similar, to those who think immigration problems are exaggerated.FrancisUrquhart said:12,594 new positive cases i believe.
They say the numbers wont be as high as predicted, then, when they are, or almost are, they say the number doesn't really matter because it's not that bad anyway.
Noteworthy, I think, because it is not the same people doing it
But I don't believe the cleavages are entirely that precise.0 -
In that case the explanation in this Guardian article doesn't make sense (unless some half-wit ignored the error):Pagan2 said:
Just tested it and got a dialog up with an exclamation and the message file not loaded completely which you have to ok awayRichard_Nabavi said:So, to be clear: Excel (even in modern versions) has a million-row limit.... OK, pretty naff in this day and age, but OK, given that it's not meant to be a serious software system...
But it doesn't give an error if you append a CSV file which would take you over the limit, but just silently truncates it? Really? I knew Excel was bad, but that bad?
https://www.theguardian.com/politics/2020/oct/05/how-excel-may-have-caused-loss-of-16000-covid-tests-in-england
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.0 -
Opening .csv files in Excel is possible, but I would say under no circumstances should you do it. (If you want to take a peek on a Windows machine use Notepad++.) There are lots of bad things that can happen if you use Excel.Richard_Nabavi said:So, to be clear: Excel (even in modern versions) has a million-row limit.... OK, pretty naff in this day and age, but OK, given that it's not meant to be a serious software system...
But it doesn't give an error if you append a CSV file which would take you over the limit, but just silently truncates it? Really? I knew Excel was bad, but that bad?0 -
Yes it does.RobD said:
It should give you an error, "file not loaded completely", or something similar.Richard_Nabavi said:So, to be clear: Excel (even in modern versions) has a million-row limit.... OK, pretty naff in this day and age, but OK, given that it's not meant to be a serious software system...
But it doesn't give an error if you append a CSV file which would take you over the limit, but just silently truncates it? Really? I knew Excel was bad, but that bad?0 -
Yeah I meant exposure in different places. Not that bad really, the same as having a bet w a bookie and laying it off later on BF. Your prerogative obvskinabalu said:
Only if the people are still around and we can agree on a close price. Otherwise I get exposure in different places and it's a bit messy.isam said:
You can still do that if you've had the original bet on here cant you?kinabalu said:
An option but it's a long timeframe and with Betfair I can close to flat when it's down to 1.3 next Spring.isam said:
Or do it privately on here and save the comm/tying up the moneykinabalu said:On topic and betting post -
I think Johnson is an absurdity as PM but I also consider the view he is likely to be gone soon to be wildly off beam. Just 10 months ago he won a general election by 80 seats. The best majority for the Conservatives since 1980s Thatcher in her pomp. He did so from a position 6 months prior on assuming the leadership where the party looked to be - was - in a hole. It was a personal triumph. A complete vindication of the ghastly man and his ghastly methods.
He will not be stepping down voluntarily. People in top jobs do not relinquish power and status except for health reasons and there is no reason to expect that here. He does not have long Covid. Neither will he be forced out by his party for the foreseeable future. The earliest it could happen is 2023 and only then if (i) he has become a clear electoral liability and (ii) there is a replacement guaranteed to be more popular.
So, there is a Betfair market, Boris Johnson exit date, and "July 2022 or later" can be backed at 1.8. I think that is outstanding value. It should be more like 1.33.
If any of the punters here take the opposite view and think it should be longer and the value is in the other direction - the lay - I have money there at 1.85 looking for a match. £50 for starters but with appetite for more. Just hit me.1 -
Good lord.FrancisUrquhart said:0 -
Dross in, dross out.
The Covid Stats site was updated at 4.00 pm.0 -
Tighter by another 0.6%Scott_xP said:0 -
Atom is better than Notepad++....LostPassword said:
Opening .csv files in Excel is possible, but I would say under no circumstances should you do it. (If you want to take a peek on a Windows machine use Notepad++.) There are lots of bad things that can happen if you use Excel.Richard_Nabavi said:So, to be clear: Excel (even in modern versions) has a million-row limit.... OK, pretty naff in this day and age, but OK, given that it's not meant to be a serious software system...
But it doesn't give an error if you append a CSV file which would take you over the limit, but just silently truncates it? Really? I knew Excel was bad, but that bad?2 -
I looked at the cases by specimen date chart. It looks like there's still some cases missing. Unless the jump between the 27th and 28th was due to some university term related thing.FrancisUrquhart said:12,594 new positive cases i believe.
0 -
Not sure what that has to do with immigration into the UK, but if you're saying that Beefy is unable to distinguish between England and the UK, I agree.Philip_Thompson said:
Not that surprising he'd say England, he's a legend playing for England, and spent his life involved with England, not the UK.Theuniondivvie said:Lord Beefy of Almeria speaking for the people of England..er..UK.
https://twitter.com/Stoviesplz/status/1313120602094526464?s=200 -
65K or 1 million is not the issue. The issue is that Excel was the wrong tool for the job. This data should have been supplied directly into a database where some form of integrity check could have been performed.MaxPB said:
He's wrong because PHE use Office 365 from what I understand and interfaces I've seen. It has the million rows already. I don't think Excel has been limited to 65k rows for about 15 years.rottenborough said:twitter.com/EdConwaySky/status/1313125283936038914
Is this like the case of the NHS using an unsupported version of Windows OS which was hacked?
Even something as simple as verifying the number of records inserted would be a help.0 -
Some underpaid intern just hitting enter until the data goes into Excel? I've done that before.Richard_Nabavi said:
In that case the explanation in this Guardian article doesn't make sense (unless some half-wit ignored the error):Pagan2 said:
Just tested it and got a dialog up with an exclamation and the message file not loaded completely which you have to ok awayRichard_Nabavi said:So, to be clear: Excel (even in modern versions) has a million-row limit.... OK, pretty naff in this day and age, but OK, given that it's not meant to be a serious software system...
But it doesn't give an error if you append a CSV file which would take you over the limit, but just silently truncates it? Really? I knew Excel was bad, but that bad?
https://www.theguardian.com/politics/2020/oct/05/how-excel-may-have-caused-loss-of-16000-covid-tests-in-england
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.2 -
I like Sublime text as well, it's good for CSV editing.FrancisUrquhart said:
Atom is better than Notepad++....LostPassword said:
Opening .csv files in Excel is possible, but I would say under no circumstances should you do it. (If you want to take a peek on a Windows machine use Notepad++.) There are lots of bad things that can happen if you use Excel.Richard_Nabavi said:So, to be clear: Excel (even in modern versions) has a million-row limit.... OK, pretty naff in this day and age, but OK, given that it's not meant to be a serious software system...
But it doesn't give an error if you append a CSV file which would take you over the limit, but just silently truncates it? Really? I knew Excel was bad, but that bad?0 -
-
You'll get no argument from me on that. I can understand preparing CSVs for upload in Excel. Using it as an analysis tool or as a faux database is not a good idea. Not when databases exist.Beibheirli_C said:
65K or 1 million is not the issue. The issue is that Excel was the wrong tool for the job. This data should have been supplied directly into a database where some form of integrity check could have been performed.MaxPB said:
He's wrong because PHE use Office 365 from what I understand and interfaces I've seen. It has the million rows already. I don't think Excel has been limited to 65k rows for about 15 years.rottenborough said:twitter.com/EdConwaySky/status/1313125283936038914
Is this like the case of the NHS using an unsupported version of Windows OS which was hacked?
Even something as simple as verifying the number of records inserted would be a help.1 -
I have always been put off by the $70-80 cost. Seems very steep for a text editor.MaxPB said:
I like Sublime text as well, it's good for CSV editing.FrancisUrquhart said:
Atom is better than Notepad++....LostPassword said:
Opening .csv files in Excel is possible, but I would say under no circumstances should you do it. (If you want to take a peek on a Windows machine use Notepad++.) There are lots of bad things that can happen if you use Excel.Richard_Nabavi said:So, to be clear: Excel (even in modern versions) has a million-row limit.... OK, pretty naff in this day and age, but OK, given that it's not meant to be a serious software system...
But it doesn't give an error if you append a CSV file which would take you over the limit, but just silently truncates it? Really? I knew Excel was bad, but that bad?0 -
Or the load was part of a macro with warnings turned off (Application.DisplayAlerts = False)Richard_Nabavi said:
In that case the explanation in this Guardian article doesn't make sense (unless some half-wit ignored the error):Pagan2 said:
Just tested it and got a dialog up with an exclamation and the message file not loaded completely which you have to ok awayRichard_Nabavi said:So, to be clear: Excel (even in modern versions) has a million-row limit.... OK, pretty naff in this day and age, but OK, given that it's not meant to be a serious software system...
But it doesn't give an error if you append a CSV file which would take you over the limit, but just silently truncates it? Really? I knew Excel was bad, but that bad?
https://www.theguardian.com/politics/2020/oct/05/how-excel-may-have-caused-loss-of-16000-covid-tests-in-england
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.0 -
Nick Leeson didn't use something like that, did he?kinabalu said:
Masters of the Universe! ☺rcs1000 said:
In my old, old life, whenever I was passed someone else's Excel file I would do a quick search for INDIRECT.Malmesbury said:
The banks got there first. I think I have spent more than half my life trying to remove Excel from the financial operations chain.....Selebian said:
It's common to refer to said hammer as the [insert name of city to be dissed, e.g. Birmingham] screwdriver - perhaps we should all start referring to Excel as the 'Whitehall Database'?eristdoof said:Caught out be the new thread problem again...
If a tradesman comes to your house to repair your fridge and has nothing but a hammer with him, it is obvious to everyone, even Boris, that he is unfit to be a fridge repairman, professional or amateur.
If a data scientist tries to compile the official government SARS-COV2 data and has nothing but Excel, it is obvious ....
Thank god we managed to kill Access. That was a stake-through-the-heart-with-garlix-and-silver-hollowpoints-just-in-case thing.....
If it was in there, you could be 99.9% sure than the spreadsheet would contain major errors.
(True story time. Back in the early 1990s, the most profitable desk at Goldman Sachs London office was Japanese Warrants trading. Every year, it raked up ridiculous, insane profits, despite Japanese warrants only being a pretty small market. Eventually someone worked out why. There was an Excel spreadsheet that calculated how much they needed to hedge their positions. That is, if Goldman Sachs owned lots of Japanese equity warrants, they needed to sell equity futures to balance their risk. And if they were short warrants, then they had to be long the market. Due to an error in the spreadsheet, it was always telling the traders they needed to have massive short positions in the Japanese equity market. As Nikkei was in a serious bear market, this error resulted in the desk making enormous profits.)0 -
They arent the same sort of thing thoughFrancisUrquhart said:
Atom is better than Notepad++....LostPassword said:
Opening .csv files in Excel is possible, but I would say under no circumstances should you do it. (If you want to take a peek on a Windows machine use Notepad++.) There are lots of bad things that can happen if you use Excel.Richard_Nabavi said:So, to be clear: Excel (even in modern versions) has a million-row limit.... OK, pretty naff in this day and age, but OK, given that it's not meant to be a serious software system...
But it doesn't give an error if you append a CSV file which would take you over the limit, but just silently truncates it? Really? I knew Excel was bad, but that bad?
Notepad++ is just a text editor and yes I know you can add on things for syntax colouring
Atom is trying to be a dev environment0 -
True. It's like when people conveniently forget that it's the Conservative and Unionist Party when it doesn't suit their argument to recall it.Philip_Thompson said:
Indeed but does anyone ever actually say "England and Wales"?tlg86 said:
Technically he was playing for England & Wales.Philip_Thompson said:
Not that surprising he'd say England, he's a legend playing for England, and spent his life involved with England, not the UK.Theuniondivvie said:Lord Beefy of Almeria speaking for the people of England..er..UK.
https://twitter.com/Stoviesplz/status/1313120602094526464?s=20
During his time commenting and everything else he does how many times do you think he's had to say "England", how often "England and Wales", and how often "UK"?
I'd guess "England" a literal order of magnitude more than any others. It would naturally be what he'd think to say first.1 -
-
Maybe getting someone with IT training and experience involved rather than a bunch of £2k per day McKinsey grads would have helped.Beibheirli_C said:
65K or 1 million is not the issue. The issue is that Excel was the wrong tool for the job. This data should have been supplied directly into a database where some form of integrity check could have been performed.MaxPB said:
He's wrong because PHE use Office 365 from what I understand and interfaces I've seen. It has the million rows already. I don't think Excel has been limited to 65k rows for about 15 years.rottenborough said:twitter.com/EdConwaySky/status/1313125283936038914
Is this like the case of the NHS using an unsupported version of Windows OS which was hacked?
Even something as simple as verifying the number of records inserted would be a help.1 -
I am not an expert on polling methodology but there seem some unusual findings in ones, particularly at the state level. For example, looking at the CBS / YouGov breakdowns:Alistair said:
Then the (high quality) polls will be spot on.rcs1000 said:I would point out that pollsters got 2012 wrong because they assumed some reversion to the mean for African American turnout.
What is HS turnout not only doesn't mean revert, but instead becomes even greater?
https://drive.google.com/file/d/1hSdIHlv2MgUGngDTUCG4UK2D_11Asbfk/view
It polls Registered Voters, 89% of say they will Definitely Vote. That doesn't sound right, especially when you look at the NYT poll for PA which only has likely voters which gives a figure of 77% (which is actually "Almost Certain")0
