topic Re: Schedule running in totals to the right in Project data & BIM

Schedule running in totals to the right

johanSR — Fri, 04 Oct 2024 22:37:43 GMT

Hi all.

I would just like to know if anyone had experience in creating a schedule like this before?

I would like to have the amounts next to descriptions, per floor, and then a total of each item at the end... As per the pic.

Operating system used: Windows 11

Re: Schedule running in totals to the right

B_Migito — Fri, 04 Oct 2024 22:34:18 GMT

Hey Johan,

As far as I know, you won't be able to get exactly that type of schedule with the native tools but you can get pretty close

If you use these options (1) with the flag on ID and sum on quantity

You can get the items and their quantities per floor like so (2)

If you need to add description, you simply add in (1) the description/personalised text between the quantity (Quantité in my image) and 2D preview (Prévisualisation plan 2D in my image)

That's about as close as I can get it

Re: Schedule running in totals to the right

johanSR — Fri, 04 Oct 2024 22:34:49 GMT

Thank you!!!

I thought so...

I set it up like this so far, but is there a way I can merge the highlighted cell/columns into one, as they would display the same info/specs...

Re: Schedule running in totals to the right

Mathias Jonathan — Fri, 04 Oct 2024 14:13:52 GMT

You can also use the "brute" force: as many properties as there are stories, a formula for each property (set to number) that verifify if the element is in the story (=1) or not (=0).

The merged properties should give you a result similar to your example.

Re: Schedule running in totals to the right

johanSR — Fri, 04 Oct 2024 14:17:37 GMT

Mathias...
Could you repeat that in English please... LOL

I don't think I understand what you mean. Would that apply to the picture preview as well?

Re: Schedule running in totals to the right

Mathias Jonathan — Fri, 04 Oct 2024 22:36:08 GMT

Re: Schedule running in totals to the right

johanSR — Fri, 04 Oct 2024 14:37:23 GMT

Mathias. Thank you!

This seems like I need to figure a bunch of stuff out before I can get to whta you've done... I don't even know how you got to the second picture settings...

But i'll try on Monday again. Thanks!!!

If you can, would you be able to send scheme setting setup as well?

Re: Schedule running in totals to the right

B_Migito — Fri, 04 Oct 2024 22:36:53 GMT

You get to the second picture by going :

>Options

>Property Manager

Re: Schedule running in totals to the right

johanSR — Mon, 07 Oct 2024 13:07:28 GMT

Hi Mathias.

I've been trying to get it to work, but I couldn't get it...

Here is my setup...

I assume I create one for each floor? And how does the expression work for each floor?

That option is greyed out...

Re: Schedule running in totals to the right

Laszlo Nagy — Mon, 07 Oct 2024 13:22:35 GMT

Try to click the Σ icon for the Quantity field in the Scheme Setup Dialog, so it changes to Σ1. That way, it will summarize the number of those items instead of summing the quantity.

Or, maybe you need to create an additional Property called "Total" whose value would be "1" for all elements regardless of which Story they are on (each element counts as 1 in the Total, right?).

So, you would not rely on the totaling function of the schedule; you would do the totaling yourself with this Property and just display the value of this "Total" Property in the Schedule. This is basically what your image shows in your original post - an additional Schedule Field called "Total". This is how you can create it.

Please let us know if either of these worked.

Re: Schedule running in totals to the right

Mathias Jonathan — Mon, 07 Oct 2024 13:19:35 GMT

@Laszlo Nagy The official Quantity works here.

@johanSR You need to have a column for each level/story property if you want the result in reference. You can't use the home story name for this kind of result. I don't understand the Classification part, did you create a classification for each story? You only need to make the properties available to the elements you want to schedule.

Re: Schedule running in totals to the right

johanSR — Mon, 07 Oct 2024 13:39:56 GMT

I think I might not be as clever as you guys... 😉

This is way too complicated for me...

I added those properties under the property manager. I thought you would need to add it to a classification to be able to reference it?

Re: Schedule running in totals to the right

johanSR — Mon, 07 Oct 2024 14:03:06 GMT

Urghhhhh.

Just as I replied I got the structure correct!!!

Now I just need the values to show up...

Re: Schedule running in totals to the right

Mathias Jonathan — Mon, 07 Oct 2024 13:54:21 GMT

My mistake, the classification seems good.

You need to have 1 story property for 1 column and then the Quantity at the end. The pameters for each column is to help you concatenate the value on on line.

Re: Schedule running in totals to the right

Mathias Jonathan — Mon, 07 Oct 2024 13:57:02 GMT

It looks like that your element don't have the correct classification to access the property.

Re: Schedule running in totals to the right

johanSR — Mon, 07 Oct 2024 14:44:51 GMT

It's showing a value, but it seems to be different all around and not the correct values.

They are assigned to a classification though...

Re: Schedule running in totals to the right

Mathias Jonathan — Mon, 07 Oct 2024 15:11:06 GMT

The "---" result is clearly a non accessed property problem.

Check each "---" value by selecting the element in the schedule then using the "select in 2D" schedule command

If you want to have everything on the same line (as it is in your example), you can remove the flag

Re: Schedule running in totals to the right

johanSR — Mon, 07 Oct 2024 16:29:15 GMT

Thanks!
I'll check those objects for the classification...
But why are some objects showing 0, when there are more than that?

Re: Schedule running in totals to the right

Mathias Jonathan — Mon, 07 Oct 2024 16:33:10 GMT

Because for each story property, you have to modify the formula: for example:

IF(Home Story Number = 4;1;0) for the fourth floor,

IF(Home Story Number = 5;1;0) for the fifth floor...

You wrote the same formula for each story, so the property verify if the object is in the ground floor each time

Re: Schedule running in totals to the right

johanSR — Thu, 10 Oct 2024 12:45:04 GMT

Thanks Mathias!!!

That did the trick. Everything is working perfectly!!