Menu
Which power plan is best for me? Excel for everyday problems
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.
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
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:
|
Leave a Reply
| « Conditional Rank, the easy way [quick tip] | Thank you, we have a home in New Zealand » |
At Chandoo.org, I have one goal, "to make you awesome in Excel & Power BI". I started this website in 2007 and today it has 1,000+ articles and tutorials on data analysis, visualization, reporting and automation using Excel and Power BI. 
8 Responses to “Which power plan is best for me? Excel for everyday problems”
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.
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
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.
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.
@Prasad
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
nice article sir
really helpful
thanks for sharing