Insert Enclosed Breaker and Disconnect Quantity

Top  Previous  Next

To insert a quantity of one line devices (in this case, enclosed breakers) into your workbook use the Insert   Enclosed Breaker and Disconnect Quantity command.  DM Electrical arrow One Line Devices arrow Insert Enclosed Breaker and Disconnect Quantity. The Insert  Enclosed  Breaker / Disconnect Quantity dialog box will open.

excel_insert_enclosed_breaker

Each attribute can either be set to <All> or to a specific value. When an attribute is set to a specific value, only enclosed breakers that have that attribute will be included in the count. When multiple attributes are specified, the device count will include devices that match all of the specified attributes. When <All> is selected for a given attribute, that attribute is not used to filter which enclosed breakers will be counted.

There are three buttons regarding which values to insert into the worksheet.

excel_insert_quantity_label

Insert Label

When you press this button, the label will be inserted on the worksheet, starting at the active cell. The label 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.

Insert Quantity

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.

Insert Both

When you press this button, the label and the function for the dialog will be inserted on the worksheet. The labels 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.

 

 


Page url: http://www.designmaster.biz/support/electrical/documentation/index.html?excel_add_in_menu_commands_insert_enclosed_breaker_and_fused_switch_quantity.htm