topic Re: Problem: Values in expressions multiplied by quantity in schedules in Collaboration with other software

Problem: Values in expressions multiplied by quantity in schedules

Anonymous — Mon, 12 Jul 2021 11:04:03 GMT

Hi!
I'm struggling with this problem.
I've created schedules of construction elements (beams and columns) where I'm listing their lengths and heights.
I needed rounded up values with some reserve. For this, I'm using expression MROUNDUP. For single elements everything works like a charm, but problem appears with multiple elements of the same length.
I've got this schedule where all elements are listed and "merge uniform" option is "on" and in this case, the property I made is useless - values from expression are multiplied by number of elements.
To be sure, I made column with property containing expression of just the beam length and it also shows beam length multiplied by the number of beams with the same length.
My question is, why values based on expressions listed in schedules are working differently from those listed directly in schedules? Is there any workaround? I was thinking of dividing the result by number of elements, but this number is specific for schedule and cannot be used in expressions...

Re: Problem: Values in expressions multiplied by quantity in schedules

Podolsky — Mon, 12 Jul 2021 12:10:06 GMT

Scheduling is not so advanced tool and this is why similar problems appear. Try to solve it differently - don't round up the values with property for example. Use calculation rules and units settings instead.

Re: Problem: Values in expressions multiplied by quantity in schedules

Anonymous — Mon, 12 Jul 2021 12:28:23 GMT

Podolsky wrote:
Scheduling is not so advanced tool and this is why similar problems appear. Try to solve it differently - don't round up the values with property for example. Use calculation rules and units settings instead.

This is not a solution for what I’m trying to achieve and will produce more problems in other schedules, but thanks.

Re: Problem: Values in expressions multiplied by quantity in schedules

Laszlo Nagy — Tue, 13 Jul 2021 09:19:43 GMT

Length type Properties will be added in Schedules when the "Merge Items" checkbox is checked.
Number type Properties will not be added when the "Merge Items" checkbox is checked.

So, the solution is to create a Number type Property instead of a Length type Property.
There is a pretty elegant solution to convert a Length type Property to a Number type Property.
Let us say you want to convert the "3D Length" Property. It would look like this (in the case of a Metric system):

3D Length / 1 m

Re: Problem: Values in expressions multiplied by quantity in schedules

Anonymous — Tue, 13 Jul 2021 09:52:34 GMT

LaszloNagy wrote:

3D Length / 1 m

Brilliant. Although using 3d length creates the same, multiplying problem with "merge items" option checked. I'm using "MAX" of left and right side length (for beams) and "max height" for columns.
Side question: is there any way to control displayed accuracy for number parameter?

Re: Problem: Values in expressions multiplied by quantity in schedules

Laszlo Nagy — Tue, 13 Jul 2021 12:13:03 GMT

I think the only way to control the exact decimal places of value is if you convert them to string type of Property and then use text manipulation commands to achieve the desired decimal places display.

Re: Problem: Values in expressions multiplied by quantity in schedules

Anonymous — Tue, 13 Jul 2021 12:48:10 GMT

Hmm... but then I loose possibility to sum up values.
Expression based properties in schedules definitely need tweaking.

Re: Problem: Values in expressions multiplied by quantity in schedules

Laszlo Nagy — Tue, 13 Jul 2021 14:49:55 GMT

Yes, it has its limitations, such as the one you mentioned.
I think the best solution would be to be able to optionally define the formatting and accuracy on a Schedule Field level in the Scheme Settings Dialog (or use the settings coming from Calculation Settings preferences).