{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["FT240-31","Mix"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":1,"defined_names":2,"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":"FT240-31","index":0,"n_rows":35,"n_cols":31,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Calculate impedance of ferrite cored inductor"]
[]
["Reference:"]
["A method for estimating the impedance of a ferrite cored toroidal inductor at RF"]
[]
["Inputs:"]
["Al (nH for 1t)",2050,null,"2631803802"]
["N",12]
["Cs (pF)",2.5]
[]
["Constants:"]
["Mix",{"$f":"Mix!B1","v":"#31"}]
["µi",{"$f":"Mix!B2","v":1500}]
[]
["Calculated values:"]
["2*pi*N^2*Al",{"$f":"2*PI()*$B$8^2*$B$7*0.000000001","v":1.854796302679414E-3}]
[]
["f (MHz)",1,1.2,1.8,2,2.5,3,3.5,4,4.5,5,5.5,6,{"$f":"M18+1","v":7},8,9,10,11,12,13,14,15,16,17,18,19,22,24,26,28,30]
["µ''",{"$f":"csinterpolate(CSTableU2,'FT240-31'!B18*1000000)","v":437.78022720651228},{"$f":"csinterpolate(CSTableU2,'FT240-31'!C18*1000000)","v":552.24283316637718},{"$f":"csinterpolate(CSTableU2,'FT240-31'!D18*1000000)","v":702.08424369573322},{"$f":"csinterpolate(CSTableU2,'FT240-31'!E18*1000000)","v":721.86290822240483},{"$f":"csinterpolate(CSTableU2,'FT240-31'!F18*1000000)","v":731.04975970601242},{"$f":"csinterpolate(CSTableU2,'FT240-31'!G18*1000000)","v":710.2466192928722},{"$f":"csinterpolate(CSTableU2,'FT240-31'!H18*1000000)","v":683.69572104777683},{"$f":"csinterpolate(CSTableU2,'FT240-31'!I18*1000000)","v":653.71743210897648},{"$f":"csinterpolate(CSTableU2,'FT240-31'!J18*1000000)","v":621.73192675928283},{"$f":"csinterpolate(CSTableU2,'FT240-31'!K18*1000000)","v":589.44104987027481},{"$f":"csinterpolate(CSTableU2,'FT240-31'!L18*1000000)","v":558.54882653178458},{"$f":"csinterpolate(CSTableU2,'FT240-31'!M18*1000000)","v":530.04029955269198},{"$f":"csinterpolate(CSTableU2,'FT240-31'!N18*1000000)","v":480.48983156281491},{"$f":"csinterpolate(CSTableU2,'FT240-31'!O18*1000000)","v":441.06006604878155},{"$f":"csinterpolate(CSTableU2,'FT240-31'!P18*1000000)","v":410.68881373928843},{"$f":"csinterpolate(CSTableU2,'FT240-31'!Q18*1000000)","v":387.31068270797374},{"$f":"csinterpolate(CSTableU2,'FT240-31'!R18*1000000)","v":368.83321626892513},{"$f":"csinterpolate(CSTableU2,'FT240-31'!S18*1000000)","v":353.17861296391436},{"$f":"csinterpolate(CSTableU2,'FT240-31'!T18*1000000)","v":339.03034912266554},{"$f":"csinterpolate(CSTableU2,'FT240-31'!U18*1000000)","v":326.18915667890695},{"$f":"csinterpolate(CSTableU2,'FT240-31'!V18*1000000)","v":314.54499192170664},{"$f":"csinterpolate(CSTableU2,'FT240-31'!W18*1000000)","v":303.98780860963211},{"$f":"csinterpolate(CSTableU2,'FT240-31'!X18*1000000)","v":294.40749637082706},{"$f":"csinterpolate(CSTableU2,'FT240-31'!Y18*1000000)","v":285.69400946629833},{"$f":"csinterpolate(CSTableU2,'FT240-31'!Z18*1000000)","v":277.73729054219706},{"$f":"csinterpolate(CSTableU2,'FT240-31'!AA18*1000000)","v":257.3123628564183},{"$f":"csinterpolate(CSTableU2,'FT240-31'!AB18*1000000)","v":245.75060990174484},{"$f":"csinterpolate(CSTableU2,'FT240-31'!AC18*1000000)","v":235.5472230494847},{"$f":"csinterpolate(CSTableU2,'FT240-31'!AD18*1000000)","v":226.53945570825286},{"$f":"csinterpolate(CSTableU2,'FT240-31'!AE18*1000000)","v":218.56460950108666}]
["µ'",{"$f":"csinterpolate(CSTableU1,'FT240-31'!B18*1000000)","v":1400.6121872500232},{"$f":"csinterpolate(CSTableU1,'FT240-31'!C18*1000000)","v":1405.2633377206644},{"$f":"csinterpolate(CSTableU1,'FT240-31'!D18*1000000)","v":1167.1564931270689},{"$f":"csinterpolate(CSTableU1,'FT240-31'!E18*1000000)","v":1090.8817288553466},{"$f":"csinterpolate(CSTableU1,'FT240-31'!F18*1000000)","v":904.13487645220391},{"$f":"csinterpolate(CSTableU1,'FT240-31'!G18*1000000)","v":768.1087633131898},{"$f":"csinterpolate(CSTableU1,'FT240-31'!H18*1000000)","v":674.34694990156652},{"$f":"csinterpolate(CSTableU1,'FT240-31'!I18*1000000)","v":596.87885427126662},{"$f":"csinterpolate(CSTableU1,'FT240-31'!J18*1000000)","v":533.83414302963945},{"$f":"csinterpolate(CSTableU1,'FT240-31'!K18*1000000)","v":484.19554241942296},{"$f":"csinterpolate(CSTableU1,'FT240-31'!L18*1000000)","v":445.06887052678888},{"$f":"csinterpolate(CSTableU1,'FT240-31'!M18*1000000)","v":413.38398426006455},{"$f":"csinterpolate(CSTableU1,'FT240-31'!N18*1000000)","v":363.33657036613073},{"$f":"csinterpolate(CSTableU1,'FT240-31'!O18*1000000)","v":326.44412897168763},{"$f":"csinterpolate(CSTableU1,'FT240-31'!P18*1000000)","v":298.68851642061406},{"$f":"csinterpolate(CSTableU1,'FT240-31'!Q18*1000000)","v":277.14272034646717},{"$f":"csinterpolate(CSTableU1,'FT240-31'!R18*1000000)","v":260.3671935305876},{"$f":"csinterpolate(CSTableU1,'FT240-31'!S18*1000000)","v":247.02909327066405},{"$f":"csinterpolate(CSTableU1,'FT240-31'!T18*1000000)","v":235.79561284039116},{"$f":"csinterpolate(CSTableU1,'FT240-31'!U18*1000000)","v":225.43260312446517},{"$f":"csinterpolate(CSTableU1,'FT240-31'!V18*1000000)","v":215.53473199756411},{"$f":"csinterpolate(CSTableU1,'FT240-31'!W18*1000000)","v":206.11096282499258},{"$f":"csinterpolate(CSTableU1,'FT240-31'!X18*1000000)","v":197.1733795009182},{"$f":"csinterpolate(CSTableU1,'FT240-31'!Y18*1000000)","v":188.73405158778854},{"$f":"csinterpolate(CSTableU1,'FT240-31'!Z18*1000000)","v":180.80504864805121},{"$f":"csinterpolate(CSTableU1,'FT240-31'!AA18*1000000)","v":160.19702617751099},{"$f":"csinterpolate(CSTableU1,'FT240-31'!AB18*1000000)","v":149.0234956597256},{"$f":"csinterpolate(CSTableU1,'FT240-31'!AC18*1000000)","v":139.47392835158013},{"$f":"csinterpolate(CSTableU1,'FT240-31'!AD18*1000000)","v":131.1200510309157},{"$f":"csinterpolate(CSTableU1,'FT240-31'!AE18*1000000)","v":123.5336064588891}]
["Rl",{"$f":"B19/$B$13*$B$16*B18*1000000","v":541.32876453919516},819.43837211056064,1562.6679112515822,1785.211537616434,2259.9139856289767,2634.7256069099453,2958.938022966689,3233.3671361941615,3459.5582370325983,3644.3102664895264,3798.6457604959583,3932.4671515256891,4158.9835609362299,4363.0750920896971,4570.4645596525597,4789.2161484999297,5016.8102295003655,5240.5950840872965,5449.8793964232018,5646.801456633425,5834.1688804270752,6014.2449436668048,6188.7472718300805,6358.8503094689713,6525.1839284422949,6999.8429491435645,7293.0771620314781,7572.796719255517,7843.4448373619207,8107.8565919837083]
["Xl",{"$f":"B20/$B$13*$B$16*B18*1000000","v":1731.9002042660468},2085.1817944761769,2597.8050577204299,2697.8178631218984,2794.9767099450942,2849.3705884979231,2918.4778686013196,2952.2365121329867,2970.4607842062264,2993.6136728446636,3026.8776834662326,3066.9723423698115,3144.9381942688174,3229.2659383898026,3324.0381354585265,3426.9552867542811,3541.4727912633621,3665.5091908214063,3790.3912009979958,3902.5612152674348,3997.730240080803,4077.8010857545637,4144.7864932312241,4200.7586528968322,4247.8494526835757,4357.948493862842,4422.5316601923314,4484.0592615291944,4539.751736039866,4582.5935303320248]
["Yl",{"$f":"IMDIV(1,COMPLEX(B21,B22))","v":"0.000164411928287576-0.000526011309277861i"},"0.000163252219672524-0.000415419350563492i","0.000170030373797759-0.000282661313921868i","0.00017058549183374-0.000257789386502038i","0.000174928046886935-0.000216344436148569i","0.000174940543661163-0.000189192543821886i","0.000171305946196714-0.000168963529771285i","0.000168664884355141-0.000154000028123634i","0.000166387466802815-0.000142864322915724i","0.000163842832326242-0.000134588470021215i","0.000161016207500858-0.000128302662551267i","0.000158116990524192-0.000123317097921162i","0.0001529725297007-0.00011567469413641i","0.000148078631474946-0.000109598223897722i","0.000143102598135769-0.000104076617875066i","0.000138094907102783-0.0000988147240165708i","0.000133035139177882-0.0000939123275801734i","0.000128132553056778-0.0000896217019893704i","0.000123669065281477-0.0000860118367364617i","0.000119848022378615-0.0000828281722765109i","0.000116638183583404-0.0000799236366337985i","0.000113907008673722-0.00007723166049861i","0.000111549463625726-0.0000747079642866679i","0.000109481791534531-0.0000723254300291486i","0.000107636781859687-0.000070070797992118i","0.000102954739510338-0.000064097359790053i","0.000100251569040218-0.0000607926843791712i","0.0000977714907153548-0.0000578931634782878i","0.00009550155780029-0.0000552758860179861i","0.0000934757908270689-0.0000528328972555236i"]
["Yc",{"$f":"COMPLEX(0,2*PI()*B18*1000000*$B$9*0.000000000001)","v":"0.000015707963267949i"},"0.0000188495559215388i","0.0000282743338823081i","0.0000314159265358979i","0.0000392699081698724i","0.0000471238898038469i","0.0000549778714378214i","0.0000628318530717959i","0.0000706858347057703i","0.0000785398163397448i","0.0000863937979737193i","0.0000942477796076938i","0.000109955742875643i","0.000125663706143592i","0.000141371669411541i","0.00015707963267949i","0.000172787595947439i","0.000188495559215388i","0.000204203522483337i","0.000219911485751286i","0.000235619449019234i","0.000251327412287183i","0.000267035375555132i","0.000282743338823081i","0.00029845130209103i","0.000345575191894877i","0.000376991118430775i","0.000408407044966673i","0.000439822971502571i","0.000471238898038469i"]
["Z",{"$f":"IMDIV(1,IMSUM(B23,B24))","v":"571.985381543738+1775.33380400467i"},"887.63160944437+2156.22112692355i","1816.11632016602+2717.14009543441i","2123.17959647916+2817.54037941834i","2823.45983098896+2858.10552245138i","3444.54575627583+2797.3045530571i","4046.10739926185+2692.24872709999i","4588.33713932535+2480.12693996261i","5058.21183181392+2194.24028793407i","5463.99121499263+1869.16538843712i","5816.51905225857+1513.907904411i","6117.6561877996+1124.71211642683i","6527.99740383109+244.052308319463i","6674.60399625977-724.147238072409i","6543.54575787861-1705.36300144481i","6147.11279650865-2593.58562269542i","5561.74963285686-3297.50844471669i","4891.67741016029-3774.67710046803i","4226.07885489515-4038.90320366231i","3614.73795339768-4134.57181987843i","3081.94410291992-4113.9683085642i","2631.61091971028-4022.16059236812i","2256.57358348703-3890.65927833624i","1945.92924675632-3739.96768799925i","1688.59674246172-3582.81405854278i","1146.11345607434-3133.46944974377i","911.114283597163-2873.69975825413i","738.348042512719-2647.00104679738i","608.30176775077-2449.39116462212i","508.569788698907-2276.403863779i"]
["R",{"$f":"IMREAL(B25)","v":571.98538154373796},887.63160944437004,1816.1163201660199,2123.17959647916,2823.4598309889602,3444.5457562758302,4046.1073992618499,4588.3371393253501,5058.2118318139201,5463.9912149926304,5816.5190522585699,6117.6561877996,6527.9974038310902,6674.6039962597697,6543.5457578786099,6147.1127965086498,5561.7496328568604,4891.6774101602896,4226.0788548951496,3614.73795339768,3081.9441029199202,2631.6109197102801,2256.5735834870302,1945.92924675632,1688.5967424617199,1146.1134560743401,911.11428359716297,738.34804251271896,608.30176775076995,508.56978869890702]
["X",{"$f":"IMAGINARY(B25)","v":1775.3338040046699},2156.2211269235499,2717.1400954344099,2817.5403794183399,2858.1055224513798,2797.3045530570998,2692.24872709999,2480.1269399626099,2194.2402879340698,1869.1653884371201,1513.9079044109999,1124.7121164268301,244.05230831946301,-724.14723807240898,-1705.3630014448099,-2593.5856226954202,-3297.5084447166901,-3774.6771004680299,-4038.9032036623098,-4134.5718198784298,-4113.9683085642,-4022.16059236812,-3890.6592783362398,-3739.9676879992498,-3582.81405854278,-3133.4694497437699,-2873.6997582541298,-2647.0010467973798,-2449.39116462212,-2276.4038637789999]
["|Z|",{"$f":"IMABS(B25)","v":1865.2017028572077},2331.7760231798138,3268.1996246543263,3527.9491760168894,4017.5480824347683,4437.3199377137335,4859.9576433270495,5215.7326755155545,5513.6373998201343,5774.8575087917043,6010.3087298677956,6220.1844487892849,6532.5578170898343,6713.7714981443023,6762.1190504270189,6671.8574711434585,6465.8039655994298,6178.7292462018604,5845.7233578356727,5491.9044607009027,5140.3418852634168,4806.5738175479473,4497.7054102948277,4215.9220747850732,3960.7973359847788,3336.4961931151952,3014.6773522824324,2748.048830284642,2523.7963701490694,2332.5217643154397]
[]
[]
[]
["Module","Version","Date"]
["CubicSpline",{"$f":"CubicSpline_version(\"v\")","v":"1.03"},{"$f":"CubicSpline_version(\"d\")","v":"2010-07-06"}]
[]
["Copyright: Owen Duffy 2010. All rights reserved."]

{"sheet":"Mix","index":1,"n_rows":67,"n_cols":17,"rows_kept":67,"cut":false,"hidden":false,"merged":[[4,4,4,6],[4,13,4,15]]}
["Mix","#31"]
["µi",1500]
[]
[]
["# #31 mix u'",null,null,null,"CSTable",null,null,null,null,"# #31 mix u''",null,null,null,"CSTable"]
[100330,1405.71,null,null,{"$f":"cstable(A6:A23,B6:B23)","v":100330},1405.71,0,null,null,99770.4,39.351399999999998,null,null,{"$f":"cstable(Mix!J6:J26,Mix!K6:K26)","v":99770.4},39.351399999999998,0]
[995581,1400.3,null,null,995581,1400.3,2.5523410763140121E-10,null,null,151347,54.429200000000002,null,null,151347,54.429200000000002,-1.5583380542549626E-10]
[1240840,1399.78,null,null,1240840,1399.78,-2.2778261426069622E-9,null,null,232253,77.051299999999998,null,null,232253,77.051299999999998,-4.3358256649668966E-10]
[1583050,1260.3900000000001,null,null,1583050,1260.3900000000001,5.3326712601630861E-10,null,null,386479,118.294,null,null,386479,118.294,9.2949255760222611E-10]
[2019810,1083.3800000000001,null,null,2019810,1083.3800000000001,-8.9394849239975838E-11,null,null,481489,150.898,null,null,481489,150.898,6.1070598337159938E-10]
[2577320,878.71199999999999,null,null,2577320,878.71199999999999,3.1186666726160853E-10,null,null,613839,208.77799999999999,null,null,613839,208.77799999999999,1.5032645696550747E-9]
[3327110,704.46900000000005,null,null,3327110,704.46900000000005,5.7033227415009688E-11,null,null,773490,302.59399999999999,null,null,773490,302.59399999999999,-3.5638652224743055E-10]
[4345270,551.80399999999997,null,null,4345270,551.80399999999997,5.8128194384817832E-11,null,null,952444,409.072,null,null,952444,409.072,2.5466097170413103E-10]
[6014070,412.57,null,null,6014070,412.57,1.7141339208485279E-11,null,null,1257160,579.23900000000003,null,null,1257160,579.23900000000003,-1.3189719256468954E-9]
[8618280,308.45,null,null,8618280,308.45,6.6118259150650408E-12,null,null,1603190,673.32799999999997,null,null,1603190,673.32799999999997,-2.3170149977449743E-10]
[13239300,233.27199999999999,null,null,13239300,233.27199999999999,4.5286535828069747E-13,null,null,2141740,729.97799999999995,null,null,2141740,729.97799999999995,-2.4881561463162642E-10]
[21305700,164.53399999999999,null,null,21305700,164.53399999999999,5.5022332779177218E-13,null,null,2763840,721.24300000000005,null,null,2763840,721.24300000000005,-2.0941242063541992E-11]
[30532100,121.59,null,null,30532100,121.59,5.630717178441426E-14,null,null,3823950,664.58500000000004,null,null,3823950,664.58500000000004,-1.0548103429505719E-11]
[42262900,84.792900000000003,null,null,42262900,84.792900000000003,1.4230865961902145E-13,null,null,5291300,571.17200000000003,null,null,5291300,571.17200000000003,9.6950916614788982E-12]
[55848300,60.525399999999998,null,null,55848300,60.525399999999998,1.7448839428668838E-14,null,null,7407780,463.19600000000003,null,null,7407780,463.19600000000003,1.0324724444143007E-11]
[72958900,40.296900000000001,null,null,72958900,40.296900000000001,3.6228673655313273E-14,null,null,11646200,358.51799999999997,null,null,11646200,358.51799999999997,1.4561039700717933E-12]
[92051100,27.460999999999999,null,null,92051100,27.460999999999999,7.2142586597134589E-15,null,null,21289100,261.77999999999997,null,null,21289100,261.77999999999997,3.9473501242861775E-13]
[101024000,23.0684,null,null,101024000,23.0684,0,null,null,39829700,188.93100000000001,null,null,39829700,188.93100000000001,1.7594208499235938E-14]
[null,null,null,null,null,null,null,null,null,57071300,149.69200000000001,null,null,57071300,149.69200000000001,7.7848056403664947E-14]
[null,null,null,null,null,null,null,null,null,78977100,122.81399999999999,null,null,78977100,122.81399999999999,-4.8087259525886363E-15]
[null,null,null,null,null,null,null,null,null,99611200,101.95399999999999,null,null,99611200,101.95399999999999,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]