• Title/Summary/Keyword: Excel program

Search Result 240, Processing Time 0.035 seconds

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.

LMR Core Flow Grouping Study

  • Kim, Y. G.;Kim, Y. I.;Kim, . Y. C.
    • Proceedings of the Korean Nuclear Society Conference
    • /
    • 1996.05b
    • /
    • pp.271-276
    • /
    • 1996
  • Coolant flow distribution to the assemblies and core coolant/component temperatures should be determined in LMR core steady state thermal-hydraulic performance analysis. Sodium flow is distributed to core assemblies with the overall goal of equalizing the peak cladding midwall temperatures for the peak temperature pin of each pin bundle, thus pin cladding damage accrual and pin reliability. The flow orificing analysis for conceptual design will be performed with Excel spreadsheet program ORFCE which was set up and tested, using the calibration factors based on available analyses data. For the verification of this program, flow orificing calculation for the MDP 840MWth core was performed. The calculational results are satisfactory compared to those of CRIEPI calculation.

  • PDF

A Simulation Study on the Number of Operators of Automobile Relay Switch Production (자동차 릴레이스 위치 생산공정의 작업자수 선정을 위한 시뮬레이션 연구)

  • 김원경
    • Journal of the Korea Society for Simulation
    • /
    • v.11 no.3
    • /
    • pp.67-77
    • /
    • 2002
  • In this paper, a production process system simulation of the automobile relay switch manufacturing factory is studied. The status of the present production system is inspected first, and the modified model is simulated next. To inspect the effect of the process parameter change, a simulation program is developed using PROMODEL simulation software plus the EXCEL VBA and Active X Automation function. Using the developed simulation program, user can find the best production condition and alternatives on the production capacity, number of workers, and inspection status considering the defective ratio of the product. The feasibility of the new alternatives is compared with the present system using statistical method.

  • PDF

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

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.

Organizational Citizenship Behavior and Performance: The Role of Employee Engagement

  • HERMAWAN, Hermawan;THAMRIN, H.M.;SUSILO, Priyo
    • The Journal of Asian Finance, Economics and Business
    • /
    • v.7 no.12
    • /
    • pp.1089-1097
    • /
    • 2020
  • Nowadays, technology and information are developing rapidly. It compels an organization or a company strive to excel in its field. In the Industrial Revolution 4.0 era, companies must maintain their assets and technology to face the competition. One asset that should be paid attention to is human resources. Human resource has two important variables, namely Organizational Citizenship Behavior (OCB) and Employee Engagement (EE). This study aims to analyze the relationship between OCB and EE on Employee Performance (EP) in the manufacturing industry in Tangerang. This study is conducted using a quantitative method with 200 respondents. The data is collected by distributing questionnaires to respondents, which is then analyzed using Structural Equation Modeling (SEM) with AMOS 23 software. The result of this study indicates that OCB has a significant effect on EE and EP. This study also finds that employee engagement has a significant effect on employee performance and can mediate the relationship between OCB and EP. From these results, the implication that can be taken is that the manufacturing industry in Tangerang must pay attention to their employees for them to develop OCB and EE, and eventually increase their performance towards the organization.

The LAE Burn Strategy Planning for Geostationary Satellite (정지궤도 위성의 LAE Burn Strategy Planning)

  • Kim, Bang-Yeop;Lee, Ho-Hyoung
    • Aerospace Engineering and Technology
    • /
    • v.6 no.2
    • /
    • pp.96-103
    • /
    • 2007
  • A program for LAE (liquid Apogee Engine) firing strategy calculation was developed. This program can be used as the first stage of transfer orbit analysis, which process receives input parameters as like initial orbit elements, ground TT&C stations positions, satellite performances and makes firing user-selectable strategies. The developed program is dedicated to GEO satellites which using LAE generally and it can calculate six back-up strategies and deals situation its maximum firing number is six. The MS-EXCEL software was used for the input and output process. And the numerical calculation part was embodied with MATLAB functions.

  • PDF

Discharge Evaluation Program Development of Anti-surge Valve for FPSO Fuel Gas Compressor System (FPSO 연료가스 압축 시스템용 부정류 방지 밸브의 유량 평가 프로그램 개발)

  • Park, Hyung-Wook;Lee, Seung-Min;Cho, Jong-Rae
    • Journal of the Korean Society for Precision Engineering
    • /
    • v.28 no.12
    • /
    • pp.1411-1418
    • /
    • 2011
  • In this study, to avoid surging in the system as a way to ensure the proper discharge requires the design of the valve capacity rating objective is to develop a program. Approximation algorithm for the capacity evaluation is suggested. Loss coefficients obtained by the algorithm is calculated put in the governing equation for the valve flow coefficient and capacity. Calculated values were compared with numerical analysis results for the verifying their validity. The proven formula is created using Excel and it can be easily available the valve design engineers. Creation of analysis models were using a version of Unigraphics NX 4.0, numerical analysis were using a flow analysis commercial program ANSYS CFX 12.0 version. Equations were referenced 'Handbook of Hydraulic Resistance - 3rd Edition'.

Analytic Hierarchy Process Approach to Estimate Weights of Evaluation Categories for School Food Service Program in Korea (계층적 분석 과정을 이용한 학교급식 운영 품질 평가 분야의 중요도 분석)

  • Lee Min-A;Yang Il-Sun;Yi Bo-Sook;Kim Hyun-Ah;Park So-Hyun
    • Journal of Nutrition and Health
    • /
    • v.39 no.1
    • /
    • pp.74-83
    • /
    • 2006
  • The purposes of this study were to (1) identify the evaluation categories, areas, attributes, and criteria of the school food service program using both a qualitative and a quantitative analyses, (2) define the relative importance of the evaluation categories, areas, attributes, and criteria of the school food service program using analytic hierarchy process, (3) organize the evaluation system to improve quality of the school food service in Korea. A survey was conducted from August to October 2004 to collect data from 172 dietitians, 15 school food service officials at the educational board, 10 professionals of school food service. Statistical analyses were performed on the data utilizing the SPSS 12.0 for Windows and Excel, such as Descriptive statistics and analytic hierarchy process was performed. The result of the analytic hierarchy process indicated that relative importance of evaluation category was 0.4319 (food service manage ment), 0.2369 (nutrition education), 0.1455 (satisfaction) and 0.0912 (parent involvement program). 'Sanitation, safety and facility (0.1739)' was the most important area among the subcategories of food service management, followed by nutrition management (0.1581), procurement (0.1375), production (0.1345), organization and personnel management (0.0662), planning (0.0644), food service evaluation (0.0585), financial accountability (0.0555), and information management (0.0554). There existed a relative importance on the three areas of the nutrition program and satisfaction evaluation category: students (0.5281, 0.6221), parents (0.1812, 0.1491), and teachers (0.1838, 0.1618). In the parent involvement program evaluation category, relative importance of committee and monitoring management was 0.4658 and information communication was 0.3724. The quality of food and service to school children can be improved by the appropriate application of the developed evaluation tool for the school food service program.

A Study on Limesurvey in the Form of Open Source Online Survey System for Curriculum Organizing (학교 교육과정 편성을 위한 오픈 소스 온라인 설문조사 시스템 Limesurvey 활용 방안)

  • Han, Ki-Sun;Chun, Seok-Ju
    • 한국정보교육학회:학술대회논문집
    • /
    • 2011.01a
    • /
    • pp.91-101
    • /
    • 2011
  • The purpose of this paper is to quickly identify school parents, teachers, students, community needs and opinions for curriculum organizing and the implementation of an online survey system for operating educational activities. Online survey system should be implemented based on Limesurvey to reduce costs and administrative costs. Limesurvery is available without the development of the separate program and offers the form of web-based template system, complete design, layout. Also, Limesurvey offers basic statistical analysis of survey data. Limesurvey can be executed by installing the program on a web hosting, typing database information. Limesurvey can be made a graph of the statistical results. Besides, Limesurvery can be stored in the form of HTML, Word, Excel, CSV Files and can be stured as basic datas for SPSS or PASW, R data, other statistical processing programs. If we could be operate Limesurvey in the form of open source-based survey program in elementary school, we could be reduced teacher's unnecessary work for statistics and overcame the problem of offline survey system.

  • PDF