Wow. That is a big doc.
These are the numbers?
Where are the holidays defined?
It would be nice if the meter just told us if it was recording peak, mid, or normal.
Yea those are the TOU rate. Holidays are defined on Page 19.
Holiday New Year’s Day, Martin Luther King, Jr. Day, Presidents’ Day, Memorial Day, Independence Day, Labor Day, Columbus Day, Veterans Day, Thanksgiving Day, and Christmas Day.
Some of these move around and arent on the same day of the month each year so I’m not sure what to do about that. Currently, I’m going to have to update my template conditions at the beginning of each year to make sure I have them set to the correct day. Realistically, it’s probably close enough for me to not even bother changing them every year.
And if you look at your electric bill you’ll see some other charges e.g., Service & Facility, GRSA E, EGCRR, Trans Cost Adj, etc. These are all defined in that pdf. Some are just base charges (Service & Facility, Renew. Energy Std Adj, Colo Energy Plan Adj, and Energy Assistance Chg) so I have those just summed up and added to the usage costs in my billed_elec_cost sensor. It does look like some of these change month to month so there’s going to be some error in the billed cost I’m calculating but it will be minimal. The others are based on usage and are defined on the rate schedule.
Well after looking again, Renew. Energy Std Adj and Colo Energy Plan Adj are supposedly 1% of the total electric bill but when I try to calcuate that I’m off a few cents so I’m not entirely sure what they are using to calc that 1%.
1 Like
For those of you in the Denver area with solar, do you have 2 meters and have them both linked up to HA? I’ve got two of the new smart meters but was only able to set up the one directly fed by solar. That means I can see how much electricity is being generated / used from the panels but until I can get the other one set up, I can’t see how much electricity is being pulled from the grid.
Currently have an open ticket with Xcel about getting the other meter on my WiFi. Having the issue where the “EDIT” button doesn’t appear to do anything. Dev tools show there’s an error response coming back from a background call that I’ve shared with support.
That’s interesting. I’m in Denver, have solar and have 2 new Gen 5 Riva meters. When signing up of Energy Launchpad, I never had the option to choose which meter to connect. As you can see from my Itron meter display key a few posts above, the main meter shows HanCOn (connected to wifi) and solar meter shows Hand15 (disconnected from wifi). As the main meter shows both power pulled from the grid and power delivered to the grid, there really is no need to connect to the solar meter imho. I can get the total solar power generated from my Enphase Envoy and subtracting the value of power delivered to the grid from the Xcel meter gives me the amount of solar power consumed by my residence.
I’m happy you’re paying for attention. I am really mostly interested in getting within 2-5%. Having a good way to visualize the approximate price is worth a lot. Recomputing the bill isn’t as important. But I am happy someone is doing it.
Thanks for the work on this… I’m in Denver and just got my new meter, and I’m excited to play around with it this weekend. I’m curious, what are the long-term thoughts on the integration? Will it be integrated into HA directly or as a HA add-on? It’s such a nice compliment to the Energey monitoring dashboard, and it would be great to see it gain wider adoption.
1 Like
I’m in the Minnesota (St. Paul area). Just got a brand new Itron Riva Gen5 meter. Does anyone know what the IR test LEd outputs? I know it pulses something every few seconds, but it’s not in a regular interval, so I’m assuming it’s a pulse of data in some sort of protocol. What is the IR LED pulsing? The Excel Launchpad is not even showing up here … not available yet I assume.
2 Likes
On some meters the LED pulses once per watthour. I’d like to find an affordable way to display cumulative usage in watthours; there are generic counters but I’m not sure what the pulse is like. Does your meter display any info other than cumulative kWh?
EDIT: I see the meter cycles through a bunch of values including: time, kWh in A, B and C timeframes, total kWh, and some other things (‘handle’ number, etc) and one reading in units of kW, but it stays fixed at 4.165 or something. Could that be max power? And there are 2 rectangles and an arrow that emulate the spinning disk on mechanical meters. I don’t know how fast it spins in watt-hours.
I have ideas for some experiments but I’d rather keep them private for now… but anyone who has this working and would like to see what can be learned please PM me?
I thought mine might be pulse per watthour, but I would expect the pulses to be equal in time between pulses … mine are not. It seems like it might be sending out a stream of pulses (some sort of data protocol) each time the LCD screen changes to display other data. I know the IR LED is definitely pulsing because I can see it with an IR light sensor.
I emailed Xcel Energy about my new meter and they only said that our Itron Riva Gen5 meters are very new in our area and things on their website are not yet set up. I would simply be happy with an API that I could access using PHP, or even an ESP32 microcontroller.
I’d like to rework the MQTT container into an official integration. That step just takes quite a bit more time to match the HA code quality standards. It’s a possibility, I would just need to do a lot more homework on what we’re looking at requirements wise.
I’m also interested in hearing from anyone who believes the meter may be erroneously causing their bill to go up, as was suspected by some in the Gatesville TX deployment.
I’m in the same boat where the edit button doesn’t work no matter what browser or device I use. Been emailing the Xcel energy launchpad team to try to get this fixed. Every few weeks they email and say it should be fixed but still the same issue. The last time I checked in Chrome dev tools when I click the edit button and look in the network tab the response contains this error so I’m thinking I’m in an area they haven’t fully setup.
"actions": [
{
"id": "175;a",
"state": "ERROR",
"returnValue": {
"cacheable": false
},
"error": [
{
"message": "DeviceUtilID is not setup for HAN Wifi [EI03########]"
}
]
}
I live in Denver and I see others in this thread from Denver that appear to be up and running but maybe they are doing certain areas in phases.
If you want to bug the launchpad team, here’s the email I have been going back and forth with: [email protected]
On my Xcel page I can see granular usage and solar production so I’m pretty sure my meters are reporting at least hourly usage data back to Xcel.
Thanks for the reminder, I’d gotten the “everything is good, try again” email back on May 22nd, still nothing. I re-emailed this morning and got this:
Sorry about the continued issue. We are expecting a new fix to be implemented early next week. We will send you an email when you can try again.
I don’t have high hopes, it’s been really frustrating where I had an SDR dongle capturing everything great until the meter change…
Interesting - I’ve been wondering if these things are accurate. Ever since having mine installed, it’s really gamified electricity use in my house. I’ve REALLY been trying to cut back use (including the fact that I have yet to kick on my AC this season along with TOU adjustments) and I’ve been pretty shocked that my bill is still nearly $50.
I seem to remember someone on Reddit complaining about it, too.
I could be getting old, but that seems high to me.
I’m considering just getting a whole house energy monitor and using that instead (I have solar so I’m very interested in how much I generate, my inverter is old enough I have no visibility unless I go physically stand at it in the back yard)
Focus on changes in kWh, not the $, to look for an accuracy problem. If you have another way of measuring usage (clamp on meter or kill-a-watt) then you can really experiment. PM me if you want to chat.
The command line option using curl in Docker based installs breaks with May 2023 releases as when they upgraded Alpine, OpenSSL 3.1.0 came along with it and does away with legacy / insecure renegotiation for purposes of mitigating RFC 5746. The curl command barfs with:
OpenSSL/3.1.0: error:0A000152:SSL routines::unsafe legacy renegotiation disabled
One can open a shell in the container and update the openssl.cnf file (/etc/ssl/openssl.cnf) to work around this, but you’ll be on the hook to do this every time you pull a new version of HA.
1 Like
You can use a separate openssl conf file just for this command. That seems more secure in general (so we aren’t changing the entire system’s ssl policies). I pointed to the config file here:
A few posts after that, I had the path fixed: OPENSSL_CONF=/config/xcelcerts/openssl.conf.
That seems to be tolerant to updates in HA. I keep mine pretty up to date.
1 Like
It would’ve been smart if I had read the rest of the forum topic lol. Funny thing is I swore I searched for ‘openssl’ in this topic before commenting…
Thanks for doing the leg work here!