Insert Motor Control Center Starter Quantity

Top  Previous  Next

To insert a quantity of one line devices (in this case, MCC starters) into your workbook use the Insert MCC Starter Quantity command.  DM Electrical arrow One Line Devices arrow Insert MCC Starter Quantity. The Insert MCC Starter Quantity dialog box will open.

InsertMCCStarterQty

The table below explains what each field in the Insert MCC Starter Quantity dialog box represents and defines.

Field

Sets

Motor Control Center

This is a criteria for which MCC starters are included in the count.  You may restrict the count to MCC starters on a specific motor control center. When this is set to <All>, all MCC starters or taps on any motor control center will be included in the count.

1, 2, or 3 Pole and Starter Size

A row will be inserted into your worksheet for each pair of starter sizes and poles selected. To select multiple starter sizes, use the Ctrl or Shift keys.

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.

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_motor_control_center_starter_quantity.htm