Showing posts with label virus. Show all posts
Showing posts with label virus. Show all posts

Tuesday, 6 October 2020

Serco Don’t Lose That Number!

If you do the Twitter thing, follow me at @HousingITguy
or LinkedIn here https://uk.linkedin.com/in/tonysmiththathousingitguy


Earlier this week, a few thousand people and probably a dozen at least of my contacts, probably grinned with a knowing smile. 

Of course I am writing about the UK’s national Serco Test and Trace spaff-up, relying on Excel spreadsheets, to collate and process Covid-19 tests. 

If I had £500 for every time I had told people off for calling 'info in spreadsheets', a database, I could have retired by now.

The situation could be laughable, if it were not so important and crucial.

Now, if anyone wants to spread blame around, I would personally start with Microsoft. Why So, you might ask🤔

The original Lotus 1-2-3, as anyone who broke their teeth on it during the 1980’s may remember, only had a maximum of 8,192 rows (and 256 columns). Now if it had stayed at that size, a very limited number of fools would have tried to store lots of data in it and sensibly selected a proper database to do the job. But no. As Reeve’s and Mortimer might have said, “They couldn’t let it lie” -  .

Microsoft’s Excel gave us 65,536 rows, immediately giving the illusion of it being a ‘database’, not a useful summary manipulation and presentation tool, which is what a spreadsheet does best. I have been involved in so many projects where users, managers and directors in some cases, have been firmly wedded to spreadsheets, needing to migrate to proper solutions, with protection, data control and robust audit. I have often proposed amnesty, after replacement system go-live, where spreadsheets can be dropped.

My proposal is that if the fearsome and opposing communities in Northern Ireland, could put their weapons beyond use, we should have a spreadsheet version of the Good Friday Agreement, where users do the same and promise never to return to them again. For some its starting to catch on thankfully.


For sure, Excel can be a good place to start for an initial prototype, but no one should continue to try to run a whole enterprise on it. Serco are not alone. Eight years ago or so, I worked with a big organisation, dealing with £8m of monthly transactions on Excel with its one million row and memory limit creaking & ready to break. Fifteen years earlier, with a turnover a 50th of that, spreadsheets just kind of worked. For that organisation it took about 4 months to procure and 12 to implement, a proper finance, feeder and self-service solution and they never looked back.

Serco however have apparently been paid £12b of taxpayers dosh and should have been able to build their own database quite quickly with 20 or so of the right ICT staff, none of which would have probably stuck with Excel, if there was any capability of a millions of test a day Moonshot a-coming.

In my time manipulating data, I have witnessed many things Excel does trying to be clever, without telling you. Truncating to 65,536 is common where old solutions can only use XLS format to export. No doubt you might have experienced that too. The type and length of unique ID’s seen in the SocialHousing sector, is ripe for Excel to helpfully swap then to scientific notation. How we laughed at that one, several weeks down the line.


 
So, beware the spreadsheet, its not a database. Don’t do a Serco Track & Trace, learn from their mistakes.

Who in YOUR organisation needs to take that advice to heart?

Related Post: Keep an eye on your staff using spreadsheets, adding up totals, with a calculator too!


_/_/_/_/_/_/_/_/

I would be pleased to connect with you on LinkedIn - http://uk.linkedin.com/in/tonysmiththathousingitguy Message me with any issues or queries, you would like to be explored in this blog. We generally receive a couple of suggestions each month.

Steely Dan – Rikki Don’t Lose That NumberSteely Dan – Rikki Don’t Lose That Number.
(c) Tony Smith, Acutance Consulting www.acutanceconsulting.co.uk 07854-655009


Access a quick list of our Social Housing ICT blog posts here

Could we help you or your organisation? Our contact details are here , get in touch we will be pleased to chat about your problems and help with your organisation issues.


File Under: #HomesForBritain,#HousingDAY,#InternetOfTenants,#Shout,#UKHousing, 07854655009, 1st Touch,1stTouch,360,365Agile,3squared,4Js, ACL,ALMO,AMS,AX,Aareon,Abritas,Academy,Accuserv,Accuserve,Active Housing,ActiveH,ActiveHousing,Acutence,Advanced,Agile,Agile365,AirWatch,Alfresco,Alignment,Allpay,Amazon Web Services,Anite,Apex,App,ArchHouse,Archouse,Asprey e-state pro,Asset Management,Associates,Aurora,Average IT Costs,AWI SX Integration Toolkit,AWS, BI,BO,BPR,BancTec,BigChange,Blockwise,BluTek,Bluebox,Blueprint,Browser Applications,Business Objects,Business Planning,Business Process Review,Business social networking, CACI,Capita One Housing,CBL,CCS IT Keystone CCSIT,CEDRM,CHICS,CHR,CIH,CMS,COA,CORE,CPL,CRM,CRM2013,CRS,CTI,CTX,Cadcorp,Capita,CapitaOne,Capita One,Capital Management,Cashflow,Castle,Castleton,Castleton Technology,Cedar Open Accounts,Cerrus,Change,Charges,Chartered Institute Of Housing,Cheaper Housing IT,Chics, Citrix,Civica,Civica CTX,Civica Cx,Civica Genero,Civica Saffron,Clearview,Clik,Cloud Dialogs,CloudDialogs,Coactiva,Codeman,Comino,Commontime,Community Reward Services,Company,Competitive Dialogue process,Component Accounting,Consilium,Consolidation, Consultancy,Consultant,Consultants,Contact Manager,Context,Contractor Systems,CorVu,Cost Reductions,Covalent,Crystal Reports,Customer Relationship Management,Cx, DRS,Deeplake,Designer Software,Development Systems,Director,Document,Documotive,Docuware,Dynamic AI,DynamicAI,Dynamics 365,D365,Dynamics365, ECMK,EDM,EDRMS,ERP,ESRI,Elmhurst,Enghouse Interactive,England,English,EnterpriseBI,Estatecraft,Etive,Exhibition,Exponential-e, Facebook,Factorwise,Field Service management,Finance,Financial Systems,Financials,Footprint,Forms,Freezes,Fusion, Gas Tag,G-Cloud,GCloud,GDPR,GGP,GIS,GasTag,Genero,GeoSolveIT,Getting best from,GoTonySmith,Grasp,Grip,Group Apex, HFI (Housing Financials interface),HG,HRA,Hardware,Hitachi Systems,Hitex,HomeMaster,Hometeam,HouSys,House,Housemark,Housemark survey,Housing,Housing Contact,Housing Group,Housing Insight,Housing Management,Housing Management Consultant,Housing Partners,Housing Portfolio Management System,Hub Asset Management,Homeswapper,Housing jigsaw, Housing Support Pro,HousingIT,HousingSupportPro,HyperOptic, IMS,IT,IT Budget,IT Training,ITIL,Impact Response,In,In4,In4Systems Promaster,InfoBoss,InHouse,InMotion,InMotion2015,InMotion2016,InfoBoss,Infoflow,Information,Information Technology,Information@Work components,Informix,Innovation, Informetis,Inphase,Inside Housing,Insight,Internet Portal,Internetalia,Invu,Ireland,Irish,itLab, Keyfax,Keylogic,Keypera,Keystone,Kirona,Kypera, Landlord,Ledgers,Linkedin,Liquid,Locality,Localz, M3,MAVIS,MD,MDM,MI,MIS,MIS-AMS,MISCS,MRI,MS Dynamics,MRI,MS Dynamics CRM2011,Microsoft365,microsoft 365,MWL,Management,Management Server,Manifest,Measuring,Mebus,Microsoft Dynamics 365,Microsoft dynamics GP 2013,Miracle,MobileIron,Mobysoft,Monopoly board images and pictures,Montal,Mr Void,MriEngage,MrVoid, NDL,NINTEX,NINTEX workflow,NPS,NPS ASSIST,NPS Housing,NPS Job Manager Mobile,NROSH,Natural,Neighbourhoods and Communities,Nintexworkflow,Northgate,Northgate Codeman,Northgate Public Services,Notice, OA,OGC Buying Solutions,OJEU Limits,ORS,Ohms,OmFax,Omniledger,One,OneAdvanced,OneServe,Open source,OpenContractor,OpenHousing,Opti-time,Options,Optitime,Oracle,Orchard,Outsource and outsourcing,OutSystems, PIMMS,PIMSS Data,PM,PRINCE2,Paloma,Pamwin,PanConnect,People Value,Peoplevalue,PfH,Pick,PlanForm,Planned maintenance,Plenfific,Plus,Portfolio Management System,PowerObjects,Pro,Pro-Points,Prodo,Progress,Promaster,Propoints,Proval,Providers,Pyramid, QL,QuantSpark,Qube,QLX,Qlikview,QueryView,Queryview reporting,Quiss, RM865,ROCC,RPs,RSL,Rave,ReAct,Reality,RedkiteCRM,Red Olive,Registered,Registered Social,Rent Increase,RentSense,RentSenseLite,Repairfinder,Reporting,Reports,RobotAutomation,Rocket, Salesforce,Salesforce.Org,SAP,SASSHA,SDM,SHBVN,SM,SOTI,SP,SQL,SQL Open Housing,SQL Reporting,SQL Server,Saffron,Safron,Saturn,Scenario,Scotland,Scots,Scottish,Scout,Sequoa,Serengeti,Serros,Server,Service,Services,Servitor,Sharepoint,Sim,SimPro, Simdel,Simdell,Slash and Burn,Social Housing ICT,Social Housing Software Applications,Social Media,Software,Software solutions,Spotlight Service,Spotlightservice,Star rating,Stores and Stock,Strategic,SunAccounts,Sunguard,Surveys,Streetwise, Swordfish,Sx3,Symatrix Human,System alignment,Systems,Systemwise, T-Files,TEAMS,TED,TFiles,TP Tracker,TSG,Tagish Casework,Tagra,Task,TAIM,Technologies (India) PVT Limited,Telecetera,Template,Terminal Services,That,Three Star,Today,Tony Smith,Tony Smith That Housing IT Guy,TonySmith that housing IT,TonySmithHou,TonySmithHousing, ,TonySmithHousingITguy,Total,Total Mobile,Totalmobile,Trace,Tribal,Twitter, U2,UC,UK,UK Housing,Ukhousing,UniClass Enterprise,Unidata,United Kingdom,Universal,Universalcredit,Universe,Unrest, Valueworks,Van Stock,Vantage,Vantage Sentinel,Version,Virtualisation,Visualmetrics,Voice,Voice and data,Voluntas, Wales,Welsh,Wheatley,Windows Server,Workflow and,Work Hub,Works Connect, XML,Xen App,XenApp,Xmbrace, ...
. . . . . . . . . . . .

Saturday, 21 March 2020

The Tracers

If you do the Twitter thing, follow me at @HousingITguy
or LinkedIn here https://uk.linkedin.com/in/tonysmiththathousingitguy


Amid the pub 🍻closures, panic buying and social distancing, there was some recent interesting Covid-19 tech news from Singapore. A new app (available to anyone now with a Singapore phone number, on the Appstore it appears), called ‘TraceTogether’, was launched yesterday (20/03/2020).

It was developed by the Singapore Government Technology Agency (GovTech) in collaboration with its Ministry Of Health over the past eight weeks. The app just requires Bluetooth to be enabled. At the time of writing, I am aware of a website/app in Spain that allows citizens to log to the health services they have self-diagnosed. Also some similar things starting in Germany.

The app works by exchanging short-distance Bluetooth signals between phones to detect other users of the app who are in close proximity. Current MOH guidelines define close proximity as two metres apart, or up to five metres, for 30 minutes.

TraceTogether APP QR Code
Records of these encounters will be stored locally in the users’ phones and will not be sent to the authorities. Users will only be asked to share these records when contacted by MOH as part of Coronavirus contact tracing investigations. If they refuse, they may be prosecuted under the Infectious Diseases Act.

Currently, contact tracing relies on the memory of interviewees. However, there have been instances when interviewees could not remember all their contacts or did not have information about people they had been in contact with.

The new app will not replace ongoing contact tracing efforts, but it will facilitate the process, enabling contact tracers to inform users who are close contacts of COVID-19 cases "more quickly".

This sounds like a great idea and probably would work well in a society, such as Singapore where the state rules firmly and community is relatively compliant. If utilised in the UK, EU, USA, Australia or other countries, it could significantly help with identification of new virus clusters. However, as has been seen, making use optional (like restricting yourself going to the pub), does not work, its take up would probably need to be mandatory in the UK, to actually make a difference.

Dr Janil Puthucheary, Minister-in-charge of GovTech, said: "The process of contact tracing starts with a recall … and that is the only thing that this app intervenes with. It means that poor memory will no longer slow down the process of contact tracing”. "In contact tracing process, time matters,” he added, noting that contact tracing remains a key part of the country’s strategy to limit local transmission of COVID-19 and this app will augment the speed at which that occurs.

“The faster the contact tracing process can be initiated and can identify the people at risk, the faster we can intervene and impose quarantine if necessary and limit spread locally," he told reporters at a press conference on Friday. Authorities hope to use the app to establish 25 per cent to 50 per cent of these close contacts.

Around data protection and GDPR worries, this app is opt-in. The authorities stressed that the use of the app is voluntary and that users have to give "explicit consent" to participate in TraceTogether. This consent can be withdrawn anytime, according to GovTech.

The app also has several layers of security and privacy safeguards in place. For example, users will submit only their mobile numbers after downloading the app. Each phone will then be assigned a user ID.

This user ID is then used to generate temporary IDs at regular intervals. It is this temporary ID that is exchanged between the phones of TraceTogether users. Such regular generation of temporary IDs protect users from eavesdropping and tracking overtime by malicious actors, according to GovTech.

It remains to be seen if this idea can be adapted for use quickly here in the UK and EU, to assist with the controlled spread of Covid-19 , or in fact there is any interest from Westminster, in pursuing it. I for one, feel that we should be using every means available of protecting wider society and controlling the spread of this dangerous virus. If tech can help, then for goodness sake, lets bring it on and give it a try.

Read the full article from Channel News Asia, here.

Related Post: Covid-19, is it changing the way your organisation measures staff contribution and throughput?
 

_/_/_/_/_/_/_/_/

I would be pleased to connect with you on LinkedIn - http://uk.linkedin.com/in/tonysmiththathousingitguy Message me with any issues or queries, you would like to be explored in this blog. We generally receive a couple of suggestions each month.

Johnny Marr – The TracersJohnny Marr – The Tracers.
(c) Tony Smith, Acutance Consulting www.acutanceconsulting.co.uk 07854-655009


Access a quick list of our Social Housing ICT blog posts here

Could we help you or your organisation? Our contact details are here , get in touch we will be pleased to chat about your problems and help with your organisation issues.

File Under: #HomesForBritain,#HousingDAY,#InternetOfTenants,#Shout,#UKHousing, 07854655009, 1st Touch,1stTouch,360,365Agile,3squared,4Js, ACL,ALMO,AMS,AX,Aareon,Abritas,Academy,Accuserv,Accuserve,Active Housing,ActiveH,ActiveHousing,Acutence,Advanced,Agile,Agile365,AirWatch,Alignment,Allpay,Amazon Web Services,Anite,Apex,App,ArchHouse,Archouse,Asprey e-state pro,Asset Management,Associates,Aurora,Average IT Costs,AWI SX Integration Toolkit,AWS, BI,BO,BPR,BancTec,BigChange,Blockwise,BluTek,Bluebox,Blueprint,Browser Applications,Business Objects,Business Planning,Business Process Review,Business social networking, CACI,Capita One Housing,CBL,CCS IT Keystone CCSIT,CHICS,CHR,CIH,CMS,COA,CORE,CPL,CRM,CRM2013,CRS,CTI,CTX,Cadcorp,Capita,CapitaOne,Capita One,Capital Management,Cashflow,Castle,Castleton,Castleton Technology,Cedar Open Accounts,Cerrus,Change,Charges,Chartered Institute Of Housing,Cheaper Housing IT,Chics, Citrix,Civica,Civica CTX,Civica Cx,Civica Genero,Civica Saffron,Clearview,Clik,Cloud Dialogs,CloudDialogs,Coactiva,Codeman,Comino,Commontime,Community Reward Services,Company,Competitive Dialogue process,Component Accounting,Consilium,Consolidation, Consultancy,Consultant,Consultants,Contact Manager,Context,Contractor Systems,CorVu,Cost Reductions,Covalent,Crystal Reports,Customer Relationship Management,Cx, DRS,Deeplake,Designer Software,Development Systems,Director,Document,Documotive,Dynamic AI,DynamicAI,Dynamics 365, ECMK,EDM,EDRMS,ERP,ESRI,Elmhurst,Enghouse Interactive,England,English,EnterpriseBI,Estatecraft,Etive,Exhibition,Exponential-e, Facebook,Factorwise,Field Service management,Finance,Financial Systems,Financials,Footprint,Forms,Freezes,Fusion, Gas Tag,G-Cloud,GCloud,GDPR,GGP,GIS,GasTag,Genero,GeoSolveIT,Getting best from,GoTonySmith,Grasp,Grip,Group Apex, HFI (Housing Financials interface),HG,HRA,Hardware,Hitachi Systems,Hitex,HomeMaster,Hometeam,HouSys,House,Housemark,Housemark survey,Housing,Housing Contact,Housing Group,Housing Insight,Housing Management,Housing Management Consultant,Housing Partners,Housing Portfolio Management System,Hub Asset Management, Housing Support Pro,HousingIT,HousingSupportPro,HyperOptic, IMS,IT,IT Budget,IT Training,ITIL,Impact Response,In,In4,In4Systems Promaster,InfoBoss,InHouse,InMotion,InMotion2015,InMotion2016,InfoBoss,Infoflow,Information,Information Technology,Information@Work components,Informix,Innovation, Informetis,Inphase,Inside Housing,Insight,Internet Portal,Internetalia,Invu,Ireland,Irish,itLab, Keyfax,Keylogic,Keypera,Keystone,Kirona,Kypera, Landlord,Ledgers,Linkedin,Liquid,Locality,Localz, M3,MAVIS,MD,MDM,MI,MIS,MIS-AMS,MISCS,MRI,MS Dynamics,MS Dynamics CRM2011,MWL,Management,Management Server,Manifest,Measuring,Mebus,Microsoft Dynamics 365,Microsoft dynamics GP 2013,Miracle,MobileIron,Mobysoft,Monopoly board images and pictures,Montal,Mr Void,MriEngage,MrVoid, NDL,NINTEX,NINTEX workflow,NPS,NPS ASSIST,NPS Housing,NPS Job Manager Mobile,NROSH,Natural,Neighbourhoods and Communities,Nintexworkflow,Northgate,Northgate Codeman,Northgate Public Services,Notice, OA,OGC Buying Solutions,OJEU Limits,ORS,Ohms,OmFax,Omniledger,One,OneAdvanced,OneServe,Open source,OpenContractor,OpenHousing,Opti-time,Options,Optitime,Oracle,Orchard,Outsource and outsourcing,OutSystems, PIMMS,PIMSS Data,PM,PRINCE2,Paloma,Pamwin,PanConnect,People Value,Peoplevalue,PfH,Pick,PlanForm,Planned maintenance,Plenfific,Plus,Portfolio Management System,PowerObjects,Pro,Pro-Points,Prodo,Progress,Promaster,Propoints,Proval,Providers,Pyramid, QL,QuantSpark,Qube,QLX,Qlikview,QueryView,Queryview reporting,Quiss, RM865,ROCC,RPs,RSL,Rave,ReAct,Reality,RedkiteCRM,Red Olive,Registered,Registered Social,Rent Increase,RentSense,RentSenseLite,Repairfinder,Reporting,Reports,RobotAutomation,Rocket, Salesforce,Salesforce.Org,SAP,SASSHA,SDM,SHBVN,SM,SOTI,SP,SQL,SQL Open Housing,SQL Reporting,SQL Server,Saffron,Safron,Saturn,Scenario,Scotland,Scots,Scottish,Scout,Sequoa,Serengeti,Serros,Server,Service,Services,Servitor,Sharepoint,Sim,SimPro, Simdel,Simdell,Slash and Burn,Social Housing ICT,Social Housing Software Applications,Social Media,Software,Software solutions,Spotlight Service,Spotlightservice,Star rating,Stores and Stock,Strategic,SunAccounts,Sunguard,Surveys, Swordfish,Sx3,Symatrix Human,System alignment,Systems,Systemwise, T-Files,TEAMS,TED,TFiles,TP Tracker,TSG,Tagish Casework,Tagra,Task,Technologies (India) PVT Limited,Telecetera,Template,Terminal Services,That,Three Star,Today,Tony Smith,Tony Smith That Housing IT Guy,TonySmith that housing IT,TonySmithHou,TonySmithHousing, ,TonySmithHousingITguy,Total,Total Mobile,Totalmobile,Trace,Tribal,Twitter, U2,UC,UK,UK Housing,Ukhousing,UniClass Enterprise,Unidata,United Kingdom,Universal,Universalcredit,Universe,Unrest, Valueworks,Van Stock,Vantage,Vantage Sentinel,Version,Virtualisation,Visualmetrics,Voice,Voice and data,Voluntas, Wales,Welsh,Wheatley,Windows Server,Workflow and,Work Hub,Works Connect, XML,Xen App,XenApp,Xmbrace, ...
. . . . . . . . . . .