Hostname: page-component-848d4c4894-x24gv Total loading time: 0 Render date: 2024-05-24T14:10:48.657Z Has data issue: false hasContentIssue false
  • English
  • Français

An Excel macro for transforming X-ray powder diffraction data to spreadsheet format

Published online by Cambridge University Press:  10 January 2013

Tapan Chakrabarty ,
Dave W. Webb  and
John M. Longo
Tapan Chakrabarty
Affiliation:
Imperial Oil Resources Limited, Research Centre, Calgary, Alberta T2L 2K8, Canada
Dave W. Webb
Affiliation:
Exxon Production Research Company, Houston, Texas 77252, USA
John M. Longo
Affiliation:
Exxon Production Research Company, Houston, Texas 77252, USA
Get access Rights & Permissions [Opens in a new window]

Abstract

An Excel command macro has been developed which directly transforms X-ray powder diffraction data to a spreadsheet format. This spreadsheet format offers a number of data reduction and plotting capabilities not available in a diffractometer's software. The conventional approach uses computer programs to transform the data outside a spreadsheet. The development of these programs is not a simple process, and requires the user to be familiar with computer programming and the software of a diffractometer. Furthermore, these programs are diffractometer-specific. A different approach is followed in which an Excel macro transforms the data within a spreadsheet. This macro, with minor modifications, can be applied generally to treat data from any diffractometer. A copy of the macro and an example illustrating its working principle are included.

Type
Research Article
Information
Powder Diffraction , Volume 8 , Issue 3 , September 1993 , pp. 160 - 161
Copyright
Copyright © Cambridge University Press 1993

Access options

Get access to the full version of this content by using one of the access options below. (Log in options will check for institutional or personal access. Content may require purchase if you do not have access.)

References

Dahan, I., Sariel, J., and Kimmel, G. (1991). “A Spreadsheet to Treat X-Ray Powder Diifraction Data,” Powder Diffr. 6, 114.CrossRefGoogle Scholar
Karanovic, Lj., and Poleti, D. (1992). “A Fortran Program for Conversion of PC-APD Files into ASCII Files,” Powder Diffr. 7, 179.CrossRefGoogle Scholar
McCarthy, G. J. (1990). “A LOTUS 1-2-3 Spreadsheet to Aid in Data Reduction for Publication of X-Ray Powder Diffraction Data,” Methods and Practices, X-Ray Powder Diffr. 8.1.1.Google Scholar