topic Re: first attempts with Schedules - Listing elements lengths in Collaboration with other software

first attempts with Schedules - Listing elements lengths

Anonymous — Tue, 29 Nov 2016 00:55:49 GMT

Hi there.

The picture is showing the setup for an schedule which I intend to GROUP BY Story and SUM reference variables for each kind of core element.

The result that I would like to have, is 4 lines, for the 4 stories, and GRAND TOTALS of all summed values for each column.

For example,
Wall-Length Beam-Length Column-Length Slab-Area
STORY 1 300m 80m 40 m 200m2

However, the result that I get is hiddenly disagrupping each kind of Wall Profile Type used in each story level.

a) Can you help me to get the above behavior?

b) Is it possible to use Excel and Pivot tables, to summarize this data? ¿Can it be connected to an AC internal database?

Thanks in advance

Re: first attempts with Schedules - Listing elements lengths

Anonymous — Tue, 29 Nov 2016 00:57:24 GMT

attach..

Re: first attempts with Schedules - Listing elements lengths

sinceV6 — Tue, 29 Nov 2016 20:11:23 GMT

Hi.

jacobidiego wrote:
a) Can you help me to get the above behavior?

I don't think you can do what you want with AC schedules.

jacobidiego wrote:
b) Is it possible to use Excel and Pivot tables, to summarize this data? ¿Can it be connected to an AC internal database?

This is the better option. AC will let you list everything you need, but when it comes to filtering, arranging, grouping, etc... the data, a spreadsheet editor will get you there sooner. The way to get this to work is to set up a publisher set for your schedules. Save either as .xls or .txt and link the information (don't just open and edit the resulting files). Should you make any changes, you just click publish again and wait for excel (in this case) to update everything.

I explained this in detail in another thread. Use search to find it.

Best regards.

Re: first attempts with Schedules - Listing elements lengths

Laszlo Nagy — Fri, 02 Dec 2016 12:06:36 GMT

You should create a custom IFC Property and set up multiple mapping rules for that IFC Property. Then schedule the IFC Property.
Here is a video about it:

https://www.youtube.com/watch?v=u-LiZh9NSEo

And here is an article about it:

http://bimblog.bondbryan.com/archicad-18-join-the-ifc-and-cobie-flow-part-2-data-mapping/

Re: first attempts with Schedules - Listing elements lengths

Anonymous — Thu, 08 Dec 2016 11:04:30 GMT

Hi laszlonagy,
Thank you!! I will try with that approach as soon as I get more used to AC.
Another way would be to access the database through SQL but this requires registering as a developer, which seems more bureaucracy.

Rightnow, i am exporting it to a an Excel, and create there the quotation calculation.

One further problem that I have, is that, this building will be built in stages depending on the hause zone and meaning, I am trying to use zones for it but elements dont get assigned to it.
Because of this, I can not filter them in Excel..

http://archicad-talk.graphisoft.com/viewtopic.php?t=54590