Morning all,
We are currently plotting our scaffolding in 3D using BricsCAD, and I've noticed that the blocks list will keep a look of all instances of the components we insert. This is very handy to work out quants of the gear, as it is a system scaffold. Doing it by hand is fine until we come to the more complex models where we could have an endless block list. Does anyone know of a way (possibly using lisp?) that we could export the blocks list into a excel file or similar editable format? Basically like a bill of quantities, based on the blocks list.
Appreciate any advice on this, as it would be great bonus of using BricsCAD.
Thanks,
Rory
Comments
DATAEXTRACT does work. Most likely you are selecting to many parameters to report on. DATAEXTRACT will only combine identical rows, so if you've included something like the insertion point to extract, then you won't get a combined count as these will likely differ.
Attach some screengrabs to illustrate what i did to achieve a basic block count extract. The last page is the key one. You essentially de-select everything, then make sure combine equal rows is checked.
Another option would be to use the tools available within your spreadsheet application such as CountIf