Search PubMed⌕ Search
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 WaterSoftwareWater MovementsJournal Article

Keep this discovery

Explore connections, maps & timelines

BibTeXRIS

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↗
PubMed2006

Phosphorous retardation and breakthrough into well water in a soil-aquifer treatment (SAT) system used for large-scale wastewater reclamation.

Retardation and breakthrough of phosphorous in the soil/sediment profiles of a SAT system at the Shafdan wastewater treatment plant, Israel, were investigated in situ. Area-weighted average effluent load to the whole site was 65 m yr(-1). Annual average concentrations of P in the recharged effluent ranged between about 1.5 and 7.7 mg L(-1) during 25 yr of operation, while P in groundwater remained 40 m sandy soil/sediment formations. By combining results of isotherm tests, long-term monitoring of phosphorous (P) in solid and liquid phases of the recharge site, a simple multi-cell tracer-movement model and measured chloride breakthrough curves to the groundwater we calculated P distribution coefficients and estimated the retardation factor of P. Laboratory measured, isotherm-based distribution coefficient, Kd(I), was about 4-6 L kg(-1) at equilibrium P concentration <6 mg L(-1), while field-based Kd(F) was considerably higher, reaching about 20-55 L kg(-1) after a load of around 1800 m effluent was recharged. Measured P breakthrough times into two shallow observation wells were 19-21 yr. Calculated P breakthrough times using Kd(F) data agreed with observations while those calculated using Kd(I) grossly underestimated retardation and predicted much shorter breakthrough times. This validated the approach and model used. Estimated P breakthrough times to the deeper observation wells and the recovery wells are more than 100 yr and 400-1100 yr, respectively. These estimates show that P contamination of the reclaimed effluents in the Shafdan plant will not be a problem in the foreseeable future.

Fresh Water↗
PubMed2006

Peat fire effects on some properties of an artificially drained peatland.

The management of artificially drained organic soils is a very important issue, since the accelerated mineralization and sometimes peat fires alter physical and chemical properties of soils and the availability of plant nutrients. This study was performed to determine relatively short- and long-term effects of peat fires on some physical and chemical properties of soils in the artificially drained Gavur Lake Peatland of Turkey. To achieve this objective, measured properties of soils burned in 2001, burned in 1965, and unburned were compared. The results indicated that soil bulk density, pH, amounts of soluble salts, CaCO3, and concentrations of ammonium acetate-extractable (AAE) Ca, Mg, K, and Na were significantly higher for both sampling depths in the burned areas. The areas burned in 2001 had higher pH, soluble salts, and the concentrations of AAE Ca, Mg, and K compared with sites burned in 1965, and this was reasoned with leaching losses and plant uptake of these basic cations for four decades in the latter. Percent saturation and organic carbon contents of soils, however, were significantly lower in the burned areas for both sampling depths. Olsen P levels were not significantly different between the sites. This work clearly shows that alterations in soils properties with peat fires do not recover in the long term.

Fresh Water↗