• Title/Summary/Keyword: MS Excel

Search Result 101, Processing Time 0.03 seconds

Knowledge Management Initiative: A Case Study of the National Library of Bangladesh

  • Sultana, Nazmin;Mostofa, SK Mamun
    • Journal of Information Science Theory and Practice
    • /
    • v.6 no.1
    • /
    • pp.6-17
    • /
    • 2018
  • This paper confers about the implementation of Knowledge Management (KM) in the National Library of Bangladesh (NLB). The main aim of this study was to investigate how the NLB goes about creating, implementing, disseminating, and applying knowledge within the organization. The other objectives of this paper were to identify the current status of KM in NLB and the understanding of different facets of KM by the staff of the National Library. The paper revealed that the situation of KM in NLB is not satisfactory. The paper also described the fact that the working environment supports the implementation but there needs to be some changes in the policies. Finally the research disclosed that NLB is a great place for implementing KM and has a large amount of possibilities for the adoption of KM. This qualitative research used the questionnaire as the main instrument for data collection. Finally, data has been processed and analyzed using SPSS and MS Excel.

Development of Stem Analysis Program(Stemwin1.0) for Windows (Windows용 수간석해(樹幹析解) 프로그램(Stemwin1.0)의 개발(開發))

  • Lee, Joon-Hak;Lee, Woo-Kyun;Seo, Jeong-Ho
    • Journal of Korean Society of Forest Science
    • /
    • v.90 no.3
    • /
    • pp.331-337
    • /
    • 2001
  • This study was performed to develope stem analysis program(Stemwin1.0) which can be used in PC with MS-Windows operating system. Stemwin1.0 uses width of annual tree ring measured with 1/100mm unit, and calculate increments of several growth factors such as DBH, height and volume with various methods. Mean DBH can be calculated by arithmetic and quadratic mean methods. Height can be estimated by parallel line, line extending and height curve methods. Volume can be estimated by Huber, Smalian, and Spline functions. Not only Total growth, Mean Annual Increment(MAI) and Current Annual Increment(CAI) of growth factors, but also merchantable volume and height, form factor, growth rate, and merchantable volume rate are automatically calculated. Stemwin1.0 can also output accurate stem taper curve with various scale, and prepare stem taper data(diameter at different disk heights) for statistical analysis for deriving stem taper model. Stemwin1.0 can export output data and graph to Excel for more compatible use of it.

  • PDF

A Study on the Optimization Problem for Offshore Oil Production and Transportation (해양 석유 생산 및 수송 최적화 문제에 관한 연구)

  • Kim, Chang-Soo;Kim, Si-Hwa
    • Journal of Navigation and Port Research
    • /
    • v.39 no.4
    • /
    • pp.353-360
    • /
    • 2015
  • The offshore oil production requires a huge amount of cost and time accompanied by multiple variables due to the peculiar nature of 'offshore'. And every process concerned is controlled by elaborate series of plans for reducing loss of lives, environment and property. This paper treats an optimization problem for offshore oil production and transportation. We present an offshore production and transportation network to define scope of the problem and construct a mixed integer linear programming model to tackle it. To demonstrate the validity of the optimization model presented, some computational experiments based on hypothetical offshore oil fields and demand markets are carried out by using MS Office Excel solver. The downstream of the offshore production and transportation network ends up with the maritime transportation problem distributing the crude oil produced from offshore fields to demand markets. We used MoDiSS(Model-based DSS in Ship Scheduling) which was built to resolve this maritime transportation problem. The paper concludes with the remark that the results of the study might be meaningfully applicable to the real world problems of offshore oil production and transportation.

Mathematical Simulation of the Temperature Dependence of Time Temperature Integrator (TTI) and Meat Qualities (육류의 품질과 Time Temperature Integrator(TTI) 온도의존성에 대한 수학적 Simulation)

  • Park, Han-Jo;Shim, Soo-Dong;Min, Sang-Gi;Lee, Seung-Ju
    • Food Science of Animal Resources
    • /
    • v.29 no.3
    • /
    • pp.349-355
    • /
    • 2009
  • The temperature dependence of time temperature integrator (TTI) was investigated in terms of the Arrhenius activation energy (Ea) to determine TTI requirements to accurately predict meat quality during storage. Mathematical simulation was conducted using a numerical analysis. First, using Euler's method and MS Excel VBA, the TTI color change was kinetically modeled and numerically calculated under several storage conditions. From the TTI color variable profiles calculated from the storage time-temperature profiles, $T_{eff}$, which is a constant temperature representing the whole temperature profiles, was calculated. Upon predicting Pseudomonas spp. concentrations (one of the meat qualities) from $T_{eff}$, it was found that if $Ea_{microbial\;spoilage}=Ea_{TTI}$ be true, then Pseudomonas concentrations were calculated to be constant with the same TTI color values, regardless of time-temperature profiles, whereas if $Ea_{microbial\;spoilage}{\neq}Ea_{TTI}$ then Pseudomonas concentrations varied even with the same TTI color values. This indicates that each TTI color value represents its own fixed degree of meat quality, only if $Ea_{meat\;qualities}=Ea_{TTI}$.

Nationwide Survey of the Database System on Gastric Cancer Patients (전국 위암 환자 데이터 관리에 관한 설문조사 결과)

  • Yang Han-Kwang
    • Journal of Gastric Cancer
    • /
    • v.4 no.1
    • /
    • pp.15-26
    • /
    • 2004
  • This nationwide survey was conducted to evaluate the current status of the database system on gastric cancer patients in Korea. The Information Committee of Korean Gastric Cancer Association (KGCA) sent questionnaires about the database management to all 402 KGCA members in 110 institutes. In addition, we asked them to send the gastric cancer sheet and the pathologic report of gastric cancer used in their institutes. Response rates were $18.9\%$ (76/402) for individuals and $51.8\%$ (57/110) for institutes, respectively. Most of the university hospitals responded to the questionnaire (response rate of university hospital: $74.6\%$, 44/59). A regular conference of gastric cancer and a digitalization of the database on gastric cancer patients were performed in 29 ($50.9\%$) and 43 ($75.4\%$) out of 57 institutes, respectively. MS excel was most commonly used for the digitalization of the database, followed by MS access and SPSS. A regularly formed gastric cancer sheet and pathologic report were used in 38 ($66.7\%$) and 49 ($86.0\%$) institutes, respectively. Hospital computerization, such as an Order Communicating System, an Electric Medical Record, and a Picture Archiving/Communicating System had been set up previously or would be set up in the near future in most institutes. In 25 gastric cancer sheets collected, the mean number of total items was 72.9 ($15\∼177$). Identification datafor the patients, surgical data, and pathologic data were included on most of the sheets, but preoperative status, preoperative diagnostic data, and postoperative hospital course were not.

  • PDF

A Study on the Computer Application and Learning Model in the CAQC Education (CAQC교육에 있어서 컴퓨터 활용과 학습모델에 관한 연구 - 히스토그램을 중심으로 한 학습모델 -)

  • Choi Myung-Ho
    • Journal of Engineering Education Research
    • /
    • v.3 no.2
    • /
    • pp.3-13
    • /
    • 2000
  • The paper has analyzed and summarized about the theoretical problem occurred in the CAQC, and has developed the learning model focused on the histogram as a case study. The range of study is to systematize the basic method of histogram generally used, and to make step by step procedures under the interactive relation with the improvement of the theory that must be added in case of the calculation by the aided of MS-Excel software. A histogram is the theory to understand the population distribution from which samples are extracted, so alternative methods are presented to estimate the population shape through an experiment and a practice. In order to enlarge the application area of the histogram in the factory, the theory of normal test, the criteria of process capability index and the probability calculation of PPM are added to the histogram. The learning model of CAQC education is proposed that is consistent with the target of histogram to control and search the cause of item defectives fast and correctly.

  • PDF

A Technique for Fast Sampling Measurement of Digital Frequency Relay (디지털주파수계전기의 고속 샘플링추정기법)

  • Nam, S.B.;Lee, H.G.;Ma, S.B.;Kim, J.S.
    • Proceedings of the KIEE Conference
    • /
    • 2006.10b
    • /
    • pp.185-190
    • /
    • 2006
  • Frequency and phasor are the most important quantities in power system operation because they can reflect the whole power system situation. Frequency reflects the dynamic energy balance between load and generating power, while operators use phasor to constitute the state of system and, moreover, phasor based line relays are currently used in most power systems. So frequency and phasor are regarded as indices for the operating power systems in practice. The proposed technique is suitable for estimation near-nominal, nomina), and off-nominal frequencies. It is useful in designing microprocessor-based relays and meters that need to measure power system frequency. Performance test results, using signals from EMTP source and Excel program, indicate that the proposed technique can provide accurate estimates within 16ms. Maximum estimation errors observed during testing are of the order of 0.006Hz for nominal, near-nominal, and off-nominal frequencies. The proposed technique provides accurate estimates in presence of noise and harmonics and in case ground fault. The rate change of the phase angle is used for estimation. To confirm the validity of the proposed algorithm, the simulation studies carried out on a typical 154[KV] double T/L system by using EMTP software. Some test results are presented in the paper.

  • PDF

Composite Document Object Retrieval and Searching System-[IN2] DOR (복합문서 개체 검색 시스템- [IN2] DOR)

  • Ahn, Tae-Sung;Yim, Joong-Su;Kim, Myung-Hoon;Ahn, Woo-Ram;Lee, Kyung-Il
    • Annual Conference on Human and Language Technology
    • /
    • 2003.10d
    • /
    • pp.113-118
    • /
    • 2003
  • 기존 문서 검색 시스템의 경우 단순히 문서 내에서 텍스트를 추출한 후 그 텍스트를 색인, 검색하는 형태를 가지고 있었다. 본 논문에서는 MS Word, Excel, HWP 등 다양한 형태의 문서에서 텍스트, 표, 이미지, 차트, 동영상 등의 문서 개체를 분석, 색인하고 이를 검색하는 시스템의 개발 방법을 제외하였다. 제안된 시스템은 문서의 내부 자료 구조를 CDML(Composite Document Markup Language)로 변환하고, 이를 색인, 저장함으로 기존의 전문 검색 시스템의 한계를 효과적으로 극복했으며, 문서 내의 검색 대상 개체로 자동 이동하고 하일라이팅 시키는 기술을 구현함으로 사용자 편익성을 높였다. 개발된 시스템의 성능을 평가한 결과, 다양한 문서 형식에 대해 평균 97% 이상의 CDML변환 성공률과 개체 검색 성공률을 보였으며, 이진 파일에서 직접 개체를 추출함으로 매우 높은 분석 및 색인 속도가 달성되었음을 확인할 수 있었다. 본 논문에서 소개된 새로운 패러다임의 문서 검색 솔루션을 통해 다양한 기술적 상업적 파급 효과가 기대되고 있다.

  • PDF

An Applied Technique of Linear Programming Using Multi-Softwares (다종 S/W 적용에 의한 선형계획법 연구)

  • 한계섭
    • The Journal of Information Systems
    • /
    • v.5
    • /
    • pp.21-41
    • /
    • 1996
  • Linear programming has become an important tool in decision-making of modern business management. This remarkable growth can be traced to the pioneering efforts of many individuals and research organizations. The popular using of personal computers make it very easy to process those complicated linear programming models. Furthermore advanced linear programming software packages assist us to solve L.P. models without any difficult process. Even though the advanced L.P. professional packages, the needs of more detailed deterministic elements for business decisions have forced us to apply dynamic approaches for more resonable solutions. For the purpose of these problems applying to the "Mathematica" packages which is composed of mathematic tools, the simplex processes show us the flexible and dynamic decision elements included to any other professional linear programming tools. Especially we need proper dynamic variables to analyze the shadow prices step by step. And applying SAS(Statistical Analysis System) packages to the L.P. problems, it is also one of the best way to get good solution. On the way trying to the other L.P. packages which are prepared for Spreadsheets i.e., MS-Excel, Lotus-123, Quatro etc. can be applied to linear programming models. But they are not so much useful for the problems. Calculating simplex tableau is an important method to interpret L.P. format for the optimal solution. In this paper we find out that the more detailed and efficient techniques to interpret useful software of mathematica and SAS for business decision making of linear programming. So it needs to apply more dynamic technique of using of Mathematica and SAS multiple software to get more efficient deterministic factors for the sophiscated L.P. solutions.

  • PDF

Development of a Web-based Information System for Rural Settlement Environment Diagnosis (웹기반의 농촌정주환경진단 정보시스템 개발)

  • Bae, Seung-Jong;Kim, Dae-Sik;Kim, Tae-Gon
    • Journal of Korean Society of Rural Planning
    • /
    • v.16 no.3
    • /
    • pp.117-129
    • /
    • 2010
  • The purpose of this paper is to develop a web-based information system for rural settlement environment diagnosis which is useful to apply the village based evaluation for new rural development projects. To achieve this purpose, this study performed : 1) analyzing the business process in the field of rural settlement environment diagnosis, 2) designing the data flow diagram and the database based on settlement environment diagnostic indices(SEDI), and 3) developing the system using APM (Apache, PHP, and MySQL) of web-system development environment. The developed system was applied to the study rural villages for testing of efficient and logical working. Users of the system, such as, researchers, decision makers, and rural residents, can input directly the village data to diagnose through a file format of Excel in MS Office. Futhermore, they can analyze the visual results with graphic and graph types, simultaneously. From the results of this study, it showed that the developed system enables decision-makers not only to assist the planning process of the rural village development project, but also to improve the level of information technology in the research and planning field concerning with rural development.