• 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).

• Journal of the Korean Society of Manufacturing Process Engineers
• /
• v.14 no.2
• /
• pp.127-133
• /
• 2015

In this study, an analytical model was developed for one-dimensional finite element analysis (1D FEA) of a spindle system of machine tools and then implemented to automate the FEA as a tool. FEA, with its vibration characteristics such as natural frequencies and modes, was performed using the universal FEA software ANSYS. VBA of EXCEL was used to provide the programming environment for its implementation. This enabled graphic user interfaces (GUIs) to be developed to allow interactions of users with the tool and, in addition, an EXCEL spreadsheet to be linked with the tool for data arrangement. The language of ANSYS was used to develop a code to perform the FEA. It generates an analytical model of the spindle system based on the information at the GUIs and subsequently performs the FEA based on the model. Automation helps identify the near-optimal design of the spindle system with minimum time and efforts.

• Advances in environmental research
• /
• v.7 no.1
• /
• pp.29-37
• /
• 2018

A simple mathematical model for predicting fixed bed adsorption dynamics is described. The model is characterized by a linear adsorption isotherm and a linear driving force expression for mass transfer. Its analytic solution can be approximated with an algebraic equation in closed form which is easily evaluated by spreadsheet computation. To demonstrate one application of the fixed bed model, a previously published adsorption system is used as a case study in this work. The adsorption system examined here describes chromium breakthrough in a fixed bed adsorber packed with imidazole functionalized adsorbent particles and is characterized by a nonlinear adsorption isotherm. However, the equilibrium behavior of the fixed bed adsorber is in essence governed by a linear adsorption isotherm due to the use of a low influent chromium concentration. It is shown that chromium breakthrough is predicted reasonably well by the fixed bed model. The model's parameters can be easily extracted from independent batch experiments. The proposed modeling approach is very simple and rapid, and only Excel is used for computation.

• Journal of Food Hygiene and Safety
• /
• v.28 no.1
• /
• pp.36-40
• /
• 2013

This study was performed to determine the ranking foods and related foodborne pathogens for the impact of climate change, e.g., increasing temperature, on microbiological food safety. To do this, we developed an impact-ranking model comprising an Excel spreadsheet by using Risk Ranger. Because of a lack of data, input values in this model were determined on the basis of an expert's opinion. These values also were converted to normal distribution, and the developed model was simulated using @RISK. In conclusion, the 5 superior ranking foods and related foodborne pathogens for climate change impact were as follows: ready-to-eat foods (RTE) (Staphylococcus aureus, Salmonella spp., and Escherichia coli O157:H7); bread and rice cakes (S. aureus and Bacillus cereus); meat and egg products (Salmonella spp., E. coli O157:H7, and S. aureus); tofu (bean curds) and jellies (B. cereus, E. coli O157:H7, and S. aureus); and fish products (S. aureus, Vibrio spp., and E. coli O157:H7).

• The Journal of Information Systems
• /
• v.20 no.1
• /
• pp.107-126
• /
• 2011

Model-based decision support system (DSS) has acted as a crucial role in strengthening the business competitiveness by providing a way of modeling and solving real-world decision problems in a quantitative and scientific manner. It is even more important for trading OTC derivatives, which requires extensive financial-engineering expertise while actively reacting to the continuously changing financial market. This paper proposes a flexible model-based DSS architecture that can support user-friendly interface for executing and analyzing the models and can adapt to the changes of financial market seamlessly. For user-friendliness, we implement the user-interfaces (UIs) using Microsoft Excel, a very widely used spreadsheet program for its great generality and extensibility. Users can utilize the analysis results of DSS or reprocess them for their special needs through the UIs in the form of familiar spreadsheets easily. For adaptiveness to the markets, the proposed architecture is constructed based on the object-oriented concepts, which enables such changes as release of a new financial product can be updated into the system without any delay at the lowest cost. We investigate the practical benefits and limitations of the proposed architecture by a case study on the construction of Model-based Trading Support System (MTSS), performed by a commercial bank in Korea.

• 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.

• Food Science of Animal Resources
• /
• v.32 no.1
• /
• pp.118-124
• /
• 2012

This study was conducted for quantitative microbial risk assessment (QMRA) of Clostridium perfringens with consumption on ham and sausage products in Korea, according to Codex guidelines. Frame-work model as product-retail-consumption pathway composed with initial contamination level, the time and temperature in distributions, and consumption data sets for ham and sausage products and also used the published predictive growth and dose-response models for Cl. perfringens. The simulation model and formulas with Microsoft@ Excel spreadsheet program using these data sets was developed and simulated with @RISK. The probability of foodborne disease by Cl. perfringens with consumption of the ham and sausage products per person per day was estimated as $3.97{\times}10^{-11}{\pm}1.80{\times}10^{-9}$. There were also noted that limitations in this study and suggestion for development of QMRA in the future in Korea.

• Coupled systems mechanics
• /
• v.2 no.1
• /
• pp.23-51
• /
• 2013

An analytical algorithm for the estimation of the resistance forces exerted on the dipper of a cable shovel and the specific energy consumed in the cutting-loading process is presented. Forces due to payload and to cutting of geomaterials under given initial conditions, cutting trajectory of the bucket, bucket's design, and geomaterial properties are analytically computed. The excavation process has been modeled by means of a kinematical shovel model, as well as of dynamic payload and cutting resistance models. For the calculation of the cutting forces, a logsandwich passive failure mechanism of the geomaterial is considered, as has been found by considering that a slip surface propagates like a mixed mode crack. Subsequently, the Upper-Bound theorem of Limit Analysis Theory is applied for the approximate calculation of the maximum reacting forces exerted on the dipper of the cable shovel. This algorithm has been implemented into an Excel$^{TM}$ spreadsheet to facilitate user-friendly, "transparent" calculations and built-in data analysis techniques. Its use is demonstrated with a realistic application of a medium-sized shovel. It was found, among others, that the specific energy of cutting exhibits a size effect, such that it decreases as the (-1)-power of the cutting depth for the considered example application.

• Korean Business Review
• /
• v.20 no.1
• /
• pp.105-122
• /
• 2007

This paper identifies the dimensions of political risk on the basis of the classification between risk and uncertainties to implement the precise identification and assessment of the various types of political risk and develop the sound assessment model to accomplish their practical applications. This paper shows the concrete and detailed processes of deriving the assessment models and applying them with the microsoft excel spreadsheet, confirms the result of Butler and Joaquin(1998), and presents the methods of identifying the various combination effects of the political risk impact and the covariance relationship with the market portfolio return through the sensitivity analysis.

• 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.