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-Ins and 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.