question

pwfarnell avatar image
pwfarnell asked

VRM BUG - extra blank lines in spreadsheet data download on the hour every hour

If I get a data download, in this example I had "Yesterday" as the time in VRM and I have 1 minute data logging from the Cerbo, the data logging was at 37 seconds past the minute. However, the Excel file from VRM has an extra blank line put in once every hour on the hour. This is a bit superfluous and causes issues with some graphing / data analysis. An example extract from the file is given below but this is repeated for every hour.

timestamp Battery Monitor [277] Battery Monitor [277] Battery Monitor [277] Battery Monitor [277] Battery Monitor [277] Battery Monitor [277]
Europe/London (+00:00) Voltage Starter battery voltage Current Consumed Amphours State of charge Time to go

V V A Ah % h
2023-11-15 00:53:37 12.82 12.64 -0.9 -9.2 99.2 240
2023-11-15 00:54:37 12.82 12.64 -1 -9.2 99.2 240
2023-11-15 00:55:37 12.82 12.64 -1 -9.2 99.2 240
2023-11-15 00:56:37 12.82 12.64 -1 -9.2 99.2 240
2023-11-15 00:57:37 12.82 12.64 -1 -9.2 99.2 240
2023-11-15 00:58:37 12.82 12.64 -1 -9.3 99.2 240
2023-11-15 00:59:37 12.82 12.64 -1 -9.3 99.2 240
2023-11-15 01:00:00





2023-11-15 01:00:37 12.82 12.64 -1 -9.3 99.2 240
2023-11-15 01:01:38 12.82 12.64 -1 -9.3 99.1 240
2023-11-15 01:02:37 12.82 12.64 -1 -9.3 99.1 240
2023-11-15 01:03:37 12.82 12.64 -1 -9.3 99.1 240
2023-11-15 01:04:37 12.82 12.64 -1 -9.4 99.1 240
2023-11-15 01:05:37 12.82 12.64 -1 -9.4 99.1 240
2023-11-15 01:06:38 12.82 12.64 -1 -9.4 99.1 240
2023-11-15 01:07:37 12.82 12.64 -1 -9.4 99.1 240
VRMvrm bug
1 comment
2 |3000

Up to 8 attachments (including images) can be used with a maximum of 190.8 MiB each and 286.6 MiB total.

kevgermany avatar image kevgermany ♦♦ commented ·
I think this is one for the VRM team, via @Guy Stewart (Victron Community Manager)
0 Likes 0 ·
1 Answer
Guy Stewart (Victron Community Manager) avatar image
Guy Stewart (Victron Community Manager) answered ·

Thanks for reporting this @pwfarnell,

I've asked the team to fix it.

2 |3000

Up to 8 attachments (including images) can be used with a maximum of 190.8 MiB each and 286.6 MiB total.

Related Resources