Max power measurement over a long period

I’m going to be adding another circuit to my home breaker box for an EV charger. I think I may not be able to do this with the normal NEC calc, but they have a method using existing loads (220.87).

  • I need maximum demand over a 1 year period. By the time I get around to doing this I’ll have a years worth of data.
    OR
  • the highest average kW reached and maintained for a 15 minute interval over a 30 day period.
    How can I extract this? It looks like using the graph interface would be cumbersome since the data sample period is greater than 15 min when the sample range is stretched out. It could be done this way, but would take a lot of mouse clicks.
    Can it be done with the Query API? Should I limit the size of the query? If so what is a reasonable number of data items, or time period?

I would setup Influxdb and export your data there. Once there, you can do complex queries that should get you the data you seek.

My normal daily peak is about 45A, and over the last 6 months it was about 69A. Those are generally for only 2-3min, since both pumps have to be running at the same time. The 6 month query takes 30-40s of compute time on an i7 (mobile running at 2GHz or so). Getting 6 months of stored data from IotaWatt to influxdb takes several days.

Use the latest InfluxDB (1.8 version, not 2.0) and latest Grafana (to allow using Flux query language).

This is one of those one-off things that is easier to just grunt through. Turns out it’s pretty easy.

You need to look at the 15 minute averages over 30 days. That’s 4 x 24 x 30 data points = 2,880. You can use query to extract that in about 8 seconds. You can just type this url into your browser:

http://iotahome.local/query?select=[time.local.iso,total_power]&begin=d-30d&end=d&group=15m&format=csv&limit=3000&download=yes

It will prompt to open or save, I saved it, opened it with a spreadsheet and entered a max() function for the average Watts column:

image

So my maximum Watts over a 15 minute period for the last 30 days was 9,700. Sorting descending I get the top ten:
image

You will need to be on release 02_05_12 to be able to set a high enough output line limit.p

1 Like

Thanks,
Can a query interfere with iotawatt’s normal operations?

Yes, it does not sample while doing a query, so keep it short. 8 seconds Is not a problem.