• 한국경영과학회:학술대회논문집
• /
• 한국경영과학회 2008년도 추계학술대회 및 정기총회
• /
• pp.304-307
• /
• 2008

A spreadsheet-based linear program (LP) software, so called, the LP-Tableau is developed to aid users to learn the simplex algorithm systematically and to understand the various conditions that make the problem unusual and, in some instances, impossible to solve. The LP-Tableau has several good features over other spreadsheet-based LP software programs available. First, the data input in the LP-Tableau is very convenient especially when small-sized problems are analyzed. Further, the LP-Tableau allows for two solution methods (i.e., Big-M and Two-Phase) and displays the whole iterations in tableau format. Thus users can easily understand the principle of the algorithm step by step. Finally, the LP-Tableau visually displays various conditions of the optimal solutions that might occur in solving the LP problems.

• 한국IT서비스학회지
• /
• 제17권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 Korean Data and Information Science Society
• /
• 제21권3호
• /
• pp.481-491
• /
• 2010

수강하는 학생 개개인이 응답한 여러 개의 파일을 한 파일에 모은 다음 이 자료를 가지고 난수생성, 표본추출 과정과 방법, 모수와 통계량을 비교하는 프로그램을 엑셀 매크로로 작성하였다. 모집단에서 일부분의 표본을 추출하여 모수와 통계량의 차이를 비교하는 등 자료의 생성, 분석, 결과의 해석을 빠른 시간내에 해결하여 학생들이 흥미를 가지고 수업에 참여하도록 유도한다. 엑셀에서는 난수발생시 중복된 값이 발생하는데 본 연구에서는 비주얼베이직 매크로로 비복원추출 프로그램을 작성하여 활용한다.

• 한국산림과학회지
• /
• 제99권2호
• /
• pp.197-203
• /
• 2010

The data of average temperature, average relative humidity, precipitation and average wind speed were collected from 674 meteorological stations in China. A specific procedure that processes original data into a new data format needed in forest fire danger rating forecast system of China was introduced systematically, and the feasibility of this method was validated in this paper. In addition, a set of meteorological data processing software was constructed by the secondary development of GIS in order to realize automation of processing data for the system. Results showed that the approach preformed well in handling temperature, average relative humidity and average wind speed, and the processing effect of precipitation was acceptable. Moreover, the automated procedure could be achieved by GIS and the working efficiency was about 3 times as much as that of manual handling. The informationization level of processing meteorological data was greatly enhanced.

• 한국공작기계학회논문집
• /
• 제17권1호
• /
• pp.150-157
• /
• 2008

Bellows are commonly used in piping systems to absorb expansion and contraction in order to reduce stress. Unlike most piping components, bellows consist of a thin-walled shell of revolution with a corrugated meridian, in order to provide the flexibility needed to absorb mechanical movements. It is a composite shell structure consisting of at least one toroidal shell, an annular plate or conical shell. It is difficult to analyze the behavior of bellows because of its complex geometry. Simplified formulas for variable mechanical behaviors of bellows are provided by a standard called EJMA. An automatic design software for bellows is programming by using VBA(Visual Basic for Application) based on EJMA. Bellows engineers can effectively make a decision for bellows geometries because this software provides graphically design results in its post-processor. Bellows design software is expected to give quite a good guidance to practical design. The characteristics of bellows are also investigated through the automatic design process in bellows design software.

• 한국건설관리학회:학술대회논문집
• /
• 한국건설관리학회 2006년도 정기학술발표대회 논문집
• /
• pp.105-110
• /
• 2006

건설공사에서 발생하는 리스크는 시공단계에 많이 발생하므로 공정관리와 통합하여 관리할 수 있다면 효율적일 것이다. 본 연구에서는 공정관리 프로그램을 이용하여 공정리스크를 통합관리하는 방법을 제안하고 있다. 제안된 방법은 사용자 프로그래밍(Visual Basic Application)이 가능한 Microsoft Project에서 구현되었으며, 공사관리자가 공정표를 작성하고 일정관리를 수행하는 과정에서 리스크를 예측하는데 도움을 줄 수 있을 것이다.

• 한국연소학회:학술대회논문집
• /
• 한국연소학회 2006년도 제32회 KOSCO SYMPOSIUM 논문집
• /
• pp.167-171
• /
• 2006

The previous models for thermal behavior in the melting furnace were deterministic, composed of such a form that if the initial input conditions are determined, the results would have been come out by using the basic heat equilibrium equations. But making the experiment by trusting the analysis results, the melted slag is fortuitously set often, because temperature variation of the melted slag in the reaction process is not point function but path function. So in this study, a transient model was developed and verified by comparing with the experimental results.

• 소성∙가공
• /
• 제16권3호
• /
• pp.163-171
• /
• 2007

Due to the complicated character of the hemming process for automobile panels, it is very difficult to setup a consistent and reliable die design guide rule that require subtle decision of experienced experts and multiple trials during hemming die design and making. In this paper an automatic die design system of hemming units is pursued by presenting some algorithms, in which geometric data and constraints of the hemming units were converted to formula. The geometries and kinematics of all part for two kinds of hemming units, 2-link type and 4-link type were analysed kinematically to build the design algorithm. The algorithms were verified by automatic drawing used AutoCAD VBA program in example for the hemming unit design of a bonnet.

• 한국시뮬레이션학회논문지
• /
• 제11권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.

• 한국경영과학회:학술대회논문집
• /
• 대한산업공학회/한국경영과학회 2002년도 춘계공동학술대회
• /
• pp.221-224
• /
• 2002

포항제철소에는 13개의 발전기가 있어 제철소에서 필요로 하는 전력을 자체적으로 945MWH 규모로 공급하고 있다. 발전소에서 사용되는 에너지원은 제철공정에서 부수적으로 발생하는 부생가스(BFG, COG, LDG, CFG)와 외부에서 구매하는 중유, LNG가 있다. 안정적인 전력공급과 비용절감을 위한 발전기 가동계획을 수립하기 위해서는, 조업상황에 따라 변동되는 전력소요량 및 부생가스 발생량을 예측하여 발전기별로 사용될 연료량을 배분하고, 발전기별 효율을 반영한 발전량을 결정하게 된다 이러만 발전기 가동계획 수립을 수작업에 의존하고 있어, 수시로 변화하는 상황에 신속한 대처가 곤란하고, 모든 요소를 고려하기가 어려워 에너지비용을 절감할 수 있는 기회손실의 우려가 있었다. 본 연구에서는 LP 및 NLP를 적응하여 발전기별 연료배분 및 발전량을 결정하는 과정을 자동적으로 수행하는 발전기 가동계획수립 Model을 개발하였다. Data 입·출력용으로 Excel, LP Package는 What's Best, Programming Language는 VBA(Visual Basic for Application)를 활용하였다.