Each Time I Tell People

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

This week I encountered in a conversation, a reference to a ‘database’, in an organisation with few specific application systems. On further investigation, (a simple, “Can you share your screen, so I can see your database”), all is revealed. What is being described is an Microsoft Excel Spreadsheet.

Now before we get fully into this post, I am not Excel-ist (or even spreadsheet-ist, if there are any Lotus SmartSuite users out there – Respect!). I am a big fan of Excel, but not for storing important data, like in a database.

I was considering just the other day, if I had £50 for every spreadsheet and each time I tell people, I had described as “not a database” or said, “stop using that spreadsheet as a database fella (he/she OBVs)”, I would have a substantial pension annuity built up by now. So many data manipulation functions have been added to Excel over a few decades, it provides a deceptive veneer. Add to that, the problem that 90% or more of spreadsheet users, have never had any formal training at all, just adds to the problem. Staff just in some cases do not understand that rows are best set up to be entities (eg each row a property, case, rent account etc, a column a particular value or field of a specific type).

Excel in the big maths scheme of things...

Many spreadsheets I see, could actually be easily transferred to Microsoft Word, with very little effort, with many people not even noticing, if a few tables were incorporated.

One big reason I hear from client staff, is that they maintain a spreadsheet because they can protect the data from the barbarians outside. In doing so, they become a silo, (although they are unlikely to twig that).

Reliance on Excel, often wastes a considerable amount of time and effort, often keeping certain staff members expert in their own silos.

My job is usually, (in the event that staff have not twigged it as yet!), is to extoll the virtues of a real database or application based on one and in most cases, transport them there as fast as possible.

So why migrate away from Excel? In contrast to Excel, databases allow users to only enter data once, as it offers the functionality to link other records together. Clearly, we might record a single asset and multiple complaints or anti-social behaviour events against it. Spreadsheets struggle with this kind of stuff.

When Excel contains more than a few hundred rows, users experience significant slowdowns. Databases utilise indexes and other means of speeding up access and reporting. Audit is generally easier too, where data can be (sometimes accidentally) lost in traditional spreadsheets. Many rows can trip up the biggest enterprises at times too!

Excel does provide sharing of a kind, although its not quite up to a proper database and often causes more problems than it actually solves. I have used Excel sharing occasionally successfully when with others scoring supplier demos, but you wouldn’t rely on running any organisation critical processes on it, believe me.

If you are reading this from a small organisation, running exclusively on Excel, you are probably overdue in giving me a call. Many small social housing providers do run on spreadsheets, many under 200 units in size and typically doubt that anyone like me would be interested in helping them organise better. In the last year, I have assisted housing providers managing 36, 160, 190 and 390 units, as well as the five to thirty thousand homes brigade. We can match suitable solutions to your needs.

If you are reading this from an organisation already with Integrated Housing Solutions and you have hundreds of spreadsheets still, perhaps you need help from a different direction. I have often helped teams with trust issues, or where additional useful and integrated functionality, can be squeezed out of existing solutions. Often the reasons for not using system modules (often already purchased and being paid for…), are sometimes tenuous. Convenience for a single team, can be over-valued beyond wider organisation integration and efficiency.  

In summary, I encounter spreadsheets usually as the rock in the road to transformation, rather than an enabler. Consider how you use spreadsheets in your organisation and consider if there should be a better way.

Related Post: Get your self-service right, or maybe come back when you can

Catch the blog monthly archive at https://soundcloud.com/housingitguy/

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

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.

Steve Gold – Each Time.
(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,MRI Socialhousing,MRISocialhousing, 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, ...
. . . . . . . . . . . .

Pocket Calculator

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

"Never trust anyone working on a spreadsheet, with a pocket calculator in one hand, adding up figures, to pop in a worksheet cell". 

An excellent observation that was shared with me last week. How many staff in your organisation operate like that?

In the same week, a team told me how well they managed voids on a spreadsheet, with a row per void, and what seemed like dozens of date columns. Each column was an action or a prompt of course. IE Keys handed in, passed to repairs team, started, complete in repairs, blah, blah. Each had targets (e.g. 5 days for minor void repair turnarounds etc), but there were no formulas in the spreadsheet, no intelligent highlighting, clever formulas in hidden columns doing the leg work etc.

That team also described that spreadsheet as a 'database'.

Funniest thing was that a workflow process was set up to manage this whole thing and that was "Too time consuming, to use". Apparently spreadsheets & even a board of T-Cards were quicker. Well, they could have been if that Excel spreadsheet had all kinds of fancy formulas that could quickly provide totals of voids, ones in time, out or approaching time etc. Reporting of course was a manual affair, requiring running a finger down a column, tapping numbers into a calculator etc. So as you can imagine, the spreadsheet is actually far less efficient than the workflow that should be in use.

While this is an interesting anecdote, it does make you wonder how many people are using Excel spreadsheets, without the slightest idea how they should be used. Much like an Armalite rifle should not be issued to a combat soldier unless they can strip it down and rebuild it, maybe we should not be giving users Excel if they don't actually know the first thing about it. Better to give them Word and just point them at the 'Insert > Table' tab on the ribbon. It would be about as efficient.

Many readers might remember that old initiative of the computer users driving license. Maybe we should have an Excel driving license, users need to complete, like a road theory test, before they can use the rows and columns. Who would be up for that?

When we recruit new staff, including managers and directors, should we not test their IT literacy too? I come across so many people like in this story, who carry their managers in trying to help them handle and do even elementary manipulation of Excel and other standard office tools. 

This might well get users using what we want them to use, so we have regain control over our processes and KPIs. Oh and lets ban pocket calculators if their owners have an Excel shortcut on their desktop, while we are at it. as they said for the "Good Friday Agreement", lets "Put them beyond use". We can move on efficiently then. Amen.

Related Post: So, can you staff even tackle a VLOOKUP then?

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

You can link with me on LinkedIn here - http://uk.linkedin.com/in/tonysmiththathousingitguy It would be great to connect !

Kraftwerk - Pocket Calculator.
(c) Tony Smith, Acutance Consulting www.acutanceconsulting.co.uk 07854-655009

PS As usual, if there are subjects you might like me to tackle on this blog, or you could benefit from any of our services please get in touch and let me know!

You can access a quick list of 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 or issue.
File Under: 360,1stTouch,4Js. , 07854655009 , ," """" ",,#UKHousing,#HousingDAY, #HomesForBritain, #Shout,1st Touch,3squared,Accuserv,Acutence,Aareon,Academy,ActiveH,Alignment,ALMO,Anite,Apex,ArchHouse,Archouse,asbestos,Asprey e-state pro,Asset Management,Aurora,Average IT Costs,App,Associates,ACL,Abritas,AMS,AX,aspireview, BO,BPR,Browser Applications,Business Objects,Business Planning, Business Process Review,Business social networking, Blockwise, Block wise,BI,BancTec,BluTek,Bluebox, Castle,CBL,Cedar Open Accounts,Cx,Change,Cheaper Housing IT,Chics, CHR,Citrix,Civica,Clearview,CMS , CCS IT Keystone CCSIT, Contractor Systems,CORE,CorVu,Cost Reductions,Covalent,CRM,Crystal Reports,CTI,CTX,Customer Relationship Management,Cashflow, COA,Coactiva,Codeman,Comino,Competitive Dialogue process,complex IT procurements,Component Accounting, Community Reward Services, Consilium, Consolidation, Consultancy,Consultant,Contact Manager,Context,CIH,Chartered Institute Of Housing,Cadcorp,Cerrus Saturn,convergeOne,CACI,CPL, CRS Director, Deeplake,Development Systems,Accuserve,Document Management,Documotive,datasystems , Microsoft dynamics GP 2013, DynamicAI, Dynamic AI, ECMK,EDRMS,England, English,EnterpriseBI,ERP Systems,ERP,Elmhurst,Estatecraft,EDM,ESRI,Exponential-e, Finance, Financial Systems, Financials, Factorwise,Facebook ,Fusion, Getting best from,gotonysmith, Grasp,Grip,GeoSolveIT,GIS,GGP, HouSys,Housing software,HG,Housemark survey,Housing Blueprint,Housemark, HRA, Housing Options, Housing Group,hotpixuk, HousingIT,hotpix,Hardware,Hitex,Housing Contact Company, Impact Response,implementations,In House,In4,InMotion, InMotion2014, InMotion2015, InMotion2016 , Exhibition, conference, Infoflow,Information Technology,Informix,inHouse,in-house workforce, Innovation,Inside Housing,Internet Portal,Internetalia, Invu,Ireland,Irish,Inphase , IT Budget,IT Training,iWorld, Innovation Group Apex,ITIL, In4Systems Promaster,IT,Insight, Keylogic,Keystone,Kirona,Kypera,Keyfax, Ledgers,Linkedin,Locality,Liquid Voice, MD ,Mr Void , MrVoid, Measuring Change,Mebus,Miracle,MISCS, mobile functionality,Monopoly board images and pictures, Montal,MS Dynamics,MS Dynamics CRM2011,Miracle Software,Management Reporting,MI,M3,MIS,MIS-AMS,Mobysoft, Northgate Codeman,Neighbourhoods and Communities, Northgate,Notice,NROSH,NINTEX , NINTEX workflow,Nintexworkflow, OA,OGC Buying Solutions,Ohms,OJEU Limits,OmFax,Omniledger,Open source software,open tender,OpenHousing,Opti-Time,Oracle,Orchard,Outsource and outsourcing,OpenContractor,ORS,OneServe, PIMMS Data Systems, Paloma,performance management systems,PfH, Pick,PIMMS,pimms4communities, Planned maintenance,People Value,Plus, Peoplevalue, PM,Progress,Promaster,Proval,Pyramid,PRINCE2,prince,Pamwin,PlanForm, Propoints, Pro-Points QL,QLX,Quiss,Qlikview, Registered Providers,Registered Social Landlord,Rent Increase Freezes,Repairfinder,Reporting,Reports,ROCC , Rocket,RPs,RSL,Reality,ReAct,reidmark,RM865, Saffron,SAP,Scots, Scottish,Scenario, Scotland,SDM,sector,TonySmithHou,Server Virtualisation,servicing, Servitor,Sharepoint,Simdel,Simdell,Slash and Burn,Social Media,Software,SQL Open Housing,SQL Reporting Services,SQL reporting services,SQL Server,Star rating,Stores and Stock,Strategic Asset Management,Sunguard ,Surveys,Sx3,System alignment, TonySmithHousing, Systemwise,SM,Sequoa,Serros,SP,Scout,score,Swordfish,Serengeti,SOTI,southview,Sunguard,Service Charges,Spotlight Service, Spotlightservice, SunAccounts Template,Task,Terminal Services, tonys , tonysm , tonysmi , tonysmith, tonysmitht, gotonysmith, tableau Business Dashboards, tonysmithth, tonysmiththa, tonysmiththat, tonysmiththath, tonysmiththatho, tonysmiththathou, tonysmiththathous, tonysmiththathousi, tonysmiththathousin, tonysmiththathousing, tonysmiththathousingg, tonysmiththathousinguy, sharepoint, share point Three Star,Today,Total repairs,Tribal,Twitter,U2, tonysmith , tonysmiththat , thathousing , thathousingIT , thathousingITguy ,TED,Tagish Casework,TP Tracker,Telecetera,Tagra,Trace, Totalmobile, Total Mobile, UniClass Enterprise,Unidata,Universal Housing,Universalcredit, universal credit, universal credits,UC,Universe,Unrest, UK, United Kingdom ,Ukhousing,UK Housing, Van Stock,Voice and data,Vantage Sentinel,Version One,Visualmetrics,Voluntas, Wales,Welsh,Windows Server,Workflow and tasking,Wheatley, Xmbrace,XML ,XenApp,Xen App .

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!

Catch the blog monthly archive at https://soundcloud.com/housingitguy/

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

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 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, ...
. . . . . . . . . . . .

Shadowplay

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

Let’s talk about the dangers of shadow IT in social housing, that awkward family secret everyone knows about but nobody wants written down in a board paper. Only last week, a client asked me in the review I am involved with, “Will you be rooting out the ‘Shadow IT’ around here”? Every landlord has it. Most pretend they don’t. And many are quietly running large chunks of their service on it while telling themselves the “core system” is well under control.

In housing, shadow IT isn’t some hoodie-wearing tech rebel spinning up servers in a cupboard. It’s far more British and far more tragic than that. It’s the Excel spreadsheet that started life as a “temporary tracker” during a HMS system or reputational issue back in 2018 and is now the only place anyone can reliably find your damp and mould cases. It’s the Access database built by someone “who was quite handy with IT” and left three restructures ago (we love restructures folks, don’t we?). It’s the compliance supplier web portal that everyone logs into because, frankly, it works, while the landlord’s own system gets updated later, badly, or not at all.

And before anyone gets sniffy, this stuff doesn’t exist because housing staff are idiots. It exists because systems don’t quite do what was promised, change requests (RFC’s) take forever, reporting is weak, and people are judged on outcomes, not architectural purity. When a neighbourhood officer is told to manage risk, meet deadlines, and keep tenants safe, they will use whatever tool actually lets them do that. Governance doesn’t fix a leaking roof.

The problem starts when the workaround quietly becomes the truth. That spreadsheet stops being “just for now” and becomes the thing everyone checks first. The core system becomes something you update to keep ICT happy. Extracts start doing the rounds by email. Versions multiply. Someone adds another tab. Someone else adds free text. Before you know it, you’ve got personal data, compliance information, and operational decisions sitting in a file called “FINAL_v7_REALLYFINAL.xlsx”. Strangely enough, organisations big & small all suffer from this.

At this point, congratulations. You don’t just have shadow IT, you have mission-critical housing services running outside any meaningful control. No proper security. No real audit trail. Poor or no clear ownership. No resilience when the one person who understands it goes on leave or, heaven forbid, leaves the organisation at the end of their contract. (where’s the knowledge transfer, good question?) 

In a regulated sector, this should be setting off alarm bells. Boards are signing off assurances about data quality, compliance, and risk while large chunks of the evidence live in places the organisation officially doesn’t recognise. Auditors ask for a report and suddenly there’s a very awkward conversation about which system is “the real one”. Spoiler: it’s usually not the one that was procured quickly & cost seven figures.

Excel deserves a special mention here. Excel is brilliant. I use it daily. It is not, and never will be, a housing management system, an asset register, a compliance or any other kind of a database. The moment someone says “don’t worry, we manage that in Excel without really understanding how a VLOOKUP works”, what they really mean is “we hope nothing goes wrong and nobody looks too closely”.

Supplier portals get a free pass far too often as well. Portals are fine if they’re part of a proper data flow. They are not fine when they quietly become the system of record and your own system is playing catch-up. At that point you’ve effectively outsourced control of your data without admitting it, documenting it, or governing it. That’s not innovation or disruption, that’s drift.

The most corrosive impact of shadow ICT is what it does to trust. Once staff learn that “the real numbers” live somewhere else, the core system becomes ceremonial. Data quality drops. Reporting becomes a debate rather than a fact. Digital transformation stalls because nobody wants to give up the thing that actually works, even if it’s held together with formulas a hope and a prayer. I should know, I am a fallen Catholic.

This isn’t an argument for banning spreadsheets or telling staff off. Shadow IT is a symptom. It shows you where systems don’t match reality, where governance has slipped, and where organisations have quietly accepted risk in order to cope.

The danger isn’t that shadow IT exists. The danger is continuing to rely on it while pretending it doesn’t.

Because the moment Excel, a portal, or a side system becomes the place the real work happens, your “core system” isn’t core at all. And everyone in the room knows it, even if nobody wants to say it out loud.

Maybe its time a third party came in and rooted out all your organisations “Shadow IT” chief?

Is your SocialHousing  ICT / transformation project drastically overrunning  ? 

Get in touch , I will drop in for a coffee & bring the KitKats ☕

       Related Post: The right Critical Friend will save you stress, time (and money) ?

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

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.

Joy Division – Shadowplay

(c) Tony Smith, Acutance Consulting www.acutanceconsulting.co.uk 07854-655009


Access a quick list of our Social Housing ICT blog posts here , what projects do we get involved in? Access them 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,ActiveF,ActiveFinance,ActiveHousing,Acutence,Advanced,Affinity,Aidenn,Agile,Agile365,AHB,AirWatch,Alscient,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,BrikHousing,Browser Applications,BC, Business Central, 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,Cx Assets, 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,CxFeedback, DRS,Deeplake,Designer Software,Development Systems,Director,Document,Documotive,Docuware,Dynamic AI,DynamicAI,Dynamics 365,D365,Dynamics365,Dynaway ECMK,EDM,EDRMS,ERP,ESRI,Elmhurst,Enghouse Interactive,England,English,EnterpriseBI,Estatecraft,Esuasive,Esynergy,Etive,Exhibition,Exponential-e, F&O, Facebook,Factorwise,Field Service management,Finance,Financial Systems,Financials,FLS,Footprint,Forms,Freezes,Fusion,Fuzzlab Gas Tag,G-Cloud,GCloud,GDPR,GGP,GIS,GasTag,Genero,GeoSolveIT,Getting best from,GoTonySmith,Grasp,Grip,Group Apex, HCL,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,HousingOne,Housing-One, Housing Support Pro,HousingIT,HousingSupportPro,HyperOptic, IMS,IPC,iProperty Cloud,IT,IT Budget,IT Training,ITIL,Impact Response,In,In4,In4Systems Promaster,InfinityGroup,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,InclineIT, Keyfax,Keylogic,Keypera,Keystone,Kirona,Kypera,Keynamics, Landlord,Ledgers,Linkedin,Liquid,Locality,Localz, M3,MadeTech,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,More IQ,MoreIQ,Microsoft Dynamics 365,Microsoft dynamics GP 2013,Miracle,MobileIron,Mobysoft,Monopoly board images and pictures,Montal,Mr Void,MriEngage,MrVoid,MoreIQ, MRI,MRI/Capita,MRI Housing One, 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,Plentific,Plus,Portfolio Management System,PowerObjects,Pro,Pro-Points,Prodo,Progress,Promaster,Propeller,Propoints,Proval,Providers,Pyramid, QL,QLX, QLF, QL Yuneo,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,Rubixx, 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,Techlabs,Technologies (India) PVT Limited,Telecetera,Template,Terminal Services,That,Three Star,Tilt,TiltAffinity,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,Visitour,Visualmetrics,Voice,Voice and data,Voicescape,Voluntas, Wales,Welsh,Wheatley,Windows Server,Workflow and,Work Hub,Works Connect, XML,Xen App,XenApp,Xmbrace, Yuneo,TS Acutance Consulting, ...

. . . . . . . . . . . . ES | FR | DE | IT | UK

  

Labour Of Love

If you do the Twitter thing, follow me at @hotpixUK
or LinkedIn here uk.linkedin.com/pub/tony-smith-bsc-hons-acih/a/979/351/




Sometimes I come across some real labours of love, encapsulated in Excel. I am sure we have all come across them, multiple worksheets, using lots of formulas, function seven deep, no end of HLOOKUPs and pivot tables.

It's amazing how some of these start off as simple ways to solve quite small problems. That's how they gain acceptance and grow into some real animals. One I encountered was from an organisation managing personal care budgets. It worked fine while they were managing a few dozen of them. Being successful, they soon were awarded a few hundred more to manage and within eight months had an expanding spreadsheet with already 25,000 rows of transactions on it.

Another example I come across often, is tracking of voids. How void teams seem to love spreadsheets and the way columns can be formatted as dates. This ignores the fact that most integrated housing management systems out there can knock out a fairly functional void action plan. Spreadsheets can look sexier though and that's often the attraction.  One I was looking at with a void team recently (I won't say where) had an Excel guru who built theirs and it looked great. However to report they had to count voids manually, there were no SUM() functions in it, or conditional highlighting to graduate a cell red when it was overdue.

When it was suggested they could build the void action plan with dates in the HMS and it was explained that would be easily reportable, the conclusion floored me. The void manager said, "Oh yes, that would be just like a database!".  "Well yes dear, that's the point of an integrated HMS", I was thinking while I bit my tongue. I calmly suggested I put it on the list of areas we will note that need addressing.

...and don't get me on the number of excel hosted Gas servicing and asbestos spreadsheets I have seen, during my 19+ years in social housing. 

There is a serious skills gap around understanding Excel and also what is possible from applications users already have. The former is a problem caused by organisations, who rarely provide enough training to assist them in getting the most from a brilliant tool. Lack of knowledge of system applications that are there, to manage our business processes, sometimes comes down to lack of training, but also some chronic under-implementation.  Suppliers are as much to blame here as project teams and ICT staff. When suppliers make it so difficult to understand and configure integrated systems, it plays into the hands of the Excel lovers.

I leave you with this poem I stumbled across this week, from Brian Bilston. You will enjoy it if you know your Excel. If there are any subtleties you are missing, get yourself on an Excel course.

Feel free to get in touch if you can knock together an 'Ode to Ohms', 'A Couplet for Comino' or a 'Promaster Pentameter'. Get your stanza's out 8-)    

     Catch the blog monthly archive at https://archive.org/details/@housingitguy

Related Post: When it comes to workflow, are your users more used to their tea-tray than their HMS Task-Tray?

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

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.


Hue and Cry - Labour Of Love.
(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: 360,1stTouch,4Js. , 07854655009 , ," """" ",,#UKHousing,#HousingDAY, #HomesForBritain, #Shout,1st Touch,3squared,Accuserv,Acutence,Aareon,Academy,ActiveH,AirWatch,Alignment,ALMO,Anite,Apex,ArchHouse,Archouse,asbestos,Asprey e-state pro,Asset Management,Aurora,Average IT Costs,App,Associates,ACL,Abritas,AMS,AX,aspireview, BO,BPR,Browser Applications,Business Objects,Business Planning, Business Process Review,Business social networking, Blockwise, Block wise,BI,BancTec,BluTek,Bluebox, Castle,CBL,Cedar Open Accounts,Cx,Change,Cheaper Housing IT,Chics, CHR,Citrix,Civica,Clearview,CMS , CCS IT Keystone CCSIT,Civica Genero,Contractor Systems,CORE,CorVu,Cost Reductions,Covalent,CRM,Crystal Reports,CTI,CTX,Customer Relationship Management,Cashflow, COA,Coactiva,Codeman,Comino,Competitive Dialogue process,complex IT procurements,Component Accounting, Community Reward Services, Consilium, Consolidation, Consultancy,Consultant,Contact Manager,Context,CIH,Chartered Institute Of Housing,Cadcorp,Cerrus Saturn,convergeOne,CACI,CPL, CRS Director, Deeplake,Development Systems,Accuserve,Document Management,Documotive,datasystems , Microsoft dynamics GP 2013, DynamicAI, Dynamic AI, ECMK,EDRMS,England, English,EnterpriseBI,ERP Systems,ERP,Elmhurst,Estatecraft,EDM,ESRI,Exponential-e, Finance, Financial Systems, Financials, Factorwise,Facebook ,Footprint,Fusion, Getting best from,gotonysmith, Grasp,Grip,GeoSolveIT,GIS,GGP,Genero,HouSys,Housing software,HG,Housemark survey,Housing Blueprint,Housemark, HRA,Housing Support Pro,HousingSupportPro,Housing Options, Housing Group,hotpixuk, HousingIT,hotpix,Hardware,Hitex,Housing Contact Company,Housing Management Consultant,Housing Management Consultants, Impact Response,iPayPro,implementations,iRobot,In House,InHouse,In4,InMotion, InMotion2014, InMotion2015, InMotion2016 , Exhibition, conference, Infoflow,Information Technology,Informix,inHouse,in-house workforce, Innovation,Inside Housing,Internet Portal,Internetalia, Invu,Ireland,Irish,Inphase , IT Budget,IT Training,iWorld, Innovation Group Apex,ITIL, In4Systems Promaster,IT,Insight, iSupport,iSupportPro, Keylogic,Keystone,Kirona,Kypera,Keyfax, Ledgers,Linkedin,Locality,Liquid Voice, MD ,Mr Void , MrVoid, Measuring Change,Mebus,Miracle,MISCS, mobile functionality,Monopoly board images and pictures, Montal,MS Dynamics,MS Dynamics CRM2011,Miracle Software,MDM,Management Reporting,MI,M3,MIS,MIS-AMS,Mobysoft, Northgate Codeman,Neighbourhoods and Communities, Northgate,Notice,NROSH,NINTEX,NINTEX workflow,Natural Forms,Nintexworkflow, OA,OGC Buying Solutions,Ohms,OJEU Limits,OmFax,Omniledger,Open source software,open tender,OpenHousing,Opti-Time,Oracle,Orchard,Outsource and outsourcing,OpenContractor,ORS,OneServe, PIMMS Data Systems, Paloma,performance management systems,PfH, Pick,PIMMS,pimms4communities, Planned maintenance,People Value,Plus, Peoplevalue, PM,Progress,Promaster,Proval,Pyramid,PRINCE2,prince,Pamwin,PlanForm, Propoints, Pro-Points QL,QLX,Quiss,Qlikview, Registered Providers,Registered Social Landlord,Rent Increase Freezes,Repairfinder,Reporting,Reports,ROCC,RobotAutomation, Rocket,RPs,RSL,Reality,ReAct,reidmark,RM865, Saffron,SAP,Scots, Scottish,Scenario, Scotland,SDM,sector,TonySmithHou,Safron,Server Virtualisation,servicing, Servitor,Sharepoint,Simdel,Simdell,SimPro,Sim Pro,Slash and Burn,Social Media,Software,SQL Open Housing,SQL Reporting Services,SQL reporting services,SQL Server,Star rating,Stores and Stock,Strategic Asset Management,Sunguard ,Surveys,Sx3,System alignment, TonySmithHousing, Systemwise,SM,Sequoa,Serros,SP,Scout,score,Swordfish,Serengeti,SOTI,southview,Sunguard,Service Charges,Spotlight Service, Spotlightservice, SunAccounts Template,Task,Terminal Services, tonys , tonysm , tonysmi , tonysmith, tonysmitht, gotonysmith, tableau Business Dashboards, tonysmithth, tonysmiththa, tonysmiththat, tonysmiththath, tonysmiththatho, tonysmiththathou, tonysmiththathous, tonysmiththathousi, tonysmiththathousin, tonysmiththathousing,Tony Smith That,Tony Smith That Housing IT Guy,TonySmith that housing IT guy,tonysmiththathousing, tonysmiththathousinguy,tony smith housing guy,sharepoint, share point Three Star,Today,Total repairs,Tribal,Twitter,U2, tonysmith , tonysmiththat , thathousing , thathousingIT , thathousingITguy ,TED,Tagish Casework,TP Tracker,Telecetera,Tagra,Trace, Totalmobile, Total Mobile, UniClass Enterprise,Unidata,Universal Housing,Universalcredit, universal credit, universal credits,UC,Universe,Unrest, UK, United Kingdom ,Ukhousing,UK Housing, Van Stock,Voice and data,Vantage Sentinel,Version One,Visualmetrics,Voluntas, Wales,Welsh,Windows Server,Workflow and tasking,Wheatley,Works Connect,worksConnect, Xmbrace,XML ,XenApp,Xen App .

Dirty Sheets

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

I was on a virtual call recently with an organisation, just live on a new comprehensive integrated housing solution. 

It was a project that I worked together with them after procurement as a Critical Friend. It had been a great project, although one that had to be elongated, due to Covid, extreme weather/flooding and some other challenges. The ALMO and a combination of very capable project managers, took all of this in their stride, bringing everything in to time and budget.

I have worked on lots of procurements and a good number I work with during the implementation, to ensure we get the most from the supplier and the project is delivered to expectations set earlier. I know other consultants who help procure and stop there. I am always sensitive to answering the question, “Could I bring this in for that budget and pretty much to that suggested timescale”? This is clearly not a concern for many others. A lot of my clients become my long term friends and its important to me to see the organisation get the solution they procured and the absolute best chance for residents to feel the benefits of it.

So, we have a nice shiny system, however there is an elephant in the room, in tabular form.

Yes my friends, I am talking about spreadsheets, these days its Excel (which has conclusively clobbered Lotus-1-2-3, Visicalc and SuperCalc on the whole). Now don’t get me wrong, I am not Spreadsheet-ist. I like them, but only used for the things that they are best at. Spreadsheets are NOT good at being a database. Excel is NOT a database!

The challenge for this organisation (like many others), is to discover out where spreadsheets are actively in use, then seek out why staff are updating them. It’s a given I guess that all organisations will have multiple copies of historic spreadsheets, that are static and if identified can be easily made read-only or archived automatically.

Asking users to ‘fess-up’ to updating and maintaining spreadsheets, can lead to limited engagement. Users may often hang on to updating spreadsheets, as they perceive it as ‘part of their job’. If eliminated, would that eliminate their job? Probably not, they would most likely do an alternative task, adding more value or being more fulfilling to them.

The windows or SharePoint file system can be used to identify active spreadsheets. Connection tools in Crystal Reports, Qlik and other tools, allow access to spreadsheet properties, creator/amend user etc, which can be the entry point to what spreadsheets are actively in use, week to week, month to month.

In my experience, a lot of the use of spreadsheets is historic. They were completed because a certain manager/director wanted them maintained, or the old system didn’t store that data. In some cases, they are maintained because managers did not ‘trust’ the primary system of record.

Once identified, ICT or business analyst staff need to work out what value is added from the spreadsheet. Also if any data recorded in spreadsheets now belongs in the new solution and put a plan together to move the data to the primary system of record. The change required will modify processes and staff jobs, hopefully cutting out waste and gravitating towards more of a single source of the truth from the new primary system of record.

The attitude towards spreadsheets and their proliferation needs to be bullish. Failure to do so will get in the way of using any new system well and a bullet that needs to be bit!   

Related Post: So Serco and the NHS are not safe to use Excel like a database now?

Catch the blog monthly archive at https://soundcloud.com/housingitguy/

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

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.

David Byrne - Gasoline And Dirty Sheets.
(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,Affinity,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,Tilt,TiltAffinity,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, ...
. . . . . . . . . . . .