• 제목/요약/키워드: Excel program

검색결과 241건 처리시간 0.024초

간호 대상자별 다빈도 간호진단, 간호중재, 간호결과 및 연계 체계조사 (A Study on Nursing Diagnoses, Interventions, Outcomes Frequently Used and Linkage to NANDA-NOC-NIC in Major Nursing Departments)

  • 김종경
    • 간호행정학회지
    • /
    • 제16권2호
    • /
    • pp.121-142
    • /
    • 2010
  • Purpose: The purpose of this study was to identify NANDA, NIC, and NOC frequently used and their linkages in major nursing departments for development of the nursing process and nursing management system. Methods: This study was a descriptive study. Data were collected from 123 nurses who worked in medical, surgical, pediatric, gynecologic, and psychiatric department. The questionnaire was based on the NANDA, NOC, NIC, and NANDA-NOC-NIC linkage system. This research was analyzed by an EXCEL program and SPSS $Pc^{+}15.0$. Results: Nursing diagnoses frequently used were 'anxiety', 'disturbed sleep pattern', 'activity intolerance', 'social isolation', 'nausea', 'ineffective airway clearance', 'chronic pain', nursing outcomes frequently used were 'thermoregulation', 'bowel elimination', 'pain control', 'vital sign status', 'pain level', and nursing interventions frequently used were 'nausea management', 'airway suctioning', 'bowel elimination management', 'diarrhea management', 'medication management'. NANDA-NOC-NIC linkages in major nursing departments were recognized, and these results were similar to the results of other researches. Conclusion: The results of this study will be provided as a guideline to apply to the nursing process and development of the nursing process system with the NANDA-NOC-NIC linkage in major nursing department.

각막지형도(topography) 각막곡률로부터 토릭 각막형상의 수식화 (Mathematical Expression of the Toric Cornea using Corneal Topography Measurements)

  • 김대수
    • 한국안광학회지
    • /
    • 제16권4호
    • /
    • pp.439-444
    • /
    • 2011
  • 목적: 수평축과 수직축 비가 다른 토릭각막의 형상을 수학적인 함수로 표현하여 각막곡률 분포의 분석과 콘택트 렌즈 착용에 필요한 눈물두께 계산에 적용한다. 방법: 각막을 타원함수로 가정하고 함수로부터 유도된 곡률반경식과 각막 토포그라피 측정 곡률반경을 일치시켜 타원함수의 변수를 결정하였다. 계산은 작성한 엑셀프로그램을 사용하였다. 결과: 중심이 각막 정점에 위치하지 않는 리본(나비)형 토포그라피 이미지를 가지는 직난시 각막의 수평, 수직 각 축에 대해 각막의 형상을 수치적으로 알 수 있는 타원함수를 구하였다. 결론: 각막에 대해 고도의 수차 등이 요구되지 않는 응용, 예를 들면 콘택트렌즈 피팅, 난시교정 등에 각막 형상을 단순한 타원함수로 표현하는 것이 편리할 것으로 판단된다.

장외파생상품거래를 위한 유연한 의사결정지원시스템 아키텍처 설계에 관한 연구: A은행 사례 (Design of Flexible DSS Architecture for OTC Derivatives Trading: 'A' Bank Case)

  • 이근우;양근우
    • 한국정보시스템학회지:정보시스템연구
    • /
    • 제20권1호
    • /
    • pp.107-126
    • /
    • 2011
  • Model-based decision support system (DSS) has acted as a crucial role in strengthening the business competitiveness by providing a way of modeling and solving real-world decision problems in a quantitative and scientific manner. It is even more important for trading OTC derivatives, which requires extensive financial-engineering expertise while actively reacting to the continuously changing financial market. This paper proposes a flexible model-based DSS architecture that can support user-friendly interface for executing and analyzing the models and can adapt to the changes of financial market seamlessly. For user-friendliness, we implement the user-interfaces (UIs) using Microsoft Excel, a very widely used spreadsheet program for its great generality and extensibility. Users can utilize the analysis results of DSS or reprocess them for their special needs through the UIs in the form of familiar spreadsheets easily. For adaptiveness to the markets, the proposed architecture is constructed based on the object-oriented concepts, which enables such changes as release of a new financial product can be updated into the system without any delay at the lowest cost. We investigate the practical benefits and limitations of the proposed architecture by a case study on the construction of Model-based Trading Support System (MTSS), performed by a commercial bank in Korea.

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

  • 남시복;이훈구;마석범;김진수
    • 대한전기학회:학술대회논문집
    • /
    • 대한전기학회 2006년도 학술대회 논문집 전문대학교육위원
    • /
    • 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

하천유사량 특성분석을 위한 유사량산정시스템 개발 (Development of Sediment Discharge Computation System for Characteristic Analysis of River Sediment Discharge)

  • 이연길;고주연;이진원;정성원
    • 한국수자원학회:학술대회논문집
    • /
    • 한국수자원학회 2009년도 학술발표회 초록집
    • /
    • pp.723-727
    • /
    • 2009
  • 본 연구에서는 유사량 측정의 적절성과 산정결과에 대한 정확성을 도모하고자 총유사량과 하상토유사량을 일관적으로 계산하고, 분석 및 관리할 수 있는 유사량산정시스템(Sediment Discharge Computation System; SDCS)을 개발하였다. 유사량산정시스템(SDCS)은 Microsoft사의 Excel VBA(Visual Basic for Applications)로 개발되어져 실행 및 분석이 간단 용이하고, 또한 유사량 산정결과를 저장하고 관리할 수 있는 DBFPAD가 내재되어 있다. 본 시스템은 크게 총유사량과 하상토유사량 산정 모듈로 구성되어 있어 각각의 모듈에서 유량규모에 대응하는 유사량과 농도를 산정할 수 있다. 총유사량 산정 모듈은 대표적인 확산-이송형 모형이라 할 수 있는 Modified Einstein 공식을 토대로 하였으며, 하상토유사량 산정 모듈은 Einstein, Ackers & White, Engelund & Hansen, Yang의 유사량 공식을 근간으로 되었다. 본 시스템은 크게 총 5개의 모듈을 가지며, 총 20개의 부프로그램(Subroutine Program)과 23개의 사용자정의함수 구문으로 개발되었다. 또한 단면의 특성변화 분석모듈과 DBFPAD 저장 및 관리모듈이 포함되어 있어 산정된 결과를 용이하게 비교 분석할 수 있고, 기존 자료와의 비교도 쉽게 수행할 수 있도록 구성하였다.

  • PDF

국내 종합병원 진단검사의학과의 면적산정 방법에 대한 연구 - 검사실 사례조사를 중심으로 (A Study on the Space Area Guideline of Clinical Laboratory in Korea - Focused on Laboratory Case Studies)

  • 김영애;송상훈
    • 의료ㆍ복지 건축 : 한국의료복지건축학회 논문집
    • /
    • 제26권2호
    • /
    • pp.39-47
    • /
    • 2020
  • Purpose: Clinical laboratory of hospital has been demanded to extension or relocation regarding with the test number increase and analyzer development. Space area criteria per test numbers, lab functions, hospital bed and lab staffs are needed for draft space programing. So, the purpose of this study is to provide the space area guideline of clinical laboratory for space calculation in planning and design the spatial environment. Methods: Literature review has been used in checking the standards and guidelines. And questionnaire surveys to laboratory supervisors in hospitals have been conducted for the data collection. 60 answers have been analysed statistically by MS Excel program. Results: The result of this study can be summarized into three way calculations. The first one shows that the basic standard workspace and distance is applied in lab design. The second one shows that average space area criteria resulted from case studies is applied by 19㎡ per one staff, 0.9~1.0㎡ per one bed, and lastly linear length calculation of workbenches and analyzers on the bench top and floor mount, is multiplying it by the sum of the counter depth plus aisle width. Implications: In updating the space area calculation guidelines, it is necessary to cooperate with medical staffs and designers.

방사성의약품 합성 프로세스 검증을 위한 네트워크 모델링 (Development of A Validation System For Automatic Radiopharmaceutical Synthesis Process Using Network Modeling)

  • 이철수;허은영;김종민;김동수
    • 산업공학
    • /
    • 제24권3호
    • /
    • pp.187-195
    • /
    • 2011
  • The automatic radiopharmaceutical module consists of several 2-way valves, couple of syringes, gas supply unit, heating(cooling) unit and sensors to control the chemical reagents as well as to help the chemical reaction. In order to control the actuators of radiopharmaceutical module, the process is tabulated using spread sheet as like excel. Unlike the common program, a trivial error is too critical to allowed in the process because the error can lead to leak the radioactive reagent and to cause the synthesis equipment failure during synthesizing. Hence, the synthesis process has been validated using graphic simulation while the operator checks the whole process visually and undergoes trial and error. The verification of the synthesis process takes a long time and has a difficulty in finding the error. This study presents a methodology to verify the process algebraically while the radiopharmaceutical module is converted to the network model. The proposed method is validated using actual synthesis process.

Development of Cost-effective Mosquito Repellent and Distribution Method by Extracting Patchouli Oil

  • KWON, Woo-Taeg;KWON, Lee-Seung;YOO, Ho-Gil;LEE, Woo-Sik
    • 산경연구논집
    • /
    • 제10권12호
    • /
    • pp.15-23
    • /
    • 2019
  • Purpose : We will develop the distribution method of wide oil extract technology to develop repellent using this technology and study mosquito repellent persistence. Research design, data and methodology : A positive control group containing purified water, ethanol and picaridin was prepared, and the experimental control group was prepared in the same proportion as the positive control group, and 0.6% of broad oil was added. The results were summarized using the calculation method according to the avoidance effect and statistically tested by t-test using the excel statistics program. Results : Experiments on skin surface area and voice control of participants showed that men had 8.9% wider skin surface area than women, and voice control tests showed that women were bitten by mosquitoes five times more than men. Both the positive and the experimental control groups had a valid duration of up to three hours, but from the time of five hours, the positive control group had 77% and the experimental control had 90%, indicating a difference of 14.4% over the positive control group. Conclusions : The mosquito repellents developed in this study on the basis of safety and continuity are cost-effective in terms of mosquito repellent, and in addition fragrance, odor removal, perfume, ink, skin care and massage effect.

메뉴 분석 방법론의 비교 연구 (What's the Best Technique on Menu Analysis?)

  • 이해영;양일선;도현욱;신서영
    • Journal of Nutrition and Health
    • /
    • 제36권3호
    • /
    • pp.319-326
    • /
    • 2003
  • The purposes of this study were to : (a) analyze the menus of food service operations using the menu analysis techniques of Kasavana & Smith, Miller, Merricks & Jones, Pavesic and Uman, (b) closely examine the characteristics of the five analysis techniques. Calculations for the menu analysis were done by computer using the MS 2000 Excel spreadsheet program. Menu mix% and unit contribution margin were used as variables by Kasavana & Smith, sales volume and food cost% by Miller, sales volume and cash contribution by Merrick & Jones, weighted contribution margin and food cost% by Pavesic, and total cash contribution and unit contribution margin by Uman. In each case, a four-cell matrix was created, and menu items were located in each according they achieved high or low scores with respect to two variables. Items that scored favorably on both variables were rated in the top category (e.g., star, prime, signature, group A, winner) and those that scored below average on both were rated in the lowest category (e.g., dog, problem, loser, group D, loser). While the 3 methods of Kasavana & Smith, Miller, Merrick & Jones focus on customers' viewpoints, the others consider the managers' viewpoints. Therefore, it is more likely to be desirable for decision-making on menus if the menu analysis technique chosen is suited to its purpose.

간호중재분류 (NIC)에 근거한 부인과 간호단위의 간호중재 분석 (Analysis of Nursing Interventions Performed by Gynecological Nursing Unit Nurses Using the Nursing Interventions Classification)

  • 홍성정;이성희;김화선
    • 여성건강간호학회지
    • /
    • 제17권3호
    • /
    • pp.275-284
    • /
    • 2011
  • Purpose: The purpose of this study was to identify nursing intervention performed by nurses on gynecological nursing units. Methods: The instrument in this study is based on the fifth edition of Nursing Interventions Classification (NIC) (2008). Data was collected by Electronic Medical record from August, 2010 to October, 2010 at one hospital and analyzed by using frequencies in the Microsoft Excel 2010 program. Results: Of a total of 82 NIC, domains of the nursing interventions showed higher percentages for physiological: basic (36.3%) and physiological: complex (34.5%). The classes of nursing interventions showed higher percentage for health system medication (12.1%), perioperative care (10.0%), and drug management (8.6%). The most frequently used top interventions were Discharge Planning. The thirty least used interventions was environmental management. Top thirty most frequently used interventions belonged to the domain of physiological: basic (37.9%), physiological: complex (31.1%), and behavioral (5.4%). Conclusion: These findings will help in the establishment of a standardized language for gynecological nursing units and enhance the quality of nursing care.