Skip Links

USGS - science for a changing world

Techniques and Methods 6–A26

NetpathXL—An Excel® Interface to the Program NETPATH

By David L. Parkhurst and Scott R. Charlton

Thumbnail of and link to PDF (377 kB)Download Publication
T&M 6-A26
PDF (377 kB)
Abstract

NetpathXL is a revised version of NETPATH that runs under Windows® operating systems. NETPATH is a computer program that uses inverse geochemical modeling techniques to calculate net geochemical reactions that can account for changes in water composition between initial and final evolutionary waters in hydrologic systems. The inverse models also can account for the isotopic composition of waters and can be used to estimate radiocarbon ages of dissolved carbon in ground water. NETPATH relies on an auxiliary, database program, DB, to enter the chemical analyses and to perform speciation calculations that define total concentrations of elements, charge balance, and redox state of aqueous solutions that are then used in inverse modeling. Instead of DB, NetpathXL relies on Microsoft Excel® to enter the chemical analyses. The speciation calculation formerly included in DB is implemented within the program NetpathXL. A program DBXL can be used to translate files from the old DB format (.lon files) to NetpathXL spreadsheets, or to create new NetpathXL spreadsheets. Once users have a NetpathXL spreadsheet with the proper format, new spreadsheets can be generated by copying or saving NetpathXL spreadsheets. In addition, DBXL can convert NetpathXL spreadsheets to PHREEQC input files. New capabilities in PHREEQC (version 2.15) allow solution compositions to be written to a .lon file, and inverse models developed in PHREEQC to be written as NetpathXL .pat and model files. NetpathXL can open NetpathXL spreadsheets, NETPATH-format path files (.pat files), and NetpathXL-format path files (.pat files). Once the speciation calculations have been performed on a spreadsheet file or a .pat file has been opened, the NetpathXL calculation engine is identical to the original NETPATH. Development of models and viewing results in NetpathXL rely on keyboard entry as in NETPATH.

Version 1.0

Posted March 2008


Suggested citation:

Parkhurst, D.L., and Charlton, S.R., 2008, NetpathXL—An Excel® interface to the program NETPATH: U.S. Geological Survey Techniques and Methods 6–A26, 11 p.



Contents

Abstract

Introduction

NetpathXL

Installing DBXL and NetpathXL

Using DBXL

Using NetpathXL

Summary and Conclusions

References Cited

Appendix 1. NetpathXL Spreadsheet File

Appendix 2. Coding methods

Appendix 3. Interfacing with PHREEQC



Part or all of this report is presented in Portable Document Format (PDF); the latest version of Adobe Acrobat Reader or similar software is required to view it. Download the latest version of Acrobat Reader, free of charge or go to access.adobe.com for free tools that allow visually impaired users to read PDF files.

Accessibility FOIA Privacy Policies and Notices

Take Pride in America home page. FirstGov button U.S. Department of the Interior | U.S. Geological Survey
URL: http://pubsdata.usgs.gov/pubs/tm/06A26/index.html
Questions or Assistance: Contact USGS
Last modified: Friday, 02-Dec-2016 15:48:02 EST