• Title/Summary/Keyword: Excel automation

Search Result 22, Processing Time 0.016 seconds

A Study on Implementation of 4D and 5D Support Algorithm Using BIM Attribute Information - Focused on Process Simulation and Quantity Calculation - (BIM 속성정보를 활용한 4D, 5D 설계 지원 알고리즘 구현 및 검증에 관한 연구 - 공정시뮬레이션과 물량산출을 중심으로 -)

  • Jeong, Jae-Won;Seo, Ji-Hyo;Park, Hye-Jin;Choo, Seung-Yeon
    • Journal of the Regional Association of Architectural Institute of Korea
    • /
    • v.21 no.4
    • /
    • pp.15-26
    • /
    • 2019
  • In recent years, researchers are increasingly trying to use BIM-based 3D models for BIM nD design such as 4D (3D + Time) and 5D (4D + Cost). However, there are still many problems in efficiently using process management based on the BIM information created at each design stage. Therefore, this study proposes a method to automate 4D and 5D design support in each design stage by using BIM-based Dynamo algorithm. To do this, I implemented an algorithm that can automatically input the process information needed for 4D and 5D by using Revit's Add-in program, Dynamo. In order to support the 4D design, the algorithm was created to enable automatic process simulation by synchronizing process simulation information (Excel file) through the Navisworks program, BIM software. The algorithm was created to automatically enable process simulation. And to support the 5D design, the algorithm was developed to enable automatic extraction of the information needed for mass production from the BIM model by utilizing the dynamo algorithm. Therefore, in order to verify the 4D and 5D design support algorithms, we verified the applicability through consultation with related workers and experts. As a result, it has been demonstrated that it is possible to manage information about process information and to quickly extract information from design and design changes. In addition, BIM data can be used to manage and input the necessary process information in 4D and 5D, which is advantageous for shortening construction time and cost. This study will make it easy to improve design quality and manage design information, and will be the foundation for future building automation research.

Automation of Information Extraction from IFC-BIM for Indoor Air Quality Certification (IFC-BIM을 활용한 실내공기질 인증 요구정보 생성 자동화)

  • Hong, Simheee;Yeo, Changjae;Yu, Jungho
    • Korean Journal of Construction Engineering and Management
    • /
    • v.18 no.3
    • /
    • pp.63-73
    • /
    • 2017
  • In contemporary society, it is increasingly common to spend more time indoors. As such, there is a continually growing desire to build comfortable and safe indoor environments. Along with this trend, however, there are some serious indoor-environment challenges, such as the quality of indoor air and Sick House Syndrome. To address these concerns the government implements various systems to supervise and manage indoor environments. For example, green building certification is now compulsory for public buildings. There are three categories of green building certification related to indoor air in Korea: Health-Friendly Housing Construction Standards, Green Standard for Energy & Environmental Design(G-SEED), and Indoor Air Certification. The first two types of certification, Health-Friendly Housing Construction Standards and G-SEED, evaluate data in a drawing plan. In comparison, the Indoor Air Certification evaluates measured data. The certification using data from a drawing requires a considerable amount of time compared to other work. A 2D tool needs to be employed to measure the area manually. Thus, this study proposes an automatic assessment process using a Building Information Modeling(BIM) model based on 3D data. This process, using open source Industry Foundation Classes(IFC), exports data for the certification system, and extracts the data to create an Excel sheet for the certification. This is expected to improve the work process and reduce the workload associated with evaluating indoor air conditions.