Date: Thu, 6 Oct 1994 21:38:41 -0600
Subject: Re: File conversion: SX50 xxx.cor to EXCEL spreadsheet
From: jstor@owlnet.rice.edu (J. C. Stormer, Jr.)
X-Attachments: :Dittybag:2230: MacExtract2.1: :Dittybag:2230:MacExtract2.1ReadMe:
I thought of a solution to the problem I mentioned yesterday. See attached...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
INSTRUCTIONS FOR MacEXTRACT2.1
Get the SX50 xxx.cor file onto the hard disk on your Mac or PC by "ftp" or
other means.
In EXCEL open the macro sheet MacExtract2.1.
Then open the SX50 xxx.cor file from EXCEL. It will appear as a
spreadsheet with all data in the first column.
With the xxx.cor spreadsheet open, call the "Corextractor" macro by typing
(cmd-option-c). The macro will create another spreadsheet with headings and
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.
"Corextractor" extracts the elemental or oxide analysis only. I have
several spreadsheet templates set up to recalculate mineral formulae and
components from the extracted analyses. To a degree this is redundant, but
In many cases I prefer slightly different modes for the recalculation, or
additional information that Quantiview does not provide. It would be
possible to modify the macro to extract mineral formulae and other
information, but this would require several different versions for each
mineral declaration since the formulae and other information are not
written to the xxx.cor files in a consistent way.
MacExtract2.1 also contains the generic extraction macro "Extractor" as
well as "Corextractor". "Extractor" can be used for xxx.kex files and is
run similarly (typing cmd-option-e) with the xxx.kex sheet window active,
but it requires input from the user. Just follow the instructions.
Dr. J. C. Stormer, Jr.,
Dept. of Geology & Geophysics, MS-126
Rice University, 6100 South Main St.,
Houston, TX 77005-1892
jstor@owlnet.rice.edu
Phone: (713) 527-4054
Attachment converted: electron: MacExtract2.1 (Type: 'XLM4' Creator: 'XCEL')