Sketchup model-based exterior facade engineering quantity calculation method, equipment and medium

Abstract

The invention relates to the technical field of building information model processing, in particular to an exterior facade engineering quantity calculation method and device based on a Sketchup model and a medium, which can directly start from the designed Sketchup model, add corresponding plug-ins, analyze the Sketchup model and design an algorithm based on related data, and can realize automatic calculation of the exterior facade engineering quantity. According to the method, automatic calculation of the project amount and the construction cost of the exterior facade is achieved through the hierarchical grouping algorithm and the dynamic sectioning technology, a designer only needs to set the unit price of an exterior facade material, the system can automatically calculate the construction cost of the exterior facade, and the construction cost index of the unit building area is further obtained to serve as a design basis. According to the method, time and labor are saved, and the engineering design efficiency and accuracy are greatly improved.

Description

Technical Field

[0001] The present invention relates to the technical field of building information model processing, and in particular to a method, device and medium for calculating facade engineering quantities based on a Sketchup model. Background Art

[0002] During the conceptual design phase, designers often turn to Sketchup to quickly construct the building's facade and outline, facilitating effective communication with project stakeholders and finalizing the final architectural design. However, during the facade design process, designers must consider project cost targets. The complex and varied facade shapes and choice of materials often lead to increased costs, potentially exceeding the budget. To ensure the facade design is both aesthetically pleasing and meets project cost targets, after completing the facade design, designers must calculate the quantities of each material used to determine the total cost. If the cost exceeds the target, the design must be adjusted and the cost recalculated. However, this process is particularly cumbersome in Sketchup, as the software's models are based on meshes. Existing technologies often require designers to estimate using manual spreadsheets, which undoubtedly increases the workload.

[0003] In summary, during the architectural design phase, designers often use Sketchup to quickly build facade models for project communication and confirmation. However, existing technologies have significant drawbacks: Sketchup models are based on triangular face structures and cannot directly output engineering quantity data. Designers need to manually count the areas corresponding to different materials, which is labor-intensive and prone to errors. When faced with complex curved surfaces or irregular facades, manual measurement accuracy is difficult to guarantee, leading to cost accounting deviations. Cost control is disconnected from design, and each plan adjustment requires manual recalculation, which is inefficient. Summary of the Invention

[0004] In view of this, the present invention proposes a method, device and medium for calculating the facade engineering quantity based on the Sketchup model. Starting directly from the designed Sketchup model, corresponding plug-ins are added to parse the Sketchup model, and an algorithm is designed based on relevant data to realize the automatic calculation of the facade engineering quantity.

[0005] To achieve the above object, the technical solution of the present invention is: A method for calculating the quantity of exterior facade engineering based on a Sketchup model comprises the following steps: creating a built-in material price library in a plug-in; Analyze the Sketchup model and automatically group components by floor height and bottom elevation to form a hierarchical structure of floors, facades, and calculation areas. The number of component groups is consistent with the total number of floors. Identify and select the specific floor group name corresponding to the facade engineering quantity calculation from the Sketchup model; For the group name corresponding to the selected target floor, extract the facade subgroup under the group; based on the built-in material price library, filter all faces in the facade subgroup that match the material price library to generate a valid face set; Convert the valid faces into a memory data structure for calculation and classify them into faces parallel to the X-axis or Y-axis according to their normal vectors; generate a cluster of vertical section planes based on the preset section spacing with the lower left corner of all faces as the reference, and perform sectioning on the classified faces to form original section lines; Perform deduplication and intersection breakpoint processing on the original section lines, and filter out short lines with a length less than 50% of the layer height; The processed and filtered lines are divided into two groups: internal section lines and external section lines; Merge external lines of the same material and add up their lengths; Calculate the area corresponding to each external line and summarize it to get the total area of ​​the facade.

[0006] The area calculation formula for each external line is: line length × cutting distance; the cutting distance is a configurable parameter with a value range of 10mm to 100m.

[0007] The project cost calculation step is also included: calling the built-in material price library, multiplying the area of ​​each material by the corresponding unit price, and summing up to get the total cost of the facade; Automatically generate unit area cost indicators based on the total building area.

[0008] The present invention also provides another method for calculating the quantity of facade engineering based on a Sketchup model, comprising the following steps: creating a built-in material price library in a plug-in; creating a Sketchup model project floor information table, including project area, floor height, and floor bottom elevation; Obtain floor data information input by the user, automatically group floors according to floor height and floor bottom elevation, parse the Sketchup model using the floor grouping results, and obtain the surface information of the corresponding components of each floor one by one; Identify and select the specific floor for which facade engineering quantities need to be calculated from the Sketchup model. Based on the built-in material price library, filter all faces of the components corresponding to that floor to generate a face set. Convert all acquired faces into memory structure data for calculation, and classify them into faces parallel to the X and Y axes according to their normal vectors. Generate a cluster of vertical section planes based on the preset section spacing, taking the lower left corner of all faces as the reference, and perform sectioning on the classified faces to form the original section lines. Perform deduplication and intersection breakpoint processing on the original section lines, and filter out short lines with a length less than 50% of the layer height; The processed and filtered lines are divided into two groups: internal section lines and external section lines; Merge external lines of the same material and add up their lengths; Calculate the area corresponding to each external line and summarize it to get the total area of ​​the facade.

[0009] Among them, when automatically grouping floors according to floor height and floor bottom elevation, components within the same elevation range are grouped together, and the total number of component groups is consistent with the total number of floors.

[0010] The area calculation formula for each external line is: line length × cutting distance; the cutting distance is a configurable parameter with a value range of 10mm to 100m.

[0011] The project cost calculation step is also included: calling the built-in material price library, multiplying the area of ​​each material by the corresponding unit price, and summing up to get the total cost of the facade; Automatically generate unit area cost indicators based on the total building area.

[0012] The present invention also provides an electronic device, comprising: a processor; a memory storing a computer program; when the processor executes the computer program, the method for calculating the facade engineering quantity based on the Sketchup model described in the present invention is implemented.

[0013] It also includes: a material price library management module, which is configured to maintain the mapping relationship between material names and unit prices; a dynamic cutting engine module, which is configured to generate cutting plane clusters based on normal vector classification results and cutting spacing parameters; and a cost calculation module, which is configured to generate real-time cost data based on line length, cutting spacing and material unit price.

[0014] The present invention also provides a computer-readable storage medium having computer instructions stored thereon, which, when executed, implement the method for calculating the facade engineering quantity based on the Sketchup model described in the present invention.

[0015] Beneficial effects: 1. This method is a plug-in solution integrated into Sketchup. It uses a hierarchical grouping algorithm and dynamic sectioning technology to automatically calculate the construction quantity and cost of facades. Designers only need to set the unit price of the facade materials, and the system will automatically calculate the construction cost of the facade. It further derives the construction cost index per unit building area as the basis for design. This method not only saves time and effort, but also greatly improves the efficiency and accuracy of engineering design.

[0016] 2. This method uses a plug-in to automatically parse the Sketchup model hierarchy, quickly locate facade subsets by floor level, and select valid calculation surfaces based on a material price database. This replaces the traditional manual face-by-face calculation method, reducing the hours of manual spreadsheet calculations to minutes with the plug-in's automated execution. Designers only need to set the section spacing and material unit price to trigger the entire process.

[0017] 3. This invention uses a dynamic sectioning algorithm to cope with curved surfaces and special-shaped structures: normal vector classification ensures vertical plane recognition accuracy, and vertical section plane clusters are generated with configurable sectioning intervals (10mm-100m). Through intersection breakpoint processing and length filtering (such as filtering out lines less than 50% of the floor height), the area calculation error rate of complex components such as special-shaped curtain walls and curved decorative strips is controlled within 5%.

[0018] 4. This method uses a built-in material price library to directly bind model material names. When designers modify facade materials or adjust the shape, the plug-in automatically re-executes the section calculation and instantly generates new cost indicators. This avoids the lag of re-exporting data and manual calculation required for design changes in traditional processes, ensuring real-time synchronization of cost data during solution iterations.

[0019] 5. The hierarchical grouping rules (floor → facade → calculation area) enforce unified data aggregation logic. For example, when merging lines for "3F facade stone" for calculation, the original data is always linked to the corresponding material face under the "3F" group in the model, eliminating floor attribution errors and material confusion that can easily occur in manual statistics.

[0020] 6. The parametric design of section spacing in this invention supports dynamic adjustment based on project precision requirements: simple, regular facades can use a 100mm spacing to improve calculation speed; complex projects can be fine-tuned to 10mm spacing to ensure detail accuracy. Furthermore, a dynamic filtering threshold based on floor height (minimum retention length = floor height × 0.5) automatically adapts to the varying structural characteristics of super-high-rise buildings and low-rise villas. BRIEF DESCRIPTION OF THE DRAWINGS

[0021] Figure 1 This is a schematic diagram of the specific process of Example 1 of the method of the present invention.

[0022] Figure 2 A schematic structural diagram of an electronic device provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0023] The present invention is described in detail below with reference to the accompanying drawings and embodiments.

[0024] The application provides a facade engineering quantity calculation method based on a Sketchup model. The Sketchup face model is converted into quantifiable engineering data through a hierarchical grouping algorithm and a dynamic sectioning technology. The initialization stage includes creating a plug-in built-in material price library as a benchmark for subsequent material checking, and automatically grouping components by floor elevation to establish a hierarchical structure (floor→ facade→ calculation area). The data extraction stage includes positioning the target floor (e.g., 3F) and extracting its facade sub-group, filtering valid material faces, converting data and classifying by normal vector (X / Y axis parallel faces). The sectioning calculation stage includes taking the lower left corner as the benchmark, sectioning the face to generate lines at intervals, cleaning the line data (de-duplication / disconnection of intersection points / filtering of short lines), and dividing the lines into two groups (internal / external). The result generation stage includes merging external lines of the same material and accumulating the length, calculating the area by “length x interval”, and finally summarizing the total facade area.

[0025] Embodiment 1 The specific process of this embodiment is shown in Figure 1 , including the following steps: Step 1: Build a plug-in and create a built-in material price library in the plug-in as basic data for engineering cost calculation and as a checking standard for materials in the Sketchup model.

[0026] Step 2: Run the Sketchup model program. Perform detailed grouping of components in the Sketchup model. Specifically, automatically group by floor elevation and floor bottom elevation, parse the Sketchup model using the floor grouping result, group components within the same elevation range, define the same group name, and the total number of groups is consistent with the total number of floors. These groups follow multiple hierarchical structures: floor—facade—calculation (or non-calculation) area.

[0027] Step 3: Follow the grouping rules to identify and select the specific floor corresponding grouping name that needs to calculate the facade engineering quantity from the Sketchup model, for example, “3F”. In the group, filter out all component groups with the first-level grouping name “3F”.

[0028] Step 4: For the filtered “3F” component group, further extract the sub-group named facade under this group.

[0029] Step 5: According to the built-in material price library, filter all faces (Face) of the extracted facade sub-group to generate a face set. Only filter the faces corresponding to the materials in the built-in material price library.

[0030] Step 6: Convert the acquired Face surfaces into memory structure data for calculation, and classify them into surfaces parallel to the X and Y axes according to the normal vectors of the surfaces.

[0031] Step 7: Determine the lower left corner of all faces, and calculate and construct vertical planes parallel to the X and Y axes according to the specified sectioning interval (which can be adjusted as needed). Use these planes to section the acquired face surfaces to form sectioning lines.

[0032] Step 8: Filter the section lines, including: clearing duplicate lines in the section lines; breaking the same lines at the intersection, and filtering lines that are less than half the length of the layer height.

[0033] Step 9: Group the filtered cutting lines based on the cutting plane, and use the grouped lines to distinguish the internal cutting lines from the external cutting lines.

[0034] Step 10: For external cutting lines, merge the lines of the same material; the lengths of the merged lines are accumulated, and the cutting spacing remains unchanged.

[0035] Step 11: For all external section lines, multiply the line length by the section spacing to obtain the area corresponding to each external section line; Sum up the areas corresponding to all external section lines to obtain the facade area.

[0036] Example 2: This example further optimizes the grouping process and proposes an optimized example, which specifically includes the following steps: Step 21: Build a plug-in and create a built-in material price library in the plug-in. This will serve as a verification standard for materials in Sketchup models and as basic data for engineering cost calculations.

[0037] Create a Sketchup model project floor information table, including project area, floor height and floor bottom elevation; Step 22: Run the Sketchup model program; The system obtains floor data information input by the user, automatically groups floors according to floor height and floor bottom elevation, and uses the floor grouping results to parse the Sketchup model to obtain the surface information of the corresponding components on each floor one by one. Components within the same elevation range are grouped together, and the total number of component groups is consistent with the total number of floors. Step 23: Identify and select the specific floor in the Sketchup model for which the facade work quantity calculation is required. Based on the built-in material price library, filter all faces of the components corresponding to that floor to generate a face set. Only faces containing materials in the built-in material price library are filtered.

[0038] Step 24: Convert the acquired Face surfaces into memory structure data for calculation, and classify them into surfaces parallel to the X and Y axes according to the normal vectors of the surfaces.

[0039] Step 25: Determine the lower left corner of all faces, and calculate and construct vertical planes parallel to the X and Y axes according to the specified sectioning interval (which can be adjusted as needed). Use these planes to section the acquired face surfaces to form sectioning lines.

[0040] Step 26: Filter the section lines, including: clearing duplicate lines in the section lines; breaking the same lines at the intersection, and filtering lines that are less than half the length of the layer height.

[0041] Step 27: Based on the section plane, group the filtered section lines, and use the grouped lines to distinguish internal section lines from external section lines.

[0042] Step 28: For external cutting lines, merge the lines of the same material; the lengths of the merged lines are accumulated, and the cutting spacing remains unchanged.

[0043] Step 29: For all external section lines, multiply the line length by the section spacing to obtain the area corresponding to each external section line; sum up the areas corresponding to all external section lines to obtain the facade area.

[0044] Furthermore, the method of the present invention can also automatically calculate the construction cost, and the specific implementation steps are as follows: For an external section line, according to the built-in material price library, the area of ​​each material in the area corresponding to the external section line is multiplied by the unit price of the material, and the project cost corresponding to the external section line is obtained by summing up; the project costs corresponding to all external section lines are summed up to obtain the overall project cost.

[0045] The embodiment of the present application also provides an electronic device, Figure 2The structure of an electronic device provided by an embodiment of the present invention is shown. For example, the electronic device 20 may include a processor 21, a memory 22, and a transmission device 23. The processor is configured to execute the method for calculating the amount of facade engineering work based on a Sketchup model described in the above embodiment. The processor and memory may be connected via a bus or other means, with a bus connection being used as an example. The transmission device may be connected to the processor and memory via a wired or wireless connection. The memory, as a non-transitory computer-readable storage medium, may be used to store non-transitory software programs, non-transitory computer executable programs, and modules, such as the program instructions / modules corresponding to the method for calculating the amount of facade engineering work based on a Sketchup model described in the embodiment of the present application. The processor executes the non-transitory software programs, instructions, and modules stored in the memory to execute various processor functions and data processing, thereby implementing the method for calculating the amount of facade engineering work based on a Sketchup model described in the above method embodiment. The memory may include a program storage area and a data storage area. The program storage area may store an operating system and application programs required for at least one function; the data storage area may store data created by the processor, etc. In addition, the memory may include a high-speed random access memory and may also include a non-volatile memory, such as at least one disk storage device, a flash memory device, or other non-volatile solid-state storage device. In some embodiments, the memory may optionally include a memory remotely located relative to the processor, and these remote memories may be connected to the processor via a network. Examples of the above-mentioned network include but are not limited to the Internet, an intranet, a local area network, a mobile communication network, and a combination thereof. The one or more modules are stored in the memory, and when executed by the processor, the facade engineering quantity calculation method based on the Sketchup model in the embodiment is executed.

[0046] Furthermore, the electronic device of the present invention may also include: a material price library management module, configured to maintain the mapping relationship between material names and unit prices; a dynamic cutting engine module, configured to generate a cutting plane cluster based on the normal vector classification results and cutting spacing parameters; a cost calculation module, configured to generate real-time cost data based on line length, cutting spacing and material unit price.

[0047] As another aspect, the present application also provides a computer readable storage medium, which can be the computer readable storage medium contained in the device described in the above embodiments; or can exist independently and not be assembled into the device. The computer readable storage medium can be a tangible storage medium such as a random access memory (RAM), a memory, a read only memory (ROM), an electrically programmable ROM, an electrically erasable programmable ROM, a register, a floppy disk, a hard disk, a removable storage disk, a CD-ROM, or any other form of storage medium known in the art. The computer readable storage medium stores one or more programs used by one or more processors to execute the method for calculating the exterior elevation engineering quantity based on the Sketchup model described in the present application.

[0048] To sum up, the above is only the preferred embodiment of the present application, and is not used to limit the protection scope of the present application. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application shall be included in the protection scope of the present application.

Claims

1. A method for calculating the quantity of facade engineering based on Sketchup model, characterized in that: The following steps are involved: Create a built-in material price library in the plugin; Analyze the Sketchup model and automatically group components by floor height and bottom elevation to form a hierarchical structure of floors, facades, and calculation areas. The number of component groups is consistent with the total number of floors. Identify and select the specific floor group name corresponding to the facade engineering quantity calculation from the Sketchup model; For the group name corresponding to the selected target floor, extract the facade subgroup under the group; Based on the built-in material price library, all faces in the facade subgroup that match the material price library are screened to generate a valid face set; Convert the valid faces into a memory data structure for calculation and classify them into faces parallel to the X-axis or Y-axis according to their normal vectors; generate a cluster of vertical section planes based on the preset section spacing with the lower left corner of all faces as the reference, and perform sectioning on the classified faces to form original section lines; Perform deduplication and intersection breakpoint processing on the original section lines, and filter out short lines with a length less than 50% of the layer height; The processed and filtered lines are divided into two groups: internal section lines and external section lines; Merge external lines of the same material and add up their lengths; Calculate the area corresponding to each external line and summarize it to get the total area of ​​the facade.

2. The method according to claim 1, characterized in that The area calculation formula for each external line is: line length × section spacing; the section spacing is a configurable parameter with a value range of 10mm to 100m.

3. The method according to claim 1 or 2, characterized in that It also includes the steps of calculating the construction cost: calling the built-in material price database, multiplying the area of ​​each material by the corresponding unit price, and summing up to get the total cost of the facade; Automatically generate unit area cost indicators based on the total building area.

4. A method for calculating the quantity of facade engineering based on Sketchup model, characterized in that: The following steps are involved: Create a built-in material price library in the plug-in; create a Sketchup model project floor information table, including project area, floor height and floor bottom elevation; Obtain floor data information input by the user, automatically group floors according to floor height and floor bottom elevation, parse the Sketchup model using the floor grouping results, and obtain the surface information of the corresponding components of each floor one by one; Identify and select the specific floor for which facade engineering quantities need to be calculated from the Sketchup model. Based on the built-in material price library, filter all faces of the components corresponding to that floor to generate a face set. Convert all acquired faces into memory structure data for calculation, and classify them into faces parallel to the X and Y axes according to their normal vectors. Generate a cluster of vertical section planes based on the preset section spacing, taking the lower left corner of all faces as the reference, and perform sectioning on the classified faces to form the original section lines. Perform deduplication and intersection breakpoint processing on the original section lines, and filter out short lines with a length less than 50% of the layer height; The processed and filtered lines are divided into two groups: internal section lines and external section lines; Merge external lines of the same material and add up their lengths; Calculate the area corresponding to each external line and summarize it to get the total area of ​​the facade.

5. The method according to claim 4, characterized in that When automatically grouping floors according to floor height and floor bottom elevation, components within the same elevation range are grouped together, and the total number of component groups is consistent with the total number of floors.

6. The method according to claim 4 or 5, characterized in that The area calculation formula for each external line is: line length × section spacing; the section spacing is a configurable parameter with a value range of 10mm to 100m.

7. The method according to claim 4 or 5, characterized in that It also includes the steps of calculating the construction cost: calling the built-in material price database, multiplying the area of ​​each material by the corresponding unit price, and summing up to get the total cost of the facade; Automatically generate unit area cost indicators based on the total building area.

8. An electronic device, characterized in that: include: processor; A memory storing a computer program; when the processor executes the computer program, the method for calculating the facade engineering quantity based on the Sketchup model according to any one of claims 1 to 7 is implemented.

9. The electronic device according to claim 8, wherein: Also includes: The material price library management module is configured to maintain the mapping relationship between material names and unit prices; A dynamic sectioning engine module is configured to generate a sectioning plane cluster according to a normal vector classification result and a sectioning spacing parameter; The cost calculation module is configured to generate real-time cost data based on line length, section spacing and material unit price.

10. A computer-readable storage medium having computer instructions stored thereon, characterized in that: When the instruction is executed, the method for calculating the facade engineering quantity based on the Sketchup model as described in any one of claims 1 to 7 is implemented.

Images