• Solar Energy
• /
• v.12 no.1
• /
• pp.15-24
• /
• 1992

An hourly simulation model of a solar LiBr-water absorption cooling and heating system (for brevity, solar absorption system) is presented, based on SuperCalc spreadsheet computational procedures. This paper demonstrates the value of using spreadsheet simulation techniques by examining the thermal performances of a solar absorption system. The hourly heating and cooling coil loads for a typical office building in Tucson, Arizona are modeled and calculated using ASHRAE methods. The details of the algorithms for the components and control schemes are presented. Two case studies are also presented using real system parameters.

• Journal of The Korean Society of Agricultural Engineers
• /
• v.51 no.2
• /
• pp.43-49
• /
• 2009

Many researcher uses simulation techniques for understanding the phenomenon and expecting the response. Simulation techniques have many advantages which is less time-consuming, easy to control constraints, and cheaper than experimental study. However Researches usually are not good at programming the model, it's hard to implement simulation model using computer language. They use spreadsheet program like Microsoft $excel^{TM}$ Although a spreadsheet program is good for modeling, it's cumbersome to describe expressions which consist of not variable name but location indicator. This study suggests the program which helps researcher developing model using graphical interface and variable name. For verifying usability, the model which is implemented by developed modeler were compared with by spreadsheet program.

• Proceedings of the Korean Geotechical Society Conference
• /
• 2010.09a
• /
• pp.1024-1029
• /
• 2010

The conventional factor of safety as used in geotechnical engineering does not reflect the degree of uncertainty of the relevant parameters. Then in the geotechnical engineering, there have been efforts to reflect the uncertainties of the geotechnical properties through probabilistic analysis. In this study, a practical method for calculation the second moment reliability index using the optimization tool of a spreadsheet software is introduced. And this methodology was proposed by Low, B. K.(1996). The method is based on the perspective of an ellipsoid that just touches the failure surface in the original space of the variables. The method is applied to vertical drains(PVD) and compared with th result of Monte Carlo Simulation method.

• Journal of Korean Society of Industrial and Systems Engineering
• /
• v.35 no.1
• /
• pp.124-131
• /
• 2012

This paper presents a spreadsheet-based reliability prediction simulation framework for the conceptual product design stage to acquire system reliability information in timely manner. During early stage, reliability performance deals with both known and unknown failure rates and component-level and subsystem-level failure estimate to predict system reliability. A technique for performing life testing simulation using Excel spreadsheet has been developed under the such circumstances. This paper also discuss the results obtainable from this method such as reliability estimate, mean and variance of failures and confidence intervals. The resultant of this reliability prediction system is mainly benefitting small and medium-sized enterprise's field engineers.

• Journal of Educational Research in Mathematics
• /
• v.15 no.4
• /
• pp.505-522
• /
• 2005

In this article we studied the role of spreadsheet in teaching function and modeling activity by some examples and students' activity performed by the six 10th graders. We especially focused the role of spreadsheet in understanding of various kinds of functions and the families of functions, and in the explanation of the given modeling problem situations. The functions of automatic copy, graphic and the cell reference of spreadsheet can be used to make students observe the causes and effects of changes of the various kind of mathematical representations of functions such as algebraic formulas, tables and graphs. Especially those functions give students a chance to identify family of functions by changing the parameters and this may lead them to the discovery of mathematical facts. In modeling activities they play a key role in the stages of the analysis of the model, explanation of the results of model and conjecture of the real world situations. As well as they make students find the rules underlying in the real world by making spreadsheet as simulation environments, which are almost impossible to make in paper and pencil environments, and give them a chance to justify their findings using mathematics.

• The Journal of Information Systems
• /
• v.2
• /
• pp.29-52
• /
• 1993

• Industrial Engineering and Management Systems
• /
• v.6 no.2
• /
• pp.106-118
• /
• 2007

This paper present a new optimization model to generate aggregate production planning by considering electric cost. The new Time Of Switching (TOS) electric type is introduced by switching over Time Of Day (TOD) and Time Of Use (TOU) electric types to minimize the electric cost. The fuzzy demand and Dynamic inventory tracking with multiple plant capacity are modeled to cover the uncertain demand of customer. The constraint for minimum hour limitation of plant running per one start up event is introduced to minimize plants idle time. Furthermore; the Optimal Weight Moving Average Factor for customer demand forecasting is introduced by monthly factors to reduce forecasting error. Application is illustrated for multiple cement mill plants. The mathematical model was formulated in spreadsheet format. Then the spreadsheet-solver technique was used as a tool to solve the model. A simulation running on part of the system in a test for six months shows the optimal solution could save 60% of the actual cost.

• Journal of Korea Society of Industrial Information Systems
• /
• v.28 no.2
• /
• pp.11-19
• /
• 2023

In this paper, we propose the methods of invoice document structure recognition and of making a spreadsheet electronic document. The texts and block location information of word blocks are recognized by an optical character recognition engine through deep learning. The word blocks on the same row and same column are found through their coordinates. The document area is divided through arrangement information of the word blocks. The character recognition result is inputted in the spreadsheet based on the document structure. In simulation result, the item placement through the proposed method shows an average accuracy of 92.30%.

• International conference on construction engineering and project management
• /
• 2007.03a
• /
• pp.130-139
• /
• 2007

This paper presents a study on risk analysis in terms of contractor's costs in construction phase in which Crystal ball (software of Decisioneering, UK) has been utilized as a main tool. To realize it, a questionnaire survey has been carried out to identify the dominant factors that strongly influence contractor costs in Vietnam. Based on results of questionnaire investigation, the survey identified three factors which were duration of each construction task, costs of reinforcing steel, and cement. Then a spreadsheet model was created in order to analyze risks. The study also indicates that the cost of reinforcing steel and cement are the cause of risks for contractors. According to the suggested model, contractors may foresee the probability of completion within the approved budget, and the possibility of earning in accordance with owner's payment conditions.

• The Korean Journal of Applied Statistics
• /
• v.15 no.1
• /
• pp.153-163
• /
• 2002

There seems to be a little trouble in delivering an effective teaching of statistics at the school of Business. Students attitude toward the understanding of mathematics appears to be one of the hindrances encountered to the wide spread use of statistics. Nevertheless, the usefulness of statistics is notably appreciated these days although students may not be aware of it. It is true that many processes of decision-making are based on various future uncertainties, however, decisions must be made at the present. In this synopsis, we would like to solve simple business problems, thereby, suggest more constructive ways to match the statistics with the interest of management. We, in the mean time, will talk about the understanding of business, method of teaching, and Monte Carlo education.