I just got my IotaWatt installed and integrated into my system. It's exactly what I've been looking for for quite a while. My goal is to monitor/record the output of my off-grid inverters - e.g. 2 x AIMs 12,000w inverters.
Here's a snap of VRef and power being consumed on each 120v leg (Red wire and Black wire) from one of my AIMS inverters.
A simple IotaWatt query (
https://docs.iotawatt.com/en/master/query.html ) like this:
http://192.168.2.xxx/query?select=
[time.local,VRef,I2Black.Watts,I2Red.Watts]&begin=2023-01-31T21:14:00&end=s&limit=360&group=5s&missing=zero&format=csv returns 5sec granularity records in csv format starting at 2023-01-31 at 9:14pm with the Inputs values illustrated in the pic above - e.g. VRef, I2Black, I2Red...
2023-01-31T21:14:00, 115.5, 431, 1118.3
2023-01-31T21:14:05, 115.3, 527.2, 1121.4
2023-01-31T21:14:10, 115.5, 437.1, 1136.1
2023-01-31T21:14:15, 115.6, 413.6, 1151.1
2023-01-31T21:14:20, 115.3, 414.3, 1138.6
....
which is straight-forward to insert into a SQL Server database table....
.....
And a simple SQL query summarizes 5 second interval data into Kwhs over a range of time....
select isnull((sum(I1Red) / 1000) * 5 / 3600, 0) as I1RedKwh
, isnull((sum(I1Black) / 1000) * 5 / 3600, 0) as I1BlackKwh
, isnull((sum(I2Red) / 1000) * 5 / 3600, 0) as I2Redkwhs
, isnull((sum(I2Black) / 1000) * 5 / 3600, 0) as I2BlackKwh
, isnull((sum(I1Red) / 1000) * 5 / 3600, 0)
+ isnull((sum(I1Black) / 1000) * 5 / 3600, 0)
+ isnull((sum(I2Red) / 1000) * 5 / 3600, 0)
+ isnull((sum(I2Black) / 1000) * 5 / 3600, 0) as TotalKwh
from iotawatt
where DataDate >= '2023-01-29 06:00' and DataDate < '2023-01-30 06:00'
This lets me integrate the metrics I'm interested in to my 'live' dashboard ...
and the raw data is in the DB for future queries. At 5s intervals, I estimate about 1.2GB / year of database file space.
One issue (for me) with IotaWatt is the Voltage Reference requirement. When the off-grid inverters are off (low battery) the VRef goes to 0 and the unit doesn't like this. However, it resumes operations when the Inverter comes on. I get the impression it goes into a 0 value induced (infinite) loop which starves the processor until the VRef comes back. This causes issues such as the Logs dismount. A recent update to ALPHA 02_08_02 firmware might help this according to the IotaWatt forum. But even in the VRef = 0 case, the query (above) returns 0 values so it works for me.
Another issue is multiple voltage references. I want to record individual power on each 120v leg of both of my inverters. To do this 'best', one would need 4 x voltage references - one for each 120v leg. But it appears that having 1 voltage ref per inverter gets me close enough. I learned I can add a 2nd (and 3rd) voltage reference on inputs 13 and 14. Using 13 as a voltage ref will let me get reasonable power data from a 2nd inverter so I can track all 4 x 120v legs from both inverters. The 3rd voltage ref - I might use use to track the power coming in from a generator (to charge the batteries).
I totally Love this unit so far as all data is local, simple to access! One can upload to a local InfluxDB for amazing graphs - which was relatively simple to setup and all local - but I don't need this.
P.S. Shoutout to @
MurphyGuy for pointing me here on a different thread and for quick responses on the IotaWatt forum @overeasy to get me oriented with my VRef issue