Hey there everyone,
I found MJ's Decision Matrix extremely helpful and decided to make a Google Sheets version for easier use. Right now I'm utilizing it to uncover what would be the best product to build for a new store my wife and I are creating. This will be the first time we approached eCommerce and we're going to implement the Decision Matrix to help our building process. We've made a simple Google Sheets file that helps calculate everything efficiently, so if you don't want to make a chart every time feel free to use ours!
Google Drive Link (click on File > Make A Copy to edit your own)
Decision Matrix
Features
- Automatically calculates everything for you
- Customizable for whatever decisions you're making (current factors and numbers are examples only)
- Color-coded total values so you can see the best choices (using conditional formatting)
_______
The default midpoint condition is set to a value of 290, but if you needed to change that, simply right-click on any of the Total Value cells below the product column, select View More Cell Actions, select Conditional Formatting, click on the Color Scale rule, then change the Midpoint number from 290 to whatever works best for you. This is usually about 60-65% of the sum of the Value column (see the RED cell)
_______
I hope this will be helpful/time-saving for you
A Quick Question For Experienced eCommerce Members
What factors would you use while researching for your next product?
I found MJ's Decision Matrix extremely helpful and decided to make a Google Sheets version for easier use. Right now I'm utilizing it to uncover what would be the best product to build for a new store my wife and I are creating. This will be the first time we approached eCommerce and we're going to implement the Decision Matrix to help our building process. We've made a simple Google Sheets file that helps calculate everything efficiently, so if you don't want to make a chart every time feel free to use ours!
Google Drive Link (click on File > Make A Copy to edit your own)
Decision Matrix
Features
- Automatically calculates everything for you
- Customizable for whatever decisions you're making (current factors and numbers are examples only)
- Color-coded total values so you can see the best choices (using conditional formatting)
_______
The default midpoint condition is set to a value of 290, but if you needed to change that, simply right-click on any of the Total Value cells below the product column, select View More Cell Actions, select Conditional Formatting, click on the Color Scale rule, then change the Midpoint number from 290 to whatever works best for you. This is usually about 60-65% of the sum of the Value column (see the RED cell)
_______
I hope this will be helpful/time-saving for you
A Quick Question For Experienced eCommerce Members
What factors would you use while researching for your next product?
Dislike ads? Become a Fastlane member:
Subscribe today and surround yourself with winners and millionaire mentors, not those broke friends who only want to drink beer and play video games. :-)
Attachments
Last edited:
Access Restricted: Unlock 1,000,000+ Posts
Stop Peeking Through the Keyhole.
Open the Door.
You hit a wall because the best advice isn't free—it's earned. Since 2007, MJ DeMarco has been active here daily (99.9% active rate), building a war room for entrepreneurs who refuse to settle for mediocrity.
- Active Daily: Life-changing content posted dozens of times every day. No dead threads.
- MJ's Inner Circle: Direct access to the author of The Millionaire Fastlane.
- Vetted Network: Connect with founders scaling to 7 and 8 figures.
- Proven Roadmaps: Strategy over motivation. Execution over "hustle porn."
"SCALED TO 6-FIGURE MONTHS"
"Tips and advice here saved me from huge mistakes, others allowed me to scale my business to 6-figure months."— User MitchC
"INSANE QUALITY OF PEOPLE"
"The number of high quality people I've met from this forum has been insane. All of it predicated on building real value."— User Richard Peck
"You are the average of the five people you surround yourself with."
Are you surrounding yourself with success?
