topic Re: Option set in Project data & BIM

Option set

kjell syryn — Sun, 14 May 2023 17:41:18 GMT

Is it possible to add a value of a expression to a option set?

for example:

In my expression i multiplied 2 number with each other (3,6 x 10 = 36). In my option set i have the values of 10-20-30-40-50-60-70-80-90-100. I want to have the value of 36 in my option set. Is there any possibility to make this happen?

Re: Option set

Barry Kelly — Mon, 15 May 2023 01:03:53 GMT

I am a little bit confused as expressions can't have an option set.

So I am not sure what they have to do with each other.

In the option set property, you can press the 'Options Setup' button and "Add' more options.

Barry.

Re: Option set

kjell syryn — Mon, 15 May 2023 07:55:43 GMT

Dear Barry Kelly

This expression changes for every zone i place and is different for every zone category. For zone 1 its 3,6 x 15,9 = 57,24. For zone 2 its 3,6 x 20,75 = 74,4. For zone 3 its 3,6 x 2 = 7,2. For some zone categories there is a minimum 10 or 30 and for others there is a maximum 50 or 80. There for i need to put that expression equation in my option set.

Kjell.

Re: Option set

Barry Kelly — Mon, 15 May 2023 08:17:15 GMT

I am still not clear on what you want.

An expression is a calculation, you have no option for the outcome.

It is what ever the calculation is.

For example calculating the area of a zone.

An option set is where you can choose from a possible list of outcomes.

There are no calculations involved, you simply choose the result you want to use.

With zone categories, this is something you set up and then choose the category as you place the zone.

Are you saying you want the category to be chosen based on the area of the zone?

If so, you could create an expression that could tell you what the category should be based on min/max areas, but I believe you would have to manually adjust the actual zone category yourself.

So if you are talking about this zone category (this is from version 22 - all I have open at the moment) ...

I am not aware of any way you can automate which category is used.

Barry.

Re: Option set

kjell syryn — Mon, 15 May 2023 08:25:32 GMT

Dear Barry Kelly

How can you make a expression for 20 different zone categories to have each a different min/max value?

Example:

Zone category 1 has a min of 20 and a max of 80

Zone category 2 has a min of 15 and a max of 90

Zone category 3 has a min of 5 and a max of 50

and so on

Re: Option set

Barry Kelly — Mon, 15 May 2023 09:20:37 GMT

@kjell syryn wrote:
How can you make a expression for 20 different zone categories to have each a different min/max value?

If the zone categories all have overlapping ranges, you can't.

In your example, if you have a zone area of 40, it could be zone category 1, 2 or 3.

You need precise rules to make a determination.

How would you choose this zone category manually if you had an area of 40?

However, if you are manually choosing the category you want, then maybe you could create an expression that checks if it belongs in the range of areas.

You could then set up a sequence of expressions that it would run through to check if it was valid or not.

I can't say what the exact format of the expressions would be (without setting it all up myself), but it would be something like ...

If zone category = "zone category 1" then if within a range of 20-80, the result is "OK"

If zone category = "zone category 2" then if within a range of 15-90, the result is "OK"

If zone category = "zone category 3" then if within a range of 5-50, the result is "OK"

The expressions will get messy though as you can't mix strings (zone category name) with numbers or areas.

I just had a quick play and couldn't get it to work.

I will try again later and if I get a result I will post back.

Barry.

Re: Option set

Barry Kelly — Tue, 16 May 2023 14:58:22 GMT

I thought it would be easier to use a sequence of expressions.

But I couldn't get it to work.

Maybe it doesn't work with IF because if it is true, that is it and if it is false it does not go to the next expression in the sequence.

But I managed to do it with a nested IFS.

This is the text for the formula I used ...

IFS ( AND ( {Property:Zone/Zone Category} = "Category 1", {Property:Zone/Measured Area} >= 20 m2, {Property:Zone/Measured Area} <= 80 m2 ), " CAT 1 OK", AND ( {Property:Zone/Zone Category} = "Category 2", {Property:Zone/Measured Area} >= 15 m2, {Property:Zone/Measured Area} <= 90 m2 ), " CAT 2 OK", AND ( {Property:Zone/Zone Category} = "Category 3", {Property:Zone/Measured Area} >= 5 m2, {Property:Zone/Measured Area} <= 50 m2 ), " CAT 3 OK" )

Change the names of the zone categories to suit yours and you can change the "OK" response as well.

This will just give you a property value to say if the zone area meets your particular category requirements.

You can add more categories, at the end before the final bracket just keep adding this but change to your next category and min/max areas...

AND ( {Property:Zone/Zone Category} = "Category 1", {Property:Zone/Measured Area} >= 20 m2, {Property:Zone/Measured Area} <= 80 m2 ), " CAT 1 OK"

I hope this is what you are after.

You still have to place the zone with the category you want, but the property will tell you if it is OK.

Barry.

Re: Option set

kjell syryn — Tue, 16 May 2023 14:58:45 GMT

Dear Barry Kelly

I want to thank you for the time and energy you put in to this. This is very helpful. This is not exactly what i need but its close. For my project the value needs to recalculate to the min/max. Also i need to put these in a schedule.

This is the expression i use. This only works for 1 Zone Category. If i want to add a other zone category it gives me a error. The 10 zone categories all got a different min and max. Is there any possibility to add more zone categories?

Re: Option set

kjell syryn — Mon, 15 May 2023 20:01:15 GMT

Dear Barry Kelly

Re: Option set

Barry Kelly — Tue, 16 May 2023 01:11:37 GMT

I have just started work for the day so I won't get to play around with this and test it until later tonight (about 10 or 12 hours from the time of this post).

But it should just be a case of adding an extra argument, exactly the same format as you have but with the next zone requirements.

Barry.

Re: Option set

Barry Kelly — Tue, 16 May 2023 14:59:44 GMT

Sorry, this post got marked automatically as spam because of the code.

I have now released it.

Feel free to spread the expression out a bit in the editor - it will still work.

If that first expression works, then it should be a matter of just doing this (I hope).

I have marked what I think you need to change in red....

IFS ( {Property:Zone/Zone Category} = "Toevoer Slaapkamer"; IF ( {Property:Ventilatie/Ontwerp Debiet (m³\/h.m²)} <= 25; 25; IF ( {Property:Ventilatie/Ontwerp Debiet (m³\/h.m²)} >= 72; 72; {Property:Ventilatie/Ontwerp Debiet (m³\/h.m²)} ) ) , {Property:Zone/Zone Category} = "new_zone"; IF ( {Property:Ventilatie/Ontwerp Debiet (m³\/h.m²)} <= 10; 10; IF ( {Property:Ventilatie/Ontwerp Debiet (m³\/h.m²)} >= 90; 90; {Property:Ventilatie/Ontwerp Debiet (m³\/h.m²)} ) ) , {Property:Zone/Zone Category} = "new_zone"; IF ( {Property:Ventilatie/Ontwerp Debiet (m³\/h.m²)} <= 10; 10; IF ( {Property:Ventilatie/Ontwerp Debiet (m³\/h.m²)} >= 90; 90; {Property:Ventilatie/Ontwerp Debiet (m³\/h.m²)} ) ) )

Barry.

Re: Option set

kjell syryn — Tue, 16 May 2023 07:12:01 GMT

Dear Barry Kelly

I want to formally thank you for all the time and effort you put in to this. You have been very grateful and helpful in making this work. I used your example and tried it myself. With a few changes in the comma it works. Thank you very much for everything.

Kjell Syryn

Re: Option set

Barry Kelly — Tue, 16 May 2023 07:17:47 GMT

Not a problem.

I didn't test it myself.

Would you mind posting the expression that does work if you don't mind, just so those following can get the correct information as well?

Or just point out where I went wrong.

Don't worry if it disappears as a spam post - I will release it.

If you have it working with all 10 zones in your expression, that is fine, I can always edit it back to a smaller sample.

Barry.

Re: Option set

kjell syryn — Tue, 16 May 2023 15:01:49 GMT

Here you can find the solution for setting a specific min/max to your zone category.

IFS ( {Property:Zone/Zone Category} = "Toevoer Slaapkamer"; IF ( {Property:Ventilatie/Ontwerp Debiet - per vierkante meter} <= 25; 25; IF ( {Property:Ventilatie/Ontwerp Debiet - per vierkante meter} >= 72; 72; {Property:Ventilatie/Ontwerp Debiet - per vierkante meter} ) ); {Property:Zone/Zone Category} = "Toevoer Woonkamer"; IF ( {Property:Ventilatie/Ontwerp Debiet - per vierkante meter} <= 75; 75; IF ( {Property:Ventilatie/Ontwerp Debiet - per vierkante meter} >= 150; 150; {Property:Ventilatie/Ontwerp Debiet - per vierkante meter} ) ); {Property:Zone/Zone Category} = "Toevoer Studeerkamer"; IF ( {Property:Ventilatie/Ontwerp Debiet - per vierkante meter} <= 25; 25; IF ( {Property:Ventilatie/Ontwerp Debiet - per vierkante meter} >= 72; 72; {Property:Ventilatie/Ontwerp Debiet - per vierkante meter} ) ); {Property:Zone/Zone Category} = "Toevoer Speelkamer"; IF ( {Property:Ventilatie/Ontwerp Debiet - per vierkante meter} <= 25; 25; IF ( {Property:Ventilatie/Ontwerp Debiet - per vierkante meter} >= 72; 72; {Property:Ventilatie/Ontwerp Debiet - per vierkante meter} ) ); {Property:Zone/Zone Category} = "Afvoer Keuken"; IF ( {Property:Ventilatie/Ontwerp Debiet - per vierkante meter} <= 50; 50; IF ( {Property:Ventilatie/Ontwerp Debiet - per vierkante meter} >= 75; 75; {Property:Ventilatie/Ontwerp Debiet - per vierkante meter} ) ); {Property:Zone/Zone Category} = "Afvoer Badkamer"; IF ( {Property:Ventilatie/Ontwerp Debiet - per vierkante meter} <= 50; 50; IF ( {Property:Ventilatie/Ontwerp Debiet - per vierkante meter} >= 75; 75; {Property:Ventilatie/Ontwerp Debiet - per vierkante meter} ) ); {Property:Zone/Zone Category} = "Afvoer Was- en droogplaats"; IF ( {Property:Ventilatie/Ontwerp Debiet - per vierkante meter} <= 50; 50; IF ( {Property:Ventilatie/Ontwerp Debiet - per vierkante meter} >= 75; 75; {Property:Ventilatie/Ontwerp Debiet - per vierkante meter} ) ); {Property:Zone/Zone Category} = "Afvoer open keuken"; IF ( {Property:Ventilatie/Ontwerp Debiet - per vierkante meter} <= 75; 75; IF ( {Property:Ventilatie/Ontwerp Debiet - per vierkante meter} >= 75; 75; {Property:Ventilatie/Ontwerp Debiet - per vierkante meter} ) ); {Property:Zone/Zone Category} = "Afvoer WC"; IF ( {Property:Ventilatie/Ontwerp Debiet - per vierkante meter} <= 25; 25; IF ( {Property:Ventilatie/Ontwerp Debiet - per vierkante meter} >= 25; 25; {Property:Ventilatie/Ontwerp Debiet - per vierkante meter} ) ) )

Re: Option set

Barry Kelly — Tue, 16 May 2023 09:21:33 GMT

@kjell syryn wrote:

With a few changes in the comma it works.

Interesting.

It must be a language/system setting.

You seem t be using semi-colons ( ; ) as your separators in the expression.

My system uses just a comma ( , ).

Glad you got it working.

So for everyone playing along at home, make sure you use the correct separator as set by your operating system.

Barry.

Re: Option set

Laszlo Nagy — Tue, 16 May 2023 15:05:42 GMT

It depends on the decimal place character used in the operating system.

If your operating system uses . (decimal point), then you have to use , (comma) in Property expressions.

If your operating system uses , (comma) as a decimal separator (like in Hungary), then you have to use ; (semicolon) in Property expressions.