• 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 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 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.

• Knowledge Management Research
• /
• v.13 no.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.

• Proceedings of the Computational Structural Engineering Institute Conference
• /
• 2008.04a
• /
• 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.

• Journal of the Korean Society of Mechanical Technology
• /
• v.20 no.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
• /
• v.23 no.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.

• Journal of the Korean Society for Nondestructive Testing
• /
• v.26 no.4
• /
• pp.246-254
• /
• 2006

A computation program has been developed for automatic data processing in the calibration process of gamma survey meter. The automatic processing program has been developed based on Visual Basic. The program has been coded according to steps of calibration procedure. The OLE(object linking an embedding) Excel automation method fur automatic data processing is used in this program, which is a kind of programming technique for the Excel control. The performance test on the basis of reference data has been carried out by using the developed program. In the results of performance test, the values of calibration factors and uncertainties by the developed program were equal to those obtained from the reference data. In addition, It was revealed that the efficiency and precision of working are significantly increased by using the developed program.

• KSCE Journal of Civil and Environmental Engineering Research
• /
• v.33 no.3
• /
• pp.1191-1202
• /
• 2013

The former researches on earthwork automation were mainly focused on GPS and sensor application, environment modelling, equipment path planning, work information management, and remote control etc. Recently, reducing $CO_2$ emission becomes one of main focuses for an automation research. In the case of earthwork operations, many kinds of construction machines or robots are involved, which can cause high level of $CO_2$ in a construction site. An effective earthwork plan and construction machine operation can both increase productivity and safety and decrease $CO_2$ emission level. In this research, some automation concepts for green earthworks are suggested such as a 3D construction site model, a 3D earthwork distribution based on two different earthwork methods, and an earthwork package construction method. A excel-based simulator is developed to generate the 3D earthwork distribution and to estimate the level of $CO_2$ emission for the given earthwork.

• Journal of the Society of Naval Architects of Korea
• /
• v.61 no.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.