• The Journal of the Society of Korean Medicine Diagnostics
• /
• v.14 no.1
• /
• pp.70-78
• /
• 2010

Objectives : To qualify or enhance the diagnostic ability of students in Oriental Medicine, so called standardized patients are ideal modality, but because it's a man-based method, more convenient tools are required. Computer-based diagnostic ability test program gives effective way for the very purpose. So we made a pilot software evaluating Pattern Identification ability in Oriental Medicine. Methods and Materials : The pilot software was coded with Microsoft's EXCEL VBA. 87 names of Zheng (Symptom Pattern) and 674 names of symptom (including some signs) are adopted from the former standardization works conducted by Korean Institute of Oriental Medicine (KIOM) in 1996. Results : Compared with some manned modalities to test Pattern Identification ability, the test by this software shows superiority in convenience and objectivity. Conclusion : This software is world's first program to perform computer-based evaluation of Pattern Identification in Oriental Medicine, and it gives effective way to complement both written test and manned clinical performance test (CPX).

• Journal of Ocean Engineering and Technology
• /
• v.31 no.2
• /
• pp.91-102
• /
• 2017

Recently, a new type of LNG membrane Tank called the "KC-1 membrane LNG Tank" was developed by KOGAS (Korean Gas Corporation). It is necessary to estimate the temperature distribution of the hull structure and insulation system for this new LNG tank, as well as the BOR (Boil-Off Rate) when exposed to outside temperature conditions to ensure the integrity of the tank structure and limit LNG evaporation, from a safety evaluation point of view. In this study, temperature distribution calculations for the hull structure and insulation system of the KC1 membrane tank were compared by employing four numerical approaches under the IGC condition. Approaches 1-3 studied 2D simulations and approach 4 used a 3D numerical simulation. Approach 1 was calculated by in-house Excel VBA codes and the three other approaches utilized ANSYS Fluent. The BOR of approach 4, the 3D simulation case, for the IGC condition was 0.0986%/day.

• Journal of the Korea Safety Management & Science
• /
• v.24 no.2
• /
• pp.127-134
• /
• 2022

Production management in the automobile parts industry is carried out according to the production plan of the customer, so it is important to prevent shortages in product supply. As the product composition became increasingly complex, the MES System was built for the purpose of efficient production plan management and inventory management, but its utilization is low. This study analyzed the problems of the MES system and sought to improve it. Through previous studies, it was confirmed that the inventory management of the pull approach that actually occurred in the warehouse is more suitable than the push approach based on the forecast of the warehouse for the volatility, complexity, and uncertainty of orders in the auto parts industry. To realize this, we tried distributed MRP by using the ADO function of VBA to link the standard information of the MES system with Excel and change the structure of the BOM table. Through this, it can help increase the accuracy of production planning and realize efficient inventory management, thereby increasing the utilization of the MES system in the auto parts industry and enhancing the competitiveness of the company.

• International conference on construction engineering and project management
• /
• 2013.01a
• /
• pp.243-251
• /
• 2013

Cash management is a major concern for all contractors in the construction industry. It is arguable that cash is the most critical resource of all. A contractor needs to secure sufficient funds to navigate the project to the end, while keeping an eye on maximizing profits along the way. Past research attempted to address such topic via developing models to tackle the time-cost tradeoff problem, cash flow forecasting, and cash flow management. Yet, little was done to integrate the three aspects of cash management together. This paper, as such, presents a comprehensive model that integrates the time-cost tradeoff problem, cash flow management, and cash flow forecasting. First, the model determines the project optimal completion time by considering the different alternative construction methods available for executing project activities. Second, it investigates different funding alternatives and proposes a project-level cash management plan. Two funding alternatives are considered; they are borrowing and company own financing. The model was built as a combinatorial optimization model that utilizes ant colony search capabilities. The model also utilizes Microsoft Project software and spreadsheets to maintain an environment that incorporates activities, their durations, and other project data, in order to estimate project completion time and cost. Ant Colony Optimization algorithm was coded as a Macro program using VBA. Finally, an example project was used to test the developed model, where it acted reliably in maximizing the contractor's profit in the test project.

• Journal of the Korea Society of Computer and Information
• /
• v.25 no.9
• /
• pp.117-123
• /
• 2020

This study intended to develop the Performance Evaluation system for the modern pentathlon such as an Olympic sporting event. The performance evaluation index system for the modern pentathlon was developed by Microsoft Excel 2016 with Visual Basic for Application that it is able to be understandable for the practical field in sport. Consequently, the system for the performance evaluation index is able to be developed within the concept of performance analysis of sport such as a notational analysis of sport. And the performance indicators for the performance evaluation index were selected by the skills to make successful outcomes. Finally, the simulation with big data gathering by the developed system would be requested that systematic reviews on successful outcomes in other sporting events would be necessary.

• Journal of Korea Water Resources Association
• /
• v.41 no.1
• /
• pp.17-25
• /
• 2008

Whether rating curves are used in practice or new ones are derived, the characteristics of regression analysis are often neglected. For example, a discharge rating curve, which is established from a regression of observed water levels (H) on observed flowrates(Q), is sometimes used for estimating a design water level corresponding to a simulated design flood runoff. However, if independent and dependent variables are changed with each other, the regression equation is changed in existing regression analysis, which is derived from vertical errors between observed data and regression line. Thus, regression equations should not be applied inversely. To avoid this problem, A new two-way variable least-squares regression analysis is proposed. The new method was applied to the rating curves of five water level stations on main stream of Nakdong River. The three kinds of regression models, which are respectively regression of Q versus H (model 1), H versus Q (model 2) and two-way (model 3), showed that the new method can reduce inadvertent mistakes when applied in practice.

• Journal of Korean Neurosurgical Society
• /
• v.40 no.4
• /
• pp.239-244
• /
• 2006

Objective : The present study evaluated overall surgical results for 3,000 patients with intracranial aneurysms, operated on in Busan Paik Hospital institution. Methods : Three thousand aneurysm cases, operated on in Busan Paik Hospital between January 1980 to June, 15th, 2005, were evaluated based on the following criteria; aneurysm form, aneurysm location, surgical results, postoperative complications, and seasonsonality of occuence. 957 cases were anterior communicating artery aneurysms, 776 were internal carotid artery[ICA] aneurysms, 755 were middle cerebral artery[MCA] aneurysms, 96 were anterior cerebral artery[ACA] aneurysms, 128 were vertebro-basilar artery[VBA] aneurysms and 288 were multiple aneurysms. The male to female ratio was 0.7 to 1 Surgical methods included 2.738 clippings, 219 coating and wrappings, 23 aneurysmoraphies, 20 proximal ligations. Results : Rebleeding occured in 5.1% of the early operation group and 16% of the late operation group respectively. Incidence of clinical vasospasm was 166% and angiographic vasospasm was 24.1%. The percentage of the multiple aneurysms was 9.5%, the percentage of the dissecting aneurysm was 6 cases [0.2%], 6 of the total [0.2%];De Novo" aneurysm, the percentage of lobectomies with clipping cases was 9 cases [03%] the percentage were incidental aneurysms; 164 [5.5%]. 88.1% had overall favorable surgical results with a 5.5 % mortality rate. Calcium-channel blocker and "Triple H" therapy did not improve mortality but did significantly improve morbidity. In the old age group, early operation reduced vasospasm, rebleeding and medical complications. The early surgery group exhibited a 86.2% favorable outcome with a 8.1% mortality rate. Intraoperative angiography reduced residual or remained aneurysms in large, giant aneurysm, especially in A.com artery aneurysm. Conclusion : The surgical results for the early surgery group according to surgical timming was better, but there were not statistically significant. ntraoperative angiography was especially useful on large aneurysms of the anterior communicating artery.

• Proceedings of the Korea Water Resources Association Conference
• /
• 2008.05a
• /
• pp.2212-2216
• /
• 2008

본 연구는 하도특성의 불규칙으로 인해 수위와 유량이 단일 관계가 형성되지 않은 경우와 유수의 흐름이 지속되어 GZF 측정이 어려운 경우에 구간분리와 GZF를 결정하는 곡선식 개발 방법론이라 할 수 있다. 첫번째 연구과제는 저수위 구간 수위-유량관계곡선식의 GZF 추정방법의 개선에 관한 연구이다. 다음과 같은 연구를 수행하기 위해서 GZF의 변화에 따라 곡선식의 신뢰도를 분석할 수 있는 프로그램을 개발하였다. 본 연구에서 개발한 프로그램은 사용자들이 쉽게 이용할 수 있는 엑셀 VBA(Visual Basic for Applications)로 작성되었으며, 입력자료 구축 모듈, 하도단면 입력 모듈, GZF 설정 모듈, GZF 평가 등의 4개 모듈로 구성되어 있다. 두 번째 연구과제는 구간분리 유무의 기준에 관한 연구로서 수위-유량관계곡선의 신뢰도에 직접적인 영향을 미친다. 본 연구에서는 일차적으로 단면의 특성이 상이한 4개의 수위관측소를 선정하여 수위-면적 곡선과 수위-면적변화량곡선을 생성하였으며 이로부터 단면변화와 구간분리의 특성을 분석하였다. 구간분리의 기준에 영향을 미치는 변수로는 단면특성인자, 유속, 하상경사, 수면경사, 단면통제, 하도통제 등을 들 수 있으며, 또한 다음과 같은 주요변수들이 서로 복합적으로 작용되기 때문에 일정한 기준을 제시하기란 어려운 부분이라 할 수 있다. 따라서 본 연구에서는 구간분리에 영향을 미치는 주요 변수 중에서도 가장 크게 영향을 주는 변수인 하도 단면의 특성 등을 중심으로 연구를 진행하였다. 먼저 단면의 특성이 서로 상이한 수위 관측소 단면을 선정하여 수위관측소별로 저수부에서 고수위 구간까지 10cm의 등간격으로 수위별 면적을 산정하여 구간분리의 가능성을 판단하였다. 구간분리의 유무에 관한 연구는 현재 진행 중에 있으며, 향후에는 1단면, 2단면, 3단면까지 파악하여 단면 특성이 구간분리에 미치는 영향 등을 파악할 계획에 있다. 또한 하도 단면의 다양성을 고려하여 단면형상이 상이한 여러 수위관측소 지점에서 구간분리의 기준을 연구할 계획이며, 단면의 특성을 파악한 후에는 유량, 유속, 하상경사, 하도통제 등을 고려할 계획이다.

• Proceedings of the Korean Institute of Navigation and Port Research Conference
• /
• v.29 no.1
• /
• pp.237-243
• /
• 2005

To design ship channel is one of important factors for planning and developing a port. Bends in channel should be avoided if possible, but the channel should be widened, if channel bend is unavoided, to account widened path of a ship in bend for the safe passage of a ship. In this study, Variable Bumper Area(VBA) model is applied to determine ship channel width in bend and channel-bend geometry. The result of this study shows that the width of a channel in bend may be designed as wide as the width in straight lane provided the angle of deflection is less than 30 degree, should be widened for 60degree deflection based on the length of the largest ship using the channel and the angle of deflection.

• Journal of Navigation and Port Research
• /
• v.29 no.8 s.104
• /
• pp.693-699
• /
• 2005

To design ship channels is one of important factors for planning and developing a port. Bends in channels should be avoided if possible, but the channel should be widened, if channel bend is unavoidable, considering the swept path of a ship for safe passage. In this study, Variable Bumper Area(VBA) model is applied to determine the channel widths in bends. The result of this study shows that the width of the bend may be designed as nearly same size of that in straight channel in case that the angle of deflection is less than 30 degrees, and that of the bend with 60 degrees deflection should be widened based on the length of the largest ship using the channel and the angle of deflection.