• Title/Summary/Keyword: Spreadsheet Simulation

Search Result 22, Processing Time 0.025 seconds

Planned Depot Maintenance Interval Decision for Unmanned Aerial Vehicle through Reliability and Maintainability Based Simulation and Operating & Support Cost Analysis (신뢰도 및 정비도 기반 시뮬레이션과 운영유지 비용분석을 통한 무인항공기의 계획창정비 주기결정)

  • Sang Yeob Lee;Jun Hyun Son
    • Journal of Aerospace System Engineering
    • /
    • v.17 no.5
    • /
    • pp.1-10
    • /
    • 2023
  • This research sought to determine the optimal cycle of Planned Depot Maintenance (PDM) for Unmanned Aerial Vehicle (UAV), and PDM through Reliability and Maintainability-based simulation and Operating and Support (O&S) cost analysis using Reliability and Maintainability analysis results. The effectiveness of the PDM was verified economically, and the optimal PDM interval that balances UAV effective operations and sustaining engineering costs was presented.

Predicting the shear strength of reinforced concrete beams using Artificial Neural Networks

  • Asteris, Panagiotis G.;Armaghani, Danial J.;Hatzigeorgiou, George D.;Karayannis, Chris G.;Pilakoutas, Kypros
    • Computers and Concrete
    • /
    • v.24 no.5
    • /
    • pp.469-488
    • /
    • 2019
  • In this research study, the artificial neural networks approach is used to estimate the ultimate shear capacity of reinforced concrete beams with transverse reinforcement. More specifically, surrogate approaches, such as artificial neural network models, have been examined for predicting the shear capacity of concrete beams, based on experimental test results available in the pertinent literature. The comparison of the predicted values with the corresponding experimental ones, as well as with available formulas from previous research studies or code provisions highlight the ability of artificial neural networks to evaluate the shear capacity of reinforced concrete beams in a trustworthy and effective manner. Furthermore, for the first time, the (quantitative) values of weights for the proposed neural network model, are provided, so that the proposed model can be readily implemented in a spreadsheet and accessible to everyone interested in the procedure of simulation.

Evaluation of Factors Related to Productivity and Yield Estimation Based on Growth Characteristics and Growing Degree Days in Highland Kimchi Cabbage (고랭지배추 생산성 관련요인 평가 및 생육량과 생육도일에 의한 수량예측)

  • Kim, Ki-Deog;Suh, Jong-Taek;Lee, Jong-Nam;Yoo, Dong-Lim;Kwon, Min;Hong, Soon-Choon
    • Horticultural Science & Technology
    • /
    • v.33 no.6
    • /
    • pp.911-922
    • /
    • 2015
  • This study was carried out to evaluate growth characteristics of Kimchi cabbage cultivated in various highland areas, and to create a predicting model for the production of highland Kimchi cabbage based on the growth parameters and climatic elements. Regression model for the estimation of head weight was designed with non-destructive measured growth variables (NDGV) such as leaf length (LL), leaf width (LW), head height (HH), head width (HW), and growing degree days (GDD), which was $y=6897.5-3.57{\times}GDD-136{\times}LW+116{\times}PH+155{\times}HH-423{\times}HW+0.28{\times}HH{\times}HW{\times}HW$, ($r^2=0.989$), and was improved by using compensation terms such as the ratio (LW estimated with GDD/measured LW ), leaf growth rate by soil moisture, and relative growth rate of leaf during drought period. In addition, we proposed Excel spreadsheet model for simulation of yield prediction of highland Kimchi cabbage. This Excel spreadsheet was composed four different sheets; growth data sheet measured at famer's field, daily average temperature data sheet for calculating GDD, soil moisture content data sheet for evaluating the soil water effect on leaf growth, and equation sheet for simulating the estimation of production. This Excel spreadsheet model can be practically used for predicting the production of highland Kimchi cabbage, which was calculated by (acreage of cultivation) ${\times}$ (number of plants) ${\times}$ (head weight estimated with growth variables and GDD) ${\times}$ (compensation terms derived relationship of GDD and growth by soil moisture) ${\times}$ (marketable head rate).

Spreadsheet Model Approach for Buffer-Sharing Fork-Join Production Systems with General Processing Times and Structure (일반 공정시간과 구조를 갖는 버퍼 공유 분기-접합 생산시스템의 스프레드시트 모형 분석)

  • Seo, Dong-Won
    • Journal of the Korea Society for Simulation
    • /
    • v.28 no.3
    • /
    • pp.65-74
    • /
    • 2019
  • For many years, it has been widely studied on fork-join production systems but there is not much literature focusing on the finite buffer(s) of either individuals or shared, and generally distributed processing times. Usually, it is difficult to handle finite buffer(s) through a standard queueing theoretical approach. In this study, by using the max-plus algebraic approach we studied buffer-shared fork-join production systems with general processing times. However, because it cannot provide proper computational ways for performance measures, we developed simulation models using @RISK software and the expressions derived from max-plus algebra. From the simulation experiments, we compared some properties on waiting time with respect to a buffer capacity under two blocking policies: BBS (Blocking Before Service) and BAS (Blocking After Service).

Spreadsheet Model Approach for Buffer-Sharing Line Production Systems with General Processing Times (일반 공정시간을 갖는 버퍼 공유 라인 생산시스템의 스프레드시트 모형 분석)

  • Seo, Dong-Won
    • Journal of the Korea Society for Simulation
    • /
    • v.28 no.2
    • /
    • pp.119-129
    • /
    • 2019
  • Although line production systems with finite buffers have been studied over several decades, except for some special cases there are no explicit expressions for system performances such as waiting times(or response time) and blocking probability. Recently, a max-plus algebraic approach for buffer-sharing systems with constant processing times was introduced and it can lead to analytic expressions for (higher) moment and tail probability of stationary waiting. Theoretically this approach can be applied to general processing times, but it cannot give a proper way for computing performance measures. To this end, in this study we developed simulation models using @RISK software and the expressions derived from max-plus algebra, and computed and compared blocking probability, waiting time (or response time) with respect to two blocking policies: communication(BBS: Blocking Before Service) and production(BAS: Blocking After Service). Moreover, an optimization problem which determines the minimum shared-buffer capacity satisfying a predetermined QoS(quality of service) is also considered.

ESTIMATION OF LONG-TERM POLLUTANT REMOVAL EFFICIENCIES OF WET RETENTION/DETENTION BASINS USING THE WEANES MODEL

  • Youn, Chi-Hyueon;Pandit, Ashok;Cho, Han-Bum
    • Proceedings of the Korea Water Resources Association Conference
    • /
    • 2005.05b
    • /
    • pp.215-219
    • /
    • 2005
  • A macro spreadsheet model, WEANES (Wet Pond Annual Efficiency Simulation Model), has been developed to predict the long-term or annual removal efficiencies of wet retention/detention basins. The model uses historical, site-specific, multi-year, rainfall data, usually available from a nearby National Oceanic and Atmospheric Administration (NOAA) climatological station to estimate basin efficiencies which are calculated based on annual mass loads. Other required input parameters are: 1) watershed parameters; drainage area, pervious curve number, directly connected impervious area, and ti me of concentration, 2) pond parameters; control and overflow elevations, pond side slopes, surface areas at control elevation and pond bottom; 3) outlet structure parameters; 4) pollutant event mean concentrations; and 5) pond loss rate which is defined as the net loss due to evaporation, infiltration and water reuse. The model offers default options for parameters such as pollutant event mean concentrations and pond loss rate. The model can serve as a design, planning, and permitting tool for consulting engineers, planners and government regulators.

  • PDF

Dynamic Behavioral Prediction of Escherichia coli Using a Visual Programming Environment (비쥬얼 프로그래밍 환경을 이용한 Escherichia coli의 동적 거동 예측)

  • Lee, Sung-Gun;Hwang, Kyu-Suk;Kim, Cheol-Min
    • Proceedings of the Korean Society for Bioinformatics Conference
    • /
    • 2004.11a
    • /
    • pp.39-49
    • /
    • 2004
  • When there is a lack of detailed kinetic information, dFBA(dynamic flux balance analysis) has correctly predicted cellular behavior under given environmental conditions with FBA and different ial equations. However, until now, dFBA has centered on substrate concentration, cell growth, and gene on/off, but a detailed hierarchical structure of a regulatory network has not been taken into account. For this reason, the dFBA has limited the represen tation of interactions between specific regulatory proteins and genes and the whole transcriptional regulation mechanism with environmental change. Moreover, to calculate optimal metabolic flux distribution which maximizes the growth flux and predict the b ehavior of cell system, linear programming package(LINDO) and spreadsheet package(EXCEL) have been used simultaneously. thses two software package have limited in the visual representation of simulation results and it can be difficult for a user to look at the effects of changing inputs to the models. Here, we descirbes the construction of hierarchical regulatory network with defined symbolsand the development of an integrated system that can predict the total control mechanism of regulatory elements (opero ns, genes, effectors, etc.), substrate concentration, growth rate, and optimal flux distribution with time. All programming procedures were accoplished in a visual programming environment (LabVIEW).

  • PDF

Evaluation of Operations Performance of Agricultural Products Supply Chain Using ROIC Tree (ROIC 나무를 이용한 농산물 공급망의 운영 성과 평가)

  • Min, Choon-Ki;Chang, Byeong-Yun
    • Journal of the Korea Society for Simulation
    • /
    • v.23 no.4
    • /
    • pp.121-129
    • /
    • 2014
  • The importance of evaluation of farming performance has been increasing with the progress of farm size and capitalization, and with the introduction of the concept of the 6th industry to agriculture. In this research, ROIC(Return on Invested Capital) tree technique was examined as a new method for analyzing operations performance of supply chain for farm produce. Current practices of production and distribution of blueberry, model crop, were investigated and ROIC tree for blueberry has been set up from the survey of the supply chain. Then, it was simulated with real values collected from the participants in the supply chain and the previous studies using a spreadsheet program. The resulting ROIC value was compared with those of other industries and the conventional performance analysis method. Features of the evaluation technique were identified and it was proposed how to apply it to agricultural field in the future.

Simulation of the Best Management Practice Impacts on Nonpoint Source Pollutant Reduction in Agricultural Area using STEPL WEB Model (STEPL WEB 모형을 이용한 농촌지역 비점오염원저감 대책 모의)

  • Park, Youn Shik;Kum, Dong Hyuk;Jung, Young Hun;Cho, Ja Pil;Lim, Kyoung Jae;Kim, Ki Sung
    • Journal of The Korean Society of Agricultural Engineers
    • /
    • v.56 no.5
    • /
    • pp.21-27
    • /
    • 2014
  • Sediment-laden water is problematic in aquatic ecosystem and for hydraulic structures in a watershed, and agriculture area in a watershed is one of source areas of nonpoint source (NPS), since soil surface typically exposures due to agricultural activities. Especially, severe sediment might flow into stream when agricultural area is located near stream like the Imha-dam watershed. Soil erosion is affected by precipitation, therefore there is a need to consider precipitation characteristics in soil erosion and best management practices (BMPs) simulation. The Web-based Spreadsheet Tool for the Estimation of Pollutant Load (STEPL WEB) allows estimating long-term sediment loads and the impact of best management practices to reduce sediment loads. STEPL WEB and predicted precipitation data by MIROC-ESM model was used to estimate sediment loads and its reduction by filter strip and conversion of agricultural area to forest in the future 30 years. The result indicates that approximately 70 % of agricultural area requires filter strip installation or that approximately 50 % of agricultural area needs to be converted to forest, for 41 % of sediment load reduction.

Construction of an Educational Computer Model for FAB of Semiconductor Manufacturing (반도체 웨이퍼 가공(FAD) 공정에서의 교육용 컴퓨터 모델 구축)

  • Jeon, Dong-Hoon;Lee, Chil-Gee
    • Journal of KIISE:Computing Practices and Letters
    • /
    • v.6 no.3
    • /
    • pp.311-318
    • /
    • 2000
  • The importance of the semiconductor industry in Korea has been growing, but the manufacturers are experiencing two major problems: poor optimization of production and low localization ratio of production equipments. Due to the complex manufacturing processes and special features such as OTD (On Time Delivery) and LIPAS (Line Item Performance Against Schedule) possibilities, several attempts to apply MRP or spreadsheet have been failed to meet the expectations. This paper describes the computer modeling technique as the solutions to analyze the problem, to formalize the semiconductor manufacturing process, and to build an advanced manufacturing environments. The computer simulation models are built referring the FAB facilities of the National Inter - University Semiconductor Research Center to show the FAB processes and the functions of each process.

  • PDF