|
EquipmentCount1(ElecDB, iAmpsMin, iAmpsMax, sDisconnect, sVolts, sLayerSystem)
This function returns a count of equipment connections from the database.
iAmpsMin: The minimum amps. All equipment connections with amps greater than this value will be included in the count. If it is passed as 0, no minimum will be used.
iAmpsMax: The maximum amps. All equipment connections with amps less than or equal to this value will be included in the count. If it is passed 0, no maximum will be used.
sDisconnect: The disconnect type to count. The valid options are the names defined in the equipment block customization dialog for this project. If it is passed as "", all disconnect types will be counted.
sVolts: The voltage to count. If it is passed as "", all voltages will be counted. The voltages that can be passed are:
Common Variables
ElecDB
sLayerSystem
Examples
Examples involving the common variables can be found by clicking on their links above.
EquipmentCount1('DM Elec'!$B$1, 0, 0, "", "", "")
This returns the count of all equipment in the project.
EquipmentCount1('DM Elec'!$B$1, 10, 100, "Hardwired Connection", "120V 1P 2W", "New")
This returns the count of all new equipment of disconnect type "Hardwired Connection" between 10 and 100 amps that are 120V 1P 2W.
|