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


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:

Chandoo

Hello Awesome...

My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.

I hope you enjoyed this article. Visit Excel for Beginner or Advanced Excel pages to learn more or join my online video class to master Excel.

Thank you and see you around.

Related articles:

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

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

    • Vignesh V says:

      Hi,

      If you dont mind can you share the excel I am looking our for such a one but not following the current format.

      Vignesh V

  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.

  5. Pvacorner says:

    nice article sir
    really helpful
    thanks for sharing

Leave a Reply


« »