• Korean Journal of Agricultural and Forest Meteorology
• /
• v.20 no.2
• /
• pp.228-232
• /
• 2018

Process-based crop models have been used to assess the impact of climate change on crop production. These models are implemented in procedural or object oriented computer programming languages including FORTRAN, C++, Delphi, Java, which have a stiff learning curve. The requirement for a high level of computer programming is one of barriers for efforts to develop and improve crop models based on biophysical process. In this study, we attempted to develop a Chinese cabbage model using Microsoft Excel with Visual Basic for Application (VBA), which would be easy enough for most agricultural scientists to develop a simple model for crop growth simulation. Results from Soil-Plant-Atmosphere-Research (SPAR) experiments under six temperature conditions were used to determine parameters of the Chinese cabbage model. During a plant growing season in SPAR chambers, numbers of leaves, leaf areas, growth rate of plants were measured six times. Leaf photosynthesis was also measured using LI-6400 Potable Photosynthesis System. Farquhar, von Caemmerer, and Berry (FvCB) model was used to simulate a leaf-level photosynthesis process. A sun/shade model was used to scale up to canopy-level photosynthesis. An Excel add-in, which is a small VBA program to assist crop modeling, was used to implement a Chinese cabbage model under the environment of Excel organizing all of equations into a single set of crop model. The model was able to simulate hourly changes in photosynthesis, growth rate, and other physiological variables using meteorological input data. Estimates and measurements of dry weight obtained from six SPAR chambers were linearly related ($R^2=0.985$). This result indicated that the Excel/VBA can be widely used for many crop scientists to develop crop models.

• Proceedings of the Korean Institute of Information and Commucation Sciences Conference
• /
• 2013.10a
• /
• pp.671-674
• /
• 2013

In this paper, we propose an efficient data search system using data partitioning algorithm in Microsoft Excel. We propose to retrieve the data quickly using VBA functioning Excel. This algorithm is to specify the sheet you are looking for. Once the sheet is specified, it searches the beginning and the end of the data in the sheet. It compares desired key words and intermediate values, starting from the position of the cell. In this way, it will search data to the end. This proposed algorithm was implemented and tested using actual VBA program. The experimental results showed that the performance was more excellent than that of the conventional search method.

• Proceedings of the Korean Society of Surveying, Geodesy, Photogrammetry, and Cartography Conference
• /
• 2003.10a
• /
• pp.211-218
• /
• 2003

The purpose of this study is to analyze the interior orientation, relative orientation, absolute orientation, space intersection, space resection, computing the orientation parameter, 3-dimensional coordinates by using the EXCE for educational purpose.

• Journal of the Korean Data and Information Science Society
• /
• v.16 no.3
• /
• pp.581-589
• /
• 2005

The purpose of this thesis is to develop and introduce Add-in program which we can systematically, visually and dynamically study discrete probability distribution of binomial distribution, poisson distribution and hypergeometric distribution, and continuous probability distribution of normal distribution, exponential distribution, and the definition and characteristics of t distribution, F distribution and ${\chi}^2$ distribution to be driven from normal distribution, and graphs, the computation process of probability by using VBA which is the device of Excel.

• Proceedings of the Korea Concrete Institute Conference
• /
• 1998.10b
• /
• pp.627-632
• /
• 1998

This study developed practical computer program COL2 to design of generic shape reinforced concrete short columns subjected to combined compression and biaxial bending. The program COL2 has been developed for user-friendly environment using Excel 97 for windows 95. Several examples including for analysis of geometrically complex column sections subjected biaxial bending are included in this paper.

• Journal of the Korean Data and Information Science Society
• /
• v.16 no.2
• /
• pp.185-193
• /
• 2005

This study develops and introduces the program for letting learners study statistics in a systematic and efficient way by using Excel tools such as VBA and Macro, when they study statistical inference at two populations. This study helps learners understand the steps on statistical inference at two populations by utilizing the systematic and visual techniques.

• Journal of the Korean Association of Geographic Information Studies
• /
• v.4 no.4
• /
• pp.21-28
• /
• 2001

In this study, GNLP(GIS linked non-linear network analysis program) for pipeline system analysis has been developed. This GNLP gets the input data for pipeline analysis from existing GIS(geographic information system) data automatically, and has GUI(graphic user interface) for user. Non-Linear Method was used for hydraulic analysis of pipe network based on Hazen-Williams equation, and Microsoft Access of relational database management system(RDBMS) was used for the framework of database applied program. GNLP system environment program was improved so that a pipe network designer can input information data for hydraulic analysis of pipeline system more easily than that of existing models. Furthermore this model generate output such as pressure and water quantities in the form of a table and a chart, and also produces output data in Excel file. This model is also able to display data effectively for analysed data confirmation and query function which is the core of GIS program.

• Journal of Korean Society of Industrial and Systems Engineering
• /
• v.40 no.4
• /
• pp.129-136
• /
• 2017

Climate change is the biggest environmental issue of our times. A variety of activities to reduce greenhouse gas emissions have been in progress to observe the Kyoto Protocol. Especially, the Energy Target Scheme is created to reduce greenhouse emission with the supervision of Korean government. This includes Green-house Gas Information Systems to promote activities in the private sector to reduce green-house gas emissions, to cut a cost of energy use, and to reduce GHG emissions. Also, the system has calculated the amount of greenhouse gases. Without any additional investment, 2.75% savings are increased over the previous year. In service sector, a cooperation of customers and employees is necessary. A reduction of GHG emissions requires a proper service organization, considering an amount of investment and payback period. Without any additional investment or replacement, employees can save energy easily turning off ventilation systems an hour before employees' departure, installing timers to turn off water purifiers and vending machines after some period of no use. The Green-house Gas Information System is similar to that of Environmental Management System. However, the Excel is the best program to calculate an amount of green-house gas emissions, and to assess for a reduced amount of GHG emissions. A goal of this research is to propose a practical method in the private sector to calculate an amount of green-house gases. The Green-house gas Information System based on Excel spreadsheet gives standards for good evaluation. The greenhouse gas information system establishes and executes the policies and objectives related to greenhouse gas emissions Similar to ISO 14001 environment management system structures, the advantages of using simplified Excel Sheet for calculating GHG emissions and reducing GHG emissions are easy to access.

• Journal of The Korean Society of Agricultural Engineers
• /
• v.48 no.6
• /
• pp.31-41
• /
• 2006

The analysis used in this work was cost-benefit analysis method. All future costs and returns of a given mushroom house were discounted to the time of initial investment (present) by means of 3.5% discount rate. Then the cost of ownership was compared to the return from the system. This analysis method has been developed and coded into a balance sheet for use on a EXCEL program. Using this programmed analysis,a large number of the case studies were examined using different combinations of economic conditions. These results will be very useful to individuals considering investment in a mushroom house, or any similar production system. By the way of the sensitivity analysis for each important parameter, the change of the marginal cost-benefit period could be finally determined. These parameters were typically construction cost of mushroom house, cost of cooling system, required cooling and heating energy amounts, unit price of mushroom media bottle, growing number of media bottles, production weight per unit bottle, sale price of mushroom, and annual number of growing period, etc.

• Journal of the Ergonomics Society of Korea
• /
• v.32 no.1
• /
• pp.153-158
• /
• 2013

Objective: This study aims to suggest different approaches in analyzing risks associated with musculoskeletal disorders (MSDS) for risk assessment. Background: Upon concluding that the changes in the industrial environments have made it hard to regulate diverse risk factors, the government has implemented a policy for risk assessment. Method: This study has proposed a method, creating programs using Excel that perform qualitative or quantitative analysis, for evaluating risk factors in risk assessments and has applied this in manufacture and service industries. Results: To verify the validity of the developed program, risk assessment has been performed on restaurant chefs as an example. For quantitative evaluation, the study has suggested approaches using the results for REBA evaluation and the analysis report on the work scenes of a fitting-shop in a shipbuilding industry. Application: Constructing and adapting a system using Excel in evaluating risk factors for risk assessments as this study suggests, is expected to contribute to revitalizing risk assessments.