We value your input!
Please participate in Archicad 28 Home Screen and Tooltips/Quick Tutorials survey

Project data & BIM
About BIM-based management of attributes, schedules, templates, favorites, hotlinks, projects in general, quality assurance, etc.
SOLVED!

Schedule running in totals to the right

johanSR
Booster

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


image.png

1 ACCEPTED SOLUTION

Accepted Solutions
Solution
Mathias Jonathan
Advocate

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

View solution in original post

21 REPLIES 21
B_Migito
Contributor

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 

1000026260.jpg

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

1000026261.jpg

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

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...

johanSR_0-1728050213790.png

 

Mathias Jonathan
Advocate

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.

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?

Mathias Jonathan
Advocate

Capture d’écran 2024-10-04 à 16.23.04.png

 

 

 

 

 

Capture d’écran 2024-10-04 à 16.23.19.png

 

 

 

 

 

 

 

 

 

 

Capture d’écran 2024-10-04 à 16.23.38.png

 

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?

You get to the second picture by going : 

 

>Options

>Property Manager

 

1000026271.jpg

 

1000026272.jpg

Hi Mathias.

 

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

Here is my setup...

 

johanSR_2-1728305887866.png

 

johanSR_3-1728305905848.png

 

 

johanSR_4-1728305980571.png

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

johanSR_5-1728306054715.png

 

 

 

johanSR_1-1728305848467.png

 

That option is greyed out...



Laszlo Nagy
Community Admin
Community Admin

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.

Loving Archicad since 1995 - Find Archicad Tips at x.com/laszlonagy
AMD Ryzen9 5900X CPU, 64 GB RAM 3600 MHz, Nvidia GTX 1060 6GB, 500 GB NVMe SSD
2x28" (2560x1440), Windows 10 PRO ENG, Ac20-Ac27

Setup info provided by author