15,841 positive cases missed

Discussion in 'Bulletin Board' started by pontyender, Oct 4, 2020.

  1. Jimmy viz

    Jimmy viz Well-Known Member

    Joined:
    Aug 30, 2012
    Messages:
    29,686
    Likes Received:
    19,159
    Trophy Points:
    113
    Occupation:
    Ballet Dancer
    Location:
    Hiding under the bed
    Style:
    Barnsley (full width)
    did we nationalise Serco?
     
    Redhelen likes this.
  2. JamDrop

    JamDrop Well-Known Member

    Joined:
    Mar 30, 2013
    Messages:
    18,594
    Likes Received:
    19,465
    Trophy Points:
    113
    Location:
    Leeds
    Style:
    Barnsley (full width)
    Unconfirmed rumours (from the Daily Mail so take with the huge barrel of salt it deserves) that the ‘world beating’ software that is being used is Excel and the cases were missed because the file size got too big and couldn’t update. Excel. Excel is not a database and shouldn’t be anywhere near this.
     
  3. Loa

    Load Bearing Pillar Well-Known Member

    Joined:
    Jul 18, 2005
    Messages:
    2,317
    Likes Received:
    1,554
    Trophy Points:
    113
    Location:
    The West Stand, second along from the Ponty end
    Home Page:
    Style:
    Barnsley (full width)
    And anyone else that has had fun over the past few months.

    I was in a pub over the weekend and i saw someone being threatened with being thrown out for talking to someone on a different table - what a miserable joyless world this has created.
     
    Last edited: Oct 5, 2020
  4. Dav

    DavidCurriesMullet Well-Known Member

    Joined:
    Aug 9, 2017
    Messages:
    3,345
    Likes Received:
    6,144
    Trophy Points:
    113
    Gender:
    Male
    Location:
    Hemingfield
    Style:
    Barnsley (full width)
    Not just excel but an out dated version due to government I.T being so basic. I don't know for sure but I'm guessing it was from Office 2010, just from experience.

    What an absolute joke, we all know excel shouldn't be used for such operations but the security of the data is also a HUGE issue.

    I thought Boris' f*ck buddy Jennifer Accuri had sorted him out with I.T? Or was the money given to her for other services?
     
  5. dreamboy3000

    dreamboy3000 Well-Known Member

    Joined:
    Oct 20, 2005
    Messages:
    59,174
    Likes Received:
    25,890
    Trophy Points:
    113
    Location:
    DB3K Towers
    Style:
    Barnsley (full width)
    All political parties are useless. I don't have faith in any of them.
     
    BFC Dave likes this.
  6. rin

    ringo Well-Known Member

    Joined:
    May 30, 2018
    Messages:
    2,286
    Likes Received:
    1,174
    Trophy Points:
    113
    Gender:
    Male
    Style:
    Barnsley (full width)
    NHS England not the government
     
  7. Tarntyke

    Tarntyke Well-Known Member

    Joined:
    Jul 29, 2005
    Messages:
    14,888
    Likes Received:
    13,100
    Trophy Points:
    113
    Location:
    Stairfoot, b4 famous rahnderbart
    Style:
    Barnsley (full width)
    Another Tory apologists line, ‘They’re all the same’
     
    Redhelen and TitusMagee like this.
  8. DEETEE

    DEETEE Well-Known Member

    Joined:
    Aug 8, 2011
    Messages:
    10,230
    Likes Received:
    2,188
    Trophy Points:
    113
    Style:
    Barnsley (full width)
    You can blame Serco all you want. And although they are not without fault the end user should be bearing the largest brunt of this.

    Regardless of the format used to send the data it would appear whichever set of bellends received it didnt undertake any basic checks.

    Checking for data completeness is a basic skill that would have picked this **** up at the time especially as it seems at least one file sent was blank!

    I would love to see who decided that XL was the way to go as well. Who signed off on that. Handycock? PHE. NHS england. All three?

    Given its cost 12 BILLION so far I assume that between the various bodies of incompetence they could have found a couple of half decent SQL or Python developers to have built something that doesnt rely on a spreadsheet being sent via Sftp.

    From testing everything that moves for Covid right the way through to the Stasi walking the town centre fining people for being in a group more than six the entire thing is a joke.

    Its all planned out on whim. Without any account or scrutiny.

    You only have to see the regional interviews from Bojo and Handcock getting his arse handed to him by MPs from all parties regarding the curfew and mask in pubs ********.

    And **** all will change until this 'vaccine' turns up...
     
    BFC Dave likes this.
  9. Redstone

    Redstone Well-Known Member

    Joined:
    Sep 10, 2005
    Messages:
    16,082
    Likes Received:
    11,523
    Trophy Points:
    113
    Style:
    Barnsley Dark
    It's just depressing as hell isn't it. Went to meadowhall briefly on Saturday and I won't be going again.
     
    BFC Dave likes this.
  10. Farnham_Red

    Farnham_Red Administrator Staff Member Admin

    Joined:
    Jul 18, 2005
    Messages:
    34,391
    Likes Received:
    23,828
    Trophy Points:
    113
    Location:
    Farnham
    Style:
    Barnsley
    I wouldnt be too shocked if it was still Excel 97 on windows XP - its unlikely to be a recent excel if its the data was too big as that can hold a lot of data, As everyone says above its not the right software
    Also its the Daily Heil so its probably not true - though with this shower its just possible it might be
    where is the error checking - it shouldnt be possible for this sort of error to occur without setting off bells and whistles
     
  11. Shy Talk

    Shy Talk Well-Known Member

    Joined:
    Jul 30, 2005
    Messages:
    8,054
    Likes Received:
    4,882
    Trophy Points:
    113
    Location:
    Tarn
    Home Page:
    Style:
    Barnsley (full width)
    Here we go again. But Corbyn...
     
    Redhelen likes this.
  12. Redstone

    Redstone Well-Known Member

    Joined:
    Sep 10, 2005
    Messages:
    16,082
    Likes Received:
    11,523
    Trophy Points:
    113
    Style:
    Barnsley Dark
    Personally I think sitting and looking at numbers to this extent does little good. Taking a few points and extrapolating a trend.
    I also think scientists have over estimated the restrictions ability in the real world to influence the transmission of covid - all that has happened are more rules which are causing now increasing harm with little benefit.
    We see now places that have had local lockdowns in place for weeks and weeks with cases still rising.
    If cases go down, it's the government's bold action. If they don't, it's our fault for not complying and the restrictions weren't severe enough.

    Government can't lose, but meanwhile the virus just does its thing.
     
    BFC Dave likes this.
  13. Jimmy viz

    Jimmy viz Well-Known Member

    Joined:
    Aug 30, 2012
    Messages:
    29,686
    Likes Received:
    19,159
    Trophy Points:
    113
    Occupation:
    Ballet Dancer
    Location:
    Hiding under the bed
    Style:
    Barnsley (full width)
    I blame Serco because it is Serco track and trace and has nothing to do with the NHS. It won’t even allow you to enter NHS tests into the app. It’s what you get when you employ your mate Dildo Harding to do things as a backhander trather than running a proper procurement exercise.
     
    Marlon, BFC Dave and JLWBigLil like this.
  14. Dan

    DannyWilsonLovechild Well-Known Member

    Joined:
    Aug 8, 2011
    Messages:
    15,574
    Likes Received:
    19,612
    Trophy Points:
    113
    Style:
    Barnsley
    See, no good comes from spreadsheets!
     
  15. Dan

    DannyWilsonLovechild Well-Known Member

    Joined:
    Aug 8, 2011
    Messages:
    15,574
    Likes Received:
    19,612
    Trophy Points:
    113
    Style:
    Barnsley
    Did you mean to add an L in her first name..... or is predictive text getting carried away again? ;-)
     
  16. Gimson&theBarnsleys

    Gimson&theBarnsleys Well-Known Member

    Joined:
    Dec 9, 2005
    Messages:
    7,469
    Likes Received:
    6,116
    Trophy Points:
    113
    Style:
    Barnsley (full width)
    And we've paid £billions up front for millions of vaccines that only those over 50 can have.
     
    DavidCurriesMullet likes this.
  17. Jimmy viz

    Jimmy viz Well-Known Member

    Joined:
    Aug 30, 2012
    Messages:
    29,686
    Likes Received:
    19,159
    Trophy Points:
    113
    Occupation:
    Ballet Dancer
    Location:
    Hiding under the bed
    Style:
    Barnsley (full width)
    definitely on purpose as in as much use as a marzipan dildo (Harding)
     
  18. Wat

    Watcher_Of_The_Skies Well-Known Member

    Joined:
    Aug 12, 2011
    Messages:
    9,302
    Likes Received:
    5,205
    Trophy Points:
    113
    Location:
    Leeds
    Style:
    Barnsley
    So it looks like they were using Excel to do a databases job. Not only that but an old version which limits the number of rows you can use. Once the 65k or so were reached it was cutting them off.

    However Excel does warn you if this happens, so either someone ignored it or they were running a macro to automatically do update incoming files, which means nobody was checking the data as all it would have taken would be for someone to search the last entry in the updated file to realise that it, and the 12k above it were missing.

    I have regularly told people at my work we shouldn't be using Excel as it wasn't built to do what's been asked of it, but the thought of doing that for millions of rows of vital health data boggles the mind.

    Their work around is apparently to split the file up into several sheets worth of data. It would be funny if it weren't so tragic.

    Another case of underfunding I expect. Might even be they used old excel because legacy systems don't support the new one....

    On the upside at least my day with Excel wasn't as bad as someone else's. The horror when discovering that must have an open window away from ending it all.
     
    Last edited: Oct 5, 2020
    DavidCurriesMullet likes this.
  19. Dav

    DavidCurriesMullet Well-Known Member

    Joined:
    Aug 9, 2017
    Messages:
    3,345
    Likes Received:
    6,144
    Trophy Points:
    113
    Gender:
    Male
    Location:
    Hemingfield
    Style:
    Barnsley (full width)
    You've hit the nail on the head, the civil service for over a decade had its I.T projects cut or outsourced to such a degree that new systems are only delivered in part due to costs. Systems are then either obsolete on delivery or not fit for purpose. Excel courses are handed out like they're the silver bullet. Excel superusers are lauded over. You'll see many job specifications which state applicants must have a good working knowledge of excel. The civil service is built on spreadsheets, if a task needs doing it needs its own spreadsheet. I sh*t you not!
     
    Watcher_Of_The_Skies likes this.
  20. Burgundy Red

    Burgundy Red Well-Known Member

    Joined:
    Nov 27, 2008
    Messages:
    5,009
    Likes Received:
    2,797
    Trophy Points:
    113
    Occupation:
    Ninja (retired)
    Location:
    Somewhere between Heaven and Woolworths
    Style:
    Barnsley
    It's bringing back awful memories from my own career of what The Meaning of Liff calls an Ely:

    Ely (n.)
    The first, tiniest inkling you get that something, somewhere, has gone terribly wrong.

    Like when you do something in the dev or test environment and then it dawns on you that you were just looking at something in production a few minutes ago ...
     

Share This Page