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 .