• Proceedings of the Safety Management and Science Conference
• /
• 2009.04a
• /
• pp.177-183
• /
• 2009

The research develops random ordering methodology of experimental design by the use of nested factor, block factor and repetition types. The spreadsheets developed are useful for quality practioner to acquire the experimental characteristics according to the random ordering.

• Proceedings of the Korean Operations and Management Science Society Conference
• /
• 2003.05a
• /
• pp.637-641
• /
• 2003

최근에 데이터관리, 통계분석, 그래프분석, What-If 분석 등을 위하여 스프레드시트가 광범위하게 사용되고 있다. 본 논문은 전자 부품을 생산하는 라인에 TGC(Theory of Constaints)를 적용하는 과정에서 활용된 엑셀 스프레드시트 프로그램의 사례에 대하여 소개한다. TOC 개념에서의 제품 조합 문제, 제약자원 선택 분석, DBR 스케쥴링 등인 자체의 함수기능, 그래프기능 해찾기 기능과 VBA(Visual Basic Application) 긴능을 이용하여 엑셀에서 구현된 내용이 포함된다.

• Research in Mathematical Education
• /
• v.10 no.1 s.25
• /
• pp.33-47
• /
• 2006

Finding good ways to support the further development of mathematically gifted students is a challenge for all mathematics educators. Simply moving able students on more rapidly to the next level of traditional mathematical instruction seems to be a limited approach, while providing supplementary enrichment material or specialized mathematical software requires us to ensure that doing so is truly worthwhile for the students. This paper presents an approach that the author has used with students of diverse capabilities in both technologically advanced and developing nations investigating mathematical ideas using a spreadsheet.

• Journal of Animal Environmental Science
• /
• v.5 no.3
• /
• pp.197-202
• /
• 1999

퇴비화 재료를 혼합하는 목적은 재료를 퇴비황에 최적조건으로 조성하여 퇴비화 성능을 향상 시키고 취기발생을 억제하기 위함이다. 퇴비화성능에 미치는 요인으로서는 C/N비, 수분 함량, 산도(pH), 산물밀도, 입자크기 등이 있다. 이 중에서 C/N비는 적정값으로 조성하기 어렵다. 본 자료는 퇴비재료의 적정 수분 함량 및 C/N비를 조성하기 위해 각 요소재료의 혼합비율을 제시하고 있다.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.16 no.4
• /
• pp.2338-2343
• /
• 2015

An analytical model was developed in this study and then implemented into a tool for automation of FEA (Finite Element Analysis) of a spindle system for natural frequencies and modes in the universal FEA software, ANSYS. VBA of EXCEL was used for the implementation. It allowed graphic user interfaces (GUIs) to be developed for a user to interact with the tool and, in addition, an EXCEL spreadsheet to be used for data arrangement. A code was developed in the language of ANSYS to generate the geometric model of the spindle system, sequentially to construct the analytical model based on the information in the GUIs, and finally to perform computation for the FEA. Its automation of the model generation and analysis can help to identify a near optimal design of the spindle system under design in minimum time and efforts.

• Journal of Practical Engineering Education
• /
• v.13 no.2
• /
• pp.233-242
• /
• 2021

In this paper, as a liberal arts course for non-majors, we proposed a supervised learning artificial neural network parameter optimization method and a basic education method for activation function to design a basic artificial neural network subject curriculum. For this, a method of finding a parameter optimization solution in a spreadsheet without programming was applied. Through this training method, you can focus on the basic principles of artificial neural network operation and implementation. And, it is possible to increase the interest and educational effect of non-majors through the visualized data of the spreadsheet. The proposed contents consisted of artificial neurons with sigmoid and ReLU activation functions, supervised learning data generation, supervised learning artificial neural network configuration and parameter optimization, supervised learning artificial neural network implementation and performance analysis using spreadsheets, and education satisfaction analysis. In this paper, considering the optimization of negative parameters for the sigmoid neural network and the ReLU neuron artificial neural network, we propose a training method for the four performance analysis results on the parameter optimization of the artificial neural network, and conduct a training satisfaction analysis.

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

• Genomics & Informatics
• /
• v.18 no.2
• /
• pp.19.1-19.6
• /
• 2020

In semantic annotation, semantic concepts are linked to natural language. Semantic annotation helps in boosting the ability to search and access resources and can be used in information retrieval systems to augment the queries from the user. In the research described in this paper, we aimed to identify ontological concepts in scientific text contained in spreadsheets. We developed a tool that can handle various types of spreadsheets. Furthermore, we used the NCBO Annotator API provided by BioPortal to enhance the semantic annotation functionality to cover spreadsheet data. Table2Annotation has strengths in certain criteria such as speed, error handling, and complex concept matching.

• IE interfaces
• /
• v.15 no.3
• /
• pp.279-285
• /
• 2002

A break-even analysis is a method used widely for profit planning or decisions in most companies. It is useful tool in financial studies because it is simple and offers useful insights from a modest amount of data. Although it is widely used, it has some weaknesses. It is limited in particular to the analysis for a short term time horizon or one period. We suggest a new break-even procedure to analyze projects with a long term time horizon as keeping the simplicity of a conventional break-even analysis. We will make efforts doing to include actual data for a cost or an income as much as possible rather than developing a mathematical model to improve unreality of a traditional break-even analysis. Also, we will use the spreadsheet software to solve problems.

• Proceedings of the Korea Water Resources Association Conference
• /
• 1992.07a
• /
• pp.479-489
• /
• 1992

A mathematical model for a long range water supply planning is develoted as a dynamic capacitated facility location problem, in which operation costs and two types of fixed costs are considered. The fixed costs are for water supply systems such as dams and reservoirs and for water conveyance systems of waterways or conduits from each water supply points. A Spreadsheet model is developed to support the efficiency of user interface and to implement a heuristic solution procedure. The proposed solution procedure utilizes SOLVER tool and it has been applied to a system with fictitious data but with reality and applicability in mind. As a result of the mathematical analysis, not only the most economic construction timings of surface water supply facilities and distribution systems but also the most economical water supply operating patterns are identified.