• Title/Summary/Keyword: Excel program

Search Result 240, Processing Time 0.031 seconds

Estimating upland crop water use in Jeju (제주도 밭작물 용수량 산정방법)

  • Lee, Yong-Il;Kim, Hyeon-Soo;Lim, Han-Cheo;Song, Chang-Khil;Moon, Kyung- Hwan;Kang, Bong-Kyoon
    • Proceedings of the Korean Society of Agricultural Engineers Conference
    • /
    • 2005.10a
    • /
    • pp.32-37
    • /
    • 2005
  • Crop evapotranspiration rates of the garlic, potato and carrot were measured in a lysimeter at the National Institute of Subtropical Agriculture. The crop coefficients were calculated using the values of the actually measured evapotranspiration(ETcrop) and the reference crop evapotranspiration (ETo) estimated by the Penman-Monteith equation. The maximum crop coefficients of the garlic, potato, carrot and cabbage were 1.07, 1.07, 0.73 and 0.92 respectively. For the Citrus Aoshima Unshiu and Hallabong in the plastic house, the maximum crop coefficients were 1.38 and 1.29 respectively. Computer program using EXCEL was also developed to estimate the crop water use.

  • PDF

New Business Model Development Using 6Sigma Methodology (6시그마 방법론을 이용한 신 비즈니스 모델 개발)

  • Sung, Ki-Wook;Yoo, Jae-Sung;Kim, Bong-Sun
    • Proceedings of the Safety Management and Science Conference
    • /
    • 2010.04a
    • /
    • pp.401-414
    • /
    • 2010
  • Global financial crisis at 2008 caused a great change of the company itself and environment as hit product, new creative business model. But it is not easy program. Ambidextrous organization excel at exploiting existing products to enable incremental innovation and at exploring new opportunities fo foster more radical innovation. In this paper are presented the improved procedures of new business model development using 6 sigma methodology. To inspired about new business ideas we use exploration method. To eliminate project's waste we use exploitation method such as 6sigma methodology. The main object of this study is to introduce an empirical study on DIDOV.

  • PDF

Development of a Prototype Software for a Corporate Customer Relationship Management in the Postal Service (우편 서비스의 법인 고객관계관리를 위한 프로토타입 소프트웨어 개발)

  • Kim, Yong-Soo;Choeh, Joon-Yeon
    • IE interfaces
    • /
    • v.25 no.2
    • /
    • pp.229-240
    • /
    • 2012
  • Conventional research on customer relationship management(CRM) in general has focused on the effects of individual customer's satisfaction, retention and profit management. However, corporate customers are more profitable than individual customers because of high volume and frequent transactions between companies. In this article, a prototype for a corporate customer relationship management is developed in the postal service. First, the frequency and amount of customers' usage were examined, and thereby the corporate customer rating scheme was established to provide customized service. Second, five different types of usage patterns were determined using clustering analysis. In addition, we presented the rationales behind the five types of patterns. Third, RFM(recency, frequency, monetary) analysis was performed, and then action plans were developed to increase sales. Finally, the prototype software was developed to automatically perform the above analysis using MS Excel program.

An Adaptive Scheme for Frequency Measurement in Power System (적응기법을 이용한 전력계통의 주파수 측정)

  • Park, Cheol-Won;Nam, Si-Bok;Sin, Myeong-Cheol
    • The Transactions of the Korean Institute of Electrical Engineers A
    • /
    • v.51 no.3
    • /
    • pp.143-152
    • /
    • 2002
  • Frequency is regarded as one of most important indices for the operating power systems. Several digital techniques for measuring frequency have been presented in the last decades. This paper proposes a design and implementation an adaptive scheme using phase angle difference calculation fort frequency measuring in power system. The advantages of the proposed technique are demonstrated by fault signals from EMTP simulation and user defined arbitrary signals by Excel program. The proposed technique is compared with the conventional methods. Performance teat results indicate that the proposed technique provides accurate measures in pretence of noise and harmonics and in case faults and is suitable for measurement near-nominal, nominal. and off-nominal frequencies. We can see that It will be useful in microprocessor based relays and digital metiers that need to measure power system frequency.

Power Load Density Analysis considering Structure and Characteristics of Subway Stations (지하철 역사의 구조 및 특성을 고려한 동력부하밀도 분석)

  • Jung, Hyun-Ki;Cha, Kwang-Seok
    • Proceedings of the KSR Conference
    • /
    • 2006.11b
    • /
    • pp.912-920
    • /
    • 2006
  • The purpose of this study is to present the design standard for load density in subway station. From the data of electric equipment capacity and electric power consumption for 43 subway stations, current levels of the load density and excess capacity factor were surveyed and analyzed, In addition mean value, standard deviation, maximum value, median value and correlation coefficient were evaluated through excel program. Also it was carried out the regression analysis. The estimation method of load density and design criterion were studied. As a result, load density in this thesis have been proposed : 51.3 $[VA/m^2]$ on the general power load can be a standard value for subway station.

  • PDF

An Analysis of the Space Size in the Apartment Unit Plan (공동주택 단위평면의 실별 면적 분석)

  • Lee, Kyung-A;Park, So-Yun;Lee, Hyun-Soo
    • Proceedings of the Korean Institute of Interior Design Conference
    • /
    • 2005.10a
    • /
    • pp.52-55
    • /
    • 2005
  • The purpose of this study is to analyze space size in the apartment unit plan towards optimal space configuration in order to offer the helpful information to housing designers. For this, we analyzed 432 samples using the Excel 2003 program. The major results of this study are as follows. 1) as the unit size gets bigger, the proportion of the usable area is increased. 2) as the unit size gets bigger, the number of spaces is increased and spaces are divided although they have the same function. 3) living room has the highest proportion in each unit, master room and kitchen are followed. 4) the proportion of living room, kitchen and entrance hall is not fluctuated while that of bedroom and bathroom is decreased. 5) there is a big gap between maximum size and minimum size of kitchen, entrance hall, bathroom and dressing room.

  • PDF

Development of Program for Relative Biological Effectiveness (RBE) Analysis of Particle Beam Therapy

  • Chung, Yoonsun;Ahn, Sang Hee;Choi, Changhoon;Park, Sohee
    • Progress in Medical Physics
    • /
    • v.28 no.1
    • /
    • pp.11-15
    • /
    • 2017
  • Relative biological effectiveness (RBE) of particle beam needs to be evaluated at particle beam therapy centers before the clinical application of the particle beam. However, since RBE analysis is implemented manually, it is useful to have a tool that can easily and effectively handle the data of experiments to generate cell survival curve and to analyze RBE simultaneously. In this work, the development of a program for RBE analysis of particle beam therapy was presented. This RBE analysis program was developed to include two parts; fitting the cell survival curves to linear-quadratic model and calculating the RBE values at a certain endpoint using fitting results. This program was also developed to simultaneously compare and analyze the template results that stored experiment data with photon and particle beam irradiations. The results of the cell survival curve obtained by each irradiation can be analyzed by the user on a desired data after reading the template stored in the easy-to-use excel file. The analysis results include the cell survival curves with error range, which are appeared in the screen and the ${\alpha}$ and ${\beta}$ parameters of linear-quadratic model with 95% confidence intervals, RBE values, and $R^2$ values to evaluate goodness-of-fit of survival curves to model, which are stored in a text cvs file. This software can generate cell survival curve, fit to model, and calculate RBE all at once with raw experiment data, so it helps users to save time for data handling and to reduce the possibility of making error on analysis. As a coming plan, we will create a user-friendly graphical user interface to present the results more intuitively.

Evaluation of Respiratory Protection Program in Petrochemical Industries: Application of Analytic Hierarchy Process

  • Kolahi, Hadi;Jahangiri, Mehdi;Ghaem, Haleh;Rostamabadi, Akbar;Aghabeigi, Mandana;Farhadi, Payam;Kamalinia, Mojtaba
    • Safety and Health at Work
    • /
    • v.9 no.1
    • /
    • pp.95-100
    • /
    • 2018
  • Background: Respiratory protection equipment (RPE) is the last resort to control exposure to workplace air pollutants. A comprehensive respiratory protection program (RPP) ensures that RPE is selected, used, and cared properly. Therefore, RPP must be well integrated into the occupational health and safety requirements. In this study, we evaluated the implementation of RPP in Iranian petrochemical industries to identify the required solutions to improve the current status of respiratory protection. Methods: This cross-sectional study was conducted among 24 petrochemical industries in Iran. The survey instrument was a checklist extracted from the Occupational Safety and Health Administration respiratory protection standard. An index, Respiratory Protection Program Index (RPPI), was developed and weighted by analytic hierarchy process to determine the compliance rate (CR) of provided respiratory protection measures with the RPP standard. Data analysis was performed using Excel 2010. Results: The most important element of RPP, according to experts, was respiratory hazard evaluation. The average value of RPPI in the petrochemical plants was $49{\pm}15%$. The highest and lowest of CR among RPP elements were RPE selection and medical evaluation, respectively. Conclusion: None of studied petrochemical industries implemented RPP completely. This can lead to employees' overexposure to hazardous workplace air contaminants. Increasing awareness of employees and employers through training is suggested by this study to improve such conditions.

A Comprehensive Computer Program for Monitor Unit Calculation and Beam Data Management: Independent Verification of Radiation Treatment Planning Systems (방사선치료계획시스템의 독립적 검증을 위한 선량 계산 및 빔데이터 관리 프로그램)

  • Kim, Hee-Jung;Park, Yang-Kyun;Park, Jong-Min;Choi, Chang-Heon;Kim, Jung-In;Lee, Sang-Won;Oh, Heon-Jin;Lim, Chun-Il;Kim, Il-Han;Ye, Sung-Joon
    • Progress in Medical Physics
    • /
    • v.19 no.4
    • /
    • pp.231-240
    • /
    • 2008
  • We developed a user-friendly program to independently verify monitor units (MUs) calculated by radiation treatment planning systems (RTPS), as well as to manage beam database in clinic. The off-axis factor, beam hardening effect, inhomogeneity correction, and the different depth correction were incorporated into the program algorithm to improve the accuracy in calculated MUs. A beam database in the program was supposed to use measured data from routine quality assurance (QA) processes for timely update. To enhance user's convenience, a graphic user interface (GUI) was developed by using Visual Basic for Application. In order to evaluate the accuracy of the program for various treatment conditions, the MU comparisons were made for 213 cases of phantom and for 108 cases of 17 patients treated by 3D conformal radiation therapy. The MUs calculated by the program and calculated by the RTPS showed a fair agreement within ${\pm}3%$ for the phantom and ${\pm}5%$ for the patient, except for the cases of extreme inhomogeneity. By using Visual Basic for Application and Microsoft Excel worksheet interface, the program can automatically generate beam data book for clinical reference and the comparison template for the beam data management. The program developed in this study can be used to verify the accuracy of RTPS for various treatment conditions and thus can be used as a tool of routine RTPS QA, as well as independent MU checks. In addition, its beam database management interface can update beam data periodically and thus can be used to monitor multiple beam databases efficiently.

  • PDF

An Longitudinal Analysis of Changing Beliefs on the Use in IT Educatee by Elaboration Likelihood Model (정교화 가능성 모형에 의한 IT 피교육자 신용 믿음 변화의 종단분석)

  • Lee, Woong-Kyu
    • Asia pacific journal of information systems
    • /
    • v.18 no.3
    • /
    • pp.147-165
    • /
    • 2008
  • IT education can be summarized as persuading the educatee to accept IT. The persuasion is made by delivering the messages for how-to-use and where-to-use to the educatee, which leads formulation of a belief structure for using IT. Therefore, message based persuasion theory, as well as IT acceptance theories such as technology acceptance model(TAM), would play a very important role for explaining IT education. According to elaboration likelihood model(ELM) that has been considered as one of the most influential persuasion theories, people change attitude or perception by two routes, central route and peripheral route. In central route, people would think critically about issue-related arguments in an informational message. In peripheral route, subjects rely on cues regarding the target behavior with less cognitive efforts. Moreover, such persuasion process is not a one-shot program but continuous repetition with feedbacks, which leads to changing a belief structure for using IT. An educatee would get more knowledge and experiences of using IT as following an education program, and be more dependent on a central route than a peripheral route. Such change would reformulate a belief structure which is different from the intial one. The objectives of this study are the following two: First, an identification of the relationship between ELM and belief structures for using IT. Especially, we analyze the effects of message interpretation through both of central and peripheral routes on perceived usefulness which is an important explaining variable in TAM and perceived use control which have perceived ease of use and perceived controllability as sub-dimensions. Second, a longitudinal analysis of the above effects. In other words, change of the relationship between interpretation of message delivered by IT education and beliefs of IT using is analyzed longitudinally. For achievement of our objectives, we suggest a research model, which is constructed as three-layered. While first layer has a dependent variable, use intention, second one has perceived usefulness and perceived use control that has two sub-concepts, perceived ease of use and perceived controllability. Finally, third one is related with two routes in ELM, source credibility and argument quality which are operationalization of peripheral route and central route respectively. By these variables, we suggest five hypotheses. In addition to relationship among variables, we suggest two additional hypotheses, moderation effects of time in the relationships between perceived usefulness and two routes. That is, source credibility's influence on perceived usefulness is decreased as time flows, and argument quality's influence is increased. For validation of it, our research model is tested empirically. With measurements which have been validated in the other studies, we survey students in an Excel class two times for longitudinal analysis. Data Analysis is done by partial least square(PLS), which is known as an appropriate approach for multi-group comparison analysis with a small sized sample as like this study. In result. all hypotheses are statistically supported. One of theoretical contributions in this study is an analysis of IT education based on ELM and TAM which are considered as important theories in psychology and IS theories respectively. A longitudinal analysis by comparison between two surveys based on PLS is also considered as a methodological contribution. In practice, finding the importance of peripheral route in early stage of IT education should be notable.