{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Characteristic","Anode","Licence"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Characteristic","index":0,"n_rows":58,"n_cols":7,"rows_kept":58,"cut":false,"hidden":false,"merged":[[36,0,36,2]]}
["GI7BT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Vgk","Ia"]
[-50,0]
[-20,0.13900000000000001]
[-5,0.38100000000000001]
[20,0.75]
[30,0.87]
[50,1.05]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Interpolation:"]
["CSTable",null,null,null,null,"Vgk","Ia"]
[{"$f":"CSTable(A12:A17,B12:B17)","v":-50},0,0,null,null,{"$f":"A12","v":-50},{"$f":"csinterpolate($A$38:$C$43,F38)","v":0}]
[-20,0.13900000000000001,8.027023490930717E-4,null,null,{"$f":"F38+($A$17-$A$12)/20","v":-45},3.6565401262100665E-3]
[-5,0.38100000000000001,-2.1621409455842985E-4,null,null,-40,1.0657673373641263E-2]
[20,0.75,-1.193363068688672E-4,null,null,-35,2.4347992863514724E-2]
[30,0.87,-2.8011061552185519E-4,null,null,-30,4.8072091717051575E-2]
[50,1.05,0,null,null,-25,8.5174563055472982E-2]
[null,null,null,null,null,-20,0.13900000000000001]
[null,null,null,null,null,-15,0.21092040471872509]
[null,null,null,null,null,-10,0.29441739306043174]
[null,null,null,null,null,-5,0.38100000000000001]
[null,null,null,null,null,0,0.46367315326899639]
[null,null,null,null,null,5,0.54142534356353755]
[null,null,null,null,null,10,0.61474094792504319]
[null,null,null,null,null,15,0.68410437229177024]
[null,null,null,null,null,20,0.75]
[null,null,null,null,null,25,0.81249654326494203]
[null,null,null,null,null,30,0.87]
[null,null,null,null,null,35,0.9211274197145406]
[null,null,null,null,null,40,0.9670027653880463]
[null,null,null,null,null,45,1.009376728367529]
[null,null,null,null,null,50,1.05]

{"sheet":"Anode","index":1,"n_rows":107,"n_cols":8,"rows_kept":107,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Characteristic!A1","v":"GI7BT"}]
[]
["CLASS AB2"]
[]
["Inputs:"]
["Output cct efficiency (%)",0.95]
["Vak pk RF (V)",{"$f":"B8+B10+B9-200","v":2050}]
["DC anode supply voltage (V)",2200]
["Grid bias voltage (V)",-35]
["Drive voltage peak (V)",85]
[]
[]
["Calculated results:"]
["Tubes",1]
["Anode current idle (A)",{"$f":"IF(B9<cutoff,0,$B$14*csinterpolate(CSIT,B9))","v":2.4347992863514724E-2}]
["Anode current peak (A)",{"$f":"$B$14*csinterpolate(CSIT,B10+B9)","v":1.05}]
["Anode current DC (A)",{"$f":"$B$14*H44","v":0.34716878915656563}]
["Anode current fundamental (A)",{"$f":"$B$14*H45","v":0.54524873309315935}]
["Anode RFpower (W)",{"$f":"$B$14*(B7-(B10+B9))*H45/2","v":545.24873309315933}]
["Anode dissipation (W)",{"$f":"(B8+B10+B9)*B17-(B7*B18/2)","v":222.24982418178433}]
["Anode efficiency (%)",{"$f":"B19/(B8*B17)","v":0.71389001824237341}]
["Resonant load (ohms)",{"$f":"B7/H45/B14","v":3759.7519729582646}]
["Output power (W)",{"$f":"B6*B19","v":517.98629643850131}]
["Output efficiency (%)",{"$f":"B19/(B8*B17)*B6","v":0.67819551733025474}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Samples",64]
[]
["Time °","Vgk","Ia","If","Idc","Index","FFT","Amplitude"]
[0,{"$f":"$B$9+$B$10*SIN((CELL(\"row\",B44)-CELL(\"row\",$B$44))*2*PI()/$B$41)","v":-35},{"$f":"IF(B44<cutoff,0,csinterpolate(CSIT,B44))","v":2.4347992863514724E-2},{"$f":"$H$45*SIN((CELL(\"row\",B44)-CELL(\"row\",$B$44))*2*PI()/$B$41)","v":0},{"$f":"$H$44","v":0.34716878915656563},0,{"$f":"fft(C44:C107)","v":"22.2188025060202"},{"$f":"IMABS(G44)/$B$41","v":0.34716878915656563}]
[{"$f":"A44+1/$B$41*360","v":5.625},-26.668543071987351,{"$f":"IF(B45<cutoff,0,csinterpolate(CSIT,B45))","v":7.1099301150080868E-2},{"$f":"$H$45*SIN((CELL(\"row\",B45)-CELL(\"row\",$B$44))*2*PI()/$B$41)","v":5.3443721586107336E-2},{"$f":"$H$44","v":0.34716878915656563},1,"-2.53508287495832E-15-17.4479594589811i",{"$f":"IMABS(G45)/$B$41*2","v":0.54524873309315935}]
[11.25,-18.417322628629098,0.15999770621564605,0.10637275091803042,0.34716878915656563,2,"-7.29446209233245+4.1210524576174E-15i",0.22795194038538907]
[16.875,-10.325802433370701,0.28879088533771768,0.15827735250935224,0.34716878915656563,3,"2.37534050791916E-15-0.405482633617374i",1.2671332300542938E-2]
[22.5,-2.4719082489673667,0.42344625388229451,0.20865765667280695,0.34716878915656563,4,"-2.12097149962647-4.62764592271125E-16i",6.6280359363327185E-2]
[28.125,5.0687226302097983,0.54246199220092151,0.25702847353862468,0.34716878915656563,5,"-2.84343539382406E-16+0.461224241637967i",1.4413257551186468E-2]
[33.75,12.223469806666188,0.64604561783887648,0.3029239656982094,0.34716878915656563,6,"-0.679249690502293-5.93895456901458E-16i",2.1226552828196656E-2]
[39.375,18.923429153909865,0.73608034281540935,0.34590213447303636,0.34716878915656563,7,"-2.83002550701631E-15+0.33403064094156i",1.043845752942375E-2]
[45,25.104076400856535,0.81375135746726657,0.38554907660354687,0.34716878915656563,8,"-0.230108298417715+2.8484837101897E-15i",7.1908843255535934E-3]
[50.625,30.705888535832642,0.8776022214935788,0.42148297036380111,0.34716878915656563,9,"1.86103845008223E-15+0.195111319660446i",6.0972287393889378E-3]
[56.25,35.674917045716342,0.92758780906459004,0.45335775271342316,0.34716878915656563,10,"-0.0828620428437143+1.92313748476405E-16i",2.589438838866072E-3]
[61.875,39.963307469610172,0.96668100707972093,0.48086645207385781,0.34716878915656563,11,"1.34990632834711E-15+0.13040144809597i",4.0750452529990629E-3]
[67.5,43.529760263459366,0.99717683946492408,0.50374414463247941,0.34716878915656563,12,"-0.00172783095500187-9.75604925350978E-16i",5.3994717343808437E-5]
[73.125,46.339928537237753,1.0203623240529818,0.52177050570372951,0.34716878915656563,13,"-1.37766063341331E-15+0.0714166419107571i",2.2317700597111593E-3]
[78.75,48.366748834274588,1.0368155395564678,0.53477193157628045,0.34716878915656563,14,"0.0294517877427735+2.28288772993512E-15i",9.2036836696167185E-4]
[84.375,49.590701767136736,1.0466983188172008,0.54262321141167735,0.34716878915656563,15,"2.07996169624498E-15+0.024790772863196i",7.74711651974875E-4]
[90,50,1.05,0.54524873309315935,0.34716878915656563,16,"0.0265515420048379+1.77635683940025E-15i",8.2973568765118432E-4]
[95.625,49.590701767136736,1.0466983188172008,0.54262321141167746,0.34716878915656563,17,"1.15803096177255E-15+0.003054664633971i",9.5458269811593755E-5]
[101.25,48.366748834274588,1.0368155395564678,0.53477193157628045,0.34716878915656563,18,"0.0164473613861498+2.89585847468787E-16i",5.1398004331718126E-4]
[106.875,46.339928537237753,1.0203623240529818,0.52177050570372951,0.34716878915656563,19,"1.01197999294116E-15-0.00304171612643827i",9.5053628951195934E-5]
[112.5,43.529760263459366,0.99717683946492408,0.50374414463247941,0.34716878915656563,20,"0.00992279400368384+4.18714855607402E-16i",3.1008731261512E-4]
[118.125,39.963307469610186,0.9666810070797216,0.48086645207385786,0.34716878915656563,21,"1.59124320978869E-15-0.00508378605900713i",1.5886831434397281E-4]
[123.75,35.67491704571637,0.92758780906459148,0.45335775271342332,0.34716878915656563,22,"0.00473952489607973-1.5717492547274E-15i",1.4811015300249155E-4]
[129.375,30.705888535832656,0.87760222149357958,0.42148297036380117,0.34716878915656563,23,"-4.87782896214407E-16-0.0052264465947213i",1.6332645608504063E-4]
[135,25.104076400856542,0.81375135746726734,0.38554907660354693,0.34716878915656563,24,"0.0000133263519674215-1.56374818150763E-15i",4.1644849898192189E-7]
[140.625,18.923429153909865,0.73608034281540935,0.34590213447303636,0.34716878915656563,25,"-1.34725469170573E-15-0.00304284476249372i",9.5088898827928747E-5]
[146.25,12.223469806666188,0.64604561783887648,0.3029239656982094,0.34716878915656563,26,"-0.00233354752510528+1.19265627105195E-16i",7.2923360159540002E-5]
[151.875,5.0687226302098196,0.54246199220092217,0.25702847353862479,0.34716878915656563,27,"-1.29592568094824E-16-0.00065164520374586i",2.0363912617058125E-5]
[157.5,-2.4719082489673596,0.42344625388229473,0.208657656672807,0.34716878915656563,28,"-0.00245038025222488+3.24095134410229E-16i",7.6574382882027504E-5]
[163.125,-10.325802433370697,0.28879088533771774,0.15827735250935226,0.34716878915656563,29,"8.40751350917462E-17+0.000214004696499431i",6.6876467656072187E-6]
[168.75,-18.417322628629069,0.1599977062156468,0.10637275091803061,0.34716878915656563,30,"-0.00216341500519945-2.54001463959042E-16i",6.7606718912482811E-5]
[174.375,-26.66854307198733,7.1099301150081048E-2,5.3443721586107454E-2,0.34716878915656563,31,"4.41434269780189E-16+0.000114362378569766i",3.5738243303051876E-6]
[180,{"$f":"$B$9+$B$10*SIN((CELL(\"row\",B76)-CELL(\"row\",$B$44))*2*PI()/$B$41)","v":-34.999999999999993},2.4347992863514745E-2,{"$f":"$H$45*SIN((CELL(\"row\",B76)-CELL(\"row\",$B$44))*2*PI()/$B$41)","v":6.6801064288996672E-17},0.34716878915656563,32,"-0.00212604060589605",{"$f":"IMABS(G76)/$B$41","v":3.3219384467125781E-5}]
[{"$f":"A76+1/$B$41*360","v":185.625},-43.331456928012649,5.4557437089177603E-3,-5.3443721586107329E-2,0.34716878915656563,33,"-4.76725050494592E-16-0.0001143623785822i"]
[191.25,-51.582677371370906,0,-0.10637275091803049,0.34716878915656563,34,"-0.00216341500520345+8.39389321938278E-16i"]
[196.875,-59.674197566629275,0,-0.15827735250935213,0.34716878915656563,35,"4.7304680992114E-16-0.000214004696499431i"]
[202.5,-67.528091751032619,0,-0.20865765667280689,0.34716878915656563,36,"-0.00245038025222599-2.75902347843249E-16i"]
[208.125,-75.068722630209805,0,-0.25702847353862468,0.34716878915656563,37,"-4.42596398983822E-16+0.000651645203746082i"]
[213.75,-82.223469806666174,0,-0.30292396569820929,0.34716878915656563,38,"-0.00233354752510567-2.6093696973116E-16i"]
[219.375,-88.923429153909851,0,-0.34590213447303619,0.34716878915656563,39,"-1.85379631838321E-15+0.00304284476249367i"]
[225,-95.104076400856542,0,-0.38554907660354687,0.34716878915656563,40,"0.0000133263519673105+1.59240838831093E-15i"]
[230.625,-100.70588853583261,0,-0.42148297036380089,0.34716878915656563,41,"7.89014578499169E-17+0.00522644659472134i"]
[236.25,-105.67491704571634,0,-0.45335775271342316,0.34716878915656563,42,"0.00473952489607984+1.63821931823023E-15i"]
[241.875,-109.96330746961017,0,-0.48086645207385781,0.34716878915656563,43,"1.79356863359175E-15+0.00508378605900726i"]
[247.5,-113.52976026345935,0,-0.5037441446324793,0.34716878915656563,44,"0.0099227940036836-5.57240106109028E-16i"]
[253.125,-116.33992853723775,0,-0.5217705057037294,0.34716878915656563,45,"6.19190740618492E-16+0.00304171612643778i"]
[258.75,-118.36674883427457,0,-0.53477193157628033,0.34716878915656563,46,"0.0164473613861485-2.75433197469588E-16i"]
[264.375,-119.59070176713674,0,-0.54262321141167746,0.34716878915656563,47,"1.01630557844455E-15-0.00305466463396887i"]
[270,-120,0,-0.54524873309315935,0.34716878915656563,48,"0.0265515420048379-1.77635683940025E-15i"]
[275.625,-119.59070176713674,0,-0.54262321141167746,0.34716878915656563,49,"3.67980885495364E-16-0.0247907728631946i"]
[281.25,-118.36674883427459,0,-0.53477193157628045,0.34716878915656563,50,"0.0294517877427735-1.57263069838813E-15i"]
[286.875,-116.33992853723775,0,-0.52177050570372951,0.34716878915656563,51,"-1.48314867670835E-15-0.0714166419107569i"]
[292.5,-113.52976026345937,0,-0.50374414463247941,0.34716878915656563,52,"-0.00172783095500167+1.2081305042071E-15i"]
[298.125,-109.96330746961019,0,-0.48086645207385786,0.34716878915656563,53,"1.2149064713236E-15-0.130401448095971i"]
[303.75,-105.67491704571637,0,-0.45335775271342332,0.34716878915656563,54,"-0.082862042843714-2.49554540985956E-16i"]
[309.375,-100.70588853583263,0,-0.421482970363801,0.34716878915656563,55,"1.91510049734733E-15-0.195111319660446i"]
[315,-95.104076400856556,0,-0.38554907660354698,0.34716878915656563,56,"-0.230108298417716-2.87714391699299E-15i"]
[320.625,-88.923429153909908,0,-0.34590213447303658,0.34716878915656563,57,"-2.43236488351069E-15-0.334030640941559i"]
[326.25,-82.223469806666188,0,-0.3029239656982094,0.34716878915656563,58,"-0.679249690502294+5.90053315452713E-16i"]
[331.875,-75.06872263020982,0,-0.25702847353862485,0.34716878915656563,59,"4.92224482879925E-16-0.461224241637966i"]
[337.5,-67.52809175103269,0,-0.20865765667280728,0.34716878915656563,60,"-2.12097149962647+3.20571477349652E-16i"]
[343.125,-59.674197566629317,0,-0.15827735250935232,0.34716878915656563,61,"2.61626319024953E-15+0.405482633617373i"]
[348.75,-51.582677371370941,0,-0.10637275091803068,0.34716878915656563,62,"-7.29446209233245-5.2945657840614E-15i"]
[354.375,-43.331456928012642,5.4557437089177672E-3,-5.344372158610728E-2,0.34716878915656563,63,"-7.52625907559854E-15+17.4479594589811i"]

{"sheet":"Licence","index":2,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Licence / Copyright"]
[]
[]
["This spreadsheet, its macros and functions, and associated documentation are Copyright 2008 Owen Duffy."]
[]
["Licence is hereby granted to use this spreadsheet for its intended purpose."]
[]
["This licence does not permit distibution with any other software product, inclusion in any compilation of products,"]
["or copying to any WWW distribution sites or web servers."]
[]
["Users should not depend on the content without independent verification. No reponsiblity is accepted for the accuracy of the spreadsheet or for any errors."]
[]
[]
[]
[]
[]
[]
[]
["Module","Version","Date"]
["CubicSpline",{"$f":"cubicspline_version(\"v\")","v":"1.03"},{"$f":"cubicspline_version(\"d\")","v":"2010-07-06"}]
["FFT",{"$f":"FFT_version(\"v\")","v":"1.05"},{"$f":"FFT_version(\"d\")","v":"2011-05-11"}]