CN111581685A - Siphon type runner molded line design and drawing method based on excel - Google Patents
Siphon type runner molded line design and drawing method based on excel Download PDFInfo
- Publication number
- CN111581685A CN111581685A CN202010296693.9A CN202010296693A CN111581685A CN 111581685 A CN111581685 A CN 111581685A CN 202010296693 A CN202010296693 A CN 202010296693A CN 111581685 A CN111581685 A CN 111581685A
- Authority
- CN
- China
- Prior art keywords
- flow channel
- excel
- siphon
- siphon type
- autocad
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 17
- 238000013507 mapping Methods 0.000 claims description 2
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 abstract description 31
- 238000010586 diagram Methods 0.000 description 5
- 230000008569 process Effects 0.000 description 2
- 230000007704 transition Effects 0.000 description 2
- PCTMTFRHKVHKIS-BMFZQQSSSA-N (1s,3r,4e,6e,8e,10e,12e,14e,16e,18s,19r,20r,21s,25r,27r,30r,31r,33s,35r,37s,38r)-3-[(2r,3s,4s,5s,6r)-4-amino-3,5-dihydroxy-6-methyloxan-2-yl]oxy-19,25,27,30,31,33,35,37-octahydroxy-18,20,21-trimethyl-23-oxo-22,39-dioxabicyclo[33.3.1]nonatriaconta-4,6,8,10 Chemical compound C1C=C2C[C@@H](OS(O)(=O)=O)CC[C@]2(C)[C@@H]2[C@@H]1[C@@H]1CC[C@H]([C@H](C)CCCC(C)C)[C@@]1(C)CC2.O[C@H]1[C@@H](N)[C@H](O)[C@@H](C)O[C@H]1O[C@H]1/C=C/C=C/C=C/C=C/C=C/C=C/C=C/[C@H](C)[C@@H](O)[C@@H](C)[C@H](C)OC(=O)C[C@H](O)C[C@H](O)CC[C@@H](O)[C@H](O)C[C@H](O)C[C@](O)(C[C@H](O)[C@H]2C(O)=O)O[C@H]2C1 PCTMTFRHKVHKIS-BMFZQQSSSA-N 0.000 description 1
- 230000004888 barrier function Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000012938 design process Methods 0.000 description 1
- 238000007599 discharging Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000000149 penetrating effect Effects 0.000 description 1
- 230000010349 pulsation Effects 0.000 description 1
- 238000007789 sealing Methods 0.000 description 1
- 239000000126 substance Substances 0.000 description 1
- 230000009466 transformation Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F30/00—Computer-aided design [CAD]
- G06F30/10—Geometric CAD
- G06F30/12—Geometric CAD characterised by design entry means specially adapted for CAD, e.g. graphical user interfaces [GUI] specially adapted for CAD
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F30/00—Computer-aided design [CAD]
- G06F30/10—Geometric CAD
- G06F30/13—Architectural design, e.g. computer-aided architectural design [CAAD] related to design of buildings, bridges, landscapes, production plants or roads
Abstract
The invention relates to the technical field of hydraulic engineering design, in particular to a siphon type runner profile design and drawing method based on excel. The method comprises the following steps: 1) calculating a functional relation of the molded line control curve of the siphon type flow channel according to the characteristics of the siphon type flow channel; 2) editing the functional relation obtained in the step 1) into excel to obtain a command stream statement for drawing a siphon-type flow channel type line pattern in AUTOCAD; 3) inputting the command stream statement obtained in the step 2) into AUTOCAD to obtain the siphon type flow channel type line pattern to be drawn. The invention can automatically draw and present the design result of the water outlet flow channel on the AUTOCAD interface very conveniently by utilizing the powerful calculation function of excel and combining the accurate drawing function of AUTOCAD. In addition, an excel single variable solving function can be utilized, and the rapid automatic solving of a certain target parameter is realized. The efficiency of siphon type runner molded lines design and drawing is greatly improved.
Description
Technical Field
The invention relates to the technical field of hydraulic engineering design, in particular to a siphon type runner profile design and drawing method based on excel.
Background
Flood control and drainage pump stations and urban embankments are important barriers for ensuring that cities are protected from flood disasters. The pump rooms of the pump stations are mostly positioned on the inner side of an urban embankment, and the water outlet flow channel is a building for discharging water from an outlet of the water pump body to a pool outside the embankment and is a water outlet channel of the pump station. The hydraulic design of the three-dimensional overflowing surface of the water outlet flow channel has great influence on the water outlet flow state, and the poor water outlet flow state not only can obviously reduce the energy performance of the water pump, but also can possibly generate vortex and pressure pulsation which threaten the stable operation of a water pump unit in the water outlet flow channel. In order to achieve the above purpose, in engineering design practice, various requirements in connection of section, flow velocity, vacuum degree and elevation such as a balance embankment, an inner foot of the embankment, an embankment top road, a flood gate, a water outlet pool, a damming weir and the like need to be considered.
The inner sides of flood control dams in many urban areas in China are mostly provided with a river-following traffic road, a water outlet flow channel of a drainage pump station is usually arranged after penetrating along a river course and turning over the dam to prevent water from being discharged into a foreign river, and due to the requirement of urban flood control, the flow channel turning-over dam generally adopts a siphon-type flow channel with a high hump, and the bottom elevation of the hump flow channel is higher than the highest designed water level of the foreign river, so that the dangerous situation that the water of the foreign river is poured into the city is avoided. The urban flood control and drainage pump station widely adopts a vertical or inclined axial flow pump station, and when the water level variation amplitude of a water outlet pool is not large, a siphon type water outlet flow channel is mostly adopted and a vacuum breaking valve cutoff mode is matched. The height of the bottom of the hump is slightly higher than the highest operating water level of the water outlet pool, and the vacuum degree of the top of the hump is required to be not more than 7.5m of the height of a water column. The cross section at the hump is designed to be flat. The joint of the siphon tube body must have good sealing performance. The designed flow velocity of the water outlet pipeline is more than 2.0-3.0 m/s. The flow velocity of the outlet is not more than 1.5m/s, and when the outlet is provided with a flap valve, the flow velocity is not more than 2.0 m/s; the upper edge of the outlet of the water outlet pipeline is required to be submerged below the lowest operating water level of the water outlet pool by 0.1-0.2 m. Furthermore, the terrain, geological conditions, traffic requirements of the dykes and dykes feet, etc. are taken into account. When the flow channel crosses the dike section, the design of the water outlet flow channel is inevitably a process of repeatedly modifying and continuously improving because of more considered factors, however, the traditional design method of the water outlet flow channel is a geometric drawing method based on the average flow velocity of the flow channel section, namely, the section shapes and the elevation relations of a plurality of controllable sections are firstly assumed, and then the smooth transition curve is used for connecting the plurality of controllable sections through the geometric constraint relation to obtain a water outlet flow channel curve; since it is difficult to satisfy all the control conditions at one time, the design process of assuming first and then adjusting is very complicated and inefficient.
Disclosure of Invention
The invention aims to solve the technical problems of complicated process and low efficiency of the traditional siphon type flow channel design and drawing method mentioned in the background technology, and provides an excel-based siphon type flow channel profile design and drawing method.
The technical scheme of the invention is as follows: a siphon type runner molded line design and drawing method based on excel is characterized in that: the method comprises the following steps: 1) calculating a functional relation of the molded line control curve of the siphon type flow channel according to the characteristics of the siphon type flow channel;
2) editing the functional relation obtained in the step 1) into Excel to obtain a command stream statement for drawing a siphon-type flow channel type line pattern in AUTOCAD;
3) inputting the command stream statement obtained in the step 2) into AUTOCAD to obtain the siphon type flow channel type line pattern to be drawn.
2. The method for design and mapping of an excel-based siphonic flow channel profile according to claim 1, wherein: the functional relationship of the siphon type runner profile control curve calculated in the step 1) comprises a functional relationship among a runner bottom surface, a runner center line and a runner top surface control point.
The invention can express the flow speed, elevation, turning radius, turning angle, control point coordinate and the like of each controllable section and the association constraint relation among the flow speed, elevation, turning radius, turning angle, control point coordinate and the like through the excel function by utilizing the powerful calculation function of the excel, the result is updated immediately when the parameters of the water outlet flow channel are modified and adjusted, and the design result of the water outlet flow channel can be conveniently and automatically drawn and presented on the AUTOCAD interface by combining the accurate drawing function of the AUTOCAD. In addition, an excel single variable solving function can be utilized to realize the rapid automatic solving of a certain target parameter. The efficiency of siphon type runner molded lines design and drawing is greatly improved.
Drawings
FIG. 1: the siphon type flow passage curve geometric relationship diagram of the embodiment;
FIG. 2: the siphon-type flow passage curve of the embodiment is provided with a geometric relationship graph with coordinates;
FIG. 3: the geometric relationship diagram of the top surface of the curved flow channel of the siphon flow channel in the embodiment;
FIG. 4: the geometric relationship diagram of the bottom surface of the curved flow channel of the siphon flow channel in the embodiment;
FIG. 5: in this embodiment, the siphon type flow channel profile design diagram obtained in step 3 is adopted.
Detailed Description
The invention is described in further detail below with reference to the figures and the specific embodiments.
Firstly, a functional relationship of the siphon type flow passage controllability curve needs to be determined, as shown in fig. 1, which is a schematic structural diagram of the siphon type flow passage controllability curve of the present embodiment, ABCD is a flow passage center line, AE and DF are end-to-end cross sections of the flow passage section, AE/, DF, a distance in the X direction of the flow passage section is L, an offset in the Y direction is H, an end-to-end section turning radius R1 and an end-to-end section turning radius R2, and a geometric relationship indicates that: the angle E is equal to angle F is equal to angle CBH is equal to angle HC is equal to angle theta.
Wherein: theta-central angle of turning section
CH-the length of segment CH;
BH-Length of line segment BH:
h is the offset of the center line of the river channel in the Y direction;
r1-first section turn radius;
r2-trailing section turning radius;
l is the X-direction distance of the flow passage.
Converting the formula to obtain:
wherein the content of the first and second substances,
namely, it is
Assuming that point a is the origin of coordinates (0, 0), after θ is obtained, the coordinates of A, B, C, D, E, F can be expressed by known coordinates L, H, R1 and R2 (as shown in fig. 2).
The geometric constraint relation between the turning sections and the connecting sections of the top and bottom curves of the section of the flow channel is the same as the central line, namely the head and tail turning sections of the section of the flow channel are connected through transition section flow channels which are respectively tangent to the turning sections.
Therefore, after only L ', H ', R1', R2' and theta ' corresponding to the top curve of the section of the flow channel are obtained, the coordinates of A ', B ', C ', D ', E ' and F ' corresponding to the top curve can be expressed by known L ', H ', R1' and R2 ';
after the curves corresponding to the bottom of the flow channel, L ', H ', R1', R2' and theta ', the coordinates of the curves corresponding to the bottom, A ', B ', C ', D ', E ', F ' can all be expressed by the known L ', H ', R1', R2 '.
The height of the front section of the flow channel is D1, the height of the tail section of the flow channel is D2, the relation between the curves of the top and the bottom of the section of the flow channel and the L, H, R1 and R2 of the central line is shown in figures 3 and 4,
as shown in fig. 3, the curve a 'B' C 'D' is the top line of the flow channel, B 'C' is tangent to the arc a 'B and the arc' C 'D', and the tangent points are the point B 'and the point C', respectively.
Wherein: l ═ L, H ═ H +0.5D2-0.5D1, R1 ═ R1-0.5D1, R2 ═ R2+0.5D 2.
As shown in fig. 4, the curve a "B" C "D" is the bottom line of the flow channel, the curve B "C" is tangent to the arc a "B" and the arc "C" D ", and the tangent points are the point B" and the point C ", respectively.
Wherein: l ═ L, H ═ H +0.5D1-0.5D2, R1 ═ R1+0.5D1, R2 ═ R2-0.5D 2.
And 2, establishing the relation among the bottom surface, the central line and the top surface control point of the flow channel in the EXCEL table by using the relational expression. Then, the EXCEL literal function is used to connect each control point and the command acceptable to AUTOCAD to form an AUTOCAD command stream statement, as shown in the following table:
and 3, opening the AUTOCAD graph, setting a user coordinate origin of a certain control point of the section of the flow channel (in the embodiment, setting a starting point A of a head section center line of the section of the flow channel as the user coordinate origin, and when setting other points as the control points, converting in EXCEL by using a coordinate transformation formula), copying the EXCEL command stream statement and pasting the EXCEL command stream statement to an AUTOCAD command line to execute the AUTOCAD command stream statement, so that the AUTOCAD graph of the flow channel can be obtained, and the flow channel drawing graph shown in the figure 5 is obtained.
And 4, if the shape of the flow channel needs to be adjusted and modified, repeating the step 2, namely modifying the parameters L, H, R1, R2, D1 and D2 in the excel, and then repeating the step 3.
And 5, if other sections such as the section area, the flow rate, the corner angle, the gradient of the gradual change straight line and the like of each controllable section need to be synchronously known, related cells can be arranged in the excel by using the excel function to be synchronously displayed, and a flow channel curve meeting the target value of a certain parameter can be quickly obtained by using the univariate solving function of the excel.
The embodiment is a flow channel curve of a certain engineering hump section, and can be actually considered as a connecting curve of channels with different widths. When D1 and D2 are equal, curves such as a horizontal turn of the flow path, a road or a channel turn are obtained.
The foregoing shows and describes the general principles, essential features, and advantages of the invention. It will be understood by those skilled in the art that the present invention is not limited to the embodiments described above, which are given by way of illustration of the principles of the present invention, and that various changes and modifications may be made without departing from the spirit and scope of the invention as defined by the appended claims. The scope of the invention is defined by the appended claims and equivalents thereof.
Claims (2)
1. A siphon type runner molded line design and drawing method based on excel is characterized in that: the method comprises the following steps: 1) calculating a functional relation of the molded line control curve of the siphon type flow channel according to the characteristics of the siphon type flow channel;
2) editing the functional relation obtained in the step 1) into excel to obtain a command stream statement for drawing a siphon-type flow channel type line pattern in AUTOCAD;
3) inputting the command stream statement obtained in the step 2) into AUTOCAD to obtain the siphon type flow channel type line pattern to be drawn.
2. The method for design and mapping of an excel-based siphonic flow channel profile according to claim 1, wherein: the functional relationship of the siphon type runner profile control curve calculated in the step 1) comprises a functional relationship among a runner bottom surface, a runner center line and a runner top surface control point.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010296693.9A CN111581685A (en) | 2020-04-15 | 2020-04-15 | Siphon type runner molded line design and drawing method based on excel |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010296693.9A CN111581685A (en) | 2020-04-15 | 2020-04-15 | Siphon type runner molded line design and drawing method based on excel |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111581685A true CN111581685A (en) | 2020-08-25 |
Family
ID=72124402
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010296693.9A Pending CN111581685A (en) | 2020-04-15 | 2020-04-15 | Siphon type runner molded line design and drawing method based on excel |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111581685A (en) |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030236639A1 (en) * | 2002-03-26 | 2003-12-25 | Curry Lynn Burton | Sewer flow analysis method |
| CN104480918A (en) * | 2014-12-15 | 2015-04-01 | 扬州大学 | Siphoning type water outlet runner with excellent hydraulic property and application method thereof |
| CN105740505A (en) * | 2016-01-21 | 2016-07-06 | 东南大学 | GPS-RTK technology based road space line shape recovery method |
| KR101721378B1 (en) * | 2016-08-18 | 2017-03-29 | 계림요업주식회사 | Toilet trap which has both odor prevention and fast finish of siphon |
| CN109271697A (en) * | 2018-09-10 | 2019-01-25 | 云南省红河州水利水电勘察设计研究院 | Based on profile data processing system and method, computer program in VBA processing AutoCAD |
| CN110321542A (en) * | 2019-06-28 | 2019-10-11 | 中国水电顾问集团贵阳勘测设计研究院岩土工程有限公司 | A method of CAD order batch, which is edited, using excel draws prospecting graph |
| WO2020015613A1 (en) * | 2018-07-16 | 2020-01-23 | 苏州浩辰软件股份有限公司 | Cad collaborative design system |
| CN111008429A (en) * | 2019-12-04 | 2020-04-14 | 中国直升机设计研究所 | Heterogeneous CAD geometric consistency comparison method based on point cloud |
-
2020
- 2020-04-15 CN CN202010296693.9A patent/CN111581685A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030236639A1 (en) * | 2002-03-26 | 2003-12-25 | Curry Lynn Burton | Sewer flow analysis method |
| CN104480918A (en) * | 2014-12-15 | 2015-04-01 | 扬州大学 | Siphoning type water outlet runner with excellent hydraulic property and application method thereof |
| CN105740505A (en) * | 2016-01-21 | 2016-07-06 | 东南大学 | GPS-RTK technology based road space line shape recovery method |
| KR101721378B1 (en) * | 2016-08-18 | 2017-03-29 | 계림요업주식회사 | Toilet trap which has both odor prevention and fast finish of siphon |
| WO2020015613A1 (en) * | 2018-07-16 | 2020-01-23 | 苏州浩辰软件股份有限公司 | Cad collaborative design system |
| CN109271697A (en) * | 2018-09-10 | 2019-01-25 | 云南省红河州水利水电勘察设计研究院 | Based on profile data processing system and method, computer program in VBA processing AutoCAD |
| CN110321542A (en) * | 2019-06-28 | 2019-10-11 | 中国水电顾问集团贵阳勘测设计研究院岩土工程有限公司 | A method of CAD order batch, which is edited, using excel draws prospecting graph |
| CN111008429A (en) * | 2019-12-04 | 2020-04-14 | 中国直升机设计研究所 | Heterogeneous CAD geometric consistency comparison method based on point cloud |
Non-Patent Citations (6)
| Title |
|---|
| QSHWINI RAO: "Data Siphoning Across Borders: The Role of Internet Tracking", 2019 FIRST IEEE INTERNATIONAL CONFERENCE ON TRUST, PRIVACY AND SECURITY IN INTELLIGENT SYSTEMS AND APPLICATIONS (TPS-ISA) * |
| 李彦军;颜红勤;葛强;严登丰;胡德义;: "泵站虹吸式出水流道优化设计", 排灌机械, no. 04, pages 1 - 2 * |
| 李文峰;姚晓敏;孙国荣;: "鄂北地区水资源配置工程设计综述", 水利水电技术, no. 07 * |
| 王军锋: "防汛道路设计中的断面曲线定位方法" * |
| 王军锋: "防汛道路设计中的断面曲线定位方法", 科技信息第28期, no. 28, pages 1 - 2 * |
| 顾美娟;卜舸;陆林广;陈阿萍;黄金军;: "刘老涧二站虹吸式出水流道的优化水力设计", 排灌机械, no. 02 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107401147B (en) | A kind of multistage free-electron model formula energy dissipating drilled shaft of annular | |
| CN111581685A (en) | Siphon type runner molded line design and drawing method based on excel | |
| CN106930199A (en) | Improve the fairing of arc Box-shaped Drainage Culvert water outlet fluidised form | |
| CN104652350A (en) | Open channel diffusion section flow-equalizing device and method for calculating placement position of open channel diffusion section flow-equalizing device | |
| CN109778798B (en) | Multistage hole pipe weir flow dividing and silt discharging method | |
| CN106087902A (en) | The scupper cyclone shaft energy-dissipating structure processed for ditch-water and water discharge method | |
| CN202450491U (en) | Open type flood discharge structure at dam crest | |
| CN205421523U (en) | Backward flow formula rainwater regulation pond | |
| CN216428499U (en) | A multi-functional inspection shaft that is used for new and old pipe of municipal drainage to plug into department | |
| CN109024492A (en) | Channel | |
| CN205529946U (en) | It has culvert of pressure makeup of imports to be applicable to no gate | |
| CN206173879U (en) | Gravity dam construction diversion structure | |
| CN209429047U (en) | The water discharge tunnel makeup of the imports for ditch water process | |
| CN109281294B (en) | Anti-arc notch cuttype overflow dam of adjustable air entrainment energy dissipation | |
| WO2021179465A1 (en) | Urban road network balanced drainage method and road construction method | |
| CN108130948A (en) | A kind of pressure current water inlet flow channel system suitable for deeper subsurface draining Boosting pumping station | |
| CN104727267B (en) | It is a kind of to form the compound shingle trap of longitudinal spiral stream sediment trapping sand discharge | |
| CN217419488U (en) | Novel pile foundation and bank wall combined revetment structure | |
| CN113089600A (en) | Rotational flow flood discharging tunnel capable of reducing outlet flow velocity of rotational flow tunnel | |
| CN208152225U (en) | A kind of pressure current water inlet flow channel system suitable for deeper subsurface draining Boosting pumping station | |
| CN109356097A (en) | The water discharge tunnel makeup of the imports for ditch water process | |
| CN209603101U (en) | A kind of powerhouse of hydropower station tailwater channel structure | |
| CN219430640U (en) | Flood removal and stagnation separation system for high sediment urban landscape river | |
| CN219343460U (en) | Vacuum siphon drainage system for sewage interception of drainage port | |
| CN111719660A (en) | Multistage independent flood drainage system for upstream type tailing pond |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200825 |