Mass Design Method for Multi-Row Parallel Pipeline Anchors

Abstract

This invention discloses a batch design method for anchor blocks in multi-row parallel pipelines. When there are many anchor blocks in multi-row parallel pipelines, the anchor block design requires individual operation using a single anchor block design program, which is inefficient. This invention selects a dedicated EXCEL file for pre-processing basic anchor block data based on the actual number of water pipelines; it uses EXCEL macro commands to process the data in the dedicated EXCEL file to generate a basic anchor block data file; based on the basic anchor block data file, it uses AutoCAD VBA technology to sequentially complete the batch automated design of anchor block shapes, anchor block plan views, and section views according to the anchor block numbering order, and generates an anchor block shape parameter file; it automatically annotates the main dimensions; finally, it uses EXCEL macro commands to process the anchor block shape parameter file to generate the final anchor block shape parameter table. This method is convenient to operate, provides intuitive results, and facilitates subsequent construction drawing generation, further improving the efficiency of anchor block design.

Description

Technical Field

[0001] This invention relates to the field of water pipeline design, and in particular to a method for mass design of anchor blocks for multi-row parallel pipelines. Background Technology

[0002] For water supply pipelines with more than one row and varying diameters, current technology only allows for automated design of single-row parallel pipeline anchors, which improves anchor design efficiency to some extent. However, when the number of anchors is large, anchor design requires individual operation using a single anchor design program for multiple rows of parallel pipelines, making batch design impossible and resulting in low design efficiency. Summary of the Invention

[0003] The purpose of this invention is to provide a method for batch design of anchor blocks for multiple rows of parallel pipelines.

[0004] To achieve the above objectives, the present invention adopts the following technical solution:

[0005] The batch design method for multi-row parallel pipeline anchor blocks according to the present invention includes the following steps:

[0006] S1. Select the dedicated EXCEL file for pre-processing basic data of the town piers based on the actual number of water pipelines.

[0007] S2, obtain the basic data required by the pre-processing dedicated EXCEL file, and use EXCEL macro commands to process the data in the pre-processing dedicated EXCEL file to generate the basic data file of the town pier;

[0008] S3. Using AutoCAD VBA technology, based on the basic data file of the pier, the automatic design of the pier shape is completed sequentially according to the pier number order, and the pier shape parameter file is generated.

[0009] S4 uses AutoCAD VBA technology to automatically generate plan and section views of the piers in batches based on the basic data file of the piers, and automatically annotates the main dimensions.

[0010] S5. Use EXCEL macro commands to process the pier shape parameter file and generate the final pier shape parameter table.

[0011] Furthermore, the basic data includes the number of anchor blocks, anchor block serial number, number of pipes, outer diameter and wall thickness of each pipe, horizontal turning angle of the pipe at the anchor block, angle between the upstream and downstream pipes and the horizontal plane, and water pressure inside the pipe.

[0012] Furthermore, both the basic data file and the shape parameter file of the town pier are in txt format.

[0013] Furthermore, the automated design of the pier shape described in step S3 is based on the pier's stress characteristics, anti-slip stability safety factor, and base stress to automatically design a pier that meets the specifications.

[0014] The advantage of this invention lies in the fact that when there are many anchor blocks on multiple rows of parallel pipelines, the anchor block design requires individual operation using a single anchor block design program for each row of parallel pipelines, resulting in low design efficiency. This invention enables batch design of anchor blocks for multiple rows of parallel pipelines. The method is convenient to operate, and the final design shape and size parameter table of the anchor blocks are automatically generated, providing intuitive results and facilitating subsequent construction drawing generation, further improving the efficiency of anchor block design. Attached Figure Description

[0015] Figure 1 This is a flowchart of the method described in this invention.

[0016] Figure 2 It is a dedicated EXCEL file for preprocessing the method described in this invention.

[0017] Figure 3 It is the dedicated EXCEL file macro command window interface for preprocessing in the method described in this invention.

[0018] Figure 4 This is the window interface for the batch design of multi-row parallel pipeline anchor blocks in the method described in this invention.

[0019] Figure 5 This is the window interface for automatically generating plan and cross-sectional views of the pier body in batches using the method described in this invention.

[0020] Figure 6 This is a schematic diagram of the automatically generated pier body shape in batches using the method described in this invention.

[0021] Figure 7 This is a schematic diagram of the pier body shape automatically generated in batches using the method described in this invention. Detailed Implementation

[0022] The technical solutions in the embodiments of the present invention will be clearly and completely described below. Obviously, the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative effort are within the scope of protection of the present invention.

[0023] Example 1

[0024] like Figure 1 As shown, the batch design method for multi-row parallel pipeline anchor blocks described in this application includes the following steps:

[0025] S1. Select a dedicated EXCEL file for pre-processing basic data of anchor blocks according to the actual number of water pipelines. This invention uses EXCEL to compile fixed-format pre-processing files for basic data of anchor blocks for 1 to 6 rows of parallel pipelines, supporting batch design of anchor blocks for 1 to 6 rows of parallel pipelines.

[0026] S2, obtain the basic data required by the pre-processing dedicated EXCEL file, and use EXCEL macro commands to process the data in the pre-processing dedicated EXCEL file to generate the basic data file of the town pier;

[0027] Basic data includes the number of anchor blocks, anchor block serial number, number of pipes, outer diameter and wall thickness of each pipe, horizontal turning angle of the pipe at the anchor block, angle between the upstream and downstream pipes and the horizontal plane, and water pressure inside the pipe.

[0028] The pre-processing EXCEL file contains macro commands pre-set according to the basic data processing requirements of the town piers. After opening and running the macro commands in the pre-processing EXCEL file, entering the project name and confirming, a basic data file of the town piers in txt format can be generated.

[0029] S3. Using AutoCAD VBA technology, based on the basic data file of the pier, the batch automated design of the pier shape is completed sequentially according to the pier number order, and a txt format pier shape parameter file is generated. The automated design of the pier shape automatically designs piers that meet the specifications based on the pier stress characteristics, the pier anti-slip stability safety factor, and the pier base stress.

[0030] To enable batch design of multiple parallel pipeline anchor blocks, the "Data Input" and "Calculation Result Output" visualization interfaces have been removed from the existing AutoCAD VBA anchor block design program for single anchor blocks, retaining only the most basic visualization interface. A batch calculation module for anchor blocks has also been added. Once the program starts running, it will automatically design each anchor block one by one based on the basic data file until all anchor blocks are designed.

[0031] S4 uses AutoCAD VBA technology to automatically generate plan and section views of the piers in batches based on the basic data file of the piers, and automatically annotates the main dimensions.

[0032] S5. Use EXCEL macro commands to process the txt format pier shape parameter file and generate the final pier shape parameter table.

[0033] Example 2

[0034] First, the basic data of the town's piers is preprocessed:

[0035] Select based on the number of pipelines in the actual water supply pipeline project. Figure 2The document shown is a dedicated preprocessing file for the basic data of the corresponding parallel pipeline anchor block batch design.

[0036] According to the requirements in the preprocessing document for basic data of the anchor blocks, prepare the relevant data of the anchor blocks arranged on the pipeline, mainly including the following data: number of anchor blocks, anchor block serial number, number of pipes, outer diameter and wall thickness of each pipe, horizontal turning angle of the pipe at the anchor block, angle between the upstream and downstream pipes and the horizontal plane, water pressure in the pipe, etc.

[0037] Use the shortcut Alt+F8 to open the "zdsjcl" macro command included in the preprocessing file for the basic data of the town's piers. Figure 3 As shown, enter a project name such as "GXXX", and after confirming, a basic data file of the town's embankment in txt format will be generated.

[0038] Then, the batch design of multiple parallel pipeline anchors is carried out. The anchor body shape is automatically designed one by one according to the anchor number sequence, and a body size that meets the relevant specifications for anchor stability calculation is obtained.

[0039] Open the AutoCAD file "ZhenDunPLSJ-V1.0.dwg", select Tools → Macros → Load Project, and open the AutoCAD VBA project file "ZhenDunPLSJ-V1.0.dvb". Figure 4 As shown. Select Tools → Macro → Macro or use the shortcut Alt+F8 to run the macro. Enter the project name "GXXX" and click "Run" to start batch design of the piers. The process will continue until the design is complete, generating a pier shape parameter file in txt format.

[0040] Afterwards, the plan and section views of the town piers are automatically generated in batches, and the main dimensions are automatically labeled.

[0041] Open the AutoCAD file "ZhenDunPLHCL-V1.0.dwg", select Tools → Macros → Load Project, and open the AutoCAD VBA project file "ZhenDunPLHCL-V1.0.dvb", as follows: Figure 5 As shown. Select Tools → Macro → Macro or Alt+F8 to run the macro. Enter the project name "GXXX" and click "Run" to begin batch automatic generation of town pier plan and section views, and automatically annotate the main dimensions, such as... Figure 6 As shown, the process continues until the design is complete.

[0042] Finally, the final table of town pier shape parameters is generated in batches.

[0043] Open the Excel file "Multi-row Parallel Pipeline Abutment Batch Design - Data Post-processing.xlsm", and use the shortcut Alt+F8 to open and run the macro command "zdsjhcl" included in the file. Figure 7 As shown, enter the project name, such as "GXXX", and after confirming, the final shape parameter table of all town piers will be automatically generated.

Claims

1. A method for batch design of anchor blocks for multi-row parallel pipelines, characterized in that: Includes the following steps: S1. Select a dedicated EXCEL file for pre-processing basic data of anchor blocks according to the actual number of water pipelines, and use EXCEL to compile fixed-format pre-processing files for basic data of anchor blocks for 1 to 6 rows of parallel pipelines respectively. S2, obtain the basic data required by the pre-processing dedicated EXCEL file, and use EXCEL macro commands to process the data in the pre-processing dedicated EXCEL file to generate a basic data file for the anchor blocks; the basic data includes the number of anchor blocks, anchor block serial number, number of pipes, outer diameter and wall thickness of each pipe, horizontal turning angle of the pipe at the anchor block, angle between the upstream and downstream pipes and the horizontal plane, and water pressure inside the pipe. S3. Using AutoCAD VBA technology, based on the basic data file of the piers, and following the pier numbering order, the batch automated design of the pier shapes is completed according to the pier stress characteristics, pier anti-slip stability safety factor, and pier base stress, and a pier shape parameter file is generated. The process of generating the pier shape parameter file includes: opening the AutoCAD file ZhenDunPLSJ-V1.0.dwg, selecting Tools, Macros, and Load Project buttons in sequence, and opening the AutoCAD VBA project file ZhenDunPLSJ-V1.

0. In DVB, select Tools, Macro, Macro or press Alt+F8 to run the macro. Enter the project name, click the run button, and start batch design of the piers until the design is complete. Then, the macro will be generated as a pier shape parameter file. S4. Using AutoCAD VBA technology, based on the basic data file of the pier, batch automatically generate pier plan views and section views, and automatically annotate the main dimensions. The process of batch automatically generating pier plan views and section views and automatically annotating the main dimensions includes: opening the AutoCAD file ZhenDunPLHCL-V1.0.dwg, selecting Tools, Macros, and Load Project in sequence, opening the AutoCAD VBA project file ZhenDunPLHCL-V1.0.dvb, selecting Tools, Macros, Macros or Alt+F8 in sequence, running the macro, entering the project name, and clicking the Run button to start batch automatically generating pier plan views and section views and automatically annotating the main dimensions until the design is complete. S5. Use EXCEL macro commands to process the pier shape parameter file and generate the final pier shape parameter table. In this program, the data input and calculation result output visualization interface are removed from the AutoCAD VBA multi-row parallel pipeline anchor design program for a single anchor pier. At the same time, a batch calculation module for anchor piers is added. After the program starts running, it will automatically design the anchor piers one by one according to the basic data file until all anchor piers are designed.

2. The method for batch design of multi-row parallel pipeline anchor blocks according to claim 1, characterized in that: Both the basic data file and the shape parameter file of the pier are in txt format.

Images