• 한국산학기술학회논문지
• /
• 제16권4호
• /
• pp.2338-2343
• /
• 2015

본 연구에서는 범용 유한요소해석 소프트웨어인 ANSYS를 사용하여 공작기계 스핀들 시스템의 유한요소 해석 자동화를 위해서 해석 모델을 개발하고, 그것을 툴로 구현하였다. 그 구현을 위해 EXCEL의 VBA를 사용하였으며, 이로 인해서 사용자가 툴과 상호교류할 수 있도록 그래픽 인터페이스를 개발할 수 있었고, 데이터 정렬을 위해서 EXCEL의 spreadsheet를 사용할 수 있었다. ANSYS 언어를 사용하여 코드를 개발하였으며, 이는 인터페이스에 입력된 정보를 사용하여 형상 모델을 만들고, 순차적으로 해석 모델을 만들며, 마지막으로 유한요소해석 연산을 수행한다. 모델 생성과 해석의 자동화는 최소한의 시간과 노력으로 설계 중인 스핀들 시스템의 근사 최적 설계를 발견하도록 도울 수 있을 것이다.

• 한국BIM학회 논문집
• /
• 제12권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.

• 한국기계가공학회지
• /
• 제14권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.

• 지식경영연구
• /
• 제13권2호
• /
• pp.37-52
• /
• 2012

A spreadsheet is a office automation software which has been widely used in almost all areas in business. A spreadsheet is used for calculation, data analysis, model building and so on. As a result, spreadsheet is a very important tool for generating knowlege in a firm. Errors in a spreadsheet model can cause a serious financial damage in a corporation. However in Korea few researches for reducing errors have been performed. Neither serious efforts to reduce errors have been executed by corporations. In this research we provided summarized the results from a survey for spreadsheet usage, summarized researches on errors in spreadsheet up to now, and suggested a rules and structured development method for reducing errors in a spreadsheet. Errors in spreadsheets are prevalent. To solve this serious problem, we need much more attention on this problem in research area. Corporations must put more efforts on setting policies and rules. And also we need the government's concern and support.

• 한국전산구조공학회:학술대회논문집
• /
• 한국전산구조공학회 2008년도 정기 학술대회
• /
• pp.294-299
• /
• 2008

Nowadays there are numerous factors to design the structure even for simple one, but many parts of the work are similar to the existing or repeated simply. In this case, design of the structure is unnecessarily needed lots of effort and time. To solve difficulties of design, an integrated design automation system for retaining wall structures that widely used is developed. The automation system consists of following items, 1) XML data structure between modules, 2) CAD visualization system to provide drawing sheets, 3) excel solution to provide structural design sheets and bills of quantity, 4) design logic to analysis and calculate behaviors of structure, and 5) GUI to represent data and results for the program.

• 한국기계기술학회지
• /
• 제20권6호
• /
• pp.824-829
• /
• 2018

Molding is the root industry of the manufacturing as a means to mass-produce developed prototypes. Molds are typically divided into injection molds and press mold industries. Injection molds produce the products by injection of molten plastic into a mold, and press molds are molded and bended plate. The ejection system, such as eject pins, is used to separate the manufactured products from the mold, which involves a number of hole operations. Location, diameter and depth of holes are often tabulated and managed collectively when designing 2D drawings. The design efficiency was realized by applying CATIA Automation to the 3D model and bringing in the data of the holes in the Excel data.

• International Journal of Computer Science & Network Security
• /
• 제23권9호
• /
• pp.37-46
• /
• 2023

The main aim of the article is to solve the problem of automating price monitoring using marketing forecasting methods and Excel functionality under martial law. The study used the method of algorithms, trend analysis, correlation and regression analysis, ANOVA, extrapolation, index method, etc. The importance of monitoring consumer price developments in market pricing at the macro and micro levels is proved. The introduction of a Dummy variable to account for the influence of martial law in market pricing is proposed, both in linear multiple regression modelling and in forecasting the components of the Consumer Price Index. Experimentally, the high reliability of forecasting based on a five-factor linear regression model with a Dummy variable was proved in comparison with a linear trend equation and a four-factor linear regression model. Pessimistic, realistic and optimistic scenarios were developed for forecasting the Consumer Price Index for the situation of the end of the Russian-Ukrainian war until the end of 2023 and separately until the end of 2024.

• 비파괴검사학회지
• /
• 제26권4호
• /
• pp.246-254
• /
• 2006

방사선 측정분야에서 사용되는 감마 서베이미터의 교정데이터 자동처리를 위한 전산 프로그램을 개발하였다. 전산 프로그램은 Visual Basic을 기반으로 개발되었으며, 교정과정에 따라 단계별로 윈도우를 제작하고 코드화하였다. 교정 데이터의 자동처리를 위해 Microsoft Excel 프로그램을 제어하여 미리 자동 연산된 엑셀 셀 내에 데이터가 입력되도록 하였다. 개발프로그램 성능평가의 일환으로 검증된 데이터와 프로그램에서 출력된 데이터를 비교한 결과, 교정인자 산출 및 불확도 평가에서 동일한 결과가 나왔다. 또한, 개발프로그램을 교정업무에 적용시킨 결과, 업무의 효율성 및 정확성은 증가하였다.

• 대한토목학회논문집
• /
• 제33권3호
• /
• pp.1191-1202
• /
• 2013

기존의 토공 자동화 연구들은 주로 GPS와 센서의 응용, 작업환경 모델링, 장비 진로계획, 작업 정보관리, 원격조정 등과 같은 주제에 관심을 두었다. 최근에는 건설자동화 연구분야에서 $CO_2$ 감축이 주요 관심사의 하나로 대두되었다. 토공작업의 경우에는 많은 종류의 건설장비나 로봇들이 관여되므로 건설현장에서 많은 양의 $CO_2$를 배출하는 작업이 되고 있다. 효과적인 토공계획과 건설장비 운영은 생산성 및 안전성을 증가시킬 뿐만 아니라 $CO_2$ 배출량도 줄일 수 있다. 본 연구에서는 3D 토공현장 모델, 2가지 시공법에 의한 3D 토량배분 방법, 토공작업 패키지 구성방법과 같은 그린 토공을 위한 몇 가지 자동화 개념을 제시하고 있다. 엑셀로 작성된 시뮬레이터를 개발을 통하여 주어진 토공작업에 대하여 3D 토량배분 계획을 수립하였고 $CO_2$ 배출량을 추정하였다.

• 대한조선학회논문집
• /
• 제61권5호
• /
• pp.370-377
• /
• 2024

The International Maritime Organization (IMO) mandates that evacuation analysis must be performed at the design stage to ensure the safety of passengers aboard ships. Therefore, ship designers are required to conduct this evacuation analysis during the ship design process. Evacuation analysis begins with creating an escape diagram that outlines the routes from each cabin to the designated assembly stations based on the designed plans. Subsequently, necessary parameters for escape analysis are measured and recorded, and the analysis is conducted using an Excel-based program. This process is manual and time-consuming. Additionally, due to the frequent design changes characteristic of passenger ships, this process must be repeated multiple times. Hence, this study proposes a method to automate this analysis process. The proposed method in this study starts with a preprocessing step to extract key components from 2D drawings. Following this, it distinguishes spaces such as cabins, corridors, and doors within the processed drawings. Using the identified spaces, it then searches for the shortest evacuation routes from each cabin to the assembly station. Based on the identified routes, the method automatically performs the simplified evacuation analysis as prescribed by IMO regulations. Applying the algorithm for automated escape analysis to Ro-Pax vessels demonstrated that the analysis time per ship, which previously took about 15 days, can be reduced to less than 10 minutes.