Green Building Forum - Spreadsheet for Meter Readings Tue, 19 Dec 2023 05:09:41 +0000 http://www.greenbuildingforum.co.uk/newforum/ Lussumo Vanilla 1.0.3 Spreadsheet for Meter Readings http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=14001&Focus=235468#Comment_235468 http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=14001&Focus=235468#Comment_235468 Mon, 25 Jan 2016 19:41:43 +0000 barge17
I have been looking for some time for a ready made spreadsheet which can make a few charts from my data, but the thing that I realy can't sort myself (brain fade) is to make it possible to read the meters on any day day of the month to give better resolution of the graph if we are running the log boiler more or less than usual.

I wonder if there is anything out there that can be adapted for my purposes?

thanks]]>
Spreadsheet for Meter Readings http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=14001&Focus=235483#Comment_235483 http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=14001&Focus=235483#Comment_235483 Tue, 26 Jan 2016 00:38:46 +0000 rhamdu
It means I can't do exact year-on-year comparisons. I might be comparing 10 October to 15 March in one winter to 18 October to 12 March in another. But it's near enough.

I'm not clear about the woodburner issue. Is it that you want to measure energy use at times when the log boiler is not in use? In that case I don't see anything for it: to get anything near complete data you will have to read meters before and after every burn. Or have I misunderstood?

It will be difficult to calculate how much electricity and gas you are saving by using the log boiler, because you can only guess how much you would have used without it. You could estimate the saving by comparing days with similar weather conditions, with and without the log boiler. OK in theory, difficult in practice I suspect.]]>
Spreadsheet for Meter Readings http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=14001&Focus=235498#Comment_235498 http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=14001&Focus=235498#Comment_235498 Tue, 26 Jan 2016 10:21:18 +0000 barge17
Yes, that is exactly what I do with the gas meter, but my problem is dividing the readings by the number of days automatically and then getting a graph out of it, the electric and water meters are another matter and could be on a separate spreadsheet.

thanks,]]>
Spreadsheet for Meter Readings http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=14001&Focus=235513#Comment_235513 http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=14001&Focus=235513#Comment_235513 Tue, 26 Jan 2016 13:28:19 +0000 mike7 Spreadsheet for Meter Readings http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=14001&Focus=235516#Comment_235516 http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=14001&Focus=235516#Comment_235516 Tue, 26 Jan 2016 14:45:05 +0000 rhamdu Spreadsheet for Meter Readings http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=14001&Focus=235520#Comment_235520 http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=14001&Focus=235520#Comment_235520 Tue, 26 Jan 2016 16:18:11 +0000 mike7 Spreadsheet for Meter Readings http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=14001&Focus=235535#Comment_235535 http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=14001&Focus=235535#Comment_235535 Tue, 26 Jan 2016 20:43:39 +0000 barge17
Then I might begin to get a better picture of the gas usage compared to volume of wood burnt.]]>
Spreadsheet for Meter Readings http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=14001&Focus=235559#Comment_235559 http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=14001&Focus=235559#Comment_235559 Wed, 27 Jan 2016 10:09:26 +0000 vord So (kW/h_2-kWh_1)/(date_2-date_1) Plot the result against date on an XY scatter plot.]]> Spreadsheet for Meter Readings http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=14001&Focus=235606#Comment_235606 http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=14001&Focus=235606#Comment_235606 Wed, 27 Jan 2016 15:32:35 +0000 barge17 Spreadsheet for Meter Readings http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=14001&Focus=235826#Comment_235826 http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=14001&Focus=235826#Comment_235826 Mon, 01 Feb 2016 20:36:25 +0000 SteamyTea Today's date as a number is 42401
Tomorrows will be 42402
Day 1 was 01/01/1900 in Excel (default settings using Windows 8.1).
So normal addition/subtraction works for dates.

You could estimate the energy input from the wood burner by weighing the timber you burn.
Make a big pile of it, weigh it, burn for a week/month/whatever, then weigh the remains.
Or you could just get an energy monitor and logger (my favourite manufacturer is no longer in existence).

It is easy to get local weather data, Met Office or WeatherUnderground. You can download historic data from both.]]>
Spreadsheet for Meter Readings http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=14001&Focus=235833#Comment_235833 http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=14001&Focus=235833#Comment_235833 Mon, 01 Feb 2016 21:42:45 +0000 Ed Davies
https://support.microsoft.com/en-us/kb/214326]]>
Spreadsheet for Meter Readings http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=14001&Focus=235835#Comment_235835 http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=14001&Focus=235835#Comment_235835 Mon, 01 Feb 2016 21:47:06 +0000 SteamyTea
Now just to work out what MS thinks 0 is, odd or even (it is even).]]>
Spreadsheet for Meter Readings http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=14001&Focus=235855#Comment_235855 http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=14001&Focus=235855#Comment_235855 Tue, 02 Feb 2016 09:21:19 +0000 barge17
The energy input from the wood burner will be measured in cages/week ( IBC cages) - we shall only burn what is home produced, and that is limited at the moment. The gas boilers will probably be used in the "shoulder" months because we don't have a proper thermal store (yet) and tar was becoming a problem last Spring when a full burn was too much for a day's use which left the log burner idling a lot.]]>