Hostname: page-component-cd9895bd7-gxg78 Total loading time: 0 Render date: 2024-12-28T02:15:33.281Z Has data issue: false hasContentIssue false

Laboratory Note. A LOTUS 1-2-3 Spreadsheet to Aid in Data Reduction for Publication of X-Ray Powder Diffraction Data

Published online by Cambridge University Press:  10 January 2013

Gregory J. McCarthy
Affiliation:
Departments of Chemistry and Geology, North Dakota State University, Fargo, North Dakota 58105, U.S.A.

Extract

My students and I have developed a LOTUS 1-2-3 spreadsheet to aid in data reduction tasks associated with preparing powder diffraction data for publication in the Powder Diffraction File (PDF) (1987) and this journal. Portions of a sample spreadsheet and the formulae in each of the computational cells are given in the Table 1. The concept of this spreadsheet should apply to any of the available computer spreadsheet programs, although the specific codes for the mathematical functions may differ.

The user enters data only into columns C, D and F-H. All other entries will be calculated from the input data. Observed 2θ angles are entered into column D. The corresponding d-spacing is calculated in column A. The Miller indices of these peaks are entered into column C. Prior to use of the spreadsheet, the observed 2θ angles and hkl's had been used to refine unit cell parameters using the Appleman and Evans (1973) least squares unit cell parameter refinement computer program implemented for the IBM PC by Garvey (1986).

Type
Research Article
Copyright
Copyright © Cambridge University Press 1988

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

Appleman, D. E. and Evans, H. T. Jr., (1973). Report PB216188. U. S. Dept. of Commerce, National Technical Information Service, 5285 Port Royal Rd., Springfield, VA 22151.Google Scholar
Garvey, R. G. (1986). Pow. Diff. 1, 114.Google Scholar
McMurdie, H. F., Morris, M. C., Evans, E. H., Paretzkin, B., and Wong-Ng, W. (1986). Pow. Diff. 1, 4043.CrossRefGoogle Scholar
Powder Diffraction File (1987). Swarthmore, PA: International Centre for Diffraction Data.Google Scholar