Road surface volume generation and calculation method based on matrix distribution

Abstract

The invention discloses a pavement volume generation and quantity calculation method based on matrix distribution. The method comprises the following steps: S1, extracting data of points from CAD (Computer Aided Design) to Excel; s2, importing the data of the Excel into the Dynamo; s3, performing parametric modeling according to the imported data; s4, exporting the model after modeling in the S3 to Revit; and S5, carrying out quantity calculation in Revit: selecting all pavement models of the same type, and carrying out one-key quantity calculation.

Description

Technical Field

[0001] The present invention relates to the field of computer civil engineering, and more specifically, proposes a pavement volume generation and quantity calculation method based on matrix distribution. Background Art

[0002] With the development of building informatization, building information modeling is becoming more and more important. However, the current modeling method is mainly manual modeling by modelers.

[0003] However, the manual modeling method has the characteristics of low efficiency, slow speed, and large engineering workload. As time becomes increasingly precious, how to increase speed, improve efficiency, and reasonably reduce engineering workload, using programming, parametric modeling is the answer of the times. Parametric modeling is a relatively new concept in the civil engineering industry. This patent proposes for the first time to generate pavement from matrix-distributed points with one click, and can calculate the quantity with one click, which innovatively improves the efficiency of civil engineering model construction in specific situations, and also improves the accuracy of the calculation. Summary of the invention

[0004] The technical problem to be solved by the present invention is to solve the problems of low efficiency, slow speed and large engineering workload in the modeling method in the prior art.

[0005] The present invention adopts the following technical solution: a road surface volume generation and volume calculation method based on matrix distribution, comprising the following steps:

[0006] S1: Extract point data from CAD to Excel according to standards ；

[0007] S2: Import Excel data into Dynamo;

[0008] S3: perform parametric modeling based on the imported data;

[0009] S4: Export the model built in S3 to Revit;

[0010] S5: Perform quantity calculation in Revit: select all pavement models of the same type and perform one-click quantity calculation.

[0011] Preferably, the standard for selecting points in S1 is to select a quasi-standard point matrix, where the quasi-standard point matrix refers to a matrix in which the horizontal and vertical coordinates of the points are not evenly distributed at fixed intervals on a two-dimensional plane, but the number of elements in each row and column is equal.

[0012] Preferably, the modeling of S3 includes the following steps:

[0013] S3.1 Input the thickness of the plate, the top elevation of the plate, and the degree of polishing;

[0014] S3.2 processes the input data and generates a model. The specific steps are as follows:

[0015] (1) Clear null values; (2) Unify the input data type in the table to numeric type; (3) Extract the data in the xyz column separately and put it into Point,ByCoordinates to generate the corresponding point; (4) Determine the number of matrix columns by how many identical x's there are in different y's, and determine the number of rows by dividing the total number by the number of columns; (5) Arrange the points generated in step (3) so that the x direction is horizontal and the y direction is vertical; (6) Cut the point list according to the number of rows, so that each sublist is a row; (7) Sort each row so that it reaches a matrix distribution with the x direction as horizontal and the y direction as vertical, and at the same time obtain the number of points in the matrix, The number of rows and columns of the matrix; (8) Sort the points distributed in the matrix in step (7); (9) Arrange every four points in step (8) into a sublist in counterclockwise order, and all these four points form a total list; (10) Move the total list as a whole to form the vertices of the upper surface and the lower surface of the subsequent pavement entity; (11) Connect the two groups of vertices separately, directly using the polygon command; (12) Combine the two groups of polygons into one, which are the two branches of the total list; (13) Transpose the total list horizontally and vertically so that the polygons are grouped in pairs; (14) Directly connect to Soild.ByLoft to complete the modeling.

[0016] Preferably, step (8) comprises the following steps: (a) four points arranged in a quadrilateral shape in a matrix are grouped together, one of the points being the nth point of the matrix arrangement.

[0017] Preferably, the acquisition of the polishing degree includes the following steps: A is the original data, B is the processed data, when A>0: B={Ceiling[(A+0.0001) / m]-1}*m; when A<0: B={Ceiling[(A-0.0001) / m]+1}*m, where Ceiling(X) represents rounding up X, and m is the minimum value of the average lateral spacing and the average longitudinal spacing.

[0018] Preferably, in step S2, the title bar in Excel is also required to be deleted before the Excel data is imported into Dynamo.

[0019] The present invention has the following beneficial effects: the present invention includes extracting data from CAD into an Excel file (recording information of the pavement model, including the location information and elevation information of each plate), obtaining information of the pavement model from the Excel file, performing parametric modeling in Dynamo according to the given information, exporting the model from Dynamo to Revit, and finally performing one-key calculation through Dynamo. During use, the present invention only needs to extract point data from CAD into an Excel table, and then write the path corresponding to the Excel file into Dynamo to complete the modeling part. After the model is built as a whole, it only needs to select a box to calculate the quantity with one key. Compared with the previous manual modeling method, it has the characteristics of simple implementation, low time and economic cost, and no human error. DETAILED DESCRIPTION

[0020] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without making creative work are within the scope of protection of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without making creative work are within the scope of protection of the present invention.

[0021] In the description of the present invention, it should be understood that the terms "center", "longitudinal", "lateral", "length", "width", "thickness", "up", "down", "front", "back", "left", "right", "vertical", "horizontal", "top", "bottom", "inside", "outside", "clockwise", "counterclockwise" and the like to indicate directions or positional relationships are only for the convenience of describing the present invention and simplifying the description, and do not indicate or imply that the referred device or element must have a specific direction, be constructed and operated in a specific direction, and therefore should not be understood as limiting the present invention.

[0022] In addition, the terms "first" and "second" are used for descriptive purposes only and should not be understood as indicating or implying relative importance or implicitly indicating the number of the indicated technical features. Therefore, the features defined as "first" and "second" may explicitly or implicitly include one or more of the features. In the description of the present invention, the meaning of "plurality" is two or more, unless otherwise clearly and specifically defined.

[0023] In the present invention, unless otherwise clearly specified and limited, the terms "installed", "connected", "connected", "fixed" and the like should be understood in a broad sense, for example, it can be a fixed connection, a detachable connection, or an integral connection; it can be a mechanical connection or an electrical connection; it can be a direct connection or an indirect connection through an intermediate medium, it can be the internal connection of two elements or the interaction relationship between two elements. For ordinary technicians in this field, the specific meanings of the above terms in the present invention can be understood according to specific circumstances.

[0024] In the present invention, unless otherwise clearly specified and limited, a first feature being "above" or "below" a second feature may include that the first and second features are in direct contact, or may include that the first and second features are not in direct contact but are in contact through another feature between them. Moreover, a first feature being "above", "above" and "above" a second feature includes that the first feature is directly above and obliquely above the second feature, or simply indicates that the first feature is higher in level than the second feature. A first feature being "below", "below" and "below" a second feature includes that the first feature is directly below and obliquely below the second feature, or simply indicates that the first feature is lower in level than the second feature.

[0025] Example

[0026] The following are only preferred implementations of the present invention. The protection scope of the present invention is not limited to the following embodiments. All technical solutions under the concept of the present invention belong to the protection scope of the present invention.

[0027] The present invention provides a method for generating and calculating road surface volume based on matrix distribution, comprising the following steps:

[0028] S1: Extract point data from CAD to Excel:

[0029] Taking CAD 2023 as an example, click the annotation, find the extracted data, and complete the data extraction according to the instructions given.

[0030] S2: Organize Excel data: delete the title bar in Excel.

[0031] S3: Import Excel data into Dynamo:

[0032] S4: Given data, parametric modeling is performed. The specific processing process can be divided into the following sub-steps:

[0033] (4.1) Input data: input the thickness of the plate, the top elevation of the plate, and the degree of polishing;

[0034] (4.2) Data processing and model generation: The specific steps are as follows:

[0035] (1) Clear null values; (2) Convert the table input data into numeric type and then convert it into a calculable type (read the data into a string first and then convert the string into a numeric type); 3) Extract the data in the xyz column separately and put it into Point,ByCordinates to generate the corresponding point; (4) Determine the number of matrix columns by how many identical x's there are in different y's, and determine the number of rows by dividing the total number by the number of columns; (5) Arrange the points generated in step (3) so that the x direction is horizontal and the y direction is vertical; (6) Cut the point list according to the number of rows, so that each sublist is a row; (7) Sort each row so that it has a matrix distribution with the x direction being horizontal and the y direction being vertical and at the same time Obtain the number of points, rows and columns in the matrix; (8) Sort the points distributed in the matrix in step (7); (9) Arrange every four points in step (8) into a sublist in counterclockwise order, and all these four points form a total list; (10) Move the total list as a whole to form the vertices of the upper surface and the lower surface of the subsequent pavement entity (determine the top elevation and thickness); (11) Connect the two groups of vertices separately and directly use the polygon command; (12) Combine the two groups of polygons into one, which are two branches of the total list; (13) Transpose the total list horizontally and vertically so that the polygons are grouped in pairs; (14) Directly connect to Soild.ByLoft to complete the modeling.

[0036] The acquisition of the degree of polishing in (4.1) includes the following steps: A is the original data, B is the processed data, when A>0: B={Ceiling[(A+0.0001) / m]-1}*m; when A<0: B={Ceiling[(A-0.0001) / m]+1}*m, where Ceiling(X) represents rounding up X, and m is the minimum value of the average horizontal spacing and the average vertical spacing. Here, adding 0.0001 based on the original data is to prevent the original data from being divisible by m. The original data means the data on the drawing, which is the coordinate of a point on a certain coordinate axis in a three-dimensional coordinate system, that is, for a point P(X,Y,Z), in CAD, the original data can be obtained by extracting information; the processed data is the data processed by the above formula on the original data, which is used to sort the original data. That is, by processing the X, Y coordinates of the point, transforming it into a standard point matrix on the plane, and then deducing the position of the original data in the quasi-standard point matrix based on the position of the processed data in the standard point matrix.

[0037] S5: Export the model from Dynamo to Revit:

[0038] Use the DirectShape.ByGeometry node, connect the model to geometry, set the category to floor, then find an existing model from Revit, get its material, and assign it to the model to be exported.

[0039] S6: One-click calculation. You only need to select the road surface to calculate its volume, and then divide it by the thickness of the floor to get the surface area of ​​the floor.

[0040] The above embodiments are only for illustrating the technical concept and features of the present invention, and their purpose is to enable people familiar with the technology to understand the content of the present invention and implement it accordingly, and they cannot be used to limit the protection scope of the present invention. Any equivalent changes or modifications made according to the spirit of the present invention should be included in the protection scope of the present invention.

Claims

1. A method for generating and calculating road surface volume based on matrix distribution, characterized in that: The steps include: S1: Extract point data from CAD to Excel according to standards ； S2: Import Excel data into Dynamo; S3: perform parametric modeling based on the imported data; S4: Export the model built in S3 to Revit; S5: Perform quantity calculation in Revit: select all pavement models of the same type and perform one-click quantity calculation.

2. The method for generating and calculating road surface volume based on matrix distribution according to claim 1, characterized in that: The standard for selecting points in S1 is to select a quasi-standard point matrix, which refers to a matrix on a two-dimensional plane in which the horizontal and vertical coordinates of the points are not evenly distributed at fixed intervals, but the number of elements in each row and each column is equal.

3. The method for generating and calculating road surface volume based on matrix distribution according to claim 1, characterized in that: The S3 modeling process includes the following steps: S3.1 Input the thickness of the plate, the top elevation of the plate, and the degree of polishing; S3.2 processes the input data and generates a model. The specific steps are as follows: (1) Clear null values; (2) Unify the input data type in the table to numeric type; (3) Extract the data in the xyz column separately and put it into Point,ByCoordinates to generate the corresponding point; (4) Determine the number of matrix columns by how many identical x's there are in different y's, and determine the number of rows by dividing the total number by the number of columns; (5) Arrange the points generated in step (3) so that the x direction is horizontal and the y direction is vertical; (6) Cut the point list according to the number of rows, so that each sublist is a row; (7) Sort each row so that it reaches a matrix distribution with the x direction as horizontal and the y direction as vertical, and at the same time obtain the number of points in the matrix, The number of rows and columns of the matrix; (8) Sort the points distributed in the matrix in step (7); (9) Arrange every four points in step (8) into a sublist in counterclockwise order, and all these four points form a total list; (10) Move the total list as a whole to form the vertices of the upper surface and the lower surface of the subsequent pavement entity; (11) Connect the two groups of vertices separately, directly using the polygon command; (12) Combine the two groups of polygons into one, which are the two branches of the total list; (13) Transpose the total list horizontally and vertically so that the polygons are grouped in pairs; (14) Directly connect to Soild.ByLoft to complete the modeling.

4. The method for generating and calculating road surface volume based on matrix distribution according to claim 3, characterized in that , the step (8) includes the following steps: (a) four points arranged in a quadrilateral in the matrix are grouped together, one of which is the nth point of the matrix arrangement.

5. The method for generating and calculating road surface volume based on matrix distribution according to claim 3, characterized in that , the acquisition of the polishing degree includes the following steps: A is the original data, B is the processed data, when A>0: B={Ceiling[(A+0.0001) / m]-1}*m; when A<0: B={Ceiling[(A-0.0001) / m]+1}*m, where Ceiling(X) represents rounding up X, and m is the minimum value of the average horizontal spacing and the average vertical spacing.

6. The method for generating and calculating road surface volume based on matrix distribution according to claim 1, characterized in that ,The step S2 also requires deleting the title bar in Excel before importing the Excel data into Dynamo.