Jump to content
Geochemist's Workbench Support Forum

How do I convert excel data to GSS spreadsheet that is supported by GWB?


Recommended Posts

Hi Lufuno,

I recommend following the steps in the tutorial "How do I transfer my data from Excel to GSS" under "Geochemical spreadsheet" on https://www.gwb.com/tutorials.php. Basically, transpose the datasheet, add analytes in the order of your Excel file with appropriate units, then paste the interior data cells all at once.

Note, the program can use a "carbonate alkalinity", not a total alkalinity. If carbonate species don't dominate the fluid's total alkalinity, you may want to try using a reaction model to reproduce the original titration determination as a way to solve for the HCO3- component concentration. For more information, please see section 16.1, Buffers in Solution, in the Geochemical and Biogeochemical Reaction Modeling text, third edition.

You'll have to make a choice about some of the redox-active components, like whether to use Fe++ vs. Fe+++. For more information, see 2.4 Redox couples and 7.3 Redox disequilibrium in the GWB Essentials Guide.


Brian Farrell
Aqueous Solutions

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...