TC-plan   V 1.01            
 
Important: All the files, supplied with TCplan.zip, must be copied to the Excel-default-file-folder,  
to be seen under "TOOLS / OPTIONS / GENERAL / Default File Location" of the Excel application.  
  For ease of use, fill the different sheets from leftmost "Effic.TC" to right "Skineff.".    
  Using the TAB - key, you can jump directly to the   input fields , within each sheet.    
 
This Excel-workbook has grown with my only ~ 2 years (-renewed) activity in Tesla coiling.  
And I have included topics of my primary interest, within different worksheets, beeing aware   
of the relative and time-depending nature of the contents. I've integrated some mails of  
prominent coilers, published in the "Tesla Coil Mailing List". And I hope, they will forgive  
my, possibly narrowed down, interpretation of their knowledge, within this Excel sheet.  
I'm very much indebted to many members of the TCML (Tesla Coil Mailing List "pupman")  
the GTL. (German Tesla List) and the TSSP (Tesla Secondary Simulation Project).  
Within the "Excel" are interfaces to two more advanced program tools of modern coiling:  
To Terry Fritz's E-Tesla for field- and secondary C calculation, and to Paul Nicholson's  
ACMI for coupling coefficient calculation. My TC-plan Excel might be confusing for the  
very 'newbie' coiler,  but hopefully provide useful service a little later on. Out of a big choice  
of nice TC design programs, I like to point to some of my favorite tools for easy TC design:  
   
  Scott Coppersmith's:    Wintesla ---> Reliable Windows program  
  Bart Anderson's Java Script:    JavaTC   ---> Modern tool, usable online or standalone  
  Bart Anderson's Excel:    Qtc        ---> very compact, contains MMC design  
  Ed Sonderman's Excel:    Teslexlb --->...from which my TC-plan started  
     
Wheras these above programs are designed for US/English input units, my one is mainly for  
the metric system. However most sizes are also expressed in inches, and it would be easy to  
change the "program" for an English units input version.  
Trying to provide a calculation-module plug-in platform, my own TC-plan may be  
too extended or too narrow, following your goals. You may remove the following worksheets,  
without affecting the calculations core:  
 
  - intro (=this sheet) - Caps  
  - Effic.TC   - Arc-mod  
  - Coupl.   - Losses  
  - MMC   - Sparkgap V  
 
By that way you can get your 'small', tailored, TC design workbook, but in this case,  
I recommend using one of the more compact design programs from the fellow coilers,   
mentioned above.- However you may extend the workbook deliberately, following your  
preferences! - If you don't like to dive into Excel 'programming', better don't remove:  
 
  - TC calc   - AWG  
  - TC sketch   - Skineff.  
  - E-Tesla   - Proxi-eff.  
  - Medhurst C  
 
...because there are linked fields, existing among those worksheets.  
With the exception of the (yellow) input- and experimental (green)data fields,      
I have provided protection of the different worksheets, however only to protect  
yourself from inadvertently corrupting the workbook. ... If you choose   
 "TOOLS / PROTECTION / UNPROTECT SHEET", you'll be able to change  
everyting you like, in the actual worksheet.(no passwords set!). "TC-plan"  
is herewith supplied to the freeware area, in order to support the serious  
hobby coiler, and you may do with it at your will. However if you decide to  
include parts or all of "TC-plan" in your website or own program, please  
give me due credit and link to:  
 
http://home.datacomm.ch/k.schraner/index.htm  
 
I have tried to eliminate errors, by recalculating my own Tesla coils and comparing  
the results to measurements, where available, apart from plausibility testing and  
reviewing the relations, within the worksheets, but I can not exclude errors remaining.   
I will of course help to resolve problems, and try to find such errors, when asked so  
by users observing such problems. But I will take no responsibility for anything  
problematic, - namely injurence of persons, waste of material or money, resulting  
from the use of this TC-plan Excel-workbook.  
 
Enhancements, comments, critics are welcome;  please e-mail to:  
 
Basel, April 12th 2001 for V1.0 Kurt Schraner  
 
 
History Record of Modifications  
 
Original by Ed Sonderman   Esondrmn@aol.com   12-10-97  
first modified by Kurt Schraner  9-17-98 / 3-17-00 / 8-13-00...  
last modified by Kurt Schraner    mai 4, 01  
 
Version Date Modifications / Error corrections  
 
1,01 mai 3, 01 - Primary wire format set to 2 decimal fraction (for smaller wire primaries)  
    - If in TC calc. /cell E30, "d/s wire diam./spacing ratio" = 1 --> set to 0.99999  
                  (was causing interpolation error in Proxi-eff.)  
  - Set numeric value of Ctotal by E-Tesla = 0 for starting calculations  
  - Set numeic value of C = 0, in sheet E-Tesla, for starting calculations  
  - Spheric topload introduced in sheets TC-calc and E-Tesla  
  - Remark "Solenoid not allowed..." in sheet E-Tesla  
  - Missing strikerail-test (height = 0 in A36) in sheet E-Tesla (set diameter in A38=0)  
  - Display coupling k and E-Tesla Ctotal outputs in sheet TC-sketch  
  - Provide value of resonant cap for NST's in sheet TC-sketch K15, based on short circuit current in G31
   
  mai 4, 01 - Small input cosmetics in sheet TC calc. More specific resistance data (Moeller, P.19)  
   
  mai 30, 01 - E-Tesla 6.11 replaced by E-Tesla 6.12C  (tested if I/O working).