PetroPlot: A Plotting and Data Management Tool Set for Microsoft Excel
| Title: | PetroPlot: A Plotting and Data Management Tool Set for Microsoft Excel |
| Author: |
Asimow, Pauld D.; Langmuir, Charles; Su, Yongjun
Note: Order does not necessarily reflect citation order of authors. |
| Citation: | Su, Yongjun, Charles H. Langmuir, and Paul D. Asimow. 2003. PetroPlot: A plotting and data management tool set for Microsoft Excel. Geochemistry Geophysics and Geosystems 4, no. 3: 1030. |
| Access Status: | At the direction of the depositing author this work is not currently accessible through DASH. |
| Full Text & Related Files: |
Su G3 03.pdf (449.8Kb; PDF) 
|
| 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. |
| Published Version: | http://dx.doi.org/10.1029/2002GC000323 |
| Other Sources: | http://www.people.fas.harvard.edu/~langmuir/homepage.html |
| Citable link to this page: | http://nrs.harvard.edu/urn-3:HUL.InstRepos:3224707 |
| Downloads of this work: |
This item appears in the following Collection(s)
-
FAS Scholarly Articles [10848]
Contact administrator regarding this item (to report mistakes or request changes)
