About SOFTWARE Software overview GEN-OPS1 Tempo my-CI Consulting Interim CILA Blog Contact

Excelling in excel just makes it more difficult

January, 18 2022
|
|

Excelling in Excel can sometimes get in the way of improvement

I have watched with great envy young engineers rattling out charts, pivot tables, and various other fantastic looking data spreadsheets. My mind is just not made that way. I struggle to keep up with reading columns and rows or cell numbers and then relating that to the interpretation. My wife tells me it is actually a condition recognised in schools and that I should get some diagnostic done to understand the problem further. Are you kidding? What else will they find? They might insist I retire on grounds of age related frailties. Who 'they' are I have no idea but I'm still shying away from the White Coats. Anyway, I rather like my 'excel disability' as some of my colleagues call it.

However, it does raise a point in my Lean world. We need to make sure being an excel wizz does not prevent the frontline teams making informed decisions or disempowering them from action.

Powerpoint and Excel are the opium of our consulting world

I have observed organisations inadvertently preventing improvement on a mass scale because of the choices made in who has access to laptops and who doesn't. Not that I think that a laptop will make a difference to continuous improvement, in fact, quite the opposite. The problem emerges when we then turn to those with access to excel - usually a manager, engineer or Business Improvement Analyst - to then interpret the data, make the pivot table and so on. I have seen teams having to wait weeks for information which could easily be done with a calculator and a flip-chart. But for some reason this does not hold the same credibility as having had the data flushed through mini-tab or excel and presented in a lovey pie chart, you know, the one I'm talking about, where the offending percentage is nicely shown as a slice of the pie slightly off set from the main body? Looks great! And therein lies the problem. Management want things presented in a neat format that can be slipped into the monthly report and by doing so it is unlikely the frontline teams will be as involved as they could be. It is a form of disenfranchisement, if you will, that we sleep walk into without knowing.  Powerpoint and excel are like a narcotic in our leadership strata, the opium of the consulting world.  OK, I exaggerate somewhat but they do salve our sensitive nerves about looking professional in front of the boss.  As for the animation, don’t get me started.

I am at my happiest when a scruffy, well used, hand written A3 is put under my nose that has been developed by the team (with the support of an analyst I might add). I can see it is theirs, they are proud of their findings and ownership of the problem and its solution.

Stick a flip-chart by the team. Encourage them to work the data without defaulting to excel or mini-tab. Sometimes a simple Pareto will do.

Celebrate their workings with the pen and be brave: take a photo of the scruffy piece of paper and stick it in your report. When asked what it is, take the leadership team on a Go Look See.

 

Check out our software for Continuous Improvement here:


GEN-OPS1 - SaaS platform for building and governing brilliant standards. Looking after the full cycle of a standard from cradle to grave and tracking competency.

TEMPO - optimising maintenance and long cycle work

my-CI - a mobile app for leaders to drive Continuous Improvement 

Director and Founder
Reduce maintenance turnaround time by 50%!
  • TEMPO is a system that has been developed to radically reduce the time taken to perform complex maintenance activities on fixed assets or fleet. It is a simple yet intelligent way of organizing your maintenance activities to complete the maintenance turnaround in half the time.
  • By organizing work sequences for trades/technicians and building critical paths and dependencies, TEMPO quickly highlights lost time opportunities in the overall planned turnaround.
  • Applying standard work instructions with step-by-step guides for process confirmation, TEMPO visualizes real-time progress for short interval control, providing instant decision making to maintain compliance to plan.
  • By using TEMPO to plan and execute complex maintenance turnarounds our clients have achieved 50%+ reduction in downtime, giving a 10%+ improvement in fleet availability.
Reduce maintenance backlog by 60%!
  • Unlock valuable maintenance time and use it to reduce chronic backlogs or stubborn deferred defects.
  • Give technicians more time for proactive interventions.
Improve asset reliability by 18%!
  • Enjoy the knock-on benefit of backlog clearance and proactive activities, improving the reliability of your assets.
Increase continuous improvement engagement by 180%!
  • TEMPO’s easy-to-use Concerns and Ideas capture feature engages technicians in driving improvements that help improve turnarounds, reliability, and availability
  • Identify the classic wastes (transport, inventory, motion, waiting, over processing, over production, defect) in relation to your maintenance activities.
  • Expose supply chain, kitting, resourcing, workplace organization, sequencing, tooling, and planning opportunities for review through TEMPO’s powerful reporting feature.
  • Analyze the hour-by-hour compliance to plan with the associated losses incurred throughout the turnaround event.
Back to top
{{BCD.web.gnav.slide + 1}}