Open Access. Powered by Scholars. Published by Universities.®

Physical Sciences and Mathematics Commons

Open Access. Powered by Scholars. Published by Universities.®

2011

Business

Business Analytics and Information Systems

Articles 1 - 2 of 2

Full-Text Articles in Physical Sciences and Mathematics

Error Control Of Iterative Linear Solvers For Integrated Groundwater Models, Matthew Dixon, Z Bai, C F. Brush, F I. Chung, E C. Dogrul, T M. Kadir Jan 2011

Error Control Of Iterative Linear Solvers For Integrated Groundwater Models, Matthew Dixon, Z Bai, C F. Brush, F I. Chung, E C. Dogrul, T M. Kadir

Business Analytics and Information Systems

An open problem that arises when using modern iterative linear solvers, such as the preconditioned conjugate gradient method or Generalized Minimum RESidual (GMRES) method, is how to choose the residual tolerance in the linear solver to be consistent with the tolerance on the solution error. This problem is especially acute for integrated groundwater models, which are implicitly coupled to another model, such as surface water models, and resolve both multiple scales of flow and temporal interaction terms, giving rise to linear systems with variable scaling. This article uses the theory of “forward error bound estimation” to explain the correspondence between …


Towards Evaluating The Quality Of A Spreadsheet: The Case Of The Analytical Spreadsheet Model, Thomas A. Grossman Jr., Vijay Mehrotra, J Sander Jan 2011

Towards Evaluating The Quality Of A Spreadsheet: The Case Of The Analytical Spreadsheet Model, Thomas A. Grossman Jr., Vijay Mehrotra, J Sander

Business Analytics and Information Systems

We consider the challenge of creating guidelines to evaluate the quality of a spreadsheet model. We suggest four principles. First, state the domain—the spreadsheets to which the guidelines apply. Second, distinguish between the process by which a spreadsheet is constructed from the resulting spreadsheet artifact. Third, guidelines should be written in terms of the artifact, independent of the process. Fourth, the meaning of “quality” must be defined. We illustrate these principles with an example. We define the domain of “analytical spreadsheet models”, which are used in business, finance, engineering, and science. We propose for discussion a framework and terminology for …