I am kind of confused by the values shown on the graph in Cloud vs CSV/API output.
In this case, I've selected 26.03.2025 19:00-26.03.2025 20:00.
Cloud - total power consumption 0.28574 kWh
CSV/API - total power consumption 155408-139120=16288/100000=0.16288 kWh
No matter what I try, I can't get to the same result as in the Cloud.
How do I calculate the total power consumption from the values in CSV/API?
What if the API returns only just one row, how do I get the total power consumption then?
JSON data from REST API
Code: Select all
[
{
"date_timestamp": 1743012107,
"phase1_fae": 10246,
"phase1_rae": null,
"phase1_fre": null,
"phase1_rre": 4020,
"phase2_fae": 122636,
"phase2_rae": null,
"phase2_fre": null,
"phase2_rre": 11418,
"phase3_fae": 6238,
"phase3_rae": null,
"phase3_fre": null,
"phase3_rre": 18144,
"fae_balanced": 139120,
"rae_balanced": null
},
{
"date_timestamp": 1743012708,
"phase1_fae": 10982,
"phase1_rae": null,
"phase1_fre": null,
"phase1_rre": 4714,
"phase2_fae": 123912,
"phase2_rae": null,
"phase2_fre": null,
"phase2_rre": 12750,
"phase3_fae": 7342,
"phase3_rae": null,
"phase3_fre": null,
"phase3_rre": 20760,
"fae_balanced": 142236,
"rae_balanced": null
},
{
"date_timestamp": 1743013729,
"phase1_fae": 11836,
"phase1_rae": null,
"phase1_fre": null,
"phase1_rre": 5808,
"phase2_fae": 125948,
"phase2_rae": null,
"phase2_fre": null,
"phase2_rre": 14956,
"phase3_fae": 9120,
"phase3_rae": null,
"phase3_fre": null,
"phase3_rre": 25118,
"fae_balanced": 146904,
"rae_balanced": null
},
{
"date_timestamp": 1743014329,
"phase1_fae": 12284,
"phase1_rae": null,
"phase1_fre": null,
"phase1_rre": 6426,
"phase2_fae": 127132,
"phase2_rae": null,
"phase2_fre": null,
"phase2_rre": 16276,
"phase3_fae": 10178,
"phase3_rae": null,
"phase3_fre": null,
"phase3_rre": 27696,
"fae_balanced": 149594,
"rae_balanced": null
},
{
"date_timestamp": 1743014929,
"phase1_fae": 12432,
"phase1_rae": null,
"phase1_fre": null,
"phase1_rre": 6946,
"phase2_fae": 128520,
"phase2_rae": null,
"phase2_fre": null,
"phase2_rre": 17836,
"phase3_fae": 11566,
"phase3_rae": null,
"phase3_fre": null,
"phase3_rre": 30392,
"fae_balanced": 152518,
"rae_balanced": null
},
{
"date_timestamp": 1743015530,
"phase1_fae": 12486,
"phase1_rae": null,
"phase1_fre": null,
"phase1_rre": 7436,
"phase2_fae": 129764,
"phase2_rae": null,
"phase2_fre": null,
"phase2_rre": 19326,
"phase3_fae": 13158,
"phase3_rae": null,
"phase3_fre": null,
"phase3_rre": 33178,
"fae_balanced": 155408,
"rae_balanced": null
}
]
Code: Select all
Timestamp;Date and time;Phase 1 Forward active Energy kWh;Phase 1 Reverse active Energy kWh;Phase 1 Forward reactive Energy kvarh;Phase 1 Reverse reactive Energy kvarh;Phase 2 Forward active Energy kWh;Phase 2 Reverse active Energy kWh;Phase 2 Forward reactive Energy kvarh;Phase 2 Reverse reactive Energy kvarh;Phase 3 Forward active Energy kWh;Phase 3 Reverse active Energy kWh;Phase 3 Forward reactive Energy kvarh;Phase 3 Reverse reactive Energy kvarh;Forward active Energy kWh - total;Reverse active Energy kWh - total;Active Energy kWh - Arithmetic balance;Forward active Energy kWh - Vector balance;Reverse active Energy kWh - Vector balance
1743012107;2025-03-26 19:01:47;0.10246;;;0.0402;1.22636;;;0.11418;0.06238;;;0.18144;1.3912;0;1.3912;1.3912;
1743012708;2025-03-26 19:11:48;0.10982;;;0.04714;1.23912;;;0.1275;0.07342;;;0.2076;1.42236;0;1.42236;1.42236;
1743013729;2025-03-26 19:28:49;0.11836;;;0.05808;1.25948;;;0.14956;0.0912;;;0.25118;1.46904;0;1.46904;1.46904;
1743014329;2025-03-26 19:38:49;0.12284;;;0.06426;1.27132;;;0.16276;0.10178;;;0.27696;1.49594;0;1.49594;1.49594;
1743014929;2025-03-26 19:48:49;0.12432;;;0.06946;1.2852;;;0.17836;0.11566;;;0.30392;1.52518;0;1.52518;1.52518;
1743015530;2025-03-26 19:58:50;0.12486;;;0.07436;1.29764;;;0.19326;0.13158;;;0.33178;1.55408;0;1.55408;1.55408;