topic BOQ’s how do you organize them with AC to send them to XL ? in Project data & BIM

BOQ’s how do you organize them with AC to send them to XL ?

mthd — Fri, 16 Feb 2024 05:44:25 GMT

Hi, I wanted to how others are organizing bills of quantities in AC to export to a spread sheet like XL ? I would like to know how this is done without GDL scripting. It seems like the scaffolding is in place with the interactive schedules. All we need is a full schedule with all the items needed to complete a project. To be able to add prices formulas and wastage factors etc right inside AC without exporting to a spread sheet or into another application. In the project browser we could have a separate BOQ’s generating while we build the 3D model and add detailed components to it. Just curious to know what others are doing with AC.

Re: BOQ’s how do you organize them with AC to send them to XL ?

Josh Verran — Fri, 16 Feb 2024 06:04:21 GMT

Hi there

No sure if this is useful, but I tend use Interactive Schedules, setup around our classification system, for example a seperate schedule for each branch.
Expression based properties are the key here. Whilst each element might hold the relevant data in unique ways, expression based properties can bring these together in a usable, coordinated way.

Re: BOQ’s how do you organize them with AC to send them to XL ?

mthd — Fri, 16 Feb 2024 10:05:56 GMT

For simplicity sake to explain what I would like AC to do similarly, please watch this short video on how Chief Architect does cost estimates and quantify take offs. Bear in mind that CA is predominantly designed for low rise residential and light commercial work.

This shouldn’t be that hard to organise right inside AC with a special add on for those of us that need it. There is a webinar scheduled for AC Hong Kong on BOQ’s coming soon to show how they do it with AC, probably for much larger and complex projects.

Because some us don’t do very complicated designs and I am familiar with CA. I would simply draw my house in this app if I needed to export quantities for estimates.

Please note it doesn’t really need to be that complicated when you see how they do it with CA.

https://www.youtube.com/watch?v=r-qGpK5BSRY

We can get the idea that all the scheduled information in an AC project can brought together in a similar simple manner for BOQ’s.

Re: BOQ’s how do you organize them with AC to send them to XL ?

Ahmed_K — Fri, 16 Feb 2024 11:33:42 GMT

Hi there,

I use Archicad as a quantity calculation system, all my QTO are based on classification , applied to elements OR building materials, but i trust building materials more,

Having a classification applied to a BM is a good start point to avoid missing / wrong classified elements, it's like a database for all your stuff, a simple rule could be applied :

1 building material = 1 classification item
Multiple copies of building materials for the same BM in reality ( Cladding strong / Cladding Weak etc ) = 1 classification item

then use component schedule to extract data.

When i need to classify elements not BM ( stair treads, objects, windows etc ) i Use Graphic overrides to check for missing / wrong classifications, graphic overrides are applies by class subtree , each group have a color in 3D

Also i Exclude that elements from component schedule if they have a classified BM to avoid duplicate quantities.

generated excel reports are exported to excel, excel can merge them using power-query, All calculations are made there, easier, and error free,

I tried to calculate and assign units inside Archicad, it could be done for elements with a bunch of properties, quantity extraction scenarios definition, and a lot of formulas,

For components / building materials, there's no calculation solution inside archicad.

I hope it helps

Re: BOQ’s how do you organize them with AC to send them to XL ?

mthd — Sat, 17 Feb 2024 06:19:00 GMT

Hi @Ahmed_K, it certainly helps very much to see your method explained here. I particularly like how you check for missing items and duplicates because that is very important. Keeping track of everything being produced in AC is not really that easy but I can certainly learn from your practical method.

Re: BOQ’s how do you organize them with AC to send them to XL ?

mthd — Sat, 17 Feb 2024 01:25:38 GMT

Hi @Josh Verran, Thank you for sharing those tips and I will certainly look into those aspects of AC in the near future. I am currently only using it for 3D modeling, design and drafting. I have used Chief Architect in the past to help with producing framing plans for manual take off entered into a spread sheet. I have also produced roof framing plans with AC using the roof wizard tool for quantity take off.

Re: BOQ’s how do you organize them with AC to send them to XL ?

jl_lt — Sat, 17 Feb 2024 05:43:19 GMT

I can see the Chief Architect guys have a lot of things figured out. Why can´t this software be used for bigger or less standard stuff again?

Re: BOQ’s how do you organize them with AC to send them to XL ?

mthd — Sat, 17 Feb 2024 06:11:18 GMT

AC certainly has the potential with the development of one master schedule quantity list with costing included and a more automated framing system. It just needs to be coordinated and organised. Right now it can get quite complicated when you see what they have to do with C5D estimating.

Re: BOQ’s how do you organize them with AC to send them to XL ?

mthd — Sat, 17 Feb 2024 09:26:35 GMT

Hi, I think I have figured out what I need to do now and how to go about BOQ’s & QTO including a cost estimating spread sheet in Archicad.

I found this excellent video tutorial applicable in my region.

https://www.youtube.com/watch?v=CQ03ZiawKTw

Thank you to all above for your help including the author of the YTV.

Also looking forward to seeing the GS Asia webinar on BOQ’s.

Re: BOQ’s how do you organize them with AC to send them to XL ?

Josh Verran — Sun, 18 Feb 2024 19:57:38 GMT

Perhaps this might help also.
As far as exporting to excel, have a look in the publisher set, and you've got options for List, CSV etc.

Re: BOQ’s how do you organize them with AC to send them to XL ?

Ahmed_K — Sun, 18 Feb 2024 19:30:57 GMT

It says video is private

Update : it works now

Re: BOQ’s how do you organize them with AC to send them to XL ?

Josh Verran — Fri, 23 Feb 2024 22:24:20 GMT

Try a refresh, it should show now.

Re: BOQ’s how do you organize them with AC to send them to XL ?

SenecaDesignLLC — Mon, 19 Feb 2024 06:05:18 GMT

I publish one massive schedule with everything.

Then my excel master file reads the data into the relevant locations for my full quantity list that's organized for printing or showing changes in potential cost.

Re: BOQ’s how do you organize them with AC to send them to XL ?

mthd — Mon, 19 Feb 2024 07:16:22 GMT

Hi @SenecaDesignLLC, I think that would be the preferred method to establish right inside AC. To create a BOQ template like yours would take quite some doing. It is metric in my region and there are different methods of measurements around the globe too. GS could learn much by interviewing you about BOQ’s for the US and those that use imperial measurements.

Re: BOQ’s how do you organize them with AC to send them to XL ?

mthd — Wed, 21 Feb 2024 07:42:20 GMT

Hi, I am waiting for a replay of the BOQ GS webinar from Hong Kong Asia to be posted. I am happy to export my AC project as a DWG file to import into CA and then model the project for take off framing etc and estimating.

My workflow is different to most but it suits the CAD tools that I already own so I like to use them for now. CA doesn’t export or import 3D IFC but it certainly would be great if it did.