The British national track and trace programme for Covid 19 is failing big time. They are using Excel spreadsheets to support their database. The most junior computer programmer knows that you do not use a spreadsheet program to support a national database which in time will contain millions of records. When I used to run projects I banned the use of spreadsheets. People are tempted to use them for everything including project plans. You can fill in the boxes with text and colour the boxes in: they look pretty but most of the time they contain useless information. Spreadsheets are perfect for accountants, bookkeepers and scientists analysing figures. Only my project officer, who prepared the budgets, was allowed to use a spreadsheet. If you need to use boxes in your reports then you can use Word.
If the Test and Trace system continues to abuse the Excel spreadsheet program then the project will continue to fail.
In 1962 we had an outbreak of Smallpox in Great Britain; there was a vaccine but it was in very short supply. Local public health authorities held the epidemic at bay by using an effective test and trace system using pen and paper - there were no PC's or Computer Tablets and Smart 'phones available.The contacts of those who caught the disease were traced and isolated in hospitals and all by manual methods. They had no choice for in the 1962 epidemic there was a 30% death rate. They saved thousands of people with simple measures until vaccine supplies came up to speed. Local public health did not need a £10 billion system, which has failed, they used pen and paper and boots on the ground. We could learn something from those days but we are probably too decadent and arrogant.
Until a vaccine comes along washing your hands and wearing a mask will not provide adequate protection, the Covid virus will still spread - this is obvious. The only measures that will keep the virus at bay is for everyone to keep their distance and to isolate the infected and their contacts. We need a test and trace system that works and urgently.
We need to control this virus and get our economy working again. We have no choice; get the pencil and paper out and get the boots on the ground. Stop the pretence that anything else will work well enough to stop the virus in its tracks.