Analyse van in- en export energie via CSV-> Excel

[hwitteveen]

Mijn vraag
Ik wil mogelijk een accu kopen en ben aan het stoeien met HA om mijn energielevering en terug levering in beeld te krijgen via HA.
Ik maak van het tabblad 'energie overzicht' een export van de data en importeer deze in Excel.
Omzetten van CSV van tekst naar kolommen en zo.

Echter van de data kan ik geen chocolade maken.
Als ik 1 dag selecteer in HA en dat exporteer kom ik op geen enkele manier op de gegevens die HA in het energie overzicht zichtbaar maakt met die 3 bollen. ( opgewekt, ge-ex-en im-porteerd, en thuis gebruik).

Dus als ik de totalen maak van de regels (Excel) dan kom ik geen enkele manier op de totaal data van HA.

Heb het bestand even meegestuurd. De gele markering is een data sprong die door mij niet te verklaren is. Dat is van 6 uur naar 7 en van 7 naar 8 uur. Dan komt de zon en gaat er terug geleverd worden.


Ik zou nl willen weten per dag wat ik terug lever aan het net en wat ik uit het net opneem. Vooral die laatste geeft mogelijk een idee van wat voor een accu (qua omvang) ik wil aanschaffen.

[itsme]

Je deelt nu een screenshot van de data zoals die nu in excel staat, ik denk dat vooral interessant is hoe de data er in de CSV uit ziet. Open de CSV eens in bijvoorbeeld notepad.

[hwitteveen]

entity_id,type,unit,2025-06-24T22:00:00.000Z,2025-06-24T23:00:00.000Z,2025-06-25T00:00:00.000Z,2025-06-25T01:00:00.000Z,2025-06-25T02:00:00.000Z,2025-06-25T03:00:00.000Z,2025-06-25T04:00:00.000Z,2025-06-25T05:00:00.000Z,2025-06-25T06:00:00.000Z,2025-06-25T07:00:00.000Z,2025-06-25T08:00:00.000Z,2025-06-25T09:00:00.000Z,2025-06-25T10:00:00.000Z,2025-06-25T11:00:00.000Z,2025-06-25T12:00:00.000Z,2025-06-25T13:00:00.000Z,2025-06-25T14:00:00.000Z,2025-06-25T15:00:00.000Z,2025-06-25T16:00:00.000Z,2025-06-25T17:00:00.000Z,2025-06-25T18:00:00.000Z,2025-06-25T19:00:00.000Z,2025-06-25T20:00:00.000Z,2025-06-25T21:00:00.000Z
sensor.p1_meter_energy_import_tariff_2,grid_consumption,kWh,0,0,0,0,0,0,0,0,0.3650000000000091,0.041999999999916326,0,0,0,0,0,0,0,0,0.014000000000123691,0.06600000000003092,0.27099999999995816,0.22000000000002728,0.3170000000000073,0.0009999999999763531
sensor.p1_meter_energy_import_tariff_1,grid_consumption,kWh,0.12800000000015643,0.10599999999999454,0.13599999999996726,0.10500000000001819,0.125,0.1069999999999709,0.0039999999999054126,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.2719999999999345
sensor.p1_meter_energy_export_tariff_1,grid_return,kWh,0,0,0,0,0,0,0.28300000000012915,0.0009999999999763531,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
sensor.p1_meter_energy_export_tariff_2,grid_return,kWh,0,0,0,0,0,0,0,0.9859999999998763,0.55600000000004,1.4429999999997563,1.4400000000000546,1.7220000000002074,2.2839999999996508,2.34900000000016,2.8220000000001164,2.6599999999998545,2.64200000000028,1.9639999999999418,1.3769999999999527,0.5989999999997053,0.1000000000003638,0,0,0
sensor.mlg0a2401h_energie_opgewekt_vandaag,solar_production,kWh,0,0,0,0,0,0,0,0.09999999999990905,0.29999999999972715,0.3999999999996362,0.49999999999954525,0.6999999999995907,0.7999999999997272,1,1.2000000000000455,1.400000000000091,1.699999999999818,1.699999999999818,1.599999999999909,0.900000000000091,0.29999999999972715,0.09999999999990905,0,0
sensor.wrg0bge0c0_energie_opgewekt_vandaag_ingang_1,solar_production,kWh,0,0,0,0,0,0,0.10000000000002274,0.5000000000001137,0.5000000000001137,0.6000000000001364,0.5000000000001137,0.5000000000001137,0.6000000000001364,0.7000000000001592,0.7000000000001592,0.6000000000001364,0.3000000000000682,0.20000000000004547,0.10000000000002274,0.10000000000002274,0.10000000000002274,0,0,0
sensor.wrg0bge0c0_energie_opgewekt_vandaag_ingang_2,solar_production,kWh,0,0,0,0,0,0,0.09999999999990905,0.49999999999954525,0.7999999999997272,0.7999999999997272,0.6999999999995907,0.6999999999995907,1,0.8999999999998636,1,0.8999999999998636,0.7999999999997272,0.3999999999996362,0.1999999999998181,0.09999999999990905,0.09999999999990905,0,0,0
sensor.evse_192_168_2_34_energie_geladen,device_consumption,kWh,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
sensor.stekker_4_helper_laptop,device_consumption,kWh,0,0,0,0,0,0,0,0.09999999999999964,0,0,0.09999999999999964,0,0,0,0,0.10000000000000142,0,0,0,0,0,0,0,0.09999999999999964
sensor.helper_warmtepomp,device_consumption,kWh,0,0,0,0,0,0,0,0,0,0.09999999999999787,0,0,0,0,0,0,0,0,0,0,0,0,0.10000000000000142,0
sensor.stekker_3_helper_tv_en_zo,device_consumption,kWh,0,0,0,0,0,0,0,0,0,0.10000000000000142,0,0,0,0,0,0,0,0,0.10000000000000142,0,0.09999999999999432,0.20000000000000284,0.10000000000000142,0.19999999999999574
sensor.stekker_6_helper,device_consumption,kWh,0.00972490128527781,0.009902279704694372,0.009914259440249928,0.009913851931500073,0.004963640123750057,0.009914005326499886,0.010008417771194544,0.010019739881333312,0.009961176205583122,0.009969989304847271,0.010002451979416627,0.01011415353680567,0.010161056988000183,0.010214643984166383,0.009992932500819673,0.00980813999719432,0.009913865246999887,0.009913555302750066,0.009914438888749988,0.00991387100550023,0.009869349213735834,0.00985850272676414,0.009960865120958395,0.014504220151916325
sensor.stekker_7_helper,device_consumption,kWh,0,0,0,0,0,0,0,0,0.5905616847189918,0.008139068272996042,0.029816044002998865,0.047167840081002055,0.01567451595499847,0.01740278309800658,0.006053289285006258,0.025039376361988275,0,0.16549273016300958,0,0,0,0,0,0
sensor.koelk_en_afwasmachine_helper_stekker_1,device_consumption,kWh,0.028695422799557946,0.010840404808000415,0.03564498591312315,0.0002643660959975591,0.03741395294400007,6.072257008327142e-8,0.032928156359588456,0.02849617982638364,0.00466651348438063,0.04246558427999503,1.113719605427832e-8,0.037284642330249085,0.028472265718725964,0.00530098630171949,0.03484425101138555,5.784178114254246e-8,0.03568271886880581,0.01343980271316525,0.05767720227188988,0,0.03672893526198351,3.0137861983803305e-8,0.0513607250174033,0.021268690443889682
sensor.helper_stekker_5,device_consumption,kWh,0.01797098759750071,0.01784459649905301,0.017701300640247553,0.017785924328464375,0.01797214270930425,0.017901242727390354,0.01790144428635898,0.017958232328140866,0.01804463261235867,0.017913862997495755,0.01804521785194879,0.017888550027194583,0.017728403390499636,0.018070558209664966,0.01794498442119874,0.017813981530494516,0.017860632820003275,0.01751976389631693,0.01780748397587928,0.017844760492110368,0.01770760270384386,0.01780724352882146,0.01790135850060892,0.01790002851858219