• Journal of Forest and Environmental Science
• /
• v.29 no.4
• /
• pp.307-313
• /
• 2013

Forest Survey consists of road survey, topographic survey, tree mapping survey, stream survey and also ridge survey. Information from forest survey is important and become essential in preparing base map to be used for forest harvesting planning and control. With the current technologies technique of data processing and mapping from traditionally hand drawn method had shifted to a computer system particularly the use of Computer Aided Design (CAD). This gives great advantages to the forest managers and logging operators. However data processing and mapping duration could be further reduced by integrating CAD with other established software such as Microsoft Excel. This time study to show that there is significance difference in term of duration for data processing and efficiency using AutoCAD in combination with Microsoft Excel program as compare to the use of AutoCAD program alone. From the study, it shows that the integration of AutoCAD and Microsoft Excel is able to reduce 70% of duration for data processing and mapping as compared to the use of AutoCAD program alone.

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

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

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

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

• Journal of the Korean Data and Information Science Society
• /
• v.23 no.6
• /
• pp.1203-1212
• /
• 2012

In this paper, we consider the development of round key generator of DES (data encryption standard) based on Microsoft Excel Macro, which was adopted as the FIPS (federal information processing standard) of USA in 1977. Simple introduction to DES is given. Algorithms for round key generator are adapted to excel macro. By repeating the 16 round which is consisted of diffusion (which hide the relation between plain text and cipher text) and the confusion (which hide the relation between cipher key and cipher text) with Microsoft Excel Macro, we can easily get the desired DES round keys.

• Journal of Digital Contents Society
• /
• v.5 no.2
• /
• pp.106-113
• /
• 2004

Once the objective of project is set up to alter the present situation to acertain future situation necessary measures need to be taken to accomplish it. In the past, making a plan and transformation was done in the form of handwork, but this article addresses analyzing and handing the project data by using a tool of Microsoft Office System and then by making a reasonable plan. This system also helps transform project data into Excel data and analyze it using Excel, and transform project data into xml data and construct xml database so that it makes it possible to handle and use data efficiently, and to set up automatic project system in the future which leads to efficient project management.

• The Korean Journal of Applied Statistics
• /
• v.17 no.1
• /
• pp.165-172
• /
• 2004

Recently, there have been several studies to develop the multivariate data analysis system which can be readily used. The common characteristic of these studies is to develop the GUI system to which advanced statistical methods can be conveniently applied. In an extension of these studies, this study aims to supply users in various fields an interactive system with the convenience of the environment of GUI, which is constructed with the Excel macro and VBA, to apply multivariate data analysis methods easily. This system provides a graphic-oriented and menu-centered user interface in the Microsoft Excel which is widely used spreadsheet and analysis program.

• Journal of the Korea Society of Computer and Information
• /
• v.3 no.2
• /
• pp.239-246
• /
• 1998

As the complexity of organizations grow, the practice of accounting necessarily becomes more and more sophisticated. As a result, accounting is becoming increasingly dependent upon computers to facilitate the interaction of measurement analysis, and reporting that is so essential in business today. Enhancements in technology-in particular, the development of computer technology-have dramatically altered the practice of accounting. This study represents a new approach in technology-based education and contains how to use Microsoft Excel 97 In preparing general ledger.

• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.18 no.1
• /
• pp.217-222
• /
• 2014

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

• Journal of Wetlands Research
• /
• v.18 no.3
• /
• pp.226-231
• /
• 2016

Land Generated Waste Load Unit(LGWLU) estimation based on land use data is required to understand the impact of land use on water quality. The method of estimating LGWLU based on the monitoring data requires a lot of time and manpower. In this study, we propose a method of land pollution unit load estimation based on land use data with LP optimization. Optimization is the process to obtain the best possible optimal solution in a given condition. This study carried out optimization by using excel solver in Microsoft Excel. This study derived LGWLU of BOD, T-N, T-P in Gongju-Si and Seocheon-Gun by using the 2012 land use map made by ministry of environment based on 2010 satellite image. This study about LGWLU estimation is expected to be able to determine more clearly the water pollution caused by land use changes.