• Journal of the Korea Computer Industry Society
• /
• v.10 no.5
• /
• pp.213-220
• /
• 2009

Regression analysis to estimate the fitted models and test hypotheses are basic statistical tools for survey data as well as experimental data. Data is collected as pairs of independent and dependent variables, and statistics are computed using matrix calculation. To estimate a best fitted model is a key to maximize reliability of regression analysis. To fit a regression model, plot data on XY axis and select the most fitted models. Researchers estimate the best model and test hypothesis with MS Excel's graph menu and matrix computation functions. In this study, I develop macros to estimate the fitted regression model and test hypotheses of relationship between variables. Subway electric charges data with one dependent variable and three independent variables are tested using developed macros, and compared with the results using built-in Excel of regression analysis.

• Journal of Korean Society of Water and Wastewater
• /
• v.28 no.6
• /
• pp.735-745
• /
• 2014

This paper presents PKES(PuKyung -Excel based Simulator) for WWTPs(wastewater treatment plants) by using MS Excel and VBA(Visual Basic for Application). PKES is a user-friendly simulator for the design and optimization of the whole plant including biological and physico-chemical processes for the wastewater and sludge treatment. PKES calculates the performance under steady or dynamic state and allows changing the mathematical model by the user. Mathematical model implemented in PKES is a improved integration model based on ASM2d and ADM1 for simulation of AS(activated sludge) and AD(anaerobic digestion). Gaseous components of $N_2$, $N_2O$, $CO_2$ and $CH_4$ are added for estimation of GHGs(greenhouse gases) emission. The simulation results for comparison between PKES and Aquasim(EAWAG) showed about the same effluent concentrations. As a result of verification using by measured data of BOD, TSS, TN and TP for 2 years of operation, calculated effluent concentrations were similar to measured effluent concentrations. The values of average RMSE(root mean square error) were 1.9, 0.8, 1.6 and 0.2 mg/L for BOD, TSS, TN and TP, respectively. Total GHGs emission of WWTP calculated by PKES was 138.5 ton-$CO_2$/day and GHGs emissions of $N_2O$, $CO_2$ and $CH_4$ were calculated at 21.7, 28.9 and 87.9 ton-$CO_2$/day, respectively. GHGs emission of activated sludge was 32.5 % and that of anaerobic digestion was 67.5 %.

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

• Communications of Mathematical Education
• /
• v.35 no.1
• /
• pp.119-136
• /
• 2021

We performed the research and education programs using engineering tools such as Mathematica, Microsoft Excel and GeoGebra for the students in mathematics mentorship program of the institute of science education for the gifted. We used the engineering tools to solve the problems and found the rules by observing the solutions. Then we generalized the rules to theorems by proving the rules. Mathematica, the professional mathematical computation program, was used to calculate and find the length of the repeating portion of the repeating decimal. Microsoft Excel, the spreadsheet software, was used to investigate the Beatty sequences. Also GeoGebra, the dynamic geometric software, was used to investigate the Voronoi diagram and develop the Voronoi game. Using GeoGebra, we designed the Voronoi game plate for the game. In this program, using engineering tools improved the mathematical creativity and the logical thinking of the gifted students in mathematics mentorship program.

• Journal of the Korean Society of Manufacturing Process Engineers
• /
• v.21 no.2
• /
• pp.94-100
• /
• 2022

A study was conducted to significantly increase the heat transfer area by simultaneously burying the excel pipe in the floor and wall of a container house, thereby greatly reducing the initial heating time. In addition, a small hot water boiler suitable for the heating load of a small container house with a maximum area of 6 m² was studied. A wall-mounted hot water boiler was developed as a result of the study. When a hot water boiler is installed outdoors for heating, heat radiation energy is lost in winter from the hot water boiler and hot water pipe due to the low temperature. We propose an approach through which the energy loss was greatly reduced and the temperature of hot water increased in proportion to the operating time. Moreover, as the mass flow rate of the hot water flowing inside the excel pipe increased, the temperature of the hot water decreased. The temperature of the wall and floor surfaces of the container house increased in proportion to the increase in the mass flow rate of hot water flowing inside the excel tube. Natural convection heat transfer was realized from the wall and floor surfaces of the container house, and the heat transfer area was increased by a factor of 3 with respect to heat transfer area limited to the floor by the existing hot water panel. As a result, the initial temperature increase rate was much higher because of the larger heat transfer area.

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

• Journal of Korean Society for Quality Management
• /
• v.36 no.2
• /
• pp.28-35
• /
• 2008

This study deals with an Excel-based scheduling system for a small and medium sized manufacturing factory without sufficient capability for managing full-scale information systems. The factory has the bottleneck with identical machines and unique batching characteristics. The scheduling problem is formulated as a variation of the parallel-machine scheduling system. It can be solved by a two-phase method: the first phase with an ant colony optimization (ACO) heuristic for order grouping and the second phase with a mixed integer programming (MIP) algorithm for scheduling groups on machines.

• Proceedings of the Korean Statistical Society Conference
• /
• 2002.11a
• /
• pp.243-248
• /
• 2002

최근 다변량자료분석과 관련하여 이를 시스템으로 구현하려는 연구가 다양한 각도로 이루어지고 있다. 이러한 연구들의 공통적인 특징은 일반 사용자들에게 고급 통계분석기법을 편리하게 활용할 수 있도록 GUI(Graphical User Interface) 환경의 시스템을 제공해 준 것이다. 이런 연구의 연장선상에서 본 연구에서는 다변량자료분석 시스템을 구현하는데 있어 사회 각 분야에서 가장 널리 활용되고 있는 사무용 프로그램인 마이크로소프트(Microsoft) Excel을 활용하여 일반 사용자들도 다변량분석을 쉽게 활용할 수 있도록 대화식 시스템을 개발하였다.

• Proceedings of the KIEE Conference
• /
• 2006.07d
• /
• pp.1947-1948
• /
• 2006

본 논문에서는 컴퓨터로 정밀 계측기기들을 자동 제어하고 데이터를 측정하기 위하여 기존의 상용 프로그램을 사용하지 않고 Excel VBA(Visual Basic for Applications)를 이용하는 방법에 대하여 연구하였다. 이는 반복측정 및 통계적 수치계산 등에서 많은 장점을 지니고 있어 수많은 국가교정기관 및 일반 산업체에서 유용하게 사용될 수 있으리라 사료된다.

• Journal of the Korea Safety Management & Science
• /
• v.18 no.1
• /
• pp.141-145
• /
• 2016

This study was to improve to utilization of non dosimetry measurements for X-ray radiography. Experiments was passed off varying the X-ray tube voltage and the thickness of the aluminum filter by actual dose. Calculated results was set to the first beam quality factors, calculated first correction coefficient by the Microsoft Excel program was set as the second beam quality factors. To make the non dosimetry measurements simply, the Excel program apply to the new beam quality factors, the error was compared to the previous studies, and the results verify the calculated value of smaller errors.