MMC Calculator      Ver 2.2      9/12/2000    Terry Fritz Mirrored & modified little in Excel  12/12/2000  Kurt Schraner
Color Legend:
Inputs[1] precalc's bad :-(( ??   :-| good :-) very good :-)) DC is in % tolerance Auxiliary Data:
Single Capacitor
Input Data ... and do a little calculation on it SI units Single Cap Specification Lead  
Transformer rated RMS output voltage Vo = 8[2] kV    Vo = 8000 V Cap type   Wima FKP1  33nF / 6kV spacing TK
Transformer rated RMS output current Io = 100 mA    Io = 0,1 A Thermal dissipation const. TK = 33[3] C/W mm C/W
Fundamental frequency of coil F  = 100 kHz Voltage per capacitor DC Vm = 1500 V 5 250
Break rate of primary gap BPS BPS = 100 BPS Voltage per capacitor AC Vacm = 450 V 7,5 167
Primary circuit equivalent resistance (~3 Ohm) Rpri = 2 Ohm Capacity per capacitor Co = 47 nF 10 133
Cap value desired [ -1 for LTR ] Ctotal Ctotal = 38 nF Cost per capacitor Ccost = 4,88 SFr 15 83
Cap value tolerance desired % of Ctotal DCtotal = 3 % 22,5 67
27,5 40
Cap value desired, used in calculation Cwish = 38,00 nF  Cwish= 3,800E-08 F Capacity per capacitor Co = 4,70E-08 F 37,5 33
Dielectric loss factor tan(d) = 0,0009  - Internal resistance Rcap = 0,03078 Ohm
Spark gap firing voltage Vf = 11,31 kV     Vf = 11314 V    Polypropylene
Nominal bang size Ebang.wish = 0.5*Cwish*Vf^2  = 2,432 J Comments: F tan(d)
Nominal cap TC power PTC.wish  = BPS*Ecap.wish = 243,2 W         1.) Vm of these Wima 6kV= caps was set to 1600V kHz -
  because the ratio of 6kV/Vacm is unusually high. 10 0,0004
F- Warning:           50 0,0008
        2.) The proposed design was realized in my first small MMC 100 0,0010
Optional:  4 < override default initial "Cps/Str" with your own value        
200 0,0016
Strings Caps/Str Ncaps Ecap Wo total C E.bang I rms Voltage Temp To Cost Life  Volt Temp 300 0,0024
J Watt nF J A V C SFr hours fitness fitness 400 0,0040
3 4 12 0,1880 0,2850 35,25 2,26 9,13 6000 9,40 58,56 0 :-(( :-)
4 4 16 0,1880 0,2850 47,00 3,01 12,17 6000 9,40 78,08 0 :-(( :-)
4 5 20 0,1203 0,1824 37,60 2,41 9,74 7500 6,02 97,60 0 :-(( :-)
5 5 25 0,1203 0,1824 47,00 3,01 12,17 7500 6,02 122,00 0 :-(( :-)
4 6 24 0,0836 0,1267 31,33 2,01 8,11 9000 4,18 117,12 0 :-( :-))
5 6 30 0,0836 0,1267 39,17 2,51 10,14 9000 4,18 146,40 0 :-( :-))
5 7 35 0,0614 0,0931 33,57 2,15 8,69 10500 3,07 170,80 1 :-| :-))
6 7 42 0,0614 0,0931 40,29 2,58 10,43 10500 3,07 204,96 1 :-| :-))
6 8 48 0,0470 0,0712 35,25 2,26 9,13 12000 2,35 234,24 6 :-)) :-))  best price for fully safe design!
7 8 56 0,0470 0,0712 41,13 2,63 10,65 12000 2,35 273,28 6 :-)) :-))
7 9 63 0,0371 0,0563 36,56 2,34 9,47 13500 1,86 307,44 37 :-)) :-))
8 9 72 0,0371 0,0563 41,78 2,67 10,82 13500 1,86 351,36 37 :-)) :-))
8 10 80 0,0301 0,0456 37,60 2,41 9,74 15000 1,50 390,40 179 :-)) :-))
9 10 90 0,0301 0,0456 42,30 2,71 10,95 15000 1,50 439,20 179 :-)) :-))
8 11 88 0,0249 0,0377 34,18 2,19 8,85 16500 1,24 429,44 746 :-)) :-))
9 11 99 0,0249 0,0377 38,45 2,46 9,96 16500 1,24 483,12 746 :-)) :-))
9 12 108 0,0209 0,0317 35,25 2,26 9,13 18000 1,04 527,04 2751 :-)) :-))
10 12 120 0,0209 0,0317 39,17 2,51 10,14 18000 1,04 585,60 2751 :-)) :-))
10 13 130 0,0178 0,0270 36,15 2,31 9,36 19500 0,89 634,40 9141 :-)) :-))
11 13 143 0,0178 0,0270 39,77 2,55 10,30 19500 0,89 697,84 9141 :-)) :-))
11 14 154 0,0153 0,0233 36,93 2,36 9,56 21000 0,77 751,52 27782 :-)) :-))
12 14 168 0,0153 0,0233 40,29 2,58 10,43 21000 0,77 819,84 27782 :-)) :-))
[1]
Sheet Protection:
In order to prevent unintentional changes to the formulas and formatting, only the yellow input cells are accessible by the user.

If you want to make your own changes to the spreadsheet, the protecton of the sheet must be removed first. (Tools menu; no password was inserted !)
[2]
The TAB key can be used for moving between the yellow input fields
[3]
Enter the thermal dissipation value from the accompanying table, based on the distance between the leads of your capacitor