• Computers and Concrete
• /
• v.8 no.1
• /
• pp.43-57
• /
• 2011

Force-deformation modelling of cracked reinforced concrete is essential for a displacement-based seismic assessment of structures and can be achieved by fibre-element analysis of the cross-section of the major lateral resisting elements. The non-linear moment curvature relationship obtained from fibre-element analysis takes into account the significant effects of axial pre-compression and contributions by the longitudinal reinforcement. Whilst some specialised analysis packages possess the capability of incorporating fibre-elements into the modelling (e.g., RESPONSE 2000), implementation of the analysis on EXCEL is illustrated in this paper. The outcome of the analysis is the moment-curvature relationship of the wall cross-section, curvature at yield and at damage control limit states specified by the user. Few software platforms can compete with EXCEL in terms of its transparencies, versatility and familiarity to the computer users. The program has the capability of handling arbitrary cross-sections that are without an axis of symmetry. Application of the program is illustrated with examples of typical cross-sections of structural walls. The calculated limiting curvature for the considered cross-sections were used to construct displacement profiles up the height of the wall for comparison with the seismically induced displacement demand.

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

• The Journal of the Institute of Internet, Broadcasting and Communication
• /
• v.17 no.1
• /
• pp.183-190
• /
• 2017

Recently, BIM (Building Information Modeling) has been attracting attention as a next-generation architectural design tool. The strength of BIM technology is that it enables collaborative work and it is shared in real time. The Revit program, an architectural design program for BIM technology, enhances the information input side, making it possible to know the information of components at the design stage. However, in the use of the Revit program, it is impossible to share or reuse a family created by one designer with another designer. In order to overcome this inefficiency, we designed the design drawing as an Excel file and made it easy to create.

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

• Proceedings of the KSR Conference
• /
• 2010.06a
• /
• pp.1630-1641
• /
• 2010

LCC can be defined as "the sum of present values of investment costs, capital costs, installation costs, energy costs, operating costs, maintenance costs, and disposal costs over the life-time of the project, product, or measure." LCCA involves estimating the costs and timing associated with each alternative over a selected analysis period and conversion of those costs to economically comparable values considering the time-value of money. The several Excel-Based LCC tools found on the internet are described in this paper. Also, This paper performed an analysis of the existing LCC commercial tools, assessing various aspects of each program. The goal was to evaluate the best features of each tool and to identify the requirements for LCC evaluation of Urban Transit Vehicle. The LCC tools are developed to address problems in many different areas and a tool developed and structured for one area cannot generally be used in another area. No general LCC tool exists and if one is needed for Urban Transit Vehicle it has to be developed by the project. Since a full LCC can be very complex it is likely that this Excel-Based LCC tool should be a small and simple tool for quick cost estimates. This paper presents a LCC tool consisting of eight excel sheets, which are "Project", "CBS", "PBS", "PM", "CM", "Others", "LCC Result" and "Diagram".

• Journal of The Korean Association of Information Education
• /
• v.13 no.3
• /
• pp.325-339
• /
• 2009

Many current researches are limited in the statistics field, which is a part of mathematics class in the secondary school. Moreover, it's hard to apply to the elementary school since they are written in English. To overcome this limitations, the objectives from the unit that is suitable for using EXCEL in the elementary mathematics lessons are selected in this research. And a problem-based learning model for these lessons would be introduced that it can help students to focus on solving substances of the problems by reducing the time for arithmetic calculation.

• Proceedings of the Korean Geotechical Society Conference
• /
• 2009.03a
• /
• pp.1113-1124
• /
• 2009

The limit equilibrium method and finite element method have been commonly used to assess the stability of anchored slope. However, the existing limit equilibrium methods do not consider the load transfer of anchor and, if the potential failure surface crosses the bonded zone of anchors, the anchor loads are not included in computing the factor of safety. In this paper, simplified bishop method, one among several methods based on the limit equilibrium is used to develope the Excel Sheet program and the working load of anchor along the failure surface is calculated by Flamant's formula, proposed by Morlier and Tenier(1982). Additionally, the finite element analysis of anchored slope considering the load transfer is performed in order to compare with the result from the limit equilibrium analysis and analyze the reinforced effect of anchor. From this study, new modelling method that limits the reinforcing range and considers the load transfer is proposed and Excel Sheet program is developed. The factor of safety for several cases between PC STABL and Excel Sheet program is also compared for verification of the program.

• Journal of The Korean Society of Agricultural Engineers
• /
• v.53 no.4
• /
• pp.11-19
• /
• 2011

PADDIMOD2 was deloped to estimate nonpoint source pollution from paddy rice fields. The PADDIMOD2 was enhanced to estimate runoff and pollutant load during non-growing as well as growing season and to be easily used for public by development of Excel based system. Nutrient concentration and hydrology were based on Dirac delta function and continuous source function, and tank model for growing season and Event Mean Concentrations (EMCs) and SCS-Curve Number method for non-growing season. The PADDIMOD2 consists of three main component (input data, parameters data, and output data) by including eight Excel spread sheets. As a result of model application, total precipitation and irrigation were 1,051.7 mm and 439.2 mm, respectivley and surface runoff and water loss including infiltration and evapotranspiration were 463.0 mm and 947.9 mm, respectively. Annual nutrient loadings of T-N and T-P from study area were 6.7 kg/$km^2$/day and 0.5 kg/$km^2$/day, respectively. Development of PADDIMOD2 was focused on minimizing input data and maximizing user friendly system and is expected to be useful tool to evaluate various non-structure BMPs and estimate unit load from paddy rice fields for application at Korean TMDL.

• Journal of the Korean Data and Information Science Society
• /
• v.25 no.6
• /
• pp.1419-1429
• /
• 2014

In this paper, we consider the development of encryption of DES (data encryption standard) based on Microsoft Excel Macro, which was adopted as the FIPS (federal information processing standard) 46 of USA in 1977. Concrete explanation of DES is given. Algorithms for DES encryption 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 Excel Macro, we can easily get the desired DES cipher text.

• Transactions of the KSME C: Technology and Education
• /
• v.2 no.1
• /
• pp.21-28
• /
• 2014

As one of the most famous spreadsheet programs that is widely applied to a variety of fields in business, MS Excel has also been used for educational purposes due to its feature of wide accessibility, enabling students to use the program through almost any kind of PC that now exists. The program is mainly used for numerical analysis and formulae applications in the fields of science and engineering. This paper shall provide the key to understanding the application of MS Excel to teaching Statics through the illustration of its essential functions for education. Also, the development process of the analysis program using macros and VBA(Visual Basic for Applications) is described for the deeper comprehension of advanced applications. Students were not only able to solve the Statics problems using basic features of MS Excel, but also discovered new systematic methods of approaching complex problems and developed application programs using macros and VBA.