• About
  • Archive
  • Contact
The Greening of Gavin
  • Home
  • Our Green Shop
    • Little Green Workshops
  • Green Workshops
    • Cheese Making
    • Soap Making
    • Soy Candle Making
  • eBooks
    • Clay Oven eBook
    • Keep Calm and Make Cheese eBook
  • Podcast
    • TGOG Podcast
    • TGoG Podcast Archive
    • Little Green Cheese
  • Vlog
  • Cheese
  • Green Living
    • Chickens
    • Gardening
    • Soap Making
    • Recipes
    • Climate Change
    • Peak Oil
    • Solar Power
  • Resources

The Great Kilowatt Challenge – Recording Data

November 20, 2011 @ 23:51 By Gavin Webber 5 Comments

How are we going so far? By now you should be able to read your meter, or at least the numbers that display, so now we are going to learn how to record and calculate our daily usage in kilowatt hours or kWh.

I suggest that you find a time of the day where you can consistently record the data.  I have chosen 7.00 pm, which is about an hour after I get home from work each day.   You will find your own special time that you can check your meter daily.  Today’s initial reading is your baseline, so do not change your consumption in anyway at all.  Use all the same appliances you would normally use.  The fun starts after the baseline reading in the next few days.

There are two main ways that we are going to record, either by paper or via an excel spreadsheet.   If you don’t have MS Excel, I have created a MS Word copy that you can simply fill in with a pen or on-line, which you can download the MS Word version this link.  If using the word version, just by subtracting yesterday’s reading from today’s reading, you can get a feel for how much electricity in kilowatt hours you are using each day.  If you don’t have MS Word, try this PDF version and print it out.

If you have MS Excel it will be a breeze because I have created the spreadsheet we are going to use for the challenge all populated with the appropriate columns and formulae.

You can download the MS Excel version at this link.  Save it to your own hard drive for safe keeping as this is what you are going to use for record keeping each day.  Before you start using it I want you to get a current electricity bill and figure out how much you are paying per kilowatt hour, then go to the calc tab and change the figure in the orange box (grid tariff) to the rate you are paying.  Make sure that if your rate is something like 21.62 cents then fill it in like such; 0.2162.  This way the calculations will work correctly.

If you have solar PV and get paid a feed-in tariff, then change the figure in the yellow box (Feedin Tariff) to your rate.  My rate is 66c, so I have entered 0.66.  I have created the spreadsheet for a Net Feed-in Tariff only.  If you need me to modify it for a Gross Feed-in Tariff then leave me a request via a comment.

So how do we record our daily data?  Well what we do is fill in the raw meter data (add together peak/non-peak is you have a digital meter) on the data tab of the spreadsheet.  If you only import from the grid, then fill in the first column using the corresponding date.  You only need to input data into the data tab.  The calcs tab will do all the work for you.

If you have solar PV then you will need to fill in the raw export and inverter readings as well.

Here is the readings I entered into my spreadsheet.

Ignore the calc tab for today, because we have only taken 1 reading and it needs 2 readings to calculate.

So you hopefully I have not confused everyone too much and if anyone finds any mistakes in the calculations then please let me know.  I have tried to make the spreadsheet as simple as possible so you only need to input your meter readings in one place.

So once again, I ask you to use all your appliances and lighting as you normally would or we will not have an accurate baseline to begin with.  Once we have recorded two readings, then we can get the energy efficiency programme under-way with daily tips for electricity reduction.  Also as we fill in the data tab with our daily readings, the graph will begin to record your progress.  I love a good graph.

Until tomorrow, and remember to have fun, and if anyone has any questions either leave a comment, or drop me an email.  Happy to help out as we are all in this together.

“The use of solar energy has not been opened up because the oil industry does not own the sun.” – RALPH NADER

Will this article help someone you know? If so help them out by sharing now!

  • Click to share on Facebook (Opens in new window)
  • Click to share on Twitter (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)
  • Click to share on Reddit (Opens in new window)
  • Click to share on Skype (Opens in new window)
  • Click to share on Pinterest (Opens in new window)
  • Click to share on Tumblr (Opens in new window)
  • Click to print (Opens in new window)
  • Click to email a link to a friend (Opens in new window)
  • More
  • Click to share on Pocket (Opens in new window)

Related

Filed Under: Electricity efficiency, renewable energy, The Great Kilowatt Challenge

← The Great Kilowatt Challenge – Meter Reading The Great Kilowatt Challenge – Baseline →

About Gavin Webber

Gavin Webber's daily goal is to live a more sustainable lifestyle, in an effort to reduce his family's environmental footprint so we can all make a difference for our children & future generations to come.

Learn more about him here and connect with him on Twitter, Facebook, and Google+.

Comments

  1. Lisa says

    November 20, 2011 at 22:11

    Hi Gavin, I have a quick question which may have an obvious answer. My meter has 4 separate readings, Phase A,b & C on the smart meter and then one reading on a dial meter. All four are separately listed on my bill. How should I enter it on the spreadsheet? Does anyone else have their usage listed like this?

    Thanks!

    Reply
  2. Lisa says

    November 20, 2011 at 22:23

    I worked it out! I will need to put my Off Peak separately as I am charged a diferent rate for that one. So easy. Ta!

    Reply
  3. Dawn says

    November 21, 2011 at 07:33

    I’d really like to use the Excel version for recording if possible but my bill seems hugely complicated – there’s a two step rate, based on how much kW.h are used (one rate for up to 1398 kW.h, another for anything over that). Is there a way to make it work for the Excel sheet? I’m going to get started with the Word version, just so I can keep with the programme. Here’s a link to the “how to read your bill” thing from my utility company if it helps: https://www.bchydro.com/youraccount/content/residential_bill.jsp
    Cheers from chilly, snowy (ok only 1 cm) Canada

    Reply
  4. Gavin says

    November 21, 2011 at 14:05

    Hi Linda, well done for figuring it out.

    Hi Dawn, I think for the purpose of this challenge, just put in the lower rate to start with. For the energy efficiency programme we will only be concerned about kilowatt hours. Oh BTW the rate at the link is very low, is it still the same.

    Gav

    Reply
  5. Dawn says

    November 21, 2011 at 15:31

    Thanks Gavin.
    Yes, the rates in the link are the same as my most recent bill. Probably not for long, though as this newspaper article explains: http://www.vancouversun.com/business/Hydro+customers+facing+rate+hikes+expert+warns/5627930/story.html

    So this challenge is very timely for us!
    Cheers…

    Reply

Comments build lively communities. Let me know your thoughts, but keep it clean and green! Spam is removed instantly. Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Search This Blog

Follow my work

About Gavin Webber

About Gavin Webber

An Ordinary Australian Man Who Has A Green Epiphany Whilst Watching A Documentary, Gets a Hybrid Car, Plants A Large Organic Vegetable Garden, Goes Totally Solar, Lowers Consumption, Feeds Composts Bins and Worms, Harvests Rainwater, Raises Chickens, Makes Cheese and Soap, and Eats Locally. All In The Effort To Reduce Our Family's Carbon Footprint So We Can Start Making A Difference For Our Children & Future Generations To Come.

Delve Into the Archives

Visit Our Online Simple Living Shop

Little Green Workshops

Latest Podcast Episode

Subscribe on iTunes

Top Posts & Pages

The Seven Stages Of Change
How To Remove Scaly Leg Mites
Curing Black Olives
Growing Queensland Blue Pumpkins (Winter Squash)
Building a Wicking Bed on Concrete
Curing Olives
Repeat After Me. I Will Never Plant Potatoes With Pumpkins Again
Selling Your Own Soap in Australia
Black Aphids On Garlic
Strawbridge Family Inspiration

Recent Awards

Recent Awards

Local Green Hero

Categories

Favourite Daily Reads

Debt Free, Cashed Up, and Laughing

The Off-Grid Solar House

Greener Me

The Rogue Ginger

Little Eco Footprints

Down To Earth

Surviving the Suburbs

Little Green Cheese

Eight Acres

The Witches Kitchen

TGOG Readers On-line

Podcast Reviews

  • Always inspiring and entertaining!
    August 4, 2016 by floriographer from Australia

    I've crowed about Gavin's podcast before but I just have to recommend it once again - I love that he shares his learning as well as his successes - it helps the rest of us try try try again! Thanks Gavin!

  • ms
    July 22, 2016 by Ketaea12 from New Zealand

    I really enjoy listening to Gavin, he has a kind lovely voice. He covers some great relevant topics for the everyday greenie. With lots of tips or how to or what not to do. Thanks Gavin, love it!!

  • Well worth your time to tune in
    October 23, 2015 by A Vision Splendid from Australia

    I can highly recommend Gavin’s podcast ! I have followed Gavin’s blog since the very beginning and have loved to see his journey unfold. Gavin has a lovely speaking voice so this podcast is always very easy to listen to. Gavin has a very authentic approach to his green living lifestyle. He shares the ups and downs but always provides motivation and practical steps that we can all implement.

  • very good
    June 28, 2015 by Scared pax from United Kingdom

    This is a great podcast if you want to improve your life in so many aspects and become a more sustainable person. I love the soothing voice, the good pace, and it contains lots of useful information. Recommended!

  • opened my eyes
    May 25, 2015 by Gorn4lyfe from Australia

    A wonderful show!

  • Inspiring
    April 30, 2015 by Alan Whelan from Ireland

    This is a great podcast if you're looking for practical info on saving money by living more sustainably from someone who's made that journey over the last few years. Told in a nice, easy conversational style

  • Green Living, inspiring and practical
    January 8, 2015 by EliseMac from Australia

    Thanks Gav for sharing what has (and hasn't) worked along your journey for living a greener lifestyle. Inspiring and achievable for anyone, I look forward to this podcast weekly.

  • Local food equals less waste
    December 27, 2014 by allotmentadventureswithjean from Australia

    Another brilliant podcast from Gavin Webber encouraging us, and showing us how, to cut down on food miles, growing our own food, and cutting down on food waste. Gavin is a really interesting speaker, showing us how to eat better, growing our own food and how to live more sustainably.

  • Honestly australian
    December 15, 2014 by HodgepodgeOz from Australia

    Fantastic podcast, with a wide variety of well thought and researched topics. Gavin is a honest, forthright pod aster with a genuine interest in helping others get green. Like a day alongside is a day wasted, so too is a week without listening to Gavin. Highly recommended for people starting out, or those in the midst of their new lifestyle. Keep it up Gavin, wish there were more great reviews! Kimberley

  • Morning motivation
    December 8, 2014 by Bunnyworm from Australia

    Gavin has a great passion for living this greener lifestyle that motivates others to do the same. The podcasts are always interesting and informative. :)

  • Passionate Advocate
    October 18, 2014 by BoomOpGirl from Australia

    Gavin's enthusiasm and passion for creating a more sustainable world is nothing short of contagious. Thanks Gav, you are my weekly source of motivation for living a sustainable life! :)

  • Gavin speaks from the heart
    October 13, 2014 by Green gavin from Australia

    Gavin's podcasts are required listening for anyone planning to live a more sustainable life. He doesn't preach, but tells you his story from the heart. You'll laugh, smile, share in his concerns and along the way you'll pick up some great tips on living a simple life.

  • Green thoughts, so well iterated
    October 9, 2014 by Kwasikwami from Australia

    This is a wonderful podcast. Not only does Gavin talk knowledgeably on a range of sustainability topics from gardening tips all the way to the issues facing humanity as a whole, but he does so in such a wonderful voice, it's like listening to my Dad, love it!!

  • Easy listening inspiration on being green
    September 24, 2014 by Broomedy from Australia

    Gav knows how to share his journey to a more sustainable life in a manner that shows just how easy it really is. Not to mention healthier, economically beneficial and generally rewarding. The podcasts are an easy way to absorb Gav's great lifestyle. I recommend to anyone.

  • Thanks Gavin!
    August 31, 2014 by Honeywoodmilk from Australia

    Great practical advice for a greener lifestyle. This podcast is for anybody interested in growing their own food in suburbia, saving electricity, brewing beer, making cheese, all that wonderful business and most of all, saving money! Thanks Gavin, love the podcast mate!

  • Enjoyed those ideas for staying warm
    August 15, 2014 by enduringdragon from United States

    Like you we are having winter here in Chile—brrr! Every bit we can save on heating we will.

  • Green Podcasts
    July 26, 2014 by Carneu from Australia

    Excellent podcasts, which are full of information to help get started on a sustainable lifestyle.

  • Practical ideas and inspiration
    July 19, 2014 by HeathrowHeath from Australia

    I highly recommend Gavin's podcast and blog. Down to earth, entertaining and inspirational. Thank you.

  • Interesting & easy to listen to
    April 27, 2014 by Velocity3 from New Zealand

    Gavin & his guests make this green journey lots of fun.

  • Great green listen
    April 18, 2014 by Obscurenickname from Australia

    Gavin is a great down to earth, tell it like it is aussie with a passion for sustainability and growing food and making cheese

Carbon Offset website

Copyright - Gavin Webber © 2023