Which power plan is best for me? Excel for everyday problems

Posted on November 9th, 2017 in Analytics , Financial Modeling - 6 comments

We had to switch power providers soon, so I started reviewing the options. There are heaps of providers in New Zealand and each offer a ton of different plans. Some offer welcome bonus or credit worth up to $ 200. Other offer straight forward rates. Some others offer discount if you sign up for both electricity and gas with them. So how do you decide which one is better for you?

Using Excel of course.

The result is awesome. I ended up saving more than $1000 with a simple model. Puzzled? Curious? Check out this short but powerful video tut.

Choosing Electricity Provider using Excel – Video

Check out the video tutorial explaining the problem and model building process. You can see it below or on our YouTube channel.

Download Example Workbook

Click here to download example workbook with all the calculations. Feed your own power plan details to see which one is better for you.

What everyday problems do you solve with Excel?

While I don’t build models to figure out if brewing coffee at home is better than buying it at local café (home brewing any day for me), I do use Excel quite a bit to answer everyday questions. Recently, I built a model to see how often I cycle vs. walk.

What about you? Do you answer everyday questions using Excel? Please share your experiences in the comments section.

Want more models? Tall, sexy, funny and flexible, we got them all:

If you want to learn how to build models using Excel, check out below tutorials & resources:

Written by Chandoo
Tags: , , , , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

6 Responses to “Which power plan is best for me? Excel for everyday problems”

  1. Vit says:

    I use Excel for anything where I need to calculate something.

    I've been tracking my daily spending in Excel for the past 12 years, so I know that when we decided to eat more healthily, we really reduced our consumption of sweets and red meat. It has a dashboard and all.

    I also used it as a family decision matrix to decide where to relocate.

  2. Harry says:

    If I'm not creating a spreadsheet for everything, then I usually think in terms of spreadsheets.

    Applying logic, metrics and rationale to decisions in the same way I would when proving a decision using excel tends to have the same output: a thought out and justified decision.

  3. Hemant says:

    GM All,
    i have a problem in which 2 spreadsheet , one spread sheet contain incoming of whole month, with vender code ,sap item code and incoming qty,
    and in another sheet contain vender code and sap item code , we need to take the data for incoming qty in the second one with out using filter option.

    please support. and give the best guidance.

    thanks
    Hemant Sharma
    9911195566

    • Prasad says:

      hey Hemant,
      there are forums where you could ask this. i'd go with vlookup, pretty sure some of the folks around here would give much more detailed and varied answers!

  4. Prasad says:

    Chandoo, you need to check out projecteuler.net and try solving some of them with Excel 😀

    I wish we could go back in town and try some of this excel awesomeness during MAC classes.

Leave a Reply