ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
WB-5 Differential-Mode Model Solver
3
Author: Jacek Pawlowski, SP3L
4
5
For an explanation on how to use it, see the technical note:
6
TN-11 Using the Differential-Mode Model Solver
7
8
The formulas embedded in the Transmission_Line_Model sheet were adapted from the file T-Line Model.xls, created and shared by Dan Maguire, AC6LA.
9
10
11
Revision history
12
1.02025-06-02Initial version.
13
1,12025-06-16S-matrix_Model sheet added.
14
2.02025-07-25Bug fix: R and X calculations for loads #2 and #3 for circuits A-E were erroneously divided by the nominal transformer ratio. In addition to the fix, the transformer impedance ratio has been excluded from the optimization process.
15
2.52026-01-01Circuit F changed. XFMR & T Network tab added.
16
2.62026-01-01Corrected data source for the charts on the Circuit A sheet.
17
2.612026-01-02Color of one of the charts corrected.
18
2.622026-01-07ZA5 and ZA6 exchanged with one another to comply with the nomenclature in the catalog.
19
2.72026-01-08F circuit added. The impedance matching charts moved to the left.
20
2.722026-01-09Updated formulas for the Target cell (Solver function).
21
2.732026-02-13The formula for Delta improved.
22
2.742026-01-22Higher limit changed from 10^6 to 10^9 in the solver settings for circuit A.
23
2.752026-01-23Number formatting of the initial/solved values.
24
2.762026-01-26Conditional formatting cleaned.
25
2.772026-01-26Delta formula for the TL circuit alined with the formulas for the A-F circuits.
26
2.782026-01-28Circuit G added.
27
2.792026-01-29Minor bugs removed.
28
3.02026-07-02Published
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100