Display of Powder X-ray Diffraction Patterns by MS-Excel/VBA

Abstract

A program working on MS-Excel/VBA (Visual Basic for Application) by which X-ray diffraction pattern are displayed on a Excel graph sheet has been developed in order to use powder X-ray diffraction data for many purposes as well as mineral identification. The program supports the following tasks: 1) to transfer X-ray diffraction data from a X-ray diffraction facility to an Excel worksheet (depending each facility), 2) to display diffraction patterns, 3) to search diffraction peaks, and 4) to represent identified minerals. It is expected by the program not only that X-ray diffraction patterns attached on reports or papers are easily prepared by the program, but also that X-ray diffraction results are easily used for other works through MS-Excel.