Converting a 0.01m3 input to kWh... any ideas?

My Gas bill tells me they calculate kWh from gas readings as:

Units consumed (m3) * Calorific value (39.2) * Volume Correction (1.02264) / 3.6

I am successfully recording an input which registers meter increment pulses at 0.01m3 since last read (using rate of change).  How do I take that value and create a kWh value for the number of pulses received?  I'd like to record how much kWh per day, week, month, etc also, like we do with Watts. 

pb66's picture

Re: Converting a 0.01m3 input to kWh... any ideas?

Can't you just do the sum and enter it as a fixed value x 0.1113541 and log to feed kwh & kwh/d etc ?

(0.01 x 39.2 x 1.02264 / 3.6 = 0.1113541)

Paul

pb66's picture

Re: Converting a 0.01m3 input to kWh... any ideas?

No Actually it's 0.111354133 when not rounded off by calculator :-)

Paul

Keen2bGreen's picture

Re: Converting a 0.01m3 input to kWh... any ideas?

Thanks Paul.  I guess I should be a but more specific.  I've never performed a calculation on a feed before - so a bit of a basic use question... How do I take the count multiply by the result, and convert to a kWh feed?

I've had a go, but not sure I'm doing it right.  My attempt attached.

Thanks again for you help.

Robert Wall's picture

Re: Converting a 0.01m3 input to kWh... any ideas?

Am I being thick, but surely the meter pulses already represent energy (not power) so can you not leave out both the rate of change and the final Power to kWh? It seems silly to me to differentiate energy to get a power, and then integrate to get back to energy.

Keen2bGreen's picture

Re: Converting a 0.01m3 input to kWh... any ideas?

I dont think that will work as the sensor send cumulative clicks so far, not clicks since last send.  So I need to use the rate of change to determine how many clicks since the last read.  I then need to calculate on the clicks.

I like to chart on kWh per day, so that's why I use that final step.

Am I duplicating?

pb66's picture

Re: Converting a 0.01m3 input to kWh... any ideas?

Does the "rate of change" part work ok? it's not something I've used. but once you have "clicks new" that figure will represent 10's of watt/hrs (0.01Kw/hrs) multiplied by 0.111354133 for a kw/hr value and just "log to feed" NOT "Power to kwh", as Robert says that bit is already done, then I think you'll able to log that to a "kwh to kwh/d" for a day by day total.

Paul

Keen2bGreen's picture

Re: Converting a 0.01m3 input to kWh... any ideas?

rate of change works very well.  Reports 0 in no change since last read (0 watts), and the number of clicks since the last read - so perfect for this sensor.  Updated to attached... just need some gas to burn now to check if its working

pb66's picture

Re: Converting a 0.01m3 input to kWh... any ideas?

I'm not so sure "log to feed" will work now I think about it some more. can you add these 2 lines to the same input after the "kWh Gas" test them at the same time?

accumulator     call it "kwh gas 2"

kwh to kWh/d   call it "kwh gas today"

Maybe an experienced pulse counter will chip in and confirm if we're doing the right thing

Paul

Schism's picture

Re: Converting a 0.01m3 input to kWh... any ideas?

Three steps I'd recommend:

log to feed - instantaneous pulses

accumulator - total pulses ever

kwh to kwh/d - pulses per day

"pulses" can be anything though, so just perform an initial calibration of x0.111354133 (or whatever) before the first step (log to feed) and all three will be recording kWh and not 0.01m3

john.b's picture

Re: Converting a 0.01m3 input to kWh... any ideas?

I think its worth logging m^3 first because the calorific value of the gas may change.  My bills frequently show different gas calorific value, so to keep track of emoncms measurement accuracy vs the meter I log m^3 first then convert to KWh.

And as Robert has said there is no point calculating rate of change if you want energy.  The pulse is already a measure of energy; you just need to convert from m^3 to kWh.

However if you want to know the average power (i.e. kW) between pulses then you could log the rate of change to a feed, but using it to calculate energy is just increasing inaccuracy.

John

 

Keen2bGreen's picture

Re: Converting a 0.01m3 input to kWh... any ideas?

Well - after a lot of playing, I've settled on t the attached.  It gives the total count so far and the interval gas consumption in Watts.  It seems to do what I want, and gives flexibility for changing the calculation to match my bill as suggested by John.

I'll confess I'm not sure how this feed processing really works.  The logic does seem odd to me.  I assume that when you log to feed the current calculated value is saved to a feed argument.  But that's not really what I experienced.

My theory was:

Register total counts so far (Log to feed-> Total Gas)

How many 0.01m3 since last read? (Total pulse count to pulse increment -> Gas Used)

Convert 0.01m3 gas to watts (calibrate X conversion factor 111.354133)

Register Watts consumed in last interval (log to feed -> Gas Watts)

Update total Gas Watts today (Power to kWh/d-> Gas kWhd)

but putting that first log to feed seems to produce some weird values.  So I'm obviously not understanding the process properly.  Is there a comprehensive tutorial on this key function?

Thanks again for your interest and help.

 

john.b's picture

Re: Converting a 0.01m3 input to kWh... any ideas?

Mike,

I'm not sure I can help you with a comprehensive tutorial, I use emoncms mainly to log my energy use, temperatures etc, then I use an Excel model to analyse it all.  So in the case of gas I just log the m^3 used.

Looking at your solution I can see you are possibly getting confused with power and energy.  Power would normally be measured in the units of Watts (W) or kilowatts (kW) and energy in Wh or kWh.

The pulse from the meter is a measure of gas used in 0.01m^3.  By multiplying the pulse by the conversion factor 111.354133 your feed will be a measure of energy in Watt-hour (Wh), not power or Gas Watts as you have called it.  You might think this is pedantic, but it is important.

So if you are looking to log energy in Watt-hours (Wh), (although kWh would normally be shown on your bill), then your last processes should be something like this.

Energy Used today (kWh to kWh/d-> Daily Energy Wh/d)

Note the process type is not Power to kWh/d anymore, but kWh to kWh/d.  Clearly your feed will be in Wh/d if you use 111.354133 as the conversion factor.

Hopefully this will be the solution you are looking for.

Keen2bGreen's picture

Re: Converting a 0.01m3 input to kWh... any ideas?

Thank you John - that is very helpful.

Just to clarify what I'm trying to do.  I'm trying to measure both really.  m3 to validate my remore reading with the physical meter, and kWh to monitor actual cost.  So that's why I'm trying to register the number of clicks (1/100 m3) and then calculate the kWh equivalent.

Cheers

Mike

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.