• Title/Summary/Keyword: excel based model

Search Result 86, Processing Time 0.028 seconds

Geomorphologic Nash Model with Variable Width Function

  • Thuy, Nguyen Thi Phuong;Kim, Joo-Cheol;Jung, Kwansue
    • Proceedings of the Korea Water Resources Association Conference
    • /
    • 2015.05a
    • /
    • pp.212-212
    • /
    • 2015
  • So far, geomorphologic dispersion due to the heterogeneity characteristics of flow paths in a basin has been demonstrated as a major factor affecting to the hydrologic response function of a catchment. This effect has considered by many previous studies taking into account flow path length factors, especially in the application of width function. Based upon the analysis of topographic index, another important geomorphologic factor extracted from DEM data, this work presents a new factor named saturation to evaluate its effects to the formation of the well-known instantaneous unit hydrograph (IUH) in Nash model and drainage structure in a river basin. First, the geomorphologic parameters corresponding to different saturation conditions are computed from DEM data with the support of GIS software. Then, in the combination of hydrologic and geomorphologic data, effective rainfall in each saturation degree and the Nash parameters are calculated using excel. Finally, the verification process with direct runoff data is conducted using Fortran programming. This process is applied to five sub-watersheds in Bocheong catchment ($485.21km^2$) in Korea where the necessary data are available and believable. The results from this approach will improve researchers and students'understandings about the relationship between rainfall and runoff and its relation with drainage structure within a catchment.

  • PDF

Vibration Reduction of Forklift Truck Using Optimization of Engine Mount Layout (마운트 배치 최적화를 통한 지게차 엔진 진동 저감)

  • Kim, Younghyun;Kim, Kyutae;Lee, Wontae
    • Transactions of the Korean Society for Noise and Vibration Engineering
    • /
    • v.24 no.2
    • /
    • pp.102-107
    • /
    • 2014
  • The engine excitation forces are considered as major vibration source for the forklift truck, especially in small class. Even though the current engine mounting system designs are acceptable for vibration isolation, the performance of the engine mounting system is still required for the tendency of light weight, higher power and driver's higher vibration requirement. In this paper vibration reduction technique of forklift engine which is supported on rubber mounts is presented. Based on the dynamic model of resilient engine mounting system, design evaluation program is established. The design optimization technique and evaluation method of system properties are discussed. Effects of optimal design are validated through comparison with test results.

Life Testing Simulation for Reliability Prediction (신뢰도 예측을 위한 수명시험 시뮬레이션)

  • Kim, Yon-Soo;Chung, Young-Bae
    • Journal of Korean Society of Industrial and Systems Engineering
    • /
    • v.35 no.1
    • /
    • pp.124-131
    • /
    • 2012
  • This paper presents a spreadsheet-based reliability prediction simulation framework for the conceptual product design stage to acquire system reliability information in timely manner. During early stage, reliability performance deals with both known and unknown failure rates and component-level and subsystem-level failure estimate to predict system reliability. A technique for performing life testing simulation using Excel spreadsheet has been developed under the such circumstances. This paper also discuss the results obtainable from this method such as reliability estimate, mean and variance of failures and confidence intervals. The resultant of this reliability prediction system is mainly benefitting small and medium-sized enterprise's field engineers.

Vibration reduction of forklift truck using optimization of engine mount layout (마운트 배치 최적화를 통한 지게차 엔진 진동 저감)

  • Kim, Younghyun;Kim, Kyutae;Lee, Wontae
    • Proceedings of the Korean Society for Noise and Vibration Engineering Conference
    • /
    • 2013.10a
    • /
    • pp.787-791
    • /
    • 2013
  • The engine excitation forces are considered as major vibration source for the forklift truck, especially in small class. Even though the current engine mounting system designs are acceptable for vibration isolation, the performance of the engine mounting system is still required for the tendency of light weight, higher power and driver's higher vibration requirement. In this paper vibration reduction technique of forklift engine which is supported on rubber mounts is presented. Based on the dynamic model of resilient engine mounting system, design evaluation program is established. The design optimization technique and evaluation method of system properties are discussed. Effects of optimal design are validated through comparison with test results.

  • PDF

Human Environment for being a Great doctor - from case to construction - (훌륭한 의사를 기르는 인적환경 - 사례에서 구조까지 -)

  • Ryue, Soo-hee
    • Korean Medical Education Review
    • /
    • v.9 no.2
    • /
    • pp.57-66
    • /
    • 2007
  • Purpose How can be a great doctor with excellence and ethics? In this study, I wanted to find out the characteristics of human environment to make a great doctor. Methods: First, I researched factors and construct of the human environment. So I conceived a model for analyzing human environment with two construction model : Howard Gardner's System Model and Bron-fenbrenner's ecological systems model. Second, I analyzed the life of the Oliver R. Evison M.D. and Ki Ryu Jang M.D. Oliver R. Evison was the pioneer of medicine of Korea and establisher of the Severance Hospital and medical college. Dr KiRyu Jang, who was called 'Schweitzer of Korea', was a good doctor of the poor and weak patients in Korea. Third, I tried to find out a new human environment model to make a great doctor. Results One model for analyzing human environment was made of relationship based on emotion. relationship teaching knowledge and skill, and relationship communicating on value. In the light of analyzing of two great doctors. Oliver R. Evison M.D. and KiRyu Jang M.D, I found out special interrelationship, Hardie, Allen, Severance for Evison, Kyosin Kim, Kyucheol Choi etc. for Ki Ryu Jang These special people were religious actors or social thinkers. Conclusions: To be a great doctor to excel and innovate medical field, medical students should have the chance to meet with people based on religious, ethical and social action, discuss on value across social fields, and can construct the idea to make and realize higher value of medical action. In sum, another important human environment for medical students would be a person who could be communicate with true value.

Efficiency analysis on advertising media for animal welfare egg - Focused on ranked logit model - (동물복지형 달걀에 대한 광고매체의 효율성 분석: Ranked Logit Model을 중심으로)

  • Ohh, Sang Jip;Jung, Yun-Pil;Oh, Kyung-Tae;Hong, Seung-Jee;Lee, Jong-In
    • Korean Journal of Agricultural Science
    • /
    • v.39 no.3
    • /
    • pp.441-450
    • /
    • 2012
  • The object of this study is to establish proper consumer-oriented advertisement strategies of animal welfare egg. Data were collected by consumer survey on November 4th, 2011 at Hanaromart in Chunchon area. SAS 9.1 and Excel 2007 were used as statistical package and ranked logit model was used to analyze the data. From the results of the study the following advertisement strategies were suggested for animal welfare egg considering the effects of advertisement media. First, internet based media were most preferred. For effectively using the internet based media the message should be succinctly and clearly transferred to consumers. Therefore if phrases and pictures emphasizing the difference between animal welfare egg and general egg were used, then positive effects could be attained from consumers in a short period. Second, advertisement media should be used differently based upon the consumers' income level. In the case of consumers under three million won income level the advertisement in the purchasing site was most effective regarding the advertisement effects. Therefore if the advertisement showing the breeding surroundings between animal welfare egg and general egg was used, positive effects could be attained. For consumers over three million won income level the homepage of egg producers was most effective in advertisement. So if more accurate information were distributed to consumers visiting the homepage and high quality egg were sold via the homepage, positive effects could be attained.

Development and Validation of Exposure Models for Construction Industry: Tier 1 Model (건설업 유해화학물질 노출 모델의 개발 및 검증: Tier-1 노출 모델)

  • Kim, Seung Won;Jang, Jiyoung;Kim, Gab Bae
    • Journal of Korean Society of Occupational and Environmental Hygiene
    • /
    • v.24 no.2
    • /
    • pp.208-218
    • /
    • 2014
  • Objectives: The major objective of this study was to develop and validate a tier 1 exposure model utilizing worker exposure monitoring data and characteristics of worker activities routinely performed at construction sites, in order to estimate worker exposures without sampling. Methods: The Registration, Evaluation, Authorization and Restriction of Chemicals(REACH) system of the European Union(EU) allows the usage of exposure models for anticipating chemical exposure of manufacturing workers and consumers. Several exposure models have been developed such as Advanced REACH Tools(ART). The ART model is based on structured subjective assessment model. Using the same framework, a tier 1 exposure model has been developed. Worker activities at construction sites have been analyzed and modifying factors have been assigned for each activity. Korean Occupational Safety and Health Agency(KOSHA) accrued work exposure monitoring data for the last 10 years, which were retrieved and converted into exposure scores. A separate set of sampling data were collected to validate the developed exposure model. These algorithm have been realized on Excel spreadsheet for convenience and easy access. Results: The correlation coefficient of the developed model between exposure scores and monitoring data was 0.36, which is smaller than those of EU models(0.6~0.7). One of the main reasons explaining the discrepancy is poor description on worker activities in KOSHA database. Conclusions: The developed tier 1 exposure model can help industrial hygienists judge whether or not air sampling is required or not.

Bioprocess Development for Production of Alkaline Protease by Bacillus pseudofirmus Mn6 Through Statistical Experimental Designs

  • Abdel-Fattah, Y.R.;El-Enshasy, H.A.;Soliman, N.A.;El-Gendi, H.
    • Journal of Microbiology and Biotechnology
    • /
    • v.19 no.4
    • /
    • pp.378-386
    • /
    • 2009
  • A sequential optimization strategy, based on statistical experimental designs, is employed to enhance the production of alkaline protease by a Bacillus pseudofirmus local isolate. To screen the bioprocess parameters significantly influencing the alkaline protease activity, a 2-level Plackett-Burman design was applied. Among 15 variables tested, the pH, peptone, and incubation time were selected based on their high positive significant effect on the protease activity. A near-optimum medium formulation was then obtained that increased the protease yield by more than 5-fold. Thereafter, the response surface methodology(RSM) was adopted to acquire the best process conditions among the selected variables, where a 3-level Box-Behnken design was utilized to create a polynomial quadratic model correlating the relationship between the three variables and the protease activity. The optimal combination of the major medium constituents for alkaline protease production, evaluated using the nonlinear optimization algorithm of EXCEL-Solver, was as follows: pH of 9.5, 2% peptone, and incubation time of 60 h. The predicted optimum alkaline protease activity was 3,213 U/ml/min, which was 6.4 times the activity with the basal medium.

Mobile Access Network Design (이동통신 액세스망 설계)

  • Kim, Hu-Gon;Paik, Chun-Hyun;Kwon, Jun-Hyuk;Chung, Yong-Joo
    • Korean Management Science Review
    • /
    • v.24 no.2
    • /
    • pp.127-142
    • /
    • 2007
  • This study deals with the optimal design of mobile access network connecting base stations(BSs) and mobile switching centers(MSCs). Generally mobile operators constitute their access networks by leasing communication lines. Using the characteristic of leased line rate based on administration region, we build an optimization model for mobile access network design which has much smaller number of variables than the existing researches. And we develop a GUI based optimization tool integrating the well-known softwares such as MS EXCEL. MS VisualBasic, MS PowerPoint and Ip_solve, a freeware optimization software. Employing the current access network configuration of a Korean mobile carrier, this study using the optimization tool obtain an optimal solution for both single MSC access network and nation-wide access network. Each optimal access network achieves 7.45% and 9.49% save of lease rate, respectively. Considering the monthly charge and total amount of lease line rate, our optimization tool provides big amount of save in network operation cost. Besides the graphical representation of access networks makes the operator easily understand and compare current and optimal access networks.

Development of Power Performance Evaluation System using Modeling Technology (설비 모델링 기술을 이용한 발전성능평가 시스템 구성방안 연구)

  • Lee, Ji-Hoon;Lee, In-tae;Jung, Nam-Joon;Bae, Jung-Seok;An, Young-Mo
    • KEPCO Journal on Electric Power and Energy
    • /
    • v.4 no.2
    • /
    • pp.81-88
    • /
    • 2018
  • Performance evaluation of a plant to efficiently manage and maintain the performance of the plant is a very important procedure. However, since the conventional performance evaluation method is an Excel-based manual method, the preparation procedure is complicated and the versatility is poor. In this paper, we analyze the problems of the existing performance evaluation system, effectively model the equipment, calculate the missing physical properties, and improve the versatility, efficiency and accuracy of the performance evaluation through the equipment modeler which performs automatic index calculation based on this.