Transmission Line Math
These two workbooks show various formulas that are used when dealing with transmission lines.
T-Line Model.xls shows the details of the mathematical model for transmission lines that is used by the Zplots and TLDetails applications.
T-Line Measure.xls shows how the characteristic impedance Zo and the propagation constant g (gamma) may be obtained from two basic impedance measurements, one with the transmission line terminated with an open circuit and a second with a short circuit termination.
Both workbooks make use of the Excel complex number functions. Under Excel 2003 and earlier, click on Tools >
Add-Insand make sure "Analysis ToolPak" is checked. Under Excel 2007 and later no special action is needed.
Download T-Line Model.xls and/or T-Line Measure.xls. Free.
Neither of these workbooks contain macros. They may be used with Open Office Calc.