Description of table DayData columns

Topics: 5. Support
Nov 6, 2016 at 9:12 PM
Edited Nov 6, 2016 at 9:13 PM
Hello everyone,
i doesn't understand the meaning of the values in column Power in the DayData Table.
Can someone describe the meaning of the column? Thank you in advance!

Image
https://www.imagebanana.com/view/2fy2o7oj/2016110623_06_09MySQLWorkbench.jpg
Greetings,
Derret
Nov 7, 2016 at 7:36 PM
sbfspot does follow the formats and values as in use bij SMA (sunny explorer)
so SBFspot uses (produces) the tables with same format and contents

in reply to your question:
  • the column with date-time corresponds to the "own-day-time-stamp" of the inverter
    this is important in the case that the internal clock of your inverter deviates from your computer
  • the software of your inverter will take each 5 minutes a snapshot of the value for "total-yield" <- second column
    and store this value in the "daily-table"
  • the "power" value is a calculated value (by the inverter)
    "power == ( "curr-total-yield" minus "previous-total-yield" ) multiplied with 12
    so -> power is the delta of the yield (in kWh) averaged over the previous 5 minute period (1hour to 5minutes = 12)
  • that "average" power is expressed in kW
  • as a result of being calculated -> you will notice that:
    -- its value is allways a multiple of 0,012
    -- unreliable values at sunrise or sunset
kind regards wim