10 Steps to Create Automations from ARCHICAD to Excel

In this video, we'll walk through 10 Steps to create Automations from ARCHICAD to Excel, focusing on the quantity and cost estimating workflow as an example.

About CONTRABIM:
Our mission is to help Architects, Engineers and Builders navigate the complexities of designing and building with 3D Virtual Models in Archicad BIM Software, through thoughtfully produced templates and training programs to help them implement a strategic workflow, enabling them to deliver projects faster, win more work, reduce waste and increase profits.

CONTRABIM Network:
To serve our community, we've launched the CONTRABIM Network which includes access to all of our Archicad Templates, Training Programs and Tools to help fast track users learning and adoption of BIM. Join the community today to get instant access to training and downloads.

Tools to Help Automate

Free Guides:

(00:00) 10 Steps to Automation
(01:07) Step 1 - Creating Properties
(03:39) Step 2 - Create Reports
(06:30) Step 3 - Load Model Elements with Properties
(08:32) Step 4 - Setup Publisher & File Path
(09:40) Step 5 - Setup Excel to Receive (CXL)
(14:23) Step 6 - Create Excel Template for Automation
(17:18) Step 7 - Connect Excel to Data Sources
(18:28) Step 8 - Publish Reports from ARCHICAD
(22:14) Step 9 - Refresh Excel Reports
(23:32) Step 10 - Review and Analyze Results
(25:04) Tools and Resources to Automate
(26:20) 5 Steps to Estimating Guide

[cesaraugustoperezramirez]

Excelente, lo pondre en práctica. Muchas gracias. Felicitaciones ;)

[CyparissMR]

Hai John. Nice Explanation!. Can this method be applied in managing layer or atribut manager in archicad?

[youtubecommenter]

Amazing! First of all, excellent process development. I followed through but have "teeny tiny" question/ comment; How do you make sure elements from hidden layers or other hidden Boolean Operator elements are *totally* excluded from any final count. I understand the standardization in templates and all but during modeling, some caution is thrown out of the window. Could we do a layer-based/ ArchiCAD element type (you mentioned materials) summary?

[ulrikeklaschka]

Exellent. Would it be possible to show us this with squaremters and volumes? I have a Problem myself with the listing .

[nemeseduard]

Great. But something to ask: in your template it is posible to change $ in any other currency? Can you calculate the costs for example in € or £?

[hazem]

Thank you so much for this great video.

I’m just wondering about these formulas you used to link it to your template.
I’d like to get it, I have GFA deductions and unit counts In separate sources from Archicad but I couldn’t rearrange them to the master stats sheet.

Thank you

[joseluisnheki]

Quisiera saber como puedes ayudarme a crear plantillas propias, no hablo ingles! Solo español ojala puedamos comunicarnos y hacer una colaboración en este tema, y exista un benefició mutuo!...

[mariansdraila]

This is great for cost estimating, but the quantities seem to be too abstract, unless there is something I'm missing! Is there a separate list that includes specifications to all those materials?

[furnaletto]

is there way to use elementary AC24 things to create costs and calculations without your personal commercial too much complex to

[geekarchitect]

This is insane ! Can this be adapted to Latham uses and languages?