USERGUIDEFORIECTR61000-4-37SUPPORTSPREADSHEET Foreword This user guide provides instructions how to use the support spreadsheet that is made available as an essential supplement with IEC TR 61000-4-37. The IEC and the spreadsheet author disclaim liability for any personal injury, property or any other indirectly resulting from this software and the document upon which its methods are based, use of, or relianceupon The spreadsheet and this user guide are provided free of charge, and free of copyrights. The spreadsheet is created using Microsoft Office, but canbe opened andthe calculations canbe and Windows-8, but should also function correctly in the Android operating system. Mathieu van den Bergh is assigned within IEC/SC77A/WG-1 as the person to support the spreadsheet and this user guide. bedownloadedfrom www.cnspoway.com Mathieu van den Bergh July 2015 [email protected] Functionsofthesupportspreadsheet Introduction The IEC TR 61000-4-37 technical report specifies a method to generate known power parameters and current harmonics,usingasetof resistive linearandphase controlled loads that arecontrolledviapower electronic circuits.In essence, the current flow through the controlled resistive loads is turned on"and "off"atuserdefinedphaseangles.Throughpowercalculations andFourieranalysis,onecancalculateall parameters with very high precision, provided the load values, the current conduction angles, and the applied voltage are known. The load values may vary slightly,due to component tolerances. Also, thepower source used in harmonic emission test systems may have small variations in voltage, or the system may be utilized at nominal 22o Volt instead of nominal23oVolt.Therefore,the spreadsheetallowsfor resistive load values, selected setting should be. Thus, the user enters the values for linear load, controlled load, system voltage, and the start/stop phase angles in degrees, and the spreadsheet produces the“Calculated parameters" in cells F10 through F19, as well as the current harmonics in cells M2 -M41. In addition, the spreadsheet computes the permitted Also, the spreadsheet has individual sheets for each of the test classes in IEC 61000-3-2. In these individual sheets the"ideal"harmonic levels are compared against the limits for the specific test class, and the percentage of limits is indicated, as well as the PASS/FAIL status for each harmonic order. test systemmeasurement with the“ideal"values.The following pages show several examples howto enter and evaluate the values for some of the tests that are specified in IEC TR 61000-4-37. M N 0 Analysis for IEC6 p00.-4.7 & IEC61000.3-2/12 Harmonics Calibration & Verification protocol TR 6100-4.37 Harm.No. Max 0.000 Toleranc 0.0000 0.013 hange the Load resistance(s) and Start.Stop Phase as desired, then wait for the re-computation 0.9150 0.869 8560 0.0000 0.000 0.013 Calculated parameters 0.3050 0.290 0.320 Linear load value: 200000.00hm Linear Load resistnc: 200000.0 0hm 0.0000 0.000 0.013 8 Contr.Load value 80.00Ohm Contr.Load reslstnc: 80.00hm 05050 062:0 0.319 System voltage 230.00V-rms 230.00 v-rms 0.0000 0.000 0.013 System voltage 10 Volt-pk 325.27 V.pk Volt-pk 0.1830 9610 325.27 V-pl Pw 541.29 Watts 0.0000 0.000 0.013 VA 598.31 11 0.1830 0.170 0.196 0.905 0.0000 0.000 0.013 1-Cr.Fact 1.563 0.1308 BLLO LO 1.THD 46.3% 0.0000 0.000 0.013 1- THC 1.089 0.1307 0.118 0.144 POHC 0.785398163 2.35619449≤. 0.204 0. 000 0.013 current 2.601 A-rms 0.1017 0.089 0.115 Amp-pk 4.067 A-pk 0.0000 000°0 0.013 0.1017 680-0 0.115 Start Phase Stop Phase 0.0000 000 0.013 135 0.0833 020'0 0.096 45 Degree 22 0.0000 0.000 CLOO Voltage (red) an Spectrum (blue) & Clas8-A Limits (red) 0.0832 0.070 0.096 4.00 2.50 0.0000 0.000 0.0705 0.058 0.083 0.0000 0.000 0.013 850'0 c80'0 0.0000 0.000 0.0611 8t0.0 0. 000 0.0611 4.00 0.0000 0.000 -400 0.0539 0.000 0.013 0.0539 0.041 0.067 A-rm Enteringthevaluesfortest1ofIECTR61000-4-37 Test no. 1 of IEC TR 61000-4-37 calls for a controlled load value of 80 Q that i