{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Spiral_Inductor_Designer","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":48,"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":"Spiral_Inductor_Designer","index":0,"n_rows":305,"n_cols":8,"rows_kept":305,"cut":false,"hidden":false,"merged":[[18,1,18,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"For full functionality, FEMM should be installed. Get FEMM from ",null,null,"www.femm.info"]
[]
[]
[]
[null,"LC Sensor calculations"]
[null,"LDC Device",null,"LDC1612/4"]
[null,"Operating temperature","T",25,"°C","Enter operating temperature"]
[null,"Sensor capacitance","C",100,"pF","Select LC tank capacitance"]
[null,"Layers","M",2,"Layers","Number of layers on PCB board (1≤M≤8)"]
[null,"Turns (per layer)","N",14,"Turns","Number of turns per layer"]
[null,{"$f":"IF(D28=\"Circular\",\"Outer diameter of the inductor\", \"Short Side of inductor\")","v":"Short Side of inductor"},"dOUT",20,"mm","Outer Diameter of the spiral inductor"]
[null,"diameter entered units",{"$f":"E25","v":"mm"},{"$f":"C26","v":"mm"}]
[null,"Outer diameter of inductor in mm",null,{"$f":"IF(D26=\"mm\",D25,D25*0.0254)","v":20},"mm"]
[null,"Sensor Shape",null,"Racetrack"]
[null,"Long side of inductor ","dL",26.88,{"$f":"E25","v":"mm"},{"$f":"IF(D29<D25,\"Sensor Long Side must be longer than Short Side\",\"\")","v":""}]
[null,"Long side of inductor in mm",null,{"$f":"IF(E29=\"mm\",D29,D29*0.0254)","v":26.88},"mm"]
[null,"ratio of long side to short side",null,{"$f":"IF(D28=\"Circular\",1,D30/D27)","v":1.3439999999999999}]
[null,"ratio of area to unit circle",null,{"$f":"1+(4*(D31-1)/PI())","v":1.4379944033888958}]
[null,"spacing between traces","S",4,"mil","Space between traces (mm or mil)"]
[null,"spacing units",{"$f":"E33","v":"mil"},{"$f":"C34","v":"mil"}]
[null,"spacing in mm",null,{"$f":"IF(D34=\"mm\",D33,D33*0.0254)","v":0.1016},"mm"]
[null,"width of trace","w",4,"mil","Width of the trace  (mm or mil)"]
[null,"trace width units",{"$f":"E36","v":"mil"},{"$f":"C37","v":"mil"}]
[null,"trace width in mm",null,{"$f":"IF(D37=\"mm\",D36,D36*0.0254)","v":0.1016},"mm"]
[null,"PCB thickness between 1st layer and 2nd layer","h12",1.5,"mm","Space between layer 1 and 2  (mm or mil)"]
[null,"PCB thickness between 2nd layer and 3rd layer","h23",1.1000000000000001,"mm","Space between layer 2 and 3  (mm or mil)"]
[null,"PCB thickness between 3rd layer and 4th layer","h34",0.185,"mm","Space between layer 3 and 4 (mm or mil)"]
[null,"PCB thickness between 4th layer and 5th layer","h45",8,{"$f":"E41","v":"mm"},"Space between layer 4 and 5  (mm or mil)"]
[null,"PCB thickness between 5th layer and 6th layer","h56",8,"mm","Space between layer 5 and 6  (mm or mil)"]
[null,"PCB thickness between 6th layer and 7th layer","h67",8,"mm","Space between layer 6 and 7  (mm or mil)"]
[null,"PCB thickness between 7th layer and 8th layer","h78",88,"mm","Space between layer 7 and 8  (mm or mil)"]
[null,"Copper thickness","t",1,"oz-Cu","Copper layer thickness  (mm,Oz-Cu, or mil)"]
[null,"copper thickness units",{"$f":"E46","v":"oz-Cu"},{"$f":"C47","v":"oz-Cu"}]
[null,"copper thickness in mm",null,{"$f":"IF(D47=\"mm\",D46, IF(D47=\"mil\",D46*0.0254,D46*0.0347))","v":3.4700000000000002E-2},"mm"]
[null,"Conductor Resistivity (at 20°C)","pr",1.6800000000000002E-8,"Ωm","Use 1.68e-08 for Copper"]
[null,"Conductor Resistivity temperature coef","pr_tc",0.39300000000000002,"%/°C","Use 0.393 for Copper"]
[null,"Conductor relative permeability","µr",1,null,"Use 1.0 for Copper"]
[null,"Parasitic capacitance","Cpar",4,"pF","Estimate - generally in the rage of 1 to 5 pf"]
[null,"Copper resistivity at operating temperature","pr_t ",{"$f":"D49*(1+(D50/100)*(D21-20))","v":1.713012E-8},"Ωm"]
[null,"Coil Fill Ratio","din/dout",{"$f":"D57/D27","v":0.71551999999999993},null,"0.2>  >0.8 is recommended"]
[null,"Average diameter","davg",{"$f":"MAX(0,D32*(D57+D27)/2)","v":24.669081589017186},"mm"]
[null,"Geometric mean diameter","p",{"$f":"(D27-D57)/(D27+D57)","v":0.16582727103152398}]
[null,"Inductor inner diameter (mm)",null,{"$f":"D27-(2*D24+1)*D38-(2*D24-1)*D35","v":14.3104},"mm"]
[null,"Inductor innder diameter desired units",{"$f":"E59","v":"mm"},{"$f":"C58","v":"mm"}]
[null,"Inductor inner diameter","din",{"$f":"IF(D58=\"mm\",D57,D57/0.0254)","v":14.3104},"mm","Inner diameter of the spiral inductor (mm or mil)"]
[null,"Self inductance per layer","L",{"$f":"0.5*4*PI()*0.0001*D24*D24*D55*(LN(2.46/D56)+0.2*D56*D56)","v":8.2101245810018604},"µH"]
[]
[]
[null,"PCB thickness L1-2 ",null,{"$f":"IF(E39=\"mm\",D39,D39*0.0254)","v":1.5},"mm"]
[null,"PCB thickness L2-3 ",null,{"$f":"IF(E40=\"mm\",D40,D40*0.0254)","v":1.1000000000000001},"mm"]
[null,"PCB thickness L3-4",null,0.185,"mm"]
[null,"PCB thickness L4-5",null,8,"mm"]
[null,"PCB thickness L5-6",null,8,"mm"]
[null,"PCB thickness L6-7",null,8,"mm"]
[null,"PCB thickness L7-8",null,88,"mm"]
[]
[null,null,null,{"$f":"IF(E46=\"mm\",D46,D46*0.0254)","v":2.5399999999999999E-2}]
[null,"Number of Turns",null,{"$f":"D24","v":14}]
[null,"Self-Inductance per layer",null,{"$f":"D60","v":8.2101245810018604},"µH"]
[null,"Number of Layers",null,{"$f":"D23","v":2}]
[null,"Target distance",null,{"$f":"D224","v":4},"mm"]
[null,"distance i7-i8",null,{"$f":"D63","v":1.5},"mm"]
[null,"distance i6-i7",null,{"$f":"D89","v":8},"mm"]
[null,"distance i5-i6",null,{"$f":"D88","v":8},"mm"]
[null,"distance i4-i5",null,{"$f":"D87","v":8},"mm"]
[null,"distance i3-i4",null,{"$f":"D86","v":0.185},"mm"]
[null,"distance i2-i3",null,{"$f":"D85","v":1.1000000000000001},"mm"]
[null,"distance i1-i2",null,{"$f":"D84","v":1.5},"mm"]
[null,"distance L1-i1",null,{"$f":"2*D75","v":8},"mm"]
[null,"PCB thickness L1-L2",null,{"$f":"D63","v":1.5},"mm"]
[null,"PCB thickness L2-L3",null,{"$f":"D64","v":1.1000000000000001},"mm"]
[null,"PCB thickness L3-L4",null,0.185,"mm"]
[null,"PCB thickness L4-L5",null,8,"mm"]
[null,"PCB thickness L5-L6",null,8,"mm"]
[null,"PCB thickness L6-L7",null,8,"mm"]
[null,"PCB thickness L7-L8",null,88,"mm"]
[null,"T Scaling",null,{"$f":"1.5625*D72^2/(1.67*D72^2-5.84*D72+65)","v":0.98612184441009787}]
[null,"Lmutual sum",null,{"$f":"(2*SUM(D99:D126))","v":1.001126267050432}]
[null,"scale factor",null,{"$f":"D92*D91+D74","v":2.9872324809511683}]
[null,"Total Inductance free-space",null,{"$f":"D93*D73","v":24.52555082102436}]
[null,"Target Interaction sum",null,{"$f":"SUM(D128:D190)","v":-3.5960015472238635E-2}]
[null,"TI scale",null,{"$f":"(D92+D95)*D91+D74","v":2.9517715241686684}]
[null,"Inductance with Target interaction",null,{"$f":"D96*D73","v":24.23441194807851}]
[]
[null,"Lmutual for 12",null,{"$f":"IF(2>D74,0,1/((0.184*ABS(SUM(D84:D84))^3-0.525*(SUM(D84:D84))^2+1.038*ABS(SUM(D84:D84))+1.001)))","v":0.50056313352521598}]
[null,"Lmutual for 13",null,{"$f":"IF(3>D74,0,1/((0.184*ABS(SUM(D84:D85))^3-0.525*(SUM(D84:D85))^2+1.038*ABS(SUM(D84:D85))+1.001)))","v":0}]
[null,"Lmutual for 14",null,{"$f":"IF(4>D74,0,1/((0.184*ABS(SUM(D84:D86))^3-0.525*(SUM(D84:D86))^2+1.038*ABS(SUM(D84:D86))+1.001)))","v":0}]
[null,"Lmutual for 15",null,{"$f":"IF(5>D74,0,1/((0.184*ABS(SUM(D84:D87))^3-0.525*(SUM(D84:D87))^2+1.038*ABS(SUM(D84:D87))+1.001)))","v":0}]
[null,"Lmutual for 16",null,{"$f":"IF(6>D74,0,1/((0.184*ABS(SUM(D84:D88))^3-0.525*(SUM(D84:D88))^2+1.038*ABS(SUM(D84:D88))+1.001)))","v":0}]
[null,"Lmutual for 17",null,{"$f":"IF(7>D74,0,1/((0.184*ABS(SUM(D84:D89))^3-0.525*(SUM(D84:D89))^2+1.038*ABS(SUM(D84:D89))+1.001)))","v":0}]
[null,"Lmutual for 18",null,{"$f":"IF(8>D74,0,1/((0.184*ABS(SUM(D84:D90))^3-0.525*(SUM(D84:D90))^2+1.038*ABS(SUM(D84:D90))+1.001)))","v":0}]
[null,"Lmutual for 23",null,{"$f":"IF(3>D74,0,1/((0.184*ABS(SUM(D85:D85))^3-0.525*(SUM(D85:D85))^2+1.038*ABS(SUM(D85:D85))+1.001)))","v":0}]
[null,"Lmutual for 24",null,{"$f":"IF(4>D74,0,1/((0.184*ABS(SUM(D85:D86))^3-0.525*(SUM(D85:D86))^2+1.038*ABS(SUM(D85:D86))+1.001)))","v":0}]
[null,"Lmutual for 25",null,{"$f":"IF(5>D74,0,1/((0.184*ABS(SUM(D85:D87))^3-0.525*(SUM(D85:D87))^2+1.038*ABS(SUM(D85:D87))+1.001)))","v":0}]
[null,"Lmutual for 26",null,{"$f":"IF(6>D74,0,1/((0.184*ABS(SUM(D85:D88))^3-0.525*(SUM(D85:D88))^2+1.038*ABS(SUM(D85:D88))+1.001)))","v":0}]
[null,"Lmutual for 27",null,{"$f":"IF(7>D74,0,1/((0.184*ABS(SUM(D85:D89))^3-0.525*(SUM(D85:D89))^2+1.038*ABS(SUM(D85:D89))+1.001)))","v":0}]
[null,"Lmutual for 28",null,{"$f":"IF(8>D74,0,1/((0.184*ABS(SUM(D85:D90))^3-0.525*(SUM(D85:D90))^2+1.038*ABS(SUM(D85:D90))+1.001)))","v":0}]
[null,"Lmutual for 34",null,{"$f":"IF(4>D74,0,1/((0.184*ABS(SUM(D86:D86))^3-0.525*(SUM(D86:D86))^2+1.038*ABS(SUM(D86:D86))+1.001)))","v":0}]
[null,"Lmutual for 35",null,{"$f":"IF(5>D74,0,1/((0.184*ABS(SUM(D86:D87))^3-0.525*(SUM(D86:D87))^2+1.038*ABS(SUM(D86:D87))+1.001)))","v":0}]
[null,"Lmutual for 36",null,{"$f":"IF(6>D74,0,1/((0.184*ABS(SUM(D86:D88))^3-0.525*(SUM(D86:D88))^2+1.038*ABS(SUM(D86:D88))+1.001)))","v":0}]
[null,"Lmutual for 37",null,{"$f":"IF(7>D74,0,1/((0.184*ABS(SUM(D86:D89))^3-0.525*(SUM(D86:D89))^2+1.038*ABS(SUM(D86:D89))+1.001)))","v":0}]
[null,"Lmutual for 38",null,{"$f":"IF(8>D74,0,1/((0.184*ABS(SUM(D86:D90))^3-0.525*(SUM(D86:D90))^2+1.038*ABS(SUM(D86:D90))+1.001)))","v":0}]
[null,"Lmutual for 45",null,{"$f":"IF(5>D74,0,1/((0.184*ABS(SUM(D87:D87))^3-0.525*(SUM(D87:D87))^2+1.038*ABS(SUM(D87:D87))+1.001)))","v":0}]
[null,"Lmutual for 46",null,{"$f":"IF(6>D74,0,1/((0.184*ABS(SUM(D87:D88))^3-0.525*(SUM(D87:D88))^2+1.038*ABS(SUM(D87:D88))+1.001)))","v":0}]
[null,"Lmutual for 47",null,{"$f":"IF(7>D74,0,1/((0.184*ABS(SUM(D87:D89))^3-0.525*(SUM(D87:D89))^2+1.038*ABS(SUM(D87:D89))+1.001)))","v":0}]
[null,"Lmutual for 48",null,{"$f":"IF(8>D74,0,1/((0.184*ABS(SUM(D87:D90))^3-0.525*(SUM(D87:D90))^2+1.038*ABS(SUM(D87:D90))+1.001)))","v":0}]
[null,"Lmutual for 56",null,{"$f":"IF(6>D74,0,1/((0.184*ABS(SUM(D88:D88))^3-0.525*(SUM(D88:D88))^2+1.038*ABS(SUM(D88:D88))+1.001)))","v":0}]
[null,"Lmutual for 57",null,{"$f":"IF(7>D74,0,1/((0.184*ABS(SUM(D88:D89))^3-0.525*(SUM(D88:D89))^2+1.038*ABS(SUM(D88:D89))+1.001)))","v":0}]
[null,"Lmutual for 58",null,{"$f":"IF(8>D74,0,1/((0.184*ABS(SUM(D88:D90))^3-0.525*(SUM(D88:D90))^2+1.038*ABS(SUM(D88:D90))+1.001)))","v":0}]
[null,"Lmutual for 67",null,{"$f":"IF(7>D74,0,1/((0.184*ABS(SUM(D89:D89))^3-0.525*(SUM(D89:D89))^2+1.038*ABS(SUM(D89:D89))+1.001)))","v":0}]
[null,"Lmutual for 68",null,{"$f":"IF(8>D74,0,1/((0.184*ABS(SUM(D89:D90))^3-0.525*(SUM(D89:D90))^2+1.038*ABS(SUM(D89:D90))+1.001)))","v":0}]
[null,"Lmutual for 78",null,{"$f":"IF(8>D74,0,1/((0.184*ABS(SUM(D90:D90))^3-0.525*(SUM(D90:D90))^2+1.038*ABS(SUM(D90:D90))+1.001)))","v":0}]
[]
[null,"Lmutual for i1-L1",null,{"$f":"IF(1>D74,0,-1/((0.184*ABS(SUM(D83:D83))^3-0.525*(SUM(D83:D83))^2+1.038*ABS(SUM(D83:D83))+1.001)))","v":-1.4303491482270824E-2}]
[null,"Lmutual for i1-L2",null,{"$f":"IF(2>D74,0,-1/((0.184*ABS(SUM(D83:D84))^3-0.525*(SUM(D83:D84))^2+1.038*ABS(SUM(D83:D84))+1.001)))","v":-8.2482560093700176E-3}]
[null,"Lmutual for i1-L3",null,{"$f":"IF(3>D74,0,-1/((0.184*ABS(SUM(D83:D85))^3-0.525*(SUM(D83:D85))^2+1.038*ABS(SUM(D83:D85))+1.001)))","v":0}]
[null,"Lmutual for i1-L4",null,{"$f":"IF(4>D74,0,-1/((0.184*ABS(SUM(D83:D86))^3-0.525*(SUM(D83:D86))^2+1.038*ABS(SUM(D83:D86))+1.001)))","v":0}]
[null,"Lmutual for i1-L5",null,{"$f":"IF(5>D74,0,-1/((0.184*ABS(SUM(D83:D87))^3-0.525*(SUM(D83:D87))^2+1.038*ABS(SUM(D83:D87))+1.001)))","v":0}]
[null,"Lmutual for i1-L6",null,{"$f":"IF(6>D74,0,-1/((0.184*ABS(SUM(D83:D88))^3-0.525*(SUM(D83:D88))^2+1.038*ABS(SUM(D83:D88))+1.001)))","v":0}]
[null,"Lmutual for i1-L7",null,{"$f":"IF(7>D74,0,-1/((0.184*ABS(SUM(D83:D89))^3-0.525*(SUM(D83:D89))^2+1.038*ABS(SUM(D83:D89))+1.001)))","v":0}]
[null,"Lmutual for i1-L8",null,{"$f":"IF(8>D74,0,-1/((0.184*ABS(SUM(D83:D90))^3-0.525*(SUM(D83:D90))^2+1.038*ABS(SUM(D83:D90))+1.001)))","v":0}]
[null,"Lmutual for i2-L1",null,{"$f":"IF(2>D74,0,-1/((0.184*ABS(SUM(D82:D83))^3-0.525*(SUM(D82:D83))^2+1.038*ABS(SUM(D82:D83))+1.001)))","v":-8.2482560093700176E-3}]
[null,"Lmutual for i2-L2",null,{"$f":"IF(2>D74,0,-1/((0.184*ABS(SUM(D82:D84))^3-0.525*(SUM(D82:D84))^2+1.038*ABS(SUM(D82:D84))+1.001)))","v":-5.1600119712277735E-3}]
[null,"Lmutual for i2-L3",null,{"$f":"IF(3>D74,0,-1/((0.184*ABS(SUM(D82:D85))^3-0.525*(SUM(D82:D85))^2+1.038*ABS(SUM(D82:D85))+1.001)))","v":0}]
[null,"Lmutual for i2-L4",null,{"$f":"IF(4>D74,0,-1/((0.184*ABS(SUM(D82:D86))^3-0.525*(SUM(D82:D86))^2+1.038*ABS(SUM(D82:D86))+1.001)))","v":0}]
[null,"Lmutual for i2-L5",null,{"$f":"IF(5>D74,0,-1/((0.184*ABS(SUM(D82:D87))^3-0.525*(SUM(D82:D87))^2+1.038*ABS(SUM(D82:D87))+1.001)))","v":0}]
[null,"Lmutual for i2-L6",null,{"$f":"IF(6>D74,0,-1/((0.184*ABS(SUM(D82:D88))^3-0.525*(SUM(D82:D88))^2+1.038*ABS(SUM(D82:D88))+1.001)))","v":0}]
[null,"Lmutual for i2-L7",null,{"$f":"IF(7>D74,0,-1/((0.184*ABS(SUM(D82:D89))^3-0.525*(SUM(D82:D89))^2+1.038*ABS(SUM(D82:D89))+1.001)))","v":0}]
[null,"Lmutual for i2-L8",null,{"$f":"IF(8>D74,0,-1/((0.184*ABS(SUM(D82:D90))^3-0.525*(SUM(D82:D90))^2+1.038*ABS(SUM(D82:D90))+1.001)))","v":0}]
[null,"Lmutual for i3-L1",null,{"$f":"IF(3>D74,0,-1/((0.184*ABS(SUM(D81:D83))^3-0.525*(SUM(D81:D83))^2+1.038*ABS(SUM(D81:D83))+1.001)))","v":0}]
[null,"Lmutual for i3-L2",null,{"$f":"IF(3>D74,0,-1/((0.184*ABS(SUM(D81:D84))^3-0.525*(SUM(D81:D84))^2+1.038*ABS(SUM(D81:D84))+1.001)))","v":0}]
[null,"Lmutual for i3-L3",null,{"$f":"IF(3>D74,0,-1/((0.184*ABS(SUM(D81:D85))^3-0.525*(SUM(D81:D85))^2+1.038*ABS(SUM(D81:D85))+1.001)))","v":0}]
[null,"Lmutual for i3-L4",null,{"$f":"IF(4>D74,0,-1/((0.184*ABS(SUM(D81:D86))^3-0.525*(SUM(D81:D86))^2+1.038*ABS(SUM(D81:D86))+1.001)))","v":0}]
[null,"Lmutual for i3-L5",null,{"$f":"IF(5>D74,0,-1/((0.184*ABS(SUM(D81:D87))^3-0.525*(SUM(D81:D87))^2+1.038*ABS(SUM(D81:D87))+1.001)))","v":0}]
[null,"Lmutual for i3-L6",null,{"$f":"IF(6>D74,0,-1/((0.184*ABS(SUM(D81:D88))^3-0.525*(SUM(D81:D88))^2+1.038*ABS(SUM(D81:D88))+1.001)))","v":0}]
[null,"Lmutual for i3-L7",null,{"$f":"IF(7>D74,0,-1/((0.184*ABS(SUM(D81:D89))^3-0.525*(SUM(D81:D89))^2+1.038*ABS(SUM(D81:D89))+1.001)))","v":0}]
[null,"Lmutual for i3-L8",null,{"$f":"IF(8>D74,0,-1/((0.184*ABS(SUM(D81:D90))^3-0.525*(SUM(D81:D90))^2+1.038*ABS(SUM(D81:D90))+1.001)))","v":0}]
[null,"Lmutual for i4-L1",null,{"$f":"IF(4>D74,0,-1/((0.184*ABS(SUM(D80:D83))^3-0.525*(SUM(D80:D83))^2+1.038*ABS(SUM(D80:D83))+1.001)))","v":0}]
[null,"Lmutual for i4-L2",null,{"$f":"IF(4>D74,0,-1/((0.184*ABS(SUM(D80:D84))^3-0.525*(SUM(D80:D84))^2+1.038*ABS(SUM(D80:D84))+1.001)))","v":0}]
[null,"Lmutual for i4-L3",null,{"$f":"IF(4>D74,0,-1/((0.184*ABS(SUM(D80:D85))^3-0.525*(SUM(D80:D85))^2+1.038*ABS(SUM(D80:D85))+1.001)))","v":0}]
[null,"Lmutual for i4-L4",null,{"$f":"IF(4>D74,0,-1/((0.184*ABS(SUM(D80:D86))^3-0.525*(SUM(D80:D86))^2+1.038*ABS(SUM(D80:D86))+1.001)))","v":0}]
[null,"Lmutual for i4-L5",null,{"$f":"IF(5>D74,0,-1/((0.184*ABS(SUM(D80:D87))^3-0.525*(SUM(D80:D87))^2+1.038*ABS(SUM(D80:D87))+1.001)))","v":0}]
[null,"Lmutual for i4-L6",null,{"$f":"IF(6>D74,0,-1/((0.184*ABS(SUM(D80:D88))^3-0.525*(SUM(D80:D88))^2+1.038*ABS(SUM(D80:D88))+1.001)))","v":0}]
[null,"Lmutual for i4-L7",null,{"$f":"IF(7>D74,0,-1/((0.184*ABS(SUM(D80:D89))^3-0.525*(SUM(D80:D89))^2+1.038*ABS(SUM(D80:D89))+1.001)))","v":0}]
[null,"Lmutual for i4-L8",null,{"$f":"IF(8>D74,0,-1/((0.184*ABS(SUM(D80:D90))^3-0.525*(SUM(D80:D90))^2+1.038*ABS(SUM(D80:D90))+1.001)))","v":0}]
[null,"Lmutual for i5-L1",null,{"$f":"IF(5>D74,0,-1/((0.184*ABS(SUM(D79:D83))^3-0.525*(SUM(D79:D83))^2+1.038*ABS(SUM(D79:D83))+1.001)))","v":0}]
[null,"Lmutual for i5-L2",null,{"$f":"IF(5>D74,0,-1/((0.184*ABS(SUM(D79:D84))^3-0.525*(SUM(D79:D84))^2+1.038*ABS(SUM(D79:D84))+1.001)))","v":0}]
[null,"Lmutual for i5-L3",null,{"$f":"IF(5>D74,0,-1/((0.184*ABS(SUM(D79:D85))^3-0.525*(SUM(D79:D85))^2+1.038*ABS(SUM(D79:D85))+1.001)))","v":0}]
[null,"Lmutual for i5-L4",null,{"$f":"IF(5>D74,0,-1/((0.184*ABS(SUM(D79:D86))^3-0.525*(SUM(D79:D86))^2+1.038*ABS(SUM(D79:D86))+1.001)))","v":0}]
[null,"Lmutual for i5-L5",null,{"$f":"IF(5>D74,0,-1/((0.184*ABS(SUM(D79:D87))^3-0.525*(SUM(D79:D87))^2+1.038*ABS(SUM(D79:D87))+1.001)))","v":0}]
[null,"Lmutual for i5-L6",null,{"$f":"IF(6>D74,0,-1/((0.184*ABS(SUM(D79:D88))^3-0.525*(SUM(D79:D88))^2+1.038*ABS(SUM(D79:D88))+1.001)))","v":0}]
[null,"Lmutual for i5-L7",null,{"$f":"IF(7>D74,0,-1/((0.184*ABS(SUM(D79:D89))^3-0.525*(SUM(D79:D89))^2+1.038*ABS(SUM(D79:D89))+1.001)))","v":0}]
[null,"Lmutual for i5-L8",null,{"$f":"IF(8>D74,0,-1/((0.184*ABS(SUM(D79:D90))^3-0.525*(SUM(D79:D90))^2+1.038*ABS(SUM(D79:D90))+1.001)))","v":0}]
[null,"Lmutual for i6-L1",null,{"$f":"IF(6>D74,0,-1/((0.184*ABS(SUM(D78:D83))^3-0.525*(SUM(D78:D83))^2+1.038*ABS(SUM(D78:D83))+1.001)))","v":0}]
[null,"Lmutual for i6-L2",null,{"$f":"IF(6>D74,0,-1/((0.184*ABS(SUM(D78:D84))^3-0.525*(SUM(D78:D84))^2+1.038*ABS(SUM(D78:D84))+1.001)))","v":0}]
[null,"Lmutual for i6-L3",null,{"$f":"IF(6>D74,0,-1/((0.184*ABS(SUM(D78:D85))^3-0.525*(SUM(D78:D85))^2+1.038*ABS(SUM(D78:D85))+1.001)))","v":0}]
[null,"Lmutual for i6-L4",null,{"$f":"IF(6>D74,0,-1/((0.184*ABS(SUM(D78:D86))^3-0.525*(SUM(D78:D86))^2+1.038*ABS(SUM(D78:D86))+1.001)))","v":0}]
[null,"Lmutual for i6-L5",null,{"$f":"IF(6>D74,0,-1/((0.184*ABS(SUM(D78:D87))^3-0.525*(SUM(D78:D87))^2+1.038*ABS(SUM(D78:D87))+1.001)))","v":0}]
[null,"Lmutual for i6-L6",null,{"$f":"IF(6>D74,0,-1/((0.184*ABS(SUM(D78:D88))^3-0.525*(SUM(D78:D88))^2+1.038*ABS(SUM(D78:D88))+1.001)))","v":0}]
[null,"Lmutual for i6-L7",null,{"$f":"IF(7>D74,0,-1/((0.184*ABS(SUM(D78:D89))^3-0.525*(SUM(D78:D89))^2+1.038*ABS(SUM(D78:D89))+1.001)))","v":0}]
[null,"Lmutual for i6-L8",null,{"$f":"IF(8>D74,0,-1/((0.184*ABS(SUM(D78:D90))^3-0.525*(SUM(D78:D90))^2+1.038*ABS(SUM(D78:D90))+1.001)))","v":0}]
[null,"Lmutual for i7-L1",null,{"$f":"IF(7>D74,0,-1/((0.184*ABS(SUM(D77:D83))^3-0.525*(SUM(D77:D83))^2+1.038*ABS(SUM(D77:D83))+1.001)))","v":0}]
[null,"Lmutual for i7-L2",null,{"$f":"IF(7>D74,0,-1/((0.184*ABS(SUM(D77:D84))^3-0.525*(SUM(D77:D84))^2+1.038*ABS(SUM(D77:D84))+1.001)))","v":0}]
[null,"Lmutual for i7-L3",null,{"$f":"IF(7>D74,0,-1/((0.184*ABS(SUM(D77:D85))^3-0.525*(SUM(D77:D85))^2+1.038*ABS(SUM(D77:D85))+1.001)))","v":0}]
[null,"Lmutual for i7-L4",null,{"$f":"IF(7>D74,0,-1/((0.184*ABS(SUM(D77:D86))^3-0.525*(SUM(D77:D86))^2+1.038*ABS(SUM(D77:D86))+1.001)))","v":0}]
[null,"Lmutual for i7-L5",null,{"$f":"IF(7>D74,0,-1/((0.184*ABS(SUM(D77:D87))^3-0.525*(SUM(D77:D87))^2+1.038*ABS(SUM(D77:D87))+1.001)))","v":0}]
[null,"Lmutual for i7-L6",null,{"$f":"IF(7>D74,0,-1/((0.184*ABS(SUM(D77:D88))^3-0.525*(SUM(D77:D88))^2+1.038*ABS(SUM(D77:D88))+1.001)))","v":0}]
[null,"Lmutual for i7-L7",null,{"$f":"IF(7>D74,0,-1/((0.184*ABS(SUM(D77:D89))^3-0.525*(SUM(D77:D89))^2+1.038*ABS(SUM(D77:D89))+1.001)))","v":0}]
[null,"Lmutual for i7-L8",null,{"$f":"IF(8>D74,0,-1/((0.184*ABS(SUM(D77:D90))^3-0.525*(SUM(D77:D90))^2+1.038*ABS(SUM(D77:D90))+1.001)))","v":0}]
[null,"Lmutual for i8-L2",null,{"$f":"IF(8>D74,0,-1/((0.184*ABS(SUM(D76:D84))^3-0.525*(SUM(D76:D84))^2+1.038*ABS(SUM(D76:D84))+1.001)))","v":0}]
[null,"Lmutual for i8-L3",null,{"$f":"IF(8>D74,0,-1/((0.184*ABS(SUM(D76:D85))^3-0.525*(SUM(D76:D85))^2+1.038*ABS(SUM(D76:D85))+1.001)))","v":0}]
[null,"Lmutual for i8-L4",null,{"$f":"IF(8>D74,0,-1/((0.184*ABS(SUM(D76:D86))^3-0.525*(SUM(D76:D86))^2+1.038*ABS(SUM(D76:D86))+1.001)))","v":0}]
[null,"Lmutual for i8-L5",null,{"$f":"IF(8>D74,0,-1/((0.184*ABS(SUM(D76:D87))^3-0.525*(SUM(D76:D87))^2+1.038*ABS(SUM(D76:D87))+1.001)))","v":0}]
[null,"Lmutual for i8-L6",null,{"$f":"IF(8>D74,0,-1/((0.184*ABS(SUM(D76:D88))^3-0.525*(SUM(D76:D88))^2+1.038*ABS(SUM(D76:D88))+1.001)))","v":0}]
[null,"Lmutual for i8-L7",null,{"$f":"IF(8>D74,0,-1/((0.184*ABS(SUM(D76:D89))^3-0.525*(SUM(D76:D89))^2+1.038*ABS(SUM(D76:D89))+1.001)))","v":0}]
[null,"Lmutual for i8-L8",null,{"$f":"IF(8>D74,0,-1/((0.184*ABS(SUM(D76:D90))^3-0.525*(SUM(D76:D90))^2+1.038*ABS(SUM(D76:D90))+1.001)))","v":0}]
[]
[null,"Sensor Free-Space Inductance",null,{"$f":"D195","v":24.52555082102436},"µH"]
[null,"Sensor Inductance with Target interaction",null,{"$f":"D97","v":24.23441194807851},"µH"]
[]
[null,"Total Inductance with no target","LTOTAL",{"$f":"D94","v":24.52555082102436},"µH",{"$f":"IF(D195=\"Error\",\"Too many turns or outer diameter too small!\",\"\")","v":""}]
[null,"Sensor Operating Frequency",null,{"$f":"IF(D20=\"LDC0851\",SQRT(2)/(2*PI()*SQRT(D195*0.000001*(D22+D52)*0.000000000001)),1/(2*PI()*SQRT(D195*0.000001*(D22+D52)*0.000000000001)))","v":3151331.4012928475},"Hz"]
[null,"Sensor Operating Frequency no target","fRES",{"$f":"IF(D196>300000,D196/1000000,D196/1000)","v":3.1513314012928473},{"$f":"IF(D196>300000,\"MHz\",\"kHz\")","v":"MHz"},{"$f":"IF(ISERROR(D197),\"\",IF(D197>(D207*1000),\"Sensor Frequency is too high, reduce C\",\"\"))","v":""}]
[null,"coil length per layer","l",{"$f":"D24*(D31-1)*2*D27+PI()*D24*(D27+D57)/2","v":947.16510407209057},"mm"]
[null,"DC resistance","Rdc",{"$f":"D53*D198*0.001*D23/(D38*0.001*D48*0.001)","v":9.2043453973129647},"Ω"]
[null,"Skin depth","sd",{"$f":"SQRT(D49/(4*PI()*PI()*0.0000001*D51*D196))*1000","v":3.674749453716529E-2},"mm"]
[null,"AC resistance (skin effect only)","Rs",{"$f":"D199*D48/(D200*(1-EXP(-D48/D200)))","v":14.224077045016568},"Ω"]
[null,"Resonance impedance estimate","Rp",{"$f":"(1/D201)*(D195*0.000001/(D22*0.000000000001))","v":17242.279230775774},"Ω"]
[null,"Rp with no Target","RP",{"$f":"D202/1000","v":17.242279230775775},"kΩ"]
[null,"Q factor","Q",{"$f":"(1/D201)*SQRT(D195*0.000001/((D22+D52)*0.000000000001))","v":34.14040111743796}]
[]
[]
[null,"Self resonant frequency (estimated)","SRF",{"$f":"1/(2*PI()*SQRT(D195*0.000001*D52*0.000000000001))/1000000","v":16.068700308989925},"MHz","SRF must be >1.25*Fsensor"]
[null,"Target Material",null,"430 Stainless Steel",null,"Select Air for No Target"]
[null,null,null,"Target Materials:"]
[null,null,null,"1006 Steel"]
[null,null,null,"304 Stainless Steel"]
[null,null,null,"316 Stainless Steel"]
[null,null,null,"416 stainless steel, annealed"]
[null,null,null,"430 Stainless Steel"]
[null,null,null,"Air "]
[null,null,null,"Aluminum, 1100"]
[null,null,null,"Aluminum, 6061-T6"]
[null,null,null,"Copper"]
[null,null,null,"Titanium"]
[null,"Other target material - enter here & select above",null,"enter here",null,"Enter exactly as named in FEMM materials library"]
[null,"Target Thickness",null,0.15,"mm"]
[null,"Target Distance","D",4,"mm"]
[null,null,{"$f":"E222","v":"mm"},{"$f":"C223","v":"mm"}]
[null,"Target Distance in mm",null,{"$f":"IF(D223=\"mm\",D222,D222*0.0254)","v":4},"mm"]
[null,"Target Distance/Sensor Diameter Ratio",null,{"$f":"D224/D27","v":0.2}]
[null,"RP Adjust Factor",null,{"$f":" 12.413*D225^4 - 11.107*D225^3 - 1.1159*D225^2 + 3.6107*D225+ 0.0669","v":0.67540879999999992}]
[null,"RP Adjust Factor (clipped)",null,{"$f":"MIN(D226,1)","v":0.67540879999999992}]
[null,"Target Conductivity (composition & thickness)",null,1]
[]
[null,"New Inductance with target",null,{"$f":"IF(EXACT(D208,D215), D195,D193)","v":24.23441194807851},"µH"]
[null,"Skin depth at new sensor frequency","sd'",{"$f":"SQRT(D49/(4*PI()*PI()*0.1*D51*D241))*1000","v":3.6637949777637617E-2},"mm"]
[null,"New Rs based on skin effect","Rs",{"$f":"D199*D48/(D231*(1-EXP(-D48/D231)))","v":14.241048142278729},"Ω"]
[null,"New Rp ","Rp",{"$f":"(1/D232)*(D240*0.000001/(D22*0.000000000001))","v":17017.295149878431},"Ω"]
[null,"Device Min Fsensor",null,{"$f":"INDEX(G281:G287,MATCH(D20,B281:B287,0))","v":1E-3},"MHz"]
[null,"Device Max Fsensor",null,{"$f":"INDEX(H281:H287,MATCH(D20,B281:B287,0))","v":10},"MHz"]
[null,"Device Min Rp",null,{"$f":"INDEX(C281:C287,MATCH(D20,B281:B287,0))","v":0.25},"kΩ"]
[null,"Device Max Rp",null,{"$f":"INDEX(D281:D287,MATCH(D20,B281:B287,0))","v":500},"kΩ"]
[null,"Device Min Q",null,{"$f":"INDEX(E281:E287,MATCH(D20,B281:B287,0))","v":2.5}]
[null,"Device Max Q",null,{"$f":"INDEX(F281:F287,MATCH(D20,B281:B287,0))","v":1000}]
[null,"Sensor Inductance from Target Interaction","L'",{"$f":"D230","v":24.23441194807851},"µH"]
[null,"Sensor Frequency with Target Interaction","fRES'",{"$f":"IF(D20=\"LDC0851\",1000/(PI()*SQRT(2*D22*D240)),1000/(2*PI()*SQRT((D22+D52)*D240)))","v":3.1702040686543103},"MHz",{"$f":"IF(ISERROR(D241),\"\",IF(D241<D234,\"Fsensor is too low\",IF(D241>D235,\"Fsensor is too high - increase L or C\",\"\")))","v":""}]
[null,"Rp with Target Interation","RP'",{"$f":"D233/1000","v":17.017295149878432},"kΩ",{"$f":"IF(ISERROR(D242),\"\",IF(D242<D236,\"Sensor Rp is too low - try a lower C or higher L\",IF(D242>D237,\"Sensor Rp too high\",\"\")))","v":""}]
[null,"Q Factor with target","Q'",{"$f":"(D242)*SQRT(D22/D240)","v":34.568002793141559},null,{"$f":"IF(ISERROR(D243),\"\",IF(D243<D238,\"Sensor Q is too low\",IF(D243>D239,\"Sensor Q too high\",\"\")))","v":""}]
[null,"Min Ccom","Ccom-min",{"$f":"0.001*ROUND((100*D22/D243),-2)","v":0.3},"nF"]
[null,"Max Ccom","Ccom-max",{"$f":"0.001*ROUND((1250*D22/D243),-1)","v":3.62},"nF"]
[null,{"$f":"IF(D20=B286,B289,\"\")","v":""},{"$f":"IF(D20=B286,C289,\"\")","v":""},{"$f":"IF(D20=B286,TEXT(D244,\"##0.0#\")&\"< C <\"&TEXT(D245,\"###.0\"),\"\")","v":""},{"$f":"IF(D20=B286,\"nF\",\"\")","v":""}]
[]
[null,"FEMM Simulation Results (only updated after pressing Run FEMM button)"]
[null,"Pass Parameters for FEMM SIM"]
[null,"Num Layers",null,{"$f":"D23","v":2}]
[null,"PCB thickness L1-2 mm",null,{"$f":"D63","v":1.5}]
[null,"PCB thickness L2-3 mm",null,{"$f":"D64","v":1.1000000000000001}]
[null,"PCB thickness L3-4 mm",null,0.185]
[null,"PCB thickness L4-5 mm",null,8]
[null,"PCB thickness L5-6 mm",null,8]
[null,"PCB thickness L6-7 mm",null,8]
[null,"PCB thickness L7-8 mm",null,88]
[null,"num Turns",null,{"$f":"D24","v":14}]
[null,"Outer Diameter in mm",null,{"$f":"D27","v":20}]
[null,"Trace Width in mm",null,{"$f":"D38","v":0.1016}]
[null,"Trace Space in mm",null,{"$f":"D35","v":0.1016}]
[null,"Trace Thickness in mm",null,{"$f":"D48","v":3.4700000000000002E-2}]
[null,"Trace Conductivity RB",null,{"$f":"D53","v":1.713012E-8}]
[null,"Target Material",null,{"$f":"D208","v":"430 Stainless Steel"}]
[null,"Target Thickness",null,{"$f":"D221","v":0.15}]
[null,"Target Distance",null,{"$f":"D222","v":4}]
[null,"Csensor",null,{"$f":"D22+D52","v":104}]
[null,"Initial Fsensor MHz",null,{"$f":"IF(ISNUMBER(D241),D241,1)","v":3.1702040686543103}]
[null,"Inner Diameter",null,{"$f":"D57","v":14.3104}]
[null,"Long side for racetrack in mm",null,{"$f":"D30","v":26.88}]
[null,"Save FEM simulation to file",null,true]
[null,"Run sensitivity",null,false]
[null,"L",null,null,"µH"]
[null,"Rp",null,null,"kΩ"]
[null,"Q"]
[null,"Sensor Frequency with Target",null,null,"MHz"]
[null,"Target Movement shift",null,1E-3,"mm"]
[null,"Sensor  Frequency at shifted target",null,null,"MHz"]
[null,"Sensitivity (frequency shift)",null,null,"ppm/µm"]
[null,"Device","MinRp","MaxRp","MinQ","MaxQ","MinFs","MaxFs"]
[null,"LDC1101",1,60,2.5,100,0.5,10]
[null,"LDC1000",1,1000,2.5,1000,5.0000000000000001E-3,5]
[null,"LDC1612/4",0.25,500,2.5,1000,1E-3,10]
[null,"LDC1312/4",0.25,500,2.5,1000,1E-3,10]
[null,"LDC0851",0.01,500,1,1000,0.3,19]
[null,"LDC2112/4",0.35,10,5,30,1,30]
[null,"LDC3114",0.35,10,5,30,5,30]
[]
[null,"Ccom Value (with Target)","Ccom"]
[]
[]
[]
[]
[null,"Quick Sensor L/C/f Calculator:"]
[null,{"$f":"IF(B297=\"L\",\"fsensor\",\"L\")","v":"L"},8,{"$f":"IF(B295=\"fsensor\",\"MHz\",\"µH\")","v":"µH"}]
[null,{"$f":"IF(B297=\"C\",\"fsensor\",\"C\")","v":"C"},220,{"$f":"IF(B296=\"fsensor\",\"MHz\",\"pF\")","v":"pF"}]
[null,"fsensor",{"$f":"IF(B297=\"fsensor\",0.000001/(2*PI()*SQRT(C295*0.000001*C296*0.000000000001)),IF(B297=\"C\",1000000000000/((C295*0.000001)*(2*PI()*C296*1000000)^2),1000000/((C296*0.000000000001)*(2*PI()*C295*1000000)^2)))","v":3.7937071032908358},{"$f":"IF(B297=\"fsensor\",\"MHz\",IF(B297=\"L\",\"µH\",\"pF\"))","v":"MHz"}]
[]
[null,"Quick Sensor Rp/Rs/Q Calculator:"]
[null,"L",8,"µH"]
[null,"C",220,"pF"]
[null,{"$f":"IF(B303=\"Rp\",\"Rs\",\"Rp\")","v":"Rs"},8,{"$f":"IF(B303=\"Rp\",\"Ω\",\"kΩ\")","v":"Ω"}]
[null,"Rp",{"$f":"1000/C302*C300/C301","v":4.5454545454545459},{"$f":"IF(B303=\"Rp\",\"kΩ\",\"Ω\")","v":"kΩ"}]
[null,"fsensor",{"$f":"(0.000001/(2*PI()*SQRT(C300*0.000001*C301*0.000000000001)))","v":3.7937071032908358},"MHz"]
[null,"Q",{"$f":"IF(B303=\"Rs\",(1000/C303)*SQRT(C300/C301),(1000/C302)*SQRT(C300/C301))","v":23.836564731139806}]

{"sheet":"Sheet1","index":1,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,null,5.7000000000000003E-5,"ohm/cm"]
[null,null,null,null,100,"cm/m"]
[null,null,null,null,{"$f":"E7*E6","v":5.7000000000000002E-3},"ohm/m"]
[null,null,null,null,{"$f":"1/E8","v":175.43859649122805},"mS"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"0.5mm"]
[null,null,"L",3.3185564969440384,3.16859]
[null,null,"Rp",3.3133044907510896]
[null,null,"Q",27.159778267581647]
[null,null,"Sensor Frequency with Target",5.8374277000851356,5.9739708461052716]
[null,null,"Target Movement shift",1E-3]
[null,null,"Sensor  Frequency at shifted target",5.8381898801003826]
[null,null,"Sensitivity (frequency shift)",130.56778677296495]
[]
[]
[]
[]
[]
[null,null,16000000]
[null,null,2000]
[null,null,{"$f":"C30/C31","v":8000}]
[null,null,{"$f":"C32/16","v":500}]
[null,null,{"$f":"DEC2HEX(C33)","v":"1F4"}]
[]
[]
[null,null,400]
[null,null,{"$f":"HEX2DEC(\"400\")","v":1024}]
[null,null,{"$f":"C38*16","v":16384}]
[null,null,{"$f":"16000000/C39","v":976.5625}]