Jump to content

Function


Recommended Posts

Does anyone one know the worksheet function needed to show the mounting height (Mtg. Height AFF) of an electrical fixture, receptacle or switch. I would like to add this to my schedule and cant seem to get it right. It would be nice if KBase had a list of these functions.

thanks

Link to comment

Assuming you are using the built in switches, receptacles, and fixtures:

=ZCenter only works correctly on switches and receptacles that are wall mounted. It's off by a little bit on all fixtures and on ceiling and floor mounted switches and receptacles.

=ZCoordinate almost always returns 0 because the Z value of the parametric object is usually 0. It uses a parameter to set the height.

The database call you are looking for is

='Switch'.'Mount' for switches

='Receptacle'.'Mount' for receptacles

='Comm Device'.'Mount' for comm devices

='Incandescent Fixture'.'Mtg Height AFF' for fixtures

hth

mk

Link to comment

If you have one database with all your devices you can put the heights into a single column with an IF/Then/Else statement.

Just copy an paste this into a cell in the header row:

=IF(PON='Switch', 'Switch'.'Mount', (IF(PON='Receptacle', 'Receptacle'.'Mount', (IF(PON='Comm Device', 'Comm Device'.'Mount', (IF(PON='Incandescent Fixture', 'Incandescent Fixture'.'Mtg Height AFF', '--')))))))

hth

mk

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...