Visual Basic programs for spreadsheet analysis.

Bruce Hunt

doi:10.1111/j.1745-6584.2005.tb02293.x

Home/Archive/PubMed

PubMed · 15726932

Visual Basic programs for spreadsheet analysis.

Bruce Hunt

View original source ↗Export metadata ↓

Abstract

A collection of Visual Basic programs, entitled Function.xls, has been written for ground water spreadsheet calculations. This collection includes programs for calculating mathematical functions and for evaluating analytical solutions in ground water hydraulics and contaminant transport. Several spreadsheet examples are given to illustrate their use.

Explore related subjects

Fresh Water Software Water Movements Journal Article

Keep this discovery

Explore connections, maps & timelines

BibTeX RIS

Bruce Hunt. Visual Basic programs for spreadsheet analysis.. https://doi.org/10.1111/j.1745-6584.2005.tb02293.x

Cite the original work for its findings. Save a collection to share your selection of sources.

KEEP EXPLORING

Related citations

PubMed2026

Widespread marine and freshwater distributions of active sulfoquinovose-degrading bacteria.

Sulfoquinovose (SQ), a sulfonated sugar produced on a gigaton scale each year, contributes to global sulfur cycling, yet the microbes and pathways mediating its turnover in the environment have been inferred largely from genomic potential rather than direct activity. Here, we coupled incubations of environmental samples with 13C-labeled SQ to DNA-stable isotope probing to identify active SQ carbon assimilators across estuary, mangrove, and lake ecosystems. In estuarine communities, Vibrio and Cognatishimia incorporated SQ-derived 13C; Novosphingobium dominated in the mangrove, and Agrobacterium in the lake. Pure-culture experiments, coupled with comparative proteomics and gene knockout validation, demonstrated that Vibrio strains degrade SQ via modified sulfoglycolytic Embden-Meyerhof-Parnas and Entner-Doudoroff pathways to produce the environmentally significant organosulfur 2,3-dihydroxypropanesulfonate. Comparative genomic analyses suggested that closely related genome representatives of Novosphingobium, Cognatishimia, and Agrobacterium encode the sulfolytic SQ monooxygenase pathway. A global survey of aquatic microbial genomes indicated that over 9% harbor SQ degradation clusters, supporting a widespread distribution of bacterial SQ catabolic potential in aquatic environments.

Fresh Water↗

PubMed2005

Dissolution of a multicomponent DNAPL pool in an experimental aquifer.

This paper presents the results from a well-defined, circular-shaped, multicomponent dense nonaqueous phase liquid (DNAPL) pool dissolution experiment conducted in a three-dimensional, bench scale model aquifer. The multicomponent pool is a mixture of tetrachloroethylene (PCE) and 1,1,2-trichloroethane (1,1,2-TCA); PCE was the major component and 1,1,2-TCA was the minor component. Downgradient plume concentrations were measured at five specific locations over time until the majority of the 1,1,2-TCA was depleted from the DNAPL pool source. The experimental results suggest distinct spatial-temporal plume patterns for minor DNAPL components versus major DNAPL components. The downgradient concentration varied over time for 1,1,2-TCA while a stable plume developed for PCE. A semi-analytical solution for contaminant transport resulting from dissolution of multicomponent nonaqueous phase liquid pools successfully simulated the plume structure and dynamics for both the major and minor DNAPL components.

Fresh Water↗

PubMed2005

Design of aquifer remediation systems: (2) estimating site-specific performance and benefits of partial source removal.

A Lagrangian stochastic model is proposed as a tool that can be utilized in forecasting remedial performance and estimating the benefits (in terms of flux and mass reduction) derived from a source zone remedial effort. The stochastic functional relationships that describe the hydraulic "structure" and non-aqueous phase liquid (NAPL) "architecture" have been described in a companion paper (Enfield, C.G., Wood, A.L., Espinoza, F.P., Brooks, M.C., Annable, M., Rao, P.S.C., this issue. Design of aquifer remediation systems: (1) describing hydraulic structure and NAPL architecture using tracers. J. Contam. Hydrol.). The previously defined functions were used along with the properties of the remedial fluids to describe remedial performance. There are two objectives for this paper. First, is to show that a simple analytic element model can be used to give a reasonable estimate of system performance. This is accomplished by comparing forecast performance to observed performance. The second objective is to display the model output in terms of change in mass flux and mass removal as a function of pore volumes of remedial fluid injected. The modelling results suggest that short term benefits are obtained and related to mass reduction at the sites where the model was tested.

Fresh Water↗