Re: Tesla Coil Computer Programs

[Esondrmn-at-aol-dot-com (by way of Terry Fritz <twftesla-at-uswest-dot-net>)]

In a message dated 7/22/00 10:52:46 AM Pacific Daylight Time, 
tesla-at-pupman-dot-com writes:

<< 
 Hi Ed,
   I too have used your spreadsheet and then went and made my own.   I used 
 the same basic equations yours does except that I plotted out the Medhurst 
 table from yours and then used the trend function to create a formula for 
the 
 self capacitance rather than a lookup table(my own "adjustment" to your fine 
 spreadsheet).  I did use yours to make sure mine worked right.
    The real point, however, is that I had an idea that might save you a 
 little effort if you are doing many designs for people.    If you have a 
cell 
 where the primary cap is entered(based on matching the transformer etc.) and 
 you have a cell that calculates the primary cap based on the primary turns 
 inductance,  why not set one cell to equal the ratio of them and use the 
goal 
 seek function to force the ratio to be one by changing the primary turns 
 cell?  It would save you the iterative approach once you have set it up.
   Just a thought for you,
 Mike
 
 
  >>
Mike,

Good idea, for future reference.

Ed Sonderman