Home  About us  Contact
 

Spreadsheet Program (spreadsheet + program)

Distribution by Scientific Domains
Engineering75%

Selected Abstracts

A dynamic interval goal programming approach to the regulation of a lake,river system

JOURNAL OF MULTI CRITERIA DECISION ANALYSIS, Issue 2 2001
Raimo P. Hämäläinen
Abstract This paper describes a model and a decision support tool for the regulation of a lake,river system using both goal sets and goal points for the water level over the year. The inflow forecast is updated periodically, which results in a series of dynamic rolling horizon goal programming problems. This involves heavy computation, and yet it can be successfully done with the spreadsheet program. The related decision support tool with a graphical user interface is called Interactive analysis of dynamic water regulation Strategies by Multi-criteria Optimization (ISMO). The Finnish Environment Institute (FEI) actively uses it in the generation of regulation policy alternatives when considered from the different perspectives of the stakeholders. Copyright © 2001 John Wiley & Sons, Ltd. [source]

Confidence Intervals for Unbalanced Two-factor Gauge R&R Studies

QUALITY AND RELIABILITY ENGINEERING INTERNATIONAL, Issue 8 2005
Liyun Gong
Abstract We consider methods for constructing confidence intervals in a two-factor gauge repeatability and reproducibility (R&R) study when there are unequal replicates. We consider both random and mixed models and propose a general approach using unweighted sums of squares. Computer simulation is used to determine how well confidence intervals maintain the stated confidence level. The main conclusion is that the method performs well under a variety of conditions typically encountered in gauge R&R studies. The method is simple and the intervals can be computed in a spreadsheet program. Copyright © 2005 John Wiley & Sons, Ltd. [source]

A spreadsheet solution of transient conduction in composite fins

INTERNATIONAL JOURNAL OF ENERGY RESEARCH, Issue 5 2002
E. M. A. Mokheimer
Abstract Transient heat transfer through composite fins is investigated by numerical methods. In this regard, governing differential equations of the two-dimensional fin and one-dimensional cladding are studied to examine the effect of Biot number and ratio of thermal conductivities of the fin material to the cladding, on the dimensionless temperature profiles. In addition, the use of spreadsheet programs in solving the composite fin problems is investigated in somewhat more detail with regard to the solution as well as presentation of the graphical results. The results show that one-dimensional analysis, traditionally used in fin analysis, is not applicable for composite fins, particularly when the conductivity ratio of the composite fin materials is very high. Copyright © 2002 John Wiley & Sons, Ltd. [source]

Simplified solution of developing laminar forced flow between parallel plates

INTERNATIONAL JOURNAL OF ENERGY RESEARCH, Issue 5 2002
Esmail M. A. Mokheimer
Abstract A simplified simulation for developing laminar forced flow in the entrance region between two parallel plates is presented. This simulation is based on an implicit finite difference numerical representation of a boundary layer model describing the flow in the entry region. This boundary layer model comprises the two conservation equations of mass and momentum. A non-iterative implicit numerical scheme is developed to convert the partial differential form of these governing equations into algebraic equations. The resultant algebraic equations have been solved simultaneously via a simplified simulation using spreadsheet programs as well as a Fortran code for the sake of comparison. The numerically obtained developing axial velocity profile at large distance downstream of the entrance shows excellent agreement with the available fully developed analytical profile. Comparison between the abilities of the spreadsheet simulation with other high-level programming languages is outlined. Copyright © 2002 John Wiley & Sons, Ltd. [source]