ChrisA Posted June 9, 2016 Share Posted June 9, 2016 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 Quote Link to comment
RickR Posted June 9, 2016 Share Posted June 9, 2016 =Zcenter() or =Zcoordinate() Help file> "Worksheet Functions" and scroll all the way down. Quote Link to comment
michaelk Posted June 10, 2016 Share Posted June 10, 2016 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 Quote Link to comment
michaelk Posted June 10, 2016 Share Posted June 10, 2016 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 Quote Link to comment
ChrisA Posted June 10, 2016 Author Share Posted June 10, 2016 Perfect thanks for the help Quote Link to comment
Recommended Posts
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.