• Journal of KIBIM
• /
• v.12 no.2
• /
• pp.49-59
• /
• 2022

The main idea of this study is to propose a BIM-based automation system drawing up a report of energy conservation plan in the architecture division. In order to obtain a building permit, an energy conservation plan must be prepared for buildings with a total floor area of 500m² or more under the current law. Currently, it is adopted as a general method to complete a report by obtaining data and drawings necessary for an energy conservation plan through manual work and input them directly into the verification system. This method takes a lot of effort and time in the design phase which ultimately increases the initial cost of the business, including the services of companies specialized in the environmental field. However, in preparation for mandatory BIM work process in the future, it is necessary to introduce BIM-based automatic creation system that has an advantage for shortening the whole process to enable rapid permission of energy-saving designs for buildings. There may be many methods of automation, but this study introduces how to build an application using Dynamo of Revit, in terms of utilizing BIM, and write an energy conservation plan by automatic completion of report through Dynamo and Excel's VBA algorithm, which can save time and cost in preparing the report of energy conservation plan compared with the manual process. Also we have insisted that the digital transformation of architectural process is a necessary for an efficient use of our automation system in the current energy conservation plan workflow.

• Journal of the Korea Society for Simulation
• /
• v.29 no.2
• /
• pp.11-20
• /
• 2020

As the manufacturing environment becomes more complex, traditional simulation models alone are having a lot of difficulties in reflecting real-time manufacturing situations. Although the Digital Twin concept is actively discussed as an alternative to overcome theses issues, many studies are being carried out only in the product design phase. This research presents a Digital Twin-based manufacturing environment framework for applying the Digital Twin concept to the manufacturing process. Twin model that is operated in virtual space, physical system and databases describing the actual manufacturing environment, are proposed as detailed components that make up the framework. To check the applicability of proposed framework, a simple Digital Twin-based manufacturing system was simulated in a conveyor system using Arena software and Excel VBA. Experiment results have shown that the twin model is transmitted real time data from the physical system via DB and were operating in the same time unit. The Excel VBA fitted parameters defined by cycle time based on historical data that real-time and training data are being accumulated together. This study proposes operating method of digital twin model through the simple experiment examples. The results lead to the applicability of Digital twin model.

• Journal of The Korean Society of Agricultural Engineers
• /
• v.47 no.7
• /
• pp.3-9
• /
• 2005

A computer system for crop information was developed using Visual Basic and ArcGIS VBA. The system is operated on ArcGIS 8.3 with Microsoft Access MDB. Landsat +ETM, KOMPSAT-1 EOC, ASTER VNIR and IKONOS panchromatic (Pan) and multi-spectral (MIS) images were included in the system to extract agricultural land use items identifiable at various spatial resolutions of images. Agriculture related data inventories using crop cover information such as texture and average pixel value of each band based on crop cultivation calendar were designed and implemented. Three IKONOS images were loaded in the system to show crop cover characteristics such as rice, pear, grape, red pepper, garlic, and surface water cover of reservoir with field surveys. GIS layers such as DEM (Digital Elevation Model), stream, road, soil, land use and administration boundary were prepared to understand the related characteristics and identify the location easily.

• Journal of the Korea Society for Simulation
• /
• v.23 no.4
• /
• pp.21-29
• /
• 2014

In general, a simulation project requires much time and money since we should develop a model that works similarly to the system at a level consistent with the project purposes. Therefore, more active research studies are required to reduce the time needed for the modeling process. This is achievable by minimizing the possible trial and error during the model development process through the appropriate conceptual model design and the automated generation of the simulation model. This paper presents a tool automatically generating an Arena model after developing a conceptual simulation model. Because our proposed tool is based on the popular Microsoft Excel and Visio, it is expected to be practically used at many industrial sites. Finally, we showed the effectiveness of the newly suggested tool by applying it to an imaginary simulation project.

• Proceedings of the Korea Water Resources Association Conference
• /
• 2007.05a
• /
• pp.2008-2012
• /
• 2007

통계청 등의 기관에 구축되어있는 기본적인 비점오염원 자료들은 행정구역별로 나뉘어져 있지만 실제수계에 도달하는 부하량 산정을 위해서는 유역별로 구분을 다시 해야만 하는 번거로움이 있다. 따라서 본 연구에서는 반복되는 비점오염원 자료의 전처리 과정의 번거로움을 피하기 위하여 지리정보체계(Geographical Infomation System; GIS)와 VBA(Visual Basic for Application)를 이용하여 통계자료의 전처리 과정을 한 번에 처리할 수 있는 시스템을 구축하였다. 본 시스템은 선택한 유역도와 행정구역도를 중첩하여 유역 내 최소행정구역의 점유율을 반영한 통계자료를 사용자 친화적으로 재분류하는 시스템이다. 본 시스템의 적용성 확인을 위하여 새만금유역 내 주상천유역을 대상으로 연구를 실시하였으며, 새만금유역에 포함되는 전라북도 최소행정구역의 토지이용 통계자료만을 기본 데이터로 활용하였다. 본 연구에서 구축된 시스템은 오염부하량 산정에 있어 요구되는 기본적인 데이터를 얻는 것에 있어서 기존의 장시간에 걸친 단순 반복작업을 대신하는 효율적인 시스템이며, ArcGIS에 대한 이해가 부족한 사용자의 경우에도 간단한 시스템조작만으로도 필요한 데이터를 구축할 수 있어 사용자에게 편리함을 제공한다. 향후 본 시스템을 이용하여 비점오염부하량 산정시스템을 개발할 수 있고, 기상자료 등과 같은 수문모형으로의 적용도 가능할 것으로 기대된다.

• Journal of Korean Society of Industrial and Systems Engineering
• /
• v.33 no.2
• /
• pp.33-38
• /
• 2010

To survive head-to-head competition, we should keep our labor productivities above those of other nations. However, our labor productivities are low compared to those of the developed countries. It is the well-known fact that we make up for the productivities with long work hours. Entering the line of developed nations safely and enjoying well-being age freely, we need to achieve high labor productivities without sacrificing work hours. What would be a fine solution? Back to the basics! Although it is important to enforce R&D on high-tech products, we should have so-called bluebird philosophy, being faithful to the basics and trying to find solutions at a stone's throw. Basics of basics may be unceasing improvement, establishing reasonable standard times, and maintaining them. To support going back to the basics, this thesis proposes VITAMAX, a motion and time study software. As VITAMAX stands for "Visual Improvement and Time Analysis for Maximizing Profits", it provides a simple and powerful visual tool which is useful for improving manual works and determining standard times. Since VITAMAX is based on the Microsoft Excel and VBA, it is very cost-effective and easy to use. VITAMAX may contribute to the profit increase of manufacturing companies, especially for the small and medium-sized enterprise.

• Journal of the Korean Geotechnical Society
• /
• v.20 no.1
• /
• pp.49-59
• /
• 2004

A GIS-based tunnelling risk management system(GIS-TURIMS) was developed as a product of this study, The developed system uses ArcView 8.1 as a basic platform and the built-in interface(VBA) has been used to perform first-order simplified analyses for the prediction of tunnelling-induced ground movements and building damage assessment. The main emphasis of this study was to develop a working framework that can be used in the perspective of tunnelling risk management. The developed system is capable of carrying out cornputationally intensive analyses for ground movement prediction as well as buildings/utilities damage assessment taking full advantage of the GIS technologies. This paper describes the concept and details of the GIS-TURIMS development and implementation.

• Journal of Korea Society of Industrial Information Systems
• /
• v.15 no.5
• /
• pp.187-196
• /
• 2010

We present a link that allows Excel to call the functions in the lp_solve system. lp_solve is free software licensed under the GPL that solves linear and mixed integer linear programs of moderate size. Our link manages the interface between Excel and lp_solve. Excel has a built-in add-in named Solver that is capable of solving mixed integer programs, but only with fewer than 200 variables. This link allows Excel users to handle substantially larger problems at no extra cost. Futhermore, we introduce that a network drawing method in Excel using arc adjacency lists of a network.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.21 no.11
• /
• pp.510-518
• /
• 2020

With the promotion of digitalization in the construction industry, BIM has become an indispensable technology. On the other hand, it has not been actively utilized in practice because of the difficulty of BIM modeling. The reason is that 3D modeling is less productive not only because of the difficulty of learning BIM software but also the modeling work is done manually. Therefore, this study proposes a method and system that can improve the productivity of BIM-based modeling. For this reason, in the study, a slit caisson, which is a typical structure of a port, was selected as a development target, and various parameters were derived through interviews with experts so that it could be used in practice. This study presents a UI construction plan that considers user convenience for efficient management and operation of diverse and complex parameters. Based on this, this study used visual programming and Excel VBA to develop a BIM-based design automation system for slit caissons. The developed system can use many parameters to quickly develop slit caisson models suitable for various design conditions that can contribute to BIM-based modeling and productivity improvement.

• Proceedings of the KAIS Fall Conference
• /
• 2007.05a
• /
• pp.154-157
• /
• 2007

본 논문에서는 컴퓨터로 정밀 계측기기들을 자동 제어하고 데이터를 측정하기 위하여 기존의 상용 프로그램을 사용하지 않고 Excel VBA(Visual Basic for Applications)를 이용하는 방법에 대하여 연구 하였다. 이는 반복측정 및 통계적 수치계산 등에서 많은 장점을 지니고 있어 수많은 국가교정기관 및 일반 산업체에서 유용하게 사용될 수 있으리라 사료된다.