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