© OMICRON 2024 Page 21 of 25
4.4 Evaluation of Measurements
This application note comes with an Excel report spreadsheet, named COMPANO-Template-Cable-
Impedance-Measurement-2023-ENU.xlsm.
Open the file COMPANO-Template-Cable-Impedance-Measurement-2023-ENU.xlsm
Fill the blue fields, including cable length and used measurement frequencies (see Table 1).
Open the COMPANO Excel File loader in Windows Start menu:
Start → OMICRON COMPANO 100 → COMPANO 100 Excel File Loader
Perform the following steps for each of the seven results files (see Table 2).
Select the “Welcome” sheet
Press “Load XML file”
Load the according result file from the USB flash drive. They are stored in the
COMPANO_100_Reports folder.
E.g. L1-L3_COMPANO_100_2023-02-27_11.05.28.499.xml
Select the “FLEX” sheet
Copy the R / X value from the first line into the R / X fields with the lower frequency (e.g. 30 Hz) in
the column for the according current loop (e.g. Z
L1-L3
for L1-L3) in the cable impedance report.