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:
Membership Required: Upgrade to Expose Nearly 1,000,000 Posts
Ready to Unleash the Millionaire Entrepreneur in You?
Become a member of the Fastlane Forum, the private community founded by best-selling author and multi-millionaire entrepreneur MJ DeMarco. Since 2007, MJ DeMarco has poured his heart and soul into the Fastlane Forum, helping entrepreneurs reclaim their time, win their financial freedom, and live their best life.
With more than 39,000 posts packed with insights, strategies, and advice, you’re not just a member—you’re stepping into MJ’s inner-circle, a place where you’ll never be left alone.
Become a member and gain immediate access to...
- Active Community: Ever join a community only to find it DEAD? Not at Fastlane! As you can see from our home page, life-changing content is posted dozens of times daily.
- Exclusive Insights: Direct access to MJ DeMarco’s daily contributions and wisdom.
- Powerful Networking Opportunities: Connect with a diverse group of successful entrepreneurs who can offer mentorship, collaboration, and opportunities.
- Proven Strategies: Learn from the best in the business, with actionable advice and strategies that can accelerate your success.
"You are the average of the five people you surround yourself with the most..."
Who are you surrounding yourself with? Surround yourself with millionaire success. Join Fastlane today!
Join Today
