How To Make Complex Decisions

SHARE this post!

One of the things that has always driven me crazy is the way that in our minds we can decide what is right based on a number of factors but when you try to get that down on paper it is really difficult to judge how to make a decision when there are a few factors, not all important and different roads that we can go down.

These decisions come up at work, at home, during sports events, anywhere where things can change and that it is hard to make an easy decision

Finally a few weeks ago I found a great way to make this work, and work really well. First if you look at the pic of a spreadsheet below you can see how this works.


The example that I am using here is a rudimentary one where my wife and I were trying to decide weather to move away from Calgary or not and if so where.

How The Spreadsheet Weights Factors


When deciding to move I wanted to figure out where in Canada would work and at the same time I wanted to weight each city based on jobs (for me), home prices (need a roof over our head), schools and education (for the kids), and weather (to stop shivering in Winter).

You can see that not only would I want to make sure that I cover each of these factors but looking at the weighting just above the description I wanted to make sure that I weighted how important each factor was, for instance weather is not nearly as important as having a job but it still counts.

The final total at the end is just a number relative to each of the cities and really only means that the highest number is the most desirable.

Now A Chance For You To Make Decisions

So how can you mod this spreadsheet for your own reasons? You may want to use this for ideas on everything from choosing your next laptop or PC to software upgrades, to relocating like we did, or where to go on your next vacation.

Here is a link to the underlying spreadsheet

Now that you can bring this spreadsheet up in excel yourself you can mod it how you want. I think that the best thing to do is to add in your own numbers and factors.

If you wanted to use this for vacations then you could change city names to vacation destinations you could change jobs to cost of trip, you could change the weighting to say that weather is most important and lets say golf course access is least important. The formulas are simple enough but the range and numbers can be changed as you wish.

One this to be very aware of. The spreadsheet is based on the highest result being the most desirable following open source repair tracking software requirements. So do mistake highest price as being a bigger number. The highest number in any column is the most desirable so a weighting of 5 makes that factor the most important and a value in a column of 1 is the least desirable.

Let me know how you like this. I am so happy to get it in a spreadsheet and would love to know what people end up using this for.

191 thoughts on “How To Make Complex Decisions

  1. We absolutely love your blog and find most of your post’s to be exactly what I’m looking for. Does one offer guest writers to write content for you personally? I wouldn’t mind creating a post or elaborating on a number of the subjects you write in relation to here. Again, awesome site!

  2. Greate pieces. Keep writing such kind of info on your page.

    Im really impressed by it.
    Hey there, You have done an incredible job. I’ll certainly digg it and in my
    opinion recommend to my friends. I’m sure they’ll be benefited from this web site.

  3. Hiya! Quick question that’s completely off topic.
    Do you know how to make your site mobile friendly?
    My blog looks weird when browsing from my iphone. I’m trying
    to find a template or plugin that might be able to
    resolve this issue. If you have any recommendations, please share.

    With thanks!

  4. I loved as much as you will receive carried out right here.
    The sketch is tasteful, your authored subject matter stylish.
    nonetheless, you command get got an shakiness over that you
    wish be delivering the following. unwell
    unquestionably come further formerly again since exactly the same nearly
    very often inside case you shield this increase.

  5. I like the helpful info you provide to your articles.
    I’ll bookmark your blog and take a look at again right here
    frequently. I am rather certain I’ll learn many new stuff right here!
    Good luck for the next!

  6. An impressive share, I merely given this onto a colleague who had been conducting a small analysis for this. And the man in reality bought me breakfast since I ran across it for him.. smile. So well then, i’ll reword that: Thnx to the treat! But yeah Thnkx for spending enough time go over this, I feel strongly regarding this and adore reading more about this topic. If you can, as you become expertise, do you mind updating your blog site to comprehend details? It really is extremely ideal for me. Big thumb up in this article!

  7. Terrific work! That is the kind of info that are
    meant to be shared across the web. Shame on Google for no longer positioning this
    submit higher! Come on over and seek advice from my site .

    Thank you =)

  8. I truly love your site.. Great colors & theme. Did you create this web site yourself? Please reply back as I’m trying to create my very own blog and want to know where you got this from or what the theme is named. Kudos!

  9. My developer is trying to convince me to move to .net from PHP.
    I have always disliked the idea because of the costs.
    But he’s tryiong none the less. I’ve been using WordPress on several websites for about a year and am concerned about switching to another platform.
    I have heard very good things about Is there a way I can transfer all
    my wordpress posts into it? Any kind of help would
    be really appreciated!

  10. I simply want to tell you that I am all new to blogs and really enjoyed this web blog. Almost certainly I’m want to bookmark your site . You really come with fantastic article content. Bless you for sharing your webpage.

  11. Having read this I thought it was really enlightening. I appreciate you finding
    the time and effort to put this short article together.

    I once again find myself spending way too much
    time both reading and leaving comments. But so what, it was still
    worth it!

Leave a Reply

Your email address will not be published.