• Proceedings of the KAIS Fall Conference
• /
• 2009.05a
• /
• pp.446-449
• /
• 2009

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

• Korean Journal of Construction Engineering and Management
• /
• v.17 no.1
• /
• pp.3-9
• /
• 2016

This study proposes a approximate cost estimation system based on Excel with VBA using weighted CBR(Case Based Reasoning). One characteristic of this system is that it generates the sheet automatically as many as the number of similar case and new estimation when it performs a case learning and a new estimate and cell formula is automatically entered into each sheet. User can be free to compose a combination of attribute factors because they can select up to ten attribute factors. This paper presents an applicability of estimation model for estimating the soil remediation cost when it use a landfarming method. When compared to a estimation model by using average unit cost and optimum multiple regression, this model shows a better result. This study was aimed at landfarming method, but it is expected that a cost estimation model using CBR will be more likely to apply in soil remediation technologies which various remediation technologies and pollutant species exist.

• Journal of Korean Society of Water and Wastewater
• /
• v.28 no.6
• /
• pp.735-745
• /
• 2014

This paper presents PKES(PuKyung -Excel based Simulator) for WWTPs(wastewater treatment plants) by using MS Excel and VBA(Visual Basic for Application). PKES is a user-friendly simulator for the design and optimization of the whole plant including biological and physico-chemical processes for the wastewater and sludge treatment. PKES calculates the performance under steady or dynamic state and allows changing the mathematical model by the user. Mathematical model implemented in PKES is a improved integration model based on ASM2d and ADM1 for simulation of AS(activated sludge) and AD(anaerobic digestion). Gaseous components of $N_2$, $N_2O$, $CO_2$ and $CH_4$ are added for estimation of GHGs(greenhouse gases) emission. The simulation results for comparison between PKES and Aquasim(EAWAG) showed about the same effluent concentrations. As a result of verification using by measured data of BOD, TSS, TN and TP for 2 years of operation, calculated effluent concentrations were similar to measured effluent concentrations. The values of average RMSE(root mean square error) were 1.9, 0.8, 1.6 and 0.2 mg/L for BOD, TSS, TN and TP, respectively. Total GHGs emission of WWTP calculated by PKES was 138.5 ton-$CO_2$/day and GHGs emissions of $N_2O$, $CO_2$ and $CH_4$ were calculated at 21.7, 28.9 and 87.9 ton-$CO_2$/day, respectively. GHGs emission of activated sludge was 32.5 % and that of anaerobic digestion was 67.5 %.

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

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

• Journal of Korean Society on Water Environment
• /
• v.26 no.2
• /
• pp.297-302
• /
• 2010

It is very important to know mean and confidence interval of water-quality constituents such as BOD for water-quality control and management of rivers and reservoirs effectively. The mean and confidence interval of BOD at Anseong2 and Hwangguji3 sampling stations which are located at the border of local governments in Anseong Stream were estimated and analyzed in this paper using Bootstrap technique which is one of non-parametric statistics. The results of Bootstrap were compared with arithmetic mean, geometric mean, Biweight method mean as a point estimator and distribution mean came from the appropriate probability distribution of Log-normal. In Bootstrap technique 12 data set was randomly selected in each year and 1000 samples was produced to get parameter of population. Visual Basic for Applications (VBA) of Microsoft Excel was utilized in Bootstrap. It was revealed that the Bootstrap technique can be used to explain more rigorously and robustly the achievement or violation of BOD target concentration in Total Maximum Daily Load (TMDL).

• IE interfaces
• /
• v.21 no.4
• /
• pp.378-384
• /
• 2008

Small sized companies have not been successful in systematically applying statistical process control because of insufficient human resources. In this paper we present a case study of automatic checking system for a small sized company which produces various types of gears. A systematic way of automatically measuring gears is proposed and statistical analysis methods are presented. To reduce variation in the measurement data, a standard operating procedure is also proposed. This case study can be helpful to quality assurance practitioners of small sized companies who are willing to develop checking or inspection systems for their products.

• Transactions of Materials Processing
• /
• v.15 no.7 s.88
• /
• pp.496-503
• /
• 2006

The inner and outer car panels for bonnet, door, and trunk lid are assembled by hemming rather than welding. To achieve successful fabrication of these panels, the complicated timing chart of hemming units for pre-and main hemming stages should be made to optimal one. In this study, a design system for automatic timing chart generation is developed. Using AutoCAD VBA and EXCEL data chart, hemming die design parameters and guidelines were put into the program to give hemming unit drawings and consequent timing charts. Then the prepared timing charts were checked and modified. The effectiveness of the system is verified by applying it successfully to hemming unit design for bonnet panel joining.

• Journal of Information Technology Services
• /
• v.17 no.2
• /
• pp.101-110
• /
• 2018

Analytic Hierarchy Process (AHP) is a systematic and objective decision method that stratifies multiple criteria to determine various evaluation factors' order of priority. Since AHP requires several stages of analysis with complicated attributes, they normally rely on computer programs for the execution of such analyses. However, the existing AHP analytic tools carry the inconvenience of having to repeatedly input massive amounts data generated in every stage. This repetitious data entry process results in prolonged analysis times and higher possibility of errors, leading to decreased reliability of the results. Thus, in this study, we develop an analytic tool that effectively simplifies the data entry process in AHP analysis, for the purpose of reducing analysis times and increasing the reliability of the results.

• Journal of the Korea Society for Simulation
• /
• v.11 no.3
• /
• pp.67-77
• /
• 2002

In this paper, a production process system simulation of the automobile relay switch manufacturing factory is studied. The status of the present production system is inspected first, and the modified model is simulated next. To inspect the effect of the process parameter change, a simulation program is developed using PROMODEL simulation software plus the EXCEL VBA and Active X Automation function. Using the developed simulation program, user can find the best production condition and alternatives on the production capacity, number of workers, and inspection status considering the defective ratio of the product. The feasibility of the new alternatives is compared with the present system using statistical method.