From what I have read:
Ccf is the volume of 100 cubic feet (cf)
I think that’s right now that you mention it, the meter says CF, but rtlamr config I have converts to CCF to line up to the Nat Grid bill. Messes me up as Nat Grid references CCF and Cubic Feet interchangeably for the same value when I went to check before I posted
meters:
- id: xxxxxxxxxx
protocol: scm+
name: meter_natgrid_gas
format: "#####.##"
unit_of_measurement: "CCF"
icon: mdi:gauge
I voted for this FR as my gas utility, Columbia Gas, lists gas consumption on the monthly statement in Ccf, then they convert Ccf to therms and bill me for the therms used.
In the meantime I plan to use templates for conversion.
Exactly the same here, thank you for the correction and adjusted the original post to be corrected.
Ok last spam post (sorry about this), would CCF or Therms for supported energy units make sense for this feature request?
EDIT: @eyager’s comment was correct, Therms calculations are varied, even month to month by the same energy provider, so doesn’t make sense here.
I’m in the same boat with using rtlamr. I have Center Hudson and they also use Ccf for billing. I have mine setup a little different tho but at the end of the day, the data is what we are looking for:
sensor:
- platform: influxdb
host: a0d7b954-influxdb
port: 8086
username:
password:
queries:
- name: "Gas Meter Reading"
unit_of_measurement: "Ccf"
value_template: '{{ ((value | int) / 100) | round(2) }}'
group_function: last
where: '"endpoint_id" = ''16602455'''
measurement: '"rtlamr"."autogen"."rtlamr"'
field: '"consumption"'
database: rtlamr
utility_meter:
hourly_gas:
source: sensor.gas_meter_reading
cycle: hourly
tariffs:
daily_gas:
source: sensor.gas_meter_reading
cycle: daily
weekly_gas:
source: sensor.gas_meter_reading
cycle: weekly
monthly_gas:
source: sensor.gas_meter_reading
cycle: monthly
offset:
days: 19
hours: 0
minutes: 0
CCF unit conversion would make sense as it is a fixed measure of a volume of gas equal to 100 cubic feet.
In addition to CCF some utilities bill gas usage by MCF which is 1000 cubic feet of gas, so that is another unit that may need to be supported.
Therms, however won’t because there is too much variation of what a therm actually is compared to a measured of volume of gas. A therm has been defined as 100,000 btu of gas, but a CCF of natural gas on average is 103,700 btu. Some will incorrectly define a therm being equal to 1 CCF, others will define 1 CCF being equal to 1.037 therms. Some utilities will take into account the actual average BTU content in the gas which can vary from month to month. For example in July the conversion would be 1.04812, but in May the conversion would be 1.06475.
Similarly we can’t automatically convert MMBtu or KWH billed based on a volume measurement because each utility would do this using a different BTU factor.
That’s a great point… I hadn’t noticed before, but looking at my bill, indeed Nat Grid uses different values for Therms calculations based on the month.
Somehow I missed it in the release notes, but in 2021.12.0 ft³
was added as a supported unit for the energy dashboard with gas. Thank you to the HA developers to add this!!
Also heads up, 1 ccf = 100 ft³ , so may need to tweak your units if you were using ccf vs ft³.
I may have lost track, but is ccf supported?
ft³ (cf) is supported, but ccf is not, however it’s a factor of 100 difference, so at least for me this was reasonable. Converting to m³ to me didn’t make sense so didn’t want to go there.
+1 to this. My utility company tracks gas in ccf, and I apparently can’t add it to the energy dashboard with ccf as a custom unit
PR opened: Add support for CCF volume unit by epenet · Pull Request #84029 · home-assistant/core · GitHub
Thanks epenet!
Supported now in Core 2023.1.1, however, CCF is not supported in Energy Dashboard yet.
Slight Workaround, you can switch your entities unit of measure to one of the supported units of measure, add it to energy dashboard, then switch the unit of measure back. It will show up in Energy Dashboard, and track and work, but in the wrong unit of measure.
I upgraded to 2023.1.2, and tried this out. My sensor configs are in yaml, so that is where I configured the units in CCF. I tried both changing an existing sensor, and creating a new one. Either sensor can be configured into the Energy Dashboard.
The issue I see, is that the Energy Dashboard takes the sensor values (even though the values are in CCF), and multiplies by 100 and displays the energy in ft³.
I’m having the same issue, my Energy dashboard keeps multiply by 100. Did you figure it out? Thanks
No, I just went back to ft³ and ignored the units.
I think I figured it out, when creating the gas sensor from reading I convert my original reading to CCF by dividing by 100 (my reading from itron meter is in cubic feet ft³, ie: 400125 ft³ ):
sensor:
- name: "Xcel Gas Meter Reading"
state_topic: "dietpi/SCMplus/ID"
unit_of_measurement: "CCF"
force_update: true
value_template: '{{ value_json.Consumption /100}}'
unique_id: "xcel_gas_meter_reading"
device_class: gas
state_class: total
Then when adding to Energy board, HA will again auto convert this CCF and display gas unit in ft³, but in other places it will just display as 4001 CCF as how I created the sensor. I had to do a full reboot after adding gas source to Energy,. This explains the issue I had earlier when I keep my reading sensor as ft³ (400125) and not convert to CCF by /100, then when adding to Energy board, HA will again multiply 400125 by 100 (cause it’s thinking the gas source is in CCF).
This is my dashboard:
xzelz, thanks for this info. I think you confirmed what I was confused about. my gas company also transmit data in cubic feet ft³. so I was dividing by 100, with a unit of measurement of CCF, but then HA energy was displaying in cubic feet ft³ and had me confused even though in states it shows as CCF. is this working for you since you made the change? my config is below - what is the diff between ‘total_increasing’ vs. ‘total’?
also, what does force_update: true do?
- name: "Gas Meter Consumption"
state_topic: "rtl_433/433/devices/SCMplus/9923/Consumption"
unique_id: "gas_meter_consumption"
device_class: 'gas'
state_class: 'total_increasing'
unit_of_measurement: "CCF"
value_template: "{{ value | float / 100 }}"