• Computers and Concrete
• /
• v.13 no.4
• /
• pp.457-482
• /
• 2014

This paper summarizes available literature on the optimization of reinforced concrete (RC) beams. The objective of optimization (e.g. minimum cost or weight), the design variables and the constraints considered by different studies vary widely and therefore, different optimization methods have been employed to provide the optimal design of RC beams, whether as isolated structural components or as part of a structural frame. The review of literature suggests that nonlinear deterministic approaches can be efficiently employed to provide optimal design of RC beams, given the small number of variables. This paper also presents spreadsheet implementation of cost optimization of RC beams in the familiar MS Excel environment to illustrate the efficiency of the exhaustive enumeration method for such small discrete search spaces and to promote its use by engineers and researchers. Furthermore, a sensitivity analysis is performed on the contribution of various design parameters to the variability of the overall cost of RC beams.

• Journal of Construction Engineering and Project Management
• /
• v.1 no.1
• /
• pp.31-36
• /
• 2011

Construction materials usually constitute a major portion of the total cost in a building construction project. Materials management Is made problematic by materials shortages, delays in supply, price fluctuations, damage and wastage, and lack of storage space. Despite the potential benefit of ICT, convincing construction organisations to embrace its use and implementation has proved a difficult task. This study seeks to identify the implementation of ICT for materials management processes in construction projects. The findings from the case studies reveal that the implementation of ICT in the materials management processes for construction projects in Malaysia Is at early stage. Microsoft Excel Spreadsheet and handheld devices are found to be the common ICT tools adopted in the materials management processes. The main barrier is found to be the cost involvement at the initial stage or overall implementation of ICT in the materials management processes. Finally, this paper concludes the finding from interviews towards the ICT implementation of materials management in the construction projects.

• International conference on construction engineering and project management
• /
• 2011.02a
• /
• pp.195-200
• /
• 2011

Construction materials usually constitute a major portion of the total cost in a building construction project. Despite the potential benefit of ICT, convincing construction organisations to embrace its use and implementation has proved a difficult task. This study seeks to identify the implementation of ICT for materials management processes in construction projects. The findings from the interviews reveal that the implementation of ICT in the materials management processes for construction projects in Malaysia is at early stage. Microsoft Excel Spreadsheet and handheld devices are found to be the common ICT tools adopted in the materials management processes. The main barrier is found to be the cost involvement at the initial stage or overall implementation of ICT in the materials management processes. Finally, this paper concludes the finding from interviews towards the ICT implementation of materials management in the construction projects.

• 한국정보교육학회:학술대회논문집
• /
• 2021.08a
• /
• pp.385-391
• /
• 2021

In this paper, a case of deep learning artificial neural network education was studied for artificial intelligence literacy education for preservice teachers and incumbent teachers. In addition, through the proposed educational case, we tried to explore the contents of artificial neural network principle education that elementary, middle and high school students can experience. To this end, first, an example of training on the principle of operation of an artificial neural network that recognizes two types of images is presented. And as an artificial neural network extension application education case, an artificial neural network education case for recognizing three types of images was presented. The number of output layers was changed according to the number of images to be recognized by the artificial neural network, and the cases implemented in a spreadsheet were divided and explained. In addition, in order to experience the operation results of the artificial neural network, we presented the educational contents to directly write the learning data necessary for the artificial neural network of the supervised learning method. In this paper, the implementation of the artificial neural network and the recognition test results are visually presented using a spreadsheet.

• Proceedings of the Korean Operations and Management Science Society Conference
• /
• 2003.05a
• /
• pp.637-641
• /
• 2003

최근에 데이터관리, 통계분석, 그래프분석, What-If 분석 등을 위하여 스프레드시트가 광범위하게 사용되고 있다. 본 논문은 전자 부품을 생산하는 라인에 TGC(Theory of Constaints)를 적용하는 과정에서 활용된 엑셀 스프레드시트 프로그램의 사례에 대하여 소개한다. TOC 개념에서의 제품 조합 문제, 제약자원 선택 분석, DBR 스케쥴링 등인 자체의 함수기능, 그래프기능 해찾기 기능과 VBA(Visual Basic Application) 긴능을 이용하여 엑셀에서 구현된 내용이 포함된다.

• Journal of Practical Engineering Education
• /
• v.13 no.2
• /
• pp.233-242
• /
• 2021

In this paper, as a liberal arts course for non-majors, we proposed a supervised learning artificial neural network parameter optimization method and a basic education method for activation function to design a basic artificial neural network subject curriculum. For this, a method of finding a parameter optimization solution in a spreadsheet without programming was applied. Through this training method, you can focus on the basic principles of artificial neural network operation and implementation. And, it is possible to increase the interest and educational effect of non-majors through the visualized data of the spreadsheet. The proposed contents consisted of artificial neurons with sigmoid and ReLU activation functions, supervised learning data generation, supervised learning artificial neural network configuration and parameter optimization, supervised learning artificial neural network implementation and performance analysis using spreadsheets, and education satisfaction analysis. In this paper, considering the optimization of negative parameters for the sigmoid neural network and the ReLU neuron artificial neural network, we propose a training method for the four performance analysis results on the parameter optimization of the artificial neural network, and conduct a training satisfaction analysis.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.16 no.4
• /
• pp.2338-2343
• /
• 2015

An analytical model was developed in this study and then implemented into a tool for automation of FEA (Finite Element Analysis) of a spindle system for natural frequencies and modes in the universal FEA software, ANSYS. VBA of EXCEL was used for the implementation. It allowed graphic user interfaces (GUIs) to be developed for a user to interact with the tool and, in addition, an EXCEL spreadsheet to be used for data arrangement. A code was developed in the language of ANSYS to generate the geometric model of the spindle system, sequentially to construct the analytical model based on the information in the GUIs, and finally to perform computation for the FEA. Its automation of the model generation and analysis can help to identify a near optimal design of the spindle system under design in minimum time and efforts.

• Journal of The Korean Association of Information Education
• /
• v.25 no.5
• /
• pp.791-801
• /
• 2021

In this paper, an educational case that can be applied as artificial intelligence literacy education for preservice teachers and incumbent teachers was studied. To this end, a case of educating the operating principle of an artificial neural network that recognizes images is proposed. This training case focuses on the basic principles of artificial neural network operation and implementation, and applies the method of finding parameter optimization solutions required for artificial neural network implementation in a spreadsheet. In this paper, we focused on the artificial neural network of supervised learning method. First, as an artificial neural network principle education case, an artificial neural network education case for recognizing two types of images was proposed. Second, as an artificial neural network extension education case, an artificial neural network education case for recognizing three types of images was proposed. Finally, the results of analyzing artificial neural network training cases and training satisfaction analysis results are presented. Through the proposed training case, it is possible to learn about the operation principle of artificial neural networks, the method of writing training data, the number of parameter calculations executed according to the amount of training data, and parameter optimization. The results of the education satisfaction survey for preservice teachers and incumbent teachers showed a positive response result of over 70% for each survey item, indicating high class application suitability.

• Journal of the Korean Society of Manufacturing Process Engineers
• /
• v.14 no.2
• /
• pp.127-133
• /
• 2015

In this study, an analytical model was developed for one-dimensional finite element analysis (1D FEA) of a spindle system of machine tools and then implemented to automate the FEA as a tool. FEA, with its vibration characteristics such as natural frequencies and modes, was performed using the universal FEA software ANSYS. VBA of EXCEL was used to provide the programming environment for its implementation. This enabled graphic user interfaces (GUIs) to be developed to allow interactions of users with the tool and, in addition, an EXCEL spreadsheet to be linked with the tool for data arrangement. The language of ANSYS was used to develop a code to perform the FEA. It generates an analytical model of the spindle system based on the information at the GUIs and subsequently performs the FEA based on the model. Automation helps identify the near-optimal design of the spindle system with minimum time and efforts.

• Proceedings of the Korean Operations and Management Science Society Conference
• /
• 1995.04a
• /
• pp.847-864
• /
• 1995

In this paper we present an integrated methodology for strategic planning in telecommunications standardization. Especially this paper focuses on the method of setting priorities for telecommunications SWAs(Standardization Work Areas) and related SWls(Standardization Work Items). To make a strategic plan for telecommunications standardization in which usually includes prioritization, resource allocation, standardization schedule for each SWA is based on prioritization of SWAs. Our methodology integrated various existing methods including the Analytic Hierarchy Process(AHP) and a modified Delphi technique. Recently, rapid technology evolution in telecommunications fields increases the necessity of developing more and more new standards. Also increased complexity of those technologies makes standards more complicated, more specified and more thick than the past ones. As a result, the number of SWAs and SWIs are being increased constantly. Furthermore, rapid telecommunication environment changes such as deregulation, liberalization, privatization, regionalization, and globalization surrounding standardization bring about new challenges and opportunities. Due to all these trends, strategic planning for telecommunications standardization grows more and more important. To cope with these challenges and also to make the more efficient use of the limited standardization resources including time, financial, human resources, we suggest more logical and rational approach that will be a backbone of strategic plan for telecommunications standardization. The telecommunications standardization planning process involves a MCDM(Multi-Criteria Decision Making) process. The Analytic Hierarchy Process(AHP) is a kind of MCDM approaches. Our method is based on a combination of a modified Delphi technique and an application of AHP(Liberator's spreadsheet model). Analyzed data from Delphi technique is used as inputs to ABP. In addition, we also focus on the technique how to combine group judgments and to handle a large number of comparisons. We present analyzed results including Pilot and Full Scale Survey according to the proposed process. The result of this study will be useful input for telecommunications standardization policy making and practical implementation.