• Journal of Korea Society of Industrial Information Systems
• /
• v.22 no.6
• /
• pp.61-69
• /
• 2017

ERP Systems can not meet All the Requirements that Needed in Their Enterprise Organizations. After the System Introduced, when it perates with Existing Systems or with New Systems, the Need for Strong Interface Technology along with the Appearance of the ERP have been gradually Increased. Interface Technologies for SAP R/3 Systems integrate Mulltiple R / 3 Systems and non R / 3 Systems, and play Important Role in Expanding the Company's Business Process. New VBA Approach was implemented as the Data Interface Design between SAP R / 3 and Other Systems. It proved to Reduce the Feeling of Resistance from User's Point of View. It also Proved to Improve the Operational Efficiency with More Convenient Input and Output Manner of Purchase Request Data.

• Proceedings of the KSRS Conference
• /
• 2005.10a
• /
• pp.257-259
• /
• 2005

A crop management system was developed using Visual Basic and ArcGIS VBA. The system is operated on ArcGlS 8.3 with Microsoft Access MOB. Landsat +ETM, KOMPSAT-l EOC, ASTER VNIR and IKONOS panchromatic (pan) and multi-spectral (MIS) images were included in the system to understand what kind of agriculture-related information can be extracted for each images. Agriculture related data inventories using crop cover information such as texture and average pixel value of the crop based on cultivation calendar were designed ,and implemented. Three IKONOS images (May 25,2001, December 25,2001, October 23,2003) 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 also supplied and can be overlaid with images to enhance the understanding the general agricultural characteristics and identifying the location easily.

• Proceedings of the Korean Statistical Society Conference
• /
• 2002.11a
• /
• pp.243-248
• /
• 2002

최근 다변량자료분석과 관련하여 이를 시스템으로 구현하려는 연구가 다양한 각도로 이루어지고 있다. 이러한 연구들의 공통적인 특징은 일반 사용자들에게 고급 통계분석기법을 편리하게 활용할 수 있도록 GUI(Graphical User Interface) 환경의 시스템을 제공해 준 것이다. 이런 연구의 연장선상에서 본 연구에서는 다변량자료분석 시스템을 구현하는데 있어 사회 각 분야에서 가장 널리 활용되고 있는 사무용 프로그램인 마이크로소프트(Microsoft) Excel을 활용하여 일반 사용자들도 다변량분석을 쉽게 활용할 수 있도록 대화식 시스템을 개발하였다.

• Journal of Korean Society of Industrial and Systems Engineering
• /
• v.35 no.2
• /
• pp.16-20
• /
• 2012

The purpose of this thesis is to develop a performance rating training tool for the time and motion study. It is widely recognized that rating training tools based on films were made several decades ago and introduced to Korea. However, to the best of our knowledge, those films are not used for rating training in Korea any more. Furthermore, although rating is still important method for the efficient operational management study, it is briefly mentioned without any training or exercise. In this paper, we propose a simple rating training tool based on Excel with VBA. The mottoes of our development are the ease of acquisition and trainees' motivation. Test results show that trainees can obtain the concept of rating and the ability of accurate and consistent rating as they play a computer game sitting in front of the personal computer.

• The Korean Journal of Applied Statistics
• /
• v.17 no.1
• /
• pp.165-172
• /
• 2004

Recently, there have been several studies to develop the multivariate data analysis system which can be readily used. The common characteristic of these studies is to develop the GUI system to which advanced statistical methods can be conveniently applied. In an extension of these studies, this study aims to supply users in various fields an interactive system with the convenience of the environment of GUI, which is constructed with the Excel macro and VBA, to apply multivariate data analysis methods easily. This system provides a graphic-oriented and menu-centered user interface in the Microsoft Excel which is widely used spreadsheet and analysis program.

• Proceedings of the Computational Structural Engineering Institute Conference
• /
• 2002.10a
• /
• pp.195-202
• /
• 2002

Generally, bridge designers must consider variable factors in design of bridge-structures. For this reason, it was difficult to make a design program till now. However, the rapid development of computers turns it into a possible one with considering complex factors and the advance of computer's language make us design programming. When we use the automatic design program including structural analysis(FEM), we can save the time and effort. Additionally, the automatic design program was generated to reduce the man' errors. Therefore, in this paper, the automatic design program of the Prestressed Concrete Slab Bridge was developed. This design program will support bridge designers with time that they can spend on a creative and efficient duty for development of design.

• Journal of the Korean Data and Information Science Society
• /
• v.22 no.6
• /
• pp.1183-1197
• /
• 2011

The prior distribution is the probability distribution we have before observing data. Using Bayes' rule, we can compute the posterior distribution, the new probability distribution, after observing data. Computing the posterior distribution is much easier than before by using Excel VBA macro. In addition, we can conveniently compute the successive updating posterior distributions after observing the independent and sequential outcomes. In this paper we compose some Excel VBA macros for applying Bayes' rule and give some examples.

• Journal of Korean Neurosurgical Society
• /
• v.39 no.5
• /
• pp.355-359
• /
• 2006

Objective : The purpose of our study is to examine the clinical significance of vertebrobasilar artery[VBA] fenestration and duplication. In addition, we review its incidence and pathogenesis. Methods : Cerebral angiography was performed in 803 patients and magnetic resonance angiography[MRA] in 880; the patients had or were suspected to have cerebrovascular disease. We retrospectively reviewed angiography and MRA. Results : Fifteen patients [eight men, seven women, 3 to 77 years of age, median age = 58 years] had a VBA fenestration and duplication. Seven [7/803 = 0.87%] of the patients undergoing cerebral angiography revealed fenestrations and one duplication of VBA. Ten patients [10/880 = 114%] among 880 patients that underwent MRA demonstrated fenestration of basilar artery[BA]. Two of 66 patients that underwent both conventional cerebral angiography and cranial MRA showed a fenestration of BA. Twelve fenestrations were located in the proximal portion of the BA and one was in the mid portion of the BA. One vertebral artery[VA] fenestration was located in the intracranial portion of the right VA, and one VA duplication was at the level of $C_{1-2}$ in the left VA. Conclusion : In addition to medial defects, flow phenomena at the proximal end of fenestrations, where hemodynamic stress and increased turbulence are present, may contribute to aneurysm formation. And arterial fenestration is a predisposing factor in vascular injury and cerebral ischemia.

• Transactions of the KSME C: Technology and Education
• /
• v.2 no.1
• /
• pp.21-28
• /
• 2014

As one of the most famous spreadsheet programs that is widely applied to a variety of fields in business, MS Excel has also been used for educational purposes due to its feature of wide accessibility, enabling students to use the program through almost any kind of PC that now exists. The program is mainly used for numerical analysis and formulae applications in the fields of science and engineering. This paper shall provide the key to understanding the application of MS Excel to teaching Statics through the illustration of its essential functions for education. Also, the development process of the analysis program using macros and VBA(Visual Basic for Applications) is described for the deeper comprehension of advanced applications. Students were not only able to solve the Statics problems using basic features of MS Excel, but also discovered new systematic methods of approaching complex problems and developed application programs using macros and VBA.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.17 no.8
• /
• pp.55-61
• /
• 2016

BIM is a rising core technology for increasing the productivity of the AEC industry, but such a paradigm shift is placing excessive demand on the practice of small medium size enterprises. BIM has many useful functions that are difficult to imagine in 2D CAD but BIM programs and the system buildup cost are too expensive. Therefore, small medium size enterprises hesitate to apply BIM in their fields. In this study, a customized 4D and 5D system was implemented using the building information generated from basic BIM tools, such as Revit, MS Project, Navisworks, and Excel VBA's customizing process to review the schedule and verify the quantities according to the schedule. Those programs are so basic in BIM circumstances, that small medium size enterprises can be equipped without burden. As a result, essential building information for 4D and 5D system implementation was investigated and its customizing process was established.