topic Re: Sum areas/lengths of selected walls in Collaboration with other software

Sum areas/lengths of selected walls

R Muller — Wed, 26 Jun 2013 20:59:51 GMT

I am trying to find a quick way to get the sum of the areas and/ or lengths of a bunch of selected walls. I have read some of the posts in this forum, and based on your advice it looks like the Element List for Quick Walls(ArchiCAD Library) may give the information I need.

However, I can't find any information about what is included in this list. The resulting table has four columns, labeled Length, Surface, Surface, Surface. The length column appears to be in inches (based on some experimentation). The three surface columns appear to be in sq. ft., and may be net of window rough opening, net of something else, and edge surface. However, I can't reproduce the numbers I see in the list, so I am not sure how the calculation is done.

What does the ArchiCAD Library have to do with it? Is there any way to customize this list?

I am currently using AC17 on Mac.

Re: How to know what is in element list

Karl Ottenstein — Wed, 26 Jun 2013 22:11:35 GMT

Any time you can avoid Lists, do so.

Scheduling areas and lengths of walls is more easily done with Element Schedules.

Right-click Schedules in the view map and create a new schedule. Make the criteria filter for walls, and whatever else you need (ID?) to select the particular walls you desire. Schedule the length/area fields, sum them as desired. Display the schedule and format as desired.

Re: How to know what is in element list

R Muller — Wed, 26 Jun 2013 23:07:39 GMT

Thank you, this looks promising. I see that if I select certain walls on the floor plan a right click allows me to schedule only the selected items.

How do I add a total at the bottom of the list?

I am not setting up a permanent schedule. Just trying to check the quantities my cost estimator is using for various elements.

Re: How to know what is in element list

Karl Ottenstein — Thu, 27 Jun 2013 02:15:54 GMT

R wrote:
How do I add a total at the bottom of the list?

You're welcome. The sigma in my last screenshot signifies to create a total for the indicated field. (If you click again and get a Sigma1 - that gives a count of matching elements instead.)

See attached screenshot - in case you also need subtotals: by clicking the third column to place a 'flag' for a field - then there is a subtotal - for every sigma field - whenever that field changes value. For this to be meaningful, the flag should go on fields sorted first - the schedule sorts from top down in the field list according to the sort direction arrow.

Clicking the 'show headline' (and possibly Settings to control it more) lets you display some initial column contents only for the first entry of several matching entries.

So, putting that all together in the screenshot, you can see the Building material appears only once (due to 'show headline') for each wall's BM, then each BM is subtotaled (due to the 'flag' to the right of BM in the Schedule fields in the scheme - and the sigma next to the length and surface area fields in the scheme). There is always a grand total for every sigma.

It's handy to create 'working' schedules that are part of your template for doing just the kind of checking that you're doing. They never have to appear in a document, but they're there when you need them.

Cheers,
Karl

Re: Sum areas/lengths of selected walls

Achille Pavlidis — Thu, 12 Dec 2013 17:02:54 GMT

Hi Karl

what about occupancy?

I tried to create a list with persons per room, but on the schedule even though a "Grand Total" row appeared, the total number doesn't.

Re: Sum areas/lengths of selected walls

gpowless — Thu, 02 Apr 2015 15:38:11 GMT

This has me perplexed:

I'm trying to schedule the inside lengths of exterior walls for each room / zone. However, where 1 wall is adjacent to more than one zone, the calculation produces one full length in one zone and ignores the rest. If I create a node in the wall at the zone junction it works but the wall ends up split into 2 sections. That would make it pretty hard to manage / modifiy multiple individual sections.

Does anyone have any ideas on how to get the schedule to pick out each wall of a continuous wall for each zone? After two days of trying every which way, I'm stumped.

Thanks,