How to check measured power values in *.csv file

[nepozs]

Just open it in any text editor capable of editing large linux text files or import it to spreadsheet.

Software examples:

• text editor
  https://notepad-plus-plus.org/ (Windows)
• IDE (containing editor and other useable software)
  https://code.visualstudio.com/ (any popular platform)
• spreadsheet
  https://www.libreoffice.org/ (any popular platform)

1. In the last column should not be any zero values.

Example of BAD file:

1,2001,161,0.0
1,2001,171,0.0
1,2001,181,0.0
1,2001,191,0.0
1,2001,201,0.0

Example of GOOD file:

1,2001,161,1.14
1,2001,171,1.15
1,2001,181,1.15
1,2001,191,1.15
1,2001,201,1.15

examples above are fragments from hs.csv file (in case color temp mode or brightness mode there will be less columns).

Next rule

2. Any power value should NOT be lower than measured standby_power but in reality many smart-plugs could not measure power values less than 0.5W so it is best do do this additional measure using multimeter (using I~ mode and multiply measured current by voltage or using P~ mode but it is uncommon) - this is intended only for experienced users (danger of electrocution!).

   If there is no ability to measure stanby power we can assume it is 0.4W for many typical Zigbee bulb from older generations.
   It is really impossible to be zero (even last generations have standby power draw order of magnitude 0.2W)

[bramstroker]

I think we should create a few pages on the wiki for content like this. That would also be the place for other measurement manuals / tips / FAQ etc, so we can help beginners to set it up.
Will see if I can give you contributer rights

[bramstroker]

I don't think you need any additional rights to create WIKI pages.

[bramstroker]

Btw I have made a first start with wiki for measurements. https://github.com/bramstroker/homeassistant-powercalc/wiki/Contributing-new-lights