Excel Spreadsheets


Click on the zip-filenames for download. 
My favorite method to design a Tesla coil is by means of an Excel-spreadsheet. It allows the quick and
easy change of the design parameters, and the view of their influence on design. By means of  "solver" or
"goalseek" methods the inverse or implicit solution of the design equations becomes feasible, opening the
possibility to fit your design to available components . Another attractive application of spreadsheets
 in coiling is the documentation and interpretation of measurement results. And a third kind is the useful
  presentation of table data, because by this way they're easily integrated in any kind of calculation.

TCplan.zip
223'854 bytes
My comprehensive TC-design spreadsheet, originally started from Ed Sondermans, but now enhanced with attached programs E-Tesla 6 from Terry Fritz and ACMI from Paul Nicholson, MMC calculator, and different useful info and tables for coilers, containing effectively also the info in the next 5 download files on this page.
freau_rules.zip
4'958 bytes
   John Freau's design rules for efficient, low break rate, synchronous rotary spark gap Tesla coils
cap_dielec.zip
7'065 bytes
   Calculate different capacitors, using an integrated table of dielectrics (Plate-,Leyden-,Ball-,Torus-)
isol_tbl.zip
17'428 bytes
   Jochen Kronjaeger's compilation of solid-, liquid- and foil- insulator data.
sparkgap_tbl.zip
27'613 bytes
   Sparkgap -voltage vs. -spacing tables of different origin, for needle points, rod gaps, balls.
awg_wire.zip
5'734 bytes
   AWG wire table.
coupling_k.zip
65'695 bytes
   Coupling factor measurements on one of my 8" Tesla coils. Language: German
bw_mk.zip
15'856 bytes
  Coupling factor measurements vs. M.Rzeszotarski's M&k calculation, for 16" TC "Black & White"
bombarder.zip
5'125 bytes
   Neon sign transformer measurements (example: my "bombarder NST"). Language: German
rlc.zip
78'705 bytes
   Switching a simple RLC circuit to to a DC source.