Hi,
From to time, I get questions from my design engineers concerning volumes of all kinds of solids in my design models, I.e, I need the volumes of all the foundations, Columns, The bridge slab and both Abutments.
Normally I measure them one by one with the volume tool in the Analyze tab, copy the information into an e-mail and send it, but there must be a more quick and robust way to do it. If I also could combine the volumes with some Items informations, it could be perfect.
In the new Microstation Connect (Just installed) I have played with the Report function, but I haven't found anything that indicates the possibility to setup a report where I can extract Volume data to export it to an Excel Sheet for further manipulation. Then the engineers could be taught generate the reports by them selves. A win-win situation.
Are there anyone that can help me ?
With thanks in advance.
Ole
Ole Bro said:I can see the problem when requesting volumes for a solid not know what type of solid it is.
When you do not know it, you have to work with all types. But in fact there are several types only, so evaluating a few DGNs provides good idea what types are used usually.
Ole Bro said:I find it quite interesting to be able to provide our contractors with that knowledge so they can calculate competitive prices.
Anything task that is repeated regularly (or at least often enough) is an opportunity for VBA macro (sometimes NET or C++ have to be used when specific feature is not supported in VBA).
Ole Bro said:I have hoped that there was some settings I had overlooked when toying with the Report functionality, but it seems more complex than that.
I think it's not "more complex", but it's about slightly different approaches and priorities:
Ole Bro said:Maybe we will find the volume reporting functionality in a coming update of Microstation.
I have two answers here:
The link Jon posted to his web contains useful information.
Ole Bro said:and the usage of Asphalt, Concrete, Gravel, Steel etc.
It sounds like task for Search tool (which I consider one from the most underestimated tools in MicroStation).
Advanced search allow to quickly build query (which can be later converted to report definition) and it support well all types all 3D element types. It does not allow (at least I do not know about any simple option) to merge more types into one search, but it's easy and quick to define search (like all SmartSolids (BReps) in level xyz), to display results and copy/paste to Excel).
With regards,
Jan
Bentley Accredited Developer: iTwin Platform - AssociateLabyrinth Technology | dev.notes() | cad.point
Ole Bro said:I can see the problem when requesting volumes for a solid not know what type of solid it is
Reports rely on ECSchema data (available in the XML files you will find in ..\MicroStation\ECSchemas). When measuring linear objects there is a catch-all class (what Paul Connelly terms a mix-in) TotalLength and similarly for areas TotalArea. There is no equivalent TotalVolume mix-in that would make your report design simple.
..\MicroStation\ECSchemas
Ole Bro said:Maybe we will find the volume reporting functionality in a coming update of Microstation
See my post below that shows a Report of Volume and Surface Area. Other missing report capability includes centre-of-gravity (COG) or similar for areas and volumes. You might like to post an Idea requesting that COG be made available when defining a report.
Regards, Jon Summers LA Solutions
Jon Summers said:When measuring linear objects there is a catch-all class (what Paul Connelly terms a mix-in) TotalLength and similarly for areas TotalArea. There is no equivalent TotalVolume mix-in that would make your report design simple.
The mix-in you are looking for is called BaseElementSchema:MstnVolume. It supplies Volume and SurfaceArea properties.I don't know if it is accessible from the current version of MicroStation's Reports dialog.
Thanks for that hint Paul Connelly!
On further investigation I see that, in a Report Definition, non-specific element geometric properties Volume and Surface Area are available. Here's the Report preview with those columns added...
Ole Bro said:I need the volumes of all the foundations, Columns, The bridge slab and both Abutments
We've added a Solids Report example to our articles about MicroStation Reports.