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.
|Catch the blog monthly archive at
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, ...