Menu
LCA och Kostnadskontroll
  • About
  • Road map
  • Changelist
  • Lexicon
  • Contact
LCA och Kostnadskontroll

Normalizing

August 22, 2019October 2, 2019

As we process one more time our data last week we realised that the way the information was gathered from the models was not normalized and, in order to compile and manipulate the data between workbook we needed that the type of data and the titles were the same throughout all the worksheet. We analysed what we had already and question the reasons for each and come up with a new set of normalized header for each category.

General information

  • Element
  • Quantity
  • Total area
  • Average_A/Unit
  • Average_A/Building block
  • Average_A/Staircases

Other Rooms

  • Element
  • Quantity
  • Average_Q/Building block
  • Average_Q/Staircases
  • Total area
  • Average_A/Unit
  • Average_A/Building block
  • Average_A/Staircases

Average of apartment types

  • Element
  • Quantity
  • Total area
  • Average_A/Unit
  • Average_A/Different types of rooms

Beams

  • Element
  • Quantity
  • Average_Q/Building block
  • Average_Q/Staircases
  • Total volume
  • Average_V/Unit
  • Average_V/Building block
  • Average_V/Staircases

Curtain wall exterior

  • Element
  • Quantity
  • Average_Q/Building block
  • Average_Q/Staircases
  • Total volume
  • Average_V/Unit
  • Average_V/Building block
  • Average_V/Staircases

Curtain wall interior

  • Not currently within the scope

Curtain wall exterior apt

  • Element
  • Quantity
  • Average_Q/Different type of apartments
  • Total volume
  • Average_V/Unit
  • Average_V/Different type of apartments

Curtain wall interior apt

  • Element
  • Quantity
  • Average_Q/Different type of apartments
  • Total volume
  • Average_V/Unit
  • Average_V/Different type of apartments

Doors exterior

  • Element
  • Quantity
  • Average_Q/Building block
  • Average_Q/Staircases
  • Total volume
  • Average_V/Unit
  • Average_Glass_V/Unit
  • Average_V/Building block
  • Average_V/Staircases
  • Total glass volume
  • Average_Glass_V/Unit
  • Average_Glass _V/Building block
  • Average_Glass _V/Staircases

Doors Interior

  • Element
  • Quantity
  • Average_Q/Building block
  • Average_Q/Staircases
  • Total volume
  • Average_V/Unit
  • Average_Glass_V/Unit
  • Average_V/Building block
  • Average_V/Staircases
  • Total glass volume
  • Average_Glass_V/Unit
  • Average_Glass _V/Building block
  • Average_Glass _V/Staircases

Doors exterior apartments

  • Element
  • Quantity
  • Average_Q/Different type of apartments
  • Total volume
  • Average_V/Unit
  • Average_V/Different type of apartments
  • Total volume glass
  • Average_Glass_V/Unit
  • Average_Glass_V/Different type of apartments

Doors interior apartments

  • Element
  • Quantity
  • Average_Q/Different type of apartments
  • Total volume
  • Average_V/Unit
  • Average_V/Different type of apartments
  • Total volume glass
  • Average_Glass_V/Unit
  • Average_Glass_V/Different type of apartments

Floor Exterior Apartments

  • Element
  • Quantity
  • Average_Q/Different type of apartments
  • Total area
  • Average_A/Unit
  • Average_A/Different type of apartments
  • Total volume
  • Average_V/Unit
  • Average_V/Different type of apartments

Floor Exterior

  • Element
  • Quantity
  • Average_Q/Building block
  • Average_Q/Staircases
  • Total area
  • Average_A/Unit
  • Average_A/Building block
  • Average_A/Staircases
  • Total volume
  • Average_V/Unit
  • Average_V/Building block
  • Average_V/Staircases

Floor interior

  • Element
  • Quantity
  • Average_Q/Building block
  • Average_Q/Staircases
  • Total area
  • Average_A/Unit
  • Average_A/Building block
  • Average_A/Staircases
  • Total volume
  • Average_V/Unit
  • Average_V/Building block
  • Average_V/Staircases

Floor interior apartments

  • Element
  • Quantity
  • Average_Q/Different type of apartments
  • Total area
  • Average_A/Unit
  • Average_A/Different type of apartments
  • Total volume
  • Average_V/Unit
  • Average_V/Different type of apartments

Pillar

  • Element
  • Quantity
  • Average_Q/Building block
  • Average_Q/Staircases
  • Total volume
  • Average_V/Unit
  • Average_V/Building block
  • Average_V/Staircases

Railings Exterior

  • Element
  • Quantity
  • Average_Q/Building block
  • Average_Q/Staircases
  • Total volume
  • Average_V/Unit
  • Average_V/Building block
  • Average_V/Staircases

Railings Exterior apartments

  • Element
  • Quantity
  • Average_Q/Different type of apartments
  • Total volume
  • Average_V/Unit
  • Average_V/Different type of apartments

Railings Interior

  • Not currently within the scope

Railings interior apartments

  • Not currently within the scope

Roofs

  • Element
  • Quantity
  • Average_Q/Building block
  • Average_Q/Staircases
  • Total area
  • Average_A/Unit
  • Average_A/Building block
  • Average_A/Staircases
  • Total volume
  • Average_V/Unit
  • Average_V/Building block
  • Average_V/Staircases

Stairs exterior

  • Not currently within the scope

Stairs interior

  • Element
  • Quantity
  • Average_Q/Building block
  • Average_Q/Staircases
  • Total area
  • Average_A/Unit
  • Average_A/Building block
  • Average_A/Staircases
  • Total volume
  • Average_V/Unit
  • Average_V/Building block
  • Average_V/Staircases

Wall Exterior

  • Element
  • Quantity
  • Average_Q/Building block
  • Average_Q/Staircases
  • Total volume
  • Average_V/Unit
  • Average_V/Building block
  • Average_V/Staircases

Wall interior

  • Element
  • Quantity
  • Average_Q/Building block
  • Average_Q/Staircases
  • Total volume
  • Average_V/Unit
  • Average_V/Building block
  • Average_V/Staircases

Wall interior apartments

  • Element
  • Quantity
  • Average_Q/Different type of apartments
  • Total volume
  • Average_V/Unit
  • Average_V/Different type of apartments

Windows

  • Element
  • Quantity
  • Average_Q/Building block
  • Average_Q/Staircases
  • Total volume
  • Average_V/Unit
  • Average_Glass_V/Unit
  • Average_V/Building block
  • Average_V/Staircases
  • Total glass volume
  • Average_Glass_V/Unit
  • Average_Glass _V/Building block
  • Average_Glass _V/Staircases

Windows apartments

  • Element
  • Quantity
  • Average_Q/Different type of apartments
  • Total volume
  • Average_V/Unit
  • Average_V/Different type of apartments
  • Total volume glass
  • Average_Glass_V/Unit
  • Average_Glass_V/Different type of apartments
©2023 LCA och Kostnadskontroll - Belatchew Labs