Solid Volume report

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

  • 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.

     
    Regards, Jon Summers
    LA Solutions

  • Thanks for that hint !

    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...

    preview

     
    Regards, Jon Summers
    LA Solutions

  • When measuring linear objects there is a catch-all class (what 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.

  • 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  terms a mix-in) TotalLength and similarly for areas TotalAreaThere is no equivalent TotalVolume mix-in that would make your report design simple.

    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

  • 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.

    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).

    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:

    • Reports (and Search tool and in fact the whole MicroStation internally) prefers engineering approach, so you have to always specify exactly what you want to do. MicroStation tools typically hide this complexity, so e.g. Measure volume tool automatically support all element types.
    • You approach is "user's one", so naturally you do not want to take care about internal technical details like how 3D elements are stored.
    Maybe we will find the volume reporting functionality in a coming update of Microstation.

    I have two answers here:

    • It's already there and available for you, as both me and Jon wrote and showed.The only issue is that not all element types are supported (yet), so it's possible to create report for e.g. Solid and/or Parametric Solid, but to work with Smart Solids leads to MicroStation crash.
    • To hope "maybe" anything new will be included is similar to e.g. hoping that Martians will visit you in your office ... it will for sure never happen. When you to discuss anything that should be added to MicroStation, post it to Ideas section.

    The link Jon posted to his web contains useful information.

    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