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