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:
- Modelling Inventory Run Rate & Cash Flows using Excel
- Sara’s Copy Shop – Break even analysis and what-if modeling in Excel [Videos]
- LEDs or CFLs? Doing Cost Benefit Analysis in Excel
- Financial Analysis & Modeling concepts 101 – Podcast
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.
Thank you and see you around.
Leave a Reply
|« Conditional Rank, the easy way [quick tip]||Thank you, we have a home in New Zealand »|