Revit MEP

Reply
Active Member
claycalhoun
Posts: 8
Registered: ‎01-29-2010
Message 11 of 11 (151 Views)

Re: Parameter Formula Conditional Statements

08-28-2013 08:39 AM in reply to: CADastrophe

CADastrophe wrote:

See the attached .rfa file (Revit 2013) as a demonstration of the setup that is achieved by the methods as described above. Load this into a Project and see what you think.

 

To work in conjunction with the checkbox method for Wires, I create a "Reporting Wires" Integer Parameter that checks the status of "Wires 3" and returns 3 if it is "YES" and 4 if it is "NO".

 

The "Reporting Integer" is calculated using the formula below, which first checks the selected Breaker Size and then checks the number of Wires with a nested IF/THEN/ELSE statement. The final line does not check for "1200A" because it is the final ELSE statement.

 

IF ( Breaker = B60 , IF ( Wires 3, 1, 2),
IF ( Breaker = B70 , IF ( Wires 3, 3, 4),
IF ( Breaker = B100 , IF ( Wires 3, 5, 6),
IF ( Breaker = B125 , IF ( Wires 3, 7, 8),
IF ( Breaker = B150 , IF ( Wires 3, 9, 10),
IF ( Breaker = B175 , IF ( Wires 3, 11, 12),
IF ( Breaker = B200 , IF ( Wires 3, 13, 14),
IF ( Breaker = B225 , IF ( Wires 3, 15, 16),
IF ( Breaker = B250 , IF ( Wires 3, 17, 18),
IF ( Breaker = B300 , IF ( Wires 3, 19, 20),
IF ( Breaker = B350 , IF ( Wires 3, 21, 22),
IF ( Breaker = B400 , IF ( Wires 3, 23, 24),
IF ( Breaker = B500 , IF ( Wires 3, 25, 26),
IF ( Breaker = B600 , IF ( Wires 3, 27, 28),
IF ( Breaker = B800 , IF ( Wires 3, 29, 30),
IF ( Breaker = B1000 , IF ( Wires 3, 31, 32),
IF ( Wires 3, 33, 34)))))))))))))))))

 

 

My apologies if I'm throwing too much out there at once...


Excellent Solution! Thank you for the detailed explanation. I like to know what is happening inside the Revit process so this really helps me out with future family development! Your family was great as an example also.

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.