PanelLoad1

Top  Previous  Next

PanelLoad1(ElecDB, sDescription, sConnectedCalculated, sLoadType)

This function returns a one line device load.

sDescription: The name of the one line device.

sConnectedCalculated: This argument controls whether the returned load is calculated or connected. Pass either "Calculated" or "Connected".

sLoadType: The load type to return. The valid values for this function are:

Lighting
Largest Motor
Motor
Receptacle
Continuous
Heating
Noncontinuous
Kitchen
Diverse
Custom Load Type 1
Custom Load Type 2

In addition, you can also pass the name of the custom load type as it is defined in the options dialog. If the load type does not exist, an error message will be returned.

Common Variables

ElecDB

Examples

Examples involving the common variables can be found by clicking on their links above.

PanelLoad1('DM Elec'!$B$1, "A", "Connected", "Motor")

This returns the connect motor load on one line device A.

PanelLoad1('DM Elec'!$B$1, "A", "Calculated", "Computers")

This returns the calculated load of type computers on one line device A. If computers is defined as one of the custom load types, this will return a value. If it is not defined as a custom load type, it will return an error.


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