Quick-MI Worksheet: Spreadsheet to Sustained Online Success

clip_image001Over 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.

00_worksheet

About Quick-MI

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.

Instructions

The Worksheet is broken into sections based on Category as indicated by the blue row starting each.

01_blue_rows

Beneath each Worksheet Category are the variables that make up the associated category.

02_variables

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.

03_description

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.

04_content

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.

05_permission

The Total Values associated with each Category will automatically update…

06_category_automatic

… as will the Quick-MI Index at the bottom of the table.

07_bottom

Quick-MI Summary boils it all down into one single page, from each variable value to handy visual representations.

08_fullscreen

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.)

 

VIEW THE QUICK-MI WORKSHEET

 

Enjoy!

Jeremy Horn
The Product Guy

About these ads
This entry was posted in modular innovation and tagged , , , by Jeremy Horn. Bookmark the permalink.

About Jeremy Horn

Jeremy Horn is an award-winning, product management veteran with thirteen years of experience leading and managing product teams. Jeremy has held various executive and advisory roles, from founder of several start-ups to driving diverse organizations in online services, consumer products, and social media. As founder of The Product Group, he has created the largest product management meetup in the world and hosts the annual awarding of The Best Product Person. Jeremy can currently be found pioneering the next generation of content management and sharing at Viacom, acting as creator and instructor of the 10-week product management course at General Assembly, and mentoring at Women 2.0 and Lean Startup Machine. Follow Jeremy on twitter @theproductguy or his blog at http://tpgblog.com.

2 thoughts on “Quick-MI Worksheet: Spreadsheet to Sustained Online Success

  1. Pingback: Automating the Path to a Better User Experience « The Product Guy

  2. Pingback: The Product Guy: Astonishin’ in 2010! « The Product Guy

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s