Open PicoLog 6 with your CM3 data displayed.
Go to the table view and configure it as below, you need to set- Time format to - "Hours, minutes and seconds from start"
Click on the "Ave." button just to export average values (all others should unchecked)
Set the output sample rate as required, I suggest for long time periods using 1 minute or greater.
In the table view set all channel units to "A" Amps.
Export to to csv
Export button -> Export CSV -> choose a file name location, click save
Open the attached spreadsheet, click on the "Import data" sheet at the bottom.
click in cell A1
Open the csv file you just exported from Picolog 6.
Press Ctrl-A (select all), then Ctrl-C (copy)
Switch to the other spreadsheet, Press Ctrl-V (paste) to paste data into the "Import data" sheet
click on the "kWh results" sheet at the bottom, to see the results.
Note I have only pasted formulas down to about row ~20000, so if you more data exported then you would need to fill more rows as required.
Excel is also limited to 1 million rows.
Enter your cost of energy for KW/h in green cell L3, if needed.
Change the voltage if required. (UK is 230 volts tolerance of -6% to +10%, which gives an allowable voltage range of 216 V to 253 V)
Note- The CM3 is not able to give phase angle or power factor data, so above only gives Apparent Power Pz (VA) for the Z currents given.
CM3 kWh cals.xlsx - https://docs.google.com/spreadsheets/d/ ... ue&sd=true Also see-
https://www.wikihow.com/Integrate-Large ... s-in-Excel
Very interesting, Im unable to download the excell sheet? its telling me im not authorised.
Can anyone help please, before i start creating my own