Insert Room Type Attribute

To insert attributes of rooms into your workbook use the Insert Room Type Attribute command. DM Electrical

Rooms

Insert Room Type Attribute. The Insert Room Type Attributes dialog box will open.

The table below explains what each field in the Insert Room Type Attributes dialog box represents and defines.

Field	Sets
Room Type	Lists the room types you may choose to display.
Attribute	The attribute refers to a type of data that can be determined for any given room type that will be entered into an excel row when selected. For example, if you select Illuminance Category, Design Master will insert into an excel cell the illuminance category for the selected room type (the label Illuminance Category will not be inserted.)
New Cells	There are two choices regarding how to insert new cells. When you select Overwrite Existing Cells, the values will be inserted over top of the existing cells. The first value will be placed in the active cell with additional values placed below. When you select Insert New Rows, new rows will be inserted for each value. The current row will be moved down to make room for the new values. The cells in the current column will contain the selected values. The other cells in the new rows will contain the same values as the current row.

When you press this button, the room type will be inserted on the worksheet, starting at the active cell. The room type is inserted as an actual value in the cells, not as a formula. Once it has been inserted, you can freely edit and modify it as needed.

When you press this button, the function for this dialog will be inserted on the worksheet with the selected criteria included as arguments to the function.

When you press this button, the room number and the function for the dialog will be inserted on the worksheet. The room number will be placed in the column of the active cell. The functions will be placed in the column to the right of the active cell.