Skip to content
Shop | Excel system

Change Management System

Change portfolio, impact, stakeholders, readiness, concerns, training, adoption, pulse surveys and sustainment.

Screenshot of the Change Management System workbook with example data
Example data from the workbook.

How it works

  1. 02 Setup holds the change, the start of week 1, the status date, targets and lists. 03 Portfolio shows all changes and the load per group in the current quarter.
  2. 04 Impact and 05 Stakeholders describe who changes what and who decides whether the change lasts.
  3. 06 Readiness checks each area before it starts. 07 Concerns is the resistance log with patterns by type.
  4. 08 Plan holds all actions. 09 Training tracks explain, show, try and check per group.
  5. 10 Adoption and 11 Pulse measure usage, proficiency and understanding. 12 Sustainment checks each area after 30, 90 and 180 days.
  6. 13 Audit holds the 25 statements for repeated checks. 14 Status shows the change on one page for the weekly review.

Definitions used in the workbook

  • Load: Sum of the impact scores of all active changes for one group. Above 5 the group is saturated: sequence the changes.
  • Readiness: Half from the criteria met, half from the readiness survey of the area. Start an area at 75 percent or more.
  • Usage and proficiency: Meetings held divided by planned, audits passed divided by done.
  • Pulse: Four questions from 1 to 5, monthly, anonymous. Results go back to the teams within a week.

Sheets in the workbook

  1. Start
  2. Setup
  3. Portfolio
  4. Impact
  5. Stakeholders
  6. Readiness
  7. Concerns
  8. Plan
  9. Training
  10. Adoption
  11. Pulse
  12. Sustainment
  13. Audit
  14. Status

Who it is for

Transformation offices and HR partners who run several changes at once.

The method behind the numbers

This workbook is part of the Change Management toolkits. The Starter Kit adds the guide and the checklist for the first 30 days. The Excellence Bundle adds playbook, workshop pack, templates, deck and the complete Excel system.

Newsletter

One Lean idea.
Every week.