GetEQData Version 1.0 is a Microsoft Visual Basic 6.0 macro data post-processor for EQ3/6, embedded inside a Microsoft Excel 2000 or Excel 97 spreadsheet. This macro will function properly with any Microsoft operating system that supports Excel 2000 and Excel 97 (i.e. Win9X, NT, 2000, and XP). It is designed to extract user-specified output, without loss of precision, from the chemical speciation modeling software EQ3/6 V. 7.2 & 8.0. It greatly enhances EQ3/6 user productivity and reliability by removing the need to "cut and paste" many individual fields of data. The software is essentially an EQ3/6 test output file to Excel worksheet parsing and formatting conversion tool. The approaches are to find (by parsing) the appropriate output, located under specific text headers, and extract that information, repeating the same extraction for any number of specified EQ3/6 output files. This extracted information is then formatted onto the currently open Ecel spreadsheet. This macro runs as a window-driven graphical user interface, where the user can easily select target EQ3/6 output files. This extracted information is then formatted onto the currently open Excel spreadsheet. This macro runs as a window-driven graphical user interface, where the user can easily select target EQ3/6 output file(s) to process. Many data extraction options are present as easily selectable option buttons and checkbox fields. The user may also select more specifically the species to extract and in what numerical units (data fields) to have this information presented in. Once a certain data extraction is identified as one to be repeated, the user can save their selections in a template for future execution. This further increases productivity, reliability and reproducibility. In order to facilitate usage of the macro, it includes a "Help" button that is able to describe many of the specific functions and features of the code. Also, many of the GetEQData controls have their own Tip Text that describe their purpose; the user can get his information by letting the mouse stop on the item in question for about one second.
To order this software or receive further information, please fill out the following request: Request Software
@misc{osti_1230515,
title = {GetEQData, Version 00},
author = {Jarek, Russell L.},
abstractNote = {GetEQData Version 1.0 is a Microsoft Visual Basic 6.0 macro data post-processor for EQ3/6, embedded inside a Microsoft Excel 2000 or Excel 97 spreadsheet. This macro will function properly with any Microsoft operating system that supports Excel 2000 and Excel 97 (i.e. Win9X, NT, 2000, and XP). It is designed to extract user-specified output, without loss of precision, from the chemical speciation modeling software EQ3/6 V. 7.2 & 8.0. It greatly enhances EQ3/6 user productivity and reliability by removing the need to "cut and paste" many individual fields of data. The software is essentially an EQ3/6 test output file to Excel worksheet parsing and formatting conversion tool. The approaches are to find (by parsing) the appropriate output, located under specific text headers, and extract that information, repeating the same extraction for any number of specified EQ3/6 output files. This extracted information is then formatted onto the currently open Ecel spreadsheet. This macro runs as a window-driven graphical user interface, where the user can easily select target EQ3/6 output files. This extracted information is then formatted onto the currently open Excel spreadsheet. This macro runs as a window-driven graphical user interface, where the user can easily select target EQ3/6 output file(s) to process. Many data extraction options are present as easily selectable option buttons and checkbox fields. The user may also select more specifically the species to extract and in what numerical units (data fields) to have this information presented in. Once a certain data extraction is identified as one to be repeated, the user can save their selections in a template for future execution. This further increases productivity, reliability and reproducibility. In order to facilitate usage of the macro, it includes a "Help" button that is able to describe many of the specific functions and features of the code. Also, many of the GetEQData controls have their own Tip Text that describe their purpose; the user can get his information by letting the mouse stop on the item in question for about one second.},
doi = {},
url = {https://www.osti.gov/biblio/1230515},
year = {Mon Jul 01 00:00:00 EDT 2002},
month = {Mon Jul 01 00:00:00 EDT 2002},
note =
}