Electro Industries/GaugeTech
Doc # E107706 V1.25A-1
Appendix
A
Transformer
Loss
Compensation
Excel
Spreadsheet
with
Examples
A.1:
Calculating
Values
QTransformer Loss Compensation is discussed in Chapter 7 of this manual. Values for three element
installations can be calculated in two ways:
•Click the TLC Calculator button on the Transformer Loss screen of the Nexus Device Profile.
The TLC Calculator button activates an Excel Spreadsheet, ONLYif you have MS Excel
installed on your computer. Acopy of the Excel Spreadsheet is offered on the following
pages with example numbers.
1. Enter the required data into the Excel Spreadsheet. The Excel program will calculate the
values needed for the Transformer Loss screen of the Device Profile.
2. Enter the values into the Device Profile.
•Use the worksheet found in Chapter 7, “Three Element Loss Compensation Worksheet” to
calculate the values by hand. Notes under each section will assist you.
1. Enter values based on the tranformer manufacturer’s test report. The worksheet is
progressive and notes under each section will guide you to the next section.
2. Enter the values into the Device Profile.
A.2: Excel Spreadsheet with Example Numbers
QIf you have MS Excel installed in your computer, use the TLC Calculator button on the Transformer
Loss screen of the Device Profile. The copy of the Spreadsheet with Example Numbers found on the
following pages will assist you.