Countermeasures Matrix in Excel

Easy to Use Countermeasures Matrix included in QI Macros add-in

Evaluates the feasibility and effectiveness of countermeasures to reduce or eliminate root causes

counter-measures matrix excelLike ecological weed prevention, a countermeasure prevents problems from ever taking root in a process. A good countermeasure not only eliminates the root cause but also prevents other weeds from growing.

Example of QI Macros Countermeasures Template in Excel

countermeasures matrix in Excel

Step by Step Instructions for Completing a Counter Measures Matrix

  1. Transfer the problem statement and the root causes from your root cause analysis (Fishbone diagram or Ishikawa diagram).
  2. For each root cause, identify one to three broad countermeasures (what to do).
  3. Rank the effectiveness of each countermeasure (Low, Medium, or High).
  4. Identify the specific actions (how to do it) for implementing each countermeasure.
  5. Rank the feasibility (time, cost) of each specific action (Low, Medium, or High).
  6. Decide which specific actions to implement.

*Note: A Countermeasures Matrix/Prioritization Matrix can be used in place of an Effort-Impact Quadrant.

In addition to the matrix, QI Macros template includes a Feasibility - Effectiveness Chart

This chart plots the ranking values in columns C and E in order to give a clearer picture of how feasible and effective the list of countermeasures may be.

feasibility effectiveness chart in the QI Macros for Excel

Other charts in QI Macros add-in