• Title/Summary/Keyword: Excel program

Search Result 241, Processing Time 0.02 seconds

The Effects of Trunk Stabilization Training on a Stroke Patient's Postural Control and Activities of Daily Living: A Sing Subject Design (뇌졸중 환자의 체간안정화 훈련이 자세조절과 일상생활동작에 미치는 영향: 단일사례연구)

  • Nam, Ju-Hyeon;Shim, Gyeong-Bo;Gwak, Seong-Won
    • The Journal of Korean society of community based occupational therapy
    • /
    • v.4 no.1
    • /
    • pp.75-84
    • /
    • 2014
  • Objective : This study intends to suggest an effective clinical intervention method for stroke patients by applying a trunk stabilization training program to a single stroke patient and investigating and analyzing the effects of the program on postural control and activities of daily living. Methods : The subject of this study was a 75 year-old female stroke patient hospitalized in C Hospital located in Gyeongju, Gyeongsangbuk-do. As for the research design, A-B-A reversal design was used with a single subject design; and the research period was a total of five weeks from April 21, 2014 to May 23, 2014. As for the research process, a total of 15 sessions were carried out including three sessions of baseline(A), nine sessions of an intervention period(B), and three sessions of maintenance(A'); and the trunk stabilization program was applied during the intervention period. To evaluate the participant's postural control and activities of living life, the Postural Assessment Scale for Stroke(PASS) and the modified Barthel Index(MBI) were used. Visual analysis was used in which collected data were plotted on a graph, using Microsoft Office Excel 2013. Results : In the postural control test, the mean scores improved from 11.7 in the baseline phase to 14.8 in the intervention phase and 15.3 in the maintenance phase. In the evaluation of activities of daily living, the score improved from 66(medium dependence) during the baseline period to 80(low dependence) after intervention and at the maintenance phase. Conclusion : It was found that the trunk stabilization training program showed effects on the stroke patient's postural control or alignment, and furthermore a beneficial improvement in the patient's performing the activities of daily living, as well.

  • PDF

A Study of Integrating ASP Databases with Customer Databases (ASP 용의 데이터베이스와 고객 데이터베이스 연동에 관한 연구)

  • Kim, Ho-Yoon;Lee, Jae-Won
    • The KIPS Transactions:PartD
    • /
    • v.11D no.5
    • /
    • pp.1063-1072
    • /
    • 2004
  • In the ASP(Application Service Provider) business, applications using database sometimes require some data from clients' databases. These days such data are extracted from client database using manual database operations as an EXCEL file and the ASP, once receiving this file, transfers it into the application's database using manual database operations. This paper describes how to deal with data transmitting between the client database and ASP database on the web without using database manual operations for data extraction and insertion. We propose a framework which enables to transmit client data in a systematical way, to match different attribute names of each database for sharing same attribute values, and to avoid exposing information about the network path of client database to the ASP. This approach consists of two steps of data processing. The first is extracting data from client database as XML format by using a downloaded client program from ASP site, the second is uploading and storing the XML file into the ASP database. The implemented prototype system shows the suggested data integration paradigm is valid and ASP business needing integration of client database can be activated using it.

LRFD Design and Reliability Level Estimation of a Steel Closed-Box Girder Bridge (폐단면 강박스거더교의 LRFD 설계와 신뢰성수준 평가)

  • Huh, Jung-Won;Yun, Dong-Geon
    • Journal of the Computational Structural Engineering Institute of Korea
    • /
    • v.23 no.2
    • /
    • pp.217-225
    • /
    • 2010
  • Most of the steel bridges in Korea are being currently designed by the allowable stress design method that uses the conventional deterministic factors of safety. However the limit state design based on the concept of probability, statistics and reliability engineering is becoming very popular as a global standard deign method, leading the rational and economic bridge design. As part of the fundamental research to establish the load and resistance factor design(LRFD) of steel bridges considering domestic environmental conditions and regional characteristics, an experimental design is conducted by applying AASHTO-LRFD specification especially to a steel closed-box girder, which occupies relatively a large portion of steel bridges in Korea. Throughout the experimental design according to various sectional changes, some of the issues to be considered in the LRFD design of a composite steel closed-box girder bridge are examined. In this process, an Excel-based design verification program is developed for easy computation and prevention of errors. Quantitative reliability levels of the bridge sections designed by LRFD are also estimated using a reliability analysis method, and compared with the target reliability indexes applied in the LRFD design to verify the validity of the procedure and methodology used in this study.

Mathematical Model for Liner Shipping Alliance Problem (컨테이너 정기선 선사의 전략적 제휴를 위한 수리적 모형 연구)

  • Chung, Ki-ho
    • Management & Information Systems Review
    • /
    • v.33 no.5
    • /
    • pp.85-95
    • /
    • 2014
  • This paper suggested an efficient mathematical model for strategic alliance of liner shipping companies. Even though a few previous research papers proposed the mathematical models for container slot chartering and allocation under liner shipping, those models were nonlinear and very difficult to solve. So their models had limits to apply them to real world problems. On the other hand, the model suggested in this paper is easy to solve and apply to real world problems because it is a integer linear programming model. This paper tried to apply the model to the same example problem as used in existing research paper. Excel add-in program, Premium Solver Platform was used to solve the problem and the optimal allocation and slot chartering for containers were able to be found easily. The result also showed that the total container shipping cost for applying the strategic alliance model was reduced compared to non-strategic alliance model.

  • PDF

ANALYSIS OF THE TRANSPORTATION LOGISTICS FOR SPENT NUCLEAR FUEL IN KOREA

  • Lee, Hyo-Jik;Ko, Won-Il;Seo, Ki-Seok
    • Nuclear Engineering and Technology
    • /
    • v.42 no.5
    • /
    • pp.582-589
    • /
    • 2010
  • As a part of the back-end fuel cycle, transportation of spent nuclear fuel (SNF) from nuclear power plants (NPPs) to a fuel storage facility is very important in establishing a nuclear fuel cycle. In Korea, the accumulated amount of SNF in the NPP pools is troublesome since the temporary storage facilities at these NPP pools are expected to be full of SNF within ten years. Therefore, Korea cannot help but plan for the construction of an interim storage facility to solve this problem in the near future. Especially, a decision on several factors, such as where the interim storage facility should be located, how many casks a transport ship can carry at a time and how many casks are initially required, affect the configuration of the transportation system. In order to analyze the various possible candidate scenarios, we assumed four cases for the interim storage facility location, three cases for the load capacity that a transport ship can carry and two cases for the total amount of casks used for transportation. First, this study considered the currently accumulated amount of SNF in Korea, and the amount of SNF generated from NPPs until all NPPs are shut down. Then, how much SNF per year must be transported from the NPPs to an interim storage facility was calculated during an assumed transportation period. Second, 24 candidate transportation scenarios were constructed by a combination of the decision factors. To construct viable yearly transportation schedules for the selected 24 scenarios, we created a spreadsheet program named TranScenario, which was developed by using MS EXCEL. TranScenario can help schedulers input shipping routes and allocate transportation casks. Also, TranScenario provides information on the cask distribution in the NPPs and in the interim storage facility automatically, by displaying it in real time according to the shipping routes, cask types and cask numbers that the user generates. Once a yearly transportation schedule is established, TranScenario provides some statistical information, such as the voyage time, the availability of the interim storage facility, the number of transported casks sent from the NPPs, and the number of transported casks received at the interim storage facility. By using this information, users can verify and validate a yearly transportation schedule. In this way, the 24 candidate scenarios could be constructed easily. Finally, these 24 scenarios were compared in terms of their operation cost.

Cause Analysis and Development of Root Cause Analysis Map using Data of Chemical Laboratory Accidents (화학실험실 사고 Data를 이용한 근본원인분석 Map 개발 및 원인 분석)

  • Lee, Su-Kyung;Yoon, Yeo-Song;Eom, Seok Hwa
    • Journal of the Korean Institute of Gas
    • /
    • v.18 no.4
    • /
    • pp.86-94
    • /
    • 2014
  • To develop a Root Cause Analysis Map which determines the cause of the accident in chemical laboratory, The Root Cause Analysis(RCA) Map for the laboratory areas was sketched from Phase 1 of the accident element to Phase 3 of the accident element, based on the RCA Map which is applied in the petrochemical industry. On the basis of laboratory RCA Map which was classified by using such method. The root causes of the 211 accident cases in laboratories were classified from Phase 4 to Phase 5 by the Cause Factor Charting technique and The cause of the accident data were inputted to EXCEL program. After that, The causes of the accident data were sorted and classified by type and each step. So 'Approximate Primary RCA Map Draft' was written. In addition, it was reaffirmed whether the root causes of 211 accidents of laboratory were appropriate to 'Primary RCA Map Draft'. By complementing the cause which was expected to cause future accidents, the RCA Map for chemical laboratories was developed. Based on 'RCA Map' proposed in this study, the causes of accidents were analysed management systems 35%, monitoring 12.2%, Human Factor Eng. 15.1% and education training 12.1% by the size of the frequency from Phase 1 to Phase 5.

A Quantitative Risk Analysis of LPG Leaked During Cylinder Delivery (가스용기 운반 중 누출된 LPG의 정량적 위험 분석)

  • Kim B-J,;Park Ki-Chang;Lee Kuen-Won
    • Journal of the Korean Institute of Gas
    • /
    • v.7 no.2 s.19
    • /
    • pp.33-41
    • /
    • 2003
  • There exists high hazard when transporting LPG as well as using, storing, and producing. For small scale LPG consumer, retailers deliver LPG to customers via a truck loading many LPG cylinders. Suppose there occurred a accident during LPG cylinder transfer, this could result in serious damages to the life and properties in the near or neighbor of the accident spot. In this regard, we made a quantitative risk analysis to estimate the possible damages and the probability through the identification of accidents causes and the simulation of the possible scenario. In this study, we made the Excel & Visual Basic computer program to perform quantitative LPG accident analysis. The simulation showed the following results. In case of UVCE(Unconfined Vapor Cloud Explosion), the effect within l0m of the accident spot showed very severe structural damages and even the accident can break the window glasses of the area of 150 m apart from accident spot. In case of TNT corresponding probit analysis, after 10 minutes LPG leaking, $75\%$ window glasses of 40 m distance was expected to be broken. And $16\%$ frames of 20m distance, $10\%$ frames of 40m distance was expected to be collapsed.

  • PDF

Area Classification of Hazardous Gas Facility According to KGS GC101 Code (KGS GC101을 통한 가스시설 폭발위험장소의 설정)

  • Kim, Jeong Hwan;Lee, Min-Kyung;Kil, Seong-Hee;Kim, Young-Gyu;Ko, Young Kyu
    • Journal of the Korean Institute of Gas
    • /
    • v.23 no.4
    • /
    • pp.46-64
    • /
    • 2019
  • Technical practice code, KGS GC101 2018, for explosion hazard area selection and distance calculation of gas facility was enacted and implemented from July 12, 2018. This code includes whole contents of IEC60079-10-1 2015 (Explosive atmospheres Part 10-1: Classification of areas - Explosive gas atmospheres), and clarifies the interpretation of ambiguous standards or adds guidelines for standards. KGS GC101 is a method for classifying explosion hazard place types: (1) Determination of leak grade (2) Determination of leakage hole size (3) Determination of leakage flow (4) Determination of dilution class (5) Determination of ventilation effectiveness, finally (6) Determination of danger place (7) Explosion The range of dangerous places can be estimated. In order to easily calculate this process, the program (KGS-HAC v1.14, C-2018-020632) composed by Visual Basic for Application (Excel) language was produced by Korea Gas Safety Corporation. We will discuss how to use codes and programs to select and set up explosion hazard zones for field users.

The Study about the Job Satisfaction and Independent Establishment of Physical Therapy of Working Physical Therapist in Gyeongnam Region (경남지역 물리치료사의 직무만족도 및 자립개설에 대한 조사연구)

  • Lee, Jun-cheol
    • The Journal of the Convergence on Culture Technology
    • /
    • v.4 no.4
    • /
    • pp.123-133
    • /
    • 2018
  • This study aimed to suggest basic data required to improve the awareness of physical therapy and examine physical therapists' awareness of the independent establishment of physical therapy clinics. To do so, 175 physical therapists in Gyeongnam areas were surveyed. Their general characteristics were statistically analyzed using SPSS 10.0, and their current workplace, working conditions and job satisfaction were analyzed using chi square distributions. The awareness of independent establishment was analyzed using the Excel program. The statistical significance (a) in this study was set at 0.05. Their interest in physical therapy was surveyed by gender, and 52.2% of males showed interest, higher than that of females. The satisfaction level of those who work in general hospitals with self-development was 32.8%, higher than that of those who work in clinics. To the question about independent establishment, 83.4% agreed to independent establishment, and 57.5% answered that the first thing to do before independent establishment is acquiring professional theoretical knowledge and clinical treatment skills. In terms of the areas of establishment, 45.2% answered physical therapy for the musculoskeletal system, and 39.7% answered that the awareness of doctors is the biggest obstacle to independent establishment. It will be necessary to ensure physical therapists acquire professional theoretical knowledge and clinical treatment skills and to improve awareness between physical therapists and doctors. In addition, it is considered that departments related to physical therapy need to be unified as a four-year course, and the independent establishment of physical therapy clinics is required to be legalized.

A Study on the Utilization of Sports Cooperatives as a Model for Creating Jobs for the Elderly (노인 일자리 창출 모델로서 스포츠협동조합의 활용방안)

  • Jung-Dong Kim;Sung-Tae Park
    • Journal of Industrial Convergence
    • /
    • v.22 no.7
    • /
    • pp.31-41
    • /
    • 2024
  • The purpose of this study is to analyze how to utilize sports cooperatives that can be a pleasure to work and add living expenses through sports as a model for creating jobs for the elderly. To this end, after reviewing the literature and expert survey using Delphi techiques for 9 sports experts and 4 cooperative experts, the following conclusions were drawn analyzing with Excel, SPSS V28, and AHP analysis Dress V 1.7 program First, as a model for creating jobs for the elderly, the economic factors, social factors, institutional factors, and middle categories 10 factors and sub-categories 36 factors were derived from the major categories for the utilization of sports cooperatives. Second, through senior sports cooperatives, economic activities generate income, and volunteer and talent-sharing activities provide opportunities for physical and mental health and social participation. And, as corporations, they can expand profit-making projects through government and local government collaboration and partnership projects, contributing to solving issues related to the elderly. In the future, follow-up studies are needed to explore the needs, satisfaction, problems, improvement plans, utilization plans, and development directions of sports cooperatives in the sports field.