Material Area Output to Excel

We used “Eneroth Material Area Counter” extension to take-off all the materialized area of faces from the SketchUp Model made for real construction project. Many thanks to this free extension by the author Eneroth. One Project SKP file (the V apartment) was attached for details. V apartment SKP file

It is so simple to copy the information in the msgbox after executed this extension to Excel file for further analysis.

As discussed with construction office, we found the need more information combined with results from aforementioned extension. Maybe “multi-tag” function for each materialized face can be expected. Please see the outline of the sketchup modeling framework. We try the sketchup outline to achieve the “multi-tag” function.

As we expected, by the help of Ruby Script, Sketchup can output CSV file to Excel. The CVS format was setup as shown. The hierarchy outline information of one floor architecture layout can be collected and recorded as the Comma-Separated String in each line of the output text file.

However, it was difficult to start scripting without the base knowledge of Sketchup Ruby Script. We studied “Automatic SketchUp RUBY” book and even tried ChatGPT, but not get good results so far.

Any suggestion is deeply appreciated.

Thanks All!

You could consider Dynamic Components

-change the material names to an underscore delimiter rather than a minus sign

  • create a template DC with all the materials, and use facearea to get each one. note you have to use a conversion to sq meters as it returns inches
  • you can use Simjoubert add DC Attributes to populate the existing
  • then build each level template and apply as for the first level

You then have a system of conversion and a method of working from scratch
The reports will be individually based on level, viewable on fly in DC option. or later as a generated report that is sent to excel

2 Likes

Many Thanks! We will try DC ~

1 Like

You may also can check this extension:

ReportArea | SketchUp Extension Warehouse


For learning Ruby, Dan have a nice collection here:

Ruby Learning Resources [WikiLists] - Developers / Ruby API - SketchUp Community

2 Likes

will give you an insight to DC “facearea” and Simjoubert DC extensions

2 Likes

We tried the extension before. It reported to the lowest level of outline. However, all the different material faces together in One Number. It needs to be reported separately.

Thanks for the extension. It also made good!

1 Like