• Proceedings of the Korean Information Science Society Conference
• /
• 2008.06c
• /
• pp.21-25
• /
• 2008

온라인 분석 처리(On-Line Analytical Processing: OLAP)은 데이터 웨어하우스로부터 다차원 데이터를 분석하거나 의사 결정을 위한 유용한 정보를 제공하고 있다. 데이터 분석을 위해, OLAP에서는 다차원 데이터를 표현한 스프레드시트(spreadsheet) 또는 피벗 테이블(PIVOT table)을 널리 사용하고 있다. 스프레드시트와 피벗 테이블은 서로 유사한 형태로써 분석의 기준이 되는 애트리뷰트들이 많은 구조이다. 사용자들은 흔히 사용되고 있는 SQL 구문을 이용하여 스프레드시트 또는 피벗 테이블에서 손쉬운 데이터 분석을 요구한다. 그러나, RDBMS에서 제공하는 SQL 구문의 사용으로, 이는 다차원 데이터를 효과적으로 분석할 수 없다. 그 이유는 SQL 구문이 다양한 데이터 분석의 목적으로 사용되거나, 요약된 집계 정보를 도출하는 데 한계가 있기 때문이다. 따라서, 본 연구에서는 SQL 구문을 확장하여 다차원 데이터를 표현한 스프레드시트를 손쉽게 조작하고, 요약된 집계를 계산하는 셀(cell) 구문을 제안한다. 이 방법은 스프레드시트와 피벗 테이블에서 행과 열이 교차하는 좌표(coordinate)를 이용하여, 특정 셀의 조작 및 선택한 부분/전체 영역에 대한 집계 정보를 계산하는 방법이다. 결과적으로, RDBMS에서 사용되는 SQL 구문이 친숙한 사용자들이 제안한 셀 구문을 이용하면, 다양한 관점에 따라 손쉽게 스프레드시트와 피벗 테이블을 다룰 수 있을 것으로 사료된다.

• Journal of Nuclear Fuel Cycle and Waste Technology(JNFCWT)
• /
• v.4 no.4
• /
• pp.353-363
• /
• 2006

In order to evaluate the potential radiological risks for the reuse of the site after decommissioning of nuclear facilities, a mathematical model was developed and materialized into the Microsoft $Excel{\circledR}$ spreadsheets frame. A set of input parameter values was proposed, which is useful in the preliminary risk screening step before the detailed evaluation with the site-specific data. It appeared that the screening levels calculated by the present model was agreed with the derived concentration guideline limits resulted from RESRAD Ver.6.2 and the German dose criteria for releasing a nuclear site from regulatory control.

• Journal of the Institute of Electronics Engineers of Korea CI
• /
• v.42 no.6
• /
• pp.11-18
• /
• 2005

In this paper, English pronunciation system and the methods of its notations which is used in the internet web sites or in electronic English dictionaries are analyzed and new font table and its key layout are presented to input it efficiently. By using this method, English pronunciation can be inputted to the spreadsheets, databases and presentations as well as word-processors, and each application program's data can have compatibility. Furthermore, it can have compatibility within another type of computers and increase inputting speed. In the result of experiments, every data can have the compatibility in all of application programs and inputting speed is increased highly compare with using the pre-existing functions of word-processors.

• Journal of the Korean Solar Energy Society
• /
• v.27 no.1
• /
• pp.19-27
• /
• 2007

The Data quality management system(DQMS) organizes and helps manage and process time sequence data usually collected in monitoring networks and programs. DQMS places particular emphasis on data qualify while maintaining a highly organized and convenient structure for data. It operates with in a flexible and powerful commercial relational data base environment which can readily link to other software platforms from local spreadsheets to network server. The Korea Institute of Energy Research(KIER) has been solar radiation data since May, 1991 for 16 different locations. KIER's new data is expected to be extensively used by designer and researchers of solar systems in lieu of unreliable old ones. Unfortunately, the quality of the data has not always been properly mentioned. The purpose of this study is to systematically identify errors in such data set using DQMS in an effort to rehabilitate error-ridden old data. DET successfully uncovered solar radiation data that had questionable quality.

• Computers and Concrete
• /
• v.25 no.4
• /
• pp.327-341
• /
• 2020

Advanced forms of structural design (e.g., displacement-based methods) require knowledge of the non-linear force-displacement behavior of both the overall building and individual lateral load resisting elements, i.e., walls or building cores. Similarly, understanding the non-linear behaviour of the elements in a structure can also allow for a less conservative structural response to be calculated by better understanding the cracked (i.e., effective) properties of the various RC elements. Calculating the non-linear response of an RC section typically involves using 'black box' analysis packages, wherein the user may not be in complete control nor be aware of all the intricate settings and/or decisions behind the scenes. This paper introduces a user-friendly and transparent analysis program for predicting the back-bone force displacement behavior of slender (i.e., flexure controlled) RC walls, building cores or columns. The program has been validated and benchmarked theoretically against both commonly available and widely used analysis packages and experimentally against a database of 16 large-scale RC wall test specimens. The program, which is called WHAM, is written using Microsoft Excel spreadsheets to promote transparency and allow users to further develop or modify to suit individual requirements. The program is available free-of-charge and is intended to be used as an educational tool for structural designers, researchers or students.

• Journal of The Korean Association of Information Education
• /
• v.23 no.1
• /
• pp.29-38
• /
• 2019

The purpose of this study was threefold: to design and develop a smart teaching and learning system based on flipped learning for elementary subject matter education; to apply the system to the elementary classroom; and to examine the effects of the system on students' achievement and satisfaction levels. The system was composed of a video part, a date part, and a learning line part. Presentations, preinstructional videos, and spreadsheets were created for the flipped classroom. The results of the analyses indicated that the teaching and learning system positively influenced students' achievement and satisfaction levels. The study concluded with the implications of the study and suggestions for the future study.

• International conference on construction engineering and project management
• /
• 2005.10a
• /
• pp.1181-1186
• /
• 2005

In many construction projects, progress and efficiency are hampered by poor communication of discipline-specific models. For example, architects use 2D or 3D CAD models and builders use CPM diagrams, Gantt charts, and spreadsheets to show their view of the project. Nowadays, advanced computer visualization tools, 4D CAD or VR, can show these disparate models to understand cross-disciplinary impacts of design and construction decisions. In Korea, several leading companies have tried to apply these tools to their pilot projects from the design phase to the maintenance phase. These companies have expected that more project stakeholders could understand a construction schedule more quickly and completely with 4D visualization than with the traditional construction management tools. However, modeling of the 4D CAD or VR can be quite time-consuming and expensive to generate manually and has therefore limited the spread and use of these models. In order to adopt widely those models in construction industry, the areas that those tools could support to take large benefits in diverse functional areas of construction management need to be analyzed. In this study, researchers analyze the usefulness and limitations of the 4D models and VR in the construction industry, develop the strategy of application priority, and improve the 4D modeling method.

• International conference on construction engineering and project management
• /
• 2013.01a
• /
• pp.243-251
• /
• 2013

Cash management is a major concern for all contractors in the construction industry. It is arguable that cash is the most critical resource of all. A contractor needs to secure sufficient funds to navigate the project to the end, while keeping an eye on maximizing profits along the way. Past research attempted to address such topic via developing models to tackle the time-cost tradeoff problem, cash flow forecasting, and cash flow management. Yet, little was done to integrate the three aspects of cash management together. This paper, as such, presents a comprehensive model that integrates the time-cost tradeoff problem, cash flow management, and cash flow forecasting. First, the model determines the project optimal completion time by considering the different alternative construction methods available for executing project activities. Second, it investigates different funding alternatives and proposes a project-level cash management plan. Two funding alternatives are considered; they are borrowing and company own financing. The model was built as a combinatorial optimization model that utilizes ant colony search capabilities. The model also utilizes Microsoft Project software and spreadsheets to maintain an environment that incorporates activities, their durations, and other project data, in order to estimate project completion time and cost. Ant Colony Optimization algorithm was coded as a Macro program using VBA. Finally, an example project was used to test the developed model, where it acted reliably in maximizing the contractor's profit in the test project.

• Korean Journal of Construction Engineering and Management
• /
• v.25 no.5
• /
• pp.63-72
• /
• 2024

This study aimed to address the issue that about 92% of domestic BIM orders only focus on the design/drafting stage and the absence of government BIM implementation guidelines for maintainers. Despite the ability of BIM to reduce maintenance LCC by around 20%, such guidelines remain insufficient. In this study, we examined the COBie requirements by comparing 45 maintenance information and Autodesk Revit (2022) inputs with COBie data. As a consequence, the necessary elements correlated with 54 pieces of data across eight spreadsheets (Contact, Space, Type, Component, System, Spare, Job, Document) and there were 13 gaps in information between the construction and maintenance. These were subsequently integrated into the ontology and their associations were evaluated with the Reasoner tool. From the results inferred, it is apparent that the COBie requirements have a correlation with one another. It is essential to carry out a survey among practitioners and a pilot operation to assess performance in the future. This research is anticipated to furnish pivotal data for the implementation of an effective property upkeep system.

• Journal of the Institute of Electronics Engineers of Korea CI
• /
• v.43 no.4 s.310
• /
• pp.31-38
• /
• 2006

In this paper, the inputting method of english pronunciation for a computer by the combining diacritical mark is studied. English pronunciation system and the methods of its notations are investigated and conditions to input english pronunciations easily are analysed. Therefore, the inputting method which can input 3, 4-level stress as well as 2-level stress is presented. By using this method, English pronunciation can be inputted to the spreadsheets, databases and presentations as well as word-processors, and each application program's data can have compatibility. In the result of experiments, every data can have the compatibility in all of application programs and inputting speed is increased highly compare with using the individual vowel method which has high speed than using the pre-existing functions of word processors.