Over the past few years I’ve been discussing Quick-MI. Now, through the help of Google Docs, I’m sharing the Quick MI Worksheet to make it even easier for you to apply Quick-MI to your products, track progress, and share the results with your team. The Quick-MI Worksheet automatically performs all the necessary calculations and summarizes the product for you.
The more relationships, the stronger the relationships, in turn, the stronger and broader can be a product’s acceptance, support, and success. These relationships comprise Modular Innovation. And it is through Quick-MI that we quantify them.
Quick-MI evaluates the degree to which a product successfully addresses the following 5 categories of Modular Innovation:
Once quantified, products are better understood and clearer courses are able to be set for improvement and solidification of the elements within products directly relevant to Modular Innovation, and subsequently relevant to sustained success.
The Worksheet is broken into sections based on Category as indicated by the blue row starting each.
Beneath each Worksheet Category are the variables that make up the associated category.
To the right of the Category variable names is the Description column providing quick guidance regarding how to quantify each variable. More detailed guidance and examples can be found within article series posted on The Product Guy.
The next two columns "Select One" and "Select All that Apply" contain the variable values. When a variable has values listed within the "Select One" column, only the variable that best describes the current product’s characteristic is selected and copied, within the same row, to the Total Value column.
When a variable has values listed within the "Select All that Apply" column each value whose Description matches the current product is mirrored into the Total Value column.
The Total Values associated with each Category will automatically update…
… as will the Quick-MI Index at the bottom of the table.
Quick-MI Summary boils it all down into one single page, from each variable value to handy visual representations.
I also find it handy to use to track product progress over time, as well as instantly overlay against products.
As an additional note, the Quick-MI Worksheet is pre-populated with sample data to make it easier to dive in and get started. As you assess your products, just replace/add/remove the variable values within the Total Value column to match your findings. (Remember, only modified the Total Value entries within the non-blue rows — everything else will update automatically for you.)
The Product Guy