SwitchboardCount1

 Top  Previous  Next

SwitchboardCount1(ElecDB, Volts, BusAmps, MainDisconnectType, MainDisconnectAmps, Mounting, PanelNeutral, sNumberOfTaps, Lugs, PanelIGBus, AIC, sLayerSystem)

This function returns a count of switchboards from the database. All of the arguments except ElecDB are optional. To not filter on a specific argument, pass it as "".

Volts: The voltage of the switchboard. The possible switchboard voltages are:

•208Y/120V 3P 4W
•480Y/277V 3P 4W
•240/120V 2P 3W
•120V 1P 2W
•240V 3P 3W
•240/120V 3P 4W
•208/120V 2P 3W
•208V 2P 2W
•208V 3P 3W
•480V 2P 2W
•480V 3P 3W
•575V 3P 3W

BusAmps: The bus amps of the switchboard

MainDisconnectType: The main disconnect type of the switchboard. The possible types are:

•Main Lugs Only
•Breaker
•Fused Switch

MainDisconnectAmps: The main disconnect amps of the switchboard. This argument is ignored if MainDisconnectType is set to "Main Lugs Only".

Mounting: The mounting of the switchboard. The possible mounting types are:

•FLUSH
•SURFACE
•RECESSED
•FLOOR

PanelNeutral: The neutral of the switchboard. The possible neutral types are:

•50%
•100%
•133%
•200%
•NONE

sNumberOfTaps: The number of positions in the switchboard.

Lugs: The type of lugs of the switchboard. The possible types are:

•STANDARD
•DOUBLE
•FEEDTHROUGH

PanelIGBus: Whether the switchboard has an IG bus or not. Pass as either "Yes" or "No".

AIC: The AIC rating of the switchboard.

Common Variables

ElecDB

sLayerSystem

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