A method for generating BIM 3D models based on Dynamo and Excel
Generating BIM three-dimensional models through Dynamo and Excel solves the problems of long manual modeling time and low accuracy during pipeline reconstruction, and achieves fast and accurate model construction, shortens construction period and reduces costs.
Patent Information
- Application Number
- CN202311717600.5
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2023-12-14
- Publication Date
- 2024-11-15
- Estimated Expiration
- 2043-12-14
AI Technical Summary
During the pipeline relocation, the existing technology has a long manual modeling time, extended construction period, high cost, and low model accuracy, which makes it impossible to effectively guide construction.
Using Dynamo and Excel methods, the absolute coordinate origin is determined through drawings, the pipeline chart data is imported, the circular tube and square tube are divided, the three-dimensional model is generated, and the Excel data is read through Dynamo to generate attachments, reducing the work of on-site modeling personnel. Improve model accuracy.
It significantly reduces modeling time, improves model components accuracy, shortens construction period, and ensures the smooth progress of the relocation project.
Smart Images

Figure CN117521227B_ABST
Abstract
Description
Technical Field
[0001] The invention belongs to the technical field of civil engineering, and in particular relates to a method for generating a BIM three-dimensional model based on Dynamo and Excel. Background Art
[0002] Pipeline relocation requires that pipeline information be converted into a BIM model first. However, the amount of existing pipeline information is extremely large. A system has more than a thousand pipeline point information, including the relationship with other points, the XY coordinates of the point, the depth from the ground, and the size of the pipeline. The pipelines are divided into circular pipes and rectangular pipes.
[0003] It takes about one week to build a BIM model for 1,000 pipeline points manually, and the overall modeling time exceeds half a year. It is completely impossible to use the BIM model to guide the relocation construction. This will extend the construction period and increase the cost. Especially when it comes to the placement of different types of pipelines, data generation, etc., the work content of on-site modelers and the improvement of model component accuracy are required. The existing modeling methods require a lot of manpower to complete the corresponding work, and the model accuracy is not high. Summary of the invention
[0004] The purpose of the present invention is to solve the above problems and provide a method for generating BIM three-dimensional models based on Dynamo and Excel, which is based on big data analysis to obtain a way to place different pipeline types and combines data generation to extremely effectively reduce the workload of on-site modelers and improve the accuracy of model components.
[0005] In order to solve the above technical problems, the technical solution of the present invention is: a method for generating a BIM three-dimensional model based on Dynamo and Excel, characterized in that it includes the following steps:
[0006] S1. Determine the absolute coordinate origin according to the drawing, and create the corresponding Revit model file according to the pipeline type in the table;
[0007] S2. Import a specific type of pipeline chart and perform data processing;
[0008] S3. According to the table data, the tubes are divided into round tubes and square tubes, and according to different rules, based on the coordinates of the two end points, the top height, and the radius / height information, a pipeline model is generated and finally placed;
[0009] S4. Import the data in the Excel chart into the model component. The data content includes the two endpoints of the pipeline, the burial method, the pipeline material, the pipeline cover, the pipeline ground, the pipeline outer top, and the pipeline inner bottom;
[0010] S5. Use Dynamo to read the rows filled with information in the "Attachments" table in Excel. The attachment types are divided into the following four categories: well type, box type, valve component type, and grate type. Generate four categories of attachments and finally obtain a complete three-dimensional model of the pipeline.
[0011] Furthermore, the process of establishing the model file in step S1 is as follows: an absolute coordinate origin is selected as the common origin of all model files, and after all pipeline types are generated, they are combined into one file through the origin.
[0012] Furthermore, the step S2 further includes the following sub-steps:
[0013] S21. Input the name of the pipeline type to be imported;
[0014] S22. Import the table into Dynamo, select the type of pipeline to be created, delete the table header that does not contain data, and unify the format through Python programming;
[0015] S23. Extract the area to which each point belongs through pipeline point pre-numbering.
[0016] Furthermore, the unified format in step S22 includes the following steps:
[0017] S221. If the pipeline point pre-number and the connection point number are in a one-to-one relationship, the row data is not processed;
[0018] S222. If the pipeline point pre-number and the connection point number are in a one-to-many relationship, copy the pipeline point pre-number to the blank area to ensure that the data format of each row is consistent.
[0019] Furthermore, the steps of dividing the area in step S23 are as follows:
[0020] S231. Different pipeline types are represented by different letters, where "J" represents water supply, "Z" represents recycled water, "W" represents sewage, "Y" represents rainwater, "R" represents gas, "L" represents electricity, "LD" represents street lights, "XH" represents signals, "D" represents telecommunications, "JK" represents public security monitoring, "G" represents industry, and "ZH" represents integrated pipe gallery. The corresponding letters are obtained through the names selected in step S21;
[0021] S232, Python programming, pre-numbering the pipeline points based on the letters obtained in step S1, the number before the letter is the area where the point is located, and the number after the letter is the number of the point in the area.
[0022] Furthermore, the step S3 includes the following sub-steps:
[0023] S31. Select and create the Revit category of square tube components - duct, and create the Revit category of round tube components - pipe;
[0024] S32. If the generated type is a round tube, the generation rule includes the following steps:
[0025] S321. Generate the center point of the pipe. The size of the circular pipe is expressed as the radius. In this row of data, it is necessary to determine whether the pipe is generated based on the inner bottom or the outer top. If there is a value in the outer top attribute, the height of the center point of the pipe is ([outer top] - radius); if there is a value in the inner bottom attribute, the height of the center point of the pipe is ([inner bottom] + radius). The center point of the pipe is generated using the three indicators of plane coordinates X, Y, and height.
[0026] S322, through the row data obtained in step S222, obtain the relationship that different pipeline center points are directly connected to each other, wherein the pipeline center point obtained in the previous step is the coordinate of the [connection point number], and the [pipeline point pre-number] is the point connected to the point; if there are two rows of data, such that the [pipeline point pre-number] of one row is equal to the [connection point number] of the other row, and the [connection point number] of one row is equal to the [pipeline point pre-number] of the other row, then the pipeline center points corresponding to the two rows of data are taken out and connected to obtain a straight line;
[0027] Step 323, based on the straight line generated in step 322, place the family of circular tubes through Dynamo. Since a circle has no direction, the circular tube component can be directly generated through the straight line;
[0028] S33. If the generated type is a square tube, the generation rule includes the following steps:
[0029] S331. Generate the center point of the pipe. The size of the square pipe is expressed as width x height. In this row of data, it is necessary to determine whether the pipe is generated based on the inner bottom or the outer top. If there is a value in the outer top attribute, the height of the center point of the pipe is ([outer top] - height / 2); if there is a value in the inner bottom attribute, the height of the center point of the pipe is ([inner bottom] + height / 2). The center point of the pipe is generated using the three indicators of plane coordinates X, Y, and height.
[0030] S332 is the same as step S322, finding the row of two connected points through the table and generating a straight line through the center point of the pipeline;
[0031] S333, find two planes that contain the vertices of the straight line and are orthogonal to the straight line;
[0032] S334. On these two planes, find a rectangle whose center point is located at the vertex of the straight line, whose width is parallel to the horizontal plane, and whose dimensions satisfy the width and height of [section dimensions] in the row data;
[0033] S335. Use lofting in Dynamo through two rectangles to obtain the solid of the square tube, and finally generate the square tube component based on the solid.
[0034] Furthermore, the method for calculating the data in step S4 comprises the following steps:
[0035] S41, endpoint, burial method, pipeline material data are directly obtained from the table;
[0036] S42, the pipeline soil cover, pipeline ground value and pipeline outer top value are obtained by combining the pipeline soil cover, pipeline ground and pipeline outer top data of the two end points respectively.
[0037] S43. After extracting the above data, load the data one by one into the corresponding components through Dynamo.
[0038] Furthermore, the four categories of attachments in step S5 are generated as follows:
[0039] S51, Well-type components are all cylindrical and symmetrical based on the Z axis, so there is no rotation angle;
[0040] S52. The box category is symmetrical based on the Z axis and has no rotation angle. The components of the box category are placed on the ground with the bottom flush with the ground. Therefore, the height of the origin of the box component placement is the data of [Ground] in the row data. Use Dynamo to find the family type of the accessory name, and use the three indicators of plane coordinates X, Y, and [Ground] to generate the accessory placement origin and place the corresponding components.
[0041] S53, the grate category is symmetrical based on the Z axis, with no rotation angle. The grate category components are located in the ground, and the top is flush with the ground. Therefore, the height of the grate component placement origin is ([ground] - grate category component height). Use Dynamo to find the family type of the attachment name, and use the plane coordinates X, Y, ([ground] - grate category component height) to generate the attachment placement origin, and place the corresponding component;
[0042] S54. Valve components include inlet and outlet pipes, so the valve is only symmetrical based on the YZ plane. In addition to the placement origin coordinates of the above three categories, it is also necessary to calculate the placement direction of the valve and the radius or cross-sectional size of the inlet and outlet pipes.
[0043] Furthermore, the placement of the well category components in step S51 includes the following sub-steps:
[0044] S511, Well type components are placed based on a certain point. According to the different types of attached pipes (circular pipes, square pipes) and the data of the inner bottom / outer top of the pipe, there are 4 locations for solving the origin height, including:
[0045] If the pipe is a circular pipe and there is a value in the pipe top attribute, the origin height of the attachment is ([Pipe Top] - Diameter - 100);
[0046] If the pipe is a round pipe and there is a value in the inner bottom property of the pipe, the origin height of the attachment is ([Inner bottom of pipe] - 100);
[0047] If the pipe is a square pipe and there is a value in the outer top attribute of the pipe, the origin height of the attachment is ([Outer top of pipe] - height - 100); if the pipe is a square pipe and there is a value in the inner bottom attribute of the pipe, the origin height of the attachment is ([Inner bottom of pipe] - 100);
[0048] S512. Use Dynamo to find the family type of the attachment name, generate the attachment placement origin using the three indicators of plane coordinates X, Y, and height, and place the corresponding component.
[0049] Furthermore, the step S54 also includes the following sub-steps:
[0050] S541, the valve placement origin coordinates are consistent with step S511, and the valve component placed at the point is obtained;
[0051] S542, the default placement angle of the family type of the valve component category is the positive direction of the X axis; use the nodes provided by Dynamo to calculate the angle between the normal vector of the straight line obtained in step S322 or S332 and the positive direction of the X axis at the placement point, and rotate the component by the angle to obtain the valve component with the correct placement direction;
[0052] S543. Obtain the data of the pipe diameter or cross-sectional size in the row of data. If it is a round pipe, correspond the [Pipe Diameter] to the [Nominal Radius] of the round pipe by placing an attribute parameter node. If it is a square pipe, extract the width and height data in the [Cross-sectional Size], correspond them to the [Width] and [Height] of the square pipe by placing an attribute parameter node, and obtain a valve component with the correct placement size.
[0053] The beneficial effects of the present invention are:
[0054] 1. The method for generating a BIM three-dimensional model based on Dynamo and Excel provided by the present invention greatly reduces the modeling time, and puts more work on the simulation, modification and review of the relocation plan, thereby ensuring the smooth progress of the relocation project and shortening the construction period.
[0055] 2. The present invention obtains a method for placing different pipeline types, and combines data generation to effectively reduce the workload of on-site modelers and improve the accuracy of model components. BRIEF DESCRIPTION OF THE DRAWINGS
[0056] Figure 1It is a pipeline table diagram in a method for generating a BIM three-dimensional model based on Dynamo and Excel of the present invention;
[0057] Figure 2 This is a before-and-after comparison diagram of the data after the present invention uses Python programming to unify the format;
[0058] Figure 3 It is a schematic diagram of the present invention generating a straight line through the center point of the pipeline;
[0059] Figure 4 It is a schematic diagram of the present invention loading data into corresponding components one by one through Dynamo. DETAILED DESCRIPTION
[0060] The present invention will be further described below in conjunction with the accompanying drawings and specific embodiments:
[0061] like Figures 1 to 4 As shown, the present invention provides a method for generating a BIM three-dimensional model based on Dynamo and Excel, comprising the following steps:
[0062] S1. Determine the absolute coordinate origin according to the drawing, and create the corresponding Revit model file according to the pipeline type in the table.
[0063] The process of establishing the model file in step S1 is as follows: an absolute coordinate origin is selected as the common origin of all model files, and after all pipeline types are generated, they are combined into one file through the origin.
[0064] In the present invention, the table refers to an Excel table of pipeline point results, which includes pipeline type, pipeline point pre-number, connection point number, burial method, pipeline material, pipe diameter or cross-sectional size, pipeline point category (special, or accessories), plane coordinates (X, Y), elevation (ground, top of the pipe, bottom of the pipe), burial depth, a total of 10 indicators that need to be considered and analyzed.
[0065] Different model files are generated according to pipeline types, each table corresponds to a model, and the generation rules are the same. For example: "Pipeline Status-Electricity.rvt", "Pipeline Status-Electricity.rvt", "Pipeline Status-Electricity.rvt", "Pipeline Status-Electricity.rvt", "Pipeline Status-Electricity.rvt", "Pipeline Status-Electricity.rvt", "Pipeline Status-Electricity.rvt", "Pipeline Status-Electricity.rvt", "Pipeline Status-Electricity.rvt", "Pipeline Status-Electricity.rvt".
[0066] S2. Import a specific type of pipeline diagram and perform data processing.
[0067] Step S2 also includes the following sub-steps:
[0068] S21. Enter the name of the pipeline type to be imported.
[0069] S22. Import the table into Dynamo, select the type of pipeline to be created, delete the table header that does not contain data, and unify the format through Python programming.
[0070] S23. Extract the area to which each point belongs through pipeline point pre-numbering.
[0071] The unified format in step S22 includes the following steps:
[0072] S221. If the pipeline point pre-number and the connection point number are in a one-to-one relationship, the row data will not be processed.
[0073] S222. If the pipeline point pre-number and the connection point number are in a one-to-many relationship, copy the pipeline point pre-number to the blank area to ensure that the data format of each row is consistent.
[0074] The steps of dividing the area in step S23 are as follows:
[0075] S231. Different pipeline types are represented by different letters, where "J" represents water supply, "Z" represents recycled water, "W" represents sewage, "Y" represents rainwater, "R" represents gas, "L" represents electricity, "LD" represents street lights, "XH" represents signals, "D" represents telecommunications, "JK" represents public security monitoring, "G" represents industry, and "ZH" represents integrated pipeline corridors. The corresponding letters are obtained through the names selected in step S21.
[0076] S232, Python programming, pre-numbering the pipeline points based on the letters obtained in step S231, the number before the letter is the area where the point is located, and the number after the letter is the number of the point in the area.
[0077] In this step, the pipeline diagram is as follows Figure 1 shown. Figure 2 This is a comparison chart of the original data and the processed data format, where: Figure 2 (a) represents the original data, and (b) represents the processed data.
[0078] S3. According to the table data, the tubes are divided into round tubes and square tubes. According to different rules and based on the coordinates of the two end points, top height, radius / height information, the pipeline model is generated and finally placed.
[0079] Step S3 includes the following sub-steps:
[0080] S31. Select and create the Revit category of square tube components - duct, and create the Revit category of round tube components - pipe.
[0081] S32. If the generated type is a round tube, the generation rule includes the following steps:
[0082] S321. Generate the center point of the pipe. The size of the circular pipe is expressed as the radius. In this row of data, it is necessary to determine whether the pipe is generated based on the inner bottom or the outer top. If there is a value in the outer top attribute, the height of the center point of the pipe is ([outer top] - radius); if there is a value in the inner bottom attribute, the height of the center point of the pipe is ([inner bottom] + radius). The center point of the pipe is generated using the three indicators of plane coordinates X, Y, and height.
[0083] S322. The row data obtained through step S222 is used to obtain the relationship of direct connection between different pipeline center points, wherein the pipeline center point obtained in the previous step is the coordinate of the [connection point number], and the [pipeline point pre-number] is the point connected to the point; if there are two rows of data, such that the [pipeline point pre-number] of one row is equal to the [connection point number] of another row, and at the same time, the [connection point number] of one row is equal to the [pipeline point pre-number] of another row, then the pipeline center points corresponding to the two rows of data are taken out and connected to obtain a straight line.
[0084] Step 323: Based on the straight line generated in step 322, place the family of circular tubes through Dynamo. Since a circle has no direction, the circular tube component can be directly generated through the straight line.
[0085] S33. If the generated type is a square tube, the generation rule includes the following steps:
[0086] S331. Generate the center point of the pipe. The size of the square pipe is expressed as width x height. In this row of data, it is necessary to determine whether the pipe is generated based on the inner bottom or the outer top. If there is a value in the outer top attribute, the height of the center point of the pipe is ([outer top] - height / 2); if there is a value in the inner bottom attribute, the height of the center point of the pipe is ([inner bottom] + height / 2). The center point of the pipe is generated using the three indicators of plane coordinates X, Y, and height.
[0087] S332 is the same as step S322, finding the row of two connected points through the table and generating a straight line through the center point of the pipeline.
[0088] Since the rectangle has a direction, the square tube will generate square tubes with different rotation angles according to the direction, such as Figure 3 As shown. Therefore, the following steps are required to generate a square tube:
[0089] S333. Find two planes that contain the vertices of the straight line and are orthogonal to the straight line.
[0090] S334. On these two planes, find a rectangle whose center point is located at the vertex of the straight line, whose width is parallel to the horizontal plane, and whose dimensions satisfy the width and height of the [cross-sectional dimensions] in the row data.
[0091] S335. Use lofting in Dynamo through two rectangles to obtain the solid of the square tube, and finally generate the square tube component based on the solid.
[0092] S4. Import the data in the Excel chart into the model component. The data content includes the two endpoints of the pipeline, the burial method, the pipeline material, the pipeline cover, the pipeline ground, the pipeline outer top, and the pipeline inner bottom.
[0093] The method for calculating the data in step S4 includes the following steps:
[0094] S41, endpoint, burial method, pipeline material data are directly obtained from the table.
[0095] S42, the pipeline soil cover, pipeline ground value and pipeline outer top value are obtained by combining the pipeline soil cover, pipeline ground and pipeline outer top data of the two end points respectively.
[0096] S43. After extracting the above data, load the data one by one into the corresponding components through Dynamo, such as Figure 4 shown.
[0097] S5. Use Dynamo to read the rows filled with information in the "Attachments" table in Excel. The attachment types are divided into the following four categories: well type, box type, valve component type, and grate type. Generate four categories of attachments and finally obtain a complete three-dimensional model of the pipeline.
[0098] The four categories of attachments in step S5 are generated as follows:
[0099] S51. Since well-type components are all cylindrical and symmetrical about the Z axis, there is no rotation angle.
[0100] S52. The box category is symmetrical based on the Z axis and has no rotation angle. The components of the box category are placed on the ground with the bottom flush with the ground. Therefore, the height of the origin of the box component placement is the data of [Ground] in the row data. Use Dynamo to find the family type of the accessory name, and use the three indicators of plane coordinates X, Y, and [Ground] to generate the accessory placement origin and place the corresponding components.
[0101] S53. The grate category is symmetrical based on the Z axis and has no rotation angle. The components of the grate category are located in the ground and the top is flush with the ground. Therefore, the height of the grate component placement origin is (
ground
ground
[0102] S54. Valve components include inlet and outlet pipes, so the valve is only symmetrical based on the YZ plane. In addition to the placement origin coordinates of the above three categories, it is also necessary to calculate the placement direction of the valve and the radius or cross-sectional size of the inlet and outlet pipes.
[0103] The placement of the well category components in step S51 includes the following sub-steps:
[0104] S511, Well type components are placed based on a certain point. According to the different types of attached pipes (circular pipes, square pipes) and the data of the inner bottom / outer top of the pipe, there are 4 locations for solving the origin height, including:
[0105] If the pipe is a circular pipe and there is a value in the outer top attribute of the pipe, the origin height of the attachment is ([outer top] - diameter - 100).
[0106] If the pipe is a circular pipe and there is a value in the inner bottom property of the pipe, the origin height of the attachment is ([Inner bottom of pipe] - 100).
[0107] If the pipe is a square pipe and there is a value in the outer top attribute of the pipe, the origin height of the attachment is ([Outer top of pipe] - height - 100).
[0108] If the pipe is a square pipe and there is a value in the inner bottom property of the pipe, the origin height of the attachment is ([Inner bottom of pipe] - 100).
[0109] S512. Use Dynamo to find the family type of the attachment name, generate the attachment placement origin using the three indicators of plane coordinates X, Y, and height, and place the corresponding component.
[0110] Step S54 also includes the following sub-steps:
[0111] S541. The valve placement origin coordinates are consistent with step S511, and the valve component placed at that point is obtained.
[0112] S542. The default placement angle of the family type of the valve component category is the positive direction of the X-axis. Use the nodes provided by Dynamo to calculate the angle between the normal vector of the straight line obtained in step S322 or S332 and the positive direction of the X-axis at the placement point, and rotate the component by this angle to obtain a valve component with the correct placement direction.
[0113] S543. Obtain the data of the pipe diameter or cross-sectional size in the row of data. If it is a round pipe, correspond the [Pipe Diameter] to the [Nominal Radius] of the round pipe by placing an attribute parameter node. If it is a square pipe, extract the width and height data in the [Cross-sectional Size], correspond them to the [Width] and [Height] of the square pipe by placing an attribute parameter node, and obtain a valve component with the correct placement size.
[0114] Those skilled in the art will appreciate that the embodiments described herein are intended to help readers understand the principles of the present invention, and should be understood that the protection scope of the present invention is not limited to such specific statements and embodiments. Those skilled in the art can make various other specific variations and combinations that do not deviate from the essence of the present invention based on the technical revelations disclosed by the present invention, and these variations and combinations are still within the protection scope of the present invention.
Claims
1. A method for generating a BIM three-dimensional model based on Dynamo and Excel, characterized in that: The following steps are involved: S1. Determine the absolute coordinate origin according to the drawing, and create the corresponding Revit model file according to the pipeline type in the table; S2. Import a specific type of pipeline chart and perform data processing; The step S2 also includes the following sub-steps: S21. Input the name of the pipeline type to be imported; S22. Import the table into Dynamo, select the type of pipeline to be created, delete the table header that does not contain data, and unify the format through Python programming; S23, extracting the area to which each point belongs through pipeline point pre-numbering; S3. According to the table data, the tubes are divided into round tubes and square tubes, and according to different rules, based on the coordinates of the two end points, the top height, and the radius / height information, a pipeline model is generated and finally placed; The step S3 comprises the following sub-steps: S31. Select and create the Revit category of square tube components - duct, and create the Revit category of round tube components - pipe; S32. If the generated type is a round tube, the generation rule includes the following steps: S321. Generate the center point of the pipe. The size of the circular pipe is expressed as the radius. In this row of data, it is necessary to determine whether the pipe is generated based on the inner bottom or the outer top. If there is a value in the outer top attribute, the height of the center point of the pipe is ([outer top] - radius); if there is a value in the inner bottom attribute, the height of the center point of the pipe is ([inner bottom] + radius). The center point of the pipe is generated using the three indicators of plane coordinates X, Y, and height. S322, through the row data obtained in step S222, obtain the relationship that different pipeline center points are directly connected to each other, wherein the pipeline center point obtained in the previous step is the coordinate of the [connection point number], and the [pipeline point pre-number] is the point connected to the point; if there are two rows of data, such that the [pipeline point pre-number] of one row is equal to the [connection point number] of the other row, and the [connection point number] of one row is equal to the [pipeline point pre-number] of the other row, then the pipeline center points corresponding to the two rows of data are taken out and connected to obtain a straight line; Step S323, based on the straight line generated in step S322, a family of circular tubes is placed through Dynamo. Since a circle has no direction, a circular tube component can be directly generated through the straight line; S33. If the generated type is a square tube, the generation rule includes the following steps: S331. Generate the center point of the pipe. The size of the square pipe is expressed as width x height. In this row of data, it is necessary to determine whether the pipe is generated based on the inner bottom or the outer top. If there is a value in the outer top attribute, the height of the center point of the pipe is ([outer top] - height / 2); if there is a value in the inner bottom attribute, the height of the center point of the pipe is ([inner bottom] + height / 2). The center point of the pipe is generated using the three indicators of plane coordinates X, Y, and height. S332 is the same as step S322, finding the row of two connected points through the table and generating a straight line through the center point of the pipeline; S333, find two planes that contain the vertices of the straight line and are orthogonal to the straight line; S334. On these two planes, find a rectangle whose center point is located at the vertex of the straight line, whose width is parallel to the horizontal plane, and whose dimensions satisfy the width and height of [section dimensions] in the row data; S335. Using two rectangles, use lofting in Dynamo to obtain the entity of the square tube, and finally generate a square tube component based on the entity; S4. Import the data in the Excel chart into the model component. The data content includes the two endpoints of the pipeline, the burial method, the pipeline material, the pipeline cover, the pipeline ground, the pipeline outer top, and the pipeline inner bottom; S5. Use Dynamo to read the rows filled with information in the "Attachments" in the Excel table. The attachment types are divided into the following four categories: well type, box type, valve component type, and grate type. Generate four categories of attachments and finally obtain a complete three-dimensional model of the pipeline. The four categories of attachments in step S5 are generated as follows: S51, Well-type components are all cylindrical and symmetrical based on the Z axis, so there is no rotation angle; S52. The box category is symmetrical based on the Z axis, with no rotation angle. The components of the box category are placed on the ground, and the bottom is flush with the ground. Therefore, the height of the origin of the box component placement is the data of [ground] in the row data. Use Dynamo to find the family type of the accessory name, and use the three indicators of plane coordinates X, Y, and [ground] to generate the accessory placement origin, and place the corresponding component; S53, the grate category is symmetrical based on the Z axis, with no rotation angle. The grate category components are located in the ground, and the top is flush with the ground. Therefore, the height of the grate component placement origin is ([ground] - grate category component height). Use Dynamo to find the family type of the attachment name, and use the plane coordinates X, Y, ([ground] - grate category component height) to generate the attachment placement origin, and place the corresponding component; S54. Valve components include inlet and outlet pipes, so the valve is only symmetrical based on the YZ plane. In addition to the placement origin coordinates of the above three categories, it is also necessary to calculate the placement direction of the valve and the radius or cross-sectional size of the inlet and outlet pipes.
2. The method for generating a BIM three-dimensional model based on Dynamo and Excel according to claim 1, characterized in that: The process of establishing the model file in step S1 is as follows: an absolute coordinate origin is selected as the common origin of all model files, and after all pipeline types are generated, they are combined into one file through the origin.
3. The method for generating a BIM three-dimensional model based on Dynamo and Excel according to claim 1, characterized in that: The unified format in step S22 includes the following steps: S221. If the pipeline point pre-number and the connection point number are in a one-to-one relationship, the row data is not processed; S222. If the pipeline point pre-number and the connection point number are in a one-to-many relationship, copy the pipeline point pre-number to the blank area to ensure that the data format of each row is consistent.
4. The method for generating a BIM three-dimensional model based on Dynamo and Excel according to claim 1, characterized in that: The steps of dividing the area in step S23 are as follows: S231. Different pipeline types are represented by different letters, where "J" represents water supply, "Z" represents recycled water, "W" represents sewage, "Y" represents rainwater, "R" represents gas, "L" represents electricity, "LD" represents street lights, "XH" represents signals, "D" represents telecommunications, "JK" represents public security monitoring, "G" represents industry, and "ZH" represents integrated pipe gallery. The corresponding letters are obtained through the names selected in step S21; S232, Python programming, pre-numbering the pipeline points based on the letters obtained in step S231, the number before the letter is the area where the point is located, and the number after the letter is the number of the point in the area.
5. The method for generating a BIM three-dimensional model based on Dynamo and Excel according to claim 1, characterized in that: The method for calculating the data in step S4 comprises the following steps: S41, endpoint, burial method, pipeline material data are directly obtained from the table; S42, the pipeline soil cover, pipeline ground value and pipeline outer top value are obtained by combining the pipeline soil cover, pipeline ground and pipeline outer top data of the two end points respectively; S43. After extracting the above data, load the data one by one into the corresponding components through Dynamo.
6. The method for generating a BIM three-dimensional model based on Dynamo and Excel according to claim 1, characterized in that: The placement of the well category components in step S51 includes the following sub-steps: S511, Well type components are placed based on a certain point. According to the different types of attached pipes and the data of the bottom / top of the pipe, there are 4 locations for solving the origin height, including: If the pipe is a circular pipe and there is a value in the pipe top attribute, the origin height of the attachment is ([Pipe Top] - Diameter - 100); If the pipe is a round pipe and there is a value in the inner bottom property of the pipe, the origin height of the attachment is ([Inner bottom of pipe] - 100); If the pipe is a square pipe and there is a value in the outer top attribute of the pipe, the origin height of the attachment is ([Outer top of pipe] - height - 100); if the pipe is a square pipe and there is a value in the inner bottom attribute of the pipe, the origin height of the attachment is ([Inner bottom of pipe] - 100); S512. Use Dynamo to find the family type of the attachment name, generate the attachment placement origin using the three indicators of plane coordinates X, Y, and height, and place the corresponding component.
7. The method for generating a BIM three-dimensional model based on Dynamo and Excel according to claim 1, characterized in that: The step S54 further comprises the following sub-steps: S541, the valve placement origin coordinates are consistent with step S511, and the valve component placed at the point is obtained; S542, the default placement angle of the family type of the valve component category is the positive direction of the X axis; use the nodes provided by Dynamo to calculate the angle between the normal vector of the straight line obtained in step S322 or S332 and the positive direction of the X axis at the placement point, and rotate the component by the angle to obtain the valve component with the correct placement direction; S543. Obtain the data of the pipe diameter or cross-sectional size in the row of data. If it is a round pipe, correspond the [Pipe Diameter] to the [Nominal Radius] of the round pipe by placing an attribute parameter node. If it is a square pipe, extract the width and height data in the [Cross-sectional Size], correspond them to the [Width] and [Height] of the square pipe by placing an attribute parameter node, and obtain a valve component with the correct placement size.
