9-14
Understanding the CITIfile Data Format
Useful Calculations
Expressing CITIfile Data in Other Data Formats
CITIfile data is represented in real and imaginary pairs. Equations can be used to express
this information in logarithmic magnitude, phase, polar, and Smith chart formats. Refer to
the following table for these equations.
Desired Format
Mathematical Equation
a
a.
Re = real. Im = imaginary.
Microsoft Excel Command
b
b.
The references to ReCell 1, ImCell 1, and Z Cell 1 refer to the real and imaginary data pair numeric values
that have been entered into specific cells in the Microsoft Excel spread sheet.
Log Magnitude
20*Log10((Re2 + Im2)) 1/2
=20*LOG10(SQRT((SUMSQ(ReCell 1,Im Cell 1)))) (dB)
Phase
tan-1(Im/Re) or arctan (Im/Re)
ATAN2(ReCell 1, ImCell 1)*180/PI() (Degree)
Polar
Magnitude = ((Re2 + Im2)) 1/2
Magnitude = (SQRT((SUMSQ(ReCell 1,Im Cell 1)))
Phase = tan-1(Im/Re) or
Phase = ATAN2(ReCell 1, ImCell 1)*180/PI()
arctan (Im/Re)
Smith Chart
Resistance =
Resistance =
(Marker)
(1 - Re2-Im2) /
((1-POWER(ReCell 1,2)-POWER(ImCell 1,2)) /
((1 -Re) 2+Im2)) * Z0
(POWER((1- ReCell 1),2)+POWER(ImCell 1,2))) * Z Cell 1
Reactance =
Reactance =
(2*Im) /
(2*ImCell 1) /
((1 - Re) 2+Im2)) * Z0
(POWER((1- ReCell 1),2)+POWER(ImCell 1,2)))*Z Cell 1
Summary of Contents for 8719ES
Page 6: ...vi ...
Page 10: ...Contents x Contents ...
Page 11: ...1 1 1 HP 8719 20 22ES Specifications and Characteristics ...
Page 60: ...1 50 HP 8719 20 22ES Specifications and Characteristics Instrument Specifications ...
Page 61: ...2 1 2 HP 8719 20 22ET Specifications and Characteristics ...
Page 98: ...2 38 HP 8719 20 22ET Specifications and Characteristics Instrument Specifications ...
Page 99: ...3 1 3 Front Rear Panel ...
Page 111: ...4 1 4 Menu Maps ...
Page 113: ...4 3 Menu Maps Menu Maps Figure 4 2 Menu Map for Copy ...
Page 114: ...4 4 Menu Maps Menu Maps Figure 4 3 Menu Map for Display ...
Page 115: ...4 5 Menu Maps Menu Maps Figure 4 4 Menu Map for Format Figure 4 5 Menu Map for Local ...
Page 116: ...4 6 Menu Maps Menu Maps Figure 4 6 Menu Map for Marker Marker Fctn and Marker Search ...
Page 118: ...4 8 Menu Maps Menu Maps Figure 4 9 Menu Map for Power and Sweep Setup ET only ...
Page 119: ...4 9 Menu Maps Menu Maps Figure 4 10 Menu Map for Power and Sweep Setup ES only ...
Page 120: ...4 10 Menu Maps Menu Maps Figure 4 11 Menu Map for Preset ...
Page 121: ...4 11 Menu Maps Menu Maps Figure 4 12 Menu Map for Save Recall ...
Page 122: ...4 12 Menu Maps Menu Maps Figure 4 13 Menu Map for Scale Ref ...
Page 128: ...5 1 5 Hardkey Softkey Reference ...
Page 194: ...6 1 6 Error Messages ...
Page 222: ...7 1 7 Options and Accessories ...
Page 234: ...8 1 8 Preset State and Memory Allocation ...
Page 253: ...8 20 Preset State and Memory Allocation Memory Allocation ...
Page 254: ...9 1 9 Understanding the CITIfile Data Format ...
Page 269: ...9 16 Understanding the CITIfile Data Format Useful Calculations ...
Page 270: ...10 1 10 Determining System Measurement Uncertainties ...
Page 281: ...10 12 Determining System Measurement Uncertainties Measurement Uncertainty Equations ...