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

ZplotsandTLDetailsapplications.

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:Download

T-Line Model.xlsand/orT-Line Measure.xls. Free.Neither of these workbooks contain macros. They may be used with Open Office Calc.