Adding custom_data - csv file format for numbers

[digoben]

I have finally successfully added Lidl HG06492C bulb to custom_data directory in my HA.
It may be worth noting that it is important what numeric format is used in HA as I struggled a bit with csv formats. Initially both brightness and color_temp csv files contained wattage in the format "1,31". The files opened fine in LibreOffice Calc, but powercalc didn't add power and energy sensors to the bulb (although adding finished with success message).
When I changed the numeric format to 1.31 it worked as expected.

I'm not sure if this is specific to my setup, but it may be worth noting.

[bramstroker]

comma is the default delimiter in CSV (comma separated values). So that means when you use comma as decimal point it will be seen as a new column in the CSV file, so that will obviously break the power calculation as there are more columns than expected.

I have added a note here: https://github.com/bramstroker/homeassistant-powercalc/blob/master/README.md#expected-file-structure

Any reason why you are not contributing the file to the powercalc library so others can also use it?