• Title/Summary/Keyword: Microsoft excel

Search Result 176, Processing Time 0.023 seconds

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

  • Kim, Daehak;Oh, Kwang Sik
    • Journal of the Korean Data and Information Science Society
    • /
    • v.25 no.6
    • /
    • pp.1467-1474
    • /
    • 2014
  • In this paper, we consider the two computer intensive methods for extended Euclidean algdrithm. Two methods we propose are C-programming based approach and Microsoft excel based method, respectively. Thses methods are applied to the derivation of greatest commnon devisor, multiplicative inverse for modular operation and the solution of diophantine equation. Concrete investigation for extended Euclidean algorithm with the computer intensive process is given. For the application of extended Euclidean algorithm, we consider the RSA encrytion method which is still popular recently.

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

  • Kim, Ki-Wang;Chang, Jae-Soon
    • The Journal of the Society of Korean Medicine Diagnostics
    • /
    • v.14 no.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).

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

  • Park, Kwang-Woong;Lee, Kang-Yeong;Kim, Chi-Han;Choi, Sang-Young
    • Journal of the military operations research society of Korea
    • /
    • v.33 no.1
    • /
    • pp.1-18
    • /
    • 2007
  • In the early stage of weapon system acquisition process, acquisition policy is necessarily established to acquire weapon system in a faster, better, cheaper way. Several alternatives, such as "buy", "domestic research and development", and "technical corporative production", can be considered for the best acquisition policy making. However, the comparison factors for those alternatives have different metrics and values. Therefore, the aim of this paper is to suggest KAAM(Knowledge-based Alternatives Analysis Model) as a scientific method to compare the alternatives having such different metrics and values and giving a weighted and normalized single measurement for the easy comparison. KAAM is a hybrid model incorporating Satty technique, Delphi/Shang method, Consensus method, and SAW method. KAAM is implemented on Microsoft Excel environment and provided tabular form user interface. Finally, an illustrative example is shown using KAAM.

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

  • Park, Moon-Kyung
    • Korean journal of food and cookery science
    • /
    • v.28 no.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
    • Journal of Distribution Science
    • /
    • v.13 no.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
    • /
    • v.25 no.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 (시립병원을 중심으로 한 커뮤니티 케어 활성화 방안)

  • Noh, Jin-Won;Lee, Yejin;Kim, Jae-Hyun;So, Ye-Kyoung;Hong, Hyun-Suk;Lee, Yunhwan
    • Korea Journal of Hospital Management
    • /
    • v.24 no.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 (지역약국 필수 실무실습 교육의 중요도, 수행도 및 교육요구도 분석 연구)

  • Jeemi Lim;MiKyong Shim
    • Korean Journal of Clinical Pharmacy
    • /
    • v.32 no.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
    • Journal of Distribution Science
    • /
    • v.12 no.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
    • International conference on construction engineering and project management
    • /
    • 2013.01a
    • /
    • 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