• Title/Summary/Keyword: excel based model

Search Result 86, Processing Time 0.024 seconds

Structural Optimization for LMTT-Mover Using the Kriging Based Approximation Model (크리깅 근사모델 모델을 이용한 LMTT 이동체의 구조최적설계)

  • Lee, Kwon-Hee;Park, Hyung-Wook;Han, Dong-Seop;Han, Geun-Jo
    • Proceedings of the Korean Institute of Navigation and Port Research Conference
    • /
    • v.29 no.1
    • /
    • pp.385-390
    • /
    • 2005
  • LMTT (Linear Motor-based Transfer Techn-ology) is a horizontal transfer system for the yard automation, which has been proposed to take the place of AGV (Automated Guided Vehicle) in the maritime container terminal. The system is based on PLMSL (Permanent Magnetic Linear Synchronous Motor) that consists of stator modules on the rail and shuttle car. It is desirable to reduce the weight of LMTT in order to control the electronic devices with minimum energy. In this research, the DACE modeling, known as the one of Kriging interpolation, is introduced to obtain the surrogate approximation model of the structural responses. Then, the GRG(Generalized Reduced Gradient) method built in Excel is adopted to determine the optimum. The objective function is set up as weight. On the contrary, the design variables are considered as transverse, longitudinal and wheel beam's thicknesses, and the constraints are the maximum stresses generated by four loading conditions.

  • PDF

Structural Optimization for LMTT-Mover Using Sequential Kriging Based Approximation Model (순차적 크리깅 근사모델을 이용한 LMTT 이송체의 구조최적설계)

  • Park Hyung Wook;Han Dong Seop;Lee Kwon Hee;Han Geun Jo
    • Proceedings of the Korean Institute of Navigation and Port Research Conference
    • /
    • 2005.10a
    • /
    • pp.289-295
    • /
    • 2005
  • LMTT (Linear Motor-based Transfer Techn-ology) is a horizontal transfer system for the yard automation This system is based on PMLSM (Permanent Magnetic Linear Synchronous Motor) toot consists of stator modules on the rail and shuttle car. In this research, the kriging interpolation method with sequential sampling find the optimum design of mover in LMTT. The design variables are considered as the transverse, longitudinal and wheel beam's thicknesses. The objective function is set up as weight, while the constant function are set up as the stresses generated by four loading conditions. The objective function is set up as weight. The optimum results obtained by the suggested method are compared with those by the GENESIS.

  • PDF

Investigation of H model blended e-learning technique in enhanced effectiveness of class learning (대학 강의실 수업의 효과성 향상을 위한 H형 블렌디드 이러닝 적용 효과 분석)

  • Choi, Byongsu;Yoo, Sang-Mi
    • The Journal of Korean Association of Computer Education
    • /
    • v.16 no.3
    • /
    • pp.49-60
    • /
    • 2013
  • This study is aimed to investigate that the blended e-learning could enhance the effectiveness compared to the conventional lecture performed in classroom. At first, both the CbE(Class based E-learning) and the EbC(E-learning based Class) mode have been generated in blended e-learning operation method following the process which analyze the various studies of interest. In addition, the instruction structures of Z Type(Zigzag model) and H-Type(Ladder model) were established as proposed model. The H-Blended e-learning based on CbE mode was introduced in the Excel Spread Sheet subject which held in A University to achieve the goal of this study. Learners were categorized and belonged to either the group 1(over 50% of attendance in cyber lecture) or the group 2(the rest of them). The data analysis was performed with $x^2$-test, t -test to compare the achievement of study between groups. The t -test result showed that the academic achievement in learning with group 1 was statistically significant than the learner in group 2. The effectiveness of the blended e-learning has been proved as the logistic regression analysis showed that the rate of the attendance in the cyber lecture functioned as indicator that enable to predict the acceptance.

  • PDF

Estimation of the Gastric Cancer Incidence in Tehran by Two-Source Capture-recapture

  • Aghaei, Abbas;Ahmadi-Jouibari, Toraj;Baiki, Omid;Mosavi-Jarrahi, Alireza
    • Asian Pacific Journal of Cancer Prevention
    • /
    • v.14 no.2
    • /
    • pp.673-677
    • /
    • 2013
  • Introduction: Capture-recapture methods have been suggested for reducing costs of disease registration as well as reducing bias in incidence estimations. This study aimed to estimate the gastric cancer incidence in the Tehran metropolis population during 2002-2006. Materials and Methods: We investigated new cases of gastric cancer reported by three sources; death certificates, pathology reports, and medical records to Tehran population-based cancer registry during 2002-2006. $G^2$ statistics and the two-source capture-recapture method were used to select the best-fitted log-linear model and to estimate incidence, respectively. EXCEL software version 2007 and SPSS software version 16 were used for this research. Results: The number of reported cases was 4,463, with an average age of 68.5 (${\pm}12.9$) years. We found the model that combined two sources of data including pathology reports and medical records and furthermore complemented by death certificates as the best model. The reported and the estimated incidences were 11.0 and 27.1 per 100,000 respectively. Conclusions: The incidence estimated by two-source capture-recapture method is about three times higher than the incidence reported by the sources under investigation. It is recommended to move towards the implementation of population-based cancer registration using various sources of data collection to achieve more accurate data.

Development of Optimum PAC Dose Prediction Program using $^{14}C$-radiolabled MIB and HSDM ($^{14}C$-radiolabeled MIB와 HSDM을 이용한 최적 PAC 투입량 예측프로그램의 개발)

  • Kim, Young-Il;Bae, Byung-Uk;Kim, Kyu-Hyoung;Hong, Hyun-Su;Westerhoff, Paul
    • Journal of Korean Society of Environmental Engineers
    • /
    • v.27 no.10
    • /
    • pp.1123-1128
    • /
    • 2005
  • NIB(methylisoborneol) is an earthy/musty odor compound produced as a second metabolite by cyanobacteria and actinomycetes. MIB is not removed by conventional water treatment(coagulation, sedimentation, filtration) and its presence in tap water, even at low ng/L levels, can result in consumer complaints. PAC(powdered activated carbon) can effectively remove MIB when the correct dose is applied. But, since most operators in water treatment plants apply a PAC dose and then adjust that dose depending on direct observation (odor detection) after treatment, the result is often under-dose or eve,-dose. In this study, kinetic and isotherm tests using $^{14}C$-radiolabeled MIB were performed to determine coefficients for the HSDM(homogeneous surface diffusion model), including liquid film mass transfer coefficient($K_f$) and surface diffusion coefficient ($D_s$). The HSDM gave a reasonable fit and allowed prediction with the experimental data. Base on the HSDM, the authors developed an optimum PAC dose prediction program using the Excel spreadsheet. When the developed program was applied at two water treatment plants, the PAC dose based on the experience of operators in the water treatment plant was significantly different from that recommended by the newly developed program. If operators are willing to use the optimum PAC dose prediction program, it should solve dosing problems.

The apartments model house bathroom chatacteristics of plane composition classified by 'pyeong' on Seoul (서울지역 아파트 모델하우스 욕실의 평형대별 평면구성)

  • Chung, Hoe-Jin;Shin, Kyung-Joo
    • Proceedings of the Korean Institute of Interior Design Conference
    • /
    • 2004.05a
    • /
    • pp.123-126
    • /
    • 2004
  • This study aims to identify the change of bathroom design characteristics through the investigation of bathroom space in apartment model houses. The bathroom space of each private exclusive area was analyzed from the plane characteristics perspective such as quantity, location, size and shape. For this study, site survey and observation was performed to analyze the characteristics of plane and design based on twenty seven model houses of seven large-sized construction firms with Seoul area focused on. Research object was restricted to from ten Pyeong's apartment to sixty Pyeong's in order to understand various characteristics of twenty seven model houses. Since analysis variables were not diverse, the main three factors - frequency, percentage and an average - were represented in Microsoft Excel worksheet, focusing on the quantity of each case, design characteristics and pattern. 1) The quantity of bathrooms: It was turned out that the quantity of bathroom was one in ten Pyeong's apartment while it was two in thirty, forty, and fifty Pyeong's apartment. There were mostly two bathrooms available in twenty Pyeong's apartment even if only one was planned in few cases. All powder rooms and dress rooms in twenty and fifty Pyeong's apartment were designed to be separated and be accessible through bedroom. 2) The size of bathrooms: As private exclusive area increased, the size of bathroom for both family and couple increased. Couple bathrooms had the tendency to be equipped with shower booth and bathtub at the same place or have more tubs than family bathrooms because couple bathrooms were bigger than family bathrooms. 3) The location of bathrooms: Couple bathrooms were usually located beyond dress rooms or powder rooms while family bathrooms were mostly located at the entrance side. 4) The shape of bathrooms: Shower booth was assumed to be in general vogue because family bathrooms, for the most part, were comprised of a flush toilet, a washstand and a shower booth. In the case of couple bathrooms, a flush toilet, a washstand, a shower booth and a tub were generally equipped in more than twenty Pyeong's apartments while a tub was not installed in twenty Pyeong's apartments.

  • PDF

A Study on the Health Index Based on Degradation Patterns in Time Series Data Using ProphetNet Model (ProphetNet 모델을 활용한 시계열 데이터의 열화 패턴 기반 Health Index 연구)

  • Sun-Ju Won;Yong Soo Kim
    • Journal of Korean Society of Industrial and Systems Engineering
    • /
    • v.46 no.3
    • /
    • pp.123-138
    • /
    • 2023
  • The Fourth Industrial Revolution and sensor technology have led to increased utilization of sensor data. In our modern society, data complexity is rising, and the extraction of valuable information has become crucial with the rapid changes in information technology (IT). Recurrent neural networks (RNN) and long short-term memory (LSTM) models have shown remarkable performance in natural language processing (NLP) and time series prediction. Consequently, there is a strong expectation that models excelling in NLP will also excel in time series prediction. However, current research on Transformer models for time series prediction remains limited. Traditional RNN and LSTM models have demonstrated superior performance compared to Transformers in big data analysis. Nevertheless, with continuous advancements in Transformer models, such as GPT-2 (Generative Pre-trained Transformer 2) and ProphetNet, they have gained attention in the field of time series prediction. This study aims to evaluate the classification performance and interval prediction of remaining useful life (RUL) using an advanced Transformer model. The performance of each model will be utilized to establish a health index (HI) for cutting blades, enabling real-time monitoring of machine health. The results are expected to provide valuable insights for machine monitoring, evaluation, and management, confirming the effectiveness of advanced Transformer models in time series analysis when applied in industrial settings.

A Blended Model of Web-based learning and Peer tutoring for improving the Scholastic achievements (학업성취도 향상을 위한 웹기반 학습과 동료 교수법의 혼합 모델)

  • Lee, YunKyung;Kim, JuGyun
    • The Journal of Korean Association of Computer Education
    • /
    • v.11 no.6
    • /
    • pp.11-27
    • /
    • 2008
  • Though web-based learning is known to be effective for computer aided practical class, it lacks in cooperative human feedback and self-adjustment. This paper presented the effects of blended learning that was based on web-based learning for learning by level and blended with peer tutoring for reducing the differentials of scholastic achievements between the students. For experimental purpose, high school students were divided into two groups and web-based EXCEL tutoring tool was developed and applied to both groups in advance. After this learning, we applied the web-based learning for comparative group as before and peer tutoring for experimental group respectively, Performance result evaluated by SPSS showed that the Blended Learning has affirmative effect in scholastic achievements. Especially, students under the medium level of experimental group could narrow the gap to the high level students in its group and this eventually improved the overall achievements of experimental group with blended learning.

  • PDF

Arabic Words Extraction and Character Recognition from Picturesque Image Macros with Enhanced VGG-16 based Model Functionality Using Neural Networks

  • Ayed Ahmad Hamdan Al-Radaideh;Mohd Shafry bin Mohd Rahim;Wad Ghaban;Majdi Bsoul;Shahid Kamal;Naveed Abbas
    • KSII Transactions on Internet and Information Systems (TIIS)
    • /
    • v.17 no.7
    • /
    • pp.1807-1822
    • /
    • 2023
  • Innovation and rapid increased functionality in user friendly smartphones has encouraged shutterbugs to have picturesque image macros while in work environment or during travel. Formal signboards are placed with marketing objectives and are enriched with text for attracting people. Extracting and recognition of the text from natural images is an emerging research issue and needs consideration. When compared to conventional optical character recognition (OCR), the complex background, implicit noise, lighting, and orientation of these scenic text photos make this problem more difficult. Arabic language text scene extraction and recognition adds a number of complications and difficulties. The method described in this paper uses a two-phase methodology to extract Arabic text and word boundaries awareness from scenic images with varying text orientations. The first stage uses a convolution autoencoder, and the second uses Arabic Character Segmentation (ACS), which is followed by traditional two-layer neural networks for recognition. This study presents the way that how can an Arabic training and synthetic dataset be created for exemplify the superimposed text in different scene images. For this purpose a dataset of size 10K of cropped images has been created in the detection phase wherein Arabic text was found and 127k Arabic character dataset for the recognition phase. The phase-1 labels were generated from an Arabic corpus of quotes and sentences, which consists of 15kquotes and sentences. This study ensures that Arabic Word Awareness Region Detection (AWARD) approach with high flexibility in identifying complex Arabic text scene images, such as texts that are arbitrarily oriented, curved, or deformed, is used to detect these texts. Our research after experimentations shows that the system has a 91.8% word segmentation accuracy and a 94.2% character recognition accuracy. We believe in the future that the researchers will excel in the field of image processing while treating text images to improve or reduce noise by processing scene images in any language by enhancing the functionality of VGG-16 based model using Neural Networks.

Structural Design of a Front Lower Control Arm Considering Durability (내구성을 고려한 하부 컨트롤 암의 구조설계)

  • Park, Han-Seok;Kim, Jong-Kyu;Seo, Sun-Min;Lee, Kwon-Hee;Park, Young-Chul
    • Journal of the Korean Society of Manufacturing Process Engineers
    • /
    • v.8 no.4
    • /
    • pp.69-75
    • /
    • 2009
  • Recently developed automotive components are getting lighter providing a higher fuel efficiency and performance. Following the current trend, this study proposes a structural optimization method for the lower control arm installed at the front side of a Vehicle. Lightweight design of lower control arm can be achieved through design and material technology. In this research, the shape of lower control arm was determined by applying the optimization technology and aluminum was selected as a steel-substitute material. Strength performance is the most important design requirement in the structural design of a control arm. This study considers the static strength in the optimization process. For the optimum design, the durability analysis is performed to predict its fatigue life. In this study, the kriging interpolation method is adopted to obtain the minimum weight satisfying the strength constraint. Optimum designs are obtained by the in-house program, EXCEL-Kriging. Also, based on the optimum model obtained for the static strength, the optimization of Index of Fatigue Durability is carried out to get th optimum fatigue performance.

  • PDF