• Proceedings of the Korean Geotechical Society Conference
• /
• 2009.03a
• /
• pp.1113-1124
• /
• 2009

The limit equilibrium method and finite element method have been commonly used to assess the stability of anchored slope. However, the existing limit equilibrium methods do not consider the load transfer of anchor and, if the potential failure surface crosses the bonded zone of anchors, the anchor loads are not included in computing the factor of safety. In this paper, simplified bishop method, one among several methods based on the limit equilibrium is used to develope the Excel Sheet program and the working load of anchor along the failure surface is calculated by Flamant's formula, proposed by Morlier and Tenier(1982). Additionally, the finite element analysis of anchored slope considering the load transfer is performed in order to compare with the result from the limit equilibrium analysis and analyze the reinforced effect of anchor. From this study, new modelling method that limits the reinforcing range and considers the load transfer is proposed and Excel Sheet program is developed. The factor of safety for several cases between PC STABL and Excel Sheet program is also compared for verification of the program.

• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.18 no.1
• /
• pp.217-222
• /
• 2014

In this paper, I propose an efficient data search system using data partitioning algorithm in Microsoft Excel. I propose searching algorithm to retrieve data quickly using VBA functioning in the Excel. This algorithm is to specify the sheet you are looking for. Once the sheet is specified, the algorithm searches the beginning and the end of the data in the sheet. The algorithm compares intermediate values and key words, from the starting position of the cell. In this way, it will search data to the end. This proposed algorithm was implemented and tested in the Excel system using VBA program. The experimental results showed that the performance was better than that of the conventional sequential search method.

• Proceedings of the Korean Institute of Information and Commucation Sciences Conference
• /
• 2013.10a
• /
• pp.671-674
• /
• 2013

In this paper, we propose an efficient data search system using data partitioning algorithm in Microsoft Excel. We propose to retrieve the data quickly using VBA functioning Excel. This algorithm is to specify the sheet you are looking for. Once the sheet is specified, it searches the beginning and the end of the data in the sheet. It compares desired key words and intermediate values, starting from the position of the cell. In this way, it will search data to the end. This proposed algorithm was implemented and tested using actual VBA program. The experimental results showed that the performance was more excellent than that of the conventional search method.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.5 no.1
• /
• pp.29-33
• /
• 2004

In this paper, I'm tying to define the connection of the Device Characteristics and the Error Terms, and yield maximum estimated value of the mismatching errors by modeling the individual devices with signal-flow graph, and by seeking the transfer function of the system with the mismatching error in the combination of the devices using the Signal-flow Graph Gain Formula.

• Transactions of the KSME C: Technology and Education
• /
• v.2 no.1
• /
• pp.21-28
• /
• 2014

As one of the most famous spreadsheet programs that is widely applied to a variety of fields in business, MS Excel has also been used for educational purposes due to its feature of wide accessibility, enabling students to use the program through almost any kind of PC that now exists. The program is mainly used for numerical analysis and formulae applications in the fields of science and engineering. This paper shall provide the key to understanding the application of MS Excel to teaching Statics through the illustration of its essential functions for education. Also, the development process of the analysis program using macros and VBA(Visual Basic for Applications) is described for the deeper comprehension of advanced applications. Students were not only able to solve the Statics problems using basic features of MS Excel, but also discovered new systematic methods of approaching complex problems and developed application programs using macros and VBA.

• The Journal of Korean Association of Computer Education
• /
• v.3 no.2
• /
• pp.59-66
• /
• 2000

This study is to design and implement Excel 2000 WBI applying the Cognitive Apprentice Model. Excel 2000 is the most used Spread Sheet program and indispensable for increasing teachers' information literacy. The Cognitive Apprentice Model is one of Constructivism learning models. Constructivism is a new educational paradigm and mainly applied in education fields. This WBI is designed and implemented according to the Cognitive Apprentice Model and composed of practical contents according to Constructivism learning principle which insists learning is occurred in real situation. For more effective interaction the teacher(computer) guides the learners individually and uses a bulletin board, E-mail and chatting room.

• Journal of The Korean Society of Agricultural Engineers
• /
• v.48 no.6
• /
• pp.31-41
• /
• 2006

The analysis used in this work was cost-benefit analysis method. All future costs and returns of a given mushroom house were discounted to the time of initial investment (present) by means of 3.5% discount rate. Then the cost of ownership was compared to the return from the system. This analysis method has been developed and coded into a balance sheet for use on a EXCEL program. Using this programmed analysis,a large number of the case studies were examined using different combinations of economic conditions. These results will be very useful to individuals considering investment in a mushroom house, or any similar production system. By the way of the sensitivity analysis for each important parameter, the change of the marginal cost-benefit period could be finally determined. These parameters were typically construction cost of mushroom house, cost of cooling system, required cooling and heating energy amounts, unit price of mushroom media bottle, growing number of media bottles, production weight per unit bottle, sale price of mushroom, and annual number of growing period, etc.

• Proceedings of the KSME Conference
• /
• 2000.11b
• /
• pp.674-679
• /
• 2000

An air handling unit(AHU) has been usually designed by manual calculations. Drawing works together with design calculations should be redone far every designing work, and also be needed to make some corrections of them. In order to design the AHU more efficiently, an AHU program has been developed. The developed program on the Windows environment is operated by the graphic user interface(GUI) realized using the Visual Basic Interpreter. The program provides calculation sheet of coils, weights and pressures in a MS-Excel file format as well as design drawing of the AHU in a Auto CAD file format idealized by AutoLISP. Those files of the commercial softwares make easier for a designer to transfer design results to the another company for bid via e-mail.

• Journal of Korean Society of Industrial and Systems Engineering
• /
• v.40 no.4
• /
• pp.129-136
• /
• 2017

Climate change is the biggest environmental issue of our times. A variety of activities to reduce greenhouse gas emissions have been in progress to observe the Kyoto Protocol. Especially, the Energy Target Scheme is created to reduce greenhouse emission with the supervision of Korean government. This includes Green-house Gas Information Systems to promote activities in the private sector to reduce green-house gas emissions, to cut a cost of energy use, and to reduce GHG emissions. Also, the system has calculated the amount of greenhouse gases. Without any additional investment, 2.75% savings are increased over the previous year. In service sector, a cooperation of customers and employees is necessary. A reduction of GHG emissions requires a proper service organization, considering an amount of investment and payback period. Without any additional investment or replacement, employees can save energy easily turning off ventilation systems an hour before employees' departure, installing timers to turn off water purifiers and vending machines after some period of no use. The Green-house Gas Information System is similar to that of Environmental Management System. However, the Excel is the best program to calculate an amount of green-house gas emissions, and to assess for a reduced amount of GHG emissions. A goal of this research is to propose a practical method in the private sector to calculate an amount of green-house gases. The Green-house gas Information System based on Excel spreadsheet gives standards for good evaluation. The greenhouse gas information system establishes and executes the policies and objectives related to greenhouse gas emissions Similar to ISO 14001 environment management system structures, the advantages of using simplified Excel Sheet for calculating GHG emissions and reducing GHG emissions are easy to access.

• Proceedings of the KSR Conference
• /
• 2007.05a
• /
• pp.846-851
• /
• 2007

The contact and messenger wire is important parts in the electric power system of the railroad. There are so many measurement method like voltage, current, scratch of surface, and glow longer of length. In this paper suggest real time monitering system of messenger wire so called RTU (Remote Terminal Unit) and this system includes CDMA module to transfer real time or saved data of memory to the end user directly who is in the long distance. The hyper terminal program of windows shows the downloaded data from RTU through CDMA communication and this data can be transferred to excel sheet easily.