Date: Wed, 5 Oct 1994 22:00:11 -0600
Subject: File conversion: SX50 xxx.cor to EXCEL spreadsheet
From: jstor@owlnet.rice.edu (J. C. Stormer, Jr.)

I have programmed a Microsoft EXCEL macro that converts the analysis data
in a xxxx.cor file to a properly formatted spreadsheet. We have been using
this for some time now, and it occurred to me that others might be able to
use it.

Our SX50 is connected to the campus ethernet. Users can electronically
transfer (ftp) files from their accounts on the SX50 Sun to any computer
with an internet connection (i.e.. even if they are from another
institution).

Once the file is received as a ASCII text file, it can be loaded into an
EXCEL spreadsheet (either Macintosh or "Windows"). However, it is formatted
so that all the data appears compressed into a single column and data for a
single analysis is on several rows. It can be sorted out with spreadsheet
commands but this is time consuming, so I wrote the macro to do it
automatically

Calling this macro with the initial spreadsheet open will create another
spreadsheet with the data properly parsed into separate columns for name,
x, y, z, and up to 24 elements or oxides with each analysis in a single
row. Plotting, averaging, alternative formula calculations, etc. can then
easily be done in the spreadsheet environment.

If you are interested, send me an e-mail message and I will reply with the
macro as an attachment (encoded in BinHex format).
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Dr. J. C. Stormer, Jr., jstor@owlnet.rice.edu
Dept. of Geology & Geophysics, MS-126 jays@rice.edu
Rice University, 6100 South Main St., Phone: (713) 527-4054
Houston, TX 77005-1892 KB5TKO


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~