Buildability Detailed Design and Implementation Plan with ARCHICAD + Excel

It is a requirement in Singapore to produce and submit color coded floor plans with tabulation of walls that shows legends, buildability types (BType), lengths, labor saving index (LSIndex) and buildability score (BScore). As we are doing it in BIM we can add part 3D models showing the floor as well. As part of ARCHICAD’s OPEN BIM approach the team have developed a very good inter-operable solution with Excel. Let us see how to do this with ARCHICAD + Excel.

Please refer to the code of practice (COP) at http://www.bca.gov.sg/BuildableDesign/others/copbdnov2015.pdf for Singapore’s buildability score requirements and the related terms.

Highlighting Elements by Properties

This is a best option to color code the elements in floor plans. We will be using Mark-Up Tools to achieve this step. Create mark-up styles for each wall type in Table 2 of COP. Please read through Sandor’s blog https://asiabim.wordpress.com/2016/02/03/highlighting-elements-by-properties-part-1/ to understand how to highlight elements by properties in ARCHICAD 19. Highlight with mark-up based on building materials. This can be applied to the 3D view as well. Please prepare the views (plan and 3D) and save it in the view map for later use.

build01.png

Create new Parameters for LSIndex and BType

We will be using ARCHICAD’s IFC Scheme setup to create the new parameters and enter the values later in the elements.

  1. Go to File/File Special/IFC 2×3/IFC Scheme Setup…
  2. Select IfcCurtainWall
  3. Click New Property / Classification…
  4. Choose Custom IFC Property and define the following
  • Property Set name: Pset_BScore – we are adding this especially for BScore
  • Property name: BType
  • Property type: Single Value
  • Value type: IfcLabel
  1. Click OK.

build02

Repeat the steps 3 to 5 with the following values

  • Property Set name: Pset_BScore
  • Property name: LSIndex
  • Property type: Single Value
  • Value type: IfcReal

build03

Repeat the above steps for IfcWall

  1. Click OK.

build04

Assign Values for the Parameters

Use the mark up tool to select the elements and assign values for the parameters. Go to the plan view and activate Mark-Up Tools from Document/Mark-up Tools.

  1. Select the mark-up entry.
  2. Click on the Select Elements button, the elements will be selected in the plan on earlier assignment.
  3. Click on Settings Dialog
  4. Go to Tags and Categories
  5. Enter values for BType and LSIndex. Refer to Buildability COP’s Table 2 for values.
  6. Click OK.

build05

Repeat the steps for the rest of the wall types.

Create a Schedule for BScore

Create a schedule that lists BType, Length, Ratio to Grand Total in percentage, LSIndex and BScore.

Note: Refer to http://helpcenter.graphisoft.com/guides/archicad-19-int-reference-guide/views-of-the-virtual-building-3/archicad-model-views/interactive-schedule/define-a-schedule-using-scheme-settings/# on how to create a new schedule using Scheme Settings.

  1. Set the Criteria as Element Type is Wall or Element Type is Curtain Wall as the schedule include both walls and curtain walls.
  2. Add the following Fields as shown in the Scheme Settings below:
  • Home Storey – Wall’s parameter.
  • BType – IFC Properties, need to click on the arrow next to the .. button below to access IFC Properties. Click on the cell below the flag to group the schedule by BType.
  • Length of Reference Line – Wall’s parameter.
  • Length – Curtain Wall’s parameter.
  • Ratio to Grand Total – Custom text, this will be populated in Excel.
  • LSIndex – IFC Properties.
  • BScore – Custom text, this will be populated in Excel.

build06

Click OK to close the Scheme Settings and see the schedule. Go to File/Save as… and choose to save the schedule as Excel file.

build07

Format in Excel

  1. Change the cells color to follow the color code used in the floor plan.
  2. Use formula to copy the above cells value – =B8
  3. Remove the unit m and change the cell to number.
  4. Remove the unit m and change the cell to number.
  5. Add the previous two cells – =D9+C9
  6. Ratio to Grand Total is in percentage of wall’s length to the overall wall’s length in the project (Note: in this sample we are doing it only for one floor) – =(E9/E36)*100. Cell E9 is the length of the wall and E36 has the total length of walls in the floor (In the actual it should be the total wall length of the project).
  7. Use formula to copy the above cells value – =G8
  8. Calculate BScore for Cast in-situ RC wall with skim coat – =G9*F9. G9 is LSIndex and F9 is Ratio of wall length to overall wall length in percentage.

Repeat this steps to the rest of the wall types.

build08

Get the Table Ready

Hide all the unnecessary rows and columns and get the table ready to transfer back to ARCHICAD.

build09

Compile the Layout

Compile the views (plan and 3D views saved in view map earlier) into a layout.

build10

  1. Select the entire table in Excel
  2. Copy it to clipboard
  3. Paste in ARCHICAD as Single Figure and
  4. Adjust it to the correct size.

build11

Let us see with another blog on an inter-operable (OPEN BIM) solution soon.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s