How to read the exported CSV file

  • Hi, I am having trouble reading the CSV file exported from the web interface of the Shelly 3EM smart meter. First of all, how do I calculate energy consumption for one day? I converted the .csv to .xlsx but for some days I saw readings of the consumption for each minute of the day but for other days the readings are for 10 minutes period. Also some of the days are not in the chronological order which is very strange. I don't understand how the energy for one reading is calculated, because some of the values are bigger than what I expect. I saw for example 40 kWh at one moment of the day, but even if I power on all my consumers in the house in the same time I will not come even closer of half of that number. My maxim approved power for the house is 9kW three-phase installation. I attached my latest csv file if someone wants to take a look and advice me. Their support couldn't articulate a clear answer on this :(. Thanks in advance!

  • I haven't a 3em so I have to ask, is this for only one of the 3 measuring?

    When I look at your csv end I can see this

    2021-04-28 23:56,5.70,0.00
    2021-04-28 23:57,5.81,0.00
    2021-04-28 23:58,6.09,0.00
    2021-04-28 23:59,6.09,0.00

    first, I think there was a changing because between the 20 and 28 is nothing and now is every minute an entry.

    The second what I can see you have in this 4 minutes a usage from 23,69 Watt

    As example from my dimmer (safe every hour)

    "2021-04-30 18:00:00","0.41"
    "2021-04-30 19:00:00","10.93"
    "2021-04-30 20:00:00","0.26"

    And this are watts.

  • The file shows the total consumption for all three phases. The inputs are not consistent and I don't know if I can count on these readings.