1 / 10

Transfer Geochemical Data from Excel to GSS: Step-by-Step Guide

Easily move your geochemical data from Excel to GSS with this comprehensive guide. Begin by setting up your analytes in a new GSS spreadsheet. Add system parameters like temperature, pH, and date, or include basis species like Ca++ or Na+. Use the Add Analytes dialog to efficiently include multiple analytes from predefined lists or user-defined options. Adjust the order and units to align with your Excel data. Import your sample data by copying from Excel and pasting into GSS. Now you’re equipped to create plots, calculate mineral saturation, and perform data analysis!

dayshaun-matthew
Download Presentation

Transfer Geochemical Data from Excel to GSS: Step-by-Step Guide

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Transfer data from Excel to GSS

  2. You can move your geochemical data from Excel to GSS

  3. Start by setting up your analytes in a new GSS spreadsheet You can addSystem parameters like temperature, pH, Eh, date, etc… …orBasis species representing chemical components like Ca++, Mg++, Na+, etc. … or choose User defined analytesto define and add custom analytes.

  4. The Add Analytesdialog lets you add several analytes at once Choose from the System parameters, Basis species, or User defined analytes… + analyte→ Add Analytesto open the dialog … then select your analytes and click Apply

  5. Rearrange the order of analytes to match your Excel spreadsheet Left-drag to reorder your analytes

  6. Change the units to match your Excel spreadsheet Select analytes, right-clickon unit field, then choose Units → mg → mg/kg You can use elemental equivalent units. For mg/kg SO4−− as sulfur, right-click, then choose As → S.

  7. You can transpose the data in your GSSspreadsheet if necessary Edit → Transpose Data Sheet

  8. Add one or more columns for samples to GSS Click + sample

  9. Copyyour numerical data and sample names from Excel… Highlight data then Ctrl + c to copy…

  10. …then paste the values into GSS Ctrl + v pastes your data. Now you’re ready to work with your data. Try creating specialty plots, calculating mineral saturation, mixing samples, converting units, and more!

More Related