• Korean Management Science Review
• /
• v.11 no.3
• /
• pp.47-54
• /
• 1994

본 연구에서는 선형계획법 프로그램을 실무용과 교육용 모두 사용할 수 있는 사용자 편의성이 강조된 선형계획법 통합환경 프로그램인 LIPED를 개발하였다. LIPED는 첫째, 풀다운(Pull Down) 메뉴 방식의 선형계획법 통합환경, 둘째, 선형계획법의 교육을 위해 여러가지 선형계획법해법 들을 통합하여 구축하였다. 셋째, 실무용으로 사용할 수 있는 안정적이고 효율적인 선형계획법 프로그램을 제공한다. 마지막으로 실험용 선형계획법 문제를 생성할 수 있는 기능과 다양한 선형계획법 입력 방식과 각 방식이 호환되도록 구축하였다. 그리고 추후연구로 교육용 LP에 Affine Scaling Algorithm, Barrier Algorithm을 추가하고, UNIX System 또는 Windows 환경하에서 통합 프로그램의 개발 및 수식 형태의 입력방식과 스프레드쉬트(Spreadsheet) 형식의 입력방식 등의 다양한 입력방식의 지원과 전문가의 지식을 연결하여 해법 선택 및 모형 구축 등을 지원할 수 있는 지능형 선형계획법 지원시스템을 구축하고 있다.

• Journal of the Korean Operations Research and Management Science Society
• /
• v.25 no.3
• /
• pp.137-154
• /
• 2000

This paper suggests a balanced scorecard (BSC) framework for measuring and evaluating the performance of knowledge workers in professional service firms(PSFs) which are typical knowldege-based organizations. As a strategic learning system, the balanced scorecard allows business leaders to drive and modify their business strategies based on the balanced measurement of key performance indicators(KPIs), which are basically divided into four domains such as financial achievement, customer orientation, internal business process, and innovation and learning. Conducting a focused case study on performance evaluation of knowledge workers from a balanced viewpoint, we could evaluate their competency and potential in more comprehensive manner. We also employ the analytic hierarchy process (AHP) approach for derive relative weights of key performance indicators and link it to a spreadsheet model for rating the individual performance of knowledge workers in a systematic way.

• Advances in environmental research
• /
• v.7 no.1
• /
• pp.29-37
• /
• 2018

A simple mathematical model for predicting fixed bed adsorption dynamics is described. The model is characterized by a linear adsorption isotherm and a linear driving force expression for mass transfer. Its analytic solution can be approximated with an algebraic equation in closed form which is easily evaluated by spreadsheet computation. To demonstrate one application of the fixed bed model, a previously published adsorption system is used as a case study in this work. The adsorption system examined here describes chromium breakthrough in a fixed bed adsorber packed with imidazole functionalized adsorbent particles and is characterized by a nonlinear adsorption isotherm. However, the equilibrium behavior of the fixed bed adsorber is in essence governed by a linear adsorption isotherm due to the use of a low influent chromium concentration. It is shown that chromium breakthrough is predicted reasonably well by the fixed bed model. The model's parameters can be easily extracted from independent batch experiments. The proposed modeling approach is very simple and rapid, and only Excel is used for computation.

• Journal of Construction Engineering and Project Management
• /
• v.7 no.1
• /
• pp.30-36
• /
• 2017

Most local agencies such as counties and small cities continuously express difficulties in making technically and financially defensible decisions on their pavement infrastructure maintenance and rehabilitation. Unlike pavement systems managed by state highway agencies, the total lane-miles of many local pavements are significantly short and they are managed by a limited number of staff who typically have multiple responsibilities. Most local agencies also do not have historical pavement performance data and the lack of a systematic decision making framework exacerbates the problem. A structured framework and an easily accessible decision support tool that reflects their local requirements, practices and operational conditions would greatly assist them in making consistent and defensible decisions. This study fills this gap by developing a systematic pavement treatment selection framework and a spreadsheet based tool for local agencies. It is expected that the proposed framework will significantly help local agencies to improve their pavement asset management practices at the project level.

• Journal of Korean Society of Occupational and Environmental Hygiene
• /
• v.10 no.2
• /
• pp.78-97
• /
• 2000

Designing the industrial ventilation system is the complex and time-consuming job. It could generate some errors in the design calculations if one uses the hand-calculator or the spreadsheet program. To overcome these difficulties, VSDS(Ventilation System Design Software) had been developed a few years ago. But, it had the difficulty in designing a complex system having many branches because the user can not see the layout of the system on the screen. Another difficulty is that VSDS had been based on the assumption of the standard air condition. VSDS has thus been improved to overcome the shortcomings of the old version of VSDS.

• Genomics & Informatics
• /
• v.11 no.1
• /
• pp.55-57
• /
• 2013

Growing numbers of studies employ cell line-based systematic short interfering RNA (siRNA) screens to study gene functions and to identify drug targets. As multiple sources of variations that are unique to siRNA screens exist, there is a growing demand for a computational tool that generates normalized values and standardized scores. However, only a few tools have been available so far with limited usability. Here, we present siMacro, a fast and easy-to-use Microsoft Office Excel-based tool with a graphic user interface, designed to process single-condition or two-condition synthetic screen datasets. siMacro normalizes position and batch effects, censors outlier samples, and calculates Z-scores and robust Z-scores, with a spreadsheet output of >120,000 samples in under 1 minute.

• Asia pacific journal of information systems
• /
• v.15 no.2
• /
• pp.97-120
• /
• 2005

As information systems are introduced in organizations, user attitudes toward IS are crucial factors for the success of such systems. Hence, understanding what affects user attitudes should be a major concern in MIS research. The purpose of this study is to improve the understanding of social influence on IS adoption. Social influence construct is stretched to include four items: subject norm, image, visibility, and voluntariness. Also, this paper examines the roles of two moderators regarding social influence: user characteristics and IT maturity. We could find that 1) social influence has a significant impact on perceived usefulness(PU), perceived ease of use(PEU), and intention, 2) the social influence on PU is more noticeable for knowledge worker than for undergraduate student, and 3) social influence on knowledge worker's PU is stronger for emerging IT(e.g., wireless internet services) than for mature IT(e.g., spreadsheet software).

• Proceedings of the Korean Nuclear Society Conference
• /
• 1996.05b
• /
• pp.271-276
• /
• 1996

Coolant flow distribution to the assemblies and core coolant/component temperatures should be determined in LMR core steady state thermal-hydraulic performance analysis. Sodium flow is distributed to core assemblies with the overall goal of equalizing the peak cladding midwall temperatures for the peak temperature pin of each pin bundle, thus pin cladding damage accrual and pin reliability. The flow orificing analysis for conceptual design will be performed with Excel spreadsheet program ORFCE which was set up and tested, using the calibration factors based on available analyses data. For the verification of this program, flow orificing calculation for the MDP 840MWth core was performed. The calculational results are satisfactory compared to those of CRIEPI calculation.

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

• IE interfaces
• /
• v.4 no.2
• /
• pp.53-66
• /
• 1991

For the strategic management of the small and/or mid sized clinics, the introduction of the clinic information system is necessary. Currently there are not many information systems for the clinics, yet. In this study, we have developed a clinic information system (CLINSYS) as a guiding prototype and suggested the development directions of the total integrated clinic decision support system. For the better user interface and easy communication. the object-oriented language Macintosh Hyper-Card and Excel are used as the developing tools. And as a part of the integrated decision system, an expert system to consult about the urine test and the blood test interpretation has been developed using the Macintosh spreadsheet Excel.