Main content | Navigation bar | Inside menu | Footer


Back to Top

Back to Top



Demagnetization Analysis In Excel

An open source workbook in Excel for viewing and analyzing demagnetization data from paleomagnetic discrete samples and u‐channels.

Software by .

The DAIE workbook is a composite tool for viewing and analyzing stepwise demagnetization data of both discrete and u-channel samples in paleomagnetic studies. It is designed with a modular structure in distinct worksheets for data inputs, commands and plots, outputs and computations. The software allows an interactive operability and all the commands and choices can be entered by sliding menus associated to single cells.


Figure Main software interface and demagnetization plots


The standard demagnetization diagrams (Zijderveld orthogonal projections, stereographic projection of unit vectors, variation of the remanence intensity during the demagnetization treatment) are shown on the same worksheet including the selectable parameters and User’s choices. In addition, various other common demagnetization parameters (MDF, DGRM) are computed. The remanence characteristic components may be computed by principal component analysis (PCA) on a selected interval of demagnetization steps. Saving of the PCA data can be done both sample by sample, or in automatic by applying the selected choices to all the samples included in the file.  

The DAIE software has been first presented at the Fall meeting of the American Geophysical Union, held in San Francisco (USA) from 3 to 7 December, 2012. The contribution is available on the web as ePoster.

The whole workbook is free both for use and editing.

The User Manual is available here.

The Excel workbook is included in a zipped file that can be downloaded here. It can be extracted by using a password that should be requested by e-mail to the author at the following e-mail address:

The use of the software should be referred to the paper:

Sagnotti Leonardo (2013), Demagnetization Analysis in Excel (DAIE) An open source workbook in Excel for viewing and analyzing demagnetization data from paleomagnetic discrete samples and uchannels, ANNALS OF GEOPHYSICS, 56, 1, 2013, D0114; doi:10.4401/ag-6282. - PDF , link


The statistics on DAIE output data can be evaluated by using other two Excel workbooks:

- Fisher statistics (1953; Dispersion on a sphere, Proc. Roy. Soc. London, A217, 295-305) – file “Fisher stat_DAIE” (present version works on up to 150 data in input), or

 - McFadden and McElhinny statistics (1988; The combined analysis of remagnetization circles and direct observations in paleomagnetism, Earth Planet. Sci. Lett., 87, 161-172) – file “McF_McE stat_DAIE” (present version works on a maximum of 10 great circles, and an alpha95 ellipse is plotted only for the mean direction).



Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License.


Back to Top