
How it works
- Open 05 Lists. Enter the team size, the period and your targets. Adapt the categories.
- Enter every idea in 02 Idea Log on the day it is given: date, submitter, category, problem and proposal.
- Enter the decision and the date the submitter heard it. The response time in working days calculates.
- Enter who implements, the due date and the date the work has changed. Status and lead time calculate.
- Read 03 Dashboard in the weekly review: answered on time, implemented share, lead time, ideas per month.
- Use 04 Action List for actions from the review that are not single ideas.
Definitions used in the workbook
- Response time: Working days from the date submitted to the date answered. The same day counts as zero.
- Answered on time: Ideas answered within the limit in 05 Lists, divided by all ideas submitted.
- Implemented share: Ideas with a date implemented, divided by all ideas submitted.
- Lead time: Calendar days from the date submitted to the date implemented, averaged over implemented ideas.
- Ideas per person and year: Ideas per person in the period, scaled to 365 days with the period in 05 Lists.
Sheets in the workbook
- Start
- Idea Log
- Dashboard
- Action List
- Lists
Who it is for
Team leaders and CI coordinators who run an idea system.
The method behind the numbers
This workbook is part of the Continuous Improvement 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.