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

검색결과 176건 처리시간 0.025초

확장 유클리드 알고리즘에 대한 컴퓨터 집약적 방법에 대한 연구 (Computer intensive method for extended Euclidean algorithm)

  • 김대학;오광식
    • Journal of the Korean Data and Information Science Society
    • /
    • 제25권6호
    • /
    • pp.1467-1474
    • /
    • 2014
  • 본 논문에서는 정수론 분야에서 가장 기초적인 방법으로 소개되는 유클리드 알고리즘과 이를 확장한 확장 유클리드 알고리즘을 소개하고 이들에 대한 컴퓨터 집약적 방법을 연구하였다. 이들 알고리즘들은 공개키 암호 분야에서 암호화의 과정에서 반드시 거쳐야 하는 과정들 중의 하나로서 그 응용성이 날로 부각되고 있다. 확장 유클리드 알고리즘에 대한 컴퓨터 집약적 방법으로서 마이크로소프트 엑셀과 C 언어를 이용하는 두 가지 방법을 각각 고안하여 제안하였다. 본 논문은 단순히 정수론 차원의 계산을 쉽고 편리하게 하기 위함만이 목적이 아니고 아주 큰 수에 대한 역원 (곱셈에 대한 역원)의 계산과 이의 공개키 암호화 활용에서 의의를 찾을 수 있다.

변증 능력 평가 소프트웨어의 구현 (Development of the Software to test Pattern Diagnosis Ability in Oriental Medicine)

  • 김기왕;장재순
    • 대한한의진단학회지
    • /
    • 제14권1호
    • /
    • pp.70-78
    • /
    • 2010
  • Objectives : To qualify or enhance the diagnostic ability of students in Oriental Medicine, so called standardized patients are ideal modality, but because it's a man-based method, more convenient tools are required. Computer-based diagnostic ability test program gives effective way for the very purpose. So we made a pilot software evaluating Pattern Identification ability in Oriental Medicine. Methods and Materials : The pilot software was coded with Microsoft's EXCEL VBA. 87 names of Zheng (Symptom Pattern) and 674 names of symptom (including some signs) are adopted from the former standardization works conducted by Korean Institute of Oriental Medicine (KIOM) in 1996. Results : Compared with some manned modalities to test Pattern Identification ability, the test by this software shows superiority in convenience and objectivity. Conclusion : This software is world's first program to perform computer-based evaluation of Pattern Identification in Oriental Medicine, and it gives effective way to complement both written test and manned clinical performance test (CPX).

무기체계 획득시 최적 의사결정을 위한 지식기반 대안분석모델(KAAM) 연구 (A Study on Knowledge-based Alternatives Analysis Model(KAAM) for the Best Decision Making in Weapon Systems Acquisition)

  • 박광웅;이강영;김치한;최상영
    • 한국국방경영분석학회지
    • /
    • 제33권1호
    • /
    • pp.1-18
    • /
    • 2007
  • 본 연구의 목적은 비교항목들의 척도가 서로 상이하고 측정치를 산정하기 곤란한 대안들의 의사결정시 대안 비교를 과학적으로 할 수 있는 지식기반 대안분석모델(KAAM)을 제안하는 것이다. KAAM은 기존의 방법인 Saaty, Delphi/Shang, Consensus, SAW 기법을 근간으로 하는 하이브리드 방식으로 구성되고 엑셀기반으로 구현하였다. 또한, 무기체계 획득사업의 사전분석 단계에서 최적 획득방안을 선정하는 실증적 사례를 적용함으로서 KAAM의 유용성을 확인하였다.

국내 위탁급식전문업체 재무건전성 추세 분석 - 1999년부터 2011년 재무제표를 중심으로 - (Trend analysis on the financial soundness of contract foodservice management companies(CFMC) : approach to the financial statements from 1999 to 2011)

  • 박문경
    • 한국식품조리과학회지
    • /
    • 제28권4호
    • /
    • pp.451-461
    • /
    • 2012
  • The purposes of this study were to examine the financial statements and analyze the financial soundness of contract foodservice management companies(CFMC) using the financial ratio. The statistical data analysis was completed using Microsoft Excel(ver.2007) for the trend line equation and using SPSS Win(ver.18.0) for wilcoxon-rank sum test. Increased asset, debt, capital and sales occurred in most of the CFMCs, but the financial trend of firm D decreased for operating profit and net profit. The financial ratio for investigating a firm's financial soundness was based on liquidity, stability, profitability, activity, and growth through financial statements. Most of the CFMCs had maintained outstanding financial soundness from 1999 to 2011. The financial statements during the decade were verified and fluctuated. The directly affected CFMCs by a school foodservice' sanitation accident had maintained better financial statements than those of other CFMCs. Therefore, there was opportunity for directly affecting CFMCs involved in school foodservice' sanitation accident to diversify the business portfolio of the firms.

Students' Perception on Quality of Indian Higher Education System

  • Potluri, Rajasekhara Mouly;Ansari, Rizwana;Khan, Saqib Rasool
    • 유통과학연구
    • /
    • 제13권1호
    • /
    • pp.19-25
    • /
    • 2015
  • Purpose - This study aims to explore students'perceptions of different quality aspects in Indian higher education, viz. tangible facilities, competence, attitudes, content, delivery, and reliability. Research design, data, and methodology - Following a comprehensive literature review, the researchers used a well-structured questionnaire and in-depth personal interviews with 500 students. The selected sample was chosen from graduate and postgraduate programs in the south Indian state of Andhra Pradesh, using convenience sampling; data were analyzed using Microsoft Excel and frequency distribution. Hypotheses were based on the literature and empirical studies. Result - 50.28 and 49.88 percent of students were positive towards tangible facilities and competence, respectively. Further, 48.92 percent and 48.97 percent were negative towards faculty attitudes and course content, respectively. Finally, 48.72 percent reacted positively on the overall quality, while 51.28 were discontented. Conclusion - This study provides reliable and conclusive information to all stakeholders, facilitating systemic improvements. It reveals students'perceptions of different quality aspects of the higher education system, and is the first study of its kind in this part of the world.

Development of a user-friendly and transparent non-linear analysis program for RC walls

  • Menegon, Scott J.;Wilson, John L.;Lam, Nelson T.K.;Gad, Emad F.
    • Computers and Concrete
    • /
    • 제25권4호
    • /
    • pp.327-341
    • /
    • 2020
  • Advanced forms of structural design (e.g., displacement-based methods) require knowledge of the non-linear force-displacement behavior of both the overall building and individual lateral load resisting elements, i.e., walls or building cores. Similarly, understanding the non-linear behaviour of the elements in a structure can also allow for a less conservative structural response to be calculated by better understanding the cracked (i.e., effective) properties of the various RC elements. Calculating the non-linear response of an RC section typically involves using 'black box' analysis packages, wherein the user may not be in complete control nor be aware of all the intricate settings and/or decisions behind the scenes. This paper introduces a user-friendly and transparent analysis program for predicting the back-bone force displacement behavior of slender (i.e., flexure controlled) RC walls, building cores or columns. The program has been validated and benchmarked theoretically against both commonly available and widely used analysis packages and experimentally against a database of 16 large-scale RC wall test specimens. The program, which is called WHAM, is written using Microsoft Excel spreadsheets to promote transparency and allow users to further develop or modify to suit individual requirements. The program is available free-of-charge and is intended to be used as an educational tool for structural designers, researchers or students.

시립병원을 중심으로 한 커뮤니티 케어 활성화 방안 (Activation plan of community care focused on a municipal hospital)

  • 노진원;이예진;김재현;소예경;홍현석;이윤환
    • 한국병원경영학회지
    • /
    • 제24권3호
    • /
    • pp.38-47
    • /
    • 2019
  • Purposes: Rapid aging and increase of high chronic diseases of the elderly are increasing the needs for expanding elderly care beyond the concept of treatment in medical institutions. This study is to discuss the core values, functions, and roles of municipal hospitals and suggest a suitable community care model. Methodology: The survey was collected twice derived from the domestic expert groups. This study analyzed experts' responses using Delphi method and Analytic Hierarchy Process, using Microsoft Excel 2016. Findings: Among the core values of the municipal hospitals, it was shown that community linkage had the highest priority. The publicity had the highest priority among the functions and roles of the municipal hospitals. In the community care models presented in this study, the model focused on 'Community Care Integration Center' showed highest relevance, suitability and applicability. Practical Implications: This study suggested three different community care models and derived the most suitable model for community care, which is focused on the municipal hospitals. It suggested effective application of the community care model to promote community care in each community.

지역약국 필수 실무실습 교육의 중요도, 수행도 및 교육요구도 분석 연구 (A Study on the Importance, Performance, and Educational Needs of the Community Pharmacy Practice Education)

  • 임지미;심미경
    • 한국임상약학회지
    • /
    • 제32권4호
    • /
    • pp.303-312
    • /
    • 2022
  • Objective: The purpose of the study was to analyze the difference in the importance and performance of the educational content of the community pharmacy practice and find the factors that influence it. Methods: A 5-point Likert scale questionnaire asked about the importance and performance of the pharmacy practice education items to community pharmacy preceptors, current students, and professors. Data were analyzed using Microsoft office 365 Excel and IBM SPSS 21.0. Results: A total of 117 people participated. The averages of importance and performance were 4.34±0.34 and 3.71±0.45, respectively. Except for the computational entry of prescriptions and medication history, the average score for the importance of all educational items was statistically significantly higher than the one for performance. Importance Performance Analysis (IPA) identified over-the-counter medication counseling, over-the-counter drug selection consultation, pharmacy management, adverse drug reaction monitoring, and understanding and implementation of drug use evaluation as the items that needed focused effort. Borich's needs were highest in the adverse drug reaction monitoring. Conclusions: Overall, high importance and low performance indicate a need for improvement in community pharmacy practice education. Since the demand for education was high in over-the-counter medication counseling, adverse drug reaction monitoring, and OTC drug selection consultation, various supports are urgently needed to strengthen pharmacy practice education in this area in the future.

Recent Trends in HR as Useful Retention Strategy in Indian Information Technology (IT) Sector

  • Potluri, Rajasekhara Mouly;V.S., Mangnale;Challa, Siva Kumar;Challagundla, Srilakshmi
    • 유통과학연구
    • /
    • 제12권1호
    • /
    • pp.29-33
    • /
    • 2014
  • Purpose - The focal point of this research is to study the implications of retention, various reasons for attrition and also different ways to control attrition along with the employee retention strategies implementing by the Indian IT sector. Research design, data and methodology - After thorough literature review on employee attrition and retention, questionnaire has prepared to collect the opinions of 200 employees which were chosen from 20 IT companies (10 each from large and medium size companies) with simple random sampling technique and also gathered the opinion of these companies HR managers on strategies they are implementing to retain their talent pool through personal and telephonic interviews. Results -The research completely limited to the IT companies located in the city of Pune which is emerged as a new IT hub of India. The collected data was analyzed with Microsoft Excel and frequency distribution. Conclusions - The researchers identified job associated, compensation related and inter-personal relations for quitting their positions along with the outlook of Indian IT companies related to the identification and implementation of retention strategies like incessant hikes in compensation package, improved working conditions, continuous introduction of employee welfare facilities, and genuine promotional policy, recognition and rewards, career planning and development, and exemplary leadership.

A STUDY ON CONSTRUCTION SCHEDULE OPTIMIZATION INTEGRATING WITH CASH-FLOW

  • Hyung-Guk Lee;Dong-Pil Shin;Sung-Hoon An;Dong-Eun Lee
    • 국제학술발표논문집
    • /
    • The 5th International Conference on Construction Engineering and Project Management
    • /
    • pp.141-144
    • /
    • 2013
  • This paper presents a system called a Cash-flow based Construction Schedule Optimization system(CfSO). The existing CPM effectively handles schedule and cost management. However, funding strategy should be considered to obtain maximum profit and to progress a project favorably. One of measures is to coordinate the contract terms between owner and subcontractors (or suppliers). Contractor may decrease the interest cost attributed to project financing by adjusting the timing of cash-inflows and cash-outflows. It is an excellent method maximizing profits. This paper presents a method to estimate the amount of a cash-flow occurred periodically by integrating the terms of contract into scheduling. The proposed method is implemented as a system prototype in Microsoft Excel. This system provides a user an automated tool that identifies an optimal schedule that secures maximum profit by adjusting start and finish times of non-critical activities' free-floats without affecting on the project completion time. This system supports a project manager to establish an optimum project schedule and identifies profitable contractual conditions against to a construction owner.

  • PDF