基于Excel处理铁磁材料截面内磁场分布数据

Data processing of "magnetic field distribution in cross section of ferromagnet" based on Excel

基于霍尔效应,并采用空间方向对称法,利用霍尔器件测量得到铁磁材料横断面微小间隙内的磁场分布,并利用Excel处理实验数据,得到间隙内磁场分布的三维立体效果图。该方法可推广到其他类型性质的磁场。同时,利用Excel可轻松的实现数据的管理和分析处理。

Based on Hall effects, with the method of directional symmetry, magnetic field distribution in cross section of ferromagnet is measured. Experimental data are processed by using Excel which presented three-dimensional surface figure of magnetic field distribution in cross seetion of ferromagnet. The method can be extended to the other types of magnetic field with different characters. Meantime, Excel can help us realizing data management and analyse processing with ease.