EASYGRESGRANT - A Microsoft Excel spreadsheet to quantify volume changes and to perform mass-balance modeling in metasomatic systems
نویسنده
چکیده
Gresens’ initial ideas about the mobility/immobility of elements and the gains and losses of material in hydrothermal systems, together with the subsequent isocon method proposed by Grant, have led to the development of a considerable number of mass-balance computer programs for application to metasomatic systems (e.g., Leitch and Day, 1990; Potdevin, 1993; Sturm, 2003; Coelho, 2006). Nevertheless, some of them (NEWGRES or Gresens 92) do not work properly on today’s computers or only work on the Windows platform (SHEARCAL or Geoiso). To date, all mass-balance programs have other problems: (1) graphical plots, such as Grant’s isocon diagram or Gresens’ composition-volume diagram, are not useful tools in order to find immobile elements when a large data set is being handled, since the large number of lines or symbols represented hinders visualization and the distinction of the elements themselves; (2) the method of arbitrary scaling of compositional data proposed to mitigate this problem in the isocon diagram (Grant, 1986) has recently been reported to be inadequate, since scaling influences the best-fit isocon, yielding errors in the mass-balance calculations (Mukherjee and Gupta, 2008). This short note presents EASYGRESGRANT, a new user-friendly interactive Microsoft Excel spreadsheet program that can be run on the Mac and Windows platforms and that permits correct selection of immobile elements from clusters of slopes, volume factors, and an improved isocon diagram, providing an error-free mass-balance modeling for application in metasomatic systems.
منابع مشابه
Tutorial Review: Simulation of Oscillating Chemical Reactions Using Microsoft Excel Macros
Oscillating reactions are one of the most interesting topics in chemistry and analytical chemistry. Fluctuations in concentrations of one the reacting species (usually a reaction intermediate) create an oscillating chemical reaction. In oscillating systems, the reaction is far from thermodynamic equilibrium. In these systems, at least one autocatalytic step is required. Developing an instinctiv...
متن کاملDesign and Use of the Microsoft Excel Solver
We describe the design and use of the spreadsheet optimizer that is bundled with Microsoft Excel. We explain why we and Microsoft made certain choices in designing its user interface, model processing, and solution algorithms for linear, nonlinear and integer programs. We describe some of the common pitfalls encountered by users, and remedies available in the latest version of Microsoft Excel. ...
متن کاملSpreadsheet Probabilistic Programming
Spreadsheet workbook contents are simple programs. Because of this, probabilistic programming techniques can be used to perform Bayesian inversion of spreadsheet computations. What is more, existing execution engines in spreadsheet applications such as Microsoft Excel can be made to do this using only built-in functionality. We demonstrate this by developing a native Excel implementation of bot...
متن کاملBook Review: The Active Modeler: Mathematical Modeling with Microsoft Excel by E. Neuwirth and D. Arganbright
A recently-published work in by two well-known authors in the field of spreadsheet modeling is reviewed.
متن کاملModeling of Climate Change Effects on Groundwater Resources: The Application of Dynamic Systems Approach
The purpose of the present study was the simulation of climate change effects on groundwater resources in Iran by using the dynamic systems approach. The approach was performed through system dynamics modeling process including problem explanation, system description, model development, model testing, and the use of the model for policy analysis. The impact of the application of various exogeno...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید
ثبت ناماگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید
ورودعنوان ژورنال:
- Computers & Geosciences
دوره 39 شماره
صفحات -
تاریخ انتشار 2012