Spreadsheet: 1a561fb2-bd35-4c35-bc0c-1c076b90813f
Sheet: Sheet1

Fill in the known values, the capacitance min and [NAME] value, the inductance value min and [NAME] value, or the frequency range.  Two of the three must be known. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18
If a component is fixed value (like a non-tapped coil or fixed capacitor) enter the value in both the MIN and MAX Blocks.
Take the calculated values from the table, and enter into the blank yellow (unknown) block.
All data should be relatively close, there is a lot of rounding going on here. The Graph will display the tuning range and update as new values are entered in the yellow areas.
of the circuit as designed. Generally try to obtain a flat response for tracking purposes.
IMPORTANT: ---> CLEAR VALUES BETWEEN CALCULATIONS either enter zero or delete the previously known values. If your data does not match this is the first thing to check.
 | Enter known Values here |  |  | Units | Calculated Values shown Below
 |  | Min | [NAME] |  | Min | [NAME]
 | Inductance | 22 | 22 | uH | 22 | 22
 | Capacitance | 72 | 94 | pF | 71.96106792779672 | 93.98996627304062
 | Frequency | 3.5 | 4 | MHz | 3.501588352974066 | 4.000946716796227
 |  |  |  |  |  |  |  |  |  |  | Table of Values for graphing
 |  |  |  |  |  |  |  |  |  | uH | pf | F | H | Mhz |  | Conversion block
 |  |  |  |  |  |  |  |  |  | 22 | 72 | 7.2e-11 | 2.2e-05 | 4.000946716796227 |  | 9.4e-11 | Farads | 7.2e-11
 |  |  |  |  |  |  |  |  |  | 22 | 72.44 | 7.244e-11 | 2.2e-05 | 3.988777349775631 |  | 2.2e-05 | Henries | 2.2e-05
 |  |  |  |  |  |  |  |  |  | 22 | 72.88 | 7.288e-11 | 2.2e-05 | 3.976718355339352 |  | 3500000 | Herz | 4000000
 |  |  |  |  |  |  |  |  |  | 22 | 73.32 | 7.332e-11 | 2.2e-05 | 3.964768075100733
 |  |  |  |  |  |  |  |  |  | 22 | 73.75999999999999 | 7.375999999999999e-11 | 2.2e-05 | 3.952924885349733 |  | 483610615653378.5 | w | 631654681669718.9
 |  |  |  |  |  |  |  |  |  | 22 | 74.19999999999999 | 7.419999999999999e-11 | 2.2e-05 | 3.941187196126209 |  | 9.398996627304062e-11 | Farads | 7.196106792779672e-11
 |  |  |  |  |  |  |  |  |  | 22 | 74.63999999999999 | 7.463999999999999e-11 | 2.2e-05 | 3.9295534503233 |  | 2.2e-05 | Henries | 2.2e-05
 |  |  |  |  |  |  |  |  |  | 22 | 75.07999999999998 | 7.507999999999999e-11 | 2.2e-05 | 3.91802212281974
 |  |  |  |  |  |  |  |  |  | 22 | 75.51999999999998 | 7.551999999999998e-11 | 2.2e-05 | 3.906591719640026
 |  |  |  |  |  |  |  |  |  | 22 | 75.95999999999998 | 7.595999999999998e-11 | 2.2e-05 | 3.895260777141375
 |  |  |  |  |  |  |  |  |  | 22 | 76.39999999999998 | 7.639999999999998e-11 | 2.2e-05 | 3.884027861226476
 |  |  |  |  |  |  |  |  |  | 22 | 76.83999999999997 | 7.683999999999998e-11 | 2.2e-05 | 3.872891566581073
 |  |  |  |  |  |  |  |  |  | 22 | 77.27999999999997 | 7.727999999999998e-11 | 2.2e-05 | 3.86185051593545
 |  |  |  |  |  |  |  |  |  | 22 | 77.71999999999997 | 7.771999999999997e-11 | 2.2e-05 | 3.850903359348952
 |  |  |  |  |  |  |  |  |  | 22 | 78.15999999999997 | 7.815999999999997e-11 | 2.2e-05 | 3.84004877351668
 |  |  |  |  |  |  |  |  |  | 22 | 78.59999999999997 | 7.859999999999997e-11 | 2.2e-05 | 3.829285461097578
 |  |  |  |  |  |  |  |  |  | 22 | 79.03999999999996 | 7.903999999999997e-11 | 2.2e-05 | 3.818612150063106
 |  |  |  |  |  |  |  |  |  | 22 | 79.47999999999996 | 7.947999999999997e-11 | 2.2e-05 | 3.808027593065777
 |  |  |  |  |  |  |  |  |  | 22 | 79.91999999999996 | 7.991999999999996e-11 | 2.2e-05 | 3.797530566826849
 |  |  |  |  |  |  |  |  |  | 22 | 80.35999999999996 | 8.035999999999996e-11 | 2.2e-05 | 3.787119871542465
 |  |  |  |  |  |  |  |  |  | 22 | 80.79999999999995 | 8.079999999999996e-11 | 2.2e-05 | 3.776794330307625
 |  |  |  |  |  |  |  |  |  | 22 | 81.23999999999995 | 8.123999999999996e-11 | 2.2e-05 | 3.766552788557321
 |  |  |  |  |  |  |  |  |  | 22 | 81.67999999999995 | 8.167999999999994e-11 | 2.2e-05 | 3.756394113524264
 |  |  |  |  |  |  |  |  |  | 22 | 82.11999999999995 | 8.211999999999994e-11 | 2.2e-05 | 3.746317193712611
 |  |  |  |  |  |  |  |  |  | 22 | 82.55999999999995 | 8.255999999999995e-11 | 2.2e-05 | 3.736320938387132
 |  |  |  |  |  |  |  |  |  | 22 | 82.99999999999994 | 8.299999999999995e-11 | 2.2e-05 | 3.726404277077302
 |  |  |  |  |  |  |  |  |  | 22 | 83.43999999999994 | 8.343999999999995e-11 | 2.2e-05 | 3.716566159095787
 |  |  |  |  |  |  |  |  |  | 22 | 83.87999999999994 | 8.387999999999993e-11 | 2.2e-05 | 3.706805553070843
 |  |  |  |  |  |  |  |  |  | 22 | 84.31999999999994 | 8.431999999999993e-11 | 2.2e-05 | 3.697121446492149
 |  |  |  |  |  |  |  |  |  | 22 | 84.75999999999993 | 8.475999999999994e-11 | 2.2e-05 | 3.687512845269636
 |  |  |  |  |  |  |  |  |  | 22 | 85.19999999999993 | 8.519999999999994e-11 | 2.2e-05 | 3.677978773304843
 |  |  |  |  |  |  |  |  |  | 22 | 85.63999999999993 | 8.563999999999992e-11 | 2.2e-05 | 3.668518272074424
 |  |  |  |  |  |  |  |  |  | 22 | 86.07999999999993 | 8.607999999999992e-11 | 2.2e-05 | 3.659130400225361
 |  |  |  |  |  |  |  |  |  | 22 | 86.51999999999992 | 8.651999999999992e-11 | 2.2e-05 | 3.64981423318152
 |  |  |  |  |  |  |  |  |  | 22 | 86.95999999999992 | 8.695999999999993e-11 | 2.2e-05 | 3.640568862761179
 |  | Inductive Impedance = | 0 |  | Capacitive Reactance= |  |  |  |  | 22 | 87.39999999999992 | 8.739999999999993e-11 | 2.2e-05 | 3.631393396805139
 |  |  |  |  |  |  |  |  |  | 22 | 87.83999999999992 | 8.783999999999991e-11 | 2.2e-05 | 3.622286958815116
 |  | Tank Circuit Impedance |  |  |  |  |  |  |  | 22 | 88.27999999999992 | 8.827999999999991e-11 | 2.2e-05 | 3.613248687602042
 |  |  |  |  |  |  |  |  |  | 22 | 88.71999999999991 | 8.871999999999991e-11 | 2.2e-05 | 3.604277736943977
 |  |  |  |  |  |  |  |  |  | 22 | 89.15999999999991 | 8.915999999999991e-11 | 2.2e-05 | 3.595373275253322
 |  |  |  |  |  |  |  |  |  | 22 | 89.59999999999991 | 8.959999999999992e-11 | 2.2e-05 | 3.586534485253023
 |  |  |  |  |  |  |  |  |  | 22 | 90.0399999999999 | 9.00399999999999e-11 | 2.2e-05 | 3.577760563661492
 |  |  |  |  |  |  |  |  |  | 22 | 90.4799999999999 | 9.04799999999999e-11 | 2.2e-05 | 3.569050720885968
 |  |  |  |  |  |  |  |  |  | 22 | 90.9199999999999 | 9.09199999999999e-11 | 2.2e-05 | 3.560404180724045
 |  |  |  |  |  |  |  |  |  | 22 | 91.3599999999999 | 9.13599999999999e-11 | 2.2e-05 | 3.551820180073122
 |  |  |  |  |  |  |  |  |  | 22 | 91.7999999999999 | 9.179999999999989e-11 | 2.2e-05 | 3.543297968647512
 |  |  |  |  |  |  |  |  |  | 22 | 92.2399999999999 | 9.223999999999989e-11 | 2.2e-05 | 3.534836808702992
 |  |  |  |  |  |  |  |  |  | 22 | 92.6799999999999 | 9.267999999999989e-11 | 2.2e-05 | 3.526435974768548
 |  |  |  |  |  |  |  |  |  | 22 | 93.11999999999989 | 9.31199999999999e-11 | 2.2e-05 | 3.518094753385099
 |  |  |  |  |  |  |  |  |  | 22 | 93.55999999999989 | 9.35599999999999e-11 | 2.2e-05 | 3.509812442850997
 |  |  |  |  |  |  |  |  |  | 22 | 93.99999999999989 | 9.399999999999988e-11 | 2.2e-05 | 3.501588352974066