System and method for quickly counting surface area of component based on Dynamo and Revit
By using the Dynamo plug-in in Revit to calculate the surface area of each element in the three-dimensional model and exporting it to Excel, the problem that existing Revit cannot effectively count the surface area of a special-shaped component is solved, and accurate statistics of the surface area of a special-shaped component is achieved.
Patent Information
- Application Number
- CN202411662156.6
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-11-20
- Publication Date
- 2025-04-08
AI Technical Summary
The existing detailed table statistics method provided by Revit cannot effectively count the surface area of the special-shaped components.
By using the Dynamo plugin in Revit, the surface area of each element in the 3D model is calculated separately and the data is exported to Excel tables.
Accurate statistics on the surface area of special-shaped components are achieved, and the surface area statistical requirements of special-shaped components are met.
Smart Images

Figure CN119784929A_ABST
Abstract
Description
Technical Field
[0001] The invention relates to the field of building construction, and in particular to a system and method for quickly counting component surface areas based on Dynamo and Revit. Background Art
[0002] Revit is widely used to create 3D models of various components, and it can also perform statistics on component lists. The statistics method of Revit's own list is as follows: Through "View → List → New List", select the category of component, and add relevant information to be counted in "Field", such as: "Type", "Thickness", "Length", "Area", "Volume", "Total", etc. The statistics method of Revit's own list is suitable for most conventional components, such as conventional rectangular beams, conventional rectangular plates, conventional rectangular columns, etc., but for special-shaped components, when counting their surface area, the statistics method of Revit's own list cannot meet the needs. Summary of the invention
[0003] The purpose of the present invention is to overcome the defects of the prior art and provide a system and method for quickly counting the surface area of components based on Dynamo and Revit, calculate the surface area of each element respectively and export the data in sequence through Excel to meet the surface area statistics requirements of special-shaped components.
[0004] To achieve the above object, the present invention provides a system for quickly counting component surface areas based on Dynamo and Revit, comprising:
[0005] Revit software for three-dimensional modeling enables the constructed three-dimensional model to include multiple elements, each element corresponding to a basic geometric shape;
[0006] A Dynamo plug-in that can be run in Revit software, including:
[0007] A selection module for selecting primitives in the three-dimensional model;
[0008] An extraction module for obtaining the basic geometric shape of the selected primitive, the extraction module being connected to the selection module;
[0009] A calculation module for calculating the area based on the basic geometric shapes, the calculation module comprising a plurality of calculation units capable of respectively calculating the areas of different basic geometric shapes, the calculation module being connected to the extraction module;
[0010] A terminal module for importing calculated data into an Excel spreadsheet, wherein the terminal module is connected to the extraction module.
[0011] A further improvement of the system for quickly counting component surface areas based on Dynamo and Revit of the present invention is that the Dynamo plug-in also includes a conversion module for unit conversion, and the conversion module is connected between the calculation module and the terminal module.
[0012] The present invention further improves the system for quickly counting component surface areas based on Dynamo and Revit in that the terminal module comprises:
[0013] Path cell used to import a blank Excel table;
[0014] An arrangement unit for controlling the plurality of calculation data to be imported sequentially from row 0 and column 0 of the blank Excel table;
[0015] An importing unit for importing the calculation data, wherein the importing unit is connected to the conversion module.
[0016] A method for quickly counting component surface areas based on Dynamo and Revit, comprising the following steps:
[0017] Step 1: Provide the above-mentioned system for quickly counting component surface areas based on Dynamo and Revit;
[0018] Step 2: Use Revit software to perform 3D modeling on the statistical components;
[0019] Step 3: Run the Dynamo plug-in to automatically export the areas of all elements of the constructed 3D model to an Excel spreadsheet.
[0020] Compared with the prior art, the advantages of the present invention are:
[0021] By calculating the area of each element of the three-dimensional model of the component to be counted, and then exporting the data to an Excel spreadsheet in turn, the overall surface area can be calculated clearly and accurately. BRIEF DESCRIPTION OF THE DRAWINGS
[0022] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the following briefly introduces the drawings required for use in the description of the embodiments. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work.
[0023] Figure 1 It is a three-dimensional model of the component to be counted in the present invention.
[0024] Figure 2 Detailed diagram of the Dynamo plug-in of the present invention.
[0025] In the figure: 1, bottom plate; 2, curved plate; 3, first tree-like column; 4, second tree-like column; 5, rectangular frame. DETAILED DESCRIPTION
[0026] The following describes the embodiments of the present invention through specific examples, and those skilled in the art can easily understand other advantages and effects of the present invention from the contents disclosed in this specification. The present invention can also be implemented or applied through other different specific embodiments, and the details in this specification can also be modified or changed in various ways based on different viewpoints and applications without departing from the spirit of the present invention.
[0027] The system and method for quickly counting component surface areas based on Dynamo and Revit of the present invention are further described in detail below in conjunction with the accompanying drawings and specific embodiments.
[0028] See also Figure 1-2 As shown in the figure, a system for quickly counting component surface areas based on Dynamo and Revit includes:
[0029] Revit software for three-dimensional modeling enables the constructed three-dimensional model to include multiple elements, each element corresponding to a basic geometric shape;
[0030] A Dynamo plug-in that can be run in Revit software. The Dynamo plug-in includes:
[0031] A selection module for selecting primitives in the three-dimensional model;
[0032] An extraction module for obtaining the basic geometric shape of the selected primitive, the extraction module being connected to the selection module;
[0033] A calculation module for calculating the area based on the basic geometric shape, the calculation module comprising a plurality of calculation units capable of respectively calculating the areas of different basic geometric shapes, the calculation module being connected to the extraction module;
[0034] A terminal module for importing calculated data into an Excel spreadsheet, the terminal module being connected to the extraction module.
[0035] Specifically, Figure 1 As shown, the graphic element includes two base plates 1, an arc-shaped plate 2 connected between the two base plates 1, a plurality of first tree-like columns 3 connected at intervals on the outside of the base plates 1, a rectangular frame 5 surrounding the periphery of the plurality of first tree-like columns 3, and a plurality of second tree-like columns 4 connected at intervals on the inside of the base plates 1.
[0036] The calculation accuracy is improved by dividing the 3D modeling into multiple primitives and calculating the surface area one by one.
[0037] Specifically, the calculation unit is a calculation algorithm.
[0038] Specifically, Figure 2 As shown: Select Model Elements is the selection module, Element.Geometry is the extraction module, Solid.Area is the calculation module, and Data.ExportExcel is the terminal module.
[0039] Specifically, the Dynamo plug-in further includes a determination module for determining whether a primitive is selected, and the determination module is connected to the terminal module.
[0040] like Figure 2 As shown: the Boolean is the judgment module.
[0041] When the graphics element is selected using the selection module, the judgment module automatically judges as "yes", and the data can be exported to an Excel table after the judgment. If the graphics element is not selected, the judgment module automatically judges as "no" to prevent the data from being exported to the Excel table. By setting the judgment module, the calculation of components other than the graphics element to be counted can be avoided.
[0042] Preferably, the Dynamo plug-in further includes a conversion module for unit conversion, and the conversion module is connected between the calculation module and the terminal module.
[0043] Specifically, Figure 2 As shown: the conversion module is actually a division algorithm, and the conversion module includes a dividend unit and a divisor unit. The calculation unit is connected to the dividend unit, and the divisor unit can input data by itself.
[0044] The unit of the data obtained by the calculation module is millimeter. By inputting "1000000" into the divisor unit, the unit is converted into square meters for the convenience of statistics.
[0045] Preferably, the terminal module comprises:
[0046] Path cell used to import a blank Excel table;
[0047] Used to control the arrangement cells of the plurality of calculation data to be imported sequentially from row 0 and column 0 of the blank Excel table;
[0048] An importing unit for importing the calculation data, wherein the importing unit is connected to the conversion module.
[0049] Specifically, Figure 2 As shown: file path is the path unit, starRow and starCol are the arrangement units, and data is the import unit.
[0050] Specifically, a blank Excel table is created in advance, its location is found through the path unit and imported into the terminal module.
[0051] The starRow is the starting row, and the starCol is the starting column. By inputting the instruction "0" into the starRow and the starCol respectively, the multiple calculation data are controlled to be imported starting from the 0th row and the 0th column of the blank Excel table.
[0052] Specifically, the terminal module also includes a renaming unit for renaming the worksheet of the blank Excel table.
[0053] like Figure 2 As shown, the renamed cell is sheetName.
[0054] Specifically, the terminal module also includes a writing unit, which is connected to the determination module. When the determination module determines as "yes", the writing unit agrees to import the data into the Excel table. When the determination module determines as "no", the writing unit refuses to import the data into the Excel table.
[0055] like Figure 2 As shown, the write unit is overWrite.
[0056] A method for quickly counting component surface areas based on Dynamo and Revit, comprising the following steps:
[0057] Step 1: Provide the above-mentioned system for quickly counting component surface areas based on Dynamo and Revit;
[0058] Step 2: Use Revit software to perform 3D modeling on the statistical components;
[0059] Step 3: Run the Dynamo plug-in to automatically export the areas of all elements of the constructed 3D model to an Excel spreadsheet.
[0060] It should be noted that the structures, proportions, sizes, etc. illustrated in the drawings of this specification are only used to match the contents disclosed in the specification for people familiar with this technology to understand and read, and are not used to limit the limiting conditions for the implementation of the present invention, so they have no substantial technical significance. Any modification of the structure, change of the proportion relationship or adjustment of the size should still fall within the scope of the technical content disclosed by the present invention without affecting the effects and purposes that can be achieved by the present invention. At the same time, the terms such as "upper", "lower", "left", "right", "middle" and "one" quoted in this specification are only for the convenience of description, and are not used to limit the scope of the implementation of the present invention. The change or adjustment of their relative relationship should also be regarded as the scope of the implementation of the present invention without substantially changing the technical content.
[0061] The above is only a preferred embodiment of the present invention, and does not limit the present invention in any form. Although the present invention has been disclosed as a preferred embodiment as above, it is not used to limit the present invention. Any technician familiar with this profession can make some changes or modifications to equivalent embodiments of equivalent changes using the technical contents disclosed above without departing from the scope of the technical solution of the present invention. However, any simple modification, equivalent change and modification made to the above embodiments based on the technical essence of the present invention without departing from the content of the technical solution of the present invention still fall within the scope of the technical solution of the present invention.
Claims
1. A system for quickly counting component surface areas based on Dynamo and Revit, characterized in that: include: Revit software for three-dimensional modeling enables the constructed three-dimensional model to include multiple elements, each element corresponding to a basic geometric shape; A Dynamo plug-in that can be run in Revit software, including: A selection module for selecting primitives in the three-dimensional model; An extraction module for obtaining the basic geometric shape of the selected primitive, the extraction module being connected to the selection module; A calculation module for calculating the area based on the basic geometric shapes, the calculation module comprising a plurality of calculation units capable of respectively calculating the areas of different basic geometric shapes, the calculation module being connected to the extraction module; A terminal module for importing calculated data into an Excel spreadsheet, wherein the terminal module is connected to the extraction module.
2. The system for quickly counting component surface areas based on Dynamo and Revit as claimed in claim 1, characterized in that: The Dynamo plug-in further includes a conversion module for unit conversion, and the conversion module is connected between the calculation module and the terminal module.
3. The system for quickly counting component surface areas based on Dynamo and Revit as claimed in claim 2, characterized in that: The terminal module comprises: Path cell used to import a blank Excel table; An arrangement unit for controlling the plurality of calculation data to be imported sequentially from row 0 and column 0 of the blank Excel table; An importing unit for importing the calculation data, wherein the importing unit is connected to the conversion module.
4. A method for quickly counting component surface areas based on Dynamo and Revit, characterized in that: Includes steps: Step 1: providing a system for quickly calculating component surface areas based on Dynamo and Revit as described in claim 1; Step 2: Use Revit software to perform 3D modeling on the statistical components; Step 3: Run the Dynamo plug-in to automatically export the areas of all elements of the constructed 3D model to an Excel spreadsheet.