question

johng avatar image
johng asked

Is there any documentation of the parameters provided in the csv download from the Advance dashboard related to my system?

I have downloaded the csv reports from my neighbours system via the Vitron portal. I have searched for documentation on each of the fields but not found anything and hoping that someone could help.

For example looking at VE.Bus System [0] and Input phase 1 I would expect Power to be equal to Current multiplied by Voltage. The latter VI calculation fluctuated wildly where Power is relatively well behaved. I suspect that the Current is simply an instantaneous value where Power is averaged.

I am working on evaluating different Tariffs from our local municipality who have now introduced Time of Use (TOU) Tariffs on top of the normal energy tariffs. The municipality is encouraging the TOU tariffs which better reflect their costs.

A possible Win-Win for User and municipality.

Thanks, John

VRM
2 |3000

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

4 Answers
Guy Stewart (Victron Community Manager) avatar image
Guy Stewart (Victron Community Manager) answered ·

Given your use case of analysing energy consumption at different times of day, have you tried working with the kWh download?

I think it will be more useful to you.

cleanshot-2020-11-12-at-191442.jpg



cleanshot-2020-11-12-at-191842.jpg


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.

Hi Guy,

Thanks for the quick answer. I think you are 100% correct. I was not sure what the difference was between the different csv files.

I have a slight logistical problem as the download link goes to my neighbours email and he does not always notice in time to download and forward. That is why I only got the one report so far.

So you've answered the immediate question, but is there any documentation for the download fields?

0 Likes 0 ·
Guy Stewart (Victron Community Manager) avatar image
Guy Stewart (Victron Community Manager) answered ·

There is not extensive or specific documentation for the advanced download, as far as I know.

Regarding Current, Voltage and Power, for AC, the relationship is not as easy as P = IV. There is another component called power factor which introduces reactive power, as compared to real power.

There is more information in Chapter 6 - AC Wiring in Margreet's Wiring Unlimited - https://www.victronenergy.com/upload/documents/Wiring-Unlimited-EN.pdf



Are there any others you would you like further info on?

timestamp

Gateway VRM Log time offset

Gateway ESS Scheduled Charging

Gateway Relay 1 state

Gateway Generator run reason

Gateway CCGX Relay 2 state

VE.Bus System Phase rotation

VE.Bus System Input voltage phase 1

VE.Bus System Input current phase 1

VE.Bus System Input frequency 1

VE.Bus System Input power 1

VE.Bus System Output voltage phase 1

VE.Bus System Output current phase 1

VE.Bus System Output frequency

VE.Bus System Output power 1

VE.Bus System Voltage

VE.Bus System Current

VE.Bus System Battery temperature

VE.Bus System Active input

VE.Bus System Active input current limit

VE.Bus System VE.Bus state

VE.Bus System VE.Bus Error

VE.Bus System Switch Position

VE.Bus System Temperature

VE.Bus System Low battery

VE.Bus System Overload

VE.Bus System Temperatur sensor alarm

VE.Bus System Voltage sensor alarm

VE.Bus System High DC Ripple

VE.Bus System Temperature L1

VE.Bus System Low battery L1

VE.Bus System Overload L1

VE.Bus System High DC Ripple L1

VE.Bus System Temperature L2

VE.Bus System Low battery L2

VE.Bus System Overload L2

VE.Bus System High DC Ripple L2

VE.Bus System Temperature L3

VE.Bus System Low battery L3

VE.Bus System Overload L3

VE.Bus System High DC Ripple L3

VE.Bus System Charge state

Battery Monitor Voltage

Battery Monitor Current

Battery Monitor Battery temperature

Battery Monitor State of charge

Battery Monitor State of health

Battery Monitor CVL - Charge Voltage Limit

Battery Monitor DVL - Discharge Voltage Limit

Battery Monitor CCL - Charge Current Limit

Battery Monitor DCL - Discharge Current Limit

Battery Monitor Discharged Energy

Battery Monitor System; minimum cell voltage

Battery Monitor System; maximum cell voltage

Solar Charger Voltage

Solar Charger Current

Solar Charger Battery watts

Solar Charger Battery temperature

Solar Charger Charger on/off

Solar Charger Charge state

Solar Charger PV power

Solar Charger Relay on the charger

Solar Charger Low batt. voltage alarm

Solar Charger High batt. voltage alarm

Solar Charger Yield today

Solar Charger Maximum charge power today

Solar Charger Yield yesterday

Solar Charger Maximum charge power yesterday

Solar Charger Error code

Solar Charger User yield

Solar Charger Voltage

Solar Charger Current

Solar Charger Battery watts

Solar Charger Battery temperature

Solar Charger Charger on/off

Solar Charger Charge state

Solar Charger PV voltage

Solar Charger PV current

Solar Charger PV power

Solar Charger Relay on the charger

Solar Charger Low batt. voltage alarm

Solar Charger High batt. voltage alarm

Solar Charger Yield today

Solar Charger Maximum charge power today

Solar Charger Yield yesterday

Solar Charger Maximum charge power yesterday

Solar Charger Error code

Solar Charger User yield

Tank [20]Tank status

System overview AC-Input

System overview PV - AC-coupled on input L1

System overview PV - DC-coupled

System overview AC Consumption L1

System overview Grid L1

System overview Voltage

System overview #1 Low SOC; discharge disabled

System overview #2 BatteryLife is active

System overview #3 Charge disabled by BMS

System overview #4 Discharge disabled by BMS

System overview #5 Slow charge is active

System overview #6 Charge disabled by user setting

System overview #7 Discharge disabled by user setting

System overview Current

System overview VE.Bus charge current

System overview Battery Power

System overview VE.Bus charge power

System overview Battery State of Charge

System overview Battery state

System overview DVCC Multiple batteries alarm

System overview DVCC Firmware insufficient alarm

System overview Grid alarm

PV Inverter L1 Voltage

PV Inverter L1 Current

PV Inverter L1 Power

PV Inverter L1 Energy

PV Inverter Error

Grid meter Grid L1 - Power

Generator start/stop Generator not detected at AC-input

Temperature sensor Temperature

Temperature sensor Temperature status

2 |3000

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

johng avatar image
johng answered ·

Thanks again Guy,

I have now managed to get the kWh download.

Time steps are every 15 minutes, I presume the kWh are for the previous 15 minutes.. Can anyone confirm?

I would also like to know how to work out total kWh to Grid and kWh from Grid as they are metered at different rates.

My assumption is:

kWh to Grid = PV to grid + Battery to grid
kWh from Grid = Grid to battery + Grid to consumers

Can anyone confirm?

Thanks again,


The list of headers are as follows:

timestamp (TimeZone details)

Solar Yield (delta) (kWh)

Grid to battery (kWh)

Grid to consumers (kWh)

PV to battery (kWh)

PV to grid (kWh)

PV to consumers (kWh)

Battery to consumers (kWh)

Battery to grid (kWh)

Genset to consumers (kWh)

Genset to battery (kWh)

Gas (m3)

2 |3000

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

johng avatar image
johng answered ·

I did some checking against the portal and the kWh are actually for the subsequent 15v minutes as shown under period above.

We'll get this documented by hook or crook :-)

2 |3000

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