CN111859596B - Control valve type selection method and control valve type selection device - Google Patents
Control valve type selection method and control valve type selection device Download PDFInfo
- Publication number
- CN111859596B CN111859596B CN201910304990.0A CN201910304990A CN111859596B CN 111859596 B CN111859596 B CN 111859596B CN 201910304990 A CN201910304990 A CN 201910304990A CN 111859596 B CN111859596 B CN 111859596B
- Authority
- CN
- China
- Prior art keywords
- control valve
- type selection
- data table
- selection
- importing
- 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.)
- Active
Links
- 238000010187 selection method Methods 0.000 title claims abstract description 20
- 238000005192 partition Methods 0.000 claims abstract description 41
- 238000004364 calculation method Methods 0.000 claims description 92
- 238000000034 method Methods 0.000 claims description 18
- 230000007246 mechanism Effects 0.000 claims description 11
- 238000004590 computer program Methods 0.000 claims description 10
- 238000012216 screening Methods 0.000 claims description 7
- 238000004513 sizing Methods 0.000 claims 7
- 230000008676 import Effects 0.000 description 9
- 230000008569 process Effects 0.000 description 6
- 238000010586 diagram Methods 0.000 description 5
- 230000006870 function Effects 0.000 description 4
- 230000006978 adaptation Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012369 In process control Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000010965 in-process control Methods 0.000 description 1
- 239000007788 liquid Substances 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 239000002699 waste material Substances 0.000 description 1
Landscapes
- Feedback Control In General (AREA)
- General Factory Administration (AREA)
Abstract
The invention provides a control valve type selection method and a control valve type selection device, and relates to the field of control valve type selection, wherein the control valve type selection method comprises the following steps: acquiring a control valve data table in an excel format, wherein the control valve data table comprises a plurality of partitions, each partition is provided with the same number of cells, the number of rows and the number of columns of the cells are the same, a plurality of parameters of different control valves are recorded in different partitions, and the same parameters of each control valve are positioned at the same position in the partition; acquiring a target position of a parameter required by the model selection of the control valve in the first partition in a control valve data table; extracting parameters required by the type selection of all control valves from a control valve data table according to the target position, and importing the parameters required by the type selection of each control valve into an excel-format type selection data table; and importing the model selection data table into model selection calculation software to obtain a model selection result file. The invention realizes batch importing of data.
Description
Technical Field
The invention relates to the field of control valve type selection, in particular to a control valve type selection method and a control valve type selection device.
Background
The control valve is an actuator in an autonomous system, whose quality of application is directly reflected on the quality of regulation of the system, as a terminal element in process control. The quality of the control valve application, besides the quality of the product itself, whether the user installs, uses and maintains correctly, it is important to calculate and select the model correctly. When the type selection calculation is carried out, the control valve data is required to be imported into calculation software according to a certain format, the currently adopted input method is purely manual input, and when the problem of type selection of a large number of control valves is solved, the method is time-consuming and labor-consuming, has high error rate and is difficult to achieve high-efficiency and accurate input results.
Disclosure of Invention
In view of the above, the present invention provides a control valve type selection method and a control valve type selection device, which are used for solving the problems of time and effort consuming and high error rate caused by manually inputting control valve parameters into a type selection data table when the control valve is selected.
In order to solve the above technical problems, the present invention provides a control valve type selection method, including:
acquiring a control valve data table in an excel format, wherein the control valve data table comprises a plurality of partitions, each partition is provided with the same number of cells, the number of rows and the number of columns of the cells are the same, a plurality of parameters of different control valves are recorded in different partitions, and the same parameters of each control valve are positioned at the same position in the partition;
acquiring a target position of a parameter required by the model selection of the control valve in the first partition in the control valve data table;
extracting all parameters required by the type selection of the control valves from the control valve data table according to the target position, and importing the parameters required by the type selection of each control valve into an excel-format type selection data table, wherein in the type selection data table, the parameters required by the type selection of each control valve occupy one row of cells;
and importing the type selection data table into type selection calculation software to obtain a type selection result file, wherein the type selection result file comprises type selection calculation result parameters of each control valve.
Optionally, the step of providing parameters required for the type selection of all control valves from the control valve data table according to the position, and importing the parameters required for the type selection of each control valve into an excel-format type selection data table further includes:
and displaying a data processing interface according to user input, wherein the data processing interface is used for screening, replacing or filling the designated parameters required by the selection in the selection data table.
Optionally, the step of providing parameters required for the type selection of all control valves from the control valve data table according to the position, and importing the parameters required for the type selection of each control valve into an excel-format type selection data table further includes:
and displaying a data input interface according to user input, wherein the data input interface is used for providing an interface for manually inputting parameters of the control valve into the selection data table for a user.
Optionally, after the obtaining the selection result file, the method further includes:
acquiring a first position of a specified type selection calculation result parameter in a type selection result file, and acquiring a second position of the specified type selection calculation result parameter in the control valve data table;
and when receiving an instruction for importing the specified type selection calculation result parameter into the control valve data table, importing the specified type selection calculation result parameter of the first position in the type selection result file into the second position in the control valve data table.
Optionally, after the obtaining the selection result file, the method further includes:
if the control valve is a rotary valve or a butterfly valve, the selected calculation result parameters required by the torque calculation of the control valve are imported into a torque calculation module, and the torque calculation module is used for calculating the torque of the control valve;
and outputting a calculation result of the torque calculation module so that a user can select an actuating mechanism of the control valve according to the calculation result.
The invention also provides a control valve type selecting device, which comprises:
the first acquisition module is used for acquiring a control valve data table in an excel format, wherein the control valve data table comprises a plurality of partitions, each partition is provided with the same number of cells, the number of rows and the number of columns of the cells are the same, a plurality of parameters of different control valves are recorded in different partitions, and the same parameters of each control valve are positioned at the same position in the partition;
the second acquisition module is used for acquiring a target position of a parameter required by the type selection of the control valve in the first partition in the control valve data table;
the first importing module is used for extracting all parameters required by the type selection of the control valves from the control valve data table according to the target position, importing the parameters required by the type selection of each control valve into an excel-format type selection data table, and occupying one row of cells in the type selection data table;
the second importing module is used for importing the model selection data table into model selection calculation software to obtain a model selection result file, and the model selection result file comprises model selection calculation result parameters of each control valve.
Optionally, the control valve type selecting device further includes:
and the data processing module is used for displaying a data processing interface according to user input, and the data processing interface is used for screening, replacing or filling the designated parameters required by the model selection in the model selection data table.
Optionally, the control valve type selecting device further includes:
the data input module is used for displaying a data input interface according to user input, and the data input interface is used for providing an interface for manually inputting parameters of the control valve into the model selection data table for a user.
Optionally, the control valve type selecting device further includes:
the third acquisition module is used for acquiring a first position of the designated type selection calculation result parameter in the type selection result file and a second position of the designated type selection calculation result parameter in the control valve data table;
and the third importing module is used for importing the model selection calculation result parameter of the first position to a second position in the control valve data table when receiving an instruction for importing the designated model selection calculation result parameter to the control valve data table.
Optionally, the control valve type selecting device further includes:
the fourth importing module is used for importing the model selection calculation result parameters required by the torque calculation of the control valve into the torque calculation module if the control valve is a rotary valve or a butterfly valve, and the torque calculation module is used for calculating the torque of the control valve;
and the output module is used for outputting the calculation result of the torque calculation module so that a user can select the actuating mechanism of the control valve according to the calculation result.
The invention also includes a control valve type device comprising a memory, a processor and a computer program stored on the memory and operable on the processor; and the processor realizes the control valve type selection method when executing the program.
The invention also comprises a computer readable storage medium having stored thereon a computer program, characterized in that the program when executed by a processor realizes the steps in the control valve selection method described above.
The technical scheme of the invention has the following beneficial effects:
according to the embodiment of the invention, the positions of the parameters required by the model selection of all the control valves are determined according to the positions of the parameters required by the model selection of the first control valve in the control valve data table, and the parameters required by the model selection of all the control valves are automatically imported into model selection calculation software according to the determined positions; therefore, batch importing of data is realized, the data processing time is shortened, and the problems of manpower waste and high error rate under the condition of manual processing are avoided.
Drawings
FIG. 1 is a flow chart of a control valve type selection method according to an embodiment of the invention;
FIG. 2 is a flow chart of a method for controlling valve selection according to another embodiment of the present invention;
FIG. 3 is a diagram of a data processing interface in accordance with an embodiment of the present invention;
FIG. 4 is a data processing interface in accordance with another embodiment of the present invention;
FIG. 5 is a schematic diagram of a control valve type device according to an embodiment of the present invention;
FIG. 6 is a schematic view of a control valve type device according to another embodiment of the present invention;
fig. 7 is a schematic structural diagram of a control valve type device according to another embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention more clear, the technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings of the embodiments of the present invention. It will be apparent that the described embodiments are some, but not all, embodiments of the invention. All other embodiments, which are obtained by a person skilled in the art based on the described embodiments of the invention, fall within the scope of protection of the invention.
Referring to fig. 1, fig. 1 is a flow chart of a control valve selection method according to an embodiment of the invention, the method includes:
step 101: acquiring a control valve data table in an excel format, wherein the control valve data table comprises a plurality of partitions, each partition is provided with the same number of cells, the number of rows and the number of columns of the cells are the same, a plurality of parameters of different control valves are recorded in different partitions, and the same parameters of each control valve are positioned at the same position in the partition;
for example, assuming that each valve data table is 60 rows, the bit number of the first control valve is in an "A1" cell, the bit number of the second control valve is in an "a61" cell, and the bit number of the nth control valve is in an "a1+60×n" cell;
step 102: acquiring a target position of a parameter required by the model selection of the control valve in the first partition in the control valve data table;
step 103: extracting all parameters required by the type selection of the control valves from the control valve data table according to the target position, and importing the parameters required by the type selection of each control valve into an excel-format type selection data table, wherein in the type selection data table, the parameters required by the type selection of each control valve occupy one row of cells;
step 104: and importing the type selection data table into type selection calculation software to obtain a type selection result file, wherein the type selection result file comprises type selection calculation result parameters of each control valve.
The model selection calculation software can be the existing control valve model selection calculation software.
According to the embodiment of the invention, batch importing of control valve data is realized, a great amount of time and labor are saved, and meanwhile, the problem of high error rate during manual importing is avoided.
Referring to fig. 2, fig. 2 is a flow chart of a control valve selection method according to another embodiment of the invention, the method includes:
step 201: acquiring a control valve data table provided by a user;
in some cases, the user-provided control valve data table is not in excel format, for example, it may be in PDF format; therefore, the control valve data table needs to be converted into an excel format;
step 202: judging whether the control valve data table is in an excel format, if so, entering a step 204, otherwise, entering a step 203;
step 203: converting the control valve data table into an excel format;
step 204: acquiring a target position of a parameter required by the model selection of the control valve in the first partition in the control valve data table;
step 205: establishing a model selection data table in an excel format, wherein the model selection data table can be named as valvedat. Xls, for example, and bringing parameters required by model selection into the model selection data table;
the creation of the profile is not limited to being performed during step 205, but may be performed prior to step 205.
In some cases, parameters required for type selection in the type selection data table may not meet the requirement of type selection calculation software, so that, optionally, the control valve type selection method in the embodiment of the invention further includes:
step 206: the parameters required by the appointed model selection in the model selection data table are arranged;
for example, the computing software may not be able to identify the parameters required for the selection partially proposed, and thus, optionally, sorting the parameters required for the selection specified in the selection data table may further include:
and displaying a data processing interface according to the input of a user on the user interface, wherein the data processing interface is used for screening, replacing or filling the designated parameters required by the selection in the selection data table.
Referring to fig. 3, fig. 3 is a data processing interface according to an embodiment of the present invention, in this embodiment, a designated parameter required for selecting a type is a medium state parameter, when a medium state is processed, the medium state in the type selection data table is extracted, and the extracted state is assumed to include data such as "Gas/Vaper", "Liquid", "stem", etc., and meanwhile, the number of each data may be displayed, and data that can be identified by the computing software is selected for replacement.
Wherein the user input may be: clicking the 'sub item processing data' button of the data processing interface, clicking the 'medium state' button under the 'sub item processing data' button, and then clicking the 'screening' button under the 'medium state' button.
The embodiment of the invention can process the data format of the model selection data table into a format which can be identified by calculation software, so as to achieve the purpose of importing parameters required by the model selection of the control valve into the calculation software.
In some embodiments of the present invention, there may be some data required for the selection of the type that cannot be directly extracted from the control valve data table, and thus, optionally, sorting the parameters required for the selection of the specified type in the selection data table may include:
according to the user input on the user interface, a data input interface is displayed, and referring to fig. 4, the data input interface is used for providing an interface for manually inputting parameters of the control valve into the selection data table for the user.
The embodiment of the invention can manually input the data required by the partial model selection which cannot be directly extracted from the control valve data table into the model selection control table, so as to achieve the aim of importing the parameters required by the model selection of the control valve into calculation software.
Step 207: and importing the data into computing software, and performing model selection computation to obtain a model selection result file.
In some cases, the obtained selected result file needs to be re-imported into the user data table for the user to view, so, in some embodiments of the present invention, referring to fig. 2, the control valve selection method of the embodiment of the present invention may further include:
assuming that the type-selection result file in step 104 described above may include a first type-selection result file, the first type-selection result file may be named valvedat.
Step 208: acquiring a first position of a specified type selection calculation result parameter in the first type selection result file, and a second position of the specified type selection calculation result parameter in the control valve data table;
step 209: and when receiving an instruction for importing the specified type selection calculation result parameter into the control valve data table, importing the specified type selection calculation result parameter of the first position in the type selection result file into the second position in the control valve data table.
For example, the type-selection result parameter may be "select Cv", which is assumed to be located in the "B1" cell in the first type-selection result file, and located in the "C1" cell in the control valve data table, and the instruction for importing the specified type-selection calculation result parameter into the control valve data table is generated by clicking the "import data to specification table" button on the user interface, and the data of the "B1" cell located in the first type-selection result file is imported into the control valve data table "C1" cell.
The embodiment of the invention is used for importing the type selection result data required by the user into the control valve data table so that the user can perform the next analysis.
In some cases, torque calculations and actuator options may also be required if the control valve includes a rotary or butterfly valve. Therefore, the control valve type selection method of the embodiment of the invention can further comprise the following steps:
assuming that the type-selection result file in step 104 may include a second type-selection result file, the second type-selection result file may be named process.
Step 210, sorting the model selection calculation results to generate detailed model selection result information, wherein the detailed model selection result information can be named as specific information;
step 211: if the control valve is a rotary valve or a butterfly valve, according to user input, the selected calculation result parameters required by torque calculation of the control valve are imported into a torque calculation module, and the torque calculation module is used for calculating the torque of the control valve;
step 212: outputting a calculation result of the torque calculation module to enable a user to select an executing mechanism of the control valve according to the calculation result;
step 213: manually selecting the type of an executing mechanism according to the torque calculation result of the torque calculation book, and importing the type of the executing mechanism and the torque calculation result into the model selection result detailed description;
wherein, in step 211, the user input may be: clicking on the "open function table" button on the user interface and clicking on the "import from process" button under "open function table" then clicking on the "create torque calculation book" button under "import from process".
In step 213, when the actuator model and the torque calculation result are imported into the model selection result detailed description, the user may input: clicking on the "open function table" button on the user interface and clicking on the "import actuator results" button under "open function table".
In some embodiments of the present invention, step 210 may further include:
if the control valve is not a rotary valve or a butterfly valve, the process is ended.
The embodiment of the invention is used for calculating the torque of the eccentric rotation butterfly valve and the butterfly valve and selecting the type of the actuating mechanism so as to perfect the calculation result of the selection.
Based on the same inventive concept, an embodiment of the present invention further provides a control valve type selecting device, please refer to fig. 5, which includes:
a first obtaining module 501, configured to obtain a control valve data table in excel format, where the control valve data table includes a plurality of partitions, each partition has the same number of cells, the number of rows and the number of columns of cells are the same, a plurality of parameters of different control valves are recorded in different partitions, and the same parameter of each control valve is located at the same position in the partition;
a second obtaining module 502, configured to obtain a target position of a parameter required for selecting a type of the control valve in the first partition in the control valve data table;
a first importing module 503, configured to extract parameters required by the type selection of all the control valves from the control valve data table according to the target position, and import the parameters required by the type selection of each control valve into an excel format type selection data table, where the parameters required by the type selection of each control valve occupy a row of cells;
and the second importing module 504 is configured to import the type selection data table into type selection calculation software to obtain a type selection result file, where the type selection result file includes type selection calculation result parameters of each control valve.
The embodiment of the invention is used for automatically importing the control valve data during the control valve type selection, saves a great deal of time and labor when manually inputting the data, and reduces the error rate.
Referring to fig. 6, fig. 6 is a schematic structural diagram of a control valve selecting apparatus according to another embodiment of the present invention, and in some embodiments of the present invention, optionally, the control valve selecting apparatus may further include:
the data processing module 505 is configured to display a data processing interface according to a user input, where the data processing interface is configured to filter, replace or fill parameters required for a specified selection in the selection data table.
Optionally, the control valve type selecting device may further include:
the data input module 506 is configured to display a data input interface according to a user input, where the data input interface is configured to provide an interface for a user to manually enter parameters of a control valve into the selection data table.
The embodiment is used for arranging the type selection data table into a format which can be identified by computing software.
Optionally, the control valve type selecting device may further include:
a third obtaining module 507, configured to obtain a first position of a specified type selection calculation result parameter in a type selection result file, and a second position of the specified type selection calculation result parameter in the control valve data table;
and a third importing module 508, configured to import the model selection calculation result parameter of the first location to a second location in the control valve data table when receiving an instruction to import the specified model selection calculation result parameter to the control valve data table.
The embodiment is used for importing the type selection calculation result batch into the control valve data table provided by the user so that the user can perform the next analysis.
Optionally, the control valve type selecting device may further include:
a fourth importing module 509, configured to import, if the control valve is a rotary valve or a butterfly valve, a model selection calculation result parameter required for calculating the torque of the control valve into a torque calculating module, where the torque calculating module is configured to calculate the torque of the control valve;
and the output module 510 is used for outputting the calculation result of the torque calculation module so that a user can select the actuating mechanism of the control valve according to the calculation result.
The embodiment is used for calculating the torque of the eccentric rotation butterfly valve and the torque of the eccentric rotation butterfly valve so as to facilitate the selection of the type of the actuating mechanism by a user.
Referring to fig. 7, fig. 7 is a schematic structural diagram of a control valve selecting apparatus according to another embodiment of the present invention, the control valve selecting apparatus 700 includes: a processor 701 and a memory 702, wherein:
in an embodiment of the present invention, the control valve type selection apparatus 700 further includes: a computer program stored on the memory 702 and executable on the processor 701, which when executed by the processor 701 performs the steps of:
acquiring a control valve data table in an excel format, wherein the control valve data table comprises a plurality of partitions, each partition is provided with the same number of cells, the number of rows and the number of columns of the cells are the same, a plurality of parameters of different control valves are recorded in different partitions, and the same parameters of each control valve are positioned at the same position in the partition;
acquiring a target position of a parameter required by the model selection of the control valve in the first partition in the control valve data table;
extracting all parameters required by the type selection of the control valves from the control valve data table according to the target position, and importing the parameters required by the type selection of each control valve into an excel-format type selection data table, wherein in the type selection data table, the parameters required by the type selection of each control valve occupy one row of cells;
and importing the type selection data table into type selection calculation software to obtain a type selection result file, wherein the type selection result file comprises type selection calculation result parameters of each control valve.
Optionally, the computer program may further implement the following steps when executed by the processor 702:
and according to the position, providing parameters required by the type selection of all the control valves from the control valve data table, importing the parameters required by the type selection of each control valve into an excel-format type selection data table, and displaying a data processing interface according to user input, wherein the data processing interface is used for screening, replacing or filling the parameters required by the type selection specified in the type selection data table.
Optionally, the computer program may further implement the following steps when executed by the processor 702:
and according to the positions, providing the parameters required by the model selection of all the control valves from the control valve data table, importing the parameters required by the model selection of each control valve into the model selection data table in an excel format, and displaying a data input interface according to user input, wherein the data input interface is used for providing an interface for manually inputting the parameters of the control valves into the model selection data table for a user.
Optionally, the computer program may further implement the following steps when executed by the processor 702:
after the model selection result file is obtained, a first position of a specified model selection calculation result parameter in the model selection result file and a second position of the specified model selection calculation result parameter in the control valve data table are obtained;
and when receiving an instruction for importing the specified type selection calculation result parameter into the control valve data table, importing the specified type selection calculation result parameter of the first position in the type selection result file into the second position in the control valve data table.
Optionally, the computer program may further implement the following steps when executed by the processor 702:
after the model selection result file is obtained, if the control valve is a rotary valve or a butterfly valve, the model selection calculation result parameters required by the torque calculation of the control valve are imported into a torque calculation module, and the torque calculation module is used for calculating the torque of the control valve;
and outputting a calculation result of the torque calculation module so that a user can select an actuating mechanism of the control valve according to the calculation result.
The embodiment of the invention also provides a computer readable storage medium, on which a computer program is stored, which when executed by a processor, implements the processes of the above-mentioned control valve selection method embodiment, and can achieve the same technical effects, and in order to avoid repetition, the description is omitted here. Wherein the computer readable storage medium is selected from Read-Only Memory (ROM), random access Memory (Random Access Memory, RAM), magnetic disk or optical disk. While the foregoing is directed to the preferred embodiments of the present invention, it will be appreciated by those skilled in the art that various modifications and adaptations can be made without departing from the principles of the present invention, and such modifications and adaptations are intended to be comprehended within the scope of the present invention.
Claims (12)
1. A method of controlling valve sizing comprising:
acquiring a control valve data table in an excel format, wherein the control valve data table comprises a plurality of partitions, each partition is provided with the same number of cells, the number of rows and the number of columns of the cells are the same, a plurality of parameters of different control valves are recorded in different partitions, and the same parameters of each control valve are positioned at the same position in the partition;
acquiring a target position of a parameter required by the model selection of the control valve in the first partition in the control valve data table;
extracting all parameters required by the type selection of the control valves from the control valve data table according to the target position, and importing the parameters required by the type selection of each control valve into an excel-format type selection data table, wherein in the type selection data table, the parameters required by the type selection of each control valve occupy one row of cells;
and importing the type selection data table into type selection calculation software to obtain a type selection result file, wherein the type selection result file comprises type selection calculation result parameters of each control valve.
2. The control valve type selection method according to claim 1, wherein after the step of extracting all parameters required for the control valve type selection from the control valve data table according to the position and importing the parameters required for the control valve type selection into the excel-format type selection data table, the method further comprises:
and displaying a data processing interface according to user input, wherein the data processing interface is used for screening, replacing or filling the designated parameters required by the selection in the selection data table.
3. The control valve type selection method according to claim 1, wherein after the step of extracting all parameters required for the control valve type selection from the control valve data table according to the position and importing the parameters required for the control valve type selection into the excel-format type selection data table, the method further comprises:
and displaying a data input interface according to user input, wherein the data input interface is used for providing an interface for manually inputting parameters of the control valve into the selection data table for a user.
4. The control valve sizing method of claim 1, further comprising, after the sizing result file is obtained:
acquiring a first position of a specified type selection calculation result parameter in a type selection result file, and acquiring a second position of the specified type selection calculation result parameter in the control valve data table;
and when receiving an instruction for importing the specified type selection calculation result parameter into the control valve data table, importing the specified type selection calculation result parameter of the first position in the type selection result file into the second position in the control valve data table.
5. The control valve profiling method of claim 1, further comprising, after the profiling result file is obtained:
if the control valve is a rotary valve or a butterfly valve, the selected calculation result parameters required by the torque calculation of the control valve are imported into a torque calculation module, and the torque calculation module is used for calculating the torque of the control valve;
and outputting a calculation result of the torque calculation module so that a user can select an actuating mechanism of the control valve according to the calculation result.
6. A control valve type selection device, comprising:
the first acquisition module is used for acquiring a control valve data table in an excel format, wherein the control valve data table comprises a plurality of partitions, each partition is provided with the same number of cells, the number of rows and the number of columns of the cells are the same, a plurality of parameters of different control valves are recorded in different partitions, and the same parameters of each control valve are positioned at the same position in the partition;
the second acquisition module is used for acquiring a target position of a parameter required by the type selection of the control valve in the first partition in the control valve data table;
the first importing module is used for extracting all parameters required by the type selection of the control valves from the control valve data table according to the target position, importing the parameters required by the type selection of each control valve into an excel-format type selection data table, and occupying one row of cells in the type selection data table;
the second importing module is used for importing the model selection data table into model selection calculation software to obtain a model selection result file, and the model selection result file comprises model selection calculation result parameters of each control valve.
7. The control valve sizing device as recited in claim 6, further comprising:
and the data processing module is used for displaying a data processing interface according to user input, and the data processing interface is used for screening, replacing or filling the designated parameters required by the model selection in the model selection data table.
8. The control valve sizing device as recited in claim 6, further comprising:
the data input module is used for displaying a data input interface according to user input, and the data input interface is used for providing an interface for manually inputting parameters of the control valve into the model selection data table for a user.
9. The control valve sizing device as recited in claim 6, further comprising:
the third acquisition module is used for acquiring a first position of the designated type selection calculation result parameter in the type selection result file and a second position of the designated type selection calculation result parameter in the control valve data table;
and the third importing module is used for importing the model selection calculation result parameter of the first position to a second position in the control valve data table when receiving an instruction for importing the designated model selection calculation result parameter to the control valve data table.
10. The control valve sizing device as recited in claim 6, further comprising:
the fourth importing module is used for importing the model selection calculation result parameters required by the torque calculation of the control valve into the torque calculation module if the control valve is a rotary valve or a butterfly valve, and the torque calculation module is used for calculating the torque of the control valve;
and the output module is used for outputting the calculation result of the torque calculation module so that a user can select the actuating mechanism of the control valve according to the calculation result.
11. A control valve type device comprising a memory, a processor and a computer program stored on the memory and executable on the processor; the control valve selection method according to any one of claims 1-5 is implemented when the processor executes the program.
12. A computer readable storage medium, on which a computer program is stored, characterized in that the program, when being executed by a processor, carries out the steps in the control valve selection method according to any one of claims 1-5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910304990.0A CN111859596B (en) | 2019-04-16 | 2019-04-16 | Control valve type selection method and control valve type selection device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910304990.0A CN111859596B (en) | 2019-04-16 | 2019-04-16 | Control valve type selection method and control valve type selection device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111859596A CN111859596A (en) | 2020-10-30 |
| CN111859596B true CN111859596B (en) | 2024-02-02 |
Family
ID=72951244
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910304990.0A Active CN111859596B (en) | 2019-04-16 | 2019-04-16 | Control valve type selection method and control valve type selection device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111859596B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| DE202013105338U1 (en) * | 2013-11-22 | 2014-01-29 | Jdv Control Valves Co., Ltd. | Parameter selection and calculation system for control valves |
| CN104156493A (en) * | 2013-05-13 | 2014-11-19 | 进典工业股份有限公司 | Parameter selection control device of control valve |
| CN105138777A (en) * | 2015-08-27 | 2015-12-09 | 北京恒华伟业科技股份有限公司 | Pole tower model selection method and device |
| CN106372143A (en) * | 2016-08-29 | 2017-02-01 | 中国能源建设集团广东省电力设计研究院有限公司 | EXCEL internal function-based two-dimensional data linear query/valve selection method |
| CN109241514A (en) * | 2018-09-10 | 2019-01-18 | 深圳市泰洲科技有限公司 | Data automatically imported method, device, computer equipment and storage medium |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9317025B2 (en) * | 2013-10-25 | 2016-04-19 | Jdv Control Valves Co., Ltd. | Parameter selection and calculation system for control valves |
| JP6295221B2 (en) * | 2015-03-17 | 2018-03-14 | アズビル株式会社 | Positioner |
-
2019
- 2019-04-16 CN CN201910304990.0A patent/CN111859596B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104156493A (en) * | 2013-05-13 | 2014-11-19 | 进典工业股份有限公司 | Parameter selection control device of control valve |
| DE202013105338U1 (en) * | 2013-11-22 | 2014-01-29 | Jdv Control Valves Co., Ltd. | Parameter selection and calculation system for control valves |
| CN105138777A (en) * | 2015-08-27 | 2015-12-09 | 北京恒华伟业科技股份有限公司 | Pole tower model selection method and device |
| CN106372143A (en) * | 2016-08-29 | 2017-02-01 | 中国能源建设集团广东省电力设计研究院有限公司 | EXCEL internal function-based two-dimensional data linear query/valve selection method |
| CN109241514A (en) * | 2018-09-10 | 2019-01-18 | 深圳市泰洲科技有限公司 | Data automatically imported method, device, computer equipment and storage medium |
Non-Patent Citations (3)
| Title |
|---|
| Selection of control valves on water optimisation projects;W Booysen 等;《2011 Proceedings of the 8th Conference on the Industrial and Commercial Use of Energy》;53-58 * |
| 协同液压设计资源共享平台及泵选型CAD***开发;王波;《中国优秀博硕士学位论文全文数据库 (硕士)工程科技Ⅱ辑（2007）》(第02期);C029-50 * |
| 热力膨胀阀选型方法研究及对***可靠性的影响;李丽芬;《中国优秀硕士学位论文全文数据库 工程科技Ⅱ辑（2010）》(第04期);C028-42 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111859596A (en) | 2020-10-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11379737B2 (en) | Method and apparatus for correcting missing value in data | |
| CN111027294B (en) | Method, device and system for summarizing table | |
| Rushing et al. | Design and analysis of experiments by Douglas Montgomery: A supplement for using JMP | |
| CN109448100A (en) | Threedimensional model format conversion method, system, computer equipment and storage medium | |
| CN109254959A (en) | A kind of data evaluation method, apparatus, terminal device and readable storage medium storing program for executing | |
| CN106843141A (en) | Numerical control device | |
| CN110472298B (en) | Method, device, equipment and storage medium for constructing electric power market model | |
| CN112527676A (en) | Model automation test method, device and storage medium | |
| CN115794641A (en) | Method, device and equipment for making number based on business process and storage medium | |
| CN111859596B (en) | Control valve type selection method and control valve type selection device | |
| CN112905451B (en) | Automatic testing method and device for application program | |
| CN116150327A (en) | Text processing method and device | |
| CN117094296A (en) | VB language-based form splitting method, intelligent terminal and storage medium | |
| CN111398703A (en) | Automatic test method and device for voltage analog-to-digital converter and storage medium | |
| CN114116449B (en) | Parameterization method and device for automatic test case and electronic equipment | |
| CN106688002A (en) | Simulation system, simulation method, and simulation program | |
| CN112699032A (en) | Method for analyzing performance test result of vdbench based on Excel | |
| CN113642667A (en) | Enhancement strategy determination method and device, electronic equipment and storage medium | |
| CN111898807A (en) | Tobacco yield prediction method based on whole genome selection and application | |
| CN117495432B (en) | Multi-time-scale voting type user potential demand analysis method and system | |
| CN108038012A (en) | Data calibration method and device, electronic equipment and computer-readable recording medium | |
| CN109388385A (en) | Method and apparatus for application and development | |
| CN117193733B (en) | Method for constructing and using example library and method for evaluating generated example code | |
| CN117635756B (en) | Automatic generation method, system and device for sheet metal die two-dimensional map and storage medium | |
| CN116361193B (en) | Method and device for testing layout document text selection |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |