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

Posted on November 9th, 2017 in Analytics , Financial Modeling - 8 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.

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.

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:

 Conditional Rank, the easy way [quick tip] Thank you, we have a home in New Zealand
 Written by Chandoo Tags: downloads, Financial Modeling, Learn Excel, Microsoft Excel Conditional Formatting, Microsoft Excel Formulas, modeling, videos 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

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!

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.

• Hui... says:

Daily dose of Excel used to have a Eular problem solving section
http://www.dailydoseofexcel.com/

Go there and search for Eular

There was many discussions about solving Eular problems with clever logic and math as opposed to brute force solutions

5. Pvacorner says:

nice article sir