Revit MEP

Revit MEP

Reply
Active Member
8 Posts
0 Kudos
Registered: ‎01-29-2010
Post 11 of 11

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