Solar exported kwh values in excel data download
Hi,
i'm hoping to work out my export data to guage the appropriate solar battery size I need to add to my 4kWh solar panel sytem.
The below 30 minute download data shows the kWh values which matches the values in the Bright app graph, except where the Bright app shows a negative value for export kWh, in the download it shows 65.??
is there a way to convert the 65.?? value to the -kWh exported value in the spreadsheet data?
(Previous days' export values (not shown below) are zeroed in the data download -Glowmarkt advised this is due to the Glow IHD display stored data being overwritten overnight by the meter data)
17/10/2023 06:00 0.18 ........ app shows consumption 0.18 kWh
17/10/2023 06:30 0.171....... ""
17/10/2023 07:00 0.24..........""
17/10/2023 07:30 65.512...........app shows consumption -0.02 kWh
17/10/2023 08:00 0.059........""
17/10/2023 08:30 65.456........ -0.08
17/10/2023 09:00 65.383....... -0.15
17/10/2023 09:30 65.379....... -0.15
17/10/2023 10:00 65.443...... -0.09
17/10/2023 10:30 0.39.......""
Comments
subtracting the 65.?? values on the glowmarkt website download data from the constant 65.5365 gives the correct exported value shown in the Bright app => QED 😁
65.512 ...65.5365-65.512 =0.0245
65.456 ...65.5365-65.456 =0.0805
65.383 ...65.5365-65.383 =0.1535
65.379 ...65.5365-65.379 =0.1575
65.443 ...65.5365-65.443 =0.0935