• Title/Summary/Keyword: Microsoft Excel

Search Result 177, Processing Time 0.024 seconds

Challenges of Transport Sector in India: A Dyadic Perspective

  • Potluri, Rajasekhara Mouly;Tejaswi, Satagopam Padma
    • The Journal of Asian Finance, Economics and Business
    • /
    • v.5 no.3
    • /
    • pp.95-102
    • /
    • 2018
  • The objective of this research is to explore the diverse challenges faced by the customer as well transport providers through the selected modes of transportation of the second most populous country in the world - India. Two separate well-structured questionnaires administered to garner the opinions on different challenges. A random sample of 100 equally selected from the customers of 3 modes of transportation along with 30 transport providers. The collected data was analyzed in Microsoft Excel and R Studio platforms using Percentile Rank Tool and R Programming Language for Chi-square test respectively. Traffic congestion coupled with parking is the major problem in case of roadways while Safety and cleanliness in railways are the first amongst the problems to reckon with. High fares and lack of trained employees are the biggest challenges faced by aviation industry. The research is concentrated only in the states of Andhra Pradesh and Telangana in India with most widely used three modes of transportation viz., Road, Rail and Airways. This research paper is first of its kind which has collected the opinions of both customers as well transport providers on the problems faced. This research proffers information about the challenges faced by the customers which there will be an enormous possibility to review their strategies and plans.

An Empirical Analysis of Costs related to Nursing Practice (간호 관련 비용의 실증적 사례분석 연구)

  • Ko, Yu Kyung;Park, Bo-Hyun
    • Journal of Korean Academy of Nursing Administration
    • /
    • v.23 no.2
    • /
    • pp.139-150
    • /
    • 2017
  • Purpose: The purpose of this study was to identify nursing service costs associated with all health care costs incurred by the institution. Methods: This study was an empirical case study research in which the nursing cost was separated from total medical cost. The nursing cost index was calculated through a cost allocation method after summarizing costs for personnel, raw materials and administration of each department in one public hospital. The 2014 budget plan, published in 'Public Hospitals Alert', was used as data and the data were analyzed using the Microsoft Office EXCEL 2013 program. Results: When comparing total medical costs and nursing costs, the nursing cost were 27.14% of the total medical cost. The nursing cost per nurse per hour was calculated as \29,128 The nursing cost per inpatient per day was calculated as \157,970, and the administration cost per patient was calculated as \133,710. Conclusion: The results of the research present the process of cost allocation of specific cost elements in the hospital and evidence for administrative costs which in the past have been only vaguely formulated. These are the significant implications of this study.

Quantitative Review of Oral Cancer Research Output from Pakistan

  • Khan, Zohaib;Muller, Steffen;Ahmed, Shahzad;Tonnies, Justus;Nadir, Faryal;Samkange-Zeeb, Florence
    • Asian Pacific Journal of Cancer Prevention
    • /
    • v.16 no.11
    • /
    • pp.4733-4739
    • /
    • 2015
  • Background: Oral cancer is the most common cancer among men and second only to breast cancer among women in Pakistan. For the effective control and prevention of oral cancer, Pakistan needs to recognize the importance of research and generation of the evidence-base which can inform policy making and planning and implementation of intervention programs. The objective of this review was to quantify oral cancer research output in Pakistan. Materials and Methods: A systematic electronic search in "Medline", "ISI-Web of Science" and "Pakmedinet", supplemented by a Google search, was carried out in January and February, 2014, to identify literature from Pakistan relevant to oral cancer. The selection of publications for the review was carried out according to preset criteria. Data were recorded and analyzed using Microsoft Excel. Results: A total of 166 publications comprising 62 case series, 36 cross sectional, 31 case control, 10 basic laboratory research, eleven reviews and two trials, were included in this review. Some 35 % of the publications focused on risk factors for oral cancer. COMSATS Institute of Information Technology was the institution with the highest contribution. Conclusions: There is a lack of research in the field of oral cancer research in Pakistan. Focused efforts should be put in place to improve both quality and quantity of oral cancer research in the country.

Application of Disinfection Models on the Plasma Process (플라즈마 공정에 대한 소독 모델 적용)

  • Back, Sang-Eun;Kim, Dong-Seog;Park, Young-Seek
    • Journal of Environmental Science International
    • /
    • v.21 no.6
    • /
    • pp.695-704
    • /
    • 2012
  • The application of disinfection models on the plasma process was investigated. Nine empirical models were used to find an optimum model. The variation of parameters in model according to the operating conditions (first voltage, second voltage, air flow rate, pH) were investigated in order to explain the disinfection model. In this experiment, the DBD (dielectric barrier discharge) plasma reactor was used to inactivate Ralstonia Solanacearum which cause wilt in tomato plantation. Optimum disinfection models were chosen among the nine models by the application of statistical SSE (sum of squared error), RMSE (root mean sum of squared error), $r^2$ values on the experimental data using the GInaFiT software in Microsoft Excel. The optimum model was shown as Weibull+talil model followed by Log-linear+ Shoulder+Tail model. Two models were applied to the experimental data according to the variation of the operating conditions. In Weibull+talil model, Log10($N_o$), Log10($N_{res}$), ${\delta}$ and p values were examined. And in Log-linear+Shoulder+Tail model, the Log10($N_o$), Log10($N_{res}$), $k_{max}$, Sl values were calculated and examined.

The development and application of environmental impact assessment program for apartment building element based on building materials LCI DB (건축재료 LCI DB 기반의 공동주택 부위별 환경영향 평가 프로그램 개발 및 적용에 관한 연구)

  • Kim, Rak Hyun;Tae, Sung Ho;Kim, Ji Hoon;Lee, Jong Gun
    • KIEAE Journal
    • /
    • v.16 no.6
    • /
    • pp.151-157
    • /
    • 2016
  • Purpose: The purpose of this study is to develop and apply an environmental impact assessment program for apartment building elements, based on the building materials of the LCI DB, which can link the LCA results of building materials and buildings. Method: For this purpose, a framework for building elements was established, and several building material combinations were developed. In addition, the LCA method for quantifying environmental load emissions from the building materials of each site was applied to establish an environmental impact database of the building materials of the LCI DB. Result: An environmental impact assessment program, based on a Microsoft Excel worksheet, was developed for apartment building elements. This program can link the environmental impact assessment of building materials and building units. To validate the program evaluation results that were obtained in this study, a comparative analysis was carried out using the results of existing evaluation methods. The error rate was estimated to be 5% for environmental impact assessment using existing evaluation methods.

JAVA BASED WEB APPLICATION FOR THE ASTRONOMICAL CATALOGUES (천문학 카탈로그 자료의 통합검색 DB 구축)

  • Sung, Hyun-Il;Sang, Jian;Kim, Bong-Gyu;Yim, In-Sung;Kim, Sang-Chul;Ahn, Young-Suk
    • Publications of The Korean Astronomical Society
    • /
    • v.20 no.1 s.24
    • /
    • pp.85-95
    • /
    • 2005
  • We collected eleven large astronomical catalogues, which include 2MASS, USNO B1.0, GSC 2 catalogues and so on. Most of these catalogues are the frequently used by astronomers for all sorts of applications. But the researches are faced with the problem of accessing these databases because these catalogues contain from tens millions up to thousands of millions of records. So we developed a web application system to manage these large catalogues, the main purpose of the web application is to allow a powerful and efficient querying activity on these catalogues through internet by using a simple web interface. User could retrieve the query result in variety of formats including plain text, HTML, Microsoft Excel format (XLS), and VOTable. Furthermore, user also could display and analyze result graphically by using a powerful interactive visualization tools named VOPlot which was developed by the Virtual Observatory-India (VOI) project.

An Exploratory Research on Country-of-Origin and Its Impact on the UAE Consumers Buying Decisions

  • POTLURI, Rajasekhara Mouly;JOHNSON, Sophia
    • The Journal of Asian Finance, Economics and Business
    • /
    • v.7 no.9
    • /
    • pp.455-466
    • /
    • 2020
  • The purpose of the paper is to explore the country-of-origin (COO) influence on the buying decisions of the United Arab Emirates (UAE) consumers. The collected data from 370 consumers were summarized and coded by using Software R Studio and Microsoft Excel. The independent variables were analyzed and tested for their significant impact on the dependent variable, final buying decision of the product/service based on its country of origin. The selected hypotheses tested by administering the Kruskal-Wallis (K-W) hypothesis testing technique. The researchers identified that UAE consumers buying decisions influenced mainly by the country of origin of the products and services. The demographic variables like age, education, country of origin influential factors, country of choice was not displaying any significant impact on the buying decisions of consumers. The survey is limited to cover the general consumers of the country who are randomly selected from Dubai and Sharjah emirates. The study is beneficial to all the types of marketers, including domestic and international companies, who have plans to know the exact influence on consumers' buying decisions. The present research paper is original and provides empirical evidence on the country of origin's impact on the buying decisions of different products/services in the UAE.

Improved Method for Determining the Height of Center of Gravity of Agricultural Tractors

  • Kim, YuYong;Noh, JaeSeung;Shin, SeungYeop;Kim, ByoungIn;Hong, SunJung
    • Journal of Biosystems Engineering
    • /
    • v.41 no.3
    • /
    • pp.170-176
    • /
    • 2016
  • Purpose: This study aimed to improve the method for determining the position of the center of gravity for agricultural tractors. Methods: The proposed method uses trigonometric functions and coordinate transformation. Data were measured according to the ISO 789-6 test procedures for the center of gravity of agricultural tractors. The height calculated using the proposed method was compared with that determined from an AutoCAD drawing. To find the center of gravity of the tractor, the algorithm for finding the intersection of the two lines was used. Results: The vertical height from the ground to the center of gravity is 682.06 mm. The vertical coordinates obtained from the calculation and the drawing were the same. Conclusions: The developed method uses trigonometric and polar coordinate transformation. The method was compared and verified with the AutoCAD drawing results. The results indicate that users can apply this developed method instead of the plotting method which is an inconvenient and time-consuming. Further, users can program Microsoft Excel to easily determine the vertical coordinate. In addition, researchers will propose this method to the ISO as a standard method for determining the center of gravity in accordance with ISO 789-6.

Human Power a Prospect of Digital Programmable Logic Controller a Field (디지털 PLC분야의 인력수요전망)

  • Kim, Soo-Yong;Park, Dong-Jin
    • Journal of Engineering Education Research
    • /
    • v.12 no.2
    • /
    • pp.89-95
    • /
    • 2009
  • This thesis investigated way of employment, education course of a training school of Programmable Logic Controller a Field. I inquired into a demand of an engineer and a necessary level of professional education. As a result, I have a purpose in what offer the information that cared for a beginning to work elevation and education training and boat development of a student more than. Faced a human power demand in an education demand and a field rehearsal student demand and analyzed it. The sample extraction used industrial classification, work of scale, Assignment sample extraction way (quota sampling). All data called at a silver phone and the investigated, The data parser analyzed the statistics that used Microsoft Excel.

Human Power a Prospect of Building Automatic Control a Field (빌딩자동제어분야의 인력수요전망)

  • Kim, Soo-Yong;Jee, Suk-Kun
    • Journal of Engineering Education Research
    • /
    • v.11 no.3
    • /
    • pp.90-95
    • /
    • 2008
  • This thesis investigated way of employment, education course of a training school of electrical company. I inquired into a demand of an engineer and a necessary level of professional education. As a result, I have a purpose in what offer the information that cared for a beginning to work elevation and education training and boat development of a student more than. Faced a human power demand in an education demand and a field rehearsal student demand and analyzed it. The sample extraction used industrial classification, work of scale, Assignment sample extraction way (quota Sampling). All data called at a silver phone and the investigated, The data parser analyzed the statistics that used Microsoft Excel.