topic Re: Is there a way to sum a large number of fill areas in ArchiCAD? in Collaboration with other software

Is there a way to sum a large number of fill areas in ArchiCAD?

Anonymous — Fri, 18 May 2018 18:44:22 GMT

Is there a way to sum a large number of fill areas in ArchiCAD?

Re: Is there a way to sum a large number of fill areas in ArchiCAD?

poco2013 — Fri, 18 May 2018 19:52:53 GMT

All fills contain the property -- Area

Simply create a schedule with the defined criteria of 'Fill' and if you want -- further filter by ID #'s

Then add the area property under 'fields' and tick the sum icon for the area field which will sum all records.

Arch 21 only allows you to sum records

Re: Is there a way to sum a large number of fill areas in ArchiCAD?

Anonymous — Sat, 19 May 2018 06:12:01 GMT

I tried to create the schedule but I can't get them listed. I don't have any elements like doors etc. It's a 2D document with rectangles which areas need to be summed. From the scheme options on the left I don't know what to select. I tried with components --> components by layers, fill layer but I couldn't get them appear in the list.

Re: Is there a way to sum a large number of fill areas in ArchiCAD?

Barry Kelly — Sat, 19 May 2018 07:27:07 GMT

ArchiCAD will only schedule fills placed in the plan view - not sections, elevations, details, etc.
Are your fills in the plan view.

Barry.

Re: Is there a way to sum a large number of fill areas in ArchiCAD?

Anonymous — Sat, 19 May 2018 11:01:08 GMT

Yes, the fills are in the plan view. I have a large number of rectangles (material) in the plan view which areas need to be summed. There is no building in the document, just the rectangles. Ideally, it would be great if I could generate different tables for the rectangles because they are divided in groups (n-number of rectangles for wall 1, n-number of them for wall 2, etc.) in the plan view. What I need is the sum of the rectangles in group 1, then the sum of them in group 2, etc.

Re: Is there a way to sum a large number of fill areas in ArchiCAD?

Karl Ottenstein — Sun, 20 May 2018 00:45:35 GMT

If the 'rectangles' were indeed drawn with the fill tool, in plan, then a schedule like the attached will give the sum of all of the areas. (If they were not drawn with the fill tool, then you can magic wand fills onto the rectangles to get corresponding fills.)

Re: Is there a way to sum a large number of fill areas in ArchiCAD?

Karl Ottenstein — Sun, 20 May 2018 00:54:00 GMT

To sum by group, you must in some way distinguish elements of the groups. The easiest way is to use the Element ID field. In the attached example, I set the Element ID to either 1 or 2 for a bunch of fills. (You can also use the fill type, etc.)

With "Merge Uniform Items" checked, instead of seeing each individual fill area, we just see the subtotal for each group. The sum (sigma) for Area gives the grand total. (Unfortunately, ARCHICAD does not give us the ability to edit empty cells and thus put the text "GRAND TOTAL" in front of the bottom line. Have to place unassociated / free-floating text on top of the schedule in the layout as a workaround.

Re: Is there a way to sum a large number of fill areas in ArchiCAD?

Anonymous — Sun, 20 May 2018 14:29:57 GMT

Thank you, Karl! I followed your steps and I managed to generate the area lists with the items distinguished by Element ID as you told me.

Re: Is there a way to sum a large number of fill areas in ArchiCAD?

Karl Ottenstein — Sun, 20 May 2018 18:33:35 GMT

Glad that worked for you. 🙂

Re: Is there a way to sum a large number of fill areas in ArchiCAD?

OBERMEYER — Tue, 22 Sep 2020 14:13:17 GMT

Is this still true for AC24? We created a schedule using fills as an exhibit to show area calculations for building permit (these drawings are a pain to generate for approval in Los Angeles, especially remodels). We then migrated file from AC20 to AC24. This is an old project, already approved, so we did not bother checking the area calculation sheet for correct migration. But we'd like to use the format as a template for ongoing projects.

I'll send screenshots in a separate post. Forgot how to load them here...

Re: Is there a way to sum a large number of fill areas in ArchiCAD?

OBERMEYER — Tue, 22 Sep 2020 14:28:44 GMT

Re: Is there a way to sum a large number of fill areas in ArchiCAD?

Barry Kelly — Wed, 23 Sep 2020 01:22:48 GMT

So long as your hotlink module contains the ID "RFA" and the actual fills contain the ID "Accessory", then I can't see any reason why this schedule would not work.
Of course if neither of these conditions is true, there will be no info in your schedule.

The 'Element types is not beam segment' and 'Element types is not columns segment' criteria can be deleted.
These were added automatically for compatibility with the new beam and column tools.

I would probably add a criteria to narrow the selection down to just fills though if that is what you are scheduling .... 'Element types is fill'.

However the fields may be the problem.
The 'Hatch Surface Area (Archicad 20)' is a conversion from an old version.
I am not sure if it still supposed to work (I think it is), but now the field is simply 'Area' that can be found in the general section when you add fields.

The other thing is if you just open the schedule, is the information there that then goes missing when you place it on the layout.
That would be a whole other problem.

Barry.