Method and system for automatic calculation of quantities based on generated structural model

Abstract

The present application relates to the technical field of quantity digital statistics, and particularly relates to a method and system for automatically calculating quantities based on a generated structure model, the method comprising: constructing a mapping table containing statistical items, data sources and calculation rules; filtering the structure model according to beam types, extracting beam bodies and supporting component family instances and geometric parameters; performing hierarchical model direct acquisition, formula calculation or associated statistical operation; generating a standardized quantity table and embedding the design drawing. The system comprises rule configuration, data extraction, quantity calculation, quantity table generation and result output modules. The present application can realize automatic and accurate statistics of quantities such as concrete, steel bars and drainage components, support precision adjustment in the stages of feasibility study, preliminary design and construction drawing, dynamically update when model parameters change, avoid manual errors, improve the efficiency of technical and economic comparison and cost control, and adapt to the statistical needs of water conservancy professional components.

Description

Technical Field

[0001] This invention belongs to the field of digital statistical engineering quantity technology, specifically relating to a method and system for automatically calculating engineering quantities based on a generated structural model. Background Technology

[0002] Throughout the design and construction cycle of underground powerhouse engineering in pumped storage power stations, the quantity statistics (including concrete, steel reinforcement, embedded components, drainage facilities, etc.) of the rock wall crane beams and ceiling support beams are the core basis for conducting technical and economic comparisons, investment estimations, construction drawing budgets, and cost control. Their statistical efficiency and accuracy directly affect the timeliness of project decision-making and the reliability of cost control. Traditional automated drawing and quantity calculation methods are dominated by the "section method": designers need to manually extract component sections from two-dimensional drawings, calculate the cross-sectional area, multiply it by the component length to obtain the concrete volume, and then manually compile a quantity table based on information such as the number of steel bars and embedded parts indicated on the design drawings. This method has significant drawbacks: 1. Inefficient and difficult to adapt to design iteration: The design of underground powerhouses requires dynamic adjustment of component dimensions according to geological conditions and unit parameters. After each adjustment, cross-sections need to be re-cut and recalculated. Especially in the early stages of design such as pre-feasibility and feasibility studies, parameters change frequently, and manual statistics are difficult to meet the timeliness requirements of "rapid response and selection".

[0003] 2. Insufficient accuracy and easy to produce statistical errors: The cross-section method relies on manual selection of cross-section positions and reading of dimensional data. For detailed components such as the secondary concrete of the rock wall crane beam, drainage steel pipes, and embedded reinforcing bars and steel plates of the ceiling support beam, it is necessary to calculate them separately and then manually add them up. In this process, deviations in data reading and calculation errors can easily lead to deviations in the quantity of work. Especially in the construction drawing stage, such errors may lead to excessive or insufficient material procurement, affecting the progress and cost of the project.

[0004] 3. Data disconnect and reliance on manual transmission: In the existing design process, the 3D model and the quantity statistics are independent of each other; the 3D model is only used as a visualization carrier, and the geometric parameters and family attributes of the components contained therein cannot be directly converted into quantity data. Designers need to manually extract the model information and enter it into the calculation table, which not only increases repetitive work, but also makes it easy for the quantity to be disconnected from the actual design due to the asynchronous data between the "model and table".

[0005] 4. Fragmented processes and lack of technical support lead to a lack of integration between drawing and quantity calculation: Traditionally, drawing and quantity calculation are completely independent serial processes. Drawing software only has the functions of view drawing and graphic annotation, without any connection design related to quantity calculation. It cannot synchronously associate the statistical attributes of components during drawing, nor can it reserve data interfaces for subsequent quantity calculation. Quantity calculation needs to be done manually after drawing is completed, by measuring dimensions from the drawings, extracting annotation information, manually entering the quantity calculation table, and substituting it into the formula. There is no automated connection mechanism throughout the process, making it impossible to realize the synchronous progress of drawing and quantity calculation. Moreover, the manual operation across processes further increases the risk of data deviation and time costs.

[0006] Although some 3D design platforms (such as Revit) provide basic quantity calculation functions, their ability to coordinate drawing and quantity calculation remains significantly limited when considering the specialized characteristics of underground plant rock wall crane beams and ceiling support beams. (1) Poor professional adaptability: The existing platform's statistical function only supports the calculation of volume and area of ​​general building components. It cannot identify special components for water conservancy projects such as drainage steel pipes and cast iron grates of rock wall crane beams, drainage floor drains of ceiling support beams, and anchor bars of structural columns. Designers need to manually supplement the statistics, making it difficult to achieve full component coverage.

[0007] (2) The calculation logic is rigid and cannot be adapted to multiple design stages: the requirements for the accuracy of engineering quantities are different in the pre-feasibility, feasibility study, bidding and construction drawing stages. The existing system lacks differentiated statistical rules and cannot dynamically adjust the calculation accuracy according to the stage requirements, resulting in either redundant or insufficient statistical results.

[0008] (3) Lack of standardized output and dynamic updates: The existing statistical results are mostly presented in the form of raw data, which need to be manually sorted into standardized tables that conform to engineering specifications; and when the parameters of the three-dimensional model are modified, the statistical results cannot be automatically updated synchronously, and the statistical process needs to be re-triggered and the tables need to be manually adjusted, making it difficult to ensure the consistency of the model, engineering quantity and drawings.

[0009] (4) Insufficient module collaboration: The drawing module and the quantity calculation module of the 3D platform are independent of each other, and there is no effective data exchange and process connection design; the component screening range determined during drawing cannot be directly reused in the quantity calculation module, and the screening conditions need to be redefined during quantity calculation; the statistical results generated by the quantity calculation module cannot be automatically adapted to the drawing size, scale parameters and layout style of the drawing, and the table format and size need to be manually adjusted and then manually inserted into the blank area of ​​the drawing; and there is no linkage update mechanism between the two, so when the model parameters change, the drawing module needs to be operated to update the drawing and the quantity calculation module needs to be operated to recalculate.

[0010] In view of this, the present invention is hereby proposed. Summary of the Invention

[0011] To address the aforementioned technical problems in the existing technology, this invention provides a method and system for automatically calculating engineering quantities based on generated structural models, solving the problems of low efficiency and poor accuracy of traditional cross-section method for quantity calculation, as well as insufficient adaptation to existing platforms and difficulty in dynamic updates.

[0012] To achieve the above objectives, the technical solution of the present invention is as follows: The first aspect is a method for automatically calculating engineering quantities based on the generated structural model, including: S1. Identify key geometric features of the 3D structural model to determine the cutting position, and create a sectional view based on the cutting position; set the core parameters of the drawing, and create a design drawing based on the core parameters of the drawing; place the sectional view and plan and elevation views in the design drawing, and perform intelligent annotation on the sectional view and plan and elevation views; create a bill of quantities view that matches the format of the design drawing. S2. Construct a quantity calculation rule mapping table, which clarifies the correspondence between statistical items and the data sources and calculation rules of the three-dimensional structural model; S3. Filter the three-dimensional structural model according to the beam type and extract the family instances and geometric parameters of the beams and supporting components; S4. Based on the quantity calculation rule mapping table, calculate the engineering quantity of each statistical item in the model data extracted in step S3 according to the beam type. S5. Organize the calculation results of step S4 into a standardized engineering quantity table. S6. Embed the standardized engineering quantity table into the corresponding design drawings and output the engineering quantity statistics results.

[0013] Furthermore, step S1 specifically includes: The sectioning position is determined by automatically identifying key geometric features of the structure or by manual drawing by the user, and a section view is created based on the sectioning position; the core parameters of the drawing are set, including the drawing font, view scale, viewport layout and engineering drawing size, and a design drawing is created based on the core parameters of the drawing; the section view and the plan and elevation views are adaptively placed according to the preset viewport layout to generate the upstream and downstream elevation views and the plan layout.

[0014] Furthermore, it also includes: The view is annotated using an intelligent annotation method that links the drawing model with annotation or calculates annotations based on associated parameters. When the design parameters of the 3D structural model change, the drawing content and corresponding annotations are updated synchronously. A bill of quantities table style is created through a dedicated view to form a bill of quantities view that matches the design drawing format, and this view is adaptively placed in the blank area of ​​the design drawing.

[0015] Furthermore, the statistical items include: concrete associated with the rock wall crane beam, concrete of structural column Z1, second-phase concrete, drainage steel pipe, cast iron grate, and embedded reinforcing bars, as well as concrete associated with the ceiling support beam, concrete of structural column Z2, drainage steel pipe, drainage floor drain, embedded reinforcing bars, steel plate, structural column anchor bars, and structural column reinforcing bars. The data sources include direct acquisition from the model, formula calculation, and correlation statistics.

[0016] Furthermore, the specific rules of the computational rule mapping table include: The calculation rule for the concrete associated with the rock wall crane beam is to read the volume parameters of the rock wall crane beam family; The calculation rule for the concrete of the structural columns associated with the rock wall crane beam is to read the volume parameters of the structural column family Z1; The calculation rule for the secondary concrete associated with the rock wall crane beam is to read the volume parameters of the secondary concrete family of the rock wall crane beam; The calculation rule for the drainage steel pipes associated with the rock wall crane beam is to count the number of drainage steel pipe family instances with a specific family name, and then multiply it by the length of a single drainage steel pipe family instance. The calculation rule for the cast iron grates associated with the rock wall crane beam is that their number is consistent with the number of drainage steel pipe family instances; The calculation rule for the pre-embedded reinforcing bars associated with the rock wall crane beam is to multiply the number of structural columns by the number of reinforcing bars in each structural column, then multiply by the length of a single reinforcing bar, and finally multiply by the mass of the reinforcing bar per meter. The number of structural columns is obtained from the Z1 column of the three-dimensional structural model. The calculation rule for the concrete associated with the ceiling support beam is to read the volume parameters of the ceiling support beam family; The calculation rule for the concrete of the structural columns associated with the ceiling support beam is to read the volume parameters of the structural column family Z2. The calculation rule for the drainage steel pipes associated with the ceiling support beam is to count the number of ceiling drainage steel pipe family instances with a specific family name, and then multiply it by the length of a single ceiling drainage steel pipe family instance. The calculation rule for the number of floor drains associated with the ceiling support beam is that its number is consistent with the number of ceiling drainage pipe family instances; The calculation rule for the pre-embedded reinforcing bars associated with the ceiling support beam is to multiply the number of embedded parts by the number of reinforcing bars in each embedded part, then multiply by the length of a single reinforcing bar, and finally multiply by the mass of the reinforcing bar per meter. The number of embedded parts is obtained from the structural foundation or specific family statistics of the three-dimensional structural model. The calculation rule for the steel plate associated with the ceiling support beam is to multiply the number of embedded parts by the length, width, and thickness of the steel plate, and then multiply by 7.85. The length, width, and thickness of the steel plate are taken from the parameters of the embedded part family. The calculation rules for the anchor bars and dowel bars of the structural columns associated with the ceiling support beam are as follows: the number of structural columns multiplied by the number of anchor bars or dowel bars in each structural column, then multiplied by the length of a single anchor bar or dowel bar, and finally multiplied by the mass of the steel bar per meter. The number of structural columns is obtained from the Z2 column of the three-dimensional structural model.

[0017] Furthermore, filtering the three-dimensional structural model according to beam type specifically involves: Use the FilteredElementCollector tool to filter the sets of rock wall crane beam family instances and ceiling support beam family instances in the 3D structural model, respectively. Extracting the family instances and geometric parameters of beams and their supporting components involves reading the volume and length parameters of the beam family instances, as well as the number of supporting structural columns and the specifications of the supporting embedded parts.

[0018] Furthermore, hierarchical computing specifically includes: For statistical projects where the data source is directly obtained from the model, the Revit API method is called to read the geometric parameters of the components; for statistical projects where the data source is calculated using formulas, the preset formulas are substituted into the calculations; for statistical projects where the data source is related statistics, the statistical results of the related components are synchronized.

[0019] Furthermore, the structure of the standardized engineering quantity table includes: number, item, specification, unit, quantity, and remarks; Among them, the number is the automatically generated serial number; the item is the name of the statistical item; the specification is extracted from the family type name or component parameters; the unit is read from the quantity calculation rule mapping table; the quantity is the calculation result of step S4, formatted according to the calculation precision and retaining one to two decimal places; the remarks are used to fill in the calculation basis or design stage information.

[0020] Furthermore, in step S6, embedding the standardized engineering quantity table into the corresponding design drawings specifically includes: Create a ViewDrafting view using the Revit API, use TextNote and DetailLine to draw the table style of the bill of quantities in the ViewDrafting view and fill in the data, then adapt the ViewDrafting view to the blank area of ​​the design drawing and match the scale and frame style of the design drawing.

[0021] Furthermore, it also includes: Step S6: When the parameters of the three-dimensional structural model are modified, steps S2 to S5 are automatically triggered to recalculate the engineering quantities of each statistical item and update the standardized engineering quantity table to ensure the consistency between the three-dimensional structural model and the engineering quantity statistics results.

[0022] Furthermore, in step S3, the calculation accuracy can be adjusted according to the design stage; The design phase includes the pre-feasibility study phase, feasibility study phase, bidding phase, and construction drawing phase. The pre-feasibility study phase retains the statistics of the main components' quantities, while the quantities of secondary components are ignored. The feasibility study phase simplifies the statistics of secondary components, and the quantities of secondary components are obtained by multiplying the main components by the corresponding coefficients of the secondary components. The bidding phase can break down the quantities of main components according to their locations. The construction drawing phase refines the statistics of all components.

[0023] Secondly, a system for automatically calculating engineering quantities based on the generated structural model includes: The rule configuration module is used to build and store a quantity calculation rule mapping table, which clarifies the correspondence between statistical items and the data sources and calculation rules of the three-dimensional structural model. The data extraction module is used to filter the three-dimensional structural model according to the beam type and extract the family instances and geometric parameters of the beams and supporting components. The quantity calculation module is used to calculate the quantity of each statistical item in the model data extracted by the data extraction module according to the beam type, based on the quantity calculation rule mapping table. The scale generation module is used to organize the calculation results of the engineering quantity calculation module into a standardized engineering quantity scale; The output module is used to embed the standardized engineering quantity table into the corresponding design drawings and output the engineering quantity statistics results.

[0024] Compared with existing technologies, the present invention provides a method and system for automatically calculating engineering quantities based on generated structural models. The method includes: constructing a mapping table containing statistical items, data sources, and calculation rules; filtering structural models by beam type, extracting family instances and geometric parameters of beams and supporting components; performing layered model direct acquisition, formula calculation, or correlation statistical operations; generating a standardized engineering quantity table and embedding it into design drawings. The system includes modules for rule configuration, data extraction, engineering quantity calculation, table generation, and result output. This invention enables automated and accurate statistical calculation of quantities for concrete, steel reinforcement, and drainage components, supports accuracy adjustments at the pre-feasibility study, feasibility study, bidding, and construction drawing stages, and allows for dynamic updates when model parameters change, avoiding human error, improving the efficiency of technical and economic comparison and cost control, and adapting to the statistical needs of professional components in water conservancy engineering. Attached Figure Description

[0025] Figure 1 A flowchart illustrating the method for automatically calculating engineering quantities provided in an embodiment of the present invention. Detailed Implementation

[0026] The technical solution of the present invention will be clearly described below with reference to the accompanying drawings. Obviously, the described embodiments are not all embodiments of the present invention. All other embodiments obtained by those skilled in the art without creative effort are within the protection scope of the present invention.

[0027] It should be noted that, unless otherwise specifically stated, the relative arrangement and numerical expressions of the components and steps described in these embodiments should not be construed as limiting the scope of the invention.

[0028] The following description of exemplary embodiments is merely illustrative and is not intended to limit the invention or its application or use in any way. Techniques, methods, and apparatus known to those skilled in the art may not be discussed in detail herein, but where applicable, such techniques, methods, and apparatus should be considered part of this specification.

[0029] Example 1 See Figure 1 , Figure 1 The method for automatically calculating engineering quantities based on the generated structural model proposed in this invention may include the following steps: S1. Identify key geometric features of the 3D structural model to determine the cutting position, and create a sectional view based on the cutting position; set the core parameters of the drawing, and create design drawings based on the core parameters of the drawing; place the sectional view and plan and elevation views in the design drawings, and intelligently annotate the views; create a quantity table view that matches the format of the design drawings; specifically including: S11. Determine the cutting position and create a sectional view: The automatic cutting position is determined by automatically identifying the centerline of the structural column and the key geometric features at the intersection of the rock wall crane beam and the structural column, combined with an intelligent cutting algorithm. Alternatively, the user can manually draw section lines to determine the cutting position, and then create a sectional view based on the cutting position. Specifically, this includes: It offers two sectioning modes: automatic and manual. In automatic sectioning mode, it automatically calculates key locations and creates section views based on preset rules and grid information. In manual sectioning mode, after the user clicks the manual creation button, they draw section lines in the plan view. The plugin captures these section lines and creates a section view based on them. ).

[0030] S12. Set drawing parameters, which include at least the drawing font, view scale, viewport layout, and engineering drawing size. Setting drawing parameters includes four core aspects: The drawing font type provides a drop-down list of text types already loaded in the Revit project (e.g., "Fangsong_GB2312"). Once selected by the user, it will be applied to all automatically generated annotations and text. The scale provides a list of commonly used scales (e.g., 1:50, 1:100, 1:200). Once selected by the user, it will be applied to newly created section views and drawings. The number and layout of viewports are specified by the user, allowing them to define the number of views to be placed on the drawing (e.g., "2 sections, 1 detail"). The plugin provides predefined layout templates such as "side-by-side" and "vertically distributed" based on the number of views. The drawing sheet size provides a list of standard sheet sizes; once selected by the user, it will match the corresponding title block family (drawing frame).

[0031] S13. Create drawings based on the drawing parameters, and adaptively place the sectional views, plan views and elevation views according to the viewport layout to generate upstream and downstream elevation views and plan layout. pass The method involves creating a new drawing based on the selected drawing sheet size. The corresponding title block family will be automatically loaded as the drawing frame. Based on the "Number of Viewports and Layout" template selected by the user in step two, the position and size of each viewport within the drawing frame will be automatically calculated. After dividing the available area within the drawing frame, all sectional views created in step one will be traversed, and viewports will be created sequentially. Place it in the center of the defined area. Automatically and uniformly set the scale of all viewports.

[0032] S14. Intelligent annotation of views, and automatic drawing updates based on parameter-driven methods: The intelligent annotation includes model-view linkage annotation based on model component attributes, or association annotation based on related parameters; when the design parameters of the 3D structural model change, the drawing content and corresponding annotations are adjusted synchronously; two annotation methods are included: Automatic annotation (model-drawing linkage): Annotation information is directly taken from the model component attributes, traversing the views corresponding to each viewport on the drawing, through... Filter the component categories that need to be labeled, and call... of The method automatically annotates the dimensions (based on geometric boundaries) and tags (based on parameters such as type tags, family and family type names) of components, and the plugin's built-in rules prevent overlapping annotations; The calculation annotation (associated with interface parameters) is used for content that needs annotation but lacks direct data in the model (such as anchor spacing and keyway dimensions of rock wall crane beams). Based on the associated component positioning lines and parameters (such as YBDCL_h3), the starting and ending coordinates (XYZ) of the annotation lines are obtained through geometric calculations. After identifying specific components, the corresponding rules are called to calculate the annotation positions, which are then displayed on the view. Create annotations.

[0033] S15. Create a ViewDrafting view using the Revit API. Use TextNote and DetailLine to draw the table style of the bill of quantities in the ViewDrafting view and fill in the data. Adapt the ViewDrafting view to the blank area of ​​the design drawing and match the scale and frame style of the design drawing. The final output includes all views, annotations, and bill of quantities, and is a complete construction detail drawing that can be printed or published.

[0034] S2. Construct a quantity calculation rule mapping table, which clarifies the correspondence between statistical items and the data sources and calculation rules of the 3D structural model; specifically including: S21. Define the data source and calculation rule mapping table: A rule configuration table needs to be created to associate statistical items with objects and calculation methods in the Revit model, as shown in Table 1. Table 1. Mapping Table of Data Sources and Calculation Rules

[0035] The statistical items include: concrete associated with the rock wall crane beam, second-phase concrete, structural column Z1 concrete, drainage steel pipe, cast iron grate, and embedded reinforcing bars, as well as concrete associated with the ceiling support beam, structural column Z2 concrete, drainage steel pipe, drainage floor drain, embedded reinforcing bars, steel plate, structural column anchor bars, and structural column reinforcing bars; data sources include direct acquisition from the model, formula calculation, and correlation statistics.

[0036] As can be seen from Table 1, the specific rules of the quantity calculation rule mapping table include: The calculation rule for the concrete associated with the rock wall crane beam is to read the volume parameters of the rock wall crane beam family; The calculation rule for the concrete of the structural columns associated with the rock wall crane beam is to read the volume parameters of the structural column family Z1; The calculation rule for the secondary concrete associated with the rock wall crane beam is to read the volume parameters of the secondary concrete family of the rock wall crane beam; The calculation rule for the drainage steel pipes associated with the rock wall crane beam is to count the number of drainage steel pipe family instances with a specific family name, and then multiply it by the length of a single drainage steel pipe family instance. The calculation rule for the cast iron grates associated with the rock wall crane beam is that their number is consistent with the number of drainage steel pipe family instances; The calculation rule for the pre-embedded reinforcing bars associated with the rock wall crane beam is to multiply the number of structural columns by the number of reinforcing bars in each structural column, then multiply by the length of a single reinforcing bar, and finally multiply by the mass of the reinforcing bar per meter. The number of structural columns is obtained from the Z1 column of the three-dimensional structural model. The calculation rule for the concrete associated with the ceiling support beam is to read the volume parameters of the ceiling support beam family; The calculation rule for the concrete of the structural columns associated with the ceiling support beam is to read the volume parameters of the structural column family Z2. The calculation rule for the drainage steel pipes associated with the ceiling support beam is to count the number of ceiling drainage steel pipe family instances with a specific family name, and then multiply it by the length of a single ceiling drainage steel pipe family instance. The calculation rule for the number of floor drains associated with the ceiling support beam is that its number is consistent with the number of instances of the ceiling drainage steel pipe family; The calculation rule for the pre-embedded reinforcing bars associated with the ceiling support beam is to multiply the number of embedded parts by the number of reinforcing bars in each embedded part, then multiply by the length of a single reinforcing bar, and finally multiply by the mass of the reinforcing bar per meter. The number of embedded parts is obtained from the structural foundation or specific family statistics of the three-dimensional structural model. The calculation rule for the steel plate associated with the ceiling support beam is to multiply the number of embedded parts by the length, width, and thickness of the steel plate, and then multiply by 7.85. The length, width, and thickness of the steel plate are taken from the parameters of the embedded part family. The calculation rules for the anchor bars and dowel bars of the structural columns associated with the ceiling support beam are as follows: the number of structural columns multiplied by the number of anchor bars or dowel bars in each structural column, then multiplied by the length of a single anchor bar or dowel bar, and finally multiplied by the mass of the steel bar per meter. The number of structural columns is obtained from the Z2 column of the three-dimensional structural model.

[0037] S3. Filter the three-dimensional structural model according to beam type, and extract family instances and geometric parameters of beams and supporting components; the filtering of the three-dimensional structural model according to beam type specifically involves: Use the FilteredElementCollector tool to filter the sets of rock wall crane beam family instances and ceiling support beam family instances in the 3D structural model, respectively. Extracting the family instances and geometric parameters of beams and their supporting components involves reading the volume and length parameters of the beam family instances, as well as the number of supporting structural columns and the specifications of the supporting embedded parts.

[0038] S4. Based on the quantity calculation rule mapping table, calculate the quantities of each statistical item in the model data extracted in step S3 according to beam type. The design stage includes the pre-feasibility study stage, feasibility study stage, bidding stage, and construction drawing stage. In the pre-feasibility study stage, the quantities of major components are retained, while the quantities of minor components are ignored. In the feasibility study stage, the statistics of minor components are simplified, and the quantities of minor components are obtained by multiplying the quantities of major components by the corresponding coefficients of minor components. In the bidding stage, the quantities of major components can be broken down and calculated according to location. In the construction drawing stage, the statistics of all components are refined. Specifically, this includes: S41. Layered calculation specifically includes: For statistical projects where the data source is directly obtained from the model, the Revit API method is called to read the geometric parameters of the components; for statistical projects where the data source is calculated using formulas, the preset formulas are substituted into the calculations; for statistical projects where the data source is related statistics, the statistical results of the related components are synchronized.

[0039] S411. Initialization and Configuration Reading: After the plugin starts, it reads the calculation rule mapping table; S412, Filtering the model by beam type: Create two collections, one for storing the quantities of rock wall crane beams. Used for storing the quantity of ceiling support beams. ;pass Collect all instances of the "Rock Wall Crane Beam" family and the "Ceiling Support Beam" family in the Revit model.

[0040] S42. Traverse beam instances and count them. S421. For each rock wall crane beam, iteratively calculate all items in the rule mapping table whose beam type is "rock wall crane beam", and perform the corresponding operation according to the data source type: If the data is obtained directly from the model, call the function to retrieve the volume parameters, convert the units, and store them in a temporary variable. If it is a formula calculation, call the custom function, and calculate the value from the parameters of the current beam or related components (such as structural columns) according to the formula defined in the rules; Encapsulate the name, specifications (obtainable from the family type name), unit, and calculated quantity of each statistical item into a... Object, added to List.

[0041] S422. For each ceiling support beam, execute the same statistical logic as for the rock wall crane beams, only processing rule items in the calculation rule mapping table whose beam type is ceiling support beam, and encapsulating the results into... Store the object later List.

[0042] S423, Summary Results: The final summary lists of quantities for the rock wall crane beam project are obtained. Summary list of ceiling support beam works .

[0043] S5. Organize the calculation results of step S4 into a standardized engineering quantity table; specifically including: S51. Generate a standard bill of quantities: The structure of a standardized bill of quantities includes: number, item, specification, unit, quantity, and remarks; where the number is an automatically generated serial number; the item is the name of the statistical item; the specification is extracted from the family type name or component parameters; the unit is read from the quantity calculation rule mapping table; the quantity is the calculation result of step S3, formatted according to the calculation precision and retaining one to two decimal places; the remarks are used to fill in the calculation basis or design stage information.

[0044] Specifically, firstly, dynamically create in the code ,Should The column structure is set as number, item, specification, unit, quantity, and remarks; Next to Perform data population: The numbering is an automatically generated sequence number (e.g., 1, 2, 3...); the item column is filled with the statistical item name (e.g., "concrete" or "drainage steel pipe"); the specification column is extracted from the family type name or specific parameter (e.g., "C30"); the unit column is read from the rule mapping table; the quantity column is filled with the summary result of the engineering quantity calculated in the second step, and the value is formatted according to the specific content (keeping the corresponding decimal places); the remarks column can be filled with auxiliary information or left blank.

[0045] Finally passed create (View Details Table), according to The column structure is Add the corresponding fields and populate them with data. Once finished, place the view details table onto the drawing.

[0046] S6. Embed the standardized engineering quantity table into the corresponding design drawings and output the engineering quantity statistics results; specifically including: The view containing the standardized quantity table from step S5 is adapted. Revit API is used to call relevant functions to ensure the view's scale matches the design drawing scale created in step S1, guaranteeing consistency between the quantity table's dimensions, text display, and the overall drawing style. Simultaneously, considering the drawing frame specifications and the layout of existing views (section views, floor plans, upstream and downstream elevation views), the plugin's blank area recognition function automatically locates areas in the drawing not occupied by viewports or annotations. The view is preferentially placed in blank corners of the drawing, ensuring it doesn't obscure core views or overlap annotations. View boundaries are adjusted to align the quantity table view with other views, guaranteeing a neat and organized drawing layout.

[0047] After embedding the views, verify the completeness of the design drawings. Confirm that the drawings contain core views such as the sectional views, plan layout, and upstream and downstream elevation views created in step S1, as well as the intelligent annotations completed in step S1 (including component dimension annotations, type markings, etc.). At the same time, confirm that the embedded standardized engineering quantity table is complete, the table column structure conforms to the number, item, specification, unit, quantity, and remarks, and the data covers statistical items such as concrete for rock wall crane beams, concrete for ceiling support beams, embedded reinforcing bars, drainage steel pipes, and drainage floor drains, forming a complete result containing views, annotations, and engineering quantity data.

[0048] Using Revit's built-in functions, the complete deliverables can be exported in a printable or publishable format. The output file automatically carries project-related identification information (such as project name, drawing number, and drawing date), which facilitates document traceability and management for subsequent design briefings, quantity verification, and other work. Ultimately, it forms a quantity statistics result that can be directly used by project participants such as design, construction, and cost auditing.

[0049] Example 2 The system for automatically calculating engineering quantities based on the generated structural model proposed in this invention includes: M1, the rule configuration module, is used to build and store the quantity calculation rule mapping table, which clarifies the correspondence between statistical items and the data sources and calculation rules of the three-dimensional structural model; M2, the data extraction module, is used to filter the three-dimensional structural model according to the beam type and extract the family instances and geometric parameters of the beam and its supporting components; M3, the quantity calculation module, is used to calculate the quantity of each statistical item in the model data extracted by the data extraction module according to the beam type, based on the quantity calculation rule mapping table. M4, Scale Generation Module, is used to organize the calculation results of the engineering quantity calculation module into a standardized engineering quantity scale; M5, Output Module, is used to embed the standardized engineering quantity table into the corresponding design drawings and output the engineering quantity statistics results.

[0050] In summary, the present invention has the following advantages: 1. Automatically extract model data and calculate quantities according to rules, replacing the manual cross-section method, reducing repetitive work and errors, and ensuring accuracy meets engineering requirements; 2. The statistical accuracy can be adjusted according to the feasibility study / preliminary design / construction drawing stage, without the need for additional tools, meeting the cost accounting needs of each stage; 3. For hydraulic engineering components such as concrete, steel bars, drainage steel pipes, and embedded reinforcing bars associated with rock wall crane beams and ceiling support beams, a customized quantity calculation rule mapping table is used to achieve full-type coverage statistics, solving the problem of insufficient adaptability of general 3D platforms to the statistics of hydraulic engineering components; 4. Automatically generate standardized engineering quantity tables and embed them into drawings to directly support subsequent work such as investment estimation and material procurement.

[0051] The above specific embodiments are only used to illustrate the technical solutions of the present invention and are not intended to limit it. Although the present invention has been described in detail with reference to examples, those skilled in the art should understand that modifications or equivalent substitutions can be made to the technical solutions of the present invention without departing from the scope of the technical solutions of the present invention, and all such modifications or substitutions should be covered within the scope of the claims of the present invention.

Claims

1. A method for automatically calculating engineering quantities based on a generated structural model, characterized in that, include: S1. Identify the key geometric features of the three-dimensional structural model to determine the cutting position, and create a cross-sectional view based on the cutting position; Set the core parameters of the drawing, and create the design drawing based on the core parameters of the drawing; Place sectional views, plan views, and elevation views in the design drawings, and intelligently annotate the sectional views, plan views, and elevation views; Create a bill of quantities view that matches the design drawing format; S2. Construct a quantity calculation rule mapping table, which clarifies the correspondence between statistical items and the data sources and calculation rules of the three-dimensional structural model; S3. Filter the three-dimensional structural model according to beam type, and extract family instances and geometric parameters of beams and supporting components; the filtering of the three-dimensional structural model according to beam type specifically involves: Use the FilteredElementCollector tool to filter the sets of rock wall crane beam family instances and ceiling support beam family instances in the 3D structural model, respectively. Extracting the family instances and geometric parameters of beams and their supporting components involves reading the volume and length parameters of the beam family instances, as well as the number of supporting structural columns and the specifications of the supporting embedded parts. S4. Based on the quantity calculation rule mapping table, calculate the engineering quantity of each statistical item in the model data extracted in step S3 according to the beam type. Layered computing specifically includes: For statistical projects where the data source is directly obtained from the model, the Revit API methods are called to read the geometric parameters of the components; for statistical projects where the data source is calculated using formulas, the preset formulas are substituted into the calculations; for statistical projects where the data source is related statistics, the statistical results of the related components are synchronized. S5. Organize the calculation results of step S4 into a standardized engineering quantity table. S6. Embed the standardized engineering quantity table into the corresponding design drawings and output the engineering quantity statistics results.

2. The method for automatically calculating engineering quantities based on the generated structural model according to claim 1, characterized in that, Step S1 specifically includes: The sectioning position is determined by automatically identifying key geometric features of the structure or by manual drawing by the user, and a section view is created based on the sectioning position; the core parameters of the drawing are set, including the drawing font, view scale, viewport layout and engineering drawing size, and a design drawing is created based on the core parameters of the drawing; the section view and the plan and elevation views are adaptively placed according to the preset viewport layout to generate the upstream and downstream elevation views and the plan layout.

3. The method for automatically calculating engineering quantities based on the generated structural model according to claim 2, characterized in that, Also includes: The view is annotated using an intelligent annotation method that links the drawing and the model or calculates annotations based on associated parameters. When the design parameters of the 3D structural model change, the drawing content and corresponding annotations are updated synchronously. Create a bill of quantities table style using a dedicated view, forming a bill of quantities view that matches the design drawing format, and then adaptively place this view in the blank area of ​​the design drawing.

4. The method for automatically calculating engineering quantities based on the generated structural model according to claim 1, characterized in that, The statistical items include: concrete associated with the rock wall crane beam, concrete of structural column Z1, second-phase concrete, drainage steel pipe, cast iron grate, and embedded reinforcing bars, as well as concrete associated with the ceiling support beam, concrete of structural column Z2, drainage steel pipe, drainage floor drain, embedded reinforcing bars, steel plate, structural column anchor bars, and structural column reinforcing bars. The data sources include direct acquisition from the model, formula calculation, and correlation statistics.

5. The method for automatically calculating engineering quantities based on the generated structural model according to claim 4, characterized in that, The specific rules of the quantity calculation rule mapping table include: The calculation rule for the concrete associated with the rock wall crane beam is to read the volume parameters of the rock wall crane beam family; The calculation rule for the concrete of the structural columns associated with the rock wall crane beam is to read the volume parameters of the structural column family Z1; The calculation rule for the secondary concrete associated with the rock wall crane beam is to read the volume parameters of the secondary concrete family of the rock wall crane beam; The calculation rule for the drainage steel pipes associated with the rock wall crane beam is to count the number of drainage steel pipe family instances with a specific family name, and then multiply it by the length of a single drainage steel pipe family instance. The calculation rule for the cast iron grates associated with the rock wall crane beam is that their number is consistent with the number of drainage steel pipe family instances; The calculation rule for the pre-embedded reinforcing bars associated with the rock wall crane beam is to multiply the number of structural columns by the number of reinforcing bars in each structural column, then multiply by the length of a single reinforcing bar, and finally multiply by the mass of the reinforcing bar per meter. The number of structural columns is obtained from the Z1 column of the three-dimensional structural model. The calculation rule for the concrete associated with the ceiling support beam is to read the volume parameters of the ceiling support beam family; The calculation rule for the concrete of the structural columns associated with the ceiling support beam is to read the volume parameters of the structural column family Z2. The calculation rule for the drainage steel pipes associated with the ceiling support beam is to count the number of ceiling drainage steel pipe family instances with a specific family name, and then multiply it by the length of a single ceiling drainage steel pipe family instance. The calculation rule for the number of floor drains associated with the ceiling support beam is that its number is consistent with the number of ceiling drainage pipe family instances; The calculation rule for the pre-embedded reinforcing bars associated with the ceiling support beam is to multiply the number of embedded parts by the number of reinforcing bars in each embedded part, then multiply by the length of a single reinforcing bar, and finally multiply by the mass of the reinforcing bar per meter. The number of embedded parts is obtained from the structural foundation or specific family statistics of the three-dimensional structural model. The calculation rule for the steel plate associated with the ceiling support beam is to multiply the number of embedded parts by the length, width, and thickness of the steel plate, and then multiply by 7.

85. The length, width, and thickness of the steel plate are taken from the parameters of the embedded part family. The calculation rules for the anchor bars and dowel bars of the structural columns associated with the ceiling support beam are as follows: the number of structural columns multiplied by the number of anchor bars or dowel bars in each structural column, then multiplied by the length of a single anchor bar or dowel bar, and finally multiplied by the mass of the steel bar per meter. The number of structural columns is obtained from the Z2 columns of the three-dimensional structural model.

6. The method for automatically calculating engineering quantities based on the generated structural model according to claim 1, characterized in that, The structure of the standardized engineering quantity table includes: number, item, specification, unit, quantity, and remarks; Among them, the number is the automatically generated serial number; the item is the name of the statistical item; the specification is extracted from the family type name or component parameters; the unit is read from the quantity calculation rule mapping table; the quantity is the calculation result of step S4, formatted according to the calculation precision and retaining one to two decimal places; the remarks are used to fill in the calculation basis or design stage information.

7. The method for automatically calculating engineering quantities based on the generated structural model according to claim 1, characterized in that, Step S6, embedding the standardized engineering quantity table into the corresponding design drawings, specifically includes: Create a ViewDrafting view using the Revit API, use TextNote and DetailLine to draw the table style of the bill of quantities in the ViewDrafting view and fill in the data, then adapt the ViewDrafting view to the blank area of ​​the design drawing and match the scale and frame style of the design drawing.

8. The method for automatically calculating engineering quantities based on the generated structural model according to claim 1, characterized in that, Also includes: Step S7: When the parameters of the three-dimensional structural model are modified, steps S2 to S5 are automatically triggered to recalculate the quantities of each statistical item and update the standardized quantity table to ensure the consistency between the three-dimensional structural model and the quantity statistics results.

9. The method for automatically calculating engineering quantities based on the generated structural model according to claim 1, characterized in that, In step S3, the calculation accuracy can be adjusted according to the design stage; The design phase includes the pre-feasibility study phase, the feasibility study phase, the bidding phase, and the construction drawing phase. The pre-feasibility study phase retains the statistics of the main components' quantities, while the quantities of secondary components are ignored. The feasibility study phase simplifies the statistics of secondary components, and the quantities of secondary components are obtained by multiplying the main components by the corresponding coefficients of the secondary components. The bidding phase can break down the quantities of main components according to their locations. The construction drawing phase refines the statistics of all components.

10. A system for automatically calculating engineering quantities based on a generated structural model, characterized in that, include: The rule configuration module is used to build and store a quantity calculation rule mapping table, which clarifies the correspondence between statistical items and the data sources and calculation rules of the three-dimensional structural model. The data extraction module is used to filter the 3D structural model according to beam type, and extract family instances and geometric parameters of beams and supporting components; the filtering of the 3D structural model according to beam type specifically includes: Use the FilteredElementCollector tool to filter the sets of rock wall crane beam family instances and ceiling support beam family instances in the 3D structural model, respectively. Extracting the family instances and geometric parameters of beams and their supporting components involves reading the volume and length parameters of the beam family instances, as well as the number of supporting structural columns and the specifications of the supporting embedded parts. The quantity calculation module is used to calculate the quantity of each statistical item in the model data extracted by the data extraction module according to the beam type, based on the quantity calculation rule mapping table. Layered computing specifically includes: For statistical projects where the data source is directly obtained from the model, the Revit API methods are called to read the geometric parameters of the components; for statistical projects where the data source is calculated using formulas, the preset formulas are substituted into the calculations; for statistical projects where the data source is related statistics, the statistical results of the related components are synchronized. The scale generation module is used to organize the calculation results of the engineering quantity calculation module into a standardized engineering quantity scale; The output module is used to embed the standardized engineering quantity table into the corresponding design drawings and output the engineering quantity statistics results.

Images