Iotawatt negative solar output

tahrenholtz · February 15, 2020, 6:19pm

Continuing the discussion from PVoutput Trouble:

It appears that I’m having the same issue getting my data to work from Iotawatt to PVoutput. Is the negative data at night only an issue with the solar output? and only at night or is this an issue with all data. For example does daily time usage always need to remain positive?

My system shows negative power use when I produce more than I use.

2020-02-14 15:00:00, 422.4, 56.4
2020-02-14 16:00:00, 217.3, 390.6
2020-02-14 17:00:00, 23.7, 599.7
2020-02-14 18:00:00, 5.2, 175.6
2020-02-14 19:00:00, 5.2, 511.1
2020-02-14 20:00:00, 5.1, 511.3
2020-02-14 21:00:00, 5.2, 382.3
2020-02-14 22:00:00, 5.1, 480.2
2020-02-14 23:00:00, 5.1, 549.0
2020-02-15 00:00:00, 5.1, 488.6
2020-02-15 01:00:00, 5.1, 592.4
2020-02-15 02:00:00, 5.1, 436.9
2020-02-15 03:00:00, 5.1, 570.0
2020-02-15 04:00:00, 5.1, 507.0
2020-02-15 05:00:00, 5.1, 592.5
2020-02-15 06:00:00, 5.0, 573.5
2020-02-15 07:00:00, 24.9, 915.6
2020-02-15 08:00:00, 268.8, 424.3
2020-02-15 09:00:00, 1058.1, -789.9
2020-02-15 10:00:00, 2545.1, -2329.1
2020-02-15 11:00:00, 3193.0, -2900.1
2020-02-15 12:00:00, 2855.4, -2223.7

overeasy · February 15, 2020, 8:31pm

Don’t know the context of the question. I can see what looks like a CSV output for what is presumably your mains. It looks right for a PV system, but PVoutput wants generation and consumption both as positive numbers. It considers any excess of generation over consumption to be export.

So while you can’t just send PVoutput the raw mains data, you can specify how to compute what it wants with a simple script. It’s all explained here: PVoutput — IoTaWatt 02_03_20 documentation

tahrenholtz · February 15, 2020, 9:57pm

I think I have the data figured out so that it is a positive. Is there a way to force iotawatt to down load is information again to PVoutput. I have deleted the existing data on PVoutput and am waiting for new data to appear. So far nothing.

overeasy · February 15, 2020, 9:59pm

https://docs.iotawatt.com/en/master/PVoutput.html#reload-history

You may have exceeded the hourly upload quota. Take a look at the message log. If that’s the case, it should start going again about now as it’s just past the hour. Also, look at the PVoutput tab in the status display and see where it’s at.

tahrenholtz · February 15, 2020, 10:01pm

Ok that is what I’m doing. Maybe I’ve bumped up against the PVoutput data limit.

overeasy · February 15, 2020, 10:05pm

You should see that in the message log.

What are you trying to do with the generation script? Any reason why you didn’t go with
(main_1 + main_2 + solar) max 0
as the documentation says?

tahrenholtz · February 15, 2020, 10:07pm

I’m concerned about my time date. I just did a restart and the log is a day off. The the time is correct but its 2/15 not 2/16

** Restart **

SD initialized.
2/15/20 22:04:22z Real Time Clock is running. Unix time 1581804262
2/15/20 22:04:22z Reset reason: Software/System restart
2/15/20 22:04:22z Trace: 8:4, 8:6, 8:8, 8:9, 9:3, 9:5, 9:9, 1:2, 1:3, 1:4, 1:3, 1:4, 1:3, 1:4, 1:3, 1:4, 1:1[6], 1:2[7], 9:0[7], 9:0, 9:1, 8:4, 8:6, 8:8, 8:9, 9:3, 9:5, 9:9, 1:2, 1:3, 10:2, 10:3
2/15/20 22:04:22z ESP8266 ChipID: 6147420
2/15/20 22:04:22z IoTaWatt 5.0, Firmware version 02_05_02
2/15/20 22:04:22z SPIFFS mounted.
2/16/20 04:04:23 Local time zone: +6:00
2/16/20 04:04:23 device name: IotaWatt
2/16/20 04:04:23 MDNS responder started for hostname IotaWatt
2/16/20 04:04:23 LLMNR responder started for hostname IotaWatt
2/16/20 04:04:23 HTTP server started
2/16/20 04:04:23 timeSync: service started.
2/16/20 04:04:23 statService: started.
2/16/20 04:04:23 dataLog: service started.
2/16/20 04:04:23 dataLog: Last log entry 02/16/20 04:04:20
2/16/20 04:04:25 WiFi connected. SSID=CenturyLink0607, IP=192.168.0.63, channel=1, RSSI -70db
2/16/20 04:04:25 Updater: service started. Auto-update class is MINOR
2/16/20 04:04:26 Updater: Auto-update is current for class MINOR.

tahrenholtz · February 15, 2020, 10:10pm

My solar pushes my Main1 + Main2 negative.

tahrenholtz · February 15, 2020, 10:16pm

By the way here is the rest of the restart status.

2/16/20 04:05:23 historyLog: service started.
2/16/20 04:05:23 historyLog: Last log entry 02/16/20 04:04:00
2/16/20 04:05:23 PVoutput: started
2/16/20 04:05:23 PVoutput: System 3901 Skyview, interval 5, donator mode
2/16/20 04:05:23 PVoutput: Reload status beginning 01/18/20 00:05:00
2/16/20 04:07:44 PVoutput: Unrecognized HTTP completion, upload Bad request 400: Moon Powered

overeasy · February 15, 2020, 10:16pm

I understand. The max function will produce the larger of it’s two operands. If the sum of the solar + main1 + main2 is negative, zero will be larger so it will return zero.

Your time zone setting is in Asia, is that where you are?

tahrenholtz · February 15, 2020, 10:19pm

Time Zone 6 = asia?

overeasy · February 15, 2020, 10:20pm

Again, where are you?

tahrenholtz · February 15, 2020, 10:20pm

it should be -6 instead correct

overeasy · February 15, 2020, 10:21pm

Again, where are you?

tahrenholtz · February 15, 2020, 10:21pm

Minneapolis Minnesota

overeasy · February 15, 2020, 10:23pm

You are in the Central Standard Time zone which is UTC-6, so yes, it should be -6 and you should also check the box to allow DST which is coming up in a month or so.

tahrenholtz · February 15, 2020, 10:25pm

Ok that was very helpful. I did just receive the first data set in PVoutput.

tahrenholtz · February 15, 2020, 10:25pm

overeasy · February 15, 2020, 10:27pm

Unless you changed something, there is a problem with the data indicated in the log that you posted. Can you use Graph+ to plot Watts for Main1, Main2 and Solar4 and post that?