CaltechAUTHORS
  A Caltech Library Service

PetroPlot: A plotting and data management tool set for Microsoft Excel

Su, Yongjun and Langmuir, Charles H. and Asimow, Paul D. (2003) PetroPlot: A plotting and data management tool set for Microsoft Excel. Geochemistry, Geophysics, Geosystems, 4 (3). 2002GC000323. ISSN 1525-2027. http://resolver.caltech.edu/CaltechAUTHORS:SUYggg03

[img]
Preview
PDF - Published Version
See Usage Policy.

439Kb
[img] Plain Text (README.txt) - Supplemental Material
See Usage Policy.

2694b
[img]
Preview
PDF (PetroPlot tutorial: FAQ, PetroPlotfiles, PetroPlot installation and startup, PetroPlot functions and utilities, Known problems, PetroPlot conventions, and Using the Visual Basic editor to view PetroPlot source code) - Supplemental Material
See Usage Policy.

1449Kb
[img] Other (Core Excel add-in library file required for all PetroPlot functions.) - Supplemental Material
See Usage Policy.

960Kb
[img] MS Excel (An Excel file with petrology data for the demonstration purpose only.) - Supplemental Material
See Usage Policy.

30Kb
[img] MS Excel (An Excel file with petrology data for the demonstration purpose only.) - Supplemental Material
See Usage Policy.

90Kb
[img] MS Excel (An Excel file for the demonstration of the spline functions.) - Supplemental Material
See Usage Policy.

52Kb

Use this Persistent URL to link to this item: http://resolver.caltech.edu/CaltechAUTHORS:SUYggg03

Abstract

PetroPlot is a 4000-line software code written in Visual Basic for the spreadsheet program Excel that automates plotting and data management tasks for large amount of data. The major plotting functions include: automation of large numbers of multiseries XY plots; normalized diagrams (e.g., spider diagrams); replotting of any complex formatted diagram with multiple series for any other axis parameters; addition of customized labels for individual data points; and labeling flexible log scale axes. Other functions include: assignment of groups for samples based on multiple customized criteria; removal of nonnumeric values; calculation of averages/standard deviations; calculation of correlation matrices; deletion of nonconsecutive rows; and compilation of multiple rows of data for a single sample to single rows appropriate for plotting. A cubic spline function permits curve fitting to complex time series, and comparison of data to the fits. For users of Excel, PetroPlot increases efficiency of data manipulation and visualization by orders of magnitude and allows exploration of large data sets that would not be possible making plots individually. The source codes are open to all users.


Item Type:Article
Related URLs:
URLURL TypeDescription
http:dx.doi.org/10.1029/2002GC000323DOIUNSPECIFIED
http://www.agu.org/pubs/crossref/2003/2002GC000323.shtmlPublisherUNSPECIFIED
ORCID:
AuthorORCID
Asimow, Paul D.0000-0001-6025-8925
Additional Information:Copyright 2003 by the American Geophysical Union. Received: 14 August 2004; Revised: 4 January 2005; Accepted: 5 January 2005; Published: 15 February 2005. Colleagues in the LDEO petrology group have been loyal beta-testers for PetroPlot. Numerous feedback and suggestions from them have substantially improved the program. Comments from Dennis Geist, Bill White, Yaoling Niu, Peter Michael, and David Christie have greatly improved both functions and documentation of this software, and lead to the creation of the tutorial. Auxiliary material for this article contains PetroPlot source files as well as a detailed tutorial explaining how to install the PetroPlot package and how to use the PetroPlot package for plotting and manipulation of geochemical data in the Microsoft Excel environment. Additional file information is provided in the README.txt. Available at: http://www.agu.org/journals/gc/gc0303/2002GC000323/supplement.shtml
Subject Keywords:Excel; plot; data-management; tool; 1094 Geochemistry: Instruments and techniques; 3694 Mineralogy and Petrology: Instruments and techniques; 9815 General or Miscellaneous: Notices and announcements; 9820 General or Miscellaneous: Techniques applicable in three or more fields
Record Number:CaltechAUTHORS:SUYggg03
Persistent URL:http://resolver.caltech.edu/CaltechAUTHORS:SUYggg03
Alternative URL:http://dx.doi.org/10.1029/2002GC000323
Official Citation:Su, Y., C. H. Langmuir, and P. D. Asimow, PetroPlot: A plotting and data management tool set for Microsoft Excel, Geochem. Geophys. Geosyst., 4(3), 1030, doi:10.1029/2002GC000323, 2003.
Usage Policy:No commercial reproduction, distribution, display or performance rights in this work are provided.
ID Code:1089
Collection:CaltechAUTHORS
Deposited By: Archive Administrator
Deposited On:19 Dec 2005
Last Modified:23 Jul 2013 18:44

Repository Staff Only: item control page