INSIGHTS

2020.07.30

R&D WORKS Vol. 14

Excel-linked BIM system

Making BIM more accessible.

R&D WORKS TOP

BIM (Building Information Modeling) is architectural modeling data that comprehensively includes all information about a building, such as design, structure, and facilities. It has a future goal of utilizing centralized information from design to post-construction operation and management. In design and construction, it contributes to visualizing the information of shapes and materials and sharing the image, but there are still major challenges in dynamic analysis of facilities and structures, and collaboration across fields. Software for analysis, calculation, and cost estimation, and methods for sharing information between fields are still insufficient. To solve this, we are developing a practical system that uses Excel, a well-known software already used in various processes, as an intermediate medium for data.

Information system based on general-purpose software Excel (Mitsubishi Jisho Design 's BIM utilization policy)

The challenge with BIM is sharing information between software

A building that has completed BIM retains all the information that makes up the building, such as the structure, finishes, materials, and equipment, making it possible to create a digital workflow for a series of steps, from various design processes to subsequent construction and MEP Engineering and Structural Engineering. The reason for this is that the information specifications between the modeling software and the analysis software do not mesh. In the end, the current situation is that the model is manually recreated in the analysis software each time, and it is not a workflow that can be called BIM.

Characteristics of data held by BIM

BIM data is characterized by its structured nature. For example, equipment such as air conditioners has individual information such as size, which is separate from larger information such as belonging to the air conditioning equipment. By structuring all information as variables, for example, equipment with the same shape can be organized into a series based on differences in performance and collectively organized into information, or conversely, it can be given an identity within a complex 3D model. In addition, the fine details of architecture have small unevenness and take a huge amount of time to process, which is inconvenient for capturing global characteristics such as airflow analysis. However, in addition to precise shape data, the structured information of BIM actually contains data that can extract simple shapes. The structured information itself is complex and vast, and it is inefficient to handle it as it is. We need to take advantage of these characteristics and come up with a system to extract and share the necessary information.

Design Scheme

An Excel-based system that removes the barriers to BIM

These issues have led to a major misunderstanding that complex and huge amounts of information and special software that can handle them are required. In order to resolve these issues and misunderstandings, we are building a system that allows Excel to coexist as BIM. In reality, any information medium should be fine. The reasons we chose Excel are as follows:

● High demand as a business tool
Excel is often used in our design work, such as for tallying up areas, technical calculations such as ventilation, and cost estimation. Because of the high demand, most people should be able to use Excel.

●Excel import/export function
Excel has built-in data input/output functions such as CSV and XML. Even software that is not so-called "BIM compatible" often has such data input/output functions, and Excel acts as a bridge between them.

- By visualizing various information, development and design speed can be accelerated.
The biggest problem with directly linking software to each other is the data format. If the formats are different, you cannot proceed without deciphering the structure. Therefore, by first visualizing the information required for linking from the 3D model in a simple form in Excel as a common format and sharing it, concurrent development is realized. It also makes it easier to adapt to calculation documents and BIM modeling technology used in the conventional design process, improving the design process. By combining it with the airflow analysis system jointly developed in parallel, it was confirmed that the workflow, which previously took more than a day, was dramatically shortened.

Development of technology to speed up design based on BIM utilization policy
BIM workflow demo video [2 minutes 30 seconds]

Excel-linked BIM system

Development | Mitsubishi Jisho Design Inc.

OTHER WORKS

R&D WORKS Vol.26

JAPAN SPORT OLYMPIC SQUARE ──Manual natural ventilation system

A rich environment can be created by opening and closing the windows by hand.

R&D WORKS Vol.25

JAPAN SPORT OLYMPIC SQUARE ──Wave-shaped slit louvers

An architectural envelope that controls shading and daylighting.

R&D WORKS Vol.24

Renovation of Otemachi Building /100-Year Building facade Edition

Familiar buildings reflect the character of the street.

R&D WORKS Vol.23

SUSTIE—ZEB-related technology demonstration building

Energy saving, health and comfort,
This is an office prototype that takes both to the next level.

R&D WORKS Vol.22

Nagomuma restroom

A refreshing office toilet.

R&D WORKS Vol.21

MELRemo-IPS — Air conditioning location detection system

Share worker location information with everyone.

R&D WORKS Vol.20

Katsuki Medical Building

The floors of the building turn into terraces.

R&D WORKS Vol.19

Gas-permeable membrane ventilation system SEPERNA®

Gas exchange reduces ventilation load.

R&D WORKS Vol.18

Sunshine Aquarium "Jellyfish Panorama"

The floors of the building are enveloped in a sea of jellyfish.

R&D WORKS Vol.17

Zero Traffic Ward
The first hospital building in Japan to be registered as a design

Guardian/A reassuring ward where care is given to patients.

R&D WORKS Vol.16

Coil washable fan coil unit

Wash the concealed air conditioner.

R&D WORKS Vol.15

SMAHOLODEO

A simple MR object using a smartphone.

R&D WORKS Vol.14

Excel-linked BIM system

Making BIM more accessible.

R&D WORKS Vol.13

Smart City Vision for the Otemachi, Marunouchi and Yurakucho Areas

Making people's "movement" smart and walkable

R&D WORKS Vol.12

CLT relocation and reconstruction structural system

A relocatable wooden structure made using CLT.

R&D WORKS Vol.11

CLT floor structure system

The floors of mid- to high-rise buildings will be made of wood.

R&D WORKS Vol.10

Louver free-fitting system

Wavy ceiling louvers.

R&D WORKS Vol.09

Rail lighting

An illuminated train runs through the curtain wall.

R&D WORKS Vol.08

Curtain Wall Sloped Back Panel

Show/Don't show
Switchable 2-way facade.

R&D WORKS Vol.07

MyRemo BLE Smartphone control system for multi-air conditioning systems for buildings

Office air conditioning that can be controlled from your smartphone.

R&D WORKS Vol.06

Highly efficient core rod vibration control system

Vibration control technology that uses a core rod to increase efficiency.

R&D WORKS Vol.05

Next Generation Ambient Lighting

Sensory performance required for lighting fixture design
Improves the "sense of brightness."

R&D WORKS Vol.04

CLT hybrid structure office

A warm, mid-rise wooden office

R&D WORKS Vol.03

Air-Soarer: A constant air speed device that realizes a variable air volume Coanda air conditioning system

An amazing technique that delivers air by crawling along the ceiling.

R&D WORKS Vol.02

Task Desk

One unit per person. The idea of personal air conditioning.

R&D WORKS Vol.01

NF System - Closed Water Spray Equipment Commercialized: 2015

Parking lot fire contained with water alone.
R&D TOP

Update : 2019.01.17

Tags

PAGE TOP